Excel level 2 - Intermediate
Microsoft Office 365 - Microsoft Excel
Book Course NowCourse Overview
Improve your Excel skills to develop more complex workbooks.
This course equips the user with a proficient knowledge of Excel, covering a wide range of commands and the production of high quality graphics and documents. The day commences with a brief review of commands covered in the Level 1 course, followed by an in-depth look at enhancing spreadsheets using multiple worksheets, database capabilities, split screens, other 'functions' and advanced charting.
This is a one-day course running from 9:30 am - 4:00 pm.
Training is hands-on and tutor-led.
We provide a comprehensive training manual, lunch and certification.
Courses run at both Swansea and Cardiff locations.
This course can be run as a company specific option either at your site or our own.
Course Content
General Review
General review of existing knowledge and the
commands covered in the Level 1 course.Multiple Worksheets
Creating multiple worksheets; moving between
sheets; deleting sheets; using 3D formulae; typing,
pointing and pasting links.Advanced Charting
Editing charts; selecting chart elements; using chart
options. Sparklines.Simple Functions
Including the IF and VLOOKUP functions.
Naming Cells
Defining names using the Name box.
Excel as a Database
Including database definition; data forms; sorting and
filtering data; sub-totals and pivot tables.Protecting Data
Protecting data and using passwords.
The Excel Environment
Showing split screens and titles.
Cell References
Working with absolute and relative cell references.
Prerequisites
Attendees will gain the maximum benefit if they have attended our Level 1 course, or are familiar with creating basic spreadsheets and using simple functions.
Qualification
This course covers material from the standard European Computer Driving Licence (Module 4, contributes to an ITQ level 2 / ECDL Extra qualification and the Microsoft Office Specialist Core
Excel syllabus.What Next?
Excel Functions
Developing formulas for calculations you want to make in Excel can be tedious and complicated. Excel has an entire library of functions or predefined formulas that you can use. There are hundreds of functions in Excel that allow you to format text, reference cells, calculate financial rates, look up information and more.
Excel Level 3
Gain an in depth knowledge of data analysis, learn how to audit your spreadsheet and use advanced features such as templates and macros.

- 130.00 +VAT Per Person
- 1 Day Course