Microsoft Office Excel 2016: Part 2 (Intermediate Level) Course

This comprehensive excel 2016 intermediate leve course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Office Excel can also take this course.

Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector.

This excel 2016 intermediate leve course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection.

This excel 2016 intermediate leve course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%.

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 Function
• 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 Data
• Query Data with Database Functions
• Database Functions
• Outline and Subtotal Data – Introduction

Analyzing Data

• Create and Modify Tables – Introduction
• Create and Modify Tables
• Use Summary Functions in Tables
• Apply Intermediate Conditional Formatting – Introduction
• 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
• Bonus Lecture