Bullet Points in Excel
Bullet points are more a Word or PowerPoint feature, but you can use them in Excel. There are a few tricks required to use them though.
(more…)Macro to Set Sparkline Axis to Zero
When creating sparkline charts in Excel one of the problems is that the vertical axis doesn’t always start at zero. It is a manual process to reset the vertical access to zero and a macro can make it much quicker and easier.
(more…)Excel FizzBuzz Challenge
I was recently reminded of a basic programming challenge called FizzBuzz. Here is my Excel solution.
(more…)Handling Extra Columns in Excel Power Query
When you import a CSV file using Power Query any extra rows are automatically included. Unfortunately, extra columns are NOT included. Here’s how to fix that. In the image below I have the Formula Bar showing for the Source step for importing a CSV file. I have highlighted the argument that specifies how many columns it will import. This argument is optional. You can edit in the Formula Bar and delete that argument. Then when you refresh the Power Query…