|Customize Excel's pivot table|
If you were to ask business owners or managers the number one program they use on a regular basis, many would probably say the spreadsheet. This versatile program helps managers and owners keep track of various information but some spreadsheets can reach such massive sizes that they become unwieldy. Excel has a function that can help you easily pull data from a large spreadsheet – the pivot table. While useful, the pivot table isn’t perfect and will usually require a some formatting.
Here’s four ways you can modify Excel 2013 for Office 365′s pivot tables to meet your needs.
Make your tables look good
When you first create a new pivot table you may notice that the numbers aren’t formatted properly, or the table didn’t pull the format from the base spreadsheet. They may have too many decimal places, or are lacking currency figures. You can make edit this by:
This will open the Field Settings panel and allow you to edit the whole Value field, which means that if you change numbers, location, etc, the formatting will stick. Pressing Number Format will bring up the Format Cell window where you can apply numbers, currencies, decimal places, etc. Pressing Ok will apply the formatting you have selected to the whole field.
You can also apply color schemes or styles by pressing the Design tab and selecting the theme that looks good to you. This will not usually change the layout, just the color and style.
Change the name of the table and fields
If you are going to be sending the table to clients or colleagues, you may want to change the name of the table and fields to something a little more user-friendly. You can change the names by:
Add gridlines for easier viewing
If you need to separate the information in the cell, the easiest thing to do is to add gridlines. This can be done by:
Change blanks to 0s
There may be an issue where the data that’s used to create the table leave blank spaces when they should be 0s. This isn’t a big deal, but it would be a good idea to ensure that, for consistency, blank cells are represented as a 0, especially if other related cells are numbers. You can force Excel to fill blank cells with a 0 by:
Excel and the pivot table bring some excellent functionality to the spreadsheet, and having a properly formatted pivot table could go a long way in ensuring the information shown is easier to read. If you would like to learn more about how Excel or any of the other Office 365 programs can help, please contact us today.
Published with permission from TechAdvisory.org. Source.
|Do you use Gmail Priority Inbox?|
When you say Inbox, few people will look at their desk for the once physical bin. Now, it’s an important part of your email platform. Chances are that your Inbox is overflowing with emails, making it hard for you to focus on the most important of them. If you use Gmail, there is a little-used function that can help you separate important emails from less-so.
|Confused about computer viruses?|
Myths have always been a part of human culture, and can be found in nearly every aspect of life, including the computer. One of the larger computer-based myths revolves around malware, more specifically the virus. Many users are familiar with the concept but have a tough time distinguishing between what is true and what isn’t. Are you one of them?
|Google to shut down Reader|
Google first launched as a search engine and has since grown to an Internet juggernaut with apps and services filling nearly every need. Anyone with a wide range of products knows that it’s hard to maintain them. To better manage their product portfolio, Google tends to shut down programs that are less popular or are deemed to be no longer useful. Some of the more recently announced retirements may be apps that you use on a daily basis.
|Two new awesome Pinterest features|
There are numerous ways a business can build a brand and ultimately grow. One of the most popular tools to help with this is social media, of which there are numerous services. The newest social media service is Pinterest which is dedicated to the sharing of images. Pinterest has recently been updated with a new layout and features that businesses with profiles will benefit from.