Learning Excel Custom Number Formatting

Learning Custom Number Formatting – One of Excel’s Magical Mystery Tours Typing data in Excel can have the same result as typing a letter on a typewriter – what you see is what you get – commonly referred to as “WYSIWYG”. Unlike

Better Excel Presentations: Increase Font Size of Formula Bar

Better Excel Presentations: Increase Font Size of Formula Bar Imagine the following scenario:  You’re in the audience of a presentation and the speaker is displaying a spreadsheet on a television or projector screen.  The screen is full of facts, figures, and formulas.

3 Handy Excel Chart Tips You Might Have Missed

3 Handy Excel Chart Tips You Might Have Missed This post will focus on three little-known chart features that will save you time when creating reports include charts. Let’s see how many you know versus how many are new to you.

How to use the Message Box in Excel VBA

How to use the Message Box in Excel VBA (syntax you'll need for MsgBox) In this tutorial you'll quickly learn the correct syntax to create a VBA message box (also referred to as a pop-up dialogue box) in Excel. I first show

Excel’s Find and Replace (surprising features)

Excel's Find and Replace (surprising features) One of the first features a Microsoft Word user discovers is the ability to search through a document, looking for a word, and replace the word with a different word. This is useful when you want