Excel Weekly Meal Planner 20150618

Excel Weekly Meal Planner http://blog.contextures.com/

There is an Excel weekly meal planner on my website, and you can use it to organize your meals, and create a shopping list. I hadn't used it for quite a while, and after opening it this week, I decided it was time for an update.

Continue reading Excel Weekly Meal Planner 20150618

Excel Roundup 20150615

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

In this week's roundup, add custom chart labels, get started with VBA, compare worksheets, get info from hyperlinks, and many more Excel 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 20150615

Compare Excel Worksheet Values and Formulas

Compare Cell Values and Formulas in Excel http://blog.contextures.com/

If Excel sheets are set up identically, you can create 3-D formulas, to sum a specific range, in a group of sheets. (You can use other functions in a 3-D formula too, such as Average, Count, Min or Max.)

For example, this workbook has sheets for the East, Central and West regions, and all three sheets are set up the same.

Continue reading Compare Excel Worksheet Values and Formulas

Excel Roundup 20150608

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

In this week's roundup, build a nested IF formula, improve your dashboards, work with dates, and change a pivot table layout.

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 20150608

Move Pivot Fields Without Dragging

Move Pivot Fields Without Dragging http://blog.contextures.com/

Last week, someone asked me if there is a menu command for moving the fields in a pivot table layout. For example, if the Region field is in the Columns area, can you use a command to move it to the Rows area, or do you have to drag it with the mouse, in the PivotTable Field List?

Continue reading Move Pivot Fields Without Dragging

Excel Roundup 20150601

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

In this week's roundup, fix drop down lists that allow invalid entries, create an interactive chart, get a free Excel book on Kindle, and much more.

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 20150601

Excel Drop Down List Allows Invalid Entries

Excel Drop Down List Allows Invalid Entries http://blog.contextures.com/

Drop down lists make it easier to enter data on a worksheet, and they help ensure that only valid items will be entered in the cell.

For example, in the screen shot below, the Manager column has a drop down list with 5 names. Only those names should be entered in the column.

Continue reading Excel Drop Down List Allows Invalid Entries

Excel Roundup 20150525

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

In this week's roundup, see how to reverse last and first names, pin a shape to a chart point, learn some Solver history, and more.

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 20150525

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