Online Courses   

Gain a marketable new skill by learning the basics of double-entry bookkeeping, financial reporting, and more.

In this comprehensive course, you will learn the basics of double-entry bookkeeping, as well as how to analyze and record financial transactions. You will get hands-on experience with handling accounts receivable, accounts payable, payroll procedures, sales taxes, and various common banking activities.

Accounting Fundamentals covers all the bases, from writing checks to preparing an income statement and closing out accounts at the end of each fiscal period. Whether you're a sole proprietor looking to manage your business finances or you simply want to gain an understanding of accounting basics for career advancement or for personal use, this course will give you a solid foundation in financial matters.

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 are preferred. Microsoft Edge and Safari are also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.
• A calculator and a printer.

Instructional Material Requirements:

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

Account Classifications, Account Titles, T Accounts, and the Accounting Equation

Welcome to Accounting Fundamentals! In this first lesson, you will learn all about account classifications, debits, credits, and T accounts. You will learn the difference between a liability and an asset and find out how to determine an owner's equity.

General Ledger Accounts and the Balance Sheet

Here's where you will begin your hands-on accounting practice: You will start by creating an imaginary company for which you will be the accountant. You will learn how to analyze your company's transactions to determine which amounts go into which accounts, then you will create your company's own General Ledger forms and post a few transactions into those accounts.

Journalizing Transactions and Posting to the General Ledger

Now that you understand the functions of the General Ledger, you're ready to move on to the next phase of recording transactions: the Journal. In this lesson, you will learn how to enter transactions into an 11-column journal and then post or transfer those amounts into appropriate General Ledger accounts.

Journalizing and Posting Cash and Charge Purchases and Payments on Account

In this lesson, you will learn all about Accounts Payable, which is money that you owe your vendors and suppliers. You will practice journalizing cash purchases and purchases on account, and you will get hands-on practice transferring those purchases to their corresponding Accounts Payable Ledger accounts.

Journalizing and Posting Cash and Charge Sales and Cash Received on Account

In this lesson, you will learn about Accounts Receivable, which is another name for money owed to your company by its customers. You will learn how to journalize and post those sales on account, how to enter charge sales into the journal, and how to transfer the information into an Accounts Receivable Ledger.

Payroll and Various Deductions

It's payday! This lesson will teach you how to determine gross pay, deductions, and net pay. You will learn how to prepare a payroll, write payroll checks, and how to prepare and maintain accurate payroll records.

Banking Services and Reports

In this lesson, you will learn all about banks and banking services: You will learn the proper way to write checks, make out deposit tickets, and reconcile your company's checking account with the bank statement. These are skills you will find valuable in both your business and personal life!

Posting Journal Totals to the General Ledger and Schedule of Accounts Payable and Schedule of Accounts Receivable

This lesson will teach you how to prepare a Schedule of Accounts Payable and a Schedule of Accounts Receivable. These reports can be used to compare the amount of money your business owes its creditors with the amount of money your customers owe your business.

End-Of-Year Worksheet

In this lesson, you will prepare a worksheet showing the net income or net loss for the fiscal period. The worksheet will show all income and expenses for the fiscal period as well as the assets, liabilities, and owner's equity account balances.

End-Of-Year Financial Reports

In this lesson, you will learn how to prepare various reports that are vital to the well-being of your company. You will learn how these reports can be used to make sound financial decisions in the next fiscal period. You will discover how to put together an Owner's Equity Statement, an Income Statement, and a Distribution of Net Income.

Journalizing and Posting Adjusting Entries

In this lesson, you will prepare for the end of the fiscal period by adjusting your asset account balances to accurately reflect the assets remaining at the end of the year. You will also find out how to journalize and post adjusting and closing entries to bring your company's General Ledger up to date.

Journalizing and Posting Closing Entries and Preparing a Post Closing Trial Balance

In the final lesson, you will prepare a Post Closing Trial Balance report to ensure that all of your debits and credits in the General Ledger balance out in preparation for the new fiscal period.

What you will learn

• Learn the basics of double-entry bookkeeping, as well as how to analyze and record financial transactions
• Get hands-on experience with handing accounts receivable, accounts payable, payroll procedures, sales taxes, and various common banking activities
• Learn about writing checks, preparing an income statement, and closing out accounts at the end of a fiscal period

How you will benefit

• Learn everything you need to know to better manage your finances
• Gain a solid understanding of accounting basics to be able to manage business finances or advance your career
• Open the door to more career opportunities in the in-demand field of accounting and finance

Nancy Koenig

Nancy Koenig is an experienced industry professional with over 40 years in the workforce, including decades in finance. Nancy has worked in various finance roles in banking, insurance, and a hospital billing office. For the last 27 years of her career, she was an administrative assistant at a technical school, which involved running and overseeing the entire budget, amongst other duties. Nancy has also held part-time jobs as a bookkeeper for an auto parts store and a cable company, where she used QuickBooks computerized software. Over the past several years, she has also co-taught the Accounting Fundamentals and Accounting Fundamentals II courses with Charlene Messier.

Give yourself skills that are in high demand by exploring corporate accounting.

While it is true that accounting professionals are scarce, those with corporate accounting experience are even scarcer. This course will provide you with a solid understanding of corporate accounting practices.

In Accounting Fundamentals II, you will explore such topics as special journals, uncollectible accounts receivable, plant assets, depreciation, notes and interest, accrued revenue and expenses, dividends, retained earnings, and various financial reports for corporations.

If you're interested in increasing your financial awareness and accountability while also gaining a marketable skill, this is the course for you.

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 are preferred. Microsoft Edge and Safari are also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.
• A calculator and a printer.

Instructional Material Requirements:

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

Accounts Payable

In this lesson, you will learn all about accounts payable. You will be journalizing and posting your company's purchases and preparing a Schedule of Accounts Payable. This lesson will give you the tools you need to successfully track those accounts.

Accounts Receivable

In this lesson you will take a close look at accounts receivable. After completing this lesson, you will know how to enter charge sales into your Sales Journal and then post them to your General Ledger. You will have also learned how to journalize payments on account received from your charge customers.

Uncollectible Accounts Receivable

In this lesson you will learn about uncollectible accounts receivable. While many believe customers will always pay what they owe, that is not always the case. You will learn how to account for long overdue receivables that probably won't ever be paid.

Plant Assets and Depreciation

In this lesson, you will learn about plant assets and depreciation. Just like your car, business assets depreciate over time, so you will need to know how to account for that expense in your records. You will also need to record these assets and calculate their depreciation in a timely manner.

Notes Payable and Notes Receivable

This lesson is all about notes payable and notes receivable. You will learn all you need to know about accounting for these situations as you learn how to record the issuance and payment of these notes payables and notes receivables.

Accrued Income and Accrued Expenses

In this lesson, you will learn how to deal with accrued income and accrued expenses. Accrued income is money that the company earns in one fiscal period but doesn't receive until after another fiscal period begins.

Dividends and Starting the Year-End Worksheet

In this lesson, you will be dealing with dividends, which is money paid to the company's stockholders on their investment. You will learn how the business accounts for the dividends it pays to its stockholders. You will also look at retained earnings, or the amount of profit the corporation retains for future use.

Complete Year-End Worksheet With Adjustments

In this lesson, you will determine whether your business has a net income or a net loss by completing the worksheet started in the previous lesson. Because many General Ledger accounts change throughout the fiscal period, you will also need to bring these accounts up to date.

End-Of-Fiscal-Period Financial Reports

It's time to begin wrapping up your books for the end of the fiscal period. In this lesson, you will learn how to compile most of the various financial reports a corporation needs to complete at the end of the fiscal period.

Adjusting and Closing Entries and Post Closing Trial Balance

In this lesson, you will get the books all caught up and ready for the next fiscal period. You will go back and journalize those adjusting entries you entered into your worksheet, then you will enter closing entries into your journal.

Preparing a Payroll

This lesson covers every employee's favorite subject: Payroll. You will learn about various mandatory and voluntary deductions from employees' pay, as well as how to journalize and post an entire payroll. As an added bonus, after this lesson, you will be able to check the accuracy of your own paycheck.

Preparing Federal Tax Deposits and Year-End Tax Reports

The final lesson focuses on preparing a variety of end-of-year tax reports. Here's your chance to go step-by-step through a multitude of IRS forms with instructions that are much easier to understand. You will fill out the federal Form 941, then learn how to make federal income tax deposits.

What you will learn

