We All Print Spreadsheets — Here’s How To Automate Some of those Tedious Steps — Introduction You know the drill… Create your spreadsheet, then go through the process to set it up for printing (either hardcopy or digital). Over and over and over… Fortunately, these steps can be easily automated and done with a keyboard shortcut or button click! Imagine the time these simple automation steps…

Have a friend write it for you! That’s ChatGPT. — The Process Prior to commencing this, I created three Named Ranges for the data set in Excel. pt_datasource — the range housing all of the values. pt_rowsource — the far left column reflecting Product names. pt_columnsource — the top row reflecting the month-end dates. These are then referenced in the request to…

This can be very useful! Here’s how. — Overview I had no idea this was possible until this weekend…but a little research goes a long way! Using Google App Script, it’s easy to create a one-click ribbon item in #googlesheets that creates a list of contents contained in a #googledrive folder of your choice. And the generated list even…

Take Advantage of this in your workbooks! — I use hyperlinks frequently for easy navigation in my #Excel workbooks. What I could never figure out was whether I could hyperlink to a Named Range? Turns out it’s fairly easy to do. 😀 Formula Syntax The HYPERLINK function syntax is =HYPERLINK (link_location, [friendly_name]) Easy enough — but to use a Named…

Here’s a basic dataset that it worked wonders on! — The overview and analysis below shows the application of Excel’s power tools — PowerQuery and PowerPivot — to a basic, but robust dataset. The point of this is to highlight that PowerQuery and PowerPivot ARE NOT just for big, complicated projects and data analysis efforts. Everyday analysis is simplified by…

Use Excel for Financial Reporting? You want to know this! — Variance Calculation and Development I recently developed a client’s financial management reporting package and implemented the LET function to simplify the formula development. Excel LET Function The LET function lets you define named variables in a formula. There are two primary reasons you might want to do this…exceljet.net The best way to understand these new functions (LET is in MS 365 version of Excel only), is to see them used in real world business situations!

Introduction I am frequently coming across tips & tricks for all the different programs and tools that I use. Especially Excel! I am accumulating these tips to create a resource down the road…so much great content to review and share! So, I’ve decided to share some of the content that has…

A List of Actual Work Use Cases to Get You Thinking! — Data and data tools seem to be THE hot topic in the business world today. Accounting and finance folks work with data a lot on a daily basis, yet only a minority have heard of or utilized PowerQuery in #excel or #powerbi (that’s my experience from speaking and consulting, and…

Every little time-saver helps…and this is a good one! — With the introduction of iOS 14, Apple introduced a new accessibility feature. You can enable certain actions to occur when you double-tap or triple-tap the back of the iPhone. 😳🔥 I had not activated this option since I use a case on my phone. …