Computer Applications   

You will learn to manage Azure subscriptions and resources, implement and manage storage, deploy and manage virtual machines (VMs), configure and manage virtual networks, and manage identities.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC, Mac, or Chromebook.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• Microsoft Word Online
• Adobe Acrobat Reader
• Software must be installed and fully operational before the course begins.

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.

The Microsoft Azure Administrator course is intended for those who are either looking to gain more knowledge about administering Azure cloud services, security, networking, and compute cloud abilities or who are looking to pass the AZ-104 exam and complete their Microsoft Certified: Azure Administrator certification.

You will learn to Implement access management with Azure users, groups, and role-based access control. This is in addition to creating Windows virtual machines in the Azure Portal, with Azure PowerShell, or using ARM Templates. You will also implement Azure Active Directory, Self-Service Password Reset, Azure AD Identity Protection, and integrated SaaS applications, understand virtual networking components, IP addressing, network routing options, and much more.

Furthermore, you will learn to use Azure Monitor to configure Azure alerts and review the Azure Activity Log, explain virtual machine usage cases, storage options, pricing, operating systems, networking capabilities, and general planning considerations. You will also discover how to optimize your use of Azure tools like the Azure portal, Azure PowerShell, Cloud Shell, and the Azure CLI.

By course completion, you will have the AZ-104 training needed to sit for the AZ-104: Microsoft Azure Administrator Exam. This course offers enrollment with a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Azure Subscriptions, Resources & Billing
2. Azure Policies
3. Azure Users & Groups
4. Azure Logging & Monitoring
5. Azure Resource Management
6. Azure User & Groups
7. Azure Logging & Monitoring
8. Azure Resource Management
9. Azure Storage Accounts & Types
10. Azure Virtual Machines
11. Shared Access Signature, backup & File
12. Deploy & Manage Virtual Machines
13. Azure Containers
14. Configure & Manage Victual Networks
15. Manage Identities

What you will learn

• Query and analyze Log Analytics data
• Deploy resources with ARM templates and organize Azure resources
• Create Azure storage accounts for different data replication, pricing, and content scenarios
• Implement virtual machine storage, blob storage, Azure files, and structured storage
• Secure and manage storage with shared access keys, Azure backup, and Azure File Sync
• Store and access data using Azure Content Delivery Network, and the Import and Export service
• Deploy custom server images and Linux virtual machines
• Configure virtual machine networking and storage options
• Implement virtual machine high availability, scalability, and custom scripts extensions
• Backup, restore, and monitor virtual machines
• Implement Azure DNS domains, zones, record types, and resolution methods
• Configure network security groups, service endpoints, logging, and network troubleshooting
• Implement site connectivity schemas, including VNet-to-VNet connections and virtual network peering
• Configure domains and tenants, users and groups, roles, and devices
• Implement and manage Azure Active Directory integration options and Azure AD Application Proxy
• Implement and configure Azure Load Balancer, Azure Traffic Manager, and Azure Application Gateway
• Use Azure RBAC to grant a granular level of access based on an administrator's assigned tasks
• Use Azure Multi-Factor Authentication to configure a strong authentication for users at sign-in

How you will benefit

• You will be prepared for the AZ-104: Microsoft Azure Administrator Exam
• Grow your IT career and open new job opportunities

Doug Bassett

Doug Bassett is an IT instructor specializing in Microsoft Azure, Server 2016/19, and Exchange messaging. He holds many highly sought-after IT certifications, including Microsoft MCSE, Microsoft MCSA, CompTIA Network+, Cisco CCNA, and Microsoft MCT. In addition to his certifications, Doug has expert knowledge of Microsoft Server 2000, 2003, 2008/2012/2016/2019, Exchange Server and Exchange Online, and Networking structure and applications. As an instructor, Doug is deeply involved in helping his students understand complex concepts and loves to approach teaching a subject from multiple angles.

This course is intended for Azure and Microsoft server security professionals and those who are looking to take and pass the AZ-500: Microsoft Azure Security Technologies exam.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC, Mac, or Chromebook.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• Microsoft Word Online
• Adobe Acrobat Reader
• Software must be installed and fully operational before the course begins.

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.

Take the next step towards getting your Azure security certification. In this online training course, you will gain the knowledge and skills needed to implement security controls, maintain the security posture, and identify and remediate vulnerabilities by using a variety of security tools. This course also covers scripting and automation, virtualization, and cloud N-tier architecture while you study for the AZ-500 certification.

By course completion, you will be prepared to sit for the AZ-500: Microsoft Azure Security Technologies Exam. This course offers enrollment with a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Azure AD Identities
2. Securing Access
3. Securing Application Access
4. Access Control
5. Network Security
6. Azure Security Center
7. Azure Containers
8. Azure Vulnerability
9. Security Operations
10. Secure Applications & Data

What you will learn

• Describe specialized data classifications on Azure
• Identify Azure data protection mechanisms
• Implement Azure data encryption methods
• Secure Internet protocols and how to implement them on Azure
• Describe Azure security services and features

How you will benefit

• You will be prepared for the AZ-500: Microsoft Azure Security Technologies Exam
• Grow your IT career and open new job opportunities

Doug Bassett

Doug Bassett is an IT instructor specializing in Microsoft Azure, Server 2016/19, and Exchange messaging. He holds many highly sought-after IT certifications, including Microsoft MCSE, Microsoft MCSA, CompTIA Network+, Cisco CCNA, and Microsoft MCT. In addition to his certifications, Doug has expert knowledge of Microsoft Server 2000, 2003, 2008/2012/2016/2019, Exchange Server and Exchange Online, and Networking structure and applications. As an instructor, Doug is deeply involved in helping his students understand complex concepts and loves to approach teaching a subject from multiple angles.

You will learn foundational level knowledge on cloud concepts; core Microsoft Azure services; security, privacy, compliance, and trust; and Azure pricing and support. You will also learn to manage Azure subscriptions and resources, implement and manage storage, deploy and manage virtual machines (VMs), configure and manage virtual networks, and manage identities.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC, Mac, or Chromebook.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• Microsoft Word Online
• Adobe Acrobat Reader
• Software must be installed and fully operational before the course begins.

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.

This comprehensive course bundle is designed to provide you with the Microsoft Azure training needed to take your career to the next level. Optimize your use of Azure tools, learn virtual machine (VM) storage and implement best practices, understand related essential functions and components, and much more, all on your own time.

The Microsoft Azure Fundamentals course is intended for entry-level Azure professionals and builds the groundwork needed to properly administer and subscribe to Microsoft Azure. From networking and cloud concepts to Azure workloads, security, privacy, and more, you will master the training needed to take your career to the next level. By course completion, you will be prepared to sit for the AZ-900 exam and achieve your Microsoft Certified: Azure Fundamentals certification.

The Microsoft Azure Administrator course is intended for those who are either looking to gain more knowledge about administering Azure cloud services, security, networking, and compute cloud abilities or who are looking to pass the AZ-104 exam and complete their Microsoft Certified: Azure Administrator certification. Whatever your motivation, this course will help you become an Azure admin pro in six months or less!

The course will also prepare you to sit for the AZ-900: Microsoft Azure Fundamentals and the AZ-104: Microsoft Azure Administrator Exams. This course offers enrollment with vouchers. The vouchers are prepaid access to sit for the certifying exam upon eligibility.

1. Microsoft Azure Fundamentals
1. Using Cloud Services
2. Differences between IaaS, PaaS, and SaaS
3. Differences Between Public, Private, and Hybrid Clouds
4. Core Azure Architecture Components
5. Core Products Available and Subscriptions in Azure
6. Azure Management and Monitoring Tools
7. Securing Network Connectivity in Azure
8. Core Azure Identity Services
9. Security Tools and Features of Azure
10. Azure Governance Methodologies
11. Conditional Access
12. Using Profiles
13. Privacy Standards
14. Azure Service Level Agreements (SLAs)
15. Mobile Application Management (MDM)
16. Windows Defender Tools
2. Microsoft Azure Administrator
1. Azure Subscriptions, Resources & Billing
2. Azure Policies
3. Azure Users & Groups
4. Azure Logging & Monitoring
5. Azure Resource Management
6. Azure User & Groups
7. Azure Logging & Monitoring
8. Azure Resource Management
9. Azure Storage Accounts & Types
10. Azure Virtual Machines
11. Shared Access Signature, backup & File
12. Deploy & Manage Virtual Machines
13. Azure Containers
14. Configure & Manage Victual Networks
15. Manage Identities

What you will learn

• Understand Azure workloads and subscriptions
• Security and privacy in Azure
• Implement access management with Azure users, groups, and role-based access control
• Use Azure Monitor to configure Azure alerts and review the Azure Activity Log
• Query and analyze Log Analytics data
• Deploy resources with ARM templates and organize Azure resources
• Store and access data using Azure Content Delivery Network, and the Import and Export service
• Deploy custom server images and Linux virtual machines
• Implement Azure DNS domains, zones, record types, and resolution methods
• Implement site connectivity schemas including VNet-to-VNet connections and virtual network peering
• Implement Azure Active Directory, Self-Service Password Reset, Azure AD Identity Protection, and integrated SaaS applications
• Configure domains and tenants, users and groups, roles, and devices
• Implement and manage Azure Active Directory integration options and Azure AD Application Proxy
• Implement and configure Azure Load Balancer, Azure Traffic Manager, and Azure Application Gateway
• Use Azure RBAC to grant a granular level of access based on an administrator's assigned tasks
• Use Azure Multi-Factor Authentication to configure a strong authentication for users at sign-in

How you will benefit

• You will be prepared for the AZ-900: Microsoft Azure Fundamentals and AZ-104: Microsoft Azure Administrator Exams
• Learn key concepts, applications, and skills that can help broaden your career working with cloud-based solutions and services

Will Panek

Will Panek is a worldwide recognized Microsoft instructor and author. Will is a 5-time Microsoft MVP and has published over 30 titles on Microsoft technologies. Will is a passionate and authoritative instructor and makes sure that his students can implement Microsoft technologies and get themselves certified along the way. Outside the class and authorship, you'd be likely to find Will at the forge smithing his latest creation.

Doug Bassett

