Excel tips, tricks, functions, formulas and shortcuts

Excel Consolidate

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…

Continue reading

Sales Tax Decalculator

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…

Continue reading

Excel Convert Formula To Value

Convert Formulas to Values in Excel There are three shortcuts you can use to convert formulas to values in Excel. This article on “Excel Convert Formula To Value” gives a step by step breakdown of each. The first option, using Shift + F10 requires the fewest keystrokes; the second, Alt + E + S is…

Continue reading

Countif Multiple Criteria (Excel)

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…

Continue reading

Bank Mixed Statement Ratio Calculator

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…

Continue reading

Bank Income Statement Ratio Calculator

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…

Continue reading

Football Field Chart Template

What is a football field chart? A football field chart is used to summarize a range of values for a business, based on different valuation methods.  This guide includes a free Football Field Chart Template to download at the end of the page. The purpose of the chart is to show how much a buyer…

Continue reading

Free XL Tutorial

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…

Continue reading
0 search results for ‘