EBookClubs

Read Books & Download eBooks Full Online

EBookClubs

Read Books & Download eBooks Full Online

Book Mastering Excel 97

    Book Details:
  • Author : Thomas Chester
  • Publisher : Sybex
  • Release : 1997
  • ISBN : 9780782119213
  • Pages : 1060 pages

Download or read book Mastering Excel 97 written by Thomas Chester and published by Sybex. This book was released on 1997 with total page 1060 pages. Available in PDF, EPUB and Kindle. Book excerpt: This most accurate Excel book available includes new chapters on issues such as charting, pivot tables and macros. More than 60 easy-to-find sidebar boxes offer insider tips on more advanced information on complex tasks and features

Book Mastering Excel Made Easy

    Book Details:
  • Author : TeachUcomp, Incorporated
  • Publisher : TeachUcomp Inc.
  • Release : 2007-05
  • ISBN : 1934131202
  • Pages : 687 pages

Download or read book Mastering Excel Made Easy written by TeachUcomp, Incorporated and published by TeachUcomp Inc.. This book was released on 2007-05 with total page 687 pages. Available in PDF, EPUB and Kindle. Book excerpt:

Book Mastering and Using Microsoft Excel 97

Download or read book Mastering and Using Microsoft Excel 97 written by H. Albert Napier and published by . This book was released on 1997 with total page 558 pages. Available in PDF, EPUB and Kindle. Book excerpt: Napier and Judd train students to become office professionals by bringing their experience as educators and corporate trainers to their latest text on Excel 97.

Book Excel 2003 Bible

    Book Details:
  • Author : John Walkenbach
  • Publisher : John Wiley & Sons
  • Release : 2013-05-06
  • ISBN : 0764549790
  • Pages : 972 pages

Download or read book Excel 2003 Bible written by John Walkenbach and published by John Wiley & Sons. This book was released on 2013-05-06 with total page 972 pages. Available in PDF, EPUB and Kindle. Book excerpt: The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" features Written by the leading Excel guru known as "Mr. Spreadsheet," John Walkenbach, who has written more than thirty books and 300 articles on related topics and maintains the popular Spreadsheet Page at www.j-walk.com/ss The definitive reference book for beginning to advanced users, featuring expert advice and hundreds of examples, tips, techniques, shortcuts, work-arounds, and more Covers expanded use of XML and Web services to facilitate data reporting, analysis, importing, and exporting information Explores Excel programming for those who want advanced information CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach's Power Utility Pak Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Book Mastering Excel

    Book Details:
  • Author : James Gips
  • Publisher : John Wiley & Sons
  • Release : 2003
  • ISBN : 9780471428572
  • Pages : 0 pages

Download or read book Mastering Excel written by James Gips and published by John Wiley & Sons. This book was released on 2003 with total page 0 pages. Available in PDF, EPUB and Kindle. Book excerpt: * Assumes no initial understanding or experience with spreadsheets. * Teaches how to use EXCEL and to solve real problems. * Emphasizes concepts that underly use of EXCEL in problem solving as well as keystrokes and mouse clicks necessary to use EXCEL. * Renowned collection of exercises. * Wide range of exercises--enabling the testing of principles in a variety of formats.

Book Mastering MIcrosoft VBA

    Book Details:
  • Author : Guy Hart-Davis
  • Publisher : John Wiley & Sons
  • Release : 2006-01-18
  • ISBN : 9780471790648
  • Pages : 737 pages

Download or read book Mastering MIcrosoft VBA written by Guy Hart-Davis and published by John Wiley & Sons. This book was released on 2006-01-18 with total page 737 pages. Available in PDF, EPUB and Kindle. Book excerpt: VBA is used for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access Easily accessible by novice programmers, VBA is also powerful enough for IT professionals who need to create specialized business applications, generating wide interest Completely revised for the new versions of the language and the Office suite, this book is the most up-to-date VBA guide on the market Includes what everyone, from power users to system administrators and professional developers, needs to know Covers all Office products in depth

