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

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