Канал: Excel Clinic

Meet Luca: The Bot Transforming Financial Statements!

Meet Luca: The Bot Transforming Financial Statements!

Lease Accounting Template (IFRS 16)

Lease Accounting Template (IFRS 16)

Free Handy Excel Tool for Accountants: Rounding

Free Handy Excel Tool for Accountants: Rounding

Financial Statement Preparation Accounting Bot | No more casting #quickbite

Financial Statement Preparation Accounting Bot | No more casting #quickbite

Financial Statement Preparation Accounting Bot | No more casting

Financial Statement Preparation Accounting Bot | No more casting

comprehensive guide on consolidation reporting packs!

comprehensive guide on consolidation reporting packs!

Transform Your Vendor Management Journey with Automation! Explore Our Latest Demo!

Transform Your Vendor Management Journey with Automation! Explore Our Latest Demo!

Invoicing using excel

Invoicing using excel

Excel Clinic | Fix laggy Excel workbook

Excel Clinic | Fix laggy Excel workbook

Excel Clinic | Fix laggy Excel workbook [5/5]

Excel Clinic | Fix laggy Excel workbook [5/5]

Excel Clinic | Fix laggy Excel workbook [4/5]

Excel Clinic | Fix laggy Excel workbook [4/5]

Excel Clinic | Fix laggy Excel workbook [3/5]

Excel Clinic | Fix laggy Excel workbook [3/5]

Excel Clinic | Fix laggy Excel workbook [1/5]

Excel Clinic | Fix laggy Excel workbook [1/5]

Excel Clinic | Fix laggy Excel workbook [2/5]

Excel Clinic | Fix laggy Excel workbook [2/5]

Contract register with reminder

Contract register with reminder

should i register for GST?

should i register for GST?

Identify Duplicates

Identify Duplicates

Turn-off GetPivotData

Turn-off GetPivotData

Top 5 productive functions for accountants

Top 5 productive functions for accountants

Filter data dynamically

Filter data dynamically

Excel Clinic | Automate Exchange Rate Table

Excel Clinic | Automate Exchange Rate Table

Explain the change: waterfall chart

Explain the change: waterfall chart

Excel Interview Questions

Excel Interview Questions

Bookkeeping using Excel

Bookkeeping using Excel

Excel Clinic | Build aging report using Power Query

Excel Clinic | Build aging report using Power Query

Excel Clinic | Cash flow statements [5/5]

Excel Clinic | Cash flow statements [5/5]

Excel Clinic | Cash flow statements [4/5]

Excel Clinic | Cash flow statements [4/5]

Excel Clinic | Cash flow statements [3/5]

Excel Clinic | Cash flow statements [3/5]

Excel Clinic | Cash flow statements [2/5]

Excel Clinic | Cash flow statements [2/5]

Excel Clinic | Cash flow statements [1/5]

Excel Clinic | Cash flow statements [1/5]

Excel Clinic | Cash flow statements

Excel Clinic | Cash flow statements

Create pivot table from multiple sheets (part 2/2)

Create pivot table from multiple sheets (part 2/2)

Create pivot table from multiple sheets (part1/2)

Create pivot table from multiple sheets (part1/2)

Compare 2 sheets in seconds

Compare 2 sheets in seconds

Excel Clinic | Two-dimensional VLOOKUP

Excel Clinic | Two-dimensional VLOOKUP

Two-dimensional VLOOKUP

Two-dimensional VLOOKUP

Excel Clinic | Number of working days

Excel Clinic | Number of working days

Excel Clinic | Number of working days

Excel Clinic | Number of working days

Excel Clinic | Leave accrual

Excel Clinic | Leave accrual

Leave accrual [Part 4/4]

Leave accrual [Part 4/4]

Leave accrual [Part 3/4]

Leave accrual [Part 3/4]

Leave accrual [Part 2/4]

Leave accrual [Part 2/4]

Leave accrual [Part 1/4]

Leave accrual [Part 1/4]

Excel Clinic | The AI in Excel - Flash Fill

Excel Clinic | The AI in Excel - Flash Fill

Excel Clinic | Remove blank rows in a data table

Excel Clinic | Remove blank rows in a data table

Excel Clinic | Consolidation in Minutes

Excel Clinic | Consolidation in Minutes

Visual filter-Slicer

Visual filter-Slicer

How to copy cells without hidden rows

How to copy cells without hidden rows

Excel Clinic | Lease accounting template

Excel Clinic | Lease accounting template

Lease accounting | Comprehensive lease accounting template

Lease accounting | Comprehensive lease accounting template

Lease accounting | Right-of-use asset schedule

Lease accounting | Right-of-use asset schedule

Lease accounting | Lease liability schedule

Lease accounting | Lease liability schedule

Lease accounting | Present value of lease payments

Lease accounting | Present value of lease payments

#shorts Discounting and Present Value-Part 5

#shorts Discounting and Present Value-Part 5

Discounting and Present Value- Part 4 Shortcut for PV

Discounting and Present Value- Part 4 Shortcut for PV

Discounting and Present Value- Part 3 Cash Flow Table

Discounting and Present Value- Part 3 Cash Flow Table

Discounting and Present Value Part 2- Simple Interest

Discounting and Present Value Part 2- Simple Interest

#shorts Discounting & Present Value Part 1- Compounding interest

#shorts Discounting & Present Value Part 1- Compounding interest

Excel Clinic | Discounting & Present Value

Excel Clinic | Discounting & Present Value

Excel Clinic | Rounding error -- the missing cents

Excel Clinic | Rounding error -- the missing cents

Why you should add additional blank row at the end of sum range?

Why you should add additional blank row at the end of sum range?

How to hide the zeros returned by XLOOKUP?

How to hide the zeros returned by XLOOKUP?

Where should you insert the helper columns?

Where should you insert the helper columns?

Why you should use a mapping table and not direct referencing?

Why you should use a mapping table and not direct referencing?

Excel Clinic | Automate financial reports

Excel Clinic | Automate financial reports

How to automate prepayment/amortization schedule (part 4/4)

How to automate prepayment/amortization schedule (part 4/4)

How to automate prepayment/amortization schedule (part 3/4)

How to automate prepayment/amortization schedule (part 3/4)

How to automate prepayment/amortization schedule (part 2/4)

How to automate prepayment/amortization schedule (part 2/4)

How to automate prepayment/amortization schedule (part1/4)

How to automate prepayment/amortization schedule (part1/4)

Excel Clinic | How to build a prepayment/amortization schedule?

Excel Clinic | How to build a prepayment/amortization schedule?

Excel Clinic | Every accountant must know

Excel Clinic | Every accountant must know

Excel Clinic | Multi-criteria VLOOKUP

Excel Clinic | Multi-criteria VLOOKUP

Excel Clinic | Why VLOOKUP fails?

Excel Clinic | Why VLOOKUP fails?

Excel Clinic | Combine multiple Excel files in seconds

Excel Clinic | Combine multiple Excel files in seconds