Excel® Tips and Tricks

Category: Excel®

Get the best in Excel® training anytime, anywhere.

Get Excel® Training

How to Create a Custom Function in Excel





Categories: Excel®, Functions

Excel functions are actually shortcuts to more complex calculations. Like a macro is to a series of steps, a function is to a longer equation. While Excel is packed full of functions, you may find that you have proprietary formulas that you use regularly that would be useful as a function shortcut. Advanced Excel users […]

Read More

Conditional Formatting Across Multiple Cells in Excel





Categories: Conditional Formatting, Excel®

Steps in this article will apply to Excel 2007-2016. Images were taken using Excel 2016. Conditional formatting is a useful Excel feature that can help you quickly scan your data without resorting to complicated filtering or fussy charts. Often, you will use conditional formatting to call attention to cells that represent an outlying condition – […]

Read More

Nesting Functions in Excel – A Tutorial for Beginners





Categories: Excel®, Functions

Most of us begin using Excel by creating simple worksheets that organize data and perform simple calculations. Then, we might dabble with some of Excel’s many pre-set functions for more complex calculations. You know you’re a real Excel addict, however, when you start thinking How can I crunch my data even more efficiently? This means […]

Read More

Excel Conditional Formatting: Date Data





Categories: Conditional Formatting, Excel®

Turning your cluttered spreadsheet of data into living, actionable information can be as simple as adding visual cues. Unless you are really good at doing date calculations in your head, conditional formatting is especially helpful when determining ages or anticipating birthdays and anniversaries. The following steps show how to perform a common Human Resources task: […]

Read More

Save Time With Our Excel Formulas Cheat Sheet





Categories: Excel®, Formulas, Functions

Syntax, Operators and Functions…Oh My! Do you speak Excel? Are you just starting out and trying to remember the go-to lingo? Well, today’s blog post is a snapshot of helpful cheat sheet material to help you build your Excel skills. Advanced Filter Criteria Popular Excel Functions and Descriptions Next Steps As you continue working in […]

Read More

Get the Most Out of Excel’s Conditional Formatting





Categories: Excel®

As a continuation of our post last week, we decided to expand on some great uses from conditional formatting. Highlighting negative values in red and using several built-in conditions is great when you are starting out, but you are not getting nearly enough bang for your buck! Here are three ways to get more out […]

Read More

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