Skip to Main Content

Microsoft Excel 2013 Expert  (MO13EX301)

Time: 9am - 4pm
Duration: 1 day

Compatible with 2013

Description:

This Advanced level is intended to help everyday users of Excel present their data in more effective ways using PivotTables and PivotCharts. Users will also learn about advanced analysis tools like the Scenario Manager, goal seek, Solver, PowerPivot, advanced functions, macros, and Visual Basic. Highlights of the course include a solid introduction to creating PivotTables with PowerPivot, coverage of advanced financial functions, hands-on practice with VLOOKUP, extensive coverage of PivotTables and PivotCharts, and an introduction to macros and Visual Basic.

Prerequisites:

MO13EX201—Microsoft Excel 2013 Advanced Essentials or equivalent is mandatory.

This course is currently available in another city, on demand or for private classes only. Call us at 888.484.2933 to learn more about our flexible scheduling options or complete our Information Request Form and we will contact you to arrange a class date that is suitable to your availability.

Course Outline

  • Getting the Most from Your Data
    • To begin, participants will learn about Excel’s automatic grouping, outlining, and subtotaling features. Participants will also explore the Scenario Manager, data analysis tools, add-ins, one and two data input tables, goal seek, and Solver. The section will conclude with a discussion on hyperlinks.
  • Pivoting Data
    • This section focuses on one of Excel’s most powerful tools: PivotTables. Participants will explore all aspects of PivotTables, including creating a PivotTable; using the contextual tabs; pivoting, summarizing, and analyzing data; formatting the PivotTable; and using external data with a PivotTable. This section also includes information on Slicers (a new feature that lets users analyze and interpret pivoted data with ease) and the classic PivotTable frame (used in Excel 2003 and earlier).
  • Charting Pivoted Data
    • In this section, participants will learn how to create, use, edit, and format PivotCharts. Participants will also get experience with advanced PivotChart tasks.
  • Advanced Excel Tasks
    • The next section of this manual will explore a few Excel features that we find handy for everyday chores. First, advanced functions (PMT, FV, VLOOKUP, SUMIF, and Database functions) and logical functions (IFERROR, AND, OR, NOT, FALSE, and TRUE) will be covered. Then, creating custom lists (which can save time when entering data) will be discussed. The section will conclude with information on linking, consolidating, and combining Excel data.
  • Macros
    • The final section of this manual will explore how to automate Excel tasks with macros. We will cover recording, running, and editing both basic and relative reference macros. Information on assigning a keyboard shortcut to a macro and managing macro security is also included.
  • Track Changes
    • Using the Track Changes feature, Excel allows you to electronically mark changes to cell data, mark spelling errors, or add comments in the margins when proofreading or collaborating on a workbook.
  • Using the Inquire Add-in
    • The Inquire Add-in allows you to compare versions of a workbook, analyze a workbook for problems or inconsistencies, or see links between workbooks or worksheets.

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