Excel is a great program because of it's ease of use both to a positive and a detriment. Realistically 50% of Excels functions are in typing text and numbers into cells the other 50% is in manipulating those text and values (Formulas, VBA, etc.). To put this in perspective Excel is only comprised of 4 layers - Application, Workbook, Worksheet, Object - to go a bit deeper into objects (cell objects specifically) their values can only contain - Text, Numbers, Formulas and Boolean. Great question that poses no right answer. Its just the framework you use to develop your custom code. It isn't really saying anything about your "excel" skills. If you are doing VBA, you have beginner to advanced developing skills. I think you people are talking about making space shuttles in groups that are working on getting their bicycles working. In terms of what Excel is capable of, it should be much harder to get to my definition of "Advanced", but when out of 5000 people, you are one of the 15 that can run a nested if with vlookups, that makes you the one eyed man in the land of the blind.Įdit: Lots of people putting Macros as Advanced. These people also generally have no idea what they did to the data and dont really know what their analysis says "but sales are up 3 percent according to the pivot!"
The ones that "know excel really good" know how to cram data into a pivot table and move things around until it looks like whatever they want it to look like. The thing about the curve is that 99 percent of office workers know word and outlook pretty damn good and act like Excel will give them cancer.
Intermediate: Can type out formulas, have dynamic fields and complex calculations.Īdvanced: Can use more logical excel formulas, chiefly vlookup, if, concatenate, and left/right/mid.Įxpert: Know what VBA is and be able to identify a problem that can only be solved with it (even if you cant actually solve the issue). Let's keep this place tidy!īeginner: Point and click interface. There is no true expert in Excel, because there's always something new to learn! If you can make your own macros from scratch, then you're approaching expert. If you can use everything in the Excel menus and ribbon confidently, then you're an intermediate user. If you can use formulas, simple formatting, validation and graphing tools, then you're a beginner. There are wizards out there that can change an office completely (I have done something similar), and unless they make things stick - people forget! It can do SO much and you can learn everything you want to do just by referring to the toolbar buttons and nothing more.Īnd in an office, people just learn from the predecessor, who also knew nothing so the flow of nothingness continues. People are too scared to muddle around in Excel to see what it can do.
Is everyone really this hopeless at Excel or did I just happen to stumble across an office full of tech illiterate mouthbreathers? Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data.
You can select code in your VBA window, press Tab, then copy and paste into your post or comment. To apply code formatting Use 4 spaces to start each line
This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.