Advance Excel
Embedded Files
04 Inserting Rows, Columns, Cells
05 Changing Size Of Rows & Columns
06 Finding Average, Max, Sum, Multiplication, Subtraction & Division
07 Sorting Data & Using Filter Function in MS Excel07
08 How to Insert Pivot Table & Chart
09 Merging Cells & Use Of CountIf Function
10 Using IF Function & Finding Percent i
11 Using Conditional Formatting & Data Formatting
12 Using Format as Table, Freeze Panes
13 How to add background image
14 Using Combine Formulas & Increasing
15 How to compare two worksheets
16 How to do Text Wrapping & Moving Data
17 How to Remove Errors in MS Excel
18 How to use CountA, Countif Function
19 How to use Consolidate Function
20 How to use Scenario Manager
21 How to use PMT Formula & Goal Seek Function
22 How to use IPMT & PPMT Formulas
25 How to use Averageif & Averageifs Formulas
27 How to use Rand & Randbetween
28 How to use Future Value Formula
29 How to use all options of Paste Special
30 How to use Vlookup Function For Multiple Results
31 How to Remove Duplicate Data
33 How to Create Drop Down List
35 How to use AutoCorrect option
37 How to use Date & Time option in Data Validation
38 How to use Custom option in Data Validation
40 How to protect whole worksheet
41 How to protect file through password
42 How to use Macro in MS Excel
43 How to use concatenate formula and "&" sign to combine data of cells
44 Advanced Excel Magical Hidden Tips & Feature
45 Advanced Excel Magical Hidden Tips & Feature To Make You an Expert
01 Basic Introduction of MS Excel
03 Creating New Workbook, Open File, Using Save, Save As
04 How To Use Cut, Copy And Paste Options
05 How To Use Find, Replace, Find Next & Replace All
06 How To Change Font, Font Size, & How To Bold, Italic, Underline A Text
07 How To Use Undo And Redo Options
08 How To Change Border Color, Font Color & Using Fill Color Options
09 How To Use Text Alignment & Indent Options To Align & Indent Text
10 How To Use Orientation Option Change Text Direction Of Text
12 How To Use Wrap Text & Merge & Center Options
13 How To Format Numbers, Dates & Time
14 How To Do Conditional Formatting & How To Highlight Cells
15 How To Use Format As Table & Cell Styles Option
16 How To Insert & Delete Rows, Columns, Cells & Sheets
17 How To Change Row Height And Column Width
18 How To Hide And Unhide A Row Or Column Using Hide And Unhide Option
19 How To Rename And Copy Or Move A Worksheet Data
20 How To Fill Months, Days, Date & Numbers By Autofill Function
21 How To Sort Numbers And Data Using Sort & Filter Option
22 How to use Mini Toolbar and Shortcut Menu
23 How To Use and customize Quick Access Toolbar
24 Using Status Bar to find sum, average etc.& What is Page Break Preview
25 How to Remove Formatting, Comments & Hyperlink using Clear Function
26 How To Do Addition, Subtraction, Division, Multiply, autosum etc
27 How To Use Clipboard To Copy & Paste Several Items
28 Using Paste Special To Copy Format, Formula, Values & its Shortcut Key
29 Copy Conditional Format, Column Width, Number Format By Paste Special
30 Using Paste Special To Transpose Data And To Add or Subtract Values
31 How To Use Data Validation Option
32 How To Create Data Validation For Decimal Numbers & Other Data Options
33 How To Create Drop Down Menu & Set Character Limit By Data Validation
34 How to Set Limit for Date & Time Using Data Validation Option
35 Preventing Duplicate Entries & Allow Text / Numbers Only
36 How To Add Data Of Multiple Sheets & Workbook By Consolidate
37 Learn To Insert & Delete Image From Background Of Data
38 How To Navigate Between Sheets Of A Workbook Using Go To Option
39 How to Use Print Option for Printing Worksheet & Setting Orientation/Margins
40 How To Print Title Or Heading On Every Page By Print Titles
41 How to use the LOOKUP Function
42 How to Use Vlookup Formula to Find Particular Data in Same/Different Workbooks
43 How To Check Column & Row Number Of A Cell By Column & Row Formula
44 How to Check Number of Columns or Rows in A Table Using Columns & Rows
45 How To Get Multiple Results By Using Vlookup Formula For Single Time45
46 Use of Hlookup Formula to Find Data from Database in Same/Different Workbooks
47 How To Freeze & Unfreeze Multiple Rows And Columns
48 Generate Random Numbers Using Rand And Randbetween Formula In
49 Learn To Calculate EMI Using PMT
50 Use Of Goal Seek Formula To Know Estimated Down Payment Amount
51 How To Insert Chart & Change Its Color, Style Etc
52 How to calculate interest & principal amount of loan using IPMT & PPMT
53 How to use Averageif & Averageifs in MS Excel to calculate average based
54 How to create template in Excel with font style, font size, alignment etc
55 How to use COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS
56 How to remove different types of formula errors
57 How to use concatenate formula and "&" sign to combine data of 2 or more cells
58 How to change case (upper, lower, proper) and concatenate text at same time
59 How to use FV formula to calculate future value of an investment
60 How to protect a complete worksheet or a part of worksheet with password
61 How to use clean formula in MS Excel for removing non-printable characters
62 How to calculate running total
63 How to split full name to first and last name
64 How to use Dsum in MS Excel to add numbers of particular column based on a condition
65 How to use Dget in Excel to search a record from a database according to a condition.
66 How to use Daverage in MS Excel to find average of a data of a column based on condition
67 How to use sumproduct in Excel to find sum of the products of one or more cell ranges
68 How to use ceiling/floor formula in Excel to find max/min round off
69 How to use Forecast formula
70 How to find & remove duplicate data/entries by using Remove Duplicates option
71 How to use Edate formula to find the name of the day of any future or past date
72 How to calculate lowest common multiple using LCM formula
73 How to calculate GCD and find ratio of numbers using GCD
74 How to calculate overtime hours
75 Calculate age using datedif formula
76 How to calculate Simple Interest
77 How to make compound interest calculation chart
79 How to calculate Compound Interest
80 How to count numerical values of a column based on a condition using Dcount
81 How to use Spelling & Thesaurus option
82 How to use TRIM function to remove extra space & SUBSTITUTE to replace characters
83 How to use replace formula to replace a part of a text
84 How to use Dcounta to count filled cells of a column according to a condition
85 How to use Sumifs to add values of column/row based on multiple conditions
86 How to use Frequency in Excel to check that how many times a record repeats
89 How to use small function to find some smallest values from the list
90 How to use Dmax & Dmin to find largest or smallest number based on a condition
91 How to use round, roundup & rounddown formula to remove decimal from digits
01 7 Super Ways To Manage Your Data
02 Userform in Excel in Hindi - Data Add | Search | Update
03 Excel में Macro सीखलो घंटों का काम मिनटों में होगा
04 Easy Way To Convert Excel To Word
06 Page Setting in Excel for Print
07 How To Use Wrap Text & Merge & Center Options
08 Top 10: Advanced Excel Tips 2019 ((Powerful & Faster!!) in Hindi
09 12 TRUCOS DE EXCEL PARA MEJORAR TUS PRESENTACIONES
10 how to automatically transfer & Save data from one sheet to another in excel |
11 Excel VLOOKUP formula with Multiple sheets |
12 Index Match Function in Excel in Hindi Simple and Easy- Better then Vlookup
13 Index and Match formula in excel hindi
14 Excel Tricks : Easy Technique To Replace Vlookup With Index and Match Functions
15 Advanced Excel Tips & Tricks [Unknown tricks]
16 Advance Excel - Top 5 Excel Time Saving tricks 2018-2019
17 Repeat Row & Column Titles on Every Printed Page from Excel in Hindi
Page updated
Google Sites
Report abuse