Want to make charts in Excel that look as good as the ones in The Economist magazine? This video shows you how. We cover three types of charts from The Economist: A special type of Bar Chart, Dumbbell Charts (also known as connected dot plot or before after chart), and Color-Coded Tables. These are professional Excel visuals you can add to your corporate presentation. You can also apply these Excel chart techniques to create other charts you come across from The Economist or elsewhere in news magazines or social media.
You'll learn how to set them up step by step, making your data presentation clear and engaging. This guide is perfect for beginners and anyone looking to improve their Excel skills. By the end of this tutorial, you'll be able to create eye-catching charts that can help in any report or presentation.
πΈ Easy-to-follow chart making in Excel πΈ Create professional-looking charts like The Economist Magazine quickly πΈ Tips for dynamic and clear data presentations in Excel
00:00 How to Make a Graph in Excel like The Economist Magazine 00:26 Bar Chart 04:32 Dumbbell Chart 11:07 Sponsor think-cell 12:45 Color-Coded Table 18:36 Outro
π¬ LINKS to related videos: Excel Charts & Graphs: Learn the Basics for a Quick Start: youtu.be/DAU0qqh_I-A Create Impressive Infographics in Excel: youtu.be/8g9DK5noi1s
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!
Many thanks to think-cell for sponsoring this video.
Make Beautiful Excel Charts Like The Economist (file included)Leila Gharani2024-03-14 | π Try think-cell for free: tinyurl.com/xelplus
Want to make charts in Excel that look as good as the ones in The Economist magazine? This video shows you how. We cover three types of charts from The Economist: A special type of Bar Chart, Dumbbell Charts (also known as connected dot plot or before after chart), and Color-Coded Tables. These are professional Excel visuals you can add to your corporate presentation. You can also apply these Excel chart techniques to create other charts you come across from The Economist or elsewhere in news magazines or social media.
You'll learn how to set them up step by step, making your data presentation clear and engaging. This guide is perfect for beginners and anyone looking to improve their Excel skills. By the end of this tutorial, you'll be able to create eye-catching charts that can help in any report or presentation.
πΈ Easy-to-follow chart making in Excel πΈ Create professional-looking charts like The Economist Magazine quickly πΈ Tips for dynamic and clear data presentations in Excel
00:00 How to Make a Graph in Excel like The Economist Magazine 00:26 Bar Chart 04:32 Dumbbell Chart 11:07 Sponsor think-cell 12:45 Color-Coded Table 18:36 Outro
π¬ LINKS to related videos: Excel Charts & Graphs: Learn the Basics for a Quick Start: youtu.be/DAU0qqh_I-A Create Impressive Infographics in Excel: youtu.be/8g9DK5noi1s
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!
Many thanks to think-cell for sponsoring this video.
#Excel #theeconomistStop Wasting Time! 3 Easy Ways to Remove Blank Rows in ExcelLeila Gharani2024-10-17 | Join 400,000+ professionals in our courses π link.xelplus.com/yt-d-all-courses Tired of deleting blank rows one by one? Learn how to quickly remove blank rows in Excel using three simple, time-saving methods!
π Learn Excel the Easy Way! Start automating tasks and analyzing data faster with our step-by-step courses: Excel Power Query Course: Clean, transform, and automate your data π xelplus.com/course/excel-power-query Excel Pivot Table Essentials Course: Summarize and analyze your data effortlessly π xelplus.com/course/excel-pivot-tables
Join now and see how easy Excel can be!
In this video, you'll discover: - Go To Special: A fast, under-20-second method to delete blank rows. - Filters & Formulas: Ideal when you want to ensure every cell in a row is empty before deleting. - Power Query: The best dynamic solution that updates automatically, perfect for large datasets.
These tips will help you avoid manual work, speed up your workflow, and keep your spreadsheets clean. No more wasted time!
Whether you need to remove blank rows or delete multiple rows with blank cells, this video has everything you need. Try these methods and see which one saves you the most time!
β¬οΈ Download the practice file here π https://xelplus.ck.page/remove-blank-rows-file
00:00 How to Delete Blank Rows in Excel 00:32 Go to Special: Fastest Solution 02:13 Filter & Formula: Delete Only Completely Empty Rows 04:29 Power Query: The Best Way to Handle Large or Changing Datasets
π¨ Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
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!
#ExcelAre These Pivot Table Mistakes Costing You?Leila Gharani2024-09-19 | Join the Excel Pivot Table Essentials course π xelplus.com/course/excel-pivot-tables Mastering Pivot Tables is a valuable, time-saving skill, and I canβt wait to teach you from the ground up.
In this video we address common pivot table related questions and how you can avoid them: How can I make sure my pivot table doesn't show outdated data? π€ How can I connect a slicer to multiple pivot tables? How can I VLOOKUP on a pivot table? π« Should I stick to the default look of pivot tables?
I'm summarized these as the 3 most common Pivot Table mistakes that are slowing you down:
1. Auto-Refresh Your Pivot Table β Learn how to make Excel update your data automatically! 2. Use One Slicer for Multiple Pivot Tables β Easily filter several Pivot Tables with just one slicer. 3. Stop Using VLOOKUP/XLOOKUP β Save time by combining data from multiple tables without writing any formulas. 4. Bonus Tip: Iβll also show you how to give your Pivot Tables a clean, professional look in just one minute!
00:00 Common Pivot Table Mistakes 00:06 Auto-Refresh your Excel Pivot Table 01:38 Use One Slicer for Multiple Pivot Tables 03:46 Not Using Power Pivot 07:07 Missing Formatting
π‘ Ready to master Pivot Tables? Click the link to join my course: Pivot Table Essentials: Basics to Mastery π xelplus.com/course/excel-pivot-tables With practice files, templates, and quizzes, youβll learn everything you need to become a Pivot Table pro!
π¨ Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
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!
Want to make your Excel Pivot Tables more powerful? In this video, we'll show you some of the best hidden features that most people miss. These simple tips will save you time and make your data analysis easier.
We'll start with how to create a pivot table quickly with the help of recommended Pivot Tables. Then, we'll show you how to keep track of important numbers with Dynamic Formattingβeven when your data changes.
Learn how to highlight top and bottom performers using Conditional Formatting in pivot tables and discover how custom number formatting can make your Excel pivot table reports look professional and clear.
Finally, weβll share how to adjust your default pivot table settings and use report filters to automate your work.
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!
#ExcelSolving Excel COUNT Problems with COUNTIFS Function (practice file included)Leila Gharani2024-08-08 | Join 400,000+ professionals in our courses here π link.xelplus.com/yt-d-all-courses
The Excel COUNTIFS function is perfect for counting cells based on multiple criteria.
What Youβll Learn: - How to use COUNTIFS - Differences between COUNTIF and COUNTIFS - Count cells with multiple conditions - Use COUNTIFS with OR conditions - Count cells not equal to a value - Count cells greater than a number - Handle blank and non-blank cells - Count cells between dates in Excel - Count cells with partial text using wildcards
π¨ Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
00:00 COUNTIFS Function in Excel 00:46 COUNTIF vs COUNTIFS 01:21 COUNTIFS Function in Excel with Multiple Criteria 03:37 Excel COUNTIFS OR 05:17 Excel COUNTIFS Not Equal To 06:20 Excel COUNTIFS Greater Than 07:29 Excel COUNTIFS Not Blank 08:42 Excel COUNTIFS Date Range 09:59 Excel COUNTIFS Contains Partial Text 11:42 Wrap Up
π¬ LINKS to related videos: How to Use SUMIFS, COUNTIFS and AVERAGEIFS in Excel: youtu.be/AZuBNWMh7VM How to SUMIFS With Multiple Criteria In the SAME Column in Excel: youtu.be/3BnvDPQk9o0
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!
Learn how to use the amazing new Excel TRANSLATE function to translate text and instructions into over 100 languages. Perfect for business forms, input sheets, team instructions, and more! There is also a DETECTLANGUAGE function that detects the language of the text.
What You'll Learn: - How to add a language dropdown in Excel - Step-by-step guide to using the Translate function - Practical examples of translating text dynamically - Tips for using the Detect Language function
00:00 How to Translate in Excel 01:04 Excel TRANSLATE Function 03:27 Detectlanguage Excel Function 03:54 Practical uses of TRANSLATE Function 05:58 Translate Data Entry Sheets 08:13 Wrap Up
Why You'll Love The TRANSLATE Function: - Makes working with international teams easier - No more manual translationβsave time and effort - Everything stays dynamic and up-to-date
Availability: These functions are currently available to Beta Channel users running Windows version 2407 (Build 16.0.17808.20000) or later.
π¨ Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
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!
Do you always forget your grocery list? π Don't worry! Learn how to use the Microsoft To Do app to keep track of your shopping list effortlessly. In this video, I'll show you how to create, manage, and share your grocery list with ease.
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!
Learn how to take screenshots on Windows 11 quickly and easily. This video covers everything from basic shortcuts to advanced Snipping Tool features. No need for extra apps β it's all built-in and free! You now have the ability to add emojis in the Snipping tool. You can add arrows and shapes. You can also use the ruler using the shortcut keys Control R. It can also be found in more options (the three dots).
Note: You might not see the new features in your version of Windows yet. These are still in Windows insider program.
Recording Videos: Windows Key + Shift + R: Record screen activity.
Customize Settings: Adjust auto-save and Print Screen shortcuts via Snipping Tool settings.
00:00 How to Take a Screenshot 00:30 Screenshot Shortcuts 02:22 How to Use Snipping Tool 03:50 Take Screenshot with Delay 04:35 Annotate Your Screenshot 05:37 Add Shapes and Emojis to Screenshot 07:22 Extract Text from Screenshot 07:36 Extract Link from QR Code 07:58 Redact Sensitive Information 08:36 Visual Search / Reverse Image Search 09:06 Take a Video Screenshot 10:14 Important Settings for Snipping Tool 11:07 Disabling Snipping Tool Opening with Print Screen 11:19 Wrap Up
π¨ Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
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!
#windows11 #screenshotIntroducing REGEX Excel Functions - Extract, Clean, and Format Data Easily! (NEW!)Leila Gharani2024-05-22 | Join 400,000+ professionals in our courses here π link.xelplus.com/yt-d-all-courses
Regex, or regular expressions, is now available in Excel beta version! This makes it SO much easier to search, match, and manipulate text. (note: currently not all beta users have access. Microsoft is slowly rolling these out.)
With regex, you can quickly find all email addresses in a list, reformat dates, or correct typos in a large dataset. You can extract phone numbers from text or change the format of thousands of rows with just a few clicks.
In this video we'll cover two new Excel functions: βΆ REGEXEXTRACT: This Excel function extracts specific text from a string using patterns called regular expressions (regex). It can find and pull the first match, all matches, or parts of the first match. βΆ REGEXREPLACE: This Excel function lets you replace parts of a text string using patterns called regular expressions (regex). This is useful for cleaning up data or making consistent changes across a dataset.
00:00 Regular Expression Regex in Excel 02:37 Extract Email Addresses with Excel REGEXEXTRACT 07:37 Extract Text Inside Parentheses with Excel REGEXEXTRACT 09:27 Extract Dates from Text with Excel REGEXEXTRACT 10:56 Extract Multiple Dates from Text in Excel 11:49 Extract Website URL from Text in Excel 14:31 Split Combined Words in Excel 14:59 Replace Leading Zeros with Excel REGEXREPLACE 16:06 Replace Special Characters with Excel REGEXREPLACE 17:30 Insert a Character at Specific Positions 18:34 RegEx Cheat Sheet 18:47 Wrap up
π¨ Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
π¬ LINKS to related videos: We FINALLY get the New Excel functions we've been Wanting! youtu.be/VWcLM6_Q_00 New Excel GROUPBY & PIVOTBY Functions: youtu.be/mCJzhCxEQlM
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 #regex #regularexpressionsHow to Use VLOOKUP in Excel (free file included)Leila Gharani2024-05-09 | Join 400,000+ professionals in our courses here π link.xelplus.com/yt-d-all-courses
Excel VLOOKUP is one of the most essential functions in Excel. In this tutorial for beginners you'll learn how to properly use Excel VLOOKUP without mistakes. Youβll learn how to quickly find information from different sheets, get exact or closest matches, and troubleshoot common errors. VLOOKUP Excel saves you time and reduces mistakes by automating data searches across your spreadsheets.
00:00 VLOOKUP Excel 00:50 How to Do a VLOOKUP Formula 05:29 VLOOKUP Across Sheets 07:09 VLOOKUP Approximate Match 09:14 VLOOKUP Not Working 11:29 NA Error in VLOOKUP 12:18 Get rid of NA Error in VLOOKUP 14:31 XLOOKUP Excel
We start with the basics: how to do a VLOOKUP to find related information, like a customerβs profession from another dataset. Youβll learn how to set up your data range correctly and discover the importance of fixing the table array to avoid shifting ranges when copying formulas. This practical VLOOKUP example shows you the essentials of how to use VLOOKUP effectively.
We also dive into advanced VLOOKUP techniques, including how to use VLOOKUP across different sheets, how to find exact matches with the FALSE parameter, and how to handle approximate matches efficiently. Plus, we tackle common VLOOKUP errors and show you how to correct them using simple adjustments and functions like TRIM and IFNA.
By the end of this video, you'll be equipped to use the VLOOKUP formula confidently. Youβll understand why itβs a go-to tool for Excel users seeking to streamline their data analysis tasks.
π¨ Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
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!
Learn to quickly make professional charts in Excel. These are simple, modern Excel charts that communicate your data clearly and in an engaging way.
This tutorial shows you how to design charts similar to those used in top industry reports. They fit in any corporate report or consulting presentation. The best part? We use a simple Excel function to create the chart. This is Excel's hidden Chart Function! The method is ideal for improving your business reports with effective visuals, without the need for complex software. Just with a few clicks you'll be able to create an impressive McKinsey chart in Excel. This McKinsey chart is often referred to as the lollipop bar chart or the pin horizontal chart.
You can also use this Excel function to create a super fast bar chart in Excel. Tweak it to create a star bar chart or use any symbol you like. It's so flexible and easy, you'll love this simple Excel hack.
Learn about: β Using the REPT function to customize chart bars with emojis and symbols. β Modifying charts dynamically to adapt to data changes instantly.
For more detailed insights and advanced techniques, check out our full course on Business Charts in Excel. This course is designed to help you create charts that stand out in any professional setting, mimicking the sophisticated styles seen in publications like The Economist and McKinsey reports.
00:00 Use THIS Excel function to Create a McKinsey chart 00:30 Create a Excel McKinsey Chart in 90 seconds 02:24 Customize the Chart 06:49 New Course: Business Charts in Excel
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!
#ExcelEasy Trick for Sorting Columns in Power Query #shortsLeila Gharani2024-02-25 | Did you know you can custom sort your columns in Power Query with this trick? It's a cool hidden Power Query feature in Excel.
π 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!
#ExcelAnswering Uncomfortable Questions with Oz du SoleilLeila Gharani2024-02-22 | Join 400,000+ professionals in our courses here π link.xelplus.com/yt-d-all-courses Today's episode is unlike any other! We're delighted to welcome Oz du Soleil, a fellow Excel MVP from Las Vegas, to dive deep into some of the most intriguing and challenging topics you've been curious about. From overcoming life's hurdles to mastering Excel and sharing personal triumphs, Oz opens up like never before. Expect a blend of humor, wisdom, and actionable insights that you won't find anywhere else.
What makes Oz's journey compelling? How does he tackle the complexities of Excel and life with equal finesse? We've got your questions covered, and trust us, you'll want to hear Oz's answers. Whether you're seeking inspiration, Excel hacks, or just a good story, this episode has something for everyone.
π¨ Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
00:00 Introduction 00:54 Oz incoming 02:18 How is Vienna? 04:07 How do you become a Microsoft MVP? 07:02 What personality is MVP life for? 11:48 Oz's background 21:56 What was your Plan B? 26:47 Oz's personal struggles 32:33 Experience with discrimination 38:51 How to manage business ups and downs and persist? 47:41 Are you married? 48:31 Do you get recognized? 49:34 Is Oz a dirty data assassin? 50:06 The most evil Excel function? 53:34 How to give your data a red mohawk? 53:52 Oz's Excel improvement idea 56:18 Oz and the kaleidoscope scene? 59:20 Jumping on the horse (Fiaker)
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!
#ExcelUse Slicers to Filter Excel Data #shortsLeila Gharani2024-02-04 | This is a cool way of filtering tables using slicer buttons instead of filter buttons.
Slicers create buttons that you can simply click to filter data. This works in Microsoft Excel tables, or PivotTables. They also show you quickly, which filters are set. This makes it easy to understand what exactly is currently displayed.
π 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!
#ExcelHow to Custom Sort a Pivot Table #shortsLeila Gharani2024-01-28 | Join 400,000+ professionals in our courses: xelplus.com/courses
Here is a simple trick on how to custom sort your date in a Microsoft Excel Pivot Table.
π 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!
#ExcelHow to freeze a row in Excel (& freeze multiple rows or columns with just one click) #shortsLeila Gharani2024-01-21 | π Join 400,000+ professionals in our courses βΊ xelplus.com/courses π¨ Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
Struggling to keep track of headers while scrolling through large datasets in Excel? Say goodbye to that frustration! In this video, we're diving into a simple yet impactful feature: Freezing Panes in Excel. You can free the top row so when you scroll, the top row is always visible. You can also freeze multiple rows or multiple columns in Excel with just one click. This is perfect for maintaining a clear view of your important data, no matter how big your spreadsheet is!
π What You'll Discover: How to freeze a single row or multiple rows to keep headers visible. Steps to freeze panes for both rows and columns, allowing for easy navigation sideways and downwards.
π₯ Key Takeaways: Enhance your data management skills in Excel with ease. Ideal for professionals dealing with extensive data reports. Learn to navigate large datasets without losing sight of key information.
π₯ Who Should Watch: Excel users at any level looking to improve their navigation skills. Professionals seeking efficient ways to manage large Excel reports. Non-native English speakers desiring straightforward, professional Excel tips.
π 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!
#ExcelExcel GROUPBY & PIVOTBY Functions - All You Need to Know (do they BEAT Pivot Tables? π€)Leila Gharani2024-01-12 | Join 400,000+ professionals in our courses here π link.xelplus.com/yt-d-all-courses
Data analysis in Excel just got easier! Let me introduce you to the new Excel functions in Office 365: Excel GROUPBY and PIVOTBY functions. With these Excel functions you get to replace pivot tables with simple Excel formulas. In the video I cover the advantages of GROUPBY and PIVOTBY over pivot tables - for example the ability of GROUPBY to aggregate text values which pivot tables can't do. Also the ability to clean your data, for example remove total rows in the middle of your dataset or exclude certain rows with the Groupby and Pivotby functions. You also no longer need to refresh your data to get the latest result because formulas update automatically.
In addition you'll learn about GROUPBY's optional arguments, like displaying headers, managing totals, and sorting data. A key highlight is its ability to process text values, offering unique text aggregations which is a notable advantage over Pivot Tables.
See GROUPBY in action as it tidies and analyzes complex data sets, easily filtering out unnecessary information for clearer reports. I also demonstrate how it efficiently groups sales data by year or month.
Finally, get to know PIVOTBY. This function is great for reducing vertical scrolling in reports, by shifting one or more of the categories to columns for a more concise and readable format.
Availability: GOUPBY & PIVOTY are currently available for Microsoft Insider Beta Channel only.
00:00 Why these new Excel functions completely beat Pivot Tables! 00:19 How to use Excel's GROUPBY function 02:19 How to use GROUPBY Optional Argument Field Headers 03:30 GROUPBY Optional Argument Total Depth 04:43 GROUPBY Optional Argument Sort Order 05:43 GROUPBY - How to Aggregate Text Values 07:27 How to Exclude Unwanted Rows with Filter Array 11:27 How to GROUPBY Years & Months 12:57 How to Combine Different Columns 13:57 How to use Excel's PIVOTBY function 16:14 Wrap Up
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 to create a drop-down list in Excel in seconds!Leila Gharani2024-01-07 | π Join 400,000+ professionals in our courses βΊ xelplus.com/courses π¨ Subscribe to our "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
In this Excel tutorial, we're showing you a simple yet powerful way to improve your Excel reports: adding a dynamic, searchable drop-down list in Microsoft 365! Perfect for making your reports more interactive and user-friendly.
π What You'll Learn: How to create a drop-down list using data from a different sheet. Steps to implement the data validation feature in Excel. Duplicates are automatically removed and the drop-down is even searchable.
π Who Should Watch: Excel users looking to improve their report presentation. Anyone interested in making their data more accessible and interactive. Non-native English speakers in corporate roles, seeking clear and professional Excel guidance.
π 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!
#ExcelQuick & Easy: Browser Shortcuts to Make Life Simpler #shortsLeila Gharani2023-12-17 | Join 400,000+ professionals in our courses: xelplus.com/courses
Let's learn how you can surf the web a lot smoother with some handy keyboard shortcuts.
π 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!
#windowsMaster Excel Web Scraping - Learn How to Import Data AND Images (with ZERO Coding)Leila Gharani2023-12-14 | Learn Power Query now with our Beginner to Pro course: link.xelplus.com/yt-pqweb π¨ Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
With the recent updates to the Power Query web connector you can grab data from pretty much any web page and bring it over to Microsoft Excel. Plus you'll have a connection to the webpage. Which means, just click the "refresh" button and pull over the latest information. π€ One challenge I was excited to tackle was to import "clickable" URL links AND images with Power Query into Excel. Yes. It's possible to have clickable links in the Power Query extract. It's also possible to extract images from web pages! Check out the video to see my solution.
π What You'll Learn: How to use Excel's web connector for easy data import. Tips for importing data from web pages without HTML tables. Creating dynamic, clickable links and images in Excel with ease.
π Excel Your Skills: Perfect for analysts, Excel enthusiasts, and anyone interested in data management. Step-by-step guidance, making it accessible for beginners and a time-saver for advanced users.
π Key Moments in This Video: 00:00 - Introduction to Excel's Web Connector 02:30 - Importing Data from Web Pages 04:38 - Add Table Using Example 09:10 - Creating Clickable hyperlinks in Power Query 12:01 - Importing web images 12:40 - Updating webpage to test 13:28 - Wrap Up
π¬ LINKS to related videos: How Power Query Will Change the Way You Use Excel: youtu.be/6lBqYInBldk You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query: youtu.be/8hjgmJk5RiA
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!
#ExcelDont Type the Dot! | How to Get Power Query Intellisense To Work #shortsLeila Gharani2023-12-03 | Join 400,000+ professionals in our courses: xelplus.com/courses
For the longest time, entering M-Functions in Microsoft Power Query was a frustrating exercise for me. Until I discovered the trick I'm sharing in this video.
π 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 #powerqueryCreate an Excel Dashboard to Easily Track Budget and Actuals with VariancesLeila Gharani2023-11-30 | Get Zebra BI-Pro for free for 30 days: bit.ly/3GjXFKV
In this step-by-step Excel tutorial, we'll create a dynamic and interactive Excel dashboard from scratch. We'll be comparing Actuals to Budget and Previous year data. The Actual data is on another sheet in an Excel table and it has a different structure so we have to use an Excel formula that enables us to lookup values in three different columns and match them so we can find the correct row. You can use different formulas. I used XLOOKUP but you can also use Index and Match (youtu.be/ontXHp9cwOQ) in case you don't have XLOOKUP. Our next challenge is to bring over budget data from another sheet. This time we have to match the rows and the columns. Again, you can use Index Match or XLOOKUP (I show the XLOOKUP approach).
I also show you how add a drop-down for months and use a formula to grab the current year.
Then I move on to variance calculations (percentage change). Once we have the information we create a column chart to compare actual and previous year data and also add Excel bar charts to show the variance. We make sure that positive values (bars) are in green and negative bars are in red. We do this dynamically of course using "invert if negative" feature of Excel charts. Lots to cover, so get ready to transform your understanding of actual sales, budget figures, and variances into a visually stunning and informative dashboard.
π What you'll discover: βΆ Excel Dashboard Design: Receive detailed, step-by-step instructions on crafting an automatically updating sales dashboard. βΆ Data Management in Excel: Learn effective techniques for extracting data from various sources and establishing intuitive user selections. βΆ Advanced Excel Functions: Gain proficiency in XLOOKUP and other critical Excel functions for precise data analysis. βΆ Variance Analysis: Understand the methods to calculate and visually present data variances. Excel Chart Visualizations: Acquire skills in adding dynamic column charts for a compelling visual data interpretation.
00:00 How to Setup an Interactive Dashboards in Excel from Scratch 00:53 Setup of Data 02:20 Drop-Down for Month Selection 07:49 Calculate Variance Actual to Previous Year/Budget 09:37 Add Visual Insights 14:00 Zebra BI Add-in 21:34 Wrap Up
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!
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.
π 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 #corporatelifeExcels NEW Checkboxes Are Incredibly Cool! Heres whyLeila Gharani2023-11-16 | Join 400,000+ professionals in our courses here π link.xelplus.com/yt-d-all-courses
In this video, I'll introduce you to the brand-new checkboxes in Excel. They're simple and much better than the old ways we used to do things. I'll take you through different ways to use these checkboxes, not just for keeping track of your to-do list. In fact, we'll be creating an interactive Excel dashboard using with the checkboxes.
Note on availability: The new Excel checkboxes are currently available in Office 365 beta version.
But first, I'll guide you step by step on how to use these checkboxes in Excel. You'll learn how to keep track of your tasks - then you'll learn how count the total number of checkboxes and also how to count the number of checked checkboxes and add it at the top of our Excel sheet. You'll then learn how to combine these checkboxes with formulas for smarter data analysis - I show the combination with the FILTER function in this example - Then you'll learn how to combine the state of the checkbox with conditional formatting, so that you can change the color and formatting of the entire row when an item is checked. Finally, you'll learn how to add a timestamp to a cell when a checkbox is checked. This is great for task and project management.
This video is perfect for beginners and for those who want to discover new features in Excel and also learn some dashboard tricks. I've made sure everything is easy to understand, with no complicated terms β just simple, clear steps that you can follow along.
00:00 How to Insert Checkboxes in Excel 00:19 New Checkboxes in Excel Basics 03:23 Count Checked Checkboxes 07:05 Combine Checkbox with Formulas 08:39 Conditional Formatting with Checkboxes 11:02 Bonus! Add a Timestamp when Checked 14:00 Wrap Up
π 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!
#ExcelKeep It Private π€« Instant Windows Shortcuts for Unexpected Interruptions #shortsLeila Gharani2023-11-12 | Join 400,000+ professionals in our courses: xelplus.com/courses
In this video I'll show you how you can quickly hide what you're doing on your computer.
π 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!
#windowsHow to Calculate Change / Variance in Pivot Tables #shortsLeila Gharani2023-11-05 | Join 400,000+ professionals in our courses: xelplus.com/courses
You'll learn how to calculate year over year variances in a Microsoft Excel Pivot Table. This works for calculating actual to budget variances as well.
π 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!
You'll learn 5 Excel features that are mega time-savers. Useful for beginners and advanced Excel users. All of these tips are easy to apply for any level. Here's what we cover: 1. Quick-Jump Excel Bookmarks: Navigating across a large workbook can be challenging. If only there were built-in bookmarks in Excel. There's a trick to achieve the same result, though: use the Name Box. 2. Analyze Data for instant insights: You need to quickly analyze an unfamiliar dataset? Why not outsource it to AI! There's an AI feature built into Excel that can do it for you. You'll find it on the Home tab, it's called Analyze Data. When you run it, it will auto-generate some ready-to-use insights in the form of pivot tables and pivot charts, or you can ask for something specific, like "give me 5 products with lowest customer ratings". It will interpret the question in data analyst terms and prepare a pivot table for you. You can then simply insert it into your report. 3. One-Click Forecasting: Would you like to forecast your future sales revenues based on past data? Select the dataset, go to the Data tab and click on Forecast Sheet. Future sales data is automatically forecasted, even accounting for seasonality. 4. Quick Analysis Tool: This one packs a whole bunch of features in a single shortcut. It's like your personal Excel assistant that you can ask for almost anything. Select the data you're working with, then press Ctrl+Q to bring up the Quick Analysis menu. It allows you to add conditional formatting, charts, totals, tables and sparklines based on your data. 5. The ultimate timesaver - Power Query: I've saved the best for last. You probably know by now that Power Query is my favorite tool. It allows you to grab data from many different sources, like text/csv, web, pdf, and more. But it also allows you to do complex transformations on the data right there in your workbook in a couple of very simple clicks. In the video, I show you how to pivot a column, but there's a ton more that you can achieve with this amazing tool. And the best part? It's fully dynamic. When your data grows, all you have to do is refresh.
00:00 Excel Timesaver features 00:20 Excel Bookmarks 02:16 How to delete a bookmark 02:30 AI Powered Data Analysis 04:29 One-Click Forecasting 06:27 Quick Analysis Tool 08:48 Power Query the ultimate timesaver 09:42 Convert Rows to Columns with Power Query (pivot data) 11:45 Learn Power Query from scratch 13:37 Wrap Up
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!
#ExcelWindows Magnifier to Make Things on the Screen Easier to See #shortsLeila Gharani2023-10-29 | Join 400,000+ professionals in our courses: xelplus.com/courses
Here is a simple trick on how to use the Windows Magnifier to zoom in and out of your screen. Use the shortcut key for quick zooming in and zooming out.
π 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!
#windowsNew Shortcut to Quickly Search the Menus in Excel #shortsLeila Gharani2023-10-22 | Join 400,000+ professionals in our courses: xelplus.com/courses
Here is a simple trick on how to quickly search for anything in Microsoft Excel.
π 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!
#ExcelQuickly Rename Excel Tables with This Quick Access Toolbar Trick #shortsLeila Gharani2023-10-15 | Join 400,000+ professionals in our courses: xelplus.com/courses
Add table name to your quick access toolbar in Microsoft Excel today.
π 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!
#ExcelProper Shutdown: Get a clean reboot every time you shutdown your PC #shortsLeila Gharani2023-10-08 | Join 400,000+ professionals in our courses: xelplus.com/courses
We've all seen the buttons for Shut down and Restart in Windows. But have you ever wondered what is the difference between a "shut down" and a "restart"?
π 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!
In this video, we're diving deep into 6 powerful strategies that will help you turn your Excel skills into a money-making machine! I've personally tested most of these methods, and to make it even more exciting, I've brought in a special guest who will share some eye-opening insights: Jordan Goldmeier - digital nomad entrepreneur. We'll categorize each strategy by its difficulty and profit potential, so you can choose the perfect fit for you. We talk about corporate jobs, consulting (the consulting freedom ladder), books, online courses, speaking opportunities, workshops and social media. There are many ways you can use your Excel skills to make money working online, onsite or from home. These don't need to be full time jobs either, you can start any of them as a side-hustle.
********************* π The Global Excel Summit is back and better than ever, and I'm excited to announce that I'm your ambassador for the third time! Don't wait too long - in-person seats are limited. Secure your tickets on the official website: globalexcelsummit.com/?via=leila Use discount code LEILA upon checkout to get an additional 20% off. π Save the Date: February 6-8, 2024 π Location: Vue Cinemas, Angel Central, London, UK *******************
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!
#ExcelHow to Repeat and Center Labels in a PivotTable #shortsLeila Gharani2023-10-01 | Join 400,000+ professionals in our courses: xelplus.com/courses
Here is a quick Excel Pivot Table tip to present your pivot table nicely and professionally. Learn how to repeat labels in the pivot table if you need the have a value on each cell or, if you want to present the pivot table a nice way you can center the labels.
π 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!
#ExcelGreat Power Query Tip βΆοΈ How to Import Entire File Content in Excel or Power BI #shortsLeila Gharani2023-09-24 | Join 400,000+ professionals in our courses: xelplus.com/courses
You can easily import entire file contents in Microsoft Excel Power Query by making the one crucial selection I'm sharing in this video. This is a great power query tip for anyone using Excel or Power BI.
π 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 #powerbiDont Use ChatGPT Until You Watch This VideoLeila Gharani2023-09-21 | Get access to "Quick Wins with ChatGPT" productivity course: link.xelplus.com/yt-chatgpt-improve-course π₯use coupon code YTGPT at checkout to get 30% off - available for limited time π₯ or join 400k professionals in our other courses: xelplus.com/courses
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.
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
π¬ 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
π 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 #promptengineeringUseful Websites to Use Today #shortsLeila Gharani2023-09-17 | Join 400,000+ professionals in our courses: xelplus.com/courses
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.
π 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!
#websitesCool Excel Trick π‘Use Slicer Buttons With a Hidden Pivot Table #shortsLeila Gharani2023-09-10 | Join 400,000+ professionals in our courses: xelplus.com/courses
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.
π 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!
#ExcelEasiest Ways to Export Power BI to Excel Smoothly and Efficiently (new updates included πͺ)Leila Gharani2023-09-07 | π Join our popular FREE Power BI QuickStart course today: link.xelplus.com/yt-d-AI-powerbi-freecourse
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.
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
π¬ 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
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 #powerbiHow to Check Formulas with Value Preview Tooltips - Debugging formulas got easier! #shorts #excelLeila Gharani2023-09-04 | Join 400,000+ professionals in our courses: xelplus.com/courses
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).
π 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!
#ExcelCopy Text From Videos or Images - Power Toys utility #shortsLeila Gharani2023-08-27 | Join 400,000+ professionals in our courses: xelplus.com/courses
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.
π 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!
π What You'll Learn: βͺοΈ Entering Python Mode in Excel: Master the basics of switching to Python mode in your Excel environment. βͺοΈ Data Frame Creation: Understand how to create and manipulate Data Frames from Excel data, providing a robust structure for analysis. βͺοΈ Custom Python Formulas: Explore the power of custom Python formulas in Excel, expanding your analytical capabilities beyond traditional Excel functions. βͺοΈ Advanced Charting: Dive into creating dynamic charts within Excel cells using Python, offering enhanced data visualization options.
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.
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
π 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!
In this video we'll cover my favorite Microsoft Windows keyboard shortcuts that will save you time and increase productivity. These essential shortcuts will make it much faster and more efficient to navigate and do your tasks on a Windows PC. I also share some cool shortcuts you can use in your internet browser.
βͺοΈ Windows + D (Show Desktop): Function: Instantly view the desktop or return to your active window. Use Case: Handy for quickly clearing the screen or accessing desktop files.
βͺοΈ Windows + V (Clipboard History): Feature: Access a history of your copied items, not just the most recent. Benefit: Paste previously copied texts or images from an extended clipboard history.
βͺοΈ Windows + Period (Emoji Picker): Function: Easily insert emojis into your text. How-to: Use arrow keys for navigation or search for specific emojis.
βͺοΈ Windows + Plus (Magnifier): Utility: Zoom in on specific screen areas for better visibility. Customization: Adjust zoom levels and increments to suit your preference.
βͺοΈ Ctrl + K (Search in Browser): Shortcut: Jump directly to the browser's search bar. Efficiency: Saves time by avoiding the use of a mouse for searching.
βͺοΈ Ctrl + Shift + T (Reopen Tabs in Browser): Functionality: Quickly reopen accidentally closed browser tabs. Convenience: Tabs reopen in the same order they were closed.
βͺοΈ Windows + Tab (Task View): Feature: View all open apps and virtual desktops in an organized manner. Use Case: Efficiently switch between apps and manage virtual desktops.
βͺοΈ Windows + L (Lock Screen): Security: Secure your workstation when stepping away. Practicality: Prevent unauthorized access while keeping apps running.
βͺοΈ Windows + X, followed by U (Shutdown): Function: Quickly initiate the shutdown process. Tip: For a clean system start, disable Fast Startup in Power Options.
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
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 #productivitytipsHow to Use TOCOL | TOROW Function in Excel #shortsLeila Gharani2023-08-06 | Join 300,000+ professionals in our courses: xelplus.com/courses
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.
π 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 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!
π 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!
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.
π Highlights of the Video: - Discover Excel's right-click search feature for effortless command access. - Explore the new Navigation pane, your key to managing complex spreadsheets. - Learn about Excel's latest keyboard shortcuts, including one for Power Query and quick value pasting. - Get introduced to the Automate tab for creating and running Office Scripts. - See the Value Preview tooltip in action, simplifying formula debugging. - Find out how to use Dynamic Arrays as a source in Power Query and in charts.
π‘ Takeaways: - Leverage new features to simplify and enhance your Excel projects. - Discover innovative ways to manage and analyze data. - Stay current with the evolving landscape of Excel functionalities.
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
π¬ 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
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!
#ExcelHow to Split Cells to Rows and Columns with TEXTSPLIT in Excel #shortsLeila Gharani2023-07-23 | Join 300,000+ professionals in our courses: xelplus.com/courses
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.
π 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!
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.
What You'll Explore: βͺοΈ How to Download and Use Sysinternals Suite βͺοΈ Deep Dive into Key Utilities: ZoomIt, Process Monitor, Autoruns, Process Explorer βͺοΈ Techniques for Optimizing Your Windows Experience
Key Highlights: βͺοΈ ZoomIt: Magnify, Annotate, Record Screen Sessions βͺοΈ Process Monitor (ProcMon): Real-Time System Event Tracking βͺοΈ Autoruns: Identify and Manage Auto-Start Software βͺοΈ Process Explorer: Advanced Task Manager Capabilities
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
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 #windowsCreate Pivot Tables Like NEVER Seen Before! (include images and data types)Leila Gharani2023-07-06 | Join 400,000+ professionals in our courses here π link.xelplus.com/yt-d-all-courses
Discover how to add images and use data types in Excel PivotTables in this tutorial. Perfect for visually enhancing your Excel reports, this guide is a must-watch for anyone looking to elevate their data presentation skills. Here's what you'll learn:
πΌοΈ Adding Images to PivotTables βͺοΈ Learn how to insert images directly into Excel cells using the new 'Place in Cell' feature. βͺοΈ See how images can be included in PivotTables, with the ability to adjust their size for better visualization.
π Incorporating Data Types in PivotTables βͺοΈ Understand how to convert data to geographical data types, offering rich information about countries right in Excel. βͺοΈ Discover how to add flags and other country-specific details to your PivotTables for a more informative report.
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.
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
π 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!
#ExcelChoose Certain Columns as Output in Excel | CHOOSECOLS & FILTER ComboLeila Gharani2023-06-25 | Join 300,000+ professionals in our courses: xelplus.com/courses
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.
π 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!
#ExcelHow to Use Excels NEW Lookup of Images π Professional Dashboards Just Got Easy β Bonus RevealLeila Gharani2023-06-22 | Join 400,000+ professionals in our courses here π link.xelplus.com/yt-d-all-courses
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.
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
π¬ 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
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!