I’ve recently shared a video on YouTube comparing Microsoft Power Automate Copilot and direct prompt query to ChatGPT4. The video demonstrates how to set up a daily check using Copilot within Power Automate, showcasing the process of adding an Outlook event, listing events, and creating an Asana task to achieve a “no code/low code” solution. Throughout the video, I face challenges, particularly in filtering events, and seek assistance from Copilot to streamline the workflow. From testing the flow to implementing the OData Data Filter with no code typed, I share my experiences and insights in h ..read more

There’s a French saying that goes “the shoemaker always has bad shoes,” which basically means that people in certain professions tend to neglect their own needs while fulfilling those of others. In my case, this expression has proven true. I regularly create complex workflows for my clients, yet I failed to notice that one of my own automations stopped running a while ago! I have a few automations in place to manage my social media, and one of them involves pre-creating a WordPress Post whenever I publish a new YouTube video. This allows me to simply edit the post on my blog and decide whether ..read more

I have been away. I was taking most of the summer on a road trip in the south of France with friends and family. I met up with some friends to do some activities like downhill mountain biking in the Alpes (with an instructor to stay alive!), partying for 3 days at a music festival (without my kid!), and after the festivities, we needed to quickly sort out our debts. And also, as a business owner, company of one and freelancer, I needed to be able to access and edit my data on the go. That’s why it’s so important to have mobile apps that let you open and manipulate your spreadsheets. Thanks to ..read more

I talked about how excited I was a few months ago when it was announced. Now we have the date for general public release to enterprise licensees: 1st November! Copilot is going to be integrated into virtually every Microsoft Apps that you already use. Think about Windows, Word, Excel, PowerPoint, video editor Clipchamp, and much more. I am getting ready by reading and playing a lot with Microsoft AI and Copilot so that I can soon come up with the best approaches for my clients to be even more productive and save time. References: https://www.theverge.com/2023/9/21/23882173/microsoft-windows-1 ..read more

Sometimes, we use functionality in an Office App and forget that what is easy for us is not always known by the beginner user. Here is one in Excel that they definitely need to use and learn all the ins and outs: Pivot Tables! Pivot Tables in Excel have been around since 1994 in Excel v5! Can you believe it? And still… it is not clear for many users but I believe it’s only the fear to try it out. So in this video, I am showing you how to get started if you heard of it and never had the time to create one. It’s actually quite simple, but really powerful! The post ? New Video Upload : Introduct ..read more

Since I teach digital skills on Microsoft topics and also Digital Marketing, let’s talk about this important Digital Marketing topic which is Web Analytics.  I am showing Google Analytics and also SquareSpace analytics. Using one of my websites to illustrate how you can read the reports as a “quick intro to Analytics”. Two aims in this walk-through: Understand what your users do on your website Understand where your visitors come from before they open your website The post ? New Video: Why you should care about your Web Analytics appeared first on Francois Tells Tech ..read more

Quelques tuyaux ou “Best Practice” que j’explique a mes stagiaires: Comment… – Masquer mes conversations – Garder / épingler mes conversations en haut de la liste – Comment désactiver les notifications de certaines conversations – Utiliser les filtres de conversations The post ? In French: Nouveaux tuyaux pour gérer les conversations dans MS Teams appeared first on Francois Tells Tech ..read more

Post in French this time – or for bilingual people who may have the same issue. And no.. no solution yet :-(. Un bug très très énervant sur Microsoft Teams: si vous utilisez plusieurs langues, il vous faut changer la langue parlée pour chaque réunion, ce qui est vraiment ridicule! Please please Microsoft, fix this tiny weeny setting! #CannotBeJustMe #multilingualTeams #MSTeamsLangues Microsoft “UserVoice” Feedback Portal has a few requests to improve this, but clearly, we need more people to vote for them. The post ? in French: A simple issue that should be fixed if there were more daily bili ..read more

What is Power Query? Power Query is a data transformation and data preparation engine.  source: https://docs.microsoft.com/en-us/power-query/power-query-what-is-power-query  This amazing tool comes embedded into Excel and is still quite unknown by many Excel users. In this walkthrough video, I am giving you a quick intro to the tool and an explanation of the relationship between Excel, Power Query and also where Power BI fits into the picture.  The post ? Introduction to Power Query: it’s simple than you may think appeared first on Francois Tells Tech ..read more

Finally! Microsoft To Do for Windows now has Natual Language Processing! It took some time but we have it!! Come on, go ahead and try it, you know you want to. The same way that you speak to your personal assistant and say “Buy chocolates for Steve this Saturday at 3pm”, now you can just type it and hit enter! The post MS To Do is adding natural text feature appeared first on Francois Tells Tech ..read more