Day 1
- Start Excel
- Work in Excel user interface
- Create workbooks
- Modify workbooks
- Enter and revise data
- Manage data by using Flash Fill
- Modify worksheets
- Move data within a workbook
- Find and Replace data
- Define Excel tables
Day 2
- Format cells
- Format Numbers
- Conditional Formatting
- Data Validation
Day 3
- Filters
- Sort worksheet data
- Sort data by using custom lists
- Organize data into levels – Subtotal
- Manipulate worksheet data (Remove Duplicates, Column to Text)
- Name groups of data
- Consolidate multiple sets of data into a single workbook
Day 4
- Create formulas to calculate values
- Working with formulas
- Copy functions
- Absolute references
- Using names in formulas
- Using formulas with tables.
- Errors in formulas
Day 5
- Scenarios
- Goal Seek
- Solver
- Analyze data by using data tables.
- Create Charts
- Summarize your data by using sparklines
Day 6
- PivoteTables
- Macros
- Manage comments
- Add protection to workbooks and worksheets
- Change default Excel options