Ultimate Computer Skills for the Workplace Online Bundle, 10 Certificate Courses

Learn How to Implement the Powers of Modern Office Software


NOW ONLY

US$1199

Save US$4801 (80%)
OFF RRP US$6000
Get Info Pack

Get Computer Skills for the Workplace, Introduction to Microsoft Project 2016, Introduction to Microsoft Excel 2016, Introduction to QuickBooks 2016, Introduction to QuickBooks, Introduction to PC Troubleshooting, Introduction to Photoshop CS6, Introduction to InDesign CC, Introduction to SQL and Understanding the Cloud in this Bundle

1. Computer Skills for the Workplace: Learn How to Implement the Powers of Modern Office Software

Most jobs today require a working knowledge of certain computer skills. Employers seek and reward employees with the skills and knowledge to send messages across the country via e-mail; use a spreadsheet to create a graph and paste it into a report; add and edit data in a database; understand the implications of file sizes, memory limitations, and network arrangements; 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 computer skills for the workplace online 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.

We'll focus on practical application for software most common to the workplace. When you finish this course, you will have learned why employers consider technological literacy so critical to the success of any organization.

2. Introduction to Microsoft Project 2016: Start Now To Learn Introduction to Microsoft Project 2016

Discover how to effectively plan, implement, and control projects using Microsoft Project 2016. From sequencing tasks, producing a baseline, and assigning resources and costs, to tracking progress, analyzing variances, and revising your project plan, Microsoft Project can help you organize all your project's details quickly and effectively.

In this course, you'll master the basics of Microsoft Project 2016 so you can create a project schedule in no time flat and then share it with clients and co-workers. Using the program's different views, such as the Calendar and Gantt Chart views, you'll manage your project information and produce effective reports. Armed with this information, you'll avoid going down dead-end alleys and overloading your schedule. And should you encounter trouble, you'll master a number of tried-and-true problem-resolution techniques to help get your project back on track.

You'll also learn how to fine-tune different aspects of your project, including splitting tasks for work interruptions and defining material consumption rates. After completing the course, you'll know how to develop, implement, and control a project plan that meets organizational and customer objectives.

3. Introduction to Microsoft Excel 2016: Learn How to Master Microsoft Excel 2016

Do you work with numbers? Then you need to master Microsoft Excel 2016 (now available through Office 365)—and this is the place to do it. Even "non-techie" beginners will find it easy to learn Excel in this fun, step-by-step online course.

These lessons will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more.

In addition, you'll get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. This informative course covers Quick Analysis, Flash Fill, and powerful charting capabilities available in Excel 2016.

This is not a tutorial, but an in-depth class where you'll get training, help, and personal support from an experienced instructor as you're learning Excel basics step-by-step. By the time you're done, you'll be using this vital Office 2016 tool like a pro.

4. Introduction to QuickBooks 2016: Take Control of the Financial Accounting for your Business

Learn to manage the financial aspects of your small business quickly and efficiently with this powerful accounting software program. QuickBooks is designed especially for the small- to midsized-business owner who needs a fully functional accounting system that's also easy to use.

In 12 lessons, you'll gain hands-on experience as you master the tools you need set up a chart of accounts; reconcile your checking account; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create estimates; and generate reports.

Whether you're new to QuickBooks or have already used earlier versions of this accounting software program, this course will empower you to take control of the financial accounting for your business.

5. Introduction to QuickBooks: Learn to Manage the Financial Aspects of your Small Business Quickly and Efficiently Using QuickBooks Online

This powerful accounting software program has helped thousands of business owners just like you manage their finances. With the online version, you also gain all the advantage of computing in the cloud, so that your files will be available to you virtually anytime, anywhere.

As we explore the pros and cons of online accounting, you'll soon see how easy it is to use the navigation features of QuickBooks Online. Then you'll gain hands-on experience as you learn all the ways this well-designed accounting program makes it a snap to manage your business' finances—from recording income and expenses, to entering checks and bank transfer entries, to setting up a chart of accounts. You'll see how to reconcile your checking account and manage credit card and loan payments; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create estimates; generate reports; and much more.

Whether you're new to QuickBooks or have already used other versions of this software program, this course will empower you to take control of the financial accounting for your business, all with the ease and convenience of an online platform.

6. Introduction to PC Troubleshooting: Start Now To Learn Introduction to PC Troubleshooting Online Course

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? Let's troubleshoot - and fix - some PCs!

7. Introduction to Photoshop CS6: Master the Secrets of Photoshop CS6

You'll learn how to use Photoshop with detailed, step-by-step instructions that you'll have no trouble following—even if you've never used a computer graphics program before! And you'll have a lot of fun doing it.

Photoshop CS6 has a host of impressive new features for photographers, and you'll encounter a number of them. We'll begin with an introduction to the Photoshop environment. Next, you'll learn techniques for creating simple digital paintings (including some brushes that let you create the look of an oil painting from a photo).

Then you'll be editing your own photographs to get rid of dust and scratches, fix the color, and correct image exposure. You'll master techniques for switching the backgrounds on images and removing wrinkles and blemishes from photos, just like they do in magazines. You'll also learn about the new content-aware Move tool in CS6 that, like magic, lets you move something on an image while intelligently replacing the "hole" left behind.

By the time you finish this fun, hands-on, project-oriented Certificate in Introduction to Photoshop CS6 Online Course, you'll be well on your way to expressing yourself with the most exciting graphics program ever developed.

Photoshop is the world's best-known photo-editing program. Artists, photographers, designers, and hobbyists all rely on Adobe Photoshop for image creation and editing. Discover the fastest and most effective ways to use Photoshop from an expert and former columnist for Photoshop User magazine.

8. Introduction to InDesign CC: Start Now To Learn Introduction to InDesign CC

Have you ever seen a terrific-looking brochure or newsletter and wondered how it was made? Chances are the designer used Adobe InDesign CC, the industry-standard desktop publishing software now available through the Creative Cloud. The course is applicable to any version of InDesign CS4 or newer.

In each lesson, we'll cover an important aspect of InDesign CC as you prepare a range of print and online products for a fictional company, Natalie's Nautical Emporium. You'll get dozens of files to work with, including a partially completed InDesign document used to start each lesson. Then you'll use the downloaded graphics, images, fonts, and other content to complete the project. And to check your work or troubleshoot any problems you encounter, you'll always get a copy of the finished InDesign project file.

Lesson by lesson, you'll discover how the program features relate to producing actual usable documents as we explore the best ways to create different types of material, how to reuse items such as colors and artwork, and how to produce publications for different page sizes and devices. You'll come away knowing how to use this popular page layout software to design and create professional-quality letterhead, business cards, brochures, forms, interactive PDF files, an eBook, and more. You don't have to be a designer or an artist to produce professional quality documents!

9. Introduction to SQL: Learn the Fundamentals of SQL

In this comprehensive 12 module certificate, you'll learn how to read and write simple and complex SQL statements, and advanced data manipulation techniques.

Starting off with database basics you'll explore basic structure and the history of relational databases, learn to understand what SQL is and how it is used. As you progress through the content you will learn sorting and retrieving data, filtering data, calculated fields and fuctions, sumarizing and grouping data, working with subquiries and much more.

By the end of this course you will have a great understanding of the fundamentals of SQL and be prepared to move deeper into understanding more advanced systems.

10. Understanding the Cloud: Start Learning to Understand the Cloud

What is the cloud? If you have trouble answering this question, you're not alone. In this course, we'll explore how the cloud works, what drives its incredible growth, and how you can use cloud services. And don't worry if you're not tech-savvy! We'll relate the cloud to things you encounter every day, using practical, non-technical language.

We'll start by looking at the building blocks of the cloud, where it started, and how it transitioned from an experiment into an unstoppable force. You'll also gain a clear understanding of IaaS, SaaS, and PaaS, and see why each may be attractive to some businesses, but not others. And you'll learn about the different kinds of clouds (public, private, and hybrid).

We'll also take an inside look at the engine rooms of the cloud: data centers. You'll examine the concept of big data?the overwhelmingly huge amounts of data that make analysis so challenging—and how the cloud infrastructure enables data to zip across the globe at lightning speed.

Social networking has also played an incredibly important role in the growth of the cloud. We'll examine how Facebook and Twitter contribute to the cloud, and how apps go from idea to app store. You'll gain an understanding of how mobile devices and major mobile ecosystems?like Apple, Android, and Windows?continue to shape the cloud, and how start-ups can use social media to shake things up like never before.

So come see how the how the cloud can work for you! Whatever your technical background, by the end of this course, you'll be thoroughly cloud-savvy.

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. This course is delivered 100% on-line and is accessible 24/7 from any computer or smartphone
  2. Instructors lead each course and you will be able to interact with them and ask questions
  3. You can study from home or at work at your own pace in your own time
  4. You can download printer friendly course material or save for viewing off line
  5. You will be awarded a certificate at completion of this course

How to study online course?

Upon enrolment an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. New courses start every month to ensure that we have the correct ratio of students to tutors available, please ensure you select a starting date when you go through our shopping cart, at checkout. The course is easy to follow and understand.

Recognition & Accreditation

All students who complete each course receive a certificate of completion per course, with a passing score (for the online assessment) and will be issued a certificate via email.

Ultimate Computer Skills for the Workplace Online Bundle, 10 Courses includes the following courses, below is a summary of each course: 

Course 1 - Certificate in Computer Skills for the Workplace Online Course

There are 12 units of study

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: E-Mail 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 Macintosh 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 e-mail, 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 multi-media. 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, 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 one 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.

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 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 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! 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.

Course 2 - Certificate in Introduction to Microsoft Project 2016 Online Course

There are 12 units of study

Lesson 01 - Overview of Microsoft Project
Microsoft Project can help you manage your project's schedule, costs, and scope in a way that you've never dreamed of. Too often, Project users never use this powerful tool to its fullest potential. In your first lesson, you'll discover how to improve your project by adopting a formal management approach. You'll get a quick overview of Project Management, and then you'll learn the basics of Microsoft Project, including a summary of the Gantt Chart view and ways to create and enter project tasks.

Lesson 02 - Creating a Solid Foundation
If you're looking for ways to keep organized, you'll see just how to do that in today's lesson! We'll walk through steps to create a project schedule in no time flat. Once you create and enter tasks in Project's Gantt Chart view, you'll set a schedule by using a calendar and assigning lead times. Then, you'll need to create task dependencies, sometimes known as links. You'll see how to perform these activities and, in the process, you'll become comfortable using Project's many dialog boxes. Before you know it, you'll be creating schedules for all your projects with little effort.

Lesson 03 - Creating and Managing Resources
You won't get too far with your project without adding resources. While tasks create the backbone of your project, people, equipment, and material bring your project to life. In this lesson, you'll find out how to apply two types of Project resources—work resources, and material resources. We'll look at two more dialog boxes—Resource Information and Assign Resources—and you'll learn how to analyze resources by using the Resource Sheet and Resource Usage views.

