Get $1 credit for every $25 spent!

Excel University: Excel Automation Skills for Accounting & Finance Course Bundle

Ending In:
Add to Cart - $29.99
Add to Cart ($29.99)
$636
95% off
wishlist
Courses
2
Lessons
16
Enrolled
227

What's Included

Product Details

Access
Lifetime
Content
9.0 hours
Lessons
8

Automation Tools Course 1: Power Query and Power Pivot

Use These Powerful Excel Tools to Build Your Reports in Tables & Graphs

By Excel University | in Online Courses

Automation Tools 1 teaches Power Query, Power Pivot, and Power BI. It demonstrates how to use these powerful tools to build the process that builds our reports (tables and graphs). You'll select the report and graph type based on Stephen Few's books Show Me the Numbers. Plus, you'll incorporate his design practices to ensure effective communication. This course uses case studies to simulate real-world workbooks and projects. The final case study brings everything together as you build a dashboard to monitor our business. You'll complete each case study in both Excel and Power BI.

  • Access 8 lectures & 9 hours of content 24/7
  • Know which type of graph is useful to feature a given relationship
  • Identify the Excel feature that summarizes values & displays them in rows and columns and includes totals
  • Recall which tool is designed to get & transform data
  • State the Excel feature that creates a graph
  • Relate multiple tables & write measures for use in a report
  • Recognize that an explicit measure is written in Power Pivot
  • Incorporate the same technologies included in Power Query & Power Pivot
Note: Software NOT included.
Jeff Lenning | Microsoft Certified Trainer, Microsoft Excel MVP
4.9/5 stars on Trustpilot: ★ ★ ★ ★
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 Excel MVP, Microsoft Certified Trainer, and a Microsoft Certified Excel Expert. He has provided continuing education to CPAs for the past 20 years, and many of his Excel articles have been featured in industry publications such as the Journal of Accountancy and California CPA Magazine.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

  • Microsoft Excel 365 for Windows

Access
Lifetime
Content
12.0 hours
Lessons
8

Automation Tools Course 2: Macros and VBA

Use VBA to Automate Manual Tasks & Control Excel Like Never Before!

By Excel University | in Online Courses

Automation Tools 2 teaches Macros and VBA (Visual Basic for Applications). It demonstrates how to use VBA to automate manual tasks. Plus, VBA allows you to see and control Excel like never before. This course uses case studies to simulate real-world workbooks and projects. Check out the first video from the course below to learn more.

  • Access 8 lectures & 12 hours of content 24/7
  • Recognize that Application is the top object in the Excel object model
  • Read, write, and edit VBA code using the Visual Basic Editor
  • Translate your actions into VBA code
  • Complete a task in Excel using Macro
  • State which Excel tab contains the commands related to programming & VBA
Note: Software NOT included.
Jeff Lenning | Microsoft Certified Trainer, Microsoft Excel MVP
4.9/5 stars on Trustpilot: ★ ★ ★ ★
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 Excel MVP, Microsoft Certified Trainer, and a Microsoft Certified Excel Expert. He has provided continuing education to CPAs for the past 20 years, and many of his Excel articles have been featured in industry publications such as the Journal of Accountancy and California CPA Magazine.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

  • Microsoft Excel 365 for Windows


Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.