Enrollment Options:

1. Intermediate Microsoft Excel 2019/Office 365
   1. Excel Charts and Graphs
   2. More Excel Charts
   3. AutoFilter and Sorting
   4. Goal Seeking
   5. Pivot Tables
   6. Advanced PivotTables
   7. Solver
   8. Sparklines
   9. Macros
   10. Introduction to Functions
   11. Math/Trig Functions
   12. VLOOKUP, INDEX, and MATCH Functions
2. Intermediate QuickBooks Online
   1. Managing Setting, Users, and Accountants
   2. Product and Service Items
   3. Managing Inventory
   4. Customizing Sales Forms and Tracking Classes and Locations
   5. Managing Projects and Sales
   6. Progress Invoicing and Bad Debts
   7. Payroll and Gift Cards
   8. Fixed Assets and Loans
   9. Business Entities and Owner Transactions
   10. Banking Rules and Budgets
   11. Multiple Currencies and Vehicle Mileage
   12. Adjusting and Reviewing the Books
3. Introduction to Microsoft Excel 2019/Office 365
   1. Excel Basics
   2. Creating a Worksheet
   3. Time-Savers
   4. Relative, Absolute, Mixed, and Circular References
   5. Three-Dimensional Workbooks
   6. Sorting, Subtotaling, and Filtering
   7. Charting Basics
   8. Advanced Charting Techniques
   9. Intro to Excel's Statistical Functions
   10. Financial Functions
   11. Worksheet Automation
   12. Mastering Excel's IF Function
4. Introduction to QuickBooks Online
   1. Getting Started
   2. Accounting Basics
   3. The Chart of Accounts
   4. Centers and Lists
   5. Bank Accounts
   6. Recording Expenses
   7. Paying Bills
   8. Credit Cards and Loans
   9. Recording Income
   10. Invoices and Estimates
   11. Billable Expenses and Customer Credits
   12. Sales Taxes and Reports