Description:
This course covers the basic skills and concepts students need to use Microsoft Access 2013 productively and efficiently. After an introduction to the Access 2013 environment, students will learn how to plan databases and create tables. Then they will learn to organize fields and records, and to work with data entry rules. Finally students will learn how to create basic queries, and how to work with forms and reports.

This course will help students prepare for the Microsoft Office Specialist exam for Access 2013 (exam 77-424). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Access 2013.

Table Of Contents:

Unit 1: Getting started
Topic A: Database Concepts
Topic B: Exploring the Access environment

Unit 2: Databases and tables
Topic A: Planning and designing databases
Topic B: Exploring tables
Topic C: Creating tables

Unit 3: Fields and records
Topic A: Changing the design of a table
Topic B: Finding and editing records
Topic C: Organizing records

Unit 4: Data Entry rules
Topic A: Setting field properties
Topic B: Working with input masks
Topic C: Setting validation rules

Unit 5: Basic queries
Topic A: Creating and using queries
Topic B: Modifying query results and queries
Topic C: Performing operations in queries

Unit 6: Using forms
Topic A: Creating forms
Topic B: Using Design view
Topic C: Sorting and filtering records

Unit 7: Working with reports
Topic A: Creating reports
Topic B: Modifying and printing reports

Description:
This course provides students with additional skills and concepts needed to use Microsoft Access 2013 productively and efficiently. They will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms and reports, insert background images and charts; and create specialized objects such as lookup fields, subforms and subreports, navigation forms, and calculated fields.

This course will help students prepare for the Microsoft Office Specialist exam for Access 2013 (exam 77-424). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Access 2013.

Table Of Contents:

Unit 1: Relational databases
Topic A: Database normalization
Topic B: Table relationships
Topic C: Referential integrity

Unit 2: Related tables
Topic A: Creating lookup fields
Topic B: Modifying lookup fields
Topic C: Subdatasheets

Unit 3: Complex queries
Topic A: Joining tables in queries
Topic B: Using calculated fields
Topic C: Summarizing and grouping values

Unit 4: Advanced form design
Topic A: Adding unbound controls
Topic B: Graphics
Topic C: Adding calculated values
Topic D: Adding combo boxes
Topic E: Advanced form types

Unit 5: Reports and printing
Topic A: Report formatting
Topic B: Calculated values and subreports
Topic C: Printing
Topic D: Label printing

Unit 6: Charts
Topic A: Charts in forms
Topic B: Charts in reports

Description:
This course provides students with additional skills and concepts needed to use Microsoft Access 2013 productively and efficiently. They will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms and reports, insert background images and charts; and create specialized objects such as lookup fields, subforms and subreports, navigation forms, and calculated fields.

This course will help students prepare for the Microsoft Office Specialist exam for Access 2013 (exam 77-424). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Access 2013.

Table Of Contents:

Description:
This course will familiarize students with spreadsheet terminology and the fundamental concepts of Microsoft Excel 2016, including identifying Excel window components, navigating worksheets, and downloading templates. In addition, students will learn the basics of entering and editing text, values, and formulas, and how to save workbooks in the native Excel format, as well as in other formats. They will learn how to move and copy data and formulas, how to determine absolute and relative references, and how to work with ranges, rows, and columns. Students will also learn how to use simple functions, and how to easily apply formatting techniques to worksheet data. They will create and modify charts, and work with graphics. Finally, they will review workbooks for spelling errors, modify page setup, and print worksheets.

This course will help students prepare for the Microsoft Office Specialist core-level exam for Excel 2016 (exam 77-727) and the Microsoft Office Specialist Expert exam for Excel 2016 (exam 77-728). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Excel 2016.

Microsoft Office Excel 2016_ Part 1

Description:
This course will teach students how to work with large worksheets in Microsoft Excel 2016, and use multiple worksheets and workbooks efficiently. It will introduce them to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. In addition, students will learn how to create outlines and subtotals, and how to create and apply cell names. They will sort and filter data, and create and format tables. They will learn how to save workbooks as Web pages, how to insert and edit hyperlinks, and how to share workbooks via email. Students will learn how to audit worksheets for errors, how to protect worksheets, how to share and merge workbooks, and track changes in a workbook. Finally, students will customize the Excel environment, and create and modify custom templates.

