Use Excel & Power Automate | Record Working Hours from Phone & Update LinkedIn from Excel!

Learn to combine Microsoft Excel with Power Automate and get more done! We'll look at two practical examples:
1. Record your working hours. You'll press a button on your mobile when you start and end your work. The time you started and ended your work will automatically be recorded in Excel.
2. You'll create a LinkedIn post directly from your Excel file!

So we'll be making 2 "Excel macros". One that's connected with your mobile and the other with LinkedIn. This is something we couldn't achieve with Excel VBA! Now anyone can create these automations. We don't need to be developers to automate our tasks. Who would have thought this could be achieved so easily?!

In the video, you'll learn how to create a Microsoft flow that uses expressions together with dynamic content. We'll use the IF expression and also learn to convert the timestamp into a proper date and time by using the FormatDateTime expression. We use 'tt' to make sure we can distinguish between AM and PM.

Timestamps
00:00 How to Use Excel in Power Automate
01:20 Record Working Hours on Mobile in Excel with Power Automate
02:32 Create Instant Cloud Flow Triggered from Mobile
05:31 Manually Trigger Flow with Power Automate App on Mobile
06:49 How to Use Functions in Power Automate
09:53 Create a LinkedIn Post from Excel with Power Automate
12:33 How to Run Power Automate Flow from Excel Online
13:56 Wrap Up

The complete blog post: https://www.xelplus.com/

LINKS to related videos:
Power Automate Beginner's Guide: https://youtu.be/SUsik0FGzI0

More Power Automate tutorials: https://www.youtube.com/playlist?list=PLmHVyfmcRKyy3jmMCBbNaDCNNXIZdeUY1
____________

★ My Online Excel Courses ► https://www.xelplus.com/courses/

✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel #powerautomate

Видео Use Excel & Power Automate | Record Working Hours from Phone & Update LinkedIn from Excel! канала Leila Gharani