Courses

Computer Software & Applications

Excel 2019 Advanced Topics

Excel 2019 Advanced Topics

[ 16 Hours ]

Compare Features
Course number: CC669419
Understanding how to use the many features of Excel 2019 is only half the battle. The other half is understanding what these features can do for you. So whether you are starting out or upgrading, using Excel on your desktop or tablet, this course covers what you need to know. In this course, you will delve into some of Excel’s more advanced topics such as: building and maintaining data lists; filters; queries; performing what-if scenarios; generating (and formatting, sorting, and modifying) pivot tables; building and running macros; and VBA programming. Course level: Intermediate. Prerequisites: An understanding of the basics of using Excel. Course includes integrated text and study guide, final exam, and grading service. Note: This version of Excel works only with Windows 10 or later.

NASBA field of study : Computer Software & Applications

Hard copy$109

PDF$109

Extra test(s)$40

Table of
Contents

Excel 2019 Basics

Excel 2019 Basics

[ 18 Hours ]

Compare Features
Course number: CC667519
Understanding how to use the many features of Excel 2019 is only half the battle. The other half is understanding what these features can do for you. So whether you are starting out or upgrading, using Excel on your desktop or tablet, this course covers what you need to know. In this course you will learn the basics: working with worksheets — learn to set up, edit, manage, format, edit, proof, reorganize, and print worksheets. Also covers how to customize Excel, how to use Excel on a touchscreen, and all the different ways to enter data. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam, and grading service. Note: This version of Excel works only with Windows 10 or later.

NASBA field of study : Computer Software & Applications

Hard copy$109

PDF$109

Extra test(s)$45

Table of
Contents

Excel 2019 Formulas, Functions, Charts and Graphics

Excel 2019 Formulas, Functions, Charts and Graphics

[ 12 Hours ]

Compare Features
Course number: CC668819
Understanding how to use the many features of Excel 2019 is only half the battle. The other half is understanding what these features can do for you. So whether you are starting out or upgrading, using Excel on your desktop or tablet, this course covers what you need to know. In this course you will learn how to build basic formulas, array formulas, date and time formulas, financial formulas, math and statistical formulas, and more. Also learn all about how to chart your worksheet data and add graphic objects like clip art, text boxes, WordArt, screenshots, graphics and more. In addition, you’ll learn how to use themes. Course level: Intermediate. Prerequisites: An understanding of the basics of using Excel. IMPORTANT NOTE: Excel 2019 is not compatible with versions of Windows prior to Windows 10. Course includes integrated text and study guide, final exam, and grading service.

NASBA field of study : Computer Software & Applications

Hard copy$79

PDF$79

Extra test(s)$30

Table of
Contents

Office 2019 - Part 1

Office 2019 - Part 1

[ 20 Hours ]

Compare Features
Course number: CC646719
Technology is supposed to help us get things done faster and more efficiently. With the tips, shortcuts, and how-tos in this course, you wi\'ll be able to do just that with Office 2019. Master all the features the different applications have in common, and then learn how to get the most from each individual part of Office. This course covers the ins and outs of Word 2019, Excel 2019, and PowerPoint 2019. You’ll learn how to create every type of document in Word; how to crunch numbers, design worksheets, and analyze data with Excel; put together and deliver PowerPoint presentations that get attention and really communicate; and more. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam and grading service.

NASBA field of study : Computer Software & Applications

Hard copy$119

PDF$119

Extra test(s)$50

Table of
Contents

Office 2019 - Part 2

Office 2019 - Part 2

[ 14 Hours ]

Compare Features
Course number: CC646819
Technology is supposed to help us get things done faster and more efficiently. With the tips, shortcuts, and how-tos in this course, you will be able to do just that with Office 2019. Master all the features the different applications have in common, and then learn how to get the most from each individual part of Office. This course covers the ins and outs of Outlook 2019, Access 2019, and special Office features. You’ll learn how to track and manage e-mail, contacts, tasks, and calendars with Outlook; create an Access database and discover how useful it can be; explore methods of customizing Office, creating brochures and newsletters with Publisher; and more. Course level: Basic. Prerequisites: A basic knowledge of Office or Course CC646719 (Office 2019 – Part 1). Course includes integrated text and study guide, final exam and grading service.

NASBA field of study : Computer Software & Applications

Hard copy$99

PDF$99

Extra test(s)$35

Table of
Contents

QuickBooks 2018

Available in PDF format only.
QuickBooks 2018

[ 16 Hours ]

Compare Features
Course number: CC662118
Discover how QuickBooks 2018 can help you build the perfect budget, process payroll, simplify your tax return prep work, create invoices, manage inventory, generate income statements, balance accounts, and much more. You\'ll learn what you should do before you install and set up QuickBooks. Also takes you through the steps of going online and backing up your data. You’ll learn how to: set up QuickBooks; enter data; create and populate lists; create invoices and credit memos; record and print sales receipts; monitor your job costs; record customer payments; make bank deposits; enter and pay bills; work with inventory; write checks; reconcile bank accounts; set up a credit card account; process payroll; perform job estimating, billing, and tracking functions; work with fixed assets and vehicles; generate most common financial reports; and more. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam, and grading service.

NASBA field of study : Computer Software & Applications.

PDF$109

Extra test(s)$40

Table of
Contents

QuickBooks 2019

QuickBooks 2019

[ 16 Hours ]

Compare Features
Course number: CC662119
Discover how QuickBooks 2019 can help you build the perfect budget, process payroll, simplify your tax return prep work, create invoices, manage inventory, generate income statements, balance accounts, and much more. You will learn what you should do before you install and set up QuickBooks. Also takes you through the steps of going online and backing up your data. You’ll learn how to: set up QuickBooks; enter data; create and populate lists; create invoices and credit memos; record and print sales receipts; monitor your job costs; record customer payments; make bank deposits; enter and pay bills; work with inventory; write checks; reconcile bank accounts; set up a credit card account; process payroll; perform job estimating, billing, and tracking functions; work with fixed assets and vehicles; generate most common financial reports; and more. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam, and grading service.

NASBA field of study : Computer Software & Applications.

Hard copy$109

PDF$109

Extra test(s)$40

Table of
Contents

Windows 10

Windows 10

[ 20 Hours ]

Compare Features
Course number: CC259602
Covers the latest version of Windows and gets you up and running with the changes and new features you\'ll find in this updated operating system. Shows you how to manage Windows tasks like navigating the interface with a mouse or touchscreen, connecting to the web, and troubleshooting problems and making quick fixes. You will be able quickly find files, connect to the Web, gather your email and social accounts in one spot, manage apps, create and manage accounts, use online tools, customize your settings, and much more. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam, and grading service.

NASBA field of study : Computer Software & Applications

Hard copy$119

PDF$119

Extra test(s)$50

Table of
Contents