Microsoft Excel Ultimate BEGINNER Course, Microsoft Excel Basics, Hacks, Tips & Shortcuts.
Course Description
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 🙂
