Official Letters & Study Templates – Business Emails, Bank Letters, Essays & Applications

  ⌨️ COMPLETE EXCEL SHORTCUT KEYS GUIDE 📁 BASIC WORKBOOK SHORTCUTS 1. File Operations: excel Ctrl + N = New Workbook Ctrl + O = Open Workbook Ctrl + S = Save Workbook F12 = Save As Ctrl + P = Print Ctrl + F4 = Close Workbook Alt + F4 = Exit Excel 2. Navigation: excel Ctrl + Home = Go to Cell A1 Ctrl + End = Go to Last Used Cell Page Down = Move Down One Screen Page Up = Move Up One Screen Alt + Page Down = Move Right One Screen Alt + Page Up = Move Left One Screen 📝 EDITING SHORTCUTS 3. Basic Editing: excel Ctrl + C = Copy Ctrl + X = Cut Ctrl + V = Paste Ctrl + Z = Undo Ctrl + Y = Redo Delete = Clear Contents Ctrl + F = Find Ctrl + H = Replace 4. Advanced Editing: excel Ctrl + D = Fill Down Ctrl + R = Fill Right Ctrl + Enter = Fill Selected Cells with Same Data Alt + Enter = Start New Line in Same Cell F2 = Edit Active Cell Ctrl + ; = Insert Current Date Ctrl + Shift + ; = Insert Current Time 📊 FORMATTING SHORTCUTS 5. Text Formatting: excel Ctrl + B = Bold Ctrl + I = Italic Ctrl...

  📊 BASIC FORMULAS SUM Formula excel =SUM(A1:A10) Use:  Adds numbers in range Example:  Total sales, salary calculation AVERAGE Formula excel =AVERAGE(B2:B20) Use:  Calculates average Example:  Average performance, monthly expenses COUNT Formula excel =COUNT(A1:A10) Use:  Counts numeric cells Example:  Employee count, project count COUNTA Formula excel =COUNTA(A1:A10) Use:  Counts non-empty cells Example:  Attendance tracking, data entries MAX Formula excel =MAX(C2:C100) Use:  Finds highest value Example:  Highest sales, maximum salary MIN Formula excel =MIN(C2:C100) Use:  Finds lowest value Example:  Lowest performance, minimum score 🔍 LOOKUP FORMULAS VLOOKUP Formula excel =VLOOKUP(A2,DataRange,2,FALSE) Use:  Vertical data search Example:  Employee records, price lists HLOOKUP Formula excel =HLOOKUP("Salary",A1:Z2,2,FALSE) Use:  Horizontal data search Example:  Comparison tables, header-based search...