Author: Michael C. Oldenburg
Publisher: Pearson Education
ISBN: 0132966026
Category : Computers
Languages : en
Pages : 465
Book Description
*** This USING Microsoft OneNote 2010 book is enhanced with over 3 hours of FREE step-by-step VIDEO TUTORIALS! *** Microsoft OneNote 2010 is an electronic notebook that helps you to gather, manage, find, use, and share the vast amounts of information that each of us must process and make sense of during any given day. The flexibility of OneNote makes it an ideal companion for most of life’s pursuits, no matter if they occur at home, at work, or at school. USING Microsoft OneNote 2010 is a media-rich learning experience designed to help new users master Microsoft OneNote 2010 quickly, and get the most out of it, fast! EVERY chapter has multiple video files integrated into the learning material which creates interactive content that works together to teach everything mainstream Microsoft OneNote 2010 users need to know. You’ll Learn How to: - Use OneNote at Home, Work, or School - Upgrade or Convert From a Previous Version - Become Familiar with the OneNote Workspace - Work with Notebooks, Sections, and Pages - Take and Format Notes - Collect and Research Information - Organize and Search Notes - Manage Security Features in OneNote - Share Notes with Other People - Use OneNote with Other Programs or Your Mobile Phone - Customize OneNote Examples of Topics Covered in VIDEO TUTORIALS, which Walk You Through Tasks You’ve Just Got to See! - Take, Format, Organize, Search, and Share Notes - Capture and Insert Information with Screen Clippings - Protect and Back up Important Sections and Notebooks - Sharing Notes on SkyDrive - Integrating OneNote with Windows Please note that due to the incredibly rich media included in your Enhanced eBook, you may experience longer download times. Please be patient while your product is delivered. This Enhanced eBook has been developed to match the Apple Enhanced eBook specifications for the iPad and may not render well on older iPhones or iPods or perform on other devices or reader applications.
Using Microsoft OneNote 2010, Enhanced Edition
Author: Michael C. Oldenburg
Publisher: Pearson Education
ISBN: 0132966026
Category : Computers
Languages : en
Pages : 465
Book Description
*** This USING Microsoft OneNote 2010 book is enhanced with over 3 hours of FREE step-by-step VIDEO TUTORIALS! *** Microsoft OneNote 2010 is an electronic notebook that helps you to gather, manage, find, use, and share the vast amounts of information that each of us must process and make sense of during any given day. The flexibility of OneNote makes it an ideal companion for most of life’s pursuits, no matter if they occur at home, at work, or at school. USING Microsoft OneNote 2010 is a media-rich learning experience designed to help new users master Microsoft OneNote 2010 quickly, and get the most out of it, fast! EVERY chapter has multiple video files integrated into the learning material which creates interactive content that works together to teach everything mainstream Microsoft OneNote 2010 users need to know. You’ll Learn How to: - Use OneNote at Home, Work, or School - Upgrade or Convert From a Previous Version - Become Familiar with the OneNote Workspace - Work with Notebooks, Sections, and Pages - Take and Format Notes - Collect and Research Information - Organize and Search Notes - Manage Security Features in OneNote - Share Notes with Other People - Use OneNote with Other Programs or Your Mobile Phone - Customize OneNote Examples of Topics Covered in VIDEO TUTORIALS, which Walk You Through Tasks You’ve Just Got to See! - Take, Format, Organize, Search, and Share Notes - Capture and Insert Information with Screen Clippings - Protect and Back up Important Sections and Notebooks - Sharing Notes on SkyDrive - Integrating OneNote with Windows Please note that due to the incredibly rich media included in your Enhanced eBook, you may experience longer download times. Please be patient while your product is delivered. This Enhanced eBook has been developed to match the Apple Enhanced eBook specifications for the iPad and may not render well on older iPhones or iPods or perform on other devices or reader applications.
Publisher: Pearson Education
ISBN: 0132966026
Category : Computers
Languages : en
Pages : 465
Book Description
*** This USING Microsoft OneNote 2010 book is enhanced with over 3 hours of FREE step-by-step VIDEO TUTORIALS! *** Microsoft OneNote 2010 is an electronic notebook that helps you to gather, manage, find, use, and share the vast amounts of information that each of us must process and make sense of during any given day. The flexibility of OneNote makes it an ideal companion for most of life’s pursuits, no matter if they occur at home, at work, or at school. USING Microsoft OneNote 2010 is a media-rich learning experience designed to help new users master Microsoft OneNote 2010 quickly, and get the most out of it, fast! EVERY chapter has multiple video files integrated into the learning material which creates interactive content that works together to teach everything mainstream Microsoft OneNote 2010 users need to know. You’ll Learn How to: - Use OneNote at Home, Work, or School - Upgrade or Convert From a Previous Version - Become Familiar with the OneNote Workspace - Work with Notebooks, Sections, and Pages - Take and Format Notes - Collect and Research Information - Organize and Search Notes - Manage Security Features in OneNote - Share Notes with Other People - Use OneNote with Other Programs or Your Mobile Phone - Customize OneNote Examples of Topics Covered in VIDEO TUTORIALS, which Walk You Through Tasks You’ve Just Got to See! - Take, Format, Organize, Search, and Share Notes - Capture and Insert Information with Screen Clippings - Protect and Back up Important Sections and Notebooks - Sharing Notes on SkyDrive - Integrating OneNote with Windows Please note that due to the incredibly rich media included in your Enhanced eBook, you may experience longer download times. Please be patient while your product is delivered. This Enhanced eBook has been developed to match the Apple Enhanced eBook specifications for the iPad and may not render well on older iPhones or iPods or perform on other devices or reader applications.
Microsoft Office Professional 2010 Step by Step
Author: Joan Lambert
Publisher: Pearson Education
ISBN: 0735652384
Category : Computers
Languages : en
Pages : 1463
Book Description
Teach yourself exactly what you need to know about using Office Professional 2010-one step at a time! With STEP BY STEP, you build and practice new skills hands-on, at your own pace. Covering Microsoft Word, PowerPoint, Outlook, Excel, Access, Publisher, and OneNote, this book will help you learn the core features and capabilities needed to: Create attractive documents, publications, and spreadsheets Manage your e-mail, calendar, meetings, and communications Put your business data to work Develop and deliver great presentations Organize your ideas and notes in one place Connect, share, and accomplish more when working together"
Publisher: Pearson Education
ISBN: 0735652384
Category : Computers
Languages : en
Pages : 1463
Book Description
Teach yourself exactly what you need to know about using Office Professional 2010-one step at a time! With STEP BY STEP, you build and practice new skills hands-on, at your own pace. Covering Microsoft Word, PowerPoint, Outlook, Excel, Access, Publisher, and OneNote, this book will help you learn the core features and capabilities needed to: Create attractive documents, publications, and spreadsheets Manage your e-mail, calendar, meetings, and communications Put your business data to work Develop and deliver great presentations Organize your ideas and notes in one place Connect, share, and accomplish more when working together"
Microsoft OneNote Step by Step
Author: Curtis Frye
Publisher: Microsoft Press
ISBN: 0735699623
Category : Computers
Languages : en
Pages : 389
Book Description
The quick way to learn Microsoft OneNote! This is learning made easy. Get productive fast with OneNote and jump in wherever you need answers. Brisk lessons and colorful screenshots show you exactly what to do, step by step--and practice files help you build your skills. Access local and online OneNote notebooks from any device Create notes that include handwriting, drawings, screen clips, audio clips, video clips, and structured equations Revise, reorganize, flag, format, search, and share your notes Customize OneNote for the way you like to work Get more done by integrating OneNote with Microsoft Word, Excel, and Outlook Share notes by using email, Microsoft OneDrive, and SharePoint Look up just the tasks and lessons you need
Publisher: Microsoft Press
ISBN: 0735699623
Category : Computers
Languages : en
Pages : 389
Book Description
The quick way to learn Microsoft OneNote! This is learning made easy. Get productive fast with OneNote and jump in wherever you need answers. Brisk lessons and colorful screenshots show you exactly what to do, step by step--and practice files help you build your skills. Access local and online OneNote notebooks from any device Create notes that include handwriting, drawings, screen clips, audio clips, video clips, and structured equations Revise, reorganize, flag, format, search, and share your notes Customize OneNote for the way you like to work Get more done by integrating OneNote with Microsoft Word, Excel, and Outlook Share notes by using email, Microsoft OneDrive, and SharePoint Look up just the tasks and lessons you need
Microsoft Office 2010 Digital Classroom
Author: AGI Creative Team
Publisher: John Wiley and Sons
ISBN: 1118058399
Category : Computers
Languages : en
Pages : 330
Book Description
The complete book-and-video training package for Office 2010! This Microsoft Office 2010 book-and-video training package-from the same professional training experts who also create many training materials for Microsoft-is like having your own personal instructor guiding you through each lesson, but you work at your own pace! The full-color book includes 27 lessons that teach you the new features and quirks of Microsoft Office 2010. Each lesson includes step-by-step instructions and lesson files, and provides valuable video tutorials that complement what you're learning and clearly demonstrate how to do tasks. This jam-packed training package takes you well beyond the basics in a series of easy-to-absorb, five-minute lessons. Shows you how to use Microsoft Office 2010, the new version of the Microsoft Office suite that is available in standard 32-bit and now also a 64-bit version Walks you through 27 lessons, each consisting of easy-to-follow, step-by-step instructions and lesson files in full color that make each task less intimidating Includes all the lesson files from the book and video tutorials that clearly show you how to do tasks and reinforces what you're learning in the book Covers exciting new Office 2010 features such as Office Web apps that can be accessed from anywhere and a streamlined new Ribbon Provides the perfect, one-stop, robust learning package-with book and supplementary video training on all the applications in Office 2010 Additional resources available on companion Web site: www.digitalclassroombooks.com Learn the ins-and-outs of Office 2010 with this all-in-one, value-packed combo!
Publisher: John Wiley and Sons
ISBN: 1118058399
Category : Computers
Languages : en
Pages : 330
Book Description
The complete book-and-video training package for Office 2010! This Microsoft Office 2010 book-and-video training package-from the same professional training experts who also create many training materials for Microsoft-is like having your own personal instructor guiding you through each lesson, but you work at your own pace! The full-color book includes 27 lessons that teach you the new features and quirks of Microsoft Office 2010. Each lesson includes step-by-step instructions and lesson files, and provides valuable video tutorials that complement what you're learning and clearly demonstrate how to do tasks. This jam-packed training package takes you well beyond the basics in a series of easy-to-absorb, five-minute lessons. Shows you how to use Microsoft Office 2010, the new version of the Microsoft Office suite that is available in standard 32-bit and now also a 64-bit version Walks you through 27 lessons, each consisting of easy-to-follow, step-by-step instructions and lesson files in full color that make each task less intimidating Includes all the lesson files from the book and video tutorials that clearly show you how to do tasks and reinforces what you're learning in the book Covers exciting new Office 2010 features such as Office Web apps that can be accessed from anywhere and a streamlined new Ribbon Provides the perfect, one-stop, robust learning package-with book and supplementary video training on all the applications in Office 2010 Additional resources available on companion Web site: www.digitalclassroombooks.com Learn the ins-and-outs of Office 2010 with this all-in-one, value-packed combo!
Introducing Windows 10 for IT Professionals
Author: Ed Bott
Publisher: Microsoft Press
ISBN: 0735696985
Category : Computers
Languages : en
Pages : 321
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.
Publisher: Microsoft Press
ISBN: 0735696985
Category : Computers
Languages : en
Pages : 321
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.
MOS 2010 Study Guide for Microsoft OneNote Exam
Author: John Pierce
Publisher: Pearson Education
ISBN: 073566854X
Category :
Languages : en
Pages : 195
Book Description
Demonstrate your expertise with Microsoft OneNote 2010 by earning a MOS certification. This official Study Guide is designed to help you practice and prepare for MOS Exam 77-853: OneNote 2010, and features: Full objective-by-objective coverage Procedures and hands-on practice tasks Ready-made, downloadable practice files Exam-discount offer from Certiport Use the in-depth exam prep, practice, and review to help advance your proficiency with OneNote 2010—and earn the credential that proves it!
Publisher: Pearson Education
ISBN: 073566854X
Category :
Languages : en
Pages : 195
Book Description
Demonstrate your expertise with Microsoft OneNote 2010 by earning a MOS certification. This official Study Guide is designed to help you practice and prepare for MOS Exam 77-853: OneNote 2010, and features: Full objective-by-objective coverage Procedures and hands-on practice tasks Ready-made, downloadable practice files Exam-discount offer from Certiport Use the in-depth exam prep, practice, and review to help advance your proficiency with OneNote 2010—and earn the credential that proves it!
Microsoft OneNote 2010 Plain & Simple
Author: Peter Weverka
Publisher: Microsoft Press
ISBN: 0735665281
Category : Computers
Languages : en
Pages : 580
Book Description
Get the guide that makes learning Microsoft OneNote 2010 plain and simple! This full-color, no-nonsense book shows you the quickest ways to take, organize, and share great notes—with easy-to-follow steps, screenshots, and concise, straightforward language. Here's WHAT you'll learn: Take notes and organize them with ease Arrange notes in pages, sections, and notebooks Add pictures, drawings, and audio and video clips Apply readymade and custom tags to your notes Link notes to web pages and Microsoft Office files Share your notes and collaborate with others Here’s HOW you’ll learn it: Jump in wherever you need answers Easy-to-follow STEPS and SCREENSHOTS show exactly what to do Handy TIPS teach new techniques and shortcuts Quick TRY THIS! exercises help apply what you learn right away
Publisher: Microsoft Press
ISBN: 0735665281
Category : Computers
Languages : en
Pages : 580
Book Description
Get the guide that makes learning Microsoft OneNote 2010 plain and simple! This full-color, no-nonsense book shows you the quickest ways to take, organize, and share great notes—with easy-to-follow steps, screenshots, and concise, straightforward language. Here's WHAT you'll learn: Take notes and organize them with ease Arrange notes in pages, sections, and notebooks Add pictures, drawings, and audio and video clips Apply readymade and custom tags to your notes Link notes to web pages and Microsoft Office files Share your notes and collaborate with others Here’s HOW you’ll learn it: Jump in wherever you need answers Easy-to-follow STEPS and SCREENSHOTS show exactly what to do Handy TIPS teach new techniques and shortcuts Quick TRY THIS! exercises help apply what you learn right away
Microsoft Publisher 2019 Training Manual Classroom in a Book
Author: TeachUcomp
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 296
Book Description
Complete classroom training manual for Microsoft Publisher 2019. 296 pages and 189 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
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 296
Book Description
Complete classroom training manual for Microsoft Publisher 2019. 296 pages and 189 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
My Microsoft Windows 7 PC
Author: Katherine Murray
Publisher: Que Publishing
ISBN: 013283202X
Category : Computers
Languages : en
Pages : 392
Book Description
The clear, friendly, visual guide to using and personalizing Windows 7 - 100% focused on what you really want to do with Windows 7! Full-color, step-by-step tasks teach you how to do what you want, find what you need, run media like a breeze, connect with anyone, and make your whole computing experience smooth and seamless Packed with screen captures that show you exactly what to do Walks through connecting devices and networks, securely sharing content, and troubleshooting problems This easy, visual tutorial doesn't just introduce new users to Windows 7: it shows how to use Windows 7's coolest new features to personalize your experience around the way you live and work. You learn how to get connected to people, places, and other devices, run Windows 7 efficiently, find what you need to run media like a breeze simplify the way you manage your life and commitments create a computing experience that's smoother, more seamless, and more fun. The book walks step-by-step through each key task you need to master, from getting comfortable with the Windows 7 desktop through connectivity, security, mobility, personalization, upgrades, troubleshooting, and much more. This book's step-by-step instructions link to callouts of Windows screen captures that show exactly what to do. Tips and Notes help you discover shortcuts and techniques you'll never find on your own, and Help features guide you past common Windows 7 problems. This book is designed for anyone just starting out with Windows 7 at home or at work, no matter how much experience you have with previous versions - or how little.
Publisher: Que Publishing
ISBN: 013283202X
Category : Computers
Languages : en
Pages : 392
Book Description
The clear, friendly, visual guide to using and personalizing Windows 7 - 100% focused on what you really want to do with Windows 7! Full-color, step-by-step tasks teach you how to do what you want, find what you need, run media like a breeze, connect with anyone, and make your whole computing experience smooth and seamless Packed with screen captures that show you exactly what to do Walks through connecting devices and networks, securely sharing content, and troubleshooting problems This easy, visual tutorial doesn't just introduce new users to Windows 7: it shows how to use Windows 7's coolest new features to personalize your experience around the way you live and work. You learn how to get connected to people, places, and other devices, run Windows 7 efficiently, find what you need to run media like a breeze simplify the way you manage your life and commitments create a computing experience that's smoother, more seamless, and more fun. The book walks step-by-step through each key task you need to master, from getting comfortable with the Windows 7 desktop through connectivity, security, mobility, personalization, upgrades, troubleshooting, and much more. This book's step-by-step instructions link to callouts of Windows screen captures that show exactly what to do. Tips and Notes help you discover shortcuts and techniques you'll never find on your own, and Help features guide you past common Windows 7 problems. This book is designed for anyone just starting out with Windows 7 at home or at work, no matter how much experience you have with previous versions - or how little.
Microsoft Excel 2019 Training Manual Classroom in a Book
Author: TeachUcomp
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 453
Book Description
Complete classroom training manual for Microsoft Excel 2019. 453 pages and 212 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 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
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 453
Book Description
Complete classroom training manual for Microsoft Excel 2019. 453 pages and 212 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 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