ExcelSuperStar.

org - How to clear BASIC Excel Interview

Pre-requisite: Sum, Multiply, Average, Max, Min

SN Area Topic
1 Maths Date Calculations, Calculating %
2 Formula Using $
3 Paste Special Value, Transpose
4 Data Analysis Sort & Filter
5 Data Analysis Maths operations on Filtered Data - SUBTOTAL()
6 Data Analysis Pivot Table
7 Formula VLOOKUP
8 Formula IF
9 Reporting Formatting - Border, Comma Style, Format Painter, TRIM, PROPER
10 Bonus Tricks FlashFill, Remove Duplicates, Text to Columns, Cond Formatting
[Bangalore-based Service Company] - Sales Data for 2018 for Mumbai, Kolkata, Gurgaon, Pune

Sale Date Client ID Client Name & Service Request ID City

5-Jan-18 91040 Apeejay House Pvt. Ltd., 1124589 Pune
10-Jan-18 91088 ISPAT industries Ltd., 1122097 Mumbai
27-Jan-18 91783 Veljan Hydrair Ltd., 1122857 Gurgaon
28-Jan-18 91814 Mishanti Consultancy services Pvt. Ltd., 112 Kolkata
31-Jan-18 92016 Bonanza Investment Pvt. Ltd., 1129985 Mumbai
5-Feb-18 92254 ICB Ltd., 1124106 Mumbai
13-Feb-18 92545 Coal India Ltd. (RSO Cal - WB), 1125725 Mumbai
28-Feb-18 93077 Pushpak Tours & Travels, 112303 Kolkata
7-Mar-18 93294 Shipcon Surveyors Pvt Ltd, 1129105 Mumbai
16-Mar-18 93447 Shyam Sundar Tea Co. Pvt. Ltd., 1124298 Gurgaon
18-Mar-18 93512 Western Consolidated , 1121853 Kolkata
22-Mar-18 93612 The Observer, 1124748 Kolkata
27-Mar-18 93743 SLP Vyapaar Pvt. Ltd., 1124672 Mumbai
2-Apr-18 93921 Shree Krishna Commercial corporation, 112 Pune
13-Apr-18 93984 ISPAT Profiles India Ltd., 112899 Pune
30-Apr-18 94170 IBP Co. Ltd., 1124566 Kolkata
3-May-18 94215 Premier Meta Products, 1125255 Gurgaon
7-May-18 94484 Happy eZon, 1122912 Kolkata
12-May-18 94576 ROTARK Controls (I) Ltd., 112786 Mumbai
28-May-18 95036 Bharat Hydro Power Corpn. Ltd., 112987 Mumbai
9-Jun-18 95154 Chino Laxsons India Ltd., 1124291 Kolkata
26-Jun-18 95501 Flury's Swiss Confectionery Pvt. Ltd, 112445 Mumbai
1-Jul-18 95515 Khaitan Paper & Industries ltd, 1124275 Gurgaon
15-Jul-18 95639 Ganapati Multiprojects Pvt. Ltd, 1126269 Kolkata
6-Aug-18 96193 Metalines Development Pvt. Ltd., 1122935 Kolkata
10-Aug-18 96488 Padma Complex Pvt. Ltd, 1122761 Mumbai
26-Aug-18 96803 M.G. Mining Co. Pvt. Ltd., 1121633 Mumbai
27-Aug-18 96882 ConLif Pvt. Ltd., 1123689 Kolkata
30-Aug-18 96948 TSS (I) Ltd. / Niranjan Engg Pvt. Ltd., 112980Kolkata
5-Sep-18 97152 Mind Edge Solutions, 112945 Gurgaon
12-Sep-18 97247 GMMC Radha Niket Atlas Industries, 112935Pune
28-Sep-18 97678 Coal India Ltd. (Mktn), 1124292 Gurgaon
11-Oct-18 97962 Mahadev Sponge & Mining Pvt. Ltd, 112662 Kolkata
14-Oct-18 97966 Jainsons International, 1124140 Mumbai
20-Oct-18 98103 Datacraft India Ltd., 112735 Kolkata
30-Oct-18 98364 SGA Business Services Pvt. Ltd, 1125316 Kolkata
1-Nov-18 98460 Industrial Machines Delhi Pvt. Ltd, 1129096 Kolkata
6-Nov-18 98465 Eastern Mines & Industries Ltd., 1127042 Gurgaon
6-Nov-18 98570 Happy Homes & Hotels Pvt. Ltd, 112695 Mumbai
28-Nov-18 99200 Rimari IT Solutions Pvt. Ltd, 1125627 Gurgaon
30-Nov-18 99275 National Film Development Corpn. Ltd., 112 Kolkata
1-Dec-18 99309 Tropican Enterpises Ltd., 1128396 Mumbai
 5-Dec-18 99485 KPL International Ltd., 112575 Kolkata
