Data Modelling in Excel Masterclass: Excel Formulas [Free Course]

Art & Science of data modelling in Excel. Master Excel formulas.
Instructed by: Excel TV | Subject: Office Productivity, Microsoft

Description

The Art Science of Excel Modeling is an in-depth exploration of how to plan, design, and maintain superior Excel models. Ideal for consultants, financial analysts, auditors, accountants, managers, and technical professionals seeking to gain a deeper understanding of the “art-science” of data modeling and how it can lead to improved business decisions. Kicking off with a bigger-picture, more philosophical view of spreadsheet design principles, our aim is to inspire critical thinking skills and confidence in an increasingly competitive job market. In our “real world based” case studies, we will explore creative solutions to routine business problems in the business, finance, and accounting world. We will also offer practical guidance for newer challenges arising from the ever-increasing volumes of “big” data that seem to be “pushing the boundaries” that Excel is naturally equipped to handle.

Outcome

1. Plan, design & maintain superior Excel models
2. Develop creative solutions to routine business problems in the business, finance, and accounting world
3. Process "big data"in Excel
4. Source and clean up source data for reporting

Take This Course

Course Info

• 71 Lectures
• 9 Hours
• Language: English
• Subject: Office Productivity, Microsoft
• Instructed by: Excel TV
• Last updated on January 2018
• Platform: Udemy