Learning Objectives
This training is a hands-on, classroom based course. The participants will be taught Excel concepts and be guided to apply those concepts to actual business scenarios.
Excel Refresher - After this lesson, the participants will be able to
- Create, save, and navigate an Excel workbook
- Understand the Excel ribbon, tabs, groups, and buttons
- Setup the Excel workbook
- Enter data into a worksheet
- Construct relative and absolute formulas
- Use simple functions to compute data
- Understanding the construction of formula and the patterns they create
- Evaluate the formula pattern to determine its use
- Utilize the autofill options
- Format cells with merge and center, cell styles, and themes
- Enter data by range
- Edit cells
- Format a worksheet
- Chart data to create a column and pie chart
- Establish data trends by using sparklines
|