All Excel classes include
Free retakes
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Excel Class - Intermediate
Excel Class - Intermediate
This intermediate Excel course moves into more advanced functionality 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 tools and techniques including:
- Data Validation: Learn to restrict what can be entered into a cell or create drop-down menus to select pre-populated data.
- Sort & Filter: Find out how to sort data either alphabetically or by the size of the number
- VLOOKUP: Learn how to retrieve the value from a table depending upon another value in a column, such as a city name associtaed with a ZIP code.
- IF Statements: Discover how to create formulas that produce different results depending upon conditions.
- SUMIFs: Create conditional sum values that total values from cells that meet a specific condition you define.
- COUNTIFs: Count the number of items that meet a certain criteria.
- Pivot Tables: Summarize and visualize data with these dynamic tables.
- Split and Join Text: Split text to multiple columns with Text to Columns.
- Navigation Shortcuts: Learn to more quickly navigate around worksheets.
This course is available individually or as part of these certificate programs:
Excel Class - Intermediate - Course Dates
All classes are led by a live instructor. Class times listed are Eastern time.
Intermediate Excel 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.