This course covers essential Excel skills, including basic functions, cell referencing, data sorting, and conditional formatting. You'll master the use of formulas like SUMIFS, and IF statements, learn to manage data using tables, create professional reports with charts and graphs, and ensure accessibility and organization through keyboard shortcuts, data validation, and error handling. The course also dives into managing linked workbooks and using dynamic arrays to improve workflow.
This certification will enhance your ability to efficiently organize and analyze data, manage spreadsheets with accuracy, and create impactful reports using Excel's core functionalities. With the skills learned, you'll be able to perform tasks with greater speed and precision, solve problems related to data integrity, and present your findings clearly using charts and visual tools. Whether for administrative, analytical, or reporting tasks, these skills will make you an indispensable asset in any professional setting.
1. Complete the entire video 100%.
2. Answer all the review questions correctly. The review questions are at the bottom of the same page where you are viewing the course video.
3. Once you have watched the whole video and answered all the review questions, the Final Quiz will open up. You need to score more than 70% in the Final Quiz to avail your CPE credit. Multiple attempts are allowed for submitting Review and Final Quiz questions.
4. Once you have completed the Review and Final quiz questions, you shall be able to download the credit certificate from the ‘My Certificates’ section. Kindly ensure you have allowed Multiple File download from your web browser to download all certificates.
5. You can download individual certificate from your "Account" as well as from this page once you complete a particular courses. Also, you can download "Consolidated Certificate" from the package page or from your account.
If neither of the above cases works, please drop an email to support@my-cpe.com or contact our support team through live chat support.