Excel

Excel Advanced:

Analyse data using Pivot Tables, Automate repetitive task with Macros and build on existing formula knowledge with Nested ifs and Text manipulation formulae.

Course Outline
Excel Advanced 1 Day

Who is it for?

The course is suitable for existing users of Microsoft Excel wanting to further their knowledge – this course covers automating spreadsheets and using advanced data handling techniques.

Prerequisites

Delegates should have a good knowledge of the Introduction and Intermediate outline.

Advanced Functions
An in-depth look into:
  • Nesting IF’s
  • And/Or Functions
  • Array Formulas
  • Text Functions
  • Database Functions
Pivot Tables
Pivot Tables and Pivot Charts:
  • Creating and Editing Tables & Charts
  • Refreshing Data
  • Displaying Pages
  • Slicers
Templates & Editing
Templates & Advanced Editing Techniques:
  • Creating & Editing Templates
  • Deleting Templates
  • Paste Special & Paste Link
  • Data Validation
  • Custom Views
  • Shared workbooks
Spreadsheet Automation
Working with Macros:
  • Creating & Naming Macros
  • Absolute and Relative Macros
  • Creating Macro Buttons
  • The VBA screen

Tags: Microsoft Excel, Software

About the Trainers

Qualifications - European Computing Driving License (ECDL) Microsoft Office Specialists (MOS) Microsoft Office User Specialist (MOUS), Microsoft Certified Applications Specialist (MCAS), 2 of our trainers have taken the Institute of Learning Management Train the Trainer Master Class Award. Every trainer has a minimum of 5 years training experience.

mpn

NC Member logo

Latest News

Windows 8 and 10

Windows 8 courses now available.

New courses for Microsoft Windows 10 will be available soon – be one of the first to see it with us.

MS Office Training

Microsoft Office weekend training and Microsoft Office 2013 upgrade training now available.

Testimonials

"This morning I set up a Macro (as per Thursday’s advanced course) and recorded the whole operation so I could apply to future reports downloads and ‘wow’ this has really saved so much time -thank you."

Iris Vicary, Telent

"After taking part in the intermediate and advanced excel courses I soon booked onto the word training. Nicola was both helpful and technical. The courses were just the right length and I would strongly recommend."

James Harris, Critchleys Chartered Accountants