Logical Tests - Excel Formulas, Conditional Formatting, PivotTables, Power Query, and More
Master Excel's logical functions, formulas, and advanced features. Learn to create powerful data analysis tools using PivotTables, conditional formatting, and Power Query for efficient data management.
Data Analysis in Excel - Important Excel Skills for Data Analysts
Master essential Excel skills for data analysis, including cleaning functions, pivot tables, and data visualization techniques to enhance your analytical capabilities.
Excel 2021 Pivot Tables Tutorial
Master Excel Pivot Tables to efficiently analyze large datasets, create insightful reports, and design powerful charts. Learn data organization, custom sorting, and advanced Power Pivot features.
Excel 2021 XLOOKUP Tutorial
Discover XLOOKUP, Excel's powerful new lookup function. Learn its advantages over VLOOKUP and INDEX/MATCH, and master techniques for faster, more efficient data retrieval and analysis.
Excel 2021 Power User Tutorial
Master advanced Excel techniques for efficient data analysis, including XLOOKUP, pivot tables, array functions, and macros. Enhance problem-solving skills and streamline complex tasks for power users.
Excel 2021 - Intro to Data Analysis Tutorial
Learn essential Excel data analysis techniques: tables, conditional formatting, functions, charts, and pivot tables for effective data insights and visualization.
Excel 2021 Advanced Tutorial - Part 3 of 3
Master advanced Excel 2021 features: nested functions, database operations, XLOOKUP, UNIQUE, SORT, FILTER, LET, data consolidation, and an introduction to macros for enhanced productivity.
Excel 2021 Intermediate Tutorial - Part 2 of 3
Enhance data analysis skills with advanced Excel features: tables, pivot tables, data validation, conditional formatting, and more. Learn to visualize and protect your data effectively.
Intermediate Microsoft Excel Tutorial - How to Use Power Pivot in Excel
Learn to use Power Pivot in Excel for advanced data analysis, creating relationships between tables, performing calculations, and building insightful reports with Pivot Tables, KPIs, and Pivot Charts.
Excel VBA Expert Tutorial
Master Excel VBA: Automate tasks, create custom functions, and build advanced tools. Learn foundational concepts and practical applications for enhanced productivity.
Excel VBA Advanced Tutorial
Comprehensive guide to advanced Excel VBA concepts, covering loops, variables, and complex functions. Ideal for business analysts and data scientists seeking to automate processes and expand Excel capabilities.
Excel Power User Advanced Tutorial
Advanced Excel techniques for power users: dynamic ranges, pivot table enhancements, web data import, and VBA macros. Develop skills to solve complex problems efficiently and push Excel's capabilities to new limits.
Excel Power User Beginner Tutorial
Master advanced Excel functions like VLOOKUP, INDEX-MATCH, and OFFSET. Learn data mining, dynamic ranges, and conditional formatting to solve complex problems efficiently and become a true Excel power user.
Excel 2016 Advanced Tutorial
Master advanced Excel techniques including named ranges, complex functions, data consolidation, solver tools, and macros to enhance your data analysis and productivity skills.
Excel 2016 Intermediate Tutorial
Comprehensive intermediate Excel tutorial covering advanced data manipulation, visualization, and analysis techniques. Learn to create pivot tables, charts, and use powerful features for efficient data management.
XLOOKUP Excel Tutorial
Master Excel's powerful XLOOKUP function for faster, more efficient data lookup. Learn its advantages over VLOOKUP and Index/Match, and explore advanced features like approximate matching and two-way searches.
Excel 2019 Expert Tutorial
Comprehensive tutorial covering advanced Excel features including named ranges, complex functions, data analysis tools, and macros. Ideal for users seeking to enhance productivity and data manipulation skills.
Excel 2019 Advanced Tutorial
Master advanced Excel 2019 features: data management, charts, pivot tables, and automation. Enhance efficiency in organizing, analyzing, and presenting complex data for professional spreadsheet mastery.
Excel 2019 Beginner Tutorial
Comprehensive tutorial covering Excel 2019 basics, from interface navigation to formulas, functions, data organization, and time-saving features for beginners and everyday users seeking efficiency.
Word Expert Tutorial
Comprehensive tutorial covering advanced Microsoft Word features, including forms, tracking changes, citations, macros, and PDF editing. Suitable for beginners and experienced users seeking to enhance productivity.
Power BI Advanced Tutorial
Master advanced Power BI techniques for data analysis and visualization. Learn to build queries, create relationships, use DAX functions, design interactive dashboards, and publish reports online.