Excel Intermediate 1-Day Course, Private 1-to-1, Portsmouth,London, Online

Excel Intermediate 1-Day Course, Private 1-to-1, Portsmouth,London, Online

Actions and Detail Panel


This Excel Intermediate course is very useful for functions and formulae, tip and tricks that moves past every day essential Excel.

About this event


This Excel course is offered one-to-one for personal attention.

Online, Instructor-led, Practical. You already have the basic Excel skills but have many questions daily and want to be more proficient.

Read more.


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 


  • 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


  • Certificate on completion (assessment based) 
  • Course notes 
  • Practical Class exercises, Homework / Revision work 
  • To assist after the course, 1 free session for questions online

Share with friends

Save This Event

Event Saved