Excel Advanced Course, Private 1-to-1, London

COVID-19: many events have been canceled or postponed, please check with the organizer the event status.
Excel Advanced Course, Private 1-to-1, London
Image from eventbrite.com
Fri 10 April 2020
Friday 10 April 2020
11:00 AM - 6:00 PM
Ended

MICROSOFT EXCEL ADVANCED COURSE, PRIVATE 1-TO-1


EXCEL COURSE SUMMARY


Excel Advanced is for Excel Experts - you work daily with Excel and your work revolves around spreadsheets and Excel databases. This course is offered one-to-one, because we understand that individuals have varying skill levels and varying applications.

PC AND MAC VERSIONS 2007 UPWARDS

EXCEL COURSE OUTLINE

General

  • Editing Standard Formatting Rules 
  • Input Validate rules 
  • Using Formulas in Conditional Formatting 
  • Group and Outline 
  • Filter and Sorting 
  • Pivot tables
  • File and sheet Linking :
  • Referring to multiple sheets and external files withing formulae and functions 
  • Working with multiple sheets
  • Linking external files

Excel Tables and Advanced Filter 

  • Working with Excel tables 
  • Selectively Copy specific datasets, selective rows and columns from sheets, workbooks or external data 
  • Automate this process and intergrate with data importing

Consilidate 
Goal seek, consolidate and scenarios 
Using Form Templates 

  • Creating Templates 

Advanced Excel Lookup Functions 

  • VLookup Function 
  • Hlookup Function 
  • Using the Index Function,
  • Using the Match Function,
  • Index and Match Together 
  • Using the Indirect Function 

Excel Advanced Functions 

  • Using Error, Logical, Array, Rounding Functions 

Excel Macros 

  • Creating, amending and deleting macros 
  • Relative and Absolute recording of cell references
  • Running macros 
  • Creating Macro menus, toolbars and shortcuts to execute macros by the click of a button


WHAT IS INCLUDED:

  • Excel Course Certificate on completion (assessment based) 
  • Excel Course notes 
  • Practical Excel Class exercises, Excel Course Homework / Excel Course Revision work 
  • Tea, coffees, but no lunch 
  • To assist after the course, 1 free session for questions online via Skype or Teamviewer. 

355 Views - 11/04/2020 Last update
food courses
PCWorkshops at Regus
Golden Cross House, London, England, GB
Event from
eventbrite.com

Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event

Nearby hotels and apartments

Golden Cross House, London, England, GB

Browse other venues in London
Discover now


Discover more events in London
Discover now



PCWorkshops at Regus
Golden Cross House, London, England, GB
Event from
eventbrite.com


Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event
  1. London
  2. PCWorkshops
  3. Excel Advanced Course, Private 1-to-1, London
 
 
 
 
Your changes have been saved.