Lesson 04 - Defining and Assigning Costs
No matter what project you work on, the bottom line is always important. So get ready to add the final piece to your basic project schedule—costs. We'll start things off by looking through a brief overview of cost accounting, exploring fixed, variable, relevant, and accrued costs. After this review, you'll learn how to assign costs by using the Resource Sheet. You'll even discover how to assign different costs for the same resource and analyze the overall costs for your project by using the Cost Table.

Lesson 05 - Project Templates, Security, and Constraints
Successful project managers are known for their efficiency and for safeguarding private information. Microsoft Project provides two excellent methods to help you in these areas: project templates and project security. You'll find out how to use some of the many templates Project has to offer, including the Residential Construction template and the New Product template. You'll also learn how to protect your project information with backups, passwords, and write protection. Then you'll discover how to put Project's task constraints to good use.

Lesson 06 - Working With Views and Managing Information
In this lesson, you'll discover how easy it is to modify your basic schedules and work with project data. You'll look at the various Project views, such as the Calendar, Leveling Gantt, and the Network Diagram. And if you don't like the default colors or fonts in your schedule or table, you'll be well-prepared to make changes. You'll even learn how and why you might want to create a combination view; add notes to your project; or sort, filter, and group data.

Lesson 07 - Fine-Tuning Your Project Plan
Many projects experience schedule compression when management or clients ask that the project be completed sooner and for less. In today's lesson, you'll discover how to improve your schedule's performance. You'll explore the Project Statistics dialog box, and you'll learn how to determine the ideal starting point in terms of planned costs and completion dates. You'll see how to change task dependencies to speed up your project and also find out how to split tasks to add more lead time. You'll also learn how to create recurring tasks and attach notes to your project's taskbars.

Lesson 08 - Baselines and Tracking
Before you implement your project, you need to create a baseline. This will help you track actual results against what you originally set out to accomplish. Microsoft Project makes it possible to set up a baseline with a few mouse clicks. You'll learn how to create a baseline and then see a variety of ways, including using the Tracking toolbar, to record your actual project results.

Lesson 09 - Managing Variances
Here's where things really start to come together! You'll learn how to compare actual results to your baseline by using the Gantt Chart and reviewing a table. You'll discover how useful status identifiers and progress lines can be to quickly gain information about your project's position. You'll also begin using the Tracking Gantt and filters to automatically identify slipping tasks. You'll also take a stroll through the basics of variance analysis by discussing the Start and Finish Date, Resources, and Work Variance Tables.

Lesson 10 - Using and Creating Reports
Once your project gets rolling, outsiders will probably want to know how things are going. It can be a real time drain answering each request individually. When others request information from you, Microsoft Project offers the perfect solution: Reports. We'll go over a representative sample of the standard reports as well as discuss how to modify and create new reports in today's lesson. By the time you finish, you'll be well acquainted with Project's reporting capabilities and also know how to create Visual Reports as Project automatically exports data to Microsoft Excel and Visio.

Lesson 11 - Printing Views
Now that you're using reports to share project information, you'll occasionally need to print various views and tables. In this lesson, you'll delve into printing Microsoft Project documents. You'll be a master at creating different views of your project with the Page Setup dialog box, and you'll clearly understand the mechanics of the Print dialog box and the Print Preview.

Lesson 12 - Closing Your Project
No project is complete until it's officially closed. In this final lesson, you'll find out how to close your project and use the Organizer to help you customize and copy views for future projects.

Course 3 - Certificate in Introduction to Microsoft Excel 2016 Online Course

There are 12 units of study

Lesson 01 - Excel Basics
In our first lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas.

Lesson 02 - Creating a Worksheet
In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted.

Lesson 03 - Time-Savers
Our third lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. We'll also spend some time working with the Quick Analysis and Flash Fill tools. By the time you finish this lesson, you'll really start to feel like an Excel pro.

Lesson 04 - Relative, Absolute, Mixed, and Circular References
Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. Today, we focus on writing sophisticated formulas that can help ease us through some rather sticky scenarios.

Lesson 05 - 3-Dimensional Workbooks
With enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. Today, you'll join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks.

Lesson 06 - Sorting, Subtotaling, and Filtering
No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. Today, you'll not only learn how to build a table in Excel, you'll also learn how to subtotal, sort, and filter.

Lesson 07 - Charting Basics
In this lesson, we'll explore the exciting world of charts. You'll build your first graph today, and you'll learn how easy it is to adjust the chart type, labels, titles, colors, and many other aspects of your chart.

Lesson 08 - Advanced Charting Techniques
Today, you'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3-D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings. You'll also discover the best ways to format your chart for print or otherwise display the truly impressive charts that you'll be creating.

Lesson 09 - Intro to Excel's Statistical Functions
Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In today's lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers.

Lesson 10 - Financial Functions
We'll continue our exploration of Excel functions with an in-depth look at Excel's handy financial functions today. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time.

Lesson 11 - Worksheet Automation
Students often rank this lesson as one of their favorites. Today, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how you can use macros to reduce just about any complex task to a single keystroke.

Lesson 12 - Mastering Excel's IF Function
I think you'll be intrigued by our final lesson, in which you'll learn how to use Excel to aid you in decision making. We'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.

Course 4 - Certificate in Introduction to QuickBooks 2016 Online Course

There are 12 units of study

Lesson 01 - Getting Started
In our first lesson, you'll become familiar with the QuickBooks interface. You'll find out how the pros use QuickBooks to simultaneously manage common accounting tasks for multiple companies, you'll get to set up a QuickBooks Company of your very own, and you'll learn some QuickBooks terminology.
We'll be practicing many new skills in this class, so it's important that you have a copy of QuickBooks installed on your computer before you begin.

Lesson 02 - The Chart of Accounts
The Chart of Accounts is the heart and soul of QuickBooks. In today's lesson, you'll learn how to take fullest advantage of this powerful tool to add, edit, and access accounts that you can use to track the value of your business or monitor your income and expenses.

Lesson 03 - Company Lists
Today, we'll learn how to use company lists in QuickBooks to gather and organize all of the information you'll need to properly conduct your business. By the time you finish this lesson, you'll know how to store and retrieve all manner of useful facts, including data on customers, vendors, products, services, important events, and more.

Lesson 04 - Bank Accounts
Today, you'll become comfortable working with bank accounts in QuickBooks. You'll learn how to tell QuickBooks about checks, withdrawals, and transfers between accounts. You'll get firsthand experience with adding, finding, and editing or voiding all manner of checking and savings account transactions. You'll even be prepared to reconcile your QuickBooks checking account with your monthly bank statement to ensure that no errors were made.

Lesson 05 - Fixed Assets and Depreciation
The physical objects you rely on to help you run your business (like furniture, machinery, vehicles, computers, telephones, or even the building that houses your business) all have significant value. The total value of these assets has a direct impact on the overall worth of your business, and there are tax implications if you sell an asset or if its value changes. That's why it's important for you to keep an accurate tally of everything your business owns. Today's lesson will provide you with plenty of opportunities to do just that.

Lesson 06 - Accounts Payable I
Without an organized system for managing all the bills your business receives, they can really start to stack up. And when bills pile up, it isn't hard to overlook one or two from time to time. That, of course, can result in late fees and credit difficulties. Today, you'll learn how to use QuickBooks to make sure you're paying all of your bills right on time—not too early, and not too late.

Lesson 07 - Accounts Payable II
Today, we're going to finish our discussion of QuickBooks' accounts payable tools. You'll learn how to get QuickBooks to memorize bills that you find yourself paying over and over again, month after month. Then, you'll learn how to create some useful accounts payable reports.

Lesson 08 - Accounts Receivable I
You'll find today's lesson useful if your business ever finds itself required to collect payment from a customer long after the products or services have been delivered. Today is the day you'll get some hands-on experience with invoicing. You'll find out how to create an invoice, fill it with invoice items, edit it, print it, and even email it to your customers.

Lesson 09 - Accounts Receivable II
Okay, so you've created an invoice and delivered it to your customer. With a little bit of luck, your customer will place the invoice on his or her "to-do" list and, eventually, you'll receive some form of payment for your troubles. Now what? You'll find out in today's lesson.

Lesson 10 - Accounts Receivable III
Today, we'll explore some useful customer-related reports that can help you keep track of exactly who owes you what. Then, you'll learn what to do if you ever incur a charge on behalf of a customer and wish to be reimbursed for that expense.

Lesson 11 - Inventory and Estimating
Today, you're going to learn how to customize your QuickBooks invoices to give them a more professional look. You'll also learn how to work with two of QuickBooks' more advanced features: inventory tracking and estimating.

Lesson 12 - Reporting
In our final lesson, you'll find out how to create, use, and memorize a wide variety of useful reports that can help you locate, organize, sort, total, summarize, and otherwise make sense of all those transactions you've painstakingly entered into QuickBooks

Course 5 - Certificate in Introduction to QuickBooks Online Course

There are 12 units of study

Getting Started
In our first lesson, you'll get familiar with the QuickBooks Online interface and explore the pros and cons of working with your accounting information online. We'll discuss the various subscription packages available, and you'll get to practice using some of the navigation and interactive features that allow you to quickly get around in the program.
    
The Chart of Accounts
The Chart of Accounts is the heart and soul of QuickBooks. In today's lesson, you'll learn how to take full advantage of this powerful tool to add, edit, and access accounts that you can use to track the value of your business or monitor your income and expenses.

Centers and Lists
Today, you'll learn how to use centers and lists in QuickBooks to gather and organize all of the information you'll need to properly conduct business with customers and vendors. By the time you finish this lesson, you'll know how to store and edit various types of information, such as addresses and payment terms, for your customers and vendors. You'll also learn how to process Form 1099 to give to your vendors at the end of the year.
    
Bank Accounts
Today, you'll get comfortable working with bank accounts in QuickBooks Online. You'll learn how to create a new bank account, connect it online, and download, match, and add transactions. Then you'll learn how to reconcile your checking account with your monthly bank statement to make sure that neither you nor the bank made any errors.

Recording Expenses—Part 1
Keeping track of the checks and other expense transactions your business incurs is one of the most critical aspects of your daily operations. In this lesson, you'll learn how to utilize QuickBooks' built-in features to enter check transactions and bank transfers like a pro. You'll also learn how to record expense transactions where you may have utilized your debit card as payment or paid the amount online. You'll even learn how to label an expense as billable so that you can later request reimbursement from a customer. Finally, you'll practice with creating a recurring transaction template that may help save you some valuable data entry time!

