This course covers basic skills including basic parts of an Excel window, formatting, alignment, indenting, merging cells; creating a simple spreadsheet with formulas, functions, format painter, absolute reference, freezing columns and rows, split windows, copy & paste, paste special, using multiple windows of the same file, printing options, creating charts and graphs, non-adjacent cells, and mail merges.

Excel Level 1 is a great introductory class for those who are starting their Excel journey or would like to know more. Participants should already know how to find a file given a path, have basic math skills, know how to use a mouse and keyboard. Objectives in Level 1 are formatting, inputting data, creating formulas and functions, format painter, absolute reference, viewing and printing options, comments/notes, creating a template and how to use an Excel database to create a mail merge using Word.

This course covers naming a range, specialprinting titles of rows & columns, paste between work-sheets, pasting values and links, viewing and workingwith multiple work-sheets, 3D formulas,  protecting a workbook \ worksheet, & cells, checking for duplicates, Excel as a database, autofilters, slicers,and creating a graph with two axis.

Excel Level 2 is a continuation of Level 1, participants should have those skills before taking Excel Level 2. Course objectives are how to work with multiple files and worksheets, naming a range and benefits, sorting and filtering data using Excel as a database, tables and their benefits, data validation, sub-totals, Pivot Tables, conditional formatting, graphs with two axis and sparklines.

This course provides advanced tools for solving real-world problems in Microsoft Excel 2019: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros.

Excel Level 3 is a continuation of Level 2, participants should have those skills before taking Excel Level 3. Course objectives are If Statements, Lookup Functions, Date and Text Functions, What-If Analysis, Exporting, Importing using Power Pivot, Simple Macros and Form Tools.