Embark on a comprehensive 6-hour journey through Microsoft Excel 2016 in this beginner-friendly tutorial. Master essential spreadsheet skills, from basic data entry and formatting to advanced functions like VLOOKUP. Learn to navigate the ribbon interface, customize toolbars, and utilize contextual menus. Explore data manipulation techniques, including fill series and flash fill. Discover various workbook views, printing options, and efficient copy-paste methods. Delve into formula creation, worksheet management, and working with multiple workbooks. Enhance your data presentation skills by creating and customizing charts and graphs. Practice your new skills with included exercises and downloadable files. By the end of this extensive tutorial, gain confidence in using Excel for various tasks and improve your productivity with spreadsheets.
The Ultimate MS Excel Crash Course - Microsoft Excel 2016 Tutorial for Beginners
Simon Sez IT via YouTube
Overview
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
Related Courses
Related articles
Reviews
5.0 rating, based on 2 Class Central reviews
-
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
-
Vasif ShaikhBest 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
