Change Location × London, UK

    Recent Locations

      Excel Intermediate Course, Private 1-to-1, London in Covent Garden


      • Excel Intermediate Course, Private 1-to-1, London Photo #1
      1 of 1
      March 26, 2019

      Tuesday  11:00 AM (on various days)

      5 Southampton Street
      Covent Garden, Greater London WC2E 7HA

      Performers:
      • No Performers Listed
      EVENT DETAILS
      Excel Intermediate Course, Private 1-to-1, London

      EXCEL INTERMEDIATE COURSE, PRIVATE 1-TO-1, PC AND MAC VERSIONS 2007 UPWARDS COURSE SUMMARY This Excel course is offered one-to-one or in small group of up to 4, because we understand that profesionals have varying skill levels and varying applications. You already have the basic Excel skills but habe many questions daily and want to be more proficients. Important: If booking within 7 days of the date of the course, we will confirm availability within 24hours COURSE OUTLINE Working with Functions and Formulas Creating Formulae in Excel, general calculations  The Function Wizard  Using Functions in Excel: The 5 Popular functions  If- function  Working with Names and Ranges  Copying formulae  Lookups - Vlookup, Hlookup, Index, Match  Managing Tables Working with Tables  Working with Records and Fields  Filters and Sorting, Freeze panes, split, protecting and unprotecting  Using Excel as a Database- Advanced filter  Pivot-tables  Create Pivot Table, Amend, Filter, Sort, Format Pivot Tables, Add additional folmulas, Refresh Data.  Pivot Charts  Adding the Finishing Touches Adding Comments  Using Themes  Adding Text Boxes  Charts and Sparklines Adding and Editing Charts  Adding and Editing Sparklines  Adding Graphics Inserting SmartArt, Formatting SmartArt, Adding Symbols, Equations, and Shapes WHAT IS INCLUDED: Certificate on completion (assessment based)  Course notes  Practical Class exercises, Homework / Revision work  Tea, coffees, but no lunch  To assist after the course, 1 free session for questions online via Skype or Teamviewer. 

      Categories: Business & Networking

      This event repeats on various days: Apr 23, Apr 30, May 7

      Event details may change at any time, always check with the event organizer when planning to attend this event or purchase tickets.