Professional Training Courses for Microsoft Office and Social Media
or Call NOW on 01952 581550

Microsoft Excel Training

SecretsNinjasGurusBusiness IntelligenceDashboards

Excel Secrets (Level 1)


Learn all the basics to create and manage spreadsheets yourself and we cover the 5 basic formulas everyone should know! Secrets of formatting and navigating super-fast and how to create charts which are stunning representation of your figures. You will create a chart with one click and learn how to manage large workbooks. A day crammed with delightful shortcuts and quicker ways to work!

Our Excel Secrets course covers Tips & Tricks for selection, navigation and using shortcuts for all the things that normally would take twice the time (which you do a lot!).

You’ll learn all the basics to create and manage spreadsheets yourself and we cover the 5 basic formulae everyone should know!

We teach the secrets of formatting super-fast and how to format your charts so they are a stunning representation of your figures. You’ll create a chart with one click and learn how to manage large workbooks.

You’ll introduce coloured icons into your spreadsheets with Conditional Formatting so you can see at once your important data. At the end of this training course you’ll feel like an Excel Wizard!

Who is it for?

This One Day course is specifically designed for office staff/managers with little or no previous knowledge of Excel, or no prior formal training. You should be able to use a keyboard and mouse and know how to save documents. This course will cover the basics of using Spreadsheets and will look in detail at:

Course Content

Getting started

  • Moving nimbly around the spreadsheet with lots of navigation shortcuts thrown in!

Entering and editing data

  • How to enter text, numbers, formula and pictures and how to work with them.

Modifying a worksheet

  • As your spreadsheet develops, you need to make changes and if you don’t know these few simple steps it can all go horribly wrong! We cover the basics of how to insert or delete rows and columns and copy formula without getting a nasty error message.

Using functions

  • Learn the simple ways to create formulas and the 5 basic formulas everyone should know!

Formatting

  • Getting to grips with that tricky formatting of text and numbers so your spreadsheets are easy to read and look amazing in just seconds.

Printing

  • Don’t get tied up in knots with printing – a few simple rules will help you print your spreadsheet right first time.

Charts

  • Starting with chart basics we’ll take you through how to format your charts so they are stunning representations of your figures.

Managing large workbooks

  • Working with large or multiple worksheets? You need to know how to traverse them in seconds and how to move and copy data within them.

Graphics and screenshots

  • Work with the beautiful new graphics features and see how you can simply take a screenshot.

Excel Ninjas (Level 2)

You’ll cover manipulating multiple files and worksheets, 3D formulas, linking cells and editing links; special number formats to speed up data entry; ways to collapse large workbooks to see the totals you need and advanced charting; Make amazing tables in one click with secret built in formula; You’ll learn how to speed up navigation around your spreadsheet and use range names in formula; using the auditing features to check your work and protect your spreadsheet. We take a look at useful built in templates and how you can use them and finish with a first look at Pivot Tables and Charts.

To help you become an Excel Ninja on this course we cover manipulating multiple files and worksheets, 3D formulas, linking cells and editing links.

We also look at special number formats to speed up data entry, ways to collapse large workbooks to see the totals you need and advanced charting – making amazing tables in one click with the secret built in formula!

You’ll learn how to speed up navigation around your spreadsheet and use range names in formula; using the auditing features will allow you to check your work and protect your spreadsheet.

We take a look at useful built in templates and how you can use them and finish with a first look at Pivot Tables and Charts.

Course Content

Using multiple worksheets and workbooks

  • We’ll show you how to use multiple workbooks and link them to save replication and keep data up to date. You’ll also learn the magic of 3-D formulas

Advanced formatting

  • How to save time using special number formats and working with functions to format text.

Outlining and subtotals

  • Learn the amazing benefits of using Outlining on large lists of data and how to consolidate data to see totals by category and how to quickly and easily create subtotals.

Cell and range names

  • See the advantages of creating and using range names in your spreadsheets and how to manage them.

Tables

  • You’ll get the upper hand by knowing how to create a table in one click so you can easily sort and filter your data.

Advanced charting

  • Take your charting skills to a professional level by learning how to use 5 key types of charts and manipulate them to show off your data!

Documenting and auditing

  • Discover how the professionals use Auditing features to find and eradicate errors in their spreadsheets, why and how to use Workbook Protection in your spreadsheets.

Templates and settings

  • Tired of creating the same documents over and over again? Learn how to simply create templates you can use repeatedly.

PivotTables and PivotCharts

  • Learn the secrets of PivotTables and feel like a Jedi Master of Excel!

Excel Gurus (Level 3)

