Microsoft Excel Training Class - Intermediate

Microsoft Excel Training Class - Intermediate

This intermediate Excel course moves into more advanced funcionality to locate, calculate, summarize and format data. Learn to summarize and organize data in Excel with Pivot Tables, write advanced functions using VLOOKUP, and create advanced charts. Discover statistical formulas like COUNTIFS and SUMIFS to better understand data, and learn Excel techniques to work more efficiently. Attend this intermediate Excel training and learn to use:

  • Split and Join Text: Split text to multiple columns with Text to Columns.
  • Data Validation: Create dropdown menus within cells to restrict entries.
  • Sort & Filter: Within database or tables, sort alphabetically or by number.
  • VLOOKUP: Retrieve a value from a table based on the value in a column.
  • IF Statements: Write formulas that show different outputs based on conditions.
  • SUMIFs: Sum values that meet one or more conditions.
  • COUNTIFs: Count the number of items that meet a certain criteria.
  • Pivot Tables: Summarize and visualize data with these dynamic tables.
  • Navigation Shortcuts: Learn to more quickly navigate around worksheets.

Microsoft Excel Training Class - Intermediate Course Dates

All classes in Boston and Philadelphia start at 9:30 a.m. and end at 4:30 p.m. and are led by a live instructor in the same classroom with you. All online classes and NYC classes are also led by a live instructor and run from 10:00 a.m. to 5:00 p.m. Eastern Time.

Course Title Course Dates Course Location Fee Register
Microsoft Excel Training Class - Intermediate

Online

American Graphics Institute American Graphics Institute
Online
Live instructor-led class online
1969-12-31T19:00:00-05:00 $219.00
Microsoft Excel Training Class - Intermediate

Online

American Graphics Institute American Graphics Institute
Online
Live instructor-led class online
1969-12-31T19:00:00-05:00 $219.00
Microsoft Excel Training Class - Intermediate

Boston

American Graphics Institute American Graphics Institute
Boston
American Graphics Institute
AGI Training Boston
150 Presidential Way
Boston - Woburn, MA 01801
1969-12-31T19:00:00-05:00 $249.00
Microsoft Excel Training Class - Intermediate

Online

American Graphics Institute American Graphics Institute
Online
Live instructor-led class online
1969-12-31T19:00:00-05:00 $219.00
Microsoft Excel Training Class - Intermediate

Online

American Graphics Institute American Graphics Institute
Online
Live instructor-led class online
1969-12-31T19:00:00-05:00 $219.00
Microsoft Excel Training Class - Intermediate

Online

American Graphics Institute American Graphics Institute
Online
Live instructor-led class online
1969-12-31T19:00:00-05:00 $219.00
Microsoft Excel Training Class - Intermediate

Boston

American Graphics Institute American Graphics Institute
Boston
American Graphics Institute
AGI Training Boston
150 Presidential Way
Boston - Woburn, MA 01801
1969-12-31T19:00:00-05:00 $249.00
Microsoft Excel Training Class - Intermediate

Online

American Graphics Institute American Graphics Institute
Online
Live instructor-led class online
1969-12-31T19:00:00-05:00 $249.00
Microsoft Excel Training Class - Intermediate

Boston

American Graphics Institute American Graphics Institute
Boston
American Graphics Institute
AGI Training Boston
150 Presidential Way
Boston - Woburn, MA 01801
1969-12-31T19:00:00-05:00 $249.00
Microsoft Excel Training Class - Intermediate

Online

American Graphics Institute American Graphics Institute
Online
Live instructor-led class online
1969-12-31T19:00:00-05:00 $249.00
Microsoft Excel Training Class - Intermediate

Online

American Graphics Institute American Graphics Institute
Online
Live instructor-led class online
1969-12-31T19:00:00-05:00 $249.00
Microsoft Excel Training Class - Intermediate

Boston

American Graphics Institute American Graphics Institute
Boston
American Graphics Institute
AGI Training Boston
150 Presidential Way
Boston - Woburn, MA 01801
1969-12-31T19:00:00-05:00 $249.00
Microsoft Excel Training Class - Intermediate

Online

American Graphics Institute American Graphics Institute
Online
Live instructor-led class online
1969-12-31T19:00:00-05:00 $249.00

Intermediate Excel Training Class Topics Covered

Topics covered in the intermediate Microsoft Excel course include the following:

Excel Worksheet Management

  • Efficient Excel Navigation: Discover shortcuts for quick and easy navigation within Excel.
  • Using Paste Special: Learn to apply formats and perform calculations on selected cells.

Understanding Text Functions and Validation

  • Splitting Text: Adapt Text to Columns for splitting text into multiple cells.
  • Joining Text: Combine text from different cells.
  • Named Ranges:  Assign names to ranges of cells for referencing when conducting calculations.
  • Data Validation: Create drop-down menus, making it easier to enter data accurately.
  • Sort & Filter: Locate and organize data in large data sets using sort and filter options.
  • Remove Duplicates: Learn to remove duplicate data from a sheet.

Using Database Functions

  • VLOOKUP: Learn to use Vlookup to locate and return related information across different columns.
  • HLOOKUP: Find out how to use Hlookup to locate and return related information across different rows.
  • VLOOKUP - Closet Match: Discover how to use Vlookup to find the closest match when an exact match is not identified.

Understanding Logical Functions

  • AND, OR: Find out how to use and/or to determine if one or more conditions are met.
  • IF statements: Learn about using IF statements to return data based on the contents of other cells.

Working with Pivot Tables

  • Pivot Tables: Discover how to use Pivot Tables to easily summarize large sets of data.
  • Pivot Tables & Grouping: Create groups within Pivot Tables.
  • Multiple Pivot Tables: Find out how to build several pivot tables within a single Excel sheet.

Using Statistical Functions

  • Ranking: Learn about Rank.eq and Rank.avg functions for determining the position of a cell within a larger array.
  • COUNTIFS: Discover the COUNTIFS function for counting cells based upon conditions.
  • SUMIFS: Apply SUMIFS function to sum cells based upon conditions.

Advanced Chart Creation

  • Combo Charts: Learn to combine two or more charts into a single chart
  • Chart axis: Find out how to add a secondary axis to a chart.

 

Intermediate Excel Course prerequisites

This course requires knowledge of Excel equivalent to the topics in our Introductory Excel Course, including knowledge of basic formulas and functions, charts, formatting, and absolute cell references. A computer with Excel is provided for use during the course.

Course materials

You will receive a comprehensive Excel course manual for this class.

Available Delivery Methods For This Class

CLASSROOM
LIVE ONLINE
PRIVATE
MY LOCATION