Most Popular Excel Tips

250 Excel Keyboard Shortcuts...

Microsoft Excel having so many unbelievable capabilities that are not instantly perceived. Excel Shortcut keys are most usef...

Industry Statistics Dashboard in Microsoft Excel...

About Dashboard: In day to day life when we talk of business, analysis is very important factor to run business successfully. Analysis help...

Trim Function in Microsoft Excel 2010...

In this article we will learn how to delete the unnecessary blank character from a cell, we will use “TRIM” function in Microsoft Excel ...

Calculating the Difference Between Hours...

To calculate an employee's working hours: Enter the following formula into a cell: =D4-C4+IF(C4D4,1) The number 1 in the IF formula e...

Changing the Default Date Separator from a Slash ...

Excel recognizes a number as a date by its date format, which uses a slash (/) as a separator, for example, 1/25/2004 is recognized as a dat...

Add Combo Box to a Sheet in Microsoft Excel 2010...

Excel Combo box is used to create a drop down list of selected items as per the choices required. There are 2 types of Combo boxes - 1st is ...

Best combination of Multiple Dashboards which cove...

Created by: kbryant414   Finance Dashboard:-It is used to present the fiscal performance. This dashboard is used to show how much rev...

Export data from Excel to Access (ADO) using VBA i...

We can export the data from Microsoft Excel to Microsoft Access by using VBA. Below is the VBA code and process which you need to paste in t...

Top 30 Microsoft Excel Interview Questions...

Interviews are challenging. Job interviews that require any sort of tracking data or simple calculations are even trickier, as this would re...

Extract the first, middle and last name in Excel 2...

To extract the first, middle and last name we use the formulas “LEFT”, “RIGHT”, “MID”, “LEN”, and “SEARCH” in Excel. ...

Converting Time to Decimal Values...

This article will convert current local time in (UTC/GMT) - World Time Zone Use the HOUR and MINUTE formulas to extract the hour and minu...

The Best Shortcut Keys in Microsoft Excel...

If you are using Microsoft Excel in your daily life, you can use excel shortcuts to save time. While preparing any report or dashboard, if w...

Sales Performance Dashboard by Haseeb A...

Created by: Haseeb A   About Dashboard: Sales performance dashboard is useful to analyze the performance of sales. By using the sale...

Add space between characters and numbers in Micros...

In this article we will learn how to add space between character and numbers in Microsoft Excel 2010. To understand how to add space betwee...

Calculate Minutes Between Date & Time In Microsoft...

While working with time and dates in excel, you frequently get the need to calculate hours, minutes and seconds between two timestamps. ...

Calculating Number of Days, Months and Years betwe...

While working on Excel, Sometimes you need to calculate the number of Days, Months and Years between the two given dates. To calculate th...

How to Calculate VAT in Excel...

In this article you will learn how to calculate VAT in Excel by using a functions? And Which formula we can use to calculate how much VAT ha...

Filtering a List into Unique Records Using the COU...

If you have a range of values which contain duplicates, we have an interesting way of filtering for these duplicate values. This is one of t...

Countifs Multiple Criteria in Microsoft Excel...

To count based on multiple criteria we use  COUNTIFS function in Microsoft Excel. Excel function COUNTIFS  is used to count the entries...

Add
Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube