Hi ,

Transform Your Excel Productivity : Automate Tasks with VBA.

In case you missed our last email, here's a reminder about the special offer we've arranged with Victor Chan for his Excel VBA course.

The Launch Excel VBA & Macros school will teach you skills to save hours even if you have zero prior experience with programming.

Here's some feedback from some of Victor's previous students.

Mauro Casagrande, Excel freelancer: “I highly recommend this VBA course for anyone looking to improve their skills in Excel automation. The course is well-structured and provides clear explanations of VBA concepts and syntax. Victor uses real-world examples and provides practical exercises to reinforce learning. The video lessons are engaging and easy to follow, and the course material is supplemented with downloadable resources. Overall, this course is an excellent investment for anyone looking to enhance their productivity and efficiency in Excel.”

Philip Shekoni, MBA, CFA, Senior financial analyst: "From someone who has taken different courses just to learn VBA (and most of the others costing multiples of what this one costs), this is one of the best courses on VBA that you'd find around.

The course includes

• Over 10 hours of lessons
• Dozens of code samples and utility macros
• Hands-on exercises and real-world examples
• 30 day money back guarantee
• Lifetime Access

Don't miss out on this chance to learn VBA from the ground up. 

The special price of $197 (60% off the full price) is only available until June 8 (11.59pm June 8th Pacific Time).

Click here to check out the course now.

NOTE: We may get a commission if you buy Victor's course, but we don't promote any old course. We've known Victor for nearly a decade and his experience and expertise means this course is well worth taking. Plus with the 30 day money back guarantee, what have you got to lose by trying it?

Excel Formatting Best Practices

Proper use of Excel formatting can significantly impact the speed and clarity in which users can work with and interpret your spreadsheets.

It enables you to highlight essential information, direct users, and encode data. Effective formatting subtly enhances usability, while poor formatting can be a distraction.

These are my top 10 GRIPES I see time and again.

Watch the Video

Number alignment

By default, in Excel numbers are aligned right and text aligned left. Don’t mess with numbers by centring them. Keep the ones, tens, hundreds etc. lined up so they’re easy to read:

Comma separators

If you have numbers in the thousands or higher, put a comma separator in them. It makes them instantly easier to read:

Rounding

If the numbers are greater than 1000, the decimals are immaterial. Round them so the important information is easy to see:

Currency Symbols

Repetition of currency labels just adds unnecessary noise. Instead, label the header of the column. And if there’s a chance it could be confused with other currencies that share the same symbol, add the currency name:

Merged Cells

Instead of merging cells, use Centre Across Selection. This way you still have the aesthetic of a centred label, without the inconvenience merged cells causes when selecting ranges interspersed with merged headers.

In the image below the tables in columns B:D and F:H look the same, but the tables in B:D have merged headers, whereas the tables in F:H use ‘Centre Across Selection’ to align them:

You’ll find the ‘Centre Across Selection’ option in the Format Cells dialog box on the Alignment tab:

In the animation below you can see the hassle Merged Cells causes when trying to sum the column of data compared to the easy when using Centre Across Selection:

Angled Text

Avoid making people turn their head to read labels where possible. The tables in columns B:D are more time consuming to interpret because the region labels are off to one side and require more effort to read than those in columns F:H, which allow the reader to read in a logical, top to bottom order:

Zoomed Out with Massive Font

I’ve never worked out why people zoom way out on a worksheet, only to then increase the font size so they can read it, but I see it a lot.

The only thing it achieves is smaller font in the column and row labels, but they hardly take up that much space anyway.

If you must zoom out, simply stop when you can still read the font.

Too Many Fonts

Too many fonts, serif fonts, comic sans and the like are all inappropriate for most business scenarios.

Keep it simple and stick to no more than three different fonts in a spreadsheet.

Choose fonts that are easy to read and complement one another. Or instead of different fonts, use different font sizes or bold to differentiate headings etc.

Too Much Colour

The image below is an anonymised example of a real workbook I was sent by someone asking for Excel help. The coloured headings are way too much. Plus, the pink and red fill colours make the font very difficult to read. It makes me want to wear sunglasses to view it:

Colour is a great tool to categorize data and communicate information, but you can do it with subtle colours too:

Or consider whether you need every column coloured because when everything is coloured, nothing stands out:

Cell borders EVERYWHERE

By default, Excel has gridlines turned on, so there’s no need to add cell borders to a table. These extra borders unnecessarily bloat your file and create a busy workspace.

If you want to hide the gridlines for the header area, apply white cell fill, and leave the gridlines in place for the table area:

This will result in a much smaller file and you won’t have the hassle of gridlines disappearing if you cut and paste a cell.

And if you want to see gridlines when you print, you can turn them on in the page layout settings:

That wraps up my pet peeves. Did I miss any formatting habits you find annoying? Please share them in the comments.

Have a great day,

Mynda Treacy

Co-founder My Online Training Hub