shortcut excel keys and excel formulas.pdf

Introduction:
Working with Excel can sometimes feel overwhelming, especially when you have large amounts of data. But did you know there are shortcuts and formulas that can make your work much easier? In this guide, I’ll take you through some of the most useful Excel shortcut keys and explain how common formulas can save you time and effort. Whether you’re a student, professional, or just someone who uses Excel occasionally, this guide will help you work smarter, not harder.

1. Excel Shortcut Keys
Using shortcuts is a great way to speed up your work in Excel. Below are some of the most commonly used shortcut keys for different tasks:

Basic Shortcut Keys
These are the basic shortcuts you will use every day. Even if you’re just starting with Excel, these keys are easy to memorize and will save you a lot of time.

Ctrl + C: Copy
Ctrl + V: Paste
Ctrl + X: Cut
Ctrl + Z: Undo
Ctrl + S: Save
These shortcuts are helpful for quickly editing and managing your worksheets. Instead of using the mouse, you can use your keyboard to perform these actions in seconds.

Navigation Shortcuts
Navigating a large Excel sheet can be tiring if you rely only on the scroll bar. With these shortcuts, you can jump to different sections of your sheet instantly.

Ctrl + Arrow keys: Jump to the end of the data in the direction of the arrow.
Ctrl + Home: Go to the beginning of the sheet.
Ctrl + End: Jump to the last cell used in the worksheet.
These shortcuts make it easier to navigate through large data sets, especially when dealing with thousands of rows and columns.

Formatting Shortcuts
Formatting your Excel sheets to make them visually appealing or organized is crucial. Below are some shortcuts to help you quickly format your data.

Ctrl + B: Bold the selected text or cell.
Ctrl + I: Italicize the selected text or cell.
Ctrl + U: Underline the selected text or cell.
Alt + H, H: Open the fill color menu to change cell background color.
Ctrl + Shift + $: Apply currency format to selected cells.
Properly formatted Excel sheets not only look more professional but also make it easier to understand your data at a glance.

Formula Shortcuts
Formulas are what make Excel so powerful. You don’t have to manually calculate everything—just use these shortcuts to quickly apply formulas.

Alt + =: AutoSum selected cells.
Ctrl + Shift + Enter: Create an array formula.
Ctrl + `: Toggle between displaying cell values and formulas.
Using these shortcuts will make entering and editing formulas much faster, which is crucial when working with complex calculations.

Selection and Editing Shortcuts
Selecting and editing data quickly in Excel is vital, especially when working with large datasets.

Ctrl + Shift + Arrow keys: Select a range of cells in the direction of the arrow.
Shift + Space: Select the entire row.
Ctrl + Space: Select the entire column.
Ctrl + Shift + L: Apply or remove

1. ExcelShortcuts
1.Ctrl+C:Copy
2.Ctrl+V:Paste
3.Ctrl+X:Cut
4.Ctrl+Z:Undo
5.Ctrl+Y:Redo
6.Ctrl+S:Save
7.Ctrl+P:Print
8.Ctrl+F:Find
9.Ctrl+H:Replace
10.Ctrl+A:SelectAll
11.Ctrl+B:Bold
12.Ctrl+I:Italic
13.Ctrl+U:Underline
14.Ctrl+N:NewWorkbook
15.Ctrl+O:OpenWorkbook
16.Ctrl+W:CloseWorkbook
17.Ctrl+PageUp:SwitchtothePreviousWorksheet
18.Ctrl+PageDown:SwitchtotheNextWorksheet
19.Ctrl+ArrowKey:MovetotheEdgeofData
20.Ctrl+Shift+ArrowKey:SelectDatatotheEdge
21.Alt+Enter:InsertaLineBreakinaCell
22.F2:EditActiveCell
23.F4:RepeatLastAction
24.F12:SaveAs
Here'sthelistofExcelformulasarrangedinto3columns:Function,
Formula,andDescription.
Function Formula Description
SUM =SUM(A1:A10) AddsupallvaluesintherangeA1to
A10.
AVERAGE =AVERAGE(A1:A10)Calculatestheaverageofthevalues
intherangeA1toA10.
IF =IF(A1>10,'Yes',
'No')
Returns"Yes"ifthevalueinA1is
greaterthan10,otherwise"No."

2. COUNT =COUNT(A1:A10)Countsthenumberofnumeric
valuesintherangeA1toA10.
COUNTA =COUNTA(A1:A10)Countsthenumberofnon-empty
cellsintherangeA1toA10.
VLOOKUP =VLOOKUP(A1,B1:D10,
2,FALSE)
LooksforavalueinA1inthefirst
columnoftherangeB1
andreturnsthevalueinthesecond
column.
HLOOKUP =HLOOKUP(A1,B1:D10,
2,FALSE)
SearchesforthevalueinA1inthe
toprowoftherangeB1
andreturnsthevalueinthesecond
row.
INDEX =INDEX(A1:B10,2,2)Returnsthevaluefromthesecond
rowandsecondcolumnoftherange
A1
.
MATCH =MATCH(A1,A2:A10,
0)
Returnstherelativepositionofthe
valueinA1withintherangeA2
.
CONCATENATE=CONCATENATE(A1,B1)CombinesthetextfromA1andB1
intoonecell.
LEFT =LEFT(A1,3) Returnsthefirst3charactersfrom
thetextinA1.
RIGHT =RIGHT(A1,3) Returnsthelast3charactersfrom
thetextinA1.
MID =MID(A1,2,4)Returns4charactersstartingfrom
thesecondcharacterinA1.
LEN =LEN(A1) Returnsthenumberofcharactersin
A1.

3. TRIM =TRIM(A1) Removesextraspacesfromthetext
inA1.
UPPER =UPPER(A1) ConvertsalltextinA1touppercase.
LOWER =LOWER(A1) ConvertsalltextinA1tolowercase.
AND =AND(A1>5,B1<10)ReturnsTRUEifbothconditions
(A1>5andB1<10)aremet.
OR =OR(A1>5,B1<10)ReturnsTRUEifeithercondition
(A1>5orB1<10)ismet.
NOW =NOW() Returnsthecurrentdateandtime.
TODAY =TODAY() Returnsthecurrentdate.
Thisformatgivesyouanoverviewofeachformula,structure,andpurpose.
FormoreinfoVisit=www.Teckblog.com