Pivot tables are very powerful in summarizing data…..sometimes you may wish to do more than just display the actual numbers. This example shows you how to show % of either column (category) total or the grand total. In addition, discover how to change the formatting of the numbers. You will also know how to refresh data – if there is ever a change in the source data, the pivot table will NOT show it until it is refreshed.
For those of you who enjoy photography, below are a few resolutions that I am hoping to follow next year! Some are tongue-in-cheek, yet serious
- When I take pictures, I promise not to take 37 shots of the same image – I will take a moment or two to look at the area, take my picture(s) yet not overdo it. Back in the days of film (and it could be costly!), I’d think things out first. Even though it is “free,” it can be very time consuming to delete excess photos or to just waste time wading through all of the images. This rule can be broken when you’re in a once-in-a-lifetime experience such as being at the top of Mt. Everest.
- Deciding what accessory, lens, gadget I need rather than want. Too often the gadgets get in the way and can slow you down (either in weight) or deplete the checking account. If it is something you need, get it. If it is a want, wait about 90 days and then you’ll decide whether or not it’s worthwhile.
- Try to learn a shortcut or two in your post production processing – actions and batches can be huge time savers when you ignored resolution #1!
- Try to spend some time just looking and enjoying the sights, vistas, beauty. We can get more joy and pleasure by admiring what we see rather than trying to recapture it! This is a great idea especially when you forgot your camera.
- Get a picture (or 2 or 3) off of the camera/computer – print it out – hang it so you (and everyone else) can enjoy the image! Change the images in the frame every few months or weeks – it’s an inexpensive way to keep your personal momentum going (as well as decorating your home or office).
if you have some time off during the holidays and are planning on improving your skills for your current (or future) job, these are the 10 basics you need to know:
- How to enter basic formulas and calculations
- Add up a column or row of cells
- Absolute and relative references
- Rounding numbers
- Scale your spreadsheet to fit on one page when printing
- Print a spreadsheet with page numbers (and knowing footers with dates, sheet name, file name)
- Freeze or lock rows and columns in
- How to use the IF function in Excel to calculate values based on different criteria
- How to use Autofilter in Excel
- How to create a Pivot Table – this is an intermediate function that is required more and more in the workforce – indicating knowledge of this topic on your resume is more than slightly helpful!
There more than a few references on the internet on how to do any or all of these – if, like most people, you desire hands on tutoring, find someone to help or take a class – either in continuing education or at a local college.
Printing a spreadsheet is basically simple. This goes into a additional topics – i.e. printing what should only be a one page worksheet that is too many pages long and how to fix it. We also discuss hiding data that we don’t others to see or have access to (hiding columns doesn’t do the trick as they can unhide them).
Copy and paste special are included in this along with rounding of numbers, you will get 4.50 instead of 4.48934533 and using paste special so you don’t get the full unrounded value.
This is a very basic function in Excel – sometimes you may need printed documentation of both of these items – the comments can be used as a reference as what needs to be done. Having formulas printed out can be a method of seeing how a complex formula was created – these printouts can be used as reference in future tasks (we cannot remember everything!).
This will work with any version of Excel up to 2016/365!
Tables have their uses in Excel where data can be instantly formatted. You can also filter (query) the data set to find data that meets specific conditions. They are useful if you need to do some quick calculations – they can also be attractively presented.