HOME | ABOUT US | CONTACT |

Register Button

Excel Advanced



Date: July 30, 2020
Time: 12:30 p.m. EDT; 11:30 a.m. CDT; 10:30 a.m. MDT; 9:30 a.m. PDT; 8:30 a.m. AKDT
Duration: 4 Hours, plus self-paced on demand
Location: ONLINE - VIRTUAL TRAINING AND SELF-PACED ON DEMAND
Tuition:   $450

Attend this LIVE, ONLINE TRAINING presented by our expert, who will be using all the interactive training tools used in the classroom and more. Youíll be able to ask questions, respond to polls, and collaborate with others. Donít let anything interrupt your training needs. Join us online and experience a different way of learning! Please click here for Virtual Training FAQs.

A continuation of our Excel Basics class, Excel Advanced is a standalone hybrid class that takes things one step further to increase your knowledge. Our tech-savvy instructor will walk you through features you may have never known existed in Excel or you werenít quite sure how to use. Itís perfect for Excel enthusiasts and those who want to learn how to utilize this program to its full capacity.

This class covers a wide range of topics, including advanced formula tasks, working with named ranges, using advanced functions, resolving formula errors, managing data, outlining and grouping data, working with scenarios, using Solver, the Analysis Tool Pak, PivotTable features, using PowerPivot and developing macros.

Just as you receive access to self-paced on demand classes in Excel Basics, youíll receive access to a curated list of advanced online Excel classes. These online courses can be accessed from any device at any time, day or night. This will ensure that youíre able to retain the knowledge learned in the virtual class while also having the ability to practice concepts on your own.

T O P I C S   I N C L U D E
Advanced Formula Tasks
  • Relative and absolute cell references
  • Multiple cell references
  • 3D references
  • Array formulas
Named Ranges
  • What they are
  • Define, edit and delete named ranges
  • Using named ranges in formulas
Using Advanced Functions
  • PMT
  • FV
  • VLOOKUP
  • HLOOKUP
  • IF, AND, OR functions
Resolving Formula Errors
  • Trace formula precedents and dependents
  • Show and evaluate formulas
  • Set error checking options
  • Use error option buttons
  • Run an error check
Managing Data
  • Consolidating data
  • Remove duplicate values
  • Configure data validation
  • Transpose data
  • Convert text to columns
Outlining and Grouping Data
  • Outline data
  • Show and hide details of outlined data
  • Group data
  • Create subtotals
  • Remove outlining and grouping
Creating Scenarios
  • Create, load, merge, edit and delete scenarios
  • Scenario summary reports
Using Solver
  • Set up a worksheet for Solver
  • Run Solver
  • Generate reports and scenarios
  • Modify Solver constraints
  • Set Solver options
Analyzing Data
  • Analysis Tool Pak
  • Goal Seek
Advanced PivotTable Features
PowerPivot
  • Enable PowerPivot
  • Import Access and Excel data into PowerPivot
  • Integrate data with relationships
Macros
  • Record a macro
  • Write a macro using the Visual Basic Editor
  • Edit and run a macro

*Topics subject to change.

Click here to find out how you can bring a Falmouth Institute seminar to your location!
© Copyright 2019 | Terms of Use | Privacy Policy