You will learn how to become an Excel Guru using Logical functions to work out ‘What IF’ questions. We cover 5 Popular Math and statistical functions for geeks but in a way that makes it easy to understand and conquer! Financial, Date and Time functions and Array formulas, together with VLOOKUP, will ensure you’ve got all the tools to manipulate Advanced Formula. You will cut down on data entry errors with Advanced Data Management; Cover importing and exporting data into Excel, how to use built-in Analytical tools like Goal Seek and Solver and finally discover how to cut down repetitive tasks by creating your own macros.

On this course you’ll learn how to use Logical functions to work out ‘What IF’ questions. We cover The 5 Most Popular Math and Statistical Functions for Geeks but in a way that makes it easy to understand and conquer! Financial, Date and Time Functions and Array Formulae, together with VLOOKUP, will ensure you’ve got all the tools to manipulate Advanced Formula. You will cut down on data entry errors with Advanced Data Management; cover Importing and Exporting Data into Excel, how to use built in Analytical Tools like Goal Seek and Solver and finally discover how to cut down repetitive tasks by creating your own Macros. The ability to use advanced formulas will set you apart giving you that all important edge in knowledge and skills enabling you to do your work faster and more effectively.

Excel is one of the world’s most popular software programmes used by millions of people – but many are untrained and only use up to 10% of it’s features. The ability to use advanced formulas will set you apart giving you that all important edge in knowledge and skills enabling you to do your work faster and more effectively.

What You Will Learn

This course is specifically designed for office workers, managers, accountants and data analysts. Delegates on this course should have existing Intermediate knowledge of Excel, and we will turn you into Excel Guru’s. We will cover some of Excel’s best kept secrets and will look in detail at:

Course Content

Logical and statistical functions

  • Become an Excel Guru using Logical functions to work out ‘What IF’ questions. We cover 5 Popular Math and statistical functions for geeks but in a way that makes it easy to understand and conquer!

Financial and date functions

  • If you need to know how to use Financial, Date and Time functions and Array formulas, you’re on the right course!

Lookups and data tables

  • Need to know the fundamentals of VLOOKUPs? We’ll make sure you understand all the essentials and give you some great examples. Depending upon your needs we may also cover using MATCH and INDEX and creating Data Tables

Advanced data management

  • Want to speed up data entry on your spreadsheets? Then validating cell entries is one lesson you won’t want to miss. Build Drop down lists, data entry conditions like ‘not before date’ and fix how many characters can be input. Sure fire way to cut down data entry errors!

Exporting and importing

  • Need to be a wizz at Exporting and Importing text files? If you work with external databases and want to manipulate that data in Excel this lesson is for you!

Analytical tools

  • Now we’re uncovering some of Excel’s best kept secrets such as how you can use Goal Seek and Solver to find the answer to your business questions! Take a peek at the Analysis ToolPak and see how you can easily create ‘Scenarios’ to show different ‘What if’ situations and choose the best options.

Macros and custom functions

  • You know you’re on your way to being an Excel Guru when you can create macros in Excel. We’ll even show you some of the behind the scenes VBA code and how to use functions within your macros.

Excel Business Intelligence (Level 4)

When you need to see all your key business data and be able to visualise what this data means…Learn how to shape and show your data faster using Get & Transform, Power Pivot, Power Maps and Power View.

This course is designed for an Advanced Excel user to Understand the capability of the new Business Intelligence tools in Excel and use them to create great data visualisations and dashboards. Our Excel Business Intelligence course has been developed to fill the gap with this innovative new collection of add-on features in Microsoft Excel 2013. This course runs through getting the BI modules installed, then how to use the 4 new tools – Power Query, Power Pivot, Power View and Power Maps.

  • Days of training:  One
  • Pre-requisites:  Basic Windows Knowledge, Excel 2013 Advanced
Course Content

How to Get BI Installed

  • First Steps

Power Query

  • Identify Data Sources Internally
  • Search for data publicly available
  • Previewing data
  • Security
  • Combining data from different sources
  • Sharing to collaborate with others

Power Pivot

  • Manipulating large amounts of data
  • Joining data from several tables
  • Creating & Editing Relationships between files and Tables
  • Power PivotTables and PivotCharts

Power View

  • Creating a new Dashboard
  • Using data from multiple sources
  • Types of Charts
  • Types of Tables
  • Using Filters
  • Deleting & Editing Dashboard elements
  • Refreshing Data
  • Power Maps
  • Launching Power Map
  • Creating New Maps
  • Layers
  • Geography and Map Level
  • Types of Map Themes
  • Adding Map Labels
  • Creating Video
  • Adding Scenes
  • Playing a Tour
  • Adding Music
  • Playing within PowerPoint

Excel Dashboards (Level 5)

If the numbers you need to track are spread out across different systems, learn how to have everything on one screen so all you need to do is give it a glance. Yes, it’s time to make a dashboard. It’s like the instrument panel for your business. Your car has one. Planes have one. Let us help you make one for your business too.