• Learn about accounts payable and receivable
• Understand how to represent uncollectible accounts in reports
• Learn about plant assets and timely depreciation of these assets
• Learn how to deal with accrued income and accrued expenses
• Understand stock dividends and retained earnings
• Learn how to prepare year-end financial documents including tax forms

How you will benefit

• Become more indispensable to any organization as you develop higher level accounting skills
• Learn everything you need to know to accurately keep the books for any type of business
• Become more aware of the accuracy of your own personal pay stubs and tax documents
• Open the door to more career opportunities in accounting

Nancy Koenig

Nancy Koenig is an experienced industry professional with over 40 years in the workforce, including decades in finance. Nancy has worked in various finance roles in banking, insurance, and a hospital billing office. For the last 27 years of her career, she was an administrative assistant at a technical school, which involved running and overseeing the entire budget, amongst other duties. Nancy has also held part-time jobs as a bookkeeper for an auto parts store and a cable company, where she used QuickBooks computerized software. Over the past several years, she has also co-taught the Accounting Fundamentals and Accounting Fundamentals II courses with Charlene Messier.

Gain the skills and knowledge you'll need to prepare for the Certified Administrative Professional exam and begin a rewarding career as an administrative assistant.

Discover how time management, accounting, business law, organizational behavior, and management affect administrative assistant responsibilities and activities. Learn the basics of accounting, including the general ledger and key accounting terms, and see how financial statements and controls help keep your organization moving in a positive direction. Understand the fundamentals of business law, contracts, and the principal-agency relationship; discover ethics and organizational politics; and understand the basics of human resources management.

Also, discover key management functions such as planning, control, motivation, and organization, discover how to increase creativity. Plus, find out how marketing differs from sales and learn the basics of operations management. This course may help you prepare for the internationally-recognized Certified Administrative Professional® (CAP®) exam offered by the International Association of Administrative Professionals® (IAAP®).

Note: This course is not affiliated with, nor has it been endorsed by, the International Association of Administrative Professionals® (IAAP®).

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 are preferred. Microsoft Edge and Safari are also compatible.
• 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.

Change Management and Teams

This lesson will discuss why change is so important, review why people are reluctant to change, and explore strategies that can help you overcome resistance to change. It'll help you establish a winning team and lead you through the stages of recruiting, evaluating, and selecting team members. You'll explore the concepts of a core team, extended team, and the overly important team. The lesson will finish up by discussing the complete performance planning process, including how to address performance problems and how to make reviews more meaningful.

Accounting Basics I

In this lesson and the one that follows, you'll learn accounting and financial concepts and fundamentals to help you increase your readiness to use financial information. You'll gain a strong foundation by learning about the general ledger, by seeing the difference between accounting and bookkeeping, and by investigating the different types of accounting. The lesson will demystify debits and credits and present the accounting equation as a cornerstone of all modern accounting systems.

Accounting Basics II

Now that you've absorbed the basics of accounting, it's time to learn how to apply financial information. You'll start off by reviewing two vital financial statements that you will find at nearly every organization—the balance sheet and the income statement. Next, you'll find out how to account for inventories and then discover the significance of cash flow. By the end of the lesson, you'll clearly understand how sound cash management helps companies stay on the right path.

Business Law I

Administrative assistants need to know the basics of business law. You'll need to have a good grasp of key legal concepts, such as the principal-agency relationship and the basics of contracts. The lesson will start things off by looking at the idea of law, going through an overview of the legal system, and discussing the essence of commercial law. It'll tackle the essentials of contracts, such as the elements and the various types, and finish up by discussing Article 2 of the Uniform Commercial Code.

Business Law II

In this lesson, you'll examine the four most popular organizational forms: sole proprietorship, general partnership, limited partnership, and corporation. You'll learn all about organizational politics, and see that wherever people work together, you'll find politics. The lesson will also touch on business ethics, a critical concept that has received much attention in recent years.

Human Resources Management

In this lesson you'll take a look at human resources management. It's possible that your job responsibilities as an administrative assistant will encompass many or all of the aspects of human resources. Even if you don't have this as a direct responsibility, you may have to interface with or be indirectly involved in aspects of human resources management, working with your company's HR manager. You'll explore employee relations, guidelines for documentation in human resources, and the staffing process. You'll also review conflict resolution, how to hire the right person, and much, much more.

Planning and Control

Life is filled with opportunities, problems, and choices. When you effectively plan and control your activities, and also make timely decisions and solve problems, you become a valued asset. You'll look at the ins and outs of planning because just about everything you do begins with a plan. The lesson will help you learn about the counterpart of planning: control. By the time you finish it, you'll know all about problem solving and be able to apply a model of decision making.

Organizing

Organizing is a critical topic that many companies struggle with. In this lesson, you'll discover how resources are organized so employees can productively perform job duties and complete tasks. You'll begin by studying the purpose of organization and examining several coordinating principles, including authority, power, and span of control. You'll learn the purpose of the staffing function and how to evaluate such key elements as recruitment, selection, appraisal, and development. The lesson will conclude by looking at six different forms of organizational charts.

Leading and Motivating

It's often said that motivation and leadership are two sides of the same coin. It's difficult to have one and not the other. This lesson will begin by defining motivation and exploring four theories of motivation, and then move into leadership. You'll learn about the different types of leadership and discover the difference between delegation and empowerment. You'll also examine creativity and see how you can increase your creativity levels.

Marketing

Most people believe that marketing is either advertising or selling. The primary objective of this lesson is to make sure that you clearly understand the distinction between marketing, advertising, and sales. You'll discover what it means to be consumer oriented and learn how to apply the four Ps (product, place, price, promotion) and see how these variables work together to form marketing strategies.

Operations Management

Operations management is one of the unheralded activities at a company. The folks that work in this area don't receive much credit and don't lead a glamorous life. They're the behind-the-scenes people that keep the ball rolling so that customers are happy and the company makes profits. In this lesson, you'll explore the diverse nature of operations management and see how selecting, designing, operating, controlling, and updating play an important role in all operating systems. Along the way, you'll learn about the importance of key concepts like forecasting, capacity, and make-or-buy analysis.

Time Management

You've probably heard the saying "time is money." How you manage your time is the key to your success. Time management is one of the most important skills you as an administrative assistant can develop. If you don't learn how to manage your time, you will not be as effective and efficient and you run the risk of letting down those people who rely on you. In this lesson, you'll learn about the importance of time management and how it can benefit you in your role as an administrative assistant. The lesson will examine the benefits of time management and identify tools and techniques to help you free up more time for work and outside interests.

What you will learn

• Learn the basics of accounting and key accounting terms
• Understand how financial statements and controls help keep your organization moving in a positive direction
• Learn the fundamentals of business law, contracts, and the principal-agency relationship
• Discover ethics and organizational politics
• Understand the basics of human resources management

How you will benefit

• Understand how all areas of a business can affect your administrative assistant responsibilities and activities
• Become more valuable to your organization as you familiarize yourself with all of its moving parts
• Open the door to new opportunities as an administrative assistant

Becky Swaim

Becky Swaim has taught since 2000, focusing on Administrative Assistant Fundamentals, Administrative Assistant Applications, and Individual Excellence. She holds a Bachelor of Arts in Speech Communication from California State University, Long Beach. Her experience includes managing large staff in medical billing and collections and as a program manager to various medical practices.

Tony Swaim

Tony Swaim has helped many clients, colleagues, and students reach their professional and personal goals. He has been an online instructor since 1998 and has taught at colleges and universities across the United States since 1981. His focus areas are project management, Six Sigma, and supply chain management. Tony manages a successful consulting firm, and his industry experience includes 20 years of supply chain management. He earned a Doctorate in Business Administration from Kennesaw State University and holds professional certifications in six disciplines, including the Project Management Professional (PMP)® certification from the Project Management Institute (PMI)® and Certified Six Sigma Black Belt (CSSBB)® from the American Society for Quality (ASQ)®.

This course will help you discover and master the essentials of managerial and staff support, information and records management, communications technology, travel and meeting coordination, space planning, and office ergonomics.

Rapid growth in the health, legal services, data processing, management, public relations, and other industries have created many new job opportunities for administrative assistants. This course will help you discover and master the essentials of managerial and staff support, information and records management, communications technology, travel and meeting coordination, space planning, and office ergonomics. You will become an indispensable member of your team by identifying opportunities and implementing solutions to turn your office into a high productivity machine.

This course and its follow up (Administrative Assistant Applications) may help you prepare for the internationally-recognized Certified Administrative Professional® (CAP®) exam offered by the International Association of Administrative Professionals® (IAAP®).

