From the course: Excel for Business Analysts
Join today to access over 24,200 courses taught by industry experts.
Mapping your data - Microsoft Excel Tutorial
From the course: Excel for Business Analysts
Mapping your data
- [Illustrator] When it comes to business analytics what frequently happens is that as you develop a larger and larger data set it can be more and more useful to the company but it can also be more and more complex. Excel can't solve the complexity in your data but it can help you to better organize it. I'm in the zero two zero five begin Excel file. Now what you see here is an example of different variables that we might be interested in for some sort of a financial analysis type project, right? We've got variables related to acquisitions, to capital gains rights, to dividends and earnings per share, to GDP, et cetera. Lots of different variables. What's nice about Excel though, is that because we have such an easy to use spreadsheet system, we can go through and create kind of a data dictionary if you will. And this lets us understand what do these different variables mean? This might not seem very important if…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.