We’ve been trying to track down Spreadsheets for a long time. We scoured the Negative Zone with the Richards/Storm family. We looked behind the expired potato salad in the office fridge. We even sent Geraldo to check Al Capone’s vault again (and, yep, it’s still pretty much empty.) We were hoping to ask Spreadsheets what […]
Does Cathy Engelbert have a point here, ladies? As the first female CEO of a major professional services firm, Cathy Engelbert learned a valuable lesson: Never trust a spreadsheet made by men. “No spreadsheet ever yielded a great result for women,” says Engelbert, who recently became commissioner of the WNBA after a 33-year career at […]
This is why your firm advises against hooking up with a fellow accountant.
Ed. note: this is third in an ongoing series to help you make the most out of Excel setting-by-setting. If you have a specific Excel demon to slay, you can get in touch for our resident white knight and Excel-slayer David Ringstrom to help you out. If you’ve implemented the changes that I’ve recommended in […]
Ed. note: this is second in an ongoing series to help you make the most out of Excel setting-by-setting. If you have a specific Excel demon to slay, you can get in touch for our resident white knight and Excel-slayer David Ringstrom to help you out. In Part 1 of this series I noted […]
Finally, the champions of the two Busy Season Survival regions — Food & Bevvie and Tech — will meet to crown the ultimate winner of GCMMBSSF&BvsT. It's been a memorable tournament unless you've been committed to Team Booze in practice as well as voting. From coffee's disappointing performance to an inspired run by Email to the exciting […]
Human beings spend, on average, a third of their lifetime sleeping. They spend six total years eating, four years cleaning the house and a little over a year on the toilet. If only someone would do a study to determine how many years the average spreadsheet jockey spends with their nose buried in multiple Excel […]
It’s mid-January, which means that at some point in the next four to six weeks or so, you’ll say to yourself, “I don’t get paid enough to do this shit.” And you might be right! But the good news is starting salaries for accountants keep going up. If you’re simply annoyed with your current boss/lunch/life […]
The following post is republished from AccountingWEB, a source of accounting news, information, tips, tools, resources and insight — everything you need to help you prosper and enjoy the accounting profession.
I was having a discussion with a colleague concerning the Excel skills in industry versus public accounting. We agreed that, generally speaking and based on surveys of class participants in our respective Excel CPE classes, industry users are more advanced than public accounting users. Within public accounting, regional firm users are more advanced than local and Big 4 users. Why is that?
We had one computer for about 150 professional staff when I started out in Big 8 public accounting oh so long ago. Back then we were the cutting edge in spreadsheet use. We were consulting with our clients on how to use Visicalc to increase productivity and reduce errors. So how did the Big 4 apparently slide to the bottom of the scale?
Theory number one holds that the Big 4 does all their training from within. They take someone who has perceived advanced skills, and use that person to teach everyone else what they know. The problem is that the in-house trainer may not know some of the advanced features in Excel that would be useful to the group. The trainer may only know slightly more than everyone else. My own experience with selling Excel to a Big 4 firm is that they feel it would be nice to know more about Excel, but it’s not imperative to the job. Rather it is better to focus CPE resources on IFRS or the latest tax code changes.
Theory number two says that associates in the Big 4 are focused in on their in-house proprietary audit software which doesn’t allow incorporating new ideas into the audit process like pivot tables or form control objects. Stick to the audit program because there is no room in the budget to experiment with Excel.
Now that I’m done ragging on the Excel skill level in the Big 4 remember I said at the beginning of the post “generally speaking” and I know there are excellent Excel users in the Big 4. I just haven’t met them yet.
As you know, PwC marched out a new compensation structure earlier this month and it’s been the subject of much interpretation, gnashing of teeth and even a fair amount of rejoicing. Of course, a complete analysis of this new structure would not be complete without the magic of Excel and lucky for you, a reader has taken the time to put some spreadsheet wizardy on it.
Here’s our tipster:
[Here] is an analysis of the new PwC compensation structure. It shows that the firm expects an approximate average raise of 8% per year and 16% per promotion year. The analysis also includes an approximate total compensation for each year of career progression.
I had to break up the image into two pieces so they could be readable. They appear on the next two pages.
Don’t forget that in Year 7, the bonus for promotion to manager is being phased in over three years, so that younger managers do not jump their more experienced colleagues in overall comp.
Obviously results will vary but this gives a pretty good picture of what your compensation will look like over the years at P. Dubs. If you’re busting, still not satisfied or have your own variables to add to the analysis provided, do share.
Welcome to the final-humpless-hump-day before the end of tax season. In today’s edition, an analyst and prospective CMA wants to know how to best improve his spreadsheet skills to the point where they’ll jump out of the screen a do a little jig. Aside from reading the Excel manual, how does one go about this?