Note: This course is not affiliated with, nor has it been endorsed by, the International Association of Administrative Professionals® (IAAP®).

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 are preferred. Microsoft Edge and Safari are also compatible.
• 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.

Introduction

In the first lesson, you will learn why organizations need administrative assistants and explore the types of work that they perform. You will be introduced to the different administrative specialties and look at an overview of their varied duties and requirements. You will learn about the International Association of Administrative Professionals (IAAP), and the professional certification—Certified Administrative Professional (CAP)—that IAAP offers.

Office Planning and Layout

As an administrative assistant, you frequently participate in office planning. This lesson will help you to understand that an office is an interdependent system where everything works together. You will see that creating an office environment requires bringing many components together.

Information Management

In today's fast-paced world, organizations move very quickly and make split-second decisions that have far reaching implications. In this lesson, you will learn how to effectively use information management to create a successful office operation and help increase your value to your organization.

Communications Technology

Telecommunications, communications, and technology fit together like a hand in a glove. This lesson will show you how telecommunications technology enables you to access information, share knowledge, and communicate without boundaries.

Records Management

In this lesson, you will learn how to productively use reprographics and manage records, two duties that are frequently handled by administrative assistants. You will also discover that records management is the management of paper documents, micromedia, and other documents.

Hardware and Software

As an administrative assistant, you spend a lot of your day inputting and storing data, retrieving and analyzing information, and producing presentations, newsletters, numerical reports, graphs, and charts. To better help you focus on computer hardware and software in this lesson to help you better understand the properties of your office computer system.

Meetings, Conferences, and Travel

This lesson covers scheduling and coordinating meetings, conferences, and business travel. As an administrative assistant, you play an important role in helping co-workers arrive at the right place at the right time. You also provide them with information and materials that enhance their effectiveness while they travel and participate in meetings.

Policies and Procedures

A critical responsibility of administrative assistants is coordinating numerous office activities. This lesson examines how to create practical policies and procedures. You will focus on the use of policies and procedures that meet organizational objectives and create order in your day-to-day activities.

Business Documents

As an administrative assistant, you spend much of your time reading and composing business documents. This lesson's objective is to enhance your business writing skills. After you finish this lesson, you will have an increased ability to write high-quality business documents.

Grammar and Punctuation

This lesson bridges the subjects of written and verbal communication by discussing the principles of grammar and punctuation. It's likely that you need to help others with their written communication, so you will also review the mechanics of proofreading.

Interpersonal Communication

As an administrative assistant, you practice interpersonal communication in a variety of ways, ranging from one-on-one to communicating in a group. This lesson will explain how your desire to share thoughts and ideas creates the first part of communication and how you create the second part when you listen, interpret, and react to feedback.

Research and Presentations

This final lesson will teach you how to perform basic research—something administrative assistants are often asked to do. It also discusses the steps you take to create a meaningful and memorable presentation, including strategies for starting your preparation and the software that can help you create a polished piece.

What you will learn

• Essentials of managerial and staff support.
• Information and records management.
• Communications technology.
• Travel and meeting coordination.
• Space planning and office ergonomics.

How you will benefit

• Become an indispensable member of your team when you put your newfound knowledge and skills into practice.
• Increase your job opportunities and earnings potential.
• Continue your education with our Administrative Assistant Applications course to prepare for the Certified Administrative Professional (CAP) exam.

Becky Swaim

Becky Swaim has taught since 2000, focusing on Administrative Assistant Fundamentals, Administrative Assistant Applications, and Individual Excellence. She holds a Bachelor of Arts in Speech Communication from California State University, Long Beach. Her experience includes managing large staff in medical billing and collections and as a program manager to various medical practices.

Tony Swaim

Tony Swaim has helped many clients, colleagues, and students reach their professional and personal goals. He has been an online instructor since 1998 and has taught at colleges and universities across the United States since 1981. His focus areas are project management, Six Sigma, and supply chain management. Tony manages a successful consulting firm, and his industry experience includes 20 years of supply chain management. He earned a Doctorate in Business Administration from Kennesaw State University and holds professional certifications in six disciplines, including the Project Management Professional (PMP)® certification from the Project Management Institute (PMI)® and Certified Six Sigma Black Belt (CSSBB)® from the American Society for Quality (ASQ)®.

In this hands-on course, you will learn Microsoft Excel 2019's advanced functions and often-overlooked features, including data analysis tools, data tables and databases, custom controls, and PivotTables.

Most organizations rely heavily on Microsoft Excel to consolidate, analyze, and report financial information and other important data. Your company is probably no exception. If you work with data of any kind, learning Excel's advanced functions to taking on greater responsibilities in your organization.

This course will help you master many features in Microsoft Excel 2019 that most users don't know exist. You will learn the secret to using formula-based conditional formatting as a creative solution to common issues. You will also learn how to leverage Excel's Power Query tool to import and transform data from about any data source. By the time you finish this course, you will have mastered Microsoft Excel 2019 and will be able to better serve your company's data management needs.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. It is not suitable for Macs or Chromebooks.

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 Excel 2019 (desktop version), available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment)
• Note: The "Starter Version" and "Web App" versions of Microsoft will not work with the full version taught in this 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 will be available online.

Customizing Excel

To kick things off, this lesson explains different ways you can modify Excel to streamline processes and make your work easier. You will use the Excel Options dialog box to customize some of Excel's behind-the-scenes behavior and set up your Quick Access Toolbar.

Table Management

This lesson explores Excel's table management features, using data forms with Excel databases, and alternative database techniques. You'll be glad to know that formatting and working with tables has become much easier in this latest version of Excel.

Data Validation

In this lesson, you will tackle data validation techniques—your first line of defense against incorrect or missing data and the logical next step after data forms. You will practice using whole number, decimal, date, time, list, and other forms of validation.

Custom Controls

This lesson will introduce you to custom controls—graphical objects that help facilitate data input and are sure to impress users. You will learn how to create standard and drop-down list boxes, check boxes, option buttons, and group boxes.

Conditional Formatting

This lesson will teach you how to use conditional formatting. You will learn how to use conditional formatting to hide errors, to highlight records based on multiple criteria, to track and alert you about due dates, to find the differences between two lists, to shade every other row, and more.

Consolidating and Outlining

In this lesson, you will learn how to use Excel's consolidation function to efficiently summarize data from multiple sources. Many Excel users do this the hard way, but with Excel's automatic consolidation feature, you will no longer need to develop a web of formula links to multiple sources.

Excel Functions and Nesting

Excel's functions are too numerous to cover in just one lesson, so this lesson focuses on a few important ones spanning four categories: Logical, Database, Math & Trig, and Lookup & Reference.

Import External Data

This lesson focuses on importing external data. You will learn how to use the built-in Query Editor using Excel's powerful Power Query tool and import external database that combines two database tables into a single import.

Data Tables

Data tables are very powerful what-if analysis tools that are great for analyzing potential outcomes of personal or business financial decisions. In this lesson, you will learn how to use two different types of data tables.

What-If Analysis Tools

This lesson explores three more of Excel's what-if analysis tools: Goal Seek, Scenario Manager, and Solver.

Advanced PivotTables

In this lesson, you will discover how to use PivotTables, which are excellent for summarizing massive amounts of data and viewing different cuts of the information quickly. There are two methods for creating PivotTables, and you will practice using both.

Analysis ToolPak, Advanced Filter, Array Formulas, and More!

Your final lesson with a look at the functions available in the Analysis ToolPak, including Moving Average and Sampling tools. You will learn how to use the View Side by Side tool and how to use the Watch Window to keep tabs on your data when you're updating a workbook.

What you will learn

• The power of what-if analysis tools like data tables, Scenario Manager, Solver, and Goal Seek
• To build creative formulas with conditional formatting to solve common problems
• To import and transform external data from multiple external sources
• To combine multiple Access tables into a single table using Power Query

How you will benefit

• Master Excel 2019 and become a more productive member of your organization
• Gain indispensable skills that will be useful in any organization that relies on numbers-based reporting
• Learn to use the power of Microsoft Excel 2019 to save time, money and frustration
• Develop skills that can be used to simplify your life of calculating and displaying numbers both personally and professionally

Chad Wambolt

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.

Gain a working knowledge of the computer skills you will need to succeed in today's job market.

Most jobs today require a working knowledge of certain computer skills. Employers seek and reward employees who can effectively send emails, create spreadsheets, manage databases, understand memory and network limitations, and recognize the function and features of modern computer components. Any job candidate who already possesses these skills will stand above those who do not.

