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...

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...

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...

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...

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. ...

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...

Calculate number of minutes between dates & time i...

In this article we will learn about how to Calculate Number of Minutes between Dates and Time in Microsoft Excel 2010. To calculate the n...

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...

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...

Calculating Number of Days, Weeks, Months and Year...

In this article you’ll learn, how to calculate number of days, weeks, months and years between 2 dates in Microsoft Excel. To calculate 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...

Copying a Formula from a Cell While Keeping the Ab...

Avoid the nightmare of pressing F4 multiple times when coping and pasting formulas! To copy/paste a Formula without changing the Absolute...

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