[Free] Microsoft Excel Ultimate Beginner Course
Microsoft Excel Basics, Hacks, Tips & Shortcuts – Free Course
What you’ll learn
- Learn Microsoft Excel Basics
- Learn Microsoft Excel the fun way, in an engaging way
- Learn Microsoft Excel Formulas
- Learn Microsoft Excel Shortcuts
- Learn Microsoft Excel Hacks to Increase your productivity
Requirements
- No requirements needed, just have a microsoft excel licence
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 🙂
-