Computer Applications   

Learn how to use Adobe Animate (formerly Adobe Flash) to design interactive animations with cutting-edge drawing tools.

This self-paced course will train you in the basics of Adobe Animate (formerly Adobe Flash). If you're new to Animate, need to update your Flash skills, or want to start designing rich, interactive animations, this course is for you.

You'll explore the Animate CC interface while learning to use the drawing tools through hands-on lessons. By course completion, you will have the skills you need to deliver your interactive animations to any device.

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.
• Adobe Animate (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Learn how to use Adobe Animate (formerly Adobe Flash) to design interactive animations with cutting-edge drawing tools.

1. Getting Started
2. Working with Drawing Tools
3. Graphic Symbols and the Library
4. Basic Animation
5. Advanced Animation
6. Button Symbols
7. Movie Clip Symbols
8. Publishing Animate Documents

What you will learn

• Different uses and capabilities of Animate's drawing tools
• Working with Graphic Symbols, Button Symbols, and the Library
• Best practices for animation design and delivery

How you will benefit

• Get comfortable with the Animate CC user interface
• Be able to create production quality animations
• Update your Flash skills to the latest Adobe animation program

Self-Study

Learn how to use Adobe Animate (formerly Adobe Flash) to design interactive animations with cutting-edge drawing tools.

This self-paced course will train you in the basics of Adobe Animate (formerly Adobe Flash). If you're new to Animate, need to update your Flash skills, or want to start designing rich, interactive animations, this course is for you.

You'll explore the Animate CC interface while learning to use the drawing tools through hands-on lessons. By course completion, you will have the skills you need to deliver your interactive animations to any device.

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.
• Adobe Animate (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Learn how to use Adobe Animate (formerly Adobe Flash) to design interactive animations with cutting-edge drawing tools.

1. Getting Started
2. Working with Drawing Tools
3. Graphic Symbols and the Library
4. Basic Animation
5. Advanced Animation
6. Button Symbols
7. Movie Clip Symbols
8. Publishing Animate Documents

What you will learn

• Different uses and capabilities of Animate's drawing tools
• Working with Graphic Symbols, Button Symbols, and the Library
• Best practices for animation design and delivery

How you will benefit

• Get comfortable with the Animate CC user interface
• Be able to create production quality animations
• Update your Flash skills to the latest Adobe animation program

Self-Study

This online Adobe Certified Professional course will help teach you how to use Adobe software and prepare you for the Adobe Certified Professional (ACP) exams.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac. A Chromebook is not compatible.

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
• Adobe Dreamweaver (not included in enrollment)
• Adobe Photoshop (not included in enrollment)
• Adobe Animate (not included in enrollment)
• Adobe Illustrator (not included in enrollment)
• Adobe InDesign (not included in enrollment)
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins

Other:

• Email capabilities and access to a personal email account

Instructional Material Requirements:

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

There is a strong demand for Adobe Creative Suite skills. In this Adobe Certified Professional course, you will learn five of the most often used Adobe programs: Dreamweaver, Illustrator, Photoshop, InDesign, and Animate (formerly Flash). You will also read short lessons, complete exercises, watch video demos and reviews of exercises, take quizzes and exams, and complete a project.

By focusing on these five programs, you will learn how to put all the parts and pieces together to develop the Adobe Creative Suite skills needed to become a professional in the design field. Becoming an Adobe Certified Professional will show you are ready to amaze clients, employers, and collaborators with proof of your skillset using the world's most creative desktop apps.

Upon completing this course, you will be ready to take the five Adobe Certified Professional (ACP) certification exams. This course offers enrollment with vouchers. The voucher is prepaid access to sit for the certifying exam upon eligibility. Proctor fees may apply, which are not included.

1. Introduction to Adobe Dreamweaver Creative Cloud (CC)
   1. A Quick Overview of Web Development
   2. Getting Started with Dreamweaver
   3. Creating HTML Pages
   4. Links
   5. Images
   6. Lists
   7. Tables
   8. Styling Content
   9. Introduction to Adobe Dreamweaver Final Exam
2. Introduction to Adobe Photoshop Creative Cloud (CC)
   1. Exploring the Photoshop Workspace
   2. Image Size and Resolution
   3. Selection Tools
   4. Painting
   5. Retouching
   6. Color Correction
   7. Advanced Layer Techniques
   8. Working with Type and Vector Shapes
   9. Designing for Web
   10. Preparing Final Art
   11. Introduction to Adobe Photoshop Final Exam
3. Adobe Animate Creative Cloud (CC)
   1. Getting Started
   2. Working with Drawing Tools
   3. Graphic Symbols and the Library
   4. Basic Animation
   5. Advanced Animation
   6. Button Symbols
   7. Movie Clip Symbols
   8. Publishing Animate Documents
   9. Introduction to Adobe Animate Final Exam
4. Introduction to Adobe Illustrator Creative Cloud (CC)
   1. Getting to Know the Illustrator Environment
   2. Getting Started
   3. Organize a Project
   4. Creating Advanced Illustrations
   5. Advanced Management of Shapes
   6. Working with Type
   7. Manage Project Components
   8. Sharing Your Project
   9. Introduction to Adobe Illustrator Final Exam
5. Introduction to Adobe InDesign Creative Cloud (CC)
   1. Getting to Know the Environment
   2. Creating a Project
   3. Working with Graphics
   4. Working with Text
   5. Master Pages
   6. Working with Templates
   7. Advanced Techniques
   8. Printing and Proofing a Project
   9. Design Principles
   10. Designing for Web
   11. Introduction to Adobe InDesign Final Exam

What you will learn

• Understand typography and formatting text
• Create and optimize images
• Configure and create web technologies
• Get comfortable with the CC user interface in all five programs
• Work with drawing tools and prepare files for output
• Discover styles and templates
• Obtain skills to work with team projects

How you will benefit

• Launch your career as a graphic or web designer
• Prepare yourself for five corresponding Adobe Certified Associate (ACA) exams
• Master Adobe's Creative Suite, which offers some of the most widely used programs for graphic designers

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

This online Adobe Certified Professional course will help teach you how to use Adobe software and prepare you for the Adobe Certified Professional (ACP) exams.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac. A Chromebook is not compatible.

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
• Adobe Dreamweaver (not included in enrollment)
• Adobe Photoshop (not included in enrollment)
• Adobe Animate (not included in enrollment)
• Adobe Illustrator (not included in enrollment)
• Adobe InDesign (not included in enrollment)
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins

Other:

• Email capabilities and access to a personal email account

Instructional Material Requirements:

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

There is a strong demand for Adobe Creative Suite skills. In this Adobe Certified Professional course, you will learn five of the most often used Adobe programs: Dreamweaver, Illustrator, Photoshop, InDesign, and Animate (formerly Flash). You will also read short lessons, complete exercises, watch video demos and reviews of exercises, take quizzes and exams, and complete a project.

By focusing on these five programs, you will learn how to put all the parts and pieces together to develop the Adobe Creative Suite skills needed to become a professional in the design field. Becoming an Adobe Certified Professional will show you are ready to amaze clients, employers, and collaborators with proof of your skillset using the world's most creative desktop apps.

Upon completing this course, you will be ready to take the five Adobe Certified Professional (ACP) certification exams. This course offers enrollment with vouchers. The voucher is prepaid access to sit for the certifying exam upon eligibility. Proctor fees may apply, which are not included.

1. Introduction to Adobe Dreamweaver Creative Cloud (CC)
   1. A Quick Overview of Web Development
   2. Getting Started with Dreamweaver
   3. Creating HTML Pages
   4. Links
   5. Images
   6. Lists
   7. Tables
   8. Styling Content
   9. Introduction to Adobe Dreamweaver Final Exam
2. Introduction to Adobe Photoshop Creative Cloud (CC)
   1. Exploring the Photoshop Workspace
   2. Image Size and Resolution
   3. Selection Tools
   4. Painting
   5. Retouching
   6. Color Correction
   7. Advanced Layer Techniques
   8. Working with Type and Vector Shapes
   9. Designing for Web
   10. Preparing Final Art
   11. Introduction to Adobe Photoshop Final Exam
3. Adobe Animate Creative Cloud (CC)
   1. Getting Started
   2. Working with Drawing Tools
   3. Graphic Symbols and the Library
   4. Basic Animation
   5. Advanced Animation
   6. Button Symbols
   7. Movie Clip Symbols
   8. Publishing Animate Documents
   9. Introduction to Adobe Animate Final Exam
4. Introduction to Adobe Illustrator Creative Cloud (CC)
   1. Getting to Know the Illustrator Environment
   2. Getting Started
   3. Organize a Project
   4. Creating Advanced Illustrations
   5. Advanced Management of Shapes
   6. Working with Type
   7. Manage Project Components
   8. Sharing Your Project
   9. Introduction to Adobe Illustrator Final Exam
5. Introduction to Adobe InDesign Creative Cloud (CC)
   1. Getting to Know the Environment
   2. Creating a Project
   3. Working with Graphics
   4. Working with Text
   5. Master Pages
   6. Working with Templates
   7. Advanced Techniques
   8. Printing and Proofing a Project
   9. Design Principles
   10. Designing for Web
   11. Introduction to Adobe InDesign Final Exam

What you will learn

• Understand typography and formatting text
• Create and optimize images
• Configure and create web technologies
• Get comfortable with the CC user interface in all five programs
• Work with drawing tools and prepare files for output
• Discover styles and templates
• Obtain skills to work with team projects

How you will benefit

• Launch your career as a graphic or web designer
• Prepare yourself for five corresponding Adobe Certified Associate (ACA) exams
• Master Adobe's Creative Suite, which offers some of the most widely used programs for graphic designers

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

Learn Adobe Premiere Pro and Photoshop skills and prepare for the Adobe Certified Professional in Video Design exam.

Requirements:

Hardware Requirements:

This course can be taken on either a PC or Mac device. A Chromebook is not compatible.

The processor should be:

• Intel® 7th Gen or newer CPU or Apple silicon M1 or newer for Mac
• Intel® 7th Gen or newer CPU with Quick Sync – or AMD Ryzen™ 3000 Series / Threadripper 2000 series or newer CPU for Windows

In addition, the computer should have to a minimum:

• 4 GB of GPU memory
• 16 GB of RAM
• 8 GB of available hard-disk space for installation
• Display of 1920 x 1080 or greater
• Microphone, speakers, and video camera

Software Requirements:

• PC: Windows 10 or later operating systems
• Mac: OS 10.8 or later
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible
• Adobe Photoshop (not included in enrollment)
• Adobe Premiere Pro (not included in enrollment) * See Premiere Pro system requirements for detailed hardware and software specifications.
• Adobe Acrobat Reader 
• Software must be installed and fully operational before the course begins

Other:

• Email capabilities and access to a personal email account
• Optional: Digital video camera - like on many modern mobile phones.

Instructional Material Requirements:

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

Are you interested in Video Design? Does the power to influence using video content appeal to you? If so, then this course is for you! Video content is used almost everywhere. Successful video editors know how to use their technical skills with precision to tell a story. If you want to become a master storyteller, achieving the Adobe Certified Professional in Video Design credential will help you. Earn the necessary certifications in Premiere Pro and Photoshop Adobe Certified Associate to show you have the editing skills to turn clips into a cinematic original.

Video editing takes source files and manipulates, combines, and arranges them to form a finished project. The result of editing may be a film, a commercial, an instructional video, or any other type of video content you can imagine. Adobe Premiere Pro is a software package for Windows and Mac OS that contains all the tools needed to edit professional-quality videos. Adobe Photoshop is the most popular graphics and photo editing software, according to Statista.

This course prepares you for the Adobe Premiere Pro and Adobe Photoshop certification exams. If you pass both of those exams, you become Adobe Certified Professionals in Video Design. 

Enrollment in this course includes exam vouchers. The voucher is pre-paid access to sit for the certifying exam upon eligibility.

1. Introduction to Adobe Photoshop Creative Cloud (CC)
   1. Exploring the Photoshop Workspace
   2. Image Size and Resolution
   3. Selection Tools
   4. Painting
   5. Retouching
   6. Color Correction
   7. Advanced Layer Techniques
   8. Working with Type and Vector Shapes
   9. Designing for Web
   10. Preparing Final Art
2. Introduction to Premiere Pro Creative Cloud (CC)
   1. Introduction to the Premiere Pro Interface
   2. Thinking in Video
   3. Setting Up a Project
   4. Basic Video Editing
   5. Exporting
   6. Clips and Markers
   7. Transitions
   8. Advanced Editing Techniques
   9. Working with Audio
   10. Visual Effects
   11. Color Correction and Grading
   12. Compositing Techniques
   13. Graphics and Titles
   14. Working in the Video Industry

What you will learn

• Understand how to work with Photoshop to edit pixel-based images to use in print, on the web, in video, and in mobile apps
• Gain general knowledge about working in the video industry
• Learn to work with Premiere Pro to create and edit videos

How you will benefit

• Launch your career as a graphic designer and/or videographer
• Prepare yourself for becoming an Adobe Certified Professional in Video Design
• Master two of the key programs in Adobe's Creative Suite, which offers some of the most widely used programs for graphic designers

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

Learn Adobe Premiere Pro and Photoshop skills and prepare for the Adobe Certified Professional in Video Design exam.

Requirements:

Hardware Requirements:

This course can be taken on either a PC or Mac device. A Chromebook is not compatible.

The processor should be:

• Intel® 7th Gen or newer CPU or Apple silicon M1 or newer for Mac
• Intel® 7th Gen or newer CPU with Quick Sync – or AMD Ryzen™ 3000 Series / Threadripper 2000 series or newer CPU for Windows

In addition, the computer should have to a minimum:

• 4 GB of GPU memory
• 16 GB of RAM
• 8 GB of available hard-disk space for installation
• Display of 1920 x 1080 or greater
• Microphone, speakers, and video camera

Software Requirements:

• PC: Windows 10 or later operating systems
• Mac: OS 10.8 or later
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible
• Adobe Photoshop (not included in enrollment)
• Adobe Premiere Pro (not included in enrollment) * See Premiere Pro system requirements for detailed hardware and software specifications.
• Adobe Acrobat Reader 
• Software must be installed and fully operational before the course begins

Other:

• Email capabilities and access to a personal email account
• Optional: Digital video camera - like on many modern mobile phones.

Instructional Material Requirements:

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

Are you interested in Video Design? Does the power to influence using video content appeal to you? If so, then this course is for you! Video content is used almost everywhere. Successful video editors know how to use their technical skills with precision to tell a story. If you want to become a master storyteller, achieving the Adobe Certified Professional in Video Design credential will help you. Earn the necessary certifications in Premiere Pro and Photoshop Adobe Certified Associate to show you have the editing skills to turn clips into a cinematic original.

Video editing takes source files and manipulates, combines, and arranges them to form a finished project. The result of editing may be a film, a commercial, an instructional video, or any other type of video content you can imagine. Adobe Premiere Pro is a software package for Windows and Mac OS that contains all the tools needed to edit professional-quality videos. Adobe Photoshop is the most popular graphics and photo editing software, according to Statista.

This course prepares you for the Adobe Premiere Pro and Adobe Photoshop certification exams. If you pass both of those exams, you become Adobe Certified Professionals in Video Design. 

Enrollment in this course includes exam vouchers. The voucher is pre-paid access to sit for the certifying exam upon eligibility.

1. Introduction to Adobe Photoshop Creative Cloud (CC)
   1. Exploring the Photoshop Workspace
   2. Image Size and Resolution
   3. Selection Tools
   4. Painting
   5. Retouching
   6. Color Correction
   7. Advanced Layer Techniques
   8. Working with Type and Vector Shapes
   9. Designing for Web
   10. Preparing Final Art
2. Introduction to Premiere Pro Creative Cloud (CC)
   1. Introduction to the Premiere Pro Interface
   2. Thinking in Video
   3. Setting Up a Project
   4. Basic Video Editing
   5. Exporting
   6. Clips and Markers
   7. Transitions
   8. Advanced Editing Techniques
   9. Working with Audio
   10. Visual Effects
   11. Color Correction and Grading
   12. Compositing Techniques
   13. Graphics and Titles
   14. Working in the Video Industry

What you will learn

• Understand how to work with Photoshop to edit pixel-based images to use in print, on the web, in video, and in mobile apps
• Gain general knowledge about working in the video industry
• Learn to work with Premiere Pro to create and edit videos

How you will benefit

• Launch your career as a graphic designer and/or videographer
• Prepare yourself for becoming an Adobe Certified Professional in Video Design
• Master two of the key programs in Adobe's Creative Suite, which offers some of the most widely used programs for graphic designers

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

Learn Adobe Illustrator, InDesign, Photoshop skills and prepare for the Adobe Certified Professional in Visual Design exams.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac. A Chromebook is not compatible.

Software Requirements:

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

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Are you interested in Graphic Design? Does visually appealing media catch your attention? If you are ready to take your art to the digital realm, this course is for you. Design skills using Adobe programs are in demand, and this course teaches the three programs focused on visual design. You will build your skills in Illustrator, InDesign, and Photoshop.

You will also be prepared for the Photoshop, Illustrator, and InDesign Adobe Certified Associate certifications. By earning two of these certifications, you will gain the Adobe Certified Professional in Visual Design certification. You will need to obtain one Photoshop certification and either one Illustrator or InDesign certification to qualify for the Visual Design certification.

This course enrollment includes vouchers. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Introduction to Adobe Photoshop Creative Cloud (CC)
   1. Exploring the Photoshop Workspace
   2. Image Size and Resolution
   3. Selection Tools
   4. Painting
   5. Retouching
   6. Color Correction
   7. Advanced Layer Techniques
   8. Working with Type and Vector Shapes
   9. Designing for Web
   10. Preparing Final Art
   11. Introduction to Adobe Photoshop Final Exam
2. Introduction to Adobe Illustrator Creative Cloud (CC)
   1. Getting to Know the Illustrator Environment
   2. Getting Started
   3. Organize a Project
   4. Creating Advanced Illustrations
   5. Advanced Management of Shapes
   6. Working with Type
   7. Manage Project Components
   8. Sharing Your Project
   9. Introduction to Adobe Illustrator Final Exam
3. Introduction to Adobe InDesign Creative Cloud (CC)
   1. Getting to Know the Environment
   2. Creating a Project
   3. Working with Graphics
   4. Working with Text
   5. Master Pages
   6. Working with Templates
   7. Advanced Techniques
   8. Printing and Proofing a Project
   9. Design Principles
   10. Designing for Web
   11. Introduction to Adobe InDesign Final Exam

What you will learn

• How to work with Illustrator to create graphics and illustrations
• Methods to use InDesign to create professional layouts and typography
• Best practices with Photoshop for image sizing and editing, and color correction

How you will benefit

• Launch your career as a graphic or web designer
• Prepare yourself for the Adobe Certified Professional in Visual Design exams
• Master key programs in Adobe's Creative Suite, which offers some of the most widely used programs for graphic designers

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

Learn Adobe Illustrator, InDesign, Photoshop skills and prepare for the Adobe Certified Professional in Visual Design exams.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac. A Chromebook is not compatible.

Software Requirements:

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

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Are you interested in Graphic Design? Does visually appealing media catch your attention? If you are ready to take your art to the digital realm, this course is for you. Design skills using Adobe programs are in demand, and this course teaches the three programs focused on visual design. You will build your skills in Illustrator, InDesign, and Photoshop.

You will also be prepared for the Photoshop, Illustrator, and InDesign Adobe Certified Associate certifications. By earning two of these certifications, you will gain the Adobe Certified Professional in Visual Design certification. You will need to obtain one Photoshop certification and either one Illustrator or InDesign certification to qualify for the Visual Design certification.

This course enrollment includes vouchers. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Introduction to Adobe Photoshop Creative Cloud (CC)
   1. Exploring the Photoshop Workspace
   2. Image Size and Resolution
   3. Selection Tools
   4. Painting
   5. Retouching
   6. Color Correction
   7. Advanced Layer Techniques
   8. Working with Type and Vector Shapes
   9. Designing for Web
   10. Preparing Final Art
   11. Introduction to Adobe Photoshop Final Exam
2. Introduction to Adobe Illustrator Creative Cloud (CC)
   1. Getting to Know the Illustrator Environment
   2. Getting Started
   3. Organize a Project
   4. Creating Advanced Illustrations
   5. Advanced Management of Shapes
   6. Working with Type
   7. Manage Project Components
   8. Sharing Your Project
   9. Introduction to Adobe Illustrator Final Exam
3. Introduction to Adobe InDesign Creative Cloud (CC)
   1. Getting to Know the Environment
   2. Creating a Project
   3. Working with Graphics
   4. Working with Text
   5. Master Pages
   6. Working with Templates
   7. Advanced Techniques
   8. Printing and Proofing a Project
   9. Design Principles
   10. Designing for Web
   11. Introduction to Adobe InDesign Final Exam

What you will learn

• How to work with Illustrator to create graphics and illustrations
• Methods to use InDesign to create professional layouts and typography
• Best practices with Photoshop for image sizing and editing, and color correction

How you will benefit

• Launch your career as a graphic or web designer
• Prepare yourself for the Adobe Certified Professional in Visual Design exams
• Master key programs in Adobe's Creative Suite, which offers some of the most widely used programs for graphic designers

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

Learn Adobe Dreamweaver, Animate, and Photoshop to prepare for the Adobe Certified Professional in Web Design exams.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac. Chromebooks are not compatible.

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
• Adobe Photoshop
• Adobe Animate
• Adobe Dreamweaver
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins

Other:

• Email capabilities and access to a personal email account

Instructional Material Requirements:

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

First impressions can create interest, grab attention, and a well-designed website can encourage clients to return. So, if you are interested in obtaining the skills to get started in web design, this is the course for you! You will learn three Adobe programs that focus on web design: Dreamweaver, Animate, and Photoshop. Upon completion, you will know how to work with the software applications and be prepared to take the Adobe Certified Professional exam for each. Once you earn the Dreamweaver and either the Animate or Photoshop Adobe Certified Professional certifications, you will also achieve the Adobe Certified Professional in Web Design.

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

1. Introduction to Adobe Dreamweaver Creative Cloud (CC)
   1. A Quick Overview of Web Development
   2. Getting Started with Dreamweaver
   3. Creating HTML Pages
   4. Links
   5. Images
   6. Lists
   7. Tables
   8. Styling Content
   9. Introduction to Adobe Dreamweaver Final Exam
2. Introduction to Adobe Photoshop Creative Cloud (CC)
   1. Exploring the Photoshop Workspace
   2. Image Size and Resolution
   3. Selection Tools
   4. Painting
   5. Retouching
   6. Color Correction
   7. Advanced Layer Techniques
   8. Working with Type and Vector Shapes
   9. Designing for Web
   10. Preparing Final Art
   11. Introduction to Adobe Photoshop Final Exam
3. Adobe Animate Creative Cloud (CC)
   1. Getting Started
   2. Working with Drawing Tools
   3. Graphic Symbols and the Library
   4. Basic Animation
   5. Advanced Animation
   6. Button Symbols
   7. Movie Clip Symbols
   8. Publishing Animate Documents
   9. Introduction to Adobe Animate Final Exam

What you will learn

• Discover how to work with Dreamweaver to define sites, format text, and format pages
• Understand how to work with Animate using drawing tools, graphic and button symbols, and the library
• Best practices to work with Photoshop for image sizing and editing, and color correction

How you will benefit

• Launch your career as a web designer
• Prepare yourself for the Adobe Certified Professional in Web Design exams
• Master key programs in Adobe's Creative Suite, which offers some of the most widely used programs for graphic designers

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

Learn Adobe Dreamweaver, Animate, and Photoshop to prepare for the Adobe Certified Professional in Web Design exams.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac. Chromebooks are not compatible.

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
• Adobe Photoshop
• Adobe Animate
• Adobe Dreamweaver
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins

Other:

• Email capabilities and access to a personal email account

Instructional Material Requirements:

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

First impressions can create interest, grab attention, and a well-designed website can encourage clients to return. So, if you are interested in obtaining the skills to get started in web design, this is the course for you! You will learn three Adobe programs that focus on web design: Dreamweaver, Animate, and Photoshop. Upon completion, you will know how to work with the software applications and be prepared to take the Adobe Certified Professional exam for each. Once you earn the Dreamweaver and either the Animate or Photoshop Adobe Certified Professional certifications, you will also achieve the Adobe Certified Professional in Web Design.

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

1. Introduction to Adobe Dreamweaver Creative Cloud (CC)
   1. A Quick Overview of Web Development
   2. Getting Started with Dreamweaver
   3. Creating HTML Pages
   4. Links
   5. Images
   6. Lists
   7. Tables
   8. Styling Content
   9. Introduction to Adobe Dreamweaver Final Exam
2. Introduction to Adobe Photoshop Creative Cloud (CC)
   1. Exploring the Photoshop Workspace
   2. Image Size and Resolution
   3. Selection Tools
   4. Painting
   5. Retouching
   6. Color Correction
   7. Advanced Layer Techniques
   8. Working with Type and Vector Shapes
   9. Designing for Web
   10. Preparing Final Art
   11. Introduction to Adobe Photoshop Final Exam
3. Adobe Animate Creative Cloud (CC)
   1. Getting Started
   2. Working with Drawing Tools
   3. Graphic Symbols and the Library
   4. Basic Animation
   5. Advanced Animation
   6. Button Symbols
   7. Movie Clip Symbols
   8. Publishing Animate Documents
   9. Introduction to Adobe Animate Final Exam

What you will learn

• Discover how to work with Dreamweaver to define sites, format text, and format pages
• Understand how to work with Animate using drawing tools, graphic and button symbols, and the library
• Best practices to work with Photoshop for image sizing and editing, and color correction

How you will benefit

• Launch your career as a web designer
• Prepare yourself for the Adobe Certified Professional in Web Design exams
• Master key programs in Adobe's Creative Suite, which offers some of the most widely used programs for graphic designers

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

Learn how to create websites with WordPress, the world's most popular website building platform.

Learn how to create attractive, sophisticated blogs and websites—without any coding! WordPress is the world's most popular content management system, powering more than 40 percent of all sites on the Internet. WordPress is an easy-to-use solution that will help you put your site on the web in far less time than by coding, and at a much lower cost than hiring a professional.

In these lessons, you'll get hands-on experience with this powerful tool as you create your own WordPress.org site and blog. You'll find out how to use WordPress to create pages and posts, add images and videos, change a site's look and feel, and include user-friendly features. You'll discover the ease of using WordPress design themes to express your creativity, and you'll see how much fun it is to be part of the vibrant WordPress online community.

In addition to mastering the technical elements of WordPress, you'll learn how to organize a blog or website, create appealing content, keep your site secure, and achieve better positions on search engine results pages. By the end of this course, you'll be able to confidently use WordPress to create a blog or a personal, business, or organizational website.

The WordPress.org version covered in this class is the platform the pros use. To set up a practice site for this class, you will need to sign up for a hosting account. Several options are described in the lessons. WordPress itself is free, but you'll need to host it somewhere.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Microsoft Edge are preferred. Mozilla Firefox and Safari are also compatible.
• WordPress.org requires a paid hosting account. You'll receive instructions on how to sign up for an account.

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 create websites with WordPress, the world's most popular website building platform.

Getting Started With WordPress

This first lesson explores the magic of WordPress! You'll discover how to use this WordPress to create an attractive, dynamic blog or website—without needing to learn any special code. You'll find out what the two "flavors" of WordPress are and why most experts recommend the WordPress.org version we will use in this course. Then you'll go online, sign up for a hosting account, and tour the WordPress Dashboard.

Creating a Blog

What can a blog do that a website can't? Blogging's become a popular way to establish an online presence. This lesson focuses on how adding a blog can make a traditional website more effective. Then you'll build a blog with WordPress—by creating, refining, and categorizing posts. You'll also find out how to encourage and control visitor feedback.

Making a WordPress Website

Get the best of both worlds by combining a blog with a traditional website. In this lesson, you'll use WordPress to create and organize web pages. You will also learn how to convert your blog to a traditional website—or vice versa—with the click of a button.

Making Your Pages Look Great

This lesson is all about WordPress themes—the templates that give your website its look and feel. You'll discover how to choose a theme, install it, and tweak it.

Working With Images and Multimedia

Photos, drawings, charts, videos, and audio clips can make your website more appealing and understandable. This lesson teaches you how to use WordPress to upload and insert images and multimedia files.

Plugins: The Modular Solution for Functional Websites

Plugins are little programs that add features to your WordPress website. In this lesson, you'll learn how to find and use them.

Making a User-Friendly Website

If your online visitors have trouble understanding or navigating your website, they'll go somewhere else. This lesson helps you pinpoint and eliminate usability problems.

Polishing Your WordPress Website

In this lesson, you'll take a long, hard look at your class project and how to make it better. You'll create a front page featuring both static and dynamic content; add links to pages, documents, email, and other sites; and repair typos, grammatical errors, and other mistakes.

Getting Search Engines to Love Your Website

What if you launched a website and nobody came? This lesson will show you how to keep that from happening. You'll find out what makes search engines tick and how to get them to visit your pages.

Making the Most of Statistics and Social Networking

Statistics are just a bunch of numbers if you don't know how to use them. This lesson focuses on how to analyze stats so you can improve your site. You'll also find out how to tie your WordPress pages into social sites like Facebook and Twitter.

WordPress Security and Monetization

This lesson will teach you how to protect a WordPress site against hackers and reviews money-making strategies for blogs and websites.

Mastering Your Domains

In the final lesson, you will take a tour of the hosting control panel, discuss domain naming strategies, and review where to get help after the course ends.

What you will learn

• Learn to use WordPress to create pages and posts, add images and videos, change a site's look and feel, and include user-friendly features
• Learn how to organize a blog or website and create appealing content
• Discover how to keep your site secure and achieve better positions on search engine results pages

How you will benefit

• Confidently use WordPress to create a blog or a personal, business, or organizational website
• Open the door to more career opportunities as a WordPress designer for small businesses
• Create your own personal website to brand yourself and your business services online

Richard Mansfield is a best-selling author and widely recognized expert on computer programming. He holds a master's degree in English from the University of California, Santa Barbara. He has written numerous articles and columns on computer topics, and was the editor of Compute! Magazine. In addition, he has authored or co-authored 44 books, including the best sellers Machine Language for Beginners (Compute!) and The Visual Guide to Visual Basic (Ventana). His more recent titles include Creating Web Pages for Dummies (co-authored, Wiley), XML for Dummies: All-in-One Desktop Reference (co-authored, Wiley), Mastering VBA for Office 2019 (Sybex), and Programming: A Beginner's Guide (McGraw-Hill). Richard's books have sold more than 600,000 copies worldwide and have been translated into 12 languages.

Learn how to create websites with WordPress, the world's most popular website building platform.

Learn how to create attractive, sophisticated blogs and websites—without any coding! WordPress is the world's most popular content management system, powering more than 40 percent of all sites on the Internet. WordPress is an easy-to-use solution that will help you put your site on the web in far less time than by coding, and at a much lower cost than hiring a professional.

In these lessons, you'll get hands-on experience with this powerful tool as you create your own WordPress.org site and blog. You'll find out how to use WordPress to create pages and posts, add images and videos, change a site's look and feel, and include user-friendly features. You'll discover the ease of using WordPress design themes to express your creativity, and you'll see how much fun it is to be part of the vibrant WordPress online community.

In addition to mastering the technical elements of WordPress, you'll learn how to organize a blog or website, create appealing content, keep your site secure, and achieve better positions on search engine results pages. By the end of this course, you'll be able to confidently use WordPress to create a blog or a personal, business, or organizational website.

The WordPress.org version covered in this class is the platform the pros use. To set up a practice site for this class, you will need to sign up for a hosting account. Several options are described in the lessons. WordPress itself is free, but you'll need to host it somewhere.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Microsoft Edge are preferred. Mozilla Firefox and Safari are also compatible.
• WordPress.org requires a paid hosting account. You'll receive instructions on how to sign up for an account.

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 create websites with WordPress, the world's most popular website building platform.

Getting Started With WordPress

This first lesson explores the magic of WordPress! You'll discover how to use this WordPress to create an attractive, dynamic blog or website—without needing to learn any special code. You'll find out what the two "flavors" of WordPress are and why most experts recommend the WordPress.org version we will use in this course. Then you'll go online, sign up for a hosting account, and tour the WordPress Dashboard.

Creating a Blog

What can a blog do that a website can't? Blogging's become a popular way to establish an online presence. This lesson focuses on how adding a blog can make a traditional website more effective. Then you'll build a blog with WordPress—by creating, refining, and categorizing posts. You'll also find out how to encourage and control visitor feedback.

Making a WordPress Website

Get the best of both worlds by combining a blog with a traditional website. In this lesson, you'll use WordPress to create and organize web pages. You will also learn how to convert your blog to a traditional website—or vice versa—with the click of a button.

Making Your Pages Look Great

This lesson is all about WordPress themes—the templates that give your website its look and feel. You'll discover how to choose a theme, install it, and tweak it.

Working With Images and Multimedia

Photos, drawings, charts, videos, and audio clips can make your website more appealing and understandable. This lesson teaches you how to use WordPress to upload and insert images and multimedia files.

Plugins: The Modular Solution for Functional Websites

Plugins are little programs that add features to your WordPress website. In this lesson, you'll learn how to find and use them.

Making a User-Friendly Website

If your online visitors have trouble understanding or navigating your website, they'll go somewhere else. This lesson helps you pinpoint and eliminate usability problems.

Polishing Your WordPress Website

In this lesson, you'll take a long, hard look at your class project and how to make it better. You'll create a front page featuring both static and dynamic content; add links to pages, documents, email, and other sites; and repair typos, grammatical errors, and other mistakes.

Getting Search Engines to Love Your Website

What if you launched a website and nobody came? This lesson will show you how to keep that from happening. You'll find out what makes search engines tick and how to get them to visit your pages.

Making the Most of Statistics and Social Networking

Statistics are just a bunch of numbers if you don't know how to use them. This lesson focuses on how to analyze stats so you can improve your site. You'll also find out how to tie your WordPress pages into social sites like Facebook and Twitter.

WordPress Security and Monetization

This lesson will teach you how to protect a WordPress site against hackers and reviews money-making strategies for blogs and websites.

Mastering Your Domains

In the final lesson, you will take a tour of the hosting control panel, discuss domain naming strategies, and review where to get help after the course ends.

What you will learn

• Learn to use WordPress to create pages and posts, add images and videos, change a site's look and feel, and include user-friendly features
• Learn how to organize a blog or website and create appealing content
• Discover how to keep your site secure and achieve better positions on search engine results pages

How you will benefit

• Confidently use WordPress to create a blog or a personal, business, or organizational website
• Open the door to more career opportunities as a WordPress designer for small businesses
• Create your own personal website to brand yourself and your business services online

Richard Mansfield is a best-selling author and widely recognized expert on computer programming. He holds a master's degree in English from the University of California, Santa Barbara. He has written numerous articles and columns on computer topics, and was the editor of Compute! Magazine. In addition, he has authored or co-authored 44 books, including the best sellers Machine Language for Beginners (Compute!) and The Visual Guide to Visual Basic (Ventana). His more recent titles include Creating Web Pages for Dummies (co-authored, Wiley), XML for Dummies: All-in-One Desktop Reference (co-authored, Wiley), Mastering VBA for Office 2019 (Sybex), and Programming: A Beginner's Guide (McGraw-Hill). Richard's books have sold more than 600,000 copies worldwide and have been translated into 12 languages.

This hands-on course will teach beginners how to use Microsoft Access 2019/Office 365 to build a database and customize the way data is stored.

Virtually every industry can benefit from the use of Microsoft Access to organize, store, and document their essential information. Data ranging from inventory and customer information to orders details and vendors can be effectively organized with Microsoft's longstanding software. If you work with databases of any kind, learning how to use Access 2019 will add a valuable skill set to your professional profile.

This course will teach you one of the most useful skills for both job seekers and those looking for promotion. If you know how to use Microsoft Excel, learning Access informs and enhances your current skill set, allowing you to take a stronger role in database management.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Access 2019: Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional 2019 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Build, edit, and maintain databases in Microsoft Access 2019/Office 365 using tables, reports, forms, and queries to give you fast access to all your important information. This hands-on course for beginners provides the skills to create an effective database for any type of information at home or on the job.

Getting to Know Access 2019

In this lesson, you'll find out what Access is and how individuals, businesses, and organizations use it to store information. You'll begin to build an Access database, including all the components that turn a list of records into reports, forms, and queries. You'll start by opening the application and creating a new database.

Controlling Your Access Table Fields

It's time to lay down the law! In this lesson, you'll impose rules that automatically fill an Access table field with a preset value or that automatically insert the symbols commonly included in phone numbers. You'll also set up rules that require allow only certain kinds of data in certain fields. With just a few minutes of work, you can make data entry simpler, clearer, and practically error-frees.

Creating Tables and Relationships

You'll create additional tables for the class database, customize them along the way, and then build relationships between them. This all paves the way for later database features, such as reports, queries, and forms that draw from multiple tables in the database.

Building Powerful Forms

In this lesson, you'll use forms for data entry and for viewing records in your tables. You'll meet the Form Wizard, which makes form building fast and easy and which allows you to select one or more tables' fields to include. You'll also learn how to change the form layout.

Adding Versatility to Forms

In this lesson, you'll add buttons and controls to forms. You'll also adjust table relationships to support the creation of multi-table forms, which paves the way to creating queries and reports that draw data from more than one table.

Interviewing Your Database

Using queries to sort, filter, and search your database is one of the most important skills you'll master in this course. In this lesson, you'll create queries that search for specific data. You'll also customize how Access displays that data. By following the instructions step by step, you'll first become familiar with the process, and then you'll get to create a query on your own!

Taking Queries to the Next Level

A query that puts specific records in order or finds all the records that have a general piece of information in common is, well, pretty common. Being able to create that kind of query is a great foundation skill, but it won't help you find a very specific record. Nor will it let you search for records within a span of dates or other numeric values. It also won't help you exclude certain records, reducing a large pool of data to just those records you need to see. In this lesson, you'll create queries that give you true power to search your database.

Multi-Table Query Control

In this lesson, you'll learn to plan, build, and use queries that pull data from more than one table at a time. This gives you more power over your data and allows you to build a great foundation for truly customized reports.

Reporting on Your Tables

Reports are easy to create and to customize. In this lesson, you'll build a simple report using the Report Wizard. Then you'll change the report's appearance, using layout view and design view. These skills provide the foundation to create and design any report you may need on any data in your database.

Creating Query-Based Reports

In this lesson, you'll create reports that are based on the results of queries you create to sort and filter your database. Because queries can combine data from multiple tables, filter for specific data, and sort the results, your report reflects just the data that meet the query's criteria. This makes truly customized reporting possible—and quite simple.

Mastering Report Design

In this lesson, you'll plan and create a completely customized report, using a specialized query that controls which data the report includes. You'll add fields that perform calculations on your data. You'll customize your report's layout, too, using design view's many tools for controlling the structure and appearance of your data.

Automating Your Database With Macros

Building macros (short programs that perform a series of steps) helps you speed up and create consistency in your more repetitive Access tasks. From opening a form to running a report to building a new record in a table, macros eliminate redundant procedures by turning them into something you can do with one click.

What you will learn

• Planning and building a database consisting of multiple tables
• Creating logical relationships between database tables
• Designing effective and powerful data entry forms
• Building efficient and useful queries to find and organize records
• Generation of professional-looking reports

How you will benefit

• You will be able to build and customize Access databases
• Existing Access databases will make more sense
• Gain knowledge to take a stronger role in the database maintenance
• Design professional-looking forms and reports

Laurie Ulrich has been writing about and teaching people to use Microsoft Office for more than 20 years—including personally training thousands of students, writing hundreds of training manuals, and authoring and co-authoring more than 30 books on subjects including Word, Excel, PowerPoint, Outlook, and Access. Her books include 2000-page epics that document every button, bell, and whistle, as well as friendlier introductory and troubleshooting books for new users. Her most recent publication on Microsoft Access is Access 2016 for Dummies. In addition to writing and teaching, Laurie runs her own firm, Limehat & Company, providing training, marketing, graphic design, and web development services to clients throughout the world, with a focus on helping growing companies and non-profit organizations build their brand through effective promotions, outreach, and education.

This hands-on course will teach beginners how to use Microsoft Access 2019/Office 365 to build a database and customize the way data is stored.

Virtually every industry can benefit from the use of Microsoft Access to organize, store, and document their essential information. Data ranging from inventory and customer information to orders details and vendors can be effectively organized with Microsoft's longstanding software. If you work with databases of any kind, learning how to use Access 2019 will add a valuable skill set to your professional profile.

This course will teach you one of the most useful skills for both job seekers and those looking for promotion. If you know how to use Microsoft Excel, learning Access informs and enhances your current skill set, allowing you to take a stronger role in database management.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Access 2019: Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional 2019 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Build, edit, and maintain databases in Microsoft Access 2019/Office 365 using tables, reports, forms, and queries to give you fast access to all your important information. This hands-on course for beginners provides the skills to create an effective database for any type of information at home or on the job.

Getting to Know Access 2019

In this lesson, you'll find out what Access is and how individuals, businesses, and organizations use it to store information. You'll begin to build an Access database, including all the components that turn a list of records into reports, forms, and queries. You'll start by opening the application and creating a new database.

Controlling Your Access Table Fields

It's time to lay down the law! In this lesson, you'll impose rules that automatically fill an Access table field with a preset value or that automatically insert the symbols commonly included in phone numbers. You'll also set up rules that require allow only certain kinds of data in certain fields. With just a few minutes of work, you can make data entry simpler, clearer, and practically error-frees.

Creating Tables and Relationships

You'll create additional tables for the class database, customize them along the way, and then build relationships between them. This all paves the way for later database features, such as reports, queries, and forms that draw from multiple tables in the database.

Building Powerful Forms

In this lesson, you'll use forms for data entry and for viewing records in your tables. You'll meet the Form Wizard, which makes form building fast and easy and which allows you to select one or more tables' fields to include. You'll also learn how to change the form layout.

Adding Versatility to Forms

In this lesson, you'll add buttons and controls to forms. You'll also adjust table relationships to support the creation of multi-table forms, which paves the way to creating queries and reports that draw data from more than one table.

Interviewing Your Database

Using queries to sort, filter, and search your database is one of the most important skills you'll master in this course. In this lesson, you'll create queries that search for specific data. You'll also customize how Access displays that data. By following the instructions step by step, you'll first become familiar with the process, and then you'll get to create a query on your own!

Taking Queries to the Next Level

A query that puts specific records in order or finds all the records that have a general piece of information in common is, well, pretty common. Being able to create that kind of query is a great foundation skill, but it won't help you find a very specific record. Nor will it let you search for records within a span of dates or other numeric values. It also won't help you exclude certain records, reducing a large pool of data to just those records you need to see. In this lesson, you'll create queries that give you true power to search your database.

Multi-Table Query Control

In this lesson, you'll learn to plan, build, and use queries that pull data from more than one table at a time. This gives you more power over your data and allows you to build a great foundation for truly customized reports.

Reporting on Your Tables

Reports are easy to create and to customize. In this lesson, you'll build a simple report using the Report Wizard. Then you'll change the report's appearance, using layout view and design view. These skills provide the foundation to create and design any report you may need on any data in your database.

Creating Query-Based Reports

In this lesson, you'll create reports that are based on the results of queries you create to sort and filter your database. Because queries can combine data from multiple tables, filter for specific data, and sort the results, your report reflects just the data that meet the query's criteria. This makes truly customized reporting possible—and quite simple.

Mastering Report Design

In this lesson, you'll plan and create a completely customized report, using a specialized query that controls which data the report includes. You'll add fields that perform calculations on your data. You'll customize your report's layout, too, using design view's many tools for controlling the structure and appearance of your data.

Automating Your Database With Macros

Building macros (short programs that perform a series of steps) helps you speed up and create consistency in your more repetitive Access tasks. From opening a form to running a report to building a new record in a table, macros eliminate redundant procedures by turning them into something you can do with one click.

What you will learn

• Planning and building a database consisting of multiple tables
• Creating logical relationships between database tables
• Designing effective and powerful data entry forms
• Building efficient and useful queries to find and organize records
• Generation of professional-looking reports

How you will benefit

• You will be able to build and customize Access databases
• Existing Access databases will make more sense
• Gain knowledge to take a stronger role in the database maintenance
• Design professional-looking forms and reports

Laurie Ulrich has been writing about and teaching people to use Microsoft Office for more than 20 years—including personally training thousands of students, writing hundreds of training manuals, and authoring and co-authoring more than 30 books on subjects including Word, Excel, PowerPoint, Outlook, and Access. Her books include 2000-page epics that document every button, bell, and whistle, as well as friendlier introductory and troubleshooting books for new users. Her most recent publication on Microsoft Access is Access 2016 for Dummies. In addition to writing and teaching, Laurie runs her own firm, Limehat & Company, providing training, marketing, graphic design, and web development services to clients throughout the world, with a focus on helping growing companies and non-profit organizations build their brand through effective promotions, outreach, and education.

If you work with data of any kind, knowing how to create a spreadsheet is key to effectively managing and organizing information. This course will introduce you to Microsoft Excel 2019 and teach you how to use this powerful software.

Do you manage large sets of numbers, names, dates, or other pieces of information? If so, then you need to create worksheets to manage, store, organize, and even analyze this information. Excel, Microsoft's powerful spreadsheet software, is the most widely-used program to handle this task. In fact, most workplaces require that new employees have a basic level of understanding of Microsoft Excel.

If you want to learn the 2019 version of Microsoft Excel, this course will introduce you to the program's basic functions and uses. Through hands-on lessons, you will learn numerous shortcuts to quickly and efficiently set up worksheets. You will also learn how to use the function wizard to calculate statistics, future values, and more. In addition, you will get tips on sorting and analyzing data, creating three-dimensional workbooks, and automating frequently-repeated tasks with macros and buttons. By the time you're done, you will know how to use this vital Office 2019 tool.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Excel 2019 (desktop version), available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
• Note: The "Starter Version" and "Web App" versions of Microsoft will not work with the full version taught in this course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Learn to quickly and efficiently use Microsoft Excel 2019/Office 365 as you discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.

Excel Basics

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

Creating a Worksheet

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

Time-Savers

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

Relative, Absolute, Mixed, and Circular References

Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. In this lesson, you'll learn to write sophisticated formulas that can help ease you through some rather sticky scenarios.

Three-Dimensional Workbooks

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

Sorting, Subtotaling, and Filtering

No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. In this lesson, you'll learn how to build a table in Excel as well as how to subtotal, sort, and filter.

Charting Basics

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

Advanced Charting Techniques

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

Intro to Excel's Statistical Functions

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

Financial Functions

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

Worksheet Automation

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

Mastering Excel's IF Function

You'll be intrigued by the final lesson, in which you'll learn how to use Excel to aid you in decision making. You'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.

What you will learn

• How to create worksheets, charts, and graphs
• Methods for sorting and analyzing automating often repeated tasks
• How to parse data with Flash Fill
• Important keyboard shortcuts

How you will benefit

• Knowing how to use Excel 2019 will make you a more productive member of your organization
• Gain indispensable skills that will be useful for numbers-based reporting
• Develop skills that can be used to simplify your life of calculating and displaying numbers both personally and professionally

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.

If you work with data of any kind, knowing how to create a spreadsheet is key to effectively managing and organizing information. This course will introduce you to Microsoft Excel 2019 and teach you how to use this powerful software.

Do you manage large sets of numbers, names, dates, or other pieces of information? If so, then you need to create worksheets to manage, store, organize, and even analyze this information. Excel, Microsoft's powerful spreadsheet software, is the most widely-used program to handle this task. In fact, most workplaces require that new employees have a basic level of understanding of Microsoft Excel.

If you want to learn the 2019 version of Microsoft Excel, this course will introduce you to the program's basic functions and uses. Through hands-on lessons, you will learn numerous shortcuts to quickly and efficiently set up worksheets. You will also learn how to use the function wizard to calculate statistics, future values, and more. In addition, you will get tips on sorting and analyzing data, creating three-dimensional workbooks, and automating frequently-repeated tasks with macros and buttons. By the time you're done, you will know how to use this vital Office 2019 tool.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Excel 2019 (desktop version), available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
• Note: The "Starter Version" and "Web App" versions of Microsoft will not work with the full version taught in this course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Learn to quickly and efficiently use Microsoft Excel 2019/Office 365 as you discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.

Excel Basics

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

Creating a Worksheet

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

Time-Savers

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

Relative, Absolute, Mixed, and Circular References

Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. In this lesson, you'll learn to write sophisticated formulas that can help ease you through some rather sticky scenarios.

Three-Dimensional Workbooks

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

Sorting, Subtotaling, and Filtering

No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. In this lesson, you'll learn how to build a table in Excel as well as how to subtotal, sort, and filter.

Charting Basics

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

Advanced Charting Techniques

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

Intro to Excel's Statistical Functions

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

Financial Functions

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

Worksheet Automation

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

Mastering Excel's IF Function

You'll be intrigued by the final lesson, in which you'll learn how to use Excel to aid you in decision making. You'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.

What you will learn

• How to create worksheets, charts, and graphs
• Methods for sorting and analyzing automating often repeated tasks
• How to parse data with Flash Fill
• Important keyboard shortcuts

How you will benefit

• Knowing how to use Excel 2019 will make you a more productive member of your organization
• Gain indispensable skills that will be useful for numbers-based reporting
• Develop skills that can be used to simplify your life of calculating and displaying numbers both personally and professionally

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.

Are you overloaded with emails, meetings, and to-do lists? Make use of Microsoft Outlook 2019 functions, and you will rapidly increase your efficiency and productivity.

Whether for personal use or work, everyone needs to stay organized. In today's world, being organized means tracking email messages and appointments, storing names and contact information of important people, and creating to-do lists to help you complete various types of projects for yourself or your job.

Many people rely on Microsoft Outlook 2019, a unique tool to help you manage email, appointments, tasks, and contacts in a single program. In this course, you'll learn how to use Microsoft Outlook 2019 for Windows, which you can buy separately or through a subscription to Microsoft 365.

You will learn to save, sort, organize, and read email messages. Set appointments along with reminders, so you'll never miss an important date! Store and search through names of important people and their contact information, and create task lists to help you make progress on different projects. By the end of the course, you'll master how to effectively navigate Outlook's four main features: Mail, Appointments, People, and Tasks.

Besides learning how to create email messages, appointments, task lists, and contact information, you'll also learn how to search and find information and sort and organize data. Whether you need to manage your personal life or your professional world, the step-by-step lessons in this course will help you master Outlook for use at home or work.

Requirements:

Hardware Requirements:

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

Software Requirements:

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

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

This Microsoft Outlook training class introduces the 2019 interface and will get you up and running quickly, working effectively with messages, calendars, and contacts.

Getting Started with Outlook 2019

In this lesson, you'll get acquainted with Outlook. You'll go over the basics of what Outlook can do and how you can use it to save time and keep yourself organized. You'll also get familiar with Outlook's user interface to help you feel comfortable using the program. After you finish this lesson, you'll be ready to start using Outlook and switching between its different functions (Mail, Calendar, People, and Tasks).

Reading Email Messages

This lesson will help you make sense of all your email messages without forcing you to scroll through a long list of messages. You'll learn how to display, sort, and organize email messages. Since email is the most popular way to communicate with people anywhere globally, learning how to read and organize email in Outlook could be the feature you'll use most often.

Finding and Grouping Messages

Receiving email is always fun, but finding ways to search through all your email messages to find what you need can spell the difference between using email as a powerful communication tool or getting lost in the daily flood of email messages. In this lesson, you'll learn how to search, tag, and select email messages and move them to a folder. You will also explore strategies for labeling and organizing email messages.

Creating Email Messages

By receiving email messages and responding to them or simply writing new email messages all your own, you can turn your email account into a two-way communication medium to reach out to people anywhere around the world. In this lesson, you'll learn different ways to create and reply to messages. You will also identify ways to edit and send email messages.

Formatting Email Messages

In this lesson, you'll learn how to format text in your email messages to make your messages more appealing and readable. Formatting text doesn't just mean improving cosmetic appearances but can also mean displaying text in an organized fashion, so it's easier to read. You will identify ways to improve email messages through the use of different fonts, colors, and styles, as well as the use of spelling and grammar checks. You'll also learn how to use bulleted and numbered lists to ensure your emails are easy to read and understand.

Editing Email Messages

This lesson is all about polishing your text, so everything is correct. After all, your words may be powerful, but if there are typos or grammatical mistakes, your email message can look less valid and legitimate. In this lesson, you'll learn different ways to proofread and edit email messages. You'll explore the search and replace feature, learn how to create hyperlinks for email and website addresses, learn how to use the signature feature, and explore different styles for your email messages.

Sending Attachments to Email Messages

Sending email messages with file attachments lets you communicate with others using more than just what you can type. You can share a spreadsheet for others to edit, send someone an interesting PDF file to read, or give someone a short video of yourself wishing him a happy birthday. In this lesson, you'll learn how to add files such as word processor documents, spreadsheets, databases, or presentations along with video and audio files to your email messages. You'll also learn how to add images to email messages and edit these using word wrapping and other methods.

Dealing with Wanted and Unwanted Email

In this lesson, you'll learn how to deal with both wanted and unwanted email messages so you can focus your time on having fun and being productive. You'll learn how to delete and retrieve email messages, as well as how to archive them. Most of your email messages will likely be those you want to receive, but too many of them can make it difficult to find what you need, so you will also learn the benefits of creating rules for sorting emails so you can deal with junk email messages easier.

Storing Contact Information

Outlook offers a way to store names and contact information in a database. Not only can this database grow as large as necessary, but no matter how big it gets, Outlook still makes it easy for you to search and find the information you need quickly and accurately. In this lesson, you'll learn all about using Outlook to store contact information of the people most important to you for business and personal use. You'll learn how to create and keep contacts, sharing and search contacts, and group and sort contacts.

Using the Outlook Calendar

Everyone needs to meet people or be at a certain place at a specific time. For busier people, your scheduled appointments may become so numerous and varied that keeping track of your time can be cumbersome. In this lesson, you'll learn all about using Outlook's calendar feature to create and store appointments. You'll identify the different ways to view and use the calendar. You'll also explore setting and viewing appointments, as well as managing, editing, and sharing these appointments.

Creating Task Lists

In this lesson, you'll learn all about using Outlook to create tasks that can help you stay focused on achieving the goals you want to achieve. Outlook makes it easy to create and store your list of tasks that you can view whenever you use Outlook. In this lesson, you'll learn how to create a task list, tag and add details to a task, and manage your tasks. Outlook's task list is just one more tool to help you keep your life organized and focused.

Taking Notes and Customizing Outlook

Once you learn how to use Outlook's note-taking feature, you can learn different keystroke shortcuts and how to customize Outlook further to serve your particular needs better. In this lesson, you'll identify ways to create and modify notes. You'll also identify keystroke shortcuts and how to use these. Along with this, you'll learn different ways to customize Outlook's user interface and change Outlook's settings. You'll also have a chance to reflect on Outlook's various features you find most valuable and then decide how you plan to customize Outlook to make it easier for you.

What you will learn

• Understand the basics of the Outlook 2019 interface and how to navigate the program
• Create a standard Mail view to work from and learn the basics of sending and receiving email
• Get to know everything you need to know about Outlook's contacts, Contacts views, Contact Groups, and Address Books
• Learn how to link Outlook to social media sites, and find out how information from People can appear throughout Outlook
• Learn how to work with one or more Outlook Calendars and the associated items: appointments, meetings, and events.
• Learn how to work with Outlook tasks and to-dos
• Learn how to customize Outlook

How you will benefit

• Harness the full power of Outlook 2019 so you can be more productive
• Learn to better communicate and keep track of all your responsibilities

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

Are you overloaded with emails, meetings, and to-do lists? Make use of Microsoft Outlook 2019 functions, and you will rapidly increase your efficiency and productivity.

Whether for personal use or work, everyone needs to stay organized. In today's world, being organized means tracking email messages and appointments, storing names and contact information of important people, and creating to-do lists to help you complete various types of projects for yourself or your job.

Many people rely on Microsoft Outlook 2019, a unique tool to help you manage email, appointments, tasks, and contacts in a single program. In this course, you'll learn how to use Microsoft Outlook 2019 for Windows, which you can buy separately or through a subscription to Microsoft 365.

You will learn to save, sort, organize, and read email messages. Set appointments along with reminders, so you'll never miss an important date! Store and search through names of important people and their contact information, and create task lists to help you make progress on different projects. By the end of the course, you'll master how to effectively navigate Outlook's four main features: Mail, Appointments, People, and Tasks.

Besides learning how to create email messages, appointments, task lists, and contact information, you'll also learn how to search and find information and sort and organize data. Whether you need to manage your personal life or your professional world, the step-by-step lessons in this course will help you master Outlook for use at home or work.

Requirements:

Hardware Requirements:

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

Software Requirements:

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

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

This Microsoft Outlook training class introduces the 2019 interface and will get you up and running quickly, working effectively with messages, calendars, and contacts.

Getting Started with Outlook 2019

In this lesson, you'll get acquainted with Outlook. You'll go over the basics of what Outlook can do and how you can use it to save time and keep yourself organized. You'll also get familiar with Outlook's user interface to help you feel comfortable using the program. After you finish this lesson, you'll be ready to start using Outlook and switching between its different functions (Mail, Calendar, People, and Tasks).

Reading Email Messages

This lesson will help you make sense of all your email messages without forcing you to scroll through a long list of messages. You'll learn how to display, sort, and organize email messages. Since email is the most popular way to communicate with people anywhere globally, learning how to read and organize email in Outlook could be the feature you'll use most often.

Finding and Grouping Messages

Receiving email is always fun, but finding ways to search through all your email messages to find what you need can spell the difference between using email as a powerful communication tool or getting lost in the daily flood of email messages. In this lesson, you'll learn how to search, tag, and select email messages and move them to a folder. You will also explore strategies for labeling and organizing email messages.

Creating Email Messages

By receiving email messages and responding to them or simply writing new email messages all your own, you can turn your email account into a two-way communication medium to reach out to people anywhere around the world. In this lesson, you'll learn different ways to create and reply to messages. You will also identify ways to edit and send email messages.

Formatting Email Messages

In this lesson, you'll learn how to format text in your email messages to make your messages more appealing and readable. Formatting text doesn't just mean improving cosmetic appearances but can also mean displaying text in an organized fashion, so it's easier to read. You will identify ways to improve email messages through the use of different fonts, colors, and styles, as well as the use of spelling and grammar checks. You'll also learn how to use bulleted and numbered lists to ensure your emails are easy to read and understand.

Editing Email Messages

This lesson is all about polishing your text, so everything is correct. After all, your words may be powerful, but if there are typos or grammatical mistakes, your email message can look less valid and legitimate. In this lesson, you'll learn different ways to proofread and edit email messages. You'll explore the search and replace feature, learn how to create hyperlinks for email and website addresses, learn how to use the signature feature, and explore different styles for your email messages.

Sending Attachments to Email Messages

Sending email messages with file attachments lets you communicate with others using more than just what you can type. You can share a spreadsheet for others to edit, send someone an interesting PDF file to read, or give someone a short video of yourself wishing him a happy birthday. In this lesson, you'll learn how to add files such as word processor documents, spreadsheets, databases, or presentations along with video and audio files to your email messages. You'll also learn how to add images to email messages and edit these using word wrapping and other methods.

Dealing with Wanted and Unwanted Email

In this lesson, you'll learn how to deal with both wanted and unwanted email messages so you can focus your time on having fun and being productive. You'll learn how to delete and retrieve email messages, as well as how to archive them. Most of your email messages will likely be those you want to receive, but too many of them can make it difficult to find what you need, so you will also learn the benefits of creating rules for sorting emails so you can deal with junk email messages easier.

Storing Contact Information

Outlook offers a way to store names and contact information in a database. Not only can this database grow as large as necessary, but no matter how big it gets, Outlook still makes it easy for you to search and find the information you need quickly and accurately. In this lesson, you'll learn all about using Outlook to store contact information of the people most important to you for business and personal use. You'll learn how to create and keep contacts, sharing and search contacts, and group and sort contacts.

Using the Outlook Calendar

Everyone needs to meet people or be at a certain place at a specific time. For busier people, your scheduled appointments may become so numerous and varied that keeping track of your time can be cumbersome. In this lesson, you'll learn all about using Outlook's calendar feature to create and store appointments. You'll identify the different ways to view and use the calendar. You'll also explore setting and viewing appointments, as well as managing, editing, and sharing these appointments.

Creating Task Lists

In this lesson, you'll learn all about using Outlook to create tasks that can help you stay focused on achieving the goals you want to achieve. Outlook makes it easy to create and store your list of tasks that you can view whenever you use Outlook. In this lesson, you'll learn how to create a task list, tag and add details to a task, and manage your tasks. Outlook's task list is just one more tool to help you keep your life organized and focused.

Taking Notes and Customizing Outlook

Once you learn how to use Outlook's note-taking feature, you can learn different keystroke shortcuts and how to customize Outlook further to serve your particular needs better. In this lesson, you'll identify ways to create and modify notes. You'll also identify keystroke shortcuts and how to use these. Along with this, you'll learn different ways to customize Outlook's user interface and change Outlook's settings. You'll also have a chance to reflect on Outlook's various features you find most valuable and then decide how you plan to customize Outlook to make it easier for you.

What you will learn

• Understand the basics of the Outlook 2019 interface and how to navigate the program
• Create a standard Mail view to work from and learn the basics of sending and receiving email
• Get to know everything you need to know about Outlook's contacts, Contacts views, Contact Groups, and Address Books
• Learn how to link Outlook to social media sites, and find out how information from People can appear throughout Outlook
• Learn how to work with one or more Outlook Calendars and the associated items: appointments, meetings, and events.
• Learn how to work with Outlook tasks and to-dos
• Learn how to customize Outlook

How you will benefit

• Harness the full power of Outlook 2019 so you can be more productive
• Learn to better communicate and keep track of all your responsibilities

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

As technology transforms business practices, Microsoft PowerPoint remains one of the most commonly used tools for presentations. This course is perfect for beginners wanting to learn how to effectively use Microsoft PowerPoint 2019 to create professional presentations.

This in-depth course introduces PowerPoint's functions and will teach you how to plan and create professional-quality presentations. You will learn how to catch your audience's attention with PowerPoint's visual features like photo album. As you become acquainted to Office 365, you will learn how to utilize OneDrive and PowerPoint Online's cross-functionality—saving, editing, and sharing your presentations online.

This course is perfect for beginners looking to learn how to use the latest PowerPoint software. You will have the opportunity to create a custom presentation with content specific to your needs. By completion, you will be able to create captivating presentations and contribute to your company's business processes.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft PowerPoint 2019 (desktop version) available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Make presentations go from "so-so" to sensation with PowerPoint. This course will help you learn to use Microsoft PowerPoint 2019/Office 365 to create professional-quality slide presentations that grab attention and make your message memorable from start to finish.

The PowerPoint 2019 Interface

This lesson explores the basic features of Microsoft PowerPoint 2019. You'll explore the Ribbon and learn how to start the PowerPoint program and plan a presentation. You'll also practice working with different views, task panes, tabs, and templates.

Creating Presentations

Now that you know the basics of PowerPoint, it's time to create a presentation from scratch. You'll start by choosing a theme for a presentation and create slides with a variety of slide layouts. You'll explore the Live Preview feature and learn how to save a file for future use. You'll also create and edit slides in Slide pane and Outline view. Finally, you'll explore ways to play a slide show.

Working With Files and Creating and Editing Tables

Including tables in your presentation lets you present a lot of information in a compact space. In this lesson you'll add, revise and format tables. You'll also explore multiple ways to open a presentation. Then, you'll learn how to preserve different versions of your work by saving with new file names.

Creating Professional Presentations

This lesson covers two topics: proofreading and printing. You'll explore the Spelling, AutoCorrect, Thesaurus and Smart Lookup feature. You'll learn to print your presentation as slides, an outline, handouts and notes pages. This versatility really helps you connect with audience members!

Working With the Images Group

This lesson switches gears and works with images instead of text. You'll learn how to embellish your slides with media images, including online pictures, Icons, 3D models and photographs. You'll also learn how to download an image from a website and insert the image on a slide.

WordArt and the Illustrations Group

This lesson includes instructions for using WordArt, Shapes, Icons, 3D Models and SmartArt Graphics. You'll then learn how to transform text into colorful WordArt objects and add Icons and 3D Models. You'll also practice drawing and filling shapes with color and special effects. Finally, you'll learn to group and edit the objects you create and add visual sophistication to your text with SmartArt Graphics.

All About Charts

In this lesson, you'll create a chart to illustrate statistical data. You'll explore chart components and learn how to add and edit specific chart elements. You'll discover how to change the look of your chart by using the options on the Chart Tools contextual tab and the chart formatting buttons.

Making Global Changes to a Presentation

Making duplicate changes to dozens of PowerPoint slides is boring and time-consuming. This lesson focuses on making global changes to slides, handouts, and notes. You'll also make global changes to modify your presentation's background or theme colors.

Creating Links

In this lesson, you'll work with hyperlinks and action buttons. Enliven your presentation as you create links from text or objects to other slides, presentations, documents, and web pages. You can add sounds and 3D effects if desired. Also introduced in this lesson is the Zoom feature which sets up presenter-driven links between slides in a presentation.

Applying Animation to Slides, Text, and Objects

This lesson explores slide transitions and the Transition tab options. You'll apply animation to text and slide objects and use the Animations tab to add animation to slide or layout masters. You'll also find out how to add sound effects, such as a chime or coin sound, to slide transitions.

Adding Advanced Animation Effects to Text and Objects

Using the Animation Pane, you'll add and reorder animated text and objects on slides. You'll discover how to apply advanced animation effects to text and objects on slides, and slide and layout masters. You'll also add an audio clip to your presentation.

Sharing and Saving Your Presentations

In this lesson, you'll focus on different ways to save and share a presentation. You'll practice converting a presentation into a PDF file, so it's accessible on computers without PowerPoint 2019. You'll learn to open, edit, and share your presentation online with PowerPoint Online and a Windows OneDrive account. Last, you'll learn how to transform your presentation into a video.

What you will learn

• Planning and presentation skills
• Formatting a presentation with themes and colors, and use slide and layout masters
• How to utilize text and objects, including Icons, 3D Models, WordArt and SmartArt
• Explore the options on the PowerPoint Ribbon, including the Online Pictures command, File menu options, and Backstage View
• Learn how to print slides, handouts, notes and an outline
• Discover the best views for creating and editing slides, and running a presentation

How you will benefit

• Master PowerPoint skills that help you produce better presentations
• Become an integral company team member with professional presentation design skills
• Gain skills that transfer to any organization and look great on your résumé

Tracy Loffer holds a master's degree in Education in Curriculum and Instruction. She has been involved in education for twenty years, as a music educator and technology trainer. She has also worked in the private sector as a trainer of domestic and international technology franchisees as well as a writer and developmental editor of educational technology materials.

As technology transforms business practices, Microsoft PowerPoint remains one of the most commonly used tools for presentations. This course is perfect for beginners wanting to learn how to effectively use Microsoft PowerPoint 2019 to create professional presentations.

This in-depth course introduces PowerPoint's functions and will teach you how to plan and create professional-quality presentations. You will learn how to catch your audience's attention with PowerPoint's visual features like photo album. As you become acquainted to Office 365, you will learn how to utilize OneDrive and PowerPoint Online's cross-functionality—saving, editing, and sharing your presentations online.

This course is perfect for beginners looking to learn how to use the latest PowerPoint software. You will have the opportunity to create a custom presentation with content specific to your needs. By completion, you will be able to create captivating presentations and contribute to your company's business processes.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft PowerPoint 2019 (desktop version) available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Make presentations go from "so-so" to sensation with PowerPoint. This course will help you learn to use Microsoft PowerPoint 2019/Office 365 to create professional-quality slide presentations that grab attention and make your message memorable from start to finish.

The PowerPoint 2019 Interface

This lesson explores the basic features of Microsoft PowerPoint 2019. You'll explore the Ribbon and learn how to start the PowerPoint program and plan a presentation. You'll also practice working with different views, task panes, tabs, and templates.

Creating Presentations

Now that you know the basics of PowerPoint, it's time to create a presentation from scratch. You'll start by choosing a theme for a presentation and create slides with a variety of slide layouts. You'll explore the Live Preview feature and learn how to save a file for future use. You'll also create and edit slides in Slide pane and Outline view. Finally, you'll explore ways to play a slide show.

Working With Files and Creating and Editing Tables

Including tables in your presentation lets you present a lot of information in a compact space. In this lesson you'll add, revise and format tables. You'll also explore multiple ways to open a presentation. Then, you'll learn how to preserve different versions of your work by saving with new file names.

Creating Professional Presentations

This lesson covers two topics: proofreading and printing. You'll explore the Spelling, AutoCorrect, Thesaurus and Smart Lookup feature. You'll learn to print your presentation as slides, an outline, handouts and notes pages. This versatility really helps you connect with audience members!

Working With the Images Group

This lesson switches gears and works with images instead of text. You'll learn how to embellish your slides with media images, including online pictures, Icons, 3D models and photographs. You'll also learn how to download an image from a website and insert the image on a slide.

WordArt and the Illustrations Group

This lesson includes instructions for using WordArt, Shapes, Icons, 3D Models and SmartArt Graphics. You'll then learn how to transform text into colorful WordArt objects and add Icons and 3D Models. You'll also practice drawing and filling shapes with color and special effects. Finally, you'll learn to group and edit the objects you create and add visual sophistication to your text with SmartArt Graphics.

All About Charts

In this lesson, you'll create a chart to illustrate statistical data. You'll explore chart components and learn how to add and edit specific chart elements. You'll discover how to change the look of your chart by using the options on the Chart Tools contextual tab and the chart formatting buttons.

Making Global Changes to a Presentation

Making duplicate changes to dozens of PowerPoint slides is boring and time-consuming. This lesson focuses on making global changes to slides, handouts, and notes. You'll also make global changes to modify your presentation's background or theme colors.

Creating Links

In this lesson, you'll work with hyperlinks and action buttons. Enliven your presentation as you create links from text or objects to other slides, presentations, documents, and web pages. You can add sounds and 3D effects if desired. Also introduced in this lesson is the Zoom feature which sets up presenter-driven links between slides in a presentation.

Applying Animation to Slides, Text, and Objects

This lesson explores slide transitions and the Transition tab options. You'll apply animation to text and slide objects and use the Animations tab to add animation to slide or layout masters. You'll also find out how to add sound effects, such as a chime or coin sound, to slide transitions.

Adding Advanced Animation Effects to Text and Objects

Using the Animation Pane, you'll add and reorder animated text and objects on slides. You'll discover how to apply advanced animation effects to text and objects on slides, and slide and layout masters. You'll also add an audio clip to your presentation.

Sharing and Saving Your Presentations

In this lesson, you'll focus on different ways to save and share a presentation. You'll practice converting a presentation into a PDF file, so it's accessible on computers without PowerPoint 2019. You'll learn to open, edit, and share your presentation online with PowerPoint Online and a Windows OneDrive account. Last, you'll learn how to transform your presentation into a video.

What you will learn

• Planning and presentation skills
• Formatting a presentation with themes and colors, and use slide and layout masters
• How to utilize text and objects, including Icons, 3D Models, WordArt and SmartArt
• Explore the options on the PowerPoint Ribbon, including the Online Pictures command, File menu options, and Backstage View
• Learn how to print slides, handouts, notes and an outline
• Discover the best views for creating and editing slides, and running a presentation

How you will benefit

• Master PowerPoint skills that help you produce better presentations
• Become an integral company team member with professional presentation design skills
• Gain skills that transfer to any organization and look great on your résumé

Tracy Loffer holds a master's degree in Education in Curriculum and Instruction. She has been involved in education for twenty years, as a music educator and technology trainer. She has also worked in the private sector as a trainer of domestic and international technology franchisees as well as a writer and developmental editor of educational technology materials.

Discover how to effectively plan and implement projects using the world's most popular project management software, Microsoft Project 2019.

Microsoft Project is a staple for project management and remains the most widely-used project management software across all industries. If you manage projects in your organization, learning how to use this longstanding resource is key to successfully and effectively seeing your projects through to completion.

In this course, you will discover how to effectively plan, implement, and control projects using Microsoft Project 2019. From sequencing tasks, producing a baseline, and assigning resources and costs, to tracking progress and revising your project plan, Microsoft Project can help you organize all your project's details.

Armed with this information, you will avoid stalling or overloading your schedule. If you encounter trouble, you will know how to best utilize Project 2019 to get your project back on track.

Requirements:

Hardware Requirements:

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

Software Requirements:

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

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Learn to effectively plan, implement, and control projects using Microsoft Project 2019/Office 365. This course will help you master the basics to create and share a project schedule, track costs and resources, produce reports, and resolve problems to keep your projects on track.

Overview of Microsoft Project

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

Creating a Solid Foundation

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

Creating and Managing Resources

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

Defining and Assigning Costs

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

Project Templates, Security, and Constraints

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

Working With Views and Managing Information

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

Fine-Tuning Your Project Plan

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

Baselines and Tracking

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

Managing Variances

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

Closing Your Project

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

Printing Views

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

Using and Creating Reports

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

What you will learn

• Effective planning, implementation, and control projects using Microsoft Project
• How to enhance your project in the areas of efficiency and security
• The importance of setting a project baseline and tracking actual results
• Generate several standard project reports and a wide variety of visual project reports

How you will benefit

• Know how to the use of the world's most popular project management software
• Gain transferable skills
• Replace informal project plans with plans based on logic and structures reflective

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

Discover how to effectively plan and implement projects using the world's most popular project management software, Microsoft Project 2019.

Microsoft Project is a staple for project management and remains the most widely-used project management software across all industries. If you manage projects in your organization, learning how to use this longstanding resource is key to successfully and effectively seeing your projects through to completion.

In this course, you will discover how to effectively plan, implement, and control projects using Microsoft Project 2019. From sequencing tasks, producing a baseline, and assigning resources and costs, to tracking progress and revising your project plan, Microsoft Project can help you organize all your project's details.

Armed with this information, you will avoid stalling or overloading your schedule. If you encounter trouble, you will know how to best utilize Project 2019 to get your project back on track.

Requirements:

Hardware Requirements:

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

Software Requirements:

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

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Learn to effectively plan, implement, and control projects using Microsoft Project 2019/Office 365. This course will help you master the basics to create and share a project schedule, track costs and resources, produce reports, and resolve problems to keep your projects on track.

Overview of Microsoft Project

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

Creating a Solid Foundation

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

Creating and Managing Resources

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

Defining and Assigning Costs

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

Project Templates, Security, and Constraints

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

Working With Views and Managing Information

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

Fine-Tuning Your Project Plan

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

Baselines and Tracking

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

Managing Variances

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

Closing Your Project

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

Printing Views

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

Using and Creating Reports

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

What you will learn

• Effective planning, implementation, and control projects using Microsoft Project
• How to enhance your project in the areas of efficiency and security
• The importance of setting a project baseline and tracking actual results
• Generate several standard project reports and a wide variety of visual project reports

How you will benefit

• Know how to the use of the world's most popular project management software
• Gain transferable skills
• Replace informal project plans with plans based on logic and structures reflective

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

Learn how the foundational skills needed to utilize Microsoft Word 2019 in Office 365. This course will teach you how to create professional-looking letters, reports, and documents.

Across all industries, the ability to create documents in a word processor is essential in day-to-day functions. From writing reports to Knowing how to use Microsoft Word, the most widely-used word processing program, adds an important skill set to your professional profile.

This course will introduce you to the 2019 version of Microsoft Word, available with the Microsoft 365 platform. You will learn the basics of Word 2019 needed to write and edit text and to create, format, and organize documents. By the time you're done with these hands-on activities, you will be able to use Word confidently at home or on the job.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
• Microsoft Word 2019 (desktop version) available with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment)
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Learn to create professional-looking letters, reports, and documents using Microsoft Word 2019/Office 365. This hands-on course will help you master the basic features of this powerful word-processing program to type, edit, and format text, and spell check and print documents like a pro.

Getting Started

In this introductory lesson, you'll learn how to use the different parts of Word 2019's user interface, how to look at your document in 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, so in this lesson, you'll go over the basics of moving the Insertion Pointer, or Cursor, and deleting text. Pressing the BACKSPACE and DELETE keys can delete text one character at a time. The keyboard lets you move the cursor one character, one word, or one line at a time. The mouse lets you quickly move the cursor and scroll through large documents far faster than the keyboard. 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're going to learn how to save the documents you create in Word. You'll learn how to save documents with unique names, as well as in other formats so that you can share your documents with people using different word processors or even different computers. Finally, you'll learn how to rename, copy, and even delete any files you've created so that you'll 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. The easiest way to edit is to delete individual characters using the BACKSPACE or DELETE keys. Another option is using Word's Overtype mode by typing over text you no longer need. If you ever delete anything by mistake, don't panic! Word's handy Undo and Redo commands retrieve unintentionally deleted text. You may also want to delete large chunks of text. Use your keyboard or mouse in tandem with the BACKSPACE or DELETE keys to efficiently remove entire sections of text. By learning how to delete text and undo mistakes, you can edit your documents quickly using Word.

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 can be handy for copying text from one document to another, comparing two different drafts of the same document, or simply using one document as a reference while writing in the second one. By learning how to open, switch between, and view multiple documents, you can increase your productivity with Word.

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 the actual size of text, alter the alignment of text, and even choose different fonts to modify the way individual letters look. As you can see, Word provides plenty of ways to help you both edit text and change it so it looks visually appealing.

Printing

Most people use Word to print letters and reports. But Word also helps you get creative by letting you choose different paper sizes and orientations. For example, you can print a letter in portrait orientation or print a sign in landscape orientation. Just think of turning a page up so its height is taller than its width (portrait orientation) or turning the page on its side so its width is wider than its height (landscape orientation). Word also lets you choose to print on different paper sizes, such as envelopes, just as long as you can run those odd-shaped paper sheets in your printer. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents using Word.

Margins, Tabs, and Page Numbering

Most of the time when you create a document, you can use the default page settings. But sometimes you may want to modify those settings to change margins around a page to give you more (or less) space on the top, bottom, left, or right sides of a page. 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'll also learn how to add page numbers to the top or bottom of a page to keep track of the right page order when you print out your document.

Paragraph Formatting

Word can be handy for typing and formatting text, but once you've written several paragraphs worth of text, you may need to format individual paragraphs separately from the rest of your document. 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 numbered lists, so you can display short bits of information in a visual manner. With Word's various paragraph-formatting options, you can customize the appearance of all your paragraphs.

Language Tools

It's not enough just to write and format your text. After you're done writing, you may need to check your spelling, change your words, and even hyphenate your text to make your entire document look the best it can. 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. With so many ways to polish your document, there's no reason not to write exactly what you want to say with Word.

Customizing Word

Word can easily handle any characters you type with a keyboard, but sometimes you may need to type an occasional foreign language character, a mathematical symbol, or another unusual character that doesn't appear on your keyboard. 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, even smiley faces. You probably won't need to type all of these characters regularly, so just find the ones you'll likely need and remember how to use them. 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

Writing involves more than just typing and editing text. With Word's advanced features, you can insert page breaks and cover pages to adjust how your text appears when you print it out. To make text on each page look its best, you can use drop caps and styles. 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

• Fundamentals of one of the most crucial software applications in the modern workplace
• Skills and tools needed to adjust margins, spacing, layout, and design of any Word document
• How to work on multiple projects at once and become faster and more efficient in a variety of Microsoft Word tasks
• Techniques for modifying the appearance of your documents in order to suit your needs

How you will benefit

• Gain the confidence needed 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 2019
• Become more proficient with one of the most widely used software programs in history

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.

Learn how the foundational skills needed to utilize Microsoft Word 2019 in Office 365. This course will teach you how to create professional-looking letters, reports, and documents.

Across all industries, the ability to create documents in a word processor is essential in day-to-day functions. From writing reports to Knowing how to use Microsoft Word, the most widely-used word processing program, adds an important skill set to your professional profile.

This course will introduce you to the 2019 version of Microsoft Word, available with the Microsoft 365 platform. You will learn the basics of Word 2019 needed to write and edit text and to create, format, and organize documents. By the time you're done with these hands-on activities, you will be able to use Word confidently at home or on the job.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
• Microsoft Word 2019 (desktop version) available with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment)
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Learn to create professional-looking letters, reports, and documents using Microsoft Word 2019/Office 365. This hands-on course will help you master the basic features of this powerful word-processing program to type, edit, and format text, and spell check and print documents like a pro.

