Complete classroom training manual for Microsoft Outlook on the Web. 143 pages and 94 individual topics. Includes practice exercises and keyboard shortcuts. You will learn all about email, tasks, effective use of the calendar, and much more. Topics Covered: 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

Complete classroom training manual for Microsoft Outlook 2019. 177 pages and 101 individual topics. Includes practice exercises and keyboard shortcuts. You will learn how to create and manage contacts, use advanced email techniques, manage and use the calendar, use tasks, create groups, use the journal, and much more. Topics Covered: CHAPTER 1- GETTING ACQUAINTED WITH OUTLOOK 1.1- The Outlook Environment 1.2- The Title Bar 1.3- The Ribbon 1.4- The Quick Access Toolbar 1.5- Touch Mode 1.6- The Navigation Bar, Folder Pane, Reading Pane, and To-Do Bar CHAPTER 2- MAKING CONTACTS 2.1- The Contacts Folder 2.2- Customizing the Contacts Folder View 2.3- Creating Contacts 2.4- Basic Contact Management 2.5- Printing Contacts 2.6- Creating Contact Groups 2.7- Categorizing Contacts 2.8- Searching for Contacts 2.9- Calling Contacts 2.10- Mapping a Contact’s Address CHAPTER 3- EMAIL 3.1- Using the Inbox 3.2- Changing the Inbox View 3.3- Message Flags 3.4- Searching for Messages 3.5- Creating, Addressing, and Sending Messages 3.6- Checking Message Spelling 3.7- Setting Message Options 3.8- Formatting Messages 3.9- Using Signatures 3.10- Replying to Messages 3.11- Forwarding Messages 3.12- Sending Attachments 3.13- Opening Attachments 3.14- Ignoring Conversations CHAPTER 4- THE SENT ITEMS FOLDER 4.1- The Sent Items Folder 4.2- Resending Messages 4.3- Recalling Messages CHAPTER 5- The Outbox Folder 5.1- Using the Outbox 5.2- Using the Drafts Folder CHAPTER 6- USING THE CALENDAR 6.1- The Calendar Window 6.2- Switching the Calendar View 6.3- Navigating the Calendar 6.4- Appointments, Meetings, and Events 6.5- Manipulating Calendar Objects 6.6- Setting an Appointment 6.7- Scheduling a Meeting 6.8- Checking Meeting Attendance Status 6.9- Responding to Meeting Requests 6.10- Scheduling an Event 6.11- Setting Recurrence 6.12- Printing the Calendar 6.13- Teams Meetings in Outlook 6.14- Meeting Notes CHAPTER 7- Tasks 7.1- Using Tasks 7.2- Printing Tasks 7.3- Creating a Task 7.4- Setting Task Recurrence 7.5- Creating a Task Request 7.6- Responding to Task Requests 7.7- Sending Status Reports 7.8- Deleting Tasks CHAPTER 8- Deleted Items 8.1- The Deleted Items Folder 8.2- Permanently Deleting Items 8.3- Recovering Deleted Items 8.4- Recovering and Purging Permanently Deleted Items CHAPTER 9- GROUPS 9.1- Accessing Groups 9.2- Creating a New Group 9.3- Adding Members to Groups and Inviting Others 9.4- Contributing to Groups 9.5- Managing Files in Groups 9.6- Accessing the Group Calendar and Notebook 9.7- Following and Stop Following Groups 9.8- Leaving Groups 9.9- Editing, Managing and Deleting Groups CHAPTER 10- The Journal Folder 10.1- The Journal Folder 10.2- Switching the Journal View 10.3- Recording Journal Items 10.4- Opening Journal Entries and Documents 10.5- Deleting Journal Items CHAPTER 11- Public Folders 11.1- Creating Public Folders 11.2- Setting Permissions 11.3- Folder Rules 11.4- Copying Public Folders CHAPTER 12- Personal & Private Folders 12.1- Creating a Personal Folder 12.2- Setting AutoArchiving for Folders 12.3- Creating Private Folders 12.4- Creating Search Folders 12.5- One-Click Archiving CHAPTER 13- Notes 13.1- Creating and Using Notes CHAPTER 14- Advanced Mailbox Options 14.1- Creating Mailbox Rules 14.2- Creating Custom Mailbox Views 14.3- Handling Junk Mail 14.4- Color Categorizing 14.5- Advanced Find 14.6- Mailbox Cleanup CHAPTER 15- OUTLOOK OPTIONS 15.1- Using Shortcuts 15.2- Adding Additional Profiles 15.3- Adding Accounts 15.4- Outlook Options 15.5- Using Outlook Help CHAPTER 16- DELEGATES 16.1- Creating a Delegate 16.2- Acting as a Delegate 16.3- Deleting Delegates CHAPTER 17- SECURITY 17.1- Types of Email Encryption in Outlook 17.2- Sending Encrypted Email

