[go: up one dir, main page]
Scribd
Upload
109 views2 pages

Excel OnePage CheatSheet

This document is an Excel one-page cheat sheet that lists various formulas and their purposes, such as SUM, AVERAGE, and VLOOKUP. It also includes useful shortcuts for efficient navigation and data manipulation within Excel. The cheat sheet serves as a quick reference for users to enhance their productivity while using Excel.

Uploaded by

Atif Trags
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
109 views2 pages

Excel OnePage CheatSheet

This document is an Excel one-page cheat sheet that lists various formulas and their purposes, such as SUM, AVERAGE, and VLOOKUP. It also includes useful shortcuts for efficient navigation and data manipulation within Excel. The cheat sheet serves as a quick reference for users to enhance their productivity while using Excel.

Uploaded by

Atif Trags
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

■ Excel One-Page Cheat Sheet

Formula Purpose

=SUM(A1:A10) Adds numbers

=AVERAGE(A1:A10) Mean value

=MIN(A1:A10) / MAX(A1:A10) Smallest / Largest

=ROUND(A1,2) Round 2 decimals

=IF(A1>100,"Pass","Fail") Condition check

=AND(A1>10,B1<20) Both conditions true

=OR(A1="Yes",B1="Yes") Either condition true

=IFERROR(A1/B1,0) Avoid errors

=VLOOKUP(101,A2:D20,3,FALSE) Vertical lookup

=HLOOKUP(50,A1:Z3,2,FALSE) Horizontal lookup

=INDEX(A2:C10,5,2) Value at row/col

=MATCH(500,A1:A20,0) Position of value

=XLOOKUP(101,A:A,B:B) Modern lookup

=LEN(A1) Character count

=TRIM(A1) Remove spaces

=PROPER(A1) Capitalize words

=UPPER(A1) / LOWER(A1) Change case

=CONCAT(A1," ",B1) Join text

=LEFT(A1,5) First 5 chars

=RIGHT(A1,3) Last 3 chars

=MID(A1,3,4) Middle chars

=SEARCH("apple",A1) Find position

=TODAY() Current date

=NOW() Date & time

=DAY(A1) / MONTH(A1) / YEAR(A1) Extract date parts

=DATEDIF(A1,B1,"d") Days between dates

=EDATE(A1,3) Add 3 months


=EOMONTH(A1,0) End of month

=PMT(rate,nper,pv) Loan payment

=FV(rate,nper,pmt) Future value

■ Excel Shortcuts
• Ctrl + Shift + L → Toggle Filters
• Ctrl + T → Convert to Table
• Ctrl + Arrow Keys → Jump to edge
• Alt + = → Auto SUM
• Ctrl + ; → Insert date
• Ctrl + Shift + : → Insert time
• Ctrl + Z / Ctrl + Y → Undo / Redo
• Ctrl + C / Ctrl + V → Copy / Paste
• F2 → Edit cell

You might also like