Conditional Formatting Basic to Advanced - 30 Examples
Comprehensive tutorial on Excel's conditional formatting, covering 30 advanced techniques for data visualization, analysis, and highlighting specific information in spreadsheets.
INDEX & MATCH Lookup Functions - Beginning to Advanced
Comprehensive tutorial on INDEX & MATCH functions in Excel, covering 18 advanced techniques from basic lookups to complex array formulas for data extraction and manipulation.
Excel Magic Trick - FREQUENCY Array Function
Comprehensive tutorial on Excel's FREQUENCY function, covering various applications from basic usage to advanced techniques for data analysis and unique item extraction.
Introduction to Power Query & Power Pivot Data Model in Excel 2016
Learn to clean data, create PivotTables, and use Power Query and Power Pivot in Excel 2016. Master data transformation, import large datasets, and build efficient data models for advanced analysis.
Hack Data Model, Date Table & DAX Measures Without Buying Power Pivot
Master advanced Excel techniques: build data models, create DAX measures, and use functions like CALCULATE and TOTALYTD. Learn to optimize PivotTables and implement variables for efficient data analysis.
Power BI for Accountants - Complete Introduction to Power BI Desktop to Build Reports & Dashboards
Learn to create dynamic sales reports and dashboards using Power BI Desktop. Master data import, cleaning, transformation, and visualization techniques for effective financial analysis and monitoring.
Excel for Accountants - Power Query & PivotTables to Import & Clean Data and Build Reports
Learn to import, clean, and analyze data using Power Query and PivotTables. Master techniques for efficient data management, creating insightful reports, and optimizing file size in Excel for accounting purposes.
Power Query Count & Extract Customer Names for 8 Sales Coupon Groups
Learn advanced Power Query techniques to analyze customer coupon usage across multiple stores, including counting and extracting customer names for various coupon groups.
Logical Formulas - Count & Extract Customer Names for 8 Sales Coupon Groups
Learn advanced Excel techniques for analyzing customer coupon usage across multiple stores, including logical formulas, array formulas, and functions like COUNTIFS, AND, OR, and INDEX.
Average, Moving Average at Different Granularity - DAX or Excel Formulas
Learn advanced Excel and DAX techniques for calculating averages and moving averages at different granularities, enhancing your data analysis skills for more accurate financial reporting.
RANKX DAX Function and More - Ranking Profit for Products within Manufacturer
Aprenda a usar a função RANKX DAX para classificar lucros de produtos por fabricante em PivotTables do Excel. Domine técnicas avançadas de análise de dados e fórmulas DAX.
Create Excel Invoices, Data Validation Drop-Down, VLOOKUP & IF Functions
Learn to create reusable Excel invoices using advanced functions like VLOOKUP, IF, and data validation. Master invoice formatting, calculations, and automated invoice numbering for efficient business operations.
Excel & Business Math - Trade Discounts, Series Discounts, Net Cost Equivalents & Wholesale Cost
Learn to calculate trade discounts and wholesale costs using Excel functions like VLOOKUP and IF. Master business terms and automate calculations for single and series discounts in retail and wholesale scenarios.
Excel and Business Math - VLOOKUP and MAX Functions for Percentage Method Federal Income Tax Deduction
Learn to calculate federal income tax withholdings using VLOOKUP and MAX functions in Excel, with practical examples for different marital statuses and pay periods.
Excel & Business Math - VLOOKUP Function for Incentive Pay: Commissions & Piecework
Master VLOOKUP for incentive pay calculations, including piecework and commissions. Learn to create lookup tables and apply VLOOKUP for various business scenarios with 15 practical examples.
Excel & Business Math - Excel Built-in Functions, Data Types and Keyboards are Fast
Learn essential Excel skills: data types, built-in functions, and keyboard shortcuts. Master efficient techniques for data analysis and calculations to enhance your productivity and accuracy in spreadsheet tasks.
Excel & Business Math - Excel's Golden Rule: Formula Inputs, What If Analysis and Excel Models
Learn Excel's Golden Rule for efficient formula solutions and models, with practical examples in building tables for student scores, monthly expenses, and payroll calculations.
Array Formula - Add Daily Rainfall 5 AM to 5 AM Next Day - Most Automatic
Learn advanced Excel array formulas to automate rainfall reporting with custom time periods. Master FREQUENCY, AGGREGATE, and SUMIFS functions for efficient data analysis and unique date extraction.
Introduction to Databases & Access
Comprehensive introduction to databases and Microsoft Access, covering key concepts, objects, data management, and comparison with Excel for effective data analysis and organization.
Excel Basics - Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set
Learn to use Power Query in Excel for data cleaning, transformation, and analysis. Master importing, combining, and refreshing data from various sources to create proper datasets and pivot tables.
Excel Basics - Excel Charts & Graphs to Visualize Quantitative Data
Learn to create effective Excel charts and graphs for data visualization, focusing on best practices and avoiding chart junk. Explore various chart types and their applications in data analysis.