See how live online training works in this brief video.
All classes include
Free retakes
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Microsoft Excel Class Online June 23, 2023 Intermediate
Excel Class - Intermediate
$249.00
This intermediate Excel class will deepen your knowledge with hands-on training. Learn to quickly find data with VLOOKUP as well as build Pivot Tables to summarize and analyze. Create advanced charts, and work with text using text functions. Learn to use statistical formulas including COUNTIFS and SUMIFS for understanding data. Expand your skills and improve your efficiency with this intermediate Excel course.
Microsoft Excel Intermediate topics covered:
Review of foundational Excel tasks
Excel workbook navigational tips and tricks
Review of formulas
Cell ranges
Formatting review
Review of cell styles
Review conditional formatting
Review of themes
Chart review
Working with lists
You can create your custom lists and use them to sort or fill. Creating a list
Database terms
Sorting a list by one column or multiple columns
Searching records
Filtering records in a list
Extracting records
Grouping records
Using data validation for entering data
Apply data validation to restrict the data type or value others can enter into the cell.
Working with text
Splitting Text
Joining Text
Removing Dups
Data Tables and data filtering and sorting
Named Ranges
VLookup and Xlookup
Using custom Excel templates
Keep branding colors, type, and other styles consistent by using a template.
Saving a workbook as a template
Opening a custom template
Accessing templates
Using a template
Saving a workbook as a template
Deleting templates
Protecting workbooks
Workbook protection levels
Using worksheet and workbook protection
Unlocking cells in a protected worksheet
Hiding and Protecting formulas
If Functions
Subtotals
Paste Special
Data Validation