Excel Tips

How to sum a column in Excel shortcut

Here is a guided step by step video with each shortcut being pressed. It shows how to type a SUM and select cells from the column automatically using shortcuts, then copy that SUM formula across the row to SUM every column.

Samuel Prevost

Oct 11, 2024

Summing a column, done without touching the mouse!

It only uses shortcuts, and no mouse clicks!

0:00

/0:29

Excel tips & tricks: Best Practices in Financial Models (with pictures)

Financial modeling can feel like a daunting skill to master, but here's the good news: you don't need to know everything to excel at it. The truth is, by following a few essential tips, you can achieve 80% of what you need with just 20% of

What is ratio analysis in financial modeling?

In the world of mergers and acquisitions (M&A), financial ratio analysis plays a crucial role in assessing a business's health, profitability, and potential for growth. As someone who's spent over six years in M&A and built more than 40 financial models, I’

How to use formatting shortcuts like a Pro?

If you're working with data in Excel, learning essential formatting shortcuts can dramatically boost your productivity. Not only will these shortcuts save you time, but they’ll also ensure your spreadsheets are polished, professional, and client-ready. In this article, we dive into 15 Excel formatting shortcuts that are

How to build a financial forecast in 4 steps? (Tesla Example)

This is a high-level process map for building accurate financial forecasts. If you’re aiming for (or starting in) roles in M&A, FP&A, or PE, understanding financial forecasting is a critical skill. What steps do you think are most critical in creating a robust forecast? This

Read more

Excel tips & tricks: Best Practices in Financial Models (with pictures)

What is ratio analysis in financial modeling?

How to use formatting shortcuts like a Pro?

How to build a financial forecast in 4 steps? (Tesla Example)