Lesson#169: What are the 4 most commonly used charts in Excel?
Excel is a powerful tool for data analysis and visualization. Charts and graphs can be used …
Lesson#169: What are the 4 most commonly used charts in Excel? Read more →
Excel Features
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#136: Learn how to Remove Duplicates works
Here I will make you learn another good and easy feature of Excel, Remove Duplicates. In …
Lesson#136: Learn how to Remove Duplicates works Read more →
Lesson#130: Paste Special with skip blanks in Excel
Here I am having an example to show you the Paste Special with skip blanks in …
Lesson#130: Paste Special with skip blanks in Excel Read more →
Lesson#129: An overview of Formula Auditing in Excel
Hello friend! I am going to share some information about Formula Auditing in Microsoft Excel. In …
Lesson#129: An overview of Formula Auditing in Excel Read more →
Lesson#122: Cell formatting in a protected sheet in Excel
Excel doesn’t accept formatting cells that are protected if they aren’t allowed for users. To format …
Lesson#122: Cell formatting in a protected sheet in Excel Read more →
Lesson#121: How to make some cells unprotected when protecting a sheet
OK, I am having a sheet here which calculates the age when the birth date is …
Lesson#121: How to make some cells unprotected when protecting a sheet Read more →
Lesson#118: Format only cells that contain Conditional Formatting
Have you seen this Conditional Formatting option – Format only cells that contain? If not then you …
Lesson#118: Format only cells that contain Conditional Formatting Read more →
Lesson#116: How to name a range in excel
This post will teach you the basic concept of Name Manager. Here I will show how …
Lesson#115: Information functions with Conditional Formatting
Here I will share general tips about Conditional Formatting and some Information functions. These functions are …
Lesson#115: Information functions with Conditional Formatting Read more →