Leila Gharani
Bring ChatGPT INSIDE Excel to Solve ANY Problem Lightning FAST
updated
Today's video is all about Open AI's amazing language model ChatGPT. 99% of the people use ChatGPT in beginner mode. They don't know how to structure prompts and waste a lot of time going back and forth. I'll show you how you can engineer the perfect prompts to explore the full potential of ChatGPT. From custom instructions to your own writing style, to using ChatGPT as its own critic or prompt engineer and how to get different output formats other than text.
π My Online Courses βΊ xelplus.com/courses
00:00 How to Create the Perfect ChatGPT Prompt
00:30 Remember Me - Custom Instructions
04:33 Write Like You - Custom Writing Style
06:28 Self-Critique
07:27 Self-Prompting
10:20 Make it Crisp
11:30 Different Output Formats
13:05 Wrap Up
β‘οΈ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
π¬ LINKS to related videos:
Bring ChatGPT INSIDE Excel to Solve ANY Problem Lightning FAST βΊ youtu.be/kQPUWryXwag
How ChatGPT Can Help With Your Complex Excel Spreadsheets βΊ youtu.be/21bXQDXSxYs
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: linkedin.com/company/xelplus
π 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!
#chatgpt #promptengineering
In this video, you'll discover 6 useful websites you probably didn't know existed. These websites are free to use (or at least have a free version) and they serve different purposes - from keeping you safe to making work fun. You're going to love these websites and tools.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#websites
Here is a simple Excel trick on how to use Pivot Table slicers in a formula based report. Basically you get to connect your formulas to slicer buttons. We'll use a hidden Microsoft Excel Pivot Table to get the slicer functionality and connect the pivot table outcome to the Excel formulas.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
Microsoft Power BI is one of the most used business intelligence tools in today's corporate world. In this video I'll show you how you can effortlessly use Power BI and Excel together. You'll learn how to insert a table or a pivot table in Excel that's linked to a Power BI dataset. We'll also take a look at how to export data from Power BI with Analyze in Excel and live connection.
π Join 400,000+ professionals in our courses: xelplus.com/courses
00:00 How to Link Excel to Power BI Data
00:46 Create a Table in Excel Linked to Power BI Data
04:26 Change Refresh Options for Linked Table
04:51 Create a Pivot Table Linked to Power BI Data
06:23 Export Power BI Data With Analyze in Excel
08:17 Export Power BI Visual With Live Connection
10:46 Requirements to Export Power BI to Excel
11:18 Wrap Up
β‘οΈ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
π¬ LINKS to related videos:
Should You Learn Power Bi? βΊ youtu.be/7ZMQZ0UUuTs
How To Create these useful Power Bi Visuals that Excel Lacks: βΊ youtu.be/GpP0EbSMRpg
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel #powerbi
Here is a simple trick on how to use value preview tooltips to check your formula in Microsoft Excel. It's a great way to debug your larger Excel formulas and find out why you're getting wrong results (in case your formula isn't returning the correct answer).
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
The utility Text Extractor in Microsoft's Power Toys suite allows you to copy text from anywhere on your screen. Just capture of a region of the screen, and the text extractor will extract the text from the image and copy the content to the clipboard.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#windows #powertoys
You can use Python INSIDE Excel now π± In this video I'll introduce this game changing new functionality of working with Python inside Excel. Is Python in Excel for non-programmers? Can everyday data analysts make use of it? I'll answer these in the video.
Plus checkout the announcement from Microsoft: techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439
If you have this feature which is currently free to use in Microsoft 365 Insiders, you will find Python in the Insert tab in the Excel Ribbon. You get a few Python libraries already ready for you to use in Excel. These are the pandas, matplotlib, seaborn, statsmodels and NumPy. You can import other libraries as you need using the import statement - for example import re module for REGEX calculations. How can you use Python in Excel in practical terms? I share a few ideas in the videos. You can use the pandas library and turn your data into a dataframe which you can then use for more complex tasks, like query the data, unpivot the data with python, create charts using matplotlib - make a line, area or even small multiples. You can grab URLs from long text by using the regex library. You can also use python together with Power Query. We'll only scratch the surface and even that is pretty awesome.
π My Online Courses βΊ xelplus.com/courses
00:00 Python in Excel
00:40 Enter Python Mode
01:32 Send Excel Data to Python - Create Data Frame
03:19 pandas Python Library
03:43 Python Describe Data
05:11 Assign Name to DataFrame
05:51 Referencing Headers Shortcut
06:26 Examples of pandas Functionalities
07:29 Create Series Python Object
09:35 Plot a Chart in an Excel Cell
10:51 pandas Documentation
11:16 Calculation Logic of Python Cells
12:07 Examples from Default Libraries
13:35 Plot Multiple Charts As Single Object
14:49 Importing Libraries & Referencing Tables
18:10 Python to Excel Power Query
18:35 Wrap Up
β‘οΈ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
π¬ LINKS to related videos:
Introduction to Office Scripts: βΊ youtu.be/fny4zUycp_w
How to Create & Use Excel Macros: βΊ youtu.be/An-2Nxf_Dms
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#python #excel
Join 400,000+ professionals in our courses: xelplus.com/courses
00:00 Super Useful Windows Shortcuts
00:18 Show Desktop
00:52 Clipboard History
01:47 Emoji Picker
02:08 Magnifier
02:47 Search in Browser
03:02 Reopen Tabs
03:22 Task View
03:47 Lock Screen
04:08 Shutdown
04:34 Wrap Up
π My Online Courses βΊ xelplus.com/courses
β‘οΈ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
π¬ LINKS to related videos:
βΊ Do NOT Shut Down Your Computer! youtu.be/a83EmWtZMfg
βΊ Cool Free Windows Utilities to Use EVERYDAY youtu.be/ZlyxesiiC6U
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#windows #productivitytips
You're going to love the new TOCOL & TOROW functions in Microsoft Excel! TOCOL lets you dynamically combine cells across multiple columns and rows into a single column. The TOROW function is very similar - you can combine data from different cells into a single row. In this video I'll show you how it works.
Requires Microsoft 365. The TOCOL & TOROW functions will not be available in Excel 2021 and earlier versions.
π My Online Excel Courses βΊ xelplus.com/courses
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
Excel Esports Takes the Spotlight on "ESPN8: The Ocho"!
Mark your calendars for 7 AM (ET), August 4, 2023, as we gear up for an adrenaline-pumping Excel Esports Elimination Battle - a completely new Excel Esports game format will be revealed!
8 Excel enthusiasts will be competing in a fierce 30-minute battle, but every 5 minutes one of them will be eliminated: Andrew Ngai, Isaac Lee, Diarmuid Early, David Brown, Alana Reid, Brittany, Michael, Emily
Hosted by Leila Gharani, Bill Jelen, Oz du Soleil!
Join 400,000+ professionals in our courses: xelplus.com/courses
π My Online Courses βΊ xelplus.com/courses
β‘οΈ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
π¬ LINKS to related videos:
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
Here is my list of the best new features and improvements in Microsoft Excel that can really make a difference for you. This includes the new Search the menus feature, the new navigation pane for large workbooks, how to check your formula with the value preview tooltip, dynamic arrays and more.
π My Online Courses βΊ xelplus.com/courses
00:00 Best New Excel Features You Need to Know About
00:17 Easy Search in Excel
01:39 Navigation Pane in Excel
03:02 New Excel Keyboard Shortcuts
03:54 Automate Tab
05:56 Value Preview Tooltip
06:41 Dynamic Arrays in Power Query
08:23 Dynamic Arrays as Charts Source
08:51 Wrap Up
β‘οΈ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
π¬ LINKS to related videos:
Introduction to Office Scripts βΊ youtu.be/fny4zUycp_w
Automatically Move Completed Tasks to an Archive βΊ youtu.be/Y7PoYlZUMgo
Do You Need to SWITCH from Excel VBA Macros to Office Scripts? βΊ youtu.be/DOvHqukAGTY
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
Sometimes you might receive data with data all in the same cell. With Microsoft's new TEXTSPLIT function in Excel you can now split cells in rows and columns. This way you can create proper data table for further data analysis.
Requires Microsoft 365. The TEXTSPLIT function will not be available in Excel 2021 and earlier versions.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
Your Window experience is about to change. Discover a free set of more than 70 tools and utilities by Microsoft that will give you more control over you PC. You'll be able to troubleshoot, diagnose, manage and monitor your Windows device like never before. You'll be able to test for malware, prioritize certain operations (good for gamers), annotate your screen and a lot more. These free Windows apps have been around since 1996 (!) and yet, not many know about them. They're perfect for developers and IT. Microsoft is still maintaining these tools and even new features are being added. There are free tools there for power users, for real techies but also for anyone who wants to get the most out of their Windows experience.
π My Online Courses βΊ xelplus.com/courses
β― DOWNLOAD Sysinternals on Microsoft:
learn.microsoft.com/en-us/sysinternals/downloads
00:00 FREE Windows Power Tools We Can't Live Without
00:53 Where to Download
01:43 ZoomIt
04:22 Process Monitor
08:00 Autoruns
09:41 Process Explorer
11:32 Wrap Up
β‘οΈ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
π¬ LINKS to related videos:
Cool Free Windows Utilities to Use EVERYDAY βΊ youtu.be/ZlyxesiiC6U
5 Mind-Blowing FREE Windows Apps βΊ youtu.be/yridBTXFme8
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#freetools #windows
Excel Pivot Tables just got a major upgrade: You can now include images in Excel PivotTables!
I'll also show you how you can make PivotTables more visually appealing by integrating Excel data types like stocks, currencies and geography. I'll also show you how you can even insert your own custom data types.
Availability: Microsoft 365 currently only in Beta Insiders channel.
π My Online Courses βΊ xelplus.com/courses
00:00 How to Use Images and Data Types in Your Excel PivotTables
01:02 Use Images in Pivot Tables
02:35 Using Data Types in Pivot Tables
06:02 How to Use Custom Data Types in Pivot Tables
08:08 Wrap Up
β‘οΈ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
π¬ LINKS to related videos:
How to Use Excel's NEW Lookup of Images: youtu.be/-BiZjkqgaHc
How to Create Custom Data Types in Excel: youtu.be/sVrtkxjfDkc
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
Sometimes you might want to choose only certain columns from your filtered dataset. For example you could apply a FILTER function on your entire data but only have selected columns from this dataset in the output. With a combination of Microsoft's new CHOOSECOLS function together with FILTER you can do just that.
Requires Microsoft 365. The CHOOSECOLS function will not be available in Excel 2021 and earlier versions.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
Microsoft just released a new feature in Excel to insert pictures inside cells. It's called "Place in Cell". This allows us to create more advanced and professional looking Excel dashboards without the need for complex solutions. Inserting images in cells makes it easy to use functions like XLOOKUP or FILTER to return an image. You can now also lookup a picture and return the corresponding information on the same row. So that pictures can be provided as a lookup value to lookup formulas like XLOOKUP.
Availability: Microsoft 365 currently only in Beta Insiders channel.
π My Online Courses βΊ xelplus.com/courses
00:00 How to Insert Pictures Into a Cell in Excel
00:32 Insert Images in Excel Cell
02:20 Return Images With Formulas
04:00 Bonus - Lookup Images
05:58 Wrap Up
β‘οΈ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
π¬ LINKS to related videos:
Breaking News! We FINALLY get the Excel functions we've been Wanting!: youtu.be/VWcLM6_Q_00
How to Use Excel's New TAKE Function: youtu.be/z66-6WVZSFY
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
This course is for you if you want to:
βοΈ Learn how to tackle real-world data problems with Power Query and other automation tools.
βοΈ Avoid Power Query pitfalls so your queries don't break in a few weeks time
βοΈ Discover new automation options your managers werenβt aware of so you can automate what comes before and after Power Query...
The course page has all the details. Watch the video, read the content, check the curriculum and see for yourself if this course is right for you.
I hope to see you inside the course and help you master Power Query and automation. π
π XelPlus.com/courses
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
In this video we'll unlock some hidden gems in your Excel Power Query Editor that you had this WHOLE time. They are simple but they will make your work life a lot easier. Some are also hidden tips when you work with Excel power query results - such as updating query refresh times, adding slicers to tables and also making it easier to change table names in Excel.
00:00 Hidden features your Excel Power Query you had this whole time
00:22 Power Query Editor Excel Shortcut
01:14 Quick Access Toolbar in Power Query
02:27 New Course: Automate with Power Query from Leila
04:25 Properly Enter M-Functions in Power Query Editor
05:32 Zoom-in and out Shortcut Keys in PQ Editor
06:05 Automatically Sort Column Headers
06:48 Import Entire File Content in Power Query
08:01 Add Table Name to QAT-Bar in Excel
09:10 Copy & Paste Power Queries to Different Excel Files
10:01 Add Slicers to Tables
11:09 Adjust Refresh Settings in Excel
11:45 Wrap Up
π My Online Courses βΊ xelplus.com/courses
Read the blog post here: xelplus.com/power-query-10-hidden-features
β‘οΈ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
π¬ LINKS to related videos:
How Power Query Will Change the Way You Use Excel: youtu.be/6lBqYInBldk
How To Import & Clean Messy Accounting Data in Excel: youtu.be/TjGbOoKvZ7M
Convert Columns to Rows in Excel: youtu.be/JMrfbv2h7p8
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel #powerquery
When working with visuals, you often need to make a graphic that perfectly match a particular color. To use that color, you'll need its exact color code. The best way to find out is to use the Color Picker in Microsoft's Power Toys.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#windows #powertoys
In this video I'll share my tips for neat and efficient note taking. You'll learn an effective note-taking technique for any type of work: The quadrant method. Whether it's for your work meetings, for your consulting projects, taking notes for school or even for your own personal projects- this method works wonders. It's how I take perfect notes now for every meeting I attend.
π My Online Courses βΊ xelplus.com/courses
β‘οΈ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
00:00 Why You Need An Efficient Note Taking System
02:30 How to Takes Notes For Work
04:55 Take Notes By Hand
06:35 Wrap Up
π¬ LINKS to related videos:
How to Use OneNote Effectively: youtu.be/Poepoh1b_3k
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#notetaking
Microsoft introduced some very useful new functions in Excel. You can use them to rearrange your data in a dynamic way.
With WRAPROWS you can take a row or column of values and make it into a table with rows and columns. You just need to tell it how many values you want in each row.
The WRAPCOLS function is a tool in Excel that lets you change the shape of a row or column of data. It lets you change a list of values into a table of values. It does this by putting some values in different columns.
Requires Microsoft 365. These functions will not be available in Excel 2021 and earlier versions.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
The new TEXTSPLIT function in Microsoft Excel allows you to split across columns or down by rows. In this video I'll show you how you can even use multiple delimiter to split text into multiple cells.
Requires Microsoft 365. The TEXTSPLIT function will not be available in Excel 2021 and earlier versions.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
This tutorial is a step by step deep dive into understanding how to use the Excel TAKE function. With the new TAKE function in Microsoft Excel you can extract a specified number of rows or columns from the start or end of your dataset. This opens many opportunities for data extraction and calculations in combination with other Excel functions. For example, you can combine TAKE with the FILTER function. This way you can filter your dataset by certain criteria and then return the top/bottom rows. Or combine TAKE with SORTBY to sort your data by a certain column and then return the top/bottom N results. We'll also cover how you can combine TAKE with another new function: VSTACK. If you're wondering what the difference between TAKE and CHOOSECOLS or CHOOSEROWS functions are, I cover that in the tutorial.
Requires Microsoft 365. The TAKE function will not be available in Excel 2021 and earlier versions.
π My Online Courses βΊ xelplus.com/courses
00:00 How to Use TAKE Function to Extract Data in Excel
01:12 How Excel TAKE Function Works
02:13 Difference between TAKE & CHOOSECOLS or CHOOSEROWS
02:58 TAKE & Average of Last Rows
04:12 Combine Excel FILTER and TAKE Function
05:13 Combine SORTBY and TAKE Function
07:32 Combine VSTACK and TAKE Function
09:55 Wrap Up
β‘οΈ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
π¬ LINKS to related videos:
Excel VSTACK: Quickly Combine Data from Multiple Sheets: youtu.be/qNz35j5ZevQ
How To Use Excel FILTER Function With Multiple Criteria: youtu.be/1mHAVptUKAk
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
Learn the trick to properly copy Excel formulas without file reference: When you copy formulas from an Excel workbook to another Excel file, it creates links referencing the old file. I'll show you how you can easily fix that so the new formulas reference the new Excel file.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
In this video I'll share my Excel Pivot Table pro tips to make the best use of Pivot Tables in Microsoft Excel. You'll discover hidden productivity tips as well as pivot table hidden tricks for example using a hidden pivot table so you can use Slicers on formulas as well. There is a lot of Excel tips and tricks that many Excel experts don't know yet.
00:00 10 Best Pro Tipps for Pivot Tables in Excel
00:23 No 1: Fast PivotTable
01:06 No 2: Adjust Field Settings
01:59 No 3: Timeline slicer
03:17 No 4: Pivot Table Without Using a PivotTable π€
04:56 No 5: Top N Analysis
06:36 No 6: Type Over Sorting
07:12 No 7: Repeating VS Centering Labels
08:15 No 8: Custom Sorting Pivot Table Fields
08:54 No 9: Easy %-Change Calculations in Pivot Tables
10:31 No 10: Disable Double-Click for Details
π My Online Courses βΊ xelplus.com/courses
β¬οΈ Download the file I use in the video from here: xelplus.com/pivot-table-pro-tips
π¬ LINKS to related videos:
Excel Pivot Tables EXPLAINED in 10 Minutes: youtu.be/UsdedFoTA68
Advanced Pivot Table Techniques: youtu.be/yHzT_BUggQk
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel #pivottable
Do you need to resize multiple images or photos all at once? In this video, I'll show you how you can use the free Power Toys Windows utility to do that. It's called Image Resizer. It allows you to bulk resize images by dragging and dropping your selected files with the right mouse button. This way, resized pictures can quickly be saved in a different folder.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#windows #powertoys
Use Microsoft Forms to as a data collection tool in your Business. Forms has gotten AI updates which will make it easier for you to prepare the forms and analyze the results. In this step-by-step tutorial I'll show you how you 3 ways you can use Microsoft Forms in your business. This applies to you whether you work at a corporate job or you're running your own business. You'll learn how to use surveys, quizzes and polls to gather insights about your customers, team and employees. Learn about the new AI features Forms has gotten recently. There is an AI form generator that prepopulates the forms with questions and answers based on the topic. There is AI generated themes based on the topic of the form. You can add music, share the form with anyone outside the organized, create timed quizzes and get insights from the results with the help of AI. The AI will also help you find patterns in the answers people provide.
We'll also cover how to use new features like AI-generated insights, questions with images, timed quizzes, and much more.
00:00 Introduction to Microsoft Forms
01:25 How to Create a Survey
05:23 How to Share Your Survey
05:56 Reviewing the Answers for Surveys
06:42 How to Create a Quiz
08:55 Reviewing the Answers for Quizzes
10:10 How to Create a Poll
11:22 Difference Polls vs Forms App in Teams
11:59 Wrap Up
π My Online Courses βΊ xelplus.com/courses
π¬ LINKS to related videos:
How To Send Forms Responses to Outlook With Power Automate: youtu.be/8sg2yGg6Q1g
Properly Create Surveys with Microsoft Forms & Export to Excel: youtu.be/nXeYv-W-Wt4
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#microsoftforms #datacollection
You're going to love the new VSTACK & HSTACK functions in Microsoft Excel! With these power functions you can append your data together. VSTACK dynamically combines arrays into a single vertical array while HSTACK combines them horizontally. In this video I'll show you how it works.
Requires Microsoft 365. The TAKE function will not be available in Excel 2021 and earlier versions.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
In this video I'll show you how to easily convert your Microsoft Excel file to a PDF file. You'll learn 3 different methods to get this done but also some important tips to avoid your text getting cut-off by adding page breaks in Excel, how to repeat header and titles on every page and how to print with landscape orientation. You'll learn how to add page numbers in your Excel sheets which is very important if you decide to print your Excel reports. You'll also learn how to center the content on the PDF page or you might choose not to center the content. Instead have the content start from the top of the PDF page. We cover it all in this video.
π My Online Courses βΊ xelplus.com/courses
00:00 Convert Excel File to PDF
00:24 Method 1: Use Shortcut
01:18 Method 2: Use Export
01:30 Method 3: Use Save As
01:47 Best Practice Tips
02:36 Page Setup
04:04 Add Page Numbers
04:55 Landscape Orientation
05:03 Repeat Headers on Printouts
05:28 Add Page Breaks
07:08 The Final Result in PDF
07:35 Wrap Up
π¬ LINKS to related videos:
How To EASILY Convert PDF to Word: youtu.be/apLkSKszEPk
Convert Picture to Data in Excel: youtu.be/68yBb7a1uGU
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel #exceltips
Microsoft Word got a new shortcut - Paste text only. Wouldnβt it be great if you could just copy and paste a formatted text without having to manually remove the source formatting like font size, type, or background color?
There is a shortcut called βkeep text onlyβ or βpaste plain textβ in other applications like Microsoft Teams. And now it's available in Word for Windows and Word Mac too! I'll show you how it works in this video.
Requires Microsoft 365. The shortcut will not be available in Excel 2021 and earlier versions.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#word #microsoftword
These are 5 cool and fun websites for you to enjoy. Whether youβre bored or just need a break from work - or you need a fun website for school. I will show you 5 fun websites that you can visit at any time to instantly cure your boredom. From free movie streaming where you can watch movies legally and for free - to free workout plans, free trivia & games and live radio stations. We've searched the web to bring you the best of the best.
00:00 Fun Websites That Will Cure Your Boredom
00:27 Free Movies & Series
01:52 Live Radio Stations
03:12 Free Workout plans
04:08 Learn How Everything Works
05:00 Free trivia website
05:54 Wrap Up
π My Online Courses βΊ xelplus.com/courses
π LINKS to Websites
Tubi TV: tubitv.com
Radio Garden: http://radio.garden
Musclewiki: musclewiki.com
HowStuffWorks: howstuffworks.com
Sporcle: sporcle.com
π¬ LINKS to related videos:
6 Useful Websites You NEED to Use! youtu.be/rvtuQo_8wTA
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I use: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#websites #fun
You're going to love the new TAKE function in Microsoft Excel! It let's you dynamically take the parts of a data set (rows or columns) you need. Basically you can use a function to keep the rows you need and discard the rest. In this video I'll show you how it works.
Requires Microsoft 365. The TAKE function will not be available in Excel 2021 and earlier versions.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
How can you use the Excel FILTER function with two criteria in different columns? I made a short video about this some time ago: youtube.com/shorts/O20bjXIXQKI - The video today gives you a more detailed explanation as well as more examples on how to use the FILTER function to tackle different data challenges.
The FILTER function in Microsoft Excel allows you to filter a range of data based on criteria. This criteria applies to a single column. But what if you need to use the Excel Filter function and apply a condition that applies to multiple columns? You might need to include two or more columns. You might need to account for AND conditions - i.e. the criteria applies to each column, or you might need an OR condition: the criteria applies to either column. There is a trick you can use with the FILTER function that helps you account for multiple columns easily. Once you learn how Excel calculates the FILTER function in the background, you'll learn how to account for any condition, value or criteria you need. Learning this will make you an Advanced Filter functions specialist :).
I'll also show you the new way of using the FILTER function and returning only the columns you need: Combine FILTER with the CHOOSECOLS function to return only the columns you need.
π My Online Courses βΊ xelplus.com/courses
00:00 Using Multiple Criteria within the Excel FILTER Function
00:41 Multiple Criteria With AND
04:58 Multiple Criteria With OR
05:51 FILTER function to return specific columns with CHOOSECOLS
07:09 FILTER Multiple Criteria In The Same Column
09:19 Wrap Up
β¬οΈ Download the file I used in the video from here: xelplus.com/excel-filter-function-with-multiple-criteria
π¬ LINKS to related videos:
Excel Lookup to Return Multiple Values with FILTER Function: youtu.be/Eehk6PC0oGs
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
With the latest update, OneNote desktop finally lets you switch between vertical and horizontal tabs. This way you can have your notebooks, sections and pages neatly organized on the left side. This way you can have the same navigation experience like in OneNote on the web, iPad, Mac, and OneNote for Windows 10.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#onenote
Editing visuals and charts in Power BI just became more Excel-like. So if you're familiar with formatting charts in Excel, you will love this Power BI update!
Microsoft introduced a new way to build and format visuals directly ON the visual. It puts common actions for creating and formatting visuals on the visuals themselves, actions such as adding fields, changing visualization types, and formatting text. Just like you're used to in Excel charts.
You can now easily format your bar, column and line charts directly on the canvas. There is an object edit mode. You don't have to keep going to the side panel to make your updates. Double click on your visual to get the blue border and edit the chart as you need. Check out the video and time stamps for more detail.
After-all most people who open Microsoft Power BI for the first time are overwhelmed. They struggle to navigate around the many panes to perform even simple actions. This update will change that.
Note: This feature for contextual on-object interaction with Power BI visuals is currently in preview. You need to turn it on manually in the Options - Preview features.
π My Online Courses βΊ xelplus.com/courses
00:00 New Power BI On Object User Interface
00:14 How to Turn On-Object Interaction On
00:32 What's Changed in Power BI
01:19 Contextual Options to Build Visuals
02:49 New Formatting Options
03:30 How to Add a Subtitle and Divider to Your Visual
03:57 Pane Switcher and How to Bring Back Closed Panes
04:27 How to Open Different Panes Side by Side
04:52 Turning On the Format Mode for Visuals
06:13 Canvas Settings
06:28 Wrap Up
π¬ LINKS to related videos:
- How to Use Microsoft Power BI: youtu.be/c7LrqSxjJQQ
- How To Create these Useful Power Bi Visuals that Excel Lacks: youtu.be/GpP0EbSMRpg
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I use: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#powerbi
Here are my favorite keyboard shortcuts for Windows 11 file explorer.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#windows #fileexplorer
Learn how to use the "record actions" button in Excel Automate tab and record an Office Scripts. With Office Scripts we'll create a macro that works on both Excel desktop and Excel online. In this example, I'll show you how to create a script to automatically move rows from one sheet to another sheet every single day.
Many of us have to maintain and update task or to-do lists in Excel. Wouldn't it be nice if tasks marked as "Complete" or "Done" are moved to an Archive automatically at the end of each day. So, next time you open the task tracker only open tasks are shown on your to-do list?
For example, you've created an Excel table to collect all the tasks your team is working on. At the end of the day, you want to move all the "Complete" or "Done" tasks to another Excel table. Instead of doing it yourself every single day, you can fully automate it. I'll show you how to create an Office Script to move rows from one table and append it to the bottom of another table based on a logic. I'll also show you how to let the script run automatically at a scheduled time using Power Automate. We'll set up a flow that runs the script every day. This way you don't need to worry about running the script yourself. Power Automate will run automatically.
With this tutorial you'll get to learn both Office Scripts and get an introduction to Power Automate and how to create a flow from Excel.
π My Online Courses βΊ xelplus.com/courses
You can download the script and file here: github.com/LG-Experiment/Scripts
00:00 Move All Rows with Status Finished Into Another Worksheet
02:00 The task tracker
03:40 Record Actions with Office Scripts
05:23 Testing the Recorded Script
06:20 Understanding Office Scripts Code
07:14 Office Scripts to copy visible range in table
08:28 Append rows to the bottom of a table with Office Scripts
11:17 Loop through a table and delete table rows with Office Scripts
15:12 Power Automate to run the script every day
18:18 Optimize and Debug Code
19:31 Wrap Up
π¬ LINKS to related videos:
Introduction to Office Scripts: youtu.be/fny4zUycp_w
How to use Office Scripts and Power Automate to do Boring Excel Tasks for You: youtu.be/v-_joMcPpLI
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#officescripts #powerautomate #excel
Did you ever have to split text over multiple rows in Microsoft Excel so it fits a page nicely? This can be quite a pain. In this video I'll show you a hidden feature that will do it for you! It's called Justify and it does just that.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
Bing Discover now has three features: Chat, Compose and Insights. With "Chat", you get to chat with a chatbot and find specific answers to your questions including resources and links to useful pages. This is all based on the new GPT-4 and it's FREE! With "Compose" you can get started on your writing. Write an email, a paragraph, a blog post or get some ideas. You can also rephrase text in different tones like "Funny", "Causal", "Professional", "Enthusiastic" and "Informational". You have the ability to immediately add the result into your page or copy and paste it in another application.
With "Insights" you get to quickly summarize the web page you're on and also find some related content.
These three features in the Edge Sidebar allow you to easily 10x your productivity like never before. It's a free AI feature that anyone can use right away. It looks like Bing has gotten better than Google search.
π Join 300,000+ professionals in my Online Courses βΊ xelplus.com/courses
00:00 AI in Edge Web Browser is a GAME CHANGER
00:29 Chat with AI in Edge
02:49 Compose Text with AI
08:11 Get AI Insights in Edge
08:50 Wrap Up
π¬ LINKS to related videos:
Why I Prefer Edge to Chrome (and YOU WILL TOO!): youtu.be/v73TaVDWh4s
Top Features of EDGE! (You've GOT to KNOW these!): youtu.be/ATIVwXhTXHg
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#bing #microsoftedge #ai
I'll show you how you can leave hidden messages and easter eggs in your Microsoft Excel file using Excel Name manager and named ranges.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
In this video, you'll discover 6 useful websites you probably didn't know existed. These websites are free to use (or at least have a free version) and they serve different purposes - from keeping you safe to making work fun. You're going to love these websites and tools. For example, there's a site that's gonna help you with your writing, especially when you can't seem to find the right words. Another one that's gonna save you from viruses and malware. Sit back and explore some seriously useful websites that are going to make your work-life easier, safer and more fun.
Here are the links to the websites:
virusscan.jotti.org
printfriendly.com
https://blush.design/
mixkit.co
imglarger.com
quillbot.com
xelplus.com
π My Online Courses βΊ xelplus.com/courses
00:00 Best Websites to Improve Daily Workflow
00:24 Jotti's Malware Scan
02:13 Print Friendly
03:16 Blush
04:30 Mixkit
06:09 AI Image Enlarger
07:27 Quillbot
09:09 XelPlus
π¬ LINKS to related videos:
- Cool Free Windows Utilities to Use EVERYDAY: youtu.be/ZlyxesiiC6U
- 5 Mind-Blowing FREE Windows Apps: youtu.be/yridBTXFme8
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ RESOURCES I use: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#websites #productivity
Microsoft Excel will now create a personalized toolbar just for you. It's based on your most frequently used commands for quick and easy access. And no worries, you'll still be able to view the classic ribbon whenever you want.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel #productivity
Career advice reversed: Here is the Ultimate Guide to sabotaging your career growth and losing motivation at work. Follow these simple steps and you'll make sure that you never move up the career ladder. To be successful in your career and be motivated at work, do the opposite of what is shared or follow what I cover at the end of the video. That's the ultimate way to career growth and being happy at your job.
I find these reverse videos more relatable. Shoutout to the Better Ideas YouTube channel which served as the inspiration for this video.
π My Online Courses βΊ xelplus.com/courses
00:00 How to NOT Get Promoted
00:09 Step 1: Stop Learning
00:54 Step 2: Complain
02:06 Step 3: Make Yourself Irreplaceable
03:07 Step 4: Stay Invisible
03:54 Step 5: Blame Others
04:53 Wrap Up
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#careeradvice #selfhelp
In this video, weβll cover how to use Microsoft's Power Toys. I'll show you my favorite utility called Always On Top. Use it to pin a window like Sticky Notes to always stay on top of other windows.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#windows #powertoys
In this video I'll show you 4 ways on how to find duplicates in your Microsoft Excel data. We'll find solutions regardless if your data is in the same column, in separate columns and even if you need to find duplicates for a combination of cells. You'll learn how to use conditional formatting to color duplicate values, how to look inside an entire row and compare one row with another and flag it is a duplicate. As a bonus you'll learn how to use a dynamic formula to flag duplicate entries with an icon or returns just the duplicate entries.
π My Online Courses βΊ xelplus.com/courses
00:00 Find and Remove Duplicates in Excel
00:33 Find Duplicates in Columns
01:43 Find Duplicate Rows
03:09 Excel Formulas to Find Duplicates
06:37 Use Formulas to Return Duplicate Values
08:07 Wrap Up
β¬οΈ Download the file I use in the video from here: xelplus.com/excel-find-and-highlight-duplicates
π¬ LINKS to related videos:
3 EASY Ways to Find and Remove Duplicates in Excel: youtu.be/ADArCWLz55Y
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
In this video, weβll set up the FILTER function with two criteria in different columns. Both of these conditions have to be met (AND) for the result to be included. If you're searching for how to FILTER your data with multiple criteria, this video has the answer. If you need OR criteria, for example looking up two different values within the same column, you'll need to use the PLUS operator.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel
OneNote is a great note taking app. You can improve your productivity and work faster in OneNote if you remember some of these useful OneNote shortcuts. In this video I'll show you the best keyboard shortcuts for Microsoft OneNote to improve productivity and streamline your workflow. You'll learn how to quickly add pages/sections, navigate faster in your notes, how to create To Dos and Flags, and how to efficiently use Search in OneNote.
00:00 Best OneNote Shortcuts to Boost Your Productivity
00:16 Which OneNote Version Should You Use?
00:40 Create New Pages/Sections
01:26 How to Navigate Faster
04:41 How to Quickly Use Tables
06:02 Add Tags and Outlook Flags
07:54 Quickly Search in OneNote
08:44 Full List of Shortcuts
08:49 Wrap Up
π My Online Courses βΊ xelplus.com/courses
π¬ LINKS to related videos:
What happened to OneNote?: youtu.be/4IkUfh05TGE
5 Tips to Unlock the Power of OneNote: youtu.be/ElsiptoaSm8
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#onenote #notetaking
OpenAI inside Excel? How can you use an API key to connect to an AI model from Excel? Wouldn't it be great to have a search box in Excel you can use to ask any question? This video shows you how.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#Excel #chatgpt
Microsoft introduced a new feature in Power BI that can suggest DAX formulas for you. You can ask for the DAX measure you need in natural language and artificial intelligence will write the DAX code for you. The AI used is OpenAI GPT-3. It's one of the first AI integrations of GPT-3 in the Microsoft applications. In this video we'll see how well this works. It's also important to test your DAX measures and also some scenarios you need to be aware of. So you'll have to currently "correct" the automatic DAX measures that are written for you.
π My Online Courses βΊ xelplus.com/courses
00:00 No More Learning DAX
00:24 Important Settings for Quick Measure Suggestions
01:43 Why Use AI in Power BI
02:14 Simple Measures with AI
03:49 More Complex Measures
05:44 When AI in Power BI Fails
09:03 What to Watch Out For
13:02 My Conclusion about AI in Power BI
π¬ LINKS to related videos:
Should You Learn Power Bi? Everything You Need To Know: youtu.be/7ZMQZ0UUuTs
How To Create these useful Power Bi Visuals that Excel Lacks: youtu.be/GpP0EbSMRpg
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π 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!
#powerbi #ai #chatgpt