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

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