Microsoft Office Training ltd

 

Quick 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

​

​

​