Mastering Excel: A Complete Course Syllabus for Beginners

 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

Popular posts from this blog

Mastering HTML: A Complete Course Syllabus from Beginner to Advance

Mastering HTML: A Complete Course Syllabus for Beginner to Advance 1. Introduction to HTML  2. Tags and Element in HTML  3. Attributes in HTML  4. HTML Tag in HTML  5. Head Tag in HTML  6. Title Tag in HTML  7. Body Tag in HTML  8. How to Create a Simple HTML Page  9. Type of Tag in HTML  10. Version of HTML  11. Introduction of HTML 5  12. Features of HTML 5  13. HTML 5 Doctype Declaration  14. How to Create Plain Text Web Page in HTML 5  15. How to insert New Line or Line Break using br Tag in HTML  16. How to write Headings using h Tag in HTML  17. How to Create Paragraph using p Tag in HTML  18. Subscript and Superscript using sub and sup Tag in HTML  19. Horizontal Rule or Horizontal Line using hr Tag in HTML  20. Align Attribute in HTML  21. Bold using b Tag in HTML  22. Italic using i Tag in HTML  23. Strong and Emphasis Tag in HTML  24. Blockquote and q Tag in HTML...
Read more

Mastering CSS and CSS 3: A Complete Course Syllabus from Beginner to Advance

Introduction to CSS  CSS Syntax  Element Selector in CSS  Way of Inserting CSS  External Style Sheet in CSS  How to link Web Page to External Style Sheet in CSS  Internal Style Sheet in CSS  Inline Style in CSS  Multiple Style Sheet  or Priority of Style Sheets in CSS  Comment in CSS  id Selector in CSS  Class Selector or Style Class in CSS  Universal Style Class in CSS  Element Specific Style Class in CSS  How to use two or more classes in CSS  Grouping Selectors in CSS  Background Properties in CSS  background color property in CSS  background image property in CSS  background repeat property in CSS  background position property in CSS  background attachment property in CSS  background shorthand property in CSS  background size property in CSS  background origin property in CSS  background clip property in CSS  How to set Multiple background Image in C...
Read more

Mastering Bootstrap: A Complete Course Syllabus from Beginner to Advance

Introduction to Bootstrap  How to Download and Use Bootstrap  How to Include Custom CSS in Bootstrap  Container and Container fluid Layout in Bootstrap  Grid System in Bootstrap  Grid System Break Points in Bootstrap  Example Grid System Break Points in Bootstrap  Auto Width Column in Bootstrap  Column Break in Bootstrap  How to set Column Order in Bootstrap  Offset Column in Bootstrap  Nesting Columns or Rows in Bootstrap  Media Object in Bootstrap  Typography in Bootstrap  Images in Bootstrap  Table in Bootstrap  Figures in Bootstrap  Colors in Bootstrap  Borders in Bootstrap  Text in Bootstrap  Spacing - Margin and Padding in Bootstrap  Vertical Alignment in Bootstrap  Visibility in Bootstrap  Sizing in Bootstrap  Position in Bootstrap  Shadow in Bootstrap  Display in Bootstrap  Embed in Bootstrap  Float in Bootstrap  Alerts in Bootstrap...
Read more