Description

Course Objectives

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

Customer Feedback

Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great.

Kelly Moreley - TACT

Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys.

Jenny Price - Acer

1 year email support service

Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk

With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.

Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses.

Tailored In company training:

You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.

Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.

Recap on Excel formulas and calculations

Overview of formulas in Excel

Relative, Absolute and Mixed cell references

Group editing worksheets

Autofill and Flash Fill

Changing Excel’s environment Options

Changing the default number of sheets

Creating an Autofill Custom List

Adding tools to the Quick Access Toolbar

Mastering Excel Tables

Introducing Excel Tables

Formatting a Table

Creating Calculated Columns

Using Slicers to filter your data

Using Totals to get statistics out of your data

Removing duplicates

Converting Tables back to normal Ranges

Using names Ranges

In Excel formulas

As a way of navigating through the workbook

Advanced Formulas

Simple IF examples

Using IF to check if a cell is blank

Nested IFs

VLOOKUP

HLOOKUP

Text Functions

Date Functions

Conditional formatting

Apply Conditional Formatting

Customising Conditional Formatting

Using Icons in Conditional Formatting

Using Formulas to conditionally format cells

Linking spreadsheets and workbooks

Making a reference to another worksheet

Making a reference to another workbook

Editing links

Troubleshooting links

Analysing databases

Quick analysis

Sorting a database

Apply filters to a database

Advance filter

Sorting and Filtering by Conditional Formats

Charts

Analyse trends in data using Sparklines

Creating charts from start to finish

Exploring the different Chart Types

Apply Chart Styles

Formatting Chart Elements

Filtering Charts by Series or Categories

Adding a Trendline to a Chart

Create a Chart Template

Attaching security to a spreadsheet and workbook

Protect Cells

Protect Structure of worksheets

Protect a Workbook by adding passwords

Introduction to Pivot Tables

What are Pivot Tables?

Using recommended pivot tables to analyse your data

Who is this course for? Who is this course for?

For those who want to explore in more detail formulas and functions, data analysis and data presentation.

Requirements Requirements

Preferably, delegates would have attended the Excel Introduction course.

Career path Career path

Excel know-how can instantly increase your job prospects as well as your salary.

80 percent of job openings require spreadsheet and word-processing software skills

Course Images

Microsoft Excel Intermediate (now with live online classes) One-to-One Training

By Microsoft Office Training

Booking options

Highlights

Description

About The Provider

Tags

Reviews