Microsoft Excel for Mac has a few obvious uses. A few blog posts back we covered budgeting in Excel, and how easy it is to set up a simple to use template that does all the calculations for you while you input the data.
Today we are going to tackle and even simpler use for Microsoft Excel on your Mac. Data Lists. The layout of any spreadsheet is very advantageous when dealing with lists of information. Anything from addresses to contacts to inventory can be listed in an easy to use format in Microsoft Excel for Mac.
Why is it easier than Microsoft Word, a dedicated word processor? Lets take a look at some data lists in each program and compare.
Here is our list of inventory for our Restaurant Supply store in Microsoft Word:
And here is the same list in Microsoft Excel:
In my opinion the Microsoft Excel list is easier to read, but that is not the main benefit. The benefit comes from the ease of manipulation. Since our products are in individual cells we can easily remove them, or format them depending on our current inventory. In the Microsoft Word example the list is more of a sentence, and much harder to manipulate without editing the entire entity.
If you like keeping lists of data, but are currently using Microsoft Word, give Microsoft Excel a try! I promise you will find it easier after a few clicks.
And as always, let the Excel Skin team know if you have any questions!
Comments will be approved before showing up.