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
Category Archives: 2 Intermediate
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
Advanced Filter
Reply
There is a powerful and efficient filtering tool in Excel called Advanced Filter. In addition to filtering values, it has the option of generating a list of unique values. There is one pitfall to avoid when using this in a macro. Continue reading