Course Excel Level 2
Download PDF
Course Duration
1 Day
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 gain the skills necessary to create spreadsheets from scratch using more advanced functions and formulas, sort and filter data, analyse data and present data in visual and vibrant ways.
Public Scheduled Dates
<<
<
>
Public scheduled prices per delegate +VAT
Private Courses
Private courses start from £645 for up to 8 delegates
Prerequisites
    • Before starting this course, we recommend that delegates have attended the Microsoft Excel Level 1 course or have equivalent knowledge.
Objectives
    • Use the IF function to automate tasks using tests.
    • Create a summary sheet that will calculate the total for a range of sheets, without duplicating the data, eg. an expenses sheet that takes the monthly totals and displays them on a summary sheet.
    • Filter a spreadsheet to show only the records that meet a specific criteria, eg. all surnames beginning with A.
    • Display data in various graphical formats that can be easily understood by anyone not using Microsoft Excel.
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
  • RECAP of Performing calculations
    Adding and Subtracting Numbers
    Multiplication and Division
    Understanding BODMAS
    Cell references
    SUM function
    AUTOSUM
    Useful Basic Functions AVERAGE, MIN, MAX and COUNT
  • Using Absolute Referencing
    Difference between Relative and Absolute References
    Absolute Reference and Dollar Sign
    Why use Absolute References
    Applying an Absolute Reference in a formula
  • 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
  • Linking within a workbook (3D-Referencing)
    Linking within a workbook
    Simple referencing in a worksheet
    Calculating across multiple sheets using 3D-Referencing
  • Calculating Data with Logical Functions (IF Function)
    IF functions
    IF function criteria
    Using IF’s to test or check your data
  • Conditional Formatting
    Conditional Formatting Types
    Highlight Cells different colours based on their value
    Top Bottom Rules
    Icon Sets
    Data Bars
    Colour Scales
    Customising Conditional Formatting
  • Performing Date and Time Calculations
    Date Shortcuts
    TODAY and NOW functions
    DATEDIF function
    YEAR, MONTH, DAY, TEXT functions
    NETWORKDAYS function
  • Comments
    Adding, Editing and Deleting Comments
  • 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
  • Presenting Data Using Charts
    Creating a chart
    Modifying charts
    Formatting charts
    Advanced Chart Features
    Multi-Axis charts
    Quick Analysis Tool

 

Latest Course Reviews
Following this training what are you going to do differently "not sure maybe do some graphs and slicing, just because i can now :)"

T.S. SIS mfg, Excel Level 2

"Learnt so much it was great."

S.P. Impact International, Excel Level 2

"[The trainer] was super patient, kept going over areas and answered all our weird and wonderful questions."

S.P. Impact International, Excel Level 2

"There are lots of little nuggets and time saving opportunities the time spent today has been invaluable, shame i haven't completed it sooner would have saved me quite a lot of time!"

S.P. Impact International, Excel Level 2

"It was brilliant thank you"

J.G. Impact International, Excel Level 2

"Will definitely use a lot from this course, mostly dashboards and use of formulas."

H.H. Norseal Ltd, Excel Level 2

"A lot of detail to take on board but interesting nonetheless."

A.P. James Jones and Sons Ltd, Excel Level 2

"An enjoyable day!"

R.G. James Jones and Sons Ltd, Excel Level 2

"Enjoyed the whole course"

G.C. James Jones and Sons Ltd, Excel Level 2

"[The trainer] was really helpful when I needed assistance and made me feel at ease"

A.M. Hemingways, Excel Level 2

"Great Course ! Great Trainer !"

A.M. Hemingways, Excel Level 2

"Very enjoyable and a very proactive and easy training session. "

D.B. James Jones and Son Ltd, Excel Level 2

"[The trainer] was fabulous at explaining and very patient."

J.M. James Jones and Son Ltd, Excel Level 2

"Good all-round training"

T.B. Public scheduled course, Excel Level 2

"All course content very informative and easy to follow. Full of handy information"

C. , Excel Level 2

"Very good run course, I learnt a lot of new skills throughout the day."

J.M. James Jones and Sons, Excel Level 2

"Extremely useful with insights on why you use functions, not only how."