This course will help students prepare for the Microsoft Office Specialist core-level exam for Excel 2016 (exam 77-727) and the Microsoft Office Specialist Expert exam for Excel 2016 (exam 77-728). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Excel 2016.

Microsoft Office Excel 2016_ Part 2

Course Objectives:

Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

You will:

• Work with multiple worksheets and workbooks.
• Use Lookup functions and formula auditing
• Share and protect workbooks.
• Automate workbook functionality.
• Create sparklines and map data.
• Forecast data.

Target Student:

This course is intended for students who are experienced Excel 2016 users and have a desire or need to advance their skills in working with some of the more advanced Excel features.

Prerequisites:

Students must complete or possess the equivalent skill level derived from:

• Microsoft® Office Excel® 2016: Part 1
• Microsoft® Office Excel® 2016: Part 2

Course Content

Lesson 1: Working with Multiple Worksheets and Workbooks

• Topic A: Use Links and External Reference
• Topic B: Use 3-D References
• Topic C: Consolidate Data

Lesson 2: Using Lookup Functions and Formula Auditing

•  Topic A: Use Lookup Functions
•  Topic B: Trace Cells
•  Topic C: Watch and Evaluate Formulas

Lesson 3: Sharing and Protecting Workbooks

•  Topic A: Collaborate on a Workbook
•  Topic B: Protect Worksheets and Workbooks

Lesson 4: Automating Workbook Functionality

•  Topic A: Apply Data Validation
•  Topic B: Search for Invalid Data and Formulas with Errors
•  Topic C: Work with Macros

Lesson 5: Creating Sparklines and Mapping Data

•  Topic A: Create Sparklines
•  Topic B: Map Data

Lesson 6: Forecasting Data

•  Topic A: Determine Potential Outcomes Using Data Tables
•  Topic B: Determine Potential Outcomes Using Scenarios
•  Topic C: Use the Goal Seek Feature
•  Topic D: Forecasting Data Trends

Appendix A: Microsoft Office Excel 2016 Exam 77-727

Appendix B: Microsoft Office Excel 2016 Expert Exam 77–728

Appendix C: Microsoft Excel 2016 Common Keyboard Shortcuts

Appendix D: Cube Functions

Appendix E: Importing and Export Data

Appendix F: Internationalizing Workbooks

Appendix G: Working with Power Pivot

Appendix H: Advanced Customization Options

Appendix I: Working with Forms and Controls

Description:
Email has become one of the most widely used methods of communication, whether for personal or business communications. In most organizations, large or small, email is the preferred form of communicating information amongst employees. As email grows in popularity and use, most organizations have found the need to implement a corporate mail management system such as Microsoft® Office Outlook® to handle the messages and meeting invitations sent among employees.

In this course, you will use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create tasks and notes for yourself, and customize the Outlook interface to suit your working style. This course is the first in a series of two Microsoft® Office Outlook® 2016 courses. It will provide you with the basic skills you need to start using Outlook 2016 to manage your email communications, contact information, calendar events, tasks, and notes.
You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Outlook 2016.

Table Of Contents:

Microsoft Office Outlook 2016_ Part 1

Description:

In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate many management tasks, work with calendars and contacts, manage tasks, protect data with archiving and data files, as well as share and delegate access to your workspaces. In short, you’ll work with a wide range of features and options and, in so doing, understand why Outlook is a leading personal management system.

This course builds upon the foundational knowledge presented in the Microsoft ® Office Outlook® 2016: Part 1 course and will help you customize a communication system well-suited to your work styles. In addition, this course will help you prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Outlook 2016.

Table Of Contents:

Microsoft Office Outlook 2016_ Part 2

Description:
This course covers the basic functions and features of PowerPoint 2013. After an introduction to PowerPoint’s window components, students will open and run a presentation and switch between views. They’ll create a basic presentation and add content; arrange, insert, and delete slides; and apply templates and design themes. Then, they’ll learn how to create and edit shapes, insert and modify WordArt objects and pictures, and work with tables, charts, and diagrams. Finally, they’ll learn how to proof a presentation, create speaker notes, and present and share their presentations.

