If you’ve been around here for a while, then you likely know that I LOVE spreadsheets. I took an Excel class as an elective in college (wow-nerd alert!) and it was possibly the single best class I could have taken to really set me apart from my peers in the accounting field. And, it made my job so much easier knowing all the tricks and tools.
However, it can be daunting to use if you aren’t familiar with the basic functions but want to follow along and create your financial plan in the classes I’ve shared or any other amazing spreadsheet resources that can be found on the web.
I created a quick 17-minute video to explain some of the basic things you need to know to get started. It’s my first video, so it’s not perfect but I hope it will be helpful if you’re not sure where to begin!
Included in this video are the following topics:
- Introduction to workbooks
- How to use multiple worksheets
- Editing rows, columns & cells
- Formatting rows, columns, cells as well as entire worksheets
- Creating basic formulas such as sum, average and count
- Other miscellaneous helpful tips
If you already have a good working knowledge of Excel, this is probably one that you can skip. Otherwise, here it is!
9 Responses
Loved the video! Such a great idea! Keep them coming ??
I’m going to make the next one more exciting, haha!
Glad to see you spreading the word on how amazing Excel is for tracking expenses and budgeting! I use pivot tables myself to summarize the expenses into categories, so I can slice and dice the numbers. Perhaps you could create a future tutorial covering pivot tables – I think others might find them useful too, although they’re more of an “advanced Excel” option.
I love using pivot tables-great idea!
I really like excel and know that I’m not anywhere close to using all the powerful functions that it has. I definitely can’t wait to see where you go with this series!!!
I’m just not sure exactly where it’s going to go either-haha! If you have any suggestions let me know. 🙂
I am also a spreadsheet nerd, so I can appreciate this post so much!
I’m glad I’m not alone in my nerdiness ;)!