Advanced Excel Formulas List PDF Free Download Top 50 Advanced Excel Formulas List No. Formula Purpose/Description 1 SUM() Adds numbers 2 SUMIF() Sums numbers based on one condition 3 SUMIFS() Sums numbers based on several criteria 4 AVERAGE() Calculates average 5 AVERAGEIF() Average based on one condition 6 AVERAGEIFS() Average based on multiple conditions 7 COUNT() Counts numeric cells 8 COUNTA() Counts non-empty cells 9 COUNTIF() Counts based on one condition 10 COUNTIFS() Counting based on multiple conditions 11 MAX() Returns the largest value 12 MIN() Returns the smallest value 13 IF() Logical condition (True / False) 14 IFERROR() Replaces errors with a custom value 15 IFS() Multiple conditions in one formula 16 VLOOKUP() Lookup value vertically from table 17 HLOOKUP() Lookup value horizontally from table 18 XLOOKUP() Advanced and improved version of VLOOKUP 19 INDEX() Returns the value from a specific row & column 20 MATCH() Returns the position of a value
📘 MS Word Full Course (Hindi + Step-by-Step Practical ) 📂 Course Structure (12 Modules) 🟩 Module 1: Introduction to MS Word MS Word क्या है? Word Interface (Tabs, Ribbon, Status Bar, etc.) File New, Open, Save, Save As, Close Shortcut Keys (Ctrl + N, Ctrl + S, etc.) 🖼 Practical: Word Interface Screenshot --- 🟩 Module 2: Basic Text Formatting Font Style, Size, Color, Bold, Italic, Underline Alignment (Left, Center, Right, Justify) Bullets, Numbering, Line Spacing 🖼 Practical: Text Formatting Example Screenshot --- 🟩 Module 3: Page Setup & Layout Margins, Page Size, Orientation Header & Footer, Page Number Page Border, Shading, Columns 🖼 Practical: Page Layout Example --- 🟩 Module 4: Tables in Word Table Insert करना Rows & Columns Add/Delete Merge/Split, Border Formatting 🖼 Practical: Table Example --- 🟩 Module 5: Insert Tab Pictures, Shapes, SmartArt Text Box, WordArt Hyperlink, Symbols, Header/Footer 🖼 Practical: Insert Menu Examples --- 🟩 Module 6: Style...