It's Monday so must be time for some #MacroMonday Excel fun. Today I want to share with you a really handy Macro that will save a backup copy of your workbook with today's (or whatever date it is) date. How cool is that?. I use this a LOT. Making backups of your Excel file should be part of your usual spreadsheet routine. What Does The Macro Do? This Macro will save your Excel workbook to a new file with today's date as part of the filename. I love … [Read more...]
Formula Friday – Using COUNTIF Function With Data Validation To Check For Repeating Values In Excel
Hi Excellers, welcome to another #formulafriday blog post in my #Excel 2021 series. Data validation is a great way to control data entry into your Excel spreadsheets. The main positive is to promote data integrity to allow easy data analysis. In this example, I will show you how to ensure that a user does not enter any duplicate customer account numbers into your Excel worksheet. This is useful when creating new customer references or accounts which need to be unique. So, I will demonstrate … [Read more...]
Formula Friday – Did You Know Excel Knew Roman?. Convert Numbers To Roman Numerals In Excel
Hello Excellers, today let's have a bit of fun with formulas. Did you know that Excel had a ROMAN function?. No, I did not either. I love when I discover something new. I will show you how to convert numbers to Roman numerals in Excel. This little Excel beauty could be used for invitations perhaps, to give a unique look to the date, or for settling arguments on the original dates of TV programs when they are re run on TV. You know that annoying little date at the end of the credits? … [Read more...]
Macro Mondays – How To Add A Break Point To Your Excel VBA Code
Hello, Excellers. Welcome to another #macroMonday blog post in my Excel tips 2021 series. Today let's look at breaking up our VBA code by adding a breakpoint to your Excel VBA code. This pauses the code at a point we choose to enable us to use the debugging environment, to perform checks to ensure all is running as expected with our Macro. First Things First - What Is A Breakpoint? A breakpoint is a selected line of code that once it has been reached, your macro will be suspended. … [Read more...]
Formula Friday – Calculate How Many People Are Working At The Same Time using the COUNTIFS Function In Excel
Happy Friday and time for more FORMULA FUN on #FORMULAFRIDAY. This article will use the COUNTIFS Function in Excel to calculate how many people are working at the same time in a retail store. Use this simple solution for a factory or some other place of work where you need to see how many people are working at any one time during the work shift hours. This is based on the clocking in and clocking out time (or scheduled shift times of workers) versus the time of day. Let's get going … [Read more...]
- 1
- 2
- 3
- …
- 45
- Next Page »
Recommended Excel Resources
