-
How to save for expected expenses
Have you ever been doing a great job sticking to your budget and then your auto license renews and you need a smog check and neither of those items is on your monthly budget? It can throw all your financial progress out of wack. However, these are perfect examples of irregular, but expected expenses. When […]
-
Excel Tips & Tricks: My favorite formulas & features
My co-worker Jonny recently told me that he used to hate Excel until he saw me use it. I think I’m still in shock that someone could hate Excel. I am a huge Excel nerd. There’s very very activities that I love more than getting lost in spreadsheets. A few years ago I converted to […]
-
vlookup formula in Excel for Mac
I recently discovered the value of vlookup in excel. And I keeping finding more and more ways and reasons to use it. Last week a co-worker needed to compare values on a report from two different dates. We were chatting about it and I realized the vlookup would solve her problem. In this example, I […]
-
Using Excel for Project Planning
I’ve used Microsoft Project in the past. There were some features I really liked, but mostly I found it frustrating, cumbersome and time-consuming. I hate wasting time; I have an obsession with being as efficient as possible. So a few years ago I ditched Project and decided to use Excel to handle my project management […]
-
Using Excel for Resource Planning
Right now I’m planning every promotion we’ll be doing in 2013. This represents hundreds of different promotions that will be managed by more than a dozen people. I’ve been using Excel to build my list of promotions so that I could: Easily filter them by categories (huge vs mini promotion, sale vs product promotion, etc.) […]
-
How to copy an entire Excel worksheet (on Excel for Mac)
There’s a quick and easy way to move an entire Excel worksheet to a different workbook. Side note: A workbook is what you’d typically think of as an Excel file. It can contain multiple work sheets. Worksheets are added, deleted and managed in the tabs at the bottom. I’ve seen people copy entire worksheets using […]
-
Adding Commands to Excel Quick Access Toolbar (Excel for PC)
When I switched to the ribboned version of Excel it was indescribably painful. I was quick and efficient at Excel and I knew exactly where I needed to go to get what I wanted. The ribboned version blew all of my knowledge out of the water. This interactive tool from Microsoft was very useful. But […]
-
How to Freeze Panes in Excel for Mac
Step 1: Grab the bar on the far right side and drag down Step 2: Drag until the top bar to below the cells you want frozen at the top Step 3: Grab the bar on the bottom right and drag to the right. Step 4: Drag the bar until it is to the right of […]