27-Dec-18 99900 The Food Corpn of India, 1121381 Gurgaon
28-Dec-18 99901 Garuda Carriers &Shipping Ltd, 1126104 Mumbai
ta, Gurgaon, Pune

Amt incl GST @ 18% Payment Recd Date

108,500 6-Jan-18
146,500 28-Mar-18
58,400 5-Aug-18
17,500 18-May-18
115,100
45,200 7-Feb-18
52,500 20-Aug-18
125,500 14-Jul-18
150,300 20-May-18
85,200 29-Mar-18
127,500 6-Apr-18
105,600
52,600 8-Jun-18
88,800 11-Jul-18
47,500 7-Sep-18
128,700 29-Aug-18
71,700 26-Jun-18
63,300 13-Aug-18
100,800 29-Sep-18
56,300 20-Oct-18
87,700 18-Nov-18
90,500 26-Jun-18
95,900 10-Nov-18
137,400
90,600 15-Dec-18
38,300 31-Oct-18
29,900 20-Oct-18
69,600 19-Nov-18
95,200 5-Nov-18
68,900 1-Oct-18
72,600
176,000
192,100 2-Nov-18
162,800 6-Nov-18
184,000 12-Dec-18
197,200
155,800 5-Dec-18
169,500 27-Nov-18
170,300
192,100
167,700
167,600
186,500
194,400
170,900
 Sale Date Payment Recd Date
5-Jan-18 6-Jan-18
10-Jan-18 28-Mar-18
27-Jan-18 5-Aug-18
28-Jan-18 18-May-18
31-Jan-18
5-Feb-18 7-Feb-18
13-Feb-18 20-Aug-18
28-Feb-18 14-Jul-18
7-Mar-18 20-May-18
16-Mar-18 29-Mar-18
18-Mar-18 6-Apr-18
22-Mar-18
27-Mar-18 8-Jun-18
2-Apr-18 11-Jul-18
13-Apr-18 7-Sep-18
30-Apr-18 29-Aug-18
3-May-18 26-Jun-18
7-May-18 13-Aug-18
12-May-18 29-Sep-18
28-May-18 20-Oct-18
9-Jun-18 18-Nov-18
26-Jun-18 26-Jun-18
1-Jul-18 10-Nov-18
15-Jul-18
6-Aug-18 15-Dec-18
10-Aug-18 31-Oct-18
26-Aug-18 20-Oct-18
27-Aug-18 19-Nov-18
30-Aug-18 5-Nov-18
5-Sep-18 1-Oct-18
12-Sep-18
28-Sep-18
11-Oct-18 2-Nov-18
14-Oct-18 6-Nov-18
20-Oct-18 12-Dec-18
30-Oct-18
1-Nov-18 5-Dec-18
6-Nov-18 27-Nov-18
6-Nov-18
28-Nov-18
30-Nov-18
1-Dec-18
 5-Dec-18
