Jon Levesque Tech shows us Microsoft Lists and Power Automate & how to use a list to power your flow to build an automated set of follow up emails.

Content index:

  • 00:00 – Introduction
  • 03:03 – Looking at the scenario
  • 03:56 – Take a look at Microsoft Lists
  • 04:30 – New List Menu
  • 05:40 – Adding a column to a list
  • 06:15 – My list for this solution
  • 08:10 – The first flow
  • 11:25 – Testing the first flow
  • 12:26 – The second flow
  • 17:01 – Testing the second flow
  • 18:25 – Conclusion and wrap up

Microsoft Mechanics shares this working from home tip: how to change default Outlook meeting length in the desktop app to give others – and yourself – a little time between meetings.

By default, meetings in Outlook are set to 30 minutes, but did you know you can set them to end earlier – as a default when creating future meetings? You can; and we’ll show you how to end meetings 5 or more minutes early for everything you schedule in the future.

For more tips like this, check out the working remotely playlist at https://aka.ms/WFHMechanics

I’ve been a fan of OneNote since I was a Tablet PC MVP, which was quite a long time ago.

However, I never feel like I’m getting the maximum benefit from the tool.

Leila Gharani share her top OneNote productivity tips.

Most of us take notes in some way or another – on a piece of paper, in a notebook, or with some app. But are your notes always readily available when you need them? And more importantly, can you easily find a specific note you’re looking for?

I tried a lot of note-taking systems in the past and I can’t tell you how many great ideas were lost over the years because I just couldn’t find the piece of paper anymore, I scribbled some notes on. It wasn’t until I found a way to use Microsoft OneNote effectively that it changed for the better. Many people don’t know that OneNote is much more than just a digital notebook.

In this OneNote tutorial (in 2020), I explore how you can take full advantage of OneNote, and share my 5 personal OneNote tips and tricks on how you can become more organized.   

Time index:

  • 01:46 Use Hierarchies to Get Organized
  • 04:37 Use Tags to Find What You Need
  • 07:04 Capture Ideas Anywhere With Sticky Notes
  • 08:23 Extract Text From Images
  • 09:35 Focus With Immersive Reader
  • 11:04 Additional features in OneNote you may find helpful (Ink to Shape, Ink to Text, Ink to Math)

Leila Gharani explains how Ideas in Excel work.

Ideas in Excel will provide you with immediate insights about your data. It will help you to quickly create summary reports and high-level visualizations. You can even directly ask it questions about your data using “normal” conversational language. Ideas, is the new artificial intelligence feature built into Excel. It does a really good job in analyzing your data and giving you a summary.

Leila Gharani shares a unique Excel formula.

It’s safe to say this Excel formula syntax has NEVER been seen before. My team and I, did an extensive search on this mysterious Excel formula syntax, but found no information about it. It’s a super short formula in Excel to count cells with text and ignore blank cells, numbers and also formula cells that result in blank cells or empty strings.

This is one of a kind Excel formula hack.