Book Excel 97 for Windows Made Simple

Download or read book Excel 97 for Windows Made Simple written by Stephen Morris and published by Routledge. This book was released on 2017-10-03 with total page 160 pages. Available in PDF, EPUB and Kindle. Book excerpt: If you: need to process information quickly and accurately want to produce professional looking reports and presentations want to produce spreadsheets, charts and graphs need a self-teaching approachthen Excel 97 for Windows Made Simple is for you!By a combination of tutorial approach, with tasks to do and easy steps, the MADE SIMPLE series of Computer Books from British publisher Butterworth-Heinemann, using British authors and designed for a European audience, stands above all others.

Book Mastering Publisher Made Easy

Download or read book Mastering Publisher Made Easy written by TeachUcomp, Inc and published by TeachUcomp Inc.. This book was released on 2007-05 with total page 265 pages. Available in PDF, EPUB and Kindle. Book excerpt:

Book Alison Balter s Mastering Microsoft Access 2000 Development

Download or read book Alison Balter s Mastering Microsoft Access 2000 Development written by Alison Balter and published by Sams Publishing. This book was released on 1999 with total page 1398 pages. Available in PDF, EPUB and Kindle. Book excerpt: What Alison's book offers over most or all of the other books on the market is that Alison is able to take a highly technical topic and present it in a manner that is easy to comprehend. It is a book that the reader will often want to read from cover to cover, but it can also act as an excellent reference. The CD includes all source code from the book, sample databases, and complete applications.

Book Mastering New CLAIT

    Book Details:
  • Author : Bernard Kane
  • Publisher : Nelson Thornes
  • Release : 2003
  • ISBN : 9780748770779
  • Pages : 488 pages

Download or read book Mastering New CLAIT written by Bernard Kane and published by Nelson Thornes. This book was released on 2003 with total page 488 pages. Available in PDF, EPUB and Kindle. Book excerpt: Easy-to-follow step-by-step guidance through Microsoft Office applications makes it ideal for self-paced learning. This title provides clear and accessible guidance on developing the key skills required for the New Clait qualification and assumes no prior knowledge. It is accessible for students, workers and adult returners alike. Each book is accompanied by a CD-ROM containing data files required to complete the exercises in the books. Featuring a wide range of graded activities to reinforce learning and skills development to provide a broader understanding of why activities are carried out in particular ways, it is written for Microsoft Office XP, but also suitable for Office 2000.

Book Let Us Learn M S Office

    Book Details:
  • Author : Mridula Sharma
  • Publisher : Prabhat Prakashan
  • Release : 2009-01-01
  • ISBN : 8188322431
  • Pages : 537 pages

Download or read book Let Us Learn M S Office written by Mridula Sharma and published by Prabhat Prakashan. This book was released on 2009-01-01 with total page 537 pages. Available in PDF, EPUB and Kindle. Book excerpt: Let Us Learn M S Office by Mridula Sharma: "Let Us Learn M S Office: Mastering Microsoft Office Suite" is a comprehensive guide by Mridula Sharma that provides step-by-step instructions and practical exercises to help readers master the Microsoft Office suite. From Word processing to Excel spreadsheets, PowerPoint presentations, and more, this book equips individuals with the essential skills to effectively utilize the tools and features of MS Office. Key Aspects of the Book "Let Us Learn M S Office: Mastering Microsoft Office Suite": Comprehensive Instruction: "Let Us Learn M S Office" offers comprehensive instruction for mastering the Microsoft Office suite. The book covers various applications such as Word, Excel, PowerPoint, and Outlook, providing detailed explanations and hands-on exercises to develop proficiency in each program. Practical Exercises: The book includes practical exercises that enable readers to apply their learning and reinforce their understanding of MS Office. These exercises simulate real-world scenarios and guide readers through the practical usage of different features and functions. Step-by-Step Guidance: "Let Us Learn M S Office" provides step-by-step guidance for performing various tasks and operations within MS Office. The book ensures that readers can follow along easily, regardless of their prior experience, and gain confidence in utilizing the software suite effectively. Mridula Sharma, a skilled instructor and expert in Microsoft Office, shares her knowledge and expertise in "Let Us Learn M S Office: Mastering Microsoft Office Suite." With a focus on practical learning, Sharma equips readers with the necessary skills to navigate and utilize the Microsoft Office suite efficiently. Her book serves as a valuable resource for students, professionals, and anyone seeking to enhance their proficiency in MS Office. "Let Us Learn M S Office" empowers readers to unlock the full potential of the software suite and maximize their productivity in various personal and professional endeavors.

