Ok readers! How are you? Today I brought a lesson on how to analyze employee database with PivotTable. Here I have a company database with records of 1,000 employees. Employee ID, Job Title, Department, Business Unit, Gender, Salary, and other …
Lesson#168: How to analyze employee database with PivotTable Read more →
Are you an Excel user? If so, check out these 11 tips to work like a pro in Excel! Get to know the keyboard shortcuts. Get to know the keyboard shortcuts. They will help you work faster and more efficiently …
Excel is one of the most useful and underrated pieces of software out there. Yes, it might not have the glitz and glamor of some of the newer programs on the market, but trust me when I say that Excel …
Lesson#166: Why Microsoft Excel Is Still the Most Useful Software? Read more →
Excel UNIQUE function has been recently introduced by Microsoft. It’s a very good function and method to remove duplicate values in Excel. So in this post, we shall discuss the function and I shall show you some examples. What is …
Hello friends! I hope you all are very well. Today we shall go a little outside of Microsoft Excel. Don’t be disappointed, and I am talking about the brother of Excel, Mr. Word. Yes, I am going to discuss the …
Lesson#164: How to easily create a mail merge in Word from Excel – step by step Read more →
Microsoft Excel has introduced some new functions in 2022. Here are 6 of the new excel formulas among all of them. Today I shall discuss 6 new Excel lookup and reference functions CHOOSECOLS, CHOOSEROWS, HSTACK, VSTACK, DROP and TAKE. What …
Lesson#163: 6 new excel formulas must know in 2022 Read more →
Microsoft Excel has introduced some new functions in 2022. Two of them are the Excel TEXTBEFORE and TEXTAFTER functions. What is TEXTBEFORE function? Excel TEXTBEFORE function Returns text that occurs before a given character or string. Syntax TEXTBEFORE(text,delimiter,[instance_num], [match_mode], [match_end], [if_not_found]) …
Lesson#162: What are TEXTBEFORE and TEXTAFTER functions in Excel? Read more →
Maximum Microsoft Excel users frequently ask this question about Excel. One of the most asked questions about Excel is, “How to remove duplicates in Excel?” or “How to delete duplicates in Excel?” or “How do I delete duplicates in Excel …
Lesson#161: How to remove duplicates in Excel? | 5 ways to delete duplicates in Excel Read more →
In this post, I am going to discuss on INDEX – MATCH combination. How can we make an efficient lookup function combining these two functions? I shall also discuss the comparison of INDEX – MATCH with VLOOKUP. What is the …
Lesson#160: How to use INDEX and MATCH? | INDEX-MATCH vs VLOOKUP Read more →
Microsoft Excel has introduced some new functions in 2022. One of them is the Excel TEXTSPLIT function. What is the TEXTSPLIT function? This function works like the Text to Column feature in Excel. This feature splits texts across columns or down …
Lesson#159: What is Excel function TEXTSPLIT? TEXTSPLIT vs TEXTJOIN comparison. Read more →