Excel for Accountants: Volume 3

Replace formula-based reports with PivotTables!
4.5 (3 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.
70 students enrolled
$175
Take This Course
  • Lectures 175
  • Contents Video: 8.5 hours
    Other: 2 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.

After this course, you'll feel comfortable building PivotTable reports to replace existing formula-based reports. Plus, you'll learn how efficiently Excel can retrieve data from other data sources, including the world wide web. The session concludes with several features than enable you to communicate data graphically.

Background

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 3 and made them both available in this Excel for Accountants Volume 3 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?

  • State the process to create a PivotTable report
  • Distinguish between formula-based and PivotTable reports
  • Identify three Excel features that can graphically communicate information
  • Identify the four PivotTable report layout areas
  • State which command is used to group a PivotTable report by month
  • Distinguish between calculated fields and calculated items
  • Identify the command that will open Excel's web browser
  • Recognize the option that imports external data directly into a PivotTable
  • State the process for creating a PivotChart

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
Welcome!
Preview
Article
Chapter 1: Overview
Preview
02:15
Section 2: Chapter 2: Selected Shortcuts
Chapter 2: Selected Shortcuts Lecture Video
06:33
Exercise 1—Format Cells
Article
Exercise 2—Center Across Selection
Article
Exercise 3—Named Reference
Article
Exercise 4—Data Validation
Article
Conclusion
Article
Solutions Video
04:04
Chapter 2 Quiz
2 questions
Section 3: PivotTable Basics
Chapter 3: PivotTable Basics Lecture Video
Preview
09:32
Exercise 1—Amount by Department
Preview
Article
Exercise 2—Amount by Account
Preview
Article
Conclusion
Preview
Article
Solutions Video
Preview
01:48
Chapter 3 Quiz
2 questions
Section 4: Row Fields
Chapter 4: Row Fields Lecture Video
06:16
Exercise 1—Two Row Fields
Article
Exercise 2—Three Row Fields
Article
Conclusion
Article
Solutions Video
02:22
Chapter 4 Quiz
2 questions
Section 5: Value Fields
Chapter 5: Value Fields Lecture Video
12:32
Exercise 1—Count
Article
Exercise 2—Sum
Article
Exercise 3—Average
Article
Exercise 4—Unique List
Article
Exercise 5—Drill Down
Article
Conclusion
Article
Solutions Video
04:08
Chapter 5 Quiz
2 questions
Section 6: Column Fields
Chapter 6: Column Fields Lecture Video
03:39
Exercise 1—Departments
Article
Exercise 2—Headers
Article
Exercise 3—Stores
Article
Conclusion
Article
Solutions Video
01:59
Chapter 6 Quiz
2 questions
Section 7: Filter Fields
Chapter 7: Filter Fields Lecture Video
04:09
Exercise 1—Single Filter
Article
Exercise 2—Multiple Filters
Article
Conclusion
Article
Solutions Video
02:09
Chapter 7 Quiz
2 questions
Section 8: Updating Data
Chapter 8: Updating Data Lecture Video
11:01
Exercise 1—Refresh
Article
Exercise 2—Change Data Source
Article
Exercise 3—Table
Article
Conclusion
Article
Solutions Video
04:05
Chapter 8 Quiz
2 questions
Section 9: Groups and Subtotals
Chapter 9: Groups and Subtotals Lecture Video
12:46
Exercise 1—Remove Region Subtotals
Article
Exercise 2—Month Groups
Article
Exercise 3—Month and Year Groups
Article
Exercise 4—Quarter Groups
Article
Conclusion
Article
Solutions Video
02:55
Chapter 9 Quiz
2 questions
Section 10: Value Formats
Chapter 10: Value Formats Lecture Video
05:27
Exercise 1—Number Format
Article
Exercise 2—Currency Format
Article
Conclusion
Article
Solutions Video
01:44
Chapter 10 Quiz
1 question
Section 11: Report Type Comparison
Chapter 11: Report Type Comparison Lecture Video Part 1
09:37
Lecture Video Part 2
12:27
Exercise 1—Warm-up
Article
Exercise 2—Crosstab
Article
Exercise 3—New Items
Article
Exercise 4—Labels without Data
Article
Exercise 5—V2 Revisited
Article
Conclusion
Article
Solutions Video
06:58
Chapter 11 Quiz
2 questions
Section 12: Options
Chapter 12: Options Lecture Video
08:05
Exercise 1—Empty Cells
Article
Exercise 2—Column Widths
Article
Exercise 3—Grand Total
Article
Conclusion
Article
Solutions Video
03:52
Chapter 12 Quiz
2 questions
Section 13: Report Layout and Design
Chapter 13: Report Layout and Design Lecture Video
11:38
Exercise 1—Accounts
Article
Exercise 2—Regions
Article
Exercise 3—Employees
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