Excel Text Horizontal and vertical alignment

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=xqnL6nCp5Gc

Excel loves include annoying, bland and boring defaults to upset your work. A weird one I've been working around for ages is this: You've created a nice chart from the bland and boring Excel default. You redirect the series to show the latest data. Excel thinks it would be a good idea to cause you a load of extra work by resetting the format of everything to default. • In this video I explain how to STOP this in your advanced settings. Yes, it's another couple of checkboxes Excel has buried where most can't find it! • CHAPTERS • 0:00 - Intro, scope of video • 1:00 - Demo of problem • 2:20 - How to stop chart reformat • 4:05 - Problem now fixed • 4:59 - Create clustered bar chart • 6:30 - Improve on default Excel chart format • 7:10 - Add extra series to chart • 8:22 - Format data bar width, colours • 9:40 - Add data labels to bars and format • 10:05 - Insert chart title and format • 12:00 - How to calculate % change • 13:02 - Add conditional formats to cells • 14:10 - How to RANK a range of numbers • 15:40 - Recap and outro • I hope you've found this helpful. Please like and subscribe for more handy content. I do this around a day job at at own expense (the main one being £300 per year website fees), so any contributions are most welcome - you can buy me a coffee here: • https://excelattheoffice.com/buy-coffee • Quirky and unique t-shirts: • https://eato.teemill.com • Kind Regards, • Adrian

#############################

New on site