27-Dec-18
28-Dec-18
Amt incl GST @ 18%
108,500
146,500
58,400
17,500
115,100
45,200
52,500
125,500
150,300
85,200
127,500
105,600
52,600
88,800
47,500
128,700
71,700
63,300
100,800
56,300
87,700
90,500
95,900
137,400
90,600
38,300
29,900
69,600
95,200
68,900
72,600
176,000
192,100
162,800
184,000
197,200
155,800
169,500
170,300
192,100
167,700
167,600
186,500
194,400
170,900
City
Pune
Mumbai
Gurgaon
Kolkata
Client Name & Service Request ID
Apeejay House Pvt. Ltd., 1124589
ISPAT industries Ltd., 1122097
Veljan Hydrair Ltd., 1122857
Mishanti Consultancy services Pvt. Ltd., 1126373
Bonanza Investment Pvt. Ltd., 1129985
ICB Ltd., 1124106
Coal India Ltd. (RSO Cal - WB), 1125725
Pushpak Tours & Travels, 112303
Shipcon Surveyors Pvt Ltd, 1129105
Shyam Sundar Tea Co. Pvt. Ltd., 1124298
Western Consolidated , 1121853
The Observer, 1124748
SLP Vyapaar Pvt. Ltd., 1124672
Shree Krishna Commercial corporation, 112903
ISPAT Profiles India Ltd., 112899
IBP Co. Ltd., 1124566
Premier Meta Products, 1125255
Happy eZon, 1122912
ROTARK Controls (I) Ltd., 112786
Bharat Hydro Power Corpn. Ltd., 112987
Chino Laxsons India Ltd., 1124291
Flury's Swiss Confectionery Pvt. Ltd, 1124456
Khaitan Paper & Industries ltd, 1124275
Ganapati Multiprojects Pvt. Ltd, 1126269
Metalines Development Pvt. Ltd., 1122935
Padma Complex Pvt. Ltd, 1122761
M.G. Mining Co. Pvt. Ltd., 1121633
ConLif Pvt. Ltd., 1123689
TSS (I) Ltd. / Niranjan Engg Pvt. Ltd., 1129805
Mind Edge Solutions, 112945
GMMC Radha Niket Atlas Industries, 1129359
Coal India Ltd. (Mktn), 1124292
Mahadev Sponge & Mining Pvt. Ltd, 1126628
Jainsons International, 1124140
Datacraft India Ltd., 112735
SGA Business Services Pvt. Ltd, 1125316
Industrial Machines Delhi Pvt. Ltd, 1129096
Eastern Mines & Industries Ltd., 1127042
Happy Homes & Hotels Pvt. Ltd, 112695
Rimari IT Solutions Pvt. Ltd, 1125627
National Film Development Corpn. Ltd., 1123111
Tropican Enterpises Ltd., 1128396
KPL International Ltd., 112575
The Food Corpn of India, 1121381
Garuda Carriers &Shipping Ltd, 1126104
Client ID
91040
93077
93921
[Bangalore-based Service Company] - Sales Data for 2018 for Mumbai, Kolkata, Gurgaon, Pune

Sale Date Client ID Client Name & Service Request ID City

5-Jan-18 91040 Apeejay House Pvt. Ltd., 1124589 Pune
10-Jan-18 91088 ISPAT industries Ltd., 1122097 Mumbai
27-Jan-18 91783 Veljan Hydrair Ltd., 1122857 Gurgaon
28-Jan-18 91814 Mishanti Consultancy services Pvt. Ltd., 112 Kolkata
31-Jan-18 92016 Bonanza Investment Pvt. Ltd., 1129985 Mumbai
5-Feb-18 92254 ICB Ltd., 1124106 Mumbai
13-Feb-18 92545 Coal India Ltd. (RSO Cal - WB), 1125725 Mumbai
28-Feb-18 93077 Pushpak Tours & Travels, 112303 Kolkata
7-Mar-18 93294 Shipcon Surveyors Pvt Ltd, 1129105 Mumbai
16-Mar-18 93447 Shyam Sundar Tea Co. Pvt. Ltd., 1124298 Gurgaon
18-Mar-18 93512 Western Consolidated , 1121853 Kolkata
22-Mar-18 93612 The Observer, 1124748 Kolkata
27-Mar-18 93743 SLP Vyapaar Pvt. Ltd., 1124672 Mumbai
2-Apr-18 93921 Shree Krishna Commercial corporation, 112 Pune
13-Apr-18 93984 ISPAT Profiles India Ltd., 112899 Pune
30-Apr-18 94170 IBP Co. Ltd., 1124566 Kolkata
3-May-18 94215 Premier Meta Products, 1125255 Gurgaon
7-May-18 94484 Happy eZon, 1122912 Kolkata
12-May-18 94576 ROTARK Controls (I) Ltd., 112786 Mumbai
28-May-18 95036 Bharat Hydro Power Corpn. Ltd., 112987 Mumbai
9-Jun-18 95154 Chino Laxsons India Ltd., 1124291 Kolkata
26-Jun-18 95501 Flury's Swiss Confectionery Pvt. Ltd, 112445 Mumbai
1-Jul-18 95515 Khaitan Paper & Industries ltd, 1124275 Gurgaon
15-Jul-18 95639 Ganapati Multiprojects Pvt. Ltd, 1126269 Kolkata
6-Aug-18 96193 Metalines Development Pvt. Ltd., 1122935 Kolkata
10-Aug-18 96488 Padma Complex Pvt. Ltd, 1122761 Mumbai
26-Aug-18 96803 M.G. Mining Co. Pvt. Ltd., 1121633 Mumbai
27-Aug-18 96882 ConLif Pvt. Ltd., 1123689 Kolkata
30-Aug-18 96948 TSS (I) Ltd. / Niranjan Engg Pvt. Ltd., 112980Kolkata
5-Sep-18 97152 Mind Edge Solutions, 112945 Gurgaon
12-Sep-18 97247 GMMC Radha Niket Atlas Industries, 112935Pune
28-Sep-18 97678 Coal India Ltd. (Mktn), 1124292 Gurgaon
11-Oct-18 97962 Mahadev Sponge & Mining Pvt. Ltd, 112662 Kolkata
14-Oct-18 97966 Jainsons International, 1124140 Mumbai
20-Oct-18 98103 Datacraft India Ltd., 112735 Kolkata
30-Oct-18 98364 SGA Business Services Pvt. Ltd, 1125316 Kolkata
1-Nov-18 98460 Industrial Machines Delhi Pvt. Ltd, 1129096 Kolkata
6-Nov-18 98465 Eastern Mines & Industries Ltd., 1127042 Gurgaon
6-Nov-18 98570 Happy Homes & Hotels Pvt. Ltd, 112695 Mumbai
28-Nov-18 99200 Rimari IT Solutions Pvt. Ltd, 1125627 Gurgaon
30-Nov-18 99275 National Film Development Corpn. Ltd., 112 Kolkata
1-Dec-18 99309 Tropican Enterpises Ltd., 1128396 Mumbai
 5-Dec-18 99485 KPL International Ltd., 112575 Kolkata
