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 TasksPowerPoint 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 WordAccess Tip: Using the AutoNumber Data Type in Access
The AutoNumber data type automatically generates a unique number for each record that’s added to a table, and is commonly used for primary key fields. Seldom, if ever, should the value of the AutoNumber field be shown to your database users. If the value of the AutoNumber field is relevant to your Access forms and reports, then it may be that you shouldn’t be using the AutoNumber type, since there[…]
READ MORE about Access Tip: Using the AutoNumber Data Type in Access