Microsoft Excel – Part 3

The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips.

Reed courses certificate of completion

Digital certificate - Included

• Working with Multiple Worksheets and Workbooks 35:28

  • 1: Before the Training starts 01:00
  • 2: A Round of Introductions 01:00
  • 3: Use Links and External References – Int Preview 01:04
  • 4: Handout: Table of Content (PDF) 13:00
  • 5: Handout: Keyboard Shortcuts (PDF) Preview 01:00
  • 6: Use Links and External References 05:37
  • 7: Use 3-D References – Introduction 00:49
  • 8: Use 3-D References 04:24
  • 9: Consolidate Data – Introduction 00:32
  • 10: Consolidate Data 05:02
  • 11: Quiz – Working with Multiple Worksheets and Workbooks 02:00

• Using Lookup Functions and Formula Auditing 19:30

  • 12: Use Lookup Functions – Introduction 00:50
  • 13: Use Lookup Functions 08:14
  • 14: Trace Precedent and Dependent Cells – Introduction 00:44
  • 15: Trace Precedent and Dependent Cells 02:59
  • 16: Watch and Evaluate Formulas – Introduction 00:44
  • 17: Watch and Evaluate Formulas 03:59
  • 18: Quiz – Using Lookup Functions and Formula Auditing 02:00

• Sharing and Protecting Workbooks 15:48

  • 19: Collaborate on a Workbook – Introduction 00:43
  • 20: Collaborate on a Workbook 05:32
  • 21: Compare and Merge Workbooks 02:52
  • 22: Protect Worksheets and Workbooks – Introduction 00:39
  • 23: Protect Worksheets and Workbooks 04:02
  • 24: Quiz – Sharing and Protecting your Workbooks 02:00

• Automating Workbook Functionality 18:57

  • 25: Apply Data Validation – Introduction 00:51
  • 26: Apply Data Validation 04:16
  • 27: Search for Invalid Data and Formulas with Errors – Introduction 00:39
  • 28: Search for Invalid Data and Formulas with Errors 03:00
  • 29: Work with Macros – Introduction 00:40
  • 30: Work with Macros 05:17
  • 31: Edit a Macro 02:14
  • 32: Quiz – Automating Workbook Functionality 02:00

• Creating Sparklines and Mapping Data 15:18

  • 33: Create Sparklines – Introduction 00:35
  • 34: Create Sparklines 03:51
  • 35: Area Maps (2D Maps) 05:05
  • 36: Map Data – Introduction 00:40
  • 37: Map Data 04:07
  • 38: Quiz – Creating Sparklines and Mapping Data 01:00

• Forecasting Data 22:43

  • 39: Determine Potential Outcomes Using Data Tables – Introduction 00:44
  • 40: Determine Potential Outcomes Using Data Tables 05:21
  • 41: Determine Potential Outcomes Using Data Scenarios – Introduction 00:22
  • 42: Determine Potential Outcomes Using Data Scenarios 05:06
  • 43: Use the Goal Seek Feature – Introduction 00:33
  • 44: Use the Goal Seek Feature 02:56
  • 45: Forecast Data Trends – Introduction 00:16
  • 46: Forecast Data Trends 03:25
  • 47: Quiz – Forecasting Data 04:00

Would you like to become an Excel specialist and use the enormous functionality of Excel to your advantage? In this expert course, you will get to know especially helpful features, such as collaborative editing of workbooks and management of more complex Excel documents, through the implementation of tools such as formula tracking and reference functions. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

Upon successful completion of this course, you’ll be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

You will:

• Work with multiple worksheets and workbooks
• Use Lookup functions and formula auditing
• Share and protect workbooks
• Automate workbook functionality
• Create sparklines and map data
• Forecast data

This course is suitable for you, if

• you need to troubleshoot large, complex workbooks
• you wish to automate repetitive tasks
• you need to construct complex Excel functions and use those functions to perform rigorous analysis of extensive, complex datasets

• The knowledge taught in the course Microsoft 365 – Learn, Understand and Use Basic Functions and Concepts or comparable practical experience is helpful to follow the content shown in this training more easily.
• This course builds upon the foundational knowledge presented in the courses Microsoft Excel – Part 1 and Microsoft Excel – Part 2.

Currently there are no Q&As for this course. Be the first to ask a question.