Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

The Ultimate MS Excel Crash Course - Microsoft Excel 2016 Tutorial for Beginners

Simon Sez IT via YouTube

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This beginner course teaches Microsoft Excel 2016 through data entry, formatting, workbook and worksheet management, formulas and functions, VLOOKUP, and chart creation. It includes seven follow-along exercises.

Syllabus

- Introduction to the Excel Course and Exercise Files -
- Basics of Using the Ribbon -
- Quick Access Toolbar -
- Mini Toolbars and Contextual Menus -
- Status Bar -
- Basics of Entering and Editing Data in a Workbook -
- Exercise 01 -
- Formatting Dates -
- Formatting Numbers -
- Exercise 02 -
- Working with Fill and Series -
- Flash Fill -
- Workbook Views, Zoom, and Freeze -
- Printing -
- Exercise 03 -
- Methods of Cutting, Copying, and Pasting -
- Delete and Clear -
- Insert, Hide, Column Width and Row Height, and Merge -
- Alignment -
- Themes and Styles -
- Exercise 04 -
- Basics of Formulas and Functions -
- Complex Examples of Formulas -
- Exercise 05 -
- Managing Worksheets -
- Working with Multiple Workbooks -
- Saving in Different File Types -
- The Spell Checker -
- Inserting Comments -
- Exercise 06 -
- The VLOOKUP Function -
- Text Functions -
- Date and Time Functions -
- Logical Functions -
- Creating Graphs and Charts -
- Customizing a Cluster Column Chart -
- Customizing a Pie Chart -
- New Chart Types in Excel 2016 -
- Exercise 7 -

Taught by

Simon Sez IT

Reviews

5.0 rating, based on 3 Class Central reviews

Start your review of The Ultimate MS Excel Crash Course - Microsoft Excel 2016 Tutorial for Beginners

  • Profile image for Vansh Sharma
    Vansh Sharma
    I just finished the Excel tutorial, and it was a total game-changer! I’ve always found spreadsheets a bit intimidating, but this video broke everything down into digestible, actionable steps.
    The explanation of Pivot Tables and VLOOKUP was particularly impressive—what used to take me hours now feels like second nature. The pacing was perfect, and the real-world examples made the complex formulas easy to visualize. I walked away feeling confident and ready to tackle my data. If you want to level up your productivity without the headache, this is the gold standard!
  • Mandapalli Ramya Sri
    I just learn more on this website I don't about this in previous I don't have minimum basics also but I'm learn very quickly and easy
  • Profile image for Vasif Shaikh
    Vasif Shaikh
    Best online couse i love it very much. Thak you
    Best online couse i love it very much. Thak you
    Best online couse i love it very much. Thak you

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.