Mastering Excel Made Easy

DOWNLOAD

Download Mastering Excel Made Easy PDF/ePub or read online books in Mobi eBooks. Click Download or Read Online button to get Mastering Excel Made Easy book now. This website allows unlimited access to, at the time of writing, more than 1.5 million titles, including hundreds of thousands of titles in various foreign languages. If the content not found or just blank you must refresh this page

Excel 2019 Basics

DOWNLOAD
Author : Nathan George
language : en
Publisher: Gtech Publishing
Release Date : 2020

Excel 2019 Basics written by Nathan George and has been published by Gtech Publishing this book supported file pdf, txt, epub, kindle and other format this book has been release on 2020 with Computers categories.

A Step-By-Step Approach to Learning Excel Fast Excel 2019 Basics covers all you need to quickly get up to speed in creating spreadsheets to provide solutions for your data. If you are new to Excel and the thought of spreadsheets makes your head spin, then you've come to the right place. This book will hold your hand through a step-by-step process in becoming skilled with Excel. If you already have some Excel skills and you want to skill-up on more advanced topics like functions, Excel tables, pivot tables, and charts, then you've also come to the right place. Excel 2019 Basics goes beyond introduction topics and covers topics like functions, Excel tables, and analysing your data with charts. The aim of this book is to guide you from beginner to being skilled with Excel within a few short hours. Learn Excel Quicker by Avoiding Unnecessary Fillers This book cuts to the chase without the unnecessary verbosity seen in many other Excel books. You don't need to get through a wall of text to learn how to quickly carry out various tasks in Excel. Hence, Excel 2019 Basics focuses on providing direct instructions for how to complete tasks with screenshots where necessary to illustrate the concepts. In this book, you'll learn how to: Add, name, copy and move worksheets. Freeze and unfreeze panes (rows and columns). Use AutoFill and Flash Fill to automate repetitive tasks. Move and copy data. Format cells, ranges and tables. Create formulas for different types of calculations. Use absolute and relative cell references. Use AutoSum to quickly automate calculations. Use functions like IF, DATE, DATEDIF, LEN, MID, and VLOOLUP. Work with Excel tables, including applying table styles. Easily filter and sort your data. Dynamically analyze your data with Pivot Table tools that can carry out automated data summaries in seconds that would have taken hours to do manually! Use the Quick Analysis tool to generate charts and sparklines with just a few clicks. Secure your workbook data and design with a password. Use many more Excel features... Get the book now to start your journey to Excel mastery today!

Excel For Microsoft 365 Training Tutorial Manual Classroom In A Book

DOWNLOAD
Author : TeachUcomp
language : en
Publisher: TeachUcomp Inc.
Release Date : 2024-01-18

Excel For Microsoft 365 Training Tutorial Manual Classroom In A Book written by TeachUcomp and has been published by TeachUcomp Inc. this book supported file pdf, txt, epub, kindle and other format this book has been release on 2024-01-18 with Computers categories.

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

Beginning Excel First Edition

DOWNLOAD
Author : Barbara Lave
language : en
Publisher:
Release Date : 2020

Beginning Excel First Edition written by Barbara Lave and has been published by this book supported file pdf, txt, epub, kindle and other format this book has been release on 2020 with categories.

This is the first edition of a textbook written for a community college introductory course in spreadsheets utilizing Microsoft Excel; second edition available: https://openoregon.pressbooks.pub/beginningexcel19/. While the figures shown utilize Excel 2016, the textbook was written to be applicable to other versions of Excel as well. The book introduces new users to the basics of spreadsheets and is appropriate for students in any major who have not used Excel before.

Excel 2019 Bible

DOWNLOAD
Author : Michael Alexander
language : en
Publisher: John Wiley & Sons
Release Date : 2018-09-25

Excel 2019 Bible written by Michael Alexander and has been published by John Wiley & Sons this book supported file pdf, txt, epub, kindle and other format this book has been release on 2018-09-25 with Computers categories.

The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, the Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more. Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2019 Bible. Create functional spreadsheets that work Master formulas, formatting, pivot tables, and more Get acquainted with Excel 2019's new features and tools Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2019 Bible has you covered with complete coverage and clear expert guidance.

Microsoft Excel 2019 For Lawyers Training Manual Classroom In A Book

