A picture is worth a thousand words, so why not save yourself from typing a thousand words by inserting a screenshot instead? No need for extra programs to capture and crop your screenshots. You can easily e-mail a picture of a dialog box, browser screen, or anything else that appears on your desktop by following these simple instructions in Outlook 2010 or Outlook 2013. Begin by creating a new e-mail,[…]
READ MORE about Outlook 2010/2013 Tip: Insert a Screenshot in a MessageMicrosoft Word: Setting the Distance between Text and Borders
One common formatting effect within Word is the application of borders around a paragraph. Word allows you to apply borders to all four sides of a paragraph—you can even have the borders be different from each other, if desired. After applying border formatting, you may decide that you need some more room between the actual border lines and the text within the paragraph. You can easily adjust this distance by[…]
READ MORE about Microsoft Word: Setting the Distance between Text and BordersExcel Tip: Speed up Excel Data Entry by Changing Enter Key Behavior
Adjusting the behavior of the Enter key can be greatly beneficial when inputting data into Excel. Hitting the Enter key to move to the next cell in Excel is a movement we really don’t have to think about anymore – that is, until we are not moved to the desired cell. Luckily, Excel has an option to change the behavior of the Enter key. To access this option, click File[…]
READ MORE about Excel Tip: Speed up Excel Data Entry by Changing Enter Key BehaviorCrystal Reports: Add a Watermark to Your Report
Watermarks are an excellent way to ensure continued security for your reports. To add a watermark, first copy the image you would like to use to the Page Header section. Select Go to Report > Section Expert. Select the Page Header under Sections, then check Underlay Following Sections on the Common tab. Click OK, and your report will be watermarked!If you would like the watermark to appear on the first page of the report[…]
READ MORE about Crystal Reports: Add a Watermark to Your ReportProject 2007 Tip: Highlight Current Tasks
Create a new view in Project to highlight tasks need to get done this week. (or any date range) Click Choose View | More Views from the Menu bar In the More Views dialog, select the Gantt Chart and click the Copy button Name you view, then select the Filter drop-down arrow and choose Date Range Check the Highlight filter option and click OK. Now simply apply your new view.[…]
READ MORE about Project 2007 Tip: Highlight Current TasksExcel Tip: Highlight All Cells Referenced by a Formula
Select a cell with a formula and press Ctrl-[ (Ctrl-open-square-bracket). Excel 2010 highlight all the cells referenced by the formula, and moves the current selection to the first of the referenced cells. Press Enter, and the selection moves to the next referenced cell. Continue to press Enter to move through the rest of the referenced cells.
READ MORE about Excel Tip: Highlight All Cells Referenced by a FormulaPowerPoint 2007 Tip: Highlighting Text in PowerPoint 2007
The ability to highlight text in your presentation is not available PowerPoint 2007. Instead, create a text box with color for any text you want to emphasize. Select the Insert tab. In the Text group, click Text Box, and then drag out a text box on your slide. Enter the text that you want highlighted in the text box. Now select the Home tab. In the Drawing group, click Shape[…]
READ MORE about PowerPoint 2007 Tip: Highlighting Text in PowerPoint 2007Crystal Reports – Prevent an Orphaned Group Header
Interested in Crystal Reports Training? Check out our Course List to view course outlines For more information about Crystal Reports training, please call (512) 794-8440 or please fill out our Class Information Request Form and we will contact you with more information. In Crystal Reports (CR), when printing or previewing a report, the Group Header displays at the bottom of the page and the group’s records appear on the following[…]
READ MORE about Crystal Reports – Prevent an Orphaned Group HeaderExcel Tip: Enter Data into Multiple Worksheets at the Same Time in Excel
Let’s say you want to enter the same title into several worksheets in the same Excel workbook. The traditional way to accomplish this is to enter the title on one worksheet, then use copy and paste to copy the title into the other worksheets. An easier way is to select multiple worksheets before entering the title. Try the following: Start Excel and open a new workbook file. Press and hold[…]
READ MORE about Excel Tip: Enter Data into Multiple Worksheets at the Same Time in ExcelWord Tip: Drawing Lines in Word
To quickly draw a horizontal line in your Word document, type three hyphens (-) in a row, then press Enter. You can draw other line styles using this same technique, only with different characters. Hyphen ( – ): standard line Underscore ( _ ): thick line Equal sign ( = ): parallel lines Tilde ( ~ ): zig-zag line Pound ( # ): ridge line Asterisk ( * ): dotted[…]
READ MORE about Word Tip: Drawing Lines in Word