E. , Excel Level 2

"Very good useful course. Trainer was brilliant and I wasn't scared to ask her to show me how to do different parts again."

A.M. James Jones, Excel Level 2

"Really enjoyed the course, [the trainer] was very engaging and most helpful."

M.C. James Jones, Excel Level 2

Following this training what are you going to do differently "Stop ruining other colleagues spreadsheets! Joking aside, I`ll be better placed to present production figures and pinpoint any trends."

D. James Jones, Excel Level 2

"Extremely informative and very beneficial in enhancing my knowledge and skills"

A.P. South Tyneside Council, Excel Level 2

"Excellent session "

M.C. South Tyneside Council, Excel Level 2

"This course will help me produce information more quickly and efficiently"

W.D. James Jones & Sons Ltd, Excel Level 2

"There was none of the course I didn't find valuable. I especially enjoyed the first part learning about formatting"

J.H. , Excel Level 2

"Very informative and presented well"

L.M. NHS South Tyneside, Excel Level 2

"Excellent course and trainer. Very informative."

M.D.M. Public scheduled, Excel Level 2

"Honest found everything on the course extremely useful. It has shown simpler, easier ways to create things in Excel and shown me how easy and useful Excel can be."

A.F. Public scheduled, Excel Level 2

Following this training what are you going to do differently "I will be using excel in a completely different way. But data validation is going to really improve my efficiency. And then conditional formatting is something I think I will be able to use in all parts of my life."

N.B. Public scheduled, Excel Level 2

"I found all aspects of this course valuable. I am looking forward to adding formulas to my spreadsheets and creating graphs for reporting purposes."

L.M. , Excel Level 2

"Everything was clearly explained and useful"

R.F. Wetherby Shade Card Co, Excel Level 2

"I thoroughly enjoyed this course and the pace suited me"

J.P. South Tyneside & Sunderland NHSFT, Excel Level 2

"I thought [the trainer] was very patient and helped the less able candidates on our course - ie me! Thank you."

C.L. South Tyneside & Sunderland NHSFT, Excel Level 2

"Everything was useful and delivered very well."

B.W. Tyne & Wear Fire & Rescue Service, Excel Level 2

Following this training what are you going to do differently "I will be far faster at multiple things as I seem to have been doing everything the long way round."

W.W. Bilfinger, Excel Level 2

"To be honest, every part of the training is very valuable. The most valuable though is vlookup"

A. FALTEC EUROPE LTD, Excel Level 2

"I would recommend this course to others"

S. , Excel Level 2

Following this training what are you going to do differently "Use these techniques throughout my work, it will help me massively."

L. , Excel Level 2

"Things I was doing on Excel that would take up hours of my day now only take 10 minutes."

S.B. THARSUS VISION LTD, Excel Level 2

"[The trainer] was a great teacher and I can’t wait for level 3. "

R. Universal Wolf, Excel Level 2

"GREAT COURSE, WELL PRESENTED !!"

R. Universal Wolf, Excel Level 2

"It was the best virtual course I have been on!"

J.M. LSL Property Services, Excel Level 2

"Thoroughly enjoyed this course!"

J.M. LSL Property Services, Excel Level 2

"Fantastic course. Could be boring material but the teacher makes it fun and interactive and is enthusiastic about the subject matter"

C.C. Martell Real Estate, Excel Level 2

"Very well presented course and lots of very useful pointers on how to do things."

G.O. Lighthouse Poole, Excel Level 2

"Enjoyed all of it - learnt some useful quick tips I was not aware of and also functions that I've not come across. Liked the charts section too."

A.T. ASW Assurance, Excel Level 2

Following this training what are you going to do differently "take less time to do everything on excel"

S.A. ASW Assurance, Excel Level 2

"I would really recommend this training to people that use Excel and want to make their life a bit easier."

S.A. ASW Assurance, Excel Level 2

"All of it was brilliant, lots I didn't know, the shortcuts, formulas, grouping"

C.Y. ASW, Excel Level 2

"I know how to do things properly now so I will spend alot less time googleing!!"

L. , Excel Level 2

"Great course, look forward to Level 3"

J.H. Lighthouse, Poole, Excel Level 2