Doug Bassett is an IT instructor specializing in Microsoft Azure, Server 2016/19, and Exchange messaging. He holds many highly sought-after IT certifications, including Microsoft MCSE, Microsoft MCSA, CompTIA Network+, Cisco CCNA, and Microsoft MCT. In addition to his certifications, Doug has expert knowledge of Microsoft Server 2000, 2003, 2008/2012/2016/2019, Exchange Server and Exchange Online, and Networking structure and applications. As an instructor, Doug is deeply involved in helping his students understand complex concepts and loves to approach teaching a subject from multiple angles.

You will learn foundational level knowledge on cloud concepts; core Microsoft Azure services; security, privacy, compliance, and trust; and Azure pricing and support. You will also learn to manage Azure subscriptions and resources, implement and manage storage, deploy and manage virtual machines (VMs), configure and manage virtual networks, and manage identities.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC, Mac, or Chromebook.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• Microsoft Word Online.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

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.

The Microsoft Azure Fundamentals course is intended for entry-level Azure professionals and builds the groundwork needed for you to properly administer and subscribe to Microsoft Azure. From networking and cloud concepts to Azure workloads, cloud security, privacy, and more, you will master the training needed to take your career to the next level. By course completion, you will be prepared to achieve your Microsoft Azure certification.

The Microsoft Azure Security Technologies course will help you gain the knowledge and skills needed to implement security controls, maintain the security posture, and identify and remediate vulnerabilities by using a variety of security tools. This course also covers scripting and automation, virtualization, and cloud N-tier architecture. Upon completion, you will have the fundamental knowledge required of a Microsoft cloud app security professional.

The course will also prepare you to sit for the AZ-900: Microsoft Azure Fundamentals and the AZ-500: Microsoft Azure Security Technologies Exams. This course offers enrollment with vouchers. The vouchers are prepaid access to sit for the certifying exam upon eligibility.

1. Microsoft Azure Fundamentals
   1. Using Cloud Services
   2. Differences between IaaS, PaaS, and SaaS
   3. Differences Between Public, Private, and Hybrid Clouds
   4. Core Azure Architecture Components
   5. Core Products Available and Subscriptions in Azure
   6. Azure Management and Monitoring Tools
   7. Securing Network Connectivity in Azure
   8. Core Azure Identity Services
   9. Security Tools and Features of Azure
   10. Azure Governance Methodologies
   11. Conditional Access
   12. Using Profiles
   13. Privacy Standards
   14. Azure Service Level Agreements (SLAs)
   15. Mobile Application Management (MDM)
   16. Windows Defender Tools
2. Microsoft Azure Security Technologies
1. Azure AD Identities
2. Securing Access
3. Securing Application Access
4. Access Control
5. Network Security
6. Azure Security Center
7. Azure Containers
8. Azure Vulnerability
9. Security Operations
10. Secure Applications & Data

What you will learn

• Concepts of onsite networking
• Cloud and cloud-based networking concepts
• Azure workloads, security, and subscriptions
• Concepts of hybrid networking
• Azure application support
• How to manage and monitor Azure Services
• Describe specialized data classifications on Azure
• Identify Azure data protection mechanisms
• Implement Azure data encryption methods
• Secure Internet protocols and how to implement them on Azure

How you will benefit

• You will be prepared for the AZ-900: Microsoft Azure Fundamentals and AZ-500: Microsoft Azure Security Technologies Exams
• Expand your career opportunities as an IT professional

Will Panek

Will Panek is a worldwide recognized Microsoft instructor and author. Will is a 5-time Microsoft MVP and has published over 30 titles on Microsoft technologies. Will is a passionate and authoritative instructor and makes sure that his students can implement Microsoft technologies and get themselves certified along the way. Outside the class and authorship, you'd be likely to find Will at the forge smithing his latest creation.

Doug Bassett

Doug Bassett is an IT instructor specializing in Microsoft Azure, Server 2016/19, and Exchange messaging. He holds many highly sought-after IT certifications, including Microsoft MCSE, Microsoft MCSA, CompTIA Network+, Cisco CCNA, and Microsoft MCT. In addition to his certifications, Doug has expert knowledge of Microsoft Server 2000, 2003, 2008/2012/2016/2019, Exchange Server and Exchange Online, and Networking structure and applications. As an instructor, Doug is deeply involved in helping his students understand complex concepts and loves to approach teaching a subject from multiple angles.

You will learn foundational level knowledge on cloud concepts; core Microsoft Azure services; security, privacy, compliance, and trust; and Azure pricing and support.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC, Mac, or Chromebook.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• Microsoft Word Online
• Adobe Acrobat Reader
• Software must be installed and fully operational before the course begins.

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.

The Microsoft Azure Fundamentals course is intended for entry-level Azure professionals and builds the groundwork needed to properly administer and subscribe to Microsoft Azure. From networking and cloud concepts to Azure workloads, security, privacy, and more, you will master the training needed to take your career to the next level. By course completion, you will be prepared to achieve your Microsoft Azure certification.

The course will also prepare you to sit for the AZ-900: Microsoft Azure Fundamentals Exam. This course offers enrollment with a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Onsite Networking
2. Benefits and Considerations of Using Cloud Services
3. Differences between IaaS, PaaS, and SaaS
4. Differences Between Public, Private, and Hybrid Clouds
5. Core Azure Architecture Components
6. Core Products Available and Subscriptions in Azure
7. Azure Management and Monitoring Tools
8. Securing Network Connectivity in Azure
9. Core Azure Identity Services
10. Security Tools and Features of Azure
11. Azure Governance Methodologies
12. Conditional Access
13. Using Profiles
14. Privacy Standards
15. Azure Service Level Agreements (SLAs)
16. Mobile Application Management (MDM)
17. Windows Defender Tools

What you will learn

• Concepts of onsite networking
• Cloud concepts
• Concepts of cloud-based networking
• Azure workloads
• Security and privacy in Azure
• Azure subscriptions
• Concepts of hybrid networking
• Azure application support
• How to manage and monitor Azure Services

How you will benefit

• You will be prepared for the AZ-900: Microsoft Azure Fundamentals Exam
• Increase your career opportunities as an IT professional

Will Panek

Will Panek is a worldwide recognized Microsoft instructor and author. Will Panek is a 5-time Microsoft MVP and has published over 30 titles on Microsoft technologies. Will is a passionate and authoritative instructor and makes sure that his students can implement Microsoft technologies and get themselves certified along the way. Outside the class and authorship, you'd be likely to find Will at the forge smithing his latest creation.

If you need to learn how to analyze data and create reports, this course is for you. You will learn how to use Crystal Reports, one of the most widely-used business intelligence tools, to design and generate complex reports.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Crystal Reports (not included in enrollment). A free 30 day trial is available.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

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. Manuals are included as downloadable PDFs throughout the course.

If you work with large amounts of data and need to create engaging reports with that data, then you need to learn Crystal Reports. As data analysis becomes increasingly important in business, knowing how to use Crystal Reports, SAP's widely-used business intelligence application, is critical. This course will teach you to use Crystal Reports and create custom SQL statements to analyze data and create reports that convey clear messages.

You will learn to format reports, to filter and group data, to use formulas, to create summary reports and charts and to export reports. You will then learn how to use sections to improve formatting, how to create sub reports, how to work with custom groups, and how to create report alerts. Finally, you will learn more advanced features of Crystal Reports and will receive a thorough introduction to SQL, including how to work with databases, how to perform simple and advanced SELECTs, and more.

By the end of the course, you will know how to connect to a data source and how to select subsets of the data to import into Crystal Reports to analyze. You will be able to create useful reports, manipulate their look and feel, and export them in a variety of shareable formats.

1. Introduction to Crystal Reports
   1. Getting Acquainted with Crystal Reports
   2. Formatting Reports
   3. Working with Objects
   4. Filtering Reports
   5. Sorting and Grouping Reports
   6. Using Basic Formulas
   7. Advanced Formatting
   8. Exporting and Distribution
2. Intermediate Crystal Reports
   1. Crystal Reports Review
   2. Using Parameters
   3. Using Subreports
   4. Charts
   5. Cross-Tabulation Reports
   6. Advanced Techniques
   7. Report Alerts
3. Introduction to SQL
   1. Relational Database Basics
   2. Simple SELECTs
   3. Advanced SELECTs
   4. Subqueries, Joins, and Unions
4. Advanced Crystal Reports
   1. Crystal Reports Review
   2. Working with SQL
   3. Advanced Functions
   4. Geographic Mapping

What you will learn

• To work with reports and custom SQL statements
• To connect to a data source
• To select subsets of data and perform analysis
• To format reports and share with others

How you will benefit

• You will gain the skills to successfully and confidently work with Crystal Reports software.
• You will work with SQL and Crystal Reports to learn the basics through advanced concepts of Crystal Reports.

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

Earning Microsoft Offices Specialist certification is an important career steppingstone if you work with Office products. This course will prepare you for the Microsoft Office Specialist Access Certification exam.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later. (Windows 11 users, it is recommended to have 8-16GB of RAM for best results.)
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Access 365, 2021, or 2019 (not included in enrollment). You can use any of these versions of Access for the course. Please note: The course is designed using Microsoft Access 365, which is updated regularly, so there may be some slight differences between your version and what you see in the course, but the core concepts and functionalities covered will remain consistent across all versions.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment.

Most employers seek candidates with a working knowledge of Microsoft Office. Being a certified Microsoft Office Specialist (MOS) gives your resume a boost and the potential to earn a higher salary than your non-certified peers. If you work with Access regularly, it's time to bring your skills to the next level by earning your Microsoft Office Specialist Access certification.

This Microsoft Access Certification Training course will prepare you for the Microsoft Office Specialist Access certification exam. You will first learn foundational database concepts. You will then learn to create databases and tables, query those tables, and create reports. By course completion, you will be able to design, customize, and fully optimize an Access database. These key skills are fundamental to passing the MOS MO-500 exam and earning your certification.

This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Microsoft Access
   1. Introduction to Microsoft Access Training
      1. Databases and Access Terms
      2. Quick Overview Access Interface
      3. Fundamentals
      4. Tables and Their Views
      5. Tables
      6. Queries
      7. Forms
      8. Reports
      9. EXAM: Introduction to Microsoft Access Exam
   2. Advanced Microsoft Access Training
      1. Relationships
      2. Advanced Queries
      3. Table Functions
      4. Advanced Forms
      5. Advanced Reports
      6. Macros
      7. Completing the Desktop Application
      8. EXAM: Advanced Microsoft Access Exam
   3. FINAL EXAM: Microsoft Access Final Exam

What you will learn

• Database concepts, interface and terminology
• Table views, queries, forms, reports, and macros
• Database design fundamentals
• Forms, reports, table relationship and desktop application with the navigation form