This course is designed to provide the fundamental computer competencies you need to survive and prosper in today's fast-changing workplace. You will learn how to implement the powers of modern office software to work faster and more efficiently. This course will also focus on practical applications for software most common to the workplace. By the time you finish, you will have learned why employers consider technological literacy so critical to the success of any organization.

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 is preferred. Microsoft Edge is also compatible.
• Any edition of Microsoft Office with desktop apps: Excel, Word, Outlook, PowerPoint, and Access (not included in enrollment).
• 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.

Overview: The Workplace Technology Solution

Whether you're looking for a new job or looking to improve your position at your current company, computer skills are essential to your success. In our first lesson, we'll examine how companies set up and use technology solutions. Then we'll take a close look at some of the components of those solutions. Just understanding how technology fits into the overall flow of work at your company will advance your position relative to your peers.

Outlook: Email and Scheduling

Your computer has a software program installed on it that's referred to as an "operating system." Most often, this system is Microsoft Windows, but it could be others, such as macOS or Linux. In this lesson, you'll learn how this system controls many important parts of the computer and how you use those controls every day for tasks like managing where you keep important files, and printing hard copies of documents. We'll also talk about menus, taskbars, and shortcuts along the way.

Word: Creating and Formatting Documents

Next to email, the word processor is probably the most frequently used application software in the workplace. Yet, if you've never taken the time to learn the basic features of most word processors, you're not performing nearly to your potential. In today's lesson, you'll learn and practice the important capabilities of word processors like Microsoft Word.

Word: More Advanced Formatting

There are many excellent features in Microsoft Word that can enable you to create and edit very professional-looking documents. In this lesson, we are going to incorporate some of the more advanced Word functions to create documents that are sure to impress your peers and your supervisor. We'll focus on formatting and organizing your information using a wide range of Word processor tools.

Excel: Spreadsheet Basics

During today's lesson, we'll go over some important fundamental concepts related to spreadsheets, including spreadsheet organization, formatting, basic formulas, and data sorting. Once you discover how to create a basic budget spreadsheet, you'll see how the skills and knowledge you gain from this lesson can have a powerful impact on your ability to contribute more in the workplace.

Excel: Formatting, Charts, and Printing

In this lesson, we'll discuss more details about the spreadsheet, and how to provide easy-to-understand, accurate data. You'll learn how to build graphs that can graphically display numeric information so you can easily demonstrate trends, analyze past results, and predict future performance. You'll also find out how to use some advanced spreadsheet tools that can make your spreadsheets even more effective.

Access: Database Basics

During this lesson, we'll examine the components of a database, focusing primarily on the user interface. In your job, you might use this interface to perform a lot of different functions, including data input, data output, and data maintenance. Clerks work with databases to input information. Other employees might work with databases to filter, sort, and read information. Database-management personnel interface with databases to keep them accurate, reliable, and secure.

PowerPoint: Creating and Editing a Presentation

PowerPoint is an important tool for creating presentations suitable for the work environment. This powerful program has many features, but they must be used correctly or else your audience will be distracted or overloaded. In this lesson, we'll explore the best ways to create an effective presentation that incorporates the right mix of multimedia. You'll learn how to insert graphics and audio into your presentation in an effective and organized manner.

Integrating Microsoft Office Programs

The suite of Microsoft Office products includes Excel and Access, which are both very powerful on their own. In this lesson, you are going to learn how to actually integrate information from one program to the other. You can create data lists with either program and easily transfer the information to the other. Considering all the work we do with lists on the computer, this is a very important skill in today's work environment. Plus, you'll find out how mail merge can save you time and effort by allowing you to customize letters, labels, and more!

Using the Internet

In today's lesson, we're going to have fun working with the Internet. This is the greatest source of information you'll ever have access to—yet it can be confusing and overwhelming if you are not familiar with the basic Internet tools. You'll really enjoy seeing how easy it is to find information that specifically meets your needs and interests.

Transferring and Protecting Data

Today, we'll go over various methods for transferring information from one computer to another. We'll explore different terms used to describe the volume of information—or size of a file—and then learn how to most effectively and efficiently move that data from place to place. You'll learn about bytes, megabytes, memory sticks, and external hard drives.

Putting Your Skills to Work

In our final lesson, we will focus on putting all your new knowledge to work! We have three specific goals. The first is to identify ways to use your computer skills to find a new job. The second is to use those same computer skills to get a promotion within your current organization. Our third goal is to explore strategies for continued learning in order to support your ever-growing employment goals.

What you will learn

• Acquire the fundamental computer competencies needed to succeed in the workplace
• Understand how to effectively use Windows 10 and Office 2016
• Discover how to create charts, presentations, word processing documents, and more

How you will benefit

• Become more technology literate and indispensable to any modern organization
• Place yourself above other candidates who do not have necessary computer knowledge and skills
• Become more confident using technology
• Identify ways to use your computer skills to find a new job or get a promotion at your current organization

Dave Paquin

Dave Paquin has been teaching computer skills in the classroom for over 15 years. He holds a Master of Science in Training and Learning Technology and has extensive experience as a Human Resources manager.

Learn powerful graphic design techniques and build websites that are both attractive and wickedly effective.

These days, creating a website is so easy almost anyone can do it. But with all the competition on the web, creating a site that's effective is more challenging than ever. Regardless of your current skills or level of knowledge, in this course you'll master the basics of web design and learn how to build sites that are better and more effective.

You'll examine the tension between form and function, explore the six major states of the website development process, and learn the basics of user-centered design. You'll also look at the five basic steps to organizing information, find out how site design themes can be used for information delivery, and review website design considerations. Along the way, you'll learn about effective type and graphics and explore the idea of making a website fully interactive. This course is a must for web designers, giving the tips and tools that will help them establish a solid career.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• An imaging program, such as Photoshop or Paint Shop Pro, is recommended (not included in enrollment).
• A web page authoring tool, such as Adobe Dreamweaver or Microsoft Expression Web, is recommended (not included in enrollment).
• 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.

Form Versus Function

This course is different from most web creation courses you'll find because it's not designed to teach you the mechanics of creating a web page or how to use a particular software program. Instead, it's designed to help you take your website creations to the next level by enhancing both design and functionality. You'll discover what attracts visitors to a website, and how to use design tools such as typography, Cascading Style Sheets (CSS), and multimedia to captivate visitors and keep them coming back.

Website Planning Process

Visitors are attracted by good design, but content is what keeps them at the site longer and motivates them to return. Learn how to use two tools to attract and retain visitors: design critiques and a content inventory. Explore the six major development stages that yield expert design and smart content. Then study the three parts of web design and the skills you'll need for each.

Interface Design

By now, you probably understand that an interface is the screen visitors see and use when they visit any page of your site. Designing an interface is easy. Designing an effective interface, however, is more challenging. There are four main elements that you'll need to consider to make your site user-centric: usability, visualization, functionality, and accessibility. Explore each of these elements to see the thought that goes into effective interface design.

Site Structure

Even if your basic content is accurate, attractive, and well written, your site won't function well without a solid and logical organizational foundation. Review the five basic steps involved in organizing information and four essential structures that you can use to build a website. Then learn how to create a flowchart for the pages you want to include on your site.

Site Design

Websites exist to inform, educate, persuade, or entertain. Take this opportunity to concentrate on site design themes that pay attention to information delivery. Learn how to organize elements in order to enable visitors to accomplish their own goals. Explore usability, content, and design.

Page Design

Discover how you can use visual and graphic design, page layout, and grids to take your designs to the next level. At the same time, become familiar with design considerations like visual hierarchy, page dimensions, and white space.

Typography on the Web

Typography plays a dual role by providing both verbal and visual communication. Almost any type of font will do to transmit information to others. But to convey the right type of mood along with the information takes a special type and color of font. Learn all the secrets here!

CSS and Font Embedding

Find out how you can use Cascading Style Sheets to modify fonts. Become familiar with inline, document-level, and external (linked) style sheets, and learn how to create an external CSS file to control the formatting of any or all pages on your site. You'll also take a look at some early font embedding techniques and explore two popular Flash-related options currently in use.

Writing for the Web

Before you write for the web, you should take the time to understand how people read online. Become familiar with the use of titles, headlines, and subheads to assist readers in navigating your site. Discover the advantages of using a web content management system. Learn how you can communicate more easily and informally with web visitors by adding a blog to your site.

Images, Colors, and Layers

