Excel for Accountants: Volume 2

Learn how to build formula-based reports and more.
4.6 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
104 students enrolled
$175
Take This Course
  • Lectures 165
  • Length 8 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2014 English

Course Description

Developed specifically for accountants, this course discusses the Excel features, functions, and techniques that are practical, relevant, and sure to save you time.

My Excel University series of books are available online in paperback and digital Kindle versions. My online Excel University courses teach the content of the books in video format. Now, for Udemy, I've combined the book text and the lecture videos of Excel University Volume 2 and made them both available in this Excel for Accountants Volume 2 course.

Course Format

Each course section will begin with the lecture video. You can work through the sample Excel file to practice. Each section also provides the text of the book which reinforces and enhances the content presented in the lecture video. I then provide additional resources and related Excel University blog posts and articles. These elements provide an effective training experience.

Instructor

Author and award-winning instructor, Jeff Lenning, is a certified public account and Microsoft certified trainer, and has helped thousands of accountants use Excel more efficiently.

What are the requirements?

  • To work on the exercises, please have Excel 2007/2010/2013 for Windows.

What am I going to get from this course?

  • Recall at least three keyboard shortcuts and the arguments of at least three functions
  • Identify which Excel function can be used to perform a multicolumn list comparison
  • Recognize which Excel function can return the last day of the month
  • Recall the arguments for the SUMIFS function
  • Recognize the Excel feature that removes duplicate values within a range
  • Recall the number of required and optional VLOOKUP arguments
  • Recall the arguments of the INDEX, IF, and IFERROR functions
  • State which function allows you to substitute a value for an error
  • Recall which Excel function returns the count of the number of cells that meet specified conditions
  • Recall the arguments of the DATE function
  • State an Excel function that returns the year of the date
  • Recall which function joins multiple text values
  • Recognize the function that would add up an amount column including only rows where the date is between two dates
  • Identify a technique that helps Excel translate a data label to a report label
  • State which feature can be used to provide a filter for dynamic digital reports
  • Identify which function can help build dynamic report headers

What is the target audience?

  • This course is designed for accountants seeking to use Excel to complete their tasks more quickly.
  • This course is not designed for people seeking generic Excel training, as the features covered are relevant to accountants.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Chapter 1: Overview
