Tuesday, April 9, 2024

Adapt Date Types for International Users (UK-US Example) - Excel #Shorts


This video, we quickly unravel the complexities of adapting date types to suit your international audience's preferences. Lets us a UK (DD-MM-YYYY) to US (MM-DD-YYYY) example. Stay tuned as we guide you through the steps to seamlessly change date formats, making your content universally understandable.


Tuesday, April 2, 2024

Clean-Up: How to Quickly Remove Empty Columns


Welcome to this tutorial for optimizing spreadsheet efficiency. Ever find yourself scrolling through endless columns searching for relevant data, only to be hindered by unnecessary empty spaces? Today, we'll go through some quick steps in Excel to help you identify and eliminate those empty columns, streamlining your data for a smoother workflow. This quick guide is designed for Excel users of all levels, from beginners to advanced, aiming to enhance your spreadsheet management skills. By the end of this tutorial, you'll be able to clean your data like a pro, making your spreadsheets both visually appealing and functionally superior. 

Sunday, March 24, 2024

Easy Rounding Techniques: Nail 5 Cents & Dollar Calculations


Dive into the world of easy rounding techniques with today's essential guide, focusing on the nearest 5 cents and dollars. Perfect for students, professionals, and anyone in between, this video will equip you with the skills to perform quick and accurate financial calculations. Stay tuned as we reveal tips and strategies that will transform your approach to rounding numbers.

Formulas Don't Work - Easy Fix! - Excel #Shorts


Are your Excel calculations refusing to cooperate, leaving you in a spreadsheet nightmare? Worry no more! In this enlightening video, we dive deep into the common mistakes that throw your formulas off track, from the classic missing equal signs to the sneaky text-formatted numbers.

You've already checked the syntax and there's no error message, but the formulas is just not calculating.  The key word is "Calculate" and it's a simple fix

Saturday, March 16, 2024

Phone Number Input Tricks - Excel #Shorts


Let’s dive into the world of phone number validation in Microsoft Excel. In this tutorial, we’ll explore techniques to ensure your phone number inputs are just the right length—no more, no less. Whether you’re building a contact list, tracking customer info, or simply want to impress your boss with your Excel prowess, this video has got your back. Check out the video to show you how.

Monday, March 4, 2024

Create Random Decimal Numbers - Excel #Shorts



Unlock the secrets of generating random decimal numbers effortlessly in today’s tutorial. Whether you're coding, crunching data, or just love numbers, understanding how to create random decimals is a game-changer. We’ll walk you through a step-by-step guide, ensuring you grasp the concept easily. Stay tuned as we dive into the world of random decimals, providing you with the knowledge to master this essential skill. In older Excel versions you had to use a combination of RANDBETWEEN, RAND and then sum to get it. But with M365 Excel or Excel 2021 there's an new function that will do it all in one step.

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!