Microsoft Excel 2010: Advanced

Pre-Requisites: Microsoft Excel® 2010 Intermediate skills.

5-stars

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

What you will learn

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.

Benefits

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

Course content

Unit 1: Advanced functions

  • Topic A: Logical functions
  • Topic B: Math and statistical functions
  • Topic C: Financial functions
  • Topic D: Displaying and printing formulas

Unit 2: Lookups and data tables

  • Topic A: Using lookup functions
  • Topic B: Using MATCH and INDEX
  • Topic C: Creating data tables

Unit 3: Advanced list management

  • Topic A: Validating cell entries
  • Topic B: Exploring database functions

Unit 4: PivotTables and PivotCharts

  • Topic A: Working with PivotTables
  • Topic B: Rearranging PivotTables
  • Topic C: Formatting PivotTables
  • Topic D: PivotCharts

Unit 5: Exporting and importing

  • Topic A: Exporting and importing text files
  • Topic B: Exporting and importing XML data
  • Topic C: Querying external databases

Unit 6: Analytical options

  • Topic A: Goal Seek and Solver
  • Topic B: The Analysis ToolPak
  • Topic C: Scenarios
  • Topic D: Views

Unit 7: Macros and custom functions

  • Topic A: Running and recording a macro
  • Topic B: Working with VBA code
  • Topic C: Creating functions

Unit 8: Conditional formatting and SmartArt

  • Topic A: Conditional formatting with graphics
  • Topic B: SmartArt graphics

Course Number : MOUS-7-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
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right
FormCraft - WordPress form builder