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

Round Numbers With Excel Formatting

Did you know that Excel limits the number of numbers that appear in a cell, in General format? I discovered that limitation this week, while updating my page on rounding functions in Excel.

Have you run into this limit? It was something that I hadn't noticed before, and there doesn't seem to be any setting to adjust this.

 

Continue reading Round Numbers With Excel Formatting

Excel Roundup 20150413

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

This week, attend a free dashboard webinar, find data with VLOOKUP, create a funnel chart, 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 20150413

Track Project Tasks in Excel

Track Project Tasks in Excel http://blog.contextures.com/

If you're working on an Excel project with a client, or other employees in your company, how do you keep track of everything that needs to be done? If emails are flying back and forth, with questions, and comments, and specification changes, it's easy for things to slip through the cracks. Then, 5 minutes before the deadline, someone realizes that a key piece is missing!

Nobody wants that to happen, so it helps to have a system for keeping track of everything that has to be done.

Continue reading Track Project Tasks in Excel

Excel Roundup 20150406

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

This week, see how to add a table of contents in a workbook, customize the right-click menu, pick a random winner, 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 20150406

Customize Excel Context Menus

Customize Excel Context Menus http://blog.contextures.com/

When you right-click in Excel, a pop-up menu appears, with a list of commands that you can use. The list changes, depending on where you've clicked, so it's called a "Context Menu".

But, even though those pop-up menus are helpful, they might not have all the commands that you like to use. Or, the commands might be there, but buried a few layers deep in the sub-menus.

Maybe you'd like to add a few commands, but there isn't a built-in way to customize those menus, like there is for the Ribbon and Quick Access Toolbar (QAT).

Continue reading Customize Excel Context Menus

Excel Roundup 20150330

This week, see how to highlight items in a dashboard, change the background colour in a chart, use Excel for project management, 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 20150330

How to Count in Excel

Learn 7 ways to count in Excel, with function tips and tricks http://blog.contextures.com/archives/2015/03/26/how-to-count-in-excel/

There are lots of different ways to count things in Excel – maybe you need to count the numbers in a column, or all the data, or just the blank cells. Fortunately, there is a function for each of those:

COUNT COUNTA COUNTBLANK

For example, to count the blank cells in the range A1:A5, use the following formula in cell A7:

=COUNTBLANK(A1:A5)

More Complicated Counting

If you have more complicated things that you need to count, there are other functions to do the job:

COUNTIF COUNTIFS SUBTOTAL AGGREGATE

For example, to count only the visible numbers, after filtering and/or

Continue reading How to Count in Excel

Excel Roundup 20150323

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

Have you used PowerMap in Excel? Microsoft's Excel team used it to illustrate the White House budget in 3D. You can read the details, and download the Excel file from their blog.

Continue reading Excel Roundup 20150323

Find and Fix Pivot Table Source Data

alt text: Find and fix pivot table data source problems http://www.contextures.com/excelpivottablesourcedata.html

After you create a pivot table, you might add or change records in the source data. Sometimes the pivot table does not update correctly, to show the new data. Or if you've inherited the pivot table file from someone else, you might not even be able to find the source data, in a large workbook.

To help with these problems, I've added a new page on my Contextures site, with tips for finding and fixing the source data for a pivot table.

Continue reading Find and Fix Pivot Table Source Data