Recording Expenses—Part 2
Without an organized system for managing all the bills your business receives, they can really start to stack up. And when bills pile up, it isn't hard to overlook one or two from time to time. That, of course, can result in late fees and credit difficulties. Today, you'll learn how to enter, edit, and pay all of your bills right on time. You'll also learn how to enter and apply vendor credits to an existing or future bill.

Credit Cards and Loans
In this lesson, you'll learn how to effectively manage Credit Card accounts in QuickBooks Online. We'll explore how to create a new Credit Card account and enter charges to that account as they occur. You'll also learn how to enter a full or partial payment of the credit card balance when it comes time for payment. Finally, you'll get the chance to create and enter a new loan balance resulting from the purchase of a long-term asset such as a vehicle or piece of equipment.

Recording Income—Part 1
You'll find today's lesson useful if your business ever sells a product or service and collects payment on the sale immediately. Today is the day you'll get some hands-on experience with creating products and services. Then you'll find out how to create multiple Sales Receipts and make the necessary deposit to your bank.
    
Recording Income—Part 2
In order to evaluate just how well your company is performing, you'll need to learn how to enter estimates, invoices, and customer payments. You'll do just that in this lesson. You'll also learn how to group multiple customer payments and record those deposits to the bank.

Recording Income—Part 3
Today, you're going to explore how to bill a customer for an expense incurred on a project or job. You'll even see how you can add a markup percentage to the amount you include on the customer invoice. Also, you'll examine the steps needed to enter credit memos, delayed credits, and refunds.
    
Customizing Sales Forms and Recording Fixed Assets
Today, you're going to learn how to customize your QuickBooks sales forms to give them a more professional look. You'll also learn how to record long-term fixed assets and record depreciation on those assets.

Sales Taxes and Reports
In our final lesson, you'll learn how to work with the sales tax features in the program to collect and remit taxes you collect from customers. You'll also find out how to create, use, and customize a wide variety of useful reports that can help you locate, organize, sort, total, summarize, and otherwise make sense of all those transactions you've painstakingly entered into QuickBooks Online.

Course 6 - Certificate in Introduction to PC Troubleshooting Online Course

There Are 12 Units Of Study

The Computing Process
Lesson 1 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
Lesson 3 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
Lesson 4 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
Lesson 6 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
Lesson 7 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 I’ll walk you through the five-step process of recovering from a virus infection. You’ll also read about safe browsing and safe email use, and you’ll 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, I’ll teach you about the power of different PC parts, including what to look for when shopping for new parts. I’ll also guide you in 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 I'll show you safe and effective ways to check, clean, and maintain the inside and outside of your computer. We'll also talk about how to donate an old computer, and I'll explain 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, I'll remind you about the computing process and about troubleshooting theory. Combined with your new knowledge of PC hardware, software, and networking, you can use these tools to fix all sorts of problems. I'll also discuss your future as a PC troubleshooter, including the certifications and careers available to anyone with the right skills.

Course 7 - Certificate in Introduction to Photoshop CS6 Online Course

There are 12 units of study
 

Introducing Photoshop
Your journey begins. Whether you're an aspiring graphic artist or a weekend photographer, Photoshop can take you places you've never dreamed of. Even if you've never touched Photoshop before, you'll be able to open, edit, and save files before this lesson ends. You'll also find out how to download images, and you'll learn simple commands that make an image "pop."
 
Choosing Colors and Painting
Did you like playing with paints as a child? In this lesson, you'll discover how enjoyable it can be to paint in Photoshop—where you don't need to clean up after yourself, and there's no odor of turpentine. You'll find out how Photoshop "thinks" about color and how you can use the brushes inside Photoshop to make a simple landscape. You'll even blend colors on your image as if they were made of oil paints or watercolors. This is a fun lesson!
 
More Brush Tools
Zoom, Scrubby Zoom, Airbrush, Eraser, Smudge: Do you know what these tools and commands mean in Photoshop? You will! In this lesson, you'll find out how to navigate your image so that you can edit and paint more effectively—and give your eyes a rest too. You'll also learn how to erase, blur, smudge, and finger paint. These techniques are fun, easy ways to make dramatic changes in your images, whether you're altering photos or creating a work of art from scratch.
 
Colorizing Images
Have you seen ads or greeting cards where most of the image is in black and white but one part's in color? Today you'll find out how to create that effect. You'll be amazed at how easy it is to transform images from color into black and white or even old-fashioned sepia. We'll also cover some tricks with the History Brush tool and history snapshots, so you can experiment while you're creating a hand-tinted image . . . and quickly undo whatever steps you don't like.
 
Making and Saving Rectangular and Oval Selections
If you wanted a friend to hand you an orange from a fruit bowl, you'd probably just point to the one you want or describe its location. Photoshop also needs directions if you want to lift something out of an image or point it out in some way. The Photoshop name for "pointing" is selections. In this lesson, you'll learn the critical skill of making selections. You'll see how easy it is to isolate portions of your image so that you can add a filter or change the colors. You'll also create vignettes, which are photos with an opaque center that falls off to a very soft edge. And if you don't like the selection you just made, you'll get help from the Refine Edge command.
 
Using Additional Selection Tools
Photoshop has some great selection tools, but until now, all of them have had trouble selecting exactly what you had in mind. You can see the flower, so why can't Photoshop? Today you'll learn to use the Lasso, Magic Wand, and Quick Selection tools to make the selections you want as you practice putting two images together.
 
Creating and Customizing Brushes
You can paint in Photoshop—even if the only thing you can do with paint in "real life" is spill it! Photoshop lets you create fabulous brushes from images and customize them in many ways. You can modify the new bristle-tip brushes to help you turn photos into art . . . or to create your own work of art just by using brushstrokes.
 
Discovering Gradients
Gradients are fountains of color. One of the current trends in photography is to colorize areas of a photo with a gradient. You can spend hundreds of dollars buying gradient-colored stock photos—or just use what you learn in this lesson to create them yourself! Even portraits can be much more exciting with a gradient added to them.
 
Setting Type and Adding Effects to Text
Whether you want to add type to a scrapbooking layout, make large type for display, or learn a little bit about Photoshop's Layer Styles, you'll enjoy this lesson. You'll try your hand at making type that warps, wiggles, and follows a path. Then you'll see what you can do to text on your own.
 
Setting Image Resolution and Image Sizes for Input and Output
Today you'll learn how to size your images for printing or for the Web. You'll find out how to scan an image so that it's large enough for your needs, but not too large, and how to crop images that have more than you really want to see.
 
Fixing Images
In this lesson, we'll focus on the three R's of photo manipulation: restoring, retouching, and rearranging. You'll be amazed by what you can do—and you'll understand why the phrase "pictures can't lie" is no longer true! You'll also discover how to use the amazing Clone Stamp panel and the "preview" feature on the Clone Stamp brush cursor. Plus you'll learn about the content-aware tools that help Photoshop make more intelligent guesses as to the fixes you want.
 
Correcting Exposure, Color, and Tonal Value
Are some of your images overexposed, underexposed, or tinged an ugly yellow? In this lesson, learn how to correct exposures and colors to make them more attractive and truer to life. Photoshop can't work miracles all the time, but if you have an image that's a bit too dark or a bit too light, you can fix it up so that it looks perfect.

Course 8 - Certificate in Introduction to InDesign CC Online Course

There are 12 units of study

Making Your Way Around InDesign CC

Wouldn't it be terrific if you could use one program to create all the different types of print materials you need for your small business, organization, or family—such as letterhead, forms, and even brochures and business cards? Well, you can! We'll spend this first lesson going over all the different types of content you can produce with InDesign. We'll explore the InDesign workspace and tools, and then we'll get right to work on our first project—a logo for the fictional business we'll create materials for throughout this course

Setting Up a New Document

Today, you'll learn all about starting and saving a new document. What's one of the most common types of print documents? If you said, "letterhead," you'd be right and well on your way into this lesson's project. By the end of the session, you'll know how to choose settings for a new file, add background images, and organize your content to create a custom letterhead. You'll also add a second page to create a matching envelope, and you'll learn how to add a custom Master page for the envelope. And as in all of our lessons, we'll go over how to use the specific colors, styles, and logo for our fictional business, but you'll be able to use the same techniques for your personal business or projects

Organizing Objects on a Layout

Organization is a key ingredient in successful work of any kind, and it's critical to successfully using InDesign. In this lesson, you'll learn about organizing in two ways. First, you'll see how to use aworkflow, or an order of operations for creating an InDesign publication. Then we'll go over how to organize materials on a page and how to use many of InDesign's tools for aligning, organizing, and laying out your content. In the process, we'll complete three projects: a sheet of address stickers, a sheet of business cards, and a reusable business card template.

Setting Up a Multipage Document

Many of your projects will use multiple pages with different layouts. Designing a catalog layout is the perfect way to learn these skills, and that's what we'll focus on today. We'll work with two different column layouts while exploring other InDesign features (like grids and document coordinates) that can help you lay out a page evenly. We'll also go over using graphic and text frame placeholders so you don't have to add content to the page to see its layout. For a final touch of realism, we'll use placeholder text during the design process to give you a good idea of how a page will look when you're finished. You'll see how to add a graphic into an existing frame and make it fit, as well as how to add content instantly using a file called a snippet.

Adding, Editing, and Threading Text

Managing text in precise and interesting ways is one of the big advantages of working with InDesign rather than a word-processing program. In this lesson, we'll begin a two-page brochure project that will take us two lessons to complete. In this first part, you'll learn different methods for adding text to your publication. Once the text is in place, you'll see how to check your text for typos and errors. We'll go over how to work with text in simple text frames and how to design threaded text (where the text slides through linked text frames on the page yet stays within the defined structure). We'll also use the Story Editor as an alternative to adding content in a layout view. You'll finish the lesson working with two columns in a single frame, and you'll see how to balance the content and auto-size the frame.

Importing Graphics and Images

The two key elements in any print project are, of course, text and images. We went over text in our last lesson, so today, we'll finish up our two-page brochure project by going over just about everything you need to know about working with images—adding them to the page in different ways, adjusting their positions, and using various commands for coordinating their sizes, proportions, and frames. We'll begin by adding images to the brochure project pages we worked on in Lesson 5, and then we'll check out some special ways to add batches of images at once to make an image collage and to place images in interesting frames. Speaking of interesting—you'll also see how you can use InDesign transparency effects to add pizzazz to any project. You'll wind up the lesson making a printable photo cube from a template.

Drawing and Working With Shapes

You might be surprised to learn that InDesign provides you with some of the same sophisticated drawing tools that you'll find in Adobe Illustrator. For example, InDesign offers the Pathfinder tool, which is the perfect tool to use if you need to combine simply drawn shapes and convert them into more complex and interesting objects. In this lesson, you'll learn how to work with some of the drawing tools to design a poster for a fashion show. You'll see how to draw several simple shapes and stack them using blend modes for interesting effects. One of the topics we'll go over is a text wrap, which is a special way to work with a drawing to tell InDesign where you want your text to display on your page. If you've ever wondered how to make text follow the shape of an object, curving around it on the page, our practice today will solve the mystery!