You can use images to add interest to your site and to help with navigation. Early designers were limited graphically by HTML attributes, and later designers discovered they could use tables to place images. Today's designers also use CSS to add styles to their text and images. As fun as CSS can be, you also have to take accessibility into account so that users with older browsers or screen readers can still navigate your website.

CSS Positioning: More Layers

The combination of HTML, CSS, and JavaScript allows you to create intensely interactive web applications similar to any game or presentation built with traditional programming languages. This interaction of HTML, CSS, and JavaScript is known as Dynamic HTML or DHTML. Become familiar with the basics of DHTML, including code you can use to enhance your designs by adding layers to your pages.

Web 2.0 and Beyond

Early websites were created by a few to be read by many. Over the years, developers added interactivity to websites through discussion forums, chat rooms, and shopping carts. These features are part of what might be called "web 1.0". Today the focus has shifted from the sponsor of the site to the visitor, and sites like Flickr and YouTube are popular. They're examples of web 2.0 sites. Examine several popular web 2.0 sites, and take a look ahead to web 3.0.

What you will learn

• Learn the fundamentals of effective website design
• Discover the relationship between website design themes and information delivery
• Explore the six major states of the website development process
• Learn how to effectively reach an online audience and stand out from the fierce competition

How you will benefit

• Learn about the elements and principles of design and how they can be applied to a number of career fields
• Gain confidence in your ability to communicate and market to a specific audience
• Open the door to new career opportunities
• Gain a greater understanding of modern, forward-thinking website design

Richard Blum

Richard Blum has been an IT industry professional for over 20 years, working mainly as a network and systems administrator. During this time, he has worked with Microsoft, Novell, Unix, and Linux servers, and has created websites using a variety of different programming languages. Blum is the author of several programming and systems administration books, including Professional Assembly Language, C# Network Programming, PostgreSQL 8 for Windows, Sendmail for Linux, Postfix, and Network Performance Open Source Toolkit.

Use Microsoft Word 2019 more efficiently by mastering its more advanced features. This hands-on course will teach you how to create an index, build a list of figures, design a table of contents, perform a mail merge, and use timesaving shortcuts to develop professional documents.

If you create business documents like letters, brochures, or newsletters, you know that their quality is representative of your organization. To create professional-quality documents efficiently and effectively, you have to use advanced word processing functions. This online course will teach you how to use Microsoft Word 2019, the newest version of Microsoft's widely-used word processing software.

Through hands-on lessons and modules, you will learn how to use a number of shortcuts and time-saving techniques to create complex documents. By the end of the course, you will know how to create and organize tables, manipulate graphics, and merge spreadsheets, amongst other functions, to turn Word into a simple desktop publishing tool.

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 is preferred. Microsoft Edge is also compatible.
• Microsoft Word 2019 (desktop version) available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment)
• Note: The "Starter Version" and "Web App" versions of Microsoft will not work with the full version taught in this 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 will be available online.

Timesavers in Word 2019

Things have come a long way since the days of the typewriter. What used to take hours can now be done in seconds with Microsoft Word 2019. And the less time you spend typing, the more time you can spend being creative and having fun. In this lesson, you'll learn shortcuts in Word that can help you create documents faster and more accurately than ever before. Not only will these shortcuts save you time, but they'll help you create letters and reports more easily than you might have thought possible.

Methods to Streamline Text Formatting

What you write is half of communication. The other half is getting people to read what you write. One way to make your writing more appealing is to make it look presentable with formatting. Of course, formatting text is easy, but applying different types of formatting over and over again can get tedious. In this lesson, you'll learn a fast and easy way to format chunks of text quickly and consistently using something called styles. You'll find out what a style is, how to apply it, and—more important—how to create and save your own styles to use in any document. By the end of this lesson, you'll be able to make any document look presentable with just the click of your mouse.

Working with Templates

A template stores the formatting of a document so that you can apply it to another document. Templates let you format entire documents as easily as formatting a single word. Word offers lots of convenient templates stored right on your computer or available over the Internet. In this lesson, you'll learn about how to search and use Word templates, and you'll also discover how you can create your own.

Adding Graphics to Your Word Documents

They say a picture is worth a thousand words, so what better way to spice up your documents than by adding pictures? In this lesson, you'll learn how to add your own digital photographs to a document so that you can show everyone your vacation pictures, family holidays, or just interesting sights you've captured with your own camera. In addition to adding your own photos, you can also add clip art from Word's massive library of free graphics. And you'll find out how to resize, rotate, and style your pictures, as well as wrap your document text around them. By the end of this lesson, you'll see why Word documents are about much more than words!

Creating Text-Based Graphics in Word

Digital photographs and clip art are just the beginning of what you can do with graphics in Word. In this lesson, you'll discover how to add a variety of informational graphics, including charts, graphs, and WordArt, which allows you to display text as a graphic image. Not only will you learn how to add these graphics, but you'll also find out how to edit them when your data changes. You'll finish off the lesson by seeing how Word allows you to format documents with multiple columns—a handy skill for creating newsletters and publications!

Organizing Your Text with Columns and Sections

Do you often create long documents? If so, you'll appreciate this lesson, which shows you how to divide a large document into parts called sections. Sections allow you to format part of a document a certain way without that formatting affecting the rest of your text. For example, you may want headers and footers to appear on some pages but not others. Sections make this easy! You'll also spend some time inserting footnotes and end-notes in a document. If you need to write research papers or other academic content, Word makes it a snap to add and format these previously pesky notes!

Creating Tables in Word

If you've ever seen a spreadsheet, you know how rows and columns let you organize numbers and text on the screen. Well, tables do the same thing in Word. In this lesson, you'll see how to create tables of all different sizes right in a Word document! You'll cover how to modify tables, too. And don't think Excel users get to have all the fun—you can even enter formulas to perform calculations in your tables, sort them, and style them for a customized look. Your data has never looked so appealing!

Creating Stationary in Word

You probably print most of your documents on standard letter-size paper. While this is great for ordinary letters or business reports, sometimes you may want to get creative with your paper sizes. But then there's the trouble of printing. In this lesson, you'll see how you can define the dimensions of the paper you're using, so Word will print everything correctly. You'll also learn how to print names and addresses directly on envelopes of any size. After this lesson, you won't feel confined to boring 8 1/2 x 11-inch paper anymore!

Creating Business Stationary in Word

As you've probably already figured out, Word can do more than write letters. It can also function as a simple desktop publishing program for creating greeting cards, calendars, or newsletters. In this lesson, you'll find out how text boxes are the key to simple desktop publishing, and you'll see how other elements come into play in customized documents. Along the way, you'll look at business cards and greeting cards to get a feel for how desktop publishing works. If you've always wanted to create a document that combines text and graphics in an artistic or visually appealing way, you'll find out how to do that and much more.

Desktop Publishing

With the basics down, it's time to take your desktop publishing skills to the next level. In this lesson, you'll discover the magic of linked text boxes that give you the power to move your text anywhere you want on the page and keep it flowing. You'll see how to create, position, resize, and group text boxes so that you have total control over your text.

Merging Data with Documents

Have you ever received one of those "personalized" letters from a company in the mail? You can be sure that nobody typed the entire sales letter from scratch. Instead, the company used a form letter and something called mail merging. In this lesson, you'll learn how to store long lists of names and addresses that you can reuse in a form letter. Just create a document once, leave blanks for inserting information such as names and addresses, and let Word personalize each letter for you. Now, you too can create personalized letters for business or personal use, such as sending out holiday greetings to family members and friends.

Creating Summative Lists of What's in Your Document

Look in most books, and you'll find a table of contents at the beginning and an index in the back. Often, these are the last components added to a document, since they need to have accurate titles and page numbers. Thankfully, Word takes a lot of the tedious work out of creating these components. In this final lesson, you'll see how you can use Styles to make creating a table of contents a snap, and you'll explore how to tag index terms so that Word knows what page they're on, even if they move later. Word can also help you keep track of any figures, such as charts, illustrations, or graphs, in your document. By letting Word worry about the details, you can create an accurate table of contents, index, or list of figures with very little extra effort on your part. These finishing touches will make your most important documents shine!

What you will learn

• Functions and features of Microsoft Word 2019
• Shortcuts and time-saving techniques including macros, keystroke shortcuts, and templates
• Finding, inserting, and modifying graphic images
• Creating and merging data and text for labels, letters, and other professional documents

How you will benefit

• Utilizing Microsoft Word 2019 as a basic desktop publishing tool adds value to your professional profile.
• By learning more advanced features of this popular software, you can contribute to your organization more effectively.

