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 - Microsoft Excel Tutorial
From the course: Excel for Business Analysts
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.