Book Mastering Peachtree Made Easy v  2008 through 2003

Download or read book Mastering Peachtree Made Easy v 2008 through 2003 written by and published by TeachUcomp Inc.. This book was released on with total page 221 pages. Available in PDF, EPUB and Kindle. Book excerpt:

Book Microsoft Office 97

Download or read book Microsoft Office 97 written by Gini Courter and published by . This book was released on 1997 with total page 708 pages. Available in PDF, EPUB and Kindle. Book excerpt: Microsoft Office 97: No experience required is a vital resource for computer users eager to master the latest release of Microsoft's popular office suite. This book guides you thorough six applications, building understanding skill by skill and preparing you for your next interview or the start of your next project. Learn every Office skill employers deem essential. Inside, you'll find through coverage of every Office 97 component, beginning with Word and Excel. You'll create presentations using PowerPoint, build databases with Access, manage information with Outlook, and create and maintain a Web site with FrontPage. Whether you work your way through from cover to cover or head straight for what you need right now, you'll quickly learn concrete skills you can apply immediately.

Book Mastering IDEAScript

Download or read book Mastering IDEAScript written by IDEA and published by John Wiley & Sons. This book was released on 2011-03-29 with total page 506 pages. Available in PDF, EPUB and Kindle. Book excerpt: With approximately 44,000 users in the U.S. and Canada, as well as 42,000 in Europe, IDEA software has become a leading provider of data analysis software for use by auditors and accountants. Written to provide users with a quick access guide for optimal use of IDEAScript, Mastering IDEAScript: The Definitive Guide is IDEA's official guide to mastering IDEAScript, covering essential topics such as Introducing IDEAScript, Understanding the Basics of IDEAScript Editor, Designing Structured Applications, Understanding IDEA Databases and much more. For auditors, accountants and controllers.

Book Excel for Microsoft 365 Training Tutorial Manual Classroom in a Book

Download or read book Excel for Microsoft 365 Training Tutorial Manual Classroom in a Book written by TeachUcomp and published by TeachUcomp Inc.. This book was released on 2024-01-18 with total page 345 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

Book Microsoft Office 97 Visual Basic Programmer s Guide

Download or read book Microsoft Office 97 Visual Basic Programmer s Guide written by Microsoft Press and published by . This book was released on 1997 with total page 0 pages. Available in PDF, EPUB and Kindle. Book excerpt: With "Microsoft Office 97 Visual Basic Programmer's Guide", readers will learn to create concise, lean, efficient code with the powerful programming language now found throughout Microsoft Office applications--Visual Basic for Applications.

Book Microsoft Excel 2019 for Lawyers Training Manual Classroom in a Book

