This site uses cookies and related technologies, as described in our Cookie Statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. You may choose to consent to our use of these technologies, or manage your own preferences.
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
