Tracking data with Microsoft Excel

December 23, 2015

0 comments

bar graph   chart   Excel   Excel Skin   Excelskin   graph   Mac Excel Shortcuts   mac shortcuts for excel   Mastering Excel   Microsoft   Microsoft Excel   Microsoft Excel for Mac   Office 2016   pie chart  



We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience.

That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The Excel Skin will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the Excel Skin just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC. And with the Excel Skin, you’ll relearn your old shortcuts in no time.

The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability.

The Excel Skin a small product that will make a big difference in your life.

 

As you may know, Microsoft Excel is a great way of keeping track of basically anything. You can track your workouts, travel plans, packing list, holiday shopping, or even your diet.
In this blog post I will show you how I use Excel to track the type of Customer Support tickets I receive on a weekly basis.
My first workbook is the data center. In this workbook I add the number of times a criteria is applied to a label compared to the total number of tickets.

The next step is to make a chart for those that are a bit more visual. The second tab will be your bar graph, and the third tab will be the pie chart. The bar graph is a nice and easy graph for the number of times a label is applied, and the pie chart is more suitable for the percentages.


To set up a chart, click on the Charts tab in the toolbar.

This will bring you to a list of charts that you can create. Click on the one you want. In this case, I will do a vertical bar chart, or Column.

What appears is a blank screen where the chart will be.

Now we must designate the data we want in the chart. To do so, right click the blank window and click Select Data.

This will open a Select Data dialog box.

In this dialog box, we want to designate the data with the Chart data range: space. Click in the blank space, and then go to your data and select the range of data you wish to select.

Click OK when you are done selecting the data, and your chart will appear.

Please let us know if you have any questions, the Excel Skin team is here to help!



Leave a comment

Comments will be approved before showing up.