How you will benefit

• Become prepared to take the Microsoft Office Specialist Access Certification exam
• Become a vital asset to any business by mastering database management and creation
• Discover advanced Microsoft Access techniques that will set you apart from competitors

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

Earning Microsoft Offices Specialist certification is an important career steppingstone if you work with Office products. This course will prepare you for the Microsoft Office Specialist Access Certification exam.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.(Windows 11 users, it is recommended to have 8-16GB of RAM for best results.)
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Access 365, 2021, or 2019 (not included in enrollment). You can use any of these versions of Access for the course. Please note: The course is designed using Microsoft Access 365, which is updated regularly, so there may be some slight differences between your version and what you see in the course, but the core concepts and functionalities covered will remain consistent across all versions.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment.

Most employers seek candidates with a working knowledge of Microsoft Office. Being a certified Microsoft Office Specialist (MOS) gives your resume a boost and the potential to earn a higher salary than your non-certified peers. If you work with Access regularly, it's time to bring your skills to the next level by earning your Microsoft Office Specialist Access certification.

This Microsoft Access Training course will prepare you for the Microsoft Office Specialist Access certification exam. You will first learn foundational database concepts. You will then learn to create databases and tables, query those tables, and create reports. By course completion, you will be able to design, customize, and fully optimize an Access database. These key skills are fundamental to passing the MOS MO-500 exam and earning your certification.

This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Microsoft Access
1. Introduction to Microsoft Access Training
   1. Databases and Access Terms
   2. Quick Overview Access Interface
   3. Fundamentals
   4. Tables and Their Views
   5. Tables
   6. Queries
   7. Forms
   8. Reports
   9. EXAM: Introduction to Microsoft Access Exam
2. Advanced Microsoft Access Training
   1. Relationships
   2. Advanced Queries
   3. Table Functions
   4. Advanced Forms
   5. Advanced Reports
   6. Macros
   7. Completing the Desktop Application
   8. EXAM: Advanced Microsoft Access Exam
3. FINAL EXAM: Microsoft Access Final Exam

What you will learn

• Database concepts, interface and terminology
• Table views, queries, forms, reports, and macros
• Database design fundamentals
• Forms, reports, table relationship and desktop application with the navigation form

How you will benefit

• Become prepared to take the Microsoft Office Specialist Access Certification exam
• Become a vital asset to any business by mastering database management and creation
• Discover advanced Microsoft Access techniques that will set you apart from competitors

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

Becoming a certified Microsoft Office Specialist (MOS) Expert demonstrates your mastery of Microsoft Office products. This course prepares you for the Microsoft Office Specialist Expert certification exam for Microsoft Excel.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office 365, 2021 or 2019 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment.

Get the Excel training you need to achieve success so you can manipulate data faster and more efficiently in most workplace situations. If your organization uses lists of any kind, you need to know how to use Microsoft Excel. Earning the Microsoft Office Specialist Excel Expert certification sets your professional skill set apart from other Excel users. The course will prepare you for the Microsoft Office Specialist: Microsoft Excel Expert exam.

In this online Excel course, you will first learn to create, modify, and format Excel worksheets, perform calculations, and print Excel workbooks. The course then moves on to teach you how to use advanced formulas, work with lists, work with illustrations and charts, and use advanced formatting techniques. You will also learn Excel's advanced features, such as pivot tables, audit worksheets, data tools, macros, and collaboration methods.

Upon completion of this course, you will be prepared for the Microsoft Excel Expert certification exam, Exam MO-201 (for Microsoft Office 2019/2021 users), or Exam MO-211 (for Microsoft Office 365 users.) This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility. Proctor fees may apply, which are not included.

1. Introduction to Excel
   1. Microsoft Office Basics
   2. Creating a Microsoft Excel Workbook
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Entering Data in Microsoft Excel Worksheets
   7. Formatting Microsoft Excel Worksheets
   8. Editing Worksheets
   9. Working with Rows and Columns
   10. Using Formulas in Microsoft Excel
   11. Finalizing Microsoft Excel Worksheets
   12. Introduction to Excel Exam
2. Intermediate Excel
   1. Common Functions
   2. Working with Lists
   3. Visualizing Your Data
   4. Working with Tables
   5. Advanced Formatting
   6. Intermediate Excel Exam
3. Advanced Excel
   1. Using PivotTables
   2. Advanced Functions
   3. Auditing Workbooks
   4. Data Tools
   5. Working with Others
   6. Recording and Using Macros
   7. Advanced Excel Exam
4. Final Exam

What you will learn

• Modify and format data in Excel to create clear, presentable worksheets
• Perform calculations, write formulas, manage workbooks, and save time with Excel shortcuts
• Use Excel database functions and logic functions to work with information in large datasets, and leverage Excel's statistical functions to analyze data
• Visualize your data using charts to show trends, create comparisons, and demonstrate other meaningful insights
• Convert, sort, filter, and manage lists to keep your data organized
• Insert and modify illustrations, logos, or shapes to create professional reports
• Emphasize interesting and unusual data with conditional formatting and save time by using styles to apply formatting instantly
• Create PivotTables and charts to quickly summarize large amounts of data
• Learn to trace precedents and dependents to learn about the data connected to your active cell
• Convert blocks of text, analyze data using tables, and leverage validation tools to control the data entered into your worksheet. Consolidate data from various sources into one master worksheet for easy summary and review
• How to protect your worksheets and workbooks for safe and secure collaboration
• Work with other applications by importing and exporting data, charts, and files

How you will benefit

• Enhance your resume with widely-recognized and in-demand Microsoft Excel skills, making you more attractive to potential employers
• Leverage Excel's powerful data analysis capabilities to make informed data-driven decisions
• Use Excel to automate repetitive tasks, saving you valuable time and reducing the risk of manual errors
• Generate sophisticated reports and visualizations using Excel to better understand your data and communicate your findings
• Master Excel's tools and shortcuts to boost your efficiency and. you to complete your tasks more quickly

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

Becoming a certified Microsoft Office Specialist (MOS) Expert demonstrates your mastery of Microsoft Office products. This course prepares you for the Microsoft Office Specialist Expert certification exam for Microsoft Excel.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office 365, 2021 or 2019 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment.

Get the Excel training you need to achieve success so you can manipulate data faster and more efficiently in most workplace situations. If your organization uses lists of any kind, you need to know how to use Microsoft Excel. Earning the Microsoft Office Specialist Excel Expert certification sets your professional skill set apart from other Excel users. The course will prepare you for the Microsoft Office Specialist: Microsoft Excel Expert exam.

In this online Excel course, you will first learn to create, modify, and format Excel worksheets, perform calculations, and print Excel workbooks. The course then moves on to teach you how to use advanced formulas, work with lists, work with illustrations and charts, and use advanced formatting techniques. You will also learn Excel's advanced features, such as pivot tables, audit worksheets, data tools, macros, and collaboration methods.

Upon completion of this course, you will be prepared for the Microsoft Excel Expert certification exam, Exam MO-201 (for Microsoft Office 2019/2021 users), or Exam MO-211 (for Microsoft Office 365 users.) This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility. Proctor fees may apply, which are not included.

1. Introduction to Excel
   1. Microsoft Office Basics
   2. Creating a Microsoft Excel Workbook
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Entering Data in Microsoft Excel Worksheets
   7. Formatting Microsoft Excel Worksheets
   8. Editing Worksheets
   9. Working with Rows and Columns
   10. Using Formulas in Microsoft Excel
   11. Finalizing Microsoft Excel Worksheets
   12. Introduction to Excel Exam
2. Intermediate Excel
   1. Common Functions
   2. Working with Lists
   3. Visualizing Your Data
   4. Working with Tables
   5. Advanced Formatting
   6. Intermediate Excel Exam
3. Advanced Excel
   1. Using PivotTables
   2. Advanced Functions
   3. Auditing Workbooks
   4. Data Tools
   5. Working with Others
   6. Recording and Using Macros
   7. Advanced Excel Exam
4. Final Exam

What you will learn

• Modify and format data in Excel to create clear, presentable worksheets
• Perform calculations, write formulas, manage workbooks, and save time with Excel shortcuts
• Use Excel database functions and logic functions to work with information in large datasets, and leverage Excel's statistical functions to analyze data
• Visualize your data using charts to show trends, create comparisons, and demonstrate other meaningful insights
• Convert, sort, filter, and manage lists to keep your data organized
• Insert and modify illustrations, logos, or shapes to create professional reports
• Emphasize interesting and unusual data with conditional formatting and save time by using styles to apply formatting instantly
• Create PivotTables and charts to quickly summarize large amounts of data
• Learn to trace precedents and dependents to learn about the data connected to your active cell
• Convert blocks of text, analyze data using tables, and leverage validation tools to control the data entered into your worksheet. Consolidate data from various sources into one master worksheet for easy summary and review
• How to protect your worksheets and workbooks for safe and secure collaboration
• Work with other applications by importing and exporting data, charts, and files

How you will benefit

• Enhance your resume with widely-recognized and in-demand Microsoft Excel skills, making you more attractive to potential employers
• Leverage Excel's powerful data analysis capabilities to make informed data-driven decisions
• Use Excel to automate repetitive tasks, saving you valuable time and reducing the risk of manual errors
• Generate sophisticated reports and visualizations using Excel to better understand your data and communicate your findings
• Master Excel's tools and shortcuts to boost your efficiency to complete your tasks more quickly

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

The Microsoft Office Specialist (MOS) Associate Certification Training course will prepare you to take the Microsoft Office Specialist certification exams for Word, Excel, PowerPoint, and Outlook.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office 365 or 2021 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

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 available online.

While proficiency in Microsoft Office is essential in most professional settings, earning a Microsoft Office Associate certification signifies that you have a deep level of skills needed to use the Office suite.

The Microsoft Office Specialist (MOS) Associate Certification Training course will teach you how to use the Microsoft Office suite at an advanced level. You will build your expertise through hands-on exercises, in-depth course material, and supplemental video demonstrations. You will also prepare for the certification exams for Word, Excel, PowerPoint, and Outlook. As you prepare for each exam, you will test your skills at regular intervals with quizzes and exams.

By course completion, you will be fully prepared to take the MO-200 and MO-201 (Excel), MO-100 and MO-101 (Word), MO-300 and MO-310 (PowerPoint), and MO-400 (Outlook) exams. To earn the Microsoft Office Specialist (MOS) Associate Certification, you must successfully complete 3 Associate level exams of your choosing.

