Everything you can do in Excel

Excel continues to be the #1 tool used for Finance & Accounting professionals…

and for good reason.

With Excel, there are pretty much no limits to what you can accomplish.

Click here to download the Excel template

Lucky for you, I’ve summarized everything that you can do in excel, and where you can find each resource.

Let’s do a walk through it all:

This is where most people start out when they open an Excel file… ​ here you can create a new file…open an existing file.. ​ access a template…or access key options.

My favorite tools here are: ​ • Set paste options - whether that be pasting values, formatting, or as a picture (Learn How to paste in Excel here) ​​ • Control cell aesthetics - whether that be fonts, colors, sizing, borders, and more ​ • Change cell format - whether that be as a number, currency, date, or more ​ • Formatting cells - whether that be conditional formatting, cell styles, insert, or deleting cells

this is where we get one of my favorite excel tools…

​tables & pivottables​

But there’s so much more that you can do in this section, such as…

• inserting shapes & illustrations

• inserting charts

• sparklines

and much more

Gonna print your document? This section has got you covered

I especially find this one useful when preparing pitch decks

Click Here to download the Excel template

oh man…so much to say on this one.

First… check out this article on every formula you need to know in excel.

Then, master this section by learning:

• Formula auditing → how you can avoid & debug errors (Check all the Excel errors)

• Watch window → monitor the value of a specific cell as you switch between tabs

and much more

BIG section…because it introduces my favorite tool…

​power query​

Something that you ABSOLUTELY need to learn.

Here you can also:

• Set data validation / drop downs

• Group / ungroup

And much more

favorite tools here are protecting a range from being edited, and utilizing notes / comments

favorite tools here are to hide grid lines, and duplicate a window on a 2nd monitor

favorite tools here are to add active x / form controls for easy buttons

That’s an introduction to about everything you can do in excel… ​

Click Here to download the Excel template

though there is so much more to share about each and every functionality!