be the expert in your office
A blog focused primarily on Microsoft Excel, PowerPoint, & Word with articles aimed to take your data analysis skills to the next level. Learn anything from creating dashboards to automating tasks with VBA code!
There is a new function in town that can do a whole heck of a lot and this function is called XLOOKUP. Let’s dive in and understand how using two XLOOKUP functions can replace the long-time coveted INDEX/MATCH/MATCH formula to lookup values in Excel.
Read MoreLearn all about the new XLOOKUP function Microsoft has release in 2019. This new Excel function has streamlined inputs that accomplish the capabilities of VLOOKUP, HLOOKUP, and INDEX/MATCH.
Read MoreIf you want access the newest Microsoft Office features, you can download the Insider version. This version of Microsoft Office acts as the first public testing grounds for all of the fresh features that have been cooked up over in Redmond. Learn how you can get setup with the Insider Version of Office in this step-by-step tutorial.
Read MoreLearn how you can pull and store real-time stock prices and associated metrics inside Excel. With this newly released feature inside Excel 365, stock information can be easily tracked in real-time using Linked Data Types.
Read MoreI’m taking a small break from writing about Excel to share with you all the equipment I use to run this website within my home office.
Read MoreBy default Excel will convert text to a hyperlink if it determines your data is a URL or an email address. This is typically not a wanted behavior and in this article you will learn how to prevent this type of auto-correction.
Read MoreThe questioning of the VBA languages lifespan seems to be a question that is on everyone’s mind. Let’s explore why so many people utilize this language, Microsoft’s current thinking on it’s uses, and when it will ultimately retire from being used.
Read MoreLearn how to utilize a few programs you already have to create automation rules that will automatically open up your Excel files, run VBA code, save the changes, and then close the file. These automations can even be setup to run while you sleep!
Read MoreThe default formats of Userforms have not been updated since the 1990’s and it is very unfortunate since UI design has changed quite a bit since then! In this article, I am going to walk you through how to transform those outdated grey userforms into fresh and current dialogs. Enjoy!
Read MoreIn this article you will learn how to use Excel’s built-in InputBox dialog to allow your users to write-in or select a cell range. This range can then be used throughout the remainder of your executable VBA code.
Read MoreLearn how to create a hover-over effect for your VBA Userform buttons. This format changing effect will allow you to match Microsoft’s current dialog box UI (user-interface) design.
Read MoreThis guide will provide you with all the critical VBA snippets you’ll need to know in order to interact with ListBox controls within your userforms.
Read MoreLearn how to easily make your personal macro file reappear if it happens to disappear on you.
Read MoreDoes your screen go crazy and start flickering or flashing every time you run your macro? Learn how to prevent this nuisance from happening (and speed up your code in the process!).
Read MoreLearn how to prevent an Excel Error message that will prompt while the Excel Application is opening, stating it cannot find an add-in that was deleted from your computer.
Read MoreIn this article I will show you how to vertically (middle) align the text in your Excel userform textbox controls. Unfortunately, there is no built-in button to do this….so we have to get a little creative!
Read MoreLearn how to find and remove external links from your Excel spreadsheets.
Read MoreIn this article, you will learn how to determine what you user currently has selected before attempting to modify the spreadsheet with your VBA code. This will prevent errors and potential irreversible devastation to the spreadsheet your VBA code will be running on.
Read MoreIn this article, you will learn the steps needed in order to save a single PowerPoint slide or all of your PowerPoint slides into image files.
Read MoreIn this article you will learn how to use VBA to automate creating and maintaining a PowerPoint multiple choice quiz from using data stored in Excel.
Read MoreBecome an expert in Excel, PowerPoint, Word, and the rest of the Microsoft Office Suite. Check out all the free tutorials and VBA code snippets!
Create Excel, PowerPoint, Word add-ins with ease with this revolutionary template and online course!
Affiliate Program | About | Example Files
Guru Solutions, LLC | © 2015-2019 | ALL RIGHTS RESERVED
Excel, PowerPoint, Word, & the rest of the Office Suite are registered trademarks of the Microsoft Corporation
This site is not affiliated with Microsoft Corporation.
