No Hurricanes in Wyoming, Thank Goodness

I trust your weekend is going well. Things are fairly normal at the Wyatt household right now, and I don't mind that at all. (Well, as "normal" as things can be these days.)

I just talked yesterday with a friend who lives in Pensacola, Florida, and I heard about their hurricane-inflicted woes. (He anticipates he will be without power until this next Wednesday.) Hurricanes are one thing we don't need to worry about in Wyoming, thank goodness.

I hope this message finds you doing well and that you enjoy the tips in this week's newsletter.

—Allen
     

ExcelTips (menu) for 19 September 2020
Powerful spreadsheets
Excel Charts in PowerPoint

A common place to use Excel charts is in your PowerPoint presentations. How you paste those charts into the presentation can have a profound effect on the size and security of the PowerPoint file.

Read this tip »

 
Dates and times
Macro for Month Name

Need to know how to generate a full month name based on a date? It's easy to do, as discussed in this tip.

Read this tip »

 
PivotTables Make You Feel Faint?

Do you get weak in the knees when asked to deal with huge amounts of data? Forget feeling faint ever again when you are asked to deal with PivotTables. Learn much more than the basics with PivotTables for the Faint of Heart, now available in three great versions.

 
Powerful spreadsheets
Updating Multiple PivotTables at Once

PivotTables are a great way to process huge amounts of data and make sense of that data. If you have a number of PivotTables in a workbook, you may want a way to update them all in one pass. This can be done through the use of a short macro, described in this tip.

Read this tip »

 
Cell formatting
When is Currency Not Currency?

One of the tools available for formatting cells is one called "Currency." This can be misleading, as it doesn't really apply the Currency format. This tip explains what is really going on.

Read this tip »

ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  307-200-0450