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:

View this post on Instagram

A post shared by Jon Acampora (@theexcelcampus)

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?

• Learn VLOOKUP with the Excel Campus Cafe:
  
  Blog post
  Downloadable Guide

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.