Getting Started

In this introductory lesson, you'll learn how to use the different parts of Word 2019's user interface, how to look at your document in 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, so in this lesson, you'll go over the basics of moving the Insertion Pointer, or Cursor, and deleting text. Pressing the BACKSPACE and DELETE keys can delete text one character at a time. The keyboard lets you move the cursor one character, one word, or one line at a time. The mouse lets you quickly move the cursor and scroll through large documents far faster than the keyboard. 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're going to learn how to save the documents you create in Word. You'll learn how to save documents with unique names, as well as in other formats so that you can share your documents with people using different word processors or even different computers. Finally, you'll learn how to rename, copy, and even delete any files you've created so that you'll 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. The easiest way to edit is to delete individual characters using the BACKSPACE or DELETE keys. Another option is using Word's Overtype mode by typing over text you no longer need. If you ever delete anything by mistake, don't panic! Word's handy Undo and Redo commands retrieve unintentionally deleted text. You may also want to delete large chunks of text. Use your keyboard or mouse in tandem with the BACKSPACE or DELETE keys to efficiently remove entire sections of text. By learning how to delete text and undo mistakes, you can edit your documents quickly using Word.

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 can be handy for copying text from one document to another, comparing two different drafts of the same document, or simply using one document as a reference while writing in the second one. By learning how to open, switch between, and view multiple documents, you can increase your productivity with Word.

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 the actual size of text, alter the alignment of text, and even choose different fonts to modify the way individual letters look. As you can see, Word provides plenty of ways to help you both edit text and change it so it looks visually appealing.

