£290
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

£290

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

About this event

EXCEL INTERMEDIATE COURSE, PRIVATE 1-TO-1

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.

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 
  • To assist after the course, 1 free session for questions online

Share with friends

Save This Event

Event Saved