A couple months ago I received an email from Titus who was looking for a way to easily populate and...
Quickly Emailing Your Spreadsheets I absolutely love using the Email As Attachment functionality provided by Excel. It's great for quickly...
Quality Matters I've written many times in the past on how the quality and formatting of your work can separate...
Moving Excel Tables Into Various Word Pages This post is an add-on to a previous post I wrote covering how...
PowerPoint Filtering This was a great idea that came from a reader named Chris Morgan. He wanted to know if...
Stop Manually Copying and Pasting! This post is a continuation of the current most popular blog post on The Spreadsheet Guru...
Taking A Previous Post One Step Further This will build from a post I previously wrote entitled Copy & Paste An...
Moving An Excel Table Into A New Word Document In this post you will learn how to write VBA code...
What This VBA Code Does When handling sensitive data it is vital to display some sort of statement to let...
Why Do This? I've received a large number of questions on how to command other programs with VBA through Excel....
Teaching Excel How To Speak PowerPoint In order to control PowerPoint (or any other program) from inside Excel's Visual Basic...
[FREE Training] 10 Amazing Excel Efficiency Tricks. Why Don't People Know These?!