Printing

Most people use Word to print letters and reports. But Word also helps you get creative by letting you choose different paper sizes and orientations. For example, you can print a letter in portrait orientation or print a sign in landscape orientation. Just think of turning a page up so its height is taller than its width (portrait orientation) or turning the page on its side so its width is wider than its height (landscape orientation). Word also lets you choose to print on different paper sizes, such as envelopes, just as long as you can run those odd-shaped paper sheets in your printer. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents using Word.

Margins, Tabs, and Page Numbering

Most of the time when you create a document, you can use the default page settings. But sometimes you may want to modify those settings to change margins around a page to give you more (or less) space on the top, bottom, left, or right sides of a page. 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'll also learn how to add page numbers to the top or bottom of a page to keep track of the right page order when you print out your document.

Paragraph Formatting

Word can be handy for typing and formatting text, but once you've written several paragraphs worth of text, you may need to format individual paragraphs separately from the rest of your document. 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 numbered lists, so you can display short bits of information in a visual manner. With Word's various paragraph-formatting options, you can customize the appearance of all your paragraphs.

Language Tools

It's not enough just to write and format your text. After you're done writing, you may need to check your spelling, change your words, and even hyphenate your text to make your entire document look the best it can. 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. With so many ways to polish your document, there's no reason not to write exactly what you want to say with Word.

