Learn Professional Excel

1. Week 5: Automating Workbook Functionality

1.1. Topic A: Apply Data Validation

1.2. Topic B: Search for Invalid Data and Formulas with Errors

1.3. Topic C: Work with Macros

2. Week 6: Creating Sparklines and Mapping Data

2.1. Topic A: Create Sparklines

2.2. Topic B: Map Data

3. Week 7: Forecasting Data

3.1. Topic A: Determine Potential Outcomes Using Data Tables

3.2. Topic B: Determine Potential Outcomes Using Scenarios

3.3. Topic C: Use the Goal Seek Feature

3.4. Topic D: Forecasting Data Trends

4. Week 8: Reports

5. Week 1: Introduction to Basic Concept of Excel

5.1. What is Excel

5.2. How to Work with Excel

5.3. Basic Formulas of Excel

5.4. Formating of Excel Data

6. Week 2: Working With Multiple Worksheets and Workbooks.

6.1. Topic A: Use Links and External References

6.2. Topic B: Use 3-D References

6.3. Topic C: Consolidate Data

7. Week 3: Using Lookup Formulas and Formula Auditing

7.1. Topic A: Use Lookup Functions

7.2. Topic B: Trace Cells

7.3. Topic C: Watch and Evaluate Formulas

8. Week 4: Sharing and Protecting Workbooks

8.1. Topic A: Collaborate on a Workbook

8.2. Topic B: Protect Worksheets and Workbooks