Excel® Tips and Tricks

Category: Excel®

Get the best in Excel® training anytime, anywhere.

Get Excel® Training

Highlight Valuable Data With Excel Conditional Formulas





Categories: Excel®

You can conditionally format your data in order to draw attention to outliers and quickly assess how significant your data points are. Conditional formatting can be used to highlight interesting cells, emphasize unusual values, and visualize data using data bars, color scales, and icon sets based on specific criteria. Excel has several built in conditions […]

Read More

How to Export Excel Spreadsheets to Word





Categories: Excel®

Excel lives up to its name when crunching numbers or organizing data. However, when you want to convey ideas beyond the table or graph, you will almost certainly turn to Word or PowerPoint. In the examples below, we are going to look at several different ways you can export, or incorporate, spreadsheets into your Word […]

Read More

Tips for Data Management in Excel





Categories: Excel®

Becoming an Excel expert is more than learning functions and cobbling together formulas. A significant part of using Excel to its full potential is knowing the art of data management. This includes everything from knowing how to set up your worksheets to managing data entry to good maintenance practices.  Here are several tips to good […]

Read More

Excel What-if Analysis: Goal Seek





Categories: Excel®

Ever find yourself wondering if Excel could help you answer the question: “What values would I need to get a known result?” The What-if Analysis features, available in Excel 2010 and up, give you the tools to do just that. Unlike functions and formulas that take given values and return a result, what-if scenarios allow […]

Read More

Excel What-if Analysis: Scenarios





Categories: Excel®

If you think of Excel as just a database for storing dead data, you will be pleasantly surprised to learn about Excel’s What-if analysis tools. Excel offers several features that allow a user to make predictions, or evaluate outcomes based upon variable inputs. In this article, we are going to look at Scenarios. What is […]

Read More

Excel Macro Tutorial for Beginners





Categories: Excel®, Macros

To follow using our example, download MacrosForBeginners.xlsx Once you get comfortable navigating Excel, it won’t be long before you start to hear about this wondrous feature called a “Macro” that can  leap tall projects with a single keystroke and make boring tasks go by faster than a speeding bullet. While Macros aren’t really the superman […]

Read More

How to Calculate Median in an Excel PivotTable – Almost!





Categories: Excel®, Pivot Tables

A frequent question that comes up when working with Excel PivotTables is how to calculate median using the table’s filters and analysis. The short answer is “Excel doesn’t do that”. Meaning, there isn’t a simple way to change the Value Field Settings to calculate “Median”. The closest you can get is “Average”. However, averages aren’t […]

Read More