Formula Friday – Shhhhh…Want To Hide Your Excel Formulas?????….
Hello Excellers, and welcome back to another blog post in my #Excel series. So, something a little different for today's #formulafriday blog. Instead of showing our Excel formulas, I...
Category: Excel Tips& Tricks
Macro Mondays – A Quick Macro To Open A Spreadsheet To A Particular Sheet And Cell
This really is a very quick #macromonday tip for you. Have you got a large Excel workbook with lots of worksheets?. It's sometimes really handy to be able to open your workbook straight to the...
Formula Friday – Use The SubTotal Function To Number Rows In An Excel Table.
Hello Excellers time for some handy #formulafriday tips. This week let's take a look at using the SUBTOTAL Function to easily number our rows in an Excel Table. You may want to number...
Excel Tip – Identify All Cells In A Worksheet With Conditional Formatting
Don't forget to sign up to the Excel at Excel Newsletter for 3 FREE Excel tips the first Wednesday of the month. Just click on the Sign Up Form to the right or use the link below. You will also...
I want to show you today how to easily insert a YouTube video into Excel. Why would I want to do that you may ask?. ..... Maybe you need to send a user a video on how to use the Excel...
Formula Friday – Easily SUM Values From Different Excel Sheets With The Same Cell Address
Time for some more Friday Formula Fun. Today we are looking at the good old SUM function, but we are going to use it to SUM the values from the same cell in multiple Excel worksheets. What does...