Learn to move and copy data, do formulas, insert rows and columns, create basic charts, & more!
Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more!
Learn advanced formulas, VLOOKUP, IF functions, data validation, database functions, formulas with dates, macros & more!
Excel Practice Lab
This class is specially designed for students who have completed our Excel Introduction, Intermediate, and Advanced classes, but don’t have much on-the-job experience using Excel. You will work on Excel assignments at your own pace, with the instructor available to help assist with questions. Assignments may include sheet formatting, basic formulas, charts and graphs, pivot tables, using VLOOKUP and IF functions.
You will learn how to use Visual Basic for Applications to customize macros, create interactive workbooks, and design user-created special functions.