This course will help students prepare for the Microsoft Office Specialist exam for PowerPoint 2013 (exam 77-422). For comprehensive certification training, students should complete the Basic and Advanced courses for PowerPoint 2013.

Table Of Contents:

Unit 1: Getting started
Topic A: The PowerPoint interface

Unit 2: Creating presentations
Topic A: Creating a basic presentation
Topic B: Working with slides

Unit 3: Editing slide content
Topic A: Formatting text and lists
Topic B: Editing efficiently

Unit 4: Working with shapes
Topic A: Creating shapes
Topic B: Formatting shapes
Topic C: Applying content to shapes

Unit 5: Graphics
Topic A: WordArt
Topic B: Pictures

Unit 6: Tables and charts
Topic A: Tables
Topic B: Charts
Topic C: SmartArt

Unit 7: Preparing and printing presentations
Topic A: Proofing presentations
Topic B: Preparing a presentation
Topic C: Printing presentations

Description:
In this course, students will build on the skills and concepts taught in PowerPoint 2013: Basic. Students will learn to control global settings by using slide masters, and to apply effects such as transitions and timings. They’ll learn more about working with images, and how to include media files, animation, and a photo album in a presentation. Next, they’ll explore advanced tools for working with SmartArt, tables, and charts, and then learn how to create action buttons and equations. Students will also integrate other Microsoft Office files, embed and link external resources, and create hyperlinks. Then, they’ll insert review comments, protect a presentation with a password, and prepare a presentation for delivery in various formats. Finally, they’ll customize application settings and toolbars, and create and apply custom themes.

This course will help students prepare for the Microsoft Office Specialist exam for PowerPoint 2013 (exam 77-422). For comprehensive certification training, students should complete the Basic and Advanced courses for PowerPoint 2013.

Table Of Contents:

Unit 1: Slide masters and transitions
Topic A: Slide masters
Topic B: Transitions and timings
Topic C: Custom slide shows

Unit 2: Graphics and media
Topic A: Modifying graphics
Topic B: Media clips
Topic C: Animations
Topic D: Photo albums

Unit 3: Customizing slide elements
Topic A: Working with SmartArt graphics
Topic B: Customizing tables
Topic C: Working with charts

Unit 4: Action buttons and equations
Topic A: Action buttons
Topic B: Equations

Unit 5: Integrating Microsoft Office files
Topic A: Applying content from a Word outline
Topic B: Embedding and linking content

Unit 6: Finalizing and distributing presentations
Topic A: Reviewing and finishing
Topic B: Distributing presentations

Unit 7: Customizing PowerPoint
Topic A: Application settings

Description:
This course covers the basic functions and features of PowerPoint 2013. After an introduction to PowerPoint’s window components, students will open and run a presentation and switch between views. They’ll create a basic presentation and add content; arrange, insert, and delete slides; and apply templates and design themes. Then, they’ll learn how to create and edit shapes, insert and modify WordArt objects and pictures, and work with tables, charts, and diagrams. Finally, they’ll learn how to proof a presentation, create speaker notes, and present and share their presentations.

This course will help students prepare for the Microsoft Office Specialist exam for PowerPoint 2013 (exam 77-422). For comprehensive certification training, students should complete the Basic and Advanced courses for PowerPoint 2013.

Table Of Contents:

Unit 1: Getting started
Topic A: The PowerPoint interface

Unit 2: Creating presentations
Topic A: Creating a basic presentation
Topic B: Working with slides

Unit 3: Editing slide content
Topic A: Formatting text and lists
Topic B: Editing efficiently

Unit 4: Working with shapes
Topic A: Creating shapes
Topic B: Formatting shapes
Topic C: Applying content to shapes

Unit 5: Graphics
Topic A: WordArt
Topic B: Pictures

Unit 6: Tables and charts
Topic A: Tables
Topic B: Charts
Topic C: SmartArt

Unit 7: Preparing and printing presentations
Topic A: Proofing presentations
Topic B: Preparing a presentation
Topic C: Printing presentations

