Work Smart!
Work Smart!
Master spreadsheet management and analysis with our comprehensive Excel tutorials. From basic functions to advanced formulas, we’ve got you covered.
This video shows how to reference cells in Excel formulas using absolute, relative and mixed referencing. In normal language, we say how to lock cells using ($) dollar sign in a formula.
Excel Cell Reference: Absolute vs Relative vs Mixed Read More »
Want to easily convert PDF to Excel and Excel to PDF without losing formatting? In this video, we’ll show you how to use free tools, Power Query, Adobe online converters, and more!
5 Ways to Convert PDF to Excel (FREE & PAID) | Convert Excel to PDF| Work Smart Hub Read More »
Curious about the difference between XLOOKUP and VLOOKUP? In this short video, we break down why XLOOKUP is superior and how to use it effectively.
XLOOKUP: The Ultimate Tool for Data Analysis Read More »
Learn how to create a dynamic calendar in Excel for 2021, 2022, 2023, 2024, 2025, and beyond, using a single formula without any VBA coding. Including Task Planner and free Excel Template.
Create a Dynamic Calendar in Excel for Unlimited Years with a Single Formula Read More »
How to use VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP functions. Know which function is best used to lookup and retrieve data. We’ll also show you how to use multiple criteria in XLOOKUP or any lookup function.
Which Lookup Function is Best? Read More »
In this comprehensive guide, we delve into the powerhouse Excel functions: IF, IFS, SWITCH, and XLOOKUP. Discover which formula reigns supreme for various scenarios through practical examples.
SWITCH vs. XLOOKUP vs. IFS vs. IF Read More »
Say goodbye to manual data entry woes! Learn how to effortlessly copy tables from websites into Excel with Power Query. No more messy formatting or tedious cleaning – just seamless data import and transformation.
Excel Web Scraping Read More »
Learn how to Merge different Excel files into one using POWER QUERY. Say goodbye to manual data consolidation and hello to efficiency!
Combine Multiple Excel Files into One using Power Query Read More »
In this tutorial, we explore a smarter way to summarize data using Excel’s Power Query. Say goodbye to manual data cleaning and transforming – automate your process with ease! 💼📊
Automate the Boring Stuff with Power Query Read More »
In this detailed tutorial, we delve into creating an immersive financial dashboard. Navigable pages showcase income, location, and sales rep data through dynamic charts and summaries. Elevate your Excel game with us!
Learn Excel Financial Dashboard Read More »