How to Create a Combo Chart in Excel
A combo chart in Excel displays two chart types (such as column and line) on the same chart. They are used to show different types of information on a single chart, such as actuals against a target.
How to Switch to Editing Mode in Excel
When opening Excel spreadsheets from unknown sources, a feature in Excel called Protected View shields you from potential risks. This is great, but to work on the document, you will need to switch to editing mode....
How to Work with Trendlines in Microsoft Excel Charts
You can add a trendline to a chart in Excel to show the general pattern of data over time. You can also extend trendlines to forecast future data. Excel makes it easy to do all of this.
How to Enter Zero Before a Number in Excel
When entering numbers into Excel, zeros at the beginning of the number are removed. This can be an issue when entering phone numbers and IDs. In this article, we will cover ways to solve this problem and keep the leading ze...
How to Cross Reference Cells Between Microsoft Excel Spreadsheets
In Microsoft Excel, it’s a common task to refer to cells on other worksheets or even in different Excel files. At first, this can seem a little daunting and confusing, but once you understand how it works, it’s no...
How to Save Time with Excel Themes
An Excel theme is a collection of colors, fonts, and effects that you can apply to a workbook with a couple of clicks. Themes ensure a consistent and professional look to your reports, and they let you more easily adhere to ...
How to Combine or Group Pie Charts in Microsoft Excel
Pie charts are popular in Excel, but they are limited. You’ll have to decide for yourself between using multiple pie charts or giving up some flexibility in favor of readability by combining them. If you do want to com...
How to Convert Text to Date Values in Microsoft Excel
Analysis of business data often requires working with date values in Excel to answer questions such as “how much money did we make today” or “how does this compare to the same day last week?” And that ...
How to Get Microsoft Excel to Calculate Uncertainty
There is doubt surrounding the accuracy of most statistical data—even when following procedures and using efficient equipment to test. Excel lets you calculate uncertainty based on your sample’s standard deviation...
How to Use Text to Columns Like an Excel Pro
Excel’s Text to Columns feature splits text in a cell into multiple columns. This simple task can save a user the heartache of manually separating the text in a cell into several columns.
How to Calculate Percentage Change with Pivot Tables in Excel
Pivot Tables are an amazing built-in reporting tool in Excel. While typically used to summarize data with totals, you can also use them to calculate the percentage of change between values. Even better: It is simple to do....
How to Use VLOOKUP on a Range of Values
VLOOKUP is one of Excel’s most well-known functions. You’ll typically use it to look up exact matches, such as the ID of products or customers, but in this article, we’ll explore how to use VLOOKUP with a ra...
How to Use Logical Functions in Excel: IF, AND, OR, XOR, NOT
Logical functions are some of the most popular and useful in Excel. They can test values in other cells and perform actions dependent upon the result of the test. This helps us to automate tasks in our spreadsheets....
How to Create a Radar Chart in Excel
A radar chart compares the values of three or more variables relative to a central point. It’s useful when you cannot directly compare the variables and is especially great for visualizing performance analysis or surv...
How to Change How Excel Displays Negative Numbers
Microsoft Excel displays negative numbers with a leading minus sign by default. It is good practice to make negative numbers easy to identify, and if you’re not content with this default, Excel provides a few different ...
How (and Why) to Use the Outliers Function in Excel
An outlier is a value that is significantly higher or lower than most of the values in your data. When using Excel to analyze data, outliers can skew the results. For example, the mean average of a data set might truly refle...