Complete classroom training manuals for Crystal Reports. Two manuals (Introductory and Advanced) in one book. 226 pages and 118 individual topics. Includes practice exercises and keyboard shortcuts. You will learn all about how to establish data connections, create complex and detailed reports, advanced charting techniques and much more. Topics Covered: 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

Complete classroom training manual for Microsoft Word 2019. 369 pages and 210 individual topics. Includes practice exercises and keyboard shortcuts. You will learn document creation, editing, proofing, formatting, styles, themes, tables, mailings, and much more. Topics Covered: CHAPTER 1- Getting Acquainted with Word 1.1- About Word 1.2- The Word Environment 1.3- The Title Bar 1.4- The Ribbon 1.5- The “File” Tab and Backstage View 1.6- The Quick Access Toolbar 1.7- Touch Mode 1.8- The Ruler 1.9- The Scroll Bars 1.10- The Document View Buttons 1.11- The Zoom Slider 1.12- The Status Bar 1.13- The Mini Toolbar 1.14- Keyboard Shortcuts CHAPTER 2- Creating Basic Documents 2.1- Opening Documents 2.2- Closing Documents 2.3- Creating New Documents 2.4- Saving Documents 2.5- Recovering Unsaved Documents 2.6- Entering Text 2.7- Moving through Text 2.8- Selecting Text 2.9- Non-Printing Characters 2.10- Working with Word File Formats 2.11- AutoSave Online Documents CHAPTER 3- Document views 3.1- Changing Document Views 3.2- Showing and Hiding the Ruler 3.3- Showing and Hiding Gridlines 3.4- Using the Navigation Pane 3.5- Zooming the Document 3.6- Opening a Copy of a Document in a New Window 3.7- Arranging Open Document Windows 3.8- Split Window 3.9- Comparing Open Documents 3.10- Switching Open Documents 3.11- Switching to Full Screen View CHAPTER 4- Basic Editing Skills 4.1- Deleting Text 4.2- Cutting, Copying, and Pasting 4.3- Undoing and Redoing Actions 4.4- Finding and Replacing Text 4.5- Selecting Text and Objects CHAPTER 5- BASIC PROOFING Tools 5.1- The Spelling and Grammar Tool 5.2- Setting Default Proofing Options 5.3- Using the Thesaurus 5.4- Finding the Word Count 5.5- Translating Documents 5.6- Read Aloud in Word CHAPTER 6- FONT Formatting 6.1- Formatting Fonts 6.2- The Font Dialog Box 6.3- The Format Painter 6.4- Applying Styles to Text 6.5- Removing Styles from Text CHAPTER 7- Formatting Paragraphs 7.1- Aligning Paragraphs 7.2- Indenting Paragraphs 7.3- Line Spacing and Paragraph Spacing CHAPTER 8- Document Layout 8.1- About Documents and Sections 8.2- Setting Page and Section Breaks 8.3- Creating Columns in a Document 8.4- Creating Column Breaks 8.5- Using Headers and Footers 8.6- The Page Setup Dialog Box 8.7- Setting Margins 8.8- Paper Settings 8.9- Layout Settings 8.10- Adding Line Numbers 8.11- Hyphenation Settings CHAPTER 9- Using Templates 9.1- Using Templates 9.2- Creating Personal Templates CHAPTER 10- Printing Documents 10.1- Previewing and Printing Documents CHAPTER 11- Helping Yourself 11.1- The Tell Me Bar and Microsoft Search 11.2- Using Word Help 11.3- Smart Lookup CHAPTER 12- Working with Tabs 12.1- Using Tab Stops 12.2- Using the Tabs Dialog Box CHAPTER 13- Pictures and Media 13.1- Inserting Online Pictures 13.2- Inserting Your Own Pictures 13.3- Using Picture Tools 13.4- Using the Format Picture Task Pane 13.5- Fill & Line Settings 13.6- Effects Settings 13.7- Alt Text 13.8- Picture Settings 13.9- Inserting Screenshots 13.10- Inserting Screen Clippings 13.11- Inserting Online Video 13.12- Inserting Icons 13.13- Inserting 3D Models 13.14- Formatting 3D Models CHAPTER 14- DRAWING OBJECTS 14.1- Inserting Shapes 14.2- Inserting WordArt 14.3- Inserting Text Boxes 14.4- Formatting Shapes 14.5- The Format Shape Task Pane 14.6- Inserting SmartArt 14.7- Design and Format SmartArt 14.8- Inserting Charts CHAPTER 15- USING BUILDING BLOCKS 15.1- Creating Building Blocks 15.2- Using Building Blocks CHAPTER 16- Styles 16.1- About Styles 16.2- Applying Styles 16.3- Showing Headings in the Navigation Pane 16.4- The Styles Task Pane 16.5- Clearing Styles from Text 16.6- Creating a New Style 16.7- Modifying an Existing Style 16.8- Selecting All Instances of a Style in a Document 16.9- Renaming Styles 16.10- Deleting Custom Styles 16.11- Using the Style Inspector Pane 16.12- Using the Reveal Formatting Pane CHAPTER 17- Themes and style sets 17.1- Applying a Theme 17.2- Applying a Style Set 17.3- Applying and Customizing Theme Colors 17.4- Applying and Customizing Theme Fonts 17.5- Selecting Theme Effects CHAPTER 18- PAGE BACKGROUNDS 18.1- Applying Watermarks 18.2- Creating Custom Watermarks 18.3- Removing Watermarks 18.4- Selecting a Page Background Color or Fill Effect 18.5- Applying Page Borders CHAPTER 19- BULLETS AND NUMBERING 19.1- Applying Bullets and Numbering 19.2- Formatting Bullets and Numbering 19.3- Applying a Multilevel List 19.4- Modifying a Multilevel List Style CHAPTER 20- Tables 20.1- Using Tables 20.2- Creating Tables 20.3- Selecting Table Objects 20.4- Inserting and Deleting Columns and Rows 20.5- Deleting Cells and Tables 20.6- Merging and Splitting Cells 20.7- Adjusting Cell Size 20.8- Aligning Text in Table Cells 20.9- Converting a Table into Text 20.10- Sorting Tables 20.11- Formatting Tables 20.12- Inserting Quick Tables CHAPTER 21- Table formulas 21.1- Inserting Table Formulas 21.2- Recalculating Word Formulas 21.3- Viewing Formulas Vs. Formula Results 21.4- Inserting a Microsoft Excel Worksheet CHAPTER 22- Inserting page elements 22.1- Inserting Drop Caps 22.2- Inserting Equations 22.3- Inserting Ink Equations 22.4- Inserting Symbols 22.5- Inserting Bookmarks 22.6- Inserting Hyperlinks CHAPTER 23- Outlines 23.1- Using Outline View 23.2- Promoting and Demoting Outline Text 23.3- Moving Selected Outline Text 23.4- Collapsing and Expanding Outline Text CHAPTER 24- MAILINGS 24.1- Mail Merge 24.2- The Step by Step Mail Merge Wizard 24.3- Creating a Data Source 24.4- Selecting Recipients 24.5- Inserting and Deleting Merge Fields 24.6- Error Checking 24.7- Detaching the Data Source 24.8- Finishing a Mail Merge 24.9- Mail Merge Rules 24.10- The Ask Mail Merge Rule 24.11- The Fill-in Mail Merge Rule 24.12- The If…Then…Else Mail Merge Rule 24.13- The Merge Record # Mail Merge Rule 24.14- The Merge Sequence # Mail Merge Rule 24.15- The Next Record Mail Merge Rule 24.16- The Next Record If Mail Merge Rule 24.17- The Set Bookmark Mail Merge Rule 24.18- The Skip Record If Mail Merge Rule 24.19- Deleting Mail Merge Rules in Word CHAPTER 25- SHARING DOCUMENTS 25.1- Sharing Documents in Word Using Co-authoring 25.2- Inserting Comments 25.3- Sharing by Email 25.4- Presenting Online 25.5- Posting to a Blog 25.6- Saving as a PDF or XPS File 25.7- Saving as a Different File Type CHAPTER 26- CREATING A TABLE OF CONTENTS 26.1- Creating a Table of Contents 26.2- Customizing a Table of Contents 26.3- Updating a Table of Contents 26.4- Deleting a Table of Contents CHAPTER 27- CREATING AN INDEX 27.1- Creating an Index 27.2- Customizing an Index 27.3- Updating an Index CHAPTER 28- CITATIONS AND BIBLIOGRAPHY 28.1- Select a Citation Style 28.2- Insert a Citation 28.3- Insert a Citation Placeholder 28.4- Inserting Citations Using the Researcher Pane 28.5- Managing Sources 28.6- Editing Sources 28.7- Creating a Bibliography CHAPTER 29- CAPTIONS 29.1- Inserting Captions 29.2- Inserting a Table of Figures 29.3- Inserting a Cross-reference 29.4- Updating a Table of Figures CHAPTER 30- CREATING FORMS 30.1- Displaying the Developer Tab 30.2- Creating a Form 30.3- Inserting Controls 30.4- Repeating Section Content Control 30.5- Adding Instructional Text 30.6- Protecting a Form CHAPTER 31- MAKING MACROS 31.1- Recording Macros 31.2- Running and Deleting Recorded Macros 31.3- Assigning Macros CHAPTER 32- WORD OPTIONS 32.1- Setting Word Options 32.2- Setting Document Properties 32.3- Checking Accessibility CHAPTER 33- DOCUMENT SECURITY 33.1- Applying Password Protection to a Document 33.2- Removing Password Protection from a Document 33.3- Restrict Editing within a Document 33.4- Removing Editing Restrictions from a Document

