How to Add a Trendline in Excel Charts?
A trendline, also known as the ‘line of best fit‘ is an important visual tool in data analytics. It is a straight (or curved) line that helps us understand data …
Steve Scott
How to Delete/Remove Checkbox in Excel?
Checkboxes provide an easy way to get yes/no type inputs from the user quickly. However, you might struggle while trying to delete these checkboxes (especially when you got multiple checkboxes …
Get Unique Values from a Column in Excel
Unique values are those that appear on a list just once. When working with data in Excel, you will often come across datasets that have duplicates in the column and …
How to Merge Two Excel Files?
Accessing data from multiple Excel files can be time-consuming and hard. You often have to switch between multiple open windows, it’s messy and you feel like there’s data all over …
How to Delete a Pivot Table in Excel?
Pivot tables are great analytical tools that help you sort, organize and summarize data. However, they can hamper the performance of your workbook if overused, or if you have a …
SetFocus in Excel VBA – How to Use it?
User forms in Excel usually have a particular ‘tab order’ that automatically navigates you to a given control as and when you enter data. However, sometimes you might want to …
Weighted Average Formula In Excel (Examples)
You might come across some data distributions where different quantities carry different levels of importance (or weightage). A standard average is not really a good representation of such distributions, since …
How to Separate Names in Excel
Performing operations on names like search, sort, filter, etc. is usually easier when full names are separated into separate columns. In fact, separating names is such a frequently performed data …
How to Break Links To External References in Excel?
Often when you inherit Excel files from other people, they can have links to other external Excel files and ranges. Many times, you don’t need to keep these links to …
Compound Interest Formula in Excel
Compound interest is a concept heavily used by the banking and finance industry. If you’re investing or saving money in a bank, Compound Interest is the magical formula that is …
How to Calculate Percentage Difference in Excel (Formulas)
The term ‘percentage difference’ is often misunderstood. A lot of people get mixed up between the terms ‘percentage difference’ and ‘percentage change’. Both are completely different concepts and have completely …
How to Create a Waterfall Chart in Excel?
Waterfall Charts are a popular mode of visualization, especially when it comes to analyzing and understanding change. They are known by different names like McKinsey Charts, Cascade Charts, and even …