Mastering Microsoft Excel 2013 - Basics - Online Training Course - CPDUK Certified
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
- Perform calculations with simple functions
- Work with multiple worksheets
- Create Pivot tables and pivot charts
- Format the appearance of data and cells
- Adjust worksheet layout and data.
Download Full Course Description (PDF)
