How to use MAXIFS Function
The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria
How to use VLOOKUP in Excel
Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number,…
How to Convert Numbers to Words in Excel
Excel doesn’t have a default function that displays numbers as English words in a worksheet, but you can add this capability by pasting the following NumberstoWords function code into a VBA (Visual Basic for Applications) module. This function lets you convert dollar and cent amounts to words with a formula, so 22.50 would read as Twenty-Two Dollars and Fifty Cents. This can be very useful if you’re using Excel as a template to print checks.
Data Analysis Expressions (DAX) Reference Guide
Data Analysis Expressions (DAX) is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel. DAX formulas include functions, operators, and values to perform advanced calculations and queries on data in related tables and columns in tabular data models.
Macros and VBA Excel Training
This course is designed to be hands-on. You will learn skills that you can apply to your own work. Bring your own projects, files and questions to the training, or use our free support anytime after training.
Top 10 Types of Financial Models
There are many different types of financial models. In this guide, we will outline the top 10 most common models used in corporate finance by financial modeling professionals.
Top 10 Excel Functions for Finance
Top 10 Microsoft Excel finance functions every every financial modeling professional should master.
Download Financial Ratios Template
Download Financial Ratios Calculation Template
Free Online Procurement Courses
Free Certificate in Procurement and Logistics for Humanitarian Operations In partnership with Mercy Corps, DisasterReady developed a no-cost certificate program comprised of online courses, interactive scenarios, and a test covering best…
Quotation and Invoice Excel Template
Download this free Invoice & Quote template, add your company name, address and email. Works with any currency – but is customized to USD and Kenya Shilling.