Excel Intermediate 1-Day Course, 1 to 1, Milton Keynes, Live Online, Online, Tuesday, 07. August 2018

Excellent Excel Course to get hands-on experience and practical knowledge in one day. Practical. Online. Instructor-led.

About this Event

EXCEL INTERMEDIATE COURSE, PRIVATE 1-TO-1
PC AND MAC VERSIONS 2007 UPWARDS

ONLINE in our Virtual Classroom. Connection Details provided upon booking


COURSE SUMMARY

This Excel course is offered one-to-one, because we understand that professionals have varying skill levels and varying applications. We make most of the time that you have taking to improve.

This course is excellent for delegates with basic Excel skills.


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 Pivot tables
  • Filter, Slicing
  • Sort,
  • Format Pivot Tables,
  • Add additional formulas,
  • 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 
  • To assist after the course, 1 free session for questions online via gotomeeting.com

Tuesday, 07. August 2018, Online, Excel Intermediate 1-Day Course, 1 to 1, Milton Keynes, Live Online

Find more interesting events
Get event recommendations based on your Facebook taste. Get it now!Show me the suitable events for meNot now