Microsoft Excel Advanced

Infero Training Ltd

Short course

In Nottingham

Save 5%
£ 188 VAT exempt

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Level

    Advanced

  • Location

    Nottingham

  • Duration

    1 Day

  • Start date

    Different dates available

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.
This course is suitable for anybody wanting to learn 2016, 2013, 2010 or 2007, as it cover all the aspects and differences between the versions.

Facilities

Location

Start date

Nottingham (Nottinghamshire)
See map
Gothic House, Barker Gate, The Lace Market, NG1 1JU

Start date

Different dates availableEnrolment now open

About this course

Upon successful completion of this course, students will be able to:

Automate worksheet functions.
Audit worksheets.
Analyze data.
Work with multiple workbooks.
Import and export data.

This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

Before taking this course, students are recommended to take the following courses, or have equivalent knowledge:

Microsoft Excel Introduction
Microsoft Excel Intermediate

At the Infero Training Website:
http://www.inferotraining.com/training-courses/microsoft-excel-courses_4.html

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

  • Microsoft Excel
  • Excel
  • Troubleshoot errors
  • Collaborate on worksheets
  • Share Excel data with other applications
  • Microsoft excel training
  • MS Excel
  • Excel 2013
  • Excel 2010

Teachers and trainers (1)

Richard Blackmore

Richard Blackmore

Trainer

Course programme

Lesson 1: Automating Worksheet Functionality

Topic 1A: Update Workbook Properties
Topic 1B: Create and Edit a Macro
Topic 1C: Apply Conditional Formatting
Topic 1D: Add Data Validation Criteria

Lesson 2: Auditing Worksheets

Topic 2A: Trace Cells
Topic 2B: Troubleshoot Invalid Data and Formula Errors
Topic 2C: Watch and Evaluate Formulas
Topic 2D: Create a Data List Outline

Lesson 3: Analyzing and Presenting Data

Topic 3A: Create Sparklines
Topic 3B: Create Scenarios
Topic 3C: Perform a What-If Analysis
Topic 3D: Perform a Statistical Analysis with the Analysis ToolPak
Topic 3E: Create Interactive Data with Power View

Lesson 4: Working with Multiple Workbooks

Topic 4A: Consolidate Data
Topic 4B: Link Cells in Different Workbooks
Topic 4C: Merge Workbooks

Lesson 5: Exporting Excel Data

Topic 5A: Export Excel Data
Topic 5B: Import a Delimited Text File
Topic 5C: Integrate Excel Data with the Web
Topic 5D: Create a Web Query

Additional information

Clients receive Microsoft Approved courseware, 100% cash back satisfaction guarantee, free refreshments, pub lunch, certificate & 12 months post-course support.

See related categories

Microsoft Excel Advanced

£ 188 VAT exempt

The best Excel courses

See all

See all