Article
Chapter 1: Overview Lecture Video
03:52
Section 2: Chapter 2: Selected Shortcuts
Chapter 2 Selected Shortcuts Lecture Video
07:12
Exercise 1—F9
Article
Exercise 2—Ctrl+Home
Article
Exercise 3—Row Shortcuts
Article
Exercise 4—Column Shortcuts
Article
Conclusion and Additional Resources
Article
Solutions Video
04:32
Chapter 2 Quiz
2 questions
Section 3: Conditional Summing Basics
Chapter 3: Conditional Summing Lecture Video
Preview
04:31
Exercise 1 - One Condition
Preview
Article
Exercise 2 - Two Conditions
Preview
Article
Exercise 3 - Three Conditions
Preview
Article
Conclusion and Additional Resources
Preview
Article
Solutions Video
Preview
03:00
Chapter 3 Quiz
2 questions
Section 4: Remove Duplicates
Chapter 4: Remove Duplicates Lecture Video
03:38
Exercise 1—Single Column List
Article
Exercise 2—Multicolumn Table
Article
Exercise 3—With SUMIFS
Article
Conclusion
Article
Solutions Video
03:18
Chapter 4 Quiz
2 questions
Section 5: Lookup Basics
Chapter 5: Lookup Basics Lecture Video - Part 1
11:20
Chapter 5: Lookup Basics Lecture Video - Part 2
09:40
Exercise 1—Breakdown of Simple Cell References
Article
Exercise 2—Account Values
Article
Exercise 3—With Named Ranges
Article
Exercise 4—With Skinny Row
Article
Exercise 5—With Tables
Article
Exercise 6—Department Data Validation
Article
Exercise 7—Balance Sheet Lookup
Article
Exercise 8—Bonus Range Lookup
Article
Exercise 9—Date Range Lookups
Article
Conclusion and Additional Resources
Article
Solutions Video
13:57
Chapter 5 Quiz
2 questions
Section 6: Improving VLOOKUP with MATCH
Chapter 6: Improve VLOOKUP with MATCH Lecture Video
09:00
Exercise 1 - Match
Article
Exercise 2—VLOOKUP Limitation
Article
Exercise 3—VLOOKUP with MATCH
Article
Exercise 4—Tables
Article
Conclusion
Article
Solutions Video
06:04
Chapter 6 Quiz
2 questions
Section 7: Improving VLOOKUP with VALUE and TEXT
Chapter 7: Improve VLOOKUP with VALUE and TEXT Lecture Video
07:09
Exercise 1—The Problem
Article
Exercise 2—VALUE
Article
Exercise 3—TEXT
Article
Exercise 4—Manual Conversion with Paste Special
Article
Conclusion
Article
Solutions Video
03:32
Chapter 7 Quiz
2 questions
Section 8: Moving Beyond VLOOKUP with INDEX
Chapter 8: Moving Beyond VLOOKUP with INDEX Lecture Video
08:30
Exercise 1—One Dimension
Article
Exercise 2—With Tables
Article
Exercise 3—Going Left
Article
Exercise 4—Insert Column
Article
Exercise 5—Two Dimensions
Article
Conclusion
Article
Solutions Video
06:43
Chapter 8 Quiz
2 questions
Section 9: Trap Errors with IFERROR
Chapter 9: Trap Errors with IFERROR Lecture Video
04:15
Exercise 1—Variance
Article
Exercise 2—Lookup Errors
Article
Exercise 3—Department Analysis
Article
Conclusion
Article
Solutions Video
02:37
Chapter 9 Quiz
2 questions
Section 10: The IF Function
Chapter 10: The IF Function Lecture Video
03:31
Exercise 1—Balance Sheet
Article
Exercise 2—Income Statement
Article
Exercise 3—Commission
Article
Conclusion
Article
Solutions Video
01:58
Chapter 10 Quiz
2 questions
Section 11: List Comparisons
Chapter 11: List Comparisons Lecture Video
03:30
Exercise 1—MATCH
Article
Exercise 2—VLOOKUP
Article
Exercise 3—IFERROR
Article
Conclusion
Article
Solutions Video
02:22
Chapter 11 Quiz
2 questions
Section 12: The ISERROR Function
Chapter 12: The ISERROR Function Lecture Video
07:03
Exercise 1—Reconciliation with MATCH
Article
Exercise 2—Reconciliation with VLOOKUP
Article
Conclusion
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jeff Lenning, Microsoft Certified Trainer

Award-winning instructor and author of Excel University, Jeff Lenning CPA has helped thousands of accountants work more efficiently with Microsoft Excel. Jeff is a Microsoft Certified Trainer and a Microsoft Certified Excel Expert. He has provided continuing education to CPAs for the past 10 years, and many of his Excel articles have been featured in industry publications such as the Journal of Accountancy and California CPA Magazine.

Highlights

Jeff began his career in the audit practice at Arthur Andersen. He was a senior financial analyst at Gateway computers and the accounting manager at Interpore Cross International. In 2000, he founded Click Consulting Inc., a technology consulting firm. In 2012, he launched Excel University.

Professional Involvement

He has served in a variety of leadership positions in the California Society of CPAs, including president of the CalCPA OCLB Chapter, chair of the CalCPA State Technology Committee, chair of the CalCPA OCLB Chapter Technology Committee, board member of the CalCPA OCLB Chapter, and a CalCPA Council Member.

He provides Excel training to Fortune 500 companies and is an instructor for the AICPA, the California CPA Education Foundation, and other organizations. A Microsoft Office Certified Excel Expert, he is a nationally recognized speaker and Microsoft Certified Trainer. He was recently recognized with the California CPA Education Foundation’s Award for Instructor Excellence.

Ready to start learning?
Take This Course