EXCELer.org

If you're working on a project, you might need to keep track of the time that you spend on its tasks. Later, you can tell a client how much time you've spent on their project, and get paid for your work. Or, you can use the time data to see how much of your day [...]

RSS Footer: Thank you for subscribing to the RSS feed for Contextures Blog . You can read the full article here: Keep Track of Time in Excel Please visit the Contextures page on Facebook

There is a sample Excel file on the Contextures website that has a list of orders, and sales rep names. You can click a button, and a sheet is created for each sales rep, with that person's orders.

There is another version of the file, and it creates a sheet for each sales rep [...]

RSS Footer: Thank you for subscribing to the RSS feed for Contextures Blog . You can read the full article here: Filter Excel Data Onto Multiple Sheets Please visit the Contextures page on Facebook

What happens when good Excel formulas go bad? A workbook of mine that worked fine for several years, when using Excel 2003, suddenly refused to update all the formulas, after a switch to Excel 2010.

Even more mysterious, the calculations worked fine on some machines, but not others. So, what was the problem?

Hint: It [...]

RSS Footer: Thank you for subscribing to the RSS feed for Contextures Blog . You can read the full article here: Excel Formulas Not Calculating Please visit the Contextures page on Facebook

When I saw the signs in this shop window, I laughed, and snapped this picture.

How confused are your customers, if you need a sign that says, "This is the door", and another sign that points to the door handle?

Later, I realized that it's not a customer problem – it's [...]

RSS Footer: Thank you for subscribing to the RSS feed for Contextures Blog . You can read the full article here: Efficient Navigation in Excel Workbooks Please visit the Contextures page on Facebook

To show instructions to users in your Excel files, you can add comments or text boxes with notes.

Another option is to put the notes in an Excel Userform, and add a Help button on each worksheet. The button can open the Help form to a specific page, and show the relevant [...]

RSS Footer: Thank you for subscribing to the RSS feed for Contextures Blog . You can read the full article here: Show Specific Info in Tabbed Excel UserForm Please visit the Contextures page on Facebook

Someone emailed me for help with an Excel AutoFilter last week. He wanted to type the criteria onto a worksheet, and have the filtered results shown automatically. There are some built-in options for filtering by text, and keep reading to see a worksheet version that Roger Govier designed.

There is [...]

RSS Footer: Thank you for subscribing to the RSS feed for Contextures Blog . You can read the full article here: Excel AutoFilter By Typing Criteria Please visit the Contextures page on Facebook

In Excel 2007 and Excel 2010, you can use the new SUMIFS function to sum items using multiple criteria.

For example, sum the orders where an account status is Active, and the number of visits is greater than or equal to 10. You can type in the criteria, but it's better to use cell [...]

RSS Footer: Thank you for subscribing to the RSS feed for Contextures Blog . You can read the full article here: Excel SUMIFS Sum With Multiple Criteria Please visit the Contextures page on Facebook

In Excel 2007 and Excel 2010, you can use the new COUNTIFS function to count, based on multiple criteria. For example, in a list of orders, you can find out how many orders were for pens, and had a quantity of 10 or more.

I have updated the Contextures COUNT Functions page, to include [...]

RSS Footer: Thank you for subscribing to the RSS feed for Contextures Blog . You can read the full article here: Use Excel COUNTIFS to Count With Multiple Criteria Please visit the Contextures page on Facebook

Have you ever written an Excel proficiency exam? Maybe you'll have some advice or tips for the person who wrote to me this week, asking for help with the Excel Expert 2007 exam. He's having trouble with the macros and custom functions that will be part of the test.

It's been a long time since [...]

RSS Footer: Thank you for subscribing to the RSS feed for Contextures Blog . You can read the full article here: Preparing for an Excel Expert Exam Please visit the Contextures page on Facebook

To focus on specific data in a pivot table, you can use report filters or field filters.

However, using those filters affects the pivot table subtotals and grand totals. Only the amounts for the filtered data are included in the results.

Another option for hiding the [...]

RSS Footer: Thank you for subscribing to the RSS feed for Contextures Blog . You can read the full article here: Hide Pivot Table Detail Without Filtering Please visit the Contextures page on Facebook