Microsoft Excel – Level 1

This workshop is for individuals new to Microsoft Excel. It covers the essential uses, tools, and features of Microsoft Excel 2019.

Topics covered:

• Tracking data — introduction to excel, entering and editing data, formatting cells, working with numbers and dates

• Using formulas — creating formulas, rearranging data, managing multiple worksheets

• Performing calculations using functions — using functions in formulas, using relative absolute cell references, creating names for cells and ranges

• Data visualization and images — crating charts to compare data, chart tools, move and size charts, adding images, conditional formatting

• Organizing large worksheets — templates, adjusting view options, sorts and filters, IF Function, data validation