![]() ![]() No worries - regarding % difference it really depends what they report on. Sorry for lack of formatting and errors but its 1am and I'm on my mobile Show them how pivots answer regular issues they deal with for their jobs, if you can prepare example data similar to what they work with they grok it much more quickly) Showing them its a built in option usually gets people seeing the point of pivots quite quickly (another redditor suggested context, I'd agree. I'd argue for showing % Difference from Previous as Month to Month, year to year difference is typically a question people have to answer and quite often the reason they take data out of a pivot is so they can do period comparison manually. Show them clean atomic data, insert Table and Named Range to use as a Pivot data source and the rest of the areas are pretty straightforward. They like gaps and big headings and merged cells. ![]() People don't like big sheets of numbers with each individual type of data on a separate row. The most common mistake I see is people trying to get "human friendly" tables into pivots. If they have dimensions (date, year, sales source etc.) as column headers then they'll struggle. I actually do excel training as a side line and I'd agree that showing people how to correctly clean and arrange data in contiguous rows columns first actually solves a lot of the problems people have with pivots. Thank you for the help! I feel like I have found my new favorite subreddit. I am avoiding calculated fields as too advanced for the time being, as well as % difference field settings.Īre there any other pivot table "musts" for people to perform basic data analysis? How to filter a field by value or field name. How to group dates by year, month, qtr.Ĩ. How to choose what goes in rows/columns/filters vs. How to change between count, sum, and avg.ĥ. My current plan is to cover these topics in this order:ī. I am looking for advice and resources on how to introduce the concepts, which features to focus on (and which to avoid), and any existing slides, data sets, or other teaching resources that exist. I am the most advanced Excel user at my workplace (a university admissions office), and I have been asked to teach a class on pivot tables to excel users who are smart, but have zero zip zilch pivot table experience. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |