Microsoft Excel Advanced Training in the North East
Microsoft Excel Level 3
This course will enable delegates to create macros, audit and analyse worksheet data, create PivotTables and PivotCharts, use lookup tables and import and export data.
Our Training
Our public scheduled, tutor-led courses take place at our training venues in the Newcastle-Upon-Tyne and Washington. If these locations are not convenient, you can choose to have a private course at your site or at a convenient location in the North East and throughout the UK.
Below are a list of Excel course outlines. To ensure you get exactly what you want out of your Microsoft Excel training in the North East, you can choose to have a course based directly on an Excel outline, or you can customise an Excel course outline to fit your organisation's specific requirements. Please click on the link to view the outline.
Excel Courses for 97, 2000, XP, 2003
Excel Level 1 (Introduction)
Excel Level 2 (Intermediate)
Excel Level 3 (Advanced)
Excel VBA
Excel Pivot Tables
Excel Courses for 2007
Excel Level 1 (Introduction)
Excel Level 2 (Intermediate)
Excel Level 3 (Advanced)
Excel VBA
Excel Pivot Tables
After attending the Microsoft Access Level 3 course delegates will be able to:
- Change the view of a spreadsheet to show a different layout without using any formatting tools, then change the data on the sheet to display different data values.
- Use the Goal Seek and Solver facilities to enable results to be predicted in a spreadsheet where data may be missing or unavailable.
- Create a PivotTable to manipulate and extract data, then create a chart to display the results.
- Create a formula that will only add up or count records that match specific criteria.
- Create a spreadsheet that will display multiple groups of records that can be updated from a single source.
- Record a Macro that will automate a repetitive task and then assign it to a new button on a new toolbar.
Some areas covered in the Excel Level 3 course include:
- Outlining
- Custom views
- Scenario
- Pivot tables
- Macros
- Look-up tables
- Using tracers to help audit a worksheet
- Complex formulas
- Styles
- Goal seek & solver
For more information on Excel Level 3 course content click here.
