Sunday, February 25, 2024

Stop Manually Adjusting: Excel's Autofit Hack


Give your spreadsheets an instant makeover with Excel's Autofit! In this tutorial, we'll show you how to use Autofit to achieve perfect formatting, quickly and efficiently. Ideal for all skill levels, this trick will ensure your data looks polished and professional in no time. Join us as we explore how to make your spreadsheets stand out with Autofit!

Tuesday, February 20, 2024

Stop Excel from Erasing Leading Zeros | Quick and Easy Solutions


Dive into today’s Excel mastery lesson where we're solving a common but perplexing problem: losing leading zeros in your data. Perfect for beginners and seasoned users alike, this video will guide you through the steps to ensure your leading zeros stay put, whether you're working on financial reports, contact lists, or inventory sheets. When you're doing a copy / paste of part numbers or department numbers, sometimes there are leading zeros in front ( to the left). Excel will often turn those "text" numbers into value numbers. You can stop this default before with some settings or tweaks.

Tuesday, February 13, 2024

Catching Wrong Dates Made Easy


In this video, I'm going to show you how to ensure that the input of the correct dates happen in Excel. This is a quick and easy tutorial that will help you avoid common mistakes when people enter dates into your spreadsheet. If you're having trouble getting people to enter dates correctly, be sure to watch this video! By the end, you'll be able to ensure that the correct dates are in Excel with ease!

How Much per Hour is $50000 a Year


In this short video, we're going to show you how to use Excel to calculate how much per hour is $50000 per year. This is a great video for anyone who wants to know how to reach their financial goals! If you're looking to calculate how much money they'll need to achieve a certain goal, then this Excel tutorial is for you! By using goal seek and calculate, you can easily find the answer to your question – in just a few minutes! Putting in the work is never so easy!

Saturday, February 3, 2024

Discover Excel's Secret Weapon: Basic Forecasts Made Easy



In this short video, we're going to show you how to use Excel's exponential smoothing feature to make basic forecasts easy. Using exponential smoothing, you can easily create forecasts for future periods with minimal effort. By understanding exponential smoothing, you'll be able to make accurate predictions for your business and achieve better outcomes!

Excel Secrets: Remove Duplicates in Seconds



In this video, we're going to show you how to remove duplicate cells in Excel in seconds! This is a useful skill to have if you're ever need to clean up your data or work with large amounts of data. If you're looking to speed up your work in Excel or clean up your data, then this video is for you! We'll show you how to remove duplicate cells in seconds, so you can get your work done faster.

Tuesday, January 16, 2024

Round to the Nearest 5 cents



Want some choice or flexibility when you round decimals? Say you don't want to use pennies anymore is currency calculations and need to round up to the nearest nickel. Use the MROUND function to do it. Or round up to the next three cent (though I wonder why that would happen....).