Mastering Excel 2016 – Basics
If you’ve mastered Microsoft Excel2016, then you have one of the most practical and valuable skill sets in all of the modern business. A spreadsheet guru can work wonders–from organizing lists to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course is your first step towards getting started with Microsoft excel.
Note: When combined with the Intermediate and Advanced versions of this course, these cover all the objectives required in the Microsoft Office Specialist exam 77-72
- Selecting and Navigating
- Keyboard Navigation and Basic Data Entry
- The Ribbon
- The Quick Access Toolbar
- Creating a New Spreadsheet
- Compatibility Issues
- Cell Data & Data Types
- Accessing Help
- Creating Worksheet Formulas
- Insert Functions
- Re-using Formulas and Functions
- Insert, Delete, & Adjust Columns & Rows
- Find and Replace
- Use Proofing and Research Tools
- Apply Text Formats
- Apply Number Formats
- Align Cell Contents
- Applying Styles and Themes
- Conditional Formatting
- Creating and Using Templates
- Preview and Print a Notebook
- Page Layout
- Configure Headers and Footers
- Managing Worksheets
- View Options
- Managing Workbook Properties