Complete classroom training manual for Excel for Microsoft 365. 345 pages and 211 individual topics. Includes practice exercises and keyboard shortcuts. You will learn how to create spreadsheets and advanced formulas, format and manipulate spreadsheet layout, sharing and auditing workbooks, create charts, maps, macros, and much more. Topics Covered: 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 Mode 14. Working With Excel File Formats 15. AutoSave Online Workbooks 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. Microsoft Search in Excel 3. Smart Lookup 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 Links Sharing Workbooks 1. About Co-authoring and Sharing Workbooks 2. Co-authoring Workbooks 3. Adding Shared Workbook Buttons in Excel 4. Traditional Workbook Sharing 5. Highlighting Changes 6. Reviewing Changes 7. Using Comments and Notes 8. 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 3. Applying Subtotals 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 Table-Related Functions 1. The Hlookup and Vlookup Functions 2. Using the IF, AND, and OR Functions 3. The IFS Function 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. Enabling Legacy Data Connections 4. Relating Tables in a Data Model 5. 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 3D Maps 1. Enabling 3D Maps 2. Creating a New 3D Maps Tour 3. Editing a 3D Maps Tour 4. Managing Layers in a 3D Maps Tour 5. Filtering Layers 6. Setting Layer Options 7. Managing Scenes 8. Custom 3D Maps 9. Custom Regions 10. World Map Options 11. Inserting 3D Map Objects 12. Previewing a Scene 13. Playing a 3D Maps Tour 14. Creating a Video of a 3D Maps Tour 15. 3D Maps Options 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

