CREATIVE EDUCATION & TRAINING

Microsoft Word shortcut keys

Basic Shortcuts
Action Shortcut Key
New document Ctrl + N
Open document Ctrl + O
Save document Ctrl + S
Save As F12
Print Ctrl + P
Close document Ctrl + W
Exit Word Alt + F4
Editing Shortcuts
Action Shortcut Key
Cut Ctrl + X
Copy Ctrl + C
Paste Ctrl + V
Undo Ctrl + Z
Redo Ctrl + Y
Select all Ctrl + A
Find Ctrl + F
Replace Ctrl + H
Text Formatting
Action Shortcut Key
Bold Ctrl + B
Italic Ctrl + I
Underline Ctrl + U
Increase font size Ctrl + Shift + >
Decrease font size Ctrl + Shift + <
Align left Ctrl + L
Center text Ctrl + E
Align right Ctrl + R
Justify text Ctrl + J
Change case Shift + F3
Navigation Shortcuts
Action Shortcut Key
Move to beginning of line Home
Move to end of line End
Move one word left Ctrl + ←
Move one word right Ctrl + →
Go to beginning of doc Ctrl + Home

[Link] | SHARAN JANGINAMATH – 8861 543 666

 CREATIVE EDUCATION & TRAINING

Go to end of doc Ctrl + End

Go to specific page Ctrl + G or F5
Other Useful Shortcuts
Action Shortcut Key
Insert hyperlink Ctrl + K
Insert page break Ctrl + Enter
Spell check F7
Word count Ctrl + Shift + G
Help F1
Microsoft Excel shortcut keys
Basic Excel Shortcuts
Action Shortcut Key
New workbook Ctrl + N
Open workbook Ctrl + O
Save Ctrl + S
Save As F12
Print Ctrl + P
Close workbook Ctrl + W
Exit Excel Alt + F4
Navigation
Action Shortcut Key
Move right Tab
Move left Shift + Tab
Move to beginning of row Home
Move to beginning of sheet Ctrl + Home
Move to end of sheet Ctrl + End
Move down Enter
Move up Shift + Enter
Move to next sheet Ctrl + Page Down
Move to previous sheet Ctrl + Page Up
Editing Cells
Action Shortcut Key
Edit selected cell F2
Copy Ctrl + C
Cut Ctrl + X
Paste Ctrl + V
Undo Ctrl + Z
Redo Ctrl + Y
Delete cell content Delete

[Link] | SHARAN JANGINAMATH – 8861 543 666

 CREATIVE EDUCATION & TRAINING

Insert current date Ctrl + ;

Insert current time Ctrl + Shift + ;
Formatting
Action Shortcut Key
Bold Ctrl + B
Italic Ctrl + I
Underline Ctrl + U
Format cells Ctrl + 1
Center align Alt + H + A + C
Left align Alt + H + A + L
Right align Alt + H + A + R
Add border Ctrl + Shift + &
Remove border Ctrl + Shift + _
AutoFit column width Alt + H + O + I
Formulas and Functions
Action Shortcut Key
Start a formula =
Insert function Shift + F3
Toggle absolute reference F4
Calculate active worksheet F9
AutoSum Alt + =
Data & Cell Selection
Action Shortcut Key
Select entire row Shift + Space
Select entire column Ctrl + Space
Select all Ctrl + A
Find Ctrl + F
Replace Ctrl + H
Go to Ctrl + G or F5
Hide selected rows Ctrl + 9
Hide selected columns Ctrl + 0

Microsoft PowerPoint shortcut keys

General Shortcuts
Shortcut Action
Ctrl + N New presentation
Ctrl + O Open a presentation
Ctrl + S Save a presentation
Ctrl + P Print

[Link] | SHARAN JANGINAMATH – 8861 543 666

 CREATIVE EDUCATION & TRAINING

Ctrl + Z Undo
Ctrl + Y Redo
Ctrl + C Copy
Ctrl + X Cut
Ctrl + V Paste
Ctrl + A Select all
Ctrl + F Find
Ctrl + H Replace
Ctrl + W / Ctrl + Q Close presentation
Slide Show Shortcuts
Shortcut Action
F5 Start slideshow from beginning
Shift + F5 Start slideshow from current slide
Esc End slideshow
B or . Black screen
W or , White screen
N / Right Arrow / Down Arrow / Enter /
Next slide
Page Down
P / Left Arrow / Up Arrow / Backspace /
Previous slide
Page Up
Number + Enter Go to slide number
Ctrl + P Pen tool during slideshow
E Erase pen drawings
Slide Editing & Navigation
Shortcut Action
Ctrl + M New slide
Ctrl + D Duplicate selected slide or object
Ctrl + Up/Down Move slide up/down in slide sorter
Ctrl + Shift + Up/Down Move slide to beginning/end
Delete Delete selected slide/object
Tab / Shift + Tab Select next/previous object
Text Formatting
Shortcut Action
Ctrl + B Bold
Ctrl + I Italic
Ctrl + U Underline
Ctrl + E Center align
Ctrl + L Left align
Ctrl + R Right align
Ctrl + T Open Font dialog box
View & Zoom
[Link] | SHARAN JANGINAMATH – 8861 543 666
 CREATIVE EDUCATION & TRAINING

