Call toll free 1-877-272-5444 |
Live Chat
Showing two or more different chart types in a single chart can be very effective in communicating information. Clustered bar charts, for instance, are good for comparing values across categories, while line charts are good at showing trends over time. … Continue reading
Microsoft Word has some handy and straightforward sorting tools. To do a simple sort, select the text or table you would like to sort, then choose HOME or TABLE TOOLS/LAYOUT then SORT , and enter your sort criteria. In this … Continue reading
In Microsoft Office, the Mini Toolbar is a stripped down version of the Font group on the Home tab (with changes such as font, underline, bold, and italicize), as well as some other common tools from other groups. To access … Continue reading
A 3D formula is one that references cells or ranges across multiple worksheets with the same layout. It may help to think of your sheets as stacked on top of one another, with ranges going through the stack of worksheets. … Continue reading
Sometimes clicking and dragging your cursor over an area of cells lacks the needed subtlety when it comes to selecting cells. When a rectangular selection doesn’t cut it, it’s time to use the GO TO SPECIAL tool, which selects cells based on certain … Continue reading
We’ve written before about manually entering dates and automatically filling them in Excel, but one of the really powerful features of Excel spreadsheets is date functions, which enable you to perform useful date and time calculations. In this post, we … Continue reading
Manually entering dates in a spreadsheet can be time consuming. Also, as we noted before, manually entered dates must be entered in a particular way, so a wrong keystroke could mean the difference between a perfect spreadsheet and one with errors. … Continue reading
When you enter dates in Excel, they may not look right at first. That’s okay though! Whenever a number or date doesn’t look the way you want in Excel, you just have to format it. This is simple enough. Quick Date Format … Continue reading
Excel features a special format for dates. Unfortunately, some people find out about how Excel formats dates only after dates hadn’t been entered properly. Perhaps an invoice gets sent out on December 1 instead of January 12 because the day … Continue reading
It happens to each and every one of us eventually. It’s quite simply a matter of working with Excel long enough that one day you find yourself zipping right along opening up a workbook when nothing seems to happen. That … Continue reading
