Microsoft Excel for Fresher | Basic MS Excel Tutorial | MS Excel First Class - 01
How to Create New Workbook in Excel | How To Make File in Excel | How To Save File in Excel - 2
Cut, Copy, Paste in Excel | How to Select Text, Row & Column in MS Excel|Microsoft Excel- Home Tab-3
Microsoft Excel Find and Replace | Home Tab in Excel | How to Find and Replace - 4
Font in Excel | Change Font Size & Color in MS Excel| How to Bold, Italic, Underline Text in Excel-5
Undo and Redo in Excel |How to use Undo and Redo options in MS Excel| Excel Quick Access Tool Bar-6
Add Border in Excel | Change Border & Border Color in MS Excel | Excel Home Tab:Fill Color in Cell-7
Text Alignment in Excel | Align & Indent Text in MS Excel | Home Tab Alignment & Indent Options -08
Orientation in Excel | Change Direction of Text | Change Text Orientation |Rotate Text in MS Excel-9
Format Painter in Excel | Use of Format Painter in MS Excel | Excel : Home Tab Clip Board Block -10
Wrap Text in Excel | Merge & Center in MS Excel | Excel: Home Tab - Alignment Block - Wrap, Merge-11
Dates & Time in Excel | Format Numbers in MS Excel | Excel : Home Tab -Number Block-Dates & Time-12
Conditional Formatting in Excel | Highlight Cell in MS Excel | Home Tab : Conditional Formatting -13
Format Table & Cell Styles Option in Excel | Format as Table in MS Excel | Cell Style in Excel -14
Insert Column & Row in Excel | Delete Rows & Columns in MS Excel | Insert Cells & Sheets in Excel-15
Change Row Height and Column Width in Excel | MS Excel - Home Tab : Cells Block - Column & Row - 16
How to Hide & Unhide Row and Column in Excel | MS Excel me Row / Column ko Hide Unhide kaise kare-17
Rename, Move & Copy Worksheet in Excel | MS Excel Move / Copy / Rename Worksheet / Home Tab - 18
AutoFill Dates, Days and Months in Excel | MS Excel - AutoFill Number, Time, Dates Days & Months -19
Sort Numbers & Data Using Sort Filter Option in Excel | MS Excel : Home Tab: Sort & Filter Option-20
Mini Toolbar for Cut, Copy, Paste in Excel | Shortcut Menu for Font, Font Size, Color in MS Excel-21
Quick Access Toolbar in Excel | Customize Quick Access Toolbar in MS Excel |New, Open, Save, Redo-22
Status Bar in Excel| How to use Status Bar in Excel| View Page Layout Page Break Preview in Excel-23
Remove Formatting, Comments & Hyperlink using Clear Function in Excel | MS Excel Clear Formatting-24
Formula of Addition, Subtraction, Multiplication, Division, Average in Excel | MS Excel Formulas -25
Cut, Copy & Paste with the help of Clip Board in Excel | MS Excel - Home Tab: Clip Board -26
Paste Special in Excel | Paste Special kya hai | MS Excel -Copy Formula & Format by Paste Special-27
Conditional Format in Excel | Paste Special in MS Excel |Copy with Paste Special kya hai -28
Paste Special in Excel | Transpose Data in MS Excel | Add, Subtract, Multiply by Paste Special - 29
Data Validation in Excel | Data Validation for Whole Number & Error Alert in MS Excel - 30
Data Validation in Excel | Decimal Number | MS Excel :Data Validation-Between, Greater/Less Than-31
Create Drop Down List with Data Validation in MS Excel | Set Character Limit in Data Validation - 32
Set Date and Time Limit in Excel| Data Validation for Date and Time | Data Validation in MS Excel-33
Prevent Duplicate Entries in MS Excel| Allow only Text / only Number | Data Validation in Excel - 34
How to Consolidate Data in Excel | Consolidate Multiple Worksheets/Workbooks into one in MS Excel-35
Insert and Delete Image from Background in MS Excel| Insert Picture| Page Layout setting in Excel-36
How to Navigate Between Excel Sheets | Go To in Find in MS Excel | Microsoft Excel Tips & Tricks-37
Printing Page Setting, Margin in MS Excel| Print Data in one Page/Multiple Copy of Page in Excel-38
Print Title and Headings in all Excel Pages| Print Title/Heading on Every Page| Printing in Excel-39
MS Excel- Lookup Function| Lookup Formula in Excel| How to use Lookup Function in Microsoft Excel-40
Use VLOOKUP Formula in Microsoft Excel | MS Excel-Vlookup Formula | Use VLOOKUP Function -41
Check Column and Row Number of Cell in MS Excel| Check Cell Column Row Number by formula in Excel-42
How to use Columns and Rows Formula in Excel | Total Number of Columns, Rows in Table in Excel - 43
Use VLOOKUP Formula in Microsoft Excel | MS Excel - VLOOKUP in Excel | VLOOKUP Function -44
Use HLOOKUP Formula in Microsoft Excel | MS Excel - HLOOKUP in Excel | HLOOKUP Function -45
Freeze Multiple Rows and Columns in Excel| How to Freeze Panes in Excel| Excel Freeze Row Column- 46
Generate Random Numbers in MS Excel | Rand and Randbetween Formula Function in Microsoft Excel -47
How to Calculate EMI on Car Home Loan | Calculate Loan EMI in MS Excel | PMT Function in Excel- 48
What-if Analysis Goal Seek in MS Excel| Goal Seek Function | Know Estimated Down Payment- 49
Create and Customize Chart in Excel | Insert Pie, Bar, Column, Line Chart| Chart Setting in Excel-50
IPMT and PPMT Formula in Excel | Calculate Monthly Principal and Interest on Loan in MS Excel - 51
Excel Averageif Function| Excel Everageifs function| Averageif and Averageifs Formula in MS Excel-52
Create Your Own Excel Templates | How to Make Excel Template | Create Custom Template in MS Excel-53
Microsoft Excel: COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS Functions| COUNTIF & COUNTIFS in Excel- 54
Remove ### Error, #DIV/0! Error, #NAME? Error, #REF! Error, #VALUE! Errors, 0 Error in MS Excel- 55
Merge Cells Data Using Concatenate and & Functions in Excel| Combine First and Last Name in Excel-56
Change Case: Upper Case Lower Case Proper Case in MS Excel| Change Case with Concatenate in Excel-57
MS Excel: FV Function to Calculate Future Value| FV Formula: Calculate Future Value of Investment-58
Protect Excel Sheet with Password | Set a Password to an Excel File | How to Lock Cells in Excel -59
Clean Function in MS Excel| How to Remove Non-Printed characters in Excel| MS Excel Clean Formula-60
Calculate Running Totals in Excel| Cumulative Total in MS Excel| Running total using Sum Formula-61
Split full Name to First and Last Name in MS Excel | Separate First and Last Name in MS Excel- 62
Use Dsum in MS Excel to add numbers of particular column based on a condition| Excel DSUM Formula-63
How to use DGET formula in MS Excel | DGET Formula in Microsoft Excel| MS Excel : DGET Function - 64
Microsoft Excel: DAVERAGE Function| use DAVERAGE Formula in Excel| DAVERAGE Function in MS Excel- 65
How to Use SUMPRODUCT Function in Excel| Use SUMPRODUCT with Multiple Criteria| Excel SUMPRODUCT- 66
Microsoft Excel: CEILING and FLOOR functions| CEILING Formula in MS Excel| Floor Formula in Excel-67
Microsoft Excel: FORECAST Function| Use Forecast Formula in MS Excel| Forecast Function in Excel- 68
Find and Delete Duplicate Data in MS Excel| Microsoft Excel : Find and Remove Duplicate Entries - 69
Microsoft Excel: EDATE Function| Find Day of Any Past Future Date in Excel| Excel EDATE Formula - 70
How to Calculate LCM in MS Excel | How to Find LCM in Excel | Microsoft Excel : LCM formula - 71
Find Ratio in MS Execl| Find GCD or HCF in MS Excel| Calculate Ratio using GCD function in Excel- 72
Calculate Overtime in Excel| How to Calculate Employee Overtime in Excel| Excel Time Calculation-73
Microsoft Excel- Datedif Function| Datedif Function in MS Excel| Calculate Age from DOB in Excel- 74
Calculate Interest in MS Excel| Calculate Simple Interest in Excel| Monthly Interest Calculation- 75
How to Calculate Compound Interest in MS Excel| Compound Interest Calculation in Microsoft Excel-76
Microsoft Excel: Power Function| How to Calculate Power of Numbers in Excel| Excel Power formula- 77
How to Calculate Compound Interest using Formula in Excel| Microsoft Excel: Interest Calculation- 78
Microsoft Excel: DCOUNT Function | use DCOUNT Formula in Excel | DCOUNT Function in MS Excel - 79
How to Check Correct Spelling in MS Excel| How to Find Synonyms in MS Excel| Review Tab in Excel- 80
Microsoft Excel: SUMIF Function | How to Use SUMIF Formula in Excel| SUMIF Function in MS Excel - 81
Microsoft Excel: TRIM & SUBSTITUDE Function| TRIM Function in Excel| SUBSTITUDE Function in Excel-82
Microsoft Excel: REPLACE Function| How to Use REPLACE Formula in Excel| REPLACE Function in Excel-83
Microsoft Excel: DCOUNTA Function| How to Use DCOUNTA Formula in Excel| DCOUNTA Function in Excel-84
Microsoft Excel: SUMIFS Function| How to Use SUMIFS Formula in Excel| SUMIFS Function in MS Excel-85
Microsoft Excel: FREQUENCY Function| Use FREQUENCY Formula in Excel| FREQUENCY Function in Excel- 86
Microsoft Excel: RANK Function| Use RANK Formula in Excel| How to Calculate Student Rank in Excel-87
Microsoft Excel : LARGE Function | How to use LARGE Formula in Excel | LARGE Function in Excel - 88
Microsoft Excel : SMALL Function | How to use SMALL Formula in Excel | SMALL Function in Excel - 89
Microsoft Excel : DMAX and DMIN Function | DMAX Formula in Excel | DMIN Formula in MS Excel - 90
Microsoft Excel : Round Function | How to Round, Round Up and Round Down Numbers in Excel - 91
Microsoft Excel: IFERROR Function| How to Use IFERROR Formula in Excel| IFERROR Function in Excel-92
IFERROR Function with VLOOKUP in MS Excel | VLOOKUP Formula in Excel | IFERROR Formula in Excel-93
How to Use VLOOKUP Function with MATCH Function in Excel | VLOOKUP and MATCH Function in Excel-94
Use INDEX with MATCH Function in Excel| Excel INDEX and MATCH Formula| Excel Index Match Function-95
How to use VLOOKUP with CHOOSE Function in Excel| Microsoft Excel VLOOKUP CHOOSE Formula Function-96
Microsoft Excel: ARRAY Function| How to Use ARRAY with SUM Function in Excel| ARRAY & SUM Formula-97
Microsoft Excel: ARRAY Function|Convert Row into Column in Excel| Use TRANSPOSE Function in Excel-98
Microsoft Excel: ARRAY Function| How to Use ARRAY with MAX Function in Excel| ARRAY & MAX Formula-99
How to apply VLOOKUP on Large / Big Data in Excel | Microsoft Excel Vlookup function with Array -100
How to Calculate Depreciation in MS Excel| Microsoft Excel: DB Function| Use DB Formula in Excel-101
Scenario Manager in MS Excel | What-If Analysis in Excel| Create and Compare Scenarios in Excel -102
Microsoft Excel - Nested IF Function - 103
How to Separate or Split First, Middle and Last Name in Excel | Text to Column wizard in Excel - 104
Use Microsoft Excel Fuzzy Lookup| How to search approximate Value in Excel| Fuzzy Lookup Add In -105
How to use iseven & isodd formula to check whether a number is even or odd in Excel? 106
MS Excel Recommended Pivot Table | How to organize data using recommended Pivot Table in Excel - 107
Microsoft Excel - Pivot Table - 108
Microsoft Excel - Pivot Chart - 109
How to create Pivot Tables and Pivot Chart in Excel| Make Pivot Chart with Pivot Table in Excel- 110
Excel ISBLANK Function | ISBLANK Formula with IF Function | Conditional Formatting with ISBLANK- 111
How to Calculate Square Root Cube Root in Microsoft Excel| Power Function SQRT Function in Excel-112
How to Reverse a list in Microsoft Excel| Reverse data Range in Excel | How to Invert Excel Data-113
Excel ISTEXT Function| Excel ISNONTEXT Function| Data Validation with ISTEXT ISNOTTEXT in Excel- 114
Combine or Merge Multiple Rows Text into One Cell in Excel| CONCATENATE and TRANSPOSE Function-115
How to view two Excel Sheets Side by side in Excel| View two Windows or Excel Files side by side-116
Microsoft Excel CHAR Function | Use CHAR Formula Function in Excel to insert Special Characters -117
CONCATENATE and CHAR Function in Excel| Concatenate Text with Line Break in Excel| Advance Excel-118
Insert Blank Row Between Each Data Row in Excel| Insert Blank Row After Every Data Row In Excel- 119
Microsoft Excel Hyperlink | How to Insert Hyperlink in Excel | How to Create Hyperlink in Excel -120
How to Insert Pictures in Excel| How to Insert Image in Excel| Insert and Resize Image in Cell - 121
Use INDIRECT Formula in Microsoft Excel | MS Excel INDIRECT Formula| INDIRECT Function - 122
MS Excel - Flash Fill | How to Use Flash Fill in Microsoft Excel | Microsoft Excel Flash Fill - 123
Left Right and Mid Function in Excel | Microsoft Excel Left Right and Mid Formula - 124
How to protect workbook in Excel | MS Excel - Protect Workbook | How to block actions in excel - 125
How to use Define Name in Excel| Excel Formula Tab| How to create & use the named range in Excel-126
How to Group Rows and Columns in Excel | Grouping Rows and Columns in Microsoft Excel - 127
Protect Excel Workbook with Password| Set Password to Excel Workbook| Lock or Unlock Excel file- 128
Excel Indirect formula with Sum Average | Find Sum, Average, Maximum, Mimimum in Excel - 129
Capitalize only First Letter of Sentence in Excel | Make sentence first letter capital in Excel- 130
Microsoft Excel Insert Shapes | How to Insert & Customize Shape in MS Excel | Shapes Formatting- 131
Microsoft Excel SmartArt | How to Insert & Customize SmartArt in MS Excel | SmartArt Formatting -132
How to Create Macro in Excel | How to Use Macro in Excel | How to Record Macro in Excel-133
How to Take Screenshot in Excel| Insert Screenshot in Excel| Excel me Screenshot kaise lete hai- 134
Comments
Post a Comment