|
Excel Training * Excel Training * Excel Training * Excel Training
On site advanced Microsoft Excel IT training courses available from Zenith Computing IT Consultancy, based in Wigan, Lancashire.
If required we can tailor our training courses to suit your needs, please ask if required.
The advanced Microsoft Excel training course lasts one day in duration and is provided on site (therefore a training room will need to be provided), the advanced Excel training course consists of the following: -
Working with advanced formulas
Using named ranges in Excel
Using absolute references
Advanced Excel functions
CONCATENATE
COUNT / COUNTA
COUNTIF
Dealing with errors
SUMIF
Lookups
IF and Nested Functions
Exploring database functions
Advanced list management
Using text to columns
Validating cell entries in Excel
Working with PivotTables
Creating PivotTables in Excel
Rearranging PivotTables in Excel
Formatting PivotTables in Excel
Working with macros
Running and recording a macro in Excel
Working with VBA code in Excel
Protection
Protecting cells in Excel
Protecting sheets in Excel
Protecting Excel workbooks
We supply Advanced Microsoft Excel IT training courses UK wide, primarily in Wigan, Chorley, Bolton, Lancaster, Preston, Blackburn, Salford, Manchester, Liverpool, Warrington, Southport, Widnes, Burnley, Crewe, Rochdale, Halifax, Huddersfield, Skelmersdale, Ormskirk, Chester & Cumbria.
To book a Microsoft Excel training course or for more course information please click here to contact us.
Other Microsoft Excel training courses that we offer: -
Foundation Microsoft Excel Training Course
Intermediate Microsoft Excel Training Course
|