"All aspects were enlightening and I am eager to put my new found knowledge to use"

T.P. , Excel Level 2

Following this training what are you going to do differently "I will be more confident working with spreadsheets and analysing data and presenting charts"

D. , Excel Level 2

Following this training what are you going to do differently "I will be more confident and competent at compiling spreadsheets."

I.M. Hitachi Construction Machinery Uk Ltd, Excel Level 2

"Very enjoyable course with a lot of good information in a short time."

J.R. Hitachi Construction Machinery UK, Excel Level 2

Following this training what are you going to do differently "A definite will be using the insert function tool & using keyboard shortcuts regular till become 2nd nature (hopefully ??)"

S.T. UPM Raflatac, Excel Level 2

Which part of the course did you find particularly valuable "The work with formulas and 'If Statements' is particularly valuable and useful - as is how to protect the data, and Data Validation"

J.S. Yorwaste, Excel Level 2

Are there any aspects of the course which you feel require improvement "I think the course was filled with great content and the trainer was very good. Extremely engaging."

S.O. Egger UK, Excel Level 2

Are there any aspects of the course which you feel require improvement "I thought the structure of the course was perfect. I was really impressed by the pre-populated worksheet. No improvements to be made."

B.T. EGGER, Excel Level 2

Which part of the course did you find particularly valuable "I found all of the course valuable. Although I do use Excel on a daily basis I wasn't aware of some of the shortcuts that were shown to us today and these will certainly benefit me goung forward"

C.P. , Excel Level 2

Following this training what are you going to do differently "I will be reviewing the excel spreadsheets that I use on a regular basis to see how I can improve them by using different formulas"

C.P. , Excel Level 2

"There were many small elements of my existing understanding that were expanded. Everything was explained really well and I now have a better understanding of things I struggled with before like how IF statements are set up. I also have easier ways to do things, like naming cells where there are absolutes."

S.F. , Excel Level 2

"The short cuts when using formulas as I wasn't aware of them whereas I've done doing things the long way round."

D.P. , Excel Level 2

"I particularly benefitted from the level of depth and explanation that went into the course step by steps. the exercisers allowed learning time to understand each module and skill."

J.G. Hitachi, Excel Level 2

Are there any aspects of the course which you feel require improvement "No, it was really good!"

V.K. Blue Phoenix UK LTD, Excel Level 2

"I found all aspects of the course valuable as I learned something from each section."

D.H. , Excel Level 2

"Very good training - made a potentially monotonous topic very engaging and easy to follow"

D.V. , Excel Level 2

"Very satisfied with this training, would recommend it! The presenter was very professional and friendly!"

A. , Excel Level 2

"Looking forward to trying some of the things I've learned"

M.L. Healthwatch North Tyneside, Excel Level 2

"I found it all valuable, the information [the trainer] gave was informative and very helpful, this course will help me massively in my role at work. I was nervous for doing the Excel course and my knowledge was very basic, but there was no need to be as [the trainer] was so lovely, friendly and professional she explained things so I we understood and checked as we were going if we were all ok."

J.H. Egger UK, Excel Level 2

"The trainer took lots of time to answer our individual questions and had lots of good examples for us to practice and work through which really helped put theory into practice. The examples made understanding much easier and meant the course wasn't too content heavy and nice and interactive."

E.F. Egger, Excel Level 2

"I thought the course was really helpful and I would fully recommend."

E.F. Egger, Excel Level 2

"I will feel more confident in general using Excel, I will be able to present data in a better way and will also feel more confident setting up my own worksheets in Excel."

D.K. Egger, Excel Level 2

"Just really useful and enjoyable"

N.W. Riverford Organic Farmers, Excel Level 2

"I will save loads of time not having to google how to do things on spreadsheets."

T.C. Riverford Organic Farmers, Excel Level 2

"Loved it!"

F.W. , Excel Level 2

"Found the course to be exactly what I needed to move forward in my role. Thank you"

J.T. Recipharm, Excel Level 2

"Liked the course very much, very informative, great tutor"

C.C. EggerUK Ltd, Excel Level 2

