Big 4 Experience: is it really necessary?

Since I have reached several milestones, and according to my 30-year plan its time to start considering this, I have been looking out at the job websites to get an idea of what may be available.
Granted I am nowhere near being ready to make a change, and I am even considering making what I am [...]

Excel Toolbox: How to create a hands off section of a Worksheet-Revisited

I have been posed with a question as to how to set ranges for the group to use while locking the rest of the worksheet.  I decided that perhaps my earlier post was a bit hard to understand.  I have written out new instructions and have additional comments.
When you lockout or leave unlocked cells in [...]

CPA Exam: What happens after you pass

One thing I have noticed.  Everybody talks about what you need to do to pass the exam and how different study methods work.  They also talk about what study programs are the best.  Very few discuss what happens after you pass.
Since I am with you and have recently experienced the joy of passing all four [...]

Excel Toolbox: Moving Macro’s

You’ve worked hard and created a macro and you saved it. The next time you go to open an Excel file, its gone. Where did it go?
Essentially all macros will default to the specific worksheet you place it in. Unless you return to that specific worksheet you will not be able to access the Macro [...]

Excel Toolbox: Shortcuts Part Three

Here is a final listing of shortcuts you can use to make your work easier on a day to day basis.
Keys for PivotTable and PivotChart reports
Lay out a report onscreen
Press F10 to make the menu bar active.
Press CTRL+TAB or CTRL+SHIFT+TAB to make the PivotTable Field List active.
Press the DOWN ARROW or UP ARROW key to [...]

Excel Toolbox: Shortcuts Part Two

Some more shortcuts for you to use, this is part of a primer I am creating for a workshop at home. You get to have it for free!
Keys for workbooks and worksheets
Preview and print

To do this
Press

Display the Print dialog box.
CTRL+P or CTRL+SHIFT+F12

Use the following keys in print preview (to get to print preview, press [...]

Excel Toolbox: Shortcuts Part One

I was thinking about all of the short cuts I use and though it would be fun to create a grid of all of the shortcuts I know about or have in one of my manuals.  I decided to make this at least a multiple part post, so watch for future posts on this topic.
[...]

Excel Toolbox: Menu bars and other things

I use just a handful of functions in Microsoft Office’s toolbar menus. I like to have them handy so I don’t have to go searching for them every time I want to use them. Here is a handy tip to get the most out of your toolbars.
If all you want to do is shorten [...]

Excel Toolbox: Creating a short cut for V-Lookup and Functions

If you have a complex calculation that you reuse frequently in Excel or perhaps you frequently use a certain formula and want to be able to create a shortcut, you don’t have to repeatedly enter a long, complex worksheet formula. Instead, you can create your own worksheet function to perform the calculation. You can then [...]