Microsoft Excel 2016 Intermediate Level

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

• Course Overview 02:26

  • 2: Introduction and Course Overview 02:26

• Working With Functions 1:08:25

  • 3: Work With Function – Introduction 01:04
  • 4: Work with Ranges – Introduction 00:56
  • 5: Name and Edit Ranges 05:34
  • 6: Use Defined Names in a Formula 03:12
  • 7: Locate and Use Specialized Functions 05:06
  • 8: Work with Logical Functions – Introduction 05:06
  • 9: IF Function 04:29
  • 10: AND, OR and NOT Function 05:40
  • 11: Combine Functions 06:18
  • 12: Functions Similar to the IF Function 05:14
  • 13: Work with Date and Time Functions – Introduction 01:23
  • 14: Today Now and Date Functions 02:54
  • 15: Networkday, Weekday, Workday and Isoweeknum Functions 05:28
  • 16: Work with Text Functions – Introduction 00:47
  • 17: Left, Right and MID Functions 02:40
  • 18: Find Function 03:19
  • 19: Text to Columns Feature 03:38
  • 20: Concatenate Function 02:59
  • 21: Upper, Lower and Proper Functions 02:38

• Working With Lists 14:33

  • 22: Short Data – Introduction 00:30
  • 23: Sort Data 03:00
  • 24: Filter Data – Introduction 00:36
  • 25: Filter Data 02:29
  • 26: Query Data with Database Functions 00:42
  • 27: Database Functions 03:12
  • 28: Outline and Subtotal Data – Introduction 00:36
  • 29: Use Subtotals to Summarize Data 03:28

• Analyzing Data 18:26

  • 30: Create and Modify Tables – Introduction 00:44
  • 31: Create and Modify Tables 06:49
  • 32: Use Summary Functions in Tables 03:21
  • 33: Apply Intermediate Conditional Formatting – Intrudaction 00:41
  • 34: Apply Intermediate Conditional Formatting 02:44
  • 35: Apply Advanced Conditional Formatting – Introduction 00:35
  • 36: Use Logical Functions to Apply Conditional Formatting 03:32

• Visualizing Data With Charts 23:20

  • 37: Create Charts – Introduction 00:38
  • 38: Create Charts 04:28
  • 39: Modify and Format Charts – Introduction 01:09
  • 40: Modify and Format Charts 05:15
  • 41: Use Advanced Chart Features – Introduction 00:29
  • 42: Create a Dual-Axis Chart 04:27
  • 43: Create a Chart Template 03:02
  • 44: Visualizing Data with Charts – Best Practice 03:52

• Using PivotTables And PivotCharts 24:59

  • 45: Create a PivotTable – Introduction 00:17
  • 46: Create a PivotTable 04:03
  • 47: Analyze PivotTable Data – Introduction 00:38
  • 48: Analyze PivotTable Data 04:29
  • 49: Analyze PivotTable Data 04:29
  • 50: Present Data with PivotCharts – Introduction 00:50
  • 51: Present Data with PivotCharts 05:01
  • 52: Filter Data by Using Timelines and Slicers – Introduction 00:54
  • 53: Filter Data by Using Slicers and Timelines 04:18

• Obtain Your Accredited Certificate of Achievement 02:00

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

The intermediate level Microsoft Office Excel 2016 training 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 intermediate level Microsoft Office Excel 2016 training course come with lifetime access with no time limit for completion. Each module of this intermediate level Microsoft Office Excel 2016 training is fully accessible from a tablet, mobile or laptop, as long as there is a secure internet connection.

Course Syllabus:

We have divided the intermediate level Microsoft Office Excel 2016 training course into 52 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 intermediate level Microsoft Office Excel 2016 training course includes the following modules:

Course Overview

• Introduction and Course Overview

Working With Functions

• Work With Function – Introduction
• Work with Ranges – Introduction
• Name and Edit Ranges
• Use Defined Names in a Formula
• Locate and Use Specialized Functions
• Work with Logical Functions – Introduction
• IF Function
• AND, OR and NOT Function11
• Combine Functions
• Functions Similar to the IF Function
• Work with Date and Time Functions – Introduction
• Today Now and Date Functions
• Networkday, Weekday, Workday and Isoweeknum Functions
• Work with Text Functions – Introduction
• Left, Right and MID Functions
• Find Function
• Text to Columns Feature
• Concatenate Function
• Upper, Lower and Proper Functions

Working With Lists

• Short Data – Introduction
• Sort Data
• Filter Data – Introduction
• Filter Data11
• Query Data with Database Functions
• Database Functions
• Outline and Subtotal Data – Introduction
• Use Subtotals to Summarize Data

Analyzing Data

• Create and Modify Tables – Introduction
• Create and Modify Tables
• Use Summary Functions in Tables
• Apply Intermediate Conditional Formatting – Intrudaction
• Apply Intermediate Conditional Formatting
• Apply Advanced Conditional Formatting – Introduction
• Use Logical Functions to Apply Conditional Formatting

Visualizing Data With Charts

• Create Charts – Introduction
• Create Charts
• Modify and Format Charts – Introduction
• Modify and Format Charts
• Use Advanced Chart Features – Introduction
• Create a Dual-Axis Chart
• Create a Chart Template
• Visualizing Data with Charts – Best Practice

Using PivotTables And PivotCharts

• Create a PivotTable – Introduction
• Create a PivotTable
• Analyze PivotTable Data – Introduction
• Analyze PivotTable Data
• Present Data with PivotCharts – Introduction
• Present Data with PivotCharts
• Filter Data by Using Timelines and Slicers – Introduction
• Filter Data by Using Slicers and Timelines

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 intermediate level Microsoft Office Excel 2016 training 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 intermediate level Microsoft Office Excel 2016 training 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 intermediate level Microsoft Office Excel 2016 training 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 intermediate level Microsoft Office Excel 2016 training 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 intermediate level Microsoft Office Excel 2016 training 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 intermediate level Microsoft Office Excel 2016 training 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.