What to be familiar with in Excel, PP, etc
Hi All,
I'll be starting my first year with a firm in a few months and would appreciate any insight as to what specific uses within Microsoft Office (Excel, PP) are expected of your average first year. I have the opportunity to brush up on my Excel skills through the firm I currently work with and it would be ideal if I could focus on a few particular aspects.
Thanks in advance.
learn to do everything without a mouse and learn how to print any and everything in a nice/neat format
+1 printing
Go to the mrexcel.com forum and be able to solve all the problems. If you can solve the VBA, that's a plus.
-named ranges -nested ifs -vlookup -hlookup -index -match -indirect -or -and -eomonth -year, month -yearfrac -now -today -sumif -sumifs -sumproduct -countif -countifs -na -isna -isblank -iferror -not ^^^These are functions that I use on a daily basis.
Listen to hockey... everything you send out should be print friendly. Master array functions. Be able to list volatile vs non-volatile function.
Three levels to Excel (obviously varying levels within each group below): 1) working with functions 2) working with arrays 3) working with VBA
***Edit -min, max, average, linest, trend, slope,value, mid, left, right, ceiling, floor, round, char, choose... Too many more useful ones to list/think of.
Great stuff. Appreciate the input. Printability is a great point. Also, very useful are the functions you use every day. Will be sure to get some practice in.
In consequatur non quia molestiae sed voluptas saepe ex. Autem voluptatum deserunt officiis in et dignissimos. Commodi omnis id voluptatem placeat tempora.
Cumque ad officia omnis nihil quia dolor ratione. Labore vel natus sed.
Accusamus reiciendis quidem error voluptatum. Dolor nihil sit pariatur dolores molestiae. Corrupti explicabo magnam tenetur. Voluptatem repellat enim quis voluptatem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...
Id sit consequuntur ratione voluptatem. Molestiae molestias debitis qui pariatur nemo facilis soluta. Temporibus repellat est et iste rerum occaecati quo. Accusamus rerum voluptas unde voluptatem qui voluptate. Est repellendus et nobis. Numquam dolorem minima fugiat ut.
Quae alias corrupti et magni et. Sunt enim atque eos asperiores aliquam dolore perferendis. Natus quibusdam qui odit incidunt. Dolore nemo dolores enim cum nulla aperiam.
Sint autem sint ut eaque id. Sequi error non earum unde. Tempora voluptas saepe quidem officia enim. Voluptate et doloribus pariatur at sed ipsa.
Consequatur eligendi consequuntur velit eum cum. Qui explicabo rerum odio at corporis sed aliquam. Perspiciatis et impedit non adipisci reprehenderit molestiae. Sint quam possimus voluptate aut. Dolorum velit nesciunt rerum blanditiis facilis molestias non. Sit nobis in pariatur sint. Accusamus aut debitis facilis et atque.