Description:
This course will teach students how to work with large worksheets in Microsoft Excel 2013, and use multiple worksheets and workbooks efficiently. It will introduce them to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. In addition, students will learn how to create outlines and subtotals, and how to create and apply cell names. They will sort and filter data, and create and format tables. They will learn how to save workbooks as Web pages, how to insert and edit hyperlinks, and how to share workbooks via email. Students will learn how to audit worksheets for errors, how to protect worksheets, how to share and merge workbooks, and track changes in a workbook. Finally, students will customize the Excel environment, and create and modify custom templates.

This course will help students prepare for the Microsoft Office Specialist core-level exam for Excel 2013 (exam 77-420) and the Microsoft Office Specialist Expert exam for Excel 2013 (exam 77-421). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Excel 2013.

Table Of Contents:

Unit 1: Managing workbooks and worksheets
Topic A: Viewing large worksheets
Topic B: Printing large worksheets
Topic C: Working with multiple worksheets
Topic D: Linking worksheets with 3-D formulas
Topic E: Using multiple workbooks
Topic F: Linking workbooks

Unit 2: Advanced formatting
Topic A: Using special number formats
Topic B: Working with themes
Topic C: Other advanced formatting

Unit 3: Outlining and subtotals
Topic A: Outlining and consolidating data
Topic B: Creating subtotals

Unit 4: Cell and range names
Topic A: Creating and using names
Topic B: Managing names

Unit 5: Data structure and tables
Topic A: Sorting and filtering data
Topic B: Working with tables

Unit 6: Web and sharing features
Topic A: Saving workbooks as Web pages
Topic B: Using hyperlinks

Unit 7: Documenting and auditing
Topic A: Auditing features
Topic B: Comments in cells and workbooks
Topic C: Protection
Topic D: Workgroup collaboration

Unit 8: Application settings and templates
Topic A: Application settings
Topic B: Working with templates

Description:
In this course, students will further build on the skills acquired in the Microsoft Excel 2013 Basic and Intermediate courses. They will work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation, and will use advanced data filtering. They will apply advanced chart formatting options, and create more complex charts. They will work with PivotTables and PivotCharts, export and import data, and query external databases. Students will learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, they will run and record macros, and explore VBA code.

This course will help students prepare for the Microsoft Office Specialist core-level exam for Excel 2013 (exam 77-420) and the Microsoft Office Specialist Expert exam for Excel 2013 (exam 77-421). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Excel 2013.

Table Of Contents:

Unit 1: Advanced functions and formulas
Topic A: Logical functions
Topic B: Conditional functions
Topic C: Financial functions
Topic D: Text functions
Topic E: Date and time functions
Topic F: Array formulas
Topic G: Calculation options

Unit 2: Lookups and data tables
Topic A: Using lookup functions
Topic B: Creating data tables

Unit 3: Advanced data management
Topic A: Validating cell entries
Topic B: Advanced filtering

Unit 4: Advanced charting
Topic A: Chart formatting options
Topic B: Combination charts
Topic C: Graphical objects

Unit 5: PivotTables and PivotCharts
Topic A: Working with PivotTables
Topic B: Modifying PivotTable data
Topic C: Formatting PivotTables
Topic D: Using PivotCharts
Topic E: PowerPivot

Unit 6: Exporting and importing data
Topic A: Exporting and importing text files

Unit 7: Analytical tools
Topic A: Goal Seek
Topic B: Scenarios
Topic C: Instant data analysis

Unit 8: Macros and Visual Basic
Topic A: Running and recording a macro
Topic B: Working with VBA code

Unit 9: Accessibility and language features
Topic A: Accessibility considerations
Topic B: Internationalization

Description:
This course covers the basic skills and concepts students need to use Microsoft Word 2013 productively and efficiently. After an introduction to Word’s window components, students will learn how to create and save documents and how to navigate documents. Then they will edit, copy and paste, and find and replace text. They will also learn how to enhance the appearance of a document by using various formatting options. In addition, they will create tables, adjust page layout, work with graphics, use styles and outlines, and proof and print documents.

Table Of Contents:

Unit 1: Getting started
Topic A: The Word window
Topic B: New documents
Topic C: Document navigation

Unit 2: Editing text
Topic A: Working with text
Topic B: The Undo and Redo commands
Topic C: Cut, copy, and paste
Topic D: Find and replace

