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…
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…
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…
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…
How to Search in Excel Find and Replace in Excel allows you to quickly search all cells and formulas in a spreadsheet for all instances that match your search criteria. This guide will cover how to search in Excel and use find and replace in Excel. Examples of what you might use the Excel Find function to search…
How to Insert the Current Date and Time in Excel For anyone working as a financial analyst, it can be useful to insert the current time and date into an Excel spreadsheet. This guide will break down how the Excel current date and time function works and outline situations where it will be helpful in…
What are #REF Excel Errors? An #REF error (the “ref” stands for reference) is the message Excel displays when a formula references a cell that no longer exists, usually caused by deleting cells that a formula is referring to. Every good financial analyst knows how to find and fix #REF Excel errors, which we will…
