HOT
blank

Excel for Accountants: Volume 3

Office Productivity

Rating4.8
Enroll Now

Excel for Accountants: Volume 3, available at $159.99, has an average rating of 4.75, with 175 lectures, 25 quizzes, based on 74 reviews, and has 493 subscribers.

You will learn about 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 This course is ideal for individuals who are This course is designed for accountants seeking to use Excel to complete their tasks more quickly. or This course is not designed for people seeking generic Excel training, as the features covered are relevant to accountants. It is particularly useful for This course is designed for accountants seeking to use Excel to complete their tasks more quickly. or This course is not designed for people seeking generic Excel training, as the features covered are relevant to accountants.

Enroll now: Excel for Accountants: Volume 3

Summary

Title: Excel for Accountants: Volume 3

Price: $159.99

Average Rating: 4.75

Number of Lectures: 175

Number of Quizzes: 25

Number of Published Lectures: 175

Number of Published Quizzes: 25

Number of Curriculum Items: 200

Number of Published Curriculum Objects: 200

Original Price: $159.99

Quality Status: approved

Status: Live

What You Will Learn

  • 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

Who Should Attend

  • 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.

Target Audiences

  • 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.

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.

Course Curriculum

Chapter 1: Chapter 1: Overview

Lecture 1: Welcome!

Lecture 2: Chapter 1: Overview

Chapter 2: Chapter 2: Selected Shortcuts

Lecture 1: Chapter 2: Selected Shortcuts Lecture Video

Lecture 2: Exercise 1—Format Cells

Lecture 3: Exercise 2—Center Across Selection

Lecture 4: Exercise 3—Named Reference

Lecture 5: Exercise 4—Data Validation

Lecture 6: Conclusion

Lecture 7: Solutions Video

Chapter 3: PivotTable Basics

Lecture 1: Chapter 3: PivotTable Basics Lecture Video

Lecture 2: Exercise 1—Amount by Department

Lecture 3: Exercise 2—Amount by Account

Lecture 4: Conclusion

Lecture 5: Solutions Video

Chapter 4: Row Fields

Lecture 1: Chapter 4: Row Fields Lecture Video

Lecture 2: Exercise 1—Two Row Fields

Lecture 3: Exercise 2—Three Row Fields

Lecture 4: Conclusion

Lecture 5: Solutions Video

Chapter 5: Value Fields

Lecture 1: Chapter 5: Value Fields Lecture Video

Lecture 2: Exercise 1—Count

Lecture 3: Exercise 2—Sum

Lecture 4: Exercise 3—Average

Lecture 5: Exercise 4—Unique List

Lecture 6: Exercise 5—Drill Down

Lecture 7: Conclusion

Lecture 8: Solutions Video

Chapter 6: Column Fields

Lecture 1: Chapter 6: Column Fields Lecture Video

Lecture 2: Exercise 1—Departments

Lecture 3: Exercise 2—Headers

Lecture 4: Exercise 3—Stores

Lecture 5: Conclusion

Lecture 6: Solutions Video

Chapter 7: Filter Fields

Lecture 1: Chapter 7: Filter Fields Lecture Video

Lecture 2: Exercise 1—Single Filter

Lecture 3: Exercise 2—Multiple Filters

Lecture 4: Conclusion

Lecture 5: Solutions Video

Chapter 8: Updating Data

Lecture 1: Chapter 8: Updating Data Lecture Video

Lecture 2: Exercise 1—Refresh

Lecture 3: Exercise 2—Change Data Source

Lecture 4: Exercise 3—Table

Lecture 5: Conclusion

Lecture 6: Solutions Video

Chapter 9: Groups and Subtotals

Lecture 1: Chapter 9: Groups and Subtotals Lecture Video

Lecture 2: Exercise 1—Remove Region Subtotals

Lecture 3: Exercise 2—Month Groups

Lecture 4: Exercise 3—Month and Year Groups

Lecture 5: Exercise 4—Quarter Groups

Lecture 6: Conclusion

Lecture 7: Solutions Video

Chapter 10: Value Formats

Lecture 1: Chapter 10: Value Formats Lecture Video

Lecture 2: Exercise 1—Number Format

Lecture 3: Exercise 2—Currency Format

Lecture 4: Conclusion

Lecture 5: Solutions Video

Chapter 11: Report Type Comparison

Lecture 1: Chapter 11: Report Type Comparison Lecture Video Part 1

Lecture 2: Lecture Video Part 2

Lecture 3: Exercise 1—Warm-up

Lecture 4: Exercise 2—Crosstab

Lecture 5: Exercise 3—New Items

Lecture 6: Exercise 4—Labels without Data

Lecture 7: Exercise 5—V2 Revisited

Lecture 8: Conclusion

Lecture 9: Solutions Video

Chapter 12: Options

Lecture 1: Chapter 12: Options Lecture Video

Lecture 2: Exercise 1—Empty Cells

Lecture 3: Exercise 2—Column Widths

Lecture 4: Exercise 3—Grand Total

Lecture 5: Conclusion

Lecture 6: Solutions Video

Chapter 13: Report Layout and Design

Lecture 1: Chapter 13: Report Layout and Design Lecture Video

Lecture 2: Exercise 1—Accounts

Lecture 3: Exercise 2—Regions

Lecture 4: Exercise 3—Employees

Lecture 5: Conclusion

Instructors

Rating Distribution

  • 1 stars: 0 votes
  • 2 stars: 0 votes
  • 3 stars: 8 votes
  • 4 stars: 26 votes
  • 5 stars: 40 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Chatgpt And Ai Tools Courses to Learn in November 2024

Top 10 Excel Vba Courses to Learn in November 2024

The Complete Copywriting Course : Write to Sell Like a Pro