Category:

Shortcuts

Welcome to my Institute!

Keyboard shortcuts save time and energy!

Microsoft Excel

Computers are like air conditioners, they stop working properly if you open Windows.

  Man is still the most extraordinary computer of all. (John F. Kennedy)

  Keyboard Shortcuts

Typing Hands
Windows
Word
PowerPoint
Excel
Outlook
Internet Explorer
InPage Pro
CorelDraw

  Main Website

Home
Salient Features
Available Courses
Certified Students
Talented Students
Unfinished Students
Download Books
Our English Books
Our Urdu Books
Free Bonus Tips
Typing Hands
Microsoft Windows
Microsoft Word
Microsoft PowerPoint
Microsoft Excel
Microsoft Outlook
Internet Explorer
Urdu InPage
CorelDraw

 

Keyboard Shortcuts for Microsoft Excel

Speed up your outputs by using these shortcuts.
Practice is the key to success. Good Luck!

HOTKEY

DESCRIPTION

BASIC INFORMATION

Default sheets (per file):

3

Total Rows per sheet:

65,536

Total Columns per sheet:

256

Total Cells per sheet:

167,77,216

FUNCTION

FORMULA

Total Profit/loss Percent

=B63*B64/100 (actual amount*profit/100)

Total Amount (Profit)

=B56*B57/100+B56 (actual amount*profit/100 + actual amount)

Total Amount (Loss)

=D22*D23/100-D22 (actual amount*profit/100 - actual amount)

Percentage (Result)

=M7/750*100  (obtained Marks/Total Marks*100)

Square Root

=SQRT(B75) (find square root of a given number)

Average

=AVERAGE(D76:D83) (find average of a given range)

Maximum Amount

=MAX(D90:D97(find maximum number in given range)

Minimum Amount

=MIN(F90:F97) (find minimum number in a given range)

Count the Entries

=COUNT(D104:D115) (counts the entries in given range)

Count if greater than 5000

=COUNTIF(B1:B31,">5000") (5000 is supposed amount)

Count if smaller than 5000

=COUNTIF(B1:B31,"<5000") (5000 is supposed amount)

Sum if greater than 5000

=SUMIF(B1:B31,">5000") (5000 is supposed amount)

Sum if smaller than 5000

=SUMIF(B1:B31,"<5000") (5000 is supposed amount)

Count years from Today

=DATEDIF(D175,NOW(),"y") (counts given date in years)

Count months from Today

=DATEDIF(D176,NOW(),"m") (counts given date in months)

Count days from Today

=DATEDIF(D177,NOW(),"d") (counts given date in days)

Choose Weekday

=TEXT(WEEKDAY(J182), "dddd")

Convert

=CONVERT(D19,"in","cm") (ft-m, lbm-kg, l-gal, C-F)

Large (First)

=LARGE(D203:D214,1(find 1st highest number )

Large (Second)

=LARGE(D203:D214,2) (find 2nd highest number )

Large (Third)

=LARGE(D203:D214,3) (find 3rd highest number )

Small (First)

=SMALL(D203:D214,1) (find 1st smallest number)

Small (Second)

=SMALL(D203:D214,2) (find 2nd smallest number)

Small (Third)

=SMALL(D203:D214,3) (find 3rd smallest number)

Insert Current Date

=TODAY() (Keyboard Shortcut Ctrl + ; semicolon)

Insert Current Time

Ctrl + : (Keyboard Shortcut)

Insert Currency Symbol

Ctrl + Shift + $ (apply on an amount, already in a cell)

Change Date Format

Ctrl + Shift + # (change date format, already in a cell)

Insert AutoSum Function

Alt + = (Keyboard Shortcut)

Show Formulas (Toggle)

Ctrl + ~ (show all formulas except results)

Move to Start /End of sheet

Ctrl + Home  /  Ctrl + End (Keyboard Shortcut)

Move to next/previous sheet

Ctrl + Page Up  / Ctrl + Page Down (Keyboard Shortcut)

Open the Format Cells dialog

Ctrl + 1 (Keyboard Shortcut)

Edit a cell's contents

F2 (Keyboard Shortcut)

Select a block/table of data

Ctrl + Shift + * (Keyboard Shortcut)

Note: Red entries are supposed cells

Compiled & Tested by: Muhammad Ajmal Beig Naz
Principal, Pentium Graphics Center & Training Institute

For more keyboard shortcuts and Tips, buy our book TIPS & TRICKS

IP Address Lookup
Country flag, you are browsing from

World Wide Consortium
How to... Computer Articles
Free Web Tools All-in-One
Free Unlimited File Hosting
Windows Live Beta
Windows Live Safety Center

 

 

To view in full screen Press F11
To bookmark page Press Ctrl+D
Free computer tips here
Online Office Tips & Tricks
XP Tweaking Guide

IBM introduces its first Personal Computer, IBM 5250 on August 12, 1981.

 

Worldwide Web (WWW) was introduced by Tim Burner Lee on August 6, 1991

 

Fact: 90% of world computers run Microsoft Windows as their operating system.

 

  Computer Jokes 

An Intel PC has four protection modes: Abort, Retry, Fail and Reboot.

Old software engineers never die, they just logout.

more computer jokes

  Letters of Alphabet 

Rotokos (Cambodia) - 74
Sindhi (Pakistan) - 52
Urdu (Pakistan) - 37
Persion (Iran) - 32
Greek (Greece) - 24
English (Global) - 26
Latin - 23

  Interesting Facts 

40% of school students are unable to read English

60% of college students are unable to understand English

70% of university students are unable to speak English

85% of working professionals are unable to give proper presentation

90% of applicants are unable to write CVs and give interview

(Mouse over picture)

Some thrilling information
about Love. Click Here

 

   
 

Home ] Salient Features ] Available Courses ] Certified Students ] Talented Students ] Unfinished Students ] Download Books ] Our English Books ] Our Urdu Books ] Free Bonus Tips ] Typing Hands ] Microsoft Windows ] Microsoft Word ] Microsoft PowerPoint ] [ Microsoft Excel ] Microsoft Outlook ] Internet Explorer ] Urdu InPage ] CorelDraw ]

Website designed and developed by Pentium Graphics Center & Training Institute
Copyright 2003-2014 by Muhammad Ajmal Beig Naz (ajmalbeig) All rights reserved

Website on air since: Tuesday, March 11, 2003 (
sub-web since: Tuesday, August 20, 2008)