Download PDF
of this course

Microsoft Excel 2016 ()

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration: 3 Days

This three days of Microsoft Word 2016 training class is designed for Excel users who want to learn the topics covered in 2016 interface.

 

Who Should Attend

Course Certifications

This course is part of the following Certifications:

Prerequisites

Course Objectives

  • Create basic worksheets using Microsoft Excel 2016

  • Perform calculations in an Excel worksheet

  • Modify an Excel worksheet

  • Modify the appearance of data within a worksheet

  • Manage Excel workbooks

  • Print the content of an Excel worksheet

  • Learn how to use handy features new in 2016

  • Use bookmarks, add watermarks and customize the ribbon

  • Learn to use formulas and functions

  • Create and modify charts

  • Convert, sort, filter and manage lists

  • Insert and modify illustrations in a worksheet

  • Learn to work with tables

  • Learn to use conditional formatting and styles

  • Create pivot tables and charts

  • Learn to trace precedents and dependents

  • Convert text and validate and consolidate data

  • Collaborate with others by protecting worksheets and workbooks

  • Create, use, edit and manage macros

  • Import and export data

Course Content

Module 1: Creating a Microsoft Excel Workbook

  • Creating a Workbook

  • Saving a Workbook

  • The Status Bar

  • Adding and Deleting Worksheets

  • Copying and Moving Worksheets

  • Changing the Order of Worksheets

  • Splitting the Worksheet Window

  • Closing a Workbook

Module 2: The Ribbon

  • Tabs

  • Groups

  • Commands

Module 3: The Backstage View (The File Menu)

  • Introduction to the Backstage View

  • Opening a Workbook

  • New Workbooks and Excel Templates

  • Printing Worksheets

  • Adding Your Name to Microsoft Excel

  • Managing Workbook Versions

Module 4: The Quick Access Toolbar

  • Adding Common Commands

  • Adding Additional Commands with the Customize Dialog Box

  • Adding Ribbon Commands or Groups

  • Placement

Module 5: Entering Data in Microsoft Excel Worksheets

  • Entering Text

  • Expand Data across Columns

  • Adding and Deleting Cells

  • Adding an Outline

  • Adding a Hyperlink

  • Add WordArt to a Worksheet

  • Using AutoComplete

  • Entering Numbers and Dates

  • Using the Fill Handle

Module 6: Formatting Microsoft Excel Worksheets

  • Hiding Worksheets

  • Adding Color to Worksheet Tabs

  • Adding Themes to Workbooks

  • Adding a Watermark

  • The Font Group

  • The Alignment Group

  • The Number Group

Module 7: Using Formulas in Microsoft Excel

  • Math Operators and the Order of Operations

  • Entering Formulas

  • AutoSum (and Other Common Auto-Formulas)

  • Copying Formulas and Functions

  • Relative, Absolute, and Mixed Cell References

Module 8: Working with Rows and Columns

  • Insert lesson titles in a bulleted list.

  • Inserting Rows and Columns

  • Deleting Rows and Columns

  • Transposing Rows and Columns

  • Setting Row Height and Column Width

  • Hiding and Unhiding Rows and Columns

  • Freezing Panes

Module 9: Editing Worksheets

  • Find and Replace

  • Using the Clipboard

  • Managing Comments

Module 10: Finalizing Microsoft Excel Worksheets

  • Setting Margins

  • Setting Page Orientation

  • Setting the Print Area

  • Print Scaling (Fit Sheet on One Page)

  • Printing Headings on Each Page/Repeating Headers and Footers

  • Headers and Footers

Module 11: Advanced Formulas

  • Using Named Ranges in Formulas

  • Naming a Single Cell

  • Naming a Range of Cells

  • Naming Multiple Single Cells Quickly

  • Using Formulas That Span Multiple Worksheets

  • Using the IF Function

  • Using AND/OR Functions

  • Using the SUMIF, AVERAGEIF, and COUNTIF Functions

  • Using the PMT Function

  • Using the LOOKUP Function

  • Using the VLOOKUP Function

  • Using the HLOOKUP Function

  • Using the CONCATENATE Function

  • Using the TRANSPOSE Function

  • Using the PROPER, UPPER, and LOWER Functions

  • The UPPER Function

  • The LOWER function

  • The TRIM Function

  • Using the LEFT, RIGHT, and MID Functions

  • The MID Function

  • Using Date Functions

  • Using the NOW and TODAY Functions

  • Creating Scenarios

  • Utilize the Watch Window

  • Consolidate Data

  • Enable Iterative Calculations

  • What-If Analyses

  • Use the Scenario Manager

  • Use Financial Functions

Module 12: Working with Lists

  • Converting a List to a Table

  • Removing Duplicates from a List

  • Sorting Data in a List

  • Filtering Data in a List

  • Adding Subtotals to a List

  • Grouping and Ungrouping Data in a List

Module 13: Working with Illustrations

  • Working with Clip Art

  • Using Shapes

  • Working with SmartArt

Module 14: Visualizing Your Data

  • Creating a Custom Chart Template

  • Inserting Charts

  • Add and Format Objects

  • Insert a Text Box

  • Create a Custom Chart Template

Module 15: Working with Tables

  • Format Data as a Table

  • Move between Tables and Ranges

  • Modify Tables

  • Define Titles

Module 16: Advanced Formatting

  • Applying Conditional Formatting

  • Working with Styles

  • Creating and Modifying Templates

Module 17: Using Pivot Tables

  • Creating Pivot Tables

  • Inserting Slicers

  • Working with Pivot Tables

  • Inserting Pivot Charts

  • More Pivot Table Functionality

Module 18: Auditing Worksheets

  • Tracing Precedents

  • Tracing Dependents

  • Showing Formulas

Module 19: Data Tools

  • Converting Text to Columns

  • Linking to External Data

  • Controlling Calculation Options

  • Data Validation

  • Consolidating Data

  • Goal Seek

Module 20: Working with Others

  • Protecting Worksheets and Workbooks

  • Tracking Changes

  • Marking a Workbook as Final

Module 21: Recording and Using Macros

  • Recording Macros

  • Running Macros

  • Editing Macros

  • Adding Macros to the Quick Access Toolbar

Module 22: Other Useful Features

  • Sparklines

  • Preparing a Workbook for Internationalization and Accessibility

  • Importing and Exporting Files

Module 23: New Features in Microsoft Excel Features in 2013 and 2016

  • One Workbook Per Window Feature

  • Using Flash Fill

  • Tell Me

  • Smart Lookup

  • New Functions in Excel 2013

  • Using New Chart Tools

  • Using the Quick Analysis Tool

  • Using the Chart Recommendation Feature

  • Treemap

  • Sunburst

  • Waterfall

  • Box and Whisker

  • Pareto

  • Using Slicers to Filter Data

  • Creating a PivotTable Timeline

  • Creating a Standalone PivotChart

  • Workspaces in Excel 2013

  • PivotTable Updates

  • Ink Equations

  • Multi-Select Option in Slicers

  • Quick Shape Formatting

  • Sharing with SharePoint or OneDrive

Course ID:


Show Schedule for 1 Month  3 Months  All 
Date Country Location Register