Unit 3: Formatting text
Topic A: Character formatting
Topic B: Tab settings
Topic C: Paragraph formatting
Topic D: Paragraph spacing and indents

Unit 4: Tables
Topic A: Creating tables
Topic B: Working with table content
Topic C: Changing the table structure
Topic D: Table design options
Topic E: Table data

Unit 5: Page layout
Topic A: Headers and footers
Topic B: Page setup

Unit 6: Graphics
Topic A: Adding graphics and clip art
Topic B: Working with graphics

Unit 7: Styles and outlines
Topic A: Examining formatting
Topic B: Working with styles
Topic C: Working with outlines

Unit 8: Proofing, printing, and exporting
Topic A: Spelling and grammar
Topic B: AutoCorrect
Topic C: Printing and exporting documents

Description:
This course will further build on the skills acquired in the Microsoft Word basic course. Students will learn to use styles and outlines, and how to format tables. Then they will insert SmartArt diagrams, work with shapes, and format text graphically. They will also learn how to format a document by adding sections, columns, and design elements such as watermarks and themes. In addition, they will use Track Changes and prepare documents for sharing and exporting. Finally, students will learn how to work with fields and perform a mail merge.
This course will help students prepare for the Microsoft Office Specialist core-level exam for Word 2013 (exam 77-418) and the Microsoft Office Specialist Expert exam for Word 2013 (exam 77-419). For comprehensive certification training, students should complete the Basic and Advanced courses for Word 2013.
Table Of Contents:

Unit 1: Styles and outlines
Topic A: Examining formatting
Topic B: Working with styles
Topic C: Working with outlines

Unit 2: Table formatting
Topic A: Table design options
Topic B: Table data

Unit 3: Illustrations
Topic A: Creating diagrams
Topic B: Working with shapes
Topic C: Formatting text graphically

Unit 4: Advanced document formatting
Topic A: Creating and formatting sections
Topic B: Working with columns
Topic C: Document design

Unit 5: Document sharing
Topic A: Document properties
Topic B: Tracking changes
Topic C: Finalizing documents

Unit 6: Mail Merge
Topic A: Form letters
Topic B: Data sources for the recipient list
Topic C: Mailing labels and envelopes

Description:
In this course, students will further build on the skills acquired in the Microsoft Word intermediate course. Students will learn to do a mail merge and create form letters. Then they will learn how to create and format sections, create a table of contents and captions, etc.
This course will help students prepare for the Microsoft Office Specialist core-level exam for Word 2013 (exam 77-418) and the Microsoft Office Specialist Expert exam for Word 2013 (exam 77-419). For comprehensive certification training, students should complete the Basic, Intermediate and Advanced courses for Word 2013.
Table Of Contents:

Unit 1: Mail Merge
Topic A: Form letters
Topic B: Data sources for the recipient list
Topic C: Mailing labels and envelopes
Unit 2: Illustrations
Topic A: Creating diagrams
Topic B: Working with shapes
Topic C: Formatting text graphically
Unit 3: Advanced document formatting
Topic A: Creating and formatting sections
Topic B: Working with columns
Topic C: Document design
Unit 4: Document references
Topic A: Tables of contents and captions
Topic B: Indexes, bibliographies, and footnotes
Unit 5: Document sharing
Topic A: Document properties
Topic B: Tracking changes
Topic C: Finalizing documents
Unit 6: Document interactivity
Topic A: Creating forms
Topic B: Inserting objects and charts
Topic C: Web pages
Unit 7: Working in Word efficiently
Topic A: Customizing the ribbon
Topic B: Macros

Description:

This course covers the fundamentals of using QuickBooks to track the finances of a small business. Students will learn how to set up a new company, manage bank account transactions, maintain customer, job, and vendor information, manage inventory, generate reports, and use the Company Snapshot window. Students will also create invoices and credit memos, write and print checks, add custom fields, set up budgets, and learn how to protect and back up their data.

Table Of Contents:

QB_Level01

Description:

In this course, students will further build on the skills acquired in the QuickBooks basic course. Students will learn how to memorize transactions, customize forms, generate reports, create graphs and prepare payroll. Students will also create job estimates and use the time tracking features of the application.

Table Of Contents:

