Course Overview
Enhance your professional skills to a whole new level with the best-selling and award-winning Excel Must know Formulas and Functions course! Don’t waste time with poor quality training – study the Excel Must know Formulas and Functions and get an expertly-designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through this online training course.
This online training course is accredited by the CPD and provides 10 points. Students can expect to complete this training course in around 2 hours. You’ll also get dedicated expert assistance from us to answer any queries you may have while studying our course.
This course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Excel Must know Formulas and Functions course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enrolling on this course.
With this comprehensive course, you can achieve your dreams and train for your ideal career. This course provides students with an in-depth learning experience which you can work through at your own pace to enhance your professional development. This course covers everything you need in order to progress in your chosen career.
Enrolling on the will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the Excel Must know Formulas and Functions program.
Why Prefer Us?
- Standard-aligned lesson planning
- Innovative and engaging contents and activities
- Assessments which measure higher-level thinking and skills
- Receive a CPD-accredited certificate upon successful completion
- Complete the program in your own time, at your own pace
- Each of our students gets full tutor support on weekdays (Monday to Friday).
Course Preview
Assessment Process
Once you have completed all the modules in the course, your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the course.
Showcase Your Accomplishment of New Skills: Get a Certification of Completion
To receive the CPD and IAO approved certificate, learners must successfully complete the course assessment. For only £10, you may obtain digital certificates. Learners in the UK can buy printed hard copies for £29, while overseas students can buy printed hard copies for £39.
Course Curriculum
| Excel Must know Formulas and Functions | |||
| Building basic math formulas | 00:08:00 | ||
| Autosum and Relative references | 00:09:00 | ||
| Absolute references | 00:06:00 | ||
| Named Ranges | 00:06:00 | ||
| Linking sheets and workbooks | 00:06:00 | ||
| If, And, Or, and the nested If functions | 00:16:00 | ||
| Countif, Sumif, Averageif, Sumifs, and Countifs functions | 00:09:00 | ||
| Vlookup and Hlookup functions | 00:15:00 | ||
| Match and Index functions | 00:07:00 | ||
| Date and time formulas and functions | 00:12:00 | ||
| Text functions | 00:11:00 | ||
| Tracing formulas | 00:08:00 | ||
COURSE REVIEWS
Course Reviews
No Reviews found for this course.