Managing and Applying Color

Did you know that your eyes can see over 16 million different colors? It's true! Fortunately, you don't have to work with that many colors in InDesign. But if you ever find yourself trying to choose between thousands and thousands of color possibilities, you'll understand why InDesign offers you so many different ways to work with your choices. In this lesson, you'll learn the best methods for choosing, naming, and organizing colors. You'll practice working with solid colors as well as gradients (which let you display a range of color within an object), and we'll round out the lesson by using some more special effects in today's fun project—a greeting card.

Designing Tables and Creating Forms

When you need to display bits of information in your publication and want to ensure it's easy to read, it's time to use a table. InDesign offers you lots of tools for designing and formatting tables while helping you make sure your content will coordinate with other documents. You'll see how this works today as we practice building tables for an invoice. You'll also find out how to use color tints in your table, as well as how to use styles to quickly and consistently reuse any of your layout features. Finally, we'll experiment with an interactive PDF form. You'll add some fields to a blank form, see how to configure a text field or button, and produce the PDF form.

Storing Text and Color Information

 Recycling doesn't just apply to items in your home or business. In this lesson, you'll see how to use the 3R's of recycling in InDesign to complete a newsletter project. As you recycle and modify colors and styles from previous lessons to create new styles in your newsletter, you'll also reuse a lot of the tools and skills you've used in previous lessons. Learning to effectively use all of InDesign's tools and features in a variety of different ways on many different projects is what it's all about!

Creating and Distributing a Complex Document

Whether you're designing publications for business, hobbies, or social or community activities, odds are you'll need to share them at some point. InDesign provides many options for exporting and reusing a document, as well as printing. We'll review a few of them today as we design a postcard using special fonts, colors, and image layout features. We'll also check out Kuler, the Adobe InDesign extension and online application used for color design. Have you ever seen text that shows an image of some sort through the letters and wondered how it's done? You'll know after today's lesson! By the time you finish this lesson, you'll know how to export a publication as an image, print directly from your desktop, or create a compact PDF version of your finished publication ready to email

Working With Color Separations, Special Layouts, and E-books

In this final lesson, we'll really test InDesign's versatility. First, we'll use a two-color version of the business cards you worked with early in the course and dig into color separations—a common method of preparing a file for a professional print shop. We'll try out special layout tools for producing alternate page layouts of different sizes in the same document. Finally, we'll wind up the course by creating an e-book.

Course 9 - Certificate in Introduction to SQL Online Course

There are 12 units of study

Module 1: Database Basics, and Structures Query Language

In our first lesson, we'll explore the basic structure and history of relational databases. Then, you'll understand what SQL is and how it is used with a relational database.

Module 2: Sorting and Retrieving Data

In this lesson, you'll learn how to use SQL to sort and retrieve data from tables. We'll talk about important query terms that enable you to communicate with your database, as well as syntax rules that will enable you to create clear and understandable queries while avoiding system generated errors.

Module 3: Filtering Data

In this lesson, you'll learn how to use SQL to filter retrieved data. You'll practice sorting retrieved data using the ORDER BY clause. You'll be able to sort single and multiple columns, and you'll know how to specify sort directions such as ascending and descending order. You'll also learn additional query terms that will help you customize your SQL queries.

Module 4: Calculated Fields and Functions

Today, you'll learn how to reformat retrieved data with calculated fields and functions. You'll also learn how to create alternate names for columns and you'll discover the secret behind merging columns with the concatenation symbol.

Module 5: Summarizing and Grouping Data

In this lesson, we'll discuss gathering significant statistics from data using aggregate functions. You'll also learn how to use the GROUP BY clause in conjunction with an aggregate function to gather important statistics from a table. Then you'll find out how to use the HAVING clause in conjunction with an aggregate function to filter groups of data from a table.

Module 6: Working with Subqueries

Today's lesson is all about subqueries. You'll learn how to extract data from multiple tables simultaneously, how to use calculated fields in subqueries, how to use the DATEPART () function in subqueries, and how to use aggregate functions in subqueries. Then we'll talk about qualification—a technique used to combine a table name with a column name so there's no question about which table the column name refers to.

Module 7: Creating and Using Table Joins

In this lesson, you'll learn how to use joins to gather information from two or more tables simultaneously. You'll learn how to use the inner join, self-join, natural join, and the outer join. Then you'll become familiar with the term Cartesian product.

Module 8: Inserting, Updating, and Deleting Data

In today's lesson, you'll discover how to manipulate data using the INSERT, UPDATE, and DELETE statements. You'll learn how to insert partial and complete rows into a table, and how to update information already stored in a table. You find out how to transfer data to a new table, how to transfer data to an existing table, and how to delete rows from a table.

Module 9: Table Creation and Maintenance

Today, you'll find out how SQL can be used to create and maintain tables. You'll learn how to use the CREATE TABLE keywords to create a table, then we'll discuss how to use the ALTER TABLE, DROP TABLE, ADD COLUMN, and DROP COLUMN keywords to manipulate the tables themselves. You'll also find out how to define a primary key, data type, and field size.

Module 10: Creating and Understanding Views

In this lesson, you'll learn how and why views are used in SQL. You'll learn how to create and use views to simplify complex queries, summarize data, and manipulate data stored in tables. I'll also teach you how to update and delete a view.

Module 11: Understanding Transaction Processing, Constraints, and Indexes

Today, you'll learn how transaction processing, constraints, and indexes are implemented in SQL. You'll work through an example that demonstrates how a transaction is created, how constraints are used in the creation of a table, and how indexes are used to improve the performance of a database by optimizing the speed at which queries are processed.

Module 12: Understanding Stored Procedures, Triggers, and Cursors

In our last lesson, you'll find out how stored procedures, triggers, and cursors are implemented in SQL. You'll see how stored procedures are created and executed, as well as how triggers work. You'll also see how cursors are declared in SQL.

Course 10 - Certificate in Understanding the Cloud Online Course

There are 12 units of study

What the Cloud Is

Confused about the cloud? You're in the right place! In this first lesson, we'll clear up some confusion and start with the basics. I'll explain the building blocks of the cloud, and that will lead us to a durable definition of the cloud that you'll use as a foundation for the rest of the course. We'll also discuss what the cloud means to you, its impact on your life, and why it'll be helpful for you to understand how it works.

How the Cloud Started and What It Solves

So how did the cloud get started? In this lesson, you'll learn the history of the cloud and how it was a natural evolution of networked computers and Internet connectivity. We'll also discuss why the cloud is so important, and we'll look at the business challenges and opportunities that the cloud addresses. By the end of this lesson, you'll have a solid understanding of how we got to where we are and how business computing operated before the cloud.

Different Kinds of Clouds: Public, Private, Hybrid

Ever wonder why some people believe the cloud is simple, while others believe it's complex? In this lesson, you'll learn why they're both right—and you'll learn how to think about the cloud from two perspectives. We'll also discuss the different types of clouds: public, private, and hybrid. And you'll get a glimpse inside the big business technology world and find out why the cloud can be such a compelling move for large organizations.

How the Cloud Grows

What's the difference between the cloud and a collection of computers? A bunch—and much of that comes down to virtualization. In this lesson, you'll learn what virtualization is and why it's so fundamental in how the cloud operates. We'll also discuss scale and how it relates to virtualization. Finally, you'll see how endpoints make all the connections work. Let's get started!

Cloud Services

If you'll recall, services is one of the five building blocks in our definition of the cloud. In this lesson, we'll look at those services. Specifically, we'll discuss three categories of cloud services: infrastructure (or Infrastructure as a Service, or IaaS), platforms (or Platform as a Service, or PaaS), and software (or Software as a Service, or SaaS). We'll discuss how these three categories compare and individuals and business can take advantage of them.

Data Centers: Where the Cloud Computes

All the computing power of the cloud needs to live somewhere, and it's not in the atmosphere. In this lesson, you'll learn all about data centers—how they operate, what they look like, where they're located, and what makes them tick. You'll also learn what makes one data center more efficient than another, and you'll get perspective on what it costs to make them operate. It's a fascinating tour, with a lot to learn and even more to explore, so let's jump in!

Understanding Data, Including Big Data

Our experience in the cloud includes the storing and transmission of data, either across the hall or across the world. In this lesson, you'll understand how to think about data in terms of its importance in the cloud, and you'll also learn why we often leave worrying about data to someone else. We'll discuss how all the data in the cloud moves across continents, across the ocean, and over airwaves. And we'll also look at a clear definition of big data in this lesson, as well as examples of where big data may be headed. 

Understanding Cloud Providers

Making sense of how cloud providers offer their services is an important step in truly understanding the cloud. In this lesson, you'll see how a well-established cloud provider organizes and presents its offerings. We'll go through each group of the cloud provider's offered services, and we'll map them to what you've already learned about the cloud and the categories you're familiar with.

Cloud Providers and Big Platforms

In this lesson, you'll learn where websites fit into the cloud and what other elements, offerings, or activities are driving the adoption and popularity of the cloud and its varied services. We'll also discuss what it means to be a big provider, and we'll examine the largest platforms—and largest overall service providers—that are in the cloud today.

Getting Into the Cloud

Learn about what goes into creating a cloud app, and how the three (plus one) ecosystems dominate the world of cloud applications. In this lesson, you also learn about the different types of devices, how they are categorized, and how they align to the types of cloud apps that are available. You'll also learn about ecosystems, and why they define how cloud apps are created, distributed, and sold.

The Cloud and #You

Today we're going to look at how social network sites like Facebook, LinkedIn, and Twitter work in the cloud and how users and organizations can create apps that connect with their huge base of users. You'll learn how social media sites let software developers interact with their sites, create apps and games that operate within and outside their sites, and why they do this. Also, you'll learn about social media tools on Facebook and in Twitter, including why the hashtag was created (#), how it's used, and how to use these sites yourself.

Conclusions, Connections, and the Future of the Cloud

This lesson ties together everything you've learned in this course. You'll learn how we can view the cloud from two primary perspectives—consumer and business—and we'll distill the primary benefits (and drivers) that have propelled cloud adoption from participants of both perspectives. We'll also discuss where these two perspectives share a common, clear force that continues to be the biggest benefit of the cloud. And finally, we'll look into the future of what the cloud may hold and what that future might mean for each of us.

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

About this Course

Get Computer Skills for the Workplace, Introduction to Microsoft Project 2016, Introduction to Microsoft Excel 2016, Introduction to QuickBooks 2016, Introduction to QuickBooks, Introduction to PC Troubleshooting, Introduction to Photoshop CS6, Introduction to InDesign CC, Introduction to SQL and Understanding the Cloud in this Bundle