27-Dec-18 99900 The Food Corpn of India, 1121381 Gurgaon
28-Dec-18 99901 Garuda Carriers &Shipping Ltd, 1126104 Mumbai
ta, Gurgaon, Pune

Amt incl GST @ 18%

108,500
146,500
58,400
17,500
115,100
45,200
52,500
125,500
150,300
85,200
127,500
105,600
52,600
88,800
47,500
128,700
71,700
63,300
100,800
56,300
87,700
90,500
95,900
137,400
90,600
38,300
29,900
69,600
95,200
68,900
72,600
176,000
192,100
162,800
184,000
197,200
155,800
169,500
170,300
192,100
167,700
167,600
186,500
194,400
170,900
SN Section Name
1 Excel Shortcuts
2 Excel Shortcuts
3 Excel Shortcuts
4 Excel Shortcuts
5 Excel Shortcuts
6 Essentials for Beginners
7 Essentials for Beginners
8 Essentials for Beginners
9 Essentials for Beginners
10 Essentials for Beginners
11 Essentials for Beginners
12 Essentials for Beginners
13 Essentials for Beginners
14 Essentials for Beginners
15 Essentials for Beginners
16 Essentials for Beginners
17 Essentials for Beginners
18 Essentials for Beginners
19 Essentials for Beginners
20 Essentials for Beginners
21 Essentials for Beginners
22 Essentials for Beginners
23 Essentials for Beginners
24 Essentials for Beginners
25 Essentials for Beginners
26 Essentials for Beginners
27 Essential Formatting Tricks
28 Essential Formatting Tricks
29 Essential Formatting Tricks
30 Essential Formatting Tricks
31 Essential Formatting Tricks
32 Essential Formatting Tricks
33 Essential Formatting Tricks
34 Essential Formatting Tricks
35 Essential Formatting Tricks
36 Essential Formatting Tricks
37 Essential Formatting Tricks
38 Essential Formatting Tricks
39 Essential Formatting Tricks
40 Essential Formatting Tricks
41 Essential Formatting Tricks
42 Essential Formatting Tricks
43 Essential Formatting Tricks
44 Essential Formatting Tricks
45 Essential Formatting Tricks
46 Essential Formatting Tricks
47 Essential Formatting Tricks
48 Essential Formatting Tricks
49 Essential Formatting Tricks
50 Sort & Filter
51 Sort & Filter
52 Sort & Filter
53 Sort & Filter
54 Sort & Filter
55 Sort & Filter
56 Sort & Filter
57 Sort & Filter
58 Sort & Filter
59 Sort & Filter
60 Sort & Filter
61 Sort & Filter
62 Sort & Filter
63 Sort & Filter
64 Sort & Filter
65 Sort & Filter
66 Sort & Filter
67 Sort & Filter
68 Sort & Filter
69 Cell Reference ($)
70 Dates
71 Dates
72 Dates
73 Dates
74 Dates
75 Dates
76 Dates
77 Dates
78 Dates
79 Dates
80 Dates
81 Dates
82 Dates
83 Dates
84 Logical Functions
85 Logical Functions
86 Logical Functions
87 Logical Functions
88 Logical Functions
 89 Logical Functions
