Course Excel Level 3
Download PDF
Course Duration
1 Day
This course will benefit those who are already up to speed with Microsoft Excel but would now like to automate some common tasks and apply advanced analysis techniques to more complex data sets. This Excel course is aimed at anyone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create Excel PivotTables and Excel PivotCharts, use lookup tables and import and export data.
Public Scheduled Dates
<<
<
>
Public scheduled prices per delegate +VAT
Private Courses
Private courses start from £645 for up to 8 delegates
Prerequisites
    • Before attending this course, we recommend that you have attended our Microsoft Excel Level 1 and 2 courses or have equivalent knowledge.
Objectives
    • Create a PivotTable to manipulate and extract data, then create a chart to display the results.
    • Create a spreadsheet that will display multiple groups of records that can be updated from a single source.
    • Create a formula that will only add up or count records that match specific criteria.
    • Record a Macro that will automate a repetitive task and then assign it to a new button on a new toolbar.
What's included
    • Lunch and refreshments when training is delivered at our training venues
    • Comprehensive course materials and exercises
    • Telephone and Email Support
Course Content
  • Using Absolute and Mixed Referencing
    Difference between Relative and Absolute References
    Absolute Reference and Dollar Signs
    Why use Absolute References
    Applying an Absolute Reference in a formula
    Mixed References
  • Tables
    Creating Tables
    Advantages of using tables
    Adding data to tables
    Table Options
    Slicers
  • Naming Cells (Ranges)
    Giving text to cells and ranges of cells
    Create Names from Selection
    Create Names using the Name Box
    Names in formulas
    Name Manager
  • Complex Functions
    Using Complex Functions
    IF Function
    Nested Ifs
    SUMIF function
    COUNTIF function
    COUNTBLANK function
    Wildcards in functions
  • Lookup Functions
    Understanding Lookup Functions
    VLOOKUP
    Approximate and Exact Matches
    Fixing Common Lookup problems
    HLOOKUP
  • Data Validation
    Specifying Validation Criteria
    Controlling entry into a cell
    Types of Validation Criteria
    Creating a Drop-down List
  • Security
    Protecting a worksheet and a workbook
  • Pivot Tables
    Creating a pivot table
    Fields to create row headings
    Fields to create column headings
    Data in the summary area
    Dynamically building a pivot table
    Rearranging fields in a pivot table
    Number formatting of the data area
    Moving pivot tables from one sheet to another or around the same sheet
    Deleting a pivot table
  • Summarising Pivot Table Data
    Managing subtotals and grand totals
    Changing the data field calculation (Sum, Count, Average etc.)
    Sort and Filter
    Drilling down to the raw data
    Building and using Report Pages
  • Grouping Pivot Data
    Grouping Date Fields
    Including Years when Grouping by Months
    Grouping Date Fields by Week
    Multi Grouping
  • Pivot Charts
    Building Pivot Charts
    Editing Pivot Chart Layouts
    Editing Pivot Chart Styles
    Using the built in chart filter buttons for presentation
  • Macros
    Recording a Macro
    Absolute References and Relative References
    Run a Macro
    Delete a Macro
    Assign a Macro to a Button
    Viewing the Code behind a Macro
    Macro Security

 

Latest Course Reviews
"Very informative, good input and time allowed"

S. , Excel Level 3

"I felt the course was really excellent and no improvement needed"

S.D. Everyturn, Excel Level 3

"great trainer and was very patient and worked thorough at a good pace"

K.K. Everyturn, Excel Level 3

"I found the VLOOKUP and flash field functions really useful. I also enjoyed learning all the additional uses of pivot tables. All of the training was very detailed whilst also being enjoyable!"

B.C. , Excel Level 3

Following this training what are you going to do differently "I am going to be turning my spreadsheets into tables and naming them. I will also now be able to use the VLOOKUP function that i was previously struggling with. I am also definitely going to use the flash field function."

B.C. , Excel Level 3

"Would highly recommend the course. Many thanks"

B.W. Public scheduled course, Excel Level 3

"Everything was fantastic"

L.R. Public scheduled course, Excel Level 3

"[The trainer] was fantastic, an absolute credit to the company. Very well presented and engaging throughout - very knowledgeable."

L.R. Public scheduled course, Excel Level 3

"The whole course was a good refresher of previous skills"

T.T. Marelli, Excel Level 3

"It has given me the confidence to start a spreadsheet from scratch again rather than copying and amending other peoples."

J.R. Yorwaste, Excel Level 3

"Trainer was very enthusiastic about Excel and how it could help. I found it quite infectious!"

A.S. The HR Dept, Durham & Newcastle South, Excel Level 3

"[The trainer] was very knowledgeable and enthusiastic, and made sure the content was delivered in an engaging way."

