Microsoft Excel – Level 1

Description

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

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 — creating 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