Is your Outlook inbox out of control? In this video, we'll learn the exact system I used at Microsoft to stay organized and finally achieve inbox zero — and ...

Get Clipboard AI: http://spr.ly/6003rQyifIn this step-by-step tutorial, learn how to use UiPath Clipboard AI, a free and powerful tool that automates those boring and repetitive copy and paste tasks.Clipboard AI uses artificial intelligence to automate the process of copying and pasting data between different applications and documents. It acts as an intelligent copy-paste assistant. Simply highlight the information you want to copy, just like you would normally in any application. Then tell Clipboard AI where to paste it. Clipboard AI analyzes the data and the target application/document, and automatically maps the copied data to the correct fields in the destination, saving you from the tedious task of manually entering it yourself.This video is sponsored by UiPath.📚 RESOURCES- Get Clipboard AI: http://spr.ly/6003rQyif⌚ TIMESTAMPS0:00 Introduction0:54 How to get Clipboard AI1:15 Copy & extract data from image / PDF2:02 Paste all data into Excel3:03 Paste specific data into Excel table3:53 Copy and extract data from text4:19 Paste extracted data from text4:55 Map and transform data5:59 Copy and paste data into webform7:36 Settings8:04 Feedback8:15 Wrap up 📺 RELATED VIDEOS- Playlist with all my videos on UiPath: https://www.youtube.com/playlist?list=PLlKpQrBME6xIIEoyVO3IgDU1gKF1h0SGl 📩 NEWSLETTER- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/🔽 CONNECT WITH ME- Official website: http://www.kevinstratvert.com- LinkedIn: https://www.linkedin.com/in/kevinstratvert/- Discord: https://bit.ly/KevinStratvertDiscord- Twitter: https://twitter.com/kevstrat- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818- TikTok: https://www.tiktok.com/@kevinstratvert- Instagram: https://www.instagram.com/kevinstratvert/🎒 MY COURSES- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/🙏 REQUEST VIDEOShttps://forms.gle/BDrTNUoxheEoMLGt5🔔 SUBSCRIBE ON YOUTUBEhttps://www.youtube.com/user/kevlers?sub_confirmation=1🙌 SUPPORT THE CHANNEL- Hit the THANKS button in any video!- Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)#stratvert #clipboardai #uipath

In this step-by-step tutorial, you'll learn how to add checkboxes to Excel and use them for various purposes. With checkboxes, you can make interactive worksheets and reports. You can use checkboxes to create checklists, dynamic charts, conditional formulas, and more.📚 RESOURCES- Get the Excel workbook to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whbEKCECLVFISIwNMFA?e=7AO2SF⌚ TIMESTAMPS0:00 Introduction0:18 Add checkbox1:02 Add multiple checkboxes1:56 Delete checkboxes2:59 Adjust size, color, and alignment3:32 Sum and count checkboxes5:47 Filter checkboxes6:40 Filter function8:42 Dynamic charts11:12 Wrap up 📺 RELATED VIDEOS- Playlist with all my videos on Microsoft Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY📩 NEWSLETTER- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/🔽 CONNECT WITH ME- Official website: http://www.kevinstratvert.com- LinkedIn: https://www.linkedin.com/in/kevinstratvert/- Discord: https://bit.ly/KevinStratvertDiscord- Twitter: https://twitter.com/kevstrat- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818- TikTok: https://www.tiktok.com/@kevinstratvert- Instagram: https://www.instagram.com/kevinstratvert/🎒 MY COURSES- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/🙏 REQUEST VIDEOShttps://forms.gle/BDrTNUoxheEoMLGt5🔔 SUBSCRIBE ON YOUTUBEhttps://www.youtube.com/user/kevlers?sub_confirmation=1🙌 SUPPORT THE CHANNEL- Hit the THANKS button in any video!- Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)#stratvert #microsoftexcel #checkbox