M.G. Tharsus, Excel Level 3

"Pivot Tables will help me present reports and information much better and more comfortably on a day to day basis"

J.C. , Excel Level 3

Following this training what are you going to do differently "I will work a lot more efficiently"

A.W. EGGER, Excel Level 3

"Thank you very much for the course. It was very useful and very practical. I refreshed my knowledge and learned new practical skills I can use at work."

O. , Excel Level 3

"Informative, helpful, professional, valuable"

O. , Excel Level 3

Following this training what are you going to do differently "Use macros more to simplify and make tasks quicker"

K.S. Betech 100PTLtd, Excel Level 3

Following this training what are you going to do differently "Write some macros into my spreadsheets following the course next month, always create tables for the data, name cells to use in formulas"

A.G. Yorwaste, Excel Level 3

Following this training what are you going to do differently "Lots! Lots of little shortcuts to remember and use, I will definitely apply all that I've learnt, I knew the basics of many of the functions but great to get more training on them from a pro because I am mainly self taught."

V.K. , Excel Level 3

Are there any aspects of the course which you feel require improvement "The course was very informative and ran at a great pace. I'd book more courses with IT Training Solutions"

S. carveti partnership, Excel Level 3

Any other comments or recommendations "I would recommend this course to many more colleagues"

S. carveti partnership, Excel Level 3

"Very satisfied with the course"

V.K. , Excel Level 3

Which part of the course did you find particularly valuable "All very valuable, particularly how to use Pivot Tables and LookUps effectively, as well as the introduction to Macros."

D.S. South Tyneside Homes, Excel Level 3

Which part of the course did you find particularly valuable "Very easy to follow along with Adele, and very easy to understand. The Data Validation and macros will be very valuable. I thought the excel sheet that we were sent was very well set all."

S.R. , Excel Level 3

"I learnt a lot more than I thought I would during the course, and Adele was able to explain some functions that I have used before, but didn't fully understand, which will benefit me in applying to more of my work."

S.R. , Excel Level 3

"Loads of very useful tips and explanations,"

C.W. South Tyneside Council, Excel Level 3

"Very easy to follow and great to do from home"

C.W. South Tyneside Council, Excel Level 3

Any other comments or recommendations "Rob was an excellent teacher and I have found his course extremely helpful, more so than I originally thought it would be."

C. NHSBSA, Excel Level 3

"Very useful course. Good venue. "

J.B. -, Excel Level 3

Following this training what are you going to do differently "I can work differently and efficiently"

I.M. , Excel Level 3

Which part of the course did you find particularly valuable "Working on the pivot table slicers and recording Macros. "

E.D. Tharsus, Excel Level 3

Which part of the course did you find particularly valuable "Slicers in pivots and table pivots. Macros , Data validation. Sum IF/Count IF "

M.P. Tharsus, Excel Level 3

Any other comments or recommendations "The trainer was excellent "

N.W. South Tyneside Council, Excel Level 3

Any other comments or recommendations "Very good, useful course."

K.G. South Tyneside Council, Excel Level 3

"Well explained. Nicely paced"

M.L. Emotional Logic, Excel Level 3

"I found Pivot table and splitting columns of the most use however the whole course was helpful, Adele gave me some 1 on 1 training at the end which was very good."

M.T. UKCG, Excel Level 3

Which part of the course did you find particularly valuable "Pivots and shortcuts and security "

A.T. Sealy UK, Excel Level 3

Following this training what are you going to do differently "Not refer to internet as much for any Excel problems! For what I require in my work I feel more confident with the knowledge Ive gained after today. Also feel I have more knowledge to help my seniors in other Excel based projects. "

R.Y. GSK, Excel Level 3

Which part of the course did you find particularly valuable "The macro and pivot functions"

S.B. GSK, Excel Level 3

Following this training what are you going to do differently "Use pivot tables and charts to display information clearly "

S.B. GSK, Excel Level 3

Following this training what are you going to do differently "Use shortcuts more effectively "

W.O. S Sheard & Son Limited, Excel Level 3

Following this training what are you going to do differently "It will speed up my work with spreadsheets "

A.R. S Sheard & Son Limited, Excel Level 3

Which part of the course did you find particularly valuable "All of the course for me was excellence, it has shown me alot of things I did not know you could do and it will help me save time and handle data much better."

L.H. Esh Group, Excel Level 3

Following this training what are you going to do differently "Will be reviewing how we produce data to make more efficient process for team producing and better output for customer."

J.I. County Durham & Darlington NHS FT, Excel Level 3

Any other comments or recommendations "The trainer is very informative and patient "

D.S. Home Office, Excel Level 3

Following this training what are you going to do differently "Put the principles into practice - autosum - named ranges - pivot tables "

