Skip to content
FAST TRACK TO POWER BI Course is NOW AVAILABLE. SIGN UP NOW.
Xelplus – Leila Gharani Logo
  • Tutorials
  • Online Courses
  • For Business
  • Resources
  • About Me
  • Log in
  • Tutorials
  • Online Courses
  • For Business
  • Resources
  • About Me
  • Log in

Learn Financial Analysis

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.

May 5th, 2022|Categories: Accounting|Tags: Balance Sheet, Cash Flow Statement, Efficiency, Financial Analysis, Income Statement, Leverage, Liquidity, P&L, Profitability|

Excel tips & tricks – stop doing these 7 things in Excel

Don't merge cells in Excel - Don't Copy Excel sheets without updating links - Don't hide rows and columns! There are better ways of doing these things. Find out 7 things you're doing wrong in Excel and how to do it correctly.

January 27th, 2022|Categories: Accounting, Charts, Dashboards, Features, Formulas, Uncategorized|

Forecasting in Excel Made Simple

Did you know you can easily create a forecast in Excel? In the example, I use data from The Home Depot and forecast the next two quarters. It's really easy, even if you need to take seasonality into consideration.

November 30th, 2021|Categories: Accounting, Charts|Tags: Forecast, Forecasting, Line Chart, Lower Confidence, Upper Confidence|

Top Excel Features for Accountants

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.

March 18th, 2021|Categories: Accounting|Tags: AutoFilter, ConditionalFormatting, data validation, Duplicates, Flash Fill, Formula Audit, Go To Special, Number Formatting, pivot table, PivotTable, Subtotal|

Excel Functions for Accounting

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)

February 25th, 2021|Categories: Accounting|Tags: Excel for Accountants, Excel for Accounting|

Financial Leverage explained

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.

January 5th, 2021|Categories: Accounting|Tags: Debt, Equity, Expenses, Financial Leverage, Interest, Investment, lemonade, lemonaid, lemonaide, Loan, Operating Expense, Profit, Return, Return on Investment, RoE|

Excel LAMBDA Function Explained

With the new Excel Lambda function you can create your own custom functions that you can reuse. The best thing about Excel Lambdas is you can create a function that loops through many cells. You can do this with ZERO coding!

December 17th, 2020|Categories: Accounting, Dashboards, Features, Formulas|Tags: BETA, Dynamic, Excel, LAMBDA, OFFSET, Recursion, Recursive, SUBSTITUTE|

Time Value of Money

Time Value of Money “A dollar today is worth more than a dollar tomorrow.” It’s a saying that is true for any business as well as your own personal finances.  It’s a simple principle that has a fancy name…Time Value of Money.

February 27th, 2020|Categories: Accounting, Formulas|Tags: Discount, Discount Rate, Inflation, Net Present Value, NPV, Opportunity COsts, Present Value, PV, Risk, Risk Factor, Time Value of Money|

Calculating Returns for a Rental Property

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.

February 13th, 2020|Categories: Accounting, Formulas|Tags: Accounting, Calculator, Cash Flow, Cash on Cash Return, Excel, Expenses, Return on Investment, Revenue, ROI|

Cash Flow Statement

The Cash Flow Statement The Cash Flow statement is one of the three main financial statements, but it is often overshadowed by its companion statements – the Income Statement and Balance Sheet. The Income Statement provides information on Revenue and Profit over

January 28th, 2020|Categories: Accounting|Tags: Adjustments, Capital, Cash Flow, Cash Flow Statement, Direct Method, Financing, Indirect method, Investing, Operations, Reconciliation|
12Next
Subscribe to my Newsletter | Copyright 2020 XelPlus.com | All Rights Reserved | Impressum | Privacy Policy
LinkedInYouTubeTwitter