How To Make Amazing Graphs In Excel Quickly And Easily
Learn how to make and format a variety of different graphs with a few clicks: Bar, Line, Stacked Area, Stacked Bar, Pie, Scatter, Combo and Gantt .Watch Promo
Impress your boss and co-workers with your beautiful and very useful graphs. If you follow along with my step by step instructions you can learn how to do these really quickly and easily.
I used to be an accountant and financial controller and I made beautiful graphs all the time. The board of directors used to think I was a genius, but actually they are very easy to do once you know how.
The course covers:
Creating the data table
Let's create our first graph
All the chart elements
Why the gridlines are crucial
Bring to life with color
How to select and move data
Line charts, stacked charts by area, stacked bar, and pie chart part 1 - formatting
Pie chart part 2 and linking data
Trendlines and scatter graphs
Combo charts and thesecondary axis
I have used Excel extensively over the last 25 years in my career as an accountant in industry. I used to set up massive spreadsheets so that every month, I just to used to push a button and generate the monthly accounts with summary and detailed pages with graphs.
It saved me so much time, and work, and made life very easy. Also it eliminated any human error, so the accounts were always accurate, which avoided any embarrassing incidents.
I really love Excel, so decided to become a trainer, and help others learn to produce the same results in a fraction of the time.
StartLine charts, stacked charts by area, stacked bar, and pie chart part 1 - formatting (4:52)
PreviewPie chart part 2 and linking data (3:49)
StartTrendlines and scatter graphs (1:27)
PreviewHow to add a secondary axis in Excel, combo charts, cashflow forecasts (5:18)
PreviewGantt charts (4:56)