B.R.H. Quorn Foods, Excel Level 3

"Fantastic. All great!"

A.S. University of Leeds, Excel Level 3

Which part of the course did you find particularly valuable "Lookups and Pivot tables but I feel as though I have learned lots from each unit we covered."

L.W. County Durham Community Foundation, Excel Level 3

Which part of the course did you find particularly valuable "Data validation plus numerous other aspects "

A.T. Hyperdrive Innovation Ltd, Excel Level 3

"Fantastic course"

D.C. Gestamp, Excel Level 3

"Very well presented course with good information, materials and exercises provided."

A. Demeter Ltd, Excel Level 3

"The tutor was excellent, patient and clear"

S.D. Ground Control, Excel Level 3

"Brilliant once again."

M.K. Durham County Council, Excel Level 3

Following this training what are you going to do differently "Create my own metrics. Analyse statistics"

J.C. CMR UK Ltd, Excel Level 3

"All of the course gave me new knowledge"

C.B. CMR UK Ltd, Excel Level 3

"All aspects greatly improved my knowledge."

P.T. Bruker JV UK Ltd., Excel Level 3

"All of the course was great"

L.T. The Labour Party, Excel Level 3

"[The trainer] was great, he explained everything really well and was very helpful when anyone was struggling"

L.T. The Labour Party, Excel Level 3

"Really enjoyed this!"

R. Labour, Excel Level 3

"All informative, but pivot tables extremely useful"

G.B. The Labour Party, Excel Level 3

"This course will change the way we format and present data in the department, saving us time and giving us a much better overview of our workload, budgets, and monthly stats."

G.B. The Labour Party, Excel Level 3

"Really useful course thank you!"

L.O. Labour Party, Excel Level 3

"Very well presented"

A.C. Engie Fabricom, Excel Level 3

"Great course thank you!"

H.T. HKA, Excel Level 3

How would you rate the course content overall "Amazing - I feel I will be so much more efficient. Content was so relevant and useful. Looking forward to applying what I have learned"

K.B. Education Development Trust, Excel Level 3

"Thank you for an excellently presented training day :)"

E.C. Nissan, Excel Level 3

"Superb course. Possibly the best course I have been on in 22 years in the Fire Service."

J.W. Durham & Darlington Fire & Rescue, Excel Level 3

"Pivot Tables - I'm going to have fun with this when I return to work!"

K.T. PX Group, Excel Level 3

"Great practical examples, with extra focus on sections tailored to individual areas of interest"

S.K. Nissan, Excel Level 3

"Excellent trainer with huge knowledge and friendly attitude. Fab course!"

E.S. Nissan, Excel Level 3

 

Other Courses In This Series Microsoft 365 Copilot for Business Users - Introduction This one-day course is designed to help business users understand the basics of Microsoft Copilot for Microsoft 365, a productivity tool that uses artificial intelligence to provide real-time intelligent assistance within Microsoft 365 productivity apps including Word, Excel, PowerPoint, Teams and O Excel Business Intelligence using Excel Power Tools This course is split into 3 main areas:1. Get and Transform (Power Query)2. Power Pivot - Data Models and DAX calculations3. Dashboard Creation with Pivot Tables, Charts and SlicersIt is aimed at users who want to analyse data from multiple sources and want to create effective data dashboards.Thi Excel Advanced Macros This course is designed to introduce you to the Macro environment of Excel, it will provide you with the confidence to record macros in Excel and then be able to gain a better understanding of the code and make changes to it. We even teach you some commands that cannot be recorded, such as how to sh VBA Essentials using Excel This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures. Excel Analysing and Presenting Data with Dashboards and Pivot Tables This outline below contains an overview of a wide range of features within Excel that when used together can be used to create interactive visual reports and dashboards. The course will show delegates how these features can be used individually to present data but can also be used in combination to Excel Level 2 In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gai Excel Level 1 - Essentials Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create

 

Your Excel course can be delivered online or in-person.  You can choose your Excel path with introduction to advanced levels. Master Excel Business Intelligence and Power Tools, VBA and more.  Learn in-person or online with our virtual classrooms.  Your course can be delivered online, at your office or at one of our training venues, it's your choice. Small class sizes. Course materials included. Flexible course content. Expert trainers and tried & tested training methods. Course materials available online using your personal training account.  You can master Excel, please contact us to book a place or request a quote.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Ask A Question
    I would like IT Training solutions Ltd to keep me informed with offers and news it believes would interest me*
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • Course Options
    Public Scheduled
    Public Scheduled
    Fixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Private
    Private
    Flexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Bespoke
    Bespoke
    Bespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.
    Virtual
    Virtual
    These courses can be attended from anywhere.
  • Virtual Training

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/24/2024 10:33:57 PM