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 »
Here I will make you learn another good and easy feature of Excel, Remove Duplicates. In this post, you will learn how to Remove Duplicates in Excel works and when and why to use them. See the above picture I …
Lesson#136: Learn how to Remove Duplicates works Read more »
Here I am having an example to show you the Paste Special with skip blanks in Excel. Serials are incomplete in both columns. In column A even numbers are absent and in column B odd numbers are absent. If you …
Lesson#130: Paste Special with skip blanks in Excel Read more »
Hello friend! I am going to share some information about Formula Auditing in Microsoft Excel. In the Formula ribbon, you can get a group of features named Formula Auditing. It includes Trace Precedents Trace Dependents Remove Arrows Show Formulas Error …
Lesson#129: An overview of Formula Auditing in Excel Read more »
Excel doesn’t accept formatting cells that are protected if they aren’t allowed for users. To format unprotected or protected cells users must allow them before protecting a sheet. When you are protecting a sheet just see these options. The third …
Lesson#122: Cell formatting in a protected sheet in Excel Read more »
OK, I am having a sheet here which calculates the age when the birth date is provided. I need to protect the sheet before giving it to users. So none of them change the structure or formula. But I also …
Lesson#121: How to make some cells unprotected when protecting a sheet Read more »
Have you seen this Conditional Formatting option – Format only cells that contain? If not then you must remember that this option makes many works of yours easier with Conditional Formatting. Then you need to go to Conditional Formatting>New Rule Then …
Lesson#118: Format only cells that contain Conditional Formatting Read more »
This post will teach you the basic concept of Name Manager. Here I will show how to name a range in excel. You can also create names for the range, reference, or formula to work in the spreadsheet easily. Above …
Here I will share general tips about Conditional Formatting and some Information functions. These functions are ISBLANK, ISERR, ISERROR, ISEVEN, ISFORMULA, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT. You can use these functions to highlight the specified types of values among an array. ISBLANK function highlights blank cells among an array of …
Lesson#115: Information functions with Conditional Formatting Read more »
I will show you how to highlight cells with errors among an array of values. Here I am having an array of values and among them, I have some cells which contain errors. If you need to highlight those cells …
Lesson#113: How to highlight cells with errors in it Read more »