Wallace Wang

Wallace Wang is the author of over 40 computer books, including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghostwritten several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.

Wallace currently teaches an online iOS App Production course through UC San Diego Extended Studies, focusing on designing apps for the iPhone using SwiftUI and Xcode, emphasizing coding, user interface/experience design, and app marketing. It covers key topics such as the psychology of user interface design, creating prototypes, and effective marketing strategies for the App Store. He has recently provided consulting services for bLinkUp, assisting them with their iOS development projects.

Learn to decipher and solve almost any problem with your PC.

Don't spend your hard-earned cash on expensive PC repairs! The vast majority of the problems people experience with their computers are completely avoidable, and most can be solved with nothing more than a few minutes of your time. Intro to PC Troubleshooting takes you step by step through the typical hardware and operating system problems encountered by technicians, teaching troubleshooting techniques to decipher any problem, and giving you the skills you need to solve them.

Once you've mastered the basics, the course launches into some of the more advanced and nasty problems that crop up in the PC, teaching you how to diagnose and fix those problems as well! Finally, Intro to PC Troubleshooting shows you how to maintain and optimize a Windows PC. So what are you waiting for? Get ready to troubleshoot and fix some PCs!

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac.
• You will also need access to one or more computers that do not contain any data you consider sensitive.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• 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 Computing Process

This lesson starts you on the path to troubleshooting PCs like a pro. You'll first look at input devices, or how you tell the computer to do stuff. In the second part of the lesson, you'll explore the pieces that do the work inside the computer. The final section describes the output devices, where the computer communicates to you.

Troubleshooting Theory

This lesson will take you through the troubleshooting process. It's not a guide to solving specific computer problems, but the steps explained here will enable you to tackle any computer problems you might encounter. The three main steps are identifying the problem, testing solutions, and completing the process.

Operating System Overview

This lesson introduces you to some of the basic components and tools of an operating system. First, you'll find out about the primary functions of operating systems. You'll then explore the major parts of Microsoft Windows, including the Desktop and Windows Explorer. You'll finish the lesson by learning about the most important troubleshooting tools for fixing operating systems.

OS Fixes

This lesson leads you through the basic steps of troubleshooting an operating system, including startup, video, sound, and application errors. You'll look at tools like Safe Mode and the System Configuration utility and learn about driver rollback. You'll end the lesson by learning how to troubleshoot audio/visual errors.

Avoiding OS Obstacles

How would you like to prevent system problems instead of rushing to fix them? In this lesson, you'll master the three most important types of preventive maintenance: backing up data that's on a hard drive, updating or upgrading the operating system, and using Windows utilities that help you monitor and maintain the OS.

Networking Basics

This lesson covers the basics of networking. First, you'll find out how networks work and what the necessary components are for a wired network. Next, you'll discover wireless networks and everything that separates them from their wired-network brethren. Finally, you'll learn about the biggest network of them all, the Internet.

Troubleshooting Network and Internet Issues

This lesson covers the steps to take when trying to fix your network or Internet connections. You'll learn how to troubleshoot wired and wireless networks, share files, and fix a dial-up or broadband Internet connection.

Preventing Internet Problems

Keep your computer safe from Internet-based attacks, including viruses and spyware! You'll discover the many types of malicious software that can infect your computer, and go through the five-step process of recovering from a virus infection. You'll also read about safe browsing and safe email use and find out how to configure a firewall to help defend your PC.

Introduction to PC Hardware

All PC techs needs to get their hands dirty eventually, which means diving inside the case and checking things out from the inside. In this lesson, you'll learn about the power of different PC parts, including what to look for when shopping for new parts. The lesson will also guide you through the safe and proper handling of components.

Installing Hardware

Replacing hardware components can dramatically improve your PC's performance. For instance, RAM can speed up your computer, a second hard drive increases your data storage capacity, and expansion cards can add features and ports to your computer. In this lesson, you'll learn to handle RAM, hard drives, and expansion cards.

Maintaining Hardware

Dirt happens! You can't make your PC last forever, but you can make it last longer and run better by keeping it clean. Get out your canned air and your distilled water (but not your pencil erasers or your household vacuum cleaner), and learn safe and effective ways to check, clean, and maintain the inside and outside of your computer. You'll also learn about how to donate an old computer and how to throw away a computer without losing data or harming the environment.

Life of a PC Troubleshooter

You've come a long way since the beginning of this course. Before you complete your PC troubleshooting training, you'll be reminded about the computing process and troubleshooting theory. Combined with your new knowledge of PC hardware, software, and networking, you can use these tools to fix all sorts of problems. You'll learn more about your future as a PC troubleshooter, including the certifications and careers available to anyone with the right skills.

What you will learn

• Learn the typical hardware and operating system problems encountered by technicians
• Gain the skills you need to solve common PC problems
• Learn how to diagnose and fix more advanced problems as well
• Learn how to maintain and optimize a Windows PC

How you will benefit

• Save time and money by learning to diagnose and troubleshoot common computer problems that you may encounter personally and professionally
• Gain confidence as you learn to fix problems on your PC and business computers
• Open the door to new career opportunities as the go to person for technology issues in most companies

Mike Meyers

Mike Meyers, also known as the "Alpha Geek," is widely recognized as the leading authority on CompTIA Certifications in the industry. He co-founded Total Seminars, LLC and National Cyber Group, LLC, and has been providing PC and network repair seminars, books, videos, and courseware to thousands of organizations worldwide. With his extensive experience in the computer and network repair industry since 1987, Mike has worked as a technician, instructor, author, consultant, and speaker.

Mike is the author of several popular PC books and videos, including the best-selling CompTIA A+ Certification All-in-One Exam Guide and CompTIA Network+ Certification All-in-One Exam Guide. He also serves as the series editor for the highly successful Mike Meyers' Certification Passport series and the Mike Meyers' Guide to series. Mike has sold over a million IT and certification books.

Master the skills you'll need to pass the Mathematical Reasoning module in the GED® test series.

Master the skills required to pass the Mathematical Reasoning module in the GED® test series. You will start off with a review of math basics and begin building the foundation you will need to solve the types of math problems commonly found on the test. In the process, you will develop hands-on experience with percentages, proportions, statistics, algebra, geometry, and more.

Each lesson will give you a chance to apply your knowledge by practicing with the same kind of questions you may find on the test. By the time you finish this course, you will be much more comfortable with your math skills, and you will know how, when, and why to use each math concept you learn.

Note: Some GED® Testing Centers require proof that you have passed a GED® test preparation course before you can take the official test. Before enrolling in this course, please check with the official GED® Testing Center where you intend to take your tests to make sure this course will meet their requirements. Not all states use the GED® test as their test for high school equivalency diploma. The GED® Program is no longer active in Canada as of May 4th, 2024. Canadian students should contact their province to learn about their testing options.

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 are preferred. Microsoft Edge and Safari are also compatible.
• 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.

Getting to Know the Test

The first lesson will help you become acquainted with the kinds of questions you'll see on the math portion of the GED® test. Did you know that you'll need to use a specific type of calculator? You'll also look at some basic math concepts and problem solving techniques that you can use throughout the course.

Fractions, Decimals, and Percentages

Fractions are the first skills that everyone forgets after leaving school. This lesson focuses on the basics of fractions, decimals, and percentages you'll need in order to prepare for the GED® math module. This lesson is intense, but those skills will most likely come back to you quickly.

Aunt Sally and the Rules of Math

Math laws and rules set the stage for the computations you'll perform in future lessons and on the math part of the GED® test. You'll find out how Aunt Sally will help you remember the order of operations, and you'll learn to write large numbers and small numbers without using dozens of zeros. You'll also find out the rules for adding negative numbers, so you'll never find your bank balance overdrawn.

Algebra Expressions

When you see test directions that tell you, "Solve for n," do you get nervous? In this lesson, you'll learn some terms that are used in algebra, including "variable" and "coefficient," and you'll find out how to simplify complicated expressions and solve problems. This lesson covers the basics of algebra and includes lots of practice to ensure that you understand those basics. Algebra isn't as scary as you might think!

Equations and Inequalities

This lesson is all about equations. You'll start by learning the language of algebra and how to write your own algebraic sentences. From there, you'll move on to solving equations and inequalities.

Quadratic Equations

Everything you need to know about quadratic equations for the GED® test is in this lesson. You'll cover the greatest common factor, factoring, and the FOIL procedure. By the time you're done, you'll be confidently solving quadratic equations.

Using a Coordinate Grid

