The Guide To Finding and Removing External Links From Your Excel File
/
Learn how to find and remove external links from your Excel spreadsheets.
Read More
Populate A PowerPoint Quiz From Excel With VBA
/
In 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 MoreFix Excel Found A Problem With Formula References In This Worksheet
/
Learn how to get rid of the Excel error message pertaining to, "Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct."
Read MoreHow To Keep Track Of Your Shapes Created With VBA Code
/
I reveal my methodology for keeping track of different types or groups of shape so they can be easily modified in bulk later on.
Read MoreChristmas Expense & Budget Tracker Excel Template 2017 (Free!)
/
Stay on top of your Christmas spending this year and use my personal Excel template to track all your expenses and stay within your budget!
Read MoreTroubleshooting Excel Print Margins
/
Learn how to fix weird spacing in your Excel print margins
Read MoreOne Instance When Merging Cells Is Needed!
/
One instance where merging cells is more favorable than centering across
Read MoreExcel Weaknesses: A Wishlist For Much Needed Improvements
/
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 MoreHow To Customize The Order Of Your Excel Slicer Buttons
/
Learn how to re-order Excel Slicer button into any order you please.
Read MoreTop 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 More