Complete classroom training manual for Word for Microsoft 365. Includes 369 pages and 210 individual topics. Includes practice exercises and keyboard shortcuts. You will learn document creation, editing, proofing, formatting, styles, themes, tables, mailings, and much more. Topics Covered: CHAPTER 1- Getting Acquainted with Word 1.1- About Word 1.2- The Word Environment 1.3- The Title Bar 1.4- The Ribbon 1.5- The “File” Tab and Backstage View 1.6- The Quick Access Toolbar 1.7- Touch Mode 1.8- The Ruler 1.9- The Scroll Bars 1.10- The Document View Buttons 1.11- The Zoom Slider 1.12- The Status Bar 1.13- The Mini Toolbar 1.14- Keyboard Shortcuts CHAPTER 2- Creating Basic Documents 2.1- Opening Documents 2.2- Closing Documents 2.3- Creating New Documents 2.4- Saving Documents 2.5- Recovering Unsaved Documents 2.6- Entering Text 2.7- Moving through Text 2.8- Selecting Text 2.9- Non-Printing Characters 2.10- Working with Word File Formats 2.11- AutoSave Online Documents CHAPTER 3- Document views 3.1- Changing Document Views 3.2- Showing and Hiding the Ruler 3.3- Showing and Hiding Gridlines 3.4- Using the Navigation Pane 3.5- Zooming the Document 3.6- Opening a Copy of a Document in a New Window 3.7- Arranging Open Document Windows 3.8- Split Window 3.9- Comparing Open Documents 3.10- Switching Open Documents 3.11- Switching to Full Screen Mode CHAPTER 4- Basic Editing Skills 4.1- Deleting Text 4.2- Cutting, Copying, and Pasting 4.3- Undoing and Redoing Actions 4.4- Finding and Replacing Text 4.5- Selecting Text and Objects CHAPTER 5- BASIC PROOFING Tools 5.1- The Spelling and Grammar Tool 5.2- Setting Default Proofing Options 5.3- Using the Thesaurus 5.4- Finding the Word Count 5.5- Translating Documents 5.6- Read Aloud in Word CHAPTER 6- FONT Formatting 6.1- Formatting Fonts 6.2- The Font Dialog Box 6.3- The Format Painter 6.4- Applying Styles to Text 6.5- Removing Styles from Text CHAPTER 7- Formatting Paragraphs 7.1- Aligning Paragraphs 7.2- Indenting Paragraphs 7.3- Line Spacing and Paragraph Spacing CHAPTER 8- Document Layout 8.1- About Documents and Sections 8.2- Setting Page and Section Breaks 8.3- Creating Columns in a Document 8.4- Creating Column Breaks 8.5- Using Headers and Footers 8.6- The Page Setup Dialog Box 8.7- Setting Margins 8.8- Paper Settings 8.9- Layout Settings 8.10- Adding Line Numbers 8.11- Hyphenation Settings CHAPTER 9- Using Templates 9.1- Using Templates 9.2- Creating Personal Templates CHAPTER 10- Printing Documents 10.1- Previewing and Printing Documents CHAPTER 11- Helping Yourself 11.1- Microsoft Search in Word 11.2- Using Word Help 11.3- Smart Lookup CHAPTER 12- Working with Tabs 12.1- Using Tab Stops 12.2- Using the Tabs Dialog Box CHAPTER 13- Pictures and Media 13.1- Inserting Online Pictures and Stock Images 13.2- Inserting Your Own Pictures 13.3- Using Picture Tools 13.4- Using the Format Picture Task Pane 13.5- Fill & Line Settings 13.6- Effects Settings 13.7- Alt Text 13.8- Picture Settings 13.9- Inserting Screenshots 13.10- Inserting Screen Clippings 13.11- Inserting Online Video 13.12- Inserting Icons 13.13- Inserting 3D Models 13.14- Formatting 3D Models CHAPTER 14- DRAWING OBJECTS 14.1- Inserting Shapes 14.2- Inserting WordArt 14.3- Inserting Text Boxes 14.4- Formatting Shapes 14.5- The Format Shape Task Pane 14.6- Inserting SmartArt 14.7- Design and Format SmartArt 14.8- Inserting Charts CHAPTER 15- USING BUILDING BLOCKS 15.1- Creating Building Blocks 15.2- Using Building Blocks CHAPTER 16- Styles 16.1- About Styles 16.2- Applying Styles 16.3- Showing Headings in the Navigation Pane 16.4- The Styles Task Pane 16.5- Clearing Styles from Text 16.6- Creating a New Style 16.7- Modifying an Existing Style 16.8- Selecting All Instances of a Style in a Document 16.9- Renaming Styles 16.10- Deleting Custom Styles 16.11- Using the Style Inspector Pane 16.12- Using the Reveal Formatting Pane CHAPTER 17- Themes and style sets 17.1- Applying a Theme 17.2- Applying a Style Set 17.3- Applying and Customizing Theme Colors 17.4- Applying and Customizing Theme Fonts 17.5- Selecting Theme Effects CHAPTER 18- PAGE BACKGROUNDS 18.1- Applying Watermarks 18.2- Creating Custom Watermarks 18.3- Removing Watermarks 18.4- Selecting a Page Background Color or Fill Effect 18.5- Applying Page Borders CHAPTER 19- BULLETS AND NUMBERING 19.1- Applying Bullets and Numbering 19.2- Formatting Bullets and Numbering 19.3- Applying a Multilevel List 19.4- Modifying a Multilevel List Style CHAPTER 20- Tables 20.1- Using Tables 20.2- Creating Tables 20.3- Selecting Table Objects 20.4- Inserting and Deleting Columns and Rows 20.5- Deleting Cells and Tables 20.6- Merging and Splitting Cells 20.7- Adjusting Cell Size 20.8- Aligning Text in Table Cells 20.9- Converting a Table into Text 20.10- Sorting Tables 20.11- Formatting Tables 20.12- Inserting Quick Tables CHAPTER 21- Table formulas 21.1- Inserting Table Formulas 21.2- Recalculating Word Formulas 21.3- Viewing Formulas Vs. Formula Results 21.4- Inserting a Microsoft Excel Worksheet CHAPTER 22- Inserting page elements 22.1- Inserting Drop Caps 22.2- Inserting Equations 22.3- Inserting Ink Equations 22.4- Inserting Symbols 22.5- Inserting Bookmarks 22.6- Inserting Hyperlinks CHAPTER 23- Outlines 23.1- Using Outline View 23.2- Promoting and Demoting Outline Text 23.3- Moving Selected Outline Text 23.4- Collapsing and Expanding Outline Text CHAPTER 24- MAILINGS 24.1- Mail Merge 24.2- The Step by Step Mail Merge Wizard 24.3- Creating a Data Source 24.4- Selecting Recipients 24.5- Inserting and Deleting Merge Fields 24.6- Error Checking 24.7- Detaching the Data Source 24.8- Finishing a Mail Merge 24.9- Mail Merge Rules 24.10- The Ask Mail Merge Rule 24.11- The Fill-in Mail Merge Rule 24.12- The If…Then…Else Mail Merge Rule 24.13- The Merge Record # Mail Merge Rule 24.14- The Merge Sequence # Mail Merge Rule 24.15- The Next Record Mail Merge Rule 24.16- The Next Record If Mail Merge Rule 24.17- The Set Bookmark Mail Merge Rule 24.18- The Skip Record If Mail Merge Rule 24.19- Deleting Mail Merge Rules in Word CHAPTER 25- SHARING DOCUMENTS 25.1- Sharing Documents in Word Using Co-authoring 25.2- Inserting Comments 25.3- Sharing by Email 25.4- Posting to a Blog 25.5- Saving as a PDF or XPS File 25.6- Saving as a Different File Type CHAPTER 26- CREATING A TABLE OF CONTENTS 26.1- Creating a Table of Contents 26.2- Customizing a Table of Contents 26.3- Updating a Table of Contents 26.4- Deleting a Table of Contents CHAPTER 27- CREATING AN INDEX 27.1- Creating an Index 27.2- Customizing an Index 27.3- Updating an Index CHAPTER 28- CITATIONS AND BIBLIOGRAPHY 28.1- Select a Citation Style 28.2- Insert a Citation 28.3- Insert a Citation Placeholder 28.4- Inserting Citations Using the Researcher Pane 28.5- Managing Sources 28.6- Editing Sources 28.7- Creating a Bibliography CHAPTER 29- CAPTIONS 29.1- Inserting Captions 29.2- Inserting a Table of Figures 29.3- Inserting a Cross-reference 29.4- Updating a Table of Figures CHAPTER 30- CREATING FORMS 30.1- Displaying the Developer Tab 30.2- Creating a Form 30.3- Inserting Controls 30.4- Repeating Section Content Control 30.5- Adding Instructional Text 30.6- Protecting a Form CHAPTER 31- MAKING MACROS 31.1- Recording Macros 31.2- Running and Deleting Recorded Macros 31.3- Assigning Macros CHAPTER 32- WORD OPTIONS 32.1- Setting Word Options 32.2- Setting Document Properties 32.3- Checking Accessibility CHAPTER 33- DOCUMENT SECURITY 33.1- Applying Password Protection to a Document 33.2- Removing Password Protection from a Document 33.3- Restrict Editing within a Document 33.4- Removing Editing Restrictions from a Document

Complete classroom training manual for Adobe Acrobat DC. 315 pages and 163 individual topics. Includes practice exercises and keyboard shortcuts. Professionally developed and sold all over the world, these materials are provided in full-color PDF format with not-for-profit reprinting rights and offer clear, concise, and easy-to-use instructions. You will learn PDF creation, advanced PDF settings, exporting and rearranging PDFs, collaboration, creating forms, document security, and much more. Topics Covered: 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