This class provides instruction on QuickBooks, Intuit's accounting software for small businesses using the online version of QuickBooks. The class is designed to teach you how to use features such as creating a company, modifying the preset chart of accounts, lists, managing expenses, products and services, sales and income, customer transactions, reconciling a checking account, invoicing customers, paying bills, inventory, reports and more. [Prerequisites: Students must have their own QuickBoooks software and account.]

Students will customize a form layout to improve usability and efficiency of data entry. Share data across applications. Use macros to improve user interface design. Use VBA to enhance tasks. Organize data into appropriate tables to ensure data dependency and minimize redundancy. Lock down and prepare a database for distribution to multiple users. Create and modify a database switchboard and set the start-up options.

Excel Level 1 provides the basic concepts and skills students need to start being productive with Microsoft Excel: how to create, save, share, and print worksheets that contain various kinds of calculations and formatting. Students will benefit most from this course if they want to accomplish basic workplace tasks in Excel, or if they want to have a solid foundation for continuing on to become an Excel Expert. If they intend to take a Microsoft Office Specialist or Expert exam for Excel, this courseware is a good place to start their preparation, but they will need to continue on to other courses to be fully prepared for either exam. The course assumes students know how to use a computer, and that they're familiar with Microsoft Windows. It does not assume that they've used a different version of Excel or another spreadsheet program before.

Word Level 1 provides the basic concepts and skills to start being productive with Microsoft Word: how to create, format, and set up a document, and how to add graphics and tables. Students will benefit most from this course if they want to accomplish basic workplace tasks in Word, or if they want to have a solid foundation for continuing on to become Word Expert. If students intend to take a Microsoft Office Specialist or Expert exam for Word, this course is a good place to start preparation, but they will need to complete other courses to be fully prepared for either exam. The course assumes that students know how to use a computer, and that they are familiar with Microsoft Windows.

This course provides the basic concepts and skills to start using Microsoft Access 2019: How to navigate the Access interface, and how to create and modify tables, queries, forms, and reports. You will benefit most from this course if you want to gain a basic understanding of Access and be able to design and create simple tables, queries, forms, and reports. The course assumes you know how to use a computer, and that you're familiar with Microsoft Windows. It does not assume that you've used a different version of Access or another database system before.

This course will provide the concepts and skills to use some more advanced features of Microsoft Word, including enhanced formatting, references, editing, and sharing, and saving to various formats. Students will benefit most from this course if they want to accomplish advanced workplace tasks in Word. The course assumes that students know how to use a computer, and that they are familiar with Microsoft Windows and the basics of Microsoft Word.

Excel Level 1 provides the basic concepts and skills students need to start being productive with Microsoft Excel: how to create, save, share, and print worksheets that contain various kinds of calculations and formatting. Students will benefit most from this course if they want to accomplish basic workplace tasks in Excel, or if they want to have a solid foundation for continuing on to become an Excel Expert. If they intend to take a Microsoft Office Specialist or Expert exam for Excel, this courseware is a good place to start their preparation, but they will need to continue on to other courses to be fully prepared for either exam. The course assumes students know how to use a computer, and that they're familiar with Microsoft Windows. It does not assume that they've used a different version of Excel or another spreadsheet program before.

Excel Level 2 builds on the basic concepts and skills of our Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel: how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users. Students will benefit most from this course if they want to use Excel 2019 to perform real-world tasks such as rearranging and presenting complex data. The course assumes students know how to use a computer, that they're familiar with Microsoft Windows, and that they've taken the Level 1 course or have equivalent introductory experience with Excel.