- Adobe Training
- Design
- Acrobat
- InDesign
- InCopy
- Illustrator
- Livecycle
- Photoshop
- Lightroom
- Web
- Actionscript
- Adobe CSS
- Dreamweaver
- Flash
- Flex
- Fireworks
- Video
- After Effects
- Premiere Pro
- Print Production
- Adobe Print Workflow
- Enfocus Pitstop Pro
- eLearning
- Captivate
- AutoCAD
- Acrobat 3D
- Masterclass
- Design Masterclass
- InDesign, Photoshop and Illustrator (5 days) Introduction
- InDesign and Photoshop (4 days) Advanced
- Photoshop + Certification (5 days)
- Web Masterclass
- Dreamweaver and Flash (5 days)
- Dreamweaver + Certification (5 days)
- Flash + Certification (5 days)
- Video Masterclass
- After Effects and Premiere Pro (5 days)
- Individual Masterclass
- Acrobat - 2 days
- Actionscript - 3 days
- Actionscript Advanced - 3 days
- InDesign - 4 days
- Photoshop - 4 days
- Illustrator - 4 days
- Flash - 5 days
- Dreamweaver - 3 days
- Flex - 5 days
- Apple and Microsoft
- Apple Certified
- Apple iPhone Development
- Final Cut Pro 101
- Final Cut Pro 300
- OSX Leopard 101 Support
- OSX Leopard 201 Server
- Mac OSX Fundementals
- Mac OSX iLife
- Microsoft
- Access Level 1
- Excel Level 1
- Excel Level 2
- Excel Level 3
- Word Level 1
- Word Level 2
- Powerpoint Level 1
- Powerpoint Level 2
- Project Level 1
- Delegate Info
- Frequently Asked Questions
- FAQs and more
- Training Locations
- Featured location
- London
- Manchester
- Glasgow
- Birmingham
- Cardiff
- Bristol
- Other Information
- Course timings
- Airport Information
- Accommodation
- Lunch and Refreshments
- Certificates
- Pre-Course Questionnaire
- Support
- Support
- Loose ends
- Cancellation Policy
- Company
- Software
- ARTS PDF
- Callas
- Acrobat Plugins
- All software
- pdfToolBox
- pdfAutoOptimiser
- DeviceLink
- PDF/A Autopilot
- Server Products
- pdfToolBox Server
- PDF/A Autopilot Server
- Enfocus
- Global Graphics
- PDF and XPS tools
- gDoc Creator
- gDoc Fusion
- gDoc PDF Server
- Contact Us
freephone: 0800 0789 462
You are in: Home > Training > Microsoft > Excel Level 2
Microsoft Excel 2007 Level 2.
This course equips the user with a proficient knowledge of Excel, covering a wide range of menu 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.
Excel
level 2
Scheduled training
scheduled training.
Excel Level 2.
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.
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
Price per person 
£105 + VAT
Number of days
1 day
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) and the Microsoft Office Specialist Core Excel syllabus
Timings
- This is a one-day introduction course running
from 9:30 am - 4:30 pm.
Cardiff
9th February
11th March
20th April
13th May
Swansea
30th April
