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.
Excel for Accountants - Formulas, Functions & Formatting to Build Account Templates
Master Excel formulas, functions, and formatting to create powerful accounting templates. Learn essential skills for efficient data management and financial analysis.
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 - Date Math, Invoices, Cash Discounts on Invoices, Nested IF Functions
Master Excel date functions, invoice elements, and cash discounts. Learn to perform date math, use nested IF functions, and understand various discount types for efficient business calculations.
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 - IF Function, IS Functions & Building a Check Register and Other IF Tricks
Learn to create a check register using Excel's IF and IS functions, with practical applications of conditional formatting, data validation, and advanced formula techniques.
Excel & Business Math - Bank Reconciliation Made Easy
Learn bank reconciliation concepts, Excel techniques for side-by-side worksheets, and conditional formatting. Master check components, endorsements, and bank services while practicing reconciliation examples.
Excel & Business Math - Important Formulas for Increase Decrease Problems
Learn essential formulas for solving increase and decrease problems in Excel, with practical examples from finance, real estate, and business to enhance your data analysis skills.
Excel & Business Math - Percent Formulas for Part, Rate & Base
Master percent formulas for Part, Rate, and Base with 8 practical examples. Learn a memorization trick and apply these universal calculations to transform your business math skills.
Excel & Business Math - Percents & Percentage Number Formats Including Fractional Percents
Master percentage calculations and Excel formatting techniques, including fractional percentages. Learn to convert, recognize, and apply percentages in business contexts with practical examples.
Excel & Business Math - Fun With Adding & Subtracting Fractions & Least Common Denominator
Learn to add and subtract fractions efficiently using the "LCD Times One Method" with practical examples on paper and in Excel. Enhance your math skills through engaging exercises and clear explanations.
Excel & Business Math - Reducing Fractions, Prime Factors and Understanding & Calculating Ratios
Master fraction reduction, prime factors, and ratio calculations in Excel and by hand. Learn practical techniques for simplifying fractions and understanding the meaning behind ratios.
Excel & Business Math - Division, Fractions, Decimals, Percentages - Number Formatting & Formulas
Master division, fractions, decimals, and percentages in Excel. Learn number formatting, formulas, and practical applications for business math, with hands-on examples and formatting tips.
Excel & Business Math - Five Steps to Solve Math Word Problems in Excel
Master Excel's five-step approach to solve math word problems efficiently. Learn to translate English to math symbols, tackle retail calculations, and handle complex unit conversions.