tag:blogger.com,1999:blog-375554718988160922024-02-20T21:47:27.180+11:00(The New) Office CoachA Resource Site for the Microsoft 365 and Google WorkspaceAnanda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.comBlogger406125tag:blogger.com,1999:blog-37555471898816092.post-52572549045170264152023-10-03T15:42:00.007+11:002023-10-03T15:42:44.040+11:00Speaking Parseltongue in Excel<p> Python in Excel is now a thing. At least in <i>some</i> Insider Builds of Microsoft Excel for Windows. One of my machines has it. <a href="https://anandasim.notion.site/Excel-and-Python-c3117be3ee5c45c18efba7b94b706231?pvs=4" target="_blank">Now investigating</a></p><p><br /></p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-12242290392994381022023-10-03T15:38:00.001+11:002023-10-03T15:38:01.207+11:00What's new 2023<p> I've been on my back for a few months following some unexpected surgery. It's been a mental reset and also interesting that tech keeps marching on, whether I'm actively participating or not.</p><p>What's new? Microsoft Loop is now available in my personal Office 365 subscription. Having a play now. <a href="https://home.microsoftpersonalcontent.com/:fl:/g/contentstorage/CSP_82b23f0c-5d36-4e18-8ec4-8d449a95119d/IQIoCOukvuI9RbuFZGC5IAxYASJLTv7XqssI7Ffr1Nywd38?e=yGysGB&nav=cz0lMkZjb250ZW50c3RvcmFnZSUyRkNTUF84MmIyM2YwYy01ZDM2LTRlMTgtOGVjNC04ZDQ0OWE5NTExOWQmZD1iIURELXlnalpkR0U2T3hJMUVtcFVSblRYRnNhRWVRN1JEaVVoMEJReUlNSkFXMXdRcUFiZzJRYVFnZ2FvX1VFMTEmZj0wMUhNTFJMQ0JJQkRWMkpQWENIVkMzWEJMRU1DNFNBRENZJmM9JTJGJmZsdWlkPTEmYT1Mb29wQXBwJnA9JTQwZmx1aWR4JTJGbG9vcC1wYWdlLWNvbnRhaW5lciZ4PSU3QiUyMnclMjIlM0ElMjJUMFJUVUh4b2IyMWxMbTFwWTNKdmMyOW1kSEJsY25OdmJtRnNZMjl1ZEdWdWRDNWpiMjE4WWlGRVJDMTVaMnBhWkVkRk5rOTRTVEZGYlhCVlVtNVVXRVp6WVVWbFVUZFNSR2xWYURCQ1VYbEpUVXBCVnpGM1VYRkJZbWN5VVdGUloyZGhiMTlWUlRFeGZEQXhTRTFNVWt4RFExaFlTVmxaUms5R00xWkdRbGt6UjB4UlVGUkRVa3RWTkVrJTNEJTIyJTJDJTIyaSUyMiUzQSUyMmE5MjdiMjE3LTJlNGYtNDBiNi1hMzBlLTM3NDMwMzdkYjM2MyUyMiU3RA%3D%3D">Microsoft Loop</a></p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-16265202671108757112022-11-18T21:56:00.000+11:002022-11-18T21:56:01.334+11:00When your ChromeOS device is offline<p>I have a Lenovo Duet 3 original version. I'm used to working online with Google Apps and files in Offline mode. However, people often ask "Can a Chromebook / Chrome OS device work properly offline? "</p><p>I just looked around at offline options</p><p></p><ul style="text-align: left;"><li>You can set Google Drive documents to Offline and use Google Docs, Sheets and Slides offline. It sounds doable but it's not working with a Windows laptop with a hard disk, really.</li><li>One recent option is to install Collabra Office (Libre Office roots) - it's on Google Play Store (Android). One thing to watch out for is to keep your Android Web Viewer up to date otherwise various features don't work properly.</li><li>Obsidian is a thought outliner which also saves to local storage and does not have to be online.</li></ul><div><br /></div><div>Give them a try</div><div><br /></div><div><br /></div><p></p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-3996751456842880962022-11-11T21:16:00.001+11:002022-11-11T21:16:09.960+11:00Google Sheets vs Microsoft Excel worksheet functions index<p> It's been a while since I shared it. New functions had crept in. Yeah, maybe I could use a dynamic range. But in the meantime, here it is <a href="https://docs.google.com/spreadsheets/d/1PIxfrYdiZk1EJiHJDgura0ek15Fg3W9vgLKLJlyZqBo/edit?usp=sharing">https://docs.google.com/spreadsheets/d/1PIxfrYdiZk1EJiHJDgura0ek15Fg3W9vgLKLJlyZqBo/edit?usp=sharing</a> </p><p>Enjoy!</p><p><br /></p><p><br /></p>
<iframe src="https://docs.google.com/spreadsheets/d/e/2PACX-1vT3GsPsCdBJm3hCORS61K-OMjeRsg-l2Yo7eb2zjgV-js07VttmZkgsbeoQvv5ZOecZgFJ5VSOHD5Nv/pubhtml?gid=0&single=true&widget=true&headers=false"></iframe><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-47363578979326819262022-06-14T21:18:00.004+10:002022-06-14T21:18:30.611+10:00Ctrl+Shift+A<iframe src="https://www.linkedin.com/embed/feed/update/urn:li:ugcPost:6938480719610486784" height="948" width="504" frameborder="0" allowfullscreen="" title="Embedded post"></iframe><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-21332437666105873032022-02-17T10:44:00.010+11:002022-02-17T10:44:51.373+11:00Nominating your Trusted Location(s) in Microsoft Access<p>If you have not heard the news, Microsoft is continuing down the path of treating VBA as a <i>hostile entity</i> even though it has been carrying the bulk of Microsoft Office defence against the darkness of competitors. The latest news is that VBA is being disabled unless the file(s) live in a <i>Trusted Location</i> or are <i>Digitally Signed</i>. Mike Wolfe has written an extensive article on how to bulk / mass rollout Trusted Location tweaks. Thanks Mike!</p><p><a href="https://nolongerset.com/hklm-trusted-location-in-ms-access/">https://nolongerset.com/hklm-trusted-location-in-ms-access/</a></p><p><br /></p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-54858813937652841602022-01-26T11:07:00.002+11:002022-01-26T11:07:08.252+11:00Embedding Your Notion<iframe src="https://embednotion.com/embed/crrlgaqb"></iframe> <style> iframe { width: 100%; height: 500px; border: 2px solid #ccc; border-radius: 10px; padding: none; } </style><div><br /></div><div><i>If you can't see anything, my test embed in Notion has expired after 30 days</i></div><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-80560972996525489212022-01-15T23:33:00.006+11:002022-01-15T23:40:14.901+11:00Notionally Linking Tables<p> I've been having a go with <a href="https://www.notion.so" target="_blank">Notion</a> - it's a significant milestone in note taking and other uses. The evolution so far:<br /><br />Plain Text > Rich Text > Outliner > Wiki > Notion (Componetised Pages)s</p><p>A Notion table (a.k.a Database) can relate to another Notion table. The tables have a One to Many relation. The <a href="https://www.notion.so/help/relations-and-rollups" target="_blank">Relation</a> can use only one column in each participating table as the link.</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhmghZ_aIQodobtUsAIFudyRHnyJDAEcVJnr73ZSa3PiL32FSjAsqPQ-4mbokXTUZDVaN0VR1h1eTkuDpG2K780KT_9B9yvPpMuhFK3OjX_uefUq-tTChiJSbX75mAMmxv15iXXcqTkSH-Y0U8af5hx7qNmKjgOLoF2YEU58SgZnFZ0Os67qpfzvhUz=s719" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="569" data-original-width="719" height="506" src="https://blogger.googleusercontent.com/img/a/AVvXsEhmghZ_aIQodobtUsAIFudyRHnyJDAEcVJnr73ZSa3PiL32FSjAsqPQ-4mbokXTUZDVaN0VR1h1eTkuDpG2K780KT_9B9yvPpMuhFK3OjX_uefUq-tTChiJSbX75mAMmxv15iXXcqTkSH-Y0U8af5hx7qNmKjgOLoF2YEU58SgZnFZ0Os67qpfzvhUz=w640-h506" width="640" /></a></div><br /><p><br /></p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-53969894102089731692021-12-15T18:19:00.003+11:002021-12-15T18:19:26.516+11:00Putting Collaboration and Coordination First<p>I grew up with MS-DOS. Word, Symphony, Paradox/DOS, even Reflex. These pillars of personal computing - dealing with words, dealing with calculations, saving and retrieving many rows of data, charting were modernised in Microsoft Windows - Word, Excel, PowerPoint, Microsoft Access. But they're still the same genre of apps. </p><p>Email came of age by 2000 but real collaboration and teamwork apps came much later. So, in this modern world, many of us still think email (some people store heaps in Microsoft Exchange), word processing, a relational database.</p><p>Quietly though, a new genre of functions have evolved into our classic apps. <i>Real-time-team-editing</i>, <i>just-in-time-revisions</i>, have become crucial to our workflow. I'm looking at right now, <a href="https://airtable.com/" rel="nofollow" target="_blank">AirTable</a> and <a href="https://www.notion.so/" rel="nofollow" target="_blank">Notion</a>.</p><p>The traditional software giants and leaders Microsoft and even Google have actually come late to the party. So they are engineering twists into their traditional apps.</p><p>Mike Tholfsen has put up this Microsoft Teams preview of <a href="https://www.microsoft.com/en-us/microsoft-loop?ms.url=microsoftcommicrosoft-loop" rel="nofollow" target="_blank">Loop</a> and towards the end, shows how these <i>micro-documents </i>are just <b>.fluid</b> files on OneDrive.</p><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="" class="BLOG_video_class" height="505" src="https://www.youtube.com/embed/jOrUZO3NOAo" width="608" youtube-src-id="jOrUZO3NOAo"></iframe></div><br /><p><br /></p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-54579133211249675142021-12-10T19:11:00.007+11:002021-12-10T19:45:04.725+11:00Listen up, there are two kinds of Pivot Tables<p> I was thinking of demonstrating how one could break out of the rigidity of <a href="https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576" rel="nofollow" target="_blank">Excel PivotTable</a> entities (you can't move the cells in a PivotTable around, you can't arbitrarily insert blank columns or rows in the midst of the block of cells) by using Excel's CUBE worksheet functions. Then I realised, eh, there are two kinds of PivotTables and only one of them has that facility.</p><p>There is the classic PivotTable created by sitting on a cell in your source data block of cells and invoking <b>Insert > PivotTable</b> - this type of PivotTable doesn't feature CUBE formulas or OLAP Tools.</p><p>The PivotTable that does offer this feature is the PivotTable created by the <a href="https://support.microsoft.com/en-us/office/power-pivot-overview-and-learning-f9001958-7901-4caa-ad80-028a6d2432ed" rel="nofollow" target="_blank">Power Pivot</a> system and is driven by an <a href="https://support.microsoft.com/en-us/office/overview-of-online-analytical-processing-olap-15d2cdde-f70b-4277-b009-ed732b75fdd6#bmolap_features_in_microsoft_excel" rel="nofollow" target="_blank">OLAP </a>engine (In Excel, Microsoft likes to call this the Data Model). This type of PivotTable features CUBE functions and DAX. </p><p>A nice diagram illustrates the difference at <a href="https://thesmartmethod.com/excel-olap-pivot-tables/" rel="nofollow" target="_blank">TheSmartMethod</a>.</p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-89659969017944167232021-12-03T14:57:00.001+11:002021-12-03T14:57:12.414+11:00Gitches in the Power Query display<p> When I launch Power Query from desktop Excel and subsequently invoke some feature which shows a pop up dialog, that pop up dialog is white and blank. I run two external displays from a dock and notebook connection. One of the displays is UHD / 4k resolution - sometimes the font used in Power Query is really small. Found out there's a Display Settings choice next to the zoom gadget on the bottom right corner of Excel.</p><p>If you have a similar problem, try either one to see whether your situation improves.</p><p><br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhxuGA5J7iJYvMQOg4r2TECAODb2ES5tjagSC2NDJhD3TgfKthtrg2k51DWRNL8WOxvLaJEIkZFzC1sLbzRvy0A-53EoJbr-BW01az05F7fnm0DRZmpJdohMVlE3-WmCdLeUbes7wq9vsilAuwlTWB2kmdb9TeSXs18lw0fpXsBGtNoi60483o81y22=s895" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="342" data-original-width="895" height="244" src="https://blogger.googleusercontent.com/img/a/AVvXsEhxuGA5J7iJYvMQOg4r2TECAODb2ES5tjagSC2NDJhD3TgfKthtrg2k51DWRNL8WOxvLaJEIkZFzC1sLbzRvy0A-53EoJbr-BW01az05F7fnm0DRZmpJdohMVlE3-WmCdLeUbes7wq9vsilAuwlTWB2kmdb9TeSXs18lw0fpXsBGtNoi60483o81y22=w640-h244" width="640" /></a></div><br /><p><br /></p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-63881072526600058492021-12-03T13:31:00.004+11:002021-12-03T13:33:25.361+11:00Just when you might get jaded with the look of Excel<p> </p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiMgHmh78MIt1kzODusisfRWpioM1MptedT774weBIjXiZHyyG7C82Zc4YkYW8RRcT0YBBYkVgOj0ooG5ATJDNqytadr-XW6sB2MGbOQK_JbWiscANcbWYfk3VVgKR6O7fDitZNFrvyr4gbGcU_J6mEQrn80AG98YVbVLXh92tW52Fgqfu53HhlMB-M=s3825" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="2021" data-original-width="3825" height="338" src="https://blogger.googleusercontent.com/img/a/AVvXsEiMgHmh78MIt1kzODusisfRWpioM1MptedT774weBIjXiZHyyG7C82Zc4YkYW8RRcT0YBBYkVgOj0ooG5ATJDNqytadr-XW6sB2MGbOQK_JbWiscANcbWYfk3VVgKR6O7fDitZNFrvyr4gbGcU_J6mEQrn80AG98YVbVLXh92tW52Fgqfu53HhlMB-M=w640-h338" width="640" /></a></div><br /><p></p><p>Click on the Excel image if you want to see it bigger. </p><p>Oh, you can reset it here</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEj-xLEQ7ekfax8XiF19MEIW-awMOBxtSXb3tq6FrYLj8Bp1oqgZJMKquxNCbqfhOgjthYeAj3QuxjramkrUZr-QqqEx45rCrJ6NS08d0earQYNx9VOf7vz2tqOk0_f9E-ru8Gm-XaH4INzNX9bBIA3gfLk-709KzuIonbDYRs-0Z1Y6VfYd5pHbRTsk=s1244" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1029" data-original-width="1244" height="331" src="https://blogger.googleusercontent.com/img/a/AVvXsEj-xLEQ7ekfax8XiF19MEIW-awMOBxtSXb3tq6FrYLj8Bp1oqgZJMKquxNCbqfhOgjthYeAj3QuxjramkrUZr-QqqEx45rCrJ6NS08d0earQYNx9VOf7vz2tqOk0_f9E-ru8Gm-XaH4INzNX9bBIA3gfLk-709KzuIonbDYRs-0Z1Y6VfYd5pHbRTsk=w400-h331" width="400" /></a></div><br /><p><br /></p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-67309398435695037752021-11-29T11:03:00.001+11:002021-11-29T11:03:03.616+11:00Microsoft Office Skills AND a Gmail address? Hire Him Now!<div style="text-align: center;"><iframe allow="autoplay; clipboard-write; encrypted-media; picture-in-picture; web-share" allowfullscreen="true" frameborder="0" height="591" scrolling="no" src="https://www.facebook.com/plugins/video.php?height=476&href=https%3A%2F%2Fwww.facebook.com%2FCollegeHumor%2Fvideos%2F245973544266729%2F&show_text=true&width=476&t=0" style="border: none; overflow: hidden;" width="476"></iframe></div><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-62464574274842479962021-11-26T18:43:00.006+11:002021-11-26T18:43:46.504+11:00Word, Excel, PowerPoint and Save Locations<p> I started out writing about Excel but to a large extent this applies to Word and PowerPoint as well.</p><p>These three <i>Desktop Apps</i> (whether on Windows or Mac OS) started out with what I would call classic file save behaviour, opening files from and saving files to <i>local disk</i> (floppy, hard disk, USB stick, shared LAN drive). Come forward to 2021 and now these desktop apps have <i>Online Web Apps</i> counterparts (Excel Online, Word Online, PowerPoint Online) with data files stored in the cloud (Microsoft OneDrive, Google Drive).</p><p>For those who work with this mix and match environment every day, they take it in their stride.</p><p> However, if you new to all this, it's time to list out the combinations and the features</p>
<iframe frameborder="0" height="886" scrolling="no" src="https://onedrive.live.com/embed?resid=ED4D5DC800CD99CF%21144066&authkey=%21ABVQuS4iXHH-ABI&em=2&wdAllowInteractivity=False&Item='Sheet1'!A1%3AI9&wdInConfigurator=True" width="700"></iframe><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-52217087645606022312021-11-10T13:32:00.001+11:002021-11-10T13:32:05.407+11:00Getting into Excel Tables<p>The first time I encountered Excel Tables I fell in love with them. They allow you to encase the unruly Excel grid that looks like a table into a valid Table, with useful Header Rows that offer sorting and filtering controls, a funky (sub)Totals footer that you can invoke or hide away. And <a href="https://peltiertech.com/structured-referencing-excel-tables/" target="_blank">Structured References</a>. <a href="https://www.myexcelonline.com/podcast/006-excel-tables-with-zack-barresse-excel-podcast-from-exceltables/" target="_blank">Zack Barrese</a> and Kevin Jones have authored a <a href="http://exceltables.com/book/" target="_blank">detailed book</a> on this topic. Thanks to <a href="https://www.linkedin.com/in/merod/" rel="nofollow" target="_blank">Carlos B.</a> for putting a rabbit hole in my path. </p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-91454686536283529052021-11-10T11:14:00.005+11:002021-11-10T12:05:13.222+11:00Time to Tango?<p>I'm a fan of <a href="https://support.microsoft.com/en-us/windows/record-steps-to-reproduce-a-problem-46582a9b-620f-2e36-00c9-04e25d784e47" target="_blank">Windows Steps Recorder</a> for creating learning / training illustrated documents. Despite the fact that Microsoft single purposed it as an issue reporting tool, thus putting the html and graphics in a .zip file that you have to unzip before you can edit. </p><p><br /></p><p>I'm on <a href="https://www.computerworld.com/author/JR-Raphael/" target="_blank">JR Raphael</a>'s email newsletter and he mentioned <a href="https://app.tango.us/app/home" target="_blank">Tango</a>, a Chrome extension and webapp that records your web browser screen, intelligently adds Steps narratives and then allows you to edit the narrative. You can then place the workflow on their website to share or download it to your desktop.</p><p>Here's <a href="https://app.tango.us/app/workflow/563682f0-c5d3-4bfe-abb8-5e7442b3b443" rel="nofollow" target="_blank">my first workflow</a> as a demonstration.</p><span></span><p><br /></p><p><a href="https://app.tango.us/app/workflow/563682f0-c5d3-4bfe-abb8-5e7442b3b443" target="_blank"><span></span></a></p><a name='more'></a><a href="https://app.tango.us/app/workflow/563682f0-c5d3-4bfe-abb8-5e7442b3b443" target="_blank">Google Sites has a Version History for easy undo of massive changes</a><p></p>
<div></div>
<div><h3>1. <a href="https://sites.google.com/d/156lQ8DXCtfyPG3RXMHNEDkYKDe4bzVbu/p/1dAYypP0HA8g5M5DarYvwHeE4ieX5eTl4/edit" target="_blank">Go to your Google Site</a></h3>
<img alt="Go to your Google Site" src="https://images.tango.us/public/screenshot_8d2c2de2-b3d8-4b15-b71a-4d446401b4a9?crop=focalpoint&fit=crop&ar=1920%3A937" width="600" />
</div>
<div><h3>2. Click on the vertical elipsis (three vertical dots) to the left of the Publish button</h3>
<img alt="Click on the vertical elipsis (three vertical dots) to the left of the Publish button" src="https://images.tango.us/public/screenshot_0f8db64b-b293-43c1-8c39-5ce697a2c084?crop=focalpoint&fit=crop&fp-x=0.890625&fp-y=0.03628601921024546&fp-z=3.0711242215667&ar=1920%3A937" width="600" />
</div>
<div><h3>3. Click on Version history</h3>
<img alt="Click on Version history" src="https://images.tango.us/public/screenshot_a876f0cc-0ad0-4ab6-aa3d-aea1e82305c9?crop=focalpoint&fit=crop&fp-x=0.928125&fp-y=0.08751334044823907&fp-z=2.99265410412009&ar=1920%3A937" width="600" />
</div>
<div><h3>4. Find the version that you want to roll back to</h3>
<img alt="Find the version that you want to roll back to" src="https://images.tango.us/public/screenshot_31c620f3-4f67-465f-9fa7-59dd39a216cc?crop=focalpoint&fit=crop&fp-x=0.91953125&fp-y=0.43383137673425826&fp-z=2.9642518190446063&ar=1920%3A937" width="600" />
</div>
<div><h3>5. Optionally rename that version if you find too many versions confusing</h3>
<img alt="Optionally rename that version if you find too many versions confusing" src="https://images.tango.us/public/screenshot_ebcc213b-ce91-4192-9044-9703f047c880?crop=focalpoint&fit=crop&fp-x=0.91875&fp-y=0.4386339381003202&fp-z=3.0511234125691953&ar=1920%3A937" width="600" />
</div>
<div><h3>6. Click on the vertical elipsis next to the Version you want to roll back to</h3>
<img alt="Click on the vertical elipsis next to the Version you want to roll back to" src="https://images.tango.us/public/screenshot_24a84072-0191-40c4-8562-e7bd7ef03317?crop=focalpoint&fit=crop&fp-x=0.984375&fp-y=0.4386339381003202&fp-z=2.6536391956952707&ar=1920%3A937" width="600" />
</div>
<div><h3>7. Click on Restore this version</h3>
<p>There will be a subsequent confirmation dialog. <br />After you Restore, you don't like the old version, go back to the latest version</p>
<img alt="Click on Restore this version" src="https://images.tango.us/public/screenshot_9e46d645-5046-4133-851d-a4291f0a9a0a?crop=focalpoint&fit=crop&ar=1920%3A937" width="600" />
</div>
<hr />
<div>
<a href="https://app.tango.us/app/workflow/563682f0-c5d3-4bfe-abb8-5e7442b3b443" target="_blank"><em>This workflow was created with Tango.</em></a>
</div><div id="gtx-trans" style="left: -23px; position: absolute; top: 266px;"><div class="gtx-trans-icon"></div></div><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-27989819235759813332021-10-19T12:18:00.004+11:002021-10-19T12:18:20.094+11:00Microsoft (Office) Desktop Programming References<p>Remember when we used to press F1 whether in the Microsoft Office App (Word, Excel etc..) or in the VBA Editor and read a .hlp file that focussed specifically on what we wanted to know? </p><p>Then .hlp gave way to .chm, and subsequently to purely online in Technet? Sometime around then, the reference materials was so inclusive, you would find yourself reading about an unrelated app, not the app you were programming about.</p><p>The latest incarnation of this reference library is in docs.microsoft.com. And again, it's plentiful diverse - ok for linear browsing but if you use the search facility, heaps of content hits are offered unrelated to what you are probably interested in. In the end, I give up and....yes, Google it.</p><p>In case you're disciplined enough to linear browse, here are:</p>
<div>
<table border="1" cellpadding="5" cellspacing="0" summary="" title="">
<tbody>
<tr>
<td width="100">
<p lang="en-US">Access</p>
</td>
<td>
<p><a href="https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/microsoft-access-sql-reference">https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/microsoft-access-sql-reference</a></p>
</td>
</tr>
<tr>
<td width="100">
<p lang="en-US">Excel</p>
</td>
<td>
<p><a href="https://docs.microsoft.com/en-us/office/vba/api/overview/excel">https://docs.microsoft.com/en-us/office/vba/api/overview/excel</a></p>
</td>
</tr>
<tr>
<td width="100">
<p lang="en-US">DAO</p>
</td>
<td>
<p><a href="https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/microsoft-data-access-objects-reference">https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/microsoft-data-access-objects-reference</a></p>
</td>
</tr>
<tr>
<td width="100">
<p lang="en-US">Word</p>
</td>
<td>
<p><a href="https://docs.microsoft.com/en-us/office/vba/api/overview/word">https://docs.microsoft.com/en-us/office/vba/api/overview/word</a></p>
</td>
</tr>
</tbody>
</table>
</div>
<p> More Later... </p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-40179131622010889142021-10-11T16:07:00.013+11:002021-10-13T15:42:01.451+11:00Simple Explainer: What is Microsoft Power BI?<h1>
What is Microsoft Power BI?
</h1>
<p><span style="font-size: xx-small;">revised: 13 Oct 2021</span></p><p>
Although a lot has been written about Microsoft Power BI, sometimes, the
level of explanation is at a different level to what you want or uses
jargon that befuddles the explanation. Here is my attempt at presenting the <i>Big Picture</i> in a
straightforward way.
</p>
<p>
Power BI is a (two part) system that allows you to:
</p>
<ul>
<li>
reach out and <b><i>Extract</i></b> sources of data – Excel
spreadsheets, Access databases, SQL Server / Oracle <i>big iron</i>
databases, even scraps from the Web (HTML lists and tables, Web API
sources)
</li>
<li>
<b><i>Transform</i></b> this data – Usually data that you
reach out and grab are not in a suitable layout / format / structure that
you can use immediately. The easiest example is that each row of data might
be a bill from a supplier, you have more than one bill per day, you may be
interested in a week’s total, a month’s total and so on..
</li>
<li>
<b><i>Load</i></b> the data into charts / tables (we call this <b><i>Visual Tiles</i></b>) so
that you can present information
“up big” to your audience.
</li>
<li>
<b><i>Deliver</i></b> and <i><b>Present </b></i>the Report to your audience.
</li>
</ul>
<p>
Now, you may be thinking that good ol’ Microsoft Excel, born in 1987, 34
years ago, is also capable of <i><b>ETLDP</b></i> (and in fact, it is). You <b><i>can use</i></b> Excel for many of the
same tasks. But
Power BI has some modern features in the presentation and delivery to your
audience.
</p>
<h1>
The Power BI vs Excel comparison
</h1>
<p>
It may also be of value to frame the explanation in what you already know,
Microsoft Excel.
</p>
<table border="1" cellpadding="10" cellspacing="0">
<thead>
<tr>
<td width="20%">
<br /></td>
<td width="40%">
<p align="center">
Modern Excel
</p>
</td>
<td width="40%">
<p align="center">
Power BI
</p>
</td>
</tr>
</thead>
<tbody>
<tr>
<td width="20%">
<p align="left">
Has a way to grab data from various sources (Extract)
</p>
</td>
<td width="40%">
<ul>
<li>Traditional methods – File > Open, Copy / Paste
</li>
<li><b><i>Power Query</i></b> tools in a menu
captioned <b><i>Get & Transform.</i></b>
</li>
</ul>
</td>
<td width="40%">
<p>
Has the same feature, called <b><i>Power Query</i></b>.
</p>
</td>
</tr>
<tr>
<td width="20%">
<p align="left">
Has a way to calculated and transform the data
</p>
</td>
<td width="40%">
<ul>
<li>Traditional methods – menus with smarts to split text in
a cell
</li>
<li>Formulae with Excel worksheet functions to calculate and
transform
</li>
<li>Manual by-hand methods of cutting, pasting, moving
cells….
</li>
<li>Has Pivot Tables
</li>
<li>Has <b><i>Power Query</i></b>
</li>
<li>Has <b>Power Pivot</b> with <b>DAX</b>
</li>
<li>Has Excel VBA Macros
</li>
</ul>
</td>
<td width="40%">
<ul>
<li>Has <b><i>Power Query “M”</i></b> language
formulae for handling tables and columns
</li>
<li>Has <b>DAX</b> language formulae for smart ways
to aggregate, filter and calculate data
</li>
<li><i>Power BI does not have Pivot Tables or Power Pivot</i>
</li>
</ul>
</td>
</tr>
<tr>
<td width="20%">
<p align="left">
Has a way to make Charts and Banners
</p>
</td>
<td width="40%">
<ul>
<li>Has cells with options to change Fonts, Borders etc…
</li>
<li>Has Conditional Formatting
</li>
<li>Has Excel Charts
</li>
<li>Has the Insert menu with Drawing Tools, Text Boxes, Smart
Shapes
</li>
<li>Has Slicers, Timelines and Sparklines
</li>
</ul>
</td>
<td width="40%">
<ul>
<li>Has built-in <b><i>Visuals</i></b> </li><li>Has an ever growing catalog of Microsoft or third party custom Visuals from AppSource gallery. This choice is much more than the built-in visuals provided by Excel.</li>
<li>Can place screen shots of small areas of Excel as Tiles
in Power BI Reports
</li>
</ul>
<p>
Anything that you want Power BI to show to your audience
must be placed as <b><i>Tiles</i></b> on the <b><i>Reports</i></b>
</p>
</td>
</tr>
<tr>
<td width="20%">
<p align="left">
Interactive Visuals
</p>
</td>
<td width="40%">
<ul>
<li>By changing the values of various cells, formulae will
recalculate, the Charts and graphics
</li>
<li>Custom VBA Macros can trigger changes to Charts
dynamically, based on triggers.
</li>
</ul>
</td>
<td width="40%">
<ul>
<li>The Report Pages and the Tiles on them have mechanisms to
filter and recalculate the underlying data without needing
VBA Macros. For certain tasks, you will need to enhance
this feature by writing <b>DAX</b> formulae.
</li>
</ul>
<p>
There is no VBA macro language although there are Python
and R tiles for advanced users.
</p>
</td>
</tr>
<tr>
<td width="20%">
<p align="left">
No Install, No Send Presentation and Delivery
</p>
</td>
<td width="40%">
<ul>
<li>To view the Excel content, the audience needs to have
desktop Excel installed on their devices.
</li>
<li>There is Excel Online that can be displayed on desktops
and mobile devices but Excel Online does not support VBA
macros so you have to avoid using that method to provide
interactivity.
</li>
</ul>
</td>
<td width="40%">
<ul>
<li><b><i>Power BI Desktop</i></b> (the free part
of the Power BI system) publishes to the <b><i>Power BI Service</i></b> (which is a
paid, subscription web portal service available to
companies)
</li>
<li>Reports and Dashboards hosted on the Power BI Service do
not rely on you sending an file to your audience, they are
web pages and display the latest information you publish.
</li>
<li>The Power BI Service can set to fetch data from web data
sources on schedule without needing intervention from you.
</li>
</ul>
</td>
</tr>
<tr>
<td width="20%">
<p align="left">
Data editing and storage
</p>
</td>
<td width="40%">
Excel is the consummate cell and grid editor to an
original or intermediate data store (Excel worksheets
containing cells). You can edit, remove or add more rows,
at will.<ul>
</ul>
</td>
<td width="40%">
<ul>
<li>We don’t think of Power BI as the original source of
data. Sure, you can generate custom Calendar tables or make
small tables for reference use. </li><li>Power BI is used to grab
from other sources and keep the data for the purposes of
drawing the interactive visuals. But you would not use it
as a tool to manually edit and type data rows.
</li>
</ul>
</td>
</tr>
<tr>
<td width="20%">
<p align="left">Interactivity in viewing, analysis, troubleshooting during data preparation</p>
</td>
<td width="40%">
Excel as a traditional spreadsheet, is highly interactive to the creator of the visual, to the person who is preparing the data.<br /><ul><li>Natively, Excel will display every row of data <i>in your face</i> within the limits of capacity, if you want to do that.</li><li>There are a whole bunch of classic spreadsheet diagnosis and analysis techniques for the creator.</li>
</ul>
</td>
<td width="40%">
<ul>
<li>Power BI is NOT a spreadsheet tool. Yes, you can see up to 1000 rows in Power Query Data Preview, but that is 1000 rows, if some inconguity lurks past that number, it's not automatically visible or alerted.</li><li>DAX in Power BI is the complement to Pivot Tables in Excel but does not have the <i>in your face</i> interactiveness that Pivot Tables and Power Pivot in Excel demonstrate.</li><li>Power BI has a lot more automatic, no code interactivity in it's Visual Tiles for the audience</li>
</ul>
</td>
</tr>
</tbody>
</table>
<h1>
So, you may still ask:
</h1>
<h2>
Do I need Power BI if I don’t do charts and stuff?
</h2>
<p>
If your tasks are more towards typing, preparing data, calculation and not
much in the way of reporting statuses or how things are going, Power BI
isn’t much of a tool for you. However, as you continue to work with rows of data in Excel (a source of work for many people around the
world), take the time to expand your Excel skills to cover:</p>
<ul>
<li>
Excel Tables and Structured Formulae
</li>
<li>
Power Query
</li>
<li>
Pivot Tables
</li>
<li>
Power Pivot and DAX
</li>
</ul>
<h2>
I like Excel and have great skills in Excel charting, Excel calculations
and VBA Macros, Can I stay in Excel?
</h2>
<p>
Yes, you can stay in Excel and in fact honing your skills in Excel (and
ancillary tools like Power Query) will always be useful. However, if your
role requires you to deliver these charts and “big picture” visuals to
colleagues regularly, Power BI is the better tool to deliver that without
the traditional need to fling Excel files to people, potentially spreading
so many files that some information leaks outside the company.
</p>
<h2>
Can I just use the free Power BI Desktop without paying for the Power BI
(web) Service?
</h2>
<p>
Think of Power BI Desktop as the design and creation tool. Microsoft is
crafty to give it free because you can skill up on it for free. However, as a deliverable end product, it’s not suitable for delivering to your audience. </p><p></p><ul style="text-align: left;"><li>Each recipient
will need to install Power BI Desktop on their machine so that they can view
the file you send them</li><li>You will be repeatedly sending them an updated file, just like you would need to do with Microsoft Excel</li><li>The interactivity of the final Reports isn’t fully
the same or as convenient. The end user will have menus and screen elements that are for editing, not for browsing information.</li><li>Power BI Desktop offers only Reports, it does not
give you Dashboards or Apps.</li><li>There are no additional security enhancements you can optionally configure to block your audience from playing with your data. You have given them the whole file.</li><li>There might be metadata that you want to keep confidential, stored in the .pbix file.</li></ul><p></p><p><span></span></p><a name='more'></a> <p></p><p>Did what I write help you understand the topic? Keep me going. <br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://www.buymeacoffee.com/sZJLrEl" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="153" data-original-width="545" height="90" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnj7iOOx4m_0QveX0pOOnQIFh6g50oB3NIvgSIplTbU-mRmDD8c85pNdNbPJOPjhNfK86QRdZ9k_IqGE_IYm2POB9_ZeWwKy1UuUBRBOE6KgOTG6J1YyQTaPt0RR4GPzoHhZ9svg_WaTc/s320/default-yellow.webp" width="320" /></a></div><br /> <p></p><p></p><p></p><p></p><p></p><p></p><p><span></span></p><p></p>
<div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-24951148798911225682021-10-04T20:50:00.000+11:002021-10-04T20:50:21.448+11:00Datavizioner Exporter for Power BI Desktop<p>I've been climbing back on the Power BI saddle, motivated for a client and probably to write a book. I tend to read and test a lot in learning products, techniques and concepts. Along the way, I chanced on Datavizioner's products for Power BI. I even got an email from Timothy Roberts asking whether I might write up an explainer from my perspective.</p><p>DavtaVizioner has offers two product:</p><p></p><ul style="text-align: left;"><li><a href="https://www.datavizioner.com/power-bi-documenter/" rel="nofollow" target="_blank">Power BI Documenter</a> (web app optionally used with an <i>External Tool</i> for convenience).</li><li><i>Power BI Exporter</i> (a <i>Power BI</i> <i>External Tool</i>)</li></ul><p></p><h1 style="text-align: left;">Power Documenter </h1><p>Their <i>Documenter</i> looks useful if you work with a fair number of Power BI files - it gives you an review of the internal objects in the .PBIT file - Reports, M Scripts, Models, Dependencies and other elements. It's on subscription plans.</p><h1 style="text-align: left;">Power BI Exporter</h1><p>I was more curious about their <i>Exporter</i> - it's a free little tool to grab the data that is in your .pbix file and spit it out as a bunch of .csv files in a .zip. </p><p>This comes in useful when you want to</p><p></p><ul style="text-align: left;"><li>tinker around with Power Query on a disconnected .pbix.</li><li>dump the data into Excel worksheets so that you can Power Query or DAX from within Excel </li></ul><p></p><h3 style="text-align: left;">Exporter workflow</h3><p>Power BI Exporter grabs the data and saves it in a bunch of .csv files in a compressed zip. It's up to you to make fresh connections to these .csv files from the .pbix and modify the <i>Source</i> of the saved queries.</p><p></p><ol style="text-align: left;"><li>Download exporter .msi file from <a href="http://www.datavizioner.com/power-bi-exporter">www.datavizioner.com/power-bi-exporter</a></li><li>Ensure that Microsoft Power BI is not running and run the .msi file to install the icon so that it appears on the External Tools command bar of Power BI when you next launch Power BI.</li><li>Launch Power BI and File Open the .pbix document you want to operate on.</li><li>Click on the Power BI Exporter icon in the External Tools command bar of Power BI.</li><li>Nominate a folder/filename for the resulting .zip file, and proceed.</li><li>After the .zip file is created, extract the .csv files into a folder.</li><li>Run Power Query and proceed to create new queries pointing to the relevant .csv files.</li><li>You can then create new processing or edit the existing queries that connect to disconnected data sources to instead, use the new .csv files.</li></ol><div><br /></div><p></p><p><br /></p><p><br /></p><p><br /></p><p><br /></p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-22179943239640987432021-08-21T20:27:00.004+10:002021-08-21T20:27:46.155+10:00Starting Microsoft Edge with a specific profile<p> I've been a Google Chrome user for a long while. Once Microsoft Edge launched, I've had a second browser that I can use for different purposes, different roles, different accounts. Yeah, I know I can use different profiles in Google Chrome as well, but it's nice to have a separate browser, Microsoft biased when I work with products like Microsoft 365 or Power BI. So I want to use Edge for those purposes. </p><p>But I have several Microsoft 365 profiles because I work with several different client organisations. So I want to shortcut into a specific profile when I launch Edge.</p><p>Hugo Bernier has<a href="https://tahoeninjas.blog/2021/02/06/launching-edge-with-different-profiles-using-shortcuts/" rel="nofollow" target="_blank"> explicit instructions on how to create a shortcut</a>.<br /></p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-58286522550695991792021-08-17T16:36:00.001+10:002021-08-17T16:36:02.987+10:00The Straight and Curlies<p>Programmers understand the difference between Straight Quotes (which they often use in their programming) and Curly Quotes (which the typography and printing industry is so enamoured of. Here's <a href="https://practicaltypography.com/straight-and-curly-quotes.html" rel="nofollow" target="_blank">an article about the differences</a>.</p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-47049895130584834982021-08-17T00:12:00.003+10:002021-08-17T00:12:21.502+10:00Microsoft Teams opens to a Meeting window not the usual Teams Window<p>I encountered a glitch where Microsoft Teams would open to the pre-Meeting dialog, with no sign of the usual Microsoft Teams window visible.</p><p>Seems it happens to other people too - you have to <a href="https://www.onmsft.com/how-to/how-to-clear-your-microsoft-teams-cache-on-windows-10" rel="nofollow" target="_blank">clear the Teams cache</a>.</p><p>From the article by Dave W. Shanahan:</p><p><span style="font-family: courier;">1. Quit Microsoft Teams.</span></p><p><span style="font-family: courier;">2. Cut and paste the following location into File Explorer:<br /> <span> </span>%appdata%\Microsoft\Teams</span></p><p><span style="font-family: courier;">3. Delete contents of the entire folder.</span></p><p><span style="font-family: courier;">4. Restart Microsoft Teams.</span></p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-55673371173988814482021-07-27T16:04:00.006+10:002021-07-27T16:04:49.147+10:00Microsoft Office 365 becomes just Microsoft 365<p> Not many people go back that far, but I remember a tale about a floppy disk brand - the tale from the 1970s goes to narrate that a certain American floppy disk brand was popular in Russia in the days of the Apple ][. When someone asked what the name of the software they were looking at was, the response was "Wabash" - that being the name on the floppy disk boxes. Of course, that was the name of the floppy disk manufacturer, not at all related to the name of the software product.</p><p>In the earliest days of Windows productivity software (that would be Microsoft Windows 3), the Microsoft productivity products were Word, Excel, Powerpoint. Subsequently they were packaged together as Microsoft Office. Fast forward to 2021, we still know Word, Excel, Powerpoint as Microsoft Office, more often, Microsoft Office 365. </p><p>In Microsoft's evolution of product branding, they've decided to call this suite, Microsoft 365. These product names went into effect March 30, 2020 - but we were so focussed on Covid-19 that we just ignored this. Over Australia, this branding has been implemented in TV ads for the general consumer and progressively in the product splash screens and help documentation and so on.</p><p>What has not changed is the maze of licences which offer different additional features at different prices.</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiU_WtElt_MXt07iCzrlUTjf1gU3FlpSXgOFgyRuSnSmQZPDXSw2Bxgfn1tVoZEV78l75eUN9zV8XDyjXpIJV7z2dCI9DRWrcr0LFy5m6N67-8XPnegdEpTT5kOGsqP2KOvdgOfXmu53Wk/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="274" data-original-width="524" height="299" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiU_WtElt_MXt07iCzrlUTjf1gU3FlpSXgOFgyRuSnSmQZPDXSw2Bxgfn1tVoZEV78l75eUN9zV8XDyjXpIJV7z2dCI9DRWrcr0LFy5m6N67-8XPnegdEpTT5kOGsqP2KOvdgOfXmu53Wk/w573-h299/image.png" width="573" /></a></div><br /><br /><p></p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-62218752494480730192021-07-26T20:32:00.006+10:002021-07-26T20:32:43.250+10:00The 100% Pie Chart<p>Often in my Microsoft Excel classes, I demonstrate and discuss Excel's charting module. Of course, the ubiquitous Pie Chart is the second chart type to touch on. I've often advised people not to use a pie if there are more than, say 7 slices because that type of chart does not communicate proportion well when there are too many slices. Today, I encountered <a href="https://www.facebook.com/DanielAndrewsMP/posts/375117550647342" rel="nofollow" target="_blank">Dan Andrew's pie</a> - whether Dan or his team made it, it's a bonza creative communication technique - use a pie with 100% from one slice. <br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://scontent.fmel15-1.fna.fbcdn.net/v/t1.6435-9/221723742_375180203974410_1700446185043805322_n.jpg?_nc_cat=109&ccb=1-3&_nc_sid=730e14&_nc_ohc=uJrBGoebAekAX81kuqb&_nc_ht=scontent.fmel15-1.fna&oh=3b62fa5843805979c6f2a2332106a152&oe=61249BA5" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="800" data-original-width="800" height="640" src="https://scontent.fmel15-1.fna.fbcdn.net/v/t1.6435-9/221723742_375180203974410_1700446185043805322_n.jpg?_nc_cat=109&ccb=1-3&_nc_sid=730e14&_nc_ohc=uJrBGoebAekAX81kuqb&_nc_ht=scontent.fmel15-1.fna&oh=3b62fa5843805979c6f2a2332106a152&oe=61249BA5" width="640" /></a></div><br /><p></p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0tag:blogger.com,1999:blog-37555471898816092.post-75690267421096844802021-07-17T17:01:00.005+10:002021-07-17T17:01:19.498+10:00Starting a new hub on Google Workspace<p> From recent discussions, I've decided to write a set of articles on Google Workspace and merge some older articles there. The hub is here: <a href="https://sites.google.com/view/workingyourspace/conversations-with-documents" target="_blank">Working Your Space</a> </p><div class="blogger-post-footer">This article originally appeared in (The New) Office Coach Blog</div>Ananda Simhttp://www.blogger.com/profile/10687537365243419292noreply@blogger.com0