1. Introduction to Excel
   1. Microsoft Office Basics
   2. Creating a Microsoft Excel Workbook
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Entering Data in Microsoft Excel Worksheets
   7. Formatting Microsoft Excel Worksheets
   8. Editing Worksheets
   9. Working with Rows and Columns
   10. Using Formulas in Microsoft Excel
   11. Finalizing Microsoft Excel Worksheets
   12. Introduction to Excel Exam
2. Intermediate Excel
   1. Common Functions
   2. Working with Lists
   3. Visualizing Your Data
   4. Working with Tables
   5. Advanced Formatting
   6. Intermediate Excel Exam
3. Advanced Excel
   1. Using PivotTables
   2. Advanced Functions
   3. Auditing Workbooks
   4. Data Tools
   5. Working with Others
   6. Recording and Using Macros
   7. Advanced Excel Exam
   8. Final Excel Exam
4. Introduction to Word
   1. Microsoft Office Basics
   2. Creating a Microsoft Word Document
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Formatting Microsoft Word Documents
   7. Editing Documents
   8. Finalizing Microsoft Word Documents
   9. Introduction to Word Exam
5. Intermediate Word
   1. Advanced Formatting
   2. Working with Tables
   3. Working with Images
   4. Page Layout
   5. Working with Illustrations
   6. Viewing Your Documents
   7. Intermediate Word Exam
6. Advanced Word
   1. Working with Long Documents
   2. Reviewing and Collaborating on Documents
   3. Comparing and Combining Documents
   4. Forms
   5. Managing Mailings
   6. Protecting Documents
   7. Macros
   8. Advanced Word Exam
   9. Final Word Exam
7. Introduction to PowerPoint
   1. Microsoft Office Basics
   2. Creating a Presentation
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Formatting Presentations
   7. Working with Images
   8. Working with Tables and Charts
   9. Preparing and Presenting
   10. Introduction to PowerPoint Exam
8. Advanced PowerPoint
   1. Customizing Presentations
   2. Presentation Masters
   3. Working with Special Effects
   4. Using SmartArt
   5. Multimedia
   6. Setting up the Slide Show
   7. Outlines and Slides
   8. Managing Multiple Presentations
   9. Finalizing Presentations
   10. Advanced PowerPoint Exam
   11. Final PowerPoint Exam
9. Introduction to Microsoft Outlook
   1. The Outlook Interface
   2. Working with Messages
   3. Working with the Calendar
   4. Organizing Contacts
   5. Working with Groups
   6. Introduction to Microsoft Outlook Exam
10. Advanced Microsoft Outlook
    1. Performing Popular Tasks
    2. Working with Tasks and Notes
    3. Using Signature and Themes
    4. Managing Your Inbox
    5. Working with Multiple Email Accounts
    6. Advanced Microsoft Outlook Exam
    7. Final Outlook Exam

What you will learn

• Master the crucial Microsoft Office suite skills: Word, Excel, PowerPoint, and Outlook to enhance your productivity
• Craft and refine Word documents with ease and precision
• Create visually stunning Excel spreadsheets to make data analysis engaging
• Design persuasive PowerPoint presentations to captivate audiences
• Streamline communication, scheduling, and collaboration using Outlook's powerful features

How you will benefit

• Increased employability: Enhance your resume with the widely-recognized and in-demand Microsoft Office skills, making you more attractive to potential employers
• Improved productivity: Streamline your daily tasks and processes by utilizing the various tools and features available in the Office suite
• Enhanced communication: Craft professional and visually appealing documents, presentations, and emails to clearly convey your message to colleagues and clients
• Data-driven decision-making: Leverage Excel's powerful data analysis capabilities to make informed decisions based on quantitative insights
• Efficient collaboration: Utilize Outlook and other Office applications to seamlessly collaborate with team members, share documents, and keep everyone on the same page
• Time-saving automation: Use Excel to automate repetitive tasks, saving you valuable time and reducing the risk of manual errors
• Customized solutions: Tailor PowerPoint presentations and Word documents to suit various audiences and purposes, adapting to the specific needs of your projects
• Superior organization: Manage your schedule, tasks, and contacts effectively using Outlook's calendar and task management features, ensuring you stay on top of your commitments
• Advanced reporting: Generate sophisticated reports and visualizations using Excel to better understand your data and communicate your findings
• Professional growth: Continuously develop your skills and stay relevant in the ever-evolving workplace by mastering the latest updates and features within the Microsoft Office suite

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

