Accounting & Finance Tutorials - Xelplus - Leila Gharani - Leila Gharani https://www.xelplus.com/tutorials/accounting-finance/ Bestselling Excel and Power BI Courses Fri, 08 Dec 2023 14:27:10 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Accounting & Finance Tutorials - Xelplus - Leila Gharani - Leila Gharani https://www.xelplus.com/tutorials/accounting-finance/ 32 32 Excel Dashboard to Track Budget and Actuals with Variances https://www.xelplus.com/excel-budget-actual-dashboard/ Fri, 08 Dec 2023 14:25:28 +0000 https://www.xelplus.com/?p=19902 Learn to build a budget vs actual dashboard in Excel. Master key formulas and chart customization for effective year-over-year variance analysis.

The post Excel Dashboard to Track Budget and Actuals with Variances appeared first on Xelplus - Leila Gharani.

]]> How to Learn Financial Analysis https://www.xelplus.com/learn-financial-analysis/ Thu, 05 May 2022 05:29:00 +0000 https://www.xelplus.com/?p=9348 The reason most people fail at understanding financial analysis is that they fail to understand the fundamental concepts. Concepts such as debits and credits, journal entries, trial balance and how these connect to the income statement, balance sheet and cash flow.

The post How to Learn Financial Analysis appeared first on Xelplus - Leila Gharani.

]]> Forecasting in Excel Made Simple https://www.xelplus.com/forecasting-in-excel-made-simple/ Tue, 30 Nov 2021 08:01:00 +0000 https://www.xelplus.com/?p=9724 Learn how to easily create a forecast in Excel - even if you have seasonality. It just takes one click and Excel can forecast the next months for you!

The post Forecasting in Excel Made Simple appeared first on Xelplus - Leila Gharani.

]]> Best Excel Features for Accountants https://www.xelplus.com/top-excel-features-for-accountants/ Thu, 18 Mar 2021 08:18:00 +0000 https://www.xelplus.com/?p=10203 Learn the 10 most important Excel features for accountants. This list is not just for those that work in accounting but also anyone who uses Excel for data analysis. You'll discover new Excel tips and tricks that will make your working life a lot easier.

The post Best Excel Features for Accountants appeared first on Xelplus - Leila Gharani.

]]> Best 10 Excel Functions for Accountants https://www.xelplus.com/excel-functions-for-accounting/ Thu, 25 Feb 2021 10:00:00 +0000 https://www.xelplus.com/?p=10260 Make sure you know these Excel functions if you work in Accounting, Finance or you are a Data Analyst. They'll make your work life a LOT easier and they work in all Excel versions (such as AGGREGATE, TRIM, ROUND & more)

The post Best 10 Excel Functions for Accountants appeared first on Xelplus - Leila Gharani.

]]> What is Financial Leverage? https://www.xelplus.com/financial-leverage-explained/ Tue, 05 Jan 2021 12:00:00 +0000 https://www.xelplus.com/?p=10378 In finance, leverage (or gearing) is about using debt (other people's money) rather than equity (your own money) for the purchase of an asset. This tutorial explains when this can be good for your business and when it can ruin your business.

The post What is Financial Leverage? appeared first on Xelplus - Leila Gharani.

]]> What is Time Value of Money and How Do You Calculate It? https://www.xelplus.com/time-value-of-money-excel-npv/ Thu, 27 Feb 2020 10:00:00 +0000 https://www.xelplus.com/?p=11449 Time Value of Money is an important concept for making good decisions when it come to money. The good news: We can easily calculate it in Excel with the NPV function.

The post What is Time Value of Money and How Do You Calculate It? appeared first on Xelplus - Leila Gharani.

]]> How to Calculate Returns on Rental Property in Excel https://www.xelplus.com/rental-property-roi-calculator-excel/ Thu, 13 Feb 2020 10:00:00 +0000 https://www.xelplus.com/?p=11477 Properly calculate returns on your rental property investment. This free Excel ROI calculator, makes it easy for you. In fact, you can use it to calculate the returns on any type of investment.

The post How to Calculate Returns on Rental Property in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Read and Properly Interpret the Cash Flow Statement https://www.xelplus.com/cash-flow-statement-explained/ Tue, 28 Jan 2020 10:00:00 +0000 https://www.xelplus.com/?p=11528 The cash flow statement shows how effective a business is in managing its cash. It can be tricky to understand. I've got you covered! Follow this explanation and you'll understand the basics of cash flow in no time.

The post How to Read and Properly Interpret the Cash Flow Statement appeared first on Xelplus - Leila Gharani.

]]> Cash Accounting versus Accrual Accounting Explained https://www.xelplus.com/cash-vs-accrual-accounting/ Tue, 21 Jan 2020 10:00:00 +0000 https://www.xelplus.com/?p=11563 There are 2 different accounting methods: Cash Accounting and Accrual Accounting. Check out this article which explains the difference with a story. This makes it really easy to understand the difference between cash basis and accrual method of accounting.

The post Cash Accounting versus Accrual Accounting Explained appeared first on Xelplus - Leila Gharani.

]]>