Mastering MS Excel - Power Functions - Online Training Course - CPDUK Certified

Mastering MS Excel - Power Functions  – Online Training Course - CPDUK Accredited.

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

Mastering MS Excel

Teacher -  Barbara Evers 

Learner - Christina Tankersley

This online Mastering MS Excel Power Functions course examines 10 of the functions more commonly listed by the experts and removes the mystery of how and why to use them. With the help of Barbara Evers, this course steps you through functions that can increase your productivity and simplify your spreadsheets.

Course content

This online Mastering MS Excel Power Functions training course includes the following:

• Unit 1: Introduction
• Unit 2: DATEDIF
• Unit 3: EDATE and EOMONTH
• Unit 4: CONVERT
• Unit 5: INDEX and MATCH
• Unit 6: INDEX MATCH MATCH
• Unit 7: Rolling averages
• Unit 8: SUMPRODUCT.

Who is the course for?

This online Mastering MS Excel Power Functions training course is suitable for anyone who wants to improve their skills in Microsoft Excel and know functions that can increase productivity and simplify spreadsheets.

Course aims

This Mastering MS Excel  Power Functions e-learning course aims to: 

• Help you explore the favourite excel functions for use in your workbooks
• Assist you in exploring the functions that can increase your productivity and simplify your spreadsheets.

Learning objectives

On completion of this Mastering MS Excel Power Functions eLearning course, the learner will be able to:

• Locate the syntax of an Excel function.
• Describe how Excel functions use True/False evaluations based on criteria.
• Write an Excel function that uses wildcards.
• Describe the syntax of an Excel function.
• Write an Excel function using the following functions: DATEDIF, EDATE, EOMONTH, CONVERT, INDEX + MATCH, OFFSET, COUNTA and SUMPRODUCT.
• Determine anniversary dates using EDATE, DATEDIF, and EOMONTH
• Convert units using the CONVERT function (e.g., miles to kilometres).
• Trace through an Excel formula using the “Evaluate Formula” feature or the Excel Formula Beautifier online tool.
• Create a rolling average using the OFFSET function or OFFSET and MATCH.
• Calculate totals and subtotals using SUMPRODUCT and describe how this can be used as an alternative to pivot tables.

Learning outcomes

Once you have completed this online Mastering MS Excel Power Functions training course, the learner will be able to:

• Locate the syntax of an Excel function
• Create nested functions using multiple Excel functions in one cell calculation
• Find a value in a large array of data using the combination of INDEX and MATCH
• Trace  an Excel formula using  the Excel Formula Beautifier online tool
• Locate values within a large array of data on one’s spreadsheet
• Calculate totals and subtotals using SUMPRODUCT, describing how this can be used as an alternative to pivot tables.

Download Full Course Description (PDF)

Mastering MS Excel - Power Functions  – Online Training Course - CPDUK Accredited.