Microsoft Excel Advanced

Lead Academy

Reed Courses Certificate of Completion

Digital certificate - Included

• Obtain Your Student ID Card 01:00

  • 1: Obtain Your Student ID Card 01:00

• Supplementary Resources 01:00

  • 2: Supplementary Resources – Microsoft Excel 2016 for Professionals Online Training 01:00

• Working With Multiple Worksheets And Workbooks 17:25

  • 3: Use Links and External References – Introduction 01:04
  • 4: Use Links and External References 05:37
  • 5: Use 3-D References – Introduction 00:49
  • 6: Use 3-D References 04:23
  • 7: Consolidate Data – Introduction 00:31
  • 8: Consolidate Data 05:01

• Using Lookup Function And Formula Auditing 17:26

  • 9: Use Lookup Functions – Introduction 00:49
  • 10: Use Lookup Functions 08:13
  • 11: Trace Precedent and Dependent Cells – Introduction 00:44
  • 12: Trace Precedent and Dependent Cells 02:58
  • 13: Watch and Evaluate Formulas – Introduction 00:44
  • 14: Watch and Evaluate Formulas 03:58

• Sharing and Protection Workbooks 13:47

  • 15: Collaborate on a Workbook – Introduction 00:43
  • 16: Collaborate on a Workbook 05:32
  • 17: Compare and Merge Workbooks – Introduction 02:52
  • 18: Protect Worksheets and Workbooks - Introduction 00:38
  • 19: Protect Worksheets and Workbooks 04:02

• Automating Wordbook Functionality 16:56

  • 20: Apply Data Validation - Introduction 00:51
  • 21: Apply Data Validation 04:16
  • 22: Search for Invalid Data and Formulas with Errors – Introduction 00:39
  • 23: Search for Invalid Data and Formulas with Errors 02:59
  • 24: Work with Macros – Introduction 00:40
  • 25: Work with Macros 05:17
  • 26: Edit a Macro 02:14

• Create Sparklines and Map Data 09:20

  • 27: Create Sparklines – Introduction 00:41
  • 28: Create Sparklines 03:53
  • 29: Map Data – Introduction 00:39
  • 30: Map Data 04:07

• Forecasting Data 18:40

  • 31: Determine Potential Outcomes Using Data Tables – Introduction 00:44
  • 32: Determine Potential Outcomes Using Data Tables 05:21
  • 33: Determine Potential Outcomes Using Data Scenarios – Introduction 00:22
  • 34: Determine Potential Outcomes Using Data Scenarios 05:06
  • 35: Use the Goal Seek Feature – Introduction 00:33
  • 36: Use the Goal Seek Feature 02:55
  • 37: Forecast Data Trends – Introduction 00:15
  • 38: Forecast Data Trends 03:24

• Obtain Your Accredited Certificate of Achievement 02:00

  • 39: Obtain Your Accredited Certificate of Achievement 02:00

The Microsoft Excel: advanced training in Microsoft Excel 2016 is a popular training course, ideal for anyone who is looking to kickstart their career as a office admin, as well as professionals who want to test their existing skills and knowledge. If you want to gain an in-depth understanding of Microsoft Office Excel, then this program is perfect for you.

This online Microsoft Excel: advanced training in Microsoft Excel 2016 course come with lifetime access with no time limit for completion. Each module of this Microsoft Excel: advanced training in Microsoft Excel 2016 is fully accessible from a tablet, mobile or laptop, as long as there is a secure internet connection.

Course Syllabus:

We have divided the Microsoft Excel: advanced training in Microsoft Excel 2016 course into 38 user-friendly modules, covering all fundamental areas of Microsoft Office Excel to provide learners with the relevant skills and industry knowledge to take their career to the next level.

This comprehensive Microsoft Excel: advanced training in Microsoft Excel 2016 course includes the following modules:

Working With Multiple Worksheets And Workbooks

• Use Links and External References – Introduction
• Use Links and External References
• Use 3-D References – Introduction
• Use 3-D References
• Consolidate Data – Introduction
• Consolidate Data

Using Lookup Function And Formula Auditing

• Use Lookup Functions – Introduction
• Use Lookup Functions
• Trace Precedent and Dependent Cells – Introduction
• Trace Precedent and Dependent Cells
• Watch and Evaluate Formulas – Introduction
• Watch and Evaluate Formulas

Sharing and Protection Workbooks

• Collaborate on a Workbook – Introduction
• Collaborate on a Workbook
• Compare and Merge Workbooks – Introduction
• Protect Worksheets and Workbooks
• Protect Worksheets and Workbooks

Automating Wordbook Functionality

• Apply Data Validation
• Apply Data Validation
• Search for Invalid Data and Formulas with Errors – Introduction
• Search for Invalid Data and Formulas with Errors
• Work with Macros – Introduction
• Work with Macros
• Edit a Macro

Create Sparklines and Map Data

• Create Sparklines – Introduction
• Create Sparklines
• Map Data – Introduction
• Map Data

Forecasting Data

• Determine Potential Outcomes Using Data Tables – Introduction
• Determine Potential Outcomes Using Data Tables
• Determine Potential Outcomes Using Data Scenarios – Introduction
• Determine Potential Outcomes Using Data Scenarios
• Use the Goal Seek Feature – Introduction
• Use the Goal Seek Feature
• Forecast Data Trends – Introduction
• Forecast Data Trends

Method of Assessment

On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately.

Certificate of Achievement

Endorsed Certificate from Quality Licence Scheme

After successfully passing the MCQ exam you will be eligible to obtain Microsoft Excel: advanced training in Microsoft Excel 2016 Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organization for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65.

Certificate of Achievement from Lead Academy

After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.

This comprehensive Microsoft Excel: advanced training in Microsoft Excel 2016 course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Office Excel.

This Microsoft Excel: advanced training in Microsoft Excel 2016 course is felicitous for those, who want to be the best in their jobs.

Whether you are completely new to the field or are an aspiring professional, the Microsoft Excel: advanced training in Microsoft Excel 2016 course will help open doors to a wide range of professions within your chosen field, helping you to stand out to employers with up-to-date skills that can be used to enhance your CV.

• There are no academic entry requirements for this Microsoft Excel: advanced training in Microsoft Excel 2016 course, and it is open to students of all academic backgrounds.
• As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol.

This Microsoft Excel: advanced training in Microsoft Excel 2016 course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry.

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