Uploaded November 2021 | Updated November 2026, 2 days ago
Join us at this Excel Meetup to hear from Vivek Bavishi
from India ๐ฎ๐ณ about "Power Apps Formulas vs Excel Formulas".
In this presentation, we will discuss how Power Apps and Excel formulas are very similar and how knowing Excel helps a lot in creating Power Apps apps.
We will also learn how to connect to Excel as a data source and some common mistakes that you could avoid.
---------------------------
About the Speaker
---------------------------
Vivek is a Senior Solutions Consultant who has been playing around with PowerApps and Flow for more than 2 years now and loves sharing his experience with the Power Platform / PowerAddicts community.
He likes connecting different APIs to PowerApps using Flow and has made some crazy PowerApps including Random Movie recommendations, Face Recognition, YouTube Deck, Smart Home Automation, and many more.
He writes blogs, makes videos, tweets the latest Power Platform updates and shares his work on GitHub. If you need to connect with him, Twitter is the quickest way to reach out or you can e-mail him at vivekbavishi@gmail.com. He is always happy to help and share with the community.
--------------------------------
Connect with Speaker
--------------------------------
Website: https://thatapiguy.tech
Blog: https://thatapiguy.tech
LinkedIn: linkedin.com/in/vivekbavishi
YouTube: youtube.com/thatapiguy
Twitter: twitter.com/that_API_guy
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).
Join us at this Excel Meetup to hear from Vivek Bavishi
from India ๐ฎ๐ณ about "Power Apps Formulas vs Excel Formulas".
In this presentation, we will discuss how Power Apps and Excel formulas are very similar and how knowing Excel helps a lot in creating Power Apps apps.
We will also learn how to connect to Excel as a data source and some common mistakes that you could avoid.
---------------------------
About the Speaker
---------------------------
Vivek is a Senior Solutions Consultant who has been playing around with PowerApps and Flow for more than 2 years now and loves sharing his experience with the Power Platform / PowerAddicts community.
He likes connecting different APIs to PowerApps using Flow and has made some crazy PowerApps including Random Movie recommendations, Face Recognition, YouTube Deck, Smart Home Automation, and many more.
He writes blogs, makes videos, tweets the latest Power Platform updates and shares his work on GitHub. If you need to connect with him, Twitter is the quickest way to reach out or you can e-mail him at vivekbavishi@gmail.com. He is always happy to help and share with the community.
--------------------------------
Connect with Speaker
--------------------------------
Website: https://thatapiguy.tech
Blog: https://thatapiguy.tech
LinkedIn: linkedin.com/in/vivekbavishi
YouTube: youtube.com/thatapiguy
Twitter: twitter.com/that_API_guy
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).


![Use XLOOKUP & XMATCH to Lookup last matching value in the column
In this video, we will learn how to use XLOOKUP & XMATCH to get the last record or lookup the last matching value in a column. In order to achieve the last record value. XLOOKUP & XMATCH have made the construction of the formula very easy comparing with the classic way of building the formula. This solution will work with the new Excel Calculation engine & Excel Online only.
โฑ Time Stamp
00:00 Intro
00:40 Understanding Dataset
01:35 XLOOKUP last match value
03:10 XMATCH last match value
04:00 Handling Index #REF! error with XMATCH
04:35 End
๐ Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family ๐จโ๐ฉโ๐งโ๐ฆ so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
๐ https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
๐๐ป Like Facebook Page :
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
VLOOKUP Data From Multiple Worksheets [Excel for mac & windows]
https://youtu.be/ROym3e-S4OQ
Lookup last matching value in the column (Excel - Mac & Windows)
https://youtu.be/bh9ELJflc_Y
Learn Exactly How to Get Crude Oil, Natural Gas & Other Commodities Prices in Excel
https://youtu.be/lLoY1mnZYEw
Extract Number & Text from a Cell in Excel | Solution 02 by Power Query
https://youtu.be/iei5rMstlJ0
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Use XLOOKUP & XMATCH to Lookup last matching value in the column](https://i.ytimg.com/vi/5mxkYqXEnqA/mqdefault.jpg)






![Right way to ALWAYS download Microsoft Office Mac from Office.com
In this video, we will see which is right place to download Microsoft Office apps for mac. Why there are two difference places to download Microsoft Office for Mac. We will also see how to register for Office Insider Program.
โฑ Time Stamp
00:00 Intro
00:22 Compare & how to download
02:00 Install Microsoft Office from Office.com
02:47 What is Microsoft Autoupdate
03:10 Enroll for Office Insider Program
03:30 Type of Office Insider Programs
04:30 End
๐ Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
- Resources: https://excelexciting.com/resources/
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family ๐จโ๐ฉโ๐งโ๐ฆ so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
๐ https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
๐๐ป Like Facebook Page :
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
Learn how to use Microsoft Flow/Power Automate
https://youtu.be/HQyxnPYW9Jc
Create Dynamics Flowcharts by connecting EXCEL to VISIO
https://youtu.be/xfIPFiAxQcQ
Hindi-Convert Number to Words In Microsoft Word [mac & windows]
https://youtu.be/mWmgbU97ZUs
Trick to Create A Data Entry Table In Power Query for Excel
https://youtu.be/bHPrRbcw6f0
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Right way to ALWAYS download Microsoft Office Mac from Office.com](https://i.ytimg.com/vi/7UlmxqG66_E/mqdefault.jpg)
