MS Excel   

Microsoft Excel 2021 - Basic 8 a.m. – 4 p.m. Lunch provided.

An introductory course to learn the basics of Excel. Skills covered will include:

1. Entering and selecting text and numbers
2. Formatting the worksheet 
3. Calculating sums and the five basic calculations
4. Creating basic formulas and financial formulas.
5. Creating Excel charts and formatting the charts.
6. Adding and adjusting sheets
7. Document properties

An intermediate course to expand your basic knowledge of Excel. Skills will include:

1. Creating formulas and understanding the order of operations.
2. Using the Fill handles in the creation of formulas
3. Addition options for formatting the worksheet. (Ex: workbook themes, titles, borders, alignments)
4. Connecting data across different sheets using VLOOKUP or XLOOKUP
5. Conditional formatting
6. Using SmartArt

The advanced course focuses on the experienced Excel user.

Skills will include: