Advanced Microsoft Excel

Objectives: This course will introduce some of the more advanced features of Microsoft Excel.

Pre Requisites: Attendees should have a good working knowledge of Microsoft Excel and be comfortable with basic arithmetic.

Duration: 2 days

The topics covered are as follows:

1 Data Functions
• Text Functions
• Logical Functions
• HLOOKUP/VLOOKUP
• Error Functions

2 Handling Worksheets
• Working with multiple sheets
• Inserting / Deleting / Renaming
• Moving / Copying

3 Formatting and Validation
• Custom Number Formats
• Conditional Formatting
• Data Validation & Cell Protection
• Hiding Cell Entries

4 Using Lists
• Advanced Sorting & Data Filtering
• Pivot Tables
• Database Functions

5 More about Worksheets
• Worksheet Auditing
• Using Views
• Scenarios & Report Manager
• Designing Data Entry Forms

6 Advanced Charting
• Understanding a Data Series
• Chart Options
• Types of Chart – Doughnuts, Radar, Surface & Bubble
• Advanced Formatting

7 Customising the Environment
• Setting Options
• Creating Custom Toolbars
• Using Styles
• Automatic / Manual Range Names
• User-Defined Templates

8 Data Analysis
• Absolute, Relative & Mixed References
• Formulas between Worksheets & Workbooks
• Data Tables
• Using Goal Seek and Solver

9 Exchanging Information
• Using Import & Export Wizards

10 Simple Macros
• Recording a Macro
• Running a Macro
• Editing a Macro

microcomputing serves the Tyne & Wear, Northeast England region, with software training courses arranged for all types of companies in Sunderland, Washington, Gateshead and Newcastle as well as County Durham, Northumberland and the Teeside area with courses for organisations in Middlesbrough, Darlington and Stockton.