PC Tips By Ritesh

learn computer

MUST USE EXCEL SHORTCUTS

Ritesh Garg

October 9, 2024

MS Excel

MUST USE EXCEL SHORTCUTS Apply borders to cells Ctrl +shift +& Cmd+Shift +& Auto sum selected cells Alt + =…
MS WORD IMPORTANT SHORTCUTS

Ritesh Garg

October 8, 2024

MS Word

MS WORD IMPORTANT SHORTCUTS Ctrl + A Select all Ctrl+Left Bracket[= decrease font size by 1 point Ctrl +B Bold…
DAILY USE EXCEL SHORTCUT KEYS

Ritesh Garg

October 5, 2024

Blog

DAILY USE EXCEL SHORTCUT KEYS Shortcut Action Menu equivalent Excel Version CTRL +S SAVE FILE+ SAVE ALL CTRL + T…
MICROSOFT EXCEL FORMULA

Ritesh Garg

October 4, 2024

MS Excel

MICROSOFT EXCEL FORMULA Basic Maths Functions Function Formula Example To add up the total =SUM(cell range ) =SUM(B2:B9) To add…
BASIC EXCEL FORMULAS

Ritesh Garg

October 3, 2024

MS Excel

BASIC EXCEL FORMULAS 1 SUM =SUM(A1:A5) 2 SUM =(A1+A2+A3+A4+A5) 3 SUM =(45+2+43+48) 4 PRODUCT =PRODUCT(F1:F2) 5 PRODUCT =(34*65) 6 SUBTRACT…
BASIC EXCEL FORMULA

Ritesh Garg

October 1, 2024

MS Excel

BASIC EXCEL FORMULA FORMULA NAME FORMULA PATTERN SUM =SUM (A1:A5) SUM =(A1+A2+A3+A4+A5) SUM =(45+2+43+48) PRODUCT =PRODUCT(F1:F2) PRODUCT =(B3*B4*85 PRODUCT =(34*65)…