Excel Training for Business
Helping you and your team understand Excel
Give your staff the confidence to perform to the standard your business deserves.
- Learning for all levels
- Develop New Skills
- Learn New Features
- Download Training Brochure
Excel Basic
Suitable for those new to Excel or who need more confidence is using some of the basic features. You will learn how to produce a spreadsheet from scratch, and how to format and work with formula and data within that spreadsheet.
Available face to face and online. Contact us today to get started.
- Creating Spreadsheets
- Entering & Editing
- Number Formats
- Navigation
- Resizing Columns
- Highlighting & Formatting
- Absolute cells references
- Creating Formula
- Formatting & Printing
- Totals
- Printing & Layout
- Headers & Footers
- Totalling & Entering data
- Sum/Min/Max/Average
- Basic Tables
Ask us a Question
“Sessions delivered by Vue IT are always in demand, our staff feedback survey has shown that they enjoy the session and meet their learning objectives. Staff are more confident in using Excel, MS Teams, Word and PowerPoint.”
Pooja at Maidstone and Tunbridge Wells NHS Trust
Excel Intermediate
This is for people who have been working with Excel and want to find out more! You will learn about using formula, working with multiple files and charts, and how to manipulate data.
Available face to face and online. Contact us today to get started.
- Working with Multiple Sheets & files
- Formula Revision / Absolute Cells References
- Inserting, Deleting, Moving and Copying Sheets
- Renaming Sheets
- Grouping Sheets
- Creating Linking and 3-D Formulas
- Creating Charts
- Creating column, line and bar charts
- Creating charts on different sheets
- Printing Charts
- Working with Tables and lists
- Sorting and filtering
- Conditional Formatting
- Linking Workbooks
Ask us a Question
“Sessions delivered by Vue IT are always in demand, our staff feedback survey has shown that they enjoy the session and meet their learning objectives. Staff are more confident in using Excel, MS Teams, Word and PowerPoint.”
Pooja at Maidstone and Tunbridge Wells NHS Trust
Excel Advanced
Designed for people wishing to improve their existing Excel skills specifically with formula, and large data sets. You will learn more about tables, vlookup and IF functions, and how to summarise data using a Pivot Table.
- PowerQuery
- Remove Duplicates
- Text Functions
- Flash Fill
- Data Validation
- Dynamic functions (Excel 365 only)
- If Functions
- Using Vlookup formula
- The new Xlookup (Excel 365 only)
- Creating and Manipulating Pivot Tables
- Sum ifs/count ifs/average ifs
- Macros
Ask us a Question
“Sessions delivered by Vue IT are always in demand, our staff feedback survey has shown that they enjoy the session and meet their learning objectives. Staff are more confident in using Excel, MS Teams, Word and PowerPoint.”
Pooja at Maidstone and Tunbridge Wells NHS Trust
Excel Advanced Plus
Excel has many useful functions. We will take a look at the Index and Match, and also at the new xlookup function which can achieve the same results.
We will also look at the Ifs group of functions, that allow us to ask questions of Excel, and then perform a function on that data if it meets a particular criteria.
There are also a number of new dynamic functions in Excel which change as the data changes. These make filtering easier and quicker and avoid the limitations encountered by autofilter.
Finally we will look at how we can use Power Query to group and consolidate Excel files.
- Index and Match/xlookup
- Sumifs/countifs/averageifs/ifs
- Dynamic functions
Dynamic functions allow you to work with live data without having to go into Power Query, and reduce the need to use Autofilter. As you update your source data, the function will automatically update.
- Filter, Sort, Sequence and Unique (these functions enable the extraction of data to easily and quick solve complicated problems.)
- Take, Wrap Rows/Wrap Columns, Choose Rows/Choose Columns allow you to easily grab chunks of data from a source.
- Power Query
- Combine Files
- Combine Multiple Sheets
Ask us a Question
“Sessions delivered by Vue IT are always in demand, our staff feedback survey has shown that they enjoy the session and meet their learning objectives. Staff are more confident in using Excel, MS Teams, Word and PowerPoint.”
Pooja at Maidstone and Tunbridge Wells NHS Trust
Power Query
Are you still using Sort and Filter in Excel? Power Query comes with Excel, and is like autofilter on steroids! You can move columns around, easily remove unwanted columns, sort, filter and join/split data. The end result is cleaned data, set out in the way your want.
Introduction to Power Query
- The Power Screen Interface
- Naming a Query
- Query Steps
- Refreshing and Editing Queries
Filtering with Power Query
- Applying a Filter
- Removing columns
- Rearranging columns
Transforming Data
- Changing Case
- Fill data
- Split Columns
- Removing Duplicates and Errors
Collating Data
- Summarising multiple sheets
- Summarising data from multiple files
IF Functions
Merge and Append Queries
Speak to us about arranging a course for you and your staff.
Microsoft Excel Refresher
Is it a while since you did an Excel course? This course will recap on some of the classics (eg formula and absolute cells!) plus introduce some of the newer Excel features that you will be wonder how you lived without.
Here is the course outline.
Working with Tables
- Creating tables that are dynamic
- Naming, total rows and banded rows
- Flash fill and Ghosting
Power Query
- Filtering and sorting using Powerpoint query
- Extracting data from a list
- Combining Queries
- Total several sheets
New Dynamic Functions
- Xlookup function
- Filter Function
- Unique Function
- Sort & Sortby Function
Speak to us about arranging a course for you and your staff.
Free taster lesson
How Shortcuts can make you more productive
Simply sign up to our mailing list to get your free recording
Why VUE IT Training
You’re in safe hands with one-on-one support from expert trainers who have many years of experience supporting delegates both onsite and online for years – just look at some testimonials we’ve had back for proof!
