 Figuring Out the Business Quarter From a Date
|
Summary: There are times when you need to figure out the business quarter in which a date falls. Here is one way of doing this:
The key to calculating the quarter is the month of the date. Here the steps to do this using an IF statement formula. Assume the date is in cell A1.
=IF(Month(A1)<=3,"Q1",IF(Month(A1)<=6,"Q2",IF(Month(A1)<=9,"Q3",IF(Month(A1)<=12,"Q4")))&"-"&Text(A1,"yy")
The IF statement checks the month to see if it returns the boundaries for the quarter (3,6,9,12) and then assigns the appropriate quarter. A dash and the last two digits of the year are added to the end of the quarter.
|
Highlighting Duplicates
|
Summary: Many times you will have duplicates in a column of data. Here is a quick way to highlight the duplicates using Excel's Conditional Formatting:
Starting by highlighting the data you want to check.
- Select the Home Tab.
- Click on Conditional Formatting in the Styles Group.
- Click on Duplicate Values.
- Select OK.
All of the duplicates will be highlighted.
|
Back to top
The Developer Tab
Summary: Advanced users of Excel will find the Developer tab to be very useful when you are working with macros. By default the Developer tab is not visible. Here is how to turn it on.
If you are using Excel 2010.
- Right mouse click on the tab line.
- Click on Customize the Ribbon.
- Click on the Developer check box.
- Click on OK
If you are using Excel 2007
- Click on the Office Button
- Click on Excel Options.
- Select Popular at the left hand side of the dialog box.
- Click on Show the Developer Tab in the Ribbon check box.
- Click on OK.
With both versions the Developer Tab should now be visible in the Ribbon.
|
|
Print Preview in Word 2012
Summary: Word 2010 has enhanced the Print Preview in Word 2010. Here's a list of the enhancements:
- To use Print Preview click on the File tab.
- Click on Print. In the right hand panel you will see a preview of what will print.
- Word 2010 Print Preview has a set of controls that allow you to increase or decrease the magnification of the print image. The zoom tools in the lower right hand corner of the Print Preview area provide five separate tools.
- The Zoom button on the left shows you the current magnification.
- Zoom Out will reduce the magnification when you click on it.
- Zoom Slider allows you to drag in either direction to increase of decrease the magnification.
- Zoom In will increase the magnification and you will see less of the page.
- Fit to Page reduces the image to let you see the entire page in the Print Preview window.
You can also click on Many Pages to view a number of page thumb nails on one page.
|
|
Summary: During your slide show you may want to write on a slide as if you were using a white board. You can use different types of pens and colours and write anything you want, including underlining, circling or any other freehand writing.Here is how to do this:
- At any point in your slide show press the right mouse button and highlight Pointer Options.
- Select the type of pen you want to use (ballpoint, felt tip or highlighter).
- Choose your ink colour.
- Hold down your left mouse button and drag the pen over the slide you want to write on.
- Click on Insert to insert the translation into your PowerPoint slide.
At the end of your presentation you will have the option to keep your ink annotations or discard them. If you keep them they will remain part of your presentation.
|
