Excel 2013 Expert

CALL NOW : 01 8404075

For those who have a good grounding in Microsoft Excel, this course will provide you with the knowledge and skills to use MS Excel at an advanced level. Like all our Excel courses, you will be given a workbook to use as you progress through the course, which will be yours to take away as a handy reference guide.You can also be confident that you’ll possess the top skills being sought by employers.You’ll also have the powerful Pitman Training name on your CV, as a quality mark of achievement. To continue your training, we'd urge you to look at our other Microsoft Office courses, or our Microsoft Office Plus Diploma.

Designed for:

Aims and Objectives:

Microsoft Excel training moves to another level with this course which takes you on to an advanced level.

On successful completion of this course, you will be in a position to prepare for the City & Guilds Spreadsheet Processing Techniques Intermediate exam, as well as the Microsoft Office Specialist test (MOS) and ECDL Advanced (Spreadsheets) exam.

Prerequisites:

To get the most out of this course, you will need to have completed our entry-level Microsoft Excel course or have the equivalent experience of this extremely popular software.

Course Content

Lesson One: Using AutoFill, carrying out date calculations, adding a picture as a watermark, creating and working with tables, converting text to columns, removing duplicates, using Flash Fill, consolidating data, using paste special, creating a custom format

Lesson Two: Defining, using and managing named ranges, using named ranges in formulas, inserting, modifying and removing hyperlinks, formatting elements of a column and pie charts, saving a chart as a template, creating combination chart, using functions: ROUND; SUMIF; SUMIF; IF; IFERROR; AND, using the IF function nested with OR

Lesson Six: Using the VLOOKUP function, inserting an embedded object into a spreadsheet, inserting a linked object into a spreadsheet, using paste special to create a link between programs, linking Excel workbooks, using the scenario manager, setting up data tables