Excel® Tips and Tricks

Category: Excel®

Get the best in Excel® training anytime, anywhere.

Get Excel® Training

Make Your Own Theme in Excel





Categories: Excel®

Do you want to enhance your Excel dashboard, charts or reports with branded colors and elements? Say you are working on a new marketing effort that requires a specific look and feel. These elements include specific color combinations to match your corporate logo and so on. It’s possible that Excel’s built-in document themes are not […]

Read More

Excel Template or Macro? When to use each!





Categories: Excel®, Macros

A lot of Excel users are confused about when to use macros and when to create templates.  A macro is a recording of formatting changes and other steps that can be replayed quickly. A template is a pre-formatted spreadsheet with headers and formulas – awaiting your data. I find that whichever one you know how […]

Read More

Calculations Without the Formulas!





Categories: Excel®

Some people use Excel because they LIKE numbers and math.  Some use Excel because they DON’T! Nick counts on Excel to do the mathematical heavy lifting.  He needs to calculate rows of data, but the thought of creating formulas and then checking the answers seems daunting.  If you feel the same way, you might like […]

Read More

Hidden Security Options in Excel





Categories: Excel®

If you have any experience in Excel, then you have probably found a few reasons to want to secure your workbooks.  Here’s an example of what happened to Mary.  She spent weeks making the perfect worksheet for her sales team to collect data about their sales.  Then, accidentally, one of the sales reps deleted five […]

Read More

Create a Custom AutoFill Series in Excel





Categories: Excel®

Excerpted from QuickClicks Microsoft Excel 2016 Reference Guide You have a set of offices and sales regions, products and specific business time units (quarters, semi-annual) that you enter repeatedly. AutoFill would be helpful, but the default AutoFill lists do not contain these terms. What can you do? Create a customized AutoFill list. When you have […]

Read More

Spotlight Excel Formula: Convert Text to Numbers





Categories: Excel®, Formulas

Numbers stored as text can present problems for lookup formulas and regular calculations. There are a few ways to convert Text to Numbers in Excel using a formula. We’ll look at three separate scenarios and see how we can use a formula to make things work the way they should. Download ConvertTexttoNumbers.xlsx and try out […]

Read More