Microsoft Windows 11 Training Manual Classroom in a Book


Book Description

Complete classroom training manual for Microsoft Windows 11. 308 pages and 183 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 File Explorer, how to adjust system and device settings, desktop management, creating documents, Using Microsoft Edge, and much more. Topics Covered: Windows Basics 1. About Windows 11 2. Sign-in to Windows 11 with a Microsoft User Account 3. How to Use the Mouse in Windows 11 4. How to Use Touch Gestures in Windows 11 5. The Windows 11 Desktop 6. How to Use the Start Button in Windows 11 7. How to Use the Start Menu in Windows 11 8. How to Customize the Start Menu in Windows 11 9. How to Search in Windows 11 10. How to Use Universal App Windows in Windows 11 11. How to Use Snap Layouts in Windows 11 12. How to Resize a Desktop Window in Windows 11 13. How to Scroll a Window in Windows 11 14. How to Use Multiple Desktops in Windows 11 15. How to Shut Down Windows 11 16. How to Use the Microsoft Store in Windows 11 17. Sign in Options in Windows 11 18. How to Change Your PIN in Windows 11 19. How to Use Widgets in Windows 11 File Explorer 1. File Explorer in Windows 11 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 11 14. Managing the Computer and Drives in Windows 11 15. Quick Access in Windows 11 16. OneDrive Folders in File Explorer 17. Zip Folders in File Explorer 18. Unzip Files in File Explorer Windows 11 Settings 1. Accessing Settings in Windows 11 System Settings 1. Accessing the System Settings 2. Display Settings in Windows 11 3. Sound Settings in Windows 11 4. Notifications Settings in Windows 11 5. Focus Assist Settings in Windows 11 6. Power & Battery Settings in Windows 11 7. Storage Settings in Windows 11 8. Nearby Sharing Settings in Windows 11 9. Multitasking Settings in Windows 11 10. Activation Settings in Windows 11 11. Troubleshoot Settings in Windows 11 12. Recovery Settings in Windows 11 13. Projecting to This PC Settings in Windows 11 14. Remote Desktop Settings in Windows 11 15. Clipboard Settings in Windows 11 16. About Settings in Windows 11 Bluetooth & Devices Settings 1. Accessing the Bluetooth & Devices Settings 2. How to Enable Bluetooth in Windows 11 3. How to Add a Device in Windows 11 4. How to Manage Devices in Windows 11 5. How to Manage Printers & Scanners in Windows 11 6. Your Phone Settings in Windows 11 7. How to Manage Cameras in Windows 11 8. Mouse Settings in Windows 11 9. Touchpad Settings in Windows 11 10. Pen & Windows Ink Settings in Windows 11 11. AutoPlay Settings in Windows 11 12. USB Settings in Windows 11 Network & Internet Settings 1. Accessing the Network & Internet Settings 2. Wi Fi Settings in Windows 11 3. Ethernet Settings in Windows 11 4. VPN Settings in Windows 11 5. Mobile Hotspot Settings in Windows 11 6. Airplane Mode Settings in Windows 11 7. Proxy Settings in Windows 11 8. Dial up Settings in Windows 11 9. Advanced Network Settings in Windows 11 Personalization Settings 1. Accessing the Personalization Settings 2. Background Settings in Windows 11 3. Colors Settings in Windows 11 4. Themes Settings in Windows 11 5. Lock Screen Settings in Windows 11 6. Touch Keyboard Settings in Windows 11 7. Start Settings in Windows 11 8. Taskbar Settings in Windows 11 9. Fonts Settings in Windows 11 10. Device Usage Settings in Windows 11 Apps Settings 1. Accessing the Apps Settings 2. Apps & Features Settings in Windows 11 3. Default Apps Settings in Windows 11 4. Offline Maps Settings in Windows 11 5. Optional Features Settings in Windows 11 6. Apps for Websites Settings in Windows 11 7. Video Playback Settings in Windows 11 8. Startup Settings in Windows 11 Accounts Settings 1. Accessing the Accounts Settings 2. Your Microsoft Account Settings in Windows 11 3. Your Info Settings in Windows 11 4. Email & Accounts Settings in Windows 11 5. Sign in Options Settings in Windows 11 6. Family & Other Users Settings in Windows 11 7. Windows Backup Settings in Windows 11 8. Access Work or School Settings in Windows 11 Time & Language Settings 1. Accessing the Time & Language Settings 2. Date & Time Settings in Windows 11 3. Language & Region Settings in Windows 11 4. Typing Settings in Windows 11 5. Speech Settings in Windows 11 Gaming Settings 1. Accessing the Gaming Settings 2. Xbox Game Bar Settings in Windows 11 3. Captures Settings in Windows 11 4. Game Mode Settings in Windows 11 Accessibility Settings 1. Accessing the Accessibility Settings 2. Text Size Settings in Windows 11 3. Visual Effects Settings in Windows 11 4. Mouse Pointer and Touch Settings in Windows 11 5. Text Cursor Settings in Windows 11 6. Magnifier Settings in Windows 11 7. Color Filters Settings in Windows 11 8. Contrast Themes Settings in Windows 11 9. Narrator Settings in Windows 11 10. Audio Accessibility Settings in Windows 11 11. Captions Settings in Windows 11 12. Speech Accessibility Settings in Windows 11 13. Keyboard Accessibility Settings in Windows 11 14. Mouse Accessibility Settings in Windows 11 15. Eye Control Settings in Windows 11 Privacy & Security Settings 1. Accessing the Privacy & Security Settings 2. Windows Security Settings in Windows 11 3. Find My Device Settings in Windows 11 4. Device Encryption Settings in Windows 11 5. For Developers Settings in Windows 11 6. General Privacy Settings in Windows 11 7. Speech Privacy Settings in Windows 11 8. Inking & Typing Personalization Setting in Windows 11 9. Diagnostics & Feedback Settings in Window 11 10. Activity History Settings in Windows 11 11. Search Permissions Settings in Windows 11 12. Searching Windows Settings in Windows 11 13. App Permissions Settings in Windows 11 Windows Update Settings 1. Accessing the Windows Update Settings 2. Windows Update in Windows 11 3. Pause Windows Updates in Windows 11 4. Update History in Windows 11 5. Advanced Windows Update Options in Windows 11 6. Windows Insider Program Settings Windows Features 1. The Control Panel in Windows 11 2. File History in Windows 11 3. System Restore in Windows 11 4. Chat in Windows 11 5. Installing Amazon Appstore Mobile Apps in Windows 11 6. Installing and Uninstalling Software Desktop Management 1. The Recycle Bin in Windows 11 2. Creating Desktop Shortcuts in Windows 11 3. Pinning Apps to the Taskbar in Windows 11 4. Notification Center and Quick Settings in Windows 11 5. OneDrive Settings in Windows 11 Creating Documents in WordPad 1. Starting WordPad and Creating a New Document 2. Copying and Pasting Text in WordPad 3. Formatting Text in WordPad 4. Saving a Document in WordPad 5. Closing and Opening a Document in WordPad 6. Printing a Document in WordPad Drawing Pictures in Paint 1. Starting Paint and Creating a New Document 2. Drawing Shapes and Lines in Paint 3. Using Tools and Brushes in Paint 4. Selections in Paint 5. Saving a Picture in Paint 6. Closing and Opening a Picture in Paint Using Microsoft Edge 1. About the Internet and World Wide Web 2. Connecting to the Internet in Windows 11 3. The Microsoft Edge Interface in Windows 11 4. Viewing Web Pages in Microsoft Edge 5. Find Text in Web Pages in Microsoft Edge 6. Immersive Reader in Microsoft Edge 7. Add a Favorite to Microsoft Edge 8. Manage Favorites in Microsoft Edge 9. Manage Browser History in Microsoft Edge 10. Manage Downloads in Microsoft Edge 11. How to Manually Update Microsoft Edge 12. Sharing Web Pages in Microsoft Edge 13. Open a Window or InPrivate Window in Microsoft Edge 14. Zoom Web Pages in Microsoft Edge 15. Print Web Pages in Microsoft Edge 16. Settings in Microsoft Edge




