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 🙂