Would it be possible to use your feedback in our marketing we only use your initials and organisation name "My second Excel course it has made a huge difference to how I present data"

J.S. STC, Excel Level 2

Following this training what are you going to do differently "Create better charts, make use of Tables, and make use of the IF Function and Conditional Formatting. I will also now be able to work better with dates, and generate data on timescales between processes."

D.S. South Tyneside Homes, Excel Level 2

"Excellent session, thank you"

C.M. , Excel Level 2

"Course was very well delivered, ideal amount of time on each section. No suggestions for improvement."

P.T. South Tyneside Council, Excel Level 2

"Enjoyable and very useful day course, Excel confidence has improved markedly already!"

P.T. South Tyneside Council, Excel Level 2

Following this training what are you going to do differently "Use Excel more often for valuable shortcuts to tasks that would otherwise take me a long time."

J. , Excel Level 2

Following this training what are you going to do differently "It'll really change the way I work with others in my team on data, and speed up the way I work in Excel"

B. , Excel Level 2

Any other comments or recommendations "Excellent trainer, very knowledgeable "

M.D. Abraham Moon Sons Ltd, Excel Level 2

Are there any aspects of the course which you feel require improvement "None, enjoyed every aspect"

C.G. Vehicle Lease and Service Ltd, Excel Level 2

Following this training what are you going to do differently "Tidy up the current spreadsheets that I use using the new features that I have learnt. Will help me with my KPIs."

C.G. Vehicle Lease and Service Ltd, Excel Level 2

Any other comments or recommendations "Great course. Knowledge is a must."

J.B. Tharsus, Excel Level 2

Any other comments or recommendations "Very clear and informative"

R.S. William Smith Group, Excel Level 2

Following this training what are you going to do differently "Much better analysis of data - use more functions"

V.H. William Smith Group, Excel Level 2

Following this training what are you going to do differently "I won't be afraid to use Excel anymore"

K.W. Hart Biologicals, Excel Level 2

Following this training what are you going to do differently "Efficiently working in sheets quicker"

J.P. Intermarketing, Excel Level 2

Following this training what are you going to do differently "Use many tips and tricks, use IF more, use function library within Excel."

S.B. Education Development Trust, Excel Level 2

Following this training what are you going to do differently "Build sheets with more &quot;depth&quot; now I have a better understanding of scope "

L.S. Intermarketing, Excel Level 2

Which part of the course did you find particularly valuable "More understanding of setting up spreadsheets - setting formulas "

K.L. Sealy UK, Excel Level 2

Following this training what are you going to do differently "Loads - the way I interpret data and present it "

N.S. Burnetts Solicitors, Excel Level 2

Following this training what are you going to do differently "Use auto-formulas to comprise sheets"

S.C. Burnetts Solicitors, Excel Level 2

Following this training what are you going to do differently "Learned how to do speedier shortcuts"

J.R. Sealy UK, Excel Level 2

Which part of the course did you find particularly valuable "The practical approach of trying every aspect whether I had already done it before or I was trying it for the first time. It was a safe space to make mistakes and a very encouraging environment. "

S.A. Fujifilm Diosynth Biotechnologies, Excel Level 2

Following this training what are you going to do differently "I will be able to present and manipulate data at work in a more efficient way. I have learned a lot of new techniques which help to make processes quicker. I will not be scared to see what Excel can actually do and using my booklet I can take my time and keep learning as I grow my confidence in the use of the system."

S.A. Fujifilm Diosynth Biotechnologies, Excel Level 2

Following this training what are you going to do differently "Now that I know formulas, I won't have to watch how to videos on Youtube, I can just refer back to my training notes."

S.P. Drummond Central, Excel Level 2

Which part of the course did you find particularly valuable "All of it, particularly graphs and Vlookup function"

K.D. GSK, Excel Level 2

Which part of the course did you find particularly valuable "All of it. Probably more the hints and tips than the general topics!"

I.S. GSK, Excel Level 2

Following this training what are you going to do differently "Use my training to improve my reports and save time"

R.B. GSK, Excel Level 2

Which part of the course did you find particularly valuable "Shortcuts, pivots, filters, links "

H.P. GSK, Excel Level 2

"Fantastic, well recommended "

