## How to Make Interactive Dashboard in Excel ðŸ“Š

Video Tutorial ï»¿ Download Excel File More Excel Projects

## How to Compare Two Columns in Excel to Find Differences

Do you want to compare two columns in Excel? If yes, then the embedded video below is for you. In it, I explain how you can show a right tick or a cross tick if the data matches or not in an Excel cell. We have used the IF formula and conditional formatting to solve … Read more

## How to Build Mobile Apps that Excel at Customer Experience?

Did you know global app downloads reached 257 billion, increasing one percent year-over-year? Mobile applications are taking the world by storm. Individuals are developing more interest in using smartphones and mobile applications, thus influencing businesses to change their approaches. Also, many companies are shifting to mobile apps that help them reach their potential audiences. The … Read more

## 8-Ways to Convert Numbers into Words in Excel | Convert Amount to Words in Excel

Converting Amounts in Words in Excel is not an easy task, Excel does not have the inbuilt function to convert any number into words, that is why we have to add external VBA codes to our file to convert any number into words. In this article, i have given 8Â Methods to convert your values into … Read more

## Download Weekly Employee Time Sheet Template in Excel

Video Tutorial ï»¿ Download Excel File More Excel Projects

## How to Apply Vlookup in Skipped Rows !!

One of my subscribers attended an interview for an MIS Executive position, and the interviewer asked him a question. He was given an Excel sheet and instructed to apply VLOOKUP to alternate rows, meaning some rows contain data while others do not. He needed to pull data for the blank rows from another sheet using … Read more

## Excel Filter Dropdown Not Working (here is the Problem’s Solution)

If you are applying Filter in Your data in Excel, but filter is not working in your excel file, then here in the below video i have provided a best solution for it. You have to change the pattern of applying the filter. you just need to select your all data first then apply filter … Read more

## How to Sum in Date Range in Excel Sumifs Formula & EOmonth Formula

Tutorial Video ï»¿ï»¿ Download Excel File More Excel Projects

## Making Stock Sheet with Re-Order Alert in Excel (Sale, Purchase, Closing Stock)

Tutorial Video ï»¿ Download Excel File More Excel Projects

## How to Sum Values in Excel, if Multiple Values are given in 1 cell

Tutorial Video ï»¿ Download Excel File More Excel Projects

## Attendance Formula Sheet in Excel (Overtime, Leave, Half Day, Present, Absent)

Tutorial Video ï»¿ Download Excel File More Excel Projects

## Offset Formula with Match Formula in Excel

The OFFSET formula in Excel is a powerful tool for creating dynamic references within your spreadsheets. Here’s a breakdown of what it does: Purpose of Offset Formula in Excel It takes a starting cell (reference) as input and then lets you specify how many rows and columns you want to move (offset) from that cell. … Read more