In this lesson, you'll put your algebra skills to work as you create lines on a coordinate grid. You'll locate points on a grid and then write equations for lines. By the end of the lesson, you'll know what slope is and how to figure out the steepness of a line.

Plane Figures and Angles

This lesson includes math that you can use in your home improvement projects as well as on the GED® test. Need to paint or carpet a room? How about building a new fence for your yard? You'll learn how to figure the area and perimeter of all kinds of shapes.

Solid Geometry: The Third Dimension

This lesson adds a third dimension to the plane objects in the previous lesson. You'll learn to compute the volume and surface area of solid objects, including prisms, spheres, pyramids, and cylinders.

Statistics: What Are the Odds?

Statistics will help you excel on the math, social studies, and science parts of the GED® test. In this lesson, you'll learn about permutations and combinations as well as measures of central tendency and probability. The lesson may not help you win the lottery, but it will prepare you for questions related to statistics!

Word Problems

This lesson will give you a chance to put many of your new math skills to work. You'll use proportions, functions, charts, and your algebra skills to solve word problems that may have stumped you in the past.

Graphs and Testing Tips

In this lesson, you'll review the graphs that you're likely to encounter on the GED® math, science, and social studies modules. The lesson will also give you test-taking tips and tell you how to register for and schedule your GED® test.

What you will learn

• Learn the types of questions you will see on the math portion of the GED test
• Learn basic math concepts and problem solving techniques
• Review and practice fractions, decimals, and percentages
• Learn math laws and rules for computations you will perform on the test
• Learn that language of algebra, write algebraic sentences and solve equations and inequalities
• Learn to locate points on a grid and write equations for lines
• Learn to figure area and perimeter
• Compute the volume and surface area of solid objects
• Learn how to solve problems related to statistics
• Look at graphs that you will encounter in several modules of the GED test
• Learn test-taking tips, how to register for the test and schedule your test

How you will benefit

• Review and master basic math skills and build a foundation you will need to solve all types of problems found on the GED test
• Be prepared and confident to take the GED test

Barbara Rolston

Barbara Rolston holds a master's degree. Since 1975, she has been taught GED preparatory classes in a variety of settings, including adult schools, community colleges, and large corporations. She also was responsible for administering the GED exam in a correctional facility for two years. Math experience includes tutoring community college students on a wide range of math topics and serving as a math consultant for a nationwide adult student assessment system.

Want to pass the GED® test? This course will help you develop the skills you'll need to succeed.

This course will help you analyze your strengths and weaknesses, so you can focus your studying on the areas that you need most. You will get the basics of what you need to know to succeed on the four GED® test modules: Reasoning Through Language Arts, Social Studies, Science, and Mathematical Reasoning.

Some GED® Testing Centers require proof that you have passed a GED® test preparation course or the official practice tests before you can take the official GED® tests. Before enrolling in this course, please check with the official GED® Testing Center where you intend to take your tests to make sure that this course will meet their requirements. Not all states use the GED® test as their test for high school equivalency diploma. As of May 4th, 2024, the GED® Program is no longer active in Canada. Canadian students should contact their province to learn about their testing options.

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 are preferred. Microsoft Edge and Safari are also compatible.
• 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.

What is the GED® Test All About?

How many subjects does the GED® test cover, and how much time do you get for each part of the test? Where do you go to take the test? Do you get to use a calculator? Will this class teach everything from four years of high school? In this lesson, you will learn the answers to all these questions and more.

Reasoning Through Language Arts: Focus on Reading

Reasoning Through Language Arts is the longest of the four GED® test modules, so you will spend three lessons on it. This lesson provides an overview of the RLA, and then focuses on your reading skills. You will start mapping out your strategy for mastering the reading passages of the RLA.

Reasoning Through Language Arts: Focus on Editing

This lesson continues preparation for the Reasoning Through Language Arts test module. You will explore the parts of speech, punctuation, capitalization, and sentence structure. What you learn in this lesson will prepare you for the editing part of the RLA test module and help with your overall writing.

Reasoning Through Language Arts: Focus on Writing

It's time to use what you learned about reading strategies and grammar to create an extended response, which is a type of essay. The extended response has a high point value, so you will want to ace it.

Mathematical Reasoning: Focus on Math Terms and Algebra Basics

This first of three math lessons introduces you to the test content and the approved GED® calculator. More than half the math questions cover algebra topics, so you will jump right into the language of algebra. You will also review the concept of "order of operations", which describes the correct order for solving a multi-step problem.

Mathematical Reasoning: Focus on Formulas and Dimensions

This lesson applies the algebra you learned to formulas and geometry dimensions. You will use formulas for perimeter, area, volume, and surface area. These lessons work in real life as well as on the test: By the end of this lesson, you will know how to figure gas mileage, the cost per unit, and sale prices, and the area and perimeter a room.

Mathematical Reasoning: Combining Algebra and Geometry

In this lesson, you will bring your basic algebra skills to a higher level and combine them with geometry concepts. You will learn how to plot points, graph lines, and figure out the slope of lines on a coordinate grid. Then you will factor and solve a quadratic equation and learn how to use tables to solve word problems algebraically.

Science: Energy and Related Systems

In your first science lesson, you will explore the theme of energy and related systems. Besides investigating the cosmos and learning physics laws, you will practice some math that relates to science. The science test also features two short-answer items, that you will prepare for in this lesson.

Science: Human Health and Living Systems

Have you ever wondered why people have different eye colors? Or, have you ever seen news reports about the effects of hurricanes, tornadoes, or earthquakes? If so, you're ready for this science lesson, which explores human health and living systems.

Social Studies: Modern Liberties and Democracy

Understanding your government is an important part of being a good citizen. As you prepare for the social studies test, you will learn about events that shaped the history and economy of the United States.

Social Studies: Dynamic Responses to Societal Systems

Explore the second social studies theme as you learn to analyze political cartoons, master the basics of economics, and learn more about 20th-century history.

Testing and Beyond

You're almost done with this course! In this lesson, you'll review a checklist to make sure you're ready for the GED® test. You will also find tips and techniques to make test day less stressful and learn about making plans for your future, whether that's college or another path.

What you will learn

• Learn the content and strategies involved in taking and passing the GED test
• Develop increasingly-important skills in reading, writing, and mathematics
• Learn test-taking tips and tricks while familiarizing yourself with the content of the GED test
• Gain the answers to many of your questions and concerns associated with the requirements of the GED

How you will benefit

• Establish the foundation for a lifetime of learning and achieving
• Acquire the knowledge and skills necessary to achieve personal and financial success
• Gain confidence that you will be able to take and pass the GED test in a single attempt

Barbara Rolston

Barbara Rolston holds a master's degree. Since 1975, she has been taught GED preparatory classes in a variety of settings, including adult schools, community colleges, and large corporations. She also was responsible for administering the GED exam in a correctional facility for two years. Math experience includes tutoring community college students on a wide range of math topics and serving as a math consultant for a nationwide adult student assessment system.

Learn essential Spanish for teachers so that you can bridge the communication gap with your Spanish-speaking students and parents! By the end of this course, you will be well on your way to becoming a Spanish speaker and effectively communicating with the Spanish-speakers all around you.

If you struggle to communicate with your Spanish-speaking students and their families, and you don't know your cabeza from your codo (that's your head from your elbow), don't worry—help is here!

Whether you took a Spanish class 20 years ago and just want to brush up a bit, or you have never taken a Spanish class, you will learn the essential Spanish for teachers and bridge the communication gap with your Spanish-speaking students and parents. Rest assured that this won't be anything like your typical high school Spanish course. You will learn new words in easy-to-digest bites, and each lesson will include Supplementary Material to help you keep expanding your vocabulary.

This course starts with the basics of Spanish pronunciation and then moves right into simple words for everyday things, such as colors, numbers, and question words. It then moves on to conversational phrases, family names, and directions. You will understand what it's like on the first day of school and words relating to enrolling new students, conversing in the classroom, talking about rules and behavior, and basic vocabulary for various academic subjects.

Finally, you will discover some survival phrases for the parent-teacher conference as you learn to describe how a child is doing, talk about academic or behavior problems, and discuss grades and homework. By the end of this course, you will be well on the path to becoming a Spanish speaker and communicating more effectively with the Spanish-speakers all around you.

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 are preferred. Microsoft Edge and Safari are also compatible.
• 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.

Speaking, Spelling, and Counting in Spanish

