If you build charts in MS Excel you may discover that some charts (especially ones that have positive and negative numbers) don't look great as the axis labels overlap the data. As shown below, the April label overlaps the data for the first bill.
Blog & Excel Tips
Free Tips & Tricks Newsletter Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.
The Future of Financial Modelling: Innovation, AI and Disruption- Free Meetup and Live YouTube stream Sep 25, 2018
Together with Lance Rubin, we have scheduled a free Meetup covering the The Future of Financial Modelling: Innovation, AI and Disruption. The MeetUp will occur on the 25th Oct 2018.
Full time equivalent calculations in Excel Jul 25, 2018
... the key planning areas is how many resources you may need given a specific workload, and more specifically how many 'full time equivalent' staff you may need. In order to do full time equivalent calculations in Excel there are some functions that would be useful to master.
Forecasting tool in Excel Jul 16, 2018
From Excel 2016, there is a convenient Forecasting tool in Excel which allows you to show Excel some historical data (say 24 months worth of sales) and Excel will, taking growth and seasonality into account, forecast for up to 50 months into the future.
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."