This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Master advanced features and functions of Microsoft Excel 2016, including data analysis tools, data tables and databases, PivotTables, custom controls, importing external data, and conditional formatting.
Wouldn't it be great to learn how to effectively use all the advanced Excel features? In this practical and information-packed Microsoft Excel training, you'll see how to truly maximize this program's functions and capabilities. After all, most organizations rely heavily on Excel to consolidate, analyze, and report data and want their employees to be proficient in this important program. This Excel training class gives you the skills you need to impress your current or future employer—and its online format means you can take this class from anywhere, at any time.
With exercises, quizzes, expert instructors, and all the latest information, the best online Excel training is right here at ed2go. We'll simplify some of those tricky Excel concepts that might seem hard to grasp, so you can discover how Excel 2016 table tools actually take the complexity out of spreadsheet creation and management. When you've completed this course, you'll be able to accomplish just about everything Microsoft Excel has to offer in displaying, analyzing, reporting, and tracking data—and you'll understand it so well, you'll even be able to share your newfound skills with your friends and colleagues.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Microsoft Office Home and Student 2016 (not included in enrollment).
Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Master advanced features and functions of Microsoft Excel 2016, including data analysis tools, data tables and databases, PivotTables, custom controls, importing external data, and conditional formatting.
Customizing Excel
Table Management
Data Validation
Custom Controls
Conditional Formatting
Consolidating and Outlining
Excel Functions and Nesting
Import External Data
Data Tables
What-If Analysis Tools
Advanced PivotTables
Analysis ToolPak, Advanced Filter, Array Formulas, and More!
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
This self-paced course will teach you the basics of working with color in web design.
Color plays an important role in visual communication, especially when designing websites. For web designers, understanding color theory is a key to creating a color palette for UI/UX projects. This self-paced course will teach you the fundamentals of color theory and how to apply this framework to your web design practice.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC or Mac.
Software Requirements:
PC: Windows 10 or later.
Mac: macOS 11.0 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Recommended: Though they are not strictly required, you will get the most out of this course if you have Adobe Photoshop and/or Adobe Illustrator installed on your computer. These tools are not included with the course.
Adobe Photoshop (not included in enrollment)
Adobe Illustrator (not included in enrollment)
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Learn the rules for working with color in UI design projects.
Terminology
Color Wheel
Explore a Live Color Wheel
Saturation, Hues and Shades
Exploring Shades and Tints Using Adobe Illustrator
Value of the Hue
Explore a Color Using Photoshop
Color Scheme
Building an Efficient Color Theme
Triadic Colors
Complementary Colors
Split Colors
Analogous Colors
Color Moods
Work with Client Color Plans
Medium Types
Color Theory Principles
Complementary Colors
Contrasting
Vibrancy
Monochromatic
Work with Color Principles
Color Context
Mode RGB/CMYK
Print or Screen
Audience Type
Choose Colors for Different Audience Types
Scope of Project
Implementing Color
Create Color Palette
Mechanics of a Color Scheme
Whitespace
Creating an Electronic Color Scheme
What you will learn
About the traditional color wheel and explore color in Adobe Illustrator
About relationships between colors and how to create a color "feel"
Basic color theory principles
About considerations for print and web
To create a color palette for your project
How you will benefit
Master the basics of color theory in a completely online environment
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Gain a working knowledge of the computer skills you will need to succeed in today's job market.
Most jobs today require a working knowledge of certain computer skills. Employers seek and reward employees who can effectively send emails, create spreadsheets, manage databases, understand memory and network limitations, and recognize the function and features of modern computer components. Any job candidate who already possesses these skills will stand above those who do not.
This course is designed to provide the fundamental computer competencies you need to survive and prosper in today's fast-changing workplace. You will learn how to implement the powers of modern office software to work faster and more efficiently. This course will also focus on practical applications for software most common to the workplace. By the time you finish, you will have learned why employers consider technological literacy so critical to the success of any organization.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. Macs are not compatible.
Software Requirements:
PC: Windows 10 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
Any edition of Microsoft Office with desktop apps: Excel, Word, Outlook, PowerPoint, and Access.(not included in enrollment).
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Confidently apply for jobs knowing that you possess the computer skills needed to perform on the job. This course includes a great introduction to Windows 10 and Office 365 to provide the fundamental computer competencies you need to prosper in a modern workplace.
Lesson 1: 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.
Lesson 2: Outlook: Email and Scheduling
Your computer has a software program installed on it that's referred to as an "operating system." Most often, this system is Microsoft Windows, but it could be others, such as macOS or Linux. In this lesson, you'll learn how this system controls many important parts of the computer and how you use those controls every day for tasks like managing where you keep important files, and printing hard copies of documents. We'll also talk about menus, taskbars, and shortcuts along the way.
Lesson 3: Word: Creating and Formatting Documents
Next to email, the word processor is probably the most frequently used application software in the workplace. Yet, if you've never taken the time to learn the basic features of most word processors, you're not performing nearly to your potential. In today's lesson, you'll learn and practice the important capabilities of word processors like Microsoft Word.
Lesson 4: 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.
Lesson 5: 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.
Lesson 6: 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.
Lesson 7: 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.
Lesson 8: PowerPoint: Creating and Editing a Presentation
PowerPoint is an important tool for creating presentations suitable for the work environment. This powerful program has many features, but they must be used correctly or else your audience will be distracted or overloaded. In this lesson, we'll explore the best ways to create an effective presentation that incorporates the right mix of multimedia. You'll learn how to insert graphics and audio into your presentation in an effective and organized manner.
Lesson 9: Integrating Microsoft Office Programs
The suite of Microsoft Office products includes Excel and Access, which are both very powerful on their own. In this lesson, you are going to learn how to actually integrate information from one program to the other. You can create data lists with either program and easily transfer the information to the other. Considering all the work we do with lists on the computer, this is a very important skill in today's work environment. Plus, you'll find out how mail merge can save you time and effort by allowing you to customize letters, labels, and more!
Lesson 10: Using the Internet
In today's lesson, we're going to have fun working with the Internet. This is the greatest source of information you'll ever have access to—yet it can be confusing and overwhelming if you are not familiar with the basic Internet tools. You'll really enjoy seeing how easy it is to find information that specifically meets your needs and interests.
Lesson 11: Transferring and Protecting Data
Today, we'll go over various methods for transferring information from one computer to another. We'll explore different terms used to describe the volume of information—or size of a file—and then learn how to most effectively and efficiently move that data from place to place. You'll learn about bytes, megabytes, memory sticks, and external hard drives.
Lesson 12: Putting Your Skills to Work
In our final lesson, we will focus on putting all your new knowledge to work! We have three specific goals. The first is to identify ways to use your computer skills to find a new job. The second is to use those same computer skills to get a promotion within your current organization. Our third goal is to explore strategies for continued learning in order to support your ever-growing employment goals.
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
This course will give you the knowledge to help you decide whether a career in cybersecurity is right for you. This course is designed to explore the basics of cybersecurity and the types of jobs found in the cybersecurity field.
This course explores a career in cybersecurity and reviews various topics, including cybersecurity roles, job requirements, problem-solving techniques, and cybersecurity concepts. This course will help you decide whether a career in cybersecurity is something that aligns with your talents and interests and, if so, the best next steps to pursue this lucrative career path.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC, Mac, or Chromebook.
Software Requirements:
PC: Windows 10 or later.
Mac: macOS 10.6 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
There are no instructional material requirements to take this course.
Getting into cybersecurity can be rewarding and lucrative! In fact, according to the U.S. Bureau of Labor Statistics, information security analysts can make over $100,000 per year. This course will give you the knowledge to help you decide whether a career in cybersecurity is right for you.
The course will start by introducing the basics of cybersecurity. You will learn the types of threats companies face daily and how a cybersecurity specialist can help prepare for and prevent those threats. Finally, the course will cover cybersecurity learning paths and different types of cybersecurity jobs and salaries.
Introduction to Cybersecurity
Cybersecurity Roles and Industries
Problem Solving
Cybersecurity Basics
Types of Information Security
Common Concepts and Terminology
Types of Threats
Secure Coding
Protecting the Business
Developing a Security Awareness Program
Employment and the Future of Cybersecurity
Next Steps
What you will learn
Explore cybersecurity as a career path
Identify cybersecurity job roles and industries
Describe the soft skills that cybersecurity professionals need
Explain the threats that cyberattacks pose to modern businesses
Explain the importance of securing information
Define common cybersecurity terms and concepts
Explain the role of secure coding in preventing cyberattacks
Identify the ways that cybersecurity professionals protect a business
Describe the key elements of a security awareness program
Identify employment opportunities and career steps in the cybersecurity field
How you will benefit
Learn if a career in cybersecurity is right for you
Explore the basics of the cybersecurity industry
Discover potential career paths in the cybersecurity field
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Take your Microsoft Excel 2016 skills to the next level as you master charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Excel functions.
In this hands-on course, you will learn how to create informative, eye-catching charts and graphs, and harness the power of Excel's data analysis tools and AutoFilter commands. In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other time-saving functions to your repertoire.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Microsoft Office Home and Student 2016 (not included in enrollment).
Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Take your Microsoft Excel 2016 skills to the next level as you master charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Excel functions.
Excel Charts and Graphs
In your first lesson, you will discover why Excel 2016 is such a powerful charting tool. To you, a workbook's numbers might tell an interesting story; to others, that story may not be obvious. You will learn how to choose the right chart for your story and then how to create, format, and edit your chart.
More Excel Charts
This lesson continues exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they may not be well-known, these options can add tremendous value to your worksheets in the right situations.
AutoFilter and Sorting
Working with data in Excel can be quite easy when you know about the tools that are available in a table format. One of these great tools is the Auto Filter command. This lesson will teach you how to use Auto Filter to limit your table information to just the records you want.
Goal Seeking
If you know what formulas you want but don't know how to get there, Excel's Goal Seek is exactly what you need. In this lesson, you will learn how to utilize this tool to avoid the trial-and-error approach that most Excel users go through to get to the right answer.
PivotTables
This lesson will teach you how to use one of the best features of Excel: the PivotTable. There's no greater "what-if" analysis tool to summarize, reorganize, and report data.
Advanced PivotTables
Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. This lesson takes a tour through some of Excel's more advanced techniques, like the PivotTable filtering tool Slicer. You will also learn how a PivotTable can serve as your source for the PivotChart.
Solver
Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you will learn how to use Solver to solve a complex problem based on criteria and constraints.
Sparklines
There's nothing more exciting than learning how to master a new feature in Excel. This lesson focuses on creating three types of Sparklines, as well as formatting options for each. By the end of the lesson, you will have the skills to create dashboard-style mini charts.
Macros
In this lesson, you will find out how to use macros to turn repetitive and often time-consuming tasks into automated Excel functions. You will also learn how to record a macro that performs time-consuming task in seconds with the click of a button.
Introduction to Functions
If you have used Excel for a while, you know there are hundreds of functions at your disposal. The last three lessons of this course will cover how and why you would use these functions. This lesson introduces creating various functions with the Text category.
Math/Trig Functions
Next to learning how to create macros, most students want to learn as much as they can about Excel functions. This lesson covers on more complex functions of the "Math & Trig" category, focusing on the SUMIF and COUNTIF functions in particular.
VLOOKUP, INDEX, and MATCH Functions
Since functions are such an integral part of using Excel, your final lesson will cover advanced features. In this lesson, you will learn how to use the VLOOKUP, INDEX, and MATCH functions.
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Learn how to use the more advanced features of Microsoft Word 2016 (now available through Office 365) including how to add graphics, use templates, and merge data.
Go beyond the basics of word processing and master the more advanced features of Microsoft Word 2016 (now available through Office 365). In this course, you'll learn how to automate Word 2016 using shortcuts to help you write more while typing less. From signs, newsletters, and greeting cards to long documents, you'll learn how to create whatever you need—quickly and with professional-looking results.
You'll also learn how to create and organize text in tables, mix graphics and text together to turn Word into a simple desktop publishing program, and merge spreadsheet and database data to create mailing labels and form letters. Along the way, you'll go through lots of examples and exercises so you can see how Word's advanced features work; but more importantly, you'll see how you can use these advanced features at home and on the job. By the end of this course, you'll know how to use Word more effectively and take advantage of all its many features so you can get your work done more quickly and more easily than you ever thought possible.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Learn how to use the more advanced features of Microsoft Word 2016 (now available through Office 365) including how to add graphics, use templates, and merge data.
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
This introductory course is for those with little to no cybersecurity experience that want to learn more about this growing industry.
This self-paced course is designed to help you increase your knowledge of cybersecurity and technology fundamentals to fill knowledge gaps in your current role or pursue an entry-level career in this in-demand field. We answer questions around what cybersecurity is, what an operating system does and the most common types, cloud computing, and many other topics related to cybersecurity foundations.
You will have the opportunity to develop your foundational cybersecurity skills through hands-on demonstrations as you follow along with the instructor videos, learn time-saving tips to increase your efficiency, and establish best practices.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC, Mac, or Chromebook.
Software Requirements:
PC: Windows 8 or later.
Mac: macOS 10.6 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
This course gives you the option of following along with the instructor on a few video-based exercises, allowing you to pause and replay until you are confident in your skillset. Should you wish to follow along, it is recommended that you have the following: Windows 10 environment, Wireshark, an AWS account (free tier), and a Windows 2016 VM (available in the AWS free tier).
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
The need for skilled cybersecurity professionals continues to grow year over year, making it a great time to enter this in-demand industry.
In this video-based learning course, you will learn fundamentals of cybersecurity such as concepts, commands, and tools from an experienced professional through lectures and follow-along demonstrations. You will also learn about cloud computing, networking, cybersecurity policy, and frameworks, as well as risk management and security auditing in a 100% online, self-paced training format.
By the completion of your course, you will have a firm understanding of cybersecurity foundations, including key concepts and best practices.
Cybersecurity Foundations
Operating Systems
Windows Command Line Foundations
Network Fundamentals
Cloud Computing Fundamentals
Cybersecurity Policy, Framework, and Guidelines
Cybersecurity Audit Foundations
Risk Management
Penetration Testing - Demonstration
What you will learn
Understand what cybersecurity entails
Identify the three most common operating systems
Execute simple commands
Learn about cloud computing and networking
Learn about cybersecurity policies, frameworks, audits, and risk management
How you will benefit
Learn if a career in cybersecurity could be right for you
Increase your baseline knowledge of foundational cybersecurity concepts
Learn tips and tricks from a working cybersecurity professional
Follow along with hands-on demonstrations to develop and practice your foundational skills
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Learn how to make the most of your scrapbooking talents and artistic ideas when you combine digital and traditional scrapbooking techniques.
Learn to use digital editing techniques to show off your photos and memorabilia in Introduction to Digital Scrapbooking! Using Photoshop Elements 11, 12, or 13, this course will teach you how to make the most of your scrapbooking talents and artistic ideas when you combine traditional and digital scrapbooking.
Starting with simple projects, you'll quickly learn how to build pages, use artistic journaling, and produce sophisticated illusions. Photoshop Elements lets you build your own clip art, create frames, and develop multi-layer pages with an endless array of layouts and designs. You'll see how to draw and create your own art, build collages and scrapbooks to share, and work with both color and black and white. If you need to restore or age images—the tools are all available to you. Come take your scrapbooking to a new level!
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC or Mac.
This course is written using the Windows version of the software. If you have Mac, you will need to make standard Windows/Mac keystroke conversions which are included in the course material.
Software Requirements:
PC: Windows 8 or later.
Mac: macOS 10.6 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
Adobe Photoshop Elements 11 or higher (not included in enrollment). Instructions, screenshots, and examples are based on versions 11, 12, and 13, but later versions, including year-numbered versions like Photoshop Elements 2020, work well with only minor changes for the course.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Make the most of your scrapbooking talents to show off your photos and memorabilia with digital scrapbooking. This course provides hands-on experience building scrapbook pages, using artistic journaling, and producing your own artwork with Photoshop Elements.
What Is Digital Scrapbooking?
Digital editing gives scrapbooking a new level of creativity! In the first lesson, you'll have an opportunity to become familiar with the online classroom, Photoshop Elements 11 (the digital editing software you'll be using in this course), and a number of ways to integrate digital options with traditional scrapbooking. You'll see how to keep your personal style intact while taking advantage of fun and easy techniques to enhance your scrapbooks.
Journaling
In this lesson, you'll have an opportunity to experiment with and explore the many options for enhancing text. You'll see how to add color, shape, and styles, along with more advanced techniques like warping text to fit on objects, making circles with words, and transforming images into text. Journaling is an important part of the storytelling process, so it's time to put the words to work!
Layering
Whether you're working with scissors and glue or digital images, one of the ways to embellish scrapbook pages is to layer artistic elements. In this, you'll explore Adobe's layers so you can master the ability to build pages with many different pieces to create the look that tells your story best! The lesson will discuss sizing, background images, frames, and piecing together pages with multiple images, text, and clip art.
Clip Art
Now that you're comfortable with backgrounds, cropping, text, and layers, it's time to add some pizzazz to your pages! In this lesson, you'll see how to create and use clip art to add personal touches and dimension to your scrapbook. You may be surprised at how many important details you have in your pictures, and with Photoshop Elements, you'll be able to pick those out and use them just where you want them. Creating clip art is fun and easy with the tools in Elements. You'll be a pro by the time you finish this lesson!
Themed Layouts
Continuity and strong story lines captivate readers—even in scrapbooks! This lesson focuses on defining themes, using repetitive elements, and sizing enlargements for excellent quality. You'll see how to build two-page layouts, create panoramic images, and use two different techniques for adding frames to your pages.
Beauty of Black and White
Bold and beautiful, black-and-white photography leads to a lesson on how to take a classic look and make it modern, timeless, or even old-fashioned. You'll see how to turn color photos into stunning black-and-white images, or how to keep just a portion in color. You'll also explore using gradients to create black-and-white backgrounds to set off color images.
Creative Illusions
In this lesson, you'll work a little magic as you learn to create special effects to enhance your backgrounds and pages. You'll even be able to create some of these from nothing! The illusion of texture and dimension is important when building a sophisticated scrapbook, and you'll look at ways to build pages that might just make you wonder if they're real. With the Effects panel, the Filter menu, and some new tricks with layers and layer styles, you'll be amazed at what you can do.
Bountiful Brushes
Much like finger painting lets you release your artistic side, Photoshop Elements brushes are full of possibilities for detailed strokes, colors, and patterns—some even paint pictures! You'll see how to use the standard brushes, create and customize your own, and build pages and backgrounds with a variety of styles and patterns.
Digital Nostalgia
In this lesson, you'll see how to turn back the hands of time to create pages using restored images and nostalgic pages. You'll also learn how to age a modern photo to match the look of older ones. With the pattern tools in Photoshop Elements, you'll create fabric-like backgrounds and even see how to add a bit of stitching. Digital editing merges the old and the new in surprising ways!
3D Imagery
Digital scrapbooking gives you lots of options for creating three-dimensional looks, and in this lesson, you'll see how to use new shortcuts to make this quick and easy. With Photoshop Elements Guided Edit and special filters, you'll be able to create reflections, spheres, and many more effects.
Digital Drawing
It's time to draw! You'll be surprised by how creative you can be with Photoshop Elements drawing tools, even if you don't think of yourself as artistic. With the Pencil tool, the Undo option, and the Eraser tool, changes and corrections are easy. You can even remove something and put it back. You'll see how to add line graphics with Wingdings and turn color images into coloring pages, as well as some other drawing techniques you can use to build backgrounds and art for your scrapbook pages.
Bringing It All Together
In the last lesson, you'll explore a couple of automatic options in Photoshop Elements to help you finish your scrapbooks quickly. You'll see how to build an automatic collage page from your images and how to upload them to book formats you can print at home or send out to have professionally printed. You'll finish this course with lots of great ideas to finish your scrapbooks and share them with your family and friends!
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Learn to use the basic features of Word 2016 (now available through Office 365) to type, edit, format, spell check, and print professional-looking documents, letters, and reports.
One of the most basic skills needed in any job is writing reports and letters using Microsoft Word 2016, now available through Office 365. In this course, you will gain the foundational skills you need to make the most of this powerful program.
Through hands-on instructions, you will learn how to add and edit text; move words from one part of your document to another; work on two or more documents simultaneously; and format your text. You will also see how to save, retrieve, copy, organize, and print your documents.
You will learn dozens of ways to modify the appearance and content of your documents by adjusting page margins, paragraph tab settings, and line spacing to create great-looking documents quickly and easily. If you need to type foreign language characters or symbols, you can do that in Word too.
By using Word's spell and grammar checker, you can catch typos and grammatical mistakes before you print or share your document with others. You will also explore the program's thesaurus feature, which can help you find exactly the right word. By the time you're done with the step-by-step lessons and hands-on activities in this course, you will be able to use Word confidently at home or on the job.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Learn to use the basic features of Word 2016 (now available through Office 365) to type, edit, format, spell check, and print professional-looking documents, letters, and reports.
Getting Started
In this introductory lesson, you will learn how to use the different parts of Word 2016's user interface, how to look at your document from different types of views, how to zoom in and out to magnify or shrink your text, and how to change the margins of individual paragraphs.
Typing and Navigation
The whole purpose of Word is to let you create and edit text. This lesson introduces the basics of moving the insertion point and deleting text. By knowing the pros and cons of navigating through a document with the keyboard and mouse, you can use both to help you work faster in Word.
File Management
In this lesson, you will learn how to save the documents you create in Word. You will also learn how to rename, copy, and even delete any files you have created, so you will always be in complete control of all the files you create.
Editing Text
After you've typed some text in a Word document, you may need to edit that text. This lesson focuses on editing text. The easiest way to edit text is to delete it, but a more sophisticated way to edit text is to copy text and paste a duplicate of that text in another location.
Working With Multiple Documents
Most people use Word to view and edit a single document at a time, but Word actually lets you open and view two or more documents at the same time. This lesson will teach you how to open, switch between, and view multiple documents.
Text Formatting and Alignment
Once you know how to add, delete, copy, and move text, the next step to modifying your document is to change the physical appearance of your text. You can make text appear in different colors or background highlighting, change text size and alignment, and even modify fonts.
Printing
Most people use Word to print letters and reports. In this lesson, you will learn about the different ways you can print a document, such as portrait orientation or landscape orientation. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents.
Margins, Tabs, and Page Numbering
By knowing how to set and use margins, you can modify an entire document or just a single page. By using tabs, you can modify how individual paragraphs look on a page. Finally, you will also learn how to add page numbers to the top or bottom of a page to keep track of page order.
Paragraph Formatting
Word provides ways to change the appearance of a paragraph's first line, line spacing within a paragraph, and line spacing between paragraphs. In addition, Word lets you create bullet and number lists, so you can display short bits of information in a visual manner.
Language Tools
For important documents, you may even need to collaborate with others. To keep track of all the changes multiple authors may make to a single document, Word offers a Track Changes feature, so you can see exactly what and who changed the document.
Customizing Word
With Word, you can press different types of keystrokes or search and click the symbol you want to use. This lets you add practically any type of unusual character to your documents. Word lets you type practically anything you want, regardless of the limitation of the keys on your keyboard.
Making a Word Document Pretty and Organized
Finally, you can use outlines to organize your text and quickly move chunks of text within a document just by rearranging an outline heading. By learning these advanced features of Word, you can make each document display text in the most appealing way possible.
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
This MySQL course provides new PHP developers with the prerequisite knowledge necessary to learn to build database-driven websites with PHP and MySQL.
This MySQL course provides new PHP developers with the prerequisite knowledge necessary to learn to build database-driven websites with PHP and MySQL. It does not cover PHP, but it prepares you for learning PHP to integrate with MySQL. Although most of the SQL learned in the course is applicable to all major databases, including SQL Server, Oracle, and PostgreSQL, it focuses on MySQL.
This course starts with the basics of relational databases. You will learn to use simple SELECT queries to pull data, and then move on to more advanced SELECTs and data manipulation. You will shape the results of your queries to create relevant reports. Once you have mastered the basics, you will get hands-on with complex data retrieval methods like subqueries, joins, outer joins, and unions. Finally, you will use INSERT, UPDATE, and DELETE while learning best practices for maintaining your records.
By the end of this MySQL for PHP course, you will know MySQL and SQL well enough to start using it with PHP (and elsewhere).
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC or Mac. Chromebooks are not compatible.
Software Requirements:
PC: Windows 8 or later.
Mac: macOS 10.10 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
In this online course you will learn how to connect MySQL to PHP. You will also learn how to create a MySQL database This MySQL course provides new PHP developers with the prerequisite knowledge necessary to learn to build database-driven websites with PHP and MySQL. This course does not cover PHP, but it prepares you for learning PHP to integrate with MySQL. Although most of the SQL learned in the course is applicable to all major databases, including SQL Server, Oracle, and PostgreSQL, it focuses on MySQL.
Relational Database Basics
Brief History of SQL
Relational Databases
Tables
Rows
Columns
Relationships
Datatypes
Primary Keys
Foreign Keys
Relational Database Management System
Popular Databases
Commercial Databases
Popular Open Source Databases
SQL Statements
Database Manipulation Language (DML)
Database Definition Language (DDL)
Database Control Language (DCL)
Simple SELECTs
Introduction to the Northwind Database
Some Basics
Comments
Whitespace and Semi-colons
Case Sensitivity
SELECTing All Columns in All Rows
Exercise: Exploring the Tables
SELECTing Specific Columns
Exercise: SELECTing Specific Columns
Sorting Records
Sorting by a Single Column
Sorting By Multiple Columns
Ascending and Descending Sorts
Exercise: Sorting Results
The WHERE Clause and Logical Operator Symbols
Checking for Equality
Checking for Inequality
Exercise: Using the WHERE Clause to Check for Equality or Inequality
Checking for Greater or Less Than
Exercise: Using the WHERE Clause to Check for Greater or Less Than
Checking for NULL
Exercise: Checking for NULL
WHERE and ORDER BY
Exercise: Using WHERE and ORDER BY Together
Checking Multiple Conditions with Boolean Operators
AND
OR
Order of Evaluation
Exercise: Writing SELECTs with Multiple Conditions
The WHERE Clause and Logical Operator Keywords
The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator
Exercise: More SELECTs with WHERE
Advanced SELECTs
Calculated Fields
Concatenation
Mathematical Calculations
Aliases
Exercise: Calculating Fields
Aggregate Functions and Grouping
Aggregate Functions
Grouping Data
Exercise: Working with Aggregate Functions
Selecting Distinct Records
Built-in Data Manipulation Functions
Common Math Functions
Common String Functions
Common Date Functions
Exercise: Data Manipulation Functions
Subqueries, Joins and Unions
Subqueries
Exercise: Subqueries
Joins
Table Aliases
Multi-table Joins
Exercise: Using Joins
Outer Joins
Unions
UNION ALL
UNION Rules
Exercise: Working with Unions
Inserting, Updating and Deleting Records (if time allows)
Inserting Records
Updating and Deleting Records
What you will learn
Understand how MySQL works
Learn to use SQL to output reports with MySQL
Learn to modify MySQL data with SQL
How you will benefit
Organizations store data in databases, and MySQL is the most popular open source database. Knowing how to query those databases opens up opportunities for you to build reports for such organizations
Database-driven websites require knowledge of SQL, and MySQL is one of the most popular databases used to build these websites, especially those built with PHP. This course gives you the prerequisite knowledge to start learning a server-side language such as PHP to use with MySQL
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Learn to use QuickBooks Online to record income and expenses; enter checks and credit card payments; track your payables, inventory, and receivables; and much more.
In this self-paced online course, you will learn to manage the financial aspects of your business quickly and efficiently with QuickBooks Online. This powerful accounting software program has helped millions of small business owners oversee their finances.
You will learn to use key features of QuickBooks Online and gain hands-on experience creating invoices, receipts, and statements; tracking payables, inventory, and receivables; generating reports; and more. Whether you're new to QuickBooks or need a quick refresher, this course will empower you to take control of your business's financial accounting, all with the ease and convenience of an online platform.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC or Mac.
Software Requirements:
PC: Windows 10 or later.
Mac: macOS 10.11 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
When your course starts, you will be directed to access and utilize the free QuickBooks Online practice site to complete the lesson and assignment steps. You do not need to purchase a subscription or additional software to complete this course. However, please note that this course is suitable only for the QuickBooks Online version. The desktop versions of QuickBooks are not compatible with this course and should not be used. If you have the desktop version, you should consider registering for the course specifically designed for your version.
Note: This course is based on the U.S. version of QuickBooks. Other locations are not supported.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Learn to use QuickBooks Online to record income and expenses; enter checks and credit card payments; track payables, inventory, and receivables; and much more.
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Learn the key concepts of SQL (Structured Query Language) the powerful and standard database management query language for relational databases.
SQL (Structured Query Language) is one of the best programming languages for beginning web developers to learn. This course will teach you the basics of designing and writing SQL queries to execute on a practice database. Using a SQL Server Express, you'll learn several real-world applications for SQL so you can put this valuable skill set on your resume.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. Macs are not compatible.
Dual monitors are helpful but are not required.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Necessary rights (local administrative rights) to install programs on the computer.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
SQL Server Express
SQL Server Management Studio
Gain a solid working knowledge of the most powerful and widely used database programming language. This course will provide you the skills to write SQL queries to create tables, retrieve data from single or multiple tables, manipulate data in a database, and gather statistics from data stored in a database.
Introduction to Database Design and SQL
In this introductory lesson, you will examine database terms and concepts. Understanding the purpose of a database and collecting data is foundational to using SQL to write queries and retrieve data result-sets that are usable.
SQL Server
In this lesson, you will install SQL Server Express and the SQL Server Management Studio to use throughout the course in your learn-by-doing practices. You will use a SQL code script to create one of the tables for the practice database in SQL Server.
Retrieving Data Result-Sets
SQL queries are the statements used to retrieve data from the database. Queries are written in a specific, logical order. In this lesson, you will explore various ways to write SQL queries to retrieve data that meets a defined criteria.
Sorting Data
SQL queries are defined and written to retrieve data in a certain order. Queries are also written to limit columns and to filter data rows. In this lesson, you will explore and practice defining and writing queries to meet a defined criteria to retrieve the expected result-set.
Designing SQL Data Tables
This lesson is about designing SQL data tables for a database. You will explore the relationship concept and how it is used in a RDBMS. You will define tables that are structured according to RDBMS standards. You will also create the tables to add to your practice database.
Designing Data Rows
In this lesson, you will add data to your newly defined tables. You will explore several methods of adding data to a table, and you will also practice writing and executing these query statements. After adding several individual rows to the tables, you will use a SQL code script to populate your tables with enough data rows to use in the learn-by-doing practices in this course.
Getting Data From Two Tables
SQL JOIN statements are used to retrieve data from more than one table. In this lesson, you will practice writing JOIN query statements that are defined to retrieve data result-sets from tables that have a relationship between their PKs and FKs.
Retrieving Data From Multiple Tables
In this lesson, you will continue writing JOIN statement that retrieve data result-sets from more than one table. You will also examine how and when to use SQL subquery statements to retrieve data from multiple tables. You will practice defining and writing JOIN and subquery queries.
Keeping the Database Up to Date
The quality of the data in the database depends on its integrity, including the concepts of data accuracy and consistency. In this lesson, you will explore writing queries to maintain the database so that it is up to date with data that is accurate, consistent, and has integrity.
Aggregate Functions
In this lesson, you will examine the concept of aggregate functions and how they are used in query statements to examine multiple rows. Aggregate functions are a method of retrieving summarized data that is useful for analysis.
SQL Views
SQL views are an important concept in database design and in using databases. In this lesson, you will explore designing and writing queries to create views. You will also explore the reason they are valuable for database security and database access.
Maximize Database Integrity and Performance
Constraints are one way to maximize the integrity of the database and minimize the opportunity for user error. Indexes are used for increasing the performance of a data query. In this lesson, you will explore both these concepts.
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Learn how to touch-type or improve your existing typing skills using Keyboarding Pro 5.
If you want to learn touch-typing or improve your existing typing skills, this is the perfect course for you! In these lessons, you'll use the Keyboarding Pro 5 program, a typing tutorial designed for personal computers, to learn how to touch-type—that is, to type text you read from a printed page or a computer screen without looking at your keyboard.
With the skills you master here, you'll become faster and more confident at the keyboard. By the end of the course, you'll know how to touch-type the alphabetic, numeric, and symbol keys; create, save, and edit word processing documents; and successfully take a timed writing test during a job interview.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. Macs are not compatible.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
When the class starts, you'll receive instructions for downloading and installing a working copy of Keyboarding Pro 5. Please do not purchase or download the software from another source.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Learn how to touch-type or improve your existing typing skills using Keyboarding Pro 5.
Getting Started with Key Pro 5
Your first lesson guides you step by step as you download, install, and set up Key Pro 5. You will also get acquainted with the program, learning about the home row keys and the reach to the "i" key on the QWERTY keyboard. Are you confused about what home row and QWERTY mean? Don't worry—this lesson explains all of that.
Lowercase Letters, Plus the Reaches to the "e" and the "n"
Now that you're getting comfortable with the home row on the QWERTY keyboard, it's time to introduce you to some new keys. This lesson focuses on proper techniques for lowercase letters. You will also use Key Pro 5 to practice the reaches to the e and the n. Is all this typing causing you aches and pains? You will find out how to reduce fatigue while typing.
The Left Shift, h, t, and Period Reaches
In this lesson, you will learn four new keystrokes: left SHIFT, h, t, and period (.). You will also provide some tips on improving speed and accuracy and introduce you to the Key Pro 5 word processor program.
Learn the r, Right SHIFT, c, and o Reaches
Continue to build your keyboarding vocabulary by learning four new key reaches in this lesson: r, right SHIFT, c, and o. You will also learn about "the Zen of typing," how touch-typing becomes an instinctive and unconscious action.
The w, Comma, b, and p Reaches
Your typing vocabulary continues to expand rapidly with the addition of the reaches to the w, comma, b, and p. Before you know it, you will be typing complete paragraphs. This lesson also covers what you need to know about carpal tunnel syndrome, a serious and painful condition that you can avoid.
The g, Question Mark, x, and u Reaches
Expand your typing vocabulary by mastering four more key reaches: the g, question mark (?), x, and u. Just a few more reaches, and you will know how to type the whole alphabet. In this lesson, you will also learn about the function (FN) key and the numbers lock (NUM LOCK) key, which are on most laptop keyboards.
The q, m, v, and Apostrophe Reaches
This lesson teaches you another four reaches for your typing vocabulary: q, m, v, and apostrophe ('). You will also learn how to save a document with a word processing program.
The z, y, Quotation Mark, and TAB Reaches
It's time to add another four reaches to your typing vocabulary: the z, y, quotation mark ("), and TAB keys. After this lesson, you will know the reaches to all the alphabetic keys. You will also find out how to open, edit, and resave word processing documents.
Alphabetic Key Review, the 1 and 8 Number Reaches, and Timed Writings
Are you ready to improve your skills and learn some new ones? After you review the z, y, x, q, v, quotation mark, and CAPS LOCK keys, you will learn the reaches to the numbers 1 and 8. Then you will take timed writings in the Key Pro 5 word processor.
Number Reaches, Deleting Text, and Alphabetic Key Review
What's the difference between the DELETE key, the BACKSPACE key, and the Cut command? By the end of this lesson, you will understand how and when to use these three editing tools. You will also continue to improve your skills with the alphabetic keys, plus you will learn more number reaches: 5, 0, 2, and 7.
Number and Symbol Reaches, Number Rules, and Key Review
When should you spell out numbers (like this: one, nine, five hundred), and when should you write them as figures (1, 9, 500)? You will also continue to improve your skills with the keys you have already learned, and you will finish the number reaches by mastering 4, 9, 3, and 6. Then you will learn two symbol reaches: the dollar sign ($) and the hyphen (-).
Symbol Reaches and Skill Building
You have already mastered some of the symbols and punctuation marks. In your last lesson together, you will meet the rest of the symbols. You will also work on your accuracy and speed with the Key Pro 5 Skill Building lessons. And you will find out how you can continue to hone your keyboarding skills long after you have finished this course.
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Obtain valuable skills working with data in Excel in this self-paced, online course.
Master the VLOOKUP function in Microsoft Excel and gain valuable skills applicable in any workplace where data is used when you complete this self-paced, online course. You will learn to work with data more effectively using the VLOOKUP functions and other helpful features in Microsoft Excel.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. Macs are not compatible.
Software Requirements:
PC: Windows 10 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Take your Microsoft Excel 2016 skills to the next level as you master charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Excel functions.
In this hands-on course, you will learn how to create informative, eye-catching charts and graphs, and harness the power of Excel's data analysis tools and AutoFilter commands. In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other time-saving functions to your repertoire.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Microsoft Office Home and Student 2016 (not included in enrollment).
Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Harness the power of Excel and become a master user of this powerful program. This hands-on course will provide skills using charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2016 functions.
Excel Charts and Graphs
In your first lesson, you will discover why Excel 2016 is such a powerful charting tool. To you, a workbook's numbers might tell an interesting story; to others, that story may not be obvious. You will learn how to choose the right chart for your story and then how to create, format, and edit your chart.
More Excel Charts
This lesson continues exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they may not be well-known, these options can add tremendous value to your worksheets in the right situations.
AutoFilter and Sorting
Working with data in Excel can be quite easy when you know about the tools that are available in a table format. One of these great tools is the Auto Filter command. This lesson will teach you how to use Auto Filter to limit your table information to just the records you want.
Goal Seeking
Learn how to use Solver to solve a complex problem based on the criteria and constraints that you provide it. You'll also explore in detail how to create all three types of Sparklines, as well as formatting options for each and gain the skills to create dashboard-like mini charts sure to make you the envy of your office.
PivotTables
Find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Then, receive a quick overview of all the categories of functions and the different methods you can use to create them.
Advanced PivotTables
Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. This lesson takes a tour through some of Excel's more advanced techniques, like the PivotTable filtering tool Slicer. You will also learn how a PivotTable can serve as your source for the PivotChart.
Solver
Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you will learn how to use Solver to solve a complex problem based on criteria and constraints.
Sparklines
There's nothing more exciting than learning how to master a new feature in Excel. This lesson focuses on creating three types of Sparklines, as well as formatting options for each. By the end of the lesson, you will have the skills to create dashboard-style mini charts.
Macros
In this lesson, you will find out how to use macros to turn repetitive and often time-consuming tasks into automated Excel functions. You will also learn how to record a macro that performs a task in seconds with the click of a button.
Introduction to Functions
If you have used Excel for a while, you know there are hundreds of functions at your disposal. The last three lessons of this course will cover how and why you would use these functions. This lesson introduces creating various functions with the Text category.
Math/Trig Functions
Next to learning how to create macros, most students want to learn as much as they can about Excel functions. This lesson covers on more complex functions of the "Math & Trig" category, focusing on the SUMIF and COUNTIF functions in particular.
VLOOKUP, INDEX, and MATCH Functions
Since functions are such an integral part of using Excel, your final lesson will cover advanced features. In this lesson, you will learn how to use the VLOOKUP, INDEX, and MATCH functions.
What you will learn
Master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2016
Learn to create useful and eye-catching charts
Discover how to manipulate data with the push of a button
Add the time-saving functions of advanced Excel users to your repertoire
How you will benefit
Take your Excel 2016 skills to an expert level and become a more productive member of your organization
Gain indispensable skills that will be useful in any organization that relies on numbers-based reporting
Learn to fully harness the power of Microsoft Excel 2016 and use all of its capabilities to save time and money
Chad Wambolt
Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn how to use the more advanced features of Microsoft Word 2016 (now available through Office 365) including how to add graphics, use templates, and merge data.
Go beyond the basics of word processing and master the more advanced features of Microsoft Word 2016 (now available through Office 365). In this course, you'll learn how to automate Word 2016 using shortcuts to help you write more while typing less. From signs, newsletters, and greeting cards to long documents, you'll learn how to create whatever you need—quickly and with professional-looking results.
You'll also learn how to create and organize text in tables, mix graphics and text together to turn Word into a simple desktop publishing program, and merge spreadsheet and database data to create mailing labels and form letters. Along the way, you'll go through lots of examples and exercises so you can see how Word's advanced features work; but more importantly, you'll see how you can use these advanced features at home and on the job. By the end of this course, you'll know how to use Word more effectively and take advantage of its many features so that you can get your work done quicker and easier than you ever thought possible.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Master the advanced features of Microsoft Word 2016 and create truly professional looking documents. This hands-on course will help you learn how to create an index, build a list of figures, design a table of contents, do desktop publishing, perform a mail merge, and use timesaving shortcuts.
Shortcuts and Time-Savers in Word 2016
Humanity has come a long way since the days of the typewriter. What used to take hours can now be done in seconds with Microsoft Word 2016. And the less time you spend typing, the more time you can spend being creative and having fun. In this lesson, you'll learn shortcuts in Word that can help you create documents faster and more accurately than ever before. Not only will these shortcuts save you time, but they'll help you create letters and reports more easily than you might have thought possible.
Text and Paragraph Formatting Methods
What you write is half of communication. The other half is getting people to read what you write. One way to make your writing more appealing is to make it look presentable with formatting. Of course, formatting text is easy, but applying different types of formatting over and over again can get tedious. That's why, in this lesson, you'll learn a fast and easy way to format chunks of text quickly and consistently using something called styles. You'll find out what a style is, how to apply it, and more important, how to create and save your own styles to use in any document. By the end of this lesson, you'll be able to make any document look presentable with just the click of your mouse.
Templates
If you've ever baked cookies, or even just watched someone else do it, you know how difficult it can be to make all the cookies in a batch look exactly alike. Some turn out big, some small, some gooey, and some burned! However, if you use a cookie cutter, you can make identically shaped cookies every time. That's the same principle you'll learn in this lesson; instead of using a cookie cutter, though, you'll use something called a template. A template stores the formatting of a document so that you can apply it to another document. Templates let you format entire documents as easily as formatting a single word. Word offers lots of convenient templates stored right on your computer or available over the Internet, and you'll also find out how you can create your own.
Graphics: Part 1
They say a picture is worth a thousand words, so what better way to spice up your documents than by adding pictures? In this lesson, you'll learn how to add your own digital photographs to a document so that you can show everyone your vacation pictures, family holidays, or just interesting sights you've captured with your own camera. In addition to adding your own photos, you can also add clip art from Word's massive library of free graphics. And you'll find out how to resize, rotate, and style your pictures, as well as wrap your document text around them. By the end of this lesson, you'll see why Word documents are about much more than words!
Graphics: Part 2, and Columns
Digital photographs and clip art are just the beginning of what you can do with graphics in Word. In this lesson, you'll discover how to add a variety of informational graphics, including charts, graphs, and WordArt, which allow you to display text as a graphic image. Not only will you learn how to add these graphics, but you'll also find out how to edit them when your data changes. You'll finish off the lesson by seeing how Word allows you to format documents with multiple columns—a handy skill for creating newsletters and publications!
Sections and Notes
Do you often create long documents? If so, you'll appreciate this lesson, which shows you how to divide a large document into parts called sections. Sections allow you to format part of a document a certain way without that formatting affecting the rest of your text. For example, you may want headers and footers to appear on some pages but not others. Sections make this easy! You'll also spend some time inserting footnotes and endnotes in a document. If you need to write research papers or other academic content, Word makes it a snap to add and format these previously pesky notes!
Tables
If you've ever seen a spreadsheet, you know how rows and columns let you organize numbers and text on the screen. Well, tables do the same thing in Word. In this lesson, you'll see how to create tables of all different sizes right in a Word document! The lesson will cover how to modify tables, too. And don't think Excel users get to have all the fun—you can even enter formulas to perform calculations in your tables, sort them, and style them for a customized look. Your data has never looked so appealing!
Envelopes and Odd-Size Pages
You probably print most of your documents on standard letter-size paper. While this is great for ordinary letters or business reports, sometimes you may want to get creative with your paper sizes. But then there's the trouble of printing. In this lesson, you'll see how you can define the dimensions of the paper you're using, so Word will print everything correctly. You'll also learn how to print names and addresses directly on envelopes of any size. After this lesson, you won't feel confined to boring 8 1/2 x 11-inch paper anymore!
Desktop Publishing: Part 1
As you've probably already figured out, Word can do more than write letters. It also functions as a simple desktop publishing program for creating greeting cards, calendars, or newsletters. In this lesson, you'll find out how text boxes are the key to simple desktop publishing and see how other elements come into play in customized documents. Along the way, you'll look at business cards and greeting cards to get a feel for how desktop publishing works. If you've always wanted to create a document that combines text and graphics in an artistic or visually appealing way, you'll find out how to do that and much more.
Desktop Publishing: Part 2
With the basics down, it's time to take your desktop publishing skills to the next level. In this lesson, you'll discover the magic of linked text boxes that give you the power to move your text anywhere you want on the page and keep it flowing. You'll see how to create, position, resize, and group text boxes so you have total control over your text.
Merging Data with Documents
Have you ever received one of those "personalized" letters from a company in the mail? You can be sure that nobody typed the entire sales letter from scratch. Instead, the company used a form letter and something called mail merging. In this lesson, you'll learn how to store long lists of names and addresses that you can use over and over again in a form letter. Just create a document once, leave blanks for inserting information such as names and addresses, and let Word personalize each letter for you. Now you, too, can create personalized letters for business or personal use, such as sending out holiday greetings to family members and friends.
Final Touches
Look in most books, and you'll find the table of contents at the beginning and an index in the back. Often, these are the last components added to a document, since they need to have accurate titles and page numbers. But Word takes a lot of the tedious work out of creating these components. In this final lesson, you'll see how you can use Styles to make creating the table of contents a snap, and then explore how to tag index terms so Word knows what page they're on, even if they move later. Word can also help you keep track of any figures, such as charts, illustrations, or graphs, in your document. By letting Word worry about the details, you can create an accurate table of contents, index, or list of figures with very little extra effort on your part. These finishing touches will make your most important documents shine!
What you will learn
Learn how shortcut keys, macros, and the AutoCorrect feature can save you time
Discover fast ways to format text in a document
Find out how to insert graphic images, including clip art and photos, into your documents
Add charts, SmartArt, and WordArt to a document, and divide any document into columns
Practice dividing a long document into sections and using footnotes and endnotes
Get acquainted with some of Word's desktop publishing features, such as using text boxes, layering, and aligning objects
Learn how to link text boxes, and position them in a document to create brochures and newsletters
Use mail merging to quickly and easily personalize form documents
How you will benefit
Master the more advanced features of Microsoft Word
Learn how to use Word more effectively and take advantage of all its many features so you can get your work done more quickly and more easily
Wallace Wang
Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn to use the basic features of Word 2016 (now available through Office 365) to type, edit, format, spell check, and print professional-looking documents, letters, and reports.
One of the most basic skills needed in any job is writing reports and letters using Microsoft Word 2016, now available through Office 365. In this course, you will gain the foundational skills you need to make the most of this powerful program.
Through hands-on instructions, you will learn how to add and edit text; move words from one part of your document to another; work on two or more documents simultaneously; and format your text. You will also see how to save, retrieve, copy, organize, and print your documents.
You will learn dozens of ways to modify the appearance and content of your documents by adjusting page margins, paragraph tab settings, and line spacing to create great-looking documents quickly and easily. If you need to type foreign language characters or symbols, you can do that in Word too.
By using Word's spell and grammar checker, you can catch typos and grammatical mistakes before you print or share your document with others. You will also explore the program's thesaurus feature, which can help you find exactly the right word. By the time you're done with the step-by-step lessons and hands-on activities in this course, you will be able to use Word confidently at home or on the job.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Microsoft Word is used in nearly every modern workplace. In this course, you will master all the basics of this powerful word-processing program, including how to type and edit text, and how to format, spell check, and print documents. You will also learn dozens of different ways to modify the appearance and content of your documents and how to catch errors with Word's spell and grammar checker. After completing the course, you will be able to use Word confidently at home or on the job.
Getting Started
In this introductory lesson, you will learn how to use the different parts of Word 2016's user interface, how to look at your document from different types of views, how to zoom in and out to magnify or shrink your text, and how to change the margins of individual paragraphs.
Typing and Navigation
The whole purpose of Word is to let you create and edit text. This lesson introduces the basics of moving the insertion point and deleting text. By knowing the pros and cons of navigating through a document with the keyboard and mouse, you can use both to help you work faster in Word.
File Management
In this lesson, you will learn how to save the documents you create in Word. You will also learn how to rename, copy, and even delete any files you have created, so you will always be in complete control of all the files you create.
Editing Text
After you've typed some text in a Word document, you may need to edit that text. This lesson focuses on editing text. The easiest way to edit text is to delete it, but a more sophisticated way to edit text is to copy text and paste a duplicate of that text in another location.
Working With Multiple Documents
Most people use Word to view and edit a single document at a time, but Word actually lets you open and view two or more documents at the same time. This lesson will teach you how to open, switch between, and view multiple documents.
Text Formatting and Alignment
Once you know how to add, delete, copy, and move text, the next step to modifying your document is to change the physical appearance of your text. You can make text appear in different colors or background highlighting, change text size and alignment, and even modify fonts.
Printing
Most people use Word to print letters and reports. In this lesson, you will learn about the different ways you can print a document, such as portrait orientation or landscape orientation. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents.
Margins, Tabs, and Page Numbering
By knowing how to set and use margins, you can modify an entire document or just a single page. By using tabs, you can modify how individual paragraphs look on a page. Finally, you will also learn how to add page numbers to the top or bottom of a page to keep track of page order.
Paragraph Formatting
Word provides ways to change the appearance of a paragraph's first line, line spacing within a paragraph, and line spacing between paragraphs. In addition, Word lets you create bullet and number lists, so you can display short bits of information in a visual manner.
Language Tools
For important documents, you may even need to collaborate with others. To keep track of all the changes multiple authors may make to a single document, Word offers a Track Changes feature, so you can see exactly what and who changed the document.
Customizing Word
With Word, you can press different types of keystrokes or search and click the symbol you want to use. This lets you add practically any type of unusual character to your documents. Word lets you type practically anything you want, regardless of the limitation of the keys on your keyboard.
Making a Word Document Pretty and Organized
Finally, you can use outlines to organize your text and quickly move chunks of text within a document just by rearranging an outline heading. By learning these advanced features of Word, you can make each document display text in the most appealing way possible.
What you will learn
Learn the fundamentals of one of the most crucial software applications in the modern workplace
Acquire the skills and learn the tools you will need to adjust margins, spacing, layout, and design of any Word document
Learn how to work on multiple projects at once and become faster and more efficient in a variety of Microsoft Word tasks
Explore the many ways to modify the appearance of your documents in order to suit your individual needs
How you will benefit
Gain the confidence you need to make the most of this indispensable software application
Learn how to make the perfect layout for useful documents of any occasion - resumes, invitations, letters, articles, training materials, and much more
Save time and avoid frustration by familiarizing yourself with the wide variety of tools at your disposal in Word 2016
Become more proficient and efficient at one of the most widely used software programs in history
Wallace Wang
Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
This hands-on, project-oriented course is filled with easy-to-follow, detailed step-by-step instructions that teach you how to edit and manipulate images and create elemental compositions using Photoshop in the Creative Cloud. Discover how to improve photographs by editing out flaws, correcting poor exposure, or creating a composite image using the newest techniques.
Photoshop is the world's most popular photo-editing program. Artists, photographers, designers, and hobbyists all rely on Adobe Photoshop for image creation and editing. The Introduction to Photoshop CC course provides meticulous instructions that will teach you how to use Photoshop Creative Cloud with confidence.
Photoshop Creative Cloud has a host of impressive new features, and you will encounter a number of them throughout the course. You will be editing your own photographs to get rid of dust and scratches, fix the color, and correct image exposure. Then you will learn how to colorize parts of an image and how to create simple digital paintings. You will master techniques for switching the backgrounds on images and removing wrinkles and blemishes from photos, just like they do in magazines.
You will also learn about the content-aware Move tools that, like magic, let you move something on an image and intelligently replace the "hole" left behind at the same time. By the time you finish this fun, hands-on, project-oriented course, you will be well on your way to expressing yourself with the most exciting graphics program ever developed.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC or Mac.
Software Requirements:
PC: Windows 10 or later.
Mac: macOS 10.14 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
Adobe Photoshop CC, Adobe Creative Cloud, or any version of Adobe Creative Suite CC that includes the Adobe Photoshop CC or Photoshop only (not included in enrollment).
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Whether you are a photographer, digital illustrator, graphic designer, or someone who wants to alter old family photos, you need to learn Adobe Photoshop. The Introduction to Photoshop Creative Cloud course is filled with easy-to-follow, detailed step-by-step instructions that teach you how to edit and manipulate images and create basic compositions using Photoshop in the Creative Cloud. Discover how to improve photographs by editing out flaws, correcting poor exposure, or creating a composite image using the newest techniques Photoshop has to offer. You will even learn how much fun you can have digitally painting and exploring filters and effects to create unique images. And, best of all, you need no prior artistic ability or Photoshop experience to take this course.
Getting to Know Adobe Photoshop
Whether you're an aspiring graphic artist or a weekend photographer, Photoshop can play many roles in image creation. Even if you've never touched Photoshop before, you'll become familiar with Photoshop's interface and 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 how to crop an image to its desired image area.
Understanding Resolution and Layers
In this lesson, you'll learn and apply the basics in setting image resolution by resizing and resampling graphics for both screen and print purposes. Then, explore the wonders of working with layers. Move and transform objects within a scene to recreate a new composition. You will learn how to add, delete, hide, merge, and group layers as well as to change the blending mode of a layer to reveal new visual effects.
Working with Objects
What makes a good image composite? Find out in this lesson where you will discover the principles of image compositing and apply these by combining images to create your first image composites. Find out how linked layers work and see what Smart Objects can do. You will learn how to use guides to assist in placing and aligning objects. Then, you will use multiple images to create a realistic still-life image. Learn how to transform objects by scaling, rotating, distorting, and warping them.
Image Adjustments
Do you have an old image that has faded over the years? Are your vacation photos over-exposed or too dark? Use image adjustments to correct contrast and color! In this lesson, you will find out how to correct an image's contrast and make the colors pop using image adjustments. You can even remove color to make a black and white or toned image. Then, apply several image adjustments along with blending modes to create a surreal image! Finish this lesson by exploring the filters gallery to apply various artistic filters to a collage.
Image Retouch and Restoration
Need to clear up a few blemishes on a headshot? Or remove unwanted telephone wires from a landscape? This lesson introduces you to the tools used in photo retouching and restoration. This lesson also covers sharpening an image, blurring areas of an image to create a depth of field, and adding a vignette to an image. You will learn how to easily clear up blemishes in portraits and restore old, damaged photographs. You will also learn how to remove or duplicate objects in a scene.
Colorizing Images
Learn how to combine colors and create color themes using Adobe Color. Sample colors from an existing image to create a new color scheme. Then, apply color to black and white photos using several techniques to color areas. Color a single object in a black and white image to create emphasis, or color the entire image, as if filling in a "digital" coloring book. This lesson also covers how to save and load swatches of color to use on other projects.
Working with Brushes
Adobe Photoshop is one of the leading applications for digital painting. This lesson introduces you to brushes and teaches you to paint using different brush types to simulate real artists' materials, such as charcoal, pastels, oil paint, and watercolor. You do not have to have strong drawing skills to complete this lesson. You will sample color from existing images and use these as templates for your digital painting.
Working with Selections
One of the most basic skills you need in Photoshop is the ability to select areas of an image. Often, you'll want to make adjustments to or fine tune areas of a photograph. The act of editing an image, no matter the desired outcome, is based heavily on your ability to make good pixel selections. In this lesson, you will learn how to use the various selection tools and to use them to create convincing shadows to objects in a composition.
Working with Masks
Masks can hide or reveal parts of a layer. Learn to use masks with images and adjustment layers to advance your image manipulation skills. Learn to use and modify masks to create complex selections around objects with thin strands of hair and clipping masks to add textures to objects.
Working with Vectors
Photoshop is able to create vector shapes and paths, which are used across many Adobe products, so learning these tools can put you ahead of the game when you are learning software such as Adobe Illustrator. This lesson is designed to guide you through the technical tools in a way that is easy to grasp.
Type and Layer Effects
Want to create an invitation or promote an event? This lesson shows you how to apply typography with images to create effective design by utilizing Adobe Fonts, manipulating text using warping, typing on a path, or typing as a mask to place an image within the letterforms. Then, polish the look of your text with layer effects. This lesson will introduce you to a world of limitless type effects.
Preparing Files for Output
Understanding what file formats to use and when can be confusing. This final lesson covers file types and when to use them. Learn how to prepare files for both print and web output. You will also learn how to create a Behance portfolio page to showcase and promote your work!
What you will learn
Master the fundamentals of Photoshop's interface and tools
Understand the essentials of digital imaging including file formats, color modes, image size, and resolution.
Comprehend and apply digital color theory and practice colorization and digital painting
Identify and apply the methods of photo retouch and restoration
Use the functionality of Photoshop's layers, selections, and masking features
How you will benefit
Discover everything you need to confidently use the tools in Photoshop to restore, retouch, and rearrange images
Develop the skills you need to begin a new hobby or entry-level career using Photoshop
Learn to effectively retouch photos and develop professional quality images for your home or business
Harness the power of Photoshop to create stunning images by enhancing photographs and developing works of art
Beverly Richards Schulz
Beverly Richards Schulz is an award-winning photographer and graduate of the New York Institute of Photography. She holds a Bachelor of Arts in Legal Studies from UC Berkeley and a master's degree in Adult and Continuing Education. For the past 10 years, Schulz has taught at the University of San Francisco. With more than 15 years teaching experience, she has written over 30 digital photography and digital editing courses. She co-authored the book "Photoshop Elements 14—What's New?"
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn to use QuickBooks Online to record income and expenses; enter checks and credit card payments; track your payables, inventory, and receivables; and much more.
This QuickBooks course will teach you how to manage your business finances with QuickBooks Online. This powerful accounting software has helped millions of small business owners oversee their finances. Now that the cloud-based version is outpacing the desktop version, there's no better time to refresh your QuickBooks knowledge.
You will learn to use key features of QuickBooks Online and gain hands-on experience creating invoices, receipts, and statements; track payables, inventory, and receivables; generating reports; and more. Whether you're new to QuickBooks or need a quick refresher, this course will empower you to take control of your business's financial accounting, all with the ease and convenience of an online platform.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC or Mac.
Software Requirements:
PC: Windows 10 or later.
Mac: macOS 10.11 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
When your course starts, you will be directed to access and utilize the free QuickBooks Online practice site to complete the lesson and assignment steps. You do not need to purchase a subscription or additional software to complete this course. However, please note that this course is suitable only for the QuickBooks Online version. The desktop versions of QuickBooks are not compatible with this course and should not be used. If you have the desktop version, you should consider registering for the course specifically designed for your version.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Manage the financial aspects of your small business quickly and efficiently using QuickBooks Online. This course will give you hands-on experience recording income and expenses; entering checks and credit card payments; tracking your payables, inventory, and receivables; and much more.
Getting Started
Your first lesson will introduce the QuickBooks Online interface and the pros and cons of working with your accounting information online. You will learn about the various subscription packages and practice using some of the interactive navigation features within the program.
Accounting Basics
To truly unlock the power of QuickBooks Online, it's helpful to have some basic accounting knowledge under your belt. In this lesson, you'll learn some introductory accounting terminology. In addition, you'll learn the basics of double entry accounting principles as well as the components of the Financial Statement.
The Chart of Accounts
The Chart of Accounts is the heart and soul of QuickBooks. In this lesson, you will 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
This lesson introduces best practices for using centers and lists in QuickBooks to gather and organize information needed to properly conduct business. You will also learn how to process Form 1099 to give to your vendors at the end of the year.
Bank Accounts
In this lesson, you will learn how to work with bank accounts in QuickBooks Online. You will learn how to create a new bank account, connect it online, and download, match, and add transactions. Then you will 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
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 will learn how to utilize QuickBooks' built-in features to enter check transactions and bank transfers like a pro.
Paying Bills
Without an organized system for managing all the bills your business receives, they can really start to stack up. When bills pile up, it becomes easy to start missing payment deadlines, which can result in late fees and credit difficulties. In this lesson, 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.
Credit Cards and Loans
In this lesson, you will learn how to effectively manage Credit Card accounts in QuickBooks Online. You will also learn how to enter a full or partial payment of the credit card balance when it comes time for payment. Finally, you will 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
You will find this lesson useful if your business ever sells a product or service and collects payment on the sale immediately. Then you will learn how to create multiple Sales Receipts and make the necessary deposit to your bank.
Invoices and Estimates
In order to evaluate just how well your company is performing, you will need to learn how to enter estimates, invoices, and customer payments. You will do just that in this lesson. You will also learn how to group multiple customer payments and record those deposits to the bank.
Billable Expenses and Customer Credits
This lesson focuses on billing customers for an expense incurred on a project or job. You will even see how you can add a markup percentage to the amount you include on the customer invoice. Also, you will examine the steps needed to enter credit memos, delayed credits, and refunds.
Sales Taxes and Reports
In your final lesson, you will learn how to work with the sales tax features in the program to collect and remit taxes you collect from customers. You will also find out how to create, use, and customize a wide variety of useful reports.
What you will learn
Learn everything you need to know about running QuickBooks in a small to mid-sized business
Discover how to set up a chart of accounts, reconcile your checking account, and create estimates
Learn to create and print invoices, receipts and statements
Understand how to track payables, inventory, and receivables
Gain the knowledge you need to generate reports
How you will benefit
Get access to Intuit's Test Drive Sample Company practice site of QuickBooks Online Plus
Get hands-on experience as you master the tools you will need to successfully use QuickBooks online
Gain the confidence to take control of the financial accounting for your business
Scott Paxton
Scott Paxton is a Certified Public Accountant and holds master's degrees in business administration and accounting. His background includes experience as a public accountant, a manager in the banking industry, an entrepreneur and a college business instructor. Paxton has also spent much of his career helping small business owners successfully implement and troubleshoot QuickBooks.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn the key concepts of SQL (Structured Query Language) the powerful and standard database management query language for relational databases.
Learn the key concepts of SQL (Structured Query Language) the powerful and standard database management query language for relational databases.
SQL (Structured Query Language) is one of the best programming languages for beginning web developers to learn. This course will teach you the basics of designing and writing SQL queries to execute on a practice database. Using a SQL Server Express, you'll learn several real-world applications for SQL so you can put this valuable skill set on your resume.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. Macs are not compatible.
Dual monitors are helpful but are not required.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
Software must be installed and fully operational before the course begins. Student will install the required software in the course.
Other:
Email capabilities and access to a personal email account.
Necessary rights (local administrative rights) to install programs on the computer.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
SQL Server Express
SQL Server Management Studio
Gain a solid working knowledge of the most powerful and widely used database programming language. This course will provide you the skills to write SQL queries to create tables, retrieve data from single or multiple tables, manipulate data in a database, and gather statistics from data stored in a database.
Introduction to Database Design and SQL
In this introductory lesson, you will examine database terms and concepts. Understanding the purpose of a database is foundational to writing efficient SQL queries that retrieve the right data.
SQL Server
In this lesson, you will install SQL Server Express and the SQL Server Management Studio to use throughout the course in your learn-by-doing practices. You will use SQL code to create one of the tables for the practice database in SQL Server.
Retrieving Data Result-Sets
SQL queries are the statements used to retrieve data from the database. Queries are written in a specific, logical order. In this lesson, you will explore various ways to write SQL queries to retrieve data that meet defined criteria.
Sorting Data
SQL queries are defined and written to retrieve data in a certain order. Queries are also written to limit columns and to filter data rows. In this lesson, you will practice writing queries that meet defined criteria and retrieve the expected result-sets.
Designing SQL Data Tables
This lesson is about designing SQL data tables for a database. You will explore the relationship concept and how it is used in an RDBMS. You will define tables that are structured according to RDBMS standards. You will also create the tables to add to your practice database.
Designing Data Rows
In this lesson, you will add data to your newly defined tables. You will explore several methods of adding data to a table and practice writing and executing these query statements. After adding several individual rows to the tables, you will use a SQL query to populate your tables with enough data rows to use in the learn-by-doing practices in this course.
Getting Data From Two Tables
SQL JOIN statements are used to retrieve data from more than one table. In this lesson, you will practice writing JOIN statements that retrieve data from tables that have a relationship between their PKs and FKs.
Retrieving Data From Multiple Tables
In this lesson, you will continue writing JOIN statements that retrieve data result-sets from more than one table. You will also examine how and when to use SQL subquery statements to retrieve data from multiple tables. You will practice defining and writing JOIN and subquery queries.
Keeping the Database Up to Date
The quality of the data in the database depends on its integrity, including the concepts of data accuracy and consistency. In this lesson, you will explore writing queries to maintain the database so that it is up to date with data that is accurate, consistent, and has integrity.
Aggregate Functions
In this lesson, you will examine the concept of aggregate functions and how they are used in query statements to examine multiple rows. Aggregate functions are a method of retrieving summarized data that is useful for analysis.
SQL Views
SQL views are an important concept in database design and in using databases. In this lesson, you will explore designing and writing queries to create views. You will also explore the reason they are valuable for database security and database access.
Maximize Database Integrity and Performance
Constraints are one way to maximize the integrity of the database and minimize the opportunity for user error. Indexes are used for increasing the performance of a data query. In this lesson, you will explore both these concepts.
What you will learn
Use SQL to develop a relational database
Design table and row structures that fulfill your requirements
Write efficient SQL queries to find and organize data
Write SQL queries to retrieve data from multiple tables
Create updates for a secure, high-performance database
How you will benefit
Gain confidence in your SQL ability, the standard database query language
Open the door to opportunities as you list basic SQL programming as a skill on your resume
Develop a new skill and learn whether or not you would like a career in IT
Mava Wilson
Mava Wilson, Ph.D., is a professor with more than 28 years of teaching experience. While she specializes in Information Systems (IS), she has taught several computer science topics, including basic computer literacy, programming, database design, and SQL. She holds a Ph.D. and master's degree in computing technology from Nova Southeastern University, as well as a bachelor's in administrative systems from Radford University.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
In this course, you will learn to use Windows 11, a powerful new operating system, including customizing your desktop, managing files and folders, and navigating the web with the latest Microsoft Edge browser.
File Explorer can help you manage your files and create text documents using WordPad. From managing files and editing photos to working with external drives, you will learn everything you need to know about getting the most from this operating system. Additionally, since security is essential, you will also learn how to protect your files and protect and update Windows 11.
By the time you finish this course, you will have mastered the basic skills you need to get the most from Windows 11 for both work and play.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC or Chromebook. Macs are not compatible.
Software Requirements:
PC: Windows 11 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Master the basic skills you need for Windows 11, the new operating system from Microsoft, which offers a more robust, more powerful, and unique computing experience. In this course, you will gain the foundation you need to start using Windows 11.
Welcome to Windows 11
Learning to use your PC well starts with learning to use Windows. In this first lesson, we'll start with the basics that every computer user must know in order to use a computer with minimal frustration. If you've been working in "frustration and aggravation" mode for a while, this lesson will take care of that. We'll start by talking about what Windows 11 is and why you want to learn it. Then, we'll get right into the most important skills and terminology that allow you to control what you see on your screen at all times. And that's important, because the first step to using anything that's in your computer is getting it on the screen where you can see it!
Use the Start Menu and Apps
In this lesson, we'll explore the revised Start Menu and Apps in Windows 11. You'll see how to use and customize the Start Menu, and we'll explore the Windows Store. You'll also see how to use the new widgets feature of Windows 11, which gives you access to quick and easy information, such as weather, traffic, sports, and news.
Personalizing Your Windows Desktop
In today's lesson, you'll have fun personalizing your computer by choosing your own desktop pictures, themes, and sound scheme. Along the way, you'll learn about the important Control Panel window in Windows 11 and tips for using dialog boxes and those occasional mysterious dimmed options that do nothing when you click them. The skills you learn in this lesson will go a long way to helping you gain complete control of your computer.
Working With Text and Files
No matter how you intend to use your computer, there'll be times when there's some typing involved. It might be for writing email messages, memos, or letters, or it might be for taking notes in a course, or for chatting with others in a website. Whatever the reason, today's lesson will teach you all the tricks for making typing (and editing) quick and easy. And you'll also discover how to save your work in files and folders, so it'll always be there when you need it!
Exploring Your System
Everything that's in your computer is stored on its hard drive. The hard drive is like a filing cabinet containing files organized into folders. Finding things you've saved in the past is a matter of opening the filing cabinet, so to speak, and then locating the correct folder. You'll use the File Explorer program to accomplish this. And in this lesson, you'll learn how it all works, so you can start gaining complete mastery of your own files and folders.
Using OneDrive, Microsoft Teams, and Microsoft To Do
In this lesson, you'll explore three Windows 11 features: OneDrive, Teams, and To Do. OneDrive is a cloud storage solution that lets you store files and folders both on your PC as well as the Microsoft cloud. Using OneDrive, you can save your data to Microsoft servers and access that data across multiple devices. Teams is communication software that is built into Windows 11. Using Teams, you can chat with friends, family, and co-workers and even host video and audio calls. Finally, you'll take a look at Microsoft To Do—an app that helps you keep track of to do tasks and lists. All of these features are designed to make your life easier!
Manage and Edit Your Photos
In this lesson, we'll have some fun with photos. Today, you'll learn how to organize your photos and view them using Windows 11's Photos App. You'll also see how to view individual photos, draw and rotate, and auto-enhance your shots. And, you'll learn about the Photos App editing tools for adjusting brightness and contrast, straightening crooked pictures, correcting red eye, and cropping.
Using Edge
The Internet is home to popular websites like Facebook, Amazon, Google, ed2go, and many others. Many of you have seen references to .com sites in ads and elsewhere. If you don't have a lot of computer experience, you might find it difficult to get to the many things you hear about on the web. But not after this lesson! In this lesson, you'll learn how to use Edge, the program that provides access to all of those popular websites.
Managing Files and Folders
Managing files and folders is one of those computer skills that every computer user needs to know. In many work and school environments, people just assume you know how to manage files, and they rarely provide any details on how to accomplish things like copying, moving, or renaming files and folders. Today's lesson will explain how to do those very things that others assume you already know how to do.
More Fun With File Management
In this lesson, you'll expand your file management skills by learning how to delete and recover files. You'll learn how to select multiple files to work with, so you don't always have to manage your files one at a time. And we'll discuss how to copy files to and from removable media like flash drives, CDs, and DVDs.
Protect Your Valuable Files!
Your computer is an investment of money, and the pictures and other files you store on your computer are an investment of time. You might even have some photos or other files that are so precious the thought of losing them causes you anxiety. What you need to do is protect those files. And that's just what this chapter is all about—how to use the tools and techniques that are built right into Windows to help you protect your valuable time and files!
Tips, Tricks, and Shortcuts
In our final lesson, you'll learn some more techniques for protecting your computer, including using resources for free protection from viruses and spyware. You'll learn how to remove programs you no longer want or need. You'll learn how to copy and paste text and create screenshots. And you'll discover some great timesaving tips and shortcuts, as well as resources for helping yourself so that you don't have to be so dependent on others.
What you will learn
Find your way around Windows 11 with the desktop, Start menu, and system settings
Understand how to customize features and personalize your desktop
Discover how File Explorer can help you manage files and learn to create basic text documents using WordPad
Comprehend how to protect your files and update Windows 11
How you will benefit
Gain confidence in your use of the Windows 11 operating system for personal and business use
Learn how to use your PC effectively, starting with Windows
Experience reduced frustration and setbacks by learning to operate your computer properly
Become a more independent computer user
Curt Simmons
Curt Simmons, B.A., M.Ed, is a best-selling author, trainer, and multi-media expert. He holds degrees in English and communication studies and has more than 10 years of experience teaching English and writing in the classroom. Additionally, Simmons has authored numerous books on a wide variety of technology topics and has been a technical editor for numerous other titles.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn how to touch-type or improve your existing typing skills using Keyboarding Pro 5.
If you want to learn touch-typing or improve your existing typing skills, this is the perfect course for you! In these lessons, you'll use the Keyboarding Pro 5 program, a typing tutorial designed for personal computers, to learn how to touch-type—that is, to type text you read from a printed page or a computer screen without looking at your keyboard.
With the skills you master here, you'll become faster and more confident at the keyboard. By the end of the course, you'll know how to touch-type the alphabetic, numeric, and symbol keys; create, save, and edit word processing documents; and successfully take a timed writing test during a job interview.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. Mac, Chromebooks, Surface, and all other tablets are not compatible.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
When the class starts, you'll receive instructions for downloading and installing a working copy of Keyboarding Pro 5. Please do not purchase or download the software from another source.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Become faster and more confident at the keyboard. This course will help you learn how to touch-type the alphabetic, numeric, and symbol keys; create, save, and edit word processing documents; and successfully take a timed writing test during a job interview.
Getting Started With Key Pro 5
Your first lesson guides you step by step as you download, install, and set up Key Pro 5. You will also get acquainted with the program, learning about the home row keys and the reach to the "i" key on the QWERTY keyboard. Are you confused about what home row and QWERTY mean? Don't worry—this lesson explains all of that.
Lowercase Letters, Plus the Reaches to the "e" and the "n"
Now that you're getting comfortable with the home row on the QWERTY keyboard, it's time to introduce you to some new keys. This lesson will focus on lowercase letters. You will also use Key Pro 5 to practice the reaches to the e and the n. Is all this typing causing you aches and pains? You will find out how to reduce fatigue while typing.
The Left Shift, h, t, and Period Reaches
In this lesson, you will learn four new keystrokes: left SHIFT, h, t, and period (.). You will also provide some tips on improving speed and accuracy and introduce you to the Key Pro 5 word processor program.
Learn the r, Right SHIFT, c, and o Reaches
Continue to build your keyboarding vocabulary by learning four new key reaches in this lesson: r, right SHIFT, c, and o. You will also learn about "the Zen of typing", which is how touch-typing becomes an instinctive and unconscious action.
The w, Comma, b, and p Reaches
Your typing vocabulary continues to expand rapidly with the addition of the reaches to the w, comma, b, and p. Before you know it, you will be typing complete paragraphs. This lesson also covers what you need to know about carpal tunnel syndrome, a serious and painful condition that you can avoid.
The g, Question Mark, x, and u Reaches
Expand your typing vocabulary by mastering four more key reaches: the g, question mark (?), x, and u. Just a few more reaches, and you will know how to type the whole alphabet. In this lesson, you will also learn about the function (FN) key and the numbers lock (NUM LOCK) key, which are on most laptop keyboards.
The q, m, v, and Apostrophe Reaches
This lesson teaches you another four reaches for your typing vocabulary: q, m, v, and apostrophe ('). You will also learn how to save a document with a word processing program.
The z, y, Quotation Mark, and Tab Reaches
It's time to add another four reaches to your typing vocabulary: the z, y, quotation mark ("), and tab keys. After this lesson, you will know the reaches to all the alphabetic keys. You will also find out how to open, edit, and resave word processing documents.
Alphabetic Key Review, the 1 and 8 Number Reaches, and Timed Writings
Are you ready to improve your skills and learn some new ones? After you review the z, y, x, q, v, quotation mark, and CAPS LOCK keys, you will learn the reaches to the numbers 1 and 8. Then you will take timed writings in the Key Pro 5 word processor.
Number Reaches, Deleting Text, and Alphabetic Key Review
What's the difference between the DELETE key, the BACKSPACE key, and the Cut command? By the end of this lesson, you will understand how and when to use these three editing tools. You will also continue to improve your skills with the alphabetic keys, plus you will learn more number reaches: 5, 0, 2, and 7.
Number and Symbol Reaches, Number Rules, and Key Review
When should you spell out numbers (like this: one, nine, five hundred), and when should you write them as figures (1, 9, 500)? You will also continue to improve your skills with the keys you have already learned, and you will finish the number reaches by mastering 4, 9, 3, and 6. Then you will learn two symbol reaches: the dollar sign ($) and the hyphen (-).
Symbol Reaches and Skill Building
You have already mastered some of the symbols and punctuation marks. In your last lesson together, you will meet the rest of the symbols. You will also work on your accuracy and speed with the Key Pro 5 Skill Building lessons. And you will find out how you can continue to hone your keyboarding skills long after you have finished this course.
What you will learn
Learn how to create, edit, and save word processing documents
Improve your typing speed and accuracy
Learn posture tips to minimize fatigue and help prevent carpal tunnel syndrome
How you will benefit
Successfully take a timed writing test during a job interview
Become more confident in your ability to type quickly and accurately
Kathy Van Pelt
Kathy Van Pelt has taught computer courses at a community college for the past 25 years. She specializes in Microsoft Office applications, Google Drive and Google Applications, the Windows and Mac operating systems, and keyboarding. She spent seven years teaching word processing and business classes at a private business college and loves being in the ever-evolving educational field.
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Master advanced features and functions of Microsoft Excel 2016, including data analysis tools, data tables and databases, PivotTables, custom controls, importing external data, and conditional formatting.
Wouldn't it be great to learn how to effectively use all the advanced Excel features? In this practical and information-packed Microsoft Excel training, you'll see how to truly maximize this program's functions and capabilities. After all, most organizations rely heavily on Excel to consolidate, analyze, and report data and want their employees to be proficient in this important program. This Excel training class gives you the skills you need to impress your current or future employer—and its online format means you can take this class from anywhere, at any time.
With exercises, quizzes, expert instructors, and all the latest information, the best online Excel training is right here at ed2go. We'll simplify some of those tricky Excel concepts that might seem hard to grasp, so you can discover how Excel 2016 table tools actually take the complexity out of spreadsheet creation and management. When you've completed this course, you'll be able to accomplish just about everything Microsoft Excel has to offer in displaying, analyzing, reporting, and tracking data—and you'll understand it so well, you'll even be able to share your newfound skills with your friends and colleagues.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Microsoft Office Home and Student 2016 (not included in enrollment).
Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Master advanced features and functions of Microsoft Excel 2016, including data analysis tools, data tables and databases, PivotTables, custom controls, importing external data, and conditional formatting.
Customizing Excel
Table Management
Data Validation
Custom Controls
Conditional Formatting
Consolidating and Outlining
Excel Functions and Nesting
Import External Data
Data Tables
What-If Analysis Tools
Advanced PivotTables
Analysis ToolPak, Advanced Filter, Array Formulas, and More!
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
This self-paced course will teach you the basics of working with color in web design.
Color plays an important role in visual communication, especially when designing websites. For web designers, understanding color theory is a key to creating a color palette for UI/UX projects. This self-paced course will teach you the fundamentals of color theory and how to apply this framework to your web design practice.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC or Mac.
Software Requirements:
PC: Windows 10 or later.
Mac: macOS 11.0 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Recommended: Though they are not strictly required, you will get the most out of this course if you have Adobe Photoshop and/or Adobe Illustrator installed on your computer. These tools are not included with the course.
Adobe Photoshop (not included in enrollment)
Adobe Illustrator (not included in enrollment)
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Learn the rules for working with color in UI design projects.
Terminology
Color Wheel
Explore a Live Color Wheel
Saturation, Hues and Shades
Exploring Shades and Tints Using Adobe Illustrator
Value of the Hue
Explore a Color Using Photoshop
Color Scheme
Building an Efficient Color Theme
Triadic Colors
Complementary Colors
Split Colors
Analogous Colors
Color Moods
Work with Client Color Plans
Medium Types
Color Theory Principles
Complementary Colors
Contrasting
Vibrancy
Monochromatic
Work with Color Principles
Color Context
Mode RGB/CMYK
Print or Screen
Audience Type
Choose Colors for Different Audience Types
Scope of Project
Implementing Color
Create Color Palette
Mechanics of a Color Scheme
Whitespace
Creating an Electronic Color Scheme
What you will learn
About the traditional color wheel and explore color in Adobe Illustrator
About relationships between colors and how to create a color "feel"
Basic color theory principles
About considerations for print and web
To create a color palette for your project
How you will benefit
Master the basics of color theory in a completely online environment
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Gain a working knowledge of the computer skills you will need to succeed in today's job market.
Most jobs today require a working knowledge of certain computer skills. Employers seek and reward employees who can effectively send emails, create spreadsheets, manage databases, understand memory and network limitations, and recognize the function and features of modern computer components. Any job candidate who already possesses these skills will stand above those who do not.
This course is designed to provide the fundamental computer competencies you need to survive and prosper in today's fast-changing workplace. You will learn how to implement the powers of modern office software to work faster and more efficiently. This course will also focus on practical applications for software most common to the workplace. By the time you finish, you will have learned why employers consider technological literacy so critical to the success of any organization.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. Macs are not compatible.
Software Requirements:
PC: Windows 10 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
Any edition of Microsoft Office with desktop apps: Excel, Word, Outlook, PowerPoint, and Access.(not included in enrollment).
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Confidently apply for jobs knowing that you possess the computer skills needed to perform on the job. This course includes a great introduction to Windows 10 and Office 365 to provide the fundamental computer competencies you need to prosper in a modern workplace.
Lesson 1: 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.
Lesson 2: Outlook: Email and Scheduling
Your computer has a software program installed on it that's referred to as an "operating system." Most often, this system is Microsoft Windows, but it could be others, such as macOS or Linux. In this lesson, you'll learn how this system controls many important parts of the computer and how you use those controls every day for tasks like managing where you keep important files, and printing hard copies of documents. We'll also talk about menus, taskbars, and shortcuts along the way.
Lesson 3: Word: Creating and Formatting Documents
Next to email, the word processor is probably the most frequently used application software in the workplace. Yet, if you've never taken the time to learn the basic features of most word processors, you're not performing nearly to your potential. In today's lesson, you'll learn and practice the important capabilities of word processors like Microsoft Word.
Lesson 4: 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.
Lesson 5: 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.
Lesson 6: 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.
Lesson 7: 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.
Lesson 8: PowerPoint: Creating and Editing a Presentation
PowerPoint is an important tool for creating presentations suitable for the work environment. This powerful program has many features, but they must be used correctly or else your audience will be distracted or overloaded. In this lesson, we'll explore the best ways to create an effective presentation that incorporates the right mix of multimedia. You'll learn how to insert graphics and audio into your presentation in an effective and organized manner.
Lesson 9: Integrating Microsoft Office Programs
The suite of Microsoft Office products includes Excel and Access, which are both very powerful on their own. In this lesson, you are going to learn how to actually integrate information from one program to the other. You can create data lists with either program and easily transfer the information to the other. Considering all the work we do with lists on the computer, this is a very important skill in today's work environment. Plus, you'll find out how mail merge can save you time and effort by allowing you to customize letters, labels, and more!
Lesson 10: Using the Internet
In today's lesson, we're going to have fun working with the Internet. This is the greatest source of information you'll ever have access to—yet it can be confusing and overwhelming if you are not familiar with the basic Internet tools. You'll really enjoy seeing how easy it is to find information that specifically meets your needs and interests.
Lesson 11: Transferring and Protecting Data
Today, we'll go over various methods for transferring information from one computer to another. We'll explore different terms used to describe the volume of information—or size of a file—and then learn how to most effectively and efficiently move that data from place to place. You'll learn about bytes, megabytes, memory sticks, and external hard drives.
Lesson 12: Putting Your Skills to Work
In our final lesson, we will focus on putting all your new knowledge to work! We have three specific goals. The first is to identify ways to use your computer skills to find a new job. The second is to use those same computer skills to get a promotion within your current organization. Our third goal is to explore strategies for continued learning in order to support your ever-growing employment goals.
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
This course will give you the knowledge to help you decide whether a career in cybersecurity is right for you. This course is designed to explore the basics of cybersecurity and the types of jobs found in the cybersecurity field.
This course explores a career in cybersecurity and reviews various topics, including cybersecurity roles, job requirements, problem-solving techniques, and cybersecurity concepts. This course will help you decide whether a career in cybersecurity is something that aligns with your talents and interests and, if so, the best next steps to pursue this lucrative career path.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC, Mac, or Chromebook.
Software Requirements:
PC: Windows 10 or later.
Mac: macOS 10.6 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
There are no instructional material requirements to take this course.
Getting into cybersecurity can be rewarding and lucrative! In fact, according to the U.S. Bureau of Labor Statistics, information security analysts can make over $100,000 per year. This course will give you the knowledge to help you decide whether a career in cybersecurity is right for you.
The course will start by introducing the basics of cybersecurity. You will learn the types of threats companies face daily and how a cybersecurity specialist can help prepare for and prevent those threats. Finally, the course will cover cybersecurity learning paths and different types of cybersecurity jobs and salaries.
Introduction to Cybersecurity
Cybersecurity Roles and Industries
Problem Solving
Cybersecurity Basics
Types of Information Security
Common Concepts and Terminology
Types of Threats
Secure Coding
Protecting the Business
Developing a Security Awareness Program
Employment and the Future of Cybersecurity
Next Steps
What you will learn
Explore cybersecurity as a career path
Identify cybersecurity job roles and industries
Describe the soft skills that cybersecurity professionals need
Explain the threats that cyberattacks pose to modern businesses
Explain the importance of securing information
Define common cybersecurity terms and concepts
Explain the role of secure coding in preventing cyberattacks
Identify the ways that cybersecurity professionals protect a business
Describe the key elements of a security awareness program
Identify employment opportunities and career steps in the cybersecurity field
How you will benefit
Learn if a career in cybersecurity is right for you
Explore the basics of the cybersecurity industry
Discover potential career paths in the cybersecurity field
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Take your Microsoft Excel 2016 skills to the next level as you master charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Excel functions.
In this hands-on course, you will learn how to create informative, eye-catching charts and graphs, and harness the power of Excel's data analysis tools and AutoFilter commands. In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other time-saving functions to your repertoire.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Microsoft Office Home and Student 2016 (not included in enrollment).
Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Take your Microsoft Excel 2016 skills to the next level as you master charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Excel functions.
Excel Charts and Graphs
In your first lesson, you will discover why Excel 2016 is such a powerful charting tool. To you, a workbook's numbers might tell an interesting story; to others, that story may not be obvious. You will learn how to choose the right chart for your story and then how to create, format, and edit your chart.
More Excel Charts
This lesson continues exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they may not be well-known, these options can add tremendous value to your worksheets in the right situations.
AutoFilter and Sorting
Working with data in Excel can be quite easy when you know about the tools that are available in a table format. One of these great tools is the Auto Filter command. This lesson will teach you how to use Auto Filter to limit your table information to just the records you want.
Goal Seeking
If you know what formulas you want but don't know how to get there, Excel's Goal Seek is exactly what you need. In this lesson, you will learn how to utilize this tool to avoid the trial-and-error approach that most Excel users go through to get to the right answer.
PivotTables
This lesson will teach you how to use one of the best features of Excel: the PivotTable. There's no greater "what-if" analysis tool to summarize, reorganize, and report data.
Advanced PivotTables
Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. This lesson takes a tour through some of Excel's more advanced techniques, like the PivotTable filtering tool Slicer. You will also learn how a PivotTable can serve as your source for the PivotChart.
Solver
Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you will learn how to use Solver to solve a complex problem based on criteria and constraints.
Sparklines
There's nothing more exciting than learning how to master a new feature in Excel. This lesson focuses on creating three types of Sparklines, as well as formatting options for each. By the end of the lesson, you will have the skills to create dashboard-style mini charts.
Macros
In this lesson, you will find out how to use macros to turn repetitive and often time-consuming tasks into automated Excel functions. You will also learn how to record a macro that performs time-consuming task in seconds with the click of a button.
Introduction to Functions
If you have used Excel for a while, you know there are hundreds of functions at your disposal. The last three lessons of this course will cover how and why you would use these functions. This lesson introduces creating various functions with the Text category.
Math/Trig Functions
Next to learning how to create macros, most students want to learn as much as they can about Excel functions. This lesson covers on more complex functions of the "Math & Trig" category, focusing on the SUMIF and COUNTIF functions in particular.
VLOOKUP, INDEX, and MATCH Functions
Since functions are such an integral part of using Excel, your final lesson will cover advanced features. In this lesson, you will learn how to use the VLOOKUP, INDEX, and MATCH functions.
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Learn how to use the more advanced features of Microsoft Word 2016 (now available through Office 365) including how to add graphics, use templates, and merge data.
Go beyond the basics of word processing and master the more advanced features of Microsoft Word 2016 (now available through Office 365). In this course, you'll learn how to automate Word 2016 using shortcuts to help you write more while typing less. From signs, newsletters, and greeting cards to long documents, you'll learn how to create whatever you need—quickly and with professional-looking results.
You'll also learn how to create and organize text in tables, mix graphics and text together to turn Word into a simple desktop publishing program, and merge spreadsheet and database data to create mailing labels and form letters. Along the way, you'll go through lots of examples and exercises so you can see how Word's advanced features work; but more importantly, you'll see how you can use these advanced features at home and on the job. By the end of this course, you'll know how to use Word more effectively and take advantage of all its many features so you can get your work done more quickly and more easily than you ever thought possible.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Learn how to use the more advanced features of Microsoft Word 2016 (now available through Office 365) including how to add graphics, use templates, and merge data.
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
This introductory course is for those with little to no cybersecurity experience that want to learn more about this growing industry.
This self-paced course is designed to help you increase your knowledge of cybersecurity and technology fundamentals to fill knowledge gaps in your current role or pursue an entry-level career in this in-demand field. We answer questions around what cybersecurity is, what an operating system does and the most common types, cloud computing, and many other topics related to cybersecurity foundations.
You will have the opportunity to develop your foundational cybersecurity skills through hands-on demonstrations as you follow along with the instructor videos, learn time-saving tips to increase your efficiency, and establish best practices.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC, Mac, or Chromebook.
Software Requirements:
PC: Windows 8 or later.
Mac: macOS 10.6 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
This course gives you the option of following along with the instructor on a few video-based exercises, allowing you to pause and replay until you are confident in your skillset. Should you wish to follow along, it is recommended that you have the following: Windows 10 environment, Wireshark, an AWS account (free tier), and a Windows 2016 VM (available in the AWS free tier).
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
The need for skilled cybersecurity professionals continues to grow year over year, making it a great time to enter this in-demand industry.
In this video-based learning course, you will learn fundamentals of cybersecurity such as concepts, commands, and tools from an experienced professional through lectures and follow-along demonstrations. You will also learn about cloud computing, networking, cybersecurity policy, and frameworks, as well as risk management and security auditing in a 100% online, self-paced training format.
By the completion of your course, you will have a firm understanding of cybersecurity foundations, including key concepts and best practices.
Cybersecurity Foundations
Operating Systems
Windows Command Line Foundations
Network Fundamentals
Cloud Computing Fundamentals
Cybersecurity Policy, Framework, and Guidelines
Cybersecurity Audit Foundations
Risk Management
Penetration Testing - Demonstration
What you will learn
Understand what cybersecurity entails
Identify the three most common operating systems
Execute simple commands
Learn about cloud computing and networking
Learn about cybersecurity policies, frameworks, audits, and risk management
How you will benefit
Learn if a career in cybersecurity could be right for you
Increase your baseline knowledge of foundational cybersecurity concepts
Learn tips and tricks from a working cybersecurity professional
Follow along with hands-on demonstrations to develop and practice your foundational skills
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Learn how to make the most of your scrapbooking talents and artistic ideas when you combine digital and traditional scrapbooking techniques.
Learn to use digital editing techniques to show off your photos and memorabilia in Introduction to Digital Scrapbooking! Using Photoshop Elements 11, 12, or 13, this course will teach you how to make the most of your scrapbooking talents and artistic ideas when you combine traditional and digital scrapbooking.
Starting with simple projects, you'll quickly learn how to build pages, use artistic journaling, and produce sophisticated illusions. Photoshop Elements lets you build your own clip art, create frames, and develop multi-layer pages with an endless array of layouts and designs. You'll see how to draw and create your own art, build collages and scrapbooks to share, and work with both color and black and white. If you need to restore or age images—the tools are all available to you. Come take your scrapbooking to a new level!
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC or Mac.
This course is written using the Windows version of the software. If you have Mac, you will need to make standard Windows/Mac keystroke conversions which are included in the course material.
Software Requirements:
PC: Windows 8 or later.
Mac: macOS 10.6 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
Adobe Photoshop Elements 11 or higher (not included in enrollment). Instructions, screenshots, and examples are based on versions 11, 12, and 13, but later versions, including year-numbered versions like Photoshop Elements 2020, work well with only minor changes for the course.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Make the most of your scrapbooking talents to show off your photos and memorabilia with digital scrapbooking. This course provides hands-on experience building scrapbook pages, using artistic journaling, and producing your own artwork with Photoshop Elements.
What Is Digital Scrapbooking?
Digital editing gives scrapbooking a new level of creativity! In the first lesson, you'll have an opportunity to become familiar with the online classroom, Photoshop Elements 11 (the digital editing software you'll be using in this course), and a number of ways to integrate digital options with traditional scrapbooking. You'll see how to keep your personal style intact while taking advantage of fun and easy techniques to enhance your scrapbooks.
Journaling
In this lesson, you'll have an opportunity to experiment with and explore the many options for enhancing text. You'll see how to add color, shape, and styles, along with more advanced techniques like warping text to fit on objects, making circles with words, and transforming images into text. Journaling is an important part of the storytelling process, so it's time to put the words to work!
Layering
Whether you're working with scissors and glue or digital images, one of the ways to embellish scrapbook pages is to layer artistic elements. In this, you'll explore Adobe's layers so you can master the ability to build pages with many different pieces to create the look that tells your story best! The lesson will discuss sizing, background images, frames, and piecing together pages with multiple images, text, and clip art.
Clip Art
Now that you're comfortable with backgrounds, cropping, text, and layers, it's time to add some pizzazz to your pages! In this lesson, you'll see how to create and use clip art to add personal touches and dimension to your scrapbook. You may be surprised at how many important details you have in your pictures, and with Photoshop Elements, you'll be able to pick those out and use them just where you want them. Creating clip art is fun and easy with the tools in Elements. You'll be a pro by the time you finish this lesson!
Themed Layouts
Continuity and strong story lines captivate readers—even in scrapbooks! This lesson focuses on defining themes, using repetitive elements, and sizing enlargements for excellent quality. You'll see how to build two-page layouts, create panoramic images, and use two different techniques for adding frames to your pages.
Beauty of Black and White
Bold and beautiful, black-and-white photography leads to a lesson on how to take a classic look and make it modern, timeless, or even old-fashioned. You'll see how to turn color photos into stunning black-and-white images, or how to keep just a portion in color. You'll also explore using gradients to create black-and-white backgrounds to set off color images.
Creative Illusions
In this lesson, you'll work a little magic as you learn to create special effects to enhance your backgrounds and pages. You'll even be able to create some of these from nothing! The illusion of texture and dimension is important when building a sophisticated scrapbook, and you'll look at ways to build pages that might just make you wonder if they're real. With the Effects panel, the Filter menu, and some new tricks with layers and layer styles, you'll be amazed at what you can do.
Bountiful Brushes
Much like finger painting lets you release your artistic side, Photoshop Elements brushes are full of possibilities for detailed strokes, colors, and patterns—some even paint pictures! You'll see how to use the standard brushes, create and customize your own, and build pages and backgrounds with a variety of styles and patterns.
Digital Nostalgia
In this lesson, you'll see how to turn back the hands of time to create pages using restored images and nostalgic pages. You'll also learn how to age a modern photo to match the look of older ones. With the pattern tools in Photoshop Elements, you'll create fabric-like backgrounds and even see how to add a bit of stitching. Digital editing merges the old and the new in surprising ways!
3D Imagery
Digital scrapbooking gives you lots of options for creating three-dimensional looks, and in this lesson, you'll see how to use new shortcuts to make this quick and easy. With Photoshop Elements Guided Edit and special filters, you'll be able to create reflections, spheres, and many more effects.
Digital Drawing
It's time to draw! You'll be surprised by how creative you can be with Photoshop Elements drawing tools, even if you don't think of yourself as artistic. With the Pencil tool, the Undo option, and the Eraser tool, changes and corrections are easy. You can even remove something and put it back. You'll see how to add line graphics with Wingdings and turn color images into coloring pages, as well as some other drawing techniques you can use to build backgrounds and art for your scrapbook pages.
Bringing It All Together
In the last lesson, you'll explore a couple of automatic options in Photoshop Elements to help you finish your scrapbooks quickly. You'll see how to build an automatic collage page from your images and how to upload them to book formats you can print at home or send out to have professionally printed. You'll finish this course with lots of great ideas to finish your scrapbooks and share them with your family and friends!
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Learn to use the basic features of Word 2016 (now available through Office 365) to type, edit, format, spell check, and print professional-looking documents, letters, and reports.
One of the most basic skills needed in any job is writing reports and letters using Microsoft Word 2016, now available through Office 365. In this course, you will gain the foundational skills you need to make the most of this powerful program.
Through hands-on instructions, you will learn how to add and edit text; move words from one part of your document to another; work on two or more documents simultaneously; and format your text. You will also see how to save, retrieve, copy, organize, and print your documents.
You will learn dozens of ways to modify the appearance and content of your documents by adjusting page margins, paragraph tab settings, and line spacing to create great-looking documents quickly and easily. If you need to type foreign language characters or symbols, you can do that in Word too.
By using Word's spell and grammar checker, you can catch typos and grammatical mistakes before you print or share your document with others. You will also explore the program's thesaurus feature, which can help you find exactly the right word. By the time you're done with the step-by-step lessons and hands-on activities in this course, you will be able to use Word confidently at home or on the job.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Learn to use the basic features of Word 2016 (now available through Office 365) to type, edit, format, spell check, and print professional-looking documents, letters, and reports.
Getting Started
In this introductory lesson, you will learn how to use the different parts of Word 2016's user interface, how to look at your document from different types of views, how to zoom in and out to magnify or shrink your text, and how to change the margins of individual paragraphs.
Typing and Navigation
The whole purpose of Word is to let you create and edit text. This lesson introduces the basics of moving the insertion point and deleting text. By knowing the pros and cons of navigating through a document with the keyboard and mouse, you can use both to help you work faster in Word.
File Management
In this lesson, you will learn how to save the documents you create in Word. You will also learn how to rename, copy, and even delete any files you have created, so you will always be in complete control of all the files you create.
Editing Text
After you've typed some text in a Word document, you may need to edit that text. This lesson focuses on editing text. The easiest way to edit text is to delete it, but a more sophisticated way to edit text is to copy text and paste a duplicate of that text in another location.
Working With Multiple Documents
Most people use Word to view and edit a single document at a time, but Word actually lets you open and view two or more documents at the same time. This lesson will teach you how to open, switch between, and view multiple documents.
Text Formatting and Alignment
Once you know how to add, delete, copy, and move text, the next step to modifying your document is to change the physical appearance of your text. You can make text appear in different colors or background highlighting, change text size and alignment, and even modify fonts.
Printing
Most people use Word to print letters and reports. In this lesson, you will learn about the different ways you can print a document, such as portrait orientation or landscape orientation. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents.
Margins, Tabs, and Page Numbering
By knowing how to set and use margins, you can modify an entire document or just a single page. By using tabs, you can modify how individual paragraphs look on a page. Finally, you will also learn how to add page numbers to the top or bottom of a page to keep track of page order.
Paragraph Formatting
Word provides ways to change the appearance of a paragraph's first line, line spacing within a paragraph, and line spacing between paragraphs. In addition, Word lets you create bullet and number lists, so you can display short bits of information in a visual manner.
Language Tools
For important documents, you may even need to collaborate with others. To keep track of all the changes multiple authors may make to a single document, Word offers a Track Changes feature, so you can see exactly what and who changed the document.
Customizing Word
With Word, you can press different types of keystrokes or search and click the symbol you want to use. This lets you add practically any type of unusual character to your documents. Word lets you type practically anything you want, regardless of the limitation of the keys on your keyboard.
Making a Word Document Pretty and Organized
Finally, you can use outlines to organize your text and quickly move chunks of text within a document just by rearranging an outline heading. By learning these advanced features of Word, you can make each document display text in the most appealing way possible.
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
This MySQL course provides new PHP developers with the prerequisite knowledge necessary to learn to build database-driven websites with PHP and MySQL.
This MySQL course provides new PHP developers with the prerequisite knowledge necessary to learn to build database-driven websites with PHP and MySQL. It does not cover PHP, but it prepares you for learning PHP to integrate with MySQL. Although most of the SQL learned in the course is applicable to all major databases, including SQL Server, Oracle, and PostgreSQL, it focuses on MySQL.
This course starts with the basics of relational databases. You will learn to use simple SELECT queries to pull data, and then move on to more advanced SELECTs and data manipulation. You will shape the results of your queries to create relevant reports. Once you have mastered the basics, you will get hands-on with complex data retrieval methods like subqueries, joins, outer joins, and unions. Finally, you will use INSERT, UPDATE, and DELETE while learning best practices for maintaining your records.
By the end of this MySQL for PHP course, you will know MySQL and SQL well enough to start using it with PHP (and elsewhere).
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC or Mac. Chromebooks are not compatible.
Software Requirements:
PC: Windows 8 or later.
Mac: macOS 10.10 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
In this online course you will learn how to connect MySQL to PHP. You will also learn how to create a MySQL database This MySQL course provides new PHP developers with the prerequisite knowledge necessary to learn to build database-driven websites with PHP and MySQL. This course does not cover PHP, but it prepares you for learning PHP to integrate with MySQL. Although most of the SQL learned in the course is applicable to all major databases, including SQL Server, Oracle, and PostgreSQL, it focuses on MySQL.
Relational Database Basics
Brief History of SQL
Relational Databases
Tables
Rows
Columns
Relationships
Datatypes
Primary Keys
Foreign Keys
Relational Database Management System
Popular Databases
Commercial Databases
Popular Open Source Databases
SQL Statements
Database Manipulation Language (DML)
Database Definition Language (DDL)
Database Control Language (DCL)
Simple SELECTs
Introduction to the Northwind Database
Some Basics
Comments
Whitespace and Semi-colons
Case Sensitivity
SELECTing All Columns in All Rows
Exercise: Exploring the Tables
SELECTing Specific Columns
Exercise: SELECTing Specific Columns
Sorting Records
Sorting by a Single Column
Sorting By Multiple Columns
Ascending and Descending Sorts
Exercise: Sorting Results
The WHERE Clause and Logical Operator Symbols
Checking for Equality
Checking for Inequality
Exercise: Using the WHERE Clause to Check for Equality or Inequality
Checking for Greater or Less Than
Exercise: Using the WHERE Clause to Check for Greater or Less Than
Checking for NULL
Exercise: Checking for NULL
WHERE and ORDER BY
Exercise: Using WHERE and ORDER BY Together
Checking Multiple Conditions with Boolean Operators
AND
OR
Order of Evaluation
Exercise: Writing SELECTs with Multiple Conditions
The WHERE Clause and Logical Operator Keywords
The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator
Exercise: More SELECTs with WHERE
Advanced SELECTs
Calculated Fields
Concatenation
Mathematical Calculations
Aliases
Exercise: Calculating Fields
Aggregate Functions and Grouping
Aggregate Functions
Grouping Data
Exercise: Working with Aggregate Functions
Selecting Distinct Records
Built-in Data Manipulation Functions
Common Math Functions
Common String Functions
Common Date Functions
Exercise: Data Manipulation Functions
Subqueries, Joins and Unions
Subqueries
Exercise: Subqueries
Joins
Table Aliases
Multi-table Joins
Exercise: Using Joins
Outer Joins
Unions
UNION ALL
UNION Rules
Exercise: Working with Unions
Inserting, Updating and Deleting Records (if time allows)
Inserting Records
Updating and Deleting Records
What you will learn
Understand how MySQL works
Learn to use SQL to output reports with MySQL
Learn to modify MySQL data with SQL
How you will benefit
Organizations store data in databases, and MySQL is the most popular open source database. Knowing how to query those databases opens up opportunities for you to build reports for such organizations
Database-driven websites require knowledge of SQL, and MySQL is one of the most popular databases used to build these websites, especially those built with PHP. This course gives you the prerequisite knowledge to start learning a server-side language such as PHP to use with MySQL
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Learn to use QuickBooks Online to record income and expenses; enter checks and credit card payments; track your payables, inventory, and receivables; and much more.
In this self-paced online course, you will learn to manage the financial aspects of your business quickly and efficiently with QuickBooks Online. This powerful accounting software program has helped millions of small business owners oversee their finances.
You will learn to use key features of QuickBooks Online and gain hands-on experience creating invoices, receipts, and statements; tracking payables, inventory, and receivables; generating reports; and more. Whether you're new to QuickBooks or need a quick refresher, this course will empower you to take control of your business's financial accounting, all with the ease and convenience of an online platform.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC or Mac.
Software Requirements:
PC: Windows 10 or later.
Mac: macOS 10.11 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
When your course starts, you will be directed to access and utilize the free QuickBooks Online practice site to complete the lesson and assignment steps. You do not need to purchase a subscription or additional software to complete this course. However, please note that this course is suitable only for the QuickBooks Online version. The desktop versions of QuickBooks are not compatible with this course and should not be used. If you have the desktop version, you should consider registering for the course specifically designed for your version.
Note: This course is based on the U.S. version of QuickBooks. Other locations are not supported.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Learn to use QuickBooks Online to record income and expenses; enter checks and credit card payments; track payables, inventory, and receivables; and much more.
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Learn the key concepts of SQL (Structured Query Language) the powerful and standard database management query language for relational databases.
SQL (Structured Query Language) is one of the best programming languages for beginning web developers to learn. This course will teach you the basics of designing and writing SQL queries to execute on a practice database. Using a SQL Server Express, you'll learn several real-world applications for SQL so you can put this valuable skill set on your resume.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. Macs are not compatible.
Dual monitors are helpful but are not required.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Necessary rights (local administrative rights) to install programs on the computer.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
SQL Server Express
SQL Server Management Studio
Gain a solid working knowledge of the most powerful and widely used database programming language. This course will provide you the skills to write SQL queries to create tables, retrieve data from single or multiple tables, manipulate data in a database, and gather statistics from data stored in a database.
Introduction to Database Design and SQL
In this introductory lesson, you will examine database terms and concepts. Understanding the purpose of a database and collecting data is foundational to using SQL to write queries and retrieve data result-sets that are usable.
SQL Server
In this lesson, you will install SQL Server Express and the SQL Server Management Studio to use throughout the course in your learn-by-doing practices. You will use a SQL code script to create one of the tables for the practice database in SQL Server.
Retrieving Data Result-Sets
SQL queries are the statements used to retrieve data from the database. Queries are written in a specific, logical order. In this lesson, you will explore various ways to write SQL queries to retrieve data that meets a defined criteria.
Sorting Data
SQL queries are defined and written to retrieve data in a certain order. Queries are also written to limit columns and to filter data rows. In this lesson, you will explore and practice defining and writing queries to meet a defined criteria to retrieve the expected result-set.
Designing SQL Data Tables
This lesson is about designing SQL data tables for a database. You will explore the relationship concept and how it is used in a RDBMS. You will define tables that are structured according to RDBMS standards. You will also create the tables to add to your practice database.
Designing Data Rows
In this lesson, you will add data to your newly defined tables. You will explore several methods of adding data to a table, and you will also practice writing and executing these query statements. After adding several individual rows to the tables, you will use a SQL code script to populate your tables with enough data rows to use in the learn-by-doing practices in this course.
Getting Data From Two Tables
SQL JOIN statements are used to retrieve data from more than one table. In this lesson, you will practice writing JOIN query statements that are defined to retrieve data result-sets from tables that have a relationship between their PKs and FKs.
Retrieving Data From Multiple Tables
In this lesson, you will continue writing JOIN statement that retrieve data result-sets from more than one table. You will also examine how and when to use SQL subquery statements to retrieve data from multiple tables. You will practice defining and writing JOIN and subquery queries.
Keeping the Database Up to Date
The quality of the data in the database depends on its integrity, including the concepts of data accuracy and consistency. In this lesson, you will explore writing queries to maintain the database so that it is up to date with data that is accurate, consistent, and has integrity.
Aggregate Functions
In this lesson, you will examine the concept of aggregate functions and how they are used in query statements to examine multiple rows. Aggregate functions are a method of retrieving summarized data that is useful for analysis.
SQL Views
SQL views are an important concept in database design and in using databases. In this lesson, you will explore designing and writing queries to create views. You will also explore the reason they are valuable for database security and database access.
Maximize Database Integrity and Performance
Constraints are one way to maximize the integrity of the database and minimize the opportunity for user error. Indexes are used for increasing the performance of a data query. In this lesson, you will explore both these concepts.
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Learn how to touch-type or improve your existing typing skills using Keyboarding Pro 5.
If you want to learn touch-typing or improve your existing typing skills, this is the perfect course for you! In these lessons, you'll use the Keyboarding Pro 5 program, a typing tutorial designed for personal computers, to learn how to touch-type—that is, to type text you read from a printed page or a computer screen without looking at your keyboard.
With the skills you master here, you'll become faster and more confident at the keyboard. By the end of the course, you'll know how to touch-type the alphabetic, numeric, and symbol keys; create, save, and edit word processing documents; and successfully take a timed writing test during a job interview.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. Macs are not compatible.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
When the class starts, you'll receive instructions for downloading and installing a working copy of Keyboarding Pro 5. Please do not purchase or download the software from another source.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Learn how to touch-type or improve your existing typing skills using Keyboarding Pro 5.
Getting Started with Key Pro 5
Your first lesson guides you step by step as you download, install, and set up Key Pro 5. You will also get acquainted with the program, learning about the home row keys and the reach to the "i" key on the QWERTY keyboard. Are you confused about what home row and QWERTY mean? Don't worry—this lesson explains all of that.
Lowercase Letters, Plus the Reaches to the "e" and the "n"
Now that you're getting comfortable with the home row on the QWERTY keyboard, it's time to introduce you to some new keys. This lesson focuses on proper techniques for lowercase letters. You will also use Key Pro 5 to practice the reaches to the e and the n. Is all this typing causing you aches and pains? You will find out how to reduce fatigue while typing.
The Left Shift, h, t, and Period Reaches
In this lesson, you will learn four new keystrokes: left SHIFT, h, t, and period (.). You will also provide some tips on improving speed and accuracy and introduce you to the Key Pro 5 word processor program.
Learn the r, Right SHIFT, c, and o Reaches
Continue to build your keyboarding vocabulary by learning four new key reaches in this lesson: r, right SHIFT, c, and o. You will also learn about "the Zen of typing," how touch-typing becomes an instinctive and unconscious action.
The w, Comma, b, and p Reaches
Your typing vocabulary continues to expand rapidly with the addition of the reaches to the w, comma, b, and p. Before you know it, you will be typing complete paragraphs. This lesson also covers what you need to know about carpal tunnel syndrome, a serious and painful condition that you can avoid.
The g, Question Mark, x, and u Reaches
Expand your typing vocabulary by mastering four more key reaches: the g, question mark (?), x, and u. Just a few more reaches, and you will know how to type the whole alphabet. In this lesson, you will also learn about the function (FN) key and the numbers lock (NUM LOCK) key, which are on most laptop keyboards.
The q, m, v, and Apostrophe Reaches
This lesson teaches you another four reaches for your typing vocabulary: q, m, v, and apostrophe ('). You will also learn how to save a document with a word processing program.
The z, y, Quotation Mark, and TAB Reaches
It's time to add another four reaches to your typing vocabulary: the z, y, quotation mark ("), and TAB keys. After this lesson, you will know the reaches to all the alphabetic keys. You will also find out how to open, edit, and resave word processing documents.
Alphabetic Key Review, the 1 and 8 Number Reaches, and Timed Writings
Are you ready to improve your skills and learn some new ones? After you review the z, y, x, q, v, quotation mark, and CAPS LOCK keys, you will learn the reaches to the numbers 1 and 8. Then you will take timed writings in the Key Pro 5 word processor.
Number Reaches, Deleting Text, and Alphabetic Key Review
What's the difference between the DELETE key, the BACKSPACE key, and the Cut command? By the end of this lesson, you will understand how and when to use these three editing tools. You will also continue to improve your skills with the alphabetic keys, plus you will learn more number reaches: 5, 0, 2, and 7.
Number and Symbol Reaches, Number Rules, and Key Review
When should you spell out numbers (like this: one, nine, five hundred), and when should you write them as figures (1, 9, 500)? You will also continue to improve your skills with the keys you have already learned, and you will finish the number reaches by mastering 4, 9, 3, and 6. Then you will learn two symbol reaches: the dollar sign ($) and the hyphen (-).
Symbol Reaches and Skill Building
You have already mastered some of the symbols and punctuation marks. In your last lesson together, you will meet the rest of the symbols. You will also work on your accuracy and speed with the Key Pro 5 Skill Building lessons. And you will find out how you can continue to hone your keyboarding skills long after you have finished this course.
This is an ed2go Self-Paced Distance Learning Course. Hover over or tap this text for more details.
Self-paced Tutorials (SPT) are for students who prefer to learn at their own pace and are comfortable with self-guidance. Students gain access to all course material, quizzes and the final exam at the time of enrollment. These courses can start at any time and have a 3 month duration of access. Some courses may have peer to peer discussions.
Obtain valuable skills working with data in Excel in this self-paced, online course.
Master the VLOOKUP function in Microsoft Excel and gain valuable skills applicable in any workplace where data is used when you complete this self-paced, online course. You will learn to work with data more effectively using the VLOOKUP functions and other helpful features in Microsoft Excel.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. Macs are not compatible.
Software Requirements:
PC: Windows 10 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Take your Microsoft Excel 2016 skills to the next level as you master charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Excel functions.
In this hands-on course, you will learn how to create informative, eye-catching charts and graphs, and harness the power of Excel's data analysis tools and AutoFilter commands. In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other time-saving functions to your repertoire.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Microsoft Office Home and Student 2016 (not included in enrollment).
Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Harness the power of Excel and become a master user of this powerful program. This hands-on course will provide skills using charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2016 functions.
Excel Charts and Graphs
In your first lesson, you will discover why Excel 2016 is such a powerful charting tool. To you, a workbook's numbers might tell an interesting story; to others, that story may not be obvious. You will learn how to choose the right chart for your story and then how to create, format, and edit your chart.
More Excel Charts
This lesson continues exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they may not be well-known, these options can add tremendous value to your worksheets in the right situations.
AutoFilter and Sorting
Working with data in Excel can be quite easy when you know about the tools that are available in a table format. One of these great tools is the Auto Filter command. This lesson will teach you how to use Auto Filter to limit your table information to just the records you want.
Goal Seeking
Learn how to use Solver to solve a complex problem based on the criteria and constraints that you provide it. You'll also explore in detail how to create all three types of Sparklines, as well as formatting options for each and gain the skills to create dashboard-like mini charts sure to make you the envy of your office.
PivotTables
Find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Then, receive a quick overview of all the categories of functions and the different methods you can use to create them.
Advanced PivotTables
Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. This lesson takes a tour through some of Excel's more advanced techniques, like the PivotTable filtering tool Slicer. You will also learn how a PivotTable can serve as your source for the PivotChart.
Solver
Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you will learn how to use Solver to solve a complex problem based on criteria and constraints.
Sparklines
There's nothing more exciting than learning how to master a new feature in Excel. This lesson focuses on creating three types of Sparklines, as well as formatting options for each. By the end of the lesson, you will have the skills to create dashboard-style mini charts.
Macros
In this lesson, you will find out how to use macros to turn repetitive and often time-consuming tasks into automated Excel functions. You will also learn how to record a macro that performs a task in seconds with the click of a button.
Introduction to Functions
If you have used Excel for a while, you know there are hundreds of functions at your disposal. The last three lessons of this course will cover how and why you would use these functions. This lesson introduces creating various functions with the Text category.
Math/Trig Functions
Next to learning how to create macros, most students want to learn as much as they can about Excel functions. This lesson covers on more complex functions of the "Math & Trig" category, focusing on the SUMIF and COUNTIF functions in particular.
VLOOKUP, INDEX, and MATCH Functions
Since functions are such an integral part of using Excel, your final lesson will cover advanced features. In this lesson, you will learn how to use the VLOOKUP, INDEX, and MATCH functions.
What you will learn
Master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2016
Learn to create useful and eye-catching charts
Discover how to manipulate data with the push of a button
Add the time-saving functions of advanced Excel users to your repertoire
How you will benefit
Take your Excel 2016 skills to an expert level and become a more productive member of your organization
Gain indispensable skills that will be useful in any organization that relies on numbers-based reporting
Learn to fully harness the power of Microsoft Excel 2016 and use all of its capabilities to save time and money
Chad Wambolt
Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn how to use the more advanced features of Microsoft Word 2016 (now available through Office 365) including how to add graphics, use templates, and merge data.
Go beyond the basics of word processing and master the more advanced features of Microsoft Word 2016 (now available through Office 365). In this course, you'll learn how to automate Word 2016 using shortcuts to help you write more while typing less. From signs, newsletters, and greeting cards to long documents, you'll learn how to create whatever you need—quickly and with professional-looking results.
You'll also learn how to create and organize text in tables, mix graphics and text together to turn Word into a simple desktop publishing program, and merge spreadsheet and database data to create mailing labels and form letters. Along the way, you'll go through lots of examples and exercises so you can see how Word's advanced features work; but more importantly, you'll see how you can use these advanced features at home and on the job. By the end of this course, you'll know how to use Word more effectively and take advantage of its many features so that you can get your work done quicker and easier than you ever thought possible.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Master the advanced features of Microsoft Word 2016 and create truly professional looking documents. This hands-on course will help you learn how to create an index, build a list of figures, design a table of contents, do desktop publishing, perform a mail merge, and use timesaving shortcuts.
Shortcuts and Time-Savers in Word 2016
Humanity has come a long way since the days of the typewriter. What used to take hours can now be done in seconds with Microsoft Word 2016. And the less time you spend typing, the more time you can spend being creative and having fun. In this lesson, you'll learn shortcuts in Word that can help you create documents faster and more accurately than ever before. Not only will these shortcuts save you time, but they'll help you create letters and reports more easily than you might have thought possible.
Text and Paragraph Formatting Methods
What you write is half of communication. The other half is getting people to read what you write. One way to make your writing more appealing is to make it look presentable with formatting. Of course, formatting text is easy, but applying different types of formatting over and over again can get tedious. That's why, in this lesson, you'll learn a fast and easy way to format chunks of text quickly and consistently using something called styles. You'll find out what a style is, how to apply it, and more important, how to create and save your own styles to use in any document. By the end of this lesson, you'll be able to make any document look presentable with just the click of your mouse.
Templates
If you've ever baked cookies, or even just watched someone else do it, you know how difficult it can be to make all the cookies in a batch look exactly alike. Some turn out big, some small, some gooey, and some burned! However, if you use a cookie cutter, you can make identically shaped cookies every time. That's the same principle you'll learn in this lesson; instead of using a cookie cutter, though, you'll use something called a template. A template stores the formatting of a document so that you can apply it to another document. Templates let you format entire documents as easily as formatting a single word. Word offers lots of convenient templates stored right on your computer or available over the Internet, and you'll also find out how you can create your own.
Graphics: Part 1
They say a picture is worth a thousand words, so what better way to spice up your documents than by adding pictures? In this lesson, you'll learn how to add your own digital photographs to a document so that you can show everyone your vacation pictures, family holidays, or just interesting sights you've captured with your own camera. In addition to adding your own photos, you can also add clip art from Word's massive library of free graphics. And you'll find out how to resize, rotate, and style your pictures, as well as wrap your document text around them. By the end of this lesson, you'll see why Word documents are about much more than words!
Graphics: Part 2, and Columns
Digital photographs and clip art are just the beginning of what you can do with graphics in Word. In this lesson, you'll discover how to add a variety of informational graphics, including charts, graphs, and WordArt, which allow you to display text as a graphic image. Not only will you learn how to add these graphics, but you'll also find out how to edit them when your data changes. You'll finish off the lesson by seeing how Word allows you to format documents with multiple columns—a handy skill for creating newsletters and publications!
Sections and Notes
Do you often create long documents? If so, you'll appreciate this lesson, which shows you how to divide a large document into parts called sections. Sections allow you to format part of a document a certain way without that formatting affecting the rest of your text. For example, you may want headers and footers to appear on some pages but not others. Sections make this easy! You'll also spend some time inserting footnotes and endnotes in a document. If you need to write research papers or other academic content, Word makes it a snap to add and format these previously pesky notes!
Tables
If you've ever seen a spreadsheet, you know how rows and columns let you organize numbers and text on the screen. Well, tables do the same thing in Word. In this lesson, you'll see how to create tables of all different sizes right in a Word document! The lesson will cover how to modify tables, too. And don't think Excel users get to have all the fun—you can even enter formulas to perform calculations in your tables, sort them, and style them for a customized look. Your data has never looked so appealing!
Envelopes and Odd-Size Pages
You probably print most of your documents on standard letter-size paper. While this is great for ordinary letters or business reports, sometimes you may want to get creative with your paper sizes. But then there's the trouble of printing. In this lesson, you'll see how you can define the dimensions of the paper you're using, so Word will print everything correctly. You'll also learn how to print names and addresses directly on envelopes of any size. After this lesson, you won't feel confined to boring 8 1/2 x 11-inch paper anymore!
Desktop Publishing: Part 1
As you've probably already figured out, Word can do more than write letters. It also functions as a simple desktop publishing program for creating greeting cards, calendars, or newsletters. In this lesson, you'll find out how text boxes are the key to simple desktop publishing and see how other elements come into play in customized documents. Along the way, you'll look at business cards and greeting cards to get a feel for how desktop publishing works. If you've always wanted to create a document that combines text and graphics in an artistic or visually appealing way, you'll find out how to do that and much more.
Desktop Publishing: Part 2
With the basics down, it's time to take your desktop publishing skills to the next level. In this lesson, you'll discover the magic of linked text boxes that give you the power to move your text anywhere you want on the page and keep it flowing. You'll see how to create, position, resize, and group text boxes so you have total control over your text.
Merging Data with Documents
Have you ever received one of those "personalized" letters from a company in the mail? You can be sure that nobody typed the entire sales letter from scratch. Instead, the company used a form letter and something called mail merging. In this lesson, you'll learn how to store long lists of names and addresses that you can use over and over again in a form letter. Just create a document once, leave blanks for inserting information such as names and addresses, and let Word personalize each letter for you. Now you, too, can create personalized letters for business or personal use, such as sending out holiday greetings to family members and friends.
Final Touches
Look in most books, and you'll find the table of contents at the beginning and an index in the back. Often, these are the last components added to a document, since they need to have accurate titles and page numbers. But Word takes a lot of the tedious work out of creating these components. In this final lesson, you'll see how you can use Styles to make creating the table of contents a snap, and then explore how to tag index terms so Word knows what page they're on, even if they move later. Word can also help you keep track of any figures, such as charts, illustrations, or graphs, in your document. By letting Word worry about the details, you can create an accurate table of contents, index, or list of figures with very little extra effort on your part. These finishing touches will make your most important documents shine!
What you will learn
Learn how shortcut keys, macros, and the AutoCorrect feature can save you time
Discover fast ways to format text in a document
Find out how to insert graphic images, including clip art and photos, into your documents
Add charts, SmartArt, and WordArt to a document, and divide any document into columns
Practice dividing a long document into sections and using footnotes and endnotes
Get acquainted with some of Word's desktop publishing features, such as using text boxes, layering, and aligning objects
Learn how to link text boxes, and position them in a document to create brochures and newsletters
Use mail merging to quickly and easily personalize form documents
How you will benefit
Master the more advanced features of Microsoft Word
Learn how to use Word more effectively and take advantage of all its many features so you can get your work done more quickly and more easily
Wallace Wang
Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn to use the basic features of Word 2016 (now available through Office 365) to type, edit, format, spell check, and print professional-looking documents, letters, and reports.
One of the most basic skills needed in any job is writing reports and letters using Microsoft Word 2016, now available through Office 365. In this course, you will gain the foundational skills you need to make the most of this powerful program.
Through hands-on instructions, you will learn how to add and edit text; move words from one part of your document to another; work on two or more documents simultaneously; and format your text. You will also see how to save, retrieve, copy, organize, and print your documents.
You will learn dozens of ways to modify the appearance and content of your documents by adjusting page margins, paragraph tab settings, and line spacing to create great-looking documents quickly and easily. If you need to type foreign language characters or symbols, you can do that in Word too.
By using Word's spell and grammar checker, you can catch typos and grammatical mistakes before you print or share your document with others. You will also explore the program's thesaurus feature, which can help you find exactly the right word. By the time you're done with the step-by-step lessons and hands-on activities in this course, you will be able to use Word confidently at home or on the job.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Microsoft Word is used in nearly every modern workplace. In this course, you will master all the basics of this powerful word-processing program, including how to type and edit text, and how to format, spell check, and print documents. You will also learn dozens of different ways to modify the appearance and content of your documents and how to catch errors with Word's spell and grammar checker. After completing the course, you will be able to use Word confidently at home or on the job.
Getting Started
In this introductory lesson, you will learn how to use the different parts of Word 2016's user interface, how to look at your document from different types of views, how to zoom in and out to magnify or shrink your text, and how to change the margins of individual paragraphs.
Typing and Navigation
The whole purpose of Word is to let you create and edit text. This lesson introduces the basics of moving the insertion point and deleting text. By knowing the pros and cons of navigating through a document with the keyboard and mouse, you can use both to help you work faster in Word.
File Management
In this lesson, you will learn how to save the documents you create in Word. You will also learn how to rename, copy, and even delete any files you have created, so you will always be in complete control of all the files you create.
Editing Text
After you've typed some text in a Word document, you may need to edit that text. This lesson focuses on editing text. The easiest way to edit text is to delete it, but a more sophisticated way to edit text is to copy text and paste a duplicate of that text in another location.
Working With Multiple Documents
Most people use Word to view and edit a single document at a time, but Word actually lets you open and view two or more documents at the same time. This lesson will teach you how to open, switch between, and view multiple documents.
Text Formatting and Alignment
Once you know how to add, delete, copy, and move text, the next step to modifying your document is to change the physical appearance of your text. You can make text appear in different colors or background highlighting, change text size and alignment, and even modify fonts.
Printing
Most people use Word to print letters and reports. In this lesson, you will learn about the different ways you can print a document, such as portrait orientation or landscape orientation. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents.
Margins, Tabs, and Page Numbering
By knowing how to set and use margins, you can modify an entire document or just a single page. By using tabs, you can modify how individual paragraphs look on a page. Finally, you will also learn how to add page numbers to the top or bottom of a page to keep track of page order.
Paragraph Formatting
Word provides ways to change the appearance of a paragraph's first line, line spacing within a paragraph, and line spacing between paragraphs. In addition, Word lets you create bullet and number lists, so you can display short bits of information in a visual manner.
Language Tools
For important documents, you may even need to collaborate with others. To keep track of all the changes multiple authors may make to a single document, Word offers a Track Changes feature, so you can see exactly what and who changed the document.
Customizing Word
With Word, you can press different types of keystrokes or search and click the symbol you want to use. This lets you add practically any type of unusual character to your documents. Word lets you type practically anything you want, regardless of the limitation of the keys on your keyboard.
Making a Word Document Pretty and Organized
Finally, you can use outlines to organize your text and quickly move chunks of text within a document just by rearranging an outline heading. By learning these advanced features of Word, you can make each document display text in the most appealing way possible.
What you will learn
Learn the fundamentals of one of the most crucial software applications in the modern workplace
Acquire the skills and learn the tools you will need to adjust margins, spacing, layout, and design of any Word document
Learn how to work on multiple projects at once and become faster and more efficient in a variety of Microsoft Word tasks
Explore the many ways to modify the appearance of your documents in order to suit your individual needs
How you will benefit
Gain the confidence you need to make the most of this indispensable software application
Learn how to make the perfect layout for useful documents of any occasion - resumes, invitations, letters, articles, training materials, and much more
Save time and avoid frustration by familiarizing yourself with the wide variety of tools at your disposal in Word 2016
Become more proficient and efficient at one of the most widely used software programs in history
Wallace Wang
Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
This hands-on, project-oriented course is filled with easy-to-follow, detailed step-by-step instructions that teach you how to edit and manipulate images and create elemental compositions using Photoshop in the Creative Cloud. Discover how to improve photographs by editing out flaws, correcting poor exposure, or creating a composite image using the newest techniques.
Photoshop is the world's most popular photo-editing program. Artists, photographers, designers, and hobbyists all rely on Adobe Photoshop for image creation and editing. The Introduction to Photoshop CC course provides meticulous instructions that will teach you how to use Photoshop Creative Cloud with confidence.
Photoshop Creative Cloud has a host of impressive new features, and you will encounter a number of them throughout the course. You will be editing your own photographs to get rid of dust and scratches, fix the color, and correct image exposure. Then you will learn how to colorize parts of an image and how to create simple digital paintings. You will master techniques for switching the backgrounds on images and removing wrinkles and blemishes from photos, just like they do in magazines.
You will also learn about the content-aware Move tools that, like magic, let you move something on an image and intelligently replace the "hole" left behind at the same time. By the time you finish this fun, hands-on, project-oriented course, you will be well on your way to expressing yourself with the most exciting graphics program ever developed.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC or Mac.
Software Requirements:
PC: Windows 10 or later.
Mac: macOS 10.14 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
Adobe Photoshop CC, Adobe Creative Cloud, or any version of Adobe Creative Suite CC that includes the Adobe Photoshop CC or Photoshop only (not included in enrollment).
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Whether you are a photographer, digital illustrator, graphic designer, or someone who wants to alter old family photos, you need to learn Adobe Photoshop. The Introduction to Photoshop Creative Cloud course is filled with easy-to-follow, detailed step-by-step instructions that teach you how to edit and manipulate images and create basic compositions using Photoshop in the Creative Cloud. Discover how to improve photographs by editing out flaws, correcting poor exposure, or creating a composite image using the newest techniques Photoshop has to offer. You will even learn how much fun you can have digitally painting and exploring filters and effects to create unique images. And, best of all, you need no prior artistic ability or Photoshop experience to take this course.
Getting to Know Adobe Photoshop
Whether you're an aspiring graphic artist or a weekend photographer, Photoshop can play many roles in image creation. Even if you've never touched Photoshop before, you'll become familiar with Photoshop's interface and 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 how to crop an image to its desired image area.
Understanding Resolution and Layers
In this lesson, you'll learn and apply the basics in setting image resolution by resizing and resampling graphics for both screen and print purposes. Then, explore the wonders of working with layers. Move and transform objects within a scene to recreate a new composition. You will learn how to add, delete, hide, merge, and group layers as well as to change the blending mode of a layer to reveal new visual effects.
Working with Objects
What makes a good image composite? Find out in this lesson where you will discover the principles of image compositing and apply these by combining images to create your first image composites. Find out how linked layers work and see what Smart Objects can do. You will learn how to use guides to assist in placing and aligning objects. Then, you will use multiple images to create a realistic still-life image. Learn how to transform objects by scaling, rotating, distorting, and warping them.
Image Adjustments
Do you have an old image that has faded over the years? Are your vacation photos over-exposed or too dark? Use image adjustments to correct contrast and color! In this lesson, you will find out how to correct an image's contrast and make the colors pop using image adjustments. You can even remove color to make a black and white or toned image. Then, apply several image adjustments along with blending modes to create a surreal image! Finish this lesson by exploring the filters gallery to apply various artistic filters to a collage.
Image Retouch and Restoration
Need to clear up a few blemishes on a headshot? Or remove unwanted telephone wires from a landscape? This lesson introduces you to the tools used in photo retouching and restoration. This lesson also covers sharpening an image, blurring areas of an image to create a depth of field, and adding a vignette to an image. You will learn how to easily clear up blemishes in portraits and restore old, damaged photographs. You will also learn how to remove or duplicate objects in a scene.
Colorizing Images
Learn how to combine colors and create color themes using Adobe Color. Sample colors from an existing image to create a new color scheme. Then, apply color to black and white photos using several techniques to color areas. Color a single object in a black and white image to create emphasis, or color the entire image, as if filling in a "digital" coloring book. This lesson also covers how to save and load swatches of color to use on other projects.
Working with Brushes
Adobe Photoshop is one of the leading applications for digital painting. This lesson introduces you to brushes and teaches you to paint using different brush types to simulate real artists' materials, such as charcoal, pastels, oil paint, and watercolor. You do not have to have strong drawing skills to complete this lesson. You will sample color from existing images and use these as templates for your digital painting.
Working with Selections
One of the most basic skills you need in Photoshop is the ability to select areas of an image. Often, you'll want to make adjustments to or fine tune areas of a photograph. The act of editing an image, no matter the desired outcome, is based heavily on your ability to make good pixel selections. In this lesson, you will learn how to use the various selection tools and to use them to create convincing shadows to objects in a composition.
Working with Masks
Masks can hide or reveal parts of a layer. Learn to use masks with images and adjustment layers to advance your image manipulation skills. Learn to use and modify masks to create complex selections around objects with thin strands of hair and clipping masks to add textures to objects.
Working with Vectors
Photoshop is able to create vector shapes and paths, which are used across many Adobe products, so learning these tools can put you ahead of the game when you are learning software such as Adobe Illustrator. This lesson is designed to guide you through the technical tools in a way that is easy to grasp.
Type and Layer Effects
Want to create an invitation or promote an event? This lesson shows you how to apply typography with images to create effective design by utilizing Adobe Fonts, manipulating text using warping, typing on a path, or typing as a mask to place an image within the letterforms. Then, polish the look of your text with layer effects. This lesson will introduce you to a world of limitless type effects.
Preparing Files for Output
Understanding what file formats to use and when can be confusing. This final lesson covers file types and when to use them. Learn how to prepare files for both print and web output. You will also learn how to create a Behance portfolio page to showcase and promote your work!
What you will learn
Master the fundamentals of Photoshop's interface and tools
Understand the essentials of digital imaging including file formats, color modes, image size, and resolution.
Comprehend and apply digital color theory and practice colorization and digital painting
Identify and apply the methods of photo retouch and restoration
Use the functionality of Photoshop's layers, selections, and masking features
How you will benefit
Discover everything you need to confidently use the tools in Photoshop to restore, retouch, and rearrange images
Develop the skills you need to begin a new hobby or entry-level career using Photoshop
Learn to effectively retouch photos and develop professional quality images for your home or business
Harness the power of Photoshop to create stunning images by enhancing photographs and developing works of art
Beverly Richards Schulz
Beverly Richards Schulz is an award-winning photographer and graduate of the New York Institute of Photography. She holds a Bachelor of Arts in Legal Studies from UC Berkeley and a master's degree in Adult and Continuing Education. For the past 10 years, Schulz has taught at the University of San Francisco. With more than 15 years teaching experience, she has written over 30 digital photography and digital editing courses. She co-authored the book "Photoshop Elements 14—What's New?"
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn to use QuickBooks Online to record income and expenses; enter checks and credit card payments; track your payables, inventory, and receivables; and much more.
This QuickBooks course will teach you how to manage your business finances with QuickBooks Online. This powerful accounting software has helped millions of small business owners oversee their finances. Now that the cloud-based version is outpacing the desktop version, there's no better time to refresh your QuickBooks knowledge.
You will learn to use key features of QuickBooks Online and gain hands-on experience creating invoices, receipts, and statements; track payables, inventory, and receivables; generating reports; and more. Whether you're new to QuickBooks or need a quick refresher, this course will empower you to take control of your business's financial accounting, all with the ease and convenience of an online platform.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC or Mac.
Software Requirements:
PC: Windows 10 or later.
Mac: macOS 10.11 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
When your course starts, you will be directed to access and utilize the free QuickBooks Online practice site to complete the lesson and assignment steps. You do not need to purchase a subscription or additional software to complete this course. However, please note that this course is suitable only for the QuickBooks Online version. The desktop versions of QuickBooks are not compatible with this course and should not be used. If you have the desktop version, you should consider registering for the course specifically designed for your version.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Manage the financial aspects of your small business quickly and efficiently using QuickBooks Online. This course will give you hands-on experience recording income and expenses; entering checks and credit card payments; tracking your payables, inventory, and receivables; and much more.
Getting Started
Your first lesson will introduce the QuickBooks Online interface and the pros and cons of working with your accounting information online. You will learn about the various subscription packages and practice using some of the interactive navigation features within the program.
Accounting Basics
To truly unlock the power of QuickBooks Online, it's helpful to have some basic accounting knowledge under your belt. In this lesson, you'll learn some introductory accounting terminology. In addition, you'll learn the basics of double entry accounting principles as well as the components of the Financial Statement.
The Chart of Accounts
The Chart of Accounts is the heart and soul of QuickBooks. In this lesson, you will 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
This lesson introduces best practices for using centers and lists in QuickBooks to gather and organize information needed to properly conduct business. You will also learn how to process Form 1099 to give to your vendors at the end of the year.
Bank Accounts
In this lesson, you will learn how to work with bank accounts in QuickBooks Online. You will learn how to create a new bank account, connect it online, and download, match, and add transactions. Then you will 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
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 will learn how to utilize QuickBooks' built-in features to enter check transactions and bank transfers like a pro.
Paying Bills
Without an organized system for managing all the bills your business receives, they can really start to stack up. When bills pile up, it becomes easy to start missing payment deadlines, which can result in late fees and credit difficulties. In this lesson, 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.
Credit Cards and Loans
In this lesson, you will learn how to effectively manage Credit Card accounts in QuickBooks Online. You will also learn how to enter a full or partial payment of the credit card balance when it comes time for payment. Finally, you will 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
You will find this lesson useful if your business ever sells a product or service and collects payment on the sale immediately. Then you will learn how to create multiple Sales Receipts and make the necessary deposit to your bank.
Invoices and Estimates
In order to evaluate just how well your company is performing, you will need to learn how to enter estimates, invoices, and customer payments. You will do just that in this lesson. You will also learn how to group multiple customer payments and record those deposits to the bank.
Billable Expenses and Customer Credits
This lesson focuses on billing customers for an expense incurred on a project or job. You will even see how you can add a markup percentage to the amount you include on the customer invoice. Also, you will examine the steps needed to enter credit memos, delayed credits, and refunds.
Sales Taxes and Reports
In your final lesson, you will learn how to work with the sales tax features in the program to collect and remit taxes you collect from customers. You will also find out how to create, use, and customize a wide variety of useful reports.
What you will learn
Learn everything you need to know about running QuickBooks in a small to mid-sized business
Discover how to set up a chart of accounts, reconcile your checking account, and create estimates
Learn to create and print invoices, receipts and statements
Understand how to track payables, inventory, and receivables
Gain the knowledge you need to generate reports
How you will benefit
Get access to Intuit's Test Drive Sample Company practice site of QuickBooks Online Plus
Get hands-on experience as you master the tools you will need to successfully use QuickBooks online
Gain the confidence to take control of the financial accounting for your business
Scott Paxton
Scott Paxton is a Certified Public Accountant and holds master's degrees in business administration and accounting. His background includes experience as a public accountant, a manager in the banking industry, an entrepreneur and a college business instructor. Paxton has also spent much of his career helping small business owners successfully implement and troubleshoot QuickBooks.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn the key concepts of SQL (Structured Query Language) the powerful and standard database management query language for relational databases.
Learn the key concepts of SQL (Structured Query Language) the powerful and standard database management query language for relational databases.
SQL (Structured Query Language) is one of the best programming languages for beginning web developers to learn. This course will teach you the basics of designing and writing SQL queries to execute on a practice database. Using a SQL Server Express, you'll learn several real-world applications for SQL so you can put this valuable skill set on your resume.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. Macs are not compatible.
Dual monitors are helpful but are not required.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
Software must be installed and fully operational before the course begins. Student will install the required software in the course.
Other:
Email capabilities and access to a personal email account.
Necessary rights (local administrative rights) to install programs on the computer.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
SQL Server Express
SQL Server Management Studio
Gain a solid working knowledge of the most powerful and widely used database programming language. This course will provide you the skills to write SQL queries to create tables, retrieve data from single or multiple tables, manipulate data in a database, and gather statistics from data stored in a database.
Introduction to Database Design and SQL
In this introductory lesson, you will examine database terms and concepts. Understanding the purpose of a database is foundational to writing efficient SQL queries that retrieve the right data.
SQL Server
In this lesson, you will install SQL Server Express and the SQL Server Management Studio to use throughout the course in your learn-by-doing practices. You will use SQL code to create one of the tables for the practice database in SQL Server.
Retrieving Data Result-Sets
SQL queries are the statements used to retrieve data from the database. Queries are written in a specific, logical order. In this lesson, you will explore various ways to write SQL queries to retrieve data that meet defined criteria.
Sorting Data
SQL queries are defined and written to retrieve data in a certain order. Queries are also written to limit columns and to filter data rows. In this lesson, you will practice writing queries that meet defined criteria and retrieve the expected result-sets.
Designing SQL Data Tables
This lesson is about designing SQL data tables for a database. You will explore the relationship concept and how it is used in an RDBMS. You will define tables that are structured according to RDBMS standards. You will also create the tables to add to your practice database.
Designing Data Rows
In this lesson, you will add data to your newly defined tables. You will explore several methods of adding data to a table and practice writing and executing these query statements. After adding several individual rows to the tables, you will use a SQL query to populate your tables with enough data rows to use in the learn-by-doing practices in this course.
Getting Data From Two Tables
SQL JOIN statements are used to retrieve data from more than one table. In this lesson, you will practice writing JOIN statements that retrieve data from tables that have a relationship between their PKs and FKs.
Retrieving Data From Multiple Tables
In this lesson, you will continue writing JOIN statements that retrieve data result-sets from more than one table. You will also examine how and when to use SQL subquery statements to retrieve data from multiple tables. You will practice defining and writing JOIN and subquery queries.
Keeping the Database Up to Date
The quality of the data in the database depends on its integrity, including the concepts of data accuracy and consistency. In this lesson, you will explore writing queries to maintain the database so that it is up to date with data that is accurate, consistent, and has integrity.
Aggregate Functions
In this lesson, you will examine the concept of aggregate functions and how they are used in query statements to examine multiple rows. Aggregate functions are a method of retrieving summarized data that is useful for analysis.
SQL Views
SQL views are an important concept in database design and in using databases. In this lesson, you will explore designing and writing queries to create views. You will also explore the reason they are valuable for database security and database access.
Maximize Database Integrity and Performance
Constraints are one way to maximize the integrity of the database and minimize the opportunity for user error. Indexes are used for increasing the performance of a data query. In this lesson, you will explore both these concepts.
What you will learn
Use SQL to develop a relational database
Design table and row structures that fulfill your requirements
Write efficient SQL queries to find and organize data
Write SQL queries to retrieve data from multiple tables
Create updates for a secure, high-performance database
How you will benefit
Gain confidence in your SQL ability, the standard database query language
Open the door to opportunities as you list basic SQL programming as a skill on your resume
Develop a new skill and learn whether or not you would like a career in IT
Mava Wilson
Mava Wilson, Ph.D., is a professor with more than 28 years of teaching experience. While she specializes in Information Systems (IS), she has taught several computer science topics, including basic computer literacy, programming, database design, and SQL. She holds a Ph.D. and master's degree in computing technology from Nova Southeastern University, as well as a bachelor's in administrative systems from Radford University.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
In this course, you will learn to use Windows 11, a powerful new operating system, including customizing your desktop, managing files and folders, and navigating the web with the latest Microsoft Edge browser.
File Explorer can help you manage your files and create text documents using WordPad. From managing files and editing photos to working with external drives, you will learn everything you need to know about getting the most from this operating system. Additionally, since security is essential, you will also learn how to protect your files and protect and update Windows 11.
By the time you finish this course, you will have mastered the basic skills you need to get the most from Windows 11 for both work and play.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC or Chromebook. Macs are not compatible.
Software Requirements:
PC: Windows 11 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Master the basic skills you need for Windows 11, the new operating system from Microsoft, which offers a more robust, more powerful, and unique computing experience. In this course, you will gain the foundation you need to start using Windows 11.
Welcome to Windows 11
Learning to use your PC well starts with learning to use Windows. In this first lesson, we'll start with the basics that every computer user must know in order to use a computer with minimal frustration. If you've been working in "frustration and aggravation" mode for a while, this lesson will take care of that. We'll start by talking about what Windows 11 is and why you want to learn it. Then, we'll get right into the most important skills and terminology that allow you to control what you see on your screen at all times. And that's important, because the first step to using anything that's in your computer is getting it on the screen where you can see it!
Use the Start Menu and Apps
In this lesson, we'll explore the revised Start Menu and Apps in Windows 11. You'll see how to use and customize the Start Menu, and we'll explore the Windows Store. You'll also see how to use the new widgets feature of Windows 11, which gives you access to quick and easy information, such as weather, traffic, sports, and news.
Personalizing Your Windows Desktop
In today's lesson, you'll have fun personalizing your computer by choosing your own desktop pictures, themes, and sound scheme. Along the way, you'll learn about the important Control Panel window in Windows 11 and tips for using dialog boxes and those occasional mysterious dimmed options that do nothing when you click them. The skills you learn in this lesson will go a long way to helping you gain complete control of your computer.
Working With Text and Files
No matter how you intend to use your computer, there'll be times when there's some typing involved. It might be for writing email messages, memos, or letters, or it might be for taking notes in a course, or for chatting with others in a website. Whatever the reason, today's lesson will teach you all the tricks for making typing (and editing) quick and easy. And you'll also discover how to save your work in files and folders, so it'll always be there when you need it!
Exploring Your System
Everything that's in your computer is stored on its hard drive. The hard drive is like a filing cabinet containing files organized into folders. Finding things you've saved in the past is a matter of opening the filing cabinet, so to speak, and then locating the correct folder. You'll use the File Explorer program to accomplish this. And in this lesson, you'll learn how it all works, so you can start gaining complete mastery of your own files and folders.
Using OneDrive, Microsoft Teams, and Microsoft To Do
In this lesson, you'll explore three Windows 11 features: OneDrive, Teams, and To Do. OneDrive is a cloud storage solution that lets you store files and folders both on your PC as well as the Microsoft cloud. Using OneDrive, you can save your data to Microsoft servers and access that data across multiple devices. Teams is communication software that is built into Windows 11. Using Teams, you can chat with friends, family, and co-workers and even host video and audio calls. Finally, you'll take a look at Microsoft To Do—an app that helps you keep track of to do tasks and lists. All of these features are designed to make your life easier!
Manage and Edit Your Photos
In this lesson, we'll have some fun with photos. Today, you'll learn how to organize your photos and view them using Windows 11's Photos App. You'll also see how to view individual photos, draw and rotate, and auto-enhance your shots. And, you'll learn about the Photos App editing tools for adjusting brightness and contrast, straightening crooked pictures, correcting red eye, and cropping.
Using Edge
The Internet is home to popular websites like Facebook, Amazon, Google, ed2go, and many others. Many of you have seen references to .com sites in ads and elsewhere. If you don't have a lot of computer experience, you might find it difficult to get to the many things you hear about on the web. But not after this lesson! In this lesson, you'll learn how to use Edge, the program that provides access to all of those popular websites.
Managing Files and Folders
Managing files and folders is one of those computer skills that every computer user needs to know. In many work and school environments, people just assume you know how to manage files, and they rarely provide any details on how to accomplish things like copying, moving, or renaming files and folders. Today's lesson will explain how to do those very things that others assume you already know how to do.
More Fun With File Management
In this lesson, you'll expand your file management skills by learning how to delete and recover files. You'll learn how to select multiple files to work with, so you don't always have to manage your files one at a time. And we'll discuss how to copy files to and from removable media like flash drives, CDs, and DVDs.
Protect Your Valuable Files!
Your computer is an investment of money, and the pictures and other files you store on your computer are an investment of time. You might even have some photos or other files that are so precious the thought of losing them causes you anxiety. What you need to do is protect those files. And that's just what this chapter is all about—how to use the tools and techniques that are built right into Windows to help you protect your valuable time and files!
Tips, Tricks, and Shortcuts
In our final lesson, you'll learn some more techniques for protecting your computer, including using resources for free protection from viruses and spyware. You'll learn how to remove programs you no longer want or need. You'll learn how to copy and paste text and create screenshots. And you'll discover some great timesaving tips and shortcuts, as well as resources for helping yourself so that you don't have to be so dependent on others.
What you will learn
Find your way around Windows 11 with the desktop, Start menu, and system settings
Understand how to customize features and personalize your desktop
Discover how File Explorer can help you manage files and learn to create basic text documents using WordPad
Comprehend how to protect your files and update Windows 11
How you will benefit
Gain confidence in your use of the Windows 11 operating system for personal and business use
Learn how to use your PC effectively, starting with Windows
Experience reduced frustration and setbacks by learning to operate your computer properly
Become a more independent computer user
Curt Simmons
Curt Simmons, B.A., M.Ed, is a best-selling author, trainer, and multi-media expert. He holds degrees in English and communication studies and has more than 10 years of experience teaching English and writing in the classroom. Additionally, Simmons has authored numerous books on a wide variety of technology topics and has been a technical editor for numerous other titles.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn how to touch-type or improve your existing typing skills using Keyboarding Pro 5.
If you want to learn touch-typing or improve your existing typing skills, this is the perfect course for you! In these lessons, you'll use the Keyboarding Pro 5 program, a typing tutorial designed for personal computers, to learn how to touch-type—that is, to type text you read from a printed page or a computer screen without looking at your keyboard.
With the skills you master here, you'll become faster and more confident at the keyboard. By the end of the course, you'll know how to touch-type the alphabetic, numeric, and symbol keys; create, save, and edit word processing documents; and successfully take a timed writing test during a job interview.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. Mac, Chromebooks, Surface, and all other tablets are not compatible.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
When the class starts, you'll receive instructions for downloading and installing a working copy of Keyboarding Pro 5. Please do not purchase or download the software from another source.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Become faster and more confident at the keyboard. This course will help you learn how to touch-type the alphabetic, numeric, and symbol keys; create, save, and edit word processing documents; and successfully take a timed writing test during a job interview.
Getting Started With Key Pro 5
Your first lesson guides you step by step as you download, install, and set up Key Pro 5. You will also get acquainted with the program, learning about the home row keys and the reach to the "i" key on the QWERTY keyboard. Are you confused about what home row and QWERTY mean? Don't worry—this lesson explains all of that.
Lowercase Letters, Plus the Reaches to the "e" and the "n"
Now that you're getting comfortable with the home row on the QWERTY keyboard, it's time to introduce you to some new keys. This lesson will focus on lowercase letters. You will also use Key Pro 5 to practice the reaches to the e and the n. Is all this typing causing you aches and pains? You will find out how to reduce fatigue while typing.
The Left Shift, h, t, and Period Reaches
In this lesson, you will learn four new keystrokes: left SHIFT, h, t, and period (.). You will also provide some tips on improving speed and accuracy and introduce you to the Key Pro 5 word processor program.
Learn the r, Right SHIFT, c, and o Reaches
Continue to build your keyboarding vocabulary by learning four new key reaches in this lesson: r, right SHIFT, c, and o. You will also learn about "the Zen of typing", which is how touch-typing becomes an instinctive and unconscious action.
The w, Comma, b, and p Reaches
Your typing vocabulary continues to expand rapidly with the addition of the reaches to the w, comma, b, and p. Before you know it, you will be typing complete paragraphs. This lesson also covers what you need to know about carpal tunnel syndrome, a serious and painful condition that you can avoid.
The g, Question Mark, x, and u Reaches
Expand your typing vocabulary by mastering four more key reaches: the g, question mark (?), x, and u. Just a few more reaches, and you will know how to type the whole alphabet. In this lesson, you will also learn about the function (FN) key and the numbers lock (NUM LOCK) key, which are on most laptop keyboards.
The q, m, v, and Apostrophe Reaches
This lesson teaches you another four reaches for your typing vocabulary: q, m, v, and apostrophe ('). You will also learn how to save a document with a word processing program.
The z, y, Quotation Mark, and Tab Reaches
It's time to add another four reaches to your typing vocabulary: the z, y, quotation mark ("), and tab keys. After this lesson, you will know the reaches to all the alphabetic keys. You will also find out how to open, edit, and resave word processing documents.
Alphabetic Key Review, the 1 and 8 Number Reaches, and Timed Writings
Are you ready to improve your skills and learn some new ones? After you review the z, y, x, q, v, quotation mark, and CAPS LOCK keys, you will learn the reaches to the numbers 1 and 8. Then you will take timed writings in the Key Pro 5 word processor.
Number Reaches, Deleting Text, and Alphabetic Key Review
What's the difference between the DELETE key, the BACKSPACE key, and the Cut command? By the end of this lesson, you will understand how and when to use these three editing tools. You will also continue to improve your skills with the alphabetic keys, plus you will learn more number reaches: 5, 0, 2, and 7.
Number and Symbol Reaches, Number Rules, and Key Review
When should you spell out numbers (like this: one, nine, five hundred), and when should you write them as figures (1, 9, 500)? You will also continue to improve your skills with the keys you have already learned, and you will finish the number reaches by mastering 4, 9, 3, and 6. Then you will learn two symbol reaches: the dollar sign ($) and the hyphen (-).
Symbol Reaches and Skill Building
You have already mastered some of the symbols and punctuation marks. In your last lesson together, you will meet the rest of the symbols. You will also work on your accuracy and speed with the Key Pro 5 Skill Building lessons. And you will find out how you can continue to hone your keyboarding skills long after you have finished this course.
What you will learn
Learn how to create, edit, and save word processing documents
Improve your typing speed and accuracy
Learn posture tips to minimize fatigue and help prevent carpal tunnel syndrome
How you will benefit
Successfully take a timed writing test during a job interview
Become more confident in your ability to type quickly and accurately
Kathy Van Pelt
Kathy Van Pelt has taught computer courses at a community college for the past 25 years. She specializes in Microsoft Office applications, Google Drive and Google Applications, the Windows and Mac operating systems, and keyboarding. She spent seven years teaching word processing and business classes at a private business college and loves being in the ever-evolving educational field.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Take your Microsoft Excel 2016 skills to the next level as you master charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Excel functions.
In this hands-on course, you will learn how to create informative, eye-catching charts and graphs, and harness the power of Excel's data analysis tools and AutoFilter commands. In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other time-saving functions to your repertoire.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Microsoft Office Home and Student 2016 (not included in enrollment).
Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Harness the power of Excel and become a master user of this powerful program. This hands-on course will provide skills using charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2016 functions.
Excel Charts and Graphs
In your first lesson, you will discover why Excel 2016 is such a powerful charting tool. To you, a workbook's numbers might tell an interesting story; to others, that story may not be obvious. You will learn how to choose the right chart for your story and then how to create, format, and edit your chart.
More Excel Charts
This lesson continues exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they may not be well-known, these options can add tremendous value to your worksheets in the right situations.
AutoFilter and Sorting
Working with data in Excel can be quite easy when you know about the tools that are available in a table format. One of these great tools is the Auto Filter command. This lesson will teach you how to use Auto Filter to limit your table information to just the records you want.
Goal Seeking
Learn how to use Solver to solve a complex problem based on the criteria and constraints that you provide it. You'll also explore in detail how to create all three types of Sparklines, as well as formatting options for each and gain the skills to create dashboard-like mini charts sure to make you the envy of your office.
PivotTables
Find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Then, receive a quick overview of all the categories of functions and the different methods you can use to create them.
Advanced PivotTables
Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. This lesson takes a tour through some of Excel's more advanced techniques, like the PivotTable filtering tool Slicer. You will also learn how a PivotTable can serve as your source for the PivotChart.
Solver
Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you will learn how to use Solver to solve a complex problem based on criteria and constraints.
Sparklines
There's nothing more exciting than learning how to master a new feature in Excel. This lesson focuses on creating three types of Sparklines, as well as formatting options for each. By the end of the lesson, you will have the skills to create dashboard-style mini charts.
Macros
In this lesson, you will find out how to use macros to turn repetitive and often time-consuming tasks into automated Excel functions. You will also learn how to record a macro that performs a task in seconds with the click of a button.
Introduction to Functions
If you have used Excel for a while, you know there are hundreds of functions at your disposal. The last three lessons of this course will cover how and why you would use these functions. This lesson introduces creating various functions with the Text category.
Math/Trig Functions
Next to learning how to create macros, most students want to learn as much as they can about Excel functions. This lesson covers on more complex functions of the "Math & Trig" category, focusing on the SUMIF and COUNTIF functions in particular.
VLOOKUP, INDEX, and MATCH Functions
Since functions are such an integral part of using Excel, your final lesson will cover advanced features. In this lesson, you will learn how to use the VLOOKUP, INDEX, and MATCH functions.
What you will learn
Master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2016
Learn to create useful and eye-catching charts
Discover how to manipulate data with the push of a button
Add the time-saving functions of advanced Excel users to your repertoire
How you will benefit
Take your Excel 2016 skills to an expert level and become a more productive member of your organization
Gain indispensable skills that will be useful in any organization that relies on numbers-based reporting
Learn to fully harness the power of Microsoft Excel 2016 and use all of its capabilities to save time and money
Chad Wambolt
Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn how to use the more advanced features of Microsoft Word 2016 (now available through Office 365) including how to add graphics, use templates, and merge data.
Go beyond the basics of word processing and master the more advanced features of Microsoft Word 2016 (now available through Office 365). In this course, you'll learn how to automate Word 2016 using shortcuts to help you write more while typing less. From signs, newsletters, and greeting cards to long documents, you'll learn how to create whatever you need—quickly and with professional-looking results.
You'll also learn how to create and organize text in tables, mix graphics and text together to turn Word into a simple desktop publishing program, and merge spreadsheet and database data to create mailing labels and form letters. Along the way, you'll go through lots of examples and exercises so you can see how Word's advanced features work; but more importantly, you'll see how you can use these advanced features at home and on the job. By the end of this course, you'll know how to use Word more effectively and take advantage of its many features so that you can get your work done quicker and easier than you ever thought possible.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Master the advanced features of Microsoft Word 2016 and create truly professional looking documents. This hands-on course will help you learn how to create an index, build a list of figures, design a table of contents, do desktop publishing, perform a mail merge, and use timesaving shortcuts.
Shortcuts and Time-Savers in Word 2016
Humanity has come a long way since the days of the typewriter. What used to take hours can now be done in seconds with Microsoft Word 2016. And the less time you spend typing, the more time you can spend being creative and having fun. In this lesson, you'll learn shortcuts in Word that can help you create documents faster and more accurately than ever before. Not only will these shortcuts save you time, but they'll help you create letters and reports more easily than you might have thought possible.
Text and Paragraph Formatting Methods
What you write is half of communication. The other half is getting people to read what you write. One way to make your writing more appealing is to make it look presentable with formatting. Of course, formatting text is easy, but applying different types of formatting over and over again can get tedious. That's why, in this lesson, you'll learn a fast and easy way to format chunks of text quickly and consistently using something called styles. You'll find out what a style is, how to apply it, and more important, how to create and save your own styles to use in any document. By the end of this lesson, you'll be able to make any document look presentable with just the click of your mouse.
Templates
If you've ever baked cookies, or even just watched someone else do it, you know how difficult it can be to make all the cookies in a batch look exactly alike. Some turn out big, some small, some gooey, and some burned! However, if you use a cookie cutter, you can make identically shaped cookies every time. That's the same principle you'll learn in this lesson; instead of using a cookie cutter, though, you'll use something called a template. A template stores the formatting of a document so that you can apply it to another document. Templates let you format entire documents as easily as formatting a single word. Word offers lots of convenient templates stored right on your computer or available over the Internet, and you'll also find out how you can create your own.
Graphics: Part 1
They say a picture is worth a thousand words, so what better way to spice up your documents than by adding pictures? In this lesson, you'll learn how to add your own digital photographs to a document so that you can show everyone your vacation pictures, family holidays, or just interesting sights you've captured with your own camera. In addition to adding your own photos, you can also add clip art from Word's massive library of free graphics. And you'll find out how to resize, rotate, and style your pictures, as well as wrap your document text around them. By the end of this lesson, you'll see why Word documents are about much more than words!
Graphics: Part 2, and Columns
Digital photographs and clip art are just the beginning of what you can do with graphics in Word. In this lesson, you'll discover how to add a variety of informational graphics, including charts, graphs, and WordArt, which allow you to display text as a graphic image. Not only will you learn how to add these graphics, but you'll also find out how to edit them when your data changes. You'll finish off the lesson by seeing how Word allows you to format documents with multiple columns—a handy skill for creating newsletters and publications!
Sections and Notes
Do you often create long documents? If so, you'll appreciate this lesson, which shows you how to divide a large document into parts called sections. Sections allow you to format part of a document a certain way without that formatting affecting the rest of your text. For example, you may want headers and footers to appear on some pages but not others. Sections make this easy! You'll also spend some time inserting footnotes and endnotes in a document. If you need to write research papers or other academic content, Word makes it a snap to add and format these previously pesky notes!
Tables
If you've ever seen a spreadsheet, you know how rows and columns let you organize numbers and text on the screen. Well, tables do the same thing in Word. In this lesson, you'll see how to create tables of all different sizes right in a Word document! The lesson will cover how to modify tables, too. And don't think Excel users get to have all the fun—you can even enter formulas to perform calculations in your tables, sort them, and style them for a customized look. Your data has never looked so appealing!
Envelopes and Odd-Size Pages
You probably print most of your documents on standard letter-size paper. While this is great for ordinary letters or business reports, sometimes you may want to get creative with your paper sizes. But then there's the trouble of printing. In this lesson, you'll see how you can define the dimensions of the paper you're using, so Word will print everything correctly. You'll also learn how to print names and addresses directly on envelopes of any size. After this lesson, you won't feel confined to boring 8 1/2 x 11-inch paper anymore!
Desktop Publishing: Part 1
As you've probably already figured out, Word can do more than write letters. It also functions as a simple desktop publishing program for creating greeting cards, calendars, or newsletters. In this lesson, you'll find out how text boxes are the key to simple desktop publishing and see how other elements come into play in customized documents. Along the way, you'll look at business cards and greeting cards to get a feel for how desktop publishing works. If you've always wanted to create a document that combines text and graphics in an artistic or visually appealing way, you'll find out how to do that and much more.
Desktop Publishing: Part 2
With the basics down, it's time to take your desktop publishing skills to the next level. In this lesson, you'll discover the magic of linked text boxes that give you the power to move your text anywhere you want on the page and keep it flowing. You'll see how to create, position, resize, and group text boxes so you have total control over your text.
Merging Data with Documents
Have you ever received one of those "personalized" letters from a company in the mail? You can be sure that nobody typed the entire sales letter from scratch. Instead, the company used a form letter and something called mail merging. In this lesson, you'll learn how to store long lists of names and addresses that you can use over and over again in a form letter. Just create a document once, leave blanks for inserting information such as names and addresses, and let Word personalize each letter for you. Now you, too, can create personalized letters for business or personal use, such as sending out holiday greetings to family members and friends.
Final Touches
Look in most books, and you'll find the table of contents at the beginning and an index in the back. Often, these are the last components added to a document, since they need to have accurate titles and page numbers. But Word takes a lot of the tedious work out of creating these components. In this final lesson, you'll see how you can use Styles to make creating the table of contents a snap, and then explore how to tag index terms so Word knows what page they're on, even if they move later. Word can also help you keep track of any figures, such as charts, illustrations, or graphs, in your document. By letting Word worry about the details, you can create an accurate table of contents, index, or list of figures with very little extra effort on your part. These finishing touches will make your most important documents shine!
What you will learn
Learn how shortcut keys, macros, and the AutoCorrect feature can save you time
Discover fast ways to format text in a document
Find out how to insert graphic images, including clip art and photos, into your documents
Add charts, SmartArt, and WordArt to a document, and divide any document into columns
Practice dividing a long document into sections and using footnotes and endnotes
Get acquainted with some of Word's desktop publishing features, such as using text boxes, layering, and aligning objects
Learn how to link text boxes, and position them in a document to create brochures and newsletters
Use mail merging to quickly and easily personalize form documents
How you will benefit
Master the more advanced features of Microsoft Word
Learn how to use Word more effectively and take advantage of all its many features so you can get your work done more quickly and more easily
Wallace Wang
Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn to use the basic features of Word 2016 (now available through Office 365) to type, edit, format, spell check, and print professional-looking documents, letters, and reports.
One of the most basic skills needed in any job is writing reports and letters using Microsoft Word 2016, now available through Office 365. In this course, you will gain the foundational skills you need to make the most of this powerful program.
Through hands-on instructions, you will learn how to add and edit text; move words from one part of your document to another; work on two or more documents simultaneously; and format your text. You will also see how to save, retrieve, copy, organize, and print your documents.
You will learn dozens of ways to modify the appearance and content of your documents by adjusting page margins, paragraph tab settings, and line spacing to create great-looking documents quickly and easily. If you need to type foreign language characters or symbols, you can do that in Word too.
By using Word's spell and grammar checker, you can catch typos and grammatical mistakes before you print or share your document with others. You will also explore the program's thesaurus feature, which can help you find exactly the right word. By the time you're done with the step-by-step lessons and hands-on activities in this course, you will be able to use Word confidently at home or on the job.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Microsoft Word is used in nearly every modern workplace. In this course, you will master all the basics of this powerful word-processing program, including how to type and edit text, and how to format, spell check, and print documents. You will also learn dozens of different ways to modify the appearance and content of your documents and how to catch errors with Word's spell and grammar checker. After completing the course, you will be able to use Word confidently at home or on the job.
Getting Started
In this introductory lesson, you will learn how to use the different parts of Word 2016's user interface, how to look at your document from different types of views, how to zoom in and out to magnify or shrink your text, and how to change the margins of individual paragraphs.
Typing and Navigation
The whole purpose of Word is to let you create and edit text. This lesson introduces the basics of moving the insertion point and deleting text. By knowing the pros and cons of navigating through a document with the keyboard and mouse, you can use both to help you work faster in Word.
File Management
In this lesson, you will learn how to save the documents you create in Word. You will also learn how to rename, copy, and even delete any files you have created, so you will always be in complete control of all the files you create.
Editing Text
After you've typed some text in a Word document, you may need to edit that text. This lesson focuses on editing text. The easiest way to edit text is to delete it, but a more sophisticated way to edit text is to copy text and paste a duplicate of that text in another location.
Working With Multiple Documents
Most people use Word to view and edit a single document at a time, but Word actually lets you open and view two or more documents at the same time. This lesson will teach you how to open, switch between, and view multiple documents.
Text Formatting and Alignment
Once you know how to add, delete, copy, and move text, the next step to modifying your document is to change the physical appearance of your text. You can make text appear in different colors or background highlighting, change text size and alignment, and even modify fonts.
Printing
Most people use Word to print letters and reports. In this lesson, you will learn about the different ways you can print a document, such as portrait orientation or landscape orientation. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents.
Margins, Tabs, and Page Numbering
By knowing how to set and use margins, you can modify an entire document or just a single page. By using tabs, you can modify how individual paragraphs look on a page. Finally, you will also learn how to add page numbers to the top or bottom of a page to keep track of page order.
Paragraph Formatting
Word provides ways to change the appearance of a paragraph's first line, line spacing within a paragraph, and line spacing between paragraphs. In addition, Word lets you create bullet and number lists, so you can display short bits of information in a visual manner.
Language Tools
For important documents, you may even need to collaborate with others. To keep track of all the changes multiple authors may make to a single document, Word offers a Track Changes feature, so you can see exactly what and who changed the document.
Customizing Word
With Word, you can press different types of keystrokes or search and click the symbol you want to use. This lets you add practically any type of unusual character to your documents. Word lets you type practically anything you want, regardless of the limitation of the keys on your keyboard.
Making a Word Document Pretty and Organized
Finally, you can use outlines to organize your text and quickly move chunks of text within a document just by rearranging an outline heading. By learning these advanced features of Word, you can make each document display text in the most appealing way possible.
What you will learn
Learn the fundamentals of one of the most crucial software applications in the modern workplace
Acquire the skills and learn the tools you will need to adjust margins, spacing, layout, and design of any Word document
Learn how to work on multiple projects at once and become faster and more efficient in a variety of Microsoft Word tasks
Explore the many ways to modify the appearance of your documents in order to suit your individual needs
How you will benefit
Gain the confidence you need to make the most of this indispensable software application
Learn how to make the perfect layout for useful documents of any occasion - resumes, invitations, letters, articles, training materials, and much more
Save time and avoid frustration by familiarizing yourself with the wide variety of tools at your disposal in Word 2016
Become more proficient and efficient at one of the most widely used software programs in history
Wallace Wang
Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
This hands-on, project-oriented course is filled with easy-to-follow, detailed step-by-step instructions that teach you how to edit and manipulate images and create elemental compositions using Photoshop in the Creative Cloud. Discover how to improve photographs by editing out flaws, correcting poor exposure, or creating a composite image using the newest techniques.
Photoshop is the world's most popular photo-editing program. Artists, photographers, designers, and hobbyists all rely on Adobe Photoshop for image creation and editing. The Introduction to Photoshop CC course provides meticulous instructions that will teach you how to use Photoshop Creative Cloud with confidence.
Photoshop Creative Cloud has a host of impressive new features, and you will encounter a number of them throughout the course. You will be editing your own photographs to get rid of dust and scratches, fix the color, and correct image exposure. Then you will learn how to colorize parts of an image and how to create simple digital paintings. You will master techniques for switching the backgrounds on images and removing wrinkles and blemishes from photos, just like they do in magazines.
You will also learn about the content-aware Move tools that, like magic, let you move something on an image and intelligently replace the "hole" left behind at the same time. By the time you finish this fun, hands-on, project-oriented course, you will be well on your way to expressing yourself with the most exciting graphics program ever developed.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC or Mac.
Software Requirements:
PC: Windows 10 or later.
Mac: macOS 10.14 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
Adobe Photoshop CC, Adobe Creative Cloud, or any version of Adobe Creative Suite CC that includes the Adobe Photoshop CC or Photoshop only (not included in enrollment).
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Whether you are a photographer, digital illustrator, graphic designer, or someone who wants to alter old family photos, you need to learn Adobe Photoshop. The Introduction to Photoshop Creative Cloud course is filled with easy-to-follow, detailed step-by-step instructions that teach you how to edit and manipulate images and create basic compositions using Photoshop in the Creative Cloud. Discover how to improve photographs by editing out flaws, correcting poor exposure, or creating a composite image using the newest techniques Photoshop has to offer. You will even learn how much fun you can have digitally painting and exploring filters and effects to create unique images. And, best of all, you need no prior artistic ability or Photoshop experience to take this course.
Getting to Know Adobe Photoshop
Whether you're an aspiring graphic artist or a weekend photographer, Photoshop can play many roles in image creation. Even if you've never touched Photoshop before, you'll become familiar with Photoshop's interface and 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 how to crop an image to its desired image area.
Understanding Resolution and Layers
In this lesson, you'll learn and apply the basics in setting image resolution by resizing and resampling graphics for both screen and print purposes. Then, explore the wonders of working with layers. Move and transform objects within a scene to recreate a new composition. You will learn how to add, delete, hide, merge, and group layers as well as to change the blending mode of a layer to reveal new visual effects.
Working with Objects
What makes a good image composite? Find out in this lesson where you will discover the principles of image compositing and apply these by combining images to create your first image composites. Find out how linked layers work and see what Smart Objects can do. You will learn how to use guides to assist in placing and aligning objects. Then, you will use multiple images to create a realistic still-life image. Learn how to transform objects by scaling, rotating, distorting, and warping them.
Image Adjustments
Do you have an old image that has faded over the years? Are your vacation photos over-exposed or too dark? Use image adjustments to correct contrast and color! In this lesson, you will find out how to correct an image's contrast and make the colors pop using image adjustments. You can even remove color to make a black and white or toned image. Then, apply several image adjustments along with blending modes to create a surreal image! Finish this lesson by exploring the filters gallery to apply various artistic filters to a collage.
Image Retouch and Restoration
Need to clear up a few blemishes on a headshot? Or remove unwanted telephone wires from a landscape? This lesson introduces you to the tools used in photo retouching and restoration. This lesson also covers sharpening an image, blurring areas of an image to create a depth of field, and adding a vignette to an image. You will learn how to easily clear up blemishes in portraits and restore old, damaged photographs. You will also learn how to remove or duplicate objects in a scene.
Colorizing Images
Learn how to combine colors and create color themes using Adobe Color. Sample colors from an existing image to create a new color scheme. Then, apply color to black and white photos using several techniques to color areas. Color a single object in a black and white image to create emphasis, or color the entire image, as if filling in a "digital" coloring book. This lesson also covers how to save and load swatches of color to use on other projects.
Working with Brushes
Adobe Photoshop is one of the leading applications for digital painting. This lesson introduces you to brushes and teaches you to paint using different brush types to simulate real artists' materials, such as charcoal, pastels, oil paint, and watercolor. You do not have to have strong drawing skills to complete this lesson. You will sample color from existing images and use these as templates for your digital painting.
Working with Selections
One of the most basic skills you need in Photoshop is the ability to select areas of an image. Often, you'll want to make adjustments to or fine tune areas of a photograph. The act of editing an image, no matter the desired outcome, is based heavily on your ability to make good pixel selections. In this lesson, you will learn how to use the various selection tools and to use them to create convincing shadows to objects in a composition.
Working with Masks
Masks can hide or reveal parts of a layer. Learn to use masks with images and adjustment layers to advance your image manipulation skills. Learn to use and modify masks to create complex selections around objects with thin strands of hair and clipping masks to add textures to objects.
Working with Vectors
Photoshop is able to create vector shapes and paths, which are used across many Adobe products, so learning these tools can put you ahead of the game when you are learning software such as Adobe Illustrator. This lesson is designed to guide you through the technical tools in a way that is easy to grasp.
Type and Layer Effects
Want to create an invitation or promote an event? This lesson shows you how to apply typography with images to create effective design by utilizing Adobe Fonts, manipulating text using warping, typing on a path, or typing as a mask to place an image within the letterforms. Then, polish the look of your text with layer effects. This lesson will introduce you to a world of limitless type effects.
Preparing Files for Output
Understanding what file formats to use and when can be confusing. This final lesson covers file types and when to use them. Learn how to prepare files for both print and web output. You will also learn how to create a Behance portfolio page to showcase and promote your work!
What you will learn
Master the fundamentals of Photoshop's interface and tools
Understand the essentials of digital imaging including file formats, color modes, image size, and resolution.
Comprehend and apply digital color theory and practice colorization and digital painting
Identify and apply the methods of photo retouch and restoration
Use the functionality of Photoshop's layers, selections, and masking features
How you will benefit
Discover everything you need to confidently use the tools in Photoshop to restore, retouch, and rearrange images
Develop the skills you need to begin a new hobby or entry-level career using Photoshop
Learn to effectively retouch photos and develop professional quality images for your home or business
Harness the power of Photoshop to create stunning images by enhancing photographs and developing works of art
Beverly Richards Schulz
Beverly Richards Schulz is an award-winning photographer and graduate of the New York Institute of Photography. She holds a Bachelor of Arts in Legal Studies from UC Berkeley and a master's degree in Adult and Continuing Education. For the past 10 years, Schulz has taught at the University of San Francisco. With more than 15 years teaching experience, she has written over 30 digital photography and digital editing courses. She co-authored the book "Photoshop Elements 14—What's New?"
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn to use QuickBooks Online to record income and expenses; enter checks and credit card payments; track your payables, inventory, and receivables; and much more.
This QuickBooks course will teach you how to manage your business finances with QuickBooks Online. This powerful accounting software has helped millions of small business owners oversee their finances. Now that the cloud-based version is outpacing the desktop version, there's no better time to refresh your QuickBooks knowledge.
You will learn to use key features of QuickBooks Online and gain hands-on experience creating invoices, receipts, and statements; track payables, inventory, and receivables; generating reports; and more. Whether you're new to QuickBooks or need a quick refresher, this course will empower you to take control of your business's financial accounting, all with the ease and convenience of an online platform.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC or Mac.
Software Requirements:
PC: Windows 10 or later.
Mac: macOS 10.11 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
When your course starts, you will be directed to access and utilize the free QuickBooks Online practice site to complete the lesson and assignment steps. You do not need to purchase a subscription or additional software to complete this course. However, please note that this course is suitable only for the QuickBooks Online version. The desktop versions of QuickBooks are not compatible with this course and should not be used. If you have the desktop version, you should consider registering for the course specifically designed for your version.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Manage the financial aspects of your small business quickly and efficiently using QuickBooks Online. This course will give you hands-on experience recording income and expenses; entering checks and credit card payments; tracking your payables, inventory, and receivables; and much more.
Getting Started
Your first lesson will introduce the QuickBooks Online interface and the pros and cons of working with your accounting information online. You will learn about the various subscription packages and practice using some of the interactive navigation features within the program.
Accounting Basics
To truly unlock the power of QuickBooks Online, it's helpful to have some basic accounting knowledge under your belt. In this lesson, you'll learn some introductory accounting terminology. In addition, you'll learn the basics of double entry accounting principles as well as the components of the Financial Statement.
The Chart of Accounts
The Chart of Accounts is the heart and soul of QuickBooks. In this lesson, you will 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
This lesson introduces best practices for using centers and lists in QuickBooks to gather and organize information needed to properly conduct business. You will also learn how to process Form 1099 to give to your vendors at the end of the year.
Bank Accounts
In this lesson, you will learn how to work with bank accounts in QuickBooks Online. You will learn how to create a new bank account, connect it online, and download, match, and add transactions. Then you will 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
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 will learn how to utilize QuickBooks' built-in features to enter check transactions and bank transfers like a pro.
Paying Bills
Without an organized system for managing all the bills your business receives, they can really start to stack up. When bills pile up, it becomes easy to start missing payment deadlines, which can result in late fees and credit difficulties. In this lesson, 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.
Credit Cards and Loans
In this lesson, you will learn how to effectively manage Credit Card accounts in QuickBooks Online. You will also learn how to enter a full or partial payment of the credit card balance when it comes time for payment. Finally, you will 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
You will find this lesson useful if your business ever sells a product or service and collects payment on the sale immediately. Then you will learn how to create multiple Sales Receipts and make the necessary deposit to your bank.
Invoices and Estimates
In order to evaluate just how well your company is performing, you will need to learn how to enter estimates, invoices, and customer payments. You will do just that in this lesson. You will also learn how to group multiple customer payments and record those deposits to the bank.
Billable Expenses and Customer Credits
This lesson focuses on billing customers for an expense incurred on a project or job. You will even see how you can add a markup percentage to the amount you include on the customer invoice. Also, you will examine the steps needed to enter credit memos, delayed credits, and refunds.
Sales Taxes and Reports
In your final lesson, you will learn how to work with the sales tax features in the program to collect and remit taxes you collect from customers. You will also find out how to create, use, and customize a wide variety of useful reports.
What you will learn
Learn everything you need to know about running QuickBooks in a small to mid-sized business
Discover how to set up a chart of accounts, reconcile your checking account, and create estimates
Learn to create and print invoices, receipts and statements
Understand how to track payables, inventory, and receivables
Gain the knowledge you need to generate reports
How you will benefit
Get access to Intuit's Test Drive Sample Company practice site of QuickBooks Online Plus
Get hands-on experience as you master the tools you will need to successfully use QuickBooks online
Gain the confidence to take control of the financial accounting for your business
Scott Paxton
Scott Paxton is a Certified Public Accountant and holds master's degrees in business administration and accounting. His background includes experience as a public accountant, a manager in the banking industry, an entrepreneur and a college business instructor. Paxton has also spent much of his career helping small business owners successfully implement and troubleshoot QuickBooks.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn the key concepts of SQL (Structured Query Language) the powerful and standard database management query language for relational databases.
Learn the key concepts of SQL (Structured Query Language) the powerful and standard database management query language for relational databases.
SQL (Structured Query Language) is one of the best programming languages for beginning web developers to learn. This course will teach you the basics of designing and writing SQL queries to execute on a practice database. Using a SQL Server Express, you'll learn several real-world applications for SQL so you can put this valuable skill set on your resume.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. Macs are not compatible.
Dual monitors are helpful but are not required.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
Software must be installed and fully operational before the course begins. Student will install the required software in the course.
Other:
Email capabilities and access to a personal email account.
Necessary rights (local administrative rights) to install programs on the computer.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
SQL Server Express
SQL Server Management Studio
Gain a solid working knowledge of the most powerful and widely used database programming language. This course will provide you the skills to write SQL queries to create tables, retrieve data from single or multiple tables, manipulate data in a database, and gather statistics from data stored in a database.
Introduction to Database Design and SQL
In this introductory lesson, you will examine database terms and concepts. Understanding the purpose of a database is foundational to writing efficient SQL queries that retrieve the right data.
SQL Server
In this lesson, you will install SQL Server Express and the SQL Server Management Studio to use throughout the course in your learn-by-doing practices. You will use SQL code to create one of the tables for the practice database in SQL Server.
Retrieving Data Result-Sets
SQL queries are the statements used to retrieve data from the database. Queries are written in a specific, logical order. In this lesson, you will explore various ways to write SQL queries to retrieve data that meet defined criteria.
Sorting Data
SQL queries are defined and written to retrieve data in a certain order. Queries are also written to limit columns and to filter data rows. In this lesson, you will practice writing queries that meet defined criteria and retrieve the expected result-sets.
Designing SQL Data Tables
This lesson is about designing SQL data tables for a database. You will explore the relationship concept and how it is used in an RDBMS. You will define tables that are structured according to RDBMS standards. You will also create the tables to add to your practice database.
Designing Data Rows
In this lesson, you will add data to your newly defined tables. You will explore several methods of adding data to a table and practice writing and executing these query statements. After adding several individual rows to the tables, you will use a SQL query to populate your tables with enough data rows to use in the learn-by-doing practices in this course.
Getting Data From Two Tables
SQL JOIN statements are used to retrieve data from more than one table. In this lesson, you will practice writing JOIN statements that retrieve data from tables that have a relationship between their PKs and FKs.
Retrieving Data From Multiple Tables
In this lesson, you will continue writing JOIN statements that retrieve data result-sets from more than one table. You will also examine how and when to use SQL subquery statements to retrieve data from multiple tables. You will practice defining and writing JOIN and subquery queries.
Keeping the Database Up to Date
The quality of the data in the database depends on its integrity, including the concepts of data accuracy and consistency. In this lesson, you will explore writing queries to maintain the database so that it is up to date with data that is accurate, consistent, and has integrity.
Aggregate Functions
In this lesson, you will examine the concept of aggregate functions and how they are used in query statements to examine multiple rows. Aggregate functions are a method of retrieving summarized data that is useful for analysis.
SQL Views
SQL views are an important concept in database design and in using databases. In this lesson, you will explore designing and writing queries to create views. You will also explore the reason they are valuable for database security and database access.
Maximize Database Integrity and Performance
Constraints are one way to maximize the integrity of the database and minimize the opportunity for user error. Indexes are used for increasing the performance of a data query. In this lesson, you will explore both these concepts.
What you will learn
Use SQL to develop a relational database
Design table and row structures that fulfill your requirements
Write efficient SQL queries to find and organize data
Write SQL queries to retrieve data from multiple tables
Create updates for a secure, high-performance database
How you will benefit
Gain confidence in your SQL ability, the standard database query language
Open the door to opportunities as you list basic SQL programming as a skill on your resume
Develop a new skill and learn whether or not you would like a career in IT
Mava Wilson
Mava Wilson, Ph.D., is a professor with more than 28 years of teaching experience. While she specializes in Information Systems (IS), she has taught several computer science topics, including basic computer literacy, programming, database design, and SQL. She holds a Ph.D. and master's degree in computing technology from Nova Southeastern University, as well as a bachelor's in administrative systems from Radford University.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
In this course, you will learn to use Windows 11, a powerful new operating system, including customizing your desktop, managing files and folders, and navigating the web with the latest Microsoft Edge browser.
File Explorer can help you manage your files and create text documents using WordPad. From managing files and editing photos to working with external drives, you will learn everything you need to know about getting the most from this operating system. Additionally, since security is essential, you will also learn how to protect your files and protect and update Windows 11.
By the time you finish this course, you will have mastered the basic skills you need to get the most from Windows 11 for both work and play.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC or Chromebook. Macs are not compatible.
Software Requirements:
PC: Windows 11 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Master the basic skills you need for Windows 11, the new operating system from Microsoft, which offers a more robust, more powerful, and unique computing experience. In this course, you will gain the foundation you need to start using Windows 11.
Welcome to Windows 11
Learning to use your PC well starts with learning to use Windows. In this first lesson, we'll start with the basics that every computer user must know in order to use a computer with minimal frustration. If you've been working in "frustration and aggravation" mode for a while, this lesson will take care of that. We'll start by talking about what Windows 11 is and why you want to learn it. Then, we'll get right into the most important skills and terminology that allow you to control what you see on your screen at all times. And that's important, because the first step to using anything that's in your computer is getting it on the screen where you can see it!
Use the Start Menu and Apps
In this lesson, we'll explore the revised Start Menu and Apps in Windows 11. You'll see how to use and customize the Start Menu, and we'll explore the Windows Store. You'll also see how to use the new widgets feature of Windows 11, which gives you access to quick and easy information, such as weather, traffic, sports, and news.
Personalizing Your Windows Desktop
In today's lesson, you'll have fun personalizing your computer by choosing your own desktop pictures, themes, and sound scheme. Along the way, you'll learn about the important Control Panel window in Windows 11 and tips for using dialog boxes and those occasional mysterious dimmed options that do nothing when you click them. The skills you learn in this lesson will go a long way to helping you gain complete control of your computer.
Working With Text and Files
No matter how you intend to use your computer, there'll be times when there's some typing involved. It might be for writing email messages, memos, or letters, or it might be for taking notes in a course, or for chatting with others in a website. Whatever the reason, today's lesson will teach you all the tricks for making typing (and editing) quick and easy. And you'll also discover how to save your work in files and folders, so it'll always be there when you need it!
Exploring Your System
Everything that's in your computer is stored on its hard drive. The hard drive is like a filing cabinet containing files organized into folders. Finding things you've saved in the past is a matter of opening the filing cabinet, so to speak, and then locating the correct folder. You'll use the File Explorer program to accomplish this. And in this lesson, you'll learn how it all works, so you can start gaining complete mastery of your own files and folders.
Using OneDrive, Microsoft Teams, and Microsoft To Do
In this lesson, you'll explore three Windows 11 features: OneDrive, Teams, and To Do. OneDrive is a cloud storage solution that lets you store files and folders both on your PC as well as the Microsoft cloud. Using OneDrive, you can save your data to Microsoft servers and access that data across multiple devices. Teams is communication software that is built into Windows 11. Using Teams, you can chat with friends, family, and co-workers and even host video and audio calls. Finally, you'll take a look at Microsoft To Do—an app that helps you keep track of to do tasks and lists. All of these features are designed to make your life easier!
Manage and Edit Your Photos
In this lesson, we'll have some fun with photos. Today, you'll learn how to organize your photos and view them using Windows 11's Photos App. You'll also see how to view individual photos, draw and rotate, and auto-enhance your shots. And, you'll learn about the Photos App editing tools for adjusting brightness and contrast, straightening crooked pictures, correcting red eye, and cropping.
Using Edge
The Internet is home to popular websites like Facebook, Amazon, Google, ed2go, and many others. Many of you have seen references to .com sites in ads and elsewhere. If you don't have a lot of computer experience, you might find it difficult to get to the many things you hear about on the web. But not after this lesson! In this lesson, you'll learn how to use Edge, the program that provides access to all of those popular websites.
Managing Files and Folders
Managing files and folders is one of those computer skills that every computer user needs to know. In many work and school environments, people just assume you know how to manage files, and they rarely provide any details on how to accomplish things like copying, moving, or renaming files and folders. Today's lesson will explain how to do those very things that others assume you already know how to do.
More Fun With File Management
In this lesson, you'll expand your file management skills by learning how to delete and recover files. You'll learn how to select multiple files to work with, so you don't always have to manage your files one at a time. And we'll discuss how to copy files to and from removable media like flash drives, CDs, and DVDs.
Protect Your Valuable Files!
Your computer is an investment of money, and the pictures and other files you store on your computer are an investment of time. You might even have some photos or other files that are so precious the thought of losing them causes you anxiety. What you need to do is protect those files. And that's just what this chapter is all about—how to use the tools and techniques that are built right into Windows to help you protect your valuable time and files!
Tips, Tricks, and Shortcuts
In our final lesson, you'll learn some more techniques for protecting your computer, including using resources for free protection from viruses and spyware. You'll learn how to remove programs you no longer want or need. You'll learn how to copy and paste text and create screenshots. And you'll discover some great timesaving tips and shortcuts, as well as resources for helping yourself so that you don't have to be so dependent on others.
What you will learn
Find your way around Windows 11 with the desktop, Start menu, and system settings
Understand how to customize features and personalize your desktop
Discover how File Explorer can help you manage files and learn to create basic text documents using WordPad
Comprehend how to protect your files and update Windows 11
How you will benefit
Gain confidence in your use of the Windows 11 operating system for personal and business use
Learn how to use your PC effectively, starting with Windows
Experience reduced frustration and setbacks by learning to operate your computer properly
Become a more independent computer user
Curt Simmons
Curt Simmons, B.A., M.Ed, is a best-selling author, trainer, and multi-media expert. He holds degrees in English and communication studies and has more than 10 years of experience teaching English and writing in the classroom. Additionally, Simmons has authored numerous books on a wide variety of technology topics and has been a technical editor for numerous other titles.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn how to touch-type or improve your existing typing skills using Keyboarding Pro 5.
If you want to learn touch-typing or improve your existing typing skills, this is the perfect course for you! In these lessons, you'll use the Keyboarding Pro 5 program, a typing tutorial designed for personal computers, to learn how to touch-type—that is, to type text you read from a printed page or a computer screen without looking at your keyboard.
With the skills you master here, you'll become faster and more confident at the keyboard. By the end of the course, you'll know how to touch-type the alphabetic, numeric, and symbol keys; create, save, and edit word processing documents; and successfully take a timed writing test during a job interview.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. Mac, Chromebooks, Surface, and all other tablets are not compatible.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
When the class starts, you'll receive instructions for downloading and installing a working copy of Keyboarding Pro 5. Please do not purchase or download the software from another source.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Become faster and more confident at the keyboard. This course will help you learn how to touch-type the alphabetic, numeric, and symbol keys; create, save, and edit word processing documents; and successfully take a timed writing test during a job interview.
Getting Started With Key Pro 5
Your first lesson guides you step by step as you download, install, and set up Key Pro 5. You will also get acquainted with the program, learning about the home row keys and the reach to the "i" key on the QWERTY keyboard. Are you confused about what home row and QWERTY mean? Don't worry—this lesson explains all of that.
Lowercase Letters, Plus the Reaches to the "e" and the "n"
Now that you're getting comfortable with the home row on the QWERTY keyboard, it's time to introduce you to some new keys. This lesson will focus on lowercase letters. You will also use Key Pro 5 to practice the reaches to the e and the n. Is all this typing causing you aches and pains? You will find out how to reduce fatigue while typing.
The Left Shift, h, t, and Period Reaches
In this lesson, you will learn four new keystrokes: left SHIFT, h, t, and period (.). You will also provide some tips on improving speed and accuracy and introduce you to the Key Pro 5 word processor program.
Learn the r, Right SHIFT, c, and o Reaches
Continue to build your keyboarding vocabulary by learning four new key reaches in this lesson: r, right SHIFT, c, and o. You will also learn about "the Zen of typing", which is how touch-typing becomes an instinctive and unconscious action.
The w, Comma, b, and p Reaches
Your typing vocabulary continues to expand rapidly with the addition of the reaches to the w, comma, b, and p. Before you know it, you will be typing complete paragraphs. This lesson also covers what you need to know about carpal tunnel syndrome, a serious and painful condition that you can avoid.
The g, Question Mark, x, and u Reaches
Expand your typing vocabulary by mastering four more key reaches: the g, question mark (?), x, and u. Just a few more reaches, and you will know how to type the whole alphabet. In this lesson, you will also learn about the function (FN) key and the numbers lock (NUM LOCK) key, which are on most laptop keyboards.
The q, m, v, and Apostrophe Reaches
This lesson teaches you another four reaches for your typing vocabulary: q, m, v, and apostrophe ('). You will also learn how to save a document with a word processing program.
The z, y, Quotation Mark, and Tab Reaches
It's time to add another four reaches to your typing vocabulary: the z, y, quotation mark ("), and tab keys. After this lesson, you will know the reaches to all the alphabetic keys. You will also find out how to open, edit, and resave word processing documents.
Alphabetic Key Review, the 1 and 8 Number Reaches, and Timed Writings
Are you ready to improve your skills and learn some new ones? After you review the z, y, x, q, v, quotation mark, and CAPS LOCK keys, you will learn the reaches to the numbers 1 and 8. Then you will take timed writings in the Key Pro 5 word processor.
Number Reaches, Deleting Text, and Alphabetic Key Review
What's the difference between the DELETE key, the BACKSPACE key, and the Cut command? By the end of this lesson, you will understand how and when to use these three editing tools. You will also continue to improve your skills with the alphabetic keys, plus you will learn more number reaches: 5, 0, 2, and 7.
Number and Symbol Reaches, Number Rules, and Key Review
When should you spell out numbers (like this: one, nine, five hundred), and when should you write them as figures (1, 9, 500)? You will also continue to improve your skills with the keys you have already learned, and you will finish the number reaches by mastering 4, 9, 3, and 6. Then you will learn two symbol reaches: the dollar sign ($) and the hyphen (-).
Symbol Reaches and Skill Building
You have already mastered some of the symbols and punctuation marks. In your last lesson together, you will meet the rest of the symbols. You will also work on your accuracy and speed with the Key Pro 5 Skill Building lessons. And you will find out how you can continue to hone your keyboarding skills long after you have finished this course.
What you will learn
Learn how to create, edit, and save word processing documents
Improve your typing speed and accuracy
Learn posture tips to minimize fatigue and help prevent carpal tunnel syndrome
How you will benefit
Successfully take a timed writing test during a job interview
Become more confident in your ability to type quickly and accurately
Kathy Van Pelt
Kathy Van Pelt has taught computer courses at a community college for the past 25 years. She specializes in Microsoft Office applications, Google Drive and Google Applications, the Windows and Mac operating systems, and keyboarding. She spent seven years teaching word processing and business classes at a private business college and loves being in the ever-evolving educational field.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Take your Microsoft Excel 2016 skills to the next level as you master charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Excel functions.
In this hands-on course, you will learn how to create informative, eye-catching charts and graphs, and harness the power of Excel's data analysis tools and AutoFilter commands. In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other time-saving functions to your repertoire.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Microsoft Office Home and Student 2016 (not included in enrollment).
Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Harness the power of Excel and become a master user of this powerful program. This hands-on course will provide skills using charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2016 functions.
Excel Charts and Graphs
In your first lesson, you will discover why Excel 2016 is such a powerful charting tool. To you, a workbook's numbers might tell an interesting story; to others, that story may not be obvious. You will learn how to choose the right chart for your story and then how to create, format, and edit your chart.
More Excel Charts
This lesson continues exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they may not be well-known, these options can add tremendous value to your worksheets in the right situations.
AutoFilter and Sorting
Working with data in Excel can be quite easy when you know about the tools that are available in a table format. One of these great tools is the Auto Filter command. This lesson will teach you how to use Auto Filter to limit your table information to just the records you want.
Goal Seeking
Learn how to use Solver to solve a complex problem based on the criteria and constraints that you provide it. You'll also explore in detail how to create all three types of Sparklines, as well as formatting options for each and gain the skills to create dashboard-like mini charts sure to make you the envy of your office.
PivotTables
Find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Then, receive a quick overview of all the categories of functions and the different methods you can use to create them.
Advanced PivotTables
Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. This lesson takes a tour through some of Excel's more advanced techniques, like the PivotTable filtering tool Slicer. You will also learn how a PivotTable can serve as your source for the PivotChart.
Solver
Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you will learn how to use Solver to solve a complex problem based on criteria and constraints.
Sparklines
There's nothing more exciting than learning how to master a new feature in Excel. This lesson focuses on creating three types of Sparklines, as well as formatting options for each. By the end of the lesson, you will have the skills to create dashboard-style mini charts.
Macros
In this lesson, you will find out how to use macros to turn repetitive and often time-consuming tasks into automated Excel functions. You will also learn how to record a macro that performs a task in seconds with the click of a button.
Introduction to Functions
If you have used Excel for a while, you know there are hundreds of functions at your disposal. The last three lessons of this course will cover how and why you would use these functions. This lesson introduces creating various functions with the Text category.
Math/Trig Functions
Next to learning how to create macros, most students want to learn as much as they can about Excel functions. This lesson covers on more complex functions of the "Math & Trig" category, focusing on the SUMIF and COUNTIF functions in particular.
VLOOKUP, INDEX, and MATCH Functions
Since functions are such an integral part of using Excel, your final lesson will cover advanced features. In this lesson, you will learn how to use the VLOOKUP, INDEX, and MATCH functions.
What you will learn
Master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2016
Learn to create useful and eye-catching charts
Discover how to manipulate data with the push of a button
Add the time-saving functions of advanced Excel users to your repertoire
How you will benefit
Take your Excel 2016 skills to an expert level and become a more productive member of your organization
Gain indispensable skills that will be useful in any organization that relies on numbers-based reporting
Learn to fully harness the power of Microsoft Excel 2016 and use all of its capabilities to save time and money
Chad Wambolt
Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn how to use the more advanced features of Microsoft Word 2016 (now available through Office 365) including how to add graphics, use templates, and merge data.
Go beyond the basics of word processing and master the more advanced features of Microsoft Word 2016 (now available through Office 365). In this course, you'll learn how to automate Word 2016 using shortcuts to help you write more while typing less. From signs, newsletters, and greeting cards to long documents, you'll learn how to create whatever you need—quickly and with professional-looking results.
You'll also learn how to create and organize text in tables, mix graphics and text together to turn Word into a simple desktop publishing program, and merge spreadsheet and database data to create mailing labels and form letters. Along the way, you'll go through lots of examples and exercises so you can see how Word's advanced features work; but more importantly, you'll see how you can use these advanced features at home and on the job. By the end of this course, you'll know how to use Word more effectively and take advantage of its many features so that you can get your work done quicker and easier than you ever thought possible.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Master the advanced features of Microsoft Word 2016 and create truly professional looking documents. This hands-on course will help you learn how to create an index, build a list of figures, design a table of contents, do desktop publishing, perform a mail merge, and use timesaving shortcuts.
Shortcuts and Time-Savers in Word 2016
Humanity has come a long way since the days of the typewriter. What used to take hours can now be done in seconds with Microsoft Word 2016. And the less time you spend typing, the more time you can spend being creative and having fun. In this lesson, you'll learn shortcuts in Word that can help you create documents faster and more accurately than ever before. Not only will these shortcuts save you time, but they'll help you create letters and reports more easily than you might have thought possible.
Text and Paragraph Formatting Methods
What you write is half of communication. The other half is getting people to read what you write. One way to make your writing more appealing is to make it look presentable with formatting. Of course, formatting text is easy, but applying different types of formatting over and over again can get tedious. That's why, in this lesson, you'll learn a fast and easy way to format chunks of text quickly and consistently using something called styles. You'll find out what a style is, how to apply it, and more important, how to create and save your own styles to use in any document. By the end of this lesson, you'll be able to make any document look presentable with just the click of your mouse.
Templates
If you've ever baked cookies, or even just watched someone else do it, you know how difficult it can be to make all the cookies in a batch look exactly alike. Some turn out big, some small, some gooey, and some burned! However, if you use a cookie cutter, you can make identically shaped cookies every time. That's the same principle you'll learn in this lesson; instead of using a cookie cutter, though, you'll use something called a template. A template stores the formatting of a document so that you can apply it to another document. Templates let you format entire documents as easily as formatting a single word. Word offers lots of convenient templates stored right on your computer or available over the Internet, and you'll also find out how you can create your own.
Graphics: Part 1
They say a picture is worth a thousand words, so what better way to spice up your documents than by adding pictures? In this lesson, you'll learn how to add your own digital photographs to a document so that you can show everyone your vacation pictures, family holidays, or just interesting sights you've captured with your own camera. In addition to adding your own photos, you can also add clip art from Word's massive library of free graphics. And you'll find out how to resize, rotate, and style your pictures, as well as wrap your document text around them. By the end of this lesson, you'll see why Word documents are about much more than words!
Graphics: Part 2, and Columns
Digital photographs and clip art are just the beginning of what you can do with graphics in Word. In this lesson, you'll discover how to add a variety of informational graphics, including charts, graphs, and WordArt, which allow you to display text as a graphic image. Not only will you learn how to add these graphics, but you'll also find out how to edit them when your data changes. You'll finish off the lesson by seeing how Word allows you to format documents with multiple columns—a handy skill for creating newsletters and publications!
Sections and Notes
Do you often create long documents? If so, you'll appreciate this lesson, which shows you how to divide a large document into parts called sections. Sections allow you to format part of a document a certain way without that formatting affecting the rest of your text. For example, you may want headers and footers to appear on some pages but not others. Sections make this easy! You'll also spend some time inserting footnotes and endnotes in a document. If you need to write research papers or other academic content, Word makes it a snap to add and format these previously pesky notes!
Tables
If you've ever seen a spreadsheet, you know how rows and columns let you organize numbers and text on the screen. Well, tables do the same thing in Word. In this lesson, you'll see how to create tables of all different sizes right in a Word document! The lesson will cover how to modify tables, too. And don't think Excel users get to have all the fun—you can even enter formulas to perform calculations in your tables, sort them, and style them for a customized look. Your data has never looked so appealing!
Envelopes and Odd-Size Pages
You probably print most of your documents on standard letter-size paper. While this is great for ordinary letters or business reports, sometimes you may want to get creative with your paper sizes. But then there's the trouble of printing. In this lesson, you'll see how you can define the dimensions of the paper you're using, so Word will print everything correctly. You'll also learn how to print names and addresses directly on envelopes of any size. After this lesson, you won't feel confined to boring 8 1/2 x 11-inch paper anymore!
Desktop Publishing: Part 1
As you've probably already figured out, Word can do more than write letters. It also functions as a simple desktop publishing program for creating greeting cards, calendars, or newsletters. In this lesson, you'll find out how text boxes are the key to simple desktop publishing and see how other elements come into play in customized documents. Along the way, you'll look at business cards and greeting cards to get a feel for how desktop publishing works. If you've always wanted to create a document that combines text and graphics in an artistic or visually appealing way, you'll find out how to do that and much more.
Desktop Publishing: Part 2
With the basics down, it's time to take your desktop publishing skills to the next level. In this lesson, you'll discover the magic of linked text boxes that give you the power to move your text anywhere you want on the page and keep it flowing. You'll see how to create, position, resize, and group text boxes so you have total control over your text.
Merging Data with Documents
Have you ever received one of those "personalized" letters from a company in the mail? You can be sure that nobody typed the entire sales letter from scratch. Instead, the company used a form letter and something called mail merging. In this lesson, you'll learn how to store long lists of names and addresses that you can use over and over again in a form letter. Just create a document once, leave blanks for inserting information such as names and addresses, and let Word personalize each letter for you. Now you, too, can create personalized letters for business or personal use, such as sending out holiday greetings to family members and friends.
Final Touches
Look in most books, and you'll find the table of contents at the beginning and an index in the back. Often, these are the last components added to a document, since they need to have accurate titles and page numbers. But Word takes a lot of the tedious work out of creating these components. In this final lesson, you'll see how you can use Styles to make creating the table of contents a snap, and then explore how to tag index terms so Word knows what page they're on, even if they move later. Word can also help you keep track of any figures, such as charts, illustrations, or graphs, in your document. By letting Word worry about the details, you can create an accurate table of contents, index, or list of figures with very little extra effort on your part. These finishing touches will make your most important documents shine!
What you will learn
Learn how shortcut keys, macros, and the AutoCorrect feature can save you time
Discover fast ways to format text in a document
Find out how to insert graphic images, including clip art and photos, into your documents
Add charts, SmartArt, and WordArt to a document, and divide any document into columns
Practice dividing a long document into sections and using footnotes and endnotes
Get acquainted with some of Word's desktop publishing features, such as using text boxes, layering, and aligning objects
Learn how to link text boxes, and position them in a document to create brochures and newsletters
Use mail merging to quickly and easily personalize form documents
How you will benefit
Master the more advanced features of Microsoft Word
Learn how to use Word more effectively and take advantage of all its many features so you can get your work done more quickly and more easily
Wallace Wang
Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn to use the basic features of Word 2016 (now available through Office 365) to type, edit, format, spell check, and print professional-looking documents, letters, and reports.
One of the most basic skills needed in any job is writing reports and letters using Microsoft Word 2016, now available through Office 365. In this course, you will gain the foundational skills you need to make the most of this powerful program.
Through hands-on instructions, you will learn how to add and edit text; move words from one part of your document to another; work on two or more documents simultaneously; and format your text. You will also see how to save, retrieve, copy, organize, and print your documents.
You will learn dozens of ways to modify the appearance and content of your documents by adjusting page margins, paragraph tab settings, and line spacing to create great-looking documents quickly and easily. If you need to type foreign language characters or symbols, you can do that in Word too.
By using Word's spell and grammar checker, you can catch typos and grammatical mistakes before you print or share your document with others. You will also explore the program's thesaurus feature, which can help you find exactly the right word. By the time you're done with the step-by-step lessons and hands-on activities in this course, you will be able to use Word confidently at home or on the job.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Microsoft Word is used in nearly every modern workplace. In this course, you will master all the basics of this powerful word-processing program, including how to type and edit text, and how to format, spell check, and print documents. You will also learn dozens of different ways to modify the appearance and content of your documents and how to catch errors with Word's spell and grammar checker. After completing the course, you will be able to use Word confidently at home or on the job.
Getting Started
In this introductory lesson, you will learn how to use the different parts of Word 2016's user interface, how to look at your document from different types of views, how to zoom in and out to magnify or shrink your text, and how to change the margins of individual paragraphs.
Typing and Navigation
The whole purpose of Word is to let you create and edit text. This lesson introduces the basics of moving the insertion point and deleting text. By knowing the pros and cons of navigating through a document with the keyboard and mouse, you can use both to help you work faster in Word.
File Management
In this lesson, you will learn how to save the documents you create in Word. You will also learn how to rename, copy, and even delete any files you have created, so you will always be in complete control of all the files you create.
Editing Text
After you've typed some text in a Word document, you may need to edit that text. This lesson focuses on editing text. The easiest way to edit text is to delete it, but a more sophisticated way to edit text is to copy text and paste a duplicate of that text in another location.
Working With Multiple Documents
Most people use Word to view and edit a single document at a time, but Word actually lets you open and view two or more documents at the same time. This lesson will teach you how to open, switch between, and view multiple documents.
Text Formatting and Alignment
Once you know how to add, delete, copy, and move text, the next step to modifying your document is to change the physical appearance of your text. You can make text appear in different colors or background highlighting, change text size and alignment, and even modify fonts.
Printing
Most people use Word to print letters and reports. In this lesson, you will learn about the different ways you can print a document, such as portrait orientation or landscape orientation. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents.
Margins, Tabs, and Page Numbering
By knowing how to set and use margins, you can modify an entire document or just a single page. By using tabs, you can modify how individual paragraphs look on a page. Finally, you will also learn how to add page numbers to the top or bottom of a page to keep track of page order.
Paragraph Formatting
Word provides ways to change the appearance of a paragraph's first line, line spacing within a paragraph, and line spacing between paragraphs. In addition, Word lets you create bullet and number lists, so you can display short bits of information in a visual manner.
Language Tools
For important documents, you may even need to collaborate with others. To keep track of all the changes multiple authors may make to a single document, Word offers a Track Changes feature, so you can see exactly what and who changed the document.
Customizing Word
With Word, you can press different types of keystrokes or search and click the symbol you want to use. This lets you add practically any type of unusual character to your documents. Word lets you type practically anything you want, regardless of the limitation of the keys on your keyboard.
Making a Word Document Pretty and Organized
Finally, you can use outlines to organize your text and quickly move chunks of text within a document just by rearranging an outline heading. By learning these advanced features of Word, you can make each document display text in the most appealing way possible.
What you will learn
Learn the fundamentals of one of the most crucial software applications in the modern workplace
Acquire the skills and learn the tools you will need to adjust margins, spacing, layout, and design of any Word document
Learn how to work on multiple projects at once and become faster and more efficient in a variety of Microsoft Word tasks
Explore the many ways to modify the appearance of your documents in order to suit your individual needs
How you will benefit
Gain the confidence you need to make the most of this indispensable software application
Learn how to make the perfect layout for useful documents of any occasion - resumes, invitations, letters, articles, training materials, and much more
Save time and avoid frustration by familiarizing yourself with the wide variety of tools at your disposal in Word 2016
Become more proficient and efficient at one of the most widely used software programs in history
Wallace Wang
Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
This hands-on, project-oriented course is filled with easy-to-follow, detailed step-by-step instructions that teach you how to edit and manipulate images and create elemental compositions using Photoshop in the Creative Cloud. Discover how to improve photographs by editing out flaws, correcting poor exposure, or creating a composite image using the newest techniques.
Photoshop is the world's most popular photo-editing program. Artists, photographers, designers, and hobbyists all rely on Adobe Photoshop for image creation and editing. The Introduction to Photoshop CC course provides meticulous instructions that will teach you how to use Photoshop Creative Cloud with confidence.
Photoshop Creative Cloud has a host of impressive new features, and you will encounter a number of them throughout the course. You will be editing your own photographs to get rid of dust and scratches, fix the color, and correct image exposure. Then you will learn how to colorize parts of an image and how to create simple digital paintings. You will master techniques for switching the backgrounds on images and removing wrinkles and blemishes from photos, just like they do in magazines.
You will also learn about the content-aware Move tools that, like magic, let you move something on an image and intelligently replace the "hole" left behind at the same time. By the time you finish this fun, hands-on, project-oriented course, you will be well on your way to expressing yourself with the most exciting graphics program ever developed.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC or Mac.
Software Requirements:
PC: Windows 10 or later.
Mac: macOS 10.14 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
Adobe Photoshop CC, Adobe Creative Cloud, or any version of Adobe Creative Suite CC that includes the Adobe Photoshop CC or Photoshop only (not included in enrollment).
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Whether you are a photographer, digital illustrator, graphic designer, or someone who wants to alter old family photos, you need to learn Adobe Photoshop. The Introduction to Photoshop Creative Cloud course is filled with easy-to-follow, detailed step-by-step instructions that teach you how to edit and manipulate images and create basic compositions using Photoshop in the Creative Cloud. Discover how to improve photographs by editing out flaws, correcting poor exposure, or creating a composite image using the newest techniques Photoshop has to offer. You will even learn how much fun you can have digitally painting and exploring filters and effects to create unique images. And, best of all, you need no prior artistic ability or Photoshop experience to take this course.
Getting to Know Adobe Photoshop
Whether you're an aspiring graphic artist or a weekend photographer, Photoshop can play many roles in image creation. Even if you've never touched Photoshop before, you'll become familiar with Photoshop's interface and 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 how to crop an image to its desired image area.
Understanding Resolution and Layers
In this lesson, you'll learn and apply the basics in setting image resolution by resizing and resampling graphics for both screen and print purposes. Then, explore the wonders of working with layers. Move and transform objects within a scene to recreate a new composition. You will learn how to add, delete, hide, merge, and group layers as well as to change the blending mode of a layer to reveal new visual effects.
Working with Objects
What makes a good image composite? Find out in this lesson where you will discover the principles of image compositing and apply these by combining images to create your first image composites. Find out how linked layers work and see what Smart Objects can do. You will learn how to use guides to assist in placing and aligning objects. Then, you will use multiple images to create a realistic still-life image. Learn how to transform objects by scaling, rotating, distorting, and warping them.
Image Adjustments
Do you have an old image that has faded over the years? Are your vacation photos over-exposed or too dark? Use image adjustments to correct contrast and color! In this lesson, you will find out how to correct an image's contrast and make the colors pop using image adjustments. You can even remove color to make a black and white or toned image. Then, apply several image adjustments along with blending modes to create a surreal image! Finish this lesson by exploring the filters gallery to apply various artistic filters to a collage.
Image Retouch and Restoration
Need to clear up a few blemishes on a headshot? Or remove unwanted telephone wires from a landscape? This lesson introduces you to the tools used in photo retouching and restoration. This lesson also covers sharpening an image, blurring areas of an image to create a depth of field, and adding a vignette to an image. You will learn how to easily clear up blemishes in portraits and restore old, damaged photographs. You will also learn how to remove or duplicate objects in a scene.
Colorizing Images
Learn how to combine colors and create color themes using Adobe Color. Sample colors from an existing image to create a new color scheme. Then, apply color to black and white photos using several techniques to color areas. Color a single object in a black and white image to create emphasis, or color the entire image, as if filling in a "digital" coloring book. This lesson also covers how to save and load swatches of color to use on other projects.
Working with Brushes
Adobe Photoshop is one of the leading applications for digital painting. This lesson introduces you to brushes and teaches you to paint using different brush types to simulate real artists' materials, such as charcoal, pastels, oil paint, and watercolor. You do not have to have strong drawing skills to complete this lesson. You will sample color from existing images and use these as templates for your digital painting.
Working with Selections
One of the most basic skills you need in Photoshop is the ability to select areas of an image. Often, you'll want to make adjustments to or fine tune areas of a photograph. The act of editing an image, no matter the desired outcome, is based heavily on your ability to make good pixel selections. In this lesson, you will learn how to use the various selection tools and to use them to create convincing shadows to objects in a composition.
Working with Masks
Masks can hide or reveal parts of a layer. Learn to use masks with images and adjustment layers to advance your image manipulation skills. Learn to use and modify masks to create complex selections around objects with thin strands of hair and clipping masks to add textures to objects.
Working with Vectors
Photoshop is able to create vector shapes and paths, which are used across many Adobe products, so learning these tools can put you ahead of the game when you are learning software such as Adobe Illustrator. This lesson is designed to guide you through the technical tools in a way that is easy to grasp.
Type and Layer Effects
Want to create an invitation or promote an event? This lesson shows you how to apply typography with images to create effective design by utilizing Adobe Fonts, manipulating text using warping, typing on a path, or typing as a mask to place an image within the letterforms. Then, polish the look of your text with layer effects. This lesson will introduce you to a world of limitless type effects.
Preparing Files for Output
Understanding what file formats to use and when can be confusing. This final lesson covers file types and when to use them. Learn how to prepare files for both print and web output. You will also learn how to create a Behance portfolio page to showcase and promote your work!
What you will learn
Master the fundamentals of Photoshop's interface and tools
Understand the essentials of digital imaging including file formats, color modes, image size, and resolution.
Comprehend and apply digital color theory and practice colorization and digital painting
Identify and apply the methods of photo retouch and restoration
Use the functionality of Photoshop's layers, selections, and masking features
How you will benefit
Discover everything you need to confidently use the tools in Photoshop to restore, retouch, and rearrange images
Develop the skills you need to begin a new hobby or entry-level career using Photoshop
Learn to effectively retouch photos and develop professional quality images for your home or business
Harness the power of Photoshop to create stunning images by enhancing photographs and developing works of art
Beverly Richards Schulz
Beverly Richards Schulz is an award-winning photographer and graduate of the New York Institute of Photography. She holds a Bachelor of Arts in Legal Studies from UC Berkeley and a master's degree in Adult and Continuing Education. For the past 10 years, Schulz has taught at the University of San Francisco. With more than 15 years teaching experience, she has written over 30 digital photography and digital editing courses. She co-authored the book "Photoshop Elements 14—What's New?"
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn to use QuickBooks Online to record income and expenses; enter checks and credit card payments; track your payables, inventory, and receivables; and much more.
This QuickBooks course will teach you how to manage your business finances with QuickBooks Online. This powerful accounting software has helped millions of small business owners oversee their finances. Now that the cloud-based version is outpacing the desktop version, there's no better time to refresh your QuickBooks knowledge.
You will learn to use key features of QuickBooks Online and gain hands-on experience creating invoices, receipts, and statements; track payables, inventory, and receivables; generating reports; and more. Whether you're new to QuickBooks or need a quick refresher, this course will empower you to take control of your business's financial accounting, all with the ease and convenience of an online platform.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course can be taken on either a PC or Mac.
Software Requirements:
PC: Windows 10 or later.
Mac: macOS 10.11 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
When your course starts, you will be directed to access and utilize the free QuickBooks Online practice site to complete the lesson and assignment steps. You do not need to purchase a subscription or additional software to complete this course. However, please note that this course is suitable only for the QuickBooks Online version. The desktop versions of QuickBooks are not compatible with this course and should not be used. If you have the desktop version, you should consider registering for the course specifically designed for your version.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Manage the financial aspects of your small business quickly and efficiently using QuickBooks Online. This course will give you hands-on experience recording income and expenses; entering checks and credit card payments; tracking your payables, inventory, and receivables; and much more.
Getting Started
Your first lesson will introduce the QuickBooks Online interface and the pros and cons of working with your accounting information online. You will learn about the various subscription packages and practice using some of the interactive navigation features within the program.
Accounting Basics
To truly unlock the power of QuickBooks Online, it's helpful to have some basic accounting knowledge under your belt. In this lesson, you'll learn some introductory accounting terminology. In addition, you'll learn the basics of double entry accounting principles as well as the components of the Financial Statement.
The Chart of Accounts
The Chart of Accounts is the heart and soul of QuickBooks. In this lesson, you will 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
This lesson introduces best practices for using centers and lists in QuickBooks to gather and organize information needed to properly conduct business. You will also learn how to process Form 1099 to give to your vendors at the end of the year.
Bank Accounts
In this lesson, you will learn how to work with bank accounts in QuickBooks Online. You will learn how to create a new bank account, connect it online, and download, match, and add transactions. Then you will 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
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 will learn how to utilize QuickBooks' built-in features to enter check transactions and bank transfers like a pro.
Paying Bills
Without an organized system for managing all the bills your business receives, they can really start to stack up. When bills pile up, it becomes easy to start missing payment deadlines, which can result in late fees and credit difficulties. In this lesson, 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.
Credit Cards and Loans
In this lesson, you will learn how to effectively manage Credit Card accounts in QuickBooks Online. You will also learn how to enter a full or partial payment of the credit card balance when it comes time for payment. Finally, you will 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
You will find this lesson useful if your business ever sells a product or service and collects payment on the sale immediately. Then you will learn how to create multiple Sales Receipts and make the necessary deposit to your bank.
Invoices and Estimates
In order to evaluate just how well your company is performing, you will need to learn how to enter estimates, invoices, and customer payments. You will do just that in this lesson. You will also learn how to group multiple customer payments and record those deposits to the bank.
Billable Expenses and Customer Credits
This lesson focuses on billing customers for an expense incurred on a project or job. You will even see how you can add a markup percentage to the amount you include on the customer invoice. Also, you will examine the steps needed to enter credit memos, delayed credits, and refunds.
Sales Taxes and Reports
In your final lesson, you will learn how to work with the sales tax features in the program to collect and remit taxes you collect from customers. You will also find out how to create, use, and customize a wide variety of useful reports.
What you will learn
Learn everything you need to know about running QuickBooks in a small to mid-sized business
Discover how to set up a chart of accounts, reconcile your checking account, and create estimates
Learn to create and print invoices, receipts and statements
Understand how to track payables, inventory, and receivables
Gain the knowledge you need to generate reports
How you will benefit
Get access to Intuit's Test Drive Sample Company practice site of QuickBooks Online Plus
Get hands-on experience as you master the tools you will need to successfully use QuickBooks online
Gain the confidence to take control of the financial accounting for your business
Scott Paxton
Scott Paxton is a Certified Public Accountant and holds master's degrees in business administration and accounting. His background includes experience as a public accountant, a manager in the banking industry, an entrepreneur and a college business instructor. Paxton has also spent much of his career helping small business owners successfully implement and troubleshoot QuickBooks.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn the key concepts of SQL (Structured Query Language) the powerful and standard database management query language for relational databases.
Learn the key concepts of SQL (Structured Query Language) the powerful and standard database management query language for relational databases.
SQL (Structured Query Language) is one of the best programming languages for beginning web developers to learn. This course will teach you the basics of designing and writing SQL queries to execute on a practice database. Using a SQL Server Express, you'll learn several real-world applications for SQL so you can put this valuable skill set on your resume.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. Macs are not compatible.
Dual monitors are helpful but are not required.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
Software must be installed and fully operational before the course begins. Student will install the required software in the course.
Other:
Email capabilities and access to a personal email account.
Necessary rights (local administrative rights) to install programs on the computer.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
SQL Server Express
SQL Server Management Studio
Gain a solid working knowledge of the most powerful and widely used database programming language. This course will provide you the skills to write SQL queries to create tables, retrieve data from single or multiple tables, manipulate data in a database, and gather statistics from data stored in a database.
Introduction to Database Design and SQL
In this introductory lesson, you will examine database terms and concepts. Understanding the purpose of a database is foundational to writing efficient SQL queries that retrieve the right data.
SQL Server
In this lesson, you will install SQL Server Express and the SQL Server Management Studio to use throughout the course in your learn-by-doing practices. You will use SQL code to create one of the tables for the practice database in SQL Server.
Retrieving Data Result-Sets
SQL queries are the statements used to retrieve data from the database. Queries are written in a specific, logical order. In this lesson, you will explore various ways to write SQL queries to retrieve data that meet defined criteria.
Sorting Data
SQL queries are defined and written to retrieve data in a certain order. Queries are also written to limit columns and to filter data rows. In this lesson, you will practice writing queries that meet defined criteria and retrieve the expected result-sets.
Designing SQL Data Tables
This lesson is about designing SQL data tables for a database. You will explore the relationship concept and how it is used in an RDBMS. You will define tables that are structured according to RDBMS standards. You will also create the tables to add to your practice database.
Designing Data Rows
In this lesson, you will add data to your newly defined tables. You will explore several methods of adding data to a table and practice writing and executing these query statements. After adding several individual rows to the tables, you will use a SQL query to populate your tables with enough data rows to use in the learn-by-doing practices in this course.
Getting Data From Two Tables
SQL JOIN statements are used to retrieve data from more than one table. In this lesson, you will practice writing JOIN statements that retrieve data from tables that have a relationship between their PKs and FKs.
Retrieving Data From Multiple Tables
In this lesson, you will continue writing JOIN statements that retrieve data result-sets from more than one table. You will also examine how and when to use SQL subquery statements to retrieve data from multiple tables. You will practice defining and writing JOIN and subquery queries.
Keeping the Database Up to Date
The quality of the data in the database depends on its integrity, including the concepts of data accuracy and consistency. In this lesson, you will explore writing queries to maintain the database so that it is up to date with data that is accurate, consistent, and has integrity.
Aggregate Functions
In this lesson, you will examine the concept of aggregate functions and how they are used in query statements to examine multiple rows. Aggregate functions are a method of retrieving summarized data that is useful for analysis.
SQL Views
SQL views are an important concept in database design and in using databases. In this lesson, you will explore designing and writing queries to create views. You will also explore the reason they are valuable for database security and database access.
Maximize Database Integrity and Performance
Constraints are one way to maximize the integrity of the database and minimize the opportunity for user error. Indexes are used for increasing the performance of a data query. In this lesson, you will explore both these concepts.
What you will learn
Use SQL to develop a relational database
Design table and row structures that fulfill your requirements
Write efficient SQL queries to find and organize data
Write SQL queries to retrieve data from multiple tables
Create updates for a secure, high-performance database
How you will benefit
Gain confidence in your SQL ability, the standard database query language
Open the door to opportunities as you list basic SQL programming as a skill on your resume
Develop a new skill and learn whether or not you would like a career in IT
Mava Wilson
Mava Wilson, Ph.D., is a professor with more than 28 years of teaching experience. While she specializes in Information Systems (IS), she has taught several computer science topics, including basic computer literacy, programming, database design, and SQL. She holds a Ph.D. and master's degree in computing technology from Nova Southeastern University, as well as a bachelor's in administrative systems from Radford University.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
In this course, you will learn to use Windows 11, a powerful new operating system, including customizing your desktop, managing files and folders, and navigating the web with the latest Microsoft Edge browser.
File Explorer can help you manage your files and create text documents using WordPad. From managing files and editing photos to working with external drives, you will learn everything you need to know about getting the most from this operating system. Additionally, since security is essential, you will also learn how to protect your files and protect and update Windows 11.
By the time you finish this course, you will have mastered the basic skills you need to get the most from Windows 11 for both work and play.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC or Chromebook. Macs are not compatible.
Software Requirements:
PC: Windows 11 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Master the basic skills you need for Windows 11, the new operating system from Microsoft, which offers a more robust, more powerful, and unique computing experience. In this course, you will gain the foundation you need to start using Windows 11.
Welcome to Windows 11
Learning to use your PC well starts with learning to use Windows. In this first lesson, we'll start with the basics that every computer user must know in order to use a computer with minimal frustration. If you've been working in "frustration and aggravation" mode for a while, this lesson will take care of that. We'll start by talking about what Windows 11 is and why you want to learn it. Then, we'll get right into the most important skills and terminology that allow you to control what you see on your screen at all times. And that's important, because the first step to using anything that's in your computer is getting it on the screen where you can see it!
Use the Start Menu and Apps
In this lesson, we'll explore the revised Start Menu and Apps in Windows 11. You'll see how to use and customize the Start Menu, and we'll explore the Windows Store. You'll also see how to use the new widgets feature of Windows 11, which gives you access to quick and easy information, such as weather, traffic, sports, and news.
Personalizing Your Windows Desktop
In today's lesson, you'll have fun personalizing your computer by choosing your own desktop pictures, themes, and sound scheme. Along the way, you'll learn about the important Control Panel window in Windows 11 and tips for using dialog boxes and those occasional mysterious dimmed options that do nothing when you click them. The skills you learn in this lesson will go a long way to helping you gain complete control of your computer.
Working With Text and Files
No matter how you intend to use your computer, there'll be times when there's some typing involved. It might be for writing email messages, memos, or letters, or it might be for taking notes in a course, or for chatting with others in a website. Whatever the reason, today's lesson will teach you all the tricks for making typing (and editing) quick and easy. And you'll also discover how to save your work in files and folders, so it'll always be there when you need it!
Exploring Your System
Everything that's in your computer is stored on its hard drive. The hard drive is like a filing cabinet containing files organized into folders. Finding things you've saved in the past is a matter of opening the filing cabinet, so to speak, and then locating the correct folder. You'll use the File Explorer program to accomplish this. And in this lesson, you'll learn how it all works, so you can start gaining complete mastery of your own files and folders.
Using OneDrive, Microsoft Teams, and Microsoft To Do
In this lesson, you'll explore three Windows 11 features: OneDrive, Teams, and To Do. OneDrive is a cloud storage solution that lets you store files and folders both on your PC as well as the Microsoft cloud. Using OneDrive, you can save your data to Microsoft servers and access that data across multiple devices. Teams is communication software that is built into Windows 11. Using Teams, you can chat with friends, family, and co-workers and even host video and audio calls. Finally, you'll take a look at Microsoft To Do—an app that helps you keep track of to do tasks and lists. All of these features are designed to make your life easier!
Manage and Edit Your Photos
In this lesson, we'll have some fun with photos. Today, you'll learn how to organize your photos and view them using Windows 11's Photos App. You'll also see how to view individual photos, draw and rotate, and auto-enhance your shots. And, you'll learn about the Photos App editing tools for adjusting brightness and contrast, straightening crooked pictures, correcting red eye, and cropping.
Using Edge
The Internet is home to popular websites like Facebook, Amazon, Google, ed2go, and many others. Many of you have seen references to .com sites in ads and elsewhere. If you don't have a lot of computer experience, you might find it difficult to get to the many things you hear about on the web. But not after this lesson! In this lesson, you'll learn how to use Edge, the program that provides access to all of those popular websites.
Managing Files and Folders
Managing files and folders is one of those computer skills that every computer user needs to know. In many work and school environments, people just assume you know how to manage files, and they rarely provide any details on how to accomplish things like copying, moving, or renaming files and folders. Today's lesson will explain how to do those very things that others assume you already know how to do.
More Fun With File Management
In this lesson, you'll expand your file management skills by learning how to delete and recover files. You'll learn how to select multiple files to work with, so you don't always have to manage your files one at a time. And we'll discuss how to copy files to and from removable media like flash drives, CDs, and DVDs.
Protect Your Valuable Files!
Your computer is an investment of money, and the pictures and other files you store on your computer are an investment of time. You might even have some photos or other files that are so precious the thought of losing them causes you anxiety. What you need to do is protect those files. And that's just what this chapter is all about—how to use the tools and techniques that are built right into Windows to help you protect your valuable time and files!
Tips, Tricks, and Shortcuts
In our final lesson, you'll learn some more techniques for protecting your computer, including using resources for free protection from viruses and spyware. You'll learn how to remove programs you no longer want or need. You'll learn how to copy and paste text and create screenshots. And you'll discover some great timesaving tips and shortcuts, as well as resources for helping yourself so that you don't have to be so dependent on others.
What you will learn
Find your way around Windows 11 with the desktop, Start menu, and system settings
Understand how to customize features and personalize your desktop
Discover how File Explorer can help you manage files and learn to create basic text documents using WordPad
Comprehend how to protect your files and update Windows 11
How you will benefit
Gain confidence in your use of the Windows 11 operating system for personal and business use
Learn how to use your PC effectively, starting with Windows
Experience reduced frustration and setbacks by learning to operate your computer properly
Become a more independent computer user
Curt Simmons
Curt Simmons, B.A., M.Ed, is a best-selling author, trainer, and multi-media expert. He holds degrees in English and communication studies and has more than 10 years of experience teaching English and writing in the classroom. Additionally, Simmons has authored numerous books on a wide variety of technology topics and has been a technical editor for numerous other titles.
This is an ed2go Instructor Led Distance Learning Course. Hover over or tap this text for more details.
Instructor-led Courses (ILC) are for students who prefer a structured learning pace with instructor support. Lessons are gated and released biweekly. This type of course has fixed monthly start dates. This course can contain Peer to Peer and Peer to Instructor discussions.
Learn how to touch-type or improve your existing typing skills using Keyboarding Pro 5.
If you want to learn touch-typing or improve your existing typing skills, this is the perfect course for you! In these lessons, you'll use the Keyboarding Pro 5 program, a typing tutorial designed for personal computers, to learn how to touch-type—that is, to type text you read from a printed page or a computer screen without looking at your keyboard.
With the skills you master here, you'll become faster and more confident at the keyboard. By the end of the course, you'll know how to touch-type the alphabetic, numeric, and symbol keys; create, save, and edit word processing documents; and successfully take a timed writing test during a job interview.
Click Here For Additional Course Information
Requirements:
Hardware Requirements:
This course must be taken on a PC. Mac, Chromebooks, Surface, and all other tablets are not compatible.
Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
When the class starts, you'll receive instructions for downloading and installing a working copy of Keyboarding Pro 5. Please do not purchase or download the software from another source.
Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Become faster and more confident at the keyboard. This course will help you learn how to touch-type the alphabetic, numeric, and symbol keys; create, save, and edit word processing documents; and successfully take a timed writing test during a job interview.
Getting Started With Key Pro 5
Your first lesson guides you step by step as you download, install, and set up Key Pro 5. You will also get acquainted with the program, learning about the home row keys and the reach to the "i" key on the QWERTY keyboard. Are you confused about what home row and QWERTY mean? Don't worry—this lesson explains all of that.
Lowercase Letters, Plus the Reaches to the "e" and the "n"
Now that you're getting comfortable with the home row on the QWERTY keyboard, it's time to introduce you to some new keys. This lesson will focus on lowercase letters. You will also use Key Pro 5 to practice the reaches to the e and the n. Is all this typing causing you aches and pains? You will find out how to reduce fatigue while typing.
The Left Shift, h, t, and Period Reaches
In this lesson, you will learn four new keystrokes: left SHIFT, h, t, and period (.). You will also provide some tips on improving speed and accuracy and introduce you to the Key Pro 5 word processor program.
Learn the r, Right SHIFT, c, and o Reaches
Continue to build your keyboarding vocabulary by learning four new key reaches in this lesson: r, right SHIFT, c, and o. You will also learn about "the Zen of typing", which is how touch-typing becomes an instinctive and unconscious action.
The w, Comma, b, and p Reaches
Your typing vocabulary continues to expand rapidly with the addition of the reaches to the w, comma, b, and p. Before you know it, you will be typing complete paragraphs. This lesson also covers what you need to know about carpal tunnel syndrome, a serious and painful condition that you can avoid.
The g, Question Mark, x, and u Reaches
Expand your typing vocabulary by mastering four more key reaches: the g, question mark (?), x, and u. Just a few more reaches, and you will know how to type the whole alphabet. In this lesson, you will also learn about the function (FN) key and the numbers lock (NUM LOCK) key, which are on most laptop keyboards.
The q, m, v, and Apostrophe Reaches
This lesson teaches you another four reaches for your typing vocabulary: q, m, v, and apostrophe ('). You will also learn how to save a document with a word processing program.
The z, y, Quotation Mark, and Tab Reaches
It's time to add another four reaches to your typing vocabulary: the z, y, quotation mark ("), and tab keys. After this lesson, you will know the reaches to all the alphabetic keys. You will also find out how to open, edit, and resave word processing documents.
Alphabetic Key Review, the 1 and 8 Number Reaches, and Timed Writings
Are you ready to improve your skills and learn some new ones? After you review the z, y, x, q, v, quotation mark, and CAPS LOCK keys, you will learn the reaches to the numbers 1 and 8. Then you will take timed writings in the Key Pro 5 word processor.
Number Reaches, Deleting Text, and Alphabetic Key Review
What's the difference between the DELETE key, the BACKSPACE key, and the Cut command? By the end of this lesson, you will understand how and when to use these three editing tools. You will also continue to improve your skills with the alphabetic keys, plus you will learn more number reaches: 5, 0, 2, and 7.
Number and Symbol Reaches, Number Rules, and Key Review
When should you spell out numbers (like this: one, nine, five hundred), and when should you write them as figures (1, 9, 500)? You will also continue to improve your skills with the keys you have already learned, and you will finish the number reaches by mastering 4, 9, 3, and 6. Then you will learn two symbol reaches: the dollar sign ($) and the hyphen (-).
Symbol Reaches and Skill Building
You have already mastered some of the symbols and punctuation marks. In your last lesson together, you will meet the rest of the symbols. You will also work on your accuracy and speed with the Key Pro 5 Skill Building lessons. And you will find out how you can continue to hone your keyboarding skills long after you have finished this course.
What you will learn
Learn how to create, edit, and save word processing documents
Improve your typing speed and accuracy
Learn posture tips to minimize fatigue and help prevent carpal tunnel syndrome
How you will benefit
Successfully take a timed writing test during a job interview
Become more confident in your ability to type quickly and accurately
Kathy Van Pelt
Kathy Van Pelt has taught computer courses at a community college for the past 25 years. She specializes in Microsoft Office applications, Google Drive and Google Applications, the Windows and Mac operating systems, and keyboarding. She spent seven years teaching word processing and business classes at a private business college and loves being in the ever-evolving educational field.
By registering, I agree to INDEMNIFY AND HOLD HARMLESS Master the Possibilities, Inc., Sidney Colen & Associates, Ltd., On Top of the World Communities, Inc., Horticultural Arts & Park Institute, Inc., Bay Laurel Community Development District, and any of their agents, directors, officers, representatives, volunteers and employees from any and all loss, damage, injury, action or cause of action resulting from the classes, events, or trips and/or equipment owned or operated or permitted to be used or operated or is used or operated. This Release Waiver and Hold Harmless Agreement includes those classes, events, or trips inside or outside of Master the Possibilities, Inc. For the full waiver, visit https://www.masterthepossibilities.org/sites/default/files/PDF/WaiverofLiability.pdf.
If class is cancelled by the participant because of COVID positive results, there will still be a processing fee incurred by the participant.