Counting in Excel

7 Ways to Count in Excel http://www.contextures.com/xlFunctions04.html

The most popular function in Excel is SUM, based on my experience. That's probably the first function you learned how to use, and in the old days, it was the only function that you could insert with the appropriately named AutoSum button.

Sometimes we overlook how much counting we have to do every day too. Here are a few scenarios that you might encounter at work (or should I say "en-count-er"?):

Sales: number of orders for a specific product, from a list in a worksheet Human Resources: count of employees with 10+ years employment Shipping: number of shipments pending,

Continue reading Counting in Excel

Excel Roundup 20150518

Weekly Excel Roundup http://blog.contextures.com/

In this week's roundup, see how to choose a chart type, check formula speed, work with pivot table source data, and many more tips.

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

 

Continue reading Excel Roundup 20150518

Pivot Table Source Data Articles

Pivot Table Data Source Tips http://blog.contextures.com/

The key to success with Excel pivot tables is having good source data. I've written many articles with pivot table data source tips, and this list will help you find the information that you need. Some of the articles are on my Contextures website, and others are on my Pivot Table blog.

Continue reading Pivot Table Source Data Articles

Excel Roundup 20150511

Weekly Excel Roundup http://blog.contextures.com/

In this week's roundup, choose a file format, get an Excel book sampler, fix dates, and build an add-in.

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

Continue reading Excel Roundup 20150511

Pivot Table Running Total Percent

Use Excel Pivot Table Running Total Percent to Analyze Sales http://www.contextures.com/xlPivot14.html

At the beginning of every month, I download the previous month's statistics for my web site, to see which pages and files were the most popular. After the data is imported to Excel, I use pivot tables to get a quick overview of the activity.

If a page is getting lots of hits, I might add a new section to it, to make the content even better. And, seeing which sample files get downloaded most frequently, gives me ideas for creating new examples.

I'm sure you do something similar for your month end, to see how things are going. And

Continue reading Pivot Table Running Total Percent

Excel Roundup 20150504

Weekly Excel Roundup http://blog.contextures.com/

In this week's roundup, look for formula inconsistencies, save time with keyboard shortcuts, use online Power BI and many more tips.

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

Continue reading Excel Roundup 20150504

Excel Table Doesn't Expand For New Data

Excel table does not expand for new data http://www.contextures.com/xlExcelTable01.html#expand

This week, while working on a client's Excel project, I ran into some trouble with Excel tables, while adding new data. Instead of expanding to include the rows, the table just ignored them.

Fortunately, the problem is easy to fix, if you know how, and if you have the patience to do lots of clicking.

Continue reading Excel Table Doesn't Expand For New Data

Excel Roundup 20150427

Weekly Excel Roundup http://blog.contextures.com/

In this week's roundup, make VLOOKUP faster, use keyboard shortcuts, run macros when Excel is closed, and many more tips.

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

 

Continue reading Excel Roundup 20150427

Upcoming Free Online Events for Excel Fans

There are a few upcoming Excel-related events that you might be interested in. These are online sessions, and all of them are free.

1-hour webinar on building Excel dashboards video course covering Excel 2013 fundamentals online conference, with a wide variety of Microsoft-related topics, including Excel

You can read the details below, and watch for the availability dates and deadlines.

Continue reading Upcoming Free Online Events for Excel Fans

Excel Roundup 20150420

Weekly Excel Roundup http://blog.contextures.com/

IN this week's roundup, you'll learn about arrays and array formulas, see how to speed up macros, and many more tips.

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

Continue reading Excel Roundup 20150420