The Microsoft Office Specialist (MOS) Associate Certification Training course will prepare you to take the Microsoft Office Specialist certification exams for Word, Excel, PowerPoint, and Outlook. Exam fees are included in the course cost.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office 365 or 2021(not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

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 available online.

While proficiency in Microsoft Office is essential in most professional settings, earning a Microsoft Office Associate certification signifies that you have a deep level of skills needed to use the Office suite.

The Microsoft Office Specialist (MOS) Associate Certification Training course will teach you how to use the Microsoft Office suite at an advanced level. You will build your expertise through hands-on exercises, in-depth course material, and supplemental video demonstrations. You will also prepare for the certification exams for Word, Excel, PowerPoint, and Outlook. As you prepare for each exam, you will test your skills at regular intervals with quizzes and exams.

By course completion, you will be fully prepared to take the MO-200 and MO-201 (Excel), MO-100 and MO-101 (Word), MO-300 and MO-310 (PowerPoint), and MO-400 (Outlook) exams. To earn the Microsoft Office Specialist (MOS) Associate Certification, you must successfully complete 3 Associate level exams of your choosing.

This course offers enrollment with or without vouchers. The vouchers are prepaid access to sit for the certifying exams upon eligibility. Proctor fees may apply, which are not included.

1. Introduction to Excel
   1. Microsoft Office Basics
   2. Creating a Microsoft Excel Workbook
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Entering Data in Microsoft Excel Worksheets
   7. Formatting Microsoft Excel Worksheets
   8. Editing Worksheets
   9. Working with Rows and Columns
   10. Using Formulas in Microsoft Excel
   11. Finalizing Microsoft Excel Worksheets
   12. Introduction to Excel Exam
2. Intermediate Excel
   1. Common Functions
   2. Working with Lists
   3. Visualizing Your Data
   4. Working with Tables
   5. Advanced Formatting
   6. Intermediate Excel Exam
3. Advanced Excel
   1. Using PivotTables
   2. Advanced Functions
   3. Auditing Workbooks
   4. Data Tools
   5. Working with Others
   6. Recording and Using Macros
   7. Advanced Excel Exam
   8. Final Excel Exam
4. Introduction to Word
   1. Microsoft Office Basics
   2. Creating a Microsoft Word Document
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Formatting Microsoft Word Documents
   7. Editing Documents
   8. Finalizing Microsoft Word Documents
   9. Introduction to Word Exam
5. Intermediate Word
   1. Advanced Formatting
   2. Working with Tables
   3. Working with Images
   4. Page Layout
   5. Working with Illustrations
   6. Viewing Your Documents
   7. Intermediate Word Exam
6. Advanced Word
   1. Working with Long Documents
   2. Reviewing and Collaborating on Documents
   3. Comparing and Combining Documents
   4. Forms
   5. Managing Mailings
   6. Protecting Documents
   7. Macros
   8. Advanced Word Exam
   9. Final Word Exam
7. Introduction to PowerPoint
   1. Microsoft Office Basics
   2. Creating a Presentation
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Formatting Presentations
   7. Working with Images
   8. Working with Tables and Charts
   9. Preparing and Presenting
   10. Introduction to PowerPoint Exam
8. Advanced PowerPoint
   1. Customizing Presentations
   2. Presentation Masters
   3. Working with Special Effects
   4. Using SmartArt
   5. Multimedia
   6. Setting up the Slide Show
   7. Outlines and Slides
   8. Managing Multiple Presentations
   9. Finalizing Presentations
   10. Advanced PowerPoint Exam
   11. Final PowerPoint Exam
9. Introduction to Microsoft Outlook
   1. The Outlook Interface
   2. Working with Messages
   3. Working with the Calendar
   4. Organizing Contacts
   5. Working with Groups
   6. Introduction to Microsoft Outlook Exam
10. Advanced Microsoft Outlook
    1. Performing Popular Tasks
    2. Working with Tasks and Notes
    3. Using Signature and Themes
    4. Managing Your Inbox
    5. Working with Multiple Email Accounts
    6. Advanced Microsoft Outlook Exam
    7. Final Outlook Exam

What you will learn

• Master the crucial Microsoft Office suite skills: Word, Excel, PowerPoint, and Outlook to enhance your productivity
• Craft and refine Word documents with ease and precision
• Create visually stunning Excel spreadsheets to make data analysis engaging
• Design persuasive PowerPoint presentations to captivate audiences
• Streamline communication, scheduling, and collaboration using Outlook's powerful features

How you will benefit

• Increased employability: Enhance your resume with the widely-recognized and in-demand Microsoft Office skills, making you more attractive to potential employers
• Improved productivity: Streamline your daily tasks and processes by utilizing the various tools and features available in the Office suite
• Enhanced communication: Craft professional and visually appealing documents, presentations, and emails to clearly convey your message to colleagues and clients
• Data-driven decision-making: Leverage Excel's powerful data analysis capabilities to make informed decisions based on quantitative insights
• Efficient collaboration: Utilize Outlook and other Office applications to seamlessly collaborate with team members, share documents, and keep everyone on the same page
• Time-saving automation: Use Excel to automate repetitive tasks, saving you valuable time and reducing the risk of manual errors
• Customized solutions: Tailor PowerPoint presentations and Word documents to suit various audiences and purposes, adapting to the specific needs of your projects
• Superior organization: Manage your schedule, tasks, and contacts effectively using Outlook's calendar and task management features, ensuring you stay on top of your commitments
• Advanced reporting: Generate sophisticated reports and visualizations using Excel to better understand your data and communicate your findings
• Professional growth: Continuously develop your skills and stay relevant in the ever-evolving workplace by mastering the latest updates and features within the Microsoft Office suite

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

This in-depth course will prepare you to sit for and pass the Microsoft Office Specialist (MOS) certification exams for Word, Excel, PowerPoint, Access, and Outlook and earn your Microsoft Office Specialist (MOS) Expert Certification.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.(Windows 11 users, it is recommended to have 8-16GB of RAM for best results.)
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office 365 or 2021 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

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 available online.

Microsoft Office is the most widely used business productivity suite. Knowing how to use its products, including Word, Excel, and PowerPoint, is valuable in any professional setting. Earning your Microsoft Office Specialist (MOS) Expert certification demonstrates your knowledge of the applications and proves that you're ready to make an immediate impact at your organization.

This course prepares you for the Microsoft Office Specialist (MOS) certification exams for Word, Excel, PowerPoint, Access, and Outlook. You will build your expertise in these programs through hands-on exercises, in-depth course material, and supplemental video demonstrations. As you prepare for each exam, you will test your skills at regular intervals with quizzes and exams.

1. Introduction to Excel
   1. Microsoft Office Basics
   2. Creating a Microsoft Excel Workbook
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Entering Data in Microsoft Excel Worksheets
   7. Formatting Microsoft Excel Worksheets
   8. Editing Worksheets
   9. Working with Rows and Columns
   10. Using Formulas in Microsoft Excel
   11. Finalizing Microsoft Excel Worksheets
   12. Introduction to Excel Exam
2. Intermediate Excel
   1. Common Functions
   2. Working with Lists
   3. Visualizing Your Data
   4. Working with Tables
   5. Advanced Formatting
   6. Intermediate Excel Exam
3. Advanced Excel
   1. Using PivotTables
   2. Advanced Functions
   3. Auditing Workbooks
   4. Data Tools
   5. Working with Others
   6. Recording and Using Macros
   7. Advanced Excel Exam
   8. Final Excel Exam
4. Introduction to Word
   1. Microsoft Office Basics
   2. Creating a Microsoft Word Document
   3. The Ribbon
   4. The Quick Access Toolbar
   5. Formatting Microsoft Word Documents
   6. Editing Documents
   7. Finalizing Microsoft Word Documents
   8. Introduction to Word Exam
5. Intermediate Word
   1. Advanced Formatting
   2. Working with Tables
   3. Working with Images
   4. Page Layout
   5. Working with Illustrations
   6. Viewing Your Documents
   7. Intermediate Word Exam
6. Advanced Word
   1. Working with Long Documents
   2. Reviewing and Collaborating on Documents
   3. Comparing and Combining Documents
   4. Forms
   5. Managing Mailings
   6. Protecting Documents
   7. Macros
   8. Advanced Word Exam
   9. Final Word Exam
7. Introduction to PowerPoint
   1. Microsoft Office Basics
   2. Creating a Presentation
   3. The Ribbon
   4. The Quick Access Toolbar
   5. Formatting Presentations
   6. Working with Images
   7. Working with Tables and Charts
   8. Preparing and Presenting
   9. Introduction to PowerPoint Exam
8. Advanced PowerPoint
   1. Customizing Presentations
   2. Presentation Masters
   3. Working with Special Effects
   4. Using SmartArt
   5. Multimedia
   6. Setting up the Slide Show
   7. Outlines and Slides
   8. Managing Multiple Presentations
   9. Finalizing Presentations
   10. Advanced PowerPoint Exam
   11. Final PowerPoint Exam
9. Introduction to Microsoft Outlook
   1. The Outlook Interface
   2. Working with Messages
   3. Working with the Calendar
   4. Organizing Contacts
   5. Working with Groups
   6. Introduction to Microsoft Outlook Exam
10. Advanced Microsoft Outlook
    1. Performing Popular Tasks
    2. Working with Tasks and Notes
    3. Using Signature and Themes
    4. Managing Your Inbox
    5. Working with Multiple Email Accounts
    6. Advanced Microsoft Outlook Exam
    7. Final Outlook Exam
11. Introduction to Microsoft Access
    1. Databases and Access Terms
    2. Quick Overview of the Access User Interface
    3. Fundamentals
    4. Tables and Their Views
    5. Tables
    6. Queries
    7. Forms
    8. Reports
    9. Introduction to Access Final Exam
12. Advanced Microsoft Access
    1. Relationships
    2. Queries
    3. Table Functions
    4. Advanced Forms
    5. Advanced Reports
    6. Macros
    7. Completing the Desktop Application
    8. Advanced Access Final Exam
    9. Access Final Access Exam

What you will learn

• Master the crucial Microsoft Office suite skills: Word, Excel, PowerPoint, Access, and Outlook to enhance your productivity
• Craft and refine Word documents with ease and precision
• Create visually stunning Excel spreadsheets to make data analysis engaging
• Design persuasive PowerPoint presentations to captivate audiences
• Optimize database management and boost efficiency with Access
• Streamline communication, scheduling, and collaboration using Outlook's powerful features

How you will benefit

• Increased employability: Enhance your resume with the widely-recognized and in-demand Microsoft Office skills, making you more attractive to potential employers
• Improved productivity: Streamline your daily tasks and processes by utilizing the various tools and features available in the Office suite
• Enhanced communication: Craft professional and visually appealing documents, presentations, and emails to clearly convey your message to colleagues and clients
• Data-driven decision-making: Leverage Excel's powerful data analysis capabilities to make informed decisions based on quantitative insights
• Efficient collaboration: Utilize Outlook and other Office applications to seamlessly collaborate with team members, share documents, and keep everyone on the same page
• Time-saving automation: Use Excel and Access to automate repetitive tasks, saving you valuable time and reducing the risk of manual errors
• Customized solutions: Tailor PowerPoint presentations and Word documents to suit various audiences and purposes, adapting to the specific needs of your projects
• Superior organization: Manage your schedule, tasks, and contacts effectively using Outlook's calendar and task management features, ensuring you stay on top of your commitments
• Advanced reporting: Generate sophisticated reports and visualizations using Excel and Access to better understand your data and communicate your findings
• Professional growth: Continuously develop your skills and stay relevant in the ever-evolving workplace by mastering the latest updates and features within the Microsoft Office suite

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

Prepare for the Microsoft Office Specialist (MOS) certification exams for Word, Excel, PowerPoint, Outlook, and Access and earn your Microsoft Office Specialist (MOS) Expert Certification. Exam fees included for five exams.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.(Windows 11 users, it is recommended to have 8-16GB of RAM for best results.)
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office 365 or 2021 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

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 available online.

Microsoft Office is the most widely used business productivity suite. Knowing how to use its products, including Word, Excel, and PowerPoint, is valuable in any professional setting. Earning your Microsoft Office Specialist (MOS) Expert certification demonstrates your knowledge of the applications and proves that you are ready to make an immediate impact at your organization.

This course prepares you for the Microsoft Office Specialist (MOS) certification exams for Word, Excel, PowerPoint, Access, and Outlook. You will build your expertise in these programs through hands-on exercises, in-depth course material, and supplemental video demonstrations. As you prepare for each exam, you will test your skills at regular intervals with quizzes and exams.

This course offers enrollment with or without vouchers. The vouchers are prepaid access to sit for five certifying exams of your choosing upon eligibility. Proctor fees may apply, which are not included.

1. Introduction to Excel
   1. Microsoft Office Basics
   2. Creating a Microsoft Excel Workbook
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Entering Data in Microsoft Excel Worksheets
   7. Formatting Microsoft Excel Worksheets
   8. Editing Worksheets
   9. Working with Rows and Columns
   10. Using Formulas in Microsoft Excel
   11. Finalizing Microsoft Excel Worksheets
   12. Introduction to Excel Exam
2. Intermediate Excel
   1. Common Functions
   2. Working with Lists
   3. Visualizing Your Data
   4. Working with Tables
   5. Advanced Formatting
   6. Intermediate Excel Exam
3. Advanced Excel
   1. Using PivotTables
   2. Advanced Functions
   3. Auditing Workbooks
   4. Data Tools
   5. Working with Others
   6. Recording and Using Macros
   7. Advanced Excel Exam
   8. Final Excel Exam
4. Introduction to Word
   1. Microsoft Office Basics
   2. Creating a Microsoft Word Document
   3. The Ribbon
   4. The Quick Access Toolbar
   5. Formatting Microsoft Word Documents
   6. Editing Documents
   7. Finalizing Microsoft Word Documents
   8. Introduction to Word Exam
5. Intermediate Word
   1. Advanced Formatting
   2. Working with Tables
   3. Working with Images
   4. Page Layout
   5. Working with Illustrations
   6. Viewing Your Documents
   7. Intermediate Word Exam
6. Advanced Word
   1. Working with Long Documents
   2. Reviewing and Collaborating on Documents
   3. Comparing and Combining Documents
   4. Forms
   5. Managing Mailings
   6. Protecting Documents
   7. Macros
   8. Advanced Word Exam
   9. Final Word Exam
7. Introduction to PowerPoint
   1. Microsoft Office Basics
   2. Creating a Presentation
   3. The Ribbon
   4. The Quick Access Toolbar
   5. Formatting Presentations
   6. Working with Images
   7. Working with Tables and Charts
   8. Preparing and Presenting
   9. Introduction to PowerPoint Exam
8. Advanced PowerPoint
   1. Customizing Presentations
   2. Presentation Masters
   3. Working with Special Effects
   4. Using SmartArt
   5. Multimedia
   6. Setting up the Slide Show
   7. Outlines and Slides
   8. Managing Multiple Presentations
   9. Finalizing Presentations
   10. Advanced PowerPoint Exam
   11. Final PowerPoint Exam
9. Introduction to Microsoft Outlook
   1. The Outlook Interface
   2. Working with Messages
   3. Working with the Calendar
   4. Organizing Contacts
   5. Working with Groups
   6. Introduction to Microsoft Outlook Exam
10. Advanced Microsoft Outlook
    1. Performing Popular Tasks
    2. Working with Tasks and Notes
    3. Using Signature and Themes
    4. Managing Your Inbox
    5. Working with Multiple Email Accounts
    6. Advanced Microsoft Outlook Exam
    7. Final Outlook Exam
11. Introduction to Microsoft Access
    1. Databases and Access Terms
    2. Quick Overview of the Access User Interface
    3. Fundamentals
    4. Tables and Their Views
    5. Tables
    6. Queries
    7. Forms
    8. Reports
    9. Introduction to Access Final Exam
12. Advanced Microsoft Access
    1. Relationships
    2. Queries
    3. Table Functions
    4. Advanced Forms
    5. Advanced Reports
    6. Macros
    7. Completing the Desktop Application
    8. Advanced Access Final Exam
    9. Access Final Access Exam

What you will learn

• Master the crucial Microsoft Office suite skills: Word, Excel, PowerPoint, Access, and Outlook to enhance your productivity
• Craft and refine Word documents with ease and precision
• Create visually stunning Excel spreadsheets to make data analysis engaging
• Design persuasive PowerPoint presentations to captivate audiences
• Optimize database management and boost efficiency with Access
• Streamline communication, scheduling, and collaboration using Outlook's powerful features

How you will benefit

• Increased employability: Enhance your resume with the widely-recognized and in-demand Microsoft Office skills, making you more attractive to potential employers
• Improved productivity: Streamline your daily tasks and processes by utilizing the various tools and features available in the Office suite
• Enhanced communication: Craft professional and visually appealing documents, presentations, and emails to clearly convey your message to colleagues and clients
• Data-driven decision-making: Leverage Excel's powerful data analysis capabilities to make informed decisions based on quantitative insights
• Efficient collaboration: Utilize Outlook and other Office applications to seamlessly collaborate with team members, share documents, and keep everyone on the same page
• Time-saving automation: Use Excel and Access to automate repetitive tasks, saving you valuable time and reducing the risk of manual errors
• Customized solutions: Tailor PowerPoint presentations and Word documents to suit various audiences and purposes, adapting to the specific needs of your projects
• Superior organization: Manage your schedule, tasks, and contacts effectively using Outlook's calendar and task management features, ensuring you stay on top of your commitments
• Advanced reporting: Generate sophisticated reports and visualizations using Excel and Access to better understand your data and communicate your findings
• Professional growth: Continuously develop your skills and stay relevant in the ever-evolving workplace by mastering the latest updates and features within the Microsoft Office suite

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

This online Microsoft Outlook Certification Training course will prepare you to take the Microsoft Office Specialist Outlook Certification exam.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Outlook 365 or 2021 (not included in enrollment). You can use either of these versions of Outlook for the course. Please note: The course is designed using Microsoft Outlook 365 Desktop Enterprise Version using the New (not Classic) interface, which is updated regularly, so there may be some slight differences between your version and what you see in the course, but the core concepts and functionalities covered will remain consistent.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

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.

Across industries, Microsoft Outlook is one of the most widely used desktop email clients. Businesses of all sizes rely on Outlook to communicate internally and externally, schedule meetings and manage contacts. If you use Outlook, becoming a Microsoft Office Specialist (MOS) in Outlook is an important step in your career.

Upon completion of this course, you will be fully prepared to sit for and pass the Microsoft Office Specialist Outlook Certification exam. This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility. Proctor fees may apply, which are not included.

1. Microsoft Outlook
   1. Introduction to Microsoft Outlook Training
      1. The Outlook Interface
      2. Working with Messages
      3. Working with the Calendar
      4. Organizing Contacts
      5. Working with Groups
      6. EXAM: Introduction to Microsoft Outlook Exam
   2. Advanced Microsoft Outlook Training
      1. Performing Popular Tasks
      2. Working with Tasks and Notes
      3. Using Signature and Themes
      4. Managing Your Inbox
      5. Working with Multiple Email Accounts
      6. EXAM: Advanced Microsoft Outlook Exam
   3. FINAL EXAM: Microsoft Outlook Final Exam

What you will learn

• Several new features in Outlook
• Best practices for Ribbon, Tabs, Groups, and Commands Explore the Backstage View
• Set up accounts and work with messages
• Manage your inbox including filtering, creating search folders, and archiving
• Work with multiple accounts

How you will benefit

• Learn to use all of the features in Microsoft Outlook
• Be prepared to take the Microsoft Office Specialist Outlook Certification exam
• Ability to earn a higher salary than non-certified peers

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

This online Microsoft Outlook Certification Training course will prepare you to take the Microsoft Office Specialist Outlook Certification exam.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Outlook 365 or 2021 (not included in enrollment). You can use either of these versions of Outlook for the course. Please note: The course is designed using Microsoft Outlook 365 Desktop Enterprise Version using the New (not Classic) interface, which is updated regularly, so there may be some slight differences between your version and what you see in the course, but the core concepts and functionalities covered will remain consistent.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

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.

Across industries, Microsoft Outlook is one of the most widely used desktop email clients. Businesses of all sizes rely on Outlook to communicate internally and externally, schedule meetings and manage contacts. If you use Outlook, becoming a Microsoft Office Specialist (MOS) in Outlook is an important step in your career.

Upon completion of this course, you will be fully prepared to sit for and pass the Microsoft Office Specialist Outlook Certification exam. This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility. Proctor fees may apply, which are not included.

1. Microsoft Outlook
   1. Introduction to Microsoft Outlook Training
      1. The Outlook Interface
      2. Working with Messages
      3. Working with the Calendar
      4. Organizing Contacts
      5. Working with Groups
      6. EXAM: Introduction to Microsoft Outlook Exam
   2. Advanced Microsoft Outlook Training
      1. Performing Popular Tasks
      2. Working with Tasks and Notes
      3. Using Signature and Themes
      4. Managing Your Inbox
      5. Working with Multiple Email Accounts
      6. EXAM: Advanced Microsoft Outlook Exam
   3. FINAL EXAM: Microsoft Outlook Final Exam

What you will learn

• Several new features in Outlook
• Best practices for Ribbon, Tabs, Groups, and Commands Explore the Backstage View
• Set up accounts and work with messages
• Manage your inbox including filtering, creating search folders, and archiving
• Work with multiple accounts

How you will benefit

• Learn to use all of the features in Microsoft Outlook
• Be prepared to take the Microsoft Office Specialist Outlook Certification exam
• Ability to earn a higher salary than non-certified peers

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

This Microsoft PowerPoint MOS Certification Training course will prepare you for the Microsoft Office Specialist PowerPoint Certification exam.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office 365, 2021, or 2019 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment.

Being a MOS Certified PowerPoint user builds credibility with your current or future employers and increases your employability and your opportunities for career advancement. That is because PowerPoint training and certification sets a standard and exemplifies your ability to learn new tools and new tricks and to execute tasks efficiently. According to Microsoft, individuals with a MOS certification can earn 15% higher salaries than their non-certified peers.

This course will teach you how to use Microsoft PowerPoint and prepare you for the Microsoft Office Specialist PowerPoint Certification exam. You will learn to create and modify basic presentations using PowerPoint. You will explore the PowerPoint environment, create a presentation, format text on slides to enhance clarity, and add graphical objects to a presentation and modify them.

Upon completion of this course, you will be fully prepared for the Microsoft Office Specialist PowerPoint Certification exam. This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Introduction to PowerPoint
   1. Microsoft Office Basics
   2. Creating a Presentation
   3. The Ribbon
   4. The Quick Access Toolbar
   5. The Backstage View (The File Menu)
   6. Formatting Presentations
   7. Working with Images
   8. Working with Tables and Charts
   9. Preparing and Presenting
   10. Introduction to PowerPoint Exam
2. Advanced PowerPoint
   1. Customizing Presentations
   2. Presentation Masters
   3. Working with Special Effects
   4. Using SmartArt
   5. Multimedia
   6. Setting up the Slide Show
   7. Outlines and Slides
   8. Managing Multiple Presentations
   9. Finalizing Presentations
   10. Advanced PowerPoint Exam
3. Final Exam

What you will learn

• Navigate the PowerPoint interface and find important tools, add shortcuts to find frequently used features quickly, and leverage built-in PowerPoint templates
• Add engaging, organized content to your slides including text, images, shapes, tables, and charts
• Use the Outline tab to stay organized, and the Slide Sorter to reorganize a presentation quickly
• Print various components of a presentation for easy sharing
• Run a slideshow with confidence
• Work with themes, styles, footers, and sections to customize your presentation
• Use the Presentation Masters to ensure consistency throughout your slides, notes, and handouts
• Add special effects appropriately and professionally and save time by using the format painter
• Create, edit, and import graphic elements and multimedia
• Merge presentations and reuse slides from multiple sources to save time
• Minimize technical issues when sharing your presentation with remote audiences
• Embed fonts, compress graphics, and check for compatibility and accessibility for easier distribution
• Protect your presentation with powerful security features

How you will benefit

• Streamline your daily tasks and processes by utilizing the various tools and features available in PowerPoint
• Customize PowerPoint presentations to suit various audiences and purposes, adapting to the specific needs of your projects
• Continuously develop your skills and stay relevant in the ever-evolving workplace by mastering the latest updates and features within PowerPoint
• Enhance your presentation creation process by becoming proficient in PowerPoint's tools and shortcuts, allowing for swift and seamless navigation throughout the software

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

This online Microsoft Certification training course will prepare you for the Microsoft Office Specialist PowerPoint Certification exam. Exam voucher included.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office 365, 2021, or 2019 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment.

Being a MOS Certified PowerPoint user builds credibility with your current or future employers and increases your employability and your opportunities for career advancement. That is because PowerPoint training and certification sets a standard and exemplifies your ability to learn new tools and new tricks and to execute tasks efficiently. According to Microsoft, individuals with a MOS certification can earn 15% higher salaries than their non-certified peers.

This course will teach you how to use Microsoft PowerPoint and prepare you for the Microsoft Office Specialist PowerPoint Certification exam. You will learn to create and modify basic presentations using PowerPoint. You will explore the PowerPoint environment, create a presentation, format text on slides to enhance clarity, and add graphical objects to a presentation and modify them.

Upon completion of this course, you will be fully prepared for the Microsoft Office Specialist PowerPoint Certification exam. This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Introduction to PowerPoint
   1. Microsoft Office Basics
   2. Creating a Presentation
   3. The Ribbon
   4. The Quick Access Toolbar
   5. The Backstage View (The File Menu)
   6. Formatting Presentations
   7. Working with Images
   8. Working with Tables and Charts
   9. Preparing and Presenting
   10. Introduction to PowerPoint Exam
2. Advanced PowerPoint
   1. Customizing Presentations
   2. Presentation Masters
   3. Working with Special Effects
   4. Using SmartArt
   5. Multimedia
   6. Setting up the Slide Show
   7. Outlines and Slides
   8. Managing Multiple Presentations
   9. Finalizing Presentations
   10. Advanced PowerPoint Exam
3. Final Exam

What you will learn

• Navigate the PowerPoint interface and find important tools, add shortcuts to find frequently used features quickly, and leverage built-in PowerPoint templates
• Add engaging, organized content to your slides including text, images, shapes, tables, and charts
• Use the Outline tab to stay organized, and the Slide Sorter to reorganize a presentation quickly
• Print various components of a presentation for easy sharing
• Run a slideshow with confidence
• Work with themes, styles, footers, and sections to customize your presentation
• Use the Presentation Masters to ensure consistency throughout your slides, notes, and handouts
• Add special effects appropriately and professionally and save time by using the format painter
• Create, edit, and import graphic elements and multimedia
• Merge presentations and reuse slides from multiple sources to save time
• Minimize technical issues when sharing your presentation with remote audiences
• Embed fonts, compress graphics, and check for compatibility and accessibility for easier distribution
• Protect your presentation with powerful security features

How you will benefit

• Streamline your daily tasks and processes by utilizing the various tools and features available in PowerPoint
• Customize PowerPoint presentations to suit various audiences and purposes, adapting to the specific needs of your projects
• Continuously develop your skills and stay relevant in the ever-evolving workplace by mastering the latest updates and features within PowerPoint
• Enhance your presentation creation process by becoming proficient in PowerPoint's tools and shortcuts, allowing for swift and seamless navigation throughout the software

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

Master the basics of Microsoft SharePoint 365—from working with lists, libraries, and forms to page customization, managing sites, site permissions, and users!

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 11 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft SharePoint 365 (not included)
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

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.

This Microsoft SharePoint training will help you build the skills you need to work in a SharePoint 365 environment. As the most popular content management system (CMS), learning SharePoint features is valuable for any individual regardless of your organization or industry.

Through this SharePoint course, you will be equipped with essential skills, so you can navigate team sites, manage lists and libraries, and create columns, content types, and views. When you successfully learn SharePoint you will increase your efficiency in document management and seamlessly empower collaboration across your organization.

1. Microsoft SharePoint Online
1. SharePoint Online End User Training
   1. Setup
   2. Introduction
   3. List Basics
   4. Library Basics
   5. Working With List Library Views
   6. Working With Sites
   7. Page Content
   8. Site Columns and Content Types
   9. Office Integration
   10. Managing SharePoint Site Permissions
2. SharePoint Online Power User Training
   1. Communications Site
   2. Hub Sites
   3. Managed Metadata
   4. Content Approval
   5. Custom Forms and Power Apps
   6. Information Management Policy
   7. Content Organizer
   8. Document ID Service
   9. Document Sets
3. FINAL EXAM: SharePoint Online Exam

What you will learn

• SharePoint versions, layouts, and navigation
• Content approval settings, site permissions, user communities
• Information management policies
• Creating custom workflows and InfoPath forms
• Navigating business connectivity services
• Working with metadata

How you will benefit

• Gain the skills needed to work within and manage SharePoint sites
• Master SharePoint and bring these in-demand workplace skills to any office
• Boost your collaboration, content management efficiency, and ability to automate workflows

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

This Microsoft Certification training course prepares you for the Microsoft Office Specialist Expert exam for Microsoft Word.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office 365, 2021 or 2019 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment.

Successfully completing your Microsoft Word training and becoming certified demonstrates mastery of one of the most desired workplace software skills by employers of any industry. Adding this credential to your resume sets your professional profile apart from the casual Word user. It validates your skills and proficiency as well as demonstrates your initiative and dedication.

This Microsoft Word course will prepare you for the Microsoft Office Specialist (MOS) Expert certification exam for Microsoft Word. You will learn to create, edit, format, and print Microsoft Word documents. You will then move on to learn advanced formatting, use Word drawing tools, create and manage tables, and work with column layouts. You will also learn more advanced techniques, such as working with tables of contents, footnotes, and endnotes, adding comments, tracking changes, comparing and combining documents, creating envelopes and labels, using Mail Merge, and protecting documents.

Upon completion of this course, you will be prepared for the Microsoft Office Specialist Expert certification exam for Word. This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Introduction to Word
   1. Microsoft Office Basics
   2. Creating a Microsoft Word Document
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Formatting Microsoft Word Documents
   7. Editing Documents
   8. Finalizing Microsoft Word Documents
   9. Introduction to Word Exam
2. Intermediate Word
   1. Advanced Formatting
   2. Working with Tables
   3. Working with Images
   4. Page Layout
   5. Working with Illustrations
   6. Viewing Your Documents
   7. Intermediate Word Exam
3. Advanced Word
   1. Working with Long Documents
   2. Reviewing and Collaborating on Documents
   3. Comparing and Combining Documents
   4. Forms
   5. Managing Mailings
   6. Protecting Documents
   7. Macros
   8. Advanced Word Exam
4. Final Exam

What you will learn

• Create and edit Microsoft Word documents
• Find tools and features using the Ribbon and use the Quick Access Toolbar to expedite your work
• Use the File tab to find key features like open, print, properties, and recent files.
• Build impressive new documents using Word templates
• Format text and other elements to keep your documents clear, organized, and easy to read, and automate repetitive tasks using macros
• Use Styles to adjust the appearance of your text, add page numbers, headers, and footers, and adjust page layout to create clear, readable documents quickly and correctly
• Use spell check and grammar check to create error-free documents
• Use tables to manage and organize information, add and edit columns to sort information easily, and manage page breaks and section breaks
• Create professional-looking documents with advanced editing tools
• Master best practices for working with images, logos, and other visuals, including placement, sizing, text wraps, borders, and effects
• Leverage document views, the navigation pane, and multiple window options to work more efficiently
• Create easy-to-navigate documents with tables of contents, indexes, and outlines.
• Use citation tools, including footnotes, endnotes, and bibliographies
• Save time by learning to compare and combine documents and collaborate effectively using comments and track changed
• Use correspondence tools for creating mail merges, envelopes, and labels.
• Protect your documents with read-only settings, watermarks, and other security features.
• Easily prepare your documents for any audience with internationalization and accessibility tools

How you will benefit

• Enhance your resume with widely-recognized and in-demand Microsoft Word skills, making you more attractive to potential employers
• Craft professional and visually appealing documents to clearly convey your message to colleagues and clients
• Customize Word documents to suit various audiences and purposes, adapting to the specific needs of your projects
• Improve your workflow by learning Word's essential tools and shortcuts, enabling you to work more efficiently and effectively

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

This Microsoft Certification training course prepares you for the Microsoft Office Specialist Expert exam for Microsoft Word. Exam voucher included.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office 365, 2021 or 2019 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment.

Successfully completing your Microsoft Word training and becoming certified demonstrates mastery of one of the most desired workplace software skills by employers of any industry. Adding this credential to your resume sets your professional profile apart from the casual Word user. It validates your skills and proficiency as well as demonstrates your initiative and dedication.

This Microsoft Word course will prepare you for the Microsoft Office Specialist (MOS) Expert certification exam for Microsoft Word. You will learn to create, edit, format, and print Microsoft Word documents. You will then move on to learn advanced formatting, use Word drawing tools, create and manage tables, and work with column layouts. You will also learn more advanced techniques, such as working with tables of contents, footnotes, and endnotes, adding comments, tracking changes, comparing and combining documents, creating envelopes and labels, using Mail Merge, and protecting documents.

Upon completion of this course, you will be prepared for the Microsoft Office Specialist Expert certification exam for Word. This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Introduction to Word
   1. Microsoft Office Basics
   2. Creating a Microsoft Word Document
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Formatting Microsoft Word Documents
   7. Editing Documents
   8. Finalizing Microsoft Word Documents
   9. Introduction to Word Exam
2. Intermediate Word
   1. Advanced Formatting
   2. Working with Tables
   3. Working with Images
   4. Page Layout
   5. Working with Illustrations
   6. Viewing Your Documents
   7. Intermediate Word Exam
3. Advanced Word
   1. Working with Long Documents
   2. Reviewing and Collaborating on Documents
   3. Comparing and Combining Documents
   4. Forms
   5. Managing Mailings
   6. Protecting Documents
   7. Macros
   8. Advanced Word Exam
4. Final Exam

What you will learn

• Create and edit Microsoft Word documents
• Find tools and features using the Ribbon and use the Quick Access Toolbar to expedite your work
• Use the File tab to find key features like open, print, properties, and recent files.
• Build impressive new documents using Word templates
• Format text and other elements to keep your documents clear, organized, and easy to read, and automate repetitive tasks using macros
• Use Styles to adjust the appearance of your text, add page numbers, headers, and footers, and adjust page layout to create clear, readable documents quickly and correctly
• Use spell check and grammar check to create error-free documents
• Use tables to manage and organize information, add and edit columns to sort information easily, and manage page breaks and section breaks
• Create professional-looking documents with advanced editing tools
• Master best practices for working with images, logos, and other visuals, including placement, sizing, text wraps, borders, and effects
• Leverage document views, the navigation pane, and multiple window options to work more efficiently
• Create easy-to-navigate documents with tables of contents, indexes, and outlines.
• Use citation tools, including footnotes, endnotes, and bibliographies
• Save time by learning to compare and combine documents and collaborate effectively using comments and track changed
• Use correspondence tools for creating mail merges, envelopes, and labels.
• Protect your documents with read-only settings, watermarks, and other security features.
• Easily prepare your documents for any audience with internationalization and accessibility tools

How you will benefit

• Enhance your resume with widely-recognized and in-demand Microsoft Word skills, making you more attractive to potential employers
• Craft professional and visually appealing documents to clearly convey your message to colleagues and clients
• Customize Word documents to suit various audiences and purposes, adapting to the specific needs of your projects
• Improve your workflow by learning Word's essential tools and shortcuts, enabling you to work more efficiently and effectively

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

Acquire the skills you need to make the most of QuickBooks Online. This course will help you understand how to get your business finances in order and save time with this powerful and useful tool. This course also serves as preparation for the QuickBooks Certified User exam.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC, Mac, or Chromebook.

Software Requirements:

• PC: Windows 10 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• QuickBooks Online (Free 1-year subscription and practice site included in enrollment.) An additional subscription or software purchase for QuickBooks Online is not required to complete this course. However, please note that this course is only suitable for the QuickBooks Online version.
• Adobe Acrobat Reader.
• Microsoft Word or equivalent.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment. The following textbooks will be shipped to you approximately 7-10 business days after enrollment:

• Bookkeeping for Dummies, 2nd Edition, by Lita Epstein, MBA
• QuickBooks online software
  • Your enrollment in this course includes a free 1-year full subscription to QuickBooks Online. You will learn how to access and activate this subscription in one of your assignments.

Please note: You will receive a digital book if the physical book is on backorder.

Master QuickBooks Online to prepare for a rewarding career in the bookkeeping field. You will learn basic bookkeeping and accounting principles, including the types of accounting information you, the business owner, manager, bookkeeper, or accountant, need to monitor. You'll then put all those principles into practice using QuickBooks Online to enter and track your finances with ease. With this online version, you get all the advantages of computing in the cloud so that your files will be available to you virtually anytime, anywhere.

This course will give you hands-on experience using QuickBooks Online to manage your business' finances—from recording income and expenses to entering checks and bank transfers to setting up a chart of accounts. You'll see how to reconcile your checking account and manage credit card and loan payments; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create estimates; generate reports; and much more. Once you complete this course, you will understand how to get your finances in order and be prepared for the QuickBooks Certified User Exam.

1. Introduction to Bookkeeping
2. Accounting Basics
3. Getting Started With QuickBooks Online
4. The Chart of Accounts
5. Centers and Lists
6. Bank Accounts
7. Recording Expenses and Paying Bills
8. Credit Cards and Loans
9. Sales Receipts
10. Invoices, Estimates, and Customizing Sales Forms
11. Billable Expenses and Customer Credits
12. Sales Taxes and Reports
13. Midterm Exam
14. Product and Service Items
15. Managing Inventory
16. Managing Projects and Sales
17. Progress Invoicing, Late Fees, and Bad Debts
18. Payroll
19. Fixed Assets and Loans
20. Business Entities and Owner Transactions
21. Banking Rules, Receipts, and Budgets
22. Adjusting and Reviewing the Books
23. Starting a Bookkeeping Business
24. Your Career Roadmap: The Job Search and Future Opportunities (Optional Lesson)
25. Communication and Organization (Optional Lesson)
26. Final Exam

What you will learn

• Successfully set up a company file in QuickBooks Online.
• Perform fundamental analysis of accounts, financial documents, and reports.
• Perform essential bookkeeping duties and tasks.
• Apply basic accounting principles (accrual method, depreciation, and so on) to bookkeeping practices.
• Understand fundamental accounting concepts and how QuickBooks works to support these concepts.

How you will benefit

• Gain confidence in your ability to use QuickBooks to perform bookkeeping tasks for any company
• Use basic, intermediate, and advanced features of QuickBooks Online proficiently
• Prepare for the QBCU Exam

Scott Paxton

Scott Paxton is a Certified Public Accountant and holds master's degrees in business administration and accounting. His background includes experience as a public accountant, a manager in the banking industry, an entrepreneur and a college business instructor. Paxton has also spent much of his career helping small business owners successfully optimize their business operations, budgets and strategic plans.

Wade Lindenberger

Wade Lindenberger is a CPA with over 20 years of financial accounting and management experience in public accounting and private industry. He is currently Director of Finance and Administration for New Children's Museum. Before his current position, he worked as the National Finance and Accounting Service Line Leader for Premier Alliance Group, a national professional services firm. Wade was also Director of the Finance and Accounting service line for the San Diego office of a global, publicly held professional services firm. Before becoming a consultant, Wade was Divisional Controller for one of the leading health and fitness club chains in the world. He has also been Internal Audit Manager and Divisional Controller for a division of a Fortune 500 global energy project management company. He began his career with Coopers & Lybrand, a predecessor to PricewaterhouseCoopers, one of the "Big Four" CPA firms. He has previously served as an instructor for courses at Coopers & Lybrand and UC San Diego. He is currently an adjunct professor at the University of San Diego School of Business. He is a member of the American Institute of Certified Bookkeepers' Advisory Board.

Helene K. Liatsos

Helene K. Liatsos is a consultant for small businesses, travel agencies, and home-based business startups with more than 25 years of experience. Along with a successful career in the travel industry, working with airlines, hotels, and travel agencies, Helene established her own business management company, Home Office Management Experts, and was awarded the 2004 Home-Based Business of the Year by the U.S. Small Business Administration. As a QuickBooks Certified Advisor, she provides bookkeeping, payroll and QuickBooks training services. She holds a Bachelor of Arts from Fairleigh Dickinson University.

Sherida Habersham

Sherida Habersham is an accomplished professional from Georgia at the intersection of technology, education, and service. She started her career as a software developer specializing in human resource management (HRM), payroll, and quality systems. Over her extensive career in education, Sherida has held several roles, including program lead, college professor, and division dean for business and information systems.

Sherida holds a Doctor of Philosophy (Ph.D.) in educational psychology, a Master of Science in computer science, and a Master of Business Administration in business. With expertise in curriculum development, business systems, and instructional leadership, she is dedicated to promoting learning and development. Additionally, she has over a decade of experience as a bookkeeping and tax expert, assisting small and medium-sized businesses (SMBs) in streamlining their operations with comprehensive bookkeeping and tax support.

Acquire the skills you need to make the most of QuickBooks Online. This course will help you understand how to get your business finances in order and save time with this powerful and useful tool. This course also serves as preparation for the QuickBooks Certified User exam.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC, Mac, or Chromebook.

Software Requirements:

• PC: Windows 10 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• QuickBooks Online (Free 1-year subscription and practice site included in enrollment.) An additional subscription or software purchase for QuickBooks Online is not required to complete this course. However, please note that this course is only suitable for the QuickBooks Online version.
• Adobe Acrobat Reader.
• Microsoft Word or equivalent.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment. The following textbooks will be shipped to you approximately 7-10 business days after enrollment:

• Bookkeeping for Dummies, 2nd Edition
• QuickBooks Online software
  • Your enrollment in this course includes a free 1-year full subscription to QuickBooks Online. You will learn how to access and activate this subscription in one of your assignments.

Please note: You will receive a digital book if the physical book is on backorder.

Master QuickBooks Online to prepare for a rewarding career in the bookkeeping field. You will learn basic bookkeeping and accounting principles, including the types of accounting information you, the business owner, manager, bookkeeper, or accountant, need to monitor. You'll then put all those principles into practice using QuickBooks Online to enter and track your finances with ease. With this online version, you get all the advantages of computing in the cloud so that your files will be available to you virtually anytime, anywhere.

This course will give you hands-on experience using QuickBooks Online to manage your business' finances—from recording income and expenses to entering checks and bank transfers to setting up a chart of accounts. You'll see how to reconcile your checking account and manage credit card and loan payments; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create estimates; generate reports; and much more. Once you complete this course, you will understand how to get your finances in order and be prepared for the QuickBooks Certified User Exam.

This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the QuickBooks Certified User Exam upon eligibility. Proctor fees may apply, which are not included.

1. Introduction to Bookkeeping
2. Accounting Basics
3. Getting Started With QuickBooks Online
4. The Chart of Accounts
5. Centers and Lists
6. Bank Accounts
7. Recording Expenses and Paying Bills
8. Credit Cards and Loans
9. Sales Receipts
10. Invoices, Estimates, and Customizing Sales Forms
11. Billable Expenses and Customer Credits
12. Sales Taxes and Reports
13. Midterm Exam
14. Product and Service Items
15. Managing Inventory
16. Managing Projects and Sales
17. Progress Invoicing, Late Fees, and Bad Debts
18. Payroll
19. Fixed Assets and Loans
20. Business Entities and Owner Transactions
21. Banking Rules, Receipts, and Budgets
22. Adjusting and Reviewing the Books
23. Starting a Bookkeeping Business
24. Your Career Roadmap: The Job Search and Future Opportunities (Optional Lesson)
25. Communication and Organization (Optional Lesson)
26. Final Exam

What you will learn

• Successfully set up a company file in QuickBooks Online.
• Perform fundamental analysis of accounts, financial documents, and reports.
• Perform essential bookkeeping duties and tasks.
• Apply basic accounting principles (accrual method, depreciation, and so on) to bookkeeping practices.
• Understand fundamental accounting concepts and how QuickBooks works to support these concepts.

How you will benefit

• Gain confidence in your ability to use QuickBooks to perform bookkeeping tasks for any company
• Use basic, intermediate, and advanced features of QuickBooks Online proficiently
• Prepare for the QBCU Exam

Scott Paxton

Scott Paxton is a Certified Public Accountant and holds master's degrees in business administration and accounting. His background includes experience as a public accountant, a manager in the banking industry, an entrepreneur and a college business instructor. Paxton has also spent much of his career helping small business owners successfully optimize their business operations, budgets and strategic plans.

Wade Lindenberger

Wade Lindenberger is a CPA with over 20 years of financial accounting and management experience in public accounting and private industry. He is currently Director of Finance and Administration for New Children's Museum. Before his current position, he worked as the National Finance and Accounting Service Line Leader for Premier Alliance Group, a national professional services firm. Wade was also Director of the Finance and Accounting service line for the San Diego office of a global, publicly held professional services firm. Before becoming a consultant, Wade was Divisional Controller for one of the leading health and fitness club chains in the world. He has also been Internal Audit Manager and Divisional Controller for a division of a Fortune 500 global energy project management company. He began his career with Coopers & Lybrand, a predecessor to PricewaterhouseCoopers, one of the "Big Four" CPA firms. He has previously served as an instructor for courses at Coopers & Lybrand and UC San Diego. He is currently an adjunct professor at the University of San Diego School of Business. He is a member of the American Institute of Certified Bookkeepers' Advisory Board.

Helene K. Liatsos

Helene K. Liatsos is a consultant for small businesses, travel agencies, and home-based business startups with more than 25 years of experience. Along with a successful career in the travel industry, working with airlines, hotels, and travel agencies, Helene established her own business management company, Home Office Management Experts, and was awarded the 2004 Home-Based Business of the Year by the U.S. Small Business Administration. As a QuickBooks Certified Advisor, she provides bookkeeping, payroll and QuickBooks training services. She holds a Bachelor of Arts from Fairleigh Dickinson University.

Sherida Habersham

Sherida Habersham is an accomplished professional from Georgia at the intersection of technology, education, and service. She started her career as a software developer specializing in human resource management (HRM), payroll, and quality systems. Over her extensive career in education, Sherida has held several roles, including program lead, college professor, and division dean for business and information systems.

Sherida holds a Doctor of Philosophy (Ph.D.) in educational psychology, a Master of Science in computer science, and a Master of Business Administration in business. With expertise in curriculum development, business systems, and instructional leadership, she is dedicated to promoting learning and development. Additionally, she has over a decade of experience as a bookkeeping and tax expert, assisting small and medium-sized businesses (SMBs) in streamlining their operations with comprehensive bookkeeping and tax support.