Word for Microsoft 365 Training Manual Classroom in a Book


Book Description

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




Pulbisher for Microsoft 365 Training Manual Classroom in a Book


Book Description

Complete classroom training manual for Publisher for Microsoft 365. 128 pages and 64 individual topics. Includes practice exercises and keyboard shortcuts. You will learn how to create publications, format objects, customize schemes, create tables, perform mailings, prepare print files, and much more. Topics Covered: 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




Windows 11 from Beginner to Advanced


Book Description

Windows 11 is not that different from Windows 10, but it is different enough that guidance may be needed, even for experienced users. Windows 11 From Beginner to Advanced gives new and veteran users of Windows information they need to master Microsoft's Windows 11 operating system. The book is divided into beginner, intermediate and expert chapters, and covers all major topics of interest, including those that are new or different when compared to Microsoft's previous operating system, Windows 10. You learn how to master Windows 11, by personalizing the operating system to your needs and making sure that everything is set up efficiently and correctly. Topics discussed in the book include modifying the appearance of the Windows operating system, setting up a reliable backup solution that does not cost money, configuring Windows Search, managing privacy settings, and quick tips that improve how you work on Windows 11 devices. Users of all experience level will find actionable information that are easy to follow. Experienced users get advanced information, that include editing policies or the Windows Registry to make modifications to the system. Things that are included (plus others not listed) Customize the appearance of Windows 11 (taskbar, Start, Explorer, themes, colors., and fonts) Make File Explorer more efficient. Improve your productivity through shortcuts and other options. Use local or Microsoft accounts. Troubleshoot Windows 11 and resolve issues on your own. Control Windows Updates. Manage privacy settings. Set up a backup solution that is efficient and free. Make use of advanced concepts such as Windows Sandbox or Windows Subsystem for Linux. A list of software recommendations




