Microsoft Access 2016 Training Manual Classroom in a Book
Title | Microsoft Access 2016 Training Manual Classroom in a Book PDF eBook |
Author | TeachUcomp |
Publisher | TeachUcomp Inc. |
Pages | 174 |
Release | 2015-10-27 |
Genre | Computers |
ISBN |
Complete classroom training manuals for Microsoft Access 2016. Three manuals (Introductory, Intermediate, Advanced) in one book. 174 pages and 105 individual topics. Includes practice exercises and keyboard shortcuts. You will learn all about relational databases, advanced queries, creating forms, reporting, macros and much more. Topics Covered: 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
Microsoft Project 2016 Training Manual Classroom in a Book
Title | Microsoft Project 2016 Training Manual Classroom in a Book PDF eBook |
Author | TeachUcomp |
Publisher | TeachUcomp Inc. |
Pages | 185 |
Release | 2015-10-27 |
Genre | Computers |
ISBN |
Complete classroom training manuals for Microsoft Project 2016. Two manuals (Introductory and Advanced) in one book. 185 pages and 101 individual topics. Includes practice exercises and keyboard shortcuts. You will learn introductory through advanced concepts including assigning and managing tasks and resources, tracking project tasks, developing dynamic reports and much more. Topics Covered: 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
Microsoft OneNote 2016 Training Manual Classroom in a Book
Title | Microsoft OneNote 2016 Training Manual Classroom in a Book PDF eBook |
Author | TeachUcomp |
Publisher | TeachUcomp Inc. |
Pages | 122 |
Release | 2015-10-27 |
Genre | Computers |
ISBN |
Complete classroom training manual for Microsoft OneNote 2019. 122 pages and 67 individual topics. Includes practice exercises and keyboard shortcuts. You will learn note creation, formatting, working with Microsoft Outlook, using tables, sharing and collaboration, formatting pages, and much more. Topics Covered: 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
Microsoft PowerPoint 2016 Training Manual Classroom in a Book
Title | Microsoft PowerPoint 2016 Training Manual Classroom in a Book PDF eBook |
Author | TeachUcomp |
Publisher | TeachUcomp Inc. |
Pages | 161 |
Release | 2015-10-27 |
Genre | Computers |
ISBN |
Complete classroom training manuals for Microsoft PowerPoint 2016. Two manuals (Introductory and Advanced) in one book. 161 pages and 82 individual topics. Includes practice exercises and keyboard shortcuts. You will learn introductory through advanced concepts – from creating simple yet elegant presentations to adding animation and video and customization. Topics Covered: 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
Microsoft Access 2019 and 365 Training Manual Classroom in a Book
Title | Microsoft Access 2019 and 365 Training Manual Classroom in a Book PDF eBook |
Author | TeachUcomp |
Publisher | TeachUcomp Inc. |
Pages | 189 |
Release | 2021-08-11 |
Genre | Computers |
ISBN |
Complete classroom training manual for Microsoft Access 2019 and 365. Includes 189 pages and 108 individual topics. Includes practice exercises and keyboard shortcuts. You will learn about creating relational databases from scratch, using fields, field properties, joining and indexing tables, queries, forms, controls, subforms, reports, charting, macros, switchboard and navigation forms, and much more. Topics Covered: 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 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. SQL View 7. Sorting Query Results 8. Hiding Fields in a Result Set 9. Using Comparison Operators 10. Using AND and OR Conditions Advanced Queries 1. Using the Between… And Condition 2. Using Wildcard Characters in Queries 3. Creating a Calculated Field 4. Creating Top Value Queries 5. Aggregate 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. Removing Duplicate Records from a Table 8. The Find Unmatched Query Creating Forms 1. Forms Overview 2. The Form Wizard 3. Creating Forms 4. Using Forms 5. Form and Report Layout View 6. Form and Report Design View 7. Viewing the Ruler and Grid 8. The Snap to Grid Feature 9. Creating a Form in Design View 10. Modifying Form Sections 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 List 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 or Subreport Control Reports 1. Using the Report Wizard 2. Creating 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 2. Insert a Modern Chart Macros 1. Creating a Standalone Macro 2. Assigning Macros to a Command Button 3. Assigning Macros to Events 4. Using Program Flow with Macros 5. Creating Autoexec Macros 6. Creating Data Macros 7. Editing Named Data Macros 8. 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
Microsoft Word 2019 Training Manual Classroom in a Book
Title | Microsoft Word 2019 Training Manual Classroom in a Book PDF eBook |
Author | TeachUcomp |
Publisher | TeachUcomp Inc. |
Pages | 369 |
Release | 2020-08-15 |
Genre | Computers |
ISBN |
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
Microsoft Teams 2020 Training Manual Classroom in a Book
Title | Microsoft Teams 2020 Training Manual Classroom in a Book PDF eBook |
Author | TeachUcomp |
Publisher | TeachUcomp Inc. |
Pages | 89 |
Release | 2020-10-19 |
Genre | Computers |
ISBN |
Complete classroom training manual for Microsoft Teams 2020. 101 pages and 51 individual topics. Includes practice exercises and keyboard shortcuts. You will learn how to create and manage teams, channels, and users, setup and attend meetings, make calls, create live events, and much more. Topics Covered: Getting Acquainted with Teams 1. The Teams Environment 2. Viewing and Managing the Activity Feed 3. Customizing Settings 4. Setting Your Status and Creating Status Messages Setting Up Teams and Channels 1. Overview of Teams and Channels 2. Creating Teams and Adding Members 3. Ordering, Editing, Hiding, and Deleting Teams 4. Managing Teams and Members 5. Creating Channels 6. Renaming, Deleting, Hiding, Showing, and Pinning Channels 7. Sending Email to an Entire Channel Posts and Messages 1. Creating and Formatting Posts 2. Making an Announcement 3. Getting Attention with @Mentions 4. Posting to Multiple Channels at Once 5. Using Tags 6. Editing and Deleting Posts and Messages 7. Reading and Saving Posts and Messages File Sharing and Collaboration 1. Uploading and Sharing Files 2. Syncing SharePoint and Teams Files 3. Collaborating on Files in Channels Chats and Calls 1. Starting and Pinning Chats 2. Filtering, Hiding, and Muting Chats 3. Creating Contacts and Contact Groups 4. Adding People to Your Speed Dial List 5. Making Video and Audio Calls 6. Answering Calls and Using the Meeting Controls Toolbar 7. Configuring Call Answer Rules and Voicemail 8. Checking Call History and Voicemail 9. Setting Up a Delegate to Take Your Calls Meetings 1. Scheduling a Meeting and Inviting Attendees 2. Using Meet Now for Instant Meetings 3. Meeting Options 4. Managing and Replying to Meetings 5. Starting and Joining a Meeting 6. Changing the Video Background in a Meeting 7. Sharing Your Screen in a Meeting 8. Sharing PowerPoint Slides in a Meeting 9. Recording a Meeting 10. Raising Hands, Spotlighting, Muting, and Removing Participants 11. Taking Notes in Meeting 12. Using Live Captions in Meetings 13. Ending a Meeting for Everyone in Attendance Live Events 1. Scheduling a Live Event 2. Producing a Live Event 3. Moderating a Live Event 4. Attending a Live Event Exploring Apps and Tools 1. Using Apps, Bots, and Connectors 2. Turing a File into a Tab 3. Using the Wiki Tab for Shared Information 4. Using the Command Box