Shortcut Action
Alt + F5 Presenter View
Ctrl + Wheel Mouse Zoom in/out
Alt + Shift + 1 Collapse all in outline view
Alt + Shift + 9 Expand all in outline view
Important Microsoft Excel functions
Basic Excel Functions
Function Description Example
SUM() Adds values =SUM(A1:A5)
AVERAGE() Calculates average =AVERAGE(B1:B10)
MAX() Returns maximum value =MAX(C1:C10)
MIN() Returns minimum value =MIN(C1:C10)
COUNT() Counts numeric values =COUNT(D1:D10)
COUNTA() Counts non-empty cells =COUNTA(A1:A10)
ROUND() Rounds a number =ROUND(A1, 2)
Logical Functions
Function Description Example
IF() Conditional logic =IF(A1>10, "Yes", "No")
AND() Checks if all conditions are =AND(A1>0, B1<100)
TRUE
OR() Checks if any condition is =OR(A1>100, B1=50)
TRUE
NOT() Reverses the logic =NOT(A1>10)
Text Functions
Function Description Example
CONCAT() / =CONCAT(A1, B1)
Joins text strings
TEXTJOIN()
LEFT() Extracts characters from the left =LEFT(A1, 3)
RIGHT() Extracts characters from the right =RIGHT(B1, 4)
Extracts characters from the
MID() =MID(C1, 2, 3)
middle
LEN() Counts number of characters =LEN(A1)
TRIM() Removes extra spaces =TRIM(A1)
UPPER() Converts to uppercase =UPPER(A1)
LOWER() Converts to lowercase =LOWER(A1)
Lookup & Reference Functions
Function Description Example
=VLOOKUP(101, A2:D10, 2,
VLOOKUP() Vertical lookup (older) FALSE)
=HLOOKUP("Name", A1:D5, 2,
HLOOKUP() Horizontal lookup FALSE)
XLOOKUP() Advanced lookup (newer Excel) =XLOOKUP(101, A2:A10, B2:B10)
INDEX() Returns value at a given position =INDEX(A1:C3, 2, 1)

[Link] | SHARAN JANGINAMATH – 8861 543 666

 CREATIVE EDUCATION & TRAINING

MATCH() Returns position of a value =MATCH(25, A1:A10, 0)

Date & Time Functions
Function Description Example
TODAY() Returns today’s date =TODAY()
NOW() Returns current date and time =NOW()
Calculates difference between
DATEDIF() =DATEDIF(A1, B1, "Y")
dates
YEAR() Extracts year =YEAR(A1)
MONTH() Extracts month =MONTH(A1)
DAY() Extracts day =DAY(A1)
TEXT() Converts date/time to text =TEXT(A1, "dd-mmm-yyyy")
Financial Functions
Function Description Example
PMT() Loan payment calculation =PMT(0.08/12, 60, -10000)
FV() Future value =FV(0.05, 10, -2000)
NPV() Net present value =NPV(0.1, B2:B6)

Creative Education and Training

It is my pleasure to welcome you all to Creative Education & Training (ISO 9001:2015 certified
institute). Computer education has become an integral part of the twenty first century. Computers have
occupied a very important place in our lives. We cannot imagine our life without computers. They are
being used in each & every field to make work easier.

The elderly people are also trying to learn how to use a computer. As the time is passing, technology is
increasing, so far our own convenience it has become important for all of us to gain computer
education.

With Best wishes

Sharanbasav Janginamath

Why Creative Education & Training?

 15+ YEARS EXPERIENCE TRAINERS
 PRACTICAL BASED TRAINING
 AFFORDABLE FEES STRUCTURE
 SYLLABUS UPTO DATE
 COMPLETE COURSE ONLINE ACCESS
 ONLINE EXAM
 QR CODE CERTIFICATE VERIFICATION

[Link] | SHARAN JANGINAMATH – 8861 543 666