Excel Formulas and Shortcut Keys PDF – 2023

Microsoft Excel! It’s a powerful spreadsheet application developed by Microsoft that is widely used for various tasks involving data organization, analysis, and visualization. Excel formulas and shortcut keys which make it easy to use. Let’s talk about commonly used Excel formulas and shortcut keys.

excel formulas pdf

Here are some key features and concepts related to Microsoft Excel:

Excel Shortcut PDF Download

  1. Workbook: An Excel file is called a workbook, and it can contain multiple worksheets.
  2. Worksheet: A worksheet is a single sheet within a workbook. Each sheet is divided into rows and columns, creating cells where data can be entered.
  3. Cells, Rows, and Columns: Cells are the individual boxes where you can input data. Cells are organized into rows (horizontally) and columns (vertically).
  4. Formulas: Excel allows you to perform calculations using formulas. Formulas begin with an equal sign (=) and can include mathematical operations, functions, and references to other cells.
  5. Functions: Excel provides a wide range of built-in functions for various calculations. Functions like SUM, AVERAGE, COUNT, IF, VLOOKUP, and many others are commonly used to manipulate and analyze data.
  6. Charts and Graphs: Excel enables you to create various types of charts and graphs to visually represent your data. These visualizations can make it easier to understand trends and patterns.
  7. Formatting: You can format cells, rows, and columns to change their appearances, such as font style, size, colour, and cell borders.
  8. Data Sorting and Filtering: Excel allows you to sort data in ascending or descending order based on specific columns. You can also apply filters to show or hide specific data based on certain criteria.
  9. Data Validation: You can set rules to validate data entry, ensuring that only specific types of data are entered into a cell.
  10. PivotTables: PivotTables are powerful tools for summarizing and analyzing large datasets. They allow you to rearrange and summarize data to quickly gain insights.
  11. Conditional Formatting: This feature allows you to format cells based on specific conditions. For example, you can highlight cells that meet certain criteria with a particular colour.
  12. Macros: Excel supports the creation of macros using Visual Basic for Applications (VBA). Macros automate repetitive tasks by recording a series of steps and then playing them back.
  13. Collaboration: Excel offers collaboration features like track changes, comments, and sharing options that enable multiple users to work on the same workbook simultaneously.

Excel Shortcut Keys

Commonly used shortcut keys ->

Excel Shortcut PDF Download

Shortcut NameShortcut Key(s)
Cut SelectionCtrl + X
Copy SelectionCtrl + C
Paste SelectionCtrl + V
UndoCtrl + Z
RedoCtrl + Y or Ctrl + Shift + Z
SaveCtrl + S
BoldCtrl + B
ItalicCtrl + I
UnderlineCtrl + U
Select AllCtrl + A
FindCtrl + F
ReplaceCtrl + H
Insert RowCtrl + Shift + + (Plus Key)
Delete RowCtrl + – (Minus Key)
Insert ColumnCtrl + Space, then Ctrl + + (Plus Key)
Delete ColumnCtrl + – (Minus Key)
Fill DownCtrl + D
Fill RightCtrl + R
AutoSumAlt + =
Format CellsCtrl + 1
Hide RowCtrl + 9
Hide ColumnCtrl + 0
Open Formula BarCtrl + ` (Backtick)
Go to Beginning of SheetCtrl + Home
Go to End of SheetCtrl + End
Freeze PanesAlt, W, F
Save AsF12

Some advanced shortcut keys ->

Excel Shortcut PDF Download

Shortcut NameShortcut Key(s)
Open WorkbookCtrl + O
Close WorkbookCtrl + W
New WorkbookCtrl + N
PrintCtrl + P
Cut FormatCtrl + Shift + X
Copy FormatCtrl + Shift + C
Paste FormatCtrl + Shift + V
Repeat Last ActionF4
Go to Next SheetCtrl + Page Down
Go to Previous SheetCtrl + Page Up
Toggle Formula ViewCtrl + ` (Backtick)
Apply Number FormatCtrl + Shift + 1
Apply Currency FormatCtrl + Shift + 4
Apply Percentage FormatCtrl + Shift + 5
Apply Date FormatCtrl + Shift + 3
Insert FunctionShift + F3
Toggle AutocompleteCtrl + E or Ctrl + Space
Move to Next CellEnter or Tab
Move to Previous CellShift + Tab
Delete Cell ContentsDelete
AutoFit Column WidthDouble-click Column Border
AutoFit Row HeightDouble-click Row Border
Group SelectionCtrl + Shift + (
Ungroup SelectionCtrl + Shift + )
Create ChartF11
Apply BorderCtrl + Shift + 7
Increase Font SizeCtrl + Shift + > or Ctrl + ]
Decrease Font SizeCtrl + Shift + < or Ctrl + [
Toggle FilterCtrl + Shift + L
Insert CommentShift + F2
Insert Current DateCtrl + ; (Semicolon)
Insert Current TimeCtrl + Shift + ; (Semicolon)
Navigate RibbonCtrl + F6 or Ctrl + Tab

Excel Formulas

FormulaDescriptionExample Usage
SUMAdds up a range of numbers=SUM(A1:A5)
AVERAGECalculates the average of a range of numbers=AVERAGE(B1:B10)
COUNTCounts the number of cells with values=COUNT(C1:C20)
MINReturns the smallest value in a range=MIN(D1:D15)
MAXReturns the largest value in a range=MAX(E1:E12)
IFReturns one value if a condition is true, another if false=IF(F1>50, “Pass”, “Fail”)
CONCATENATECombines multiple text strings into one=CONCATENATE(“Hello”, ” “, “World”)
VLOOKUPSearches for a value in a range and returns a related value from another range=VLOOKUP(G1, A1:B10, 2, FALSE)
HLOOKUPSimilar to VLOOKUP, but searches in rows=HLOOKUP(G1, A1:D5, 3, FALSE)
INDEXReturns a value from a specific cell in a range based on row and column numbers=INDEX(A1:E10, 3, 2)
MATCHSearches for a value in a range and returns its relative position=MATCH(G1, A1:A20, 0)
COUNTIFCounts the number of cells that meet a specific condition=COUNTIF(B1:B20, “>50”)
SUMIFAdds up values in a range based on a specific condition=SUMIF(C1:C10, “Apples”, D1:D10)
AVERAGEIFCalculates the average of values that meet a specific condition=AVERAGEIF(E1:E15, “High”, F1:F15)
ROUNDRounds a number to a specified number of digits=ROUND(3.14159, 2)
ROUNDUPRounds a number up to a specified number of digits=ROUNDUP(5.6789, 2)
ROUNDDOWNRounds a number down to a specified number of digits=ROUNDDOWN(8.54321, 2)
LENReturns the number of characters in a text string=LEN(“Hello, World!”)
LEFTReturns a specified number of characters from the beginning of a text string=LEFT(“Excel”, 3)
RIGHTReturns a specified number of characters from the end of a text string=RIGHT(“Functions”, 4)
MIDReturns a specified number of characters from the middle of a text string=MID(“OpenAI”, 2, 3)

For a comprehensive list of Excel formulas and functions, you can explore Excel’s official documentation or online resources like Microsoft’s Excel support pages.

.

.

Do You Know: What is Glycemic Index (GI)?

Leave a Comment