Intermediate Excel - Data Management & Add-In's

Giving you the skills to fully utilise Excel
Overview

Excel has long been a popular choice for creating spreadsheets, analysing data and creating graphical representations of information. Excel has more bells and whistles than any version before it, and can be daunting for a novice user.

There are few things in life more impressive than a properly formatted and presented spreadsheet, so if you want to dazzle colleagues with your workbook wizardry or automate a process you repeat every day then this is the course for you.
 

Course Code
INT0.5EXCP2
Duration
0 Day
Delivery Style
Virtual
Course Type
Public or Private
Max Delegates
12
Available as Nutshell
No

Book your virtual training

  • Date
  • Venue
  • Cost
  • More info

Book your place

Purpose of this course

This course will introduce you to Excel and give you the skills to use the program every day as well as the knowledge of advanced functions and features. 

Who is this course for

Super users that will be responsible for not only using Excel themselves for also training their colleagues on how to make the most of the application.

You will learn how to
  • Create and customise workbooks in Excel.  
  • Use Excel as a day to day user.
  • Present data graphically.
  • Create Pivot tables and graphs.
  • Use Excel functions and formulae for mathematical processes and automation.
  • Program Excel using Visual Basic.
Benefits for your organisation

This course will enable delegates to format and present data in easier to understand ways, as well as improving their efficiency through the use of advanced Excel Macros and shortcuts. 

Benefits for you as an individual

An in-depth knowledge of Excel is useful for any role in an organisation and can make day to day data management quicker and easier.

Advanced Data Management
  • Managing large datasets
  • Grouping
  • Outlining 
  • Subtotalling
Excel Add-Ins
  • Scenario Manager
  • Data analysis ToolPak
  • Correlation Analysis
  • Predictive modelling
  • Solver
Prerequisites

There are no prerequisites for this course though a basic knowledge of Microsoft Office would be advantageous. 

About the Lead Trainer

Jason is one of the technical trainers here at Quanta covering areas such as the CompTIA course track and Microsoft systems and applications. Jason has previously worked as a web designer, system administrator and technical consultant for organisations including a plant nursery and web service provider.

When he’s not at Quanta, Jason is an avid American Football fan and can also occasionally be found singing and dancing with local Amateur Gilbert and Sullivan societies. He does however promise to keep the theatrics to a minimum in the classroom.