Microsoft Excel Training
Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction.
For more demanding uses, Excel can be used to create charts, automate spreadsheets, apply advanced formulas, create Pivot tables and much much more!
Please select the version that you’re interested in
Please select the level that you’re interested in
Microsoft Excel 2010 Advanced
This course is aimed at experienced Excel users who need to perform more complex functions, lists analysis, use What-If tools and who would like to start recording basic macros.
You must have sound Excel skills and understand key concepts of spreadsheets, or equivalent to our Intermediate course level.
This is a 1 day Excel Advanced Course. The course starts at 09:30 and runs until 16:30. Alternate timings can be arranged upon request. The course can be held on a date that suits you.
Our Microsoft Excel Advanced course can be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.
Excel 2010 Advanced Course Outline
AND, OR, NOT
Combining IF AND, OR, NOT
Vertical Lookup (VLOOKUP)
Horizontal Lookup (HLOOKUP)
Lookup and Information Functions
ISTEXT, ISVALUE, ISDATE, ISNULL, ISERR, ISNA
ADVANCED LIST MANAGEMENT
Database Functions: DSUM, DMIN, DMAX, DAVERAGE, DCOUNT, DCOUNTA
UPPER, LOWER, PROPER
SUMMARISING DATA WITH PIVOT TABLES
Inserting calculated fields
Changing Value Filed Settings
Using Report Filter
Grouping Data containing Dates and Numbers
Formatting Pivot Table
Showing and Hiding the Grand Total
Refreshing Data In Pivot Table
Changing The Scope Of The Data source
Summarizing Values by Sum, Count, Average, Max, and Product
Show Values As % of Grand Total, % of Column Total, % of Row Tota
Pivot Table Options
Using Slicers for Effective Filtering
WHAT IF TOOLS
PROTECTING AND COLLABORATION
Sharing a file
Accepting or rejecting changes
Applying Data validation rules
Protecting cells, sheets, files
Password protecting a file
Password protecting a cell range
INTRODUCTION TO MACROS
Displaying the Developer Tab
Review And Purpose of Macros
Macros saving locations
Absolute and Relative Macro recording
Assigning to –
Quick Access Toolbar
One to One
(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training
Group for up to 8 learners
What Our Clients Say
This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.