In these step-by-step tutorials, learn how to use Microsoft Excel. Find out how to get started with MS Excel in under 10 minutes. Learn about Pivot Tables, formulas and functions, vlookup, shortcuts. Also, find out about the latest new features and the top tips and tricks.
Curated by: Kevin Stratvert (120 videos)
In this step-by-step tutorial, learn how to manage your finances directly in Microsoft Excel using the new Money in Excel template add-in made by Microsoft. Money in Excel is a dynamic, smart template and add-in for Excel that allows you to securely connect your bank, credit card, investment, and loan accounts to Excel and automatically import your transaction and account information into an Excel spreadsheet. Keep track of your money, get closer to your financial goals, and easily customize to suit your needs. Availability Money in Excel is now available to Microsoft 365 Personal and Family subscribers in the U.S. Download Money in Excel template https://templates.office.com/en-us/money-in-excel-tm77948210 - Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com 0:00 Introduction 2:30 How to get and launch Money in Excel 4:30 Welcome tab 5:06 Instruction worksheet 5:22 Money in Excel pane & Get Started 5:45 Add an account 7:20 Transaction tab 7:40 Snapshot tab 9:04 Categories tab 9:15 Adding Net Worth and Recurring transactions 11:20 See insights related to your finances 11:47 Settings tab 12:11 Wrap up Watch all my Excel tutorial videos here: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY As full disclosure, I work at Microsoft as a full-time employee.