Count Days from a Date to Today in Excel (Formula)
Counting the number of days from a given date to today is a very common thing in life. When we need to know the age of a newborn baby, the …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
How to Convert Date to Quarter in Excel
Converting dates to quarters in Excel has several benefits. For instance, it can come in handy while dealing with financial or sales data, enabling you to analyze performance quarterly. This …
Convert Latitude Longitude to Decimal Degrees in Excel
Have you encountered an Excel dataset with latitude and longitude values in DMS (Degrees, Minutes, Seconds) format? It can be challenging to handle, but don’t worry! There are methods to convert …
Change Count to Sum in Excel Pivot Table
As you work with PivotTables in Excel, sometimes you may need to change the summary function from the “Count” function that counts the number of non-empty values in a field …
Check If Value is in List in Excel
Sometimes we need to do some data validations when we are analyzing a large data set. For example, we need to check whether or not certain values are in the …
How to Create QR Codes in Excel?
Quick Response (QR) codes can be used in Excel to share information or to access data stored in an Excel spreadsheet quickly. However, Excel does not have a built-in feature to …
How to Calculate Ratio in Excel?
When doing financial analysis, it is common to calculate ratios in Excel. We need to find ratios not just in financial analysis but also in many other situations (such as …
Change Cell Color Based on Value of Another Cell in Excel
In Excel, you can change the cell color based on the value of another cell using conditional formatting. For example, you can highlight the names of sales reps in column …
How to Calculate Elapsed Time in Excel
Calculating the elapsed time is something we all do daily. We’ve seen elapsed time calculations in sports, competitions, tasks, travel, etc. Since Excel stores time values as numbers in the …
How to Connect Slicer to Multiple Pivot Tables
Excel Pivot Tables help us to analyze a large set of data in a matter of seconds. We can apply slicers to Pivot Tables and filter our data based on …
How to Change Data Source in Pivot Table
Pivot Tables are a very useful feature in Excel to analyze and summarize data. Sometimes we need to change the data sources of our Pivot Tables as we have added …
Separate Comma Separated Values in Excel
Comma Separated Values (CSV) data format is quite common and you will often find yourself working with this kind of data in Excel. In such cases, you may want to …