Everyday Office retweeted
New video from @AskEvOffice today about #powerquery in @msexcel - filtering a query by a parameter by using a dynamic drop-down. youtu.be/TX6mmJRwpg8
Everyday Office retweeted
#PowerQuery and #PowerPivot work together in @msexcel to give you incredible power. Here, we create a custom Calendar Table and save it to an Excel template. youtu.be/wjt9mHlfztQ
Everyday Office retweeted
New #PowerQuery video in @msexcel from @AskEvOffice - Get rid of #VLOOKUP, and replace it with an Outer Join! youtu.be/f9k3-7GdxpI
Recalling emails doesn't work in 2020. However, if you use Rules in @Outlook, you can accomplish almost the same thing: youtu.be/Y_Y88kn2V7M #tipsandtricks
Everyday Office retweeted
New #PowerQuery video today: Append all the Tables in a workbook to make a single #PivotTable in #Excel youtu.be/xMXB_-6uLac
In @msonenote you create lists so often (bullets, numbered) that it makes sense to use #shortcuts for them. youtube.com/watch?v=sUxqfcgr…
New #PowerQuery in @msexcel video today: date calculations, simple math, and logical functions youtu.be/iEDdnSVq8T0
Shortcuts get you where you want to go faster, with less frustration. #PPT #PowerPoint #KeyboardShortcut
Everyday Office retweeted
In 2020, you should be using #PowerQuery in @msexcel for hundreds of situations. Here's a powerful example - pulling a live, filtered segment of a huge dataset: youtu.be/q2_FWbZJv3Q
Amazing #PowerQuery tools: flipping columns with Unpivot, and filling rows down youtube.com/watch?v=mEz7XgFQ… #excel #shortcuts
New #PowerPivot video (in @msexcel) from @neilmalek today - replace VLOOKUP with Relationships, and create a multi-table Pivot Table. youtu.be/H0tb1OjKZWU
In today's #Podcast, @neilmalek of @KnackTraining discusses automation, and leaning into the humanity of our work. buzzsprout.com/784982/episod…
Incredible insights and detail about file types, archiving, backing up, collaborating.. @excelwriter knows his stuff! @msexcel #disasterrecovery #disasterprevention #spreadsheets
New episode of @AskEvOffice dropped - critically important conversation with @excelwriter about disaster prevention and recovery. Look for Everyday Office on your podcast app of choice!
1
Goal for 2020: bring as many tangible, real-world examples of #powerquery as possible. In this video, we show how to cut a week of work for a fire department. #youtube #tutorial #Excel
New video: solving a firefighter scheduling problem with Power Query youtu.be/WkF5bGgkUK0
Office 365 Groups are amazingly useful - group email, SharePoint site, Teams, Planner, etc. Here's how to make one: youtube.com/watch?v=7DZP0fYI…





