Microsoft Excel Advanced

Course Objectives

Create custom lists
Use Text and Date functions
Use logical functions AND and OR
Combine IF functions with Absolute Cell Referencing
Nest functions If, AND and OR
Apply conditional formatting
Insert and show comments
Audit worksheets and track changes
Apply auto formatting
Use data validation
Apply security to spreadsheet
Use VLOOKUP function across workbooks
Create Pivot Tables for data analysis
Use Goal Seek
Apply solutions using Solver
Record a macro
Assign a macro to a toolbar
Assign a macro to a form button
Customise and create toolbar

Microsoft Certified Office Specialist, Microsoft certified Master and Microsoft Certified Systems Engineer. Tracy Sharp has been writing and delivering training for over 13 years for training providers and direct to companies. Over 20 years experience in the Computer industry.

You can book a training course from only £295 per day (no VAT) for up to 8 delegates.

Full or half day training courses delivered at your company for your convenience.

Courses include instructor-led training, workbooks, reference guide, certificates and unlimited after-course support for each delegate after the training has been delivered.

A guaranteed quality, personal and professional training service.