OUTLOOK® SHORTCUT KEYS

Alt + S Send the email

Ctrl + C Copy selected text

Ctrl + X Cut selected text

Ctrl + P Open print dialog box

Ctrl + K Complete name/email typed in address bar

 Ctrl + B Bold highlighted selection

Ctrl + I Italicize highlighted selection

 Ctrl + U Underline highlighted selection

 Ctrl + R Reply to an email

 Ctrl + F Forward an email

 Ctrl + N Create a new email

 Ctrl + Shift + A Create a new appointment to your calendar

 Ctrl + Shift + O Open the outbox

Ctrl + Shift + I Open the inbox

Ctrl + Shift + K Add a new task

Ctrl + Shift + C Create a new contact

 Ctrl + Shift+ J Create a new journal entry

EXCEL® SHORTCUT KEYS

F2 Edit the selected cell

F5 Go to a specific cell

F7 Spell check selected text and/or document

F11 Create chart

Ctrl + Shift + ; Enter the current time

Ctrl + ; Enter the current date

Alt + Shift + F1 Insert new worksheet

Shift + F3 Open the Excel® formula window

Shift + F5 Bring up search box

Ctrl + A Select all contents of worksheet

Ctrl + B Bold highlighted selection

Ctrl + I Italicize highlighted selection

Ctrl + C Copy selected text

Ctrl + V Paste

Ctrl + D Fill

Ctrl + K Insert link

Ctrl + F Open find and replace options

Ctrl + G Open go-to options

Ctrl + H Open find and replace options

Ctrl + U Underline highlighted selection

Ctrl + Y Underline selected text

Ctrl + 5 Strikethrough highlighted selection

Ctrl + O Open options

Ctrl + N Open new document

Ctrl + P Open print dialog box

Ctrl + S Save

Ctrl + Z Undo last action

Ctrl + F9 Minimize current window

Ctrl + F10 Maximize currently selected window

Ctrl + F6 Switch between open workbooks/windows

Ctrl + Page up

& Page Down Move between Excel® worksheets in the same document

Ctrl + Tab Move between two or more open Excel® files

Alt + = Create formula to sum all of above cells

Ctrl + ‘ Insert value of above cell into current cell

Ctrl + Shift + ! Format number in comma format

Ctrl + Shift + $ Format number in currency format

Ctrl + Shift + # Format number in date format

Ctrl + Shift + % Format number in percentage format

Ctrl + Shift + ^ Format number in scientific format

Ctrl + Shift + @ Format number in time format

Ctrl + g Move to next section of text

Ctrl + Space Select entire column

Shift + Space Select entire row

Ctrl + W Close document

MICROSOFT® WINDOWS® SHORTCUT KEYS

Alt + Tab Switch between open applications

Alt + Shift + Tab Switch backwards between open applications

Alt + Print Screen Create screen shot for current program

Ctrl + Alt + Del Reboot/Windows® task manager

Ctrl + Esc Bring up start menu

Alt + Esc Switch between applications on taskbar

F2 Rename selected icon

F3 Start find from desktop

F4 Open the drive selection when browsing

F5 Refresh contents

Alt + F4 Close current open program

Ctrl + F4 Close window in program

Ctrl + Plus Key Automatically adjust widths of all columns

in Windows Explorer

Alt + Enter Open properties window of selected icon

or program

Shift + F10 Simulate right-click on selected item

Shift + Del Delete programs/files permanently

Holding Shift During Bootup Boot safe mode or bypass system files

Holding Shift During Bootup When putting in an audio CD, will prevent

CD Player from playing

BASIC SHORTCUT KEYS

Alt + F File menu options in current program

Alt + E Edit options in current program

F1 Universal help (for all programs)

Ctrl + A Select all text

Ctrl + X Cut selected item

Shift + Del Cut selected item

Ctrl + C Copy selected item

Ctrl + Ins Copy selected item

Ctrl + V Paste

Shift + Ins Paste

Home Go to beginning of current line

Ctrl + Home Go to beginning of document

End Go to end of current line

Ctrl + End Go to end of document

Shift + Home Highlight from current position to beginning of line

Shift + End Highlight from current position to end of line

Ctrl + f Move one word to the left at a time

Ctrl + g Move one word to the right at a tim

How to use Excel DCOUNT formula

							This is the Database range.
Product	Wattage	Life Hours	Brand	Unit Cost	Box Quantity	Boxes In Stock	Value Of Stock
Bulb	200	3000	Horizon	£4.50	4	3	£54.00
Neon	100	2000	Horizon	£2.00	15	2	£60.00
Spot	60						£0.00
Other	10	8000	Sunbeam	£0.80	25	6	£120.00
Bulb	80	1000	Horizon	£0.20	40	3	£24.00
Spot	100	unknown	Horizon	£1.25	10	4	£50.00
Spot	200	3000	Horizon	£2.50	15	1	£37.50
Other	25	unknown	Sunbeam	£0.50	10	3	£15.00
Bulb	200	3000	Sunbeam	£5.00	3	2	£30.00
Neon	100	2000	Sunbeam	£1.80	20	5	£180.00
Bulb	100	unknown	Sunbeam	£0.25	10	5	£12.50
Bulb	10	800	Horizon	£0.20	25	2	£10.00
Bulb	60	1000	Sunbeam	£0.15	25	1	£3.75
Bulb	80	1000	Sunbeam	£0.20	30	2	£12.00
Bulb	100	2000	Horizon	£0.80	10	5	£40.00
Bulb	40	1000	Horizon	£0.10	20	5	£10.00
Count the number of products of a particular Brand which have a Life Hours rating.
			Brand	These two cells are the Criteria range.
		Type the brand name :	Horizon
		The COUNT value of Horizon is :	7	=DCOUNT(B3:I19,D3,E23:E24)
What Does It Do ?
This function examines a list of information and counts the values in a specified column.
It can only count values, the text items and blank cells are ignored.
Syntax
=DCOUNT(DatabaseRange,FieldName,CriteriaRange)
The DatabaseRange is the entire list of information you need to examine, including the
field names at the top of the columns.
The FieldName is the name, or cell, of the values to Count, such as "Value Of Stock" or I3.
The CriteriaRange is made up of two types of information.
The first set of information is the name, or names, of the Fields(s) to be used as the basis
for selecting the records, such as the category Brand or Wattage.
The second set of information is the actual record, or records, which are to be selected, such
as Horizon as a brand name, or 100 as the wattage.
Formatting
No special formatting is needed.
Examples
The count of a particular product, with a specific number of boxes in stock.
			Product	Boxes In Stock
			Bulb	5
		The number of products is :	3	=DCOUNT(B3:I19,H3,E50:F51)
This is the same calculation but using the name "Boxes In Stock" instead of the cell address.
			3	=DCOUNT(B3:I19,"Boxes In Stock",E50:F51)
The count of the number of  Bulb products equal to a particular Wattage.
			Product	Wattage
			Bulb	100
		The count is :	2	=DCOUNT(B3:I19,"Boxes In Stock",E61:F62)
The count of Bulb products between two Wattage values.
			Product	Wattage	Wattage
			Bulb	>=80	<=100
		The count is :	4	=DCOUNT(B3:I19,"Boxes In Stock",E68:G69)