Skip to main content

Excel University: Excel Automation Skills for Accounting & Finance Course Bundle for $29 April 27, 2021 at 02:00AM



Checkout Now

Expires April 27, 2121 23:59 PST
Buy now and get 95% off

Automation Tools Course 1: Power Query and Power Pivot


KEY FEATURES

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.

PRODUCT SPECS

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

THE EXPERT

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.

Automation Tools Course 2: Macros and VBA


KEY FEATURES

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.

PRODUCT SPECS

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

THE EXPERT

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.




Checkout Now

Comments

Popular posts from this blog

2019’s Udemy *New Year’s Sale: Get Udemy courses for as low as $9.99 now! W/ Coupon code - January 01, 2019 at 01:18AM

2019’s Udemy *New Year’s Sale: Get Udemy courses for as low as $9.99 now! Make 2019 the year you rise to your potential and achieve all your New Year resolutions, with the most popular courses from leading instructors, for as low as $9.99 each! *New Year’s Sale: Get Udemy courses for as low as $9.99 […] The post 2019’s Udemy *New Year’s Sale: Get Udemy courses for as low as $9.99 now! W/ Coupon code appeared first on CouponRim . from CouponRim https://cpr.im/2An4ERS

SyncMate 7: Lifetime Expert License for $14 January 02, 2019 at 02:00AM

Checkout Now Expires April 02, 2019 23:59 PST Buy now and get 71% off Checkout Now KEY FEATURES If you jump between Apple and non-Apple devices, you understand the hassle that is keeping your data synced across the board. That's why there's SyncMate, the ingenious tool that lets you synchronize data between your Mac and other devices all in a single, convenient application. From contacts and calendars to folders and iTunes, SyncMate makes it easy to keep all of your data synchronized, and with an Expert license, you'll enjoy even more syncing options, like automatic syncing, backups, and more. Keep your data in sync between your Mac & other platforms, including Android, iCloud and Dropbox Sync your Mac w/ multiple devices simultaneously Automatically keep data on your devices up to speed with Autosync Use hassle-free w/ invisible background syncing Sync your contacts, calendars, folders & more Seamlessly sync multimedia files in

The Complete Big Data Master Class Bundle for $35 March 10, 2019 at 03:00AM

Checkout Now Expires March 10, 2024 23:59 PST Buy now and get 96% off Learn By Example: Plotly KEY FEATURES You don't need to be a programming prodigy to get started in data science. Easy to use and highly accessible, Plotly is library in Python that lets you create complex plots and graphs with minimal programming know-how. From creating basic charts to adding motion to your visualizations, this course will walk you through the Plotly essentials with hands-on examples that you can follow. Access 28 lectures & 2 hours of content 24/7 Learn how to build line charts, bar charts, histograms, pie charts & other basic visualizations Explore visualizing data in more than two dimensions Discover how to add motion to your graphs Work w/ plots on your local machine or share them via the Plotly Cloud PRODUCT SPECS Important Details Length of time users can access this course: lifetime Access options: web and mobile streaming Certification of completion in