Mastering Excel 2016 – Basics

The world is filled with two kinds of people: a handful of people who are masters of Excel, and the millions of others who wish they were 

If you’ve mastered Microsoft Excel 2016, then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to businesses’ critical questions like ROI, budget allocations, tracking expenditures, and more. This course is your first step towards getting started with Microsoft Excel.  

This is our most requested training course! If you learn to use Excel 2016, you will start to see how useful it is in your life – from formatting your grocery list to calculating complex ROI values. If you are just getting started with Excel, let our Microsoft Certified Trainers, Barbara Evers and Christina Tankersley, walk you through the basics of what you need to know about Microsoft Excel 2016.  

Topics covered include: 

• Navigating around Excel 
• Creating and saving a workbook 
• Using basic Office features including Undo, Redo, and Office clipboard 
• The basics of functions and formulas 
• Applying formatting 
• Managing workbook properties 

Lesson

1. Introduction
2. Navigating the Interface
3. Selecting Data
4. Using Commands
5. Creating a New Workbook
6. Entering Cell Data
7. Using AutoFill
8. Using Flash Fill
9. Using Excel Help
10. Creating Formulas
11. Inserting Functions
12. Copying Formulas and Functions
13. Using Absolute References
14. Inserting and Deleting Cells
15. Searching and Replacing
16. Using Proofing and Researching Tools
17. Applying Text Formats
18. Applying Number Formats
19. Customizing Number Formats
20. Aligning Cell Contents
21. Applying Cell Styles
22. Applying Themes
23. Iserting Hyperlinks
24. Applying Conditional Formatting to Numbers
25. Applying Conditional Formatting to Text and Dates
26. Applying Comparative Analysis Formatting
27. Using Templates
28. Printing Workbooks
29. Setting the Page Layout
30. Inserting Page Breaks
31. Configuring Headers and Footers, Part 1
32. Configuring Headers and Footers, Part 2
33. Managing Worksheets, Part 1
34. Managing Worksheets, Part
35. Managing Worksheets, Part 2
36. Creating a Custom View
37. Managing Worksheet Views
38. Managing Workbook Views
39. Managing Workbook Properties
40. Customizing General Options
41. Customizing the Ribbon
42. Customizing the Quick Access Toolbar