Mastering Microsoft Excel 2013 - Advanced - Online Training Course - CPDUK Certified

Mastering Microsoft Excel 2013 - Advanced - Online Training Course - CPDUK Accredited.

Welcome to The Mandatory Training Group's online Mastering Microsoft Excel 2013 advanced training course. All our online training courses, programmes and qualifications are accredited by the CPD Certification Service (CPDUK).

Mastering Microsoft Excel 2013

Teacher - Barbara Evers 

Learner - Christina Tankersley

This online Microsoft Excel 2013 advanced training course will teach you how to use Excel 2013 functions and features. Barbara will train you to customise Microsoft Excel 2013, create and modify PivotTables, create easy-to-view charts and graphs and use conditional formatting and sparklines to highlight data trends in this course.

Course Content

This online Mastering Microsoft Excel 2013 advanced training course includes the following:

• Unit 1: Quick analysis & slicers
• Unit 2: Subtotals
• Unit 3: Creating pivot tables
• Unit 4: Recommended pivot tables
• Unit 5: Customising pivot tables
• Unit 6: Pivot charts
• Unit 7: Customising your view - Part 1
• Unit 8: Customising your view - Part 2
• Unit 9: Advanced formatting
• Unit 10: Advanced data copy techniques
• Unit 11: Transforming data with the clipboard
• Unit 12: Using data validation
• Unit 13: Analysing data: scenario manager
• Unit 14: Analysing data: data tables
• Unit 15: Analysing data: goal seek
• Unit 16: Text to columns
• Unit 17: Consolidating data
• Unit 18: Creating macros
• Unit 19: Advanced macros
• Unit 20: Creating random numbers and custom series
• Unit 21: External references
• Unit 22: Customising the ribbon and toolbar
• Unit 23: Power view.

Who is the course for?

This online Mastering Microsoft Excel 2013 advanced training course is suitable for learners with a basic knowledge of Excel who wants to master formatting and complex ROI values.

Course aims

This Mastering Microsoft Excel 2013 advanced eLearning course aims to:

• Appreciate the role of excel to gain an understanding of business trends
• Develop your knowledge and skills on the use of spreadsheets in both business and personal life.

Learning objectives

On completion of this Mastering Microsoft Excel 2013 advanced e-learning course, the learner will be able to:

• Demonstrate navigating around the Excel Interface
• Explain the relationship between Workbooks, Worksheets, rows, columns, cells, and named ranges
• Describe how to create and use Pivot Tables and Pivot Charts.

Learning outcomes

Once you have completed this online Mastering Microsoft Excel 2013 advanced training course, the learner will be able to:

• Explain how to customise Microsoft Excel 2013 for its effective utilisation
• Create easy-to-view Charts and Graphs using Excel 2013
• Discuss data trends basing on Conditional and Sparklines
• Modify pivot tables on a spreadsheet to demonstrate the gained skill.

Download Full Course Description (PDF)

Mastering Microsoft Excel 2013 - Advanced - Online Training Course - CPDUK Accredited.