Excel - ADVANCED



After going over 2 Excel manuals, I was ready to tackle higher challenges. At this point, I felt super confident entering the big league. Bring on the more sophisticated tools, I am up for it.

  • Looking up data! ... Yes, I am ready.
  • Nesting functions! ... I have built myself to this day.
  • PivotTable calculations! ... I have been waiting for this.
  • Data validation, 2 variables table, and Macros! ... Let’s go, I’m right here.
  • Some concepts may be a bit more challenging! ... I will then keep practicing until I get it.

Nothing at this point phases me. I’ve come this far with hard work; I am going all the way.

And congratulations to you if you’re reading this. You’re about to embark on a major Excel excursion, and you should totally embrace it.

Excel ADVANCED – Course Description

This course relies on all the knowledge you previously acquired and takes it to the next level. Be part of a learning experience that sets you on your way to become an avid Excel user.

Become proficient with higher-end tools and features within this amazing program and feel like you can find a viable solution to all your data requirements.

Discover how to use named cells and ranges in formulas instead of references, and how to nest functions within others to complete a large but logical operation.

Learn how to look up data via a Vlookup, Hlookup, and Index and Match functions, or the more recent Xlookup – and many of their uses.

This course builds up on what you know about PivotTables already, and teaches you to build your own calculations as well as making use of an array of ones built-in.

Additional topics such as data validation enable you to control the input into your worksheet cells. Others like Macros facilitate the automation of routine business processes.

As it has been the case in the other two class levels, there will be many tips and tricks and fun shortcuts sprinkled throughout this session as well.

This is a one-day course that will place you in a club of high-end users. With this solid knowledge base you have so far acquired, the sky’s the limit.

This course is closed for enrollment.

Excel ADVANCED – Knowledge Requirement

While attending an intermediate class isn’t required, it is crucial that you have a solid understanding of:

·       Main concepts covered in the Foundation course

·       Sorting and Filtering and working with data lists and tables

·       Linking worksheets

·       Working with PivotTables and modifying them

·       Writing If statements using numbers, calculations, and text

·       Basic knowledge of data charts




Excel ADVANCED - Course Overview:

This course focuses on the following areas:

·       The advantage in using named cells/ranges

·       Learning how to nest functions within others

·       Automate searching for data using lookups

·       Control Text appearance using functions

·       Pivot Tables calculations

·      Automating certain routine processes with Macros



Excel ADVANCED - Course Outline

·       Customizing the Quick Access Toolbar - set your environment to match your liking

·       Customizing the Ribbon – create additional tabs/groups and add on the buttons of your choice

·       Using Named Cells and Ranges – replace cell ranges with names in formulas

·       Nesting Excel Functions – learn how to incorporate a function within another

·       Vlookup, Hlookup, and Xlookup – instruct excel to look up and return values from a dataset

·       Transposing Data – change data layout from horizontal to vertical and vice versa

·       Pivot Tables Built-in Calculations – explore different computations for your data

·       SumIf and CountIf – add and count data that meets a certain criterion

·       Data Validation – set rules on certain cells to limit the data entered

·       Two Variables Tables – see the results of several inputs at the same time

·       Conditional Formatting – create a certain look for your data based on conditions you set

·       Text Functions – concatenate and parse data and other functions