Learn Professional Excel

Get Started. It's Free
or sign up with your email address
Learn Professional Excel by Mind Map: Learn Professional Excel

1. Week 1: Introduction to Basic Concept of Excel

1.1. What is Excel

1.2. How to Work with Excel

1.3. Basic Formulas of Excel

1.4. Formating of Excel Data

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

2.1. Topic A: Use Links and External References

2.2. Topic B: Use 3-D References

2.3. Topic C: Consolidate Data

3. Week 3: Using Lookup Formulas and Formula Auditing

3.1. Topic A: Use Lookup Functions

3.2. Topic B: Trace Cells

3.3. Topic C: Watch and Evaluate Formulas

4. Week 4: Sharing and Protecting Workbooks

4.1. Topic A: Collaborate on a Workbook

4.2. Topic B: Protect Worksheets and Workbooks

5. Week 5: Automating Workbook Functionality

5.1. Topic A: Apply Data Validation

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

5.3. Topic C: Work with Macros

6. Week 6: Creating Sparklines and Mapping Data

6.1. Topic A: Create Sparklines

6.2. Topic B: Map Data

7. Week 7: Forecasting Data

7.1. Topic A: Determine Potential Outcomes Using Data Tables

7.2. Topic B: Determine Potential Outcomes Using Scenarios

7.3. Topic C: Use the Goal Seek Feature

7.4. Topic D: Forecasting Data Trends

8. Week 8: Reports