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

The Mandatory Training Group
Delivery Method: eLearning

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

Mastering MS Excel - Power Functions - Online Training Course - The Mandatory Training Group UK -

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 - The Mandatory Training Group UK -

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

                                                Book Now Make Enquiry

                                                Write A Review Of Mastering MS Excel - Power Functions - Online Training Course - CPDUK Certified

                                                eLearning
                                                £59.99 (inc VAT)
                                                Book Now Make Enquiry Add To Wishlist
                                                All prices include VAT where applicable