Microsoft Excel Advanced (Level 3) 2003 2007 2010 2013

Base2 Training Limited

Training

In Newcastle Upon Tyne

£ 495 VAT exempt

The best Excel courses

See all

See all

Description

  • Type

    Training

  • Level

    Advanced

  • Location

    Newcastle upon tyne

  • Duration

    2 Days

Become fully proficient with Microsoft Excel by completing this two day course. The course will introduce some of the more advanced features of Microsoft Excel to further develop your skills. A comprehensive tour is taken around the abilities of Excel which includes calculations, worksheet auditing, lists of data, forms, charts, pivot tables and macros.

Important information

Documents

  • Course content

Facilities

Location

Start date

Newcastle Upon Tyne (Tyne and Wear)
See map
The Quadrus Centre, Woodstock Way, Boldon, NE35 9PF

Start date

On request

About this course

Learn all the functions that Microsoft Excel has to offer at an advanced level.

The course is intended for individuals who are experienced users of Windows and Microsoft Excel.

Experience in using/creating spreadsheets is required.

Certificate of participation can be obtained if required.

On receiving your request we will contact you to explain course content, including course dates and payment options.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel training
  • Auditing
  • Microsoft Excel
  • IT Auditing
  • Microsoft excel training
  • MS Excel
  • Macros
  • Worksheets
  • Data Entry Forms
  • Charting
  • Pivot tables
  • Spreadsheets
  • Formatting
  • Database functions
  • Formula Auditing

Teachers and trainers (1)

Chris Edmondson

Chris Edmondson

IT Trainer

Course programme

Advanced Microsoft Excel

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

See related categories

Microsoft Excel Advanced (Level 3) 2003 2007 2010 2013

£ 495 VAT exempt

The best Excel courses

See all

See all