Microsoft Excel Intermediate Training contains all formulas that are required to be known in all jobs. It can also be beneficial for those who just finished the university studies and looking for a job in any sector.

Only relevant and essential exercises that you will need to know in work. It will require a good understanding of basic Excel knowledge.

This course will help you to learn all formulas that could be required for any jobs, and with the help of this course, your Excel knowledge will be outstanding.

We will guide you step by step through the Intermediate Microsoft Excel formulas to advanced level and beyond. You will start with the basics,  building a solid foundation that will give you further knowledge as you progress into the more advanced level topics,  array functions.

At the completion of this Microsoft Excel Intermediate course, you will be able to complete any Excel tasks with efficiency and proficiency.

This Microsoft Excel Intermediate training course is suitable whatever version of Excel you use, from 2007 – 2016, you will expand your knowledge and skills. By the end of this course, you will be able to create charts, work efficiently with multiple sheets in workbooks, use essential functions effectively, use productivity tools and work with the Excel list/database features.

Led by highly experienced Microsoft Excel trainers with many years of experience our hands-on courses mean that you will leave with lots of practical Excel experience as well as useful tips and tricks.

The goal of this course is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyze data in spreadsheets, such as sorting, filtering, conditional formatting, and auditing.

You will also organize table data and present data as charts.

You will discover how Excel spreadsheets are constructed and be given a clear path on how to create templates.

You might be interested in MS Excel Advanced training as a next step.

This officially accredited Microsoft course.

YOU WILL LEARN HOW TO

• Quickly summarise multiple sheets of data into one

• Turn long lists and reports into easy to read tables

• Formulas to check whether cells pass or fail your rules

• Create links between cells so that they all update automatically

• Highlight targets, trends, duplicates and errors with Conditional Formatting

• Formatting and layout consistency by saving as a Template

IMPORTANT COURSE INFORMATION

Requirements

Students should have strong basic skills with Microsoft Excel.

Certificate

Students will receive official Microsoft Certificate.

COURSE OUTLINE

Using Named Ranges in Formulas

Use Financial Functions
Using Named Ranges in Formulas

Naming a Single Cell

Naming a Range of Cells

Naming Multiple Single Cells Quickly

Using Formulas That Span Multiple Worksheets

Using the IF Function

Using AND/OR Functions

Using the SUMIF, AVERAGEIF, and COUNTIF Functions

Using the PMT Function

Using the LOOKUP Function

Using the VLOOKUP Function

Using the HLOOKUP Function

Using the CONCATENATE Function

Using the TRANSPOSE Function

Using the PROPER, UPPER, and LOWER Functions

The UPPER Function

The LOWER function

The TRIM Function

Using the LEFT, RIGHT, and MID Functions

The MID Function

Using Date Functions

Using the NOW and TODAY Functions

Creating Scenarios

Utilize the Watch Window

Consolidate Data

Enable Iterative Calculations

What-If Analyses

Use the Scenario Manager

Use Financial Functions

Module 2: Working with Lists
Converting a List to a Table

Removing Duplicates from a List

Sorting Data in a List

Filtering Data in a List

Adding Subtotals to a List

Grouping and Ungrouping Data in a List

Working with Large Worksheets

Working with Multiple Worksheets and Workbooks

Working with dates

List Management

Documenting and Auditing

Using Templates

Module 3: Working with Illustrations
Working with Clip Art

Using Shapes

Working with SmartArt

Module 4: Visualizing Your Data
Creating a Custom Chart Template

Inserting Charts

Add and Format Objects

Insert a Text Box

Create a Custom Chart Template

Module 5: Working with Tables
Mastering Excel Tables

Organising Worksheet Data

Charts

Format Data as a Table

Move between Tables and Ranges

Modify Tables

Define Titles

Auditing a Worksheet

Analysing Selected Data

Module 6: Advanced Formatting
Applying Conditional Formatting

Working with Styles

Creating and Modifying Templates

Advanced Pivot Tables

Module 7: Microsoft Excel Features that Were New in 2013
New Functions in Excel 2013

Using New Chart Tools

Using the Quick Analysis Tool

Using the Chart Recommendation Feature

Module 8: Features New in 2016
New Charts

Treemap

Sunburst

Histogram

Waterfall

Box and Whisker

Pareto