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 …
Steve Scott
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 Create Bubble Chart in Excel
When we create Excel charts, we have to make them more engaging to users. Bubble charts are such attractive chart types to show complex data. When we use different bubble …
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 …
Get Text to Fit in Cell in Excel
When we work in Excel, the cell content does not always fit the cell size. In such situations, some options available to us include text wrapping, changing the row height …
How to Calculate Standard Deviation in Excel?
Standard Deviation is one of the best measures in statistics to find the spread of a distribution. As it is very common to do statistical calculations in Microsoft Excel, it …