Remove Duplicate In Excel | Easy Problem Solving

Did you ever come across a situation wherein, you see a lot of copied data or duplicates in excel and you don’t even remember copying it. Well, it happens with all of us at some point in time and finding and removing such copied data in your spreadsheet will take up a lot of time. So instead use the following tricks for finding and removing duplicates.


Advance Microsoft Excel
Microsoft Excel Is Great Spread Sheet Based Software
S.No Particulars
1 Intro To Mircrosoft Excel
2 Excel Screen Parts
3 Let's Start Home Tab
4 Selection In Microsoft Excel
5 Font Group In Microsoft Excel
6 Alignment Group
7 Number Group
8 Styles
9 Table Tools ,Design Tab
10 Cell Styles
11 Cells Group
12 Editing Section
13 Formulas Introduction In Excel
14 Using Autosum
15 Using Insert Function
16 Avg , Min , Max , If Function
17 Fill Options In Excel
18 Fill Options With Dates , Number
19 Sort And Filter In Excel
20 Find And Select In Excel


S.No Particulars
1 Using Autosum
2 Using Insert Function
3 Avg , Min , Max , If Function
4 Basics Of Functions And Formulas
5 Use Of Insert Function
6 How To Type Formulas
7 Basics Of Formulas
8 Total On Status Bar
Financial Formulas
9 Rate Function (Using Loan Installments Example)
10 Pmt Function (Using Monthly Repayment Example)
11 Future Value Function (Using Deposit Amount Example)
12 Nper Function ( Using Loan Time Calculation Example)
13 Db Function (Depriciation Calculation Example)
Logical Formulas
14 Logical If (Using Result Example)
15 Logical And (Using Age Example)
16 Logical If & And (Using Age Example)
17 Logical Combined If & And (Using Age Example)
18 Logical Or (Using Test Example)
19 Logical If & Or (Using Age Example)
20 Logical Combined If & Or (Using Age Example)
Text Formulas
21 Trim Formula(Remove Extra Spaces Example)
22 Left Formula(Using In Extract Left Characters)
23 Right Formula(Using In Extract Right Characters)
24 Replace Formula( Using Character Removing Example)
25 Mid Formula (With Character Extractor Example)
26 Concatenate Function( With Text Joining Example)
27 Upper Function ( Use To Uppercase Characters)
28 Upper And Concatenate
29 Find Function
30 Left And Find Function( Use To Seprate Names)
Date Formulas
31 How To Set Date Formats
32 Date Function
33 Days 360 (Using Library Record Example)
34 Now Function
35 Day Function
36 Month Function
37 Year Function
38 Hour Function
39 Minute Function
40 Networkdays (To Count Networking Days )
Lookup Formulas
41 Vlookup Formula ( With Exact Match Example)
42 Vlookup Formula ( With Approximate Example)
43 Vlookup Range Acceptance
44 Hlookup Formula
45 Match Formula
46 Index Formula
47 Index And Match Formula Together
48 Transpose (Rows To Columns)
Maths And Trignomatery
49 Abs Function
50 .
51 Power Function
52 Fact Function
53 Rand Function
54 Rand With Range
55 Ranbetween
56 Sumif(Using Number As Condition)
57 Sumif(Using Character As Condtion)
More Functions

1 Defined Names And Using Name Manager
2 Formula Auditing
3 Calculaton Group


S.No Particulars
1 Get External Data Group
2 From Access
3 From Web
4 Connections Group
5 Sort And Filter-Sort Options
6 Sort And Filter-Filter Options
7 Advance Filter Options
8 Data Tools
9 Outline Group




Insert Tab


S.No Particulars
1 Pivot Tables And Its Options
2 Table And Its Options
3 Charts And Its Options
4 Sparklines And Its Options
5 Filter Slicer
6 Links
7 Text Options
8 Symbols Group



Pagelayout Tab
S.No Particulars
1 Themes Group
2 Page Setup Group Settings In Excel
3 Orientation
4 Scale To Fit
5 Sheet Options
6 Arrange


Review Tab
S.No Particulars
1 Proffing
2 Language
3 Comment
4 Changes Group With Password Protection



View Tab
S.No Particulars
1 Workbook Views
2 Show Group
3 Zoom Group
4 Window Group
5 Macros Group In Excel