- 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 3
Microsoft Excel 2007 Level 3.
This course is designed to enable the proficient user to gain extended use of the spreadsheet package. The day starts with a brief review of commands covered in the Level 1 and 2 courses, followed by an in-depth look at some of the advanced tools of this package, such as Scenarios, Auditing and the Solver. The course covers conditional formatting, creating templates, data validation and data analysis tools. There will also be a detailed look at creating and using simple and complex macros to enhance spreadsheet efficiency
Excel
level 3
Scheduled training
scheduled training.
Excel Level 3.
General Review
- General review of existing knowledge and the
commands covered in Levels 1 and 2
Goal Seek and Solver
- Finding values for one or more input cells to optimise the value of a formula
Scenario Manager
- Setting up a scenario; switching between scenarios
Auditing
- Error checking
Data Validation
- Creating comments and defining valid cell entries.
Templates
- Creating and saving a template
Conditional Formatting
- Setting and using conditional formatting
Macros
- Creating and running macros; assigning macros to buttons, keystrokes, menus and toolbars
Hyperlinks
- Using Hyperlinks to move to specific cell references in spreadsheets.
Price per person 
£115 + VAT
Number of days
1 day
Prerequisites
- To gain the maximum benefit from this course, an attendee should have attended our Levels 1 and 2 courses, or have an equivalent understanding of Excel, especially the use of formulae, functions and multiple worksheets
Qualification
- This course covers material from the Advanced European Computer Driving Licence and the Microsoft Office Specialist Expert Excel syllabus
Timings
- This is a one-day advanced course running
from 9:30 am - 4:30 pm.
Cardiff
16th February
30th March
27th April
20th May
Swansea
11th May
