The latest version of Microsoft Office is 2019/O365 but the earlier formats - 2016, 2013 are 2010 - are still very much to be found in offices and homes throughout the UK and abroad.  Microsoft, however, has now ceased to provide support for Office 2007, 2003 and Windows XP.  The table below displays the icons that represent the different applications available in Microsoft Office.  Click on an icon to see more details, such as course outlines and main features.

 

For the everyday user, each version provides all of the basics for that particular Office application but you will see the new releases add a little more functionality to its predecessor.  All course outlines can be download as a PDF file; simply click on the appropriate logo to open up a new window, read about the course and download the outlines.

Word with text.jpg

Microsoft Excel Level 3

Microsoft Excel training throughout the UK, including Manchester, Leeds, Birmingham, York, Carlisle, Newcastle, Sheffield, Glasgow, Edinburgh, Aberdeen, Derby, Norwich, Portsmouth, Swansea, Cardiff, Chester.  For overseas training and contracts, please call to discuss your requirements.

Microsoft Excel Level 3 – Course Outline

 

 

About This Course

This one-day course is designed to build on the skills gained from attending Excel Level 2.

 

Delegates will learn to manage and summarise data files, perform multi-sheet and cross-book calculations and automate their workbooks.

 

Target Audience

Delegates should have previously attended the Level 2 course or have relevant knowledge of the software.

 

At Course Completion

After completing this course, students will be able to:

 

  • Work with PivotTables

  • Adding/removing passwords to open

  • Adding/removing passwords to modify

  • Protecting cells and worksheets

  • Use Data Validation

  • Use What-If Analysis: Goal Seek, Scenarios, Solver

  • Trace errors in formulae

  • Use Trace Dependents/Precedents

  • Create macros and attaching to the Ribbon or a command button

 

Course Content

 

Unit 1 – Pivot Table Reports

  • Create and manipulate a PivotTable

  • PivotCharts

  • Using Slicers

  • PivotTable Timelines

  • Add a Calculated Field

 

Unit 2 – File Handling

  • Apply/remove a password to open

  • Apply/remove a password to modify

  • Protecting cells within a workbook

  • Data validation

  • Finding files

 

Unit 3 – Shared Workbooks

  • Sharing the workbook

  • Checking user status

  • Tracking changes

  • Resolving conflicts

  • History Worksheet

 

Unit 4 – Templates

  • Create a template

  • Use a template

  • Edit a template

  • Insert a template as a worksheet

 

Unit 5 – What-If Analysis

  • What-If Tables

  • Use Goal Seek

  • Scenario Manager

 

Unit 6 – Solver

  • Solver overview

  • Use the solver feature

 

Unit 7 – Macros and Custom Controls

  • Record a macro

  • Assign a macro to a shortcut key

  • Run a macro using the tools macro command

  • Attach macro to a button

  • Format the text inside a button

 

Unit 8 – Auditing Worksheets

  • Trace errors in formulae

  • Using Trace Precedents and Dependents

 

Lesson 9 - Using the Watch Window

  • Adding a Watch to a cell

  • Adding a Watch to all the cells with Formulas

  • Displaying a cell in the Watch Window

  • Deleting a Watch

  • Hiding the Watch Window

 

Unit 10 – Importing Data

  • Import text into a worksheet

  • Import data from a database

 

 

Course duration: one day

 

Word with text.jpg
Visio with text.jpg
Excel with text.jpg
Publisher with text.jpg
PowerPoint with text.jpg
OneNote with text.jpg
Outlook with text.jpg
Access with text.jpg
SharePoint with text.jpg
Project with text.jpg

Contact Us

128A Albert Road West, Heaton, Bolton, BL1 5EB, UK

Tel: 07931 388426

©2019 Easy PC Training Ltd