Figure out dates by using formulas in Excel
Quick Reference Card
The calendar starts at 1900 in Excel for Windows
Dates are stored in Excel as serial numbers starting with 1, which for Excel for Windows
represents January 1, 1900. Thats when its cale
Create formulas in Excel
EXERCISE 1: TYPE SOME SIMPLE FORMULAS TO ADD, SUBTRACT, MULTIPLY, AND
Click in cell A1. First youll add two numbers.
Press ENTER on your keyboard to get the result of 916.
Now lets subtra
Get control of page numbers, headers, and footers
OPEN HEADERS AND FOOTERS
Use one of three methods:
Double-click in the header or footer area of the document.
Right-click in the header or footer area, and click Edit Header.
Click the Insert tab, and i
Work with tables
EXERCISE 1: CREATE A TABLE
Click inside the data; for example, click in cell A3.
On the ribbon, click the Insert tab.
In the Tables group, click Table.
The Create Table dialog box opens.
Make sure that the My table ha
Keyboard shortcuts in Excel 2010
This article describes what Key Tips are and how you can use them to access the ribbon. It
also lists CTRL combination shortcut keys, function keys, and some other common shortcut
keys for Microsoft Excel.
Note If you are
Word 2010 tips and techniques
OPEN WORD REALLY FAST
Press the Windows Key+R, type winword, and then press Enter.
USE A TEMPLATE FROM OFFICE.COM
On the File tab, click New, and then under Office.com Templates, choose a template.
CONVERT TEXT INTO A TABLE
Create and customize a table of contents
GENERATE A TOC
To generate a TOC, Word by default looks for built-in heading styles to be applied to document headings.
There are other ways to mark the text for inclusion, too, and these are detailed in subse
Quick Reference Card
THE RIBBON, IN 3 PARTS
The ribbon is the rectangular region across the top of the document window. It puts the options you need in plain
view. The ribbon has three basic components:
Tabs. There are eight of them across the top. Each r
Create accessible Word documents
Run Accessibility Checker
Click the File tab, and then click Info.
Under Prepare for Sharing, click Check for Issues.
Click Check Accessibility.
You will return to your document where the Accessibility Checker
Enable the use of other languages in your Office programs
You can change the editing, display, ScreenTip, and Help languages of your Microsoft Office programs so that they
are different languages. The languages available depend on the language version of
Access the ribbon
1. Press ALT. The KeyTips are displayed over each feature that is
available in the current view.
2. Press the letter shown in the KeyTip over the tab that you want to
3. Continue pressing letters until you press t