Archives: Resources

Error Bars in Excel

What are Error Bars in Excel? Error bars in Excel are graphical representations of data variability. They show the precision of a measurement. The bars usually represent standard deviation and standard error. They indicate how far from the determined value the true value is. Error bars on charts provide a more comprehensive view of the…

Continue reading

VBA If Else

VBA If Else statements Building a VBA If Else statement is quite similar to building a nested if formula inside Excel. The benefit of using VBA instead is that it’s much easier to follow, since nested IFs tend to complicate with multiple parenthesis enclosures. In a VBA if statement, each IF clause is separate from…

Continue reading

Dynamic Financial Analysis

Dynamic Financial Analysis This guide will teach you how to perform dynamic financial analysis in Excel using advanced formulas and functions. INDEX, MATCH, and INDEX MATCH MATCH Functions 1. The INDEX function works similarly to the VLOOKUP function by returning a value in a table based on the intersection of a row and column position…

Continue reading

Group in Excel

Guide on How to Group in Excel Grouping rows and columns in Excel is critical for building and maintaining a well-organized and well-structured financial model. Using the Excel group function is the best practice when it comes to staying organized, as you should never hide cells in Excel. This guide will show you how to…

Continue reading

Dynamic Dates, Sum, Average and Scenarios

Dynamic Dates, Sum, Average and Scenarios For financial analysts in investment banking, equity research, FP&A, and corporate development, it is advantageous to learn advanced Excel skills because it makes you stand out from your competitors. In this article, we will go through some of the best industry practices that will help you dramatically speed up…

Continue reading

Dashboard Creation in Excel

Creating a Dashboard in Excel A good financial analyst needs to be a master of dashboard creation in Excel.  It’s not always a skill that comes naturally to people, and practice, combined with good training, is the key to success.  In this free guide, we’ve outlined the most important tips and tricks for creating a…

Continue reading

Excel for Beginners

A “Dummies” Guide to Excel for Beginners Welcome to our free Excel for Beginners guide! In this guide, we will give you everything a beginner needs to know – what is Excel, why we use it, and what are the most important keyboard shortcuts, functions, and formulas.  If you’re new to MS Excel, then you’ve…

Continue reading

Formula vs Function

What is a Formula vs Function in Excel? A Formula is an equation designed by a user in Excel, while a Function is a predefined calculation in the spreadsheet application. This guide will walk you through Formula vs Function in Excel so you know exactly what the similarities and differences are. Excel enables users to…

Continue reading

Add Months to Date

How to Make Excel Add Months to Date In Excel, you can add a number of months to a date using the EDATE function.  This can be very useful when performing financial modeling and you are adjusting time periods.  This is a step by step guide on how to have Excel Add Months to Date. For…

Continue reading
0 search results for ‘