- 48
- 3 155
Wisdify
United States
Приєднався 27 лют 2017
Our mission is simple: We want to empower young professionals with the skills and knowledge to succeed professionally. We are not being taught the real-world hard and soft skills we need to advance in our careers. Wisdify's here to help fill that gap. We offer specialized online courses focused on today's most in-demand skills including data analytics, dashboards, financial modeling, Excel, and more! You can find our courses at wisdify.com.
Excel XLOOKUP Explained: What It Is and How to Use It
In this video, Franco from Wisdify breaks down what XLOOKUP is and how to use it effectively in Excel. XLOOKUP is a powerful function that simplifies working with data from different tables, worksheets, or even other workbooks. Learn how XLOOKUP addresses the limitations of VLOOKUP, including its inability to look to the left or work with non-adjacent columns. Follow along as Franco demonstrates real-world examples of using XLOOKUP to match employee data with project assignments, even when the data spans multiple locations.
Whether you're working within a single table, across separate tables, or with data outside of Excel tables, XLOOKUP proves to be a versatile and efficient solution. Find out how to avoid common pitfalls, such as unanchored ranges, and learn why XLOOKUP is a game changer for Excel users with Office 2021 and above. Watch now to master XLOOKUP and streamline your Excel workflows!
Timestamps:
00:00 - Introduction to XLOOKUP
00:35 - Example: Employee Projects Table
01:00 - The Problem with VLOOKUP
02:19 - Introduction to XLOOKUP
03:19 - Using XLOOKUP: Step-by-Step Guide
04:10 - Validating Results with XLOOKUP
04:57 - XLOOKUP Beyond a Single Table
05:19 - XLOOKUP with Non-Adjacent Columns
Whether you're working within a single table, across separate tables, or with data outside of Excel tables, XLOOKUP proves to be a versatile and efficient solution. Find out how to avoid common pitfalls, such as unanchored ranges, and learn why XLOOKUP is a game changer for Excel users with Office 2021 and above. Watch now to master XLOOKUP and streamline your Excel workflows!
Timestamps:
00:00 - Introduction to XLOOKUP
00:35 - Example: Employee Projects Table
01:00 - The Problem with VLOOKUP
02:19 - Introduction to XLOOKUP
03:19 - Using XLOOKUP: Step-by-Step Guide
04:10 - Validating Results with XLOOKUP
04:57 - XLOOKUP Beyond a Single Table
05:19 - XLOOKUP with Non-Adjacent Columns
Переглядів: 18
Відео
Add a Currency Converter in Excel in Minutes! (Easy Tutorial)
Переглядів 259 годин тому
Learn how to create a dynamic currency converter in Excel in just a few minutes! This tutorial is perfect for professionals working in banks, multinational corporations, or any environment where currency conversions are a regular task. Stop wasting time manually multiplying exchange rates and streamline your workflow with this powerful tool. In this step-by-step guide, you’ll learn how to: - Se...
How to Link Sheets in Excel: A Beginner's Guide
Переглядів 249 годин тому
Learn how to link sheets in Excel and create a dynamic workflow in just a few simple steps! This video is perfect for anyone working with spreadsheets that need data from multiple sheets or tabs. Avoid the hassle of copy-pasting values and discover how to reference cells across different sheets while keeping your data dynamic and up-to-date. Whether you're calculating revenue, managing assumpti...
How to Password-Protect Your Excel Spreadsheets: Step-by-Step Guide
Переглядів 99 годин тому
Learn how to password protect your Excel spreadsheets step by step in this easy-to-follow tutorial. Whether you’re working in a collaborative environment or simply want to secure sensitive data, this guide will show you how to make your Excel files foolproof. We’ll cover three essential techniques: allowing edits to specific ranges, protecting individual sheets, and securing the entire workbook...
Why Using Excel Macros Could Expose You to Cyber Threats
Переглядів 22День тому
Are Excel macros putting your data at risk? Learn how to use them safely. While Excel macros are powerful tools for automating tasks and improving efficiency, they can also pose serious cybersecurity risks if misused. In this video, we’ll explore how malicious macros can expose your files and networks to threats like ransomware and phishing attacks, and more importantly, how to protect yourself...
How to Quickly Clear Numeric Input from Excel Spreadsheets
Переглядів 35День тому
Resetting large spreadsheets can be time-consuming, especially when working with dynamic models or recurring reports. In this video, I’ll show you a simple and efficient way to isolate and clear numbers using Excel’s “Go To Special” feature. Whether you’re dealing with a few tables or hundreds of rows, this trick will save you valuable time and effort. If this tip helped streamline your workflo...
Maximize Screen Space in Excel Tips You Didn't Know You Needed
Переглядів 30День тому
Struggling with a cluttered Excel workspace? In this video, I’ll show you how to create a cleaner, more spacious view to tackle large data sets, build dashboards, and stay focused on your tasks. From hiding the formula bar and ribbon to leveraging full-screen mode and advanced display settings, you’ll learn actionable tips to make the most of your screen real estate. If these tips helped, don’t...
How to Hide and Unhide Multiple Sheets in Excel Without Macros
Переглядів 9День тому
If you’re working on a polished report and need to simplify what your clients or colleagues see, this quick Excel trick will save you time. Instead of hiding sheets one by one, I’ll show you how to group sheets together for fast and easy hiding and unhiding. No macros or complex formulas required-just a simple method anyone can use, whether you’re an Excel beginner or a pro. If this video helpe...
Top 5 Excel Formulas Every Accountant Should Know
Переглядів 8914 днів тому
In this video, discover the top 5 Excel formulas every accountant and data analyst must know to save time, eliminate errors, and supercharge productivity. From mastering arithmetic functions like SUM, AVERAGE, MIN, and MAX to diving into lookup techniques using VLOOKUP, HLOOKUP, and advanced methods like XLOOKUP and INDEX MATCH, we cover essential skills to transform your spreadsheets into powe...
Data Analysis in Excel: Commonly Used Functions Accountants Should Master
Переглядів 2714 днів тому
Timestamps 00:00 Introduction: Essential Excel Functions for Accountants 00:37 Sorting and Filtering: Organize Data Easily 02:00 Conditional Formatting: Highlight Key Insights 05:02 Using Tables: Add Structure to Your Data 07:03 Pivot Tables: Summarize Data in Seconds 10:24 Charts and Graphs: Visualize Your Insights 11:44 Conclusion: Mastering Excel for Impact
5 Most Powerful Data Analysis Functions in Excel For Accounting & Finance
Переглядів 24114 днів тому
Discover the 5 most powerful Excel tools that every accounting and finance professional must master! In this video, Franco from Wisdify breaks down how to use these game-changing functions to streamline your workflows, uncover insights, and make smarter, data-driven decisions. Perfect for Excel beginners and pros alike, this guide will transform the way you work with data. 00:00 Introduction: 5...
VLOOKUP vs HLOOKUP What's The Difference
Переглядів 2014 днів тому
Learn the key differences between VLOOKUP and HLOOKUP in Excel and when to use each function. In this video, we break down how these powerful lookup tools work, their specific use cases, and how to apply them effectively to manage and analyze data. Whether you're retrieving data from columns with VLOOKUP or rows with HLOOKUP, understanding these functions can save you time and help you avoid co...
Top 5 Skills CPAs Need for Corporate Finance Success
Переглядів 2821 день тому
Learn the top 5 skills CPAs need to transition into corporate finance success! From mastering financial modeling and advanced Excel to strategic thinking, data visualization, and effective communication, this video breaks down everything you need to become a corporate finance pro. Follow Bob’s journey and get actionable insights to level up your career! Timestamps 00:00 - Intro 00:30 - CPA vs. ...
Understanding Weighted Average Cost of Capital WACC for M&A
Переглядів 6121 день тому
In this video, you'll discover how to understand and calculate the Weighted Average Cost of Capital (WACC) and why it’s so vital in mergers and acquisitions. We break down WACC into simple concepts, exploring how assets, liabilities, debt, and equity play a role. With practical examples, we'll show you how to determine the cost of capital, assess project viability, and use WACC for decision-mak...
From Public to Industry Accounting: Career Path, Salary & Life
Переглядів 16Місяць тому
Deciding between public accounting and industry? In this video, we compare the career paths, work-life balance, and salary potential in each field. Whether you’re a CPA in public accounting considering a switch, or a recent graduate choosing your path, we’ll help you make an informed decision. Hear insights on the benefits and challenges of each path, plus tips for CPAs looking to make a change...
Is Corporate Finance Better Than Public Accounting? Career Insights for CPAs
Переглядів 23Місяць тому
Is Corporate Finance Better Than Public Accounting? Career Insights for CPAs
Excel Data Validation Best Practices for Accounting & Finance
Переглядів 110Місяць тому
Excel Data Validation Best Practices for Accounting & Finance
XLOOKUP vs VLOOKUP: Which One Should You Use?
Переглядів 146Місяць тому
XLOOKUP vs VLOOKUP: Which One Should You Use?
Pivot Tables vs VLOOKUP: When to Use Each in Excel
Переглядів 20Місяць тому
Pivot Tables vs VLOOKUP: When to Use Each in Excel
How to Create Custom Error and Input Messages in Excel
Переглядів 34Місяць тому
How to Create Custom Error and Input Messages in Excel
Master Absolute & Relative References in Excel! (video)
Переглядів 26Місяць тому
Master Absolute & Relative References in Excel! (video)
7 Ways Accountants Can Use Excel Macros To Save Time
Переглядів 765Місяць тому
7 Ways Accountants Can Use Excel Macros To Save Time
Public Accounting to Industry: Key Skills A CPA Should Develop
Переглядів 21Місяць тому
Public Accounting to Industry: Key Skills A CPA Should Develop
How To Unhide All Rows & Columns In Excel (Quickly)
Переглядів 992 місяці тому
How To Unhide All Rows & Columns In Excel (Quickly)
How To Hide Rows With Certain Data in Excel
Переглядів 662 місяці тому
How To Hide Rows With Certain Data in Excel
How To Remove Leading Spaces In Excel
Переглядів 682 місяці тому
How To Remove Leading Spaces In Excel
Financial Modeling Projecting Revenue
Переглядів 489 місяців тому
Financial Modeling Projecting Revenue
Nobody with intermediate Excel skills and higher uses VLOOKUP and HLOOKUP, because of XLOOKUP those formulas are obsolete. Your video is years past it's useby date.
Thank you so much for this amazing video! I need some advice: My OKX wallet holds some USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). Could you explain how to move them to Binance?
Tips are great but without a downloadable source of the macro code your video is almost useless as it means I have to develop the code. But perhaps at the time of 1:30 I have not yet watched your entire video. I did however look in the below descriptions and see nothing about a dowloadable source. Please provide the source code.
I really appreciate your efforts! Just a quick off-topic question: My OKX wallet holds some USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). How should I go about transferring them to Binance?
You're doing a fantastic job! I need some advice: I have a SafePal wallet with USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). How should I go about transferring them to Binance?
Thanks for sharing such valuable information! Could you help me with something unrelated: I have a SafePal wallet with USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). How should I go about transferring them to Binance?
💕 *PromoSM*
You discussed everything clearly!
Thanks for the comment. Glad you liked it!