Excel for Microsoft 365 Training Tutorial Manual Classroom in a Book


Book Description

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




Introducing Windows 10 for IT Professionals


Book Description

Get a head start evaluating Windows 10--with technical insights from award-winning journalist and Windows expert Ed Bott. This guide introduces new features and capabilities, providing a practical, high-level overview for IT professionals ready to begin deployment planning now. This edition was written after the release of Windows 10 version 1511 in November 2015 and includes all of its enterprise-focused features. The goal of this book is to help you sort out what’s new in Windows 10, with a special emphasis on features that are different from the Windows versions you and your organization are using today, starting with an overview of the operating system, describing the many changes to the user experience, and diving deep into deployment and management tools where it’s necessary.




QuickBooks Desktop Pro 2024 Training Manual Classroom in a Book


Book Description

Complete classroom training manual for QuickBooks Desktop Pro 2024. 315 pages and 194 individual topics. Includes practice exercises and keyboard shortcuts. You will learn how to set up a QuickBooks company file, pay employees and vendors, create custom reports, reconcile your accounts, use estimating, time tracking and much more. Topics Covered: The QuickBooks Environment 1. The Home Page and Insights Tabs 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 12. Customer Groups 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 9. Automatically Transferring Credits Between Jobs 10. Manually Transferring Credits Between Jobs 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 7. Upload and Review Bills 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 8. Adding Bank Feeds 9. Reviewing Bank Feed Transactions 10. Bank Feed Rules 11. Disconnecting Bank Feed Accounts 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 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 Payment Reminders 7. Receipt Management Using QuickBooks Tools 1. Company File Cleanup 2. Exporting and Importing List Data Using IIF Files 3. Advanced Importing of Excel 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 11. Moving QuickBooks Desktop Using the Migrator Tool 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




QuickBooks Pro 2024 for Lawyers Training Manual Classroom in a Book


Book Description