Customizing Word

Word can easily handle any characters you type with a keyboard, but sometimes you may need to type an occasional foreign language character, a mathematical symbol, or another unusual character that doesn't appear on your keyboard. 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, even smiley faces. You probably won't need to type all of these characters regularly, so just find the ones you'll likely need and remember how to use them. 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

Writing involves more than just typing and editing text. With Word's advanced features, you can insert page breaks and cover pages to adjust how your text appears when you print it out. To make text on each page look its best, you can use drop caps and styles. 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

• Fundamentals of one of the most crucial software applications in the modern workplace
• Skills and tools needed to adjust margins, spacing, layout, and design of any Word document
• How to work on multiple projects at once and become faster and more efficient in a variety of Microsoft Word tasks
• Techniques for modifying the appearance of your documents in order to suit your needs

How you will benefit

• Gain the confidence needed 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 2019
• Become more proficient with one of the most widely used software programs in history

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.

Learn how to create websites with WordPress, the world's most popular website building platform.

Learn how to create attractive, sophisticated blogs and websites—without any coding! WordPress is the world's most popular content management system, powering more than 40 percent of all sites on the Internet. WordPress is an easy-to-use solution that will help you put your site on the web in far less time than by coding, and at a much lower cost than hiring a professional.

In these lessons, you'll get hands-on experience with this powerful tool as you create your own WordPress.org site and blog. You'll find out how to use WordPress to create pages and posts, add images and videos, change a site's look and feel, and include user-friendly features. You'll discover the ease of using WordPress design themes to express your creativity, and you'll see how much fun it is to be part of the vibrant WordPress online community.