1. Computer Skills for the Workplace: Learn How to Implement the Powers of Modern Office Software

Most jobs today require a working knowledge of certain computer skills. Employers seek and reward employees with the skills and knowledge to send messages across the country via e-mail; use a spreadsheet to create a graph and paste it into a report; add and edit data in a database; understand the implications of file sizes, memory limitations, and network arrangements; 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 computer skills for the workplace online 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.

We'll focus on practical application for software most common to the workplace. When you finish this course, you will have learned why employers consider technological literacy so critical to the success of any organization.

2. Introduction to Microsoft Project 2016: Start Now To Learn Introduction to Microsoft Project 2016

Discover how to effectively plan, implement, and control projects using Microsoft Project 2016. From sequencing tasks, producing a baseline, and assigning resources and costs, to tracking progress, analyzing variances, and revising your project plan, Microsoft Project can help you organize all your project's details quickly and effectively.

In this course, you'll master the basics of Microsoft Project 2016 so you can create a project schedule in no time flat and then share it with clients and co-workers. Using the program's different views, such as the Calendar and Gantt Chart views, you'll manage your project information and produce effective reports. Armed with this information, you'll avoid going down dead-end alleys and overloading your schedule. And should you encounter trouble, you'll master a number of tried-and-true problem-resolution techniques to help get your project back on track.

You'll also learn how to fine-tune different aspects of your project, including splitting tasks for work interruptions and defining material consumption rates. After completing the course, you'll know how to develop, implement, and control a project plan that meets organizational and customer objectives.

3. Introduction to Microsoft Excel 2016: Learn How to Master Microsoft Excel 2016

Do you work with numbers? Then you need to master Microsoft Excel 2016 (now available through Office 365)—and this is the place to do it. Even "non-techie" beginners will find it easy to learn Excel in this fun, step-by-step online course.

These lessons will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more.

In addition, you'll get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. This informative course covers Quick Analysis, Flash Fill, and powerful charting capabilities available in Excel 2016.

This is not a tutorial, but an in-depth class where you'll get training, help, and personal support from an experienced instructor as you're learning Excel basics step-by-step. By the time you're done, you'll be using this vital Office 2016 tool like a pro.

4. Introduction to QuickBooks 2016: Take Control of the Financial Accounting for your Business

Learn to manage the financial aspects of your small business quickly and efficiently with this powerful accounting software program. QuickBooks is designed especially for the small- to midsized-business owner who needs a fully functional accounting system that's also easy to use.

In 12 lessons, you'll gain hands-on experience as you master the tools you need set up a chart of accounts; reconcile your checking account; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create estimates; and generate reports.

Whether you're new to QuickBooks or have already used earlier versions of this accounting software program, this course will empower you to take control of the financial accounting for your business.

5. Introduction to QuickBooks: Learn to Manage the Financial Aspects of your Small Business Quickly and Efficiently Using QuickBooks Online

This powerful accounting software program has helped thousands of business owners just like you manage their finances. With the online version, you also gain all the advantage of computing in the cloud, so that your files will be available to you virtually anytime, anywhere.

As we explore the pros and cons of online accounting, you'll soon see how easy it is to use the navigation features of QuickBooks Online. Then you'll gain hands-on experience as you learn all the ways this well-designed accounting program makes it a snap to manage your business' finances—from recording income and expenses, to entering checks and bank transfer entries, to setting up a chart of accounts. You'll see how to reconcile your checking account and manage credit card and loan payments; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create estimates; generate reports; and much more.

Whether you're new to QuickBooks or have already used other versions of this software program, this course will empower you to take control of the financial accounting for your business, all with the ease and convenience of an online platform.

6. Introduction to PC Troubleshooting: Start Now To Learn Introduction to PC Troubleshooting Online Course

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? Let's troubleshoot - and fix - some PCs!

7. Introduction to Photoshop CS6: Master the Secrets of Photoshop CS6

You'll learn how to use Photoshop with detailed, step-by-step instructions that you'll have no trouble following—even if you've never used a computer graphics program before! And you'll have a lot of fun doing it.

Photoshop CS6 has a host of impressive new features for photographers, and you'll encounter a number of them. We'll begin with an introduction to the Photoshop environment. Next, you'll learn techniques for creating simple digital paintings (including some brushes that let you create the look of an oil painting from a photo).

Then you'll be editing your own photographs to get rid of dust and scratches, fix the color, and correct image exposure. You'll master techniques for switching the backgrounds on images and removing wrinkles and blemishes from photos, just like they do in magazines. You'll also learn about the new content-aware Move tool in CS6 that, like magic, lets you move something on an image while intelligently replacing the "hole" left behind.

By the time you finish this fun, hands-on, project-oriented Certificate in Introduction to Photoshop CS6 Online Course, you'll be well on your way to expressing yourself with the most exciting graphics program ever developed.

Photoshop is the world's best-known photo-editing program. Artists, photographers, designers, and hobbyists all rely on Adobe Photoshop for image creation and editing. Discover the fastest and most effective ways to use Photoshop from an expert and former columnist for Photoshop User magazine.

8. Introduction to InDesign CC: Start Now To Learn Introduction to InDesign CC

Have you ever seen a terrific-looking brochure or newsletter and wondered how it was made? Chances are the designer used Adobe InDesign CC, the industry-standard desktop publishing software now available through the Creative Cloud. The course is applicable to any version of InDesign CS4 or newer.

In each lesson, we'll cover an important aspect of InDesign CC as you prepare a range of print and online products for a fictional company, Natalie's Nautical Emporium. You'll get dozens of files to work with, including a partially completed InDesign document used to start each lesson. Then you'll use the downloaded graphics, images, fonts, and other content to complete the project. And to check your work or troubleshoot any problems you encounter, you'll always get a copy of the finished InDesign project file.

Lesson by lesson, you'll discover how the program features relate to producing actual usable documents as we explore the best ways to create different types of material, how to reuse items such as colors and artwork, and how to produce publications for different page sizes and devices. You'll come away knowing how to use this popular page layout software to design and create professional-quality letterhead, business cards, brochures, forms, interactive PDF files, an eBook, and more. You don't have to be a designer or an artist to produce professional quality documents!

9. Introduction to SQL: Learn the Fundamentals of SQL

In this comprehensive 12 module certificate, you'll learn how to read and write simple and complex SQL statements, and advanced data manipulation techniques.

Starting off with database basics you'll explore basic structure and the history of relational databases, learn to understand what SQL is and how it is used. As you progress through the content you will learn sorting and retrieving data, filtering data, calculated fields and fuctions, sumarizing and grouping data, working with subquiries and much more.

By the end of this course you will have a great understanding of the fundamentals of SQL and be prepared to move deeper into understanding more advanced systems.

10. Understanding the Cloud: Start Learning to Understand the Cloud

What is the cloud? If you have trouble answering this question, you're not alone. In this course, we'll explore how the cloud works, what drives its incredible growth, and how you can use cloud services. And don't worry if you're not tech-savvy! We'll relate the cloud to things you encounter every day, using practical, non-technical language.

We'll start by looking at the building blocks of the cloud, where it started, and how it transitioned from an experiment into an unstoppable force. You'll also gain a clear understanding of IaaS, SaaS, and PaaS, and see why each may be attractive to some businesses, but not others. And you'll learn about the different kinds of clouds (public, private, and hybrid).

We'll also take an inside look at the engine rooms of the cloud: data centers. You'll examine the concept of big data?the overwhelmingly huge amounts of data that make analysis so challenging—and how the cloud infrastructure enables data to zip across the globe at lightning speed.

Social networking has also played an incredibly important role in the growth of the cloud. We'll examine how Facebook and Twitter contribute to the cloud, and how apps go from idea to app store. You'll gain an understanding of how mobile devices and major mobile ecosystems?like Apple, Android, and Windows?continue to shape the cloud, and how start-ups can use social media to shake things up like never before.

So come see how the how the cloud can work for you! Whatever your technical background, by the end of this course, you'll be thoroughly cloud-savvy.

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. This course is delivered 100% on-line and is accessible 24/7 from any computer or smartphone
  2. Instructors lead each course and you will be able to interact with them and ask questions
  3. You can study from home or at work at your own pace in your own time
  4. You can download printer friendly course material or save for viewing off line
  5. You will be awarded a certificate at completion of this course

How to study online course?

Upon enrolment an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. New courses start every month to ensure that we have the correct ratio of students to tutors available, please ensure you select a starting date when you go through our shopping cart, at checkout. The course is easy to follow and understand.

Recognition & Accreditation

All students who complete each course receive a certificate of completion per course, with a passing score (for the online assessment) and will be issued a certificate via email.

Ultimate Computer Skills for the Workplace Online Bundle, 10 Courses includes the following courses, below is a summary of each course: 

Course 1 - Certificate in Computer Skills for the Workplace Online Course

There are 12 units of study

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: E-Mail 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 Macintosh 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 e-mail, 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 multi-media. 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, 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 one 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.

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 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 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! 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.

Course 2 - Certificate in Introduction to Microsoft Project 2016 Online Course

There are 12 units of study

Lesson 01 - Overview of Microsoft Project
Microsoft Project can help you manage your project's schedule, costs, and scope in a way that you've never dreamed of. Too often, Project users never use this powerful tool to its fullest potential. In your first lesson, you'll discover how to improve your project by adopting a formal management approach. You'll get a quick overview of Project Management, and then you'll learn the basics of Microsoft Project, including a summary of the Gantt Chart view and ways to create and enter project tasks.

Lesson 02 - Creating a Solid Foundation
If you're looking for ways to keep organized, you'll see just how to do that in today's lesson! We'll walk through steps to create a project schedule in no time flat. Once you create and enter tasks in Project's Gantt Chart view, you'll set a schedule by using a calendar and assigning lead times. Then, you'll need to create task dependencies, sometimes known as links. You'll see how to perform these activities and, in the process, you'll become comfortable using Project's many dialog boxes. Before you know it, you'll be creating schedules for all your projects with little effort.

Lesson 03 - Creating and Managing Resources
You won't get too far with your project without adding resources. While tasks create the backbone of your project, people, equipment, and material bring your project to life. In this lesson, you'll find out how to apply two types of Project resources—work resources, and material resources. We'll look at two more dialog boxes—Resource Information and Assign Resources—and you'll learn how to analyze resources by using the Resource Sheet and Resource Usage views.

Lesson 04 - Defining and Assigning Costs
No matter what project you work on, the bottom line is always important. So get ready to add the final piece to your basic project schedule—costs. We'll start things off by looking through a brief overview of cost accounting, exploring fixed, variable, relevant, and accrued costs. After this review, you'll learn how to assign costs by using the Resource Sheet. You'll even discover how to assign different costs for the same resource and analyze the overall costs for your project by using the Cost Table.

