Microsoft Excel Training
Introduction to Microsoft Excel (Intro level)
Description
Excel 2016: Essentials
Course Description: Come and learn the essential business features of Excel 2016 including creating formulas, working with basic functions, creating quick and effective charts, applying a filter, and inserting a table. This class will also introduce the top new features in Excel such as flash fill and quick analysis options. Make Excel work for you!
Course Objectives
Getting Started with Excel
- Navigating the Worksheet
- Selection Techniques
- Keyboard shortcuts
- Zoom Feature
- Getting Help
- Quick Access Toolbar
- Customize the Ribbon
- Auto Calculate
- Quick Analysis
New Features
- Collaboration
- Tell Me
- Smart Look Up
- Insights into what you’re working on
- Ink equations
- Simpler sharing (SharePoint, OneDrive, One Drive for Business)
- Improved Version History
- New Themes
- Data Loss Protection
Working with Excel
- Columns, Rows, Cells and Ranges
- Worksheet Management
- Page Layout
- Entering & Deleting Data
- Use AutoFill Handle
- Cut, Copy & Paste
- Paste Special
- Insert/Delete Cells, Rows and Columns
- Quick shape formatting
- Insert Picture with correct orientation
Formulas
- Introducing the Formula Bar
- Relative and Absolute References
- Mathematical Operators
- Order of Operation
- Multiple Cell References
- Auditing Buttons
- How to Use AutoSum - (SUM, AVERAGE, MIN, MAX)