Author: Kristin Cullen
Publisher: Rockport Pub
ISBN: 9781592531585
Category : Design
Languages : en
Pages : 258
Book Description
New in Paperback! An inspired resource for creating excellent layouts Layout Workbook is one of five volumes in Rockport's series of practical and inspirational workbooks that cover the fundamental areas of the graphic design business.
Layout Workbook: Revised and Updated
Author: Dennis Puhalla
Publisher: Rockport Publishers
ISBN: 1631594982
Category : Design
Languages : en
Pages : 240
Book Description
Layout Workbook is one of five volumes in Rockport's series of practical and inspirational workbooks that cover the fundamental areas of the graphic design business. In the original, 2005 edition, author Kristin Cullen tackled the often perplexing job of nailing down a layout that works. In the new edition, with a new cover and new look, Dennis Puhalla (author of Rockport's Design Elements: Form and Space) will refresh and update the text, case studies, and imagery. More than a collection of great examples of layout, this book is an invaluable resource for students, designers, and creative professionals who seek design understanding and inspiration. The book illuminates the broad category of layout, communicating specifically what it takes to design with excellence. It also addresses the heart of design-the how and why of the creative process. In Layout Workbook, the subject is approached with a series of step-by-step fundamental chapters (a "how-to" of layout) addressing topics such as The Function of Design, Inspiration, The Design Process, Intuition, Structure and Organization, The Interaction of Visual Elements, Typography, and Design Analysis. The book offers inspirational quotations and a unique, progressive design that truly reflects its content.
Publisher: Rockport Publishers
ISBN: 1631594982
Category : Design
Languages : en
Pages : 240
Book Description
Layout Workbook is one of five volumes in Rockport's series of practical and inspirational workbooks that cover the fundamental areas of the graphic design business. In the original, 2005 edition, author Kristin Cullen tackled the often perplexing job of nailing down a layout that works. In the new edition, with a new cover and new look, Dennis Puhalla (author of Rockport's Design Elements: Form and Space) will refresh and update the text, case studies, and imagery. More than a collection of great examples of layout, this book is an invaluable resource for students, designers, and creative professionals who seek design understanding and inspiration. The book illuminates the broad category of layout, communicating specifically what it takes to design with excellence. It also addresses the heart of design-the how and why of the creative process. In Layout Workbook, the subject is approached with a series of step-by-step fundamental chapters (a "how-to" of layout) addressing topics such as The Function of Design, Inspiration, The Design Process, Intuition, Structure and Organization, The Interaction of Visual Elements, Typography, and Design Analysis. The book offers inspirational quotations and a unique, progressive design that truly reflects its content.
Color Design Workbook
Author: Terry Lee Stone
Publisher: Rockport Pub
ISBN: 9781592534333
Category : Art
Languages : en
Pages : 246
Book Description
Annotation This workbook allows readers to explore colour through the language of the professionals. It supplies tips on how to talk to clients and use colour in presentations along with historical and cultural meanings and colour theory.
Publisher: Rockport Pub
ISBN: 9781592534333
Category : Art
Languages : en
Pages : 246
Book Description
Annotation This workbook allows readers to explore colour through the language of the professionals. It supplies tips on how to talk to clients and use colour in presentations along with historical and cultural meanings and colour theory.
Publication Design Workbook
Author: Timothy Samara
Publisher: Rockport Publishers
ISBN: 1616735902
Category : Design
Languages : en
Pages : 242
Book Description
DIVPublication Design Workbook is packed with information regarding the ins and outs of publication design. The media featured includes magazines, literature systems, newsletters, exhibition catalogs, annual reports, newspapers, and retail catalogs. Both current and historical approaches are provided to give readers a complete background on design style, application, and techniques involved in creating effective publications. Readers will develop a clear understanding of publication design through a comprehensive and accessible workshop-style format. Fundamentals of form and content are included, along with diagrams to further textual understanding. This is the most complete book for designers on applied publication design principles combined with an awe-inspiring collection of the best work from around the world. /div
Publisher: Rockport Publishers
ISBN: 1616735902
Category : Design
Languages : en
Pages : 242
Book Description
DIVPublication Design Workbook is packed with information regarding the ins and outs of publication design. The media featured includes magazines, literature systems, newsletters, exhibition catalogs, annual reports, newspapers, and retail catalogs. Both current and historical approaches are provided to give readers a complete background on design style, application, and techniques involved in creating effective publications. Readers will develop a clear understanding of publication design through a comprehensive and accessible workshop-style format. Fundamentals of form and content are included, along with diagrams to further textual understanding. This is the most complete book for designers on applied publication design principles combined with an awe-inspiring collection of the best work from around the world. /div
Information Design Workbook, Revised and Updated
Author: Kim Baer
Publisher: Rockport Publishers
ISBN: 1631598066
Category : Design
Languages : en
Pages : 242
Book Description
Information Design Workbook, Revised and Updated takes a methodical, yet comprehensive, approach to conveying the fundamentals of effective, innovative information design by examining history, theory, criticism, technology and media, process, method, and practice. With several new case studies and the latest approaches, you'll learn how to create visually compelling and meaningful graphics. Opening with a very brief history followed by an instructive breakdown of the discipline, get an intimate understanding of the complexities of crafting information designto effectively improve communication both functionally and aesthetically. You'll learn every aspect of the discovery process, including how to work within your client's business structure, create a project timeline, identify and prioritize possible audiences, construct a creative brief, and explore personas (user profiles) and scenarios. Then, explore best practices and get practical tips on creating planning documents and testing your design. An overview of key design principles—including color, type styling, structure, and graphic elements—shows you how to apply these basic tools to develop powerful information design solutions. A wide range of case studies from premier design firms around the world illustrate how all the complex considerations and techniques outlined in the first half of the book come into play. The author critiques and explains why each design is successful in terms of formal quality (Aesthetics) and function (How does it improve communication?). The case studies include cutting edge examples of printed matter, information graphics, interactive experiences, environmental design, as well as experimental projects. Using these principles and methods as a foundation and the real-world examples as a springboard, you can learn to execute well-crafted, functional, and aesthetically beautiful information design.
Publisher: Rockport Publishers
ISBN: 1631598066
Category : Design
Languages : en
Pages : 242
Book Description
Information Design Workbook, Revised and Updated takes a methodical, yet comprehensive, approach to conveying the fundamentals of effective, innovative information design by examining history, theory, criticism, technology and media, process, method, and practice. With several new case studies and the latest approaches, you'll learn how to create visually compelling and meaningful graphics. Opening with a very brief history followed by an instructive breakdown of the discipline, get an intimate understanding of the complexities of crafting information designto effectively improve communication both functionally and aesthetically. You'll learn every aspect of the discovery process, including how to work within your client's business structure, create a project timeline, identify and prioritize possible audiences, construct a creative brief, and explore personas (user profiles) and scenarios. Then, explore best practices and get practical tips on creating planning documents and testing your design. An overview of key design principles—including color, type styling, structure, and graphic elements—shows you how to apply these basic tools to develop powerful information design solutions. A wide range of case studies from premier design firms around the world illustrate how all the complex considerations and techniques outlined in the first half of the book come into play. The author critiques and explains why each design is successful in terms of formal quality (Aesthetics) and function (How does it improve communication?). The case studies include cutting edge examples of printed matter, information graphics, interactive experiences, environmental design, as well as experimental projects. Using these principles and methods as a foundation and the real-world examples as a springboard, you can learn to execute well-crafted, functional, and aesthetically beautiful information design.
Color Design Workbook: New, Revised Edition
Author: Sean Adams
Publisher: Rockport Publishers
ISBN: 1631594109
Category : Design
Languages : en
Pages : 240
Book Description
From the meanings behind colors to working with color in presentations, Color Design Workbook provides you with the information needed to effectively apply color to design work. Since color is such an important part of graphic design, designers need the most up-to-date, as well as the most fundamental, information on the subject to have the tools needed to use color effectively. The Color Design Workbook, New, Revised Edition explains the meanings behind colors, working with color in presentations, and loads more. This guide book provides you with the vital information needed to creatively and effectively apply color to your own design work. You will also receive guidance on talking with clients about color and selling color ideas, and you'll also learn the science behind color theory. Case studies are included to show the effects some color choices had on both their clients and consumers. So why wait any longer? Become a color expert now!
Publisher: Rockport Publishers
ISBN: 1631594109
Category : Design
Languages : en
Pages : 240
Book Description
From the meanings behind colors to working with color in presentations, Color Design Workbook provides you with the information needed to effectively apply color to design work. Since color is such an important part of graphic design, designers need the most up-to-date, as well as the most fundamental, information on the subject to have the tools needed to use color effectively. The Color Design Workbook, New, Revised Edition explains the meanings behind colors, working with color in presentations, and loads more. This guide book provides you with the vital information needed to creatively and effectively apply color to your own design work. You will also receive guidance on talking with clients about color and selling color ideas, and you'll also learn the science behind color theory. Case studies are included to show the effects some color choices had on both their clients and consumers. So why wait any longer? Become a color expert now!
The Graphic Design Reference & Specification Book
Author: Poppy Evans
Publisher: Rockport Publishers
ISBN: 161058788X
Category : Design
Languages : en
Pages : 320
Book Description
The Graphic Design Reference & Specification Book is a must-have sourcebook for every designer—amateur of professional. Completely practical with only the most needed information, this valuable book provides designers with all the little details that can make or break a design, such as: How much space to leave in the gutter when designing barrel folds How to layout a template for a box, and the ratios of each part Metric conversion charts Copyright and trademark standards Proofreaders' symbols Image file formats Standard camera formats and sizes Finding the best scanning resolution Type basics and terminology Guide to printing processes Paper usage guide Standard binding types Process color finder Proofing methods Standard envelope sizes in the USA, Europe, Canada and Asia And much more. Take thisreference everywhere you go for details on all the things you can never find but need to know when designing. The Reference & Specification Book series from Rockport Publishers offers students and practicing professionals in a range of creative industries must-have information in their area of specialty in an up-to-date, concise handbook.
Publisher: Rockport Publishers
ISBN: 161058788X
Category : Design
Languages : en
Pages : 320
Book Description
The Graphic Design Reference & Specification Book is a must-have sourcebook for every designer—amateur of professional. Completely practical with only the most needed information, this valuable book provides designers with all the little details that can make or break a design, such as: How much space to leave in the gutter when designing barrel folds How to layout a template for a box, and the ratios of each part Metric conversion charts Copyright and trademark standards Proofreaders' symbols Image file formats Standard camera formats and sizes Finding the best scanning resolution Type basics and terminology Guide to printing processes Paper usage guide Standard binding types Process color finder Proofing methods Standard envelope sizes in the USA, Europe, Canada and Asia And much more. Take thisreference everywhere you go for details on all the things you can never find but need to know when designing. The Reference & Specification Book series from Rockport Publishers offers students and practicing professionals in a range of creative industries must-have information in their area of specialty in an up-to-date, concise handbook.
Excel Data Analysis
Author: Hector Guerrero
Publisher: Springer
ISBN: 3030012794
Category : Business & Economics
Languages : en
Pages : 358
Book Description
This book offers a comprehensive and readable introduction to modern business and data analytics. It is based on the use of Excel, a tool that virtually all students and professionals have access to. The explanations are focused on understanding the techniques and their proper application, and are supplemented by a wealth of in-chapter and end-of-chapter exercises. In addition to the general statistical methods, the book also includes Monte Carlo simulation and optimization. The second edition has been thoroughly revised: new topics, exercises and examples have been added, and the readability has been further improved. The book is primarily intended for students in business, economics and government, as well as professionals, who need a more rigorous introduction to business and data analytics – yet also need to learn the topic quickly and without overly academic explanations.
Publisher: Springer
ISBN: 3030012794
Category : Business & Economics
Languages : en
Pages : 358
Book Description
This book offers a comprehensive and readable introduction to modern business and data analytics. It is based on the use of Excel, a tool that virtually all students and professionals have access to. The explanations are focused on understanding the techniques and their proper application, and are supplemented by a wealth of in-chapter and end-of-chapter exercises. In addition to the general statistical methods, the book also includes Monte Carlo simulation and optimization. The second edition has been thoroughly revised: new topics, exercises and examples have been added, and the readability has been further improved. The book is primarily intended for students in business, economics and government, as well as professionals, who need a more rigorous introduction to business and data analytics – yet also need to learn the topic quickly and without overly academic explanations.
Microsoft Excel 2019 Training Manual Classroom in a Book
Author: TeachUcomp
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 453
Book Description
Complete classroom training manual for Microsoft Excel 2019. 453 pages and 212 individual topics. Includes practice exercises and keyboard shortcuts. You will learn how to create spreadsheets and advanced formulas, format and manipulate spreadsheet layout, sharing and auditing workbooks, create charts, maps, macros, and much more. Topics Covered: Getting Acquainted with Excel 1. About Excel 2. The Excel Environment 3. The Title Bar 4. The Ribbon 5. The “File” Tab and Backstage View 6. Scroll Bars 7. The Quick Access Toolbar 8. Touch Mode 9. The Formula Bar 10. The Workbook Window 11. The Status Bar 12. The Workbook View Buttons 13. The Zoom Slider 14. The Mini Toolbar 15. Keyboard Shortcuts File Management 1. Creating New Workbooks 2. Saving Workbooks 3. Closing Workbooks 4. Opening Workbooks 5. Recovering Unsaved Workbooks 6. Opening a Workbook in a New Window 7. Arranging Open Workbook Windows 8. Freeze Panes 9. Split Panes 10. Hiding and Unhiding Workbook Windows 11.Comparing Open Workbooks 12. Switching Open Workbooks 13. Switching to Full Screen View 14. Working With Excel File Formats 15. AutoSave Online Workbooks Data Entry 1. Selecting Cells 2. Entering Text into Cells 3. Entering Numbers into Cells 4. AutoComplete 5. Pick from Drop-Down List 6. Flash Fill 7. Selecting Ranges 8. Ranged Data Entry 9. Using AutoFill Creating Formulas 1. Ranged Formula Syntax 2. Simple Formula Syntax 3. Writing Formulas 4. Using AutoSum 5. Inserting Functions 6. Editing a Range 7. Formula AutoCorrect 8. AutoCalculate 9. Function Compatibility Copying & Pasting Formulas 1. Relative References and Absolute References 2. Cutting, Copying, and Pasting Data 3. AutoFilling Cells 4. The Undo Button 5. The Redo Button Columns & Rows 1. Selecting Columns & Rows 2. Adjusting Column Width and Row Height 3. Hiding and Unhiding Columns and Rows 4. Inserting and Deleting Columns and Rows Formatting Worksheets 1. Formatting Cells 2. The Format Cells Dialog Box 3. Clearing All Formatting from Cells 4. Copying All Formatting from Cells to Another Area Worksheet Tools 1. Inserting and Deleting Worksheets 2. Selecting Multiple Worksheets 3. Navigating Worksheets 4. Renaming Worksheets 5. Coloring Worksheet Tabs 6. Copying or Moving Worksheets Setting Worksheet Layout 1. Using Page Break Preview 2. Using the Page Layout View 3. Opening The Page Setup Dialog Box 4. Page Settings 5. Setting Margins 6. Creating Headers and Footers 7. Sheet Settings Printing Spreadsheets 1. Previewing and Printing Worksheets Helping Yourself 1. Using Excel Help 2. The Tell Me Bar 3. Smart Lookup Creating 3D Formulas 1. Creating 3D Formulas 2. 3D Formula Syntax 3. Creating 3D Range References Named Ranges 1. Naming Ranges 2. Creating Names from Headings 3. Moving to a Named Range 4. Using Named Ranges in Formulas 5. Naming 3D Ranges 6. Deleting Named Ranges Conditional Formatting and Cell Styles 1. Conditional Formatting 2. Finding Cells with Conditional Formatting 3. Clearing Conditional Formatting 4. Using Table and Cell Styles Paste Special 1. Using Paste Special 2. Pasting Links Sharing Workbooks 1. About Co-authoring and Sharing Workbooks 2. Co-authoring Workbooks 3. Adding Shared Workbook Buttons in Excel 4. Traditional Workbook Sharing 5. Highlighting Changes 6. Reviewing Changes 7. Using Comments and Notes 8. Compare and Merge Workbooks Auditing Worksheets 1. Auditing Worksheets 2. Tracing Precedent and Dependent Cells 3. Tracing Errors 4. Error Checking 5. Using the Watch Window 6. Cell Validation Outlining Worksheets 1. Using Outlines 2. Applying and Removing Outlines 3. Applying Subtotals Consolidating Worksheets 1. Consolidating Data Tables 1. Creating a Table 2. Adding an Editing Records 3. Inserting Records and Fields 4. Deleting Records and Fields Sorting Data 1. Sorting Data 2. Custom Sort Orders Filtering Data 1. Using AutoFilters 2. Using the Top 10 AutoFilter 3. Using a Custom AutoFilter 4. Creating Advanced Filters 5. Applying Multiple Criteria 6. Using Complex Criteria 7. Copying Filter Results to a New Location 8. Using Database Functions Using What-If Analysis 1. Using Data Tables 2. Using Scenario Manager 3. Using Goal Seek 4. Forecast Sheets Table-Related Functions 1. The Hlookup and Vlookup Functions 2. Using the IF, AND, and OR Functions 3. The IFS Function Sparklines 1. Inserting and Deleting Sparklines 2. Modifying Sparklines Creating Charts In Excel 1. Creating Charts 2. Selecting Charts and Chart Elements 3. Adding Chart Elements 4. Moving and Resizing Charts 5. Changing the Chart Type 6. Changing the Data Range 7. Switching Column and Row Data 8. Choosing a Chart Layout 9. Choosing a Chart Style 10. Changing Color Schemes 11. Printing Charts 12. Deleting Charts Formatting Charts in Excel 1. Formatting Chart Objects 2. Inserting Objects into a Chart 3. Formatting Axes 4. Formatting Axis Titles 5. Formatting a Chart Title 6. Formatting Data Labels 7. Formatting a Data Table 8. Formatting Error Bars 9. Formatting Gridlines 10. Formatting a Legend 11. Formatting Drop and High-Low Lines 12. Formatting Trendlines 13. Formatting Up/Down Bars 14. Formatting the Chart and Plot Areas 15. Naming Charts 16. Applying Shape Styles 17. Applying WordArt Styles 18. Saving Custom Chart Templates Data Models 1. Creating a Data Model from External Relational Data 2. Creating a Data Model from Excel Tables 3. Enabling Legacy Data Connections 4. Relating Tables in a Data Model 5. Managing a Data Model PivotTables and PivotCharts 1. Creating Recommended PivotTables 2. Manually Creating a PivotTable 3. Creating a PivotChart 4. Manipulating a PivotTable or PivotChart 5. Changing Calculated Value Fields 6. Formatting PivotTables 7. Formatting PivotCharts 8. Setting PivotTable Options 9. Sorting and Filtering Using Field Headers PowerPivot 1. Starting PowerPivot 2. Managing the Data Model 3. Calculated Columns and Fields 4. Measures 5. Creating KPIs 6. Creating and Managing Perspectives 7. PowerPivot PivotTables and PivotCharts 3D Maps 1. Enabling 3D Maps 2. Creating a New 3D Maps Tour 3. Editing a 3D Maps Tour 4. Managing Layers in a 3D Maps Tour 5. Filtering Layers 6. Setting Layer Options 7. Managing Scenes 8. Custom 3D Maps 9. Custom Regions 10. World Map Options 11. Inserting 3D Map Objects 12. Previewing a Scene 13. Playing a 3D Maps Tour 14. Creating a Video of a 3D Maps Tour 15. 3D Maps Options Slicers and Timelines 1. Inserting and Deleting Slicers 2. Modifying Slicers 3. Inserting and Deleting Timelines 4. Modifying Timelines Security Features 1. Unlocking Cells 2. Worksheet Protection 3. Workbook Protection 4. Password Protecting Excel Files Making Macros 1. Recording Macros 2. Running and Deleting Recorded Macros 3. The Personal Macro Workbook
Publisher: TeachUcomp Inc.
ISBN:
Category : Computers
Languages : en
Pages : 453
Book Description
Complete classroom training manual for Microsoft Excel 2019. 453 pages and 212 individual topics. Includes practice exercises and keyboard shortcuts. You will learn how to create spreadsheets and advanced formulas, format and manipulate spreadsheet layout, sharing and auditing workbooks, create charts, maps, macros, and much more. Topics Covered: Getting Acquainted with Excel 1. About Excel 2. The Excel Environment 3. The Title Bar 4. The Ribbon 5. The “File” Tab and Backstage View 6. Scroll Bars 7. The Quick Access Toolbar 8. Touch Mode 9. The Formula Bar 10. The Workbook Window 11. The Status Bar 12. The Workbook View Buttons 13. The Zoom Slider 14. The Mini Toolbar 15. Keyboard Shortcuts File Management 1. Creating New Workbooks 2. Saving Workbooks 3. Closing Workbooks 4. Opening Workbooks 5. Recovering Unsaved Workbooks 6. Opening a Workbook in a New Window 7. Arranging Open Workbook Windows 8. Freeze Panes 9. Split Panes 10. Hiding and Unhiding Workbook Windows 11.Comparing Open Workbooks 12. Switching Open Workbooks 13. Switching to Full Screen View 14. Working With Excel File Formats 15. AutoSave Online Workbooks Data Entry 1. Selecting Cells 2. Entering Text into Cells 3. Entering Numbers into Cells 4. AutoComplete 5. Pick from Drop-Down List 6. Flash Fill 7. Selecting Ranges 8. Ranged Data Entry 9. Using AutoFill Creating Formulas 1. Ranged Formula Syntax 2. Simple Formula Syntax 3. Writing Formulas 4. Using AutoSum 5. Inserting Functions 6. Editing a Range 7. Formula AutoCorrect 8. AutoCalculate 9. Function Compatibility Copying & Pasting Formulas 1. Relative References and Absolute References 2. Cutting, Copying, and Pasting Data 3. AutoFilling Cells 4. The Undo Button 5. The Redo Button Columns & Rows 1. Selecting Columns & Rows 2. Adjusting Column Width and Row Height 3. Hiding and Unhiding Columns and Rows 4. Inserting and Deleting Columns and Rows Formatting Worksheets 1. Formatting Cells 2. The Format Cells Dialog Box 3. Clearing All Formatting from Cells 4. Copying All Formatting from Cells to Another Area Worksheet Tools 1. Inserting and Deleting Worksheets 2. Selecting Multiple Worksheets 3. Navigating Worksheets 4. Renaming Worksheets 5. Coloring Worksheet Tabs 6. Copying or Moving Worksheets Setting Worksheet Layout 1. Using Page Break Preview 2. Using the Page Layout View 3. Opening The Page Setup Dialog Box 4. Page Settings 5. Setting Margins 6. Creating Headers and Footers 7. Sheet Settings Printing Spreadsheets 1. Previewing and Printing Worksheets Helping Yourself 1. Using Excel Help 2. The Tell Me Bar 3. Smart Lookup Creating 3D Formulas 1. Creating 3D Formulas 2. 3D Formula Syntax 3. Creating 3D Range References Named Ranges 1. Naming Ranges 2. Creating Names from Headings 3. Moving to a Named Range 4. Using Named Ranges in Formulas 5. Naming 3D Ranges 6. Deleting Named Ranges Conditional Formatting and Cell Styles 1. Conditional Formatting 2. Finding Cells with Conditional Formatting 3. Clearing Conditional Formatting 4. Using Table and Cell Styles Paste Special 1. Using Paste Special 2. Pasting Links Sharing Workbooks 1. About Co-authoring and Sharing Workbooks 2. Co-authoring Workbooks 3. Adding Shared Workbook Buttons in Excel 4. Traditional Workbook Sharing 5. Highlighting Changes 6. Reviewing Changes 7. Using Comments and Notes 8. Compare and Merge Workbooks Auditing Worksheets 1. Auditing Worksheets 2. Tracing Precedent and Dependent Cells 3. Tracing Errors 4. Error Checking 5. Using the Watch Window 6. Cell Validation Outlining Worksheets 1. Using Outlines 2. Applying and Removing Outlines 3. Applying Subtotals Consolidating Worksheets 1. Consolidating Data Tables 1. Creating a Table 2. Adding an Editing Records 3. Inserting Records and Fields 4. Deleting Records and Fields Sorting Data 1. Sorting Data 2. Custom Sort Orders Filtering Data 1. Using AutoFilters 2. Using the Top 10 AutoFilter 3. Using a Custom AutoFilter 4. Creating Advanced Filters 5. Applying Multiple Criteria 6. Using Complex Criteria 7. Copying Filter Results to a New Location 8. Using Database Functions Using What-If Analysis 1. Using Data Tables 2. Using Scenario Manager 3. Using Goal Seek 4. Forecast Sheets Table-Related Functions 1. The Hlookup and Vlookup Functions 2. Using the IF, AND, and OR Functions 3. The IFS Function Sparklines 1. Inserting and Deleting Sparklines 2. Modifying Sparklines Creating Charts In Excel 1. Creating Charts 2. Selecting Charts and Chart Elements 3. Adding Chart Elements 4. Moving and Resizing Charts 5. Changing the Chart Type 6. Changing the Data Range 7. Switching Column and Row Data 8. Choosing a Chart Layout 9. Choosing a Chart Style 10. Changing Color Schemes 11. Printing Charts 12. Deleting Charts Formatting Charts in Excel 1. Formatting Chart Objects 2. Inserting Objects into a Chart 3. Formatting Axes 4. Formatting Axis Titles 5. Formatting a Chart Title 6. Formatting Data Labels 7. Formatting a Data Table 8. Formatting Error Bars 9. Formatting Gridlines 10. Formatting a Legend 11. Formatting Drop and High-Low Lines 12. Formatting Trendlines 13. Formatting Up/Down Bars 14. Formatting the Chart and Plot Areas 15. Naming Charts 16. Applying Shape Styles 17. Applying WordArt Styles 18. Saving Custom Chart Templates Data Models 1. Creating a Data Model from External Relational Data 2. Creating a Data Model from Excel Tables 3. Enabling Legacy Data Connections 4. Relating Tables in a Data Model 5. Managing a Data Model PivotTables and PivotCharts 1. Creating Recommended PivotTables 2. Manually Creating a PivotTable 3. Creating a PivotChart 4. Manipulating a PivotTable or PivotChart 5. Changing Calculated Value Fields 6. Formatting PivotTables 7. Formatting PivotCharts 8. Setting PivotTable Options 9. Sorting and Filtering Using Field Headers PowerPivot 1. Starting PowerPivot 2. Managing the Data Model 3. Calculated Columns and Fields 4. Measures 5. Creating KPIs 6. Creating and Managing Perspectives 7. PowerPivot PivotTables and PivotCharts 3D Maps 1. Enabling 3D Maps 2. Creating a New 3D Maps Tour 3. Editing a 3D Maps Tour 4. Managing Layers in a 3D Maps Tour 5. Filtering Layers 6. Setting Layer Options 7. Managing Scenes 8. Custom 3D Maps 9. Custom Regions 10. World Map Options 11. Inserting 3D Map Objects 12. Previewing a Scene 13. Playing a 3D Maps Tour 14. Creating a Video of a 3D Maps Tour 15. 3D Maps Options Slicers and Timelines 1. Inserting and Deleting Slicers 2. Modifying Slicers 3. Inserting and Deleting Timelines 4. Modifying Timelines Security Features 1. Unlocking Cells 2. Worksheet Protection 3. Workbook Protection 4. Password Protecting Excel Files Making Macros 1. Recording Macros 2. Running and Deleting Recorded Macros 3. The Personal Macro Workbook