PrintDURATION: 1 day
|TIME: 09:00 to 16:00 GMT|
Join our Advanced Excel courses online and we guarantee to improve your efficiency when dealing with company data. IPSO FACTO is based at Fareham, between Southampton and Portsmouth, Hampshire, UK. However, this course can be delivered live online or onsite across the UK.
Time is one of your most valuable resources and the cost relating to the inefficient use of your time can be enormous. Excel is a widely used Microsoft App that many workers use on a regular basis, and can without training be a major time waster. During this popular IPSO FACTO Advanced Excel course you will learn techniques to significantly improve your efficiency when dealing with data.
The course covers a wide range of useful business tools, techniques and formulas that will enable you to protect, control, analyse and manipulate company data. You don’t have to be an expert to attend this course, but you will find some of the topics easier to understand if you use Excel on a regular basis. The course is structured but informal, and you will be encouraged to ask and answer questions throughout. The Advanced Excel course is supported by other related Microsoft courses.
If you use Excel on a regular basis and want to learn new time saving techniques but want to explore some of the more advanced Excel features useful in a business environment then this course is suitable for you. Perfect for Managers, IT Support, Supervisors, Executives, Business owners and those who want to explore advanced techniques.
You must also consider two related apps that may benefit you: Microsoft PowerBI (Business Intelligence) and Microsoft Power Automate. The PowerBI desktop app is free to download and is perfect to manage your company data.
Virtual classroom using Microsoft Teams: £850+VAT for up to 8 delegates
On-site: £950+VAT for up to 8 delegates (rates may differ if outside Hampshire, Dorset and Wiltshire)
To improve your business efficiency using a range of Advanced Excel tools and techniques.
The advanced Excel course online content may change slightly to reflect the needs of the course delegates.
Precedents and Dependents – Tracking all formula relationships on a worksheet – Evaluate Nested Formulas
“A very useful technique to help understand the structure and accuracy of a complex spreadsheet”.
Functions LEFT, RIGHT, MID, FIND, LEN. LEN and FIND. RIGHT, LEN and FIND
“You will be able to extract and join together various elements of data from a large list”.
Control – Options – Business uses – Working with Validation
“We explore various validation techniques to control a users experience with a spreadsheet”.
Overview of Protection – Securing a workbook – Worksheet element protection – Remove protection – Allow users to edit ranges of cells – Protection of worksheet and workbook elements – Workbook Structure and Windows protection – Mark as Final options
“The ability to protect elements of a spreadsheet using different techniques will allow you to control how users interact with it”.
Using Goal Seek – Solver – Scenario – Business uses
“A fantastic set of business tools that will allow you to quickly ask a wide range of business questions”.
Create – Edit – Update – Delete reports – Calculated Fields
“We explore the ability to create detailed Pivot tables using calculated fields and Slicers”.
Creating – Using – Formatting – Disconnect and Delete Slicers
“Slicers are a useful visual filters with lists of data”.
Create a data type using Power Query
Import, Connect and Transform data using Microsoft Power Query