![Piggy Bank Accountant](/img/default-banner.jpg)
- Видео 425
- Просмотров 389 690
Piggy Bank Accountant
Канада
Добавлен 10 фев 2023
My mission is to help business professionals be more productive at work with Microsoft Copilot & Microsoft Excel.
Microsoft Excel Tips & Tricks: From basics to advanced techniques, learn how to become an Excel wizard. From dashboards, to pivot tables, to variance analysis, and much more!
Copilot Tutorials & Hacks: Discover how to leverage Microsoft Copilot to boost productivity and efficiency in your daily tasks.
👔 About Me
I'm a CPA (Chartered Professional Accountant) with experience at a Big 4 accounting firm, a major video game company, raised $31M in Venture Capital funding & Exit a company for $200M.
🔔Why Subscribe
Because learning should be fun! My experience in Corporate world for 10 years+ and my personality gets you addicted to usually boring Excel & Copilot tips.
Download Your FREE Copilot Cheat Sheet Here! ➡️ bit.ly/ai_productive
🤝Join 6,000+ students who have learned from me
courses.davidpba.com
Complete strangers now addicted to Excel & Copilot
Microsoft Excel Tips & Tricks: From basics to advanced techniques, learn how to become an Excel wizard. From dashboards, to pivot tables, to variance analysis, and much more!
Copilot Tutorials & Hacks: Discover how to leverage Microsoft Copilot to boost productivity and efficiency in your daily tasks.
👔 About Me
I'm a CPA (Chartered Professional Accountant) with experience at a Big 4 accounting firm, a major video game company, raised $31M in Venture Capital funding & Exit a company for $200M.
🔔Why Subscribe
Because learning should be fun! My experience in Corporate world for 10 years+ and my personality gets you addicted to usually boring Excel & Copilot tips.
Download Your FREE Copilot Cheat Sheet Here! ➡️ bit.ly/ai_productive
🤝Join 6,000+ students who have learned from me
courses.davidpba.com
Complete strangers now addicted to Excel & Copilot
Microsoft Copilot VLOOKUP & XLOOKUP Excel Tutorial
Microsoft Copilot in Excel VLOOKUP & XLOOKUP Functions guide
Copilot Essentials Course: From AI Beginner to Proficient ➡️ bit.ly/3wdAhNL
⬇️ Download the free practice workbook here: davidpba.myflodesk.com/rph28drtke
Watch This Next: ruclips.net/video/GYjW4SbHciQ/видео.html
Join 5,000+ business professionals students here ➡️ courses.davidpba.com
🤝 Work with me
🔗Excel & AI Courses 👉 courses.davidpba.com
📞 LinkedIn: www.linkedin.com/in/david-fortin-cpa-816b20b5/
⏰ Timecodes ⏰
00:00 - Intro
00:34 - Merge two lists using VLOOKUP with Microsoft Copilot
04:05 - Copilot in Excel XLOOKUP tutorial
08:32 - Groupe & Merge data with XLOOKUP using Copilot in Excel
11:39 - Outro
#copilot #copilotexcel #microsoftcopil...
Copilot Essentials Course: From AI Beginner to Proficient ➡️ bit.ly/3wdAhNL
⬇️ Download the free practice workbook here: davidpba.myflodesk.com/rph28drtke
Watch This Next: ruclips.net/video/GYjW4SbHciQ/видео.html
Join 5,000+ business professionals students here ➡️ courses.davidpba.com
🤝 Work with me
🔗Excel & AI Courses 👉 courses.davidpba.com
📞 LinkedIn: www.linkedin.com/in/david-fortin-cpa-816b20b5/
⏰ Timecodes ⏰
00:00 - Intro
00:34 - Merge two lists using VLOOKUP with Microsoft Copilot
04:05 - Copilot in Excel XLOOKUP tutorial
08:32 - Groupe & Merge data with XLOOKUP using Copilot in Excel
11:39 - Outro
#copilot #copilotexcel #microsoftcopil...
Просмотров: 192
Видео
Excel has NO SECRETS for Microsoft MVP Jordan Goldmeier (Vlog Interview)
Просмотров 4814 дней назад
Microsoft MVP @JordanGoldmeier talks Microsoft Excel in this vlog interview Copilot Essentials Course: From AI Beginner to Proficient ➡️ bit.ly/3wdAhNL Watch This Next: ruclips.net/video/F59K2UF1LuQ/видео.html Join 5,000 business professionals students here ➡️ courses.davidpba.com Follow Jordan www.linkedin.com/in/jordangoldmeier/ 🤝 Work with me 🔗Excel & AI Courses 👉 courses.davidpba.com 📞 Link...
AI in Excel Tutorial: Microsoft Copilot & ChatGPT
Просмотров 1,6 тыс.28 дней назад
AI in Excel guide with Microsoft Copilot and ChatGPT for modern data-driven insights and dynamic dashboards. Copilot Essentials Course: From AI Beginner to Proficient ➡️ bit.ly/3wdAhNL Watch This Next: ruclips.net/video/n8UD3oWQ4ik/видео.html Join 5,000 business professionals students here ➡️ courses.davidpba.com 🤝 Work with me 🔗Excel & AI Courses 👉 courses.davidpba.com 📞 LinkedIn: www.linkedin...
Microsoft Copilot Demo: 3 Ways To Boost Productivity At Work
Просмотров 1,3 тыс.Месяц назад
Microsoft Copilot Demo: 3 use cases to increase productivity with Microsoft Copilot Copilot Essentials Course: From AI Beginner to Proficient ➡️ bit.ly/3wdAhNL Join 5,000 business professionals students here ➡️ courses.davidpba.com Watch This Next: ruclips.net/video/mr2N7wchAwQ/видео.html In this video, I'll demo three powerful ways Microsoft Copilot can transform your daily tasks and help you ...
How to Use Microsoft Sticky Notes [Full Tutorial with 2024 NEW Features]
Просмотров 952Месяц назад
Discover the ultimate guide to Microsoft Sticky Notes! 📝 In this comprehensive tutorial, we cover everything you need to know, including the exciting NEW features for 2024. Whether you're a beginner or a seasoned user, this video will help you master Sticky Notes and boost your productivity. Join 5,000 business professionals students here ➡️ courses.davidpba.com Watch This Next: ruclips.net/vid...
How to Write Professional Emails with Microsoft Copilot
Просмотров 144Месяц назад
Learn how to draft Professional Emails with Copilot and save time Copilot Essentials Course: From AI Beginner to Proficient ➡️ bit.ly/3wdAhNL Join 5,000 business professionals students here ➡️ courses.davidpba.com Watch This Next: ruclips.net/video/rRxthaLFZcY/видео.html 🤝 Work with me 🔗Excel & Copilot Courses👉 courses.davidpba.com 📞 LinkedIn: www.linkedin.com/in/david-fortin-cpa-816b20b5/ Want...
From CFA to Solopreneur (Journey, Salary, Challenges) @CharleneCong
Просмотров 246Месяц назад
Charlene Cong talks about her journey as a CFA, her salary, her challenges and her biggest career move. Follow Charlene here @CharleneCong Charlene's LinkedIn www.linkedin.com/in/charlenecong/ ⏰ Timecodes ⏰ 00:00 - Intro 01:28 - Journey to Becoming a CFA 💰 02:53 - Investment Strategy Insights 💡 08:35 - Transition to RUclipsr & Business owner🎥 24:02 - Salary progression and negotiation 🏙️ 28:30 ...
Sticky Notes & AI: Note taking has forever changed (take better notes) ✍️
Просмотров 735Месяц назад
Be more organized and take smarter notes with Microsoft Sticky Notes and Microsoft Copilot. Copilot Essentials Course: From AI Beginner to Proficient is now available➡️ bit.ly/3wdAhNL In this video, we explore how Sticky Notes ✍️ have forever changed with the integration of AI. Learn how to take SMARTER notes 🧠 and boost your productivity using advanced features in Sticky Notes, OneNote 📒, and ...
From Audit to FP&A: My Story (First role, $30M VC Raise, daily tasks, lessons learned, $200M Exit)
Просмотров 1372 месяца назад
My journey and accounting career path from Audit to Financial Planning & Analysis Join 5,000 business professionals students here ➡️ courses.davidpba.com ⬇️ Free E-book 10 Copilot Use Cases To Speed Up Productivity: bit.ly/ebook-copilot 🎬Related Videos ruclips.net/video/REAM9MoaMoo/видео.html ruclips.net/video/xAMRbsXqv0A/видео.html This video was helpful? Join my channel to support me! 👉 rucli...
How To Build Complex Excel Functions EASILY with Copilot
Просмотров 3382 месяца назад
Microsoft Excel Functions & Formulas never been so easy to learn with Copilot. Join 5,000 business professionals students here ➡️ courses.davidpba.com ⬇️ Free E-book 10 Copilot Use Cases To Speed Up Productivity: bit.ly/ebook-copilot 🎬Related Videos ruclips.net/video/mvf4DzQM6c8/видео.html ruclips.net/video/0ovDfXuumww/видео.html ruclips.net/video/B3eQnnpE7_E/видео.html This video was helpful? ...
How to Use Microsoft Copilot Mobile App [Guide & Overview]
Просмотров 4252 месяца назад
How to Use Microsoft Copilot Mobile App [Guide & Overview]
Introduction to AI & Microsoft Copilot [Beginner Tutorial]
Просмотров 4272 месяца назад
Introduction to AI & Microsoft Copilot [Beginner Tutorial]
Microsoft Copilot Mini Course: Essentials for Beginners (15 Minutes)
Просмотров 4282 месяца назад
Microsoft Copilot Mini Course: Essentials for Beginners (15 Minutes)
Microsoft ALREADY Removing Key Copilot Features 🤦
Просмотров 1,6 тыс.3 месяца назад
Microsoft ALREADY Removing Key Copilot Features 🤦
Top 7 Microsoft Copilot Productivity Tips for Work
Просмотров 1 тыс.3 месяца назад
Top 7 Microsoft Copilot Productivity Tips for Work
Create PowerPoint with Copilot FREE Version
Просмотров 1 тыс.3 месяца назад
Create PowerPoint with Copilot FREE Version
GPT-4o + Copilot: Another marketing stunt from Microsoft?
Просмотров 1,3 тыс.3 месяца назад
GPT-4o Copilot: Another marketing stunt from Microsoft?
How To Get ChatGPT-4o for FREE (Quick Tutorial)
Просмотров 7 тыс.3 месяца назад
How To Get ChatGPT-4o for FREE (Quick Tutorial)
GPT-4o VS Copilot - Which one gives best data analysis results?
Просмотров 6 тыс.3 месяца назад
GPT-4o VS Copilot - Which one gives best data analysis results?
Microsoft Copilot Taught Me Power Query and I'm SHOCKED
Просмотров 8784 месяца назад
Microsoft Copilot Taught Me Power Query and I'm SHOCKED
Power BI & Power Query Expert talks Excel (Candid interview with @GoodlyChandeep )
Просмотров 3444 месяца назад
Power BI & Power Query Expert talks Excel (Candid interview with @GoodlyChandeep )
Microsoft Copilot Full Course: Intermediate Tutorial
Просмотров 7404 месяца назад
Microsoft Copilot Full Course: Intermediate Tutorial
Data Strategist Discusses How AI Impacts Data-Driven Jobs
Просмотров 874 месяца назад
Data Strategist Discusses How AI Impacts Data-Driven Jobs
Financial Modeller Danielle Stein Fairhurst Honest Thoughts About Excel
Просмотров 1444 месяца назад
Financial Modeller Danielle Stein Fairhurst Honest Thoughts About Excel
The CORRECT Way to Use Copilot in Excel (for FREE)
Просмотров 1,4 тыс.4 месяца назад
The CORRECT Way to Use Copilot in Excel (for FREE)
What is Microsoft Copilot? Everything you need to know
Просмотров 8254 месяца назад
What is Microsoft Copilot? Everything you need to know
How I escaped a toxic boss in my corporate job
Просмотров 1304 месяца назад
How I escaped a toxic boss in my corporate job
How To Create Your First Custom GPT in Microsoft Copilot (Step-by-step tutorial)
Просмотров 6815 месяцев назад
How To Create Your First Custom GPT in Microsoft Copilot (Step-by-step tutorial)
How to create Custom GPTs in Microsoft Copilot (and complete your tasks WAY faster)
Просмотров 6575 месяцев назад
How to create Custom GPTs in Microsoft Copilot (and complete your tasks WAY faster)
perhaps its cuz you spelled taylor's name wrong!
what is best way once you reach 30 msgs, to continue talk? ive asked copilot and it failed me every single time. i asked it for keyword but find i have start the whole story again.
I think they just added this but it makes sense. After too many messages the AI gets confused. So thats why you have to get kinda good at your promto at first to narrow the results as much as possible. Cheers !
@@piggybankaccountant Im asking for a summary of all we said, then cutting and pasting. Haven't used yet. But you think it will work? is it all Ai's or just, which?
Thanks Dave. I am going to try this out
Love this guy.
Hey there. You just made my day. Big thanks 😌😌😌
I use mac and my ms excel is online one. What shortcut I should use?
I just saw this vid today and it's just great 🎉 I love your funny and cool approach 😁
Hey thank you! Means a lot!
I think they both have they own strength
You're right!!! I use both
Why do u compare with gpt 3.5? Gpt 4 is free already once u login
Because you have 10 free prompts then you get downgraded to 3.5
Super video ....please how can add my Vlookup function in excel
Please share workbook for practice
This might be off-topic, but what resolution does your monitor have? I’m trying to match the size of my Windows taskbar to yours on Windows 11, but I haven't been able to put the small size
Hey there, no questions are off topic my man. You can use LinkedIn for a faster response next time. My monitor is the ASUS ROG SWIFT PG279Q 27" 2560x1440
Absolutely useless video; you didn't show a single way to use co-pilot to take notes during meetings.
How is this different from chat gpt
It isn't
The main difference of ChatGPT and Copilot is that Copilot is seamlessly integrated in your MS365 apps. By instance you can prompt Copilot to search through your emails to save tremendous time. Also the GPT model used (the dictionary behind what you search) is stronger with Copilot (it is on GPT-4 as we speak) while ChATGPT free version only offer you 10 prompts on GPT-4o. Copilot is web based while chatgpt isnt. More details in this video if ever: ruclips.net/video/0ovDfXuumww/видео.html
Great video. Very helpful. Thank you.
Thank you!!! It was the extended version of the tutorial you already watched ;) Hope you got some value out of it John!
Merci David / Good Job
Salut Bruno! Merci c'est vraiment gentil! Connectons sur LinkedIn si jamais ce n'est pas encore fait :) www.linkedin.com/in/david-fortin-cpa-816b20b5/
Great tutorial. Thanks! However, I'm missing the pin to desktop on individual sticky note. When I click the eclipse all I get is the color chart and the delete button?
Hello !!! Thanks for the positive comment. I am not sure why you don't see it, you might not have hte preview mode? Do you see the other options? This should be released soon to everyone and you should have the pin option which is wonderful!
Is copilot free to download
@@mrjotz thank you
Yes there is a free vresion and it works very well =)
Good stuff man !
Hey thank you so much! If you only knew how these kind of comments warm my heart. Cheers, to the next video ;)
Looks like Copilot in Excel would be helpful for beginner and intermediate users. Of course, always check your results.
Oh yes AI isnt perfect!! And yes it helps so much someone just starting!!!!!!!!
I hoped i'd be able to add them into onenote but now it just feels like another place to look for my notes
I totally agree taht a button "Push to OneNote" or an integration in OneNote itself to click "add to this page" would be imho EASY and AMAZING!!!!
Very well done, very informative and to the point! Merci
Bonjour Bruno! Tu avais détecté l'accent du Saguenay Lac Saint-Jean n'est-ce pas? Merci ça fait plaisir =)
@@piggybankaccountant ton anglais est très bon avec ton humour que tu ajoute ça fait encore plus plaisant à t’écouter.
When will be available exactly?
I am not sure exactly, the preview mode can last quite long at Microsoft. Here is more info on the topic: www.reddit.com/r/windows/comments/1en6qo8/notice_about_the_new_sticky_notes_preview/
August
It's already in my laptop <3
what version is you powerpoint?
This is PowerPoint for Office 365 so Microsoft 365 license.
you look like a dude that use ai for everything 😂
00:02 Save time and be more productive using Microsoft Copilot in Word 01:10 Learn how to prompt Co-pilot for effective assistance. 02:17 Learn how to summarize past professional experience using Microsoft Word and Copilot. 03:23 Exploring Microsoft Copilot's resume generation feature. 04:31 Microsoft Copilot can rewrite text prompts with specific instructions. 05:32 Using Microsoft Copilot to create word documents based on existing ones 06:41 Microsoft Copilot simplifies data visualization and document summarization. 07:51 Microsoft Copilot Word features are encountering licensing issues
00:02 Learn to write professional emails with Microsoft Copilot. 00:30 Write a professional email draft to send to Mr. Musk 00:53 Microsoft Copilot helps create professional email drafts. 01:13 Microsoft Copilot ensures careful processing of orders 01:34 Asking Copilot for help in writing professional emails 01:59 Microsoft Copilot suggests professional email content. 02:25 Microsoft Copilot provides grammar correction for professional emails. 02:49 Learn about Microsoft Copilot in the course Microsoft Co-Pilot Essentials
00:01 Microsoft Copilot is a handy AI tool available for both iOS and Android. 01:10 Microsoft Copilot Mobile App interface overview 02:16 Microsoft Copilot has three working modes. 03:19 Access and utilize recent chat history and create prompts with ease. 04:39 Microsoft Copilot Mobile App has a feature to use voice memo for note-taking 05:48 Microsoft Copilot Mobile App allows seamless switching between voice and keyboard input 06:45 The Copilot mobile app has a notebook feature and plugins. 07:46 CoPilot Pro integration not available on mobile
00:01 The Perfect Prompt Formula helps you ask Microsoft Copilot effectively. 01:03 Getting recommendations for kid-friendly activities in Paris from Microsoft Copilot. 02:12 Context and details are everything for effective prompts 03:24 Writing effective prompts in Copilot 04:34 Utilize Microsoft Copilot Pro in 365 apps like Outlook for efficient summaries 05:38 Microsoft Copilot tailors email prompts for Elder travelers to Paris 06:51 Reviewing changes made by Copilot in a code snippet 07:58 Writing prompt for a friendly email to arrange a trip to Paris for experienced 30-year-old travelers.
00:01 Use Copilot to build PowerPoint presentations 01:51 Using Copilot to Generate Images in PowerPoint 03:45 Summon a video using Microsoft Copilot in Microsoft Edge 05:22 Microsoft Copilot can summarize videos and PDFs 07:04 Microsoft Copilot can summarize documents and analyze charts for quick insights. 08:47 Microsoft Copilot can enhance chart creation, image translation, and Excel formula writing. 10:35 Using Copilot to generate Excel formulas for data manipulation 12:17 Replace vendor list file with actual sheet name
Why doesn't the copilot button appear in my Teams application? I have a business account, I am the administrator and I purchased microsoft for 365 business and copilot for microsoft 365 with the Teams option. Is it because i am using it from Mexico and in spanish? Thans in advance
It is a tough one to answer. You should have one if you bought the business license of Copilot. Did you JUST buy it? If so you might need to activate your license. Refer to this video ruclips.net/video/PU12d4athrQ/видео.html
@@piggybankaccountant thanks for answering. I did activate it, actually i can use it in other apps such as word or PowerPoint, that's why I'm so confused... also, do you have by any chance videos about the use and customization of copilot studio? I have troubles with it as well
@vichernandez0205 you sure you have business? This sound like you have individuals do you?
I am sure, in fact i created a business account only to have the copilot for microsoft 365 (i am the administrator and the only one on my enterprise hah) as i saw that it was better than copilot pro (for personal accounts). But i didn't understand a thing
@vichernandez0205 this might be the issue. Your configuration or the type of license you got. Do you have access to copilot studio ? And how much you pay a month? Business is 30usd while individuals is 20 usd
Great video! I am now moving to Windows and didn't know Sticky Notes was so powerful! Thanks for the walk-through 🙌
Hey thank you for your comment. I really taught this video could help a lot of people. Share it with your colleagues and friends 🫶❤️
Thanks for having me on your channel David!! Was a great conversation with you:) Charlene xx
Want to become AI proficient? Microsoft Copilot Essentials Course ➡ bit.ly/3wdAhNL
waste of time he didnt say some new
Love your story! Need more finance ppl like us to join this journey!!❤
Rob from the netherlands
Hey Rob, email me at davidfortincpa@gmail.com or reachout on linkedin I have something for you www.linkedin.com/in/david-fortin-cpa-816b20b5/
I think the GPT plugging option is no longer available, I am using a pro copilot but I cant find it.
Youre right they are removing it for individuals license :(
waste of every ones time , hope you lose your channel for this
Hello David from Poinciana, FL!
Hello Madame Sherry!!! I need to go to Florida one day!
Pure positivity!
Beautiful place for a run up there!
Epic. Thanks for sharing your journey, my man. Good to hear a bit more about your backstory!
thanks man!! first "vlog" haha
⬇ Free E-book 10 Copilot Use Cases To Speed Up Productivity: bit.ly/ebook-copilot
Thank you for this video and nice work you are doing ;) Greetings from Slovakia
Thank you!!!
@@piggybankaccountant Gracias David!
When I click "print contacts" nothing happens. 😢
Did you try with a different browser: microsoft edge, or chrome or even mozilla firefox? Keep me posted :)
@@piggybankaccountant Same thing happened to me when i tried via Firefox... BUT tried with Edge and worked perfectly
It's the same thing. That's why they got funds pulled by Elon
Sir, the video was too good but it should’ve been a bit slow
Want more videos on copilot sir
What is the next video (which topic) would you like me to cover?
Copilot Essentials Course: From AI Beginner to Proficient is now available➡ bit.ly/3wdAhNL COUPON CODE = COPILOT50