Helpful Tips Blog
Excel Legacy Shortcuts
The following table is a list of Alt-Key shortcuts that still work with current versions of Excel. File Menu Alt+F New Alt+F-N Open Alt+F-O Close Alt+F-C Save Alt+F-S Save As Alt+F-A Print Preview Alt+F-V Print Alt+F-P Send To Alt+F-D Edit Menu Alt+E Undo Alt+E-U Cut...read more
In Microsoft Word, how can I get the filename (and path) in my document footer?
From the Insert menu select Footer. Once the Footer Design tab is displayed, click on Quick Parts and select Field… When the Field dialog box opens, you can select Document Information from the Categories section to narrow down the list of fields. The one you’re...read more
What is the purpose of the thesaurus feature in MS Word?
With Word’s Thesaurus, you can look up synonyms of words (different words with the same meaning) and antonyms (words with the opposite meaning). Just right-click on a word. In this example, the word is adolescence, and the synonyms are listed to give you other...read more
How do I create a Drop Cap in Word?
A drop cap is the first letter of a paragraph that is much larger than the surrounding text. Drop caps are traditionally used in printed books, newspaper articles, and also web pages. A drop cap can be sized so that is as large as the first few lines of text. Here is...read more
How do I add text directly onto an image in Word?
You can draw a text box on top of an image and enter text right into it. In the following example is an image and below it some text. From the Insert tab, click on Text Box and then Draw Text Box. Draw a textbox directly on top of the image. Cut and Paste the...read more
How do I create queries in Microsoft Access?
Go to the Create ribbon and select the Query Wizard. From the Simple Query Wizard dialog box, select the fields you want to be included in the report. Add fields by either double-clicking them or by single-clicking the field name and then the ">" icon. Selected...read more
How do I link an Excel spreadsheet into Access?
If you have data in Excel, you can bring that data into an Access table. For example, the following is a small database in Excel. You can link the Excel table into Access by clicking on the Excel icon in the Import & Link section of the External Data tab. When...read more
Why is the formula bar important in MS-Excel?
In Excel you have the option of entering data directly into a cell or by entering into the formula bar. It might be easier when initially entering straight data to enter it into the cell. But the formula bar makes it helpful when entering a formula (equation) or a...read more
In Excel, how do you create more than one graph type in one chart?
If you have ranges of data that don’t fit on one range you can create, in effect, more than one graph type on the same graph. In the following example, there is a range of data in Column C indicating sales in one department and in Column D the percentage of sales from...read more
How do I convert seconds to minutes in Microsoft Excel?
Depending on how your spreadsheet is set up you can do a few things. If your seconds are calculated from the time of day, you can convert the time to minutes and seconds. The cells in columns C and F are formatted with the general format. So therefore, you could...read more
How do you create equations in Microsoft Word?
If you need to insert an equation in Word, position your cursor where you want the equation to appear and go to the Insert tab. If you click on the arrow to the right of Equation, a group of built-in equations will appear. If you don't see what you want, click on...read more
Save time and get your work done more easily. Click on any of the links below to download Keyboard Shortcuts. Word Format Microsoft Word Keyboard Shortcuts Microsoft Excel Keyboard Shortcuts Office 365 Keyboard Shortcuts PDF Format Microsoft Word Keyboard...read more