$395 (USD)
SAVE $57

Add To Cart
QuickBooks-Online-Microsoft-Excel-2019

Introduction to Microsoft Excel 2019/Office 365
I. Excel Basics
II. Creating a Worksheet
III. Time-Savers
IV. Relative, Absolute, Mixed, and Circular References
V. 3-Dimensional Workbooks
VI. Sorting, Subtotaling, and Filtering
VII. Charting Basics
VIII. Advanced Charting Techniques
IX. Intro to Excel's Statistical Functions
X. Financial Functions
XI. Worksheet Automation
XII. Mastering Excel's IF Function
Intermediate Microsoft Excel 2019/Office 365
I. Excel Charts and Graphs
II. More Excel Charts
III. AutoFilter and Sorting
IV. Goal Seeking
V. Pivot Tables
VI. Advanced PivotTables
VII. Solver
VIII. Sparklines
IX. Macros
X. Introduction to Functions
XI. Math/Trig Functions
XII. VLOOKUP, INDEX, and MATCH Functions
Introduction to QuickBooks Online
I. Getting Started
II. Accounting Basics
III. The Chart of Accounts
IV. Centers and Lists
V. Bank Accounts
VI. Recording Expenses—Part 1
VII. Recording Expenses—Part 2
VIII. Credit Cards and Loans
IX. Recording Income—Part 1
X. Recording Income—Part 2
XI. Recording Income—Part 3
XII. Sales Taxes and Reports
Intermediate QuickBooks Online
I. Managing Setting, Users, and Accountants
II. Product and Service Items
III. Managing Inventory
IV. Customizing Sales Forms and Tracking Classes and Locations.
V. Managing Projects and Sales
VI. Progress Invoicing and Bad Debts
VII. Payroll and Gift Cards
VIII. Fixed Assets and Loans
IX. Business Entities and Owner Transactions.
X. Banking Rules and Budgets
XI. Multiple Currencies and Vehicle Mileage
XII. Adjusting and Reviewing the Books

 
  Close Nav
  • Learn a new skill or enhance existing skills for professional development or personal enrichment.
  • New sessions starting monthly with lessons and assignments released weekly.
  • 2-4 hours a week in a convenient six-week format.
  • Interactive learning environment. Classroom built around discussion areas where you can engage with classmates and instructors.
  • Expert instructors develop, lead, and interact with students in each course.
  • Award of completion from your learning institution with passing score.
  • Gain the knowledge needed to move forward with your education.
  • Start anytime. Access Granted upon registration.
  • Courses are designed to be completed within 6-12 weeks.
  • Interactive multi-media instruction with integrated assessment, allowing you to work at your own pace.
  • Professional instructors support you throughout your learning experience.
  • Confirmation of successful course completion.
  • Build industry skills or earn continuing education credits in a variety of fields.
  • Start Anytime. Access to all course material and assessments from day one.
  • Many tutorials can be completed in just a few hours.
  • Quick independent study. Learn something new or expand your knowledge while working at your own pace.
  • Material developed by industry leaders and student support offered.
  • Certificate of completion awarded with passing score.

Forgot Password?