How to Lock a Pivot Table in Excel
When working with Excel, you may find yourself using pivot tables to organize and analyze your data more efficiently. However, there might be instances where you want to lock and …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
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 …
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
When you have two or more PivotTables built from the same data, you usually want them to filter together. Click one slicer button, and every report on the sheet changes …
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 …