In addition to mastering the technical elements of WordPress, you'll learn how to organize a blog or website, create appealing content, keep your site secure, and achieve better positions on search engine results pages. By the end of this course, you'll be able to confidently use WordPress to create a blog or a personal, business, or organizational website.

The WordPress.org version covered in this class is the platform the pros use. To set up a practice site for this class, you will need to sign up for a hosting account. Several options are described in the lessons. WordPress itself is free, but you'll need to host it somewhere.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Microsoft Edge are preferred. Mozilla Firefox and Safari are also compatible.
• WordPress.org requires a paid hosting account. You'll receive instructions on how to sign up for an account.

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 create websites with WordPress, the world's most popular website building platform.

Getting Started With WordPress

This first lesson explores the magic of WordPress! You'll discover how to use this WordPress to create an attractive, dynamic blog or website—without needing to learn any special code. You'll find out what the two "flavors" of WordPress are and why most experts recommend the WordPress.org version we will use in this course. Then you'll go online, sign up for a hosting account, and tour the WordPress Dashboard.

Creating a Blog

What can a blog do that a website can't? Blogging's become a popular way to establish an online presence. This lesson focuses on how adding a blog can make a traditional website more effective. Then you'll build a blog with WordPress—by creating, refining, and categorizing posts. You'll also find out how to encourage and control visitor feedback.

Making a WordPress Website

Get the best of both worlds by combining a blog with a traditional website. In this lesson, you'll use WordPress to create and organize web pages. You will also learn how to convert your blog to a traditional website—or vice versa—with the click of a button.

Making Your Pages Look Great

This lesson is all about WordPress themes—the templates that give your website its look and feel. You'll discover how to choose a theme, install it, and tweak it.

Working With Images and Multimedia

Photos, drawings, charts, videos, and audio clips can make your website more appealing and understandable. This lesson teaches you how to use WordPress to upload and insert images and multimedia files.

Plugins: The Modular Solution for Functional Websites

Plugins are little programs that add features to your WordPress website. In this lesson, you'll learn how to find and use them.

Making a User-Friendly Website

If your online visitors have trouble understanding or navigating your website, they'll go somewhere else. This lesson helps you pinpoint and eliminate usability problems.

Polishing Your WordPress Website

In this lesson, you'll take a long, hard look at your class project and how to make it better. You'll create a front page featuring both static and dynamic content; add links to pages, documents, email, and other sites; and repair typos, grammatical errors, and other mistakes.

Getting Search Engines to Love Your Website

What if you launched a website and nobody came? This lesson will show you how to keep that from happening. You'll find out what makes search engines tick and how to get them to visit your pages.

Making the Most of Statistics and Social Networking

Statistics are just a bunch of numbers if you don't know how to use them. This lesson focuses on how to analyze stats so you can improve your site. You'll also find out how to tie your WordPress pages into social sites like Facebook and Twitter.

WordPress Security and Monetization

This lesson will teach you how to protect a WordPress site against hackers and reviews money-making strategies for blogs and websites.

Mastering Your Domains

In the final lesson, you will take a tour of the hosting control panel, discuss domain naming strategies, and review where to get help after the course ends.

What you will learn

• Learn to use WordPress to create pages and posts, add images and videos, change a site's look and feel, and include user-friendly features
• Learn how to organize a blog or website and create appealing content
• Discover how to keep your site secure and achieve better positions on search engine results pages

How you will benefit

• Confidently use WordPress to create a blog or a personal, business, or organizational website
• Open the door to more career opportunities as a WordPress designer for small businesses
• Create your own personal website to brand yourself and your business services online

Richard Mansfield is a best-selling author and widely recognized expert on computer programming. He holds a master's degree in English from the University of California, Santa Barbara. He has written numerous articles and columns on computer topics, and was the editor of Compute! Magazine. In addition, he has authored or co-authored 44 books, including the best sellers Machine Language for Beginners (Compute!) and The Visual Guide to Visual Basic (Ventana). His more recent titles include Creating Web Pages for Dummies (co-authored, Wiley), XML for Dummies: All-in-One Desktop Reference (co-authored, Wiley), Mastering VBA for Office 2019 (Sybex), and Programming: A Beginner's Guide (McGraw-Hill). Richard's books have sold more than 600,000 copies worldwide and have been translated into 12 languages.

Learn how to create websites with WordPress, the world's most popular website building platform.

Learn how to create attractive, sophisticated blogs and websites—without any coding! WordPress is the world's most popular content management system, powering more than 40 percent of all sites on the Internet. WordPress is an easy-to-use solution that will help you put your site on the web in far less time than by coding, and at a much lower cost than hiring a professional.

In these lessons, you'll get hands-on experience with this powerful tool as you create your own WordPress.org site and blog. You'll find out how to use WordPress to create pages and posts, add images and videos, change a site's look and feel, and include user-friendly features. You'll discover the ease of using WordPress design themes to express your creativity, and you'll see how much fun it is to be part of the vibrant WordPress online community.

