Leila Gharani shows us how to use Microsoft Forms you can collect data from different people via fillable forms that you can control from Excel.

With Microsoft Forms you can easily create surveys, quizzes and polls. You can export the data to Excel to analyze and share the results with your audience. No programming is necessary, no VBA, no add-ons. Just a Microsoft 365 account (free or paid).

We’ll cover how you can use Microsoft forms to add dropdowns, multiple choice, calendar date selection, number checks, net promoter score, and even star ratings.

Time Stamps

  • 00:00 How to Use Microsoft Forms
  • 01:19 How to Get Started with Microsoft Forms
  • 01:50 Automatic Connection between Excel and Microsoft Forms
  • 02:58 Create Data Entry Form with Microsoft Forms
  • 04:10 Star rating in Microsoft Forms
  • 04:35 Choice in Microsoft Forms
  • 05:08 How to add a drop-down to Microsoft Forms
  • 06:10 Date picker with calendar pop-up
  • 06:30 Add a text box and validate numbers
  • 06:50 Add a Likert scale to Microsoft Forms
  • 07:15 Net Promoter score in Microsoft Forms
  • 07:50 How to Add a Theme to Microsoft Forms
  • 08:09 How to Share a Data Entry Form with Microsoft Forms
  • 09:24 How to Fill Out a Data Entry Form
  • 10:34 Analyze the Responses from Microsoft Forms in Excel
  • 13:39 Grid

Leila Gharani explores the new LET function in Excel.

Excel’s new LET function can make your formulas easier to read and it can improve the performance of your formulas so they run faster. This applies to formulas that use the same expression (e.g. formulas, values) multiple times.

Time Stamps

  • 00:00 Why use Excel’s LET function
  • 01:07 Availability and Syntax of Excel LET Function
  • 03:12 Example of LET Function with IF Conditions
  • 06:53 Example of LET Function with Multiple IF Conditions and Symbols
  • 08:55 Does Excel LET Function REALLY Improve Performance?
  • 11:03 LET Function with Excel Dynamic Arrays
  • 14:46 Performance of Excel LET Function with Dynamic Arrays

In this video Leila Gharani covers the Best 6 FREE Excel Add-Ins to improve your reporting, data analysis and make your life a LOT easier.

Time Stamps:

  • 00:00 Best FREE Excel Add-Ins
  • 00:55 How to Install Add-Ins in Excel
  • 01:45 QR4Office
  • 02:47 Web Video Player
  • 03:41 Visio Data Visualizer
  • 07:16 People Graph
  • 09:14 Mini Calendar and Date Picker
  • 10:49 Bing Maps

Leila Gharani explains why PowerQuery is such a powerful tool.

Excel Power Query has been a part of Excel since Excel 2016! It’s in the Data tab under Get and Transform. Unfortunately many people haven’t explored what it has to offer! They continue doing things the old “manual” way, Or the “complex” way with difficult formulas.

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.