23. May 2019 - 11:00 till 18:00
Share it on:

Excel Intermediate 1-Day Course, Private 1-to-1, Manchester | Regus Spaces | Thursday, 23. May 2019

Excel Intermediate Course, Private 1-to-1, in Manchester
This Excel course is offered one-to-one, 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.
Course Outline
Working with Functions and Formulas


Creating Formulae in Excel, general calculations


The Function Wizard


Sum, Average, Maximum, Minimum, Count Functions


If- function

Copying formulae

Working with Lookup- Functions

Working with Names and Ranges
Lookups - Vlookup, Hlookup, Index, Match
Sumifs, Averageifs, Countifs
Pivot-tables

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

Charts and Sparklines

Adding and Editing Charts
Adding and Editing Sparklines

 
 Included: Teas, Coffees (but no lunch), Laptops for use during the course, Course Notes, Course exercises and examples, access to online materials, Certificate, 1-hour after-course online consultation.