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 Certificate
      • Video Editing
      • Premiere Pro
      • After Effects
      • Final Cut
      • Video Editing for High School Students
      • Web Accessibility
      • Web Accessibility
      • Section 508
    • Column 4
      • Web Design
      • WordPress
      • 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 Certificate
      • Video Editing
      • Premiere Pro
      • After Effects
      • 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 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
During the pandemic all in-person classes are delivered live online. You can retake the course in-person at no cost once our classrooms reopen. See how live online training works in this brief video.

During the pandemic all in-person classes are delivered live online. You can retake the course in-person at no cost once our classrooms reopen. 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:

Excel Cell Management

  • Cell Locking: Learn to create powerful formulas by locking columns or rows.
  • Cell Auditing: Understand the relationship between formulas and cells.
  • Windows: Discover techniques for editing active windows.
  • Hot Keys: Learn to use the ribbon as a custom set of personalized shortcuts.


Using Special Formatting in Excel

  • Date functions: Learn to calculate dates using several functions
  • Conditional Formatting of Formulas: Discover how to use conditional formatting of formulas using custom rules.

Understanding Advanced Excel Functions

  • Nested IF statements: Learn to use nested IF statements to create multiple options for populating cells
  • IF statements using AND/OR: Learn additional IF functions available by using AND / OR

Using Excel for What If Analysis

  • Goal Seek: Adjust input values to find desired results
  • Data Tables: Display the range of effects for one or two variables on a formula using Data Tables.

Understanding Advanced Analytical Tools in Excel

  • Data Consolidation: Learn to summarize data from separate ranges, consolidating it to a specific output range
  • Conditional SumProduct: Learn how using SumProduct with conditions excludes data that fails to meet specific criteria
  • Pivot Table-Calculations: Learn to create calculated columns and rows using a Pivot Table to expand beyond source data
  • Pivot Charts: Learn to build dynamic visual representations of data from pivot tables

Using Excel’s Advanced Database Functions

  • MATCH function: Learn to return the column or row number of a lookup value
  • VLOOKUP-MATCH: Create more accurate VLookUps through enhancing the determination of the Column Index number
  • INDEX-MATCH: Efficiently return values and references from cells at the intersection of the row and column
  • INDEX-Double MATCH: Learn to use a second Match function to create powerful two-way lookups

Learning Macros in Excel

  • Recording Macros: Learn to record Macros involving formatting and calculations
  • Relative Macros: Understand how to create relative reference macros used in ad-hoc reporting

 

 

Register
Footer
  • 781-376-6044
  • CONTACT US
  • SEE ALL AGI TRAINING LOCATIONS

© Copyright 2002 - 2023 American Graphics Institute