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.
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.
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.
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 - PivotTable Power - Amazing PivotTable Reporting Tricks - Slicers to Show Values As
Master advanced PivotTable techniques in Excel, including slicers, custom calculations, and data analysis. Learn to create powerful reports and gain insights from complex datasets.
Excel Basics - Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & More
Learn to leverage Excel's Table feature for dynamic ranges in VLOOKUP, PivotTables, charts, and more. Master efficient data management and analysis techniques for improved productivity.
Excel Basics - Excel VLOOKUP Function Made Easy
Master Excel's VLOOKUP function with 9 practical examples, from exact matches for product pricing to approximate matches for commission calculations, enhancing your data analysis skills.
Excel Basics - IF Function Made Easy and IS Functions Too - Epic Examples
Master Excel's IF and IS functions with 14 practical examples, enhancing your data analysis and decision-making skills for various business scenarios.
Excel Basics - PivotTables & SUMIFS Function to Create Summary Reports
Learn to create summary reports using PivotTables and SUMIFS function in Excel. Master data analysis techniques, proper data set creation, and efficient report formatting for regional, daily, and sales rep summaries.
Excel Lookup Formulas
Master Excel lookup formulas like VLOOKUP, INDEX MATCH, and XLOOKUP. Learn advanced techniques for complex data retrieval, multi-criteria searches, and cross-sheet lookups to enhance your spreadsheet skills.
Drop Down Lists in Excel - Dependent, Unique Lists and Other Data Validation Lists
Master dynamic drop-down lists in Excel for efficient data validation, including dependent lists, unique item extraction, and custom validation techniques. Enhance spreadsheet functionality and user experience.
Excel VBA & Macros Tutorials
Master Excel VBA and macros to automate tasks, manipulate data, and enhance spreadsheet functionality. Learn key concepts like objects, loops, and custom functions for efficient workflow.
Excel Intermediate Functions & Features
Master advanced Excel functions like IF, VLOOKUP, IFS, and custom formatting. Learn time-saving techniques, data manipulation, and presentation skills to enhance productivity and analysis capabilities.
Table Filter and Charts Add-on - Real Cases
Learn to leverage Table Filter and Charts add-on with various Confluence tools for enhanced data visualization and analysis.
Working with Table Filter for Confluence Add-On
Learn to manage various filter types, create pivot tables and dynamic charts, and export data using the Table Filter add-on for Confluence, enhancing data visualization and analysis.