In addition to mastering the technical elements of WordPress, you'll learn how to organize a blog or website, create appealing content, keep your site secure, and achieve better positions on search engine results pages. By the end of this course, you'll be able to confidently use WordPress to create a blog or a personal, business, or organizational website.

The WordPress.org version covered in this class is the platform the pros use. To set up a practice site for this class, you will need to sign up for a hosting account. Several options are described in the lessons. WordPress itself is free, but you'll need to host it somewhere.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Microsoft Edge are preferred. Mozilla Firefox and Safari are also compatible.
• WordPress.org requires a paid hosting account. You'll receive instructions on how to sign up for an account.

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 create websites with WordPress, the world's most popular website building platform.

Getting Started With WordPress

This first lesson explores the magic of WordPress! You'll discover how to use this WordPress to create an attractive, dynamic blog or website—without needing to learn any special code. You'll find out what the two "flavors" of WordPress are and why most experts recommend the WordPress.org version we will use in this course. Then you'll go online, sign up for a hosting account, and tour the WordPress Dashboard.

Creating a Blog

What can a blog do that a website can't? Blogging's become a popular way to establish an online presence. This lesson focuses on how adding a blog can make a traditional website more effective. Then you'll build a blog with WordPress—by creating, refining, and categorizing posts. You'll also find out how to encourage and control visitor feedback.

Making a WordPress Website

Get the best of both worlds by combining a blog with a traditional website. In this lesson, you'll use WordPress to create and organize web pages. You will also learn how to convert your blog to a traditional website—or vice versa—with the click of a button.

Making Your Pages Look Great

This lesson is all about WordPress themes—the templates that give your website its look and feel. You'll discover how to choose a theme, install it, and tweak it.

Working With Images and Multimedia

Photos, drawings, charts, videos, and audio clips can make your website more appealing and understandable. This lesson teaches you how to use WordPress to upload and insert images and multimedia files.

Plugins: The Modular Solution for Functional Websites

Plugins are little programs that add features to your WordPress website. In this lesson, you'll learn how to find and use them.

Making a User-Friendly Website

If your online visitors have trouble understanding or navigating your website, they'll go somewhere else. This lesson helps you pinpoint and eliminate usability problems.

Polishing Your WordPress Website

In this lesson, you'll take a long, hard look at your class project and how to make it better. You'll create a front page featuring both static and dynamic content; add links to pages, documents, email, and other sites; and repair typos, grammatical errors, and other mistakes.

Getting Search Engines to Love Your Website

What if you launched a website and nobody came? This lesson will show you how to keep that from happening. You'll find out what makes search engines tick and how to get them to visit your pages.

Making the Most of Statistics and Social Networking

Statistics are just a bunch of numbers if you don't know how to use them. This lesson focuses on how to analyze stats so you can improve your site. You'll also find out how to tie your WordPress pages into social sites like Facebook and Twitter.

WordPress Security and Monetization

This lesson will teach you how to protect a WordPress site against hackers and reviews money-making strategies for blogs and websites.

Mastering Your Domains

In the final lesson, you will take a tour of the hosting control panel, discuss domain naming strategies, and review where to get help after the course ends.

What you will learn

• Learn to use WordPress to create pages and posts, add images and videos, change a site's look and feel, and include user-friendly features
• Learn how to organize a blog or website and create appealing content
• Discover how to keep your site secure and achieve better positions on search engine results pages

How you will benefit

• Confidently use WordPress to create a blog or a personal, business, or organizational website
• Open the door to more career opportunities as a WordPress designer for small businesses
• Create your own personal website to brand yourself and your business services online

Richard Mansfield is a best-selling author and widely recognized expert on computer programming. He holds a master's degree in English from the University of California, Santa Barbara. He has written numerous articles and columns on computer topics, and was the editor of Compute! Magazine. In addition, he has authored or co-authored 44 books, including the best sellers Machine Language for Beginners (Compute!) and The Visual Guide to Visual Basic (Ventana). His more recent titles include Creating Web Pages for Dummies (co-authored, Wiley), XML for Dummies: All-in-One Desktop Reference (co-authored, Wiley), Mastering VBA for Office 2019 (Sybex), and Programming: A Beginner's Guide (McGraw-Hill). Richard's books have sold more than 600,000 copies worldwide and have been translated into 12 languages.

This course covers a broad range of digital literacy skills needed in today's tech-driven society. You will learn key topics based on learning objectives covered on the three IC3 Digital Literacy Certification exams, including: -Computing Fundamentals: The Computing Fundamentals exam covers computer literacy topics, such as computer hardware, software, operating systems, peripherals, and troubleshooting. -Key Applications: The Key Applications exam covers Microsoft Office applications including Word, Excel, PowerPoint, and Access. -Living Online: The Living Online exams covers skills for using the Internet to communicate and collaborate in a safe and ethical way. Instruction is based on Chrome, Gmail, and Google Calendar.

This hands-on course will teach beginners how to use Microsoft Access 2019/Office 365 to build a database and customize the way data is stored.

Virtually every industry can benefit from the use of Microsoft Access to organize, store, and document their essential information. Data ranging from inventory and customer information to orders details and vendors can be effectively organized with Microsoft's longstanding software. If you work with databases of any kind, learning how to use Access 2019 will add a valuable skill set to your professional profile.

This course will teach you one of the most useful skills for both job seekers and those looking for promotion. If you know how to use Microsoft Excel, learning Access informs and enhances your current skill set, allowing you to take a stronger role in database management.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Access 2019: Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional 2019 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Build, edit, and maintain databases in Microsoft Access 2019/Office 365 using tables, reports, forms, and queries to give you fast access to all your important information. This hands-on course for beginners provides the skills to create an effective database for any type of information at home or on the job.

Getting to Know Access 2019

In this lesson, you'll find out what Access is and how individuals, businesses, and organizations use it to store information. You'll begin to build an Access database, including all the components that turn a list of records into reports, forms, and queries. You'll start by opening the application and creating a new database.

Controlling Your Access Table Fields

It's time to lay down the law! In this lesson, you'll impose rules that automatically fill an Access table field with a preset value or that automatically insert the symbols commonly included in phone numbers. You'll also set up rules that require allow only certain kinds of data in certain fields. With just a few minutes of work, you can make data entry simpler, clearer, and practically error-frees.

Creating Tables and Relationships

You'll create additional tables for the class database, customize them along the way, and then build relationships between them. This all paves the way for later database features, such as reports, queries, and forms that draw from multiple tables in the database.

Building Powerful Forms

In this lesson, you'll use forms for data entry and for viewing records in your tables. You'll meet the Form Wizard, which makes form building fast and easy and which allows you to select one or more tables' fields to include. You'll also learn how to change the form layout.

Adding Versatility to Forms

In this lesson, you'll add buttons and controls to forms. You'll also adjust table relationships to support the creation of multi-table forms, which paves the way to creating queries and reports that draw data from more than one table.

Interviewing Your Database

Using queries to sort, filter, and search your database is one of the most important skills you'll master in this course. In this lesson, you'll create queries that search for specific data. You'll also customize how Access displays that data. By following the instructions step by step, you'll first become familiar with the process, and then you'll get to create a query on your own!

Taking Queries to the Next Level

A query that puts specific records in order or finds all the records that have a general piece of information in common is, well, pretty common. Being able to create that kind of query is a great foundation skill, but it won't help you find a very specific record. Nor will it let you search for records within a span of dates or other numeric values. It also won't help you exclude certain records, reducing a large pool of data to just those records you need to see. In this lesson, you'll create queries that give you true power to search your database.

Multi-Table Query Control

In this lesson, you'll learn to plan, build, and use queries that pull data from more than one table at a time. This gives you more power over your data and allows you to build a great foundation for truly customized reports.

Reporting on Your Tables

Reports are easy to create and to customize. In this lesson, you'll build a simple report using the Report Wizard. Then you'll change the report's appearance, using layout view and design view. These skills provide the foundation to create and design any report you may need on any data in your database.

Creating Query-Based Reports

In this lesson, you'll create reports that are based on the results of queries you create to sort and filter your database. Because queries can combine data from multiple tables, filter for specific data, and sort the results, your report reflects just the data that meet the query's criteria. This makes truly customized reporting possible—and quite simple.

Mastering Report Design

In this lesson, you'll plan and create a completely customized report, using a specialized query that controls which data the report includes. You'll add fields that perform calculations on your data. You'll customize your report's layout, too, using design view's many tools for controlling the structure and appearance of your data.

Automating Your Database With Macros

Building macros (short programs that perform a series of steps) helps you speed up and create consistency in your more repetitive Access tasks. From opening a form to running a report to building a new record in a table, macros eliminate redundant procedures by turning them into something you can do with one click.

What you will learn

• Planning and building a database consisting of multiple tables
• Creating logical relationships between database tables
• Designing effective and powerful data entry forms
• Building efficient and useful queries to find and organize records
• Generation of professional-looking reports

How you will benefit

• You will be able to build and customize Access databases
• Existing Access databases will make more sense
• Gain knowledge to take a stronger role in the database maintenance
• Design professional-looking forms and reports

Laurie Ulrich has been writing about and teaching people to use Microsoft Office for more than 20 years—including personally training thousands of students, writing hundreds of training manuals, and authoring and co-authoring more than 30 books on subjects including Word, Excel, PowerPoint, Outlook, and Access. Her books include 2000-page epics that document every button, bell, and whistle, as well as friendlier introductory and troubleshooting books for new users. Her most recent publication on Microsoft Access is Access 2016 for Dummies. In addition to writing and teaching, Laurie runs her own firm, Limehat & Company, providing training, marketing, graphic design, and web development services to clients throughout the world, with a focus on helping growing companies and non-profit organizations build their brand through effective promotions, outreach, and education.

This hands-on course will teach beginners how to use Microsoft Access 2019/Office 365 to build a database and customize the way data is stored.

Virtually every industry can benefit from the use of Microsoft Access to organize, store, and document their essential information. Data ranging from inventory and customer information to orders details and vendors can be effectively organized with Microsoft's longstanding software. If you work with databases of any kind, learning how to use Access 2019 will add a valuable skill set to your professional profile.

This course will teach you one of the most useful skills for both job seekers and those looking for promotion. If you know how to use Microsoft Excel, learning Access informs and enhances your current skill set, allowing you to take a stronger role in database management.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Access 2019: Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional 2019 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Build, edit, and maintain databases in Microsoft Access 2019/Office 365 using tables, reports, forms, and queries to give you fast access to all your important information. This hands-on course for beginners provides the skills to create an effective database for any type of information at home or on the job.

Getting to Know Access 2019

In this lesson, you'll find out what Access is and how individuals, businesses, and organizations use it to store information. You'll begin to build an Access database, including all the components that turn a list of records into reports, forms, and queries. You'll start by opening the application and creating a new database.

Controlling Your Access Table Fields

It's time to lay down the law! In this lesson, you'll impose rules that automatically fill an Access table field with a preset value or that automatically insert the symbols commonly included in phone numbers. You'll also set up rules that require allow only certain kinds of data in certain fields. With just a few minutes of work, you can make data entry simpler, clearer, and practically error-frees.

Creating Tables and Relationships

You'll create additional tables for the class database, customize them along the way, and then build relationships between them. This all paves the way for later database features, such as reports, queries, and forms that draw from multiple tables in the database.

Building Powerful Forms

In this lesson, you'll use forms for data entry and for viewing records in your tables. You'll meet the Form Wizard, which makes form building fast and easy and which allows you to select one or more tables' fields to include. You'll also learn how to change the form layout.

Adding Versatility to Forms

In this lesson, you'll add buttons and controls to forms. You'll also adjust table relationships to support the creation of multi-table forms, which paves the way to creating queries and reports that draw data from more than one table.

Interviewing Your Database

Using queries to sort, filter, and search your database is one of the most important skills you'll master in this course. In this lesson, you'll create queries that search for specific data. You'll also customize how Access displays that data. By following the instructions step by step, you'll first become familiar with the process, and then you'll get to create a query on your own!

Taking Queries to the Next Level

A query that puts specific records in order or finds all the records that have a general piece of information in common is, well, pretty common. Being able to create that kind of query is a great foundation skill, but it won't help you find a very specific record. Nor will it let you search for records within a span of dates or other numeric values. It also won't help you exclude certain records, reducing a large pool of data to just those records you need to see. In this lesson, you'll create queries that give you true power to search your database.

Multi-Table Query Control

In this lesson, you'll learn to plan, build, and use queries that pull data from more than one table at a time. This gives you more power over your data and allows you to build a great foundation for truly customized reports.

Reporting on Your Tables

Reports are easy to create and to customize. In this lesson, you'll build a simple report using the Report Wizard. Then you'll change the report's appearance, using layout view and design view. These skills provide the foundation to create and design any report you may need on any data in your database.

Creating Query-Based Reports

In this lesson, you'll create reports that are based on the results of queries you create to sort and filter your database. Because queries can combine data from multiple tables, filter for specific data, and sort the results, your report reflects just the data that meet the query's criteria. This makes truly customized reporting possible—and quite simple.

Mastering Report Design

In this lesson, you'll plan and create a completely customized report, using a specialized query that controls which data the report includes. You'll add fields that perform calculations on your data. You'll customize your report's layout, too, using design view's many tools for controlling the structure and appearance of your data.

Automating Your Database With Macros

Building macros (short programs that perform a series of steps) helps you speed up and create consistency in your more repetitive Access tasks. From opening a form to running a report to building a new record in a table, macros eliminate redundant procedures by turning them into something you can do with one click.

What you will learn

• Planning and building a database consisting of multiple tables
• Creating logical relationships between database tables
• Designing effective and powerful data entry forms
• Building efficient and useful queries to find and organize records
• Generation of professional-looking reports

How you will benefit

• You will be able to build and customize Access databases
• Existing Access databases will make more sense
• Gain knowledge to take a stronger role in the database maintenance
• Design professional-looking forms and reports

Laurie Ulrich has been writing about and teaching people to use Microsoft Office for more than 20 years—including personally training thousands of students, writing hundreds of training manuals, and authoring and co-authoring more than 30 books on subjects including Word, Excel, PowerPoint, Outlook, and Access. Her books include 2000-page epics that document every button, bell, and whistle, as well as friendlier introductory and troubleshooting books for new users. Her most recent publication on Microsoft Access is Access 2016 for Dummies. In addition to writing and teaching, Laurie runs her own firm, Limehat & Company, providing training, marketing, graphic design, and web development services to clients throughout the world, with a focus on helping growing companies and non-profit organizations build their brand through effective promotions, outreach, and education.

If you work with data of any kind, knowing how to create a spreadsheet is key to effectively managing and organizing information. This course will introduce you to Microsoft Excel 2019 and teach you how to use this powerful software.

Do you manage large sets of numbers, names, dates, or other pieces of information? If so, then you need to create worksheets to manage, store, organize, and even analyze this information. Excel, Microsoft's powerful spreadsheet software, is the most widely-used program to handle this task. In fact, most workplaces require that new employees have a basic level of understanding of Microsoft Excel.

If you want to learn the 2019 version of Microsoft Excel, this course will introduce you to the program's basic functions and uses. Through hands-on lessons, you will learn numerous shortcuts to quickly and efficiently set up worksheets. You will also learn how to use the function wizard to calculate statistics, future values, and more. In addition, you will get tips on sorting and analyzing data, creating three-dimensional workbooks, and automating frequently-repeated tasks with macros and buttons. By the time you're done, you will know how to use this vital Office 2019 tool.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Excel 2019 (desktop version), available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
• Note: The "Starter Version" and "Web App" versions of Microsoft will not work with the full version taught in this course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Learn to quickly and efficiently use Microsoft Excel 2019/Office 365 as you discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.

Excel Basics

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

Creating a Worksheet

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

Time-Savers

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

Relative, Absolute, Mixed, and Circular References

Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. In this lesson, you'll learn to write sophisticated formulas that can help ease you through some rather sticky scenarios.

Three-Dimensional Workbooks

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

Sorting, Subtotaling, and Filtering

No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. In this lesson, you'll learn how to build a table in Excel as well as how to subtotal, sort, and filter.

Charting Basics

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

Advanced Charting Techniques

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

Intro to Excel's Statistical Functions

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

Financial Functions

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

Worksheet Automation

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

Mastering Excel's IF Function

You'll be intrigued by the final lesson, in which you'll learn how to use Excel to aid you in decision making. You'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.

What you will learn

• How to create worksheets, charts, and graphs
• Methods for sorting and analyzing automating often repeated tasks
• How to parse data with Flash Fill
• Important keyboard shortcuts

How you will benefit

• Knowing how to use Excel 2019 will make you a more productive member of your organization
• Gain indispensable skills that will be useful for numbers-based reporting
• Develop skills that can be used to simplify your life of calculating and displaying numbers both personally and professionally

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.

If you work with data of any kind, knowing how to create a spreadsheet is key to effectively managing and organizing information. This course will introduce you to Microsoft Excel 2019 and teach you how to use this powerful software.

Do you manage large sets of numbers, names, dates, or other pieces of information? If so, then you need to create worksheets to manage, store, organize, and even analyze this information. Excel, Microsoft's powerful spreadsheet software, is the most widely-used program to handle this task. In fact, most workplaces require that new employees have a basic level of understanding of Microsoft Excel.

If you want to learn the 2019 version of Microsoft Excel, this course will introduce you to the program's basic functions and uses. Through hands-on lessons, you will learn numerous shortcuts to quickly and efficiently set up worksheets. You will also learn how to use the function wizard to calculate statistics, future values, and more. In addition, you will get tips on sorting and analyzing data, creating three-dimensional workbooks, and automating frequently-repeated tasks with macros and buttons. By the time you're done, you will know how to use this vital Office 2019 tool.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Excel 2019 (desktop version), available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
• Note: The "Starter Version" and "Web App" versions of Microsoft will not work with the full version taught in this course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Learn to quickly and efficiently use Microsoft Excel 2019/Office 365 as you discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.

Excel Basics

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

Creating a Worksheet

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

Time-Savers

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

