What is Excel consolidate? The consolidate function in Excel allows an analyst to combine information from multiple workbooks into one place. The Excel consolidate function lets you select data from its various locations and creates a table to summarize the information for you. Before you go on to learn more about Excel consolidation, you may…
What is a Sales Tax Decalculator? A sales tax decalculator will tell you the pre-tax price of a good or service when the total price and tax rate are known. You can download our free Excel template to determine the pre-tax price. How the Sales Tax Decalculator Works The Excel sales tax decalculator works…
How to countif multiple criteria? The Excel formula to countif multiple criteria is =countifs(). The “s” on the end makes it plural and therefore implies that there are multiple criteria (2 or more). In the examples and illustrations below in this tutorial will show you exactly how to use COUNTIFS in Excel. How to use…
Bank Mixed Statement Ratio Calculator The Bank Mixed Statement Ratio Calculator can be used to determine a bank’s profitability and financial strength using items found on an income statement and balance sheet. This template includes the following ratios: Return on Assets (ROA) Ratio Return on Equity (ROE) Ratio Provision for Credit Losses (PCL) Ratio Net…
Bank Income Statement Ratio Calculator The Bank Income Statement Ratio Calculator can determine a bank’s profitability, efficiency, and growth through information found on an income statement. Using inputs such as operating expenses, net interest expenses, and net income, the calculator will produce ratios that are important for the analysis of a bank’s income statement. This…
Free xl tutorial If you’re looking for a free crash course to learn all about Excel, then our free xl tutorial course is the best option for you. We’ve condensed a lot of information and lessons into a concise, easy-to-follow course with all the most important xl functions and formulas. Please enroll in our free…
