Excel Guru Gal

10/05/2018

So... I'm in the WSJ.

In the workplace, spreadsheet experts face a constant barrage of help requests; ‘run the other way’

08/18/2015

Excel Training Slide Deck & Worksheets http://wp.me/p3M0R6-3A

This was a 2hr all staff training I conducted on Excel. 1st half is appropriate for the most basic users. 2nd half is appropriate for more advanced users.

03/12/2014

Today’s Date in a Cell http://wp.me/p3M0R6-34

Need to quickly put today’s date in a cell? There are two ways depending on the desired result. 1) =TODAY() will update the date in the cell every time the file is opened. If today is March 12, 2014, that is what the cell will read. However, when…

02/24/2014

Visualizing and Tracing Formulas http://wp.me/p3M0R6-2W

Tracing formulas through the Formula Auditing tools in Excel can be invaluable in navigating complex formulas and diagnosing unexpected results. This guide reviews methods of visualizing and tracing formulas, including Trace Precedents, Trace Dependents,…

12/16/2013

Data Analysis Toolpak - Statistics in Excel http://wp.me/p3M0R6-2x

The Data Analysis Toolpak in Excel provides an interface to the native statistical functions. Using simple graphical dialogs to select and input data, the tools produce reports for common statistical tests. This guide covers the Descriptive Statistics…

11/19/2013

Alert: Adobe Flash update auto-installs McAfee Security Scan http://wp.me/p3M0R6-2g

Unfortunately, Adobe’s latest Flash Player update (which runs videos and interactive things on the web) automatically includes an installation of “McAfee Security Scan.” While this will not harm your computer, it can be confusing to see… [ 112 more words. ]

09/20/2013

Change all to Title Case

I’ve covered the quick and dirty way to change all text to UPPERCASE or lowercase in Excel by using Word and the shift + F3 trick, but that will not work for Title Case. Say you have a list (or … Continue reading →

09/15/2013

Change all to UPPERCASE (or lowercase) – the quick and dirty way

Changing text case in Excel can be accomplished in many ways. For this quick and dirty tip, I actually recommend using a feature of Word. There’s probably a Very Good Reason why Microsoft included this handy shortcut in Word and … Continue reading →

08/07/2013

Guide: Data Tables

Download my latest Guide: Data Tables

07/18/2013

Seeking logo. Any ideas?

07/18/2013

Welcome to my new page!