IT & Software | Software Development
Microsoft Excel for Professionals: An Introduction to Formulas and Functionalities
The course delves into the various formulas and functionalities of Microsoft Excel through an interactive hands-on workshop. Participants will be introduced to the application and use of formulae and functions that provide the basis for spreadsheet model building in a business context.
To ensure participants are given a high level of attention this course will take a limited number of attendees and will be delivered by an experienced practitioner with extensive experience and knowledge in the field.
Knowledge of Microsoft Excel
What you'll learn
- Data formatting: including conditional formatting and the use of data styles;
- Date-related functions: EoMonth, EDate, YearFrac
- Increasing effectiveness of working with data through the use of Lookup Functions: VLOOKUP, HLOOKUP, Match, Index, Choose
- Using formulas and logical functions: Min, Max, Med, Average, Sum, Sumif, Sumifs, Sumproduct, Count, CountIf, Subtotal, and other logical functions (IF, OR, AND, NOT)
- Data analysis and handling: using Pivot Tables, Data Filters, Data Sorting, Charts
- Target audience: This course is designed for professionals in business whose roles requires the frequent use of Excel (financial controllers, accounts clerks, etc.)
By the end of this module participants would be able to identify and apply the most appropriate and effective Excel formulas and functionalities to address specific action and requirements, and would be able to apply these new skills to deliver Excel-related work in a more proficient manner. Participants would have mastered the use of the Lookup functions, various logical functions and would be able to perform advanced formatting functions. Participants would also be able to develop different methods of analysing and working with data as well as presenting data through the use of tables and charts.
This course can be delivered to your organisation as part of our bespoke Corporate Training Solutions, at your own time and your own convenience.
CPE Hours: This course qualifies for 6 hours of structured CPE which can be classified as professional competency. A certificate of attendance will be provided at the end of each session.
For every three courses booked from our KPMG Learning Suites, attendees receive a discount voucher of 40% to be redeemed on their next course purchased from any Learning Suite!
The KPMG Learning Academy aims to leverage on an extensive amount of subject matter expertise generated from years of experience and hands-on approach of its trainers, in a Big 4 International Audit and Consultancy firm.
It provides diverse educational and training programmes which include ACCA qualifications, Continuous Professional Education seminars in accounting, tax, people management and other areas, postgraduate and undergraduate degrees and industry certifications.
Training is delivered in different formats, from live online sessions, to eLearning modules, classroom and blended training courses. All sessions offered by the Academy can be tailored to the individual needs of a business, while new subject areas can be explored according to the business’ requirements. The Academy works with its clients to design and build effective and practical learning solutions centred on the learner experience.
The Academy has its own Learning Management System (LMS) for online learning which can also be made available to businesses as repository of the eLearning content for access by their employees.
KPMG Learning Academy is licensed as a Further and Higher Education Institution (License number: 2017 – 010) by the National Commission for Further and Higher Education.