Complete classroom training manual for QuickBooks Pro 2024 for Lawyers. Full classroom manual in one book. 351 pages and 213 individual topics. Includes practice exercises and keyboard shortcuts. You will learn how to create and effectively manage a legal company file as well as use QuickBooks for trust accounting. In addition, you’ll receive our complete QuickBooks curriculum. Topics Covered: 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 12. Customer Groups 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 9. Automatically Transferring Credits Between Jobs 10. Manually Transferring Credits Between Jobs 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 7. Upload and Review Bills 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 8. Adding Bank Feeds 9. Reviewing Bank Feed Transactions 10. Bank Feed Rules 11. Disconnecting Bank Feed Accounts 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 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 Payment Reminders 7. Receipt Management Using QuickBooks Tools 1. Company File Cleanup 2. Exporting and Importing List Data Using IIF Files 3. Advanced Importing of Excel 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 11. Moving QuickBooks Desktop Using the Migrator Tool 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 Creating a Legal Company File 1. Making a Legal Company Using Express Start 2. Making a Legal Company Using the EasyStep Interview 3. Reviewing the Default Chart of Accounts 4. Entering Vendors 5. Entering Clients and Cases 6. Enabling Class Tracking for Law Firms 7. Creating Billing Line Items Setting up a Trust Account 1. What is an IOLTA? 2. Creating Accounts for Trust Management 3. Creating Items for Trust Management Managing a Trust Account 1. Depositing Client Money into the Client Trust Account 2. Entering Bills to Pay from the Trust Account 3. Recording Bills for Office Expenses 4. Paying Bills from the Client Trust Account 5. Using a Client Trust Credit Card 6. Time Tracking and Invoicing for Legal Professionals 7. Paying the Law Firm’s Invoices Using the Client Funds 8. Refunding Unused Client Trust Account Funds 9. Escheated Trust Funds Trust Account Reporting 1. Creating a Trust Account Liability Proof Report 2. Creating a Trust Liability Balances by Client Report 3. Creating a Client Ledger Report 4. Creating an Account Journal Report




Windows 11 For Dummies


Book Description

Need Windows help? Find the latest tips and tricks in this perennial favorite on Windows Windows 11 promises to be the fastest, most secure, and most flexible version of the Microsoft operating system yet. With a promise like that, of course you want to start using it, as quickly as possible! Windows 11 For Dummies gives you that speed, security, and flexibility by getting you up to date with the latest in Windows. Windows expert and bestselling author Andy Rathbone gives you a helping hand by showing you how to get around the newly updated Windows 11 interface, how to use the new Windows tools like Teams and widgets, and how to use Android apps. Your tour of Windows 11 starts with the Start menu and ends with how to troubleshoot when things go wrong. In between you find out how to find files on your hard drive, connect with friends and colleagues on Microsoft Teams, transfer photos from your phone to your hard drive, or switch between your desktop and laptop. Additional topics include: Navigating the Start menu Finding where your files are hiding Adding separate user accounts to keep your kids out of your business Connecting to a WiFi network Customizing your widgets Switching to a laptop or tablet You know what you want to get done. Keep Windows 11 For Dummies by your desktop, laptop, and tablet, and you can open it at any time to find out how to get your Windows computer to do what you need.




QuickBooks Desktop Pro 2022 Training Manual Classroom in a Book


Book Description

Complete classroom training manual for QuickBooks Desktop Pro 2022. 303 pages and 190 individual topics. Includes practice exercises and keyboard shortcuts. You will learn how to set up a QuickBooks company file, pay employees and vendors, create custom reports, reconcile your accounts, use estimating, time tracking and much more. Topics Covered: The QuickBooks Environment 1. The Home Page and Insights Tabs 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 12. Customer Groups 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 9. Automatically Transferring Credits Between Jobs 10. Manually Transferring Credits Between Jobs 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 7. Upload and Review Bills 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 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 Payment Reminders 7. Receipt Management Using QuickBooks Tools 1. Company File Cleanup 2. Exporting and Importing List Data Using IIF Files 3. Advanced Importing of Excel 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 11. Moving QuickBooks Desktop Using the Migrator Tool 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