- VIDEO COURSES
- SUBSCRIPTIONS
- MANUALS
- REFERENCE CARDS
- Adobe
- Mac OS
- Microsoft Office
- Microsoft Teams
- QuickBooks Online
- QuickBooks Pro
- Sage
- SQL
- Windows
- STICKERS
- SUPPORT
- LOGIN
Getting Acquainted with Access
1. Creating a New Database
2. Overview of a Database
3. The Access Interface
4. Touch Mode
5. Viewing Database Objects in the Navigation Bar
6. Opening and Closing Databases
Creating Relational Database Tables
1. The "Flat File" Method of Data Storage
2. The Relational Model of Data Storage
3. Tips for Creating a Relational Database
4. Creating Relational Database Tables
5. Assigning a Primary Key to a Table
Using Tables
1. Using Datasheet View
2. Navigating in Datasheet View
3. Adding Records in Database View
4. Editing and Deleting Records in Datasheet View
5. Inserting New Fields
6. Renaming Fields
7. Deleting Fields
Field Properties
1. Setting Field Properties
2. The 'Field Size' Property
3. The 'Format' Property for Date/Time Fields
4. The 'Format' Property for Logical Fields
5. Setting Default Values for Fields
6. Setting Input Masks
7. Setting Up Validation Rules and Responses
8. Requiring Field Input
9. Allowing Zero Length Entries
Joining Tables in a Database
1. The Relationships Window
2. Enforcing Referential Integrity
3. Creating Lookup Fields
Indexing Tables
1. Indexes
2. Creating Indexes
3. Deleting Indexes
Queries
1. Using the Simple Query Wizard
2. Designing Queries
3. Joining Tables in a Query
4. Adding Criteria to the QBE Grid
5. Running A Query
6. How is Using the QBE Grid Writing SQL Code?
7. Sorting Query Results
8. Hiding Fields in a Query
9. Using Comparison Operators
10. Using 'AND' and 'OR' Conditions
Advanced Queries
1. Using the 'BETWEEN...AND' Condition
2. Using Wildcard Characters in Criteria
3. Creating a Calculated Field
4. Creating 'Top Value' Queries
5. Function Queries
6. Parameter Queries
Advanced Query Types
1. Make-Table Queries
2. Update Queries
3. Append Queries
4. Delete Queries
5. Crosstab Queries
6. The 'Find Duplicates' Query
7. The 'Find Unmatched' Query
Creating Forms
1. Forms Overview
2. The Form Wizard
3. Creating AutoForms
4. Using Forms
5. Form and Report Layout View
6. Form and Report Design View
7. Viewing the Ruler and Gridlines
8. The 'Snap to Grid' Feature
9. Creating a Form in Design View
10. Modifying Form Selections in Design View
Form & Report Controls
1. Selecting Controls
2. Deleting Controls
3. Moving and Resizing Controls
4. Sizing Controls 'To Fit'
5. 'Nudging' Controls
6. Aligning, Spacing and Sizing Controls
7. Formatting Controls
8. Viewing Control Properties
Using Controls
1. The Controls Group
2. Adding Label Controls
3. Adding Logos and Image Controls
4. Adding Line and Rectangle Controls
5. Adding Combo Box Controls
6. Adding List Box Controls
7. Setting Tab Order
Subforms
1. Creating Subforms
2. Using the Subform/Subreport Control
Reports
1. Using the Report Wizard
2. Using Basic Reports
3. Creating a Report in Design View
4. Sorting and Grouping Data in Reports
5. Creating Calculated Fields
Subreports
1. Creating Subreports
Charting Data
1. Using Charts
Macros
1. Creating a Standalone Macro
2. Assigning Macros to a Command Button
3. Using Program Flow with Macros
4. Creating Autoexec Macros
5. Creating Data Macros
6. Editing Named Data Macros
7. Renaming and Deleting Named Data Macros
Switchboard and Navigation Forms
1. Creating a Switchboard Form
2. Creating a Navigation Form
3. Controlling Startup Behavior
Advanced Features
1. Getting External Data
2. Exporting Data
3. Setting a Database Password
Helping Yourself
1. Using Access Help
2 The Tell Me Bar- 2016 Only
Introduction and Overview
1. What is Accounting?
2. Accounting Methods
3. Ethics in Financial Reporting
4. Introduction to Financial Statements
5. Business Activities
6. GAAP
7. Sarbanes-Oxley Act
8. Accrual vs. Cash Basis of Accounting
Financial Statements
1. Balance Sheets
2. Accounting Transactions
3. Debits and Credits
4. T-Accounts and Journal Entries
5. The Balance Sheet
6. Income Statements
7. Retained Earnings Statement
8. Statement of Cash Flows
Assets
1. Introduction to Assets
2. Current Assets
3. Property, Plant and Equipment
4. Long-Term Investments
5. Intangible Assets
6. Depreciation
Liabilities
1. Introduction to Liabilities
2. Current Liabilities
3. Notes Payable
4. Sales Tax Payable
5. Unearned Revenue
6. Payroll Payable
7. Long-Term Liabilities
Other Accounting Transactions
1. The Trial Balance
2. Adjusting Entries
3. Closing the Books
4. Sales Revenues, Gross Profits & Operating Activities
Inventory
1. Classifying Inventory
2. Determining Inventory Quantities
3. Cost of Goods Sold
4. FIFO and LIFO
5. Average Cost Method
Stockholder’s Equity
1. Corporate Form of Organization
2. Stock Issue Considerations
3. Accounting for Treasury Stock
4. Preferred Stock
5. Dividends and Retained Earnings
Managerial Accounting
1. Introduction to Managerial Accounting
2. Code of Ethics for Managerial Accounting
3. Managerial Cost Concepts
4. Other Managerial Concepts
Cost Accounting Systems
1. Cost Accounting Systems
2. Job Order Flow
3. Reporting Job Order Costing
4. Process Cost Systems
5. Activity Based Costing
Accounts Payable
1. Accounts Payable
2. Early Payment Discounts
Behavior of Costs and Expenses
1. Cost Behavior
2. Break-Even Analysis and Contribution Margin Ratio
3. Margin of Safety
Basic Banking
1. Making Deposits and Transfers
2. Reconciling Bank Accounts
Cost Controlling
1. Budgetary Control
2. Static and Flexible Budgets
3. Responsibility Accounting
4. Standard Costs
5. Analyzing and Reporting Variances
Profit and Budget Planning
1. Budgeting Basics
2. Preparing the Operating Budgets
3. Preparing the Financial Budgets
Management Decision Making
1. Introduction to Management Decision Making
2. Incremental Analysis
3. Capital Budgeting and Annual Rate of Return
4. Other Tools for Analysis and Decision Making
Getting Acquainted with Acrobat
1. Introduction to Adobe Acrobat Pro and PDFs
2. The Acrobat Environment
3. The Acrobat Home View
4. The Acrobat Tools View
5. The Acrobat Document View
6. The Menu Bar
7. Toolbars in Acrobat
8. The Common Tools Toolbar
9. Customizing the Common Tools Toolbar
10. Customizing the Quick Tools Toolbar
11. The Page Controls Toolbar
12. Resetting All Customizable Toolbars
13. Showing and Hiding All Toolbars and the Menu Bar
14. The Navigation Pane
15. The Tools Center
16. Customizing the Tools Pane
Opening and Viewing PDFs
1. Opening PDFs
2. Selecting and Copying Text and Graphics
3. Rotating Pages
4. Changing the Viewing Options
5. Using the Zoom Tools
6. Reviewing Preferences
7. Finding Words and Phrases
8. Searching a PDF and Using the Search Pane
9. Sharing PDFs by Email
10. Sharing PDFs with Adobe Send and Track
Creating PDFs
1. Creating New PDFs
2. Creating PDFs from a File
3. Creating PDFs from Multiple Files
4. Creating Multiple PDF Files at Once
5. Creating PDFs from Scanned Documents
6. Creating PDFs Using the PDF Printer
7. Creating PDFs from Web Pages Using a Browser
8. Creating PDFs from Web Pages Using Acrobat
9. Creating PDFs from the Clipboard
10. Creating PDFs Using Microsoft Office
11. Creating PDFs in Excel, PowerPoint, and Word
12. Creating PDFs in Adobe Applications
13. Creating PDFs in Outlook
14. Converting Folders to PDF in Outlook
Custom PDF Creation Settings
1. PDF Preferences in Excel, PowerPoint, and Word
2. Adobe PDF Settings
3. Creating and Modifying Preset Adobe PDF Settings
4. The General Category in Preset Adobe PDF Settings
5. The Images Category in Preset Adobe PDF Settings
6. The Fonts Category in Preset Adobe PDF Settings
7. The Color Category in Preset Adobe PDF Settings
8. The Advanced Category in Preset Adobe PDF Settings
9. The Standards Category in Preset Adobe PDF Settings
10. Create PDF and Email in Excel, PowerPoint, and Word
11. Mail Merge and Email in Word
12. Create and Review in Excel, PowerPoint, and Word
13. Importing Acrobat Comments in Word
14. Embed Flash in PowerPoint and Word
15. PDF Settings and Automatic Archival in Outlook
Basic PDF Editing
1. Initial View Settings for PDFs
2. Full Screen Mode
3. The Edit PDF Tool
4. Adding, Formatting, Resizing, Rotating and Moving Text
5. Editing Text
6. Managing Text Flow with Articles
7. Adding and Editing Images
8. Changing the Page Number Display
9. Cropping Pages and Documents
Advanced PDF Settings
1. Adding and Removing Watermarks
2. Adding and Removing Page Backgrounds
3. Adding Headers and Footers
4. Attaching Files to a PDF
5. Adding Metadata
6. Optimizing a PDF for File Size and Compatibility
Bookmarks
1. Using Bookmarks in a PDF
2. Modifying and Organizing Bookmarks
3. Assigning Actions to Bookmarks
Adding Multimedia Content and Interactivity
1. Creating and Editing Buttons
2. Adding Video, Sound, and SWF Files
3. Adding 3D Content to PDFs
4. Adding Page Transitions
Combining and Rearranging PDFs
1. Extracting and Replacing Pages
2. Splitting a PDF into Multiple Files
3. Inserting Pages from Files and Other Sources
4. Moving and Copying Pages
5. Combining PDFs
Exporting and Converting Content
1. Exporting Text
2. Exporting Images
3. Exporting PDFs to Microsoft Word
4. Exporting PDFs to Microsoft Excel
5. Exporting PDFs to Microsoft PowerPoint
Collaborating
1. Methods of Collaborating
2. Sending for Email Review
3. Sending for Shared Review
4. Reviewing Documents
5. Adding Comments and Annotation
6. The Comment Pane
7. Advanced Comments List Option Commands
8. Enabling Extended Commenting in Acrobat Reader
9. Using Drawing Tools
10. Stamping and Creating Custom Stamps
11. Importing Changes in a Review
12. Using Tracker to Manage PDF Reviews
Creating and Working With Portfolios
1. Creating a PDF Portfolio
2. PDF Portfolio Views
3. Using Layout View
4. Managing Portfolio Content
5. Using Details View
6. Setting Portfolio Properties
Getting Started With Forms
1. Creating a Form from an Existing PDF
2. Designing a Form in Microsoft Word
3. Creating a Form from a Scanned Document
4. Creating Forms from Image Files
5. Creating Text Fields
6. Creating Radio Buttons and Checkboxes
7. Creating Drop-Down and List Boxes
8. Creating Buttons
9. Creating a Digital Signature Field
10. General Properties of Form Fields
11. Appearance Properties of Form Fields
12. Position Properties of Form Fields
13. Options Properties of Form Fields
14. Actions Properties of Form Fields
15. Selection Change and Signed Properties of Form Fields
16. Format Properties of Form Fields
17. Validate Properties of Form Fields
18. Calculate Properties of Form Fields
19. Align, Center, Match Size, and Distribute Form Fields
20. Setting Form Field Tab Order
21. Enabling Users and Readers to Save Forms
22. Distributing Forms
23. Responding to a Form
24. Collecting Distributed Form Responses
25. Managing a Form Response File
26. Using Tracker with Forms
Professional Print Production
1. Overview of Print Production Support
2. Previewing Color Separations
3. Color Management and Conversion
4. Using the Object Inspector
5. Using the Preflight Dialog Box
6. Correcting Hairlines
7. Saving as a Standards-Compliant PDF
Scanning and Optical Character Recognition
1. Recognizing Text in a Scanned PDF
2. Recognizing Text in PDFs
3. Reviewing and Correcting OCR Suspects
Automating Routine Tasks
1. Using Actions
2. Creating Custom Actions
3. Editing and Deleting Custom Actions
4. Sharing Actions
Document Protection and Security
1. Methods of Securing a PDF
2. Password-Protecting a PDF
3. Creating and Registering Digital IDs
4. Using Certificate Encryption
5. Creating a Digital Signature
6. Digitally Signing a PDF
7. Certifying a PDF
8. Signing Documents with Adobe Sign
9. Getting Others to Sign Documents
10. Redacting Content in a PDF
11. Redaction Properties
12. Revealing and Clearing Hidden Information
Adobe Reader and Document Cloud
1. Opening and Navigating PDFs in Reader
2. Adding Comments
3. Digitally Signing a PDF
4. Adobe Document Cloud
Adobe Acrobat Help
1. Adobe Acrobat Help
The Crystal Reports Environment
1. Starting Crystal Reports
2. The Menu Bar
3. Using Toolbars
4. The Design View
Creating Data Connections
1. Creating a New Blank Report
2. The Database Expert
3. Access/Excel (DAO)
4. ADO.NET (XML)
5. Database Files
6. Java Beans Connectivity
7. JDBC (JNDI)
8. ODBC (RDO)
9. OLAP
10. OLE DB (ADO)
11. Salesforce.com
12. SAP BW MDX Query
13. SAP Info Sets
14. SAP Operational Data Source
15. SAP Table, Cluster, or Function
16. Universes
17. XML and Web Services
18. Repository
19. More Data Sources
20. Selecting Report Data and Tables
21. The Data Explorer
Creating Basic Reports
1. Adding Data Fields to a Report
2. Browsing Field Data
3. Selecting, Moving, and Resizing Fields
4. Using the “Size” and “Align” Commands
5. Creating Text Objects
6. Saving a Report
7. Previewing a Report
8. Refreshing the Report Data
Linking Tables in a Report
1. Basic Table Structures and Terms
2. Linking Multiple Tables
3. Table Joins
4. Enforcing Table Joins and Changing Link Types
Basic Formatting Techniques
1. Formatting Report Objects
2. The "Common" Tab of the Format Editor
3. The "Number" Tab of the Format Editor
4. The "Font" Tab of the Format Editor
5. The "Border" Tab of the Format Editor
6. The "Date and Time" Tab of the Format Editor
7. The "Paragraph" Tab of the Format Editor
8. The "Picture" Tab of the Format Editor
9. The "Boolean" Tab of the Format Editor
10. The "Hyperlink" Tab of the Format Editor
11. The "Subreport" Tab of the Format Editor
12. Drawing Lines
13. Drawing Boxes
14. Format Painter
15. Formatting Part of a Text Object
16. The Template Expert
17. Inserting Pictures
Record Selection
1. The Select Expert
2. Setting Multiple Filters
3. Editing the Selection Formula
Sorting and Grouping Records
1. The Record Sort Expert
2. The Group Expert
3. Managing Groups
4. Summarizing Groups
5. Hierarchical Groupings
6. The Group Sort Expert
Printing Reports
1. Inserting Special Fields
2. Page Setup
3. Printing Reports
Using Formulas
1. Crystal Reports Formula Syntax
2. The Formula Workshop- Formula Editor Window
3. Creating Formula Fields
4. Crystal Syntax
5. Basic Syntax
6. Finding Function and Operator Assistance
Advanced Formatting
1. The Highlighting Expert
2. The Section Expert
3. Conditionally Formatting a Section
4. Conditionally Formatting a Field
5. Manipulating Multiple Sections
Summary Reports
1. Summarizing Report Data
2. Using the DrillDownGroupLevel Feature
Charting
1. The Chart Expert
2. Editing Charts
3. Setting General Chart Options
4. Formatting Selected Chart Items
5. Formatting a Data Series
6. Formatting Chart Gridlines
7. Setting Chart Axes Options
8 . Adding Chart Trendlines
9 . Modifying a 3D Chart View
10. Using Chart Templates
11. Auto-Arranging Charts
Advanced Reporting Tools
1. Using Running Totals
2. Creating Parameter Fields
3. Parameterized Record Selection
4. Creating Subreports
5. Report Alerts
6. Report Alert Functions
Advanced Formula Creation
1. Evaluation Time Functions
2. Declaring Variables
3. Using and Displaying Variables
4. Using Array Values
5. Using “If… Then… Else…” Statements
6. Using the “Select/Case” Statement
7. Using “For” Loops
8. Using “Do… While” Loops
9. The IIF Function
Advanced Reporting
1. Creating a Report Template
2. Exporting Report Results
3. Exporting as HTML
4. Setting Default Options
5. Setting Report Options
Using Report Wizards
1. Using the Report Wizards
2. Report Wizard Types
3. Creating a Cross-Tab Report
Advanced Database Concepts
1. Viewing the SQL Code
2. Using Table Aliases
3. Verifying the Database
4. Setting the Datasource Location
5. Mapping Fields
Getting Acquainted with Dreamweaver
1. The Dreamweaver Environment
2. The Designer Workspace
3. The Menu Bar
4. The Designer View Icons
5. The Designer View Toolbar
6. Working With Panels
7. The Properties Inspector
8. The Insert Panel
9. Other Common Panels
Creating a Website
1. About New Websites
2. The Root Folder
3. Defining a Website
4. Creating a New Web Page
5. Saving and Closing Web Pages
6. Opening Saved Web Pages
7. Previewing Web Pages
8. Multi-Browser Previews
All About Text
1. Working With Text
2. Exploring Heading Levels
3. Formatting Text Color
4. Changing a Web Page's Background Color
5. Aligning Text
6. Creating Paragraphs
7. Working With Fonts
8. Using Custom Fonts
9. Using Bold and Italics With Text
10. Creating Lists
11. Special Characters
12. Creating Block Quotes
All About Images
1. Using Images in a Web Page
2. Image File Types
3. Commonly Used Web Images
4. Inserting Images Into a Web Page
5. Image Properties
6. Borders and Spacing Around Images
7. Using Background Images
8. Resizing Images
9. Cropping Images
10. Using Images and Text Together
11. When to Use Outside Imaging Programs
12. Opening an Image in Adobe Photoshop
13. Cropping an Image Using Photoshop
14. Saving an Image Using Photoshop
15. Resizing an Image Using Photoshop
16. Working with Custom Fonts in Photoshop
All About Hyperlinks
1. Inserting a Hyperlink Into a Web Page
2. Turning Images Into Hyperlinks
3. Creating Image Maps
4. Named Anchor Links
5. Adding an Email Link to a Web Page
6. Changing the Appearance of Hyperlinks
Using Frames
1. Using Frames
2. Adding Content to Frames
3. Naming Frames
4. Deleting Frames
5. Linking to Frames
Tables
1.When to Use Tables
2. Creating Tables
3. Inserting and Editing Content in Tables
4. Editing Rows and Columns
5. Table Borders and Backgrounds
6. Spacing and Padding in Table Cells
7. Merging and Splitting Table Cells
CSS Basics
1. Working with Cascading Style Sheets
2. Editing CSS Styles
3. Creating Class Styles
4. Applying Class Styles
5. Editing Class Styles
6. Customizing HTML Tags
7. Modifying Fonts Using CSS
CSS Layouts and AP Divs
1. Creating External Style Sheets
2. Attaching External Style Sheets
3. Editing an External Style Sheet
4. Absolute Positioning Versus Relative Positioning
5. About AP Divs
6. Nested AP Divs
7. Designing a Web Page Using CSS Layouts
8. Editing CSS Layouts
9. Inserting an Image Into a Header
10. Adding Images to a CSS Layout
Spry Widgets & Forms
1. Spry Widgets, Behavior Events and Actions
2. Creating a Drop-Down Menu
3. Editing a Drop-Down Menu
4. Creating Tabbed Panels
5. Adding Content to Tabbed Panels
6. Editing Tabbed Panels
7. Open Browser Window Behavior
8. About Forms
9. Adding Text Fields to Forms
10. Inserting Checkboxes Into Forms
11. Inserting Radio Buttons Into Forms
12. Inserting Lists and Menus Into Forms
13. Adding Buttons to Forms
Publishing Your Website
1. Domain Names Versus Web Hosting
2. When is my site ready to publish?
3. Setting Up a Remote Site
4. Connecting to a Remote Server
5. Putting Files on the Remote Site
6. Canceling Uploads and Deleting Remote Site Files
7. Downloading Files from the Remote Site
Website Management
1. Site Assets
2. Changing Links Site-Wide
3. Finding and Replacing Text
4. Site Reports
5. Checking Files In and Out
6. Using Design Notes
Adobe Bridge
1. The Adobe Bridge Environment
2. Display Options
3. Compact Mode
4. Navigating, Opening & Placing Files
5. Searching for Files and Folders
6. Labeling and Rating Files
7. Sorting and Filtering Files
8. Copying, Moving and Deleting Files
9. Stacking and Unstacking
10. Previewing Images and the Loupe Tool
11. Rotating Images
12. Viewing a Slideshow
13. Viewing and Editing Metadata
14. Keywords
Getting Acquainted with Excel
1. About Excel
2. The Excel Environment
3. The Title Bar
4. The Ribbon
5. The "File" Tab and Backstage View
6. Scroll Bars
7. The Quick Access Toolbar
8. Touch Mode
9. The Formula Bar
10. The Workbook Window
11. The Status Bar
12. The Workbook View Buttons
13. The Zoom Slider
14. The Mini Toolbar
15. Keyboard Shortcuts
File Management
1. Creating New Workbooks
2. Saving Workbooks
3. Closing Workbooks
4. Opening Workbooks
5. Recovering Unsaved Workbooks
6. Opening a Workbook in a New Window
7. Arranging Open Workbook Windows
8. Freeze Panes
9. Split Panes
10. Hiding and Unhiding Workbook Windows
11.Comparing Open Workbooks
12. Switching Open Workbooks
13. Switching to Full Screen View
14. Working With Excel File Formats
Data Entry
1. Selecting Cells
2. Entering Text into Cells
3. Entering Numbers into Cells
4. AutoComplete
5. Pick from Drop-Down List
6. Flash Fill
7. Selecting Ranges
8. Ranged Data Entry
9. Using AutoFill
Creating Formulas
1. Ranged Formula Syntax
2. Simple Formula Syntax
3. Writing Formulas
4. Using AutoSum
5. Inserting Functions
6. Editing a Range
7. Formula AutoCorrect
8. AutoCalculate
9. Function Compatibility
Copying & Pasting Formulas
1. Relative References and Absolute References
2. Cutting, Copying, and Pasting Data
3. AutoFilling Cells
4. The Undo Button
5. The Redo Button
Columns & Rows
1. Selecting Columns & Rows
2. Adjusting Column Width and Row Height
3. Hiding and Unhiding Columns and Rows
4. Inserting and Deleting Columns and Rows
Formatting Worksheets
1. Formatting Cells
2. The Format Cells Dialog Box
3. Clearing All Formatting from Cells
4. Copying All Formatting from Cells to Another Area
Worksheet Tools
1. Inserting and Deleting Worksheets
2. Selecting Multiple Worksheets
3. Navigating Worksheets
4. Renaming Worksheets
5. Coloring Worksheet Tabs
6. Copying or Moving Worksheets
Setting Worksheet Layout
1. Using Page Break Preview
2. Using the Page Layout View
3. Opening The Page Setup Dialog Box
4. Page Settings
5. Setting Margins
6. Creating Headers and Footers
7. Sheet Settings
Printing Spreadsheets
1. Previewing and Printing Worksheets
Helping Yourself
1. Using Excel Help
2. The Tell Me Bar- 2016 Only
3. The Smart Lookup and Insights- 2016 Only
Creating 3D Formulas
1. Creating 3D Formulas
2. 3D Formula Syntax
3. Creating 3D Range References
Named Ranges
1. Naming Ranges
2. Creating Names from Headings
3. Moving to a Named Range
4. Using Named Ranges in Formulas
5. Naming 3D Ranges
6. Deleting Named Ranges
Conditional Formatting and Cell Styles
1. Conditional Formatting
2. Finding Cells with Conditional Formatting
3. Clearing Conditional Formatting
4. Using Table and Cell Styles
Paste Special
1. Using Paste Special
2. Pasting Linked Formulas
Sharing Workbooks
1. About Sharing Workbooks
2. Simplified Workbook Sharing in Excel 2016
3. Traditional Workbook Sharing
4. Highlighting Changes
5. Reviewing Changes
6. Using Comments
7. Compare and Merge Workbooks
Auditing Worksheets
1. Auditing Worksheets
2. Tracing Precedent and Dependent Cells
3. Tracing Errors
4. Error Checking
5. Using the Watch Window
6. Cell Validation
Outlining Worksheets
1. Using Outlines
2. Applying and Removing Outlines
Consolidating Worksheets
1. Consolidating Data
Tables
1. Creating a Table
2. Adding an Editing Records
3. Inserting Records and Fields
4. Deleting Records and Fields
Sorting Data
1. Sorting Data
2. Custom Sort Orders
Filtering Data
1. Using AutoFilters
2. Using the Top 10 AutoFilter
3. Using a Custom AutoFilter
4. Creating Advanced Filters
5. Applying Multiple Criteria
6. Using Complex Criteria
7. Copying Filter Results to a New Location
8. Using Database Functions
Using What-If Analysis
1. Using Data Tables
2. Using Scenario Manager
3. Using Goal Seek
4. Forecast Sheets- 2016 Only
Table-Related Functions
1. The Hlookup and Vlookup Functions
2. Using the IF, AND, and OR Functions
Sparklines
1. Inserting and Deleting Sparklines
2. Modifying Sparklines
Creating Charts In Excel
1. Creating Charts
2. Selecting Charts and Chart Elements
3. Adding Chart Elements
4. Moving and Resizing Charts
5. Changing the Chart Type
6. Changing the Data Range
7. Switching Column and Row Data
8. Choosing a Chart Layout
9. Choosing a Chart Style
10. Changing Color Schemes
11. Printing Charts
12. Deleting Charts
Formatting Charts in Excel
1. Formatting Chart Objects
2. Inserting Objects into a Chart
3. Formatting Axes
4. Formatting Axis Titles
5. Formatting a Chart Title
6. Formatting Data Labels
7. Formatting a Data Table
8. Formatting Error Bars
9. Formatting Gridlines
10. Formatting a Legend
11. Formatting Drop and High-Low Lines
12. Formatting Trendlines
13. Formatting Up/Down Bars
14. Formatting the Chart and Plot Areas
15. Naming Charts
16. Applying Shape Styles
17. Applying WordArt Styles
18. Saving Custom Chart Templates
Data Models
1. Creating a Data Model from External Relational Data
2. Creating a Data Model from Excel Tables
3. Relating Tables in a Data Model
4. Managing a Data Model
PivotTables and PivotCharts
1. Creating Recommended PivotTables
2. Manually Creating a PivotTable
3. Creating a PivotChart
4. Manipulating a PivotTable or PivotChart
5. Changing Calculated Value Fields
6. Formatting PivotTables
7. Formatting PivotCharts
8. Setting PivotTable Options
9. Sorting and Filtering Using Field Headers
PowerPivot
1. Starting PowerPivot
2. Managing the Data Model
3. Calculated Columns and Fields
4. Measures
5. Creating KPIs
6. Creating and Managing Perspectives
7. PowerPivot PivotTables and PivotCharts
Power View
1. Starting Power View
2. Adding Report Visualizations
3. Changing the Layout of Report Visualizations
4. Using Undo and Redo in Power View
5. Formatting the Power View Sheet
6. Creating Multiples in a Chart
7. Filtering Power View Using the Filter Data
8. Cross-Filtering Visualizations
Slicers and Timelines
1. Inserting and Deleting Slicers
2. Modifying Slicers
3. Inserting and Deleting Timelines
4. Modifying Timelines
Security Features
1. Unlocking Cells
2. Worksheet Protection
3. Workbook Protection
4. Password Protecting Excel Files
Making Macros
1. Recording Macros
2. Running and Deleting Recorded Macros
3. The Personal Macro Workbook
Getting Acquainted with HTML
1. Introduction to the Internet
2. Introduction to HTML Terminology
3. Options for Writing HTML
4. Unicode Transformation Format (UTF)
5. HTML5 Resources
New for HTML5
1. What's different in HTML5?
2. !DOCTYPE in HTML5
Designing a Webpage
1. Design Considerations and Planning
2. Basic Tags and Document Structure
3. HTML Tags
4. Head Tags
5. Title Tags
6. Body Tags
7. Metadata
8. Saving an HTML Page
Page Formatting
1. Adding a New Paragraph
2. Adding a Line Break
3. Inserting Blank Space
4. Preformatted Text
5. Changing a Pages's Background Color
6. Div Element
Text Items and Objects
1. Headings
2. Comments
3. Block Quotes
4. Horizontal Lines
5. Special Characters
Creating Lists
1. Numbered (Ordered) Lists
2. Bulleted (Unordered) Lists
3. Nested Lists
4. Definition Lists
Links
1. What are Links?
2. Text Links
3. Image Links
4. Opening a Page in a New Window or Tab
5. Setting All Links on a Page to Open in a New Window or Tab
6. Linking to an Area on the Same Page (Bookmarks)
7. Linking to an E-mail Address
8. Linking to Other Types of Files
Images
1. Introduction to Images for Webpages
2. Adding Images to Webpages
3. Re-Sizing an Image
4. Alternative (ALT) Text
5. Image Labels
Basic Tables
1. Inserting a Table
2. Table Borders
3. Table Headers
Iframes
1. What is an Iframe?
2. Inserting Iframes
3. Setting Height and Width
4. Using an Iframe for a Link Target
Forms
1. About Forms
2. Sending to E-mail
3. Text Boxes
4. Text Areas
5. Check Boxes
6. Menu Lists
7. Radio Buttons
8. Submit Button
9. Reset Button
10. Changing the Tab Order
Video and Audio
1. About Video and Audio Files
2. Linking to Video and Audio Files
3. Adding Video
4. Adding Audio
5. Using YouTube to Display Video
Troubleshooting
1. Troubleshooting
Cascading Style Sheets
1. What are Cascading Style Sheets?
2. CSS Syntax
3. Creating an Internal CSS
4. Linking to a CSS
5. Adding Comments and Notes to a CSS
6. Creating an Internal Style Sheet
7. ID and Class
8. Inline Styling
Working With Text in CSS
1. Emphasizing Text (Bold and Italic)
2. Decoration
3. Indentation
4. Transformation
5. Text Alignment
6. Fonts
7. Font Sizes
8. Letter Spacing (Kerning)
9. Line Spacing (Leading)
10. Text Color
11. Margins
12. Padding
13. Borders
14. Styling Links
15. Number and Bullet Styles
16. Sizing Elements
17. Text Wrapping
18. Shadowing
Creating Backgrounds in CSS
1. Colors
2. Images
3. Fixed Images
Images in CSS
1. Opacity
2. Floating Images
3. Image Galleries
4. Image Sprites
Box Model in CSS
1. What is a box model?
2. Margin
3. Padding
4. Border
5. Outline
Working With Elements in CSS
1. Display and Visibility
2. Grouping and Nesting
3. Dimensions and Elements
4. Positioning
5. Floating
6. Pseudo-Classes/Pseudo-Elements
Adding a Navigation Bar in CSS
1. Vertical Navigation Bar
2. Horizontal Navigation Bar - Inline
3. Horizontal Navigation Bar - Floating
CSS Tables
1. Borders
2. Collapsed Borders
3. Table Width and Cell Height
4. Table Color
5. Table Text Alignment
6. Table Padding
Working With Transforms in CSS
1. What are transforms?
2. 2D Transforms
3. 3D Transforms
Transitions and Animations in CSS
1. Transitions
2. Animations
CSS Shorthand
1. Shorthand Properties
Before You Get the Interview
1. Introduction to Interviewing
2. Write an Effective Resume
3. Develop Great References
4. Use Technology Wisely
5. Dress the Part
6. Other Considerations
Once the Interview is Scheduled
1. Research the Company
2. Practice, Practice, Practice
3. Prepare for the Interview
4. Stay Healthy
5. Grooming for Success
During the Interview
1. Types of Interviews
2. Make a Great First Impression
3. General Strategies for Answering Questions
4. Mirroring
5. Representational Systems
6. Body Language Dos
7. Body Language Don'ts
8. Tips and Tricks
9. Ending the Interview
After the Interview
1. Take Notes
2. Thank the Interviewer
3. Following Up
4. The Second Interview
Practice Questions
1. The Behavioral Interview
2. Practice Questions 1-5
3. Practice Questions 6-10
4. Practice Questions 11-15
Conclusion
1. Further Study
2. Conclusion
Getting Acquainted with JavaScript
1. Introduction to JavaScript
2. JavaScript vs. Java
3. The Tag
4. External JavaScript
5. Uses for JavaScript
The Makeup of JavaScript
1. JavaScript Statements
2. Code and Code Blocks
3. Whitespace
4. Case Sensitivity
5. Breaking Up a Line of Code
JavaScript Comments
1. Single Line Comments
2. Multi-Line Comments
3. End of Line Comments
4. Using Comments to Stop Execution
JavaScript Variables
1. What are JavaScript Variables?
2. Syntax for Text and Numerical Values
3. Creating (Declaring) Variables
4. Re-Declaring Variables
5. Undefined Value
6. Using One Statement for Multiple Variables
7. Local Variables and Global Variables
Exploring JavaScript Data Types
1. Dynamic Data Types in JavaScript
2. Null
3. Number
4. String
5. Boolean
6. Array
7. Object
JavaScript Objects
1. Creating Objects
2. Accessing Object Properties
3. Accessing Object Methods
JavaScript Functions
1. JavaScript Function Definition and Syntax
2. Functions with a Return Value
3. Calling a Function with Arguments
4. Assigning Values to Undeclared Variables
JavaScript Operators
1. Arithmetic Operators
2. Assignment Operators
3. Adding Strings and Numbers
4. Comparison Operators
5. Logical Operators
6. Conditional Operators
JavaScript Conditions
1. If Statements
2. The Switch Statement
JavaScript Loops
1. The FOR Loop
2. The FOR…IN Loop
3. The WHILE Loop
4. The DO…WHILE Loop
JavaScript Break and Continue
1. The Break Statement
2. The Continue Statement
3. JavaScript Labels
JavaScript Errors
1. The Try…Catch Statement
2. The Throw Statement
JavaScript Form Validation
1. Form Validation
2. E-Mail Validation
JavaScript RegExp Object
1. RegExp Definition and Modifiers
2. RegExp Special Characters
3. RegExp Methods
JavaScript Hoisting
1. Declarations
2. Initializations
JavaScript USE STRICT Directive
1. What is the USE STRICT Directive and Why Use It?
2. What’s Not Allows in STRICT Mode?
JavaScript HTML DOM
1. What is HTML DOM?
2. HTML DOM Methods and Properties
3. HTML DOM Document
4. Finding HTML Elements
5. Changing the Output Stream
6. Changing the Value of an Attribute
7. Changing CSS
HTML DOM Events
1. Using Events
2. The ONCHANGE Event
HTML DOM Navigation
1. DOM Nodes
2. Node Relationships
3. Child Nodes and Values
4. NODE…Properties
5. HTML DOM Nodelist
6. Root Nodes
Adding and Removing DOM Nodes
1. Creating New HTML Elements (Nodes)
2. Removing Existing HTML Elements (Nodes)
3. Replacing HTML Elements (Nodes)
JavaScript Browser Object Model (BOM)
1. What is the Browser Object Model (BOM)?
2. The Window Object
3. Window Size Properties
4. Other Window Methods and Properties
Window Screen Object
1. What does the Window Screen Object Do?
2. Window Screen Object Properties.
Window Location Object
1. What does the Window Location Object Do?
2. Window Location HREF Property
3. Window Location PATHNAME Property
4. Window Location ASSIGN() Method
Window History Object
1. What does the WindowHistory Object Do?
2. Window History Back andForward Methods
Window Navigator Object
1. What does the WindowNavigator Object Do?
JavaScript Popup Boxes
1. The Alert Box
2. The Confirm Box
3. The Prompt Box
JavaScript Timing Events
1. What are JavaScript TimingEvents?
2. SETINTERVAL() and CLEARINTERVAL() Methods
3. SETTIMEOUT() and CLEARTIMEOUT() Methods
4. Creating a Clock
JavaScript Cookies
1. What are Cookies?
2. Working with Cookies
The JavaScript Console Object
1. The Console Object
2. Inline Grouping
3. Timers
4. String Substitution
Advanced JavaScript Objects
1. The Object Literal and the Keyword New
2. Using an Object Constructor
3. JavaScript Prototype
4. Mutable Objects and Immutable Primitive Values
5. JavaScript Object Properties
6. Adding New Properties and Deleting Properties
Number Object
1. What is a Number Object?
2. Hexadecimal Numbers
3. NaN – Not a Number
4. Infinity
String Object
1. Using the String Object
2. String Properties and Methods
3. Special Characters
Date Object
1. The Date Object
2. Set and Compare Dates
3. Convert the Date to a String
Array Object
1. Create and Access an Array Object
2. Joining Arrays
3. Working with Arrays
Math Object
1. The Math Object and Mathematical Constants
2. Math Object Methods
JavaScript Libraries (Frameworks)
1. JavaScript Libraries or Frameworks
2. Testing jQuery
Getting Acquainted with OneNote
1. The OneNote Environment
2. The Title Bar
3. The Ribbon
4. The "File" Tab and Backstage View
5. The Quick Access Toolbar
6. The Scroll Bars
7. The Mini Toolbar
Getting Started
1. Opening, Saving and Closing Notebooks
2. Creating New Notebooks
3. Creating, Moving and Deleting Sections and Pages
4. Creating, Moving and Deleting Subpages
Notes
1. Creating a Basic Note
2. Quick Notes
3. Copying and Pasting Content
4. Screen Clippings
5. Adding Pictures
6. Adding Audio & Video Files
7. Inserting Online Video
8. Recording Audio & Video Files
9. Adding Other Types of Files
10. Embedding an Excel Spreadsheet
11. Adding Mathematical Equations
12. Quick Filing - Sending Information to OneNote
Formatting Notes
1. Basic Text Formatting
2. Bullets and Numbering
3. Checking Spelling
4. Setting Default Proofing Options
Working with Microsoft Outlook
1. Inserting Outlook Meetings
2. Sending Notebook Pages via Microsoft Outlook
3. Working with Microsoft Outlook Tasks
Tables
1. Creating a Table
2. Working with Columns and Rows
3. Formatting Tables and Table Data
4. Moving Tables and Table Data
Writing Tools
1. Pen Mode
2. Formatting Written Notes & Drawings
3. Adding and Removing Note Space
4. Converting Handwriting to Type
Viewing and Organizing Information
1. Organizing the OneNote Interface
2. Creating New Windows
3. Searching Content in a Notebook
4. Wiki Linking
5. Tagging Notes
6. Working with Sections
7. Section Groups
Stationery and Templates
1. Applying Templates and Stationery
2. Custom Templates
3. Choosing a Default Template
Formatting Pages
1. Defining Paper Size and Margins
2. Formatting Page Backgrounds
3. Adding a Background Graphic
Printing
1. Previewing and Printing
Sharing Notebooks & Collaborating
1. Saving and Exporting Notebooks to Share
2. Creating a Shared Notebook and Inviting Others to Share
3. Sharing Notes in an Outlook Meeting Invitation
4. Synching Notebooks
5. Sending Pages in Various Formats
6. Author Indicators
7. Finding Newly Added Content with Highlighting
8. Page Versions
9. The Notebook Recycle Bin
Researching with OneNote
1. Linked Notes
2. The Research Pane
3. Translating Text with the Mini Translator
Changing OneNote Options
1. Customizing the Quick Access Toolbar and Ribbon
2. Changing OneNote Options
Helping Yourself
1. Using OneNote Help
Getting Acquainted with Outlook
1. The Outlook Environment
2. The Title Bar
3. The Ribbon
4. The Quick Access Toolbar
5. Touch Mode
6. The Navigation Bar, Folder Pane, Reading Pane, and To-Do Bar
7. What's New in Outlook 2016
Making Contacts
1. The People Folder
2. Customizing the Contacts Folder View
3. Creating Contacts
4. Basic Contact Management
5. Printing Contacts
6. Creating Contact Groups
7. Categorizing Contacts
8. Searching for Contacts
9. Calling Contacts
10. Mapping a Contact's Address
E-Mail
1. Using the Inbox
2. Changing the Inbox View
3. Message Flags
4. Searching for Messages
5. Creating, Addressing, and Sending Messages
6. Checking Message Spelling
7. Setting Message Options
8. Formatting Messages
9. Using Signatures
10. Replying to Messages
11. Forwarding Messages
12. Sending Attachments
13. Sharing a OneDrive File as an Attachment- 2016 Only
14. Opening Attachments
15. Ignoring Conversations
The Sent Items Folder
1. The Sent Items Folder
2. Resending Messages
3. Recalling Messages
The Outbox Folder
1. Using the Outbox
Using the Calendar
1. The Calendar Window
2. Switching the Calendar View
3. Navigating the Calendar
4. Appointments, Meetings and Events
5. Manipulating Calendar Objects
6. Setting an Appointment
7. Scheduling a Meeting
8. Checking Meeting Attendance Status
9. Responding to Meeting Requests
10. Scheduling an Event
11. Setting Recurrence
12. Printing the Calendar
13. Join Skype Meeting in Outlook 2016
14. Meeting Notes
Tasks
1. Using Tasks
2. Printing Tasks
3. Creating a Task
4. Setting Task Recurrence
5. Creating a Task Request
6. Responding to Task Requests
7. Sending Status Reports
8. Deleting Tasks
Deleted Items
1. The Deleted Items Folder
2. Permanently Deleting Items
3. Recovering Deleted Items
4. Recovering and Purging Permanently Deleted Items
Groups
1. Accessing Groups
2. Creating a New Group
3. Adding Members to Groups
4. Contributing to Groups
5. Managing Files in Groups
6. Accessing the Group Calendar
7. Subscribing to and Unsubscribing from Groups
8. Leaving Groups
9. Editing, Managing and Deleting Groups
The Journal Folder
1. The Journal Folder
2. Switching the Journal View
3. Recording Journal Items
4. Opening Journal Entries and Documents
5. Deleting Journal Items
Public Folders
1. Creating Public Folders
2. Setting Permissions
3. Folder Rules
4. Copying Public Folders
Personal and Private Folders
1. Creating a Personal Folder
2. Setting AutoArchiving for Folders
3. Creating Private Folders
4. Creating Search Folders
Notes
1. Creating and Using Notes
Advanced Mailbox Options
1. Creating Mailbox Rules
2. Creating Custom Mailbox Views
3. Handling Junk Mail
4. Color Categorizing
5. Advanced Find
6. Mailbox Cleanup
Outlook Options
1. Using Shortcuts
2. Adding Additional Profiles
3. Adding Additional Services
4. Outlook Options
5. Using Outlook Help
Delegates
1. Creating a Delegate
2. Acting as a Delegate
3. Deleting Delegates
Getting Acquainted with Outlook on the Web
1. Introduction to the Outlook on the Web
2. What is the Outlook on the Web?
3. Starting Outlook on the Web
4. The Outlook on the Web Environment
5. System Requirements for the Outlook on the Web
6. Using the Outlook on the Web (Light) Version
7. Applying a Theme
8. Adding and Managing Add-ins
E-Mail
1. Using the Inbox
2. Creating and Addressing Messages
3. Entering and Formatting Messages
4. Checking Message Spelling
5. Saving Message Drafts
6. Sending Attachments from OneDrive
7. Sending Local Attachments
8. Inserting Pictures
9. Sending a Message
10. Receiving E-Mail Messages
11. Opening Messages
12. Printing Messages
13. Downloading Attachments
14. Replying to Messages
15. Forwarding Messages
16. Ignoring a Conversation Thread
17. The Deleted Items Folder
18. Permanently Deleting Items
19. Recovering Deleted Items
Managing Items
1. Creating and Managing Categories
2. Categorizing Items
3. Marking Messages as Read or Unread
4. Flagging Items
5. Marking Messages as Junk
6. Pinning Messages
7. Archiving Messages
8. Changing the Display of Messages in the Inbox Pane
Mailbox Management
1. Creating and Using Inbox and Sweep Rules
2. Creating a Folder
3. Moving and Copying Messages
4. Managing the Favorites Folder List
5. Filtering and Sorting Messages in the Inbox Pane
6. Setting and Managing Folder Permissions
7. Finding Items
E-Mail Options
1.Creating and Using E-Mail Signatures
2. Using Automatic Replies (Out of Office Assistant)
3. Changing Your Password
4. Viewing Your Mailbox Usage
5. Enabling Online Access
Calendar
1. Opening the Calendar
2. Navigating Calendar Dates
3. Creating Appointments and Events
4. Canceling Appointments and Events
5. Creating Recurring Appointments and Events
6. Printing the Calendar
7. Sharing Calendars
8. Managing Multiple Calendars
9. Adding Shared Calendars
10. Using the Scheduling Assistant
11. Using the Suggested Meetings App
12. Accessing Calendar Options
13. Changing Automatic Processing Settings
14. Changing the Calendar Appearance
15. Changing the Notifications Settings
16. Publishing Calendars
17. Changing Reminders Settings
Meetings
1. Creating a Meeting Request
2. Responding to Meeting Requests
3. Viewing Meeting Request Responses
4. Editing and Updating Meetings
5. Creating Recurring Meetings
People
1. Creating a New Contact
2. Adding Contacts from E-Mail
3. Creating a Contact List
4. Linking Contacts
5. Finding Contacts
6. Connecting to Social Networks
7. Using the Directory
8. Importing Contacts
Tasks
1. Creating a New Task
2. Editing Tasks
3. Attaching Files to Tasks
4. Viewing Tasks and Flagged Items
5. Sorting Tasks
6. Filtering Tasks
7. Deleting Tasks
Groups
1. Accessing Groups
2. Creating a New Group
3. Adding Members to Groups
4. Contributing to Groups
5. Managing Files in Groups
6. Accessing the Group Calendar
7. Changing the View of Groups
8. Subscribing to and Unsubscribing from Groups
9. Leaving Groups
10. Editing, Managing, and Deleting Groups
Getting Acquainted with Peachtree
1. The Peachtree Environment
2. The Peachtree Navigation Centers
3. Using the Menu Bar
4. Using the Main Application Toolbar
5. Learning Common Business Terms
Setting Up a Company
1. Creating a Peachtree Company
2. Setting Customer Defaults
3. Setting Vendor Defaults
4. Setting Inventory Defaults
5. The Payroll Setup Wizard
6. Setting Payroll & Employee Defaults
7. Setting Job Defaults
8. Making a Backup
9. Restoring from a Backup File
Using the General Ledger
1. General Ledger Default Settings
2. Adding Accounts
3. Deleting Accounts
4. Adding Beginning Account Balances
5. Adding General Journal Entries
6. Basic General Ledger Reports
7. Entering Account Budgets
8. The Cash Account Register
Starting Accounts Receivable
1. Setting Up Accounts Receivable Defaults
2. Adding Customers
3. Adding Customer Beginning Balances
4. Setting Statement and Invoice Defaults
5. Sales Orders & Invoicing
6. The Sales Orders Window
7. The Sales/Invoicing Window
8. The Receipts Window
9. Statements and Finance Charges
10. Selecting Deposits
11. Changing a Record ID
Starting Accounts Payable
1. Setting Up Accounts Payable Defaults
2. Adding Vendors
3. Adding Beginning Balances for Vendors
4. The Purchase Orders Window
5. Entering a Drop Shipment
6. Select for Purchase Orders
7. The Purchases/Receive Inventory Window
8. The Payments Window
9. The Select For Payment Window
Adding Inventory
1. Adding Inventory
2. Removing Inventory
3. Entering Inventory Beginning Balances
4. Building and Unbuilding Assemblies
5. Making Inventory Adjustments
6. Changing Item Prices
Creating Payroll
1. Adding Employees
2. Adding Employee Beginning Balances
3. Paying a Group of Employees
4. Paying an Employee
5. Creating Payroll Formulas
6. Elements of Payroll Formulas
Account Management
1. Writing Checks
2. Voiding Checks
3. Reconciling Bank Accounts
4. Changing the Accounting Period
Using Sales Tax
1. The Sales Tax Wizard
2. Sales Tax Authorities
3. Sales Tax Codes & Exempt Sales
4. Collecting Sales Tax
5. Paying Sales Taxes
Using Quotes
1. Entering Quotes
2. Converting Quotes
Job Tracking
1. Setting Up a Job
2. Setting Job Defaults
3. Entering Beginning Balances for Jobs
4. Making Purchases for a Job
5. Invoicing for Job Purchases
6. Job Tracking
Time and Billing
1. Adding Time Ticket Employees
2. Entering Activity Items
3. Entering Charge Items
4. Entering Time Tickets
5. Entering Expense Tickets
6. Billing Time and Expense Tickets
Changing System Settings
1. Changing Posting Methods
2. Posting/Unposting
3. Memorized Transactions
4. Using the Purge Wizard
5. Using the Year-End Wizard
Reporting
1. The Cash Manager
2. The Collection Manager
3. The Payment Manager
4. The Financial Manager
5. Find on Report
6. Preset Reports
7. Report Groups
8. Modifying Reports
9. Exporting Reports to Excel
10. Importing & Exporting Data
11. Exporting to PDF
12. Modifying Screen Templates
13. Modifying Forms
The Internal Accounting Review
1. Using the Internal Accounting Review
Action Items
1. Events
2. To-Do Items
3. Alerts
Options
1. Changing Global Options
2. Changing the System Date
Assets and Liabilities
1. Assets and Liabilities
2. Creating an Other Current Assets Account
3. Subtracting Value from an Other Current Assets Account
4. Creating a Fixed Assets Account
5. Accumulated Depreciation
6. Liability Accounts
7. Paying on a Long Term Liability
8. Equity
Credits
1. Entering Credit Memos
2. Applying Credit Memos
3. Entering Vendor Credit Memos
Help
1. Using the Contents
2. Using the Index
3. Using the Search Feature
Getting Acquainted with Photoshop
1. The Photoshop Environment
2. Palettes and the Palette Well
3. Creating Custom Workspaces
4. Opening Images
5. Using the File Browser
6. Image Magnification
7. Viewing Document Information
8. Moving the Image
9. Undoing Mistakes and The History Palette
10. Displaying Drawing Guides
11. Making Measurements
12. Adding Annotations
13. Setting Preferences
Adobe Bridge
1. The Adobe Bridge Environment
2. Display Options
3. Compact Mode
4. Navigating, Opening & Placing Files
5. Searching for Files and Folders
6. Labeling and Rating Files
7. Sorting and Filtering Files
8. Copying, Moving and Deleting Files
9. Stacking and Unstacking
10. Previewing Images and the Loupe Tool
11. Rotating Images
12. Viewing a Slideshow
13. Viewing and Editing Metadata
14. Keywords
15. Mini Bridge
Basic Image Manipulation
1. Bitmap Images
2. Vector Images
3. Image Size and Resolution Settings
4. Scanning Images
5. Creating New Images
6. Placing Files
Color Basics
1. Color Modes and Models
2. Color Mode Conversion
3. Previewing Color Differences Between Operating Systems
4. Color Management
5. Foreground and Background Colors
6. Using the Color Picker
7. Selecting Colors with the Color Palette
8. Selecting Colors with the Eyedropper Tool
9. Selecting Colors with the Swatches Palette
Painting Tools
1. Painting Tools
2. The Brush Tool
3. Blending Modes
4. The Pencil Tool
5. The Color Replacement Tool
6. The Eraser Tool
7. The Magic Eraser Tool
8. The Background Eraser Tool
9. Using the Art History Brush
10. Using the History Brush
11. Using the Mixer Brush
Brush Settings
1. Using the Brushes Palette
2. Creating Custom Brush Tips by Selection
3. Creating Custom Brush Tips in the Brushes Palette
4. Setting Shape Dynamics
5. Setting Brush Scattering
6. Setting Brush Texture
7. Setting Dual Brushes
8. Setting Color Dynamics
9. Setting Other Dynamics
10. Miscellaneous Brush Settings
11. Clearing Brush Settings
12. Saving a Customized Brush
13. Saving a Customized Brush Library
Making Selections
1. Selection Basics
2. Making Pixel Selections
3. The Marquee Tools
4. Refining Edges of Selections
5. The Lasso Tools
6. The Magic Wand Tool
7. The Quick Selection Tool
8. Selecting by Color Range
9. Adjusting Pixel Selections
10. The Extract Command
11. Copying and Pasting Pixel Selections
12. Saving and Loading Selections
Filling and Stroking
1. Applying Fills
2. Using the Paint Bucket Tool
3. Using the Gradient Tool
4. Using the Gradient Editor
5. Using Patterns
6. Using the Pattern Maker
7. Stroking
Layers
1. Using Layers and Layer Groups/Sets
2. Creating Layers and Layer Groups/Sets
3. Stacking and Linking Layers
4. Moving Layer Content with the Move Tool
5. Locking Layers
6. Common Layer Management Tasks
7. Merging and Flattening Layers
Advanced Layers
1. Layer Styles
2. Adjustment Layers and Fill Layers
3. The Adjustments Panel
4. Masking Layers
5. The Masks Panel
6. Creating Clipping Groups
7. Creating Knockouts
8. Smart Objects
9. Smart Filters
Text
1. Text Basics
2. Entering Text
3. Selecting Text
4. Editing the Bounding Box
5. Creating a Type Selection
6. Applying Effects to Type Layers
7. Using the Character Palette
8. Checking for Spelling Errors
9. Using the Paragraph Palette
Drawing
1. Raster vs. Vector
2. Shape Layers and Shape Options
3. Using the Shape Tools
4. Using the Pen Tools
5. Using the Anchor Point Tools
6. Using the Paths Palette
7. Working with Paths
Using Channels and Masking
1. Using the Channels Palette
2. Using Channels
3. Spot Colors
4. Blending Channels and Layers
5. Masks
6. Using Alpha Channels
Manipulating Images
1. Changing the Canvas Size
2. Rotating and Flipping Images
3. The Rotate View Tool
4. Cropping Images
5. The Perspective Crop Tool
6. The Slice Tools
7. The Free Transform Command
8. The Smudge Tool
9. Blurring and Sharpening Images
10. Using the Dodge Tool and the Burn Tool
11. The Sponge Tool
12. Filters and The Filter Gallery
13. The Liquify Command
14. Vanishing Point
15. Content-Aware Scaling
16. The Puppet Warp Tool
17. The Clone Stamp Tool
18. The Pattern Stamp Tool
19. The Healing Brush Tool
19. The Spot Healing Brush Tool
20. The Patch Tool
21. The Content-Aware Move Tool
22. The Red Eye Tool
Saving Images
1. Saving Images
2. The Save for Web & Devices Dialog Box
Printing
1. Printing Images
2. Setting Printing Options
Automating Tasks
1. Actions and the Actions Palette
2. Playing Actions
3. Editing Actions
3. Playing Pre-Loaded Actions
Help
1. Photoshop Help
2. System Info
3. Online Updates
Getting Acquainted with Photoshop Elements
1. Introduction to Photoshop Elements
2. The Welcome Screen
3. Changing the Start-Up Mode
4. eLive
Importing Photos Into the Organizer
1. The Organizer Environment
2. JPEG and Camera Raw
3. Importing Photos from Files and Folders
4. Importing Photos from Cameras and Card Readers
5. Importing Photos from a Scanner
6. Importing Photos in Bulk
7. Setting Watch Folders (Windows Only)
Using the Organizer
1. Grid, Single Photo, and Full Screen Views
2. Creating and Using Albums
3. Photo Sharing
4. Managing Albums
5. The Taskbar
6. Creating a New Catalog
7. Renaming Images
8. Creating Keyword Tags
9. Creating New Tag Categories
10. Assigning and Managing Tags and Ratings
11. Stacking and Unstacking
12. Assigning Digital Notes
13. Sorting Images
14. Searching and Finding Your Images
15. Date View and Timeline View
16. Back Up and Restore a Catalog
17. Managing Files in the Organizer
Camera Raw
1. About Processing Camera Raw Files
2. Opening a Camera Raw Image from the Organizer
3. Opening a Camera Raw Image from the Editor
4. The Camera Raw Dialog Box in the Editor
5. Camera Raw Tools
6. Camera Calibration Settings
7. Applying and Saving Custom Camera Settings
8. Adjusting White Levels
9. Making Basic Tonal Adjustments
10. Making Image Detail Adjustments
11. Opening a Copy of the Camera Raw File in the Editor
12. Saving a Camera Raw File as a DNG File
Edit Modes
1. The Different Edit Modes
2. The Expert Edit Mode Environment
3. The Panel Bin and Taskbar
4. The Photo Bin
5. The Undo Command and Undo History Panel
6. Opening Images
7. Image Magnification
8. Viewing Document Information
9. Moving the Image
10. Setting Preferences
11. Quick Edit Mode
12. Guided Edit Mode
Basic Image Manipulation
1. Bitmap Images
2. Vector Images
3. Image Size and Resolution Settings
4. Creating New Images
5. Placing Files
6. Displaying Drawing Guides
Color Basics
1. Color Modes and Models
2. Color Mode Conversion
3. Color Management
4. Foreground and Background Colors
5. Using the Color Picker
6. Selecting Colors with the Color Picker Tool
7. Selecting Colors with the Swatches Panel
Painting Tools
1. Painting Tools
2. The Brush Tool
3. Blending Modes
4. The Impressionist Brush
5. The Pencil Tool
6. The Color Replacement Tool
7. The Eraser Tool
8. The Magic Eraser Tool
9. The Background Eraser Tool
10. The Smart Brush Tools
Brush Settings
1. Using the Brush Preset Picker
2. Loading New Brush Sets
3. Creating Custom Brush Presets
4. Creating Brush Tips from Selections
5. Setting Shape Dynamics
6. Resetting the Brush and Tool Settings
Making Selections
1. Selection Basics
2. Making Pixel Selections
3. The Marquee Tools
4. The Lasso Tool
5. The Polygonal Lasso Tool
6. The Magnetic Lasso Tool
7. The Magic Wand Tool
8. The Auto Selection Tool
9. The Selection Brush Tool
10. The Refine Selection Brush Tool
11. The Quick Selection Tool
12. Modifying Pixel Selections
13. Refining Selection Edges
14. Transforming Selections
15. Copying and Pasting Pixel Selections
16. Saving and Loading Selections
Filling and Stroking
1. Applying Fills
2. Using the Paint Bucket Tool
3. Using the Gradient Tool
4. Using the Gradient Editor
5. Using Patterns
6. Stroking
Layers
1. About Layers and the Layers Panel
2. Layer Types
3. Creating New Layers
4. Converting a Background Layer
5. Selecting Layers
6. Hiding and Showing Layers
7. Duplicating Layers
8. Stacking and Linking Layers
9. Linking Layers
10. Grouping Layers
11. Color Coding Layers
12. Moving Layer Content with the Move Tool
13. Locking Pixels in Layers
14. Renaming Layers and Deleting Layers
15. Merging Layers and Flattening Layers
16. Layer Styles
17. Adjustment Layers and Fill Layers
18. Creating Clipping Groups
19. Layer Masks
Text
1. Text Basics
2. Creating Point Text
3. Creating Paragraph Text
4. Selecting Text
5. Manipulating and Moving Text Boxes
6. Creating a Type Mask
7. Warping Text
8. Applying Layer Styles to Text Layers
9. Simplifying Text
10. Text on Selections, Shapes and Custom Paths Tools
Drawing
1. Raster vs. Vector
2. Shape Layers and Shape Options
3. Using the Shape Tools
4. The Cookie Cutter Tool
Manipulating Images
1. Changing the Canvas Size
2. Rotating and Flipping Images
3. Cropping Images
4. The Free Transform Command
5. The Smudge Tool
6. Blurring and Sharpening Images
7. Using the Dodge Tool and the Burn Tool
8. The Sponge Tool
9. Filters and The Filter Gallery
10. The Liquify Command
11. Applying Effects
12. The Clone Stamp Tool
13. The Recompose Tool
14. Photomerge
15. The Pattern Stamp Tool
16. The Healing Brush Tool
17. The Spot Healing Brush Tool
18. The Straighten Tool
19. The Content-Aware Move Tool
20. Correcting Camera Distortions
Enhancing Photos
1. Auto Fixes
2. The Red Eye Removal Tool
3. Adjusting Shadows/Highlights
4. Adjusting Brightness/Contrast
5. Using Levels
6. Removing Color Casts
7. Hue/Saturation
8. Removing Color
9. Replacing Color
10. Color Curves
11. Adjusting Skin Tone
12. Defringing Layers
13. Adjust Smart Fix
14. Convert to Black and White
15. Haze Removal
16. Adjust Sharpness
17. Open Closed Eyes
18. Adjust Facial Features
19. Shake Reduction
20. Unsharp Mask
21. Repairing Photos
Saving Images
1. Saving Images
2. The Save for Web Dialog Box
Printing, Sharing & Creating
1. Printing Images
2. Creation Wizards
3. Creating a Slide Show
4. Editing a Slide Show
5. Sharing Your Creations
Help
1. Elements Help
2. System Info
3. Online Updates
Getting Acquainted with PowerPoint
1. The PowerPoint Environment
2. The Title Bar
3. The Ribbon
4. The "File" Tab and Backstage View
5. The Quick Access Toolbar
6. Touch/Mouse Mode
7. The Scroll Bars
8. The Presentation View Buttons
9. The Zoom Slider
10. The Status Bar
11. The Mini Toolbar
12. Keyboard Shortcuts
13. What's New in PowerPoint 2016
Creating Basic Presentations
1. Opening Presentations
2. Closing Presentations
3. Creating New Presentations
4. Saving Presentations
5. Recovering Unsaved Presentations
6. Inserting New Slides
7. Applying Slide Layouts
8. Sharing Presentations
9. Working with PowerPoint File Formats
Using Presentation Views
1. Normal View
2. Outline View
3. Slide Sorter View
4. Notes Page View
5. Slide Show View
6. Reading View
Using Text
1. Adding Text to Slides
2. Basic Object Manipulation
3. Font Formatting
4. Paragraph Formatting
5. Applying Custom Bullets and Numbering
6. Using Tabs
7. Setting Text Options
8. Checking Spelling
Using Pictures
1. Inserting Pictures Saved Locally
2. Inserting Online Pictures
3. Basic Graphic Manipulation
4. Using Picture Tools
5. Using the Format Picture Task Pane
6. Fill and Line Settings
7. Effects Settings
8. Size and Properties Settings
9. Picture Settings
Using SmartArt
1. Inserting and Manipulating SmartArt
2. Formatting SmartArt
Using Slide Show View
1. Running a Slide Show
2. Using Custom Shows
Printing Your Presentation
1. Changing Slide Size
2. Setting the Slide Header and Footer
3. Previewing and Printing Presentations
Helping Yourself
1. Using PowerPoint Help
2. The Tell Me Bar
3. Smart Lookup and Insights
Applying Animation
1. Adding Slide Transition Animation
2. Adding Object Animation
Drawing Objects
1. Inserting Shapes
2. Formatting Shapes
3. Inserting WordArt
Inserting Video and Sound
1. Inserting Videos
2. Inserting Audio
3. Animating Multimedia Playback
4. Recording a Sound
5. Screen Recording
Using Themes
1. Applying Themes
2. Creating Custom Color Schemes
3. Creating Custom Font Schemes
4. Customizing the Slide Background
Using Presentation Masters
1. Using Slide Masters and Slide Layouts
2. Using the Notes Master
3. Using the Handout Master
4. Saving a Presentation Template
Setting Up the Presentation
1. Setting Up the Slide Show
2. Recording Narration
3. Rehearsing Timings
Applying Actions
1. Inserting Actions
2. Inserting Hyperlinks
Inserting Charts, Tables, and Objects
1. Inserting Charts
2. Inserting Tables
3. Inserting Objects
Setting PowerPoint Options
1. Setting PowerPoint Options
Getting Acquainted with Project
1. About Project
2. Starting Project
3. Project Management Terms and Concepts
4. The Project Environment
5. The Title Bar
6. The Ribbon
7. The "File" Tab and Backstage View
8. The Scroll Bars
9. The Quick Access Toolbar
10. The Entry Bar
11. The Status Bar
12. Touch Mode
Project Basics
1. Opening Projects
2. Closing Projects
3. Creating New Projects
4. Saving Projects
5. Changing Project Views
6. Planning a Project
Tasks
1.Creating Tasks
2. Editing and Deleting Tasks
3. Setting Task Duration
4. Linking Tasks
5. Marking Milestones
6. Using Phases and Summary Tasks
7. Using Task Notes
Resources
1. Project Resources Overview
2. Creating Work Resources
3. Creating Material Resources
4. Creating Cost Resources
5. Entering Costs for Project Resources
6. Scheduling Work Resources
7. Creating New Base Calendars
Resource and Task Assignment
1. Assigning Work Resources to Tasks
2. Assigning Material Resources to Tasks
3. Assigning Cost Resources to Tasks
4. The Team Planner
Tracking Project Tasks
1. Creating Project Baselines
2. Updating Multiple Tasks in a Project
3. Updating Tasks Individually
4. Rescheduling Uncompleted Work
Formatting Gantt Chart Views
1. Formatting Text in a Gantt Chart
2. Formatting Gridlines in a Gantt Chart
3. Formatting the Task Bar Layout in a Gantt Chart
4. Formatting Columns in Gantt Charts
5. Applying Bar and Gantt Chart Styles
6. Drawing Objects
7. Formatting Timescale in Gantt Charts
8. Creating Custom Views
Other Project Views
1. Using Timeline View
2. Creating Multiple Timelines
3. The Task Usage View
4. The Network Diagram View
5. The Calendar View
6. Printing Views
Advanced Task Management
1. Setting Task Lead and Lag Time
2. Using Task Constraints
3. Task Types
4. Setting Deadlines
5. Interrupting Tasks
6. Moving and Rescheduling Tasks
7. Inspecting Tasks
8. Creating Recurring Tasks
9. Entering Fixed Costs
10. Critical Paths
11. Using WBS Codes
Advanced Resource Management
1. Applying Multiple Resource Rates
2. Advanced Resource Availability
3. Using Work Contours
4. Material Resource Consumption Rates
5. Delaying Resource Assignments
Advanced Project Tracking
1. Monitoring Resource Allocation
2. Leveling Overallocated Resources
3. Monitoring Project Costs
4. Monitoring Project Statistics
Advanced Project Tools
1. Using the Organizer
2. Making Macros
3. Customizing the Ribbon
4. Creating and Linking Resource Pools
5. Using and Updating Resource Pools
6. Consolidating and Linking Multiple Projects
Reporting
1. Using Earned Value Analysis
2. Creating Basic Reports
3. Selecting Report Objects
4. Changing the Report View
5. Basic Report Formatting
6. Inserting Report Objects
7. Managing Reports
8. Basic Page Setup for Reports
9. Advanced Page Setup for Reports
10. Printing Reports
Modifying Report Objects
1. Selecting, Moving and Resizing Report Charts
2. Using the Field List with Report Charts
3. Designing Report Charts
4. Formatting Report Charts
5. Using Report Tables
6. Designing Report Tables
7. Setting Report Table Layout Options
8. Modifying Pictures, Text Boxes and Shapes
9. Formatting Text Boxes and Shapes
10. Formatting Report Pictures
Visual Reporting
1. Using Visual Reports
Getting Acquainted with Publisher
1. The Publisher Environment
2. The Title Bar
3. The Ribbon
4. The File Tab and Backstage View
5. The Quick Access Toolbar
6. Touch Mode
7. The Scroll Bars
8. The Page Layout View Buttons
9. The Zoom Slider and Zoom Button
10. The Status Bar
11. The Mini Toolbar
12. Keyboard Shortcuts
Creating Basic Publications
1. Creating New Publications
2. Changing the Publication Template
3. Using Business Information
4. Saving Publications
5. Closing Publications
6. Opening Publications
7. Inserting New Pages
8. Deleting Pages
9. Moving Pages
Basic Skills
1. Inserting Text Boxes
2. Inserting Shapes
3. Adding Text to Shapes
4. Inserting Pictures Saved Locally
5. Inserting Online Pictures
6. Inserting Picture Placeholders
7. Using the Scratch Area
8. Moving, Resizing, and Rotating Objects
9. Deleting Objects
10. Using Find and Replace
11. Using AutoCorrect
12. Inserting WordArt
Formatting Objects
1. Formatting Text
2. Formatting Shapes
3. Formatting Pictures
Using Building Blocks
1. Creating Basic Building Blocks
2. Using Building Blocks
Master Pages
1. Using Master Pages
Customizing Schemes
1. Creating a Custom Color Scheme
2. Creating a Custom Font Scheme
3. Customizing Page Backgrounds
Using Tables
1. Creating and Deleting Tables
2. Selecting Table Elements
3. Inserting and Deleting Columns and Rows
4. Merging Text in Table Cells
5. Modifying Text in Table Cells
6. Formatting Tables
Page Setup and Layouts
1. Using Page Setup
2. Using Layout Guides
3. Using the Rulers
Mailings
1. Mail Merge
2. The Step by Step Mail Merge Wizard
3. Creating a Data Source
4. Selecting Recipients
5. Inserting and Deleting Merge Fields
6. Previewing a Merge
7. Detaching the Data Source
8. Finishing a Mail Merge
9.Merging a Catalog
Printing
1. Previewing and Printing
2. Using the Pack and Go Feature
3. Sharing and Exporting Publications
Helping Yourself
1. Using Publisher Help
The QuickBooks Environment
1. The Home Page
2. The Centers
3. The Menu Bar and Keyboard Shortcuts
4. The Open Window List
5. The Icon Bar
6. Customizing the Icon Bar
7. The Chart of Accounts
8. Accounting Methods
9. Financial Reports
Creating a QuickBooks Company File
1. Using Express Start
2. Using the EasyStep Interview
3. Returning to the Easy Step Interview
4. Creating a Local Backup Copy
5. Restoring a Company File from a Local Backup Copy
6. Setting Up Users
7. Single and Multiple User Modes
8. Closing Company Files
9. Opening a Company File
Using Lists
1. Using Lists
2. The Chart of Accounts
3. The Customers & Jobs List
4. The Employees List
5. The Vendors List
6. Using Custom Fields
7. Sorting List
8. Inactivating and Reactivating List Items
9. Printing Lists
10. Renaming & Merging List Items
11. Adding Multiple List Entries from Excel
Setting Up Sales Tax
1. The Sales Tax Process
2. Creating Tax Agencies
3. Creating Individual Sales Tax Items
4. Creating a Sales Tax Group
5. Setting Sales Tax Preferences
6. Indicating Taxable & Non-taxable Customers and Items
Setting Up Inventory Items
1. Setting Up Inventory
2. Creating Inventory Items
3. Creating a Purchase Order
4. Receiving Items with a Bill
5. Entering Item Receipts
6. Matching Bills to Item Receipts
7. Adjusting Inventory
Setting Up Other Items
1. Service Items
2. Non-Inventory Items
3. Other Charges
4. Subtotals
5. Groups
6. Discounts
7. Payments
8. Changing Item Prices
Basic Sales
1. Selecting a Sales Form
2. Creating an Invoice
3. Creating Batch Invoices
4. Creating a Sales Receipt
5. Finding Transaction Forms
6. Previewing Sales Forms
7. Printing Sales Forms
Using Price Levels
1. Using Price Levels
Creating Billing Statements
1. Setting Finance Charge Defaults
2. Entering Statement Charges
3. Applying Finance Charges and Creating Statements
Payment Processing
1. Recording Customer Payments
2. Entering a Partial Payment
3. Applying One Payment to Multiple Invoices
4. Entering Overpayments
5. Entering Down Payments or Prepayments
6. Applying Customer Credits
7. Making Deposits
8. Handling Bounced Checks
Handling Refunds
1. Creating a Credit Memo and Refund Check
2. Refunding Customer Payments
Entering and Paying Bills
1. Setting Billing Preferences
2. Entering Bills
3. Paying Bills
4. Early Bill Payment Discounts
5. Entering a Vendor Credit
6. Applying a Vendor Credit
Using Bank Accounts
1. Using Registers
2. Writing Checks
3. Writing a Check for Inventory Items
4. Printing Checks
5. Transferring Funds
6. Reconciling Accounts
7. Voiding Checks
Paying Sales Tax
1. Sales Tax Reports
2. Using the Sales Tax Payable Register
3. Paying Your Tax Agencies
Reporting
1. Graph and Report Preferences
2. Using QuickReports
3. Using QuickZoom
4. Preset Reports
5. Modifying a Report
6. Rearranging and Resizing Report Columns
7. Memorizing a Report
8. Memorized Report Groups
9. Printing Reports
10. Batch Printing Forms
11.Exporting Reports to Excel
12. Saving Forms and Reports as PDF Files
13. Comment on a Report
14. Process Multiple Reports
15. Scheduled Reports
Using Graphs
1. Using Graphs
2. Company Snapshot
Customizing Forms
1. Creating New Form Templates
2. Performing Basic Customization
3. Performing Additional Customization
4. The Layout Designer
5. Changing the Grid and Margins in the Layout Designer
6. Selecting Objects in the Layout Designer
7. Moving and Resizing Objects in the Layout Designer
8. Formatting Objects in the Layout Designer
9. Copying Objects and Formatting in the Layout Designer
10. Adding and Removing Objects in the Layout Designer
11. Aligning and Stacking Objects in the Layout Designer
12. Resizing Columns in the Layout Designer
Estimating
1. Creating a Job
2. Creating an Estimate
3. Duplicating Estimates
4. Invoicing From Estimates
5. Updating Job Statuses
6. Inactivating Estimates
7. Making Purchases for a Job
8. Invoicing for Job Costs
9. Using Job Reports
Time Tracking
1. Tracking Time and Printing a Blank Timesheet
2. Weekly Timesheets
3. Time/Enter Single Activity
4. Invoicing from Time Data
5. Using Time Reports
6. Tracking Vehicle Mileage
7. Charging Customers for Mileage
Payroll
1. The Payroll Process
2. Creating Payroll Items
3. Setting Employee Defaults
4. Setting Up Employee Payroll Information
5. Creating Payroll Schedules
6. Creating Scheduled Paychecks
7. Creating Unscheduled Paychecks
8. Creating Termination Paychecks
9. Voiding Paychecks
10. Tracking Your Tax Liabilities
11. Paying Your Payroll Tax Liabilities
12. Adjusting Payroll Liabilities
13. Entering Liability Refund Checks
14. Process Payroll Forms
15. Tracking Workers Compensation
Using Credit Card Accounts
1. Creating Credit Card Accounts
2. Entering Credit Card Charges
3. Reconciling and Paying Credit Cards
Assets and Liabilities
1. Assets and Liabilities
2. Creating and Using an Other Current Asset Account
3. Removing Value from Other Current Asset Accounts
4. Creating Fixed Asset Accounts
5. Creating Liability Accounts
6. Setting the Original Cost of Fixed Assets
7. Tracking Depreciation
8. The Loan Manager
9. The Fixed Asset Item List
Equity Accounts
1. Equity Accounts
2. Recording an Owner's Draw
3. Recording a Capital Investment
Writing Letters With QuickBooks
1. Using the Letters and Envelopes Wizard
2. Editing Letter Templates
Company Management
1. Viewing Your Company Information
2. Setting Up Budgets
3. Using the To Do List
4. Using Reminders and Setting Preferences
5. Making General Journal Entries
6. Using the Cash Flow Projector
Using QuickBooks Tools
1. Company File Cleanup
2. Exporting List Data to an IIF File
3. Advanced Importing of Data
4. Updating QuickBooks
5. Using the Calculator
6. Using the Portable Company Files
7. Using the Calendar
8. The Income Tracker
9. The Bill Tracker
10. The Lead Center
Using the Accountant's Review
1. Creating an Accountant's Copy
2. Transferring an Accountant's Copy
3. Importing Accountant's
4. Removing Restrictions
Using the Help Menu
1. Using Help
The QuickBooks Online Plus Environment
1. The Dashboard Page
2. The Create Menu
3. The Navigation Bar
4. The Gear
Creating a Company File
1. Signing Up for QuickBooks Online Plus
2. Importing Company Data from a QuickBooks Desktop Version
3. Creating a New Company File
4. How Backups Work in QuickBooks Online Plus
5. Setting Up and Managing Users
6. Transferring the Master Administrator
7. Customizing Company File Settings
8. Customizing Billing and Subscription Settings
9. Customizing Sales Settings
10. Customizing Expenses Settings
11. Customizing Payment Settings
12. Customizing Advanced Settings
13. Signing Out of QuickBooks Online
14. Switching Company Files
15. Cancelling a Company File
Using Pages and Lists
1. Using Lists and Pages
2. The Chart of Accounts
3. Adding New Accounts
4. Assigning Account Numbers
5. Adding New Customers
6. The Customers Page and List
7. Adding Employees to the Employees List
8. Adding New Vendors
9. The Vendors Page and List
10. Sorting Lists
11. Inactivating and Reactivating List Items
12. Printing Lists
13. Renaming and Merging List Items
14. Importing List Entries from a CSV or Excel File
Setting Up Sales Tax
1. The Sales Tax Process in QuickBooks Online
2. Enabling Sales Tax and Sales Tax Settings
3. Adding, Editing, and Deactivating Sales Tax Rates and Agencies
4. Setting a Default Sales Tax
5. Indicating Taxable & Non-Taxable Customers and Items
Setting Up Inventory Items
1. Setting Up Inventory
2. Creating Inventory Items
3. Enabling Custom Fields in Purchase Orders
4. Creating a Purchase Order
5. Applying Purchase Orders to Vendor Transactions
6. Adjusting Inventory
Setting Up Other Items
1. Creating a Product or Service Item
2. Creating a Bundle
3. Creating a Discount Line Item
4. Creating a Payment Plan
5. Changing Item Prices
Basic Sales
1. Enabling Custom Fields in Sales Forms
2. Creating an Invoice
3. Creating a Recurring Invoice
4. Creating Batch Invoices
5. Creating a Sales Receipt
6. Finding Transaction Forms
7. Previewing Sales Forms
8. Printing Sales Forms
9. Grouping and Subtotaling Items in Invoices
10. Grouping and Hiding Item Display in Service Only Invoices
11. Entering a Delayed Charge
12. Managing Sales Transactions
13. Sending Invoice Links
Creating Billing Statements
1. Entering Customer Charges
2. Creating Finance Charge Items
3. Creating Finance Charge Invoices
4. Creating Customer Statements
Payment Processing
1. Recording Customer Payments
2. Entering a Partial Payment
3. Applying One Payment to Multiple Invoices
4. Entering Overpayments
5. Entering Down Payments or Prepayments
6. Applying Customer Credits
7. Making Deposits
8. Handling Bounced Checks by Invoice
9. Handling Bounced Checks by Check
10. Handling Bounced Checks by Journal Entry
11. Handling Bad Debt
Handling Refunds
1. Creating a Credit Memo and Refund Check
2. Refunding Customer Payments
3. Entering a Delayed Credit
Entering And Paying Bills
1. Entering Bills
2. Paying Bills
3. Creating Terms for Early Bill Payment
4. Early Bill Payment Discounts
5. Entering a Vendor Credit
6. Applying a Vendor Credit
7. Managing Expense Transactions
Using Bank Accounts
1. Using Registers
2. Writing Checks
3. Writing a Check for Inventory Items
4. Printing Checks
5. Transferring Funds Between Accounts
6. Reconciling Accounts
7. Voiding Checks
8. Creating an Expense
9. Managing Bank and Credit Card Transactions
10. Managing Bank Transaction Rules
Paying Sales Tax
1. Sales Tax Reports
2. Using the Sales Tax Payable Register
3. Paying Your Tax Agencies
Reporting
1. Creating Customer and Vendor QuickReports
2. Creating Account QuickReports
3. Using QuickZoom
4. Preset Reports
5. Basic Preset Report Customization
6. Customizing General Report Settings
7. Customizing Rows and Columns Report Settings
8. Customizing Aging Report Settings
9. Customizing Filter Report Settings
10. Customizing Header and Footer Report Settings
11. Resizing Report Columns
12. Emailing, Printing, and Exporting Preset Reports
13. Saving Customized Reports
14. Using Report Groups
15. Management Reports
16. Customizing Management Reports
Using Graphs
1. Company Snapshot
Customizing Forms
1. Creating Custom Form Styles
2. Custom Form Design Settings
3. Custom Form Content Settings
4. Custom Form Emails Settings
5. Custom Form Payments Settings
6. Managing Custom Form Styles
Estimating
1. Using Sub-Customers for Jobs
2. Enabling and Creating Estimates
3. Changing the Term “Estimate”
4. Invoicing from an Estimate
5. Duplicating Estimates
6. Using an Estimate with Multiple
Invoices
7. Changing the Estimate Status
8. Entering Expenses for Jobs
9. Invoicing for Job Costs
10. Using Job Reports
11. Deleting Estimates
Time Tracking
1. Tracking Time and Printing Timesheets
2. Weekly Timesheets
3. Single Time Activity
4. Invoicing from Time Data
5. Using Time Reports
6. Entering Bills for Mileage
Payroll
1. The Payroll Process
2. Creating Employee Deductions andCompany Contributions & Garnishments
3. Adding Additional Pay Types for Employees
4. Editing Employee Information
5. Creating Payroll Schedules
6. Creating Scheduled Paychecks
7. Creating One Paycheck at a Time
8. Creating Commission Only or Bonus Only Paychecks
9. Handling Terminated Employees
10. Edit, Delete, or Void Paychecks
11. Tracking Your Tax Liabilities
12. Paying Payroll Tax Liabilities
13. Adjusting Fringe Benefits
14. Process Payroll Forms
15. Tracking Workers’ Compensation
16. Manually Recording External Payroll
Using Credit Card Accounts
1. Creating Credit Card Accounts
2. Entering Charges on Credit Cards
3. Entering Credit Card Credits
4. Reconciling and Paying Credit Cards
Assets and Liabilities
1. Assets and Liabilities
2. Creating and Using Other Current Asset Accounts
3. Removing Value from Other Current Asset Accounts
4. Creating Fixed Asset Accounts
5. Creating Liability Accounts
6. Setting the Original Cost of the Fixed Asset
7. Tracking Depreciation
Equity Accounts
1. Equity Accounts
2. Recording an Owner's Draw
3. Recording a Capital Investment
Company Management
1. Viewing Your Company Information
2. Setting Up Budgets
3. Using the Reminder List
4. Making General Journal Entries
Using QuickBooks Tools
1. Exporting Report and List Data to Excel
2. Using the Audit Log
Using QuickBooks Other Lists
1. Using the Recurring Transactions List
2. Using the Location List
3. Using the Payment Methods List
4. Using the Terms List
5. Using the Classes List
6. Using the Attachments List
Allowing Accountant Access
1. Inviting Your Accountant
Using Help, Feedback and Apps
1. Using the Help Menu
2. Submitting Feedback
3. Extending QuickBooks Online Using Apps
Introduction to Resume Writing
1. The Function of a Resume
2. Types of Resumes
3. How Long Should Your Resume Be?
4. Fonts, Margins and Printing
5. File Formats
Section Headings
1. Developing a "Master Resume"
2. Resume Header
3. Objective/Summary/Profile
4. Experience
5. Education
6. Skills
7. Involvement
8. Research
9. Awards
10. Publications
11. Activities
12. Work Status
13. Tailoring Your Resume
Understanding Keywords
1. About ATS
2. Researching Keywords
3. Using Keywords in Your Resume
Covering All The Bases
1. The Cover Letter
2. Developing Professional References
3. Other Preparations
Review Questions
1. Review Questions 1-5
2. Review Questions 6-10
3. Review Questions 11-15
Conclusion
1. Further Study
2. Conclusion
Getting Acquainted with Sage 50
1. The Sage 50 Environment
2. The Sage 50 Navigation Centers
3. Using the Menu Bar
4. Learning Common Business Terms
Setting Up a Company
1. Creating a Sage 50 Company
2. Setting Customer Defaults
3. Setting Vendor Defaults
4. Setting Inventory Defaults
5. The Payroll Setup Wizard
6. Setting Employee Defaults
7. Setting Job Defaults
8. Making a Backup
9. Restoring from a Backup File
10. Setting up Security and Creating Users
Using the General Ledger
1. General Ledger Default Settings
2. Adding Accounts
3. Deleting Accounts
4. Adding Beginning Account Balances
5. Adding General Journal Entries
6. Basic General Ledger Reports
7. Entering Account Budgets
8. The Cash Account Register
Using Sales Tax
1. The Sales Tax Wizard
2. Collecting Sales Tax
3. Paying Sales Taxes
Entering Records
1. Entering Customer Records
2. Entering Customer Beginning Balances
3. Entering Vendor Records
4. Entering Vendor Beginning Balances
5. Entering Inventory
6. Entering Inventory Beginning Balances
7. Changing a Record ID
Accounts Receivable
1. Setting Statement and Invoice Defaults
2. Quotes, Sales Orders and Invoicing
3. Entering Quotes
4. Converting Quotes
5. The Sales Orders Window
6. The Proposals Window
7. The Sales/Invoicing Window
8. Entering and Applying Credit Memos
9. The Receive Money Window
10. Statements and Finance Charges
11. Selecting Deposits
Accounts Payable
1. The Purchase Orders Window
2. Entering a Drop Shipment
3. Select for Purchase Orders
4. The Purchases/Receive Inventory Window
5. The Payments Window
6. The Select For Payment Window
7. Entering Vendor Credit Memos
Managing Inventory
1. Building and Unbuilding Assemblies
2. Making Inventory Adjustments
3. Changing Item Prices
Creating Payroll
1. Adding Employees
2. Adding Employee Beginning Balances
3. Performance Reviews and Raise History
4. Paying a Group of Employees
5. Paying an Employee
Account Management
1. Writing Checks
2. Voiding Checks
3. Reconciling Bank Accounts
4. Changing the Accounting Period
Job Tracking
1. Setting Up a Job
2. Creating Custom Fields for Jobs
3. Creating Phases for Jobs
4. Creating Cost Codes for Phases
5. Entering Beginning Balances for a Job
6. Making Purchases for a Job
7. Invoicing for Job Purchases
8. Job Tracking
9. Entering Change Orders for a Job
Time and Billing
1. Adding Time Ticket Employees
2. Entering Activity Items
3. Entering Charge Items
4. Entering Time Tickets
5. Entering Expense Tickets
6. Billing Time and Expense Tickets
Changing System Settings
1. Changing Your Company's Posting Methods
2. Posting/Unposting
3. Memorized Transactions
4. Using the Purge Wizard
5. Using the Year-End Wizard
Reporting
1. The Cash Manager
2. The Collection Manager
3. The Payment Manager
4. The Financial Manager
5. Find on Report
6. Previewing and Printing Preset Reports
7. Report Groups
8. Modifying Reports
9. Exporting Reports to Excel
10. Importing and Exporting Data
11. Exporting Reports to PDF
12. Modifying Task Window Screen Templates
13. Modifying Forms
The Internal Accounting Review
1. Using the Internal Accounting Review
Action Items
1. Events
2. To-Do Items
3. Alerts
Options
1. Changing Global Options
2. Changing the System Date
Assets and Liabilities
1. Assets and Liabilities
2. Creating an Other Current Assets Account
3. Subtracting Value from an Other Current Assets Account
4. Creating a Fixed Assets Account
5. Accumulated Depreciation
6. Liability Accounts
7. Paying on a Long Term Liability
8. Equity
Help
1. Using the Contents
2. Using the Index
3. Using the Search Feature
Introduction to Databases and SQL
1. Overview of a Database
2. The "Flat-File" Method of Data Storage
3. The Relational Model of Data Storage
4. Tips for Creating a Relational Database
5. What is SQL?
6. Using SQL in Access 2013
Data Definition Language
1. The CREATE Statement
2. The CREATE DATABASE Statement
3. The CREATE TABLE Statement
4. The CREATE INDEX Statement
5. SQL Constraints
6. The DROP Statement
7. The ALTER TABLE Statement
8. NULL Values in SQL
9. Data Types in SQL
10. Auto-Increment in SQL
Data Manipulation Language
1. The INSERT Statement
2. The UPDATE Statement
3. The DELETE Statement
4. The SELECT Statement
5. The WHERE Clause
6. Criteria Notation and Wildcard Characters in the WHERE Clause
7. The ORDER BY Clause
8. The GROUP BY Clause and Aggregate Functions
9. The JOIN Clause
10. The UNION Operator
11. The SELECT INTO Statement
12. The INSERT INTO SELECT Statement
13. Subqueries
Data Control Language
1. The CREATE USER and CREATE ROLE Statements
2. Privileges
3. The GRANT Statement
4. The REVOKE Statement
5. The ALTER USER and ALTER ROLE Statements
6. The DROP USER and DROP ROLE Statements
Transaction Control Language
1. The TRANSACTION Statement
SQL Functions and Aliases
1. Understanding SQL Functions
2. Calculated Fields and Column Aliases
3. Table Aliases
Views
1. About Views
2. The CREATE VIEW Statement
3. The ALTER VIEW Statement
4. The DROP VIEW Statement
Introduction to Windows
1. About Windows
2. Sign in to Windows 10 with a Microsoft User Account
3. The Mouse
4. Touch Gestures in Windows 10
5. The Windows Desktop
6. The Start Button
7. The Start Menu in Windows 10
8. Customizing the Start Menu in Windows 10
9. The Start Screen in Windows 10
10. Customizing the Start Screen in Windows 10
11. Choosing the Start Menu or Start Screen
12. Tablet Mode Settings in Windows 10
13. Using Tablet Mode in Windows 10
14. Text Search in Windows 10
15. Search Using Cortana in Windows 10
16. Universal App Windows in Windows 10
17. App Snapping in Windows 10
18. Resizing a Desktop Window
19. Scrolling a Window
20. Shutting Down Windows
21. Downloading Apps from the Windows Store
22. Sign-in with a PIN or Picture
23. Changing or Removing a PIN or Picture Password
File Explorer
1. File Explorer in Windows 10
2. Navigating Folders
3. Changing Folder Views
4. Sorting Folder Contents
5. Selecting Files
6. Opening a File
7. Reopening a Frequently Opened Folder
8. Creating a New Folder
9. Renaming Files and Folders
10. Cutting, Copying, and Pasting Files and Folders
11. Burning a CD or DVD
12. Deleting Files
13. Managing Libraries in Windows 10
14. Managing the Computer and Drives in Windows 10
15. Quick Access in Windows 10
16. OneDrive Folders in File Explorer
17. Zip Folders in File Explorer
18. Unzip Files in File Explorer
Windows 10 Settings
1. Windows 10 Settings
System Settings
1. Accessing the “System” Settings
2. Changing the Display Settings
3. Notification and Action Settings
4. Managing Apps and Features
5. Multitasking Settings in Windows 10
6. Battery Saver Settings in Windows 10
7. Power and Sleep Settings in Windows 10
8. Manage Storage Space in Windows 10
9. Download and Manage Offline Maps in Windows 10
10. Set the Default Apps in Windows 10
11. View Information About Your Device
Devices Settings
1. Accessing the “Devices” Settings
2. Managing Printers and Scanners
3. Managing Other Connected Devices
4. Mouse and Touchpad Settings
5. Typing Settings
6. AutoPlay Settings
Network and Internet Settings
1. Accessing the “Network and Internet” Settings
2. Connect to Wi-Fi Networks and Manage Wi-Fi Settings
3. Airplane Mode Settings
4. View Data Usage
5. VPN Settings
6. Dial-up Settings
7. Ethernet Settings
8. Proxy Settings
Personalization Settings
1. Accessing the “Personalization” Settings
2. Changing the Background Settings
3. Changing the Color Settings
4. Lock Screen and Screen Saver Settings
5. Theme, Sound, and Desktop Icon Settings
6. Start Settings
Accounts Settings
1. Accessing the “Accounts” Settings
2. Managing Your Account Settings
3. Manage Sign-in Options for Your Device
4. Managing Work Access Account Settings
5. Managing Family and Other Users
6. Managing Sync Settings
Time and Language Settings
1. Accessing the “Time and Language” Settings
2. Date and Time Settings
3. Region and Language Settings
4. Speech Settings
Ease of Access Settings
1. Accessing the “Ease of Access” Settings
2. Narrator Settings
3. Magnifier Settings
4. High Contrast Settings
5. Closed Captions Settings
6. Keyboard Accessibility Settings
7. Mouse Accessibility Settings
8. Cursor and Other Visual Accessibility Settings
Privacy Settings
1. Accessing the “Privacy” Settings
2. General Privacy Settings
3. Location Privacy Settings
4. Camera Privacy Settings
5. Microphone Privacy Settings
6. Speech, Inking, and Typing Privacy Settings
7. Account Info Privacy Settings
8. Contacts Privacy Settings
9. Calendar Privacy Settings
10. Messaging Privacy Settings
11. Radios Privacy Settings
12. Privacy Settings for Other Devices
13. Feedback and Diagnostics Privacy Settings
14. Background Apps Privacy Settings
Update and Security Settings
1. Accessing the “Update and Security” Settings
2. Windows Update Settings
3. Windows Defender Settings
4. Backup Settings
5. Recovery Settings
6. Activation Settings
7. Developer Settings
Control Panel Settings
1. The Control Panel
2. File History
3. System Restore
4. Audio Adjustment
5. Adding Devices and Printers
6. Installing and Uninstalling Software
Desktop Management
1. The Recycle Bin
2. Creating Desktop Shortcuts
3. Pinning Items to the Taskbar
4. Moving and Resizing the Taskbar
5. Setting the Date and Time Display
6. The Action Center
7. Virtual Desktops
8. OneDrive Settings
9. Using Cortana
Creating Documents
1. Starting WordPad and Creating a New Document
2. Copying and Pasting Text
3. Formatting Text
4. Saving a Document
5. Opening a Document
6. Printing a Document
7. Closing a Document
Drawing Pictures
1. Starting Paint and Creating a New Document
2. Drawing Shapes and Lines
3. Adding Text
4. Erasing Parts of a Picture
5. Saving a Picture
6. Opening a Picture
Using the Internet and Microsoft Edge
1. About the Internet
2. Connecting to the Internet
3. The Microsoft Edge Interface
4. Viewing Web Pages in Microsoft Edge
5. Find Text in Web Pages in Microsoft Edge
6. Reading View in Microsoft Edge
7. Add a Favorite to Microsoft Edge
8. Add a Page to the Reading List
9. Manage Favorites in the Hub
10. Manage the Reading List in the Hub
11. Manage Browser History in the Hub
12. Manage Downloads in the Hub
13. Make a Web Note in Microsoft Edge
14. Sharing Web Pages in Microsoft Edge
15. Opening a New Window or New InPrivate Window
16. Zoom Web Pages in Microsoft Edge
17. Print Web Pages in Microsoft Edge
18. Settings in Microsoft Edge
19. Advanced Settings in Microsoft Edge
20. Using Cortana in Microsoft Edge
21. Windows Defender in Windows 10
Printing Information
1. Selecting a Printer
2. General Printing Options
3. Managing Print Jobs
Getting Acquainted with Word
1. About Word
2. The Word Environment
3. The Title Bar
4. The Ribbon
5. The "File" Tab and Backstage View
6. The Quick Access Toolbar
7. Touch Mode
8. The Ruler
9. The Scroll Bars
10. The Document View Buttons
11. The Zoom Slider
12. The Status Bar
13. The Mini Toolbar
14. Keyboard Shortcuts
Creating Basic Documents
1. Opening Documents
2. Closing Documents
3. Creating New Documents
4. Saving Documents
5. Recovering Unsaved Documents
6. Entering Text
7. Moving through Text
8. Selecting Text
9. Non-Printing Characters
Document Views
1. Changing Document Views
2. Showing and Hiding the Ruler
3. Showing and Hiding Gridlines
4. Showing and Hiding the Navigation Pane
5. Zooming the Document
6. Opening a Copy of a Document in a New Window
7. Arranging Open Document Windows
8. Split Window
9. Comparing Open Documents
10. Switching Open Documents
11. Switching to Full Screen View
12. Working with Word File Formats
Basic Editing Skills
1. Deleting Text
2. Cutting, Copying, and Pasting
3. Undoing and Redoing Actions
4. Finding and Replacing Text
5. Selecting Text and Objects
Basic Proofing Tools
1. The Spelling and Grammar Tool
2. Setting Default Proofing Options
3. Using the Thesaurus
4. Finding the Word Count
5. Translating Documents
Font Formatting
1. Formatting Fonts
2. The Font Dialog Box
3. The Format Painter
4. Applying Styles to Text
5. Removing Styles from Text
Formatting Paragraphs
1. Aligning Paragraphs
2. Indenting Paragraphs
3. Line Spacing and Paragraph Spacing
Document Layout
1. About Documents and Sections
2. Setting Page and Section Breaks
3. Creating Columns in a Document
4. Creating Column Breaks
5. Using Headers and Footers
6. The Page Setup Dialog Box
7. Setting Margins
8. Paper Settings
9. Layout Settings
10. Adding Line Numbers
11. Hyphenation Settings
Using Templates
1. Using Templates
2. Creating Personal Templates
Printing Documents
1. Previewing and Printing Documents
Helping Yourself
1. Using Word Help
2. The Tell Me Bar- 2016 Only
3. Smart Lookup and Insights- 2016 Only
Working with Tabs
1. Using Tab Stops
2. Using the Tabs Dialog Box
Pictures and Media
1. Inserting Online Pictures
2. Inserting Your Own Pictures
3. Using Picture Tools
4. Using the Format Picture Task Pane
5. Fill & Line Settings
6. Effects Settings
7. Layout & Properties Settings
8. Picture Settings
9. Inserting Screenshots
10. Inserting Screen Clippings
11. Inserting Online Video
Drawing Objects
1. Inserting Shapes
2. Inserting WordArt
3. Inserting Text Boxes
4. Formatting Shapes
5. The Format Shape Task Pane
6. Inserting SmartArt
7. Design and Format SmartArt
8. Inserting Charts
Using Building Blocks
1. Creating Building Blocks
2. Using Building Blocks
Styles
1. About Styles
2. Applying Styles
3. Showing Headings in the Navigation Pane
4. The Styles Task Pane
5. Clearing Styles from Text
6. Creating a New Style
7. Modifying an Existing Style
8. Selecting All Instances of a Style in a Document
9. Renaming Styles
10. Deleting Custom Styles
11. Using the Style Inspector Pane
12. Using the Reveal Formatting Pane
Themes and Style Sets
1. Applying a Theme
2. Applying a Style Set
3. Customizing Theme Colors
4. Customizing Theme Fonts
5. Selecting Theme Effects
Page Backgrounds
1. Applying Watermarks
2. Creating Custom Watermarks
3. Removing Watermarks
4. Selecting a Page Background Color or Fill Effect
5. Applying Page Borders
Bullets and Numbering
1. Applying Bullets and Numbering
2. Formatting Bullets and Numbering
3. Applying a Multilevel List
4. Modifying a Multilevel List Style
Tables
1. Using Tables
2. Creating Tables
3. Selecting Table Objects
4. Inserting and Deleting Columns and Rows
5. Deleting Cells and Tables
6. Merging and Splitting Cells
7. Adjusting Cell Size
8. Aligning Text in Table Cells
9. Converting a Table into Text
10. Sorting Tables
11. Formatting Tables
12. Inserting Quick Tables
Table Formulas
1. Inserting Table Formulas
2. Recalculating Word Formulas
3. Viewing Formulas vs. Formula Results
4. Inserting a Microsoft Excel Worksheet
Inserting Page Elements
1. Inserting Drop Caps
2. Inserting Equations
3. Inserting Ink Equations
4. Inserting Symbols
5. Inserting Bookmarks
6. Inserting Hyperlinks
Outlines
1. Using Outline View
2. Promoting and Demoting Outline Text
3. Moving Selected Outline Text
4. Collapsing and Expanding Outline Text
Mailings
1. Mail Merge
2. The Step by Step Mail Merge Wizard
3. Creating a Data Source
4. Selecting Recipients
5. Inserting and Deleting Merge Fields
6. Error Checking
7. Detaching the Data Source
8. Finishing a Mail Merge
Sharing Documents
1. Simplified Document Sharing in Word 2016
2. Inserting Comments
3. Sharing by Email
4. Presenting Online
5. Posting to a Blog
6. Saving as a PDF or XPS File
7. Saving as a Different File Type
Creating a Table of Contents
1. Creating a Table of Contents
2. Customizing a Table of Contents
3. Updating a Table of Contents
4. Deleting a Table of Contents
Creating an Index
1. Creating an Index
2. Customizing an Index
3. Updating an Index
Citations and Bibliography
1. Select a Citation Style
2. Insert a Citation
3. Insert a Citation Placeholder
4. Managing Sources
5. Editing Sources
6. Creating a Bibliography
Captions
1. Inserting Captions
2. Inserting a Table of Figures
3. Inserting a Cross-Reference
4. Updating a Table of Figures
Creating Formats
1. Displaying the Developer Tab
2. Creating a Form
3. Inserting Controls
4. Repeating Section Content Control
5. Adding Instructional Text
6. Protecting a Form
Making Macros
1. Recording Macros
2. Running and Deleting Recorded Macros
3. Assigning Macros
Word Options
1. Setting Word Options
2. Setting Document Properties
3. Checking Accessibility
Document Security
1. Applying Password Protection to a Document
2. Removing Password Protection from a Document
3. Restrict Editing within a Document
4. Removing Editing Restrictions from a Document
Introduction to WordPress
1. Introduction to WordPress
2. WordPress.com vs. WordPress.org
3. Installing and Running WordPress
4. Logging into the Admin Area
5. The WordPress Interface and Dashboard
6. The WordPress Toolbar
Creating Posts
1. Posts vs. Pages
2. Creating a New Post
3. The Formatting Toolbar
4. Copying and Pasting Content
5. Text Formatting
6. Creating Links
7. Adding Images
8. Using Featured Images
9. Adding Images from a URL
10. Adding an Image Gallery
11. Saving a Draft
12. Using Revisions to Compare and Restore
13. Publishing Posts
14. Using Categories and Tags
15. Using the Read More Tag and Excerpts
16. Managing Comments
Creating Pages
1. Creating Basic Pages
2. Page Hierarchy
3. Using Page Templates
4. Creating a Static Front (Home) Page
5. Managing Pages and Posts
6. Quick Edit
7. Bulk Edit
Managing Media
1. Managing Images, Video and Other Media
2. Bulk Deleting Media
3. Managing Media Settings
4. Editing Images in the Media Library
5. Editing Video Information in the Media Library
6. Editing Audio File Information in the Media Library
7. Editing Other File Information in the Media Library
8. Inserting a Video into a Page or Post
9. Inserting a Video Playlist into a Page or Post
10. Inserting an Audio File into a Page or Post
11. Inserting an Audio Playlist into a Page or Post
Creating Portfolios
1.Creating a Portfolio
2. Portfolio Categories
3. Managing Portfolios
WordPress Plugins
1. Installing Plugins
2. Installing a Form Plugin
3. Installing a Social Media Button Plugin
4. Installing an E-Commerce Plugin
Themes and Customizing Site Appearance
1. Selecting and Changing Themes
2. The Theme Customizer
3. Custom Header Images
4. Custom Menus
5. Using Widgets
6. Installing Themes from the WordPress Theme Directory
7. Installing Custom Themes
8. Customizing WordPress for Mobile
Managing Your User Profile
1. Managing Your User Profile
2. Creating a Gravatar Profile
3. Adding and Managing Users
4. General Settings
5. Writing Settings
6. Reading Settings
7. Discussion Settings
8. Media Settings
9. Importing and Exporting Content
Attracting and Keeping an Audience
1. Creating Permalinks
2. Search Engine Optimization
3. Moderating Comments
Maintenance and Security
1. How WordPress Works
2. Manually Installing Themes and Plugins
3. Updating WordPress
4. Security and Backup Plugins