Lesson 05 - Project Templates, Security, and Constraints
Successful project managers are known for their efficiency and for safeguarding private information. Microsoft Project provides two excellent methods to help you in these areas: project templates and project security. You'll find out how to use some of the many templates Project has to offer, including the Residential Construction template and the New Product template. You'll also learn how to protect your project information with backups, passwords, and write protection. Then you'll discover how to put Project's task constraints to good use.

Lesson 06 - Working With Views and Managing Information
In this lesson, you'll discover how easy it is to modify your basic schedules and work with project data. You'll look at the various Project views, such as the Calendar, Leveling Gantt, and the Network Diagram. And if you don't like the default colors or fonts in your schedule or table, you'll be well-prepared to make changes. You'll even learn how and why you might want to create a combination view; add notes to your project; or sort, filter, and group data.

Lesson 07 - Fine-Tuning Your Project Plan
Many projects experience schedule compression when management or clients ask that the project be completed sooner and for less. In today's lesson, you'll discover how to improve your schedule's performance. You'll explore the Project Statistics dialog box, and you'll learn how to determine the ideal starting point in terms of planned costs and completion dates. You'll see how to change task dependencies to speed up your project and also find out how to split tasks to add more lead time. You'll also learn how to create recurring tasks and attach notes to your project's taskbars.

Lesson 08 - Baselines and Tracking
Before you implement your project, you need to create a baseline. This will help you track actual results against what you originally set out to accomplish. Microsoft Project makes it possible to set up a baseline with a few mouse clicks. You'll learn how to create a baseline and then see a variety of ways, including using the Tracking toolbar, to record your actual project results.

Lesson 09 - Managing Variances
Here's where things really start to come together! You'll learn how to compare actual results to your baseline by using the Gantt Chart and reviewing a table. You'll discover how useful status identifiers and progress lines can be to quickly gain information about your project's position. You'll also begin using the Tracking Gantt and filters to automatically identify slipping tasks. You'll also take a stroll through the basics of variance analysis by discussing the Start and Finish Date, Resources, and Work Variance Tables.

Lesson 10 - Using and Creating Reports
Once your project gets rolling, outsiders will probably want to know how things are going. It can be a real time drain answering each request individually. When others request information from you, Microsoft Project offers the perfect solution: Reports. We'll go over a representative sample of the standard reports as well as discuss how to modify and create new reports in today's lesson. By the time you finish, you'll be well acquainted with Project's reporting capabilities and also know how to create Visual Reports as Project automatically exports data to Microsoft Excel and Visio.

Lesson 11 - Printing Views
Now that you're using reports to share project information, you'll occasionally need to print various views and tables. In this lesson, you'll delve into printing Microsoft Project documents. You'll be a master at creating different views of your project with the Page Setup dialog box, and you'll clearly understand the mechanics of the Print dialog box and the Print Preview.

Lesson 12 - Closing Your Project
No project is complete until it's officially closed. In this final lesson, you'll find out how to close your project and use the Organizer to help you customize and copy views for future projects.

Course 3 - Certificate in Introduction to Microsoft Excel 2016 Online Course

There are 12 units of study

Lesson 01 - Excel Basics
In our first lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas.

Lesson 02 - Creating a Worksheet
In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted.

Lesson 03 - Time-Savers
Our third lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. We'll also spend some time working with the Quick Analysis and Flash Fill tools. By the time you finish this lesson, you'll really start to feel like an Excel pro.

Lesson 04 - Relative, Absolute, Mixed, and Circular References
Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. Today, we focus on writing sophisticated formulas that can help ease us through some rather sticky scenarios.

Lesson 05 - 3-Dimensional Workbooks
With enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. Today, you'll join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks.

Lesson 06 - Sorting, Subtotaling, and Filtering
No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. Today, you'll not only learn how to build a table in Excel, you'll also learn how to subtotal, sort, and filter.

Lesson 07 - Charting Basics
In this lesson, we'll explore the exciting world of charts. You'll build your first graph today, and you'll learn how easy it is to adjust the chart type, labels, titles, colors, and many other aspects of your chart.

Lesson 08 - Advanced Charting Techniques
Today, you'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3-D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings. You'll also discover the best ways to format your chart for print or otherwise display the truly impressive charts that you'll be creating.

Lesson 09 - Intro to Excel's Statistical Functions
Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In today's lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers.

Lesson 10 - Financial Functions
We'll continue our exploration of Excel functions with an in-depth look at Excel's handy financial functions today. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time.

Lesson 11 - Worksheet Automation
Students often rank this lesson as one of their favorites. Today, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how you can use macros to reduce just about any complex task to a single keystroke.

Lesson 12 - Mastering Excel's IF Function
I think you'll be intrigued by our final lesson, in which you'll learn how to use Excel to aid you in decision making. We'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.

Course 4 - Certificate in Introduction to QuickBooks 2016 Online Course

There are 12 units of study

Lesson 01 - Getting Started
In our first lesson, you'll become familiar with the QuickBooks interface. You'll find out how the pros use QuickBooks to simultaneously manage common accounting tasks for multiple companies, you'll get to set up a QuickBooks Company of your very own, and you'll learn some QuickBooks terminology.
We'll be practicing many new skills in this class, so it's important that you have a copy of QuickBooks installed on your computer before you begin.

Lesson 02 - The Chart of Accounts
The Chart of Accounts is the heart and soul of QuickBooks. In today's lesson, you'll learn how to take fullest advantage of this powerful tool to add, edit, and access accounts that you can use to track the value of your business or monitor your income and expenses.

Lesson 03 - Company Lists
Today, we'll learn how to use company lists in QuickBooks to gather and organize all of the information you'll need to properly conduct your business. By the time you finish this lesson, you'll know how to store and retrieve all manner of useful facts, including data on customers, vendors, products, services, important events, and more.

Lesson 04 - Bank Accounts
Today, you'll become comfortable working with bank accounts in QuickBooks. You'll learn how to tell QuickBooks about checks, withdrawals, and transfers between accounts. You'll get firsthand experience with adding, finding, and editing or voiding all manner of checking and savings account transactions. You'll even be prepared to reconcile your QuickBooks checking account with your monthly bank statement to ensure that no errors were made.

Lesson 05 - Fixed Assets and Depreciation
The physical objects you rely on to help you run your business (like furniture, machinery, vehicles, computers, telephones, or even the building that houses your business) all have significant value. The total value of these assets has a direct impact on the overall worth of your business, and there are tax implications if you sell an asset or if its value changes. That's why it's important for you to keep an accurate tally of everything your business owns. Today's lesson will provide you with plenty of opportunities to do just that.

Lesson 06 - Accounts Payable I
Without an organized system for managing all the bills your business receives, they can really start to stack up. And when bills pile up, it isn't hard to overlook one or two from time to time. That, of course, can result in late fees and credit difficulties. Today, you'll learn how to use QuickBooks to make sure you're paying all of your bills right on time—not too early, and not too late.

Lesson 07 - Accounts Payable II
Today, we're going to finish our discussion of QuickBooks' accounts payable tools. You'll learn how to get QuickBooks to memorize bills that you find yourself paying over and over again, month after month. Then, you'll learn how to create some useful accounts payable reports.

Lesson 08 - Accounts Receivable I
You'll find today's lesson useful if your business ever finds itself required to collect payment from a customer long after the products or services have been delivered. Today is the day you'll get some hands-on experience with invoicing. You'll find out how to create an invoice, fill it with invoice items, edit it, print it, and even email it to your customers.

Lesson 09 - Accounts Receivable II
Okay, so you've created an invoice and delivered it to your customer. With a little bit of luck, your customer will place the invoice on his or her "to-do" list and, eventually, you'll receive some form of payment for your troubles. Now what? You'll find out in today's lesson.

Lesson 10 - Accounts Receivable III
Today, we'll explore some useful customer-related reports that can help you keep track of exactly who owes you what. Then, you'll learn what to do if you ever incur a charge on behalf of a customer and wish to be reimbursed for that expense.

Lesson 11 - Inventory and Estimating
Today, you're going to learn how to customize your QuickBooks invoices to give them a more professional look. You'll also learn how to work with two of QuickBooks' more advanced features: inventory tracking and estimating.

Lesson 12 - Reporting
In our final lesson, you'll find out how to create, use, and memorize a wide variety of useful reports that can help you locate, organize, sort, total, summarize, and otherwise make sense of all those transactions you've painstakingly entered into QuickBooks

Course 5 - Certificate in Introduction to QuickBooks Online Course

There are 12 units of study

Getting Started
In our first lesson, you'll get familiar with the QuickBooks Online interface and explore the pros and cons of working with your accounting information online. We'll discuss the various subscription packages available, and you'll get to practice using some of the navigation and interactive features that allow you to quickly get around in the program.
    
The Chart of Accounts
The Chart of Accounts is the heart and soul of QuickBooks. In today's lesson, you'll learn how to take full advantage of this powerful tool to add, edit, and access accounts that you can use to track the value of your business or monitor your income and expenses.

Centers and Lists
Today, you'll learn how to use centers and lists in QuickBooks to gather and organize all of the information you'll need to properly conduct business with customers and vendors. By the time you finish this lesson, you'll know how to store and edit various types of information, such as addresses and payment terms, for your customers and vendors. You'll also learn how to process Form 1099 to give to your vendors at the end of the year.
    
Bank Accounts
Today, you'll get comfortable working with bank accounts in QuickBooks Online. You'll learn how to create a new bank account, connect it online, and download, match, and add transactions. Then you'll learn how to reconcile your checking account with your monthly bank statement to make sure that neither you nor the bank made any errors.

Recording Expenses—Part 1
Keeping track of the checks and other expense transactions your business incurs is one of the most critical aspects of your daily operations. In this lesson, you'll learn how to utilize QuickBooks' built-in features to enter check transactions and bank transfers like a pro. You'll also learn how to record expense transactions where you may have utilized your debit card as payment or paid the amount online. You'll even learn how to label an expense as billable so that you can later request reimbursement from a customer. Finally, you'll practice with creating a recurring transaction template that may help save you some valuable data entry time!

Recording Expenses—Part 2
Without an organized system for managing all the bills your business receives, they can really start to stack up. And when bills pile up, it isn't hard to overlook one or two from time to time. That, of course, can result in late fees and credit difficulties. Today, you'll learn how to enter, edit, and pay all of your bills right on time. You'll also learn how to enter and apply vendor credits to an existing or future bill.

Credit Cards and Loans
In this lesson, you'll learn how to effectively manage Credit Card accounts in QuickBooks Online. We'll explore how to create a new Credit Card account and enter charges to that account as they occur. You'll also learn how to enter a full or partial payment of the credit card balance when it comes time for payment. Finally, you'll get the chance to create and enter a new loan balance resulting from the purchase of a long-term asset such as a vehicle or piece of equipment.

