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 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.

Power BI (Business Intelligence) works with many data sources (Excel, Access, SQL Server, and etc.) todevelop an interactive data visualization, or dashboard, giving valuable insights for business reviews and decisions. Those who work with data from multiple sources, to create reports regarding data analysis, marketing, sales, inventory control, production, education, and etc. will benefit most from this course.Requires experience with Excel or other computer applications dealing with data, and different database type software. You should be comfortable developing reports such as PivotTables and charts in Excel.

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.