Pivot charts are a powerful way to visualize and analyze data in Excel. They allow you to summarize and compare large amounts of data in different ways, such as by categories, regions, or time periods. In this video, you will learn how to create and customize pivot charts in Excel, from formatting the data to changing the chart type.You will learn how to:- Format the data in columns so that it can be used for pivot charts- Insert a pivot chart using the Insert tab- Understand what fields are and how to drag them into the areas to start constructing a pivot chart- Change the chart type- Apply filters to the pivot chart to refine the dataBy the end of this video, you will have a strong grasp of how pivot charts work and how to use them to create dynamic and interactive charts in Excel. You will also be able to apply the same skills to create pivot tables, which are another way to summarize and analyze data in Excel.📚 RESOURCES- Sample workbook to follow along: https://1drv.ms/x/s!AmxrofZZlZ-wha0FbNIDuh_BHhEgVw?e=WyNc0e- Pivot Tables tutorial: https://youtu.be/PdJzy956wo4- In-depth Excel Charts tutorial: https://youtu.be/eHtZrIb0oWY⌚ TIMESTAMPS00:00 Introduction00:21 Prepare data00:53 Insert pivot chart01:29 PivotChart fields02:03 Drag fields between areas04:40 Change chart type05:52 Design and format06:41 Filter field07:23 Insert new pivot chart08:13 Switch row and column09:29 Filters area10:50 Wrap up📺 RELATED VIDEOS- Playlist with all my videos on Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLDnoK7OovAVVsGNV55MS3K📩 NEWSLETTER- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/🔽 CONNECT WITH ME- Official website: http://www.kevinstratvert.com- LinkedIn: https://www.linkedin.com/in/kevinstratvert/- Discord: https://bit.ly/KevinStratvertDiscord- Twitter: https://twitter.com/kevstrat- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818- TikTok: https://www.tiktok.com/@kevinstratvert- Instagram: https://www.instagram.com/kevinstratvert/🎒 MY COURSES- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/🙏 REQUEST VIDEOShttps://forms.gle/BDrTNUoxheEoMLGt5🔔 SUBSCRIBE ON YOUTUBEhttps://www.youtube.com/user/kevlers?sub_confirmation=1🙌 SUPPORT THE CHANNEL- Hit the THANKS button in any video!- Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)#stratvert #excel #pivotcharts

In this step-by-step tutorial, you will learn how to create a pivot table from multiple Excel worksheets and workbooks. A pivot table is a powerful tool that lets you summarize and analyze data in different ways. You will see how to combine data from different sources. 📚 RESOURCES - Sample Workbook: https://1drv.ms/x/s!AmxrofZZlZ-whZdWxnDcdvNGuVTfSA?e=b91Vkv - Same Workbook with 2023 Data: https://1drv.ms/x/s!AmxrofZZlZ-whZdYEoGQ7BBK881-3w?e=FcAIz9 ⌚ TIMESTAMPS 00:00 Introduction 00:37 Overview of the data 01:34 Launch Power Query Editor 02:28 Import data tables 04:24 Append queries 05:48 Transform data 06:23 Make & customize pivot table 08:43 Relate data tables 12:00 Wrap up 📺 RELATED VIDEOS - How to Create Pivot Tables in Excel: https://youtu.be/PdJzy956wo4 - How to use Microsoft Power Query: https://youtu.be/0aeZX1l4JT4 - Playlist with all my videos on Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLDnoK7OovAVVsGNV55MS3K 📩 NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/ 🔽 CONNECT WITH ME - Official web site: http://www.kevinstratvert.com - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Discord: https://bit.ly/KevinStratvertDiscord - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/ 🎒 MY COURSES - Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/ 🙏 REQUEST VIDEOS https://forms.gle/BDrTNUoxheEoMLGt5 🔔 SUBSCRIBE ON YOUTUBE https://www.youtube.com/user/kevlers?sub_confirmation=1 🙌 SUPPORT THE CHANNEL - Hit the THANKS button in any video! - Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same) #stratvert #excel #pivottable