QuickBooks Online with Microsoft Excel 2019

QuickBooks Online with Microsoft Excel 2019

96 Course Hrs
  • Details
  • Syllabus
  • Requirements

Details

This comprehensive course will teach you the basics of accounting with QuickBooks Online, and the skills you need to increase your financial awareness using Microsoft Excel.

Introduction to Microsoft Excel 2019

If you want to learn the 2019 version of Microsoft Excel, this course will introduce you to the program's basic functions and uses. You will learn numerous shortcuts to quickly and efficiently set up worksheets.

Intermediate Microsoft Excel 2019

Learn how harness the power of Excel's data analysis tools and AutoFilter commands and how to create macros that eliminate repetitive tasks.

Introduction to QuickBooks Online

This QuickBooks course will teach you how to manage your business finances with QuickBooks Online. You will learn to use key features of QuickBooks Online and gain hands-on experience creating invoices, receipts, statements and more.

Intermediate QuickBooks Online

This course dives deeper into the software's intermediate features, such as tracking product and service items, managing inventory, and customizing sales forms.

Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.

Enrollment Options:
Instructor-Led
Course Code: B14126
Start Dates*Nov 11 | Dec 09 | Jan 13 | Feb 10
*Choose start date in cart
$395.00 USD

Syllabus

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

Requirements

Hardware Requirements:

  • This course must be taken on a PC device. A Mac OS is not compatible.

Software Requirements:

  • PC: Windows 10 or later operating systems.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
  • Microsoft Excel 2019: Available to download with a subscription to Office 365, or with Microsoft Office Home and Student 2019. (not included in enrollment)
  • When your course starts, you will be directed to access and utilize the free QuickBooks Online practice site to complete the lesson and assignment steps. You do not need to purchase a subscription or additional software to complete this course. However, please note that this course is suitable only for the QuickBooks Online version. The desktop versions of QuickBooks are not compatible with this course and should not be used. If you have the desktop version, you should consider registering for the course specifically designed for your version.
  • Adobe Acrobat Reader. Click here to download the Acrobat Reader.
  • Software must be installed and fully operational before the course begins.
  • Note: The "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.

Other:

  • Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.