DOWNLOAD
Author : TeachUcomp
language : en
Publisher: TeachUcomp Inc.
Release Date : 2019-10-27

Microsoft Excel 2019 For Lawyers Training Manual Classroom In A Book written by TeachUcomp and has been published by TeachUcomp Inc. this book supported file pdf, txt, epub, kindle and other format this book has been release on 2019-10-27 with Computers categories.

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

Excel 2019 Advanced Topics

DOWNLOAD
Author : Nathan George
language : en
Publisher:
Release Date : 2019-07-14

Excel 2019 Advanced Topics written by Nathan George and has been published by this book supported file pdf, txt, epub, kindle and other format this book has been release on 2019-07-14 with categories.

Use Advanced Tools to Create Quick Solutions and Increase Your Productivity Whether you have basic Excel skills or you're a power user, Excel 2019 Advanced Topics is full of tips and techniques that enable you to leverage the power of Excel in creating robust solutions for your data at home or at work. When building complicated spreadsheets solutions, using the right tool in Excel can increase the accuracy and efficiency of your work. Gain Expert Skills in Excel The aim of this book is to provide you with tools and techniques that enable you to create Excel solutions to problems that require more than a basic knowledge of Excel. This is not an exhaustive guide on advanced Excel, but a special selection of intermediate to advanced topics relevant to productivity tasks you're more likely to encounter at home, in your business or at work. Excel 2019 Advanced Topics explains how to automate Excel with macros, use What-If Analysis tools to create data scenarios and projections, analyze data with pivot tables and pivot charts, debug formulas, use data tools to consolidate data, remove duplicate values from lists, create financial formulas to carry out financial calculations, and much more. In this book, you'll learn how to: Remove duplicate rows from a data list. Delete blank rows in your data list. Consolidate data from different worksheets or workbooks. Import and use data from external sources like Microsoft Access databases, CSV text files, and Internet web pages. Troubleshoot and fix errors in formulas with various formula debugging tools. Use advanced functions to create conditional formulas, manipulate text, and make financial calculations. Use macros to automate Excel tasks. Analyze alternate data set and scenarios with What-If Analysis tools. Use the Solver Add-in for more complex What-If Analysis of different data sets. Dynamically analyze data with pivot tables and pivot charts. Protect your workbook, worksheets, or specific cells within your worksheets from unauthorised access or changes. Scroll up and click the Look Inside feature on the top left-hand side of the page and get started today!

Advanced Excel Success

DOWNLOAD
Author : Alan Murray
language : en
Publisher:
Release Date : 2021

Advanced Excel Success written by Alan Murray and has been published by this book supported file pdf, txt, epub, kindle and other format this book has been release on 2021 with Electronic books categories.

Explore advanced skills in Excel and gain an amazing array of tricks and tools to increase your productivity. This book discusses new techniques such as power functions, chart tricks, and many more to master Excel. Advanced Excel Success starts with a few useful data tools in Excel followed by advanced formulas that will help you increase productivity. Here, you will learn power functions that aggregate, return ranges, and much more. Further, you will look at custom formatting tricks along with advanced charting tricks. These include automatically changing the color of key metrics, dynamically sorting chart data, and building creative labels. Next, you will understand the role of Power Query which is one of the most important upgrades in Excel. Power Query is the Microsoft Data Connectivity and Data Preparation technology that enables business users to seamlessly access data stored in hundreds of data sources and reshape it to fit their needs, with an easy-to-use, engaging, and no-code user experience. Finally, you will learn Power Pivot which is a distinct feature in Excel that goes beyond spreadsheets. After reading this book, you will be well equipped to work on Excel with its advanced features. You will: Work with the most useful data tools Understand formulas and the ten power functions Use advanced chart and formatting tricks and techniques for dynamic and effective visuals Work with power tools.

Microsoft Word 2019 For Lawyers Training Manual Classroom In A Book

DOWNLOAD
Author : TeachUcomp
language : en
Publisher: TeachUcomp Inc.
Release Date : 2020-10-27

Microsoft Word 2019 For Lawyers Training Manual Classroom In A Book written by TeachUcomp and has been published by TeachUcomp Inc. this book supported file pdf, txt, epub, kindle and other format this book has been release on 2020-10-27 with Computers categories.

