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