Mastering Microsoft Excel 2013 - Basics - Online Training Course - CPDUK Certified
The Mandatory Training Group
Delivery Method: eLearning
Mastering Microsoft Excel 2013 - Basics - Online Training Course - CPDUK Accredited.
Welcome to The Mandatory Training Group's online Mastering Microsoft Excel 2013 basics training course. All our online training courses, programmes and qualifications are accredited by the CPD Certification Service (CPDUK).
Mastering Microsoft Excel 2013 - Basics
Teacher - Barbara Evers
Learner - Christina Tankersley
This online Mastering Microsoft Excel 2013 basics training course with trainers Barbara Evers and Christina Tankersley will teach you everything about Microsoft Excel 2013, from customising Microsoft Excel 2013 to work better for you to creating easy-to-view charts and graphs in this course.
Course content
This online Mastering Microsoft Excel 2013 basics training course includes the following:
Unit 1: Looking at excel 2013
Unit 2: Worksheet navigation - Part 1
Unit 3: Worksheet navigation - Part 2
Unit 4: Sheet tab options
Unit 5: The excel interface
Unit 6: The status bar
Unit 7: Keyboard shortcuts
Unit 8: File types
Unit 9: Open, save, and autoSave
Unit 10: Templates
Unit 11: AutoCorrect
Unit 12: Undo and redo
Unit 13: Text formatting - Part 1
Unit 14: Text formatting - Part 2
Unit 15: The windows clipboard
Unit 16: Microsoft office clipboard
Unit 17: Highlighting and navigating in a workbook
Unit 18: Entering data in series
Unit 19: Flash fill
Unit 20: Formulas
Unit 21: Intro to functions.
Who is this course for?
This online Mastering Microsoft Excel 2013 basics training course is suitable for anyone who wants to learn Excel basics, from organising lists to creating multi-layered, interactive reports to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more.
Course aims
The aims of this Mastering Microsoft Excel 2013 basics e-learning course are to:
Teach you the basic elements of excel to enter and organise data, use functions, and build charts and PivotTables.
Make you understand the core features and tools in Excel 2013.
Learning objectives
On completion of this Mastering Microsoft Excel 2013 basics eLearning 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 basics training course, the learner will be able to:
Customise the general options and language options of excel
Explain the difference between a pivot table and a pivot chart
Describe a basic page layout of the MS Excel sheet