Relative, Absolute, Mixed, and Circular References

Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. In this lesson, you'll learn to write sophisticated formulas that can help ease you through some rather sticky scenarios.

Three-Dimensional Workbooks

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

Sorting, Subtotaling, and Filtering

No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. In this lesson, you'll learn how to build a table in Excel as well as how to subtotal, sort, and filter.

Charting Basics

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

Advanced Charting Techniques

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

Intro to Excel's Statistical Functions

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

Financial Functions

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

Worksheet Automation

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

Mastering Excel's IF Function

You'll be intrigued by the final lesson, in which you'll learn how to use Excel to aid you in decision making. You'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.

What you will learn

• How to create worksheets, charts, and graphs
• Methods for sorting and analyzing automating often repeated tasks
• How to parse data with Flash Fill
• Important keyboard shortcuts

How you will benefit

• Knowing how to use Excel 2019 will make you a more productive member of your organization
• Gain indispensable skills that will be useful for numbers-based reporting
• Develop skills that can be used to simplify your life of calculating and displaying numbers both personally and professionally

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.

Are you overloaded with emails, meetings, and to-do lists? Make use of Microsoft Outlook 2019 functions, and you will rapidly increase your efficiency and productivity.

Whether for personal use or work, everyone needs to stay organized. In today's world, being organized means tracking email messages and appointments, storing names and contact information of important people, and creating to-do lists to help you complete various types of projects for yourself or your job.

Many people rely on Microsoft Outlook 2019, a unique tool to help you manage email, appointments, tasks, and contacts in a single program. In this course, you'll learn how to use Microsoft Outlook 2019 for Windows, which you can buy separately or through a subscription to Microsoft 365.

You will learn to save, sort, organize, and read email messages. Set appointments along with reminders, so you'll never miss an important date! Store and search through names of important people and their contact information, and create task lists to help you make progress on different projects. By the end of the course, you'll master how to effectively navigate Outlook's four main features: Mail, Appointments, People, and Tasks.

Besides learning how to create email messages, appointments, task lists, and contact information, you'll also learn how to search and find information and sort and organize data. Whether you need to manage your personal life or your professional world, the step-by-step lessons in this course will help you master Outlook for use at home or work.

Requirements:

Hardware Requirements:

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

Software Requirements:

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

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

This Microsoft Outlook training class introduces the 2019 interface and will get you up and running quickly, working effectively with messages, calendars, and contacts.

Getting Started with Outlook 2019

In this lesson, you'll get acquainted with Outlook. You'll go over the basics of what Outlook can do and how you can use it to save time and keep yourself organized. You'll also get familiar with Outlook's user interface to help you feel comfortable using the program. After you finish this lesson, you'll be ready to start using Outlook and switching between its different functions (Mail, Calendar, People, and Tasks).

Reading Email Messages

This lesson will help you make sense of all your email messages without forcing you to scroll through a long list of messages. You'll learn how to display, sort, and organize email messages. Since email is the most popular way to communicate with people anywhere globally, learning how to read and organize email in Outlook could be the feature you'll use most often.

Finding and Grouping Messages

Receiving email is always fun, but finding ways to search through all your email messages to find what you need can spell the difference between using email as a powerful communication tool or getting lost in the daily flood of email messages. In this lesson, you'll learn how to search, tag, and select email messages and move them to a folder. You will also explore strategies for labeling and organizing email messages.

Creating Email Messages

By receiving email messages and responding to them or simply writing new email messages all your own, you can turn your email account into a two-way communication medium to reach out to people anywhere around the world. In this lesson, you'll learn different ways to create and reply to messages. You will also identify ways to edit and send email messages.

Formatting Email Messages

In this lesson, you'll learn how to format text in your email messages to make your messages more appealing and readable. Formatting text doesn't just mean improving cosmetic appearances but can also mean displaying text in an organized fashion, so it's easier to read. You will identify ways to improve email messages through the use of different fonts, colors, and styles, as well as the use of spelling and grammar checks. You'll also learn how to use bulleted and numbered lists to ensure your emails are easy to read and understand.

Editing Email Messages

This lesson is all about polishing your text, so everything is correct. After all, your words may be powerful, but if there are typos or grammatical mistakes, your email message can look less valid and legitimate. In this lesson, you'll learn different ways to proofread and edit email messages. You'll explore the search and replace feature, learn how to create hyperlinks for email and website addresses, learn how to use the signature feature, and explore different styles for your email messages.

Sending Attachments to Email Messages

Sending email messages with file attachments lets you communicate with others using more than just what you can type. You can share a spreadsheet for others to edit, send someone an interesting PDF file to read, or give someone a short video of yourself wishing him a happy birthday. In this lesson, you'll learn how to add files such as word processor documents, spreadsheets, databases, or presentations along with video and audio files to your email messages. You'll also learn how to add images to email messages and edit these using word wrapping and other methods.

Dealing with Wanted and Unwanted Email

In this lesson, you'll learn how to deal with both wanted and unwanted email messages so you can focus your time on having fun and being productive. You'll learn how to delete and retrieve email messages, as well as how to archive them. Most of your email messages will likely be those you want to receive, but too many of them can make it difficult to find what you need, so you will also learn the benefits of creating rules for sorting emails so you can deal with junk email messages easier.

Storing Contact Information

Outlook offers a way to store names and contact information in a database. Not only can this database grow as large as necessary, but no matter how big it gets, Outlook still makes it easy for you to search and find the information you need quickly and accurately. In this lesson, you'll learn all about using Outlook to store contact information of the people most important to you for business and personal use. You'll learn how to create and keep contacts, sharing and search contacts, and group and sort contacts.

Using the Outlook Calendar

Everyone needs to meet people or be at a certain place at a specific time. For busier people, your scheduled appointments may become so numerous and varied that keeping track of your time can be cumbersome. In this lesson, you'll learn all about using Outlook's calendar feature to create and store appointments. You'll identify the different ways to view and use the calendar. You'll also explore setting and viewing appointments, as well as managing, editing, and sharing these appointments.

Creating Task Lists

In this lesson, you'll learn all about using Outlook to create tasks that can help you stay focused on achieving the goals you want to achieve. Outlook makes it easy to create and store your list of tasks that you can view whenever you use Outlook. In this lesson, you'll learn how to create a task list, tag and add details to a task, and manage your tasks. Outlook's task list is just one more tool to help you keep your life organized and focused.

Taking Notes and Customizing Outlook

Once you learn how to use Outlook's note-taking feature, you can learn different keystroke shortcuts and how to customize Outlook further to serve your particular needs better. In this lesson, you'll identify ways to create and modify notes. You'll also identify keystroke shortcuts and how to use these. Along with this, you'll learn different ways to customize Outlook's user interface and change Outlook's settings. You'll also have a chance to reflect on Outlook's various features you find most valuable and then decide how you plan to customize Outlook to make it easier for you.

What you will learn

• Understand the basics of the Outlook 2019 interface and how to navigate the program
• Create a standard Mail view to work from and learn the basics of sending and receiving email
• Get to know everything you need to know about Outlook's contacts, Contacts views, Contact Groups, and Address Books
• Learn how to link Outlook to social media sites, and find out how information from People can appear throughout Outlook
• Learn how to work with one or more Outlook Calendars and the associated items: appointments, meetings, and events.
• Learn how to work with Outlook tasks and to-dos
• Learn how to customize Outlook

How you will benefit

• Harness the full power of Outlook 2019 so you can be more productive
• Learn to better communicate and keep track of all your responsibilities

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

Are you overloaded with emails, meetings, and to-do lists? Make use of Microsoft Outlook 2019 functions, and you will rapidly increase your efficiency and productivity.

Whether for personal use or work, everyone needs to stay organized. In today's world, being organized means tracking email messages and appointments, storing names and contact information of important people, and creating to-do lists to help you complete various types of projects for yourself or your job.

Many people rely on Microsoft Outlook 2019, a unique tool to help you manage email, appointments, tasks, and contacts in a single program. In this course, you'll learn how to use Microsoft Outlook 2019 for Windows, which you can buy separately or through a subscription to Microsoft 365.

You will learn to save, sort, organize, and read email messages. Set appointments along with reminders, so you'll never miss an important date! Store and search through names of important people and their contact information, and create task lists to help you make progress on different projects. By the end of the course, you'll master how to effectively navigate Outlook's four main features: Mail, Appointments, People, and Tasks.

Besides learning how to create email messages, appointments, task lists, and contact information, you'll also learn how to search and find information and sort and organize data. Whether you need to manage your personal life or your professional world, the step-by-step lessons in this course will help you master Outlook for use at home or work.

Requirements:

Hardware Requirements:

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

Software Requirements:

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

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

This Microsoft Outlook training class introduces the 2019 interface and will get you up and running quickly, working effectively with messages, calendars, and contacts.

Getting Started with Outlook 2019

In this lesson, you'll get acquainted with Outlook. You'll go over the basics of what Outlook can do and how you can use it to save time and keep yourself organized. You'll also get familiar with Outlook's user interface to help you feel comfortable using the program. After you finish this lesson, you'll be ready to start using Outlook and switching between its different functions (Mail, Calendar, People, and Tasks).

Reading Email Messages

This lesson will help you make sense of all your email messages without forcing you to scroll through a long list of messages. You'll learn how to display, sort, and organize email messages. Since email is the most popular way to communicate with people anywhere globally, learning how to read and organize email in Outlook could be the feature you'll use most often.

Finding and Grouping Messages

Receiving email is always fun, but finding ways to search through all your email messages to find what you need can spell the difference between using email as a powerful communication tool or getting lost in the daily flood of email messages. In this lesson, you'll learn how to search, tag, and select email messages and move them to a folder. You will also explore strategies for labeling and organizing email messages.

Creating Email Messages

By receiving email messages and responding to them or simply writing new email messages all your own, you can turn your email account into a two-way communication medium to reach out to people anywhere around the world. In this lesson, you'll learn different ways to create and reply to messages. You will also identify ways to edit and send email messages.

Formatting Email Messages

In this lesson, you'll learn how to format text in your email messages to make your messages more appealing and readable. Formatting text doesn't just mean improving cosmetic appearances but can also mean displaying text in an organized fashion, so it's easier to read. You will identify ways to improve email messages through the use of different fonts, colors, and styles, as well as the use of spelling and grammar checks. You'll also learn how to use bulleted and numbered lists to ensure your emails are easy to read and understand.

Editing Email Messages

This lesson is all about polishing your text, so everything is correct. After all, your words may be powerful, but if there are typos or grammatical mistakes, your email message can look less valid and legitimate. In this lesson, you'll learn different ways to proofread and edit email messages. You'll explore the search and replace feature, learn how to create hyperlinks for email and website addresses, learn how to use the signature feature, and explore different styles for your email messages.

Sending Attachments to Email Messages

Sending email messages with file attachments lets you communicate with others using more than just what you can type. You can share a spreadsheet for others to edit, send someone an interesting PDF file to read, or give someone a short video of yourself wishing him a happy birthday. In this lesson, you'll learn how to add files such as word processor documents, spreadsheets, databases, or presentations along with video and audio files to your email messages. You'll also learn how to add images to email messages and edit these using word wrapping and other methods.

Dealing with Wanted and Unwanted Email

In this lesson, you'll learn how to deal with both wanted and unwanted email messages so you can focus your time on having fun and being productive. You'll learn how to delete and retrieve email messages, as well as how to archive them. Most of your email messages will likely be those you want to receive, but too many of them can make it difficult to find what you need, so you will also learn the benefits of creating rules for sorting emails so you can deal with junk email messages easier.

Storing Contact Information

Outlook offers a way to store names and contact information in a database. Not only can this database grow as large as necessary, but no matter how big it gets, Outlook still makes it easy for you to search and find the information you need quickly and accurately. In this lesson, you'll learn all about using Outlook to store contact information of the people most important to you for business and personal use. You'll learn how to create and keep contacts, sharing and search contacts, and group and sort contacts.

Using the Outlook Calendar

Everyone needs to meet people or be at a certain place at a specific time. For busier people, your scheduled appointments may become so numerous and varied that keeping track of your time can be cumbersome. In this lesson, you'll learn all about using Outlook's calendar feature to create and store appointments. You'll identify the different ways to view and use the calendar. You'll also explore setting and viewing appointments, as well as managing, editing, and sharing these appointments.

Creating Task Lists

In this lesson, you'll learn all about using Outlook to create tasks that can help you stay focused on achieving the goals you want to achieve. Outlook makes it easy to create and store your list of tasks that you can view whenever you use Outlook. In this lesson, you'll learn how to create a task list, tag and add details to a task, and manage your tasks. Outlook's task list is just one more tool to help you keep your life organized and focused.

Taking Notes and Customizing Outlook

Once you learn how to use Outlook's note-taking feature, you can learn different keystroke shortcuts and how to customize Outlook further to serve your particular needs better. In this lesson, you'll identify ways to create and modify notes. You'll also identify keystroke shortcuts and how to use these. Along with this, you'll learn different ways to customize Outlook's user interface and change Outlook's settings. You'll also have a chance to reflect on Outlook's various features you find most valuable and then decide how you plan to customize Outlook to make it easier for you.

What you will learn

• Understand the basics of the Outlook 2019 interface and how to navigate the program
• Create a standard Mail view to work from and learn the basics of sending and receiving email
• Get to know everything you need to know about Outlook's contacts, Contacts views, Contact Groups, and Address Books
• Learn how to link Outlook to social media sites, and find out how information from People can appear throughout Outlook
• Learn how to work with one or more Outlook Calendars and the associated items: appointments, meetings, and events.
• Learn how to work with Outlook tasks and to-dos
• Learn how to customize Outlook

How you will benefit

• Harness the full power of Outlook 2019 so you can be more productive
• Learn to better communicate and keep track of all your responsibilities

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

As technology transforms business practices, Microsoft PowerPoint remains one of the most commonly used tools for presentations. This course is perfect for beginners wanting to learn how to effectively use Microsoft PowerPoint 2019 to create professional presentations.

This in-depth course introduces PowerPoint's functions and will teach you how to plan and create professional-quality presentations. You will learn how to catch your audience's attention with PowerPoint's visual features like photo album. As you become acquainted to Office 365, you will learn how to utilize OneDrive and PowerPoint Online's cross-functionality—saving, editing, and sharing your presentations online.

This course is perfect for beginners looking to learn how to use the latest PowerPoint software. You will have the opportunity to create a custom presentation with content specific to your needs. By completion, you will be able to create captivating presentations and contribute to your company's business processes.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft PowerPoint 2019 (desktop version) available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Make presentations go from "so-so" to sensation with PowerPoint. This course will help you learn to use Microsoft PowerPoint 2019/Office 365 to create professional-quality slide presentations that grab attention and make your message memorable from start to finish.

The PowerPoint 2019 Interface

This lesson explores the basic features of Microsoft PowerPoint 2019. You'll explore the Ribbon and learn how to start the PowerPoint program and plan a presentation. You'll also practice working with different views, task panes, tabs, and templates.

Creating Presentations

Now that you know the basics of PowerPoint, it's time to create a presentation from scratch. You'll start by choosing a theme for a presentation and create slides with a variety of slide layouts. You'll explore the Live Preview feature and learn how to save a file for future use. You'll also create and edit slides in Slide pane and Outline view. Finally, you'll explore ways to play a slide show.

Working With Files and Creating and Editing Tables

Including tables in your presentation lets you present a lot of information in a compact space. In this lesson you'll add, revise and format tables. You'll also explore multiple ways to open a presentation. Then, you'll learn how to preserve different versions of your work by saving with new file names.

Creating Professional Presentations

This lesson covers two topics: proofreading and printing. You'll explore the Spelling, AutoCorrect, Thesaurus and Smart Lookup feature. You'll learn to print your presentation as slides, an outline, handouts and notes pages. This versatility really helps you connect with audience members!

Working With the Images Group

This lesson switches gears and works with images instead of text. You'll learn how to embellish your slides with media images, including online pictures, Icons, 3D models and photographs. You'll also learn how to download an image from a website and insert the image on a slide.

WordArt and the Illustrations Group

This lesson includes instructions for using WordArt, Shapes, Icons, 3D Models and SmartArt Graphics. You'll then learn how to transform text into colorful WordArt objects and add Icons and 3D Models. You'll also practice drawing and filling shapes with color and special effects. Finally, you'll learn to group and edit the objects you create and add visual sophistication to your text with SmartArt Graphics.

All About Charts

In this lesson, you'll create a chart to illustrate statistical data. You'll explore chart components and learn how to add and edit specific chart elements. You'll discover how to change the look of your chart by using the options on the Chart Tools contextual tab and the chart formatting buttons.

Making Global Changes to a Presentation

Making duplicate changes to dozens of PowerPoint slides is boring and time-consuming. This lesson focuses on making global changes to slides, handouts, and notes. You'll also make global changes to modify your presentation's background or theme colors.

Creating Links

In this lesson, you'll work with hyperlinks and action buttons. Enliven your presentation as you create links from text or objects to other slides, presentations, documents, and web pages. You can add sounds and 3D effects if desired. Also introduced in this lesson is the Zoom feature which sets up presenter-driven links between slides in a presentation.

Applying Animation to Slides, Text, and Objects

This lesson explores slide transitions and the Transition tab options. You'll apply animation to text and slide objects and use the Animations tab to add animation to slide or layout masters. You'll also find out how to add sound effects, such as a chime or coin sound, to slide transitions.

Adding Advanced Animation Effects to Text and Objects

Using the Animation Pane, you'll add and reorder animated text and objects on slides. You'll discover how to apply advanced animation effects to text and objects on slides, and slide and layout masters. You'll also add an audio clip to your presentation.

Sharing and Saving Your Presentations

In this lesson, you'll focus on different ways to save and share a presentation. You'll practice converting a presentation into a PDF file, so it's accessible on computers without PowerPoint 2019. You'll learn to open, edit, and share your presentation online with PowerPoint Online and a Windows OneDrive account. Last, you'll learn how to transform your presentation into a video.

What you will learn

• Planning and presentation skills
• Formatting a presentation with themes and colors, and use slide and layout masters
• How to utilize text and objects, including Icons, 3D Models, WordArt and SmartArt
• Explore the options on the PowerPoint Ribbon, including the Online Pictures command, File menu options, and Backstage View
• Learn how to print slides, handouts, notes and an outline
• Discover the best views for creating and editing slides, and running a presentation

How you will benefit

• Master PowerPoint skills that help you produce better presentations
• Become an integral company team member with professional presentation design skills
• Gain skills that transfer to any organization and look great on your résumé

Tracy Loffer holds a master's degree in Education in Curriculum and Instruction. She has been involved in education for twenty years, as a music educator and technology trainer. She has also worked in the private sector as a trainer of domestic and international technology franchisees as well as a writer and developmental editor of educational technology materials.

As technology transforms business practices, Microsoft PowerPoint remains one of the most commonly used tools for presentations. This course is perfect for beginners wanting to learn how to effectively use Microsoft PowerPoint 2019 to create professional presentations.

This in-depth course introduces PowerPoint's functions and will teach you how to plan and create professional-quality presentations. You will learn how to catch your audience's attention with PowerPoint's visual features like photo album. As you become acquainted to Office 365, you will learn how to utilize OneDrive and PowerPoint Online's cross-functionality—saving, editing, and sharing your presentations online.

This course is perfect for beginners looking to learn how to use the latest PowerPoint software. You will have the opportunity to create a custom presentation with content specific to your needs. By completion, you will be able to create captivating presentations and contribute to your company's business processes.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft PowerPoint 2019 (desktop version) available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Make presentations go from "so-so" to sensation with PowerPoint. This course will help you learn to use Microsoft PowerPoint 2019/Office 365 to create professional-quality slide presentations that grab attention and make your message memorable from start to finish.

The PowerPoint 2019 Interface

This lesson explores the basic features of Microsoft PowerPoint 2019. You'll explore the Ribbon and learn how to start the PowerPoint program and plan a presentation. You'll also practice working with different views, task panes, tabs, and templates.

Creating Presentations

Now that you know the basics of PowerPoint, it's time to create a presentation from scratch. You'll start by choosing a theme for a presentation and create slides with a variety of slide layouts. You'll explore the Live Preview feature and learn how to save a file for future use. You'll also create and edit slides in Slide pane and Outline view. Finally, you'll explore ways to play a slide show.

Working With Files and Creating and Editing Tables

Including tables in your presentation lets you present a lot of information in a compact space. In this lesson you'll add, revise and format tables. You'll also explore multiple ways to open a presentation. Then, you'll learn how to preserve different versions of your work by saving with new file names.

Creating Professional Presentations

This lesson covers two topics: proofreading and printing. You'll explore the Spelling, AutoCorrect, Thesaurus and Smart Lookup feature. You'll learn to print your presentation as slides, an outline, handouts and notes pages. This versatility really helps you connect with audience members!

Working With the Images Group

This lesson switches gears and works with images instead of text. You'll learn how to embellish your slides with media images, including online pictures, Icons, 3D models and photographs. You'll also learn how to download an image from a website and insert the image on a slide.

WordArt and the Illustrations Group

This lesson includes instructions for using WordArt, Shapes, Icons, 3D Models and SmartArt Graphics. You'll then learn how to transform text into colorful WordArt objects and add Icons and 3D Models. You'll also practice drawing and filling shapes with color and special effects. Finally, you'll learn to group and edit the objects you create and add visual sophistication to your text with SmartArt Graphics.

All About Charts

In this lesson, you'll create a chart to illustrate statistical data. You'll explore chart components and learn how to add and edit specific chart elements. You'll discover how to change the look of your chart by using the options on the Chart Tools contextual tab and the chart formatting buttons.

Making Global Changes to a Presentation

Making duplicate changes to dozens of PowerPoint slides is boring and time-consuming. This lesson focuses on making global changes to slides, handouts, and notes. You'll also make global changes to modify your presentation's background or theme colors.

Creating Links

In this lesson, you'll work with hyperlinks and action buttons. Enliven your presentation as you create links from text or objects to other slides, presentations, documents, and web pages. You can add sounds and 3D effects if desired. Also introduced in this lesson is the Zoom feature which sets up presenter-driven links between slides in a presentation.

Applying Animation to Slides, Text, and Objects

This lesson explores slide transitions and the Transition tab options. You'll apply animation to text and slide objects and use the Animations tab to add animation to slide or layout masters. You'll also find out how to add sound effects, such as a chime or coin sound, to slide transitions.

Adding Advanced Animation Effects to Text and Objects

Using the Animation Pane, you'll add and reorder animated text and objects on slides. You'll discover how to apply advanced animation effects to text and objects on slides, and slide and layout masters. You'll also add an audio clip to your presentation.

Sharing and Saving Your Presentations

In this lesson, you'll focus on different ways to save and share a presentation. You'll practice converting a presentation into a PDF file, so it's accessible on computers without PowerPoint 2019. You'll learn to open, edit, and share your presentation online with PowerPoint Online and a Windows OneDrive account. Last, you'll learn how to transform your presentation into a video.

What you will learn

• Planning and presentation skills
• Formatting a presentation with themes and colors, and use slide and layout masters
• How to utilize text and objects, including Icons, 3D Models, WordArt and SmartArt
• Explore the options on the PowerPoint Ribbon, including the Online Pictures command, File menu options, and Backstage View
• Learn how to print slides, handouts, notes and an outline
• Discover the best views for creating and editing slides, and running a presentation

How you will benefit

• Master PowerPoint skills that help you produce better presentations
• Become an integral company team member with professional presentation design skills
• Gain skills that transfer to any organization and look great on your résumé

Tracy Loffer holds a master's degree in Education in Curriculum and Instruction. She has been involved in education for twenty years, as a music educator and technology trainer. She has also worked in the private sector as a trainer of domestic and international technology franchisees as well as a writer and developmental editor of educational technology materials.

Discover how to effectively plan and implement projects using the world's most popular project management software, Microsoft Project 2019.

Microsoft Project is a staple for project management and remains the most widely-used project management software across all industries. If you manage projects in your organization, learning how to use this longstanding resource is key to successfully and effectively seeing your projects through to completion.

In this course, you will discover how to effectively plan, implement, and control projects using Microsoft Project 2019. From sequencing tasks, producing a baseline, and assigning resources and costs, to tracking progress and revising your project plan, Microsoft Project can help you organize all your project's details.

Armed with this information, you will avoid stalling or overloading your schedule. If you encounter trouble, you will know how to best utilize Project 2019 to get your project back on track.

Requirements:

Hardware Requirements:

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

Software Requirements:

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

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Learn to effectively plan, implement, and control projects using Microsoft Project 2019/Office 365. This course will help you master the basics to create and share a project schedule, track costs and resources, produce reports, and resolve problems to keep your projects on track.

Overview of Microsoft Project

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

Creating a Solid Foundation

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

Creating and Managing Resources

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

Defining and Assigning Costs

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

Project Templates, Security, and Constraints

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

Working With Views and Managing Information

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

Fine-Tuning Your Project Plan

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

Baselines and Tracking

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

Managing Variances

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

Closing Your Project

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

Printing Views

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

Using and Creating Reports

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

What you will learn

• Effective planning, implementation, and control projects using Microsoft Project
• How to enhance your project in the areas of efficiency and security
• The importance of setting a project baseline and tracking actual results
• Generate several standard project reports and a wide variety of visual project reports

How you will benefit

• Know how to the use of the world's most popular project management software
• Gain transferable skills
• Replace informal project plans with plans based on logic and structures reflective

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

Discover how to effectively plan and implement projects using the world's most popular project management software, Microsoft Project 2019.

Microsoft Project is a staple for project management and remains the most widely-used project management software across all industries. If you manage projects in your organization, learning how to use this longstanding resource is key to successfully and effectively seeing your projects through to completion.

In this course, you will discover how to effectively plan, implement, and control projects using Microsoft Project 2019. From sequencing tasks, producing a baseline, and assigning resources and costs, to tracking progress and revising your project plan, Microsoft Project can help you organize all your project's details.

Armed with this information, you will avoid stalling or overloading your schedule. If you encounter trouble, you will know how to best utilize Project 2019 to get your project back on track.

Requirements:

Hardware Requirements:

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

Software Requirements:

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

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Learn to effectively plan, implement, and control projects using Microsoft Project 2019/Office 365. This course will help you master the basics to create and share a project schedule, track costs and resources, produce reports, and resolve problems to keep your projects on track.

Overview of Microsoft Project

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

Creating a Solid Foundation

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

Creating and Managing Resources

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

Defining and Assigning Costs

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

Project Templates, Security, and Constraints

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

Working With Views and Managing Information

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

Fine-Tuning Your Project Plan

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

Baselines and Tracking

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

Managing Variances

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

Closing Your Project

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

Printing Views

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

Using and Creating Reports

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

What you will learn

• Effective planning, implementation, and control projects using Microsoft Project
• How to enhance your project in the areas of efficiency and security
• The importance of setting a project baseline and tracking actual results
• Generate several standard project reports and a wide variety of visual project reports

How you will benefit

• Know how to the use of the world's most popular project management software
• Gain transferable skills
• Replace informal project plans with plans based on logic and structures reflective

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

Learn how the foundational skills needed to utilize Microsoft Word 2019 in Office 365. This course will teach you how to create professional-looking letters, reports, and documents.

Across all industries, the ability to create documents in a word processor is essential in day-to-day functions. From writing reports to Knowing how to use Microsoft Word, the most widely-used word processing program, adds an important skill set to your professional profile.

This course will introduce you to the 2019 version of Microsoft Word, available with the Microsoft 365 platform. You will learn the basics of Word 2019 needed to write and edit text and to create, format, and organize documents. By the time you're done with these hands-on activities, you will be able to use Word confidently at home or on the job.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
• Microsoft Word 2019 (desktop version) available with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment)
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Learn to create professional-looking letters, reports, and documents using Microsoft Word 2019/Office 365. This hands-on course will help you master the basic features of this powerful word-processing program to type, edit, and format text, and spell check and print documents like a pro.

Getting Started

In this introductory lesson, you'll learn how to use the different parts of Word 2019's user interface, how to look at your document in 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, so in this lesson, you'll go over the basics of moving the Insertion Pointer, or Cursor, and deleting text. Pressing the BACKSPACE and DELETE keys can delete text one character at a time. The keyboard lets you move the cursor one character, one word, or one line at a time. The mouse lets you quickly move the cursor and scroll through large documents far faster than the keyboard. 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're going to learn how to save the documents you create in Word. You'll learn how to save documents with unique names, as well as in other formats so that you can share your documents with people using different word processors or even different computers. Finally, you'll learn how to rename, copy, and even delete any files you've created so that you'll 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. The easiest way to edit is to delete individual characters using the BACKSPACE or DELETE keys. Another option is using Word's Overtype mode by typing over text you no longer need. If you ever delete anything by mistake, don't panic! Word's handy Undo and Redo commands retrieve unintentionally deleted text. You may also want to delete large chunks of text. Use your keyboard or mouse in tandem with the BACKSPACE or DELETE keys to efficiently remove entire sections of text. By learning how to delete text and undo mistakes, you can edit your documents quickly using Word.

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 can be handy for copying text from one document to another, comparing two different drafts of the same document, or simply using one document as a reference while writing in the second one. By learning how to open, switch between, and view multiple documents, you can increase your productivity with Word.

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 the actual size of text, alter the alignment of text, and even choose different fonts to modify the way individual letters look. As you can see, Word provides plenty of ways to help you both edit text and change it so it looks visually appealing.

Printing

Most people use Word to print letters and reports. But Word also helps you get creative by letting you choose different paper sizes and orientations. For example, you can print a letter in portrait orientation or print a sign in landscape orientation. Just think of turning a page up so its height is taller than its width (portrait orientation) or turning the page on its side so its width is wider than its height (landscape orientation). Word also lets you choose to print on different paper sizes, such as envelopes, just as long as you can run those odd-shaped paper sheets in your printer. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents using Word.

Margins, Tabs, and Page Numbering

Most of the time when you create a document, you can use the default page settings. But sometimes you may want to modify those settings to change margins around a page to give you more (or less) space on the top, bottom, left, or right sides of a page. 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'll also learn how to add page numbers to the top or bottom of a page to keep track of the right page order when you print out your document.

Paragraph Formatting

Word can be handy for typing and formatting text, but once you've written several paragraphs worth of text, you may need to format individual paragraphs separately from the rest of your document. 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 numbered lists, so you can display short bits of information in a visual manner. With Word's various paragraph-formatting options, you can customize the appearance of all your paragraphs.

Language Tools

It's not enough just to write and format your text. After you're done writing, you may need to check your spelling, change your words, and even hyphenate your text to make your entire document look the best it can. 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. With so many ways to polish your document, there's no reason not to write exactly what you want to say with Word.

Customizing Word

Word can easily handle any characters you type with a keyboard, but sometimes you may need to type an occasional foreign language character, a mathematical symbol, or another unusual character that doesn't appear on your keyboard. 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, even smiley faces. You probably won't need to type all of these characters regularly, so just find the ones you'll likely need and remember how to use them. 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

Writing involves more than just typing and editing text. With Word's advanced features, you can insert page breaks and cover pages to adjust how your text appears when you print it out. To make text on each page look its best, you can use drop caps and styles. 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

• Fundamentals of one of the most crucial software applications in the modern workplace
• Skills and tools needed to adjust margins, spacing, layout, and design of any Word document
• How to work on multiple projects at once and become faster and more efficient in a variety of Microsoft Word tasks
• Techniques for modifying the appearance of your documents in order to suit your needs

How you will benefit

• Gain the confidence needed 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 2019
• Become more proficient with one of the most widely used software programs in history

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.

Learn how the foundational skills needed to utilize Microsoft Word 2019 in Office 365. This course will teach you how to create professional-looking letters, reports, and documents.

Across all industries, the ability to create documents in a word processor is essential in day-to-day functions. From writing reports to Knowing how to use Microsoft Word, the most widely-used word processing program, adds an important skill set to your professional profile.

This course will introduce you to the 2019 version of Microsoft Word, available with the Microsoft 365 platform. You will learn the basics of Word 2019 needed to write and edit text and to create, format, and organize documents. By the time you're done with these hands-on activities, you will be able to use Word confidently at home or on the job.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
• Microsoft Word 2019 (desktop version) available with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment)
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

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

Learn to create professional-looking letters, reports, and documents using Microsoft Word 2019/Office 365. This hands-on course will help you master the basic features of this powerful word-processing program to type, edit, and format text, and spell check and print documents like a pro.

Getting Started

In this introductory lesson, you'll learn how to use the different parts of Word 2019's user interface, how to look at your document in 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, so in this lesson, you'll go over the basics of moving the Insertion Pointer, or Cursor, and deleting text. Pressing the BACKSPACE and DELETE keys can delete text one character at a time. The keyboard lets you move the cursor one character, one word, or one line at a time. The mouse lets you quickly move the cursor and scroll through large documents far faster than the keyboard. 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're going to learn how to save the documents you create in Word. You'll learn how to save documents with unique names, as well as in other formats so that you can share your documents with people using different word processors or even different computers. Finally, you'll learn how to rename, copy, and even delete any files you've created so that you'll 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. The easiest way to edit is to delete individual characters using the BACKSPACE or DELETE keys. Another option is using Word's Overtype mode by typing over text you no longer need. If you ever delete anything by mistake, don't panic! Word's handy Undo and Redo commands retrieve unintentionally deleted text. You may also want to delete large chunks of text. Use your keyboard or mouse in tandem with the BACKSPACE or DELETE keys to efficiently remove entire sections of text. By learning how to delete text and undo mistakes, you can edit your documents quickly using Word.

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 can be handy for copying text from one document to another, comparing two different drafts of the same document, or simply using one document as a reference while writing in the second one. By learning how to open, switch between, and view multiple documents, you can increase your productivity with Word.

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 the actual size of text, alter the alignment of text, and even choose different fonts to modify the way individual letters look. As you can see, Word provides plenty of ways to help you both edit text and change it so it looks visually appealing.

Printing

Most people use Word to print letters and reports. But Word also helps you get creative by letting you choose different paper sizes and orientations. For example, you can print a letter in portrait orientation or print a sign in landscape orientation. Just think of turning a page up so its height is taller than its width (portrait orientation) or turning the page on its side so its width is wider than its height (landscape orientation). Word also lets you choose to print on different paper sizes, such as envelopes, just as long as you can run those odd-shaped paper sheets in your printer. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents using Word.

Margins, Tabs, and Page Numbering

Most of the time when you create a document, you can use the default page settings. But sometimes you may want to modify those settings to change margins around a page to give you more (or less) space on the top, bottom, left, or right sides of a page. 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'll also learn how to add page numbers to the top or bottom of a page to keep track of the right page order when you print out your document.

Paragraph Formatting

Word can be handy for typing and formatting text, but once you've written several paragraphs worth of text, you may need to format individual paragraphs separately from the rest of your document. 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 numbered lists, so you can display short bits of information in a visual manner. With Word's various paragraph-formatting options, you can customize the appearance of all your paragraphs.

Language Tools

It's not enough just to write and format your text. After you're done writing, you may need to check your spelling, change your words, and even hyphenate your text to make your entire document look the best it can. 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. With so many ways to polish your document, there's no reason not to write exactly what you want to say with Word.

Customizing Word

Word can easily handle any characters you type with a keyboard, but sometimes you may need to type an occasional foreign language character, a mathematical symbol, or another unusual character that doesn't appear on your keyboard. 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, even smiley faces. You probably won't need to type all of these characters regularly, so just find the ones you'll likely need and remember how to use them. 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

Writing involves more than just typing and editing text. With Word's advanced features, you can insert page breaks and cover pages to adjust how your text appears when you print it out. To make text on each page look its best, you can use drop caps and styles. 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

• Fundamentals of one of the most crucial software applications in the modern workplace
• Skills and tools needed to adjust margins, spacing, layout, and design of any Word document
• How to work on multiple projects at once and become faster and more efficient in a variety of Microsoft Word tasks
• Techniques for modifying the appearance of your documents in order to suit your needs

How you will benefit

• Gain the confidence needed 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 2019
• Become more proficient with one of the most widely used software programs in history

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.