Complete classroom training manuals for Microsoft Word 2019 for Lawyers. 396 pages and 223 individual topics. Includes practice exercises and keyboard shortcuts. You will learn how to perform legal reviews, create citations and authorities and use legal templates. In addition, you’ll receive our complete Word curriculum. Topics Covered: Getting Acquainted with Word 1. About Word 2. The Word Environment 3. The Title Bar 4. The Ribbon 5. The “File” Tab and Backstage View 6. The Quick Access Toolbar 7. Touch Mode 8. The Ruler 9. The Scroll Bars 10. The Document View Buttons 11. The Zoom Slider 12. The Status Bar 13. The Mini Toolbar 14. Keyboard Shortcuts Creating Basic Documents 1. Opening Documents 2. Closing Documents 3. Creating New Documents 4. Saving Documents 5. Recovering Unsaved Documents 6. Entering Text 7. Moving through Text 8. Selecting Text 9. Non-Printing Characters 10. Working with Word File Formats 11. AutoSave Online Documents Document Views 1. Changing Document Views 2. Showing and Hiding the Ruler 3. Showing and Hiding Gridlines 4. Showing and Hiding the Navigation Pane 5. Zooming the Document 6. Opening a Copy of a Document in a New Window 7. Arranging Open Document Windows 8. Split Window 9. Comparing Open Documents 10. Switching Open Documents 11. Switching to Full Screen View Basic Editing Skills 1. Deleting Text 2. Cutting, Copying, and Pasting 3. Undoing and Redoing Actions 4. Finding and Replacing Text 5. Selecting Text and Objects Basic Proofing Tools 1. The Spelling and Grammar Tool 2. Setting Default Proofing Options 3. Using the Thesaurus 4. Finding the Word Count 5. Translating Documents 6. Read Aloud in Word Font Formatting 1. Formatting Fonts 2. The Font Dialog Box 3. The Format Painter 4. Applying Styles to Text 5. Removing Styles from Text Formatting Paragraphs 1. Aligning Paragraphs 2. Indenting Paragraphs 3. Line Spacing and Paragraph Spacing Document Layout 1. About Documents and Sections 2. Setting Page and Section Breaks 3. Creating Columns in a Document 4. Creating Column Breaks 5. Using Headers and Footers 6. The Page Setup Dialog Box 7. Setting Margins 8. Paper Settings 9. Layout Settings 10. Adding Line Numbers 11. Hyphenation Settings Using Templates 1. Using Templates 2. Creating Personal Templates Printing Documents 1. Previewing and Printing Documents Helping Yourself 1. The Tell Me Bar and Microsoft Search 2. Using Word Help 3. Smart Lookup Working with Tabs 1. Using Tab Stops 2. Using the Tabs Dialog Box Pictures and Media 1. Inserting Online Pictures 2. Inserting Your Own Pictures 3. Using Picture Tools 4. Using the Format Picture Task Pane 5. Fill & Line Settings 6. Effects Settings 7. Alt Text 8. Picture Settings 9. Inserting Screenshots 10. Inserting Screen Clippings 11. Inserting Online Video 12. Inserting Icons 13. Inserting 3D Models 14. Formatting 3D Models Drawing Objects 1. Inserting Shapes 2. Inserting WordArt 3. Inserting Text Boxes 4. Formatting Shapes 5. The Format Shape Task Pane 6. Inserting SmartArt 7. Design and Format SmartArt 8. Inserting Charts Using Building Blocks 1. Creating Building Blocks 2. Using Building Blocks Styles 1. About Styles 2. Applying Styles 3. Showing Headings in the Navigation Pane 4. The Styles Task Pane 5. Clearing Styles from Text 6. Creating a New Style 7. Modifying an Existing Style 8. Selecting All Instances of a Style in a Document 9. Renaming Styles 10. Deleting Custom Styles 11. Using the Style Inspector Pane 12. Using the Reveal Formatting Pane Themes and Style Sets 1. Applying a Theme 2. Applying a Style Set 3. Applying and Customizing Theme Colors 4. Applying and Customizing Theme Fonts 5. Selecting Theme Effects Page Backgrounds 1. Applying Watermarks 2. Creating Custom Watermarks 3. Removing Watermarks 4. Selecting a Page Background Color or Fill Effect 5. Applying Page Borders Bullets and Numbering 1. Applying Bullets and Numbering 2. Formatting Bullets and Numbering 3. Applying a Multilevel List 4. Modifying a Multilevel List Style Tables 1. Using Tables 2. Creating Tables 3. Selecting Table Objects 4. Inserting and Deleting Columns and Rows 5. Deleting Cells and Tables 6. Merging and Splitting Cells 7. Adjusting Cell Size 8. Aligning Text in Table Cells 9. Converting a Table into Text 10. Sorting Tables 11. Formatting Tables 12. Inserting Quick Tables Table Formulas 1. Inserting Table Formulas 2. Recalculating Word Formulas 3. Viewing Formulas vs. Formula Results 4. Inserting a Microsoft Excel Worksheet Inserting Page Elements 1. Inserting Drop Caps 2. Inserting Equations 3. Inserting Ink Equations 4. Inserting Symbols 5. Inserting Bookmarks 6. Inserting Hyperlinks Outlines 1. Using Outline View 2. Promoting and Demoting Outline Text 3. Moving Selected Outline Text 4. Collapsing and Expanding Outline Text 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. Error Checking 7. Detaching the Data Source 8. Finishing a Mail Merge 9. Mail Merge Rules 10. The Ask Mail Merge Rule 11. The Fill-in Mail Merge Rule 12. The If…Then…Else Mail Merge Rule 13. The Merge Record # Mail Merge Rule 14. The Merge Sequence # Mail Merge Rule 15. The Next Record Mail Merge Rule 16. The Next Record If Mail Merge Rule 17. The Set Bookmark Mail Merge Rule 18. The Skip Record If Mail Merge Rule 19. Deleting Mail Merge Rules in Word Sharing Documents 1. Sharing Documents in Word Using Co-authoring 2. Inserting Comments 3. Sharing by Email 4. Presenting Online 5. Posting to a Blog 6. Saving as a PDF or XPS File 7. Saving as a Different File Type Creating a Table of Contents 1. Creating a Table of Contents 2. Customizing a Table of Contents 3. Updating a Table of Contents 4. Deleting a Table of Contents Creating an Index 1. Creating an Index 2. Customizing an Index 3. Updating an Index Citations and Bibliography 1. Select a Citation Style 2. Insert a Citation 3. Insert a Citation Placeholder 4. Inserting Citations Using the Researcher Pane 5. Managing Sources 6. Editing Sources 7. Creating a Bibliography Captions 1. Inserting Captions 2. Inserting a Table of Figures 3. Inserting a Cross-Reference 4. Updating a Table of Figures Creating Forms 1. Displaying the Developer Tab 2. Creating a Form 3. Inserting Controls 4. Repeating Section Content Control 5. Adding Instructional Text 6. Protecting a Form Making Macros 1. Recording Macros 2. Running and Deleting Recorded Macros 3. Assigning Macros Word Options 1. Setting Word Options 2. Setting Document Properties 3. Checking Accessibility Document Security 1. Applying Password Protection to a Document 2. Removing Password Protection from a Document 3. Restrict Editing within a Document 4. Removing Editing Restrictions from a Document Legal Reviewing 1. Using the Compare Feature 2. Using the Combine Feature 3. Tracking Changes 4. Lock Tracking 5. Show Markup Options 6. Using the Document Inspector Citations and Authorities 1. Marking Citations 2. Creating a Table of Authorities 3. Updating a Table of Authorities 4. Inserting Footnotes and Endnotes Legal Documents and Printing 1. Printing on Legal Paper 2. Using Legal Templates in Word 3. WordPerfect to Word Migration Issues

Pulbisher For Microsoft 365 Training Manual Classroom In A Book

DOWNLOAD
Author : TeachUcomp
language : en
Publisher: TeachUcomp Inc.
Release Date : 2024-06-13

Pulbisher For Microsoft 365 Training Manual Classroom In A Book written by TeachUcomp and has been published by TeachUcomp Inc. this book supported file pdf, txt, epub, kindle and other format this book has been release on 2024-06-13 with Computers categories.

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

Word For Microsoft 365 Training Manual Classroom In A Book

DOWNLOAD
Author : TeachUcomp
language : en
Publisher: TeachUcomp Inc.
Release Date : 2024-03-26

Word For Microsoft 365 Training Manual Classroom In A Book written by TeachUcomp and has been published by TeachUcomp Inc. this book supported file pdf, txt, epub, kindle and other format this book has been release on 2024-03-26 with Computers categories.

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