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

1. Navigating the Worksheet
2. Selection Techniques
3. Keyboard shortcuts
4. Zoom Feature
5. Getting Help
6. Quick Access Toolbar
7. Customize the Ribbon
8. Auto Calculate
9. Quick Analysis

New Features

1. Collaboration
2. Tell Me
3. Smart Look Up
4. Insights into what you’re working on
5. Ink equations
6. Simpler sharing (SharePoint, OneDrive, One Drive for Business)
7. Improved Version History
8. New Themes
9. Data Loss Protection

Working with Excel

1. Columns, Rows, Cells and Ranges
2. Worksheet Management
3. Page Layout
4. Entering & Deleting Data
5. Use AutoFill Handle
6. Cut, Copy & Paste
7. Paste Special
8. Insert/Delete Cells, Rows and Columns
9. Quick shape formatting
10. Insert Picture with correct orientation

Formulas

1. Introducing the Formula Bar
2. Relative and Absolute References
3. Mathematical Operators
4. Order of Operation
5. Multiple Cell References
6. Auditing Buttons
7. How to Use AutoSum - (SUM, AVERAGE, MIN, MAX)

Note:  Please complete the Excel 2016 "Intro" Training - Session 1 of 2 prior to this session.

To register, visit the following link:

https://icba.arlo.co/w/events/23-excel-2016-essentials-part-1