Recording Income—Part 1
You'll find today's lesson useful if your business ever sells a product or service and collects payment on the sale immediately. Today is the day you'll get some hands-on experience with creating products and services. Then you'll find out how to create multiple Sales Receipts and make the necessary deposit to your bank.
    
Recording Income—Part 2
In order to evaluate just how well your company is performing, you'll need to learn how to enter estimates, invoices, and customer payments. You'll do just that in this lesson. You'll also learn how to group multiple customer payments and record those deposits to the bank.

Recording Income—Part 3
Today, you're going to explore how to bill a customer for an expense incurred on a project or job. You'll even see how you can add a markup percentage to the amount you include on the customer invoice. Also, you'll examine the steps needed to enter credit memos, delayed credits, and refunds.
    
Customizing Sales Forms and Recording Fixed Assets
Today, you're going to learn how to customize your QuickBooks sales forms to give them a more professional look. You'll also learn how to record long-term fixed assets and record depreciation on those assets.

Sales Taxes and Reports
In our final lesson, you'll learn how to work with the sales tax features in the program to collect and remit taxes you collect from customers. You'll also find out how to create, use, and customize a wide variety of useful reports that can help you locate, organize, sort, total, summarize, and otherwise make sense of all those transactions you've painstakingly entered into QuickBooks Online.

Course 6 - Certificate in Introduction to PC Troubleshooting Online Course

There Are 12 Units Of Study

The Computing Process
Lesson 1 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
Lesson 3 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
Lesson 4 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
Lesson 6 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
Lesson 7 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 I’ll walk you through the five-step process of recovering from a virus infection. You’ll also read about safe browsing and safe email use, and you’ll 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, I’ll teach you about the power of different PC parts, including what to look for when shopping for new parts. I’ll also guide you in 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 I'll show you safe and effective ways to check, clean, and maintain the inside and outside of your computer. We'll also talk about how to donate an old computer, and I'll explain 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, I'll remind you about the computing process and about troubleshooting theory. Combined with your new knowledge of PC hardware, software, and networking, you can use these tools to fix all sorts of problems. I'll also discuss your future as a PC troubleshooter, including the certifications and careers available to anyone with the right skills.

Course 7 - Certificate in Introduction to Photoshop CS6 Online Course

There are 12 units of study
 

Introducing Photoshop
Your journey begins. Whether you're an aspiring graphic artist or a weekend photographer, Photoshop can take you places you've never dreamed of. Even if you've never touched Photoshop before, you'll be able to open, edit, and save files before this lesson ends. You'll also find out how to download images, and you'll learn simple commands that make an image "pop."
 
Choosing Colors and Painting
Did you like playing with paints as a child? In this lesson, you'll discover how enjoyable it can be to paint in Photoshop—where you don't need to clean up after yourself, and there's no odor of turpentine. You'll find out how Photoshop "thinks" about color and how you can use the brushes inside Photoshop to make a simple landscape. You'll even blend colors on your image as if they were made of oil paints or watercolors. This is a fun lesson!
 
More Brush Tools
Zoom, Scrubby Zoom, Airbrush, Eraser, Smudge: Do you know what these tools and commands mean in Photoshop? You will! In this lesson, you'll find out how to navigate your image so that you can edit and paint more effectively—and give your eyes a rest too. You'll also learn how to erase, blur, smudge, and finger paint. These techniques are fun, easy ways to make dramatic changes in your images, whether you're altering photos or creating a work of art from scratch.
 
Colorizing Images
Have you seen ads or greeting cards where most of the image is in black and white but one part's in color? Today you'll find out how to create that effect. You'll be amazed at how easy it is to transform images from color into black and white or even old-fashioned sepia. We'll also cover some tricks with the History Brush tool and history snapshots, so you can experiment while you're creating a hand-tinted image . . . and quickly undo whatever steps you don't like.
 
Making and Saving Rectangular and Oval Selections
If you wanted a friend to hand you an orange from a fruit bowl, you'd probably just point to the one you want or describe its location. Photoshop also needs directions if you want to lift something out of an image or point it out in some way. The Photoshop name for "pointing" is selections. In this lesson, you'll learn the critical skill of making selections. You'll see how easy it is to isolate portions of your image so that you can add a filter or change the colors. You'll also create vignettes, which are photos with an opaque center that falls off to a very soft edge. And if you don't like the selection you just made, you'll get help from the Refine Edge command.
 
Using Additional Selection Tools
Photoshop has some great selection tools, but until now, all of them have had trouble selecting exactly what you had in mind. You can see the flower, so why can't Photoshop? Today you'll learn to use the Lasso, Magic Wand, and Quick Selection tools to make the selections you want as you practice putting two images together.
 
Creating and Customizing Brushes
You can paint in Photoshop—even if the only thing you can do with paint in "real life" is spill it! Photoshop lets you create fabulous brushes from images and customize them in many ways. You can modify the new bristle-tip brushes to help you turn photos into art . . . or to create your own work of art just by using brushstrokes.
 
Discovering Gradients
Gradients are fountains of color. One of the current trends in photography is to colorize areas of a photo with a gradient. You can spend hundreds of dollars buying gradient-colored stock photos—or just use what you learn in this lesson to create them yourself! Even portraits can be much more exciting with a gradient added to them.
 
Setting Type and Adding Effects to Text
Whether you want to add type to a scrapbooking layout, make large type for display, or learn a little bit about Photoshop's Layer Styles, you'll enjoy this lesson. You'll try your hand at making type that warps, wiggles, and follows a path. Then you'll see what you can do to text on your own.
 
Setting Image Resolution and Image Sizes for Input and Output
Today you'll learn how to size your images for printing or for the Web. You'll find out how to scan an image so that it's large enough for your needs, but not too large, and how to crop images that have more than you really want to see.
 
Fixing Images
In this lesson, we'll focus on the three R's of photo manipulation: restoring, retouching, and rearranging. You'll be amazed by what you can do—and you'll understand why the phrase "pictures can't lie" is no longer true! You'll also discover how to use the amazing Clone Stamp panel and the "preview" feature on the Clone Stamp brush cursor. Plus you'll learn about the content-aware tools that help Photoshop make more intelligent guesses as to the fixes you want.
 
Correcting Exposure, Color, and Tonal Value
Are some of your images overexposed, underexposed, or tinged an ugly yellow? In this lesson, learn how to correct exposures and colors to make them more attractive and truer to life. Photoshop can't work miracles all the time, but if you have an image that's a bit too dark or a bit too light, you can fix it up so that it looks perfect.

Course 8 - Certificate in Introduction to InDesign CC Online Course

There are 12 units of study

Making Your Way Around InDesign CC

Wouldn't it be terrific if you could use one program to create all the different types of print materials you need for your small business, organization, or family—such as letterhead, forms, and even brochures and business cards? Well, you can! We'll spend this first lesson going over all the different types of content you can produce with InDesign. We'll explore the InDesign workspace and tools, and then we'll get right to work on our first project—a logo for the fictional business we'll create materials for throughout this course

Setting Up a New Document

Today, you'll learn all about starting and saving a new document. What's one of the most common types of print documents? If you said, "letterhead," you'd be right and well on your way into this lesson's project. By the end of the session, you'll know how to choose settings for a new file, add background images, and organize your content to create a custom letterhead. You'll also add a second page to create a matching envelope, and you'll learn how to add a custom Master page for the envelope. And as in all of our lessons, we'll go over how to use the specific colors, styles, and logo for our fictional business, but you'll be able to use the same techniques for your personal business or projects

Organizing Objects on a Layout

Organization is a key ingredient in successful work of any kind, and it's critical to successfully using InDesign. In this lesson, you'll learn about organizing in two ways. First, you'll see how to use aworkflow, or an order of operations for creating an InDesign publication. Then we'll go over how to organize materials on a page and how to use many of InDesign's tools for aligning, organizing, and laying out your content. In the process, we'll complete three projects: a sheet of address stickers, a sheet of business cards, and a reusable business card template.

Setting Up a Multipage Document

Many of your projects will use multiple pages with different layouts. Designing a catalog layout is the perfect way to learn these skills, and that's what we'll focus on today. We'll work with two different column layouts while exploring other InDesign features (like grids and document coordinates) that can help you lay out a page evenly. We'll also go over using graphic and text frame placeholders so you don't have to add content to the page to see its layout. For a final touch of realism, we'll use placeholder text during the design process to give you a good idea of how a page will look when you're finished. You'll see how to add a graphic into an existing frame and make it fit, as well as how to add content instantly using a file called a snippet.

Adding, Editing, and Threading Text

Managing text in precise and interesting ways is one of the big advantages of working with InDesign rather than a word-processing program. In this lesson, we'll begin a two-page brochure project that will take us two lessons to complete. In this first part, you'll learn different methods for adding text to your publication. Once the text is in place, you'll see how to check your text for typos and errors. We'll go over how to work with text in simple text frames and how to design threaded text (where the text slides through linked text frames on the page yet stays within the defined structure). We'll also use the Story Editor as an alternative to adding content in a layout view. You'll finish the lesson working with two columns in a single frame, and you'll see how to balance the content and auto-size the frame.

Importing Graphics and Images

The two key elements in any print project are, of course, text and images. We went over text in our last lesson, so today, we'll finish up our two-page brochure project by going over just about everything you need to know about working with images—adding them to the page in different ways, adjusting their positions, and using various commands for coordinating their sizes, proportions, and frames. We'll begin by adding images to the brochure project pages we worked on in Lesson 5, and then we'll check out some special ways to add batches of images at once to make an image collage and to place images in interesting frames. Speaking of interesting—you'll also see how you can use InDesign transparency effects to add pizzazz to any project. You'll wind up the lesson making a printable photo cube from a template.

Drawing and Working With Shapes

You might be surprised to learn that InDesign provides you with some of the same sophisticated drawing tools that you'll find in Adobe Illustrator. For example, InDesign offers the Pathfinder tool, which is the perfect tool to use if you need to combine simply drawn shapes and convert them into more complex and interesting objects. In this lesson, you'll learn how to work with some of the drawing tools to design a poster for a fashion show. You'll see how to draw several simple shapes and stack them using blend modes for interesting effects. One of the topics we'll go over is a text wrap, which is a special way to work with a drawing to tell InDesign where you want your text to display on your page. If you've ever wondered how to make text follow the shape of an object, curving around it on the page, our practice today will solve the mystery!

Managing and Applying Color

