The focus of this website is changing to equipping people to be better analysts using a variety of tools rather than exclusively Excel. It will also provide more information about my services to small and medium enterprises.
Formatting in Excel
Formatting in Excel seems to be a topic of interest for users at all levels of expertise. In this post I look at three different areas – formatting basics, formatting a report and formatting cells; so there should be something for everyone. Continue reading
Macro to Select the Date
Are you looking for a macro to select the date? Recently I was looking for some type of calendar or built-in dialog box that would enable a user to select the date which I would then feed into my macro. I saw one option but that looked too involved for my purposes so I wrote my own function. Continue reading
Trim Your Selected Data
Do you find yourself having to apply Excel’s TRIM function to columns of data from another data source? The following macro will trim your selected data, i.e. remove blanks from the start or end of each cell. This method can also be adapted to other situations like formatting text or performing calculations. Continue reading
Waterfall Chart
A waterfall chart shows the impact of a series of changes on an initial value to produce a final value, for example changes in a budget or forecast between two years. Unfortunately, this is not a standard chart in Excel’s selection so we will look at how to create it. Continue reading