Skip to main content
Adobe training, UX Courses, and Photoshop Classes at AGI
American Graphics Institute
Secondary
  • About
  • Contact
  • Locations
  • Books
  • All classes
  • UX Classes
  • Cart
  • Log in
Search
Search
Main menu
  • Classes & Workshops
    • Classes & Workshops
    • Column 1
      • Adobe Classes
      • Photoshop
      • InDesign
      • Illustrator
      • Premiere Pro
      • After Effects
      • Animate
      • Acrobat
      • Captivate
      • XD
      • Creative Cloud
      • All Adobe
      • Digital Marketing
      • HTML Email
      • Google Analytics
      • Google Tag Manager
      • Digital Marketing Certificate
    • Column 2
      • Elearning
      • Captivate
      • Camtasia
      • Graphic Design
      • Graphic Design Course
      • Design Thinking
      • Graphic Design Certificate
      • Graphic Design for High School Students
      • Office Skills
      • PowerPoint
      • Keynote
      • Excel
      • Access
      • Google Docs
      • Presentation Design
      • PowerPoint Design
      • Keynote Presentation Design
    • Column 3
      • UX Classes
      • UX Design
      • Information Architecture
      • Rapid Prototyping
      • UX for Mobile & Touch
      • Figma
      • Sketch
      • XD
      • UXQB CPUX Certification
      • UX Certification
      • UX Design Certificate
      • Video Editing
      • Premiere Pro
      • After Effects
      • DaVinci Resolve
      • Final Cut
      • Video Editing for High School Students
      • Video Production
      • Web Accessibility
      • Web Accessibility
      • Section 508
    • Column 4
      • Web Design
      • WordPress Classes
      • HTML
      • CSS
      • Responsive Web Design
      • Web Design Certificate
      • Web Graphics
      • Web Design for High School Students
      • Web Development
      • JavaScript
      • HTML
      • CSS
      • Drupal
      • WordPress
      • CAD & 3D Design
      • Sketchup
      • 3DS
      • Maya
      • See All Classes
  • Online Training
    • Online Training
    • Column 1
      • Adobe Classes
      • Photoshop
      • InDesign
      • Illustrator
      • Premiere Pro
      • After Effects
      • Animate
      • Acrobat
      • Captivate
      • XD
      • Creative Cloud
      • All Adobe
      • Digital Marketing
      • HTML Email
      • Google Analytics
      • Google Tag Manager
      • Digital Marketing Certificate
    • Column 2
      • Elearning
      • Captivate
      • Camtasia
      • Graphic Design
      • Graphic Design Course
      • Graphic Design Certificate
      • Design Thinking
      • Office Skills
      • PowerPoint
      • Keynote
      • Excel
      • Access
      • Google Docs
      • Presentation Design
      • PowerPoint Design
      • Keynote Presentation Design
      • Figma
    • Column 3
      • UX Classes
      • UX Design
      • Information Architecture
      • Rapid Prototyping
      • UX for Phone & Touch
      • Sketch
      • XD
      • UXQB CPUX Certification
      • UX Certification
      • UX Design Certificate
      • Video Editing
      • Premiere Pro
      • After Effects
      • DaVinci Resolve
      • Final Cut
      • Web Accessibility
      • Web Accessibility
      • Section 508
    • Column 4
      • Web Design
      • Web Design Certificate
      • WordPress
      • HTML
      • CSS
      • Responsive Web Design
      • Web Graphics
      • Web Development
      • JavaScript
      • HTML
      • CSS
      • Drupal
      • WordPress
      • CAD & 3D Design
      • Sketchup
      • 3DS
      • Maya
      • See All Classes
  • Certificate Programs
    • Certificate Programs
    • Column 1
      • Web Design Certificate
      • UX Design Certificate
      • Digital Marketing Certificate
    • Column 2
      • Graphic Design Certificate
      • Video Editing Certificate
      • Web Development Certificate
    • Column 3
      • Photoshop Certificate
      • All Certificate Programs
  • Creative Cloud Classes
    • Creative Cloud Classes
    • Column 1
      • Creative Cloud for Print & Digital
      • Creative Cloud for Video
      • Creative Cloud for Web
    • Column 2
      • Photoshop CC
      • InDesign CC
      • Illustrator CC
    • Column 3
      • Premiere Pro CC
      • After Effects CC
      • Animate CC
      • See All Classes
  • Adobe Training
    • Adobe Training
    • Column 1
      • Photoshop
      • InDesign
      • Illustrator
      • Animate
      • Acrobat
    • Column 2
      • Premiere Pro
      • After Effects
      • XD
      • Captivate
      • Connect
    • Column 3
      • Dreamweaver
      • Creative Cloud
      • LiveCycle
      • AEM Forms
      • InCopy
      • All Adobe Classes
      • See All Classes
  • Private Training

  • About
  • Contact
  • Locations
  • Books
  • All classes
  • UX Classes
  • Cart
  • Log in
Breadcrumb
  1. Home
  2. Excel Classes
  3. Microsoft Excel Class Online June 7, 2023 Advanced
See how live online training works in this brief video.

See how live online training works in this brief video.

Learn about our Online Training Center

All classes include

free retakes of courses Free retakes

Curriculum provided Detailed curriculum

Live instructor Live instructor

flexible rescheduling Flexible rescheduling

flexible rescheduling Certificate of Completion

Microsoft Excel Class Online June 7, 2023 Advanced

Excel Class - Advanced

Wed, Jun 7 2023
Online Training

$249.00

Register

This advanced Excel class will turn you into an Excel power user, making you more efficient when using Excel. Learn to use powerful Excel capabilities, including nested functions, and sensitivity analysis, in this one-day advanced course.

Download Course Description (PDF)
See all Excel Classes

Advanced Excel class topics covered

The Advanced Microsoft Excel training course covers the following topics:

Working Across Sheets and Files

  • Data consolidation

Pivot table calculations and charts

  • Creating a PivotTable from a list or a table
  • Customizing a PivotTable
  • Refreshing a PivotTable
  • Creating a calculation in a PivotTable
  • Creating Pivot charts
  • Creating a table from a list
  • Using what-if analysis tools

Working with custom formats

  • Locking cells
  • Learn to lock rows or columns with mixed cell referencing
  • Lock rows
  • Lock columns
  • Mixed cell referencing
  • Custom number formats

Advanced conditional formatting

  • Automatically apply conditional formatting

Nested IF statements:

  • Beyond the standard IF statements
  • Use nested IF statements to include multiple options
  • Create complex logic statements
  • Creating conditional or multiple conditionals

Goal seek

  • Find values to create an output across an Excel sheet/workbook.
  • Use a goal seek tool to find values to meet a specific result

Data Tables

  • Impacting a targeted output
  • Building sensitivity analysis

Match vlookup

  • Create a VLOOKUP by using the MATCH function

Match index

  • Performing a reverse lookup
  • Discovering how to combine two MATCH’s within the INDEX Data extraction

Working with Macros

Extra Sheets

  • Auditing Cells
  • Discovering errors within formulas
  • Tracing for dependent and precedent values
  • Go to special

Hot Keys

  • Automate functions and commands
  • Text formatting to calculations using your keyboard
Register
Footer
  • 781-376-6044
  • CONTACT US
  • SEE ALL AGI TRAINING LOCATIONS

© Copyright 2002 - 2023 American Graphics Institute