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-
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.
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.
Arrows Symbols (➷➹) with Custom Formatting in Excel
Custom formatting is very useful in Excel. You can display some Icon with colors with the numbers. Here we have taken an example wherein we have displayed designer up/down Arrows
Highlight Unmatched Cells using Conditional Formatting in Excel
In this article you will learn how to Highlight Unmatched Cells Cells values from another range using Conditional formatting. For Example, we have Sales and Product Master worksheets. In the
Highlight the Consecutive Duplicates in Excel
In this article you will learn how to highlight the Consecutive Duplicates in Excel using Conditional Formatting. You will also learn how to highlight consecutive weekly off in an Attendance