90 Data Cleaning
91 Data Cleaning
92 Data Cleaning
93 Data Cleaning
94 Data Cleaning
95 Data Cleaning
96 Data Cleaning
97 Data Cleaning
98 Data Cleaning
99 Data Cleaning
100 Data Cleaning
101 Data Cleaning
102 Data Cleaning
103 Data Cleaning
104 Data Cleaning
105 Data Cleaning
106 Data Cleaning
107 Data Cleaning
108 Data Cleaning
109 Data Cleaning
110 Data Cleaning
111 Data Cleaning
112 Data Cleaning
113 Data Cleaning
114 Data Cleaning
115 Data Cleaning
116 Pivot Table
117 Pivot Table
118 Pivot Table
119 Pivot Table
120 Lookup Formulas (A-Z)
121 Lookup Formulas (A-Z)
122 Lookup Formulas (A-Z)
123 Lookup Formulas (A-Z)
124 Lookup Formulas (A-Z)
125 Lookup Formulas (A-Z)
126 Lookup Formulas (A-Z)
127 Lookup Formulas (A-Z)
128 Lookup Formulas (A-Z)
129 Lookup Formulas (A-Z)
130 Lookup Formulas (A-Z)
131 Lookup Formulas (A-Z)
132 Lookup Formulas (A-Z)
133 Lookup Formulas (A-Z)
134 Lookup Formulas (A-Z)
135 Lookup Formulas (A-Z)
136 Lookup Formulas (A-Z)
137 Lookup Formulas (A-Z)
138 Lookup Formulas (A-Z)
139 Lookup Formulas (A-Z)
140 Lookup Formulas (A-Z)
141 Lookup Formulas (A-Z)
142 Lookup Formulas (A-Z)
143 Lookup Formulas (A-Z)
144 Lookup Formulas (A-Z)
145 Lookup Formulas (A-Z)
146 Lookup Formulas (A-Z)
147 Lookup Formulas (A-Z)
148 Lookup Formulas (A-Z)
149 Conditional Aggregation
150 Conditional Aggregation
151 Conditional Aggregation
152 Conditional Aggregation
153 Conditional Aggregation
154 Conditional Aggregation
155 Conditional Aggregation
156 Conditional Aggregation
157 Conditional Aggregation
158 Conditional Aggregation
159 Conditional Aggregation
160 Conditional Formatting
161 Conditional Formatting
162 Conditional Formatting
163 Conditional Formatting
164 Conditional Formatting
165 Conditional Formatting
166 Conditional Formatting
167 What-If Analysis
168 What-If Analysis
169 What-If Analysis
170 What-If Analysis
171 What-If Analysis
172 What-If Analysis
173 Report Consolidation
174 Report Consolidation
175 Report Consolidation
176 Report Consolidation
177 Report Consolidation
178 Report Consolidation
179 Printing
180 Workbook & Worksheet Security
181 Workbook & Worksheet Security
182 Workbook & Worksheet Security
183 Workbook & Worksheet Security
184 Special Tricks
185 Special Tricks
186 Special Tricks
187 Special Tricks
188 Special Tricks
189 Advanced Excel Projects - Finance
190 Advanced Excel Projects - Finance
191 Advanced Excel Projects - Finance
192 Advanced Excel Projects - Finance
193 Advanced Excel Projects - Finance
194 Advanced Excel Projects - Finance
195 Advanced Excel Projects - Finance
196 Advanced Excel Projects - Finance
197 Advanced Excel Projects - Sales
198 Advanced Excel Projects - Sales
199 Advanced Excel Projects - Sales
200 Bonus - Office 365 Updates
201 Bonus - Office 365 Updates
202 Bonus - Office 365 Updates
203 Bonus - Office 365 Updates
204 Bonus - Office 365 Updates
205 Bonus - Office 365 Updates
206 Bonus - Office 365 Updates
207 Bonus - Office 365 Updates
208 Bonus - Office 365 Updates
209 Bonus - Office 365 Updates
210 Basics of Macros
211 Basics of Macros
212 Basics of Macros
213 Basics of Macros
214 Basics of Macros
215 Basics of Macros
216 Basics of Macros
217 Basics of Macros
218 Basics of Macros
219 Basics of Macros
220 Basics of Macros
221 Basics of Macros
222 Basics of Macros
223 Basics of Macros
New lecture name
Best Excel Shortcuts - Part 1 of 4
Best Excel Shortcuts - Part 2 of 4
Best Excel Shortcuts - Part 3 of 4
Best Excel Shortcuts - Part 4 of 4
How to create custom shortcuts using Quick Access Toolbar (QAT)?
Three easy ways to do SUM or total of numbers
Basics of MAX & MIN formula
Use of MAX formula in Finance (Tax & Billing)
Use of SMALL & LARGE formula in Finance
Using MEDIAN formula to remove outliers
Using Paste Special (Value, Transpose) for daily work
Paste Special (Transpose) vs TRANSPOSE Formula
Using COUNTBLANK to count blank cells
Difference between COUNT vs. COUNTA
Using Status Bar for Quick Calculations
Using SUMPRODUCT Function in Finance & Costing
Easiest way to calculate YoY Growth Percentage
What is POWER formula
How to calculate the maturity amount of Fixed Deposit
Basics of ROUND formula
Basics of ROUNDUP & ROUNDDOWN formula
Uses of ROUNDUP & ROUNDDOWN formula in Finance
Basics of MROUND formula
Advanced Trick of Round Formula in Finance
Using Autofill feature to create automatic list of Dates
Using Autofill feature to create automatic list of Numbers
7 ways to use Format Cells
How to hide a text without coloring the cell white?
What is - Numbers stored as Text?
How to write full cheque numbers with missing zeroes?
What is Superscript inside Format Cells?
Basics of formatting tabular datasets
How to format lengthy headings using Wrap Text & Alignment?
How is Format Painter used to copy & paste formats?
How to use Format Painter multiple times?
How to remove all formatting in one click?
Working with Tables
How to color multiple sheet tabs?
How to use Freeze Panes for Rows & Columns at the same time?
Grouping
Gridlines
How to create a simple drop-down list with Data Validation?
How to remove a drop-down list?
How to activate the Developer Tab in 2007-2019 in Excel?
How to create an interactive Spin Button for an Excel Dashboard?
How to create an interactive Scroll Bar for an Excel Dashboard?
7 Tricks of Comments - Basic to Expert
4 Tricks of Hyperlinking - Basic to Expert
How to hide a sheet so that no one can unhide easily?
How to Sort numbers from largest to smallest?
How to Sort text alphabetically (A-Z)?
How to Sort dates oldest to newest?
How to Sort rows by cell color?
Best Practice before you sort any dataset
How to do 2-level Sorting?
The hidden trick of Horizontal Sorting
The hidden trick of Sorting using a custom list
The hidden trick to add a blank row between every row using Sort
Basics of Filter & Calculating SUM on the filter list
The most common mistake Filter users make while choosing datasets
Importance of SUBTOTAL formula in a Filtered dataset
SUBTOTAL formula's confusing parameters - Mystery Solved
Number Filter option in Filter
How to navigate a Filtered dataset using Shortcuts?
How is Advanced Filter different than General Filter?
The hidden trick to apply seprate Filters on two datasets of the same worksheet?
The hiddent trick to paste values on a Filtered dataset
How to use Slicer on a Filtered dataset?
Use of Cell Referencing ($) in formulas - Explained
Why does a Date in Excel looks like a random number?
How to calculate the duration using two dates with timestamp?
Date formulas - DAY, MONTH, YEAR & DATE - Part 1
Date formulas - DAY, MONTH, YEAR & DATE - Part 2
Date formulas - TEXT & WEEKDAY - Part 1
Date formulas - TEXT & WEEKDAY - Part 2
Why is EDATE referred as Expiry Date?
Why is EOMONTH referred as End of Month?
Date formulas - TODAY & NOW with Shortcuts
The hidden trick to rectify dates format using Text to Columns
How to use WORKDAY.INTL formula to calculate project deadline?
How to use NETWORKDAYS.INTL to calculate working days between two dates?
The hidden formula of DATEDIF
How to find the 1st, 3rd and 5th Saturday of any month
Basics of Logical Formula - Part 1
Basics of Logical Formula - Part 2
Basics of Logical Formula - Part 3
Quick Recap of Logical Formulas with advanced exercises
Using multiple Logical formulas - IF, AND, OR in an advanced exercise
Logical Check Formulas for Text, Numbers, & Errors including IFERROR
How to remove duplicate values?
Using UPPER, PROPER, & LOWER formulas to change the case of the texr
Using TRIM formula to remove excess spaces in a sentence
Using VALUE formula to convert numbers stored as text to a number format
Using LEN formula to calculate the number of characters in a cell
Basics of RIGHT, LEFT & MID formulas
SEARCH vs FIND
SEARCH & MID
How to find and delete all the error values at once?
Shortcut to make best use of Go To (Special) technique
How to fill intermittent blank cells using Go To (Special) technique?
Other uses of Ctrl G - Formula, Constants, Visible cells
Using Text to Column feature to split data values - Part 1 (Delimited)
Using Text to Column feature to split data values - Part 2 (Fixed Width)
When is Text to Column feature used to change the Data Format (General, Text)?
How to convert a series of email IDs to a vertical list for Attendance?
How can Text to Columns help in writing correct SUM & VLOOKUP formulas?
Using CONCATENATE and Ampersand (&) to join values
Find & Replace - Part 1 (with Wildcard Character)
Find & Replace - Part 2 (MS Word vs MS Excel)
Quick Recap of Advanced Find & Replace
SUBSTITUTE - the formula version of Find & Replace
FlashFill - Basics to Advanced
Project - FlashFill, T2C, SUBSTITUTE - Bank Data
Project - Electricity Consumption - Method #1
Project - Electricity Consumption - Method #2
Pivot Table (A-Z) Part 1
Pivot Table (A-Z) Part 2
Expert-level Pivot Table Trick using Power Query - Split to Rows
Expert-level Pivot Table Trick using Power Query - Unpivot Column
Basics of VLOOKUP for first time users - Why do we need it?
Basics of VLOOKUP for first time users - fix Table Array using $
Basics of VLOOKUP for first time users - TRUE vs FALSE - Part 1
Basics of VLOOKUP for first time users - TRUE vs FALSE - Part 2
Common mistakes of VLOOKUP users - Why do we get N/A?
How to do inter-worksheet VLOOKUP?
Vlookup vs. Hlookup - Simplified
Using VLOOKUp with TRUE for doing Debtors Ageing Analysis
Using VLOOKUp with TRUE for doing Score Grading
Using VLOOKUp with TRUE for doing Food Quality Grading
Using VLOOKUp with TRUE for calculating correct tax rate as per applicable date
Basics of MATCH formula - Part 1
Basics of MATCH formula - Part 2
How to do 2D Lookup using VLOOKUP & MATCH - Example 1
How to do 2D Lookup using VLOOKUP & MATCH - Example 2
How to do inter-worksheet 2D Lookup using VLOOKUP & MATCH? - Example 1
How to do inter-worksheet 2D Lookup using VLOOKUP & MATCH? - Example 2
LOOKUP vs. VLOOKUP vs. HLOOKUP vs. MATCH
How to do Reverse Lookup using INDEX & MATCH formula - Part 1
How to do Reverse Lookup using INDEX & MATCH formula - Part 2
Exercise | Using INDEX & MATCH formula to do Reverse Lookup
Fuzzy Lookup can do what VLOOKUP can't - Lookup for data with different spelling
Basics of INDIRECT formula
Create a Dashboard from 25+ worksheets using INDIRECT formula
Use VLOOKUP & INDIRECT formula to pull data from multiple sheets
How to do 3D Lookup using VLOOKUP, MATCH, INDIRECT & name ranges?
Basics - Using OFFSET formula to create Dynamic Ranges
Using OFFSET to create dynamic calculations - Part 1 (Intermediate)
Using OFFSET to create dynamic calculations - Part 2 (Advanced)
Basics of COUNTIF formula
Basics of SUMIF formula
Basics of AVERAGEIF formula
COUNTIFS & SUMIFS - Part 1 (Intermediate)
COUNTIFS & SUMIFS - Part 2 (Advanced)
Exercise - Using SUMIFS & COUNTIFS with 3 criteria
Exercise - Using SUMIFS to find sum of values between two dates
Using COUNTIFS to find duplicates and reconcile two lists
The hidden trick of COUNTIFS to calculate running count based on the ID value
The hidden trick of COUNTIFS to do VLOOKUP for duplicate values
The hidden trick of SUMIFS to calculate running sum total based on the ID value
Conditional Formatting - Color cells based on errors, blanks, duplicates, user-defined value
Conditional Formatting - Color cells using Data Bars, Icon Sets, Color Scales
Create a Dashboard for comparing Actual vs Budget using Conditional Formatting
Using Conditional Formatting for changing the cell color based on list value chosen
Formula-based Conditional Formatting - color the entire row based on user-selected value
Formula-based Conditional Formatting - color the cell that matches two user criterias
Formula-based Conditional Formatting - Highlight cells that have prohibited values
Basics of Data Table feature of What-If Analysis
Using Data Table feature of What-If Analysis with INDIRECT formula
Advanced use case of Data Table feature for Loan EMI payments
Limitations of using Scroll Bar & Spin Button
Basics - Using Goal Seek to back-calculate
Basics - Scenario Manager for Best, Worst & Base Case
The hidden trick of Consolidation using SUM for multiple sheets
How to use CONSOLIDATE feature of Excel? - Part 1
How to use CONSOLIDATE feature of Excel? - Part 2
How to use SUBTOTAL feature of Excel using one criteria?
How to use SUBTOTAL feature of Excel using two criteria?
The hidden trick of SUBTOTAL feature & Go To (Special) to merge cells into blocks
Top 10 Printing Tricks & Settings
Level of Password Security - File vs. Sheet vs. Workbook Structure
How to hide a sheet so that no one can unhide easily?
How to remove “Protect sheet” Password with Notepad?
How to remove remove “Protect workbook” Password with Notepad?
The hidden trick to Compare two Excel files
The hidden trick to join cell values without using CONCATENATE
The hidden trick to activate Data Entry Form
How to Copy Text from Image | OneNote Tutorial
PDF to Word Converter | Without Software
Convert "Dr" & "Cr" suffix of Tally dayasets into positive & negative values
Clean-up complex Bank Statement sheet of Borrowers
Analyse payments made to Suppliers using FlashFill, VLOOKUP & Pivot Table
Extract multiple voucher nos. from a cell to create a list
Create a Frequency Distribution of sales ticket size using Pivot Table?
Calculate Stock Revaluation write-off amount using VLOOKUP with TRUE and MATCH
Form 26AS - TDS | What is Form 26AS | Format
PAN Assessee Status - using MID & VLOOKUP
Calculate Sales Commission using advanced SUMIFS and VLOOKUP with TRUE
Allocate sales value of a project to the individual team members
Sales Visualization - without Charts
UNIQUE
Concat & TextJoin
Project - TextJoin & IF
IFS & SWITCH
MAXIFS & MINIFS
Filter
SORT
SORTBY
Sequence
LET
Why do we learn Excel VBA Macros?
How to learn Excel VBA Macros?
How to enable Developer Tab in Excel?
Basics of Developer Tab in Excel
Important Macro Security Settings in Excel
How to save Macros in Excel for future use?
How to create a Macros in Excel?
How to run a Macro in all open Workbooks?
Using a Button to run a Macros in Excel
Running a Macro in different ways in Excel
Understanding VBA Workspace in Excel (Basics)
Watch a Macro being recorded
Searching Google for VBA Codes - using the 3 magic words
Searching Google for VBA Codes - in Blogs vs Forum
Duration
5:44
5:28
4:52
4:59
2:47
1:39
2:12
4:21
4:46
1:50
4:15
6:32 This Course Includes:
2:44 19 hours of on-demand Hindi video
2:04 220+ HD Videos
1:44 Excel Mastery eBook
3:50 Practice files | Certificate of completion
3:17 Get 2-Year Access
2:25
3:12
2:58 ENROLL NOW
2:30
1:57
3:47
4:57
3:12
4:36
4:09
3:28
2:35
3:27
1:30
3:25
2:42
2:40
3:01
2:54
2:50
1:39
4:46
3:14
0:33
3:33
2:01
 3:14
