Subtotal feature in Excel
In this article, you will learn about the Subtotal feature of Microsoft Excel. Excel can organize data in groups, allowing you to easily show and hide different sections of your
Excel Tips and Tricks
This category offers a collection of tips and tricks to help you master Excel and work more efficiently. From keyboard shortcuts to advanced formulas and functions, our tutorials cover a range of topics to help you save time and simplify your work. Each tutorial comes with a free practice file for download and tutorial videos to help you understand the concepts better. Start exploring this category now and take your Excel skills to the next level. Impress your colleagues and boss with your proficiency in Excel by exploring this category today.
Progress Bar in Excel Cells using Conditional Formatting
In this article, you will learn how to display the Progress Bar in Excel Cells. We have used Conditional Formatting Data Bar to create this. chart will be filled according
Search Text from Specific or all columns in Excel
In this article, you will learn how to use Advanced Conditional Formatting to search text in data. Here we have taken the example for employee Performance rating data. We two
Auto Bullet Points in Excel
In this article, you will learn how to add Auto Bullet Points in Excel using Custom formatting. To add the auto bullet point in excel range below are the steps-
Apply Same Format on other Charts
In this article, you will learn how to apply the Same Chart Format on the other Charts. Let’s say we have month-wise sales data chart and we do some formatting
Show Hidden/Collapsed Cells data on the Chart
In this article, you will learn how to display Show Hidden/Collapsed Cells data on the chart. if we create a chart for month wise sales and hide or collapse few
Quick Re-Arrange Columns Sequence Using Data Sorting
In this article, you will learn how to sort the data by columns. If you have multiple columns in your excel sheet and you want to arrange the order of
Dynamic Number Format for Millions and Thousands
Many times, when we create a chart and our numbers are quite big then our data labels on the chart are not proper readable. In that case we can change
Highlight and get birthdays count from Date of Birth
In this article, you will learn how to get count of persons from a Date of Birth data whose birthdays are in the specific month. You will also learn how
Insert a picture in Excel Comments
In this article, you will learn how to Insert a picture in Excel comments. Here I have taken the example for my popular Dashboards which are freely available to download.