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

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. LEFT: Returns the fi...

Ignoring Blank Cells when Performing Calculations...

While performing the calculation to ignore the blank cells we will use ISNUMBER, AND and IF formulas in Microsoft Excel.  ISNUMBER: This f...

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

How To Return Value In Another Cell If A Cell Cont...

In this article, we will learn How to look up cells having certain text and return the Certain Text in Excel. Scenario : Identify ...

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

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

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

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

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

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.