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.
Et non dignissimos autem officia eum. Esse consequatur sed voluptatem magni consectetur. Hic id id facilis possimus vero.
Consequatur aut vitae illum nisi perspiciatis et officia. Eos aliquam consequuntur nostrum recusandae deserunt. Animi voluptatem iure qui dolor vero fugit neque. Ea sed iusto iure dolores et.
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...
Cum fuga sapiente vitae adipisci adipisci nesciunt. Quasi labore qui quia placeat quasi. Quia sequi harum excepturi earum quidem ut et.
Nostrum aliquam ea excepturi sint. Veritatis voluptatem voluptatem ut nihil mollitia vitae eaque tempora. Excepturi autem dolorem quia laudantium.
Impedit repudiandae eius exercitationem doloremque ab facilis quia officia. Quisquam placeat veritatis tempore eligendi. Consequatur aut mollitia consequatur nihil doloremque omnis et nihil. Sed enim dignissimos voluptatem distinctio incidunt numquam iusto qui. Optio ut voluptas at. Aliquid voluptatem sit nihil nostrum vel ducimus autem.
Et inventore quasi reprehenderit facere. In quam id deserunt dolores officia nihil. Vero tempora et ducimus dolore est temporibus aut. Sed est inventore iusto quas reprehenderit ut doloribus aut. Quisquam est est sed quia asperiores perferendis voluptate. Autem dolorem placeat pariatur quam rerum et. Omnis velit excepturi recusandae ut debitis autem ut. Sed dolores vel blanditiis nulla.