Microsoft® Office Excel 2016: Level 1

Course Objective: Students will create and edit Excel worksheets and workbooks, use formulas and functions, and apply formatting and printing techniques.

Prerequisites: To ensure your success, each student should have a general knowledge of Microsoft Windows and Microsoft Office concepts.

Contact us to discuss if this level is right for you.

What’s New in 2016: Did you know that Excel will automatically complete cell entry for you when it detects a pattern? Learn more about flash fill. Get familiar with the new features added for help, such as Tell Me More and Learn More. Excel is packed with exciting new templates and features to make your workload easier.

Lesson 1: Creating a Worksheet

Topic 1A: Explore the Interface and the Ribbon
Topic 1B: Update a Workbook’s Properties
Topic 1C: Navigate and Select Data in Excel
Topic 1D: Enter Data and Save a Workbook
Topic 1E: Customize the Quick Access Toolbar
Topic 1F: Obtain Help
Topic 1G: Use Microsoft Office Templates

Lesson 2: Performing Calculations

Topic 2A: Calculate with Formulas
Topic 2B: Calculate with Functions
Topic 2C: Copy Formulas and Functions
Topic 2D: AutoFill Options, Flash-Fill and Series List

Lesson 3: Modifying a Worksheet

Topic 3A: Manipulate Data
Topic 3B: Insert & Delete Cells, Columns and Rows
Topic 3C: Find and Replace Data in a Worksheet
Topic 3D: Manipulate Worksheet Elements

Lesson 4: Formatting a Worksheet

Topic 4A: Modify Fonts
Topic 4B: Add Borders, Color to Cells, Cell Styles
Topic 4C: Change Column Width and Row Height
Topic 4D: Apply Number Formats
Topic 4E: Position Cell Contents

Lesson 5: Printing Workbook Contents

Topic 5A: Print Workbook Contents
Topic 5B: Set Page Layout and Print Options
Topic 5C: Set Page Breaks

Lesson 6: Managing Large Workbooks

Topic 6A: Format Worksheet Tabs
Topic 6B: Manage Worksheets in a Workbook
Topic 6C: Manage the View of Worksheets

Lesson 7: Inserting Graphic Objects

Topic 7A: Insert and Modify Pictures and ClipArt
Topic 7B: Draw and Modify Shapes
Topic 7C: Illustrate Workflow Using SmartArt
Topic 7D: Layer and Group Graphic Objects

Excel 2016 Training Class Outlines:

Excel 2016 Level 1: Fundamentals of Excel
Excel 2016 Level 2: Intermediate Functions and Features
Excel 2016 Level 3: Advanced Tools and Collaboration Features
Excel 2016 Level 4: Advanced Formulas and Functions
Excel 2016 Level 5: Introduction To VBA Macros
Excel 2016 Level 6: Advanced VBA Macros