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.
Category Archive: Excel Tips
Excel 2010, 2007 and 2003 tips, tricks and tutorials.
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.
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 …
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.
