Excel Modeling for Professionals: Best Practices & Pitfalls
- Offered byCoursera
Excel Modeling for Professionals: Best Practices & Pitfalls at Coursera Overview
Duration | 17 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Excel Modeling for Professionals: Best Practices & Pitfalls at Coursera Highlights
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Intermediate Level
- Approx. 17 hours to complete
- English Subtitles: English
Excel Modeling for Professionals: Best Practices & Pitfalls at Coursera Course details
- Through this course learners will gain the tools to decide whether or not Excel is the right software to use. They will learn how to set up good input data, format correctly, and the importance of good documentation. Learners will gain the ability to discern between different functions, to understand the pitfalls and strengths of commonly used functions, and to apply correct functions to their excel models. Those that follow the course will also gain understanding of logical spreadsheet structure, graphs and reporting, and protection and hidden information in Excel, and users will learn how to apply these things to their own models. Finally users will get practical tips and steps for the finalization of a model, the automated checks, the manual run through, and general testing that one should do to ensure that their Excel model is accurate and complete.
- What sets this course apart is that we don?t focus on quick fixes or specific tips and tricks. This course is for those that already understand Excel. The aim of the course is to elevate Excel models, to improve clarity, longevity, and transferability of these models, and to reduce mistakes and to encourage consistency in businesses as they work with Excel.
Excel Modeling for Professionals: Best Practices & Pitfalls at Coursera Curriculum
A Foundation for Better Spreadsheets
About this masterclass
Expert Video: Ingeborg Hawighorst - Is Excel the answer?
Expert Video: Importance of good input data, and how to check it
Expert Video: The importance of Formatting in Excel
Expert Video: Why is documentation important?
Introduction
5 Excel Blunders that show how important safe Excel use is
Match the correct solution to the problem
Testing your input data
How to format consistently in Excel
The importance of documentation
A foundation for better spreadsheets
Good Use of Formulas and Functions
Recap & look forward
Expert Video: Pitfalls of commonly used Functions & Formulas
Expert Video: Functions and Formulas
Expert Video: Functions and Alternatives
Find & Search Functions
Calculation Functions
Other Functions
Spreadsheet Structure and Logical Flow
Recap & look forward
Expert Video: Linear and logical spreadsheet flow
Expert Video: Keep it Simple
Expert Video: Protection and Hidden Information
Linear and logical spreadsheet flow
Keep it Simple
Protection & Hidden Information
Spreadsheet Structure and Logical Flow
Finishing Touches
Recap & look forward
Charts, Pivot Tables, and Reporting (Gasper Kamensek)
Charts, Pivot Tables, and Reporting (Henk Vlootman)
Expert Video: Checking, Testing, and Validation
Expert Video: Finalization
Charts and Reporting
Checking, Testing, and Validation
Finalization
Excel Modeling for Professionals: Best Practices & Pitfalls at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?