Lesson#168: How to analyze employee database with PivotTable
Ok readers! How are you? Today I brought a lesson on how to analyze employee database …
Lesson#168: How to analyze employee database with PivotTable Read more →
Lesson#167:11 tips to work like Pro in Excel
Are you an Excel user? If so, check out these 11 tips to work like a …
Lesson#166: Why Microsoft Excel Is Still the Most Useful Software?
Excel is one of the most useful and underrated pieces of software out there. Yes, it …
Lesson#166: Why Microsoft Excel Is Still the Most Useful Software? Read more →
Lesson#165: What is the Excel UNIQUE function?
Excel UNIQUE function has been recently introduced by Microsoft. It’s a very good function and method …
Lesson#164: How to easily create a mail merge in Word from Excel – step by step
Hello friends! I hope you all are very well. Today we shall go a little outside …
Lesson#164: How to easily create a mail merge in Word from Excel – step by step Read more →
Lesson#163: 6 new excel formulas must know in 2022
Microsoft Excel has introduced some new functions in 2022. Here are 6 of the new excel …
Lesson#163: 6 new excel formulas must know in 2022 Read more →
Lesson#162: What are TEXTBEFORE and TEXTAFTER functions in Excel?
Microsoft Excel has introduced some new functions in 2022. Two of them are the Excel TEXTBEFORE and …
Lesson#162: What are TEXTBEFORE and TEXTAFTER functions in Excel? Read more →
Lesson#161: How to remove duplicates in Excel? | 5 ways to delete duplicates in Excel
Maximum Microsoft Excel users frequently ask this question about Excel. One of the most asked questions …
Lesson#161: How to remove duplicates in Excel? | 5 ways to delete duplicates in Excel Read more →
Lesson#160: How to use INDEX and MATCH? | INDEX-MATCH vs VLOOKUP
In this post, I am going to discuss on INDEX – MATCH combination. How can we …
Lesson#160: How to use INDEX and MATCH? | INDEX-MATCH vs VLOOKUP Read more →
Lesson#159: What is Excel function TEXTSPLIT? TEXTSPLIT vs TEXTJOIN comparison.
Microsoft Excel has introduced some new functions in 2022. One of them is the Excel TEXTSPLIT …
Lesson#159: What is Excel function TEXTSPLIT? TEXTSPLIT vs TEXTJOIN comparison. Read more →