Excel Power Functions - Online Training Course - CPDUK Certified

Excel Power Functions  – Online Training Course - CPDUK Accredited.

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

Excel Power Functions

Teacher - Barbara Evers

Learner -  Christina Tankersley

This online Excel Power Functions training course will teach you how to use the 10 Excel functions recommended by the experts. Barbara Evers steps you through functions that can increase your productivity and simplify your spreadsheets.

Course content

This Excel Power Functions e-learning 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 Excel Power Functions training course is suitable for anyone who wants to learn the steps through functions that can increase productivity and simplify spreadsheets.

Course aims

The aims of this Excel Power Functions eLearning course is to:

• Develop your skills needed to Use the 10 Excel Functions
• Help you perform a variety of calculations within your data.

Learning objectives

On completion of this Excel Power Functions e-learning course, the learner will be able to:

• Locate the syntax of an Excel function and explain the basics of function syntax design.
• Describe how Excel functions use True/False evaluations based on criteria.
• Write an Excel function that uses wildcards.
• Describe the syntax and write an Excel function using the following functions:
  • DATEDIF
  • EDATE
  • EOMONTH
  • CONVERT
  • INDEX + MATCH
  • OFFSET
  • COUNTA
  • SUMPRODUCT
• Create nested functions using multiple Excel functions in one cell calculation.
• Determine anniversary dates using EDATE, DATEDIF, and EOMONTH.
• Convert units using the CONVERT function (e.g., miles to kilometres).
• Find a value in a large array of data using the combination of INDEX and MATCH.
• Debug or 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 Excel Power Functions training course, the learner will be able to:

• Explain how to use the Excel Power functions with syntax and examples.
• Create, share, and collaborate with numbers.
• Perform various kinds of sums, formulas, functions, tables, and charts according to business needs.

Download Full Course Description (PDF)

Excel Power Functions - Online Training Course - CPDUK Certified.