
Who is David Fortin, CPA aka Piggy Bank Accountant.
Going through the big sections of the template
Covering basics sums and fill functions & shortcuts
Split & Transpose formulas and functions.
How to properly sort and filter your data
How Tables can be useful in your day to day
Drop Down list to avoid error and group data
Analyze & Charts
Pivot Tables your GO TO tool
This course is a very basic level entry Microsoft Excel Tutorial. If you are intermediate, you might still learn a few shortcuts or productivity tips.
I am going to go through the Microsoft Excel Built-in Template "Welcome to Excel". That you can open on your computer at the same time as I do it (which I highly recommend that you do in order to solidify the learnings)
I could summarize this video with the followings : Microsoft Excel basics, charts, formulas, your go to place to learn excel from zero. Mainly beginner and intermediate level.
The Welcome to Excel template go through these subjects :
Sums & Fill
Show you how to do sum, sumifs, tips with CTRL C CTRL V
Show you how to drag formulas and the flash fill funciton
Split & Transpose
Splitting text and copying values from horizontal to vertical is taught here.
Sort & Filter
Going through different type of filters that will help you (Filter by Color , Filter top performers, bottom performers)
Tables
Very introductive level on tables and why you should / should not use it.
Drop-Downs
Drop downs list to help your data entry faster.
Analyze & Charts
Quick words on analyze and charts
Pivot Tables
The most excel useful tool ever invented :)