Skip to Main Content

Microsoft Excel 2013 Advanced Essentials  (MO13EX201)

Time: 9am - 4pm
Duration: 1 day

Compatible with 2013

Description:

This Intermediate level is intended to help everyday users of Excel become more proficient by expanding their knowledge of functions, formulas, and new Excel features.

Prerequisites:

MO13EX101—Microsoft Excel 2013 Core Essentials or equivalent is mandatory.

Public Class Schedule

Location Language Date Price Register
Ottawa English June 19 $ 265.00
Web-based(Opens in new window) English June 19 $ 265.00
Ottawa English July 12 $ 265.00
Web-based(Opens in new window) English July 12 $ 265.00
Ottawa English September 7 $ 265.00
Web-based(Opens in new window) English September 7 $ 265.00
Ottawa English November 8 $ 265.00
Web-based(Opens in new window) English November 8 $ 265.00

We're Here to Help

Don't see the dates you need? Call us at 888.484.2933 or Tell Us What You Need.

Course Outline

  • Advanced File Tasks
    • This section teaches students how to use the Open and Save dialogs to create new files and folders. It also covers file types that are compatible with Excel, how to work with older file formats, and how to protect their workbook against accidental or intentional changes to the data. Finally, this section will discuss the many file management tools and checkers that are used to scan workbooks for personal information and compatibility issues.
  • Working with Functions and Formulas
    • In this section, participants will learn how to properly reference cells, use mathematical operators, and how to check their formulas for errors and evaluate their formulas. This section also covers how to browse, insert, and use functions to perform complex mathematical operations. Students will learn how to use the IF function, use nested functions to perform multiple operations, and define and use range names. Finally, array formulas will be discussed.
  • Managing Tables
    • Tables are an important part of Excel because they inherently contain a lot of useful functionality, including sorting and filtering. This section teaches participants how to add and edit tables, edit table information, perform sort and filter operations, and even how to use Excel as a database.
  • Data Validation
    • Data Validation allows you to set a rule to reject invalid dates and numbers.
  • Adding the Finishing Touches
    • This section details how to round off a spreadsheet by discussing how to check spelling and use the research pane to look up words, facts, and figures. Students will learn how to apply and use theme effects and create text boxes, pictures, and Clip Art. Basic image editing will also be discussed.
  • Showing Data as a Graphic
    • This final section will show how to to add and edit shapes. And the new Sparkline feature will be discussed, showing participants how to add, edit, and customize these useful graphs-in-a-cell.

Private training is available for this course.

Call us at 1-888-484-2933 to learn more about our flexible scheduling options or complete our Information Request Form.

© 2018 Eliquo, Inc. All rights reserved.

Back to Top