How To Customize The Order Of Your Excel Slicer Buttons
/
Learn how to re-order Excel Slicer button into any order you please.
Read More
Top Online Excel & VBA Courses 2017
/
I'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 MoreVBA Guide To Referencing Worksheet Tabs
/
The 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 MoreHow To Change Excel's Group Outline Direction Settings
/
Learn how to adjust the Outline Group settings in Excel to change the direction of how cells expand and collapse.
Read MoreHow To Change The Mouse Cursor Icon In Your VBA Userform
/
Learn 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 MoreUse VBA To Automatically Adjust Your Charts Y-Axis Min and Max Values
/
This 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 MoreUse Yahoo! Finance To Pull Stock Information Into Excel
/
This 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 MoreDynamically Populating VBA Array Variables To Store Lists of Data
/
Array 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 MorePrevent Microsoft Office Add-ins From Disappearing From The Ribbon Interface
/
With 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 MoreMy First Microsoft Excel MVP Award!
/
On 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 MoreTop Microsoft Excel Add-ins You Should Consider Using
/
A 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 MoreHow To Find And Remove Duplicate Excel Cell Data
/
Learn 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 MoreHow To Add A Center Across Selection Button To Excel's Home Ribbon Tab
/
I 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 MoreRetain Font Formats After Changing An Excel Shape's Formula
/
This 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 MoreAllow User-Specific Login Credentials To Be Pulled With Excel VBA
/
There 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 MoreCombining Text With The CONCAT and TEXTJOIN Excel Functions
/
There 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 MorePreventing Users From Printing Your Excel Workbook Tabs With VBA
/
Sometimes 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 MoreBest Excel Keyboard Shortcuts For Editing Columns & Rows
/
By 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 MoreHow To Create Your Own User-Defined Functions With VBA
/
Mention 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 MoreCorrecting Shape Assigned Macro Links After Copying Worksheet VBA
/
The easiest way to copy over VBA code while copying your worksheets into a new workbook is to store your VBA macros within the worksheet itself instead of the typical Modules that most people use. While it is possible to copy Modules from one workbook to another, it adds another layer of VBA coding that is much more of a hassle than storing your code within a Worksheet Object.
Read More
