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!
As Microsoft continues to persuade people to sign up for their Office 365 subscription in lieu of purchasing individual copies of Office, I am hoping that the Office team moves towards sending out more updates on a regular basis (similar to how Google does with their Chrome browser).
Read MoreLearn how to re-order Excel Slicer button into any order you please.
Read MoreI've gone ahead and created this post to round up some of the best quality courses currently available on topics like creating dashboards, mastering Pivot Tables, and figuring out how to write custom VBA code.
Read MoreThe following VBA guide is intended to show you have your can target specific worksheets within your workbooks in order to apply changes to them.
Read MoreLearn how to adjust the Outline Group settings in Excel to change the direction of how cells expand and collapse.
Read MoreLearn how to change which cursor icon display while your users use your userform. This article will also show you how to upload your own cursor icons into your userform.
Read MoreThis article will show you how to use VBA to automatically adjust the min and max axis bound figures for the vertical (Y) axis of your spreadsheet charts.
Read MoreThis article will show you how to pull Stock related data directly from Yahoo! Finance into your Excel Spreadsheet. This includes real time stock prices, dividends, 52-week highs, and historical data.
Read MoreArray variables are very powerful tools to store data within your VBA code. Learn how you can dynamically populate these variables to handle your changing data.
Read MoreWith a recent Office update in July 2016, Microsoft has chosen to secretly block add-in files downloaded from the internet by default. This can cause add-ins to disapear whenever you close your Office Application.
Read MoreOn July 1st, 2016 I received an email from Microsoft congratulating me on being awarded the Microsoft Excel MVP award for 2016. I was the only new person in the Excel category to receive the award out of the list of winners and I had to reread the email quite a few times before my mind could accept that I was now officially part of an amazing group of Excel users from across the world.
Read MoreA compiled directory of some of the most popular add-ins you can use with Excel. The directory is split up by specific categories and contains links to the individual sale pages for the add-ins.
Read MoreLearn a bunch of different methods that you can accomplish flagging and removing duplicate values within your data sets. This article offers both spreadsheet and VBA macro solutions for you to use
Read MoreI am a huge advocate for using the Excel functionality of Center Across Selection instead of Merge & Center. The main reason is it forgoes issues with copy/pasting cells that are merged.
Read MoreThis is a frustration I seem to always face while creating dashboards or graphics for Excel reports. I create a super cool callout graphic to bring attention to an important figure in my data. I have this graphic perfectly formatted and proceed to copy it a couple of times to link some more important figures to these callouts.
Read MoreThere are a ton of great data programs out there that integrate very nicely with Excel. The problem I see handled poorly over and over again is that analysts will store their login credentials directly inside their automated VBA code or even worse, the spreadsheet itself!
Read MoreThere are a variety of reasons why you might want to combine various cell values into a single value. You might be trying to create a unique ID to perform a lookup or simply wanting to combine location information such as a city with a country. The Microsoft Excel developers have recognized the importance of joining our data inside of Excel and have finally added two more extremely useful functions that we can incorporate into our arsenal of text manipulating skills. In this article, you will learn the basics of combining text with these brand new functions and hopefully you gain some insight into how you can use them inside your spreadsheet work on a regular basis.
Read MoreSometimes when you have models that are dealing with sensitive information, you want to take extra steps to prevent that data from getting passed around. In this article, you will be walked through different scenarios where you can prevent anyone from using the Print features to makes printouts of your Excel tabs.
Read MoreBy using the correct shortcuts, you can also save a lot of precious time, which can be utilized for other productive work. Check these 6 shortcuts in Microsoft Excel which can be used to make manipulating columns and rows a breeze!
Read MoreMention the word "function" to an Excel user, and immediately they'll envision common functions such as SUM or DATE or even VLOOKUP. This is understandable, as Excel makes available hundreds of functions you can use in your own formulas to massage your data.
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!
Affiliates (Coming Soon!)| About | Tools | Example Files
Guru Solutions, LLC | © 2015-2017 | 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.
