Chris wants you to always ask the question, 'Is there a better, faster, more accurate way to do this?' His website helps provide the answer.

The Spreadsheet Guru - Chris Newman shares Excel tips with the goal of turning you into your office's Spreadsheet Guru.

He's a great resource for learning Excel dashboards and gaining efficiency with shortcuts, formulas and functions.

Learn Excel Dashboards - If you want to discover how to make beautiful Excel dashboards, Brad Edgar is your man.

Useful Excel Resources Links from fellow Excel enthusiasts

Open Folder using VBA and Show if Already Open.

Use VBA ShellExecute to Open URL in Default Browser.

Convert Decimal Time to Hours Minutes Seconds with VBA.

Use VBA to Mute, Unmute, Volume Up and Volume Down.

Macro to Enable Trust Access to the VBA Project Object Model.

Match Value in Range to Same Position in Another Range.

VBA Dir Function to Check if File Exists.

Find the Closest Number in a Range with this VBA UDF.

Return Position of Element in VBA Array.

Check if folder exists, then create folder with VBA MkDir.

Play System Sounds and WAV Files With VBA PlaySound.

Display Screen Size and Other Metrics with VBA UDF.

A VBA UDF to Enhance Excel's CELL and INFO Functions.

We also stuffed it with 140 macro examples. This cheat sheet set has over 200 practical tips covering the 125 most important topics in Excel VBA. Chapter 1 starts with VBA basics and each subsequent chapter introduces you to more advanced topics.Įxcel VBA Tutorials Chapter 1: Getting Startedįor more essential VBA tips, grab a copy of our Ultimate VBA Training Bundle. These Excel VBA tutorials are designed to teach you everything you need to know about Excel VBA. Excel VBA Tutorials and Examples Tutorials, Guides and Blog Posts

Vba excel