ROUNDUP Excel
How to Use Excel ROUNDUP The Excel ROUNDUP function allows a user to round a number up in Excel, to a certain number of decimal points. For anyone who performs financial analysis in Excel it can frequently be important to round a number to a specific decimal place or to a whole number. In this session,…
VBA Methods
What is a VBA Method? A VBA method is a piece of code attached to a VBA object, variable, or data reference that tells Excel what action to perform in relation to that object. Copying, pasting, and selecting are just some examples of VBA methods that can be performed. (VBA stands for “Visual Basic for…
Data Validation in Excel
What is Data Validation in Excel? Data validation in Excel is an existing and accessible tool to ensure data integrity while building a financial model. Although it is only an easy extra step, data validation in Excel is an extremely useful tool to secure your model inputs and outputs. This article is intended to provide…
Excel Pivot Table Guide
What is a Pivot Table in Excel? A pivot table allows you to organize, sort, manage and analyze large data sets in a dynamic way. Pivot tables are one of Excel’s most powerful data analysis tools, used extensively by financial analysts around the world. In a pivot table, Excel essentially runs a database behind the…
Advanced Excel Formulas for Financial Analysts and Power Users
Learn about the ten essential advanced Excel formulas for financial analysts, including INDEX MATCH, IF combined with AND/OR, OFFSET with SUM or AVERAGE, CHOOSE, XNPV and XIRR, SUMIF and COUNTIF, PMT and IPMT, LEN and TRIM, CONCATENATE, and CELL functions. These advanced Excel formulas are crucial for performing complex data analysis, financial modeling, and enhancing…
Common Excel Confusions
Common Confusions in Excel When working on financial models within Excel, it is quite common to come across some of the following confusions. It may seem like Excel is bugging, but in reality, there are some easy fixes to common Excel confusions. Check out our FREE Excel crash course to avoid making these easy mistakes. Common…
Excel Shortcut Keys
Excel Shortcut Keys Excel shortcut keys come in handy to maneuver through Excel much faster and more efficiently. In fact, using shortcut keys is much quicker than using a mouse. What are Navigational Shortcut Keys? Navigational shortcut keys help the user move around within Excel. These shortcut keys allow the user to move across cells…
Excel Shortcuts Overview
Why Use Excel Shortcuts? An often-overlooked method of increasing productivity when working in an Excel model is to use Excel shortcuts, or shortcut keys. These shortcut keys perform major functions that, when used instead of clicking in the toolbar, dramatically increase efficiency and speed. Imagine simply pressing two or three keys on the keyboard as…
IF Statement Between Two Numbers
How to Combine IF with AND functions In Excel, you can combine IF with AND functions to return a value based on two different numbers. It can be very useful when performing financial modeling and when you are creating conditional situations. In this article, learn how to build an IF statement between two numbers so you…