A.L. GSK, Excel Level 2

Which part of the course did you find particularly valuable "All of it, but mostly use of formula and tables"

S.H. GSK, Excel Level 2

"Very patient and understanding trainer"

M.R. GSK, Excel Level 2

Any other comments or recommendations "I feel as though I have learnt lots of new functions that will assist me in doing my job"

T.W. Nicholsons Sealing Technologies, Excel Level 2

Following this training what are you going to do differently "Use Excel for more intricate functions "

P.T. Hyde Park Source, Excel Level 2

"Fantastic!"

A.S. , Excel Level 2

"The trainer was very helpful. Took the time to explain things to individuals who needed it."

A.B. Nicholsons Sealing Technologies, Excel Level 2

Any other comments or recommendations "Very good and informative. The trainer was good and not reading from a book, very knowledgeable and approachable. "

S.R. Edinburgh Woollen Mill, Excel Level 2

Which part of the course did you find particularly valuable "Learned some quick, simple ways that I didn't know were there"

C.P. Egger Uk, Excel Level 2

Following this training what are you going to do differently "Use the formulas and implement them into reports on BO analysis "

N.S. Egger Uk, Excel Level 2

Following this training what are you going to do differently "This will speed up and improve appearance of charts which I produce in reports "

P.B. Egger UK, Excel Level 2

"The course has shown me the easier way to do things I was doing before so I will put that into practice."

L.P. Egger UK, Excel Level 2

"Course was delivered well to someone with limited knowledge and confidence"

L.P. Egger UK, Excel Level 2

Following this training what are you going to do differently "Increase technical ability and streamline my work. Use more of the functions rather than typing out formulas. "

D.S. Home Office, Excel Level 2

"The overall course was a great reminder about certain features. I particularly found data validation and conditional formatting very useful."

A.G. Home Office, Excel Level 2

"I was happy with all of it as it will allow me to use Excel more confidently "

L.G. Home Office, Excel Level 2

Which part of the course did you find particularly valuable "Learning short cuts and filters"

M.C. CMR UK Ltd, Excel Level 2

"Enjoyable course"

D.S. CMR UK Ltd, Excel Level 2

Following this training what are you going to do differently "Use Excel in different and easier ways"

P.C. CMR UK Ltd, Excel Level 2

"I enjoyed learning about graphs and tables as this will help me within my job."

S.B. FM Coatings, Excel Level 2

"Really enjoyable"

B.S. Direct Rail Services, Excel Level 2

"Great that lunch is provided and snacks/brews"

S.L. British Gypsum, Excel Level 2

"Great course, easy to follow, would recommend"

B.M. Direct Rail Services, Excel Level 2

"All parts relevant with good training materials"

C.L. Direct Rail Services, Excel Level 2

"Excellent training"

S. Nissan, Excel Level 2

"Learned a lot from today's course that I can take into my workplace"

C.D. nissan nmuk, Excel Level 2

"Everything was useful"

N.R. Northern Powergrid, Excel Level 2

"Very informative practical course."

T.W. Stobart Rail Ltd, Excel Level 2

"An all round great course, thanks once again."

S.F. Nissan, Excel Level 2

"Helped me to improve my skills and find quicker ways to do things. All the material outlined on the course description was covered, exactly as I expected. The training material was very thoughtfully laid out."

C.W. Nissan, Excel Level 2

"I recently attended the Level 1 course, so this was a perfect and relevant next step in my Excel training. Picked up some tips which will assist me everyday back in the office. Great course, much appreciated."

H.M. Nissan, Excel Level 2

"Excellent course, well worth doing."

A.P. Siemens, Excel Level 2

"[The trainer] made me feel very settled and explained everything in detail. Fantastic Course"

P.C. Hodgson Sayers Ltd, Excel Level 2

"Our trainer was always open to questions and was always clear on explaining the main objectives and tasks to do. Was very easy to follow and we covered all I expected for this level. Brilliant!"

M.S. Nissan, Excel Level 2

"Trainer was excellent, very enthusiastic and knowledgeable."

A.M. Nissan, Excel Level 2

 

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 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 Level 3 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 an 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 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

 

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/25/2024 10:09:04 PM