4:33
3:42
7:41
6:24
3:56
3:08
1:53
2:07
1:51
2:20
2:28
4:32
4:04
3:16
3:14
1:57
4:50
4:52
3:29
2:50
8:07
1:30
3:42
2:41
6:54
4:23
3:40
1:39
1:39
4:31
1:52
4:36
3:57
1:55
6:26
3:17
3:34
4:07
6:08
3:10
5:16
4:28
12:31
9:16
 4:41
3:41
2:15
1:22
2:34
1:10
3:56
5:05
5:59
2:39
2:03
5:08
3:09
4:52
5:24
4:58
4:10
4:49
3:05
8:12
7:44
7:36
2:26
6:00
8:45
7:21
10:51
27:37:00
3:07
7:15
13:32
6:55
5:44
7:28
5:42
5:56
8:36
4:20
6:34
5:16
4:00
5:35
5:11
4:24
6:33
 5:26
7:51
6:48
8:51
5:02
6:29
5:51
4:04
9:26
10:19
4:12
7:49
6:55
9:22
10:51
3:32
4:20
3:27
11:17
8:57
11:32
6:02
3:22
7:56
6:21
7:01
6:17
3:03
7:48
2:38
7:08
7:57
4:05
11:37
16:47
6:56
7:56
6:12
5:40
4:02
9:19
10:32
7:28
8:38
8:52
11:02
7:52
3:56
6:37
4:38
3:01
0:59
2:12
2:08
3:26
6:08
9:26
8:57
7:10
3:07
10:04
7:41
1:46
13:00
9:52
7:55
3:38
4:47
8:44
7:05
4:06
5:00
6:24
2:14
2:04
2:37
4:49
1:46
2:04
1:06
2:16
3:50
5:54
2:06
3:00
4:40
3:00
2:12
8:13
6:49