Mastering VBA for Microsoft Office 2016 PDF Download
Are you looking for read ebook online? Search for your book and save it on your Kindle device, PC, phones or tablets. Download Mastering VBA for Microsoft Office 2016 PDF full book. Access full book title Mastering VBA for Microsoft Office 2016 by Richard Mansfield. Download full books in PDF and EPUB format.
Author: Richard Mansfield
Publisher: John Wiley & Sons
ISBN: 1119225388
Category : Computers
Languages : en
Pages : 986
Get Book Here
Book Description
Enhance productivity in any Office application with zero programming experience Mastering VBA for Microsoft Office 2016 helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience , you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. Clear, systematic tutorials walk beginners through the basics, while intermediate and advanced content guides more experienced users toward efficient solutions. This comprehensive guide starts at the beginning to get you acquainted with VBA so you can start recording macros right away. You'll then build upon that foundation to utilize the full capabilities of the language as you use loops and functions, message boxes, input boxes, and dialog boxes to design your own Office automation program. Add-ins, embedded macros, content controls, and more give you advanced tools to enhance productivity, and all instruction is backed by real-world practice projects in Word, Excel, Outlook, and PowerPoint. Productivity is the name of the game, and automating certain computing tasks is an easy solution with significant impact for any business. This book shows you how, with step-by-step guidance and expert insight. Expand Office 2016 functionality with macros Learn how to work with VBA and the entire Office suite Create effective code, even with no programing experience Understand ActiveX, XML-based files, the developer tab, and more VBA is designed to be understandable and accessible to beginners, but powerful enough to create specialized business applications. If you're ready to begin exploring the possibilities, Mastering VBA for Microsoft Office 2016 gets you started right away.
Author: James Gips
Publisher:
ISBN: 9781323759400
Category :
Languages : en
Pages : 418
Get Book Here
Book Description
Not just another 'how-to' book, Mastering Excel 2016 goes beyond teaching how to use Excel by demonstrating how to use it for problem solving. From basics through the advanced, it explores the concepts that underlie the keystrokes and mouse clicks and emphasizes how they can be used to solve real problems.
Author: Mike Smart
Publisher:
ISBN: 9781909253094
Category : Computers
Languages : en
Pages : 518
Get Book Here
Book Description
This book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to learn Excel. You'll immediately appreciate the value and relevance of each skill as it is taught. Both IT professionals and absolute beginners will love this book because it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way. Amongst other things you'll learn how to: ¿Use Excel 2016¿s new 3D maps feature to create interactive video tours ¿Use Excel 2016¿s new Get & Transform tool to clean and combine data ¿Perform What-If analysis to model and compare business scenarios ¿Use advanced functions to solve real-world business problems ¿Create intuitive user interfaces using form controls and recorded macros ¿Master dynamic tables and structured table references ¿Use Excel 2016¿s new Append and Merge queries to de-normalize data ¿Master Excel¿s data modeling features to define table relationships ¿Completely understand Excel¿s ability to create OLAP cubes ¿Use OLAP pivot tables and 3D Maps to present OLAP cube data. ¿Use OLAP features to gain total control over PivotTable formatting ¿Break the million row limit with Excels 2016¿s new Big Data features
Author: Richard Mansfield
Publisher: John Wiley & Sons
ISBN: 1119225388
Category : Computers
Languages : en
Pages : 986
Get Book Here
Book Description
Enhance productivity in any Office application with zero programming experience Mastering VBA for Microsoft Office 2016 helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience , you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. Clear, systematic tutorials walk beginners through the basics, while intermediate and advanced content guides more experienced users toward efficient solutions. This comprehensive guide starts at the beginning to get you acquainted with VBA so you can start recording macros right away. You'll then build upon that foundation to utilize the full capabilities of the language as you use loops and functions, message boxes, input boxes, and dialog boxes to design your own Office automation program. Add-ins, embedded macros, content controls, and more give you advanced tools to enhance productivity, and all instruction is backed by real-world practice projects in Word, Excel, Outlook, and PowerPoint. Productivity is the name of the game, and automating certain computing tasks is an easy solution with significant impact for any business. This book shows you how, with step-by-step guidance and expert insight. Expand Office 2016 functionality with macros Learn how to work with VBA and the entire Office suite Create effective code, even with no programing experience Understand ActiveX, XML-based files, the developer tab, and more VBA is designed to be understandable and accessible to beginners, but powerful enough to create specialized business applications. If you're ready to begin exploring the possibilities, Mastering VBA for Microsoft Office 2016 gets you started right away.
Author: TeachUcomp
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 479
Get Book Here
Book Description
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
Author: TeachUcomp
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 345
Get Book Here
Book Description
Complete classroom training manual for Excel for Microsoft 365. 345 pages and 211 individual topics. Includes practice exercises and keyboard shortcuts. You will learn how to create spreadsheets and advanced formulas, format and manipulate spreadsheet layout, sharing and auditing workbooks, create charts, maps, macros, and much more. Topics Covered: Getting Acquainted with Excel 1. About Excel 2. The Excel Environment 3. The Title Bar 4. The Ribbon 5. The “File” Tab and Backstage View 6. Scroll Bars 7. The Quick Access Toolbar 8. Touch Mode 9. The Formula Bar 10. The Workbook Window 11. The Status Bar 12. The Workbook View Buttons 13. The Zoom Slider 14. The Mini Toolbar 15. Keyboard Shortcuts File Management 1. Creating New Workbooks 2. Saving Workbooks 3. Closing Workbooks 4. Opening Workbooks 5. Recovering Unsaved Workbooks 6. Opening a Workbook in a New Window 7. Arranging Open Workbook Windows 8. Freeze Panes 9. Split Panes 10. Hiding and Unhiding Workbook Windows 11.Comparing Open Workbooks 12. Switching Open Workbooks 13. Switching to Full Screen Mode 14. Working With Excel File Formats 15. AutoSave Online Workbooks Data Entry 1. Selecting Cells 2. Entering Text into Cells 3. Entering Numbers into Cells 4. AutoComplete 5. Pick from Drop-Down List 6. Flash Fill 7. Selecting Ranges 8. Ranged Data Entry 9. Using AutoFill Creating Formulas 1. Ranged Formula Syntax 2. Simple Formula Syntax 3. Writing Formulas 4. Using AutoSum 5. Inserting Functions 6. Editing a Range 7. Formula AutoCorrect 8. AutoCalculate 9. Function Compatibility Copying & Pasting Formulas 1. Relative References and Absolute References 2. Cutting, Copying, and Pasting Data 3. AutoFilling Cells 4. The Undo Button 5. The Redo Button Columns & Rows 1. Selecting Columns & Rows 2. Adjusting Column Width and Row Height 3. Hiding and Unhiding Columns and Rows 4. Inserting and Deleting Columns and Rows Formatting Worksheets 1. Formatting Cells 2. The Format Cells Dialog Box 3. Clearing All Formatting from Cells 4. Copying All Formatting from Cells to Another Area Worksheet Tools 1. Inserting and Deleting Worksheets 2. Selecting Multiple Worksheets 3. Navigating Worksheets 4. Renaming Worksheets 5. Coloring Worksheet Tabs 6. Copying or Moving Worksheets Setting Worksheet Layout 1. Using Page Break Preview 2. Using the Page Layout View 3. Opening The Page Setup Dialog Box 4. Page Settings 5. Setting Margins 6. Creating Headers and Footers 7. Sheet Settings Printing Spreadsheets 1. Previewing and Printing Worksheets Helping Yourself 1. Using Excel Help 2. Microsoft Search in Excel 3. Smart Lookup Creating 3D Formulas 1. Creating 3D Formulas 2. 3D Formula Syntax 3. Creating 3D Range References Named Ranges 1. Naming Ranges 2. Creating Names from Headings 3. Moving to a Named Range 4. Using Named Ranges in Formulas 5. Naming 3D Ranges 6. Deleting Named Ranges Conditional Formatting and Cell Styles 1. Conditional Formatting 2. Finding Cells with Conditional Formatting 3. Clearing Conditional Formatting 4. Using Table and Cell Styles Paste Special 1. Using Paste Special 2. Pasting Links Sharing Workbooks 1. About Co-authoring and Sharing Workbooks 2. Co-authoring Workbooks 3. Adding Shared Workbook Buttons in Excel 4. Traditional Workbook Sharing 5. Highlighting Changes 6. Reviewing Changes 7. Using Comments and Notes 8. Compare and Merge Workbooks Auditing Worksheets 1. Auditing Worksheets 2. Tracing Precedent and Dependent Cells 3. Tracing Errors 4. Error Checking 5. Using the Watch Window 6. Cell Validation Outlining Worksheets 1. Using Outlines 2. Applying and Removing Outlines 3. Applying Subtotals Consolidating Worksheets 1. Consolidating Data Tables 1. Creating a Table 2. Adding an Editing Records 3. Inserting Records and Fields 4. Deleting Records and Fields Sorting Data 1. Sorting Data 2. Custom Sort Orders Filtering Data 1. Using AutoFilters 2. Using the Top 10 AutoFilter 3. Using a Custom AutoFilter 4. Creating Advanced Filters 5. Applying Multiple Criteria 6. Using Complex Criteria 7. Copying Filter Results to a New Location 8. Using Database Functions Using What-If Analysis 1. Using Data Tables 2. Using Scenario Manager 3. Using Goal Seek 4. Forecast Sheets Table-Related Functions 1. The Hlookup and Vlookup Functions 2. Using the IF, AND, and OR Functions 3. The IFS Function Sparklines 1. Inserting and Deleting Sparklines 2. Modifying Sparklines Creating Charts In Excel 1. Creating Charts 2. Selecting Charts and Chart Elements 3. Adding Chart Elements 4. Moving and Resizing Charts 5. Changing the Chart Type 6. Changing the Data Range 7. Switching Column and Row Data 8. Choosing a Chart Layout 9. Choosing a Chart Style 10. Changing Color Schemes 11. Printing Charts 12. Deleting Charts Formatting Charts in Excel 1. Formatting Chart Objects 2. Inserting Objects into a Chart 3. Formatting Axes 4. Formatting Axis Titles 5. Formatting a Chart Title 6. Formatting Data Labels 7. Formatting a Data Table 8. Formatting Error Bars 9. Formatting Gridlines 10. Formatting a Legend 11. Formatting Drop and High-Low Lines 12. Formatting Trendlines 13. Formatting Up/Down Bars 14. Formatting the Chart and Plot Areas 15. Naming Charts 16. Applying Shape Styles 17. Applying WordArt Styles 18. Saving Custom Chart Templates Data Models 1. Creating a Data Model from External Relational Data 2. Creating a Data Model from Excel Tables 3. Enabling Legacy Data Connections 4. Relating Tables in a Data Model 5. Managing a Data Model PivotTables and PivotCharts 1. Creating Recommended PivotTables 2. Manually Creating a PivotTable 3. Creating a PivotChart 4. Manipulating a PivotTable or PivotChart 5. Changing Calculated Value Fields 6. Formatting PivotTables 7. Formatting PivotCharts 8. Setting PivotTable Options 9. Sorting and Filtering Using Field Headers PowerPivot 1. Starting PowerPivot 2. Managing the Data Model 3. Calculated Columns and Fields 4. Measures 5. Creating KPIs 6. Creating and Managing Perspectives 7. PowerPivot PivotTables and PivotCharts 3D Maps 1. Enabling 3D Maps 2. Creating a New 3D Maps Tour 3. Editing a 3D Maps Tour 4. Managing Layers in a 3D Maps Tour 5. Filtering Layers 6. Setting Layer Options 7. Managing Scenes 8. Custom 3D Maps 9. Custom Regions 10. World Map Options 11. Inserting 3D Map Objects 12. Previewing a Scene 13. Playing a 3D Maps Tour 14. Creating a Video of a 3D Maps Tour 15. 3D Maps Options Slicers and Timelines 1. Inserting and Deleting Slicers 2. Modifying Slicers 3. Inserting and Deleting Timelines 4. Modifying Timelines Security Features 1. Unlocking Cells 2. Worksheet Protection 3. Workbook Protection 4. Password Protecting Excel Files Making Macros 1. Recording Macros 2. Running and Deleting Recorded Macros 3. The Personal Macro Workbook
Author: TeachUcomp
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 396
Get Book Here
Book Description
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
Author: TeachUcomp
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 161
Get Book Here
Book Description
Complete classroom training manuals for Microsoft PowerPoint 2016. Two manuals (Introductory and Advanced) in one book. 161 pages and 82 individual topics. Includes practice exercises and keyboard shortcuts. You will learn introductory through advanced concepts – from creating simple yet elegant presentations to adding animation and video and customization. Topics Covered: Getting Acquainted with PowerPoint 1. The PowerPoint Environment 2. The Title Bar 3. The Ribbon 4. The “File” Tab and Backstage View 5. The Quick Access Toolbar 6. Touch/Mouse Mode 7. The Scroll Bars 8. The Presentation View Buttons 9. The Zoom Slider 10. The Status Bar 11. The Mini Toolbar 12. Keyboard Shortcuts 13. What’s New in PowerPoint 2016 Creating Basic Presentations 1. Opening Presentations 2. Closing Presentations 3. Creating New Presentations 4. Saving Presentations 5. Recovering Unsaved Presentations 6. Inserting New Slides 7. Applying Slide Layouts 8. Sharing Presentations 9. Working with PowerPoint File Formats Using Presentation Views 1. Normal View 2. Outline View 3. Slide Sorter View 4. Notes Page View 5. Slide Show View 6. Reading View Using Text 1. Adding Text to Slides 2. Basic Object Manipulation 3. Font Formatting 4. Paragraph Formatting 5. Applying Custom Bullets and Numbering 6. Using Tabs 7. Setting Text Options 8. Checking Spelling Using Pictures 1. Inserting Pictures Saved Locally 2. Inserting Online Pictures 3. Basic Graphic Manipulation 4. Using Picture Tools 5. Using the Format Picture Task Pane 6. Fill and Line Settings 7. Effects Settings 8. Size and Properties Settings 9. Picture Settings Using SmartArt 1. Inserting and Manipulating SmartArt 2. Formatting SmartArt Using Slide Show View 1. Running a Slide Show 2. Using Custom Shows Printing Your Presentation 1. Changing Slide Size 2. Setting the Slide Header and Footer 3. Previewing and Printing Presentations Helping Yourself 1. Using PowerPoint Help 2. The Tell Me Bar 3. Smart Lookup and Insights Applying Animation 1. Adding Slide Transition Animation 2. Adding Object Animation Drawing Objects 1. Inserting Shapes 2. Formatting Shapes 3. Inserting WordArt Inserting Video and Sound 1. Inserting Videos 2. Inserting Audio 3. Animating Multimedia Playback 4. Recording a Sound 5. Screen Recording Using Themes 1. Applying Themes 2. Creating Custom Color Schemes 3. Creating Custom Font Schemes 4. Customizing the Slide Background Using Presentation Masters 1. Using Slide Masters and Slide Layouts 2. Using the Notes Master 3. Using the Handout Master 4. Saving a Presentation Template Setting Up the Presentation 1. Setting Up the Slide Show 2. Recording Narration 3. Rehearsing Timings Applying Actions 1. Inserting Actions 2. Inserting Hyperlinks Inserting Charts, Tables, and Objects 1. Inserting Charts 2. Inserting Tables 3. Inserting Objects Setting PowerPoint Options 1. Setting PowerPoint Options
Author: Ritu Arora
Publisher: BPB Publications
ISBN: 935551865X
Category : Computers
Languages : en
Pages : 309
Get Book Here
Book Description
Unleash the power of Excel for advanced data analysis, automation, and productivity KEY FEATURES ● Build a solid foundation in Excel by learning the basics, including the creation and formatting cells, sheets, and workbooks. ● Explore advanced Excel techniques, including formulas, data analysis, and VBA macros. ● Discover the potential of ChatGPT for Excel automation, that enables you to automate tasks and generate insightful reports. DESCRIPTION Advanced Excel is a powerful tool that goes beyond basic spreadsheet functions, allowing users to perform complex calculations, manipulate large datasets, create interactive visualizations, automate tasks, and conduct in-depth data analysis. If you want to enhance your productivity, accuracy, and decision-making skills in Excel, look no further. This book is a comprehensive guide that explores the advanced features of Microsoft Excel. From creating macros with VBA to automating tasks, working with large datasets, creating visualizations, and conducting data analysis, this book covers it all. Additionally, it also introduces ChatGPT, an AI chatbot that enhances Excel automation. With practical examples and clear instructions, this guide empowers users to maximize their productivity, efficiency, and decision-making skills in Excel. By the end of this book, you will have developed the expertise and confidence to tackle complex tasks in Excel with ease. WHAT YOU WILL LEARN ● Develop proficiency in working with large datasets. ● Conduct data analysis using powerful tools like Vlookup and Advanced Pivot Tables. ● Create impactful charts and graphs that effectively communicate your findings and insights. ● Seamlessly integrate Excel with other applications to streamline your workflows and enhance collaboration. ● Discover time-saving techniques and shortcut keys to improve your productivity and efficiency in Excel. WHO THIS BOOK IS FOR For individuals seeking to enhance their Excel skills for advanced tasks, this extensive book serves as a valuable asset. It also caters to the needs of accountants, financial analysts, business analysts, and data scientists who aspire to boost their efficiency and productivity in Excel. TABLE OF CONTENTS 1. Overview of Excel 2021 2. Cell References and Range 3. Working with Formulas and Functions 4. Data Validation 5. Protection 6. Sorting a Database 7. Filtering a Database 8. Subtotals and Data Consolidation 9. Pivot Tables 10. Conditional Formatting 11. What-if-Analysis 12. Working with Multiple Worksheets, Workbooks and Applications 13. Working with Charts 14. Creating and Recording Macros in VBA 15. Assigning Buttons to Macros 16. Functions and Subroutines in VBA 17. Conditional Statements in VBA 18. Variables and Data Types in VBA 19. Looping Structures in VBA 20. Arrays and Collections in VBA 21. Debugging and Error Handling in VBA 22. User Forms and User Input in VBS 23. Advanced VBA Techniques and Best Practices 24. Building Custom Add-ins with VBA 25. ChatGPT with Excel
Author: TeachUcomp
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 395
Get Book Here
Book Description
Complete classroom training manuals for Word for Microsoft 365 for Lawyers. 395 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 Mode 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. Microsoft Search in Word 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 and Stock Images 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. Posting to a Blog 5. Saving as a PDF or XPS File 6. 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
Author: TeachUcomp
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 128
Get Book Here
Book Description
Complete classroom training manual for Publisher for Microsoft 365. 128 pages and 64 individual topics. Includes practice exercises and keyboard shortcuts. You will learn how to create publications, format objects, customize schemes, create tables, perform mailings, prepare print files, and much more. Topics Covered: Getting Acquainted with Publisher 1. The Publisher Environment 2. The Title Bar 3. The Ribbon 4. The File Tab and Backstage View 5. The Quick Access Toolbar 6. Touch Mode 7. The Scroll Bars 8. The Page Layout View Buttons 9. The Zoom Slider and Zoom Button 10. The Status Bar 11. The Mini Toolbar 12. Keyboard Shortcuts Creating Basic Publications 1. Creating New Publications 2. Changing the Publication Template 3. Using Business Information 4. Saving Publications 5. Closing Publications 6. Opening Publications 7. Inserting New Pages 8. Deleting Pages 9. Moving Pages Basic Skills 1. Inserting Text Boxes 2. Inserting Shapes 3. Adding Text to Shapes 4. Inserting Pictures Saved Locally 5. Inserting Online Pictures 6. Inserting Picture Placeholders 7. Using the Scratch Area 8. Moving, Resizing, and Rotating Objects 9. Deleting Objects 10. Using Find and Replace 11. Using AutoCorrect 12. Inserting WordArt Formatting Objects 1. Formatting Text 2. Formatting Shapes 3. Formatting Pictures Using Building Blocks 1. Creating Basic Building Blocks 2. Using Building Blocks Master Pages 1. Using Master Pages Customizing Schemes 1. Creating a Custom Color Scheme 2. Creating a Custom Font Scheme 3. Customizing Page Backgrounds Using Tables 1. Creating and Deleting Tables 2. Selecting Table Elements 3. Inserting and Deleting Columns and Rows 4. Merging Text in Table Cells 5. Modifying Text in Table Cells 6. Formatting Tables Page Setup and Layouts 1. Using Page Setup 2. Using Layout Guides 3. Using the Rulers Mailings 1. Mail Merge 2. The Step by Step Mail Merge Wizard 3. Creating a Data Source 4. Selecting Recipients 5. Inserting and Deleting Merge Fields 6. Previewing a Merge 7. Detaching the Data Source 8. Finishing a Mail Merge 9.Merging a Catalog Printing 1. Previewing and Printing 2. Using the Pack and Go Feature 3. Sharing and Exporting Publications Helping Yourself 1. Using Publisher Help
