Microsoft Excel – Advanced: Masterclass

Loading Events

« All Events

  • This event has passed.

Microsoft Excel – Advanced: Masterclass

8th December 2017 @ 9:30 am - 5:00 pm

|Recurring Event (See all)

One event on 8th December 2017 at 9:30am

One event on 12th January 2018 at 9:30am

One event on 9th February 2018 at 9:30am

One event on 12th March 2018 at 9:30am

One event on 9th April 2018 at 9:30am

One event on 9th May 2018 at 9:30am

One event on 8th June 2018 at 9:30am

One event on 9th July 2018 at 9:30am

Member price – £120.00 + VAT
Non-member price – £160.00 + VAT

Duration – 1 Day

 

The previous stages of Excel introduce several very useful functions and tools, as introduced in the intermediate course; one single function cannot always provide you with a solution. The master class focuses on how to combine the features, functions and tools of Excel together. This course is not just about integration, but several new functions will also be introduced such as Financial, Text & Date formulas. This will give the user confidence to master any formula. In addition this course also introduces Macros VBA.

  • Refresher Workshop
  • Date Formulas – Day / Month / Year / WeekDay / WeekNum
  • Combined Advanced Formulas – IF / AND / OR / V & H Lookup Combined
  • Problem Solving Exercises – The Solver / Utilising / Complex Formulas
  • Introduction to Macros VBA – Recording, Editing, Running Macros / Understanding VBA / Rem
  • Statements
  • Advanced Customising Of Excel – Toolbars / Menus
  • Advanced Formatting – Templates / Consolidating Data / Track Changes / Auditing
  • Forms / Dropdown Lists / Tick Boxes / Spinners
  • Date Formulas – Day / Month / Year / Weekday / WeekNum
  • Combined Date Formulas: =IF(WeekDay(A1,2)<=5,”Work”,”Play”)
  • Advanced Combined Text Formulas – Len / Left / Right / Mid / Find / Proper / Upper / Lower
  • Problem Solving Workshops
  • Question and Answers

Details

Date:
8th December 2017
Time:
9:30 am - 5:00 pm
Event Categories:
, , ,

Venue

Sheffield
South Yorkshire United Kingdom

Organiser

Carrie Sudbury – Chamber Skills Solutions
Phone:
01709 386200
Email:
training@brchamber.co.uk
Website:
www.brchamber.co.uk/training

Other

Enquiry Only
Is Inquirable

Book this training course