Bottom Line: Learn five issues and workarounds for the new PIVOTBY function recently introduced by Microsoft. Skill Level: Intermediate Video Tutorial Watch on YouTube & Subscribe to our ChannelDownload the Excel File You can access the Excel file used in the video for free by clicking below. 5 Problems with PIVOTBY.xlsxDownload Excel's New PIVOTBY Function Microsoft recently introduced two new functions for Excel: GROUPBY and PIVOTBY. These functions allow users to create summary reports using formulas. While these new features offer exciting possibilities, they come with their own set o ..read more

Bottom Line: Learn to create a date field that automatically updates weekly. Skill Level: Beginner Video Tutorial Watch on YouTube & Subscribe to our Channel I received an inquiry from Rhonda asking how to automate the regular update of a date field weekly. The solution lies in leveraging Excel's built-in functions, TODAY and WEEKDAY, to dynamically calculate the date for each week. If you're like Rhonda and would like to know how to avoid manually updating a date field each week, let me walk you through writing a formula to make it automatic, saving you time and effort. How t ..read more

The football squares pool betting game is a great way to add some fun to your Super Bowl party. Especially for people who aren't fans of the game or teams. It also adds excitement to boring games. You can click the links below to download the printable or digital versions. Downloads Printable PDF Football Squares Pool.pdfDownload Tip: Print double sided if you want to use the signup sheet (details below). Excel File Football Squares Pool.xlsxDownload Google Sheets Football Squares Pool – Go to File > Make a copy to save the file to your Google account and then share it with friends. Video ..read more

Bottom Line: Learn how Power Query can be used to quickly clean up messy data. Skill Level: Beginner Whether you're dealing with messy spreadsheets or CSV files, the process of cleaning up data can be daunting. Fortunately, Excel provides powerful tools like Power Query to streamline this task. In this guide, we'll walk you through the process of data cleanup using Excel, focusing on the invaluable Power Query feature. Video Tutorial Watch on YouTube & Subscribe to our Channel Downloads You can download the example files from our full Power Query guide linked here. Why Data Cleanup Matter ..read more

As we dive into the new year, updating dates in Excel sheets for 2024 is on everyone's agenda. The task may seem daunting, especially if you're dealing with numerous sheets or cells. In this blog post, we'll walk you through a handy Excel shortcut that will simplify the task of updating headers and values across multiple sheets. Video Tutorial Watch on YouTube & Subscribe to our Channel The 2024 Header Date Update One common task when updating Excel sheets for the new year is changing the headers to reflect the current year. Manually updating each cell can be tedious and time-consuming. F ..read more

If your selection is at the top of a column, and you want to quickly select the entire column, you can use the keyboard shortcut Ctrl + Shift + ↓. However, this ONLY works if there are no blank cells in the column. Columns that have blank cells require you to repeatedly hit the down arrow to make it all the way down to the end. So, is there a workaround? There are two things you could do to achieve the same result and potentially save you some time. Video Tutorial Watch on YouTube & Subscribe to our Channel Downloads Select Column with Blanks Example.xlsxDownload Option 1 The first is t ..read more

Are you looking for gift ideas for a fellow Excel fan, co-worker, or data geek this holiday season? In this post, I share some of my favorite holiday picks and exclusive offers for our Excel Campus community. Happy holidays! Featured Gift: Elevate Excel You can now give the gift of our comprehensive Excel training program, Elevate Excel! You can purchase an entire year for $490. There will be an option to check a box labeled “Is this a gift?” at check-out. What is Elevate Excel? Elevate is our subscription-based, beginner to advanced-level Excel training course with access to our entire tr ..read more

Bottom Line: Learn how to automate 5 routine Excel tasks using Power Query. Skill level: Intermediate Automate your way to a promotion with our Power Query Pro Course! 80% off this Black Friday. For a limited time, join our self-paced Power Query training program, with step-by-step tutorials designed for beginner to intermediate Excel users. For just $49, you'll get lifetime access to over 8 modules of training. Learn More Watch the Tutorial Watch on YouTube & Subscribe to our Channel Download the Excel File You can use the same workbook that I use in the video by downloadin ..read more

I recently received this question from our Elevate Excel training program: “How can I lock everything on a sheet except for the slicers? It's a good question. You may have a dashboard like this one, where you don't want users to make changes to any of the charts on the left, but you do want them to be able to interact with the slicers on the right. Click to enlargeVideo Tutorial Watch on YouTube & Subscribe to our Channel Downloads Dashboard Example.xlsxDownload It's possible to lock an entire sheet except for certain components. Here's how. First, right-click on the slicer and select Siz ..read more

Bottom Line: Learn to format and use pie charts properly, and when to use alternative charts instead. Skill level: Beginner Video Tutorial Watch on YouTube & Subscribe to our ChannelDownload the Excel Files You can track with the video using the files below. Pie Chart Makeovers – BEGIN.xlsxDownload Pie Chart Makeovers – FINAL.xlsxDownload Pie or Not? When it comes to the art and science of data visualization (a.k.a. principles for creating charts and dashboards), pie charts are a controversial topic. Some experts will tell you to NEVER use pie charts.  Others say use them sparingl ..read more