Excel for Accounting

Focused View

Steve Friedman and Madecraft

1:09:33

120 View

01 - Introduction

01 - Being good at Excel.mp4

01:08

02 - 1. Your Excel Toolkit

01 - Absolute and relative references.mp4

05:31

02 - Using references to build spreadsheets.mp4

04:00

03 - Loan and financial functions.mp4

03:20

04 - Date functions.mp4

03:49

05 - How time works in Excel.mp4

04:17

03 - 2. Becoming a Power User

01 - IF formulas.mp4

04:23

02 - Using XLOOKUP.mp4

03:28

03 - Importance of VLOOKUP.mp4

04:41

04 - Pivot tables.mp4

04:23

05 - COUNTIF and SUMIF.mp4

03:01

06 - COUNTIFS and SUMIFS.mp4

03:57

07 - SUMIF(S) for accounting and finance.mp4

05:33

08 - Charts and graphs.mp4

04:26

09 - Error checking.mp4

03:16

04 - 3. Continuing Your Excel Journey

01 - Excel best practices.mp4

03:53

02 - Common problems and troubleshooting.mp4

04:56

05 - Conclusion

01 - Let's get started.mp4

01:31

Description

Excel is one of the most important skills for an accountant to have, but it can be tough if you’re unsure of where to start or how to complete a specific task. It’s easy to feel overwhelmed and not know where to start using the many functions available in Excel. In this course, Steve Friedman, the founder and Chief Instructor of Rockstar Excel, teaches you skills to ensure you can confidently leverage Excel in your role as an accountant. He shares essential formulas to use and shows you how to use tools like Pivot Tables, XLOOKUPs, and SUMIFs. He explains how to build and utilize an Excel Toolkit, spot errors quickly and easily, and refine your skills to become a power user. If you’re looking for some clarity and direction in your Excel learning journey, join Steve in this course.

This course was created by Madecraft. We are pleased to host this training in our library.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Accounting

Steve Friedman and Madecraft

Instructor's Courses

With over 20 years experience, I can show you how to unlock the power of Excel to get more done in less time, amaze your boss and potential employers, and enjoy unparalleled job security. Even if you're afraid of spreadsheets or have never used Excel before. There are a ton of complicated things you can do in Excel. But only a few simple things to learn to unlock the power of Excel to transform your career or business. I'll very quickly show you how to be an Excel Rockstar, saving hours a day, automating tasks, and accomplishing work you never thought possible. I'm a former Corporate Controller/CFO in the fast-paced tech startup space, who used Excel to ensure accurate and timely financials, maintain a sound financial footing, and keep a sense of stability through rapid growth, cash crunches, shifting business models, and nonstop crises.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.