Mastering Microsoft Excel 2013 - Advanced - Online Training Course - CPDUK Certified
The Mandatory Training Group
Delivery Method: eLearning
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.