Description:
Photoshop CS6: Basic, ACE Edition, is part of a three-course series that will help students prepare for the Adobe Certified Expert exam for Photoshop CS6. Students will modify digital images to add creative effects and repair defects. After completing this course, the student will be able to use Photoshop CS6 to make selections, create and transform layers, apply image adjustments, retouch and repair photographs, resize images, and use Adobe Bridge to view and organize files.

Table Of Contents:

Unit 1: Getting started
Topic A: File types
Topic B: The Photoshop environment
Topic C: Tool options and presets

Unit 2: Image selections
Topic A: Selection techniques
Topic B: Modifying selections

Unit 3: Layers
Topic A: Creating layers
Topic B: Transform controls
Topic C: Using type layers
Topic D: Creating paragraph styles

Unit 4: Basic image adjustments
Topic A: Levels adjustments
Topic B: Curves adjustments

Unit 5: Repairing and retouching images
Topic A: Repairing image defects
Topic B: Retouching images
Topic C: Removing image areas
Topic D: Painting
Topic E: Using filters

Unit 6: Resizing images
Topic A: Image resolution
Topic B: Image canvas size

Unit 7: Managing files with Adobe Bridge
Topic A: Browsing files in Adobe Bridge
Topic B: Working with metadata
Topic C: Organizing collections
Topic D: Outputting projects

Appendix A: ACE exam objectives map
Topic A: Comprehensive exam objectives

Description:
Photoshop CS6: Production, ACE Edition, is part two of a three-course series that will help students prepare for the Adobe Certified Expert exam for Photoshop CS6. Students will learn techniques for preparing consistent, high-quality images for both print and electronic media. After completing this course, the student will be able to use Photoshop CS6 to work with camera raw images and automate actions, create panoramas and HDR images as well as simulate effects used in photography, apply color management and print with color management, prepare CMYK color separations, optimize images for online use, and create frame-based and video animations.

Table Of Contents:

Unit 1: Camera Raw and batch processing
Topic A: Basic Camera Raw adjustments
Topic B: Selective Camera Raw corrections
Topic C: Batch processing in Camera Raw
Topic D: Automation in Photoshop and Bridge

Unit 2: Photographic techniques
Topic A: Panoramas
Topic B: HDR images
Topic C: Photographic adjustments
Topic D: Lens adjustments

Unit 3: Color management
Topic A: Color management basics
Topic B: Color space conversion
Topic C: Printing with color management

Unit 4: CMYK separations
Topic A: Prepress color settings
Topic B: CMYK image adjustments

Unit 5: Web images
Topic A: Optimizing images for the Web
Topic B: Creating transparency
Topic C: Creating frame-based animation

Unit 6: Timeline animation
Topic A: Working with video in Photoshop
Topic B: Editing video clips
Topic C: Video transitions
Topic D: Video design elements
Topic E: Publishing video

Appendix A: ACE exam objectives map
Topic A: Comprehensive exam objectives

Description:
Photoshop CS6: Advanced, ACE Edition, is the final part of a three-course series that will help students prepare for the Adobe Certified Expert exam for Photoshop CS6. Students will modify digital images and learn additional techniques for creating image effects. After completing this course, the student will be able to use Photoshop CS6 to work with multiple layers, use color and gradient fills and adjust color, create layer masks, create and edit vector shapes, and apply a variety of creative effects such as Puppet Warp and Liquify.

Table Of Contents:

Unit 1: Working with multiple layers
Topic A: Layer groups
Topic B: Blending modes
Topic C: Smart Objects
Topic D: Layer comps

Unit 2: Working with color
Topic A: Filling image areas
Topic B: Gradients and overlays
Topic C: Color adjustments

Unit 3: Masks
Topic A: Mask channels
Topic B: Layer masks
Topic C: Refine selections and masks

Unit 4: Vector shapes
Topic A: Vector layers
Topic B: Vector shapes
Topic C: Editing vector paths
Topic D: Vector paths and type

Unit 5: Creative image effects
Topic A: Warping
Topic B: Liquify
Topic C: Black and white and duotone images
Topic D: Smart Filters

Appendix A: ACE exam objectives map
Topic A: Comprehensive exam objectives