Category Archive: Excel Tips

Excel 2010, 2007 and 2003 tips, tricks and tutorials.

How to Use Excel’s MOD Function

In this article, you’ll learn how to use the Excel’s MOD function to find the remainder after division. The MOD function can be used in conditional formatting and data validation.

Pivot Table: How to Group Data by Number Ranges

Would you like to group your pivot table data by age range, price range, or any other number range? The simple process is explained in our blog post.

Excel Tip: How to Make Formulas “Invisible”

Excel Tip: The ability to make your formulas invisible is powerful, especially when you have complex functions. If users can’t see your functions, they can’t try to edit them.

Is It Time to Switch From Excel Pivot Tables to Power Pivot?

Making the decision to switch from Excel Pivot Tables to Power Pivot? Explore the pros and cons of each option.

Excel Pivot Table Tip – How to Make SUM Function the Default

A question from an Excel training session: How can I make SUM the default function?

What’s New With Excel 2016?

Every business relies on controlling data—from organizing to analyzing. It is especially critical now more than ever as changes occur at a rapid pace, driving the need for more capabilities, command over every process, and flexibility. Add the increasing volume in data, and companies that fail to take full control over it could experience unfavorable …

Continue reading »

Excel File Corrupted? Here’s 1 Way to Recover Data

Do you think your Excel file is corrupted? Recovering corrupted Excel files can be a challenging process. If you are able to open the file, this method may save you time and headaches.

#1 Cause of Pivot Table Headaches

The key to maximizing Excel Pivot Table’s powerful features is making sure your source data is properly formatted.

Excel Tip – How to Protect Specific Cells

Wondering how to protect specific cells in Excel? This blog post has the step-by-step instructions.

Paste Values Keyboard Shortcut (Excel Tip)

Excel Tip – Find yourself pasting values often? Here’s a keyboard shortcut to speed up the process.

Older posts «