QuickBooks Intro – Desktop
QuickBooks is an accounting software package that allows you to more effectively manage your small or medium-sized business. This class will cover QuickBooks basics and provide tips to help you become more efficient in your day-to-day functions.
QuickBooks Intro - Cloud Based
QuickBooks is an accounting software package that allows you to more effectively manage your small or medium-sized business. This class will cover QuickBooks basics and provide tips to help you become more efficient in your day-to-day functions. This course teaches the cloud-based version.
QuickBooks Intermediate - Cloud Based
In this course, students will expand upon the skills learned in the introductory course and learn more about using QuickBooks to deal with physical inventory and payroll. This course teaches the cloud-based version of QuickBooks. Students are expected to have prior experience with QuickBooks.
MS Word - Advanced
In this course, take a closer look at tracking document changes, working with multiple reviewers, document sharing and access control as well as digital signatures. Explore personalization options to control AutoCorrect and recovery options. Learn how to automate repetitive tasks with macros and make custom keyboard shortcuts. Become familiar with some of the ways MS Word can interact and integrate with other applications in the MS Office suite.
MS PowerPoint - Advanced
Learn advanced PowerPoint skills, how to present the story of the data. Review the basics, and also learn design principles, how to create customized presentations, special effects, slide, notes and handout masters.
MS Excel Intro
This introductory course in MS Excel spreadsheets covers working with tables and creating and navigating worksheets, including entering, editing and formatting numbers, text, and dates. Learn how to write formulas and use functions for calculations. Create and format charts to visualize data and illustrate trends. Explore sorting and filtering while learning some helpful tools for working with large data sets.
MS Excel Intermediate
Apply more advanced workbook formatting using themes and styles, and learn to use custom number formats and conditional formatting. Add subtotals, nested functions, date and time calculations, text modification, and conditional functions to your Excel skillset. Explore the potential of lookup functions and analysis tools.
MS Excel Pivot Tables & Charts
The pivot table is one of the most useful spreadsheet tools for analyzing and summarizing data. Explore the visualization possibilities of Excel charts, pivot tables, and pivot charts.
MS Excel Advanced
Learn more advanced skills for working with tables and explore options for protecting workbook data. Become familiar with charting, financial functions and what-if analysis tools, scenarios and goal seeking. Create, format, and filter pivot tables to summarize data and create calculated fields.
MS Excel VBA Programming
Harnessing the power of VBA in MS Office can make you the MVP at your company! In this course, students will learn how to use macros to automate routine tasks and create custom functions in MS Excel, beginning from simple examples and working up to Visual Basic programming using dialog boxes and control structures.
With this advanced VBA course you will grow your arsenal of time-saving tricks to become the most essential member of your team! In this course, take a much deeper dive into automating Excel data analysis, with applications in business intelligence, finance and multi-sheet big data extraction.
Introduction to Microsoft Access 2019/Office 365
Build, edit, and maintain databases in Microsoft Access 2019/Office 365 using tables, reports, forms, and queries to give you fast access to all your important information. This hands-on course for beginners provides the skills to create an effective database for any type of information at home or on the job. This course is offered through Ed2Go.
Intermediate Microsoft Access 2019/Office 365
Develop a fully functional database in this hands-on Microsoft Access 2019/Office 365 course. Master advanced techniques for presenting data, automating common tasks, and building navigation as you work to create a database project from scratch. This course is offered through Ed2Go.
Introduction to Microsoft Project 2019/Office 365
Learn to effectively plan, implement, and control projects using Microsoft Project 2019/Office 365. This course will help you master the basics to create and share a project schedule, track costs and resources, produce reports, and resolve problems to keep your projects on track. This course is offered through Ed2Go.