Its a continuous learning process, I don't think even the MVP s would claim to know everything possible in Excel, so start with getting the basics for your needs nailed then push on from there. Thats what I did to the point where I now do Excel training at client sites and conferences and build custom reports and functional workbooks as a nice little sideline to my main business.ĭespite this I still consider myself intermediate because I know of several more advanced areas where I am woefully less experienced simply because I rarely need to use those features in my work.
Its more likely to stick if you have practical examples rather than theoretical potential you might never need to use. So use it a lot and Google examples of How To for challenges you face for your specific needs. Excel is a bit like Photoshop - you can get very advanced in the 10% that you need and never touch other areas, functions, macros, statistics etc that someone else might need daily. The biggest thing is to use it a lot on the sort of thing you need to do. But I jumped in to the advanced level books early in my career and I'd recommend getting lost with advanced stuff and re-reading as you advance rather than exhausting a simple book and still having unanswered questions. O'Reilly stuff is ok for an introduction to intermediate stage. Don't bother with the For Dummies stuff it's really too basic to be useful. Expensive at the time but worth it and they come with a CD of examples which were very useful. The best of these would be the Microsoft Inside Out series.
Never once paid for online training but to be fair when I started using pre excel spreadsheets like statgraphics and then Excel the only options were books. Self taught with Microsoft help, ozGrid, Mr Excel, Excel is Fun, Excel TV. 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. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block 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.
0 kommentar(er)
