From the course: Excel for Business Analysts

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Finding a data model

Finding a data model - Microsoft Excel Tutorial

From the course: Excel for Business Analysts

Start my 1-month free trial

Finding a data model

- [Instructor] One challenge that comes up in just about every business analytics project is actually getting started in the first place. In particular, a lot of businesses say that they're interested in doing more with analytics but they're not really sure how to get started. Excel can't truly solve this problem, but it can help. I'm in the zero two zero four begin Excel file. Now, one of the nice things about Excel is that it creates an easy way to kind of think through problems analytically, and then to create templates that we can use later on. You could create templates on your own and just save them as individual sheets. You can also create templates by using Excel macros or alternatively, you can create templates by using add-ins. Now, a lot of people are familiar with Excel in general but you may or may not be familiar with Excel add-ins. Excel add-ins are basically specialized extensions that kind of plug into Excel…

Contents