£175

MICROSOFT EXCEL ADVANCE COURSE

Event Information

Share this event

Date and Time

Location

Location

CF34 0BQ

Office 3 Llynfi Enterprise Centre

Heol Ty Gwyn Industrial Estate

Maesteg, Wales CF34 0BQ

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

This one-day Advance Excel course focuses on the more advanced functions within Microsoft Excel and is centred on manipulating and analysing data. This course will cover how to normalise data and analyse it, import data using queries, prepare and analyse data with 'What If' functions and scenario building. You will learn the knowledge to record macros and create icons on the toolbars to run them. Finally you will learn the ability to use analysis tools to forecast figures based on a range of scenarios.

Course Content

  • Text functions in Excel

  • Count functions

  • Advanced 'If' statements

  • Create a pivot table reports from new

  • Analysing data with pivot tables

  • Manipulating pivot tables

  • Formatting pivot tables

  • Creating pivot charts

  • Trace cell precedents & cell dependents

  • Goal seek to reverse calculate a formula

  • Creating single input data tables

  • Setting up scenarios for What-If?

  • Consolidating data by position

  • Group and outline features

  • Importing text files

  • Setting up database queries

  • Recording macros

  • Editing macros

  • Creating buttons to run macros

  • Customising access to Excel commands

  • Adding icons to the toolbars

  • Creating a custom tab

  • Adding options to menus to run macros


Who is this course for?

This course is aimed at learners who have a good grounding in Excel either from experience or attending our Intermediate Microsoft Excel training course. If your job involves manipulating and analysing data in Excel, you will find this course very useful. You will also find it helpful if you spend most of your working day using Excel and would like to fill in gaps in your knowledge.

Share with friends

Date and Time

Location

CF34 0BQ

Office 3 Llynfi Enterprise Centre

Heol Ty Gwyn Industrial Estate

Maesteg, Wales CF34 0BQ

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved