A Comprehensive List of Keyboard Shortcuts for Excel
From Pointy Haired Dilbert, a comprehensive list of keyboard shortcuts for Excel.
Posted on Tuesday, February 23, 2010 |
Comments (0) |
Permalink
From Pointy Haired Dilbert, a comprehensive list of keyboard shortcuts for Excel.
A nice post from the Contextures Blog that illustrates how to use the TRIM and SUBSTITUTE functions to clean data for list comparisons, etc.
The code to name an Excel chart using VBA is:
ActiveChart.Parent.Name = "Chart Name"
Via the PTS Blog - a series of posts that step through the process of building an Excel add-in:
Key in on the word "enumeration" when searching the Microsoft Knowledge Base for the numbers tied to the VBA chart types.
This Microsoft Knowldge Base article describes the types and subtypes of Excel charts. It also describes what type of data each chart best represents.
This Microsoft Knowledge Base article describes how to trap errors in a macro using various methods.
This Microsoft Knowledge Base article describes how to trap errors in a macro using an "on error" statement.
This Microsoft Knowledge Base article illustrates how to use VBA to remove zero percent labels from a pie chart.
Microsoft recently came out with an add-in that allows the user to manipulate points on a chart . . . "In Excel 2007, it's no longer possible to directly change a point a chart. In previous versions, you could drag a chart point to change the underlying value."
via: The Spreadsheet Page
If you need to graphically represent variances, you probably know that the calculations needed to create waterfall charts that cross the X axis are complex to build and tedious to maintain. The PTS Excel Waterfall Chart Utility is an Excel add-in that automates the process of creating waterfall charts that cross the X axis.