Download or read book Microsoft Excel 2019 for Lawyers Training Manual Classroom in a Book written by TeachUcomp and published by TeachUcomp Inc.. This book was released on 2019-10-27 with total page 479 pages. Available in PDF, EPUB and Kindle. Book excerpt: Complete classroom training manuals for Microsoft Excel 2019 for Lawyers. 479 pages and 224 individual topics. Includes practice exercises and keyboard shortcuts. You will learn how to effectively use legal templates, legal business functions (such as the Pv and Fv functions) and simple IOLTA management. In addition, you’ll receive our complete Excel curriculum. Topics Covered: Getting Acquainted with Excel 1. About Excel 2. The Excel Environment 3. The Title Bar 4. The Ribbon 5. The “File” Tab and Backstage View 6. Scroll Bars 7. The Quick Access Toolbar 8. Touch Mode 9. The Formula Bar 10. The Workbook Window 11. The Status Bar 12. The Workbook View Buttons 13. The Zoom Slider 14. The Mini Toolbar 15. Keyboard Shortcuts File Management 1. Creating New Workbooks 2. Saving Workbooks 3. Closing Workbooks 4. Opening Workbooks 5. Recovering Unsaved Workbooks 6. Opening a Workbook in a New Window 7. Arranging Open Workbook Windows 8. Freeze Panes 9. Split Panes 10. Hiding and Unhiding Workbook Windows 11.Comparing Open Workbooks 12. Switching Open Workbooks 13. Switching to Full Screen View 14. Working With Excel File Formats 15. AutoSave Online Workbooks Data Entry 1. Selecting Cells 2. Entering Text into Cells 3. Entering Numbers into Cells 4. AutoComplete 5. Pick from Drop-Down List 6. Flash Fill 7. Selecting Ranges 8. Ranged Data Entry 9. Using AutoFill Creating Formulas 1. Ranged Formula Syntax 2. Simple Formula Syntax 3. Writing Formulas 4. Using AutoSum 5. Inserting Functions 6. Editing a Range 7. Formula AutoCorrect 8. AutoCalculate 9. Function Compatibility Copying & Pasting Formulas 1. Relative References and Absolute References 2. Cutting, Copying, and Pasting Data 3. AutoFilling Cells 4. The Undo Button 5. The Redo Button Columns & Rows 1. Selecting Columns & Rows 2. Adjusting Column Width and Row Height 3. Hiding and Unhiding Columns and Rows 4. Inserting and Deleting Columns and Rows Formatting Worksheets 1. Formatting Cells 2. The Format Cells Dialog Box 3. Clearing All Formatting from Cells 4. Copying All Formatting from Cells to Another Area Worksheet Tools 1. Inserting and Deleting Worksheets 2. Selecting Multiple Worksheets 3. Navigating Worksheets 4. Renaming Worksheets 5. Coloring Worksheet Tabs 6. Copying or Moving Worksheets Setting Worksheet Layout 1. Using Page Break Preview 2. Using the Page Layout View 3. Opening The Page Setup Dialog Box 4. Page Settings 5. Setting Margins 6. Creating Headers and Footers 7. Sheet Settings Printing Spreadsheets 1. Previewing and Printing Worksheets Helping Yourself 1. Using Excel Help 2. The Tell Me Bar 3. Smart Lookup Creating 3D Formulas 1. Creating 3D Formulas 2. 3D Formula Syntax 3. Creating 3D Range References Named Ranges 1. Naming Ranges 2. Creating Names from Headings 3. Moving to a Named Range 4. Using Named Ranges in Formulas 5. Naming 3D Ranges 6. Deleting Named Ranges Conditional Formatting and Cell Styles 1. Conditional Formatting 2. Finding Cells with Conditional Formatting 3. Clearing Conditional Formatting 4. Using Table and Cell Styles Paste Special 1. Using Paste Special 2. Pasting Links Sharing Workbooks 1. About Co-authoring and Sharing Workbooks 2. Co-authoring Workbooks 3. Adding Shared Workbook Buttons in Excel 4. Traditional Workbook Sharing 5. Highlighting Changes 6. Reviewing Changes 7. Using Comments and Notes 8. Compare and Merge Workbooks Auditing Worksheets 1. Auditing Worksheets 2. Tracing Precedent and Dependent Cells 3. Tracing Errors 4. Error Checking 5. Using the Watch Window 6. Cell Validation Outlining Worksheets 1. Using Outlines 2. Applying and Removing Outlines 3. Applying Subtotals Consolidating Worksheets 1. Consolidating Data Tables 1. Creating a Table 2. Adding an Editing Records 3. Inserting Records and Fields 4. Deleting Records and Fields Sorting Data 1. Sorting Data 2. Custom Sort Orders Filtering Data 1. Using AutoFilters 2. Using the Top 10 AutoFilter 3. Using a Custom AutoFilter 4. Creating Advanced Filters 5. Applying Multiple Criteria 6. Using Complex Criteria 7. Copying Filter Results to a New Location 8. Using Database Functions Using What-If Analysis 1. Using Data Tables 2. Using Scenario Manager 3. Using Goal Seek 4. Forecast Sheets Table-Related Functions 1. The Hlookup and Vlookup Functions 2. Using the IF, AND, and OR Functions 3. The IFS Function Sparklines 1. Inserting and Deleting Sparklines 2. Modifying Sparklines Creating Charts In Excel 1. Creating Charts 2. Selecting Charts and Chart Elements 3. Adding Chart Elements 4. Moving and Resizing Charts 5. Changing the Chart Type 6. Changing the Data Range 7. Switching Column and Row Data 8. Choosing a Chart Layout 9. Choosing a Chart Style 10. Changing Color Schemes 11. Printing Charts 12. Deleting Charts Formatting Charts in Excel 1. Formatting Chart Objects 2. Inserting Objects into a Chart 3. Formatting Axes 4. Formatting Axis Titles 5. Formatting a Chart Title 6. Formatting Data Labels 7. Formatting a Data Table 8. Formatting Error Bars 9. Formatting Gridlines 10. Formatting a Legend 11. Formatting Drop and High-Low Lines 12. Formatting Trendlines 13. Formatting Up/Down Bars 14. Formatting the Chart and Plot Areas 15. Naming Charts 16. Applying Shape Styles 17. Applying WordArt Styles 18. Saving Custom Chart Templates Data Models 1. Creating a Data Model from External Relational Data 2. Creating a Data Model from Excel Tables 3. Enabling Legacy Data Connections 4. Relating Tables in a Data Model 5. Managing a Data Model PivotTables and PivotCharts 1. Creating Recommended PivotTables 2. Manually Creating a PivotTable 3. Creating a PivotChart 4. Manipulating a PivotTable or PivotChart 5. Changing Calculated Value Fields 6. Formatting PivotTables 7. Formatting PivotCharts 8. Setting PivotTable Options 9. Sorting and Filtering Using Field Headers PowerPivot 1. Starting PowerPivot 2. Managing the Data Model 3. Calculated Columns and Fields 4. Measures 5. Creating KPIs 6. Creating and Managing Perspectives 7. PowerPivot PivotTables and PivotCharts 3D Maps 1. Enabling 3D Maps 2. Creating a New 3D Maps Tour 3. Editing a 3D Maps Tour 4. Managing Layers in a 3D Maps Tour 5. Filtering Layers 6. Setting Layer Options 7. Managing Scenes 8. Custom 3D Maps 9. Custom Regions 10. World Map Options 11. Inserting 3D Map Objects 12. Previewing a Scene 13. Playing a 3D Maps Tour 14. Creating a Video of a 3D Maps Tour 15. 3D Maps Options Slicers and Timelines 1. Inserting and Deleting Slicers 2. Modifying Slicers 3. Inserting and Deleting Timelines 4. Modifying Timelines Security Features 1. Unlocking Cells 2. Worksheet Protection 3. Workbook Protection 4. Password Protecting Excel Files Making Macros 1. Recording Macros 2. Running and Deleting Recorded Macros 3. The Personal Macro Workbook Using Online Templates 1. Downloading Online Templates 2. Saving a Template 3. Creating New Workbooks from Saved Templates Legal Templates 1. Chapter Overview 2. Using the Law Firm Financial Analysis Worksheet 3. Using the Law Firm Project Tracker 4. Using the Law Firm Project Plan Legal Business Functions 1. The Pv Function 2. The Fv Function 3. The IRR and XIRR Functions Simple IOLTA Management 1. IOLTA Basics 2. Using Excel for Simple IOLTA Management 3. Using the Simple IOLTA Template