Excel Level 1

Introduction

This course is ideal for both inexperienced users to Excel and long-term users who have had no formal training (often self-taught) and would like to make sure they are prepared for further levels. A general understanding of the personal computer and Windows would be useful. There are lots of useful time-saving tips.

Introduction to Spreadsheets
Data Entry
The Ribbon Bar
Selecting Data
Selecting Multiple Ranges
Fill
Resizing
Insert New Columns and Rows
Formatting
Date and Time Entries & Functions
Notes and Comments
Working with Multiple Worksheets
Copy & Fill
Percentage
Sorting Data
Filter Data
Find Data
Page Setup
Show Formulas
Freeze Panes
Aggregate Functions
Conditional Formatting
Basic Charts
Handy Shortcuts

Excel Level 2

Intermediate

This course is designed for users who wish to increase their skills and knowledge of spreadsheets and Microsoft Excel. This level will help the delegate to produce more productive spreadsheets using formulas and function techniques. Please make sure you can carry out at least 80% of the Level 1 content and be able to enter formulas to carry out calculations.

Logic Functions
IF Function
Concatenation
Unique and Sort Array Functions (365)
Count – Average – Sum – Maximum – Minimum Functions
Nested IF Function
AND OR NOT
Static Dates and Times
Custom Date Formats
Custom Time Formats
Dynamic Dates and Times
Basic Date Calculations
Date Functions
Custom Fill
Naming Cells & Ranges
Managing Names
VLOOKUP Function
IFERROR and IFNA
HLOOKUP Function
Match Function
Index Function
Index & Match
XLOOKUP
Filter
Handy Shortcuts

Excel Level 3

Advanced

This course is designed for users who have a good knowledge and understanding of spreadsheets and wish to use more advanced features of the programme.

This level covers a lot of the built in features to help you carry out your tasks at work.

Naming Cells & Ranges
Excel Forms
Scenario Manager
Goal Seek
Data Validation
Subtotals
Grouping & Outlining
Toolbars
Pivot Tables
Pivot Charts
Tables
Excel Macros
Macro Security
Saving a Macro Workbook
Recording & Running a Macro
Relative Cell References (Macros)
Viewing & Editing a Macro
Assigning Macros
Global Macros

Excel Level 4

Power Pivot - Masterclass

If you analyse data from many sources e.g. CSV, Text, Access etc. or you have too much data to fit on a traditional worksheet then understanding how to use the most up to date features of Excel will benefit you and your staff.
This course provides a solid foundation and understanding of Power Query, Power Pivot and DAX.

This course is ideal for experienced users who are responsible for analysing data from many sources and have a good understanding of Excel functions and formulas.

Power Query
Sources of Data
Power Query Editor
Query Editor Tools
Loading Data from Power Query
Pivoting and Unpivoting
Modify Queries
Merging Queries
Appending Queries
Connect to a Folder of Files
Data Model Views
Database Normalisation
Data and Lookup Tables
Primary and Foreign Keys
Star and Snowflake Schemes
Editing Relationships
Active and Inactive Relationships
Cardinality
Connecting Multiple Tables
Filter Direction
Hiding Fields
Hierarchies
Assignment
Power Pivot
Calculated Columns
Where to use calculated Columns
DAX Measures
Create Explicit Measures (within Power Pivot)
Data Analysis Expressions (DAX)
Basic Measures

PowerPoint

PowerPoint in a Day

This course is designed for users who either have no knowledge of PowerPoint or have some knowledge and wish to learn more about its features. The course is also suitable for users who would like a refresher of the basics. A general understanding of the personal computer and Windows would be useful.

The aim of this course is to look at all the features of PowerPoint and how to produce memorable slides to help the audience remember what the presenter is delivering. Don't make do with basic Microsoft templates when you can easily create stunning corporate presentations yourself. This is a practical hands-on course, where you get the opportunity to practice creating stunning slides and not just a bullet point type presentation.

Presenter View
Inspirational Ideas & Resources
PowerPoint Views
The Ribbon Bar
Presenting & Changing Slides
Planning a Presentation
Importing Slides (Two Methods)
Slide Layouts
Slide Master
Working with Images
Shapes
Slide Transitions
Animations
Motion Paths
WordArt
SmartArt
Tables
Charts
Audio Clips
Video Clips
Optimizing and Compressing Media
Notes Page
Printing
Action Buttons & Hyperlinks
Hyperlinks
Slide Sorter View
Sections
Saving a Presentation
Sharing a Presentation
Creating Handouts
Shortcuts

NOTE: POWERPOINT

This course works better if each delegate has two monitors