ITAAI - Accounting - Analytics - Excel - Power BI

Lecture 12: Recording money received against invoice in Xero

Lecture 11: Recording Invoice and Income in Xero

Lecture 10: Reconciling Manual Journal (Journal Entries) in Xero

Lecture 9: Reconciling Petty Cash in Xero

Lecture 8: Uploading bank statement and Bank Reconciliation in Xero

Lecture 7: Recording Spend Money in Xero

Lecture 6: Recording Transfer Money between banks in Xero

Lecture 5: Recording Money Received in Xero

Lecture 4: Getting started with Xero, adding bank accounts

Lecture 3: Getting started with Xero, adding new expense categories

Lecture 2: Getting started with Xero. Adding new income categories

Lecture 1: Getting started with Xero

Power BI Matrix Column Sorting

Income Statement in Excel (aka Profit and Loss Statement)

Lecture 6: Calculating Cost of Sales. Course: Financial Modeling in Excel

SQL for Financial Analysis and Financial Reporting - Part 3: Creating database and uploading data

Excel Inventory Template with FIFO method of Inventory Valuation & Automated Calculations

Lecture 2: Importing data to Power BI

VLOOKUP & XLOOKUP in Power BI - RELATED & LOOKUP VALUE

Split data in an Excel column to two columns

Custom sorting in

Progress bar and Dashboard card on

Switch Report Currency on Slicer Click

Copy paste cells as absolute reference in

Extracting data substring - Using LEFT, MID, and RIGHT functions, Flash fill, and Text to Columns

Writing

Present Negative Numbers without Negative Sign in Power BI Reports

Lecture 1: Understanding scenario, assumptions and information. Course: Financial Modeling in Excel

Online Checklist in Google Sheets - Checkbox with automatic Count

Writing