The Excel Digest: August 8th 2023

Happy Tuesday! 🌏​

Today I'm sharing some of my favorite Excel-related content from the last week, as well as trending Excel content you should know.

Microsoft Excel Tips & Updates:

Watch on YouTube & Subscribe to our Channel

  • The future of Microsoft Office theme colors:

First up: a vibrant change or controversial choice? In this video, we look at the latest update from Microsoft that introduces a fresh color theme to Excel, drawing comparisons to the iconic purple dinosaur, Barney. We show you the new color palette in action on various sheets and table styles, highlighting the shift from classic yellow to vibrant purple.

While opinions are divided—some embracing the change and others less enthusiastic—we explore how to revert back to the familiar look or customize colors to suit individual preferences. Join the conversation by sharing your thoughts in the comments section below!

  • My LEAST favorite Excel Tip:

Next up is my LEAST favorite Excel tip, and why I rank it low on my list of Excel shortcuts you should know. Admittedly, your opinion on this may depend on where in the world you're located, but we still prefer other tips to this one.

Which Excel shortcut is your least favorite?

[We teach VLOOKUP using a coffee shop menu to break down the steps into easy concepts]

And lastly, grab a coffee and learn VLOOKUP with our comprehensive guide to using this function. In our example, we choose a coffee shop menu to break down the process into simple, easy-to-understand steps.

Microsoft Excel Content You Should Learn This Week:

Before you leave, check out our top three trending blog posts this week. Popular tutorials give us an insight into which Excel skills are currently in demand, meaning you can brush up on the Excel tools you need to stay relevant:

  • 3 Ways to Combine Text in Excel – Formulas, Functions & Power Query

    Learn How to Combine Text from Multiple Columns in Excel: Tips and Techniques Discover effective methods to merge information from separate columns into one cohesive output. This comprehensive guide explores three approaches to combining text, catering to various Excel versions and user preferences.
  • 7 Keyboard Shortcuts for the Filter Drop Down Menus

    Boost Your Productivity with 7 Essential Keyboard Shortcuts for Excel Filter Drop-Down Menus! Discover efficient techniques for optimizing your data sorting and filtering tasks. In this post, we share a set of keyboard shortcuts that empower you to navigate the filter drop-down menus swiftly. From activating filters to searching for specific items, each shortcut is (we think) a game-changer.
  • How to Use VBA Macros to Copy Data to Another Workbook

    Discover how to streamline the process of copying and pasting data between different Excel workbooks using VBA macros.

And finally, we want to hear from you! Share your Excel goals for the week in the comments section below, and how you hope to achieve them.


Your email address will not be published. Required fields are marked *

Generic filters
Exact matches only

Excel Shortcuts List

keyboard shortcuts list banner

Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac.

Excel Shortcuts List

Join Our Weekly Newsletter

The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel.

Join Our Free Newsletter