Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In this third course of our Excel specialization Excel Skills for Business you will delve deeper into some of the most powerful features Excel has to offer. When you have successfully completed the course you will be able to
Check for and prevent errors in spreadsheets;
Create powerful automation in spreadsheets;
Apply advanced formulas and conditional logic to help make informed business decisions; and
Create spreadsheets that help forecast and model data.
Once again, we have brought together a great teaching team that will be with you every step of the way. Nicky, Prashan and myself will guide you through each week. As we are exploring these more advanced topics, we are following Alex who is an Excel consultant called in by businesses that experience issues with their spreadsheets.
Lookup Table, Microsoft Excel Vba, Data Validation, Microsoft Excel Macro
Bewertungen
4.8 (7,240 Bewertungen)
5 stars
84,58 %
4 stars
13,12 %
3 stars
1,74 %
2 stars
0,31 %
1 star
0,23 %
DM
7. März 2019
Love this course....It taught me a lot. It was little more challenging but I passed it. I definitely need more practice at doing these formulas and equations. Thank You for offering this great course
UA
20. Juli 2020
Practice Challenge of Week 6 is very difficult. It would be great if the team could add the step by step video on how to solve that challenge. It will be a big help for all the future learners.
Aus der Unterrichtseinheit
Formula Auditing and Protection
If you are worried that errors have crept into your worksheet, this module will show you how to check for errors, trace precedents and dependents, resolve circular references, and finally, protect your worksheets and workbooks from further harm.