In this lesson, you will discover that mastering the Spanish alphabet is as easy as A-B-C! You will also learn simple tricks for pronouncing Spanish words, and you will start building your vocabulary by learning to count from zero to nine.

Colors, Gender in Spanish, and More Counting Words

In this lesson, you will learn the Spanish words for a rainbow of colors and find out how to count all the way up to 199—all while learning fun facts about the culture of Latin America.

Talking About People

Family is all-important to many Spanish speaking cultures. In this lesson, you will find out how to say the names of all your students' relatives. Also, you will start putting your words into conversational phrases and sentences.

Words for Talking About "Who" and "When"

This lesson explores pronouns, an important building block of your Spanish vocabulary. In addition, you will learn how to talk about the months of the year and the days of the week.

Directional Words, Questions, and Prepositions

Supercharge your Spanish sentences with new power words! In this lesson, you will learn prepositions, words for directions, and three new words for asking questions.

Verbs, Verbs, Verbs!

If you think Spanish verbs are a big headache, you're in for a pleasant surprise. This lesson explores "easy" verb tenses and delves into the difference between the "to be" verbs, ser, and estar.

Off to School! Survival Phrases for the First Day

You will add to your repertoire of Spanish survival phrases in this lesson and discover a simple way to ask key questions when enrolling new students. You will also master an important new skill: telling time in Spanish.

Conversing in the Classroom

You're back-to-school to learn the Spanish words for common classroom objects and activities. In this lesson, you will strengthen your communication skills with a host of new adjectives that will come in handy both in and out of the classroom.

Words for Talking About School Rules and Feelings

"How are you feeling today?" By the end of this lesson, you will be able to ask and answer that question in Spanish! You will also know how to explain classroom rules, regulations, and instructions to students en español.

Vocabulary for Teaching and Learning

Words for teaching, learning, and doing are at the top of the agenda for this lesson. In addition, you will look at vocabulary builders you can use to explain concepts in English, math, science, and history.

Visiting the Cafeteria, Playground, and Nurse's Office

If you need to assist a student in the cafeteria or on the playground, you will have lots of helpful words at your fingertips after this lesson. You will also learn key vocabulary words for talking about those medical emergencies that sometimes happen on campus.

Making the Parent-Teacher Conference a Success

Parent-teacher conferences go much more smoothly when you can share information directly with Spanish-speaking parents or guardians. In this lesson, you will learn lots of new words for describing your students' strengths, pointing out areas where they can improve, and praising their achievements.

What you will learn

• Learn the basics of Spanish pronunciation
• Learn simple words for everyday things
• Learn conversational phrases and sentences
• Learn Spanish words for enrolling new students, conversing in the classroom, talking about rules and expectations, and basic vocabulary for academic subjects
• Learn phrases to use in the cafeteria and on the playground
• Learn survival phrases for the parent-teacher conference

How you will benefit

• Communicate effectively with the Spanish-speakers all around you
• Learn Spanish words that you can use in everyday school situations
• Confidently communicate with the parents of your Spanish-speaking students

Tara Bradley Williams

Tara Bradley Williams has authored several Spanish textbooks and occupational Spanish reference guides, including the "¡A Conversar!" and "¡A Trabajar!" series. She taught Spanish and English as a Second Language at the high school and community college levels for over 10 years. She has also operated a Spanish language school and served as a medical interpreter. Tara has BA degrees in Spanish and Sociology from St. Norbert College and an MA in Higher Education and Adult Studies from the University of Denver. She has studied Spanish at the Universidad de Ortega y Gasset in Toledo, Spain and has lived and traveled extensively in Spain and Latin America.

This course will teach you how to develop the motivation, discipline, and creativity to quit your job and be your own boss.

Starting a home-based business is the hottest trend in today's challenging business environment! Learn how to be your own boss and eliminate the stress of having a job. The benefits of working from home are endless!

Earn what you deserve, be independent, have tax deductions, do away with traffic, office politics and more! Learn how to develop the entrepreneurial qualities - motivation, discipline, creativity - that you will need to succeed! This class is a great way to start your own business or enhance the one you already have.

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 are preferred. Microsoft Edge and Safari are also compatible.
• 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.

Introduction to Home-Based Businesses

This lesson will introduce you to the variety of reasons why most people want to operate their own home-based business. You'll take an honest look at the benefits as well as the challenges of working at home. Then, you'll see what it takes to be an entrepreneur—and if this lifestyle will work for you.

Selecting a Business

What kind of home-based business should I start? Have you asked yourself this question? Hopefully so, because this is one of the most important issues you need to consider. By thoughtfully exploring your options, you'll spare yourself costly mistakes that come with sinking your time, money, and energy into the wrong business. In this lesson, you'll focus on your talents and abilities so that your home-based business will be a great fit!

Names, Logos, and Legal Protections

Having the right name and look for your home-based business is essential. In this lesson, you'll find out how to create the image that will draw customers to you and bring them back time and again. You'll get creative with names and logos, and then you'll learn how to protect your work with fictitious name statements, trademarks, copyrights, and patents.

Zoning, Licenses, Permits, and Insurance

Did you know that not all businesses are allowed to operate from a private residence? It's vital that you are familiar with the rules and regulations for the area you live in—before you start! For that reason, you'll explore zoning laws, licenses, permits, and insurance issues in this lesson.

The Business Plan

If you want your business to succeed, then you'll need to write an effective business plan. Your home-based venture is like a road trip; to get where you want to go, you need a map that shows you where you're starting from, where your destination is, and which route you want to take. In this lesson, you will learn how to put together a step-by-step action plan. This requires thorough research into each area of your business, so plan to roll up your sleeves and get to work!

Creating a Marketing Plan

To make your business thrive, you need to market it like a professional. So in this lesson, you'll learn how to create a marketing plan. Simply providing terrific products and services is not enough—you need to know who make up your marketplace, what your objectives are, and what your competition is up to. Remember, a home-based business doesn't have a convenient storefront. You've got to be creative about letting people know what you do.

Sales Techniques

In this lesson, you'll learn a lot about the fine art of selling your product or service. It's so important to be real, to listen, and to know how to bargain and close the sale. Sound scary? Many people get cold feet when it comes to sales. Don't worry though, because this lesson will give you the key to effective selling: Developing relationships based on trust and credibility.

Banking, Record Keeping, and Taxes

Are you just dying to learn about banking, record keeping, and taxes, right? No? Well, they're not the most exciting topics, admittedly, but they are crucial to your business. In this lesson, you'll learn about expenses and deductions, maintaining the appropriate records for all your revenue, categorizing your expenses, and keeping track of sales tax. Grab a cup of coffee, and keep your eyes open for this lesson!

Setting Up Your Home Office

Do you know how to set up your office for maximum efficiency? If not, then you've come to the right place. Conducting your business from the kitchen table is really not the ideal situation. So join me and see how to find just the right area in your home that will allow you to work in a sane and productive fashion. Learn how to set boundaries for your office, figure out what size office and setup you need, and make sure your office is ergonomically and aesthetically pleasing. Taking the time to set up your home office today is an investment in your future.

Organize Your Business for Success

In this lesson, you'll delve into getting organized. To some people, the word organize sounds constricting and limiting—everything has a place and must be in it at all times. It's time to toss that idea right out the window! The goal in organizing your business is to give yourself freedom. Whether you're dealing with paperwork or time management, your system of organization should not restrict or confine you in any way. Come and see how organizing will work for you and never against you.

Your Professional Image

One thing entrepreneurs often overlook is their professional image—how their business looks to the outside world. When your 5-year-old answers the phone and starts playing guessing games with potential customers, or when your computer equipment is still running Windows XP, you've got an image problem! The impression you make through your image can bring customers to you or drive them to your competition. So, in this lesson, you'll look at what not to do and what to do regarding your personal appearance, attitude, and printed materials.

Balancing Business and Family

In all your hard work of building a business, you don't want to forget the most important people: not your customers, but your family. You'll need to clarify expectations, reach compromises that work for everybody, and especially set boundaries. In this last lesson, you'll learn how to protect your work and your relationships and have fun with both. It's all a matter of balance.

What you will learn

• Learn how to protect your work with statements, trademarks, copyrights, and patents
• Understand zoning laws, licenses, permits, and insurance issues
• Learn how to put together business and marketing plans
• Gain key effective selling techniques
• Learn about banking, record keeping, and taxes
• Understand how your professional image can affect your business

How you will benefit

• Gain confidence in your ability to run a home-based business
• Learn how to be your own boss and eliminate the stress of having a job
• Understand how to protect your work and your family relationships to succeed with both

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.