Microsoft Excel Basics Tutorial for Beginners

Excel skills are necessary for many professional jobs. This video shows the top 20 tips on how to get started as a beginner on Excel.

__________

MENTIONED IN THIS VIDEO

The Ultimate Guide to Finally Learn Excel:
https://finallylearn.com/the-ultimate-guide-to-finally-learn-excel/

Excel Basics Playlist:
https://www.youtube.com/playlist?list=PLfGIgQ5MF87BO2ScuNUv38qXAPhxSZLz1

__________

LEARN MORE

✅ Subscribe to Finally Learn https://www.youtube.com/finallylearn?sub_confirmation=1
? Visit Finally Learn: https://finallylearn.com/welcome/
? Time Value of Money Playlist: https://youtube.com/playlist?list=PLfGIgQ5MF87AxKStl_GhqJwSCrlC5cMvG
?? Excel Basics for Beginners Playlist: https://youtube.com/playlist?list=PLfGIgQ5MF87BO2ScuNUv38qXAPhxSZLz1
? Intermediate Accounting Study Guide https://finallylearn.com/intermediate-accounting-study-guide/
? Intermediate Accounting 1 Playlist: https://youtube.com/playlist?list=PLfGIgQ5MF87Ai2bWa1sTxIDRPqr6eNI4s
? Intermediate Accounting 2 Playlist: https://youtube.com/playlist?list=PLfGIgQ5MF87ATzNtzfgL0bSim8oh_CJ1t

__________

BOOKS I RECOMMEND

? The Little Book of Common Sense Investing (Jack Bogle is the father of index fund investing) https://amzn.to/3cOIHi2
? A Random Walk Down Wall Street (Burton Malkiel's book on why index funds beat the investing pros) https://amzn.to/3mt6OpX
? The Boglehead's Guide to the Three-Fund Portfolio (Simplifying your portfolio with just three funds) https://amzn.to/3cOeEas

__________

SAY HI ON SOCIAL

? Website: https://www.finallylearn.com
? Instagram: http://instagram.com/finallylearn
? Twitter: https://twitter.com/finallylearn
? YouTube: https://www.youtube.com/finallylearn

__________

MY GEAR

? Microphone https://amzn.to/39Dd7Sm
? Laptop https://amzn.to/2PVacxz
? Laptop Backpack https://amzn.to/2OnqkHI
? Financial Calculator https://amzn.to/3duFvY0
? Earbuds https://amzn.to/2PzHNx9
? Journal Notebook https://amzn.to/3f4jrUX
? Archival Ink Pens https://amzn.to/3tBHCiY


__________

CHAPTERS

0:00 Introduction
0:37 Tip 1 Columns and Rows
1:08 Tip 2 Cell Names and Ranges
1:27 Tip 3 One Item One Cell
4:26 Tip 4 Ribbon and Views
6:24 Tip 5 Excel Formulas
8:10 Tip 6 Excel Functions
11:38 Tip 7 Copy / Paste (5 ways)
12:10 Tip 9 Cell Formatting
16:00 Tip 8 Relative vs. Absolute Address
18:42 Tip 10 AutoSum
20:09 Tip 11 Format a Table
21:48 Tip 12 Column Width
22:26 Tip 13 and 14 Filter and Sort
25:08 Tip 15 Multiple Sheets / Tabs
25:30 Tip 16 VLOOKUP
26:20 Tip 17 Formula Builder
28:20 Tip 18 Data Validation
30:08 Tip 19 Named Range
31:26 Tip 20 AVERAGEIFS and COUNTIFS
34:00 Tip 21 Copy and Paste Special

__________

ABOUT ME
My name is Jeff Mankin. I teach accounting, finance, and Excel. I started my website FinallyLearn.com and my channel to teach more people financial topics. I have a passion for teaching financial topics using Excel. I have articles and videos on many financial topics. My goal is to help you finally learn financial skills! Check out the playlists on accounting basics, time value of money, and Intermediate Accounting. I hope you join me on the Finally Learn channel!
__________

DISCLAIMERS & DISCLOSURES

This content is for education and entertainment purposes only. Finally Learn does not provide accounting, tax, financial planning, or investment advice. The information is being presented without consideration of the investment objectives, risk tolerance, or financial circumstances of any specific investor and might not be suitable for all investors. Past performance is not indicative of future results. All investing involves risk, including the possible loss of principal.

This description contains affiliate links that allow you to find the items mentioned in this video and support the channel at no cost to you. Finally Learn is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to www.amazon.com. Thank you for your support!


#finallylearn #jeffmankin


47 Subscribers
08/26/2020

https://youtu.be/FvU4onTHvA8