Welcome to my channel! I share videos related to productivity tools, systems and tips to help you get things done better and faster. My goal is to help you save time so you can spend it on the activities that matter.
Ever since learning about tables in Excel I'm stunned that Sheets has no good equivalent. If you're directly referencing columns by letter or rows by number you've instantly failed. Do not pass go, do not collect $200, go directly to jail, and think about your crimes.
couldn't you also just power query and clean and import the new data set into a Table and then refresh all, you know since tables are dynamic and a pivot will update on refresh all along with your source query? literally a few clicks solution, open book, refresh all - In my experience you need to do the refresh all two times though because the pivot will update same time your table is updating so it could miss some of your data. So run Refresh All two times and everything is updated. So simple....... You just made this way harder then it had to be.
@@PerkinsGreg - Good Point, and good content for those that don't have PQ but dang, people need to move off the legacy apps. Power Query has been in every release of Excel since 2016 release, People need to get off the legacy stuff and save themselves a lot of headache. Power Query is where it's at for repetitive tasks, few clicks of your mouse and everything refreshes for you. It just take a little while to set up same as you would have to do with manually doing the data additions., But so well worth the amount of time spent vs the amount of time it saves you every single time you run it you'll be sooooo glad you did. LOL any way's have a good one.
@@PerkinsGreg - Another thought, using something everyone has access to and simplifies this process greatly, is you stated you have to bring this data in every week right?.... Ok so make your Range here in this book a Table that you then paste your info into the Table instead of a Range, since that's what your doing anyways is pasting stuff into that Range.... Then point your pivot table new source to the table you just created and then refresh the pivot. Once this is set up you don't need to change your Pivot source or anything any longer all you need to do is refresh the pivot...... So then your process would be bring in the new data, pasting it into that table then go to Pivot table right click and refresh.... Done. Hope that makes sense and helps as well. Anyways, your making great content, keep it up.
Good basic viz, and I learned some really useful shortcuts in this video. (Never new you cold just copy and paste a line over the dots in a graph; very useful.)
Sorry fella, but this is poor. Some analysts don’t understand that, as a director, I don’t have the time to absorb noise and/or understand elaborate illustrations. A professional analyst understands that it’s not about trying to impress me; it is about making the best use of my time.
Sorry you didn't like it. In reality, different individuals assimilate data in different ways and this clearly is not for you. I have another chart to illustrate in a few weeks, so best not tune in to watch that video 😆
Hi you should be able to right mouse click and add data labels. You’ll need to layer them, so total in the grey bar chart first, the the red and finally the green. There should be an option to add the label to top middle or bottom of the bar
Cool stuff! Nicely presented. My favorite was how you moved the categories just by renaming the cell. I am also eager to try the YOY% tip as well. Thanks and keep up the good work!
Subscribe here 🛎: ru-vid.com/show-UCSMHCVgRSSFV6Z79PpNSxkg Other Time Saving Excel Hacks:https: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Bo_xpvl3Zpg.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-RehBtME8u7I.html
Nice. Although I can't wrap my head around the colon in the sum formula, never used that before I thought that was used for ranges and not sure what it does!
Instead of wrapping two FILTER functions to choose only certain columns, just use the CHOOSECOLS function =CHOOSECOLS(FILTER(B4:H15,(B4:B15=K2)*(D4:D15=N2)),2,4) A lot cleaner and less prone to errors when deciding where zeros and ones should go inside the curly brackets