Comprehensive Microsoft Excel 2016 Training

On the first day of this comprehensive Microsoft Excel 2016 training course, students will learn to use Excel 2016 to create, modify, and format Excel worksheets, perform calculations, and print Excel workbooks. The second day of class will focus on using advanced formulas, working with lists, working with illustrations and charts, and using advanced formatting techniques. And on the third and final day of class, students will learn to work with pivot tables, audit worksheets, work with data tools, protect documents for collaboration with others, and work with macros.

Goals
  1. Create basic worksheets using Microsoft Excel.
  2. Perform calculations in an Excel worksheet.
  3. Modify an Excel worksheet.
  4. Modify the appearance of data within a worksheet.
  5. Manage Excel workbooks.
  6. Print the content of an Excel worksheet.
  7. Learn to use formulas and functions.
  8. Create and modify charts.
  9. Convert, sort, filter, and manage lists.
  10. Insert and modify illustrations in a worksheet.
  11. Learn to work with tables.
  12. Learn to use conditional formatting and styles.
  13. Create pivot tables and charts.
  14. Learn to trace precedents and dependents.
  15. Convert text and validate and consolidate data.
  16. Collaborate with others by protecting worksheets and workbooks.
  17. Create, use, edit, and manage macros.
  18. Import and export data.
Outline
  1. Creating a Microsoft Excel Workbook
    1. Starting Microsoft Excel
    2. Creating a Workbook
    3. Saving a Workbook
    4. The Status Bar
    5. Adding and Deleting Worksheets
    6. Copying and Moving Worksheets
    7. Changing the Order of Worksheets
    8. Splitting the Worksheet Window
    9. Closing a Workbook
    10. Creating a Microsoft Excel Workbook
  2. The Ribbon
    1. Tabs
    2. Groups
      1. Tell Me
    3. Commands
    4. Exploring the Ribbon
  3. The Backstage View (The File Menu)
    1. Introduction to the Backstage View
    2. Opening a Workbook
    3. Open a Workbook
    4. New Workbooks and Excel Templates
    5. Select, Open and Save a Template Agenda
    6. Printing Worksheets
    7. Print a Worksheet
    8. Adding Your Name to Microsoft Excel
    9. Adding a Theme to Microsoft Excel
  4. The Quick Access Toolbar
    1. Adding Common Commands
    2. Adding Additional Commands with the Customize Dialog Box
    3. Adding Ribbon Commands or Groups
    4. Placement
    5. Customize the Quick Access Toolbar
  5. Entering Data in Microsoft Excel Worksheets
    1. Entering Text
      1. Using Flash Fill
      2. Expand Data across Columns
    2. Adding and Deleting Cells
    3. Adding a Hyperlink
    4. Add WordArt to a Worksheet
    5. Using AutoComplete
    6. Entering Text and Using AutoComplete
    7. Entering Numbers and Dates
    8. Using the Fill Handle
    9. Entering Numbers and Dates
  6. Formatting Microsoft Excel Worksheets
    1. Selecting Ranges of Cells
    2. Hiding Worksheets
    3. Adding Color to Worksheet Tabs
    4. Adding Themes to Workbooks
    5. Customize a Workbook Using Tab Colors and Themes
    6. Adding a Watermark
    7. The Font Group
    8. Working with Font Group Commands
    9. The Alignment Group
    10. Working with Alignment Group Commands
    11. The Number Group
    12. Working with Number Group Commands
  7. Using Formulas in Microsoft Excel
    1. Math Operators and the Order of Operations
    2. Entering Formulas
      1. Ink Equations
    3. AutoSum (and Other Common Auto-Formulas)
    4. Copying Formulas and Functions
      1. Displaying Formulas
    5. Relative, Absolute, and Mixed Cell References
    6. Working with Formulas
  8. Working with Rows and Columns
    1. Inserting Rows and Columns
    2. Deleting Rows and Columns
    3. Transposing Rows and Columns
    4. Setting Row Height and Column Width
    5. Hiding and Unhiding Rows and Columns
    6. Freezing Panes
    7. Working with Rows and Columns
  9. Editing Worksheets
    1. Find
    2. Find and Replace
    3. Using Find and Replace
    4. Using the Clipboard
    5. Using the Clipboard
    6. Using Format Painter
    7. Managing Comments
      1. Adding Comments
      2. Working with Comments
  10. Finalizing Microsoft Excel Worksheets
    1. Setting Margins
    2. Setting Page Orientation
    3. Setting the Print Area
    4. Print Scaling (Fit Sheet on One Page)
    5. Printing Headings on Each Page/Repeating Headers and Footers
    6. Headers and Footers
    7. Preparing to Print
  11. Advanced Formulas
    1. Using Named Ranges in Formulas
      1. Naming a Single Cell
      2. Naming a Range of Cells
      3. Naming Multiple Single Cells Quickly
    2. Using Named Ranges in Formulas
    3. Using Formulas That Span Multiple Worksheets
    4. Entering a Formula Using Data in Multiple Worksheets
    5. Using the IF Function
      1. Using AND/OR Functions
      2. Using the SUMIF, AVERAGEIF, and COUNTIF Functions
    6. Using the IF Function
    7. Using the PMT Function
    8. Using the PMT Function
    9. Using the LOOKUP Function
    10. Using the VLOOKUP Function
    11. Using the VLOOKUP Function
    12. Using the HLOOKUP Function
    13. Using the CONCAT Function
    14. Using the CONCAT Function
    15. Using the TRANSPOSE Function
    16. Using the PROPER, UPPER, and LOWER Functions
      1. The UPPER Function
      2. The LOWER function
      3. The TRIM Function
    17. Using the PROPER Function
    18. Using the LEFT, RIGHT, and MID Functions
      1. The MID Function
    19. Using the LEFT and RIGHT Functions
    20. Using Date Functions
      1. Using the NOW and TODAY Functions
    21. Using the YEAR, MONTH, and DAY Functions
    22. Creating Scenarios
      1. Utilize the Watch Window
      2. Consolidate Data
      3. Enable Iterative Calculations
      4. What-If Analyses
      5. Use the Scenario Manager
      6. Use Financial Functions
  12. Working with Lists
    1. Converting a List to a Table
    2. Converting a List to a Table
    3. Removing Duplicates from a List
    4. Removing Duplicates from a List
    5. Sorting Data in a List
    6. Sorting Data in a List
    7. Filtering Data in a List
    8. Filtering Data in a List
    9. Adding Subtotals to a List
      1. Grouping and Ungrouping Data in a List
    10. Adding Subtotals to a List
  13. Working with Illustrations
    1. Working with Clip Art
    2. Working with Clip Art
    3. Using Shapes
    4. Adding Shapes
    5. Working with Icons
    6. Working with SmartArt
    7. Using Office Ink
  14. Visualizing Your Data
    1. Inserting Charts
    2. Using the Chart Recommendation Feature
    3. Inserting Charts
    4. Editing Charts
      1. Changing the Layout of a Chart
    5. Using Chart Tools
      1. Changing the Style of a Chart
      2. Adding a Shape to a Chart
      3. Adding a Trendline to a Chart
      4. Adding a Secondary Axis to a Chart
      5. Adding Additional Data Series to a Chart
      6. Switch between Rows and Columns in a Chart
      7. Positioning a Chart
      8. Modifying Chart and Graph Parameters
    6. Using the Quick Analysis Tool
      1. Watching Animation in a Chart
      2. Showing, Hiding, or Changing the Location of the Legend in a Chart
      3. Showing or Hiding the Title of a Chart
      4. Changing the Title of a Chart
      5. Showing, Hiding, or Changing the Location of Data Labels in a Chart..162
      6. Changing the Style of Pieces of a Chart
    7. Editing Charts
    8. Add and Format Objects
      1. Insert a Text Box
    9. Create a Custom Chart Template
  15. Working with Tables
    1. Format Data as a Table
    2. Move between Tables and Ranges
    3. Modify Tables
      1. Add and Remove Cells within a Table
      2. Change Table Styles
    4. Define Titles
      1. Band Rows and Columns
      2. Total Row Option
      3. Remove Styles from Tables
    5. Creating and Modifying a Table in Excel
  16. Advanced Formatting
    1. Applying Conditional Formatting
    2. Using Conditional Formatting
    3. Working with Styles
      1. Applying Styles to Tables
      2. Applying Styles to Cells
    4. Working with Styles
    5. Creating and Modifying Templates
      1. Modify a Custom Template
  17. Using Pivot Tables
    1. Creating Pivot Tables
      1. Preparing Your Data
      2. Inserting a Pivot Table
      3. Creating a PivotTable Timeline
    2. More PivotTable Functionality
    3. Inserting Slicers
    4. Multi-Select Option in Slicers
    5. PivotTable Enhancements
    6. Working with Pivot Tables
      1. Grouping Data
      2. Using PowerPivot
      3. Managing Relationships
    7. Inserting Pivot Charts
    8. More Pivot Table Functionality
      1. Creating a Standalone PivotChart
    9. Working with Pivot Tables
  18. Auditing Worksheets
    1. Tracing Precedents
    2. Tracing Precedents
    3. Tracing Dependents
    4. Tracing Dependents
    5. Showing Formulas
  19. Data Tools
    1. Converting Text to Columns
    2. Converting Text to Columns
    3. Linking to External Data
    4. Controlling Calculation Options
    5. Data Validation
    6. Using Data Validation
    7. Consolidating Data
    8. Consolidating Data
    9. Goal Seek
    10. Using Goal Seek
  20. Working with Others
    1. Protecting Worksheets and Workbooks
      1. Password Protecting a Workbook
      2. Removing Workbook Metadata
      3. Restoring Previous Versions
    2. Password Protecting a Workbook
      1. Password Protecting a Worksheet
    3. Password Protecting a Worksheet
      1. Password Protecting Ranges in a Worksheet
    4. Password Protecting Ranges in a Worksheet
    5. Marking a Workbook as Final
  21. Recording and Using Macros
    1. Recording Macros
      1. Copy a Macro from Workbook to Workbook
    2. Recording a Macro
    3. Running Macros
    4. Editing Macros
    5. Adding Macros to the Quick Access Toolbar
      1. Managing Macro Security
    6. Adding a Macro to the Quick Access Toolbar
  22. Random Useful Items
    1. Sparklines
      1. Inserting Sparklines
      2. Customizing Sparklines
    2. Inserting and Customizing Sparklines
    3. Using Microsoft Translator
    4. Preparing a Workbook for Internationalization and Accessibility
      1. Display Data in Multiple International Formats
      2. Modify Worksheets for Use with Accessibility Tools
      3. Accessibility: Using Sounds
      4. Use International Symbols
      5. Manage Multiple Options for +Body and +Heading Fonts
    5. Importing and Exporting Files
      1. Importing Delimited Text Files
    6. Importing Text Files
      1. Exporting Worksheet Data to Microsoft Word
    7. Copying Data from Excel to Word
      1. Exporting Excel Charts to Microsoft Word
    8. Copying Charts from Excel to Word
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Microsoft Excel class:

  • Familiarity with using a personal computer, mouse, and keyboard.
  • Comfortable in the Windows environment.
  • Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.
Preparing for Class
Follow-on Courses

Training for your Team

Length: 3 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

Training for Yourself

  • Live Online Training
  • For Individuals
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

For Online Training, See:

What people say about our training

Great class at the right level of detail. The live instructor via WebEx is a good alternative to waiting for a local class. I am recommending it to others on my team.
David Holland
Optum Technology
Our instructor was very intelligent on the subject. Fields of study were discussed in-depth and further explained when necessary. The class was at a manageable pace for understanding and retaining new terms and concepts.
Joe Evans
Union Pacific Railroad
This is a Great Course. The instructor really helped me learn new ways to use MS Word.
Neal Murty
UNC Hospital Chapel Hill NC
The best thing about Webucator classes is that they are taught by developers who are actually using the tools in their professional careers! They provide tips and guidance based on their experience in addition to following the course materials.
Amanda Brown
Genzyme

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

61,415

Students who have taken Instructor-led Training

11,764

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.29

Students rated our trainers 9.29 out of 10 based on 29,272 reviews

Contact Us or call 1-877-932-8228