How to Capitalize Names in Excel

What I tell you? In this country, you gotta get the data first. Then when you get the data, you gotta format the data. Then when you format the data, THEN you get the woman. -Tony Montana Thanks Tony. Your words of wisdom will live on forever. Capitalize Names in Excel Having nicely formatted data is a must if you …

JosephHow to Capitalize Names in Excel

Excel Shortcuts on Your Mac Keyboard!

Do you like to move quick in Excel? And I mean lightning fast. For example, have you ever typed a little, then move your hand to the mouse to click the toolbar area? Then move back to the keyboard, back to the mouse, the keyboard, the mouse….you get the idea. It reminds me of Filbert from Rocko’s Modern Life when …

JosephExcel Shortcuts on Your Mac Keyboard!

How to Program in VBA – Intro

If you’ve done a lot of work in Excel, you’ve probably heard about Macros or VBA. VBA can help you do your work much, much faster. It can also help you expand the true power of Excel in ways you never thought possible. Ranging from processing data in a worksheet all the way to scraping web pages, VBA is quite …

JosephHow to Program in VBA – Intro

Excel Dashboard Course

Do you want to¬†really impress your manager? Or your manager’s manager? Then you should learn how to create Excel dashboards. Seriously, this is like catnip for managers. If you want to know how to create beautiful graphs that really convey the message of where the company is and where they need to go (which is extremely important to managers), then …

JosephExcel Dashboard Course

Using Enum to Keep Track of Worksheet Columns

If you code much in VBA, you have probably had to manipulate worksheets at some point. There are some common ways to work with worksheets through VBA. You have the Range object, where you can write in a string of the address you need to access. And you have the Cells object, where you use the [Row,Column] notation to access …

JosephUsing Enum to Keep Track of Worksheet Columns

Alternative to Multiple IF Statements

Have you ever had to create a multiple IF statement? Ever notice how crazy it looks with all those parentheses and it’s difficult to follow? Well, I was wondering if there was another way I could create a multiple IF statements that would be cleaner and easier to edit if need be. And I have. What I have discovered isn’t …

JosephAlternative to Multiple IF Statements

Arrange Windows for the Obsessive Compulsive

I’m sure you can find how to Arrange Windows in Excel all over the web; it’s been covered many times. However, if you’re anything like me, you would like to know how to control the actual arrangement is done by Excel. Maybe you’d like the window on the left to be the “before” worksheet and the worksheet on the right …

JosephArrange Windows for the Obsessive Compulsive

View multiple worksheets at the same time

Sometimes you would like to view multiple worksheets at once. Maybe you have two worksheets to compare side-by-side or you are working on one worksheet where you need to reference another section at the same time. I’ve been in these situations before and it’s nice to know that Excel offers ways to show multiple worksheet / workbooks in a nice …

JosephView multiple worksheets at the same time

Merge Cells In Depth

Excel’s Merge Cells feature offers a simple way to organize expand the space a single cell contains. If you have a summary page, for example, you may want to create a title for the display. Or on your data sheet, maybe you want to show that two columns belong to a specific group of data. Either way, Merge Cells in …

JosephMerge Cells In Depth

Array Formulas for Beginners

Excel Array formulas are one of the handiest tools to have under your Excel¬†tool belt. You can expand regular Excel formulas to provide a lot more power to regular functions. Take the function AVERAGEIF() as an example. Before Excel 2007, you had to use array formulas to provide the same functionality. And while array formulas are extremely powerful, they can …

JosephArray Formulas for Beginners