Microsoft Excel 2013: Advanced

Pre-Requisites: Microsoft Excel® 2013 Intermediate skills.


Key Features

  • Online live classroom available
  • Quality learning materials
  • Small Class Sizes
  • State of the Art Facility
  • Free Retakes
  • Instructor Led Classroom training
  • Certified Industry Experienced Teachers
  • 100% Job Placement assistance

This course will give students the ability to create advanced spreadsheets using the full range of Microsoft Excel tools and features. Students will learn to apply custom formatting, and to use LOOKUP functions as well as how to use lists. Students will also learn how to customize and automate Excel using macros.

This course is intended for students learning Microsoft Excel® 2013 Advanced skills.

Advanced functions and formulas

  • Logical functions
  • Conditional functions
  • Financial functions
  • Text functions
  • Date and time functions
  • Array formulas
  • Calculation options

Lookups and data tables

  • Using lookup functions
  • Creating data tables

Advanced data management

  • Validating cell entries
  • Advanced filtering

Advanced charting

  • Chart formatting options
  • Combination charts
  • Graphical objects

PivotTables and PivotCharts

  • Working with PivotTables
  • Modifying PivotTable data
  • Formatting PivotTables
  • Using PivotCharts
  • PowerPivot

Exporting and importing data

  • Exporting and importing text files

Analytical tools

  • Goal Seek
  • Scenarios
  • Instant data analysis

Macros and Visual Basic

  • Running and recording a macro
  • Working with VBA code

Accessibility and language features

  • Accessibility considerations
  • Internationalization



Course Number : MOUS-8-0202

Duration : 8 hours

1 Step 1

Request Information!

Who you are?

By submitting this form, you are giving your express written consent for Global Information Technology to contact you regarding our programs and services using email, telephone or text.  This consent is not required to purchase goods/services, and you may always call us directly at 1-866-464-4846.

reCaptcha v3