Advanced Excel Tutorial - Advanced Functions - VLOOKUP, IF, Forecasting, Statistical
Master advanced Excel functions like VLOOKUP, IF, and forecasting. Learn to manipulate dates, use financial formulas, and apply statistical analysis for data-driven decision making.
Excel 2019 Power User Tutorial
Advanced Excel techniques for data analysis, including VLOOKUP troubleshooting, INDEX MATCH, PivotTables, array formulas, conditional formatting, charts, and macros. Ideal for power users seeking efficient problem-solving methods.
Awesome Excel Tips and Tricks for 2023
Discover 30 essential Excel tips and tricks to boost productivity, from basic formatting to advanced functions, covering a wide range of features for beginners and intermediate users.
Visualizing Data and Building Dashboards in Excel & Power BI
Comprehensive guide to data visualization and dashboard creation in Excel and Power BI, covering various chart types, PivotTables, Power Query, and advanced techniques for effective data presentation.
Excel Array Formulas & Functions - 50 Examples of How to Become an Array Expert
Master Excel array formulas with 50 practical examples, covering fundamental concepts, advanced functions, and real-world applications for data analysis and reporting.
All Important Excel Lookup Formulas - Excel Worksheet, Power Query & DAX – 28 Examples
Comprehensive guide to Excel lookup formulas, covering XLOOKUP, FILTER, XMATCH, INDEX, and more. Includes examples in Excel, Power Query, and DAX for exact and approximate matches.
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.
Automating Purchase Requisitions in SAP S/4HANA with SAP Process Automation
Streamline procurement processes with SAP tools. Learn to analyze, automate, and optimize purchase requisition creation using SAP Signavio Process Insights and SAP Process Automation in S/4HANA.
How to Transform Excel Data into a Striking Visual Report with Microsoft Power BI
Transform Excel data into interactive visual reports using Microsoft Power BI. Learn importing, data manipulation, DAX expressions, chart creation, and report customization in this beginner-friendly tutorial.
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 Beginner Tutorial - Part 1 of 3
Comprehensive introduction to Excel 2021 basics, covering interface, calculations, functions, formatting, and essential features for efficient spreadsheet management and data analysis.
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.
Intermediate Microsoft Excel Tutorial - How to Use Power Query
Learn Power Query in Excel: Import, transform, and consolidate data efficiently. Master data cleaning, column manipulation, merging tables, and formula creation for streamlined data management.
Automate Excel With Python - Python Excel Tutorial
Learn to automate Excel using Python and OpenPyXL. Master workbook creation, cell manipulation, and data styling for efficient spreadsheet management and analysis.
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.