Did you know that your eyes can see over 16 million different colors? It's true! Fortunately, you don't have to work with that many colors in InDesign. But if you ever find yourself trying to choose between thousands and thousands of color possibilities, you'll understand why InDesign offers you so many different ways to work with your choices. In this lesson, you'll learn the best methods for choosing, naming, and organizing colors. You'll practice working with solid colors as well as gradients (which let you display a range of color within an object), and we'll round out the lesson by using some more special effects in today's fun project—a greeting card.

Designing Tables and Creating Forms

When you need to display bits of information in your publication and want to ensure it's easy to read, it's time to use a table. InDesign offers you lots of tools for designing and formatting tables while helping you make sure your content will coordinate with other documents. You'll see how this works today as we practice building tables for an invoice. You'll also find out how to use color tints in your table, as well as how to use styles to quickly and consistently reuse any of your layout features. Finally, we'll experiment with an interactive PDF form. You'll add some fields to a blank form, see how to configure a text field or button, and produce the PDF form.

Storing Text and Color Information

 Recycling doesn't just apply to items in your home or business. In this lesson, you'll see how to use the 3R's of recycling in InDesign to complete a newsletter project. As you recycle and modify colors and styles from previous lessons to create new styles in your newsletter, you'll also reuse a lot of the tools and skills you've used in previous lessons. Learning to effectively use all of InDesign's tools and features in a variety of different ways on many different projects is what it's all about!

Creating and Distributing a Complex Document

Whether you're designing publications for business, hobbies, or social or community activities, odds are you'll need to share them at some point. InDesign provides many options for exporting and reusing a document, as well as printing. We'll review a few of them today as we design a postcard using special fonts, colors, and image layout features. We'll also check out Kuler, the Adobe InDesign extension and online application used for color design. Have you ever seen text that shows an image of some sort through the letters and wondered how it's done? You'll know after today's lesson! By the time you finish this lesson, you'll know how to export a publication as an image, print directly from your desktop, or create a compact PDF version of your finished publication ready to email

Working With Color Separations, Special Layouts, and E-books

In this final lesson, we'll really test InDesign's versatility. First, we'll use a two-color version of the business cards you worked with early in the course and dig into color separations—a common method of preparing a file for a professional print shop. We'll try out special layout tools for producing alternate page layouts of different sizes in the same document. Finally, we'll wind up the course by creating an e-book.

Course 9 - Certificate in Introduction to SQL Online Course

There are 12 units of study

Module 1: Database Basics, and Structures Query Language

In our first lesson, we'll explore the basic structure and history of relational databases. Then, you'll understand what SQL is and how it is used with a relational database.

Module 2: Sorting and Retrieving Data

In this lesson, you'll learn how to use SQL to sort and retrieve data from tables. We'll talk about important query terms that enable you to communicate with your database, as well as syntax rules that will enable you to create clear and understandable queries while avoiding system generated errors.

Module 3: Filtering Data

In this lesson, you'll learn how to use SQL to filter retrieved data. You'll practice sorting retrieved data using the ORDER BY clause. You'll be able to sort single and multiple columns, and you'll know how to specify sort directions such as ascending and descending order. You'll also learn additional query terms that will help you customize your SQL queries.

Module 4: Calculated Fields and Functions

Today, you'll learn how to reformat retrieved data with calculated fields and functions. You'll also learn how to create alternate names for columns and you'll discover the secret behind merging columns with the concatenation symbol.

Module 5: Summarizing and Grouping Data

In this lesson, we'll discuss gathering significant statistics from data using aggregate functions. You'll also learn how to use the GROUP BY clause in conjunction with an aggregate function to gather important statistics from a table. Then you'll find out how to use the HAVING clause in conjunction with an aggregate function to filter groups of data from a table.

Module 6: Working with Subqueries

Today's lesson is all about subqueries. You'll learn how to extract data from multiple tables simultaneously, how to use calculated fields in subqueries, how to use the DATEPART () function in subqueries, and how to use aggregate functions in subqueries. Then we'll talk about qualification—a technique used to combine a table name with a column name so there's no question about which table the column name refers to.

Module 7: Creating and Using Table Joins

In this lesson, you'll learn how to use joins to gather information from two or more tables simultaneously. You'll learn how to use the inner join, self-join, natural join, and the outer join. Then you'll become familiar with the term Cartesian product.

Module 8: Inserting, Updating, and Deleting Data

In today's lesson, you'll discover how to manipulate data using the INSERT, UPDATE, and DELETE statements. You'll learn how to insert partial and complete rows into a table, and how to update information already stored in a table. You find out how to transfer data to a new table, how to transfer data to an existing table, and how to delete rows from a table.

Module 9: Table Creation and Maintenance

Today, you'll find out how SQL can be used to create and maintain tables. You'll learn how to use the CREATE TABLE keywords to create a table, then we'll discuss how to use the ALTER TABLE, DROP TABLE, ADD COLUMN, and DROP COLUMN keywords to manipulate the tables themselves. You'll also find out how to define a primary key, data type, and field size.

Module 10: Creating and Understanding Views

In this lesson, you'll learn how and why views are used in SQL. You'll learn how to create and use views to simplify complex queries, summarize data, and manipulate data stored in tables. I'll also teach you how to update and delete a view.

Module 11: Understanding Transaction Processing, Constraints, and Indexes

Today, you'll learn how transaction processing, constraints, and indexes are implemented in SQL. You'll work through an example that demonstrates how a transaction is created, how constraints are used in the creation of a table, and how indexes are used to improve the performance of a database by optimizing the speed at which queries are processed.

Module 12: Understanding Stored Procedures, Triggers, and Cursors

In our last lesson, you'll find out how stored procedures, triggers, and cursors are implemented in SQL. You'll see how stored procedures are created and executed, as well as how triggers work. You'll also see how cursors are declared in SQL.

Course 10 - Certificate in Understanding the Cloud Online Course

There are 12 units of study

What the Cloud Is

Confused about the cloud? You're in the right place! In this first lesson, we'll clear up some confusion and start with the basics. I'll explain the building blocks of the cloud, and that will lead us to a durable definition of the cloud that you'll use as a foundation for the rest of the course. We'll also discuss what the cloud means to you, its impact on your life, and why it'll be helpful for you to understand how it works.

How the Cloud Started and What It Solves

So how did the cloud get started? In this lesson, you'll learn the history of the cloud and how it was a natural evolution of networked computers and Internet connectivity. We'll also discuss why the cloud is so important, and we'll look at the business challenges and opportunities that the cloud addresses. By the end of this lesson, you'll have a solid understanding of how we got to where we are and how business computing operated before the cloud.

Different Kinds of Clouds: Public, Private, Hybrid

Ever wonder why some people believe the cloud is simple, while others believe it's complex? In this lesson, you'll learn why they're both right—and you'll learn how to think about the cloud from two perspectives. We'll also discuss the different types of clouds: public, private, and hybrid. And you'll get a glimpse inside the big business technology world and find out why the cloud can be such a compelling move for large organizations.

How the Cloud Grows

What's the difference between the cloud and a collection of computers? A bunch—and much of that comes down to virtualization. In this lesson, you'll learn what virtualization is and why it's so fundamental in how the cloud operates. We'll also discuss scale and how it relates to virtualization. Finally, you'll see how endpoints make all the connections work. Let's get started!

Cloud Services

If you'll recall, services is one of the five building blocks in our definition of the cloud. In this lesson, we'll look at those services. Specifically, we'll discuss three categories of cloud services: infrastructure (or Infrastructure as a Service, or IaaS), platforms (or Platform as a Service, or PaaS), and software (or Software as a Service, or SaaS). We'll discuss how these three categories compare and individuals and business can take advantage of them.

Data Centers: Where the Cloud Computes

All the computing power of the cloud needs to live somewhere, and it's not in the atmosphere. In this lesson, you'll learn all about data centers—how they operate, what they look like, where they're located, and what makes them tick. You'll also learn what makes one data center more efficient than another, and you'll get perspective on what it costs to make them operate. It's a fascinating tour, with a lot to learn and even more to explore, so let's jump in!

Understanding Data, Including Big Data

Our experience in the cloud includes the storing and transmission of data, either across the hall or across the world. In this lesson, you'll understand how to think about data in terms of its importance in the cloud, and you'll also learn why we often leave worrying about data to someone else. We'll discuss how all the data in the cloud moves across continents, across the ocean, and over airwaves. And we'll also look at a clear definition of big data in this lesson, as well as examples of where big data may be headed. 

Understanding Cloud Providers

Making sense of how cloud providers offer their services is an important step in truly understanding the cloud. In this lesson, you'll see how a well-established cloud provider organizes and presents its offerings. We'll go through each group of the cloud provider's offered services, and we'll map them to what you've already learned about the cloud and the categories you're familiar with.

Cloud Providers and Big Platforms

In this lesson, you'll learn where websites fit into the cloud and what other elements, offerings, or activities are driving the adoption and popularity of the cloud and its varied services. We'll also discuss what it means to be a big provider, and we'll examine the largest platforms—and largest overall service providers—that are in the cloud today.

Getting Into the Cloud

Learn about what goes into creating a cloud app, and how the three (plus one) ecosystems dominate the world of cloud applications. In this lesson, you also learn about the different types of devices, how they are categorized, and how they align to the types of cloud apps that are available. You'll also learn about ecosystems, and why they define how cloud apps are created, distributed, and sold.

The Cloud and #You

Today we're going to look at how social network sites like Facebook, LinkedIn, and Twitter work in the cloud and how users and organizations can create apps that connect with their huge base of users. You'll learn how social media sites let software developers interact with their sites, create apps and games that operate within and outside their sites, and why they do this. Also, you'll learn about social media tools on Facebook and in Twitter, including why the hashtag was created (#), how it's used, and how to use these sites yourself.

Conclusions, Connections, and the Future of the Cloud

This lesson ties together everything you've learned in this course. You'll learn how we can view the cloud from two primary perspectives—consumer and business—and we'll distill the primary benefits (and drivers) that have propelled cloud adoption from participants of both perspectives. We'll also discuss where these two perspectives share a common, clear force that continues to be the biggest benefit of the cloud. And finally, we'll look into the future of what the cloud may hold and what that future might mean for each of us.

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

We provide a 7 Day Money Back Refund on all Courses

Now Only US$1199 Save US$4801 (80%)
OFF RRP US$6000
Delivery Method Online
Get Info Pack

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value $600)

 

The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Features:
  • 12 month online access,  24/7 anywhere.
  • Complement your individual course purchase.
  • Internationally recognized by the IAOTS.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Share this course

Course Summary

Course ID No.: 007CSW10CB
Delivery Mode: Online
Course Access: 6-8 Weeks Per Course
Time required: 240 Hours
Assessments: Yes
Qualification: Certificate

Start Dates

This course is available to begin on the following dates

  • 17 July
  • 14 August
  • 11 September
  • 16 October

Learn More With Course Bundles

Popular Courses and Bundles