Download or read book Access 2003 Personal Trainer written by CustomGuide Inc and published by "O'Reilly Media, Inc.". This book was released on 2005 with total page 392 pages. Available in PDF, EPUB and Kindle. Book excerpt: A fully illustrated, modular approach to the features of Access allows readers to proceed at their own pace.

Download or read book Access 2003 Personal Trainer written by and published by . This book was released on 2005 with total page 384 pages. Available in PDF, EPUB and Kindle. Book excerpt:

Download or read book Project 2003 Personal Trainer written by CustomGuide Inc and published by "O'Reilly Media, Inc.". This book was released on 2005 with total page 240 pages. Available in PDF, EPUB and Kindle. Book excerpt: Now included with Microsoft Office, Project 2003 is the world's leading project management tool. With extensive help resources and printing assistance, Project 2003 enables users to organize and track tasks and resources efficiently to keep projects on time and within budget.If you want to realize the immense potential of Microsoft Project 2003 and harness the many features and functionality of this powerful tool, you need Project 2003 Personal Trainer. It includes everything you want to know about Project 2003--and then plenty more. It's the most complete and engaging tutorial available for Microsoft Project.As part of O'Reilly's new Personal Trainer Series, this book is based on content from CustomGuide (www.customguide.com), a leading provider of computer training materials that fly in the face of traditional, dry course materials that bore users to tears. CustomGuide is dedicated to delivering courseware, quick references, software bulletins, and e-learning courses that are fun, flexible, and easy to use.And this book is no exception to their rule. Project 2003 Personal Trainer lets you, whatever your technical expertise (or lack thereof), learn exactly what you need to know--at your own pace. Unlike many consumer software tutorials that dumb down (and dull up) the material or make it exceptionally technical and confusing, this book is written in a style that you'll find entertaining, easy to follow, and most of all, clear and informative.Beginning with the fundamentals of planning and managing a project with Microsoft Project 2003, the book then includes sections on: working with the task list managing costs, timelines, and available resources using the project database viewing and updating a project tracking progress creating reports handling multiple projects The fully illustrated Project 2003 Personal Trainer features dozens of time-saving, task-oriented lessons, includes detailed diagrams, and comes with a fully interactive CD tutorial to guide your learning--everything you need to become a Project pro.

Download or read book Excel 2003 Personal Trainer written by and published by "O'Reilly Media, Inc.". This book was released on 2004 with total page 488 pages. Available in PDF, EPUB and Kindle. Book excerpt: With sections on editing, formatting, functions, formulas, lists, macros, creating and managing workbooks, and creating and editing charts, this tutorial also includes an interactive companion CD-ROM.

Download or read book Word 2003 Personal Trainer written by CustomGuide Inc and published by "O'Reilly Media, Inc.". This book was released on 2005 with total page 470 pages. Available in PDF, EPUB and Kindle. Book excerpt: Provides a training manual on using Microsoft Office Word 2003, covering such topics as working with tables, performing mail merge, using Document collaboration, and working with forms.

Download or read book Access 2003 Personal Trainer B Cd Rom written by Custom Guide and published by . This book was released on 2005-01-01 with total page 372 pages. Available in PDF, EPUB and Kindle. Book excerpt: This straightforward, practical, and complete guide to mastering the powerful and complex OpenBSD operating system, is for the experienced UNIX user who wants to add OpenBSD to his or her repertoire. The author assumes a knowledge of basic UNIX commands, design, and permissions. The book takes you through the intricacies of the platform and teaches how to manage your system, offering friendly explanations, background information, troubleshooting suggestions, and copious examples throughout.

Download or read book Access 2003 for Starters written by Kate Chase and published by "O'Reilly Media, Inc.". This book was released on 2005-10-31 with total page 398 pages. Available in PDF, EPUB and Kindle. Book excerpt: A guide to Microsoft Access covers such topics as creating databases, creating tables, sorting and filtering, using queries, and generating reports.

Download or read book Use Business Technology BSBCMN205A Windows XP Office 2003 written by Cheryl Price and published by Max Johnson. This book was released on 2004 with total page 158 pages. Available in PDF, EPUB and Kindle. Book excerpt:

Download or read book Outlook 2003 Personal Trainer written by CustomGuide Inc and published by "O'Reilly Media, Inc.". This book was released on 2005 with total page 342 pages. Available in PDF, EPUB and Kindle. Book excerpt: Complete and engaging, this handbook features task-oriented lessons that allow readers to proceed at their own pace.

Download or read book Integrating Excel and Access written by Michael Schmalz and published by O'Reilly Media, Inc.. This book was released on 2006 with total page 244 pages. Available in PDF, EPUB and Kindle. Book excerpt: Showing developers and power users how to combine the tools of Excel with the structured storage and more powerful querying of Access, this guide covers everything a reader really needs in order for projects to work efficiently.

Download or read book Official Gazette of the United States Patent and Trademark Office written by and published by . This book was released on 2005 with total page 1032 pages. Available in PDF, EPUB and Kindle. Book excerpt:

Download or read book Microsoft Access 2019 and 365 Training Manual Classroom in a Book written by TeachUcomp and published by TeachUcomp Inc.. This book was released on 2021-08-11 with total page 189 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

Download or read book O Leary Series Microsoft Office Excel 2003 Brief written by Timothy O'Leary and published by Career Education. This book was released on 2003-10-17 with total page 348 pages. Available in PDF, EPUB and Kindle. Book excerpt: The goal of the O’Leary Series is to give students a basic understanding of computing concepts and to build the skills necessary to ensure that information technology is an advantage in whatever career they choose in life. The O’Leary Microsoft Office 2003 texts are crafted to be the true step-by-step way for students to develop Microsoft Office application skills. The text design emphasizes step-by-step instructions with full screen captures that illustrate the results of each step performed. Each Tutorial (chapter) combines conceptual coverage with detailed software-specific instructions. A running case that is featured in each tutorial highlights the real-world applications of each software program and leads students step-by-step from problem to solution.

Download or read book O Leary Series Microsoft Office Excel 2003 Introductory written by Timothy O'Leary and published by McGraw-Hill/Irwin. This book was released on 2003-12-31 with total page 572 pages. Available in PDF, EPUB and Kindle. Book excerpt: The goal of the O’Leary Series is to give students a basic understanding of computing concepts and to build the skills necessary to ensure that information technology is an advantage in whatever career they choose in life. The O’Leary Microsoft Office 2003 texts are crafted to be the true step-by-step way for students to develop Microsoft Office application skills. The text design emphasizes step-by-step instructions with full screen captures that illustrate the results of each step performed. Each Tutorial (chapter) combines conceptual coverage with detailed software-specific instructions. A running case that is featured in each tutorial highlights the real-world applications of each software program and leads students step-by-step from problem to solution.

Download or read book Microsoft Outlook for Lawyers Training Manual Classroom in a Book written by TeachUcomp and published by TeachUcomp Inc.. This book was released on 2020-10-27 with total page 211 pages. Available in PDF, EPUB and Kindle. Book excerpt: Complete classroom training manuals for Microsoft Outlook 2019 for Lawyers. 211 pages and 120 individual topics. Includes practice exercises and keyboard shortcuts. You will learn how to effectively manage legal contacts, tasks and digital security. In addition, you’ll receive our complete Outlook curriculum. Topics Covered: Getting Acquainted with Outlook 1. The Outlook Environment 2. The Title Bar 3. The Ribbon 4. The Quick Access Toolbar 5. Touch Mode 6. The Navigation Bar, Folder Pane, Reading Pane, and To-Do Bar Making Contacts 1. The People Folder 2. Customizing the Contacts Folder View 3. Creating Contacts 4. Basic Contact Management 5. Printing Contacts 6. Creating Contact Groups 7. Categorizing Contacts 8. Searching for Contacts 9. Calling Contacts 10. Mapping a Contact’s Address E-Mail 1. Using the Inbox 2. Changing the Inbox View 3. Message Flags 4. Searching for Messages 5. Creating, Addressing, and Sending Messages 6. Checking Message Spelling 7. Setting Message Options 8. Formatting Messages 9. Using Signatures 10. Replying to Messages 11. Forwarding Messages 12. Sending Attachments 13. Opening Attachments 14. Ignoring Conversations The Sent Items Folder 1. The Sent Items Folder 2. Resending Messages 3. Recalling Messages The Outbox Folder 1. Using the Outbox 2. Using the Drafts Folder Using the Calendar 1. The Calendar Window 2. Switching the Calendar View 3. Navigating the Calendar 4. Appointments, Meetings and Events 5. Manipulating Calendar Objects 6. Setting an Appointment 7. Scheduling a Meeting 8. Checking Meeting Attendance Status 9. Responding to Meeting Requests 10. Scheduling an Event 11. Setting Recurrence 12. Printing the Calendar 13. Teams Meetings in Outlook 14. Meeting Notes Tasks 1. Using Tasks 2. Printing Tasks 3. Creating a Task 4. Setting Task Recurrence 5. Creating a Task Request 6. Responding to Task Requests 7. Sending Status Reports 8. Deleting Tasks Deleted Items 1. The Deleted Items Folder 2. Permanently Deleting Items 3. Recovering Deleted Items 4. Recovering and Purging Permanently Deleted Items Groups 1. Accessing Groups 2. Creating a New Group 3. Adding Members to Groups and Inviting Others 4. Contributing to Groups 5. Managing Files in Groups 6. Accessing the Group Calendar and Notebook 7. Following and Stop Following Groups 8. Leaving Groups 9. Editing, Managing and Deleting Groups The Journal Folder 1. The Journal Folder 2. Switching the Journal View 3. Recording Journal Items 4. Opening Journal Entries and Documents 5. Deleting Journal Items Public Folders 1. Creating Public Folders 2. Setting Permissions 3. Folder Rules 4. Copying Public Folders Personal and Private Folders 1. Creating a Personal Folder 2. Setting AutoArchiving for Folders 3. Creating Private Folders 4. Creating Search Folders 5. One-Click Archiving Notes 1. Creating and Using Notes Advanced Mailbox Options 1. Creating Mailbox Rules 2. Creating Custom Mailbox Views 3. Handling Junk Mail 4. Color Categorizing 5. Advanced Find 6. Mailbox Cleanup Outlook Options 1. Using Shortcuts 2. Adding Additional Profiles 3. Adding Accounts 4. Outlook Options 5. Using Outlook Help Delegates 1. Creating a Delegate 2. Acting as a Delegate 3. Deleting Delegates Security 1. Types of Email Encryption in Outlook 2. Sending Encrypted Email Managing Mail 1. Using Subfolders 2. Using Mailbox Rules to Organize Mail 3. Using Search and Search Folders to Organize Mail 4. Making Mail Easier to Search 5. Managing Reminders 6. Saving Email as PDF 7. Turning Emails into Tasks 8. AutoReply to Email 9. Auto-forward Email 10. Using Quick Parts 11. Using Quick Steps in Outlook 12. Tips to Reduce PST Folder Size 13. Adding Confidentiality Notices 14. Deferring Mail Delivery Legal Contacts 1. Using BCC for Confidentiality with Contact Groups Managing Legal Scheduling 1. Automatically Processing Meeting Requests Managing Tasks 1. Task Tracking vs. Forwarding Email 2. Viewing and Managing Task Times 3. Categorizing Tasks and Managing Views

Download or read book Microsoft Windows 11 Training Manual Classroom in a Book written by TeachUcomp and published by TeachUcomp Inc.. This book was released on 2022-04-26 with total page 308 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

Download or read book Microsoft Excel 2019 for Lawyers Training Manual Classroom in a Book written by TeachUcomp and published by TeachUcomp Inc.. This book was released on 2019-10-27 with total page 479 pages. Available in PDF, EPUB and Kindle. Book excerpt: Complete classroom training manuals for Microsoft Excel 2019 for Lawyers. 479 pages and 224 individual topics. Includes practice exercises and keyboard shortcuts. You will learn how to effectively use legal templates, legal business functions (such as the Pv and Fv functions) and simple IOLTA management. In addition, you’ll receive our complete Excel curriculum. 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 View 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. The Tell Me Bar 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 Using Online Templates 1. Downloading Online Templates 2. Saving a Template 3. Creating New Workbooks from Saved Templates Legal Templates 1. Chapter Overview 2. Using the Law Firm Financial Analysis Worksheet 3. Using the Law Firm Project Tracker 4. Using the Law Firm Project Plan Legal Business Functions 1. The Pv Function 2. The Fv Function 3. The IRR and XIRR Functions Simple IOLTA Management 1. IOLTA Basics 2. Using Excel for Simple IOLTA Management 3. Using the Simple IOLTA Template