Saturday, 11 February 2017

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

Thursday, 2 February 2017

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)