Excel

Determining a Name for a Week Number

Allen Wyatt's Excel tips -

You could use Excel to collect data that is useful in your business. For instance, you might use it to collect information showing which people have reserved various weeks of your facilities. This tip explains a few ways you can find the names associated with a range of reservation weeks.

Read this ExcelTip: Determining a Name for a Week Number
Microsoft Excel Tips - Learn Excel Faster!

Macros in Template Files

Allen Wyatt's Excel tips -

People often place macros in template files to perform any number of tasks. This tip describes a situation where the link between a toolbar button and a macro was broken when a new document was created from a template. The problem was corrected by double-checking where the toolbar button pointed when referencing the macro.

Read this ExcelTip: Macros in Template Files
Microsoft Excel Tips - Learn Excel Faster!

Good Chart Data

Jon Peltier -

The most important chart trick is Get The Data Right. You will save time and make better charts if you use Good Chart Data. Here are characteristics of Good Chart Data. The post Good Chart Data...

continue reading...

Make Excel Chart Gridlines Square

Jon Peltier -

The grids in an Excel XY scatter chart are rarely square. Here's how to adjust axis scales or chart size with VBA to make square gridlines. The post Make Excel Chart Gridlines Square appeared first...

continue reading...

Update: RefTreeAnalyser

JKP's Excel pages -

RefTreeAnalyser 2.0 has just been updated to build 170. Improved sorting of chart series nodes on Objects dialog and fixed truncation of some labels on dialogs.
Subscribe to necesitomas.com agregador: Excel