Business applications Books

Book Synopsis

Read more less

Book SynopsisRobotic Process Automation will continue its exponential growth over the next five years. This book brings a new focus on RPA's strategic potential: the innovations made possible and how to deliver through effective sourcing stakeholder-buy-in, governance, change management, and capability development practices.Table of ContentsChapter 1: Robotic Process Automation: The Diffusion of Innovation Challenge Chapter 2: Becoming Strategic with RPA Chapter 3: Start Right: RPA Sourcing, Platform and Total Value Chapter 4: Institutionalise Fast: Gaining Stakeholder Buy-In and Governance Chapter 5: Institutionalise Fast: Change Management and Capability Development Chapter 6: On The Maturity Path: Institutionalise and Innovate Chapter 7: In Their Own Words: Manufacturing, Retail and Telecommunications Chapter 8: In Their Own Words: Financial, Insight, Health and Business Services

Read more less

Book Synopsis Covers Word, Excel, PowerPoint, and Outlook Format Word documents for maximum visual impact Build powerful, reliable Excel workbooks for analysis and reporting Prepare highly effective PowerPoint presentations Use Outlook to organize your email, calendar, and contacts Includes downloadable practice files Table of ContentsPart 1: Microsoft Office (Microsoft 365 Apps) 1: Explore Office 2: Create and manage files Part 2: Microsoft Word 3: Modify the structure and appearance of text 4: Collaborate on documents 5: Merge data with documents and labels Part 3: Excel 6: Perform calculations on data 7: Manage worksheet data 8: Reorder and summarize data 9: Analyze alternative data sets Part 4: PowerPoint 10: Create and manage slides 11: Insert and manage simple graphics 12: Add sound and movement to slides Part 5: Microsoft Outlook 13: Send and receive email messages 14: Organize your Inbox 15: Manage scheduling Appendix: Keyboard shortcuts

Read more less

Book SynopsisEvolving digital communication, and the way workers use it to interact with each other, is a constant feature of the workplace. However, the Covid-19 pandemic has dramatically altered the way that millions of people around the world work, and this has led to a considerable rise in the number of people using remote working options such as collaborative software and video communication.Microsoft (MS) Teams has emerged as one of the most powerful and flexible tools for linking workers in an organization, whether they are in an office environment or working remotely. Teams can also be used in a school or higher education setting if students have to access classes remotely. Teams can be used to create dedicated groups of people (teams), who can then interact with each other on specific subjects. This interaction can include text chats, video calls, document sharing and even knowledge Wikis. MS Teams is a comprehensive work tool and at first sight it can seem somewhat daunting. However, Microsoft Teams in easy steps is the perfect guide to understanding Teams and becoming a fully-integrated team player. The book looks at all of areas of using Teams, including: Obtaining TeamsLearning the Teams interfaceGetting started with creating and joining teamsExpanding the functionality of Teams with the use of ChannelsUsing Chat to communicate with colleaguesJoining and scheduling meetingsUsing video to communicate with individuals and groupsSharing documents for a fully collaborative experience with TeamsIncreasing the options within Teams through the use of appsExpanding the knowledge base of your organization with customized WikisMicrosoft Teams in easy steps is the book to help you keep up with the constantly evolving workplace, and ensure that you are not left behind in any aspect of a team-working environment.

Read more less

Book SynopsisComputing Essentials adds a focus on the growing impact of AI tools on industries andcareers, ethical considerations of AI, AI presence in social media, andinnovative uses of AI. These concepts have been incorporated into the maintext, as well as the Privacy, Ethics, Community, Making IT Work for You, and ALook to the Future features.

Read more less

Book Synopsis

Read more less

Book SynopsisSteve McConnell is recognized as one of the premier authors and voices in the development community. He is Chief Software Engineer of Construx Software and was the lead developer of Construx Estimate and of SPC Estimate Professional, winner of Software Development magazine's Productivity Award. He is the author of several books, including Code Complete and Rapid Development, both honored with Software Development magazine's Jolt Award.Table of ContentsWelcome to software construction Metaphors for a richer understanding of software development Measure twice, cut once: Upstream prerequisites Key construction decisions Design in construction Working classes High-Quality routines Defensive programming The Pseudocode programming process General issues in using variables The power of variable names Fundamental data types Unusual data types Organizing straight-line code Using conditionals Controlling loops Unusual control structures Table driven methods General control issues The software-quality landscape Collaborative construction Developer testing Debugging refactoring Code tuning strategies How program size affects construction Integration Programming tools Layout & style Self documenting code Personal character Themes in software craftsmanship

Read more less

Book SynopsisThis book is for people worrying about their sinking ship. Based on experience, it is a guide for navigating the blockers, buzzwords and bloody-mindedness that doom any analogue organisation trapped into thinking that while the internet has changed the world, it won't change their world. Companies that grew up on the web have changed our expectations of the services we rely on. We demand simplicity, speed and low cost. Organizations founded before the Internet aren't keeping up - despite spending millions on IT, marketing and 'innovation'. This revised, expanded second edition of Digital Transformation at Scale is a guide to building a digital institution. It explains how a growing band of reformers in businesses and governments around the world have helped their organizations pivot to this new way of working, and what lessons others can learn from their experience. It is based on the authors' experience designing and helping to deliver the UK's Government Digital Service (GDS). The GDS was a new institution made responsible for the digital transformation of government, designing public services for the Internet era. It snipped £4 billion off the government's technology bill, opened up public sector contracts to thousands of new suppliers, and delivered online services so good that citizens chose to use them over the offline alternatives, without a big marketing campaign. Other countries and companies noticed, with the GDS model now being copied around the world.Trade Review"Now more than ever we need to take the chance to shape the digital world as it shapes us. All governments and large organisations must take part. The story in this powerful book is essential reading." — Martha Lane Fox, Baroness Lane-Fox of Soho; "Business transformation is hard. Government transformation is harder. But both must make the transition to the digital age if they are to thrive. Digital Transformation at Scale is written by those who know how it’s done, because they’ve led that transformation. This is THE invaluable guide to bringing legacy institutions into the 21st century." — Tim O’Reilly, Founder and CEO, O’Reilly Media; "The transformation the authors led in the UK sparked change in governments around the world, including the Obama White House. Their approach broke open decades of dysfunction and waste and made the public believe in government. And that belief is foundational to our democracy." — Jen Pahlka, Executive Director of Code for America; "The Government Digital Service was one of the great unsung triumphs of the last parliament. This book is indispensable for any leader looking to emulate that success." — David Cameron, Prime Minister of the United Kingdom (2010–16); "An important and timely book. Dealing with government online should be as easy as ordering from Amazon. The UK model – acting like a start-up rather than a traditional government agency – is one from which all big organisations should learn." — Malcolm Turnbull, Prime Minister of Australia (2015–18)

Read more less

Book SynopsisTable of ContentsIntroduction 1 About This Book 2 Foolish Assumptions 3 Icons Used in This Book 3 Beyond the Book 4 Where to Go from Here 4 Part 1: Supercharged Reporting with Power Pivot 5 Chapter 1: Thinking Like a Database 7 Exploring the Limits of Excel and How Databases Help 7 Scalability 8 Transparency of analytical processes 9 Separation of data and presentation 10 Getting to Know Database Terminology 11 Databases 11 Tables 11 Records, fields, and values 12 Queries 13 Understanding Relationships 13 Chapter 2: Introducing Power Pivot 17 Understanding the Power Pivot Internal Data Model 18 Linking Excel Tables to Power Pivot 20 Preparing Excel tables 21 Adding Excel Tables to the data model 22 Creating relationships between Power Pivot tables 24 Managing existing relationships 26 Using the Power Pivot data model in reporting 27 Chapter 3: The Pivotal Pivot Table 29 Introducing the Pivot Table 30 Defining the Four Areas of a Pivot Table 30 Values area 30 Row area 31 Column area 31 Filter area 32 Creating Your First Pivot Table 33 Changing and rearranging a pivot table 36 Adding a report filter 37 Keeping the pivot table fresh 38 Customizing Pivot Table Reports 40 Changing the pivot table layout 40 Customizing field names 41 Applying numeric formats to data fields 42 Changing summary calculations 43 Suppressing subtotals 44 Showing and hiding data items 47 Hiding or showing items without data 49 Sorting the pivot table 51 Understanding Slicers 52 Creating a Standard Slicer 54 Getting Fancy with Slicer Customizations 56 Size and placement 56 Data item columns 57 Miscellaneous slicer settings 58 Controlling Multiple Pivot Tables with One Slicer 58 Creating a Timeline Slicer 59 Chapter 4: Using External Data with Power Pivot 63 Loading Data from Relational Databases 64 Loading data from SQL Server 64 Loading data from Microsoft Access databases 70 Loading data from other relational database systems 72 Loading Data from Flat Files 75 Loading data from external Excel files 76 Loading data from text files 78 Loading data from the Clipboard 81 Loading Data from Other Data Sources 82 Refreshing and Managing External Data Connections 83 Manually refreshing Power Pivot data 83 Setting up automatic refreshing 84 Preventing Refresh All 85 Editing the data connection 86 Chapter 5: Working Directly with the Internal Data Model 89 Directly Feeding the Internal Data Model 89 Managing Relationships in the Internal Data Model 95 Managing Queries and Connections 96 Creating a New Pivot Table Using the Internal Data Model 97 Filling the Internal Data Model with Multiple External Data Tables 98 Chapter 6: Adding Formulas to Power Pivot 103 Enhancing Power Pivot Data with Calculated Columns 103 Creating your first calculated column 104 Formatting calculated columns 105 Referencing calculated columns in other calculations 106 Hiding calculated columns from end users 107 Utilizing DAX to Create Calculated Columns 108 Identifying DAX functions that are safe for calculated columns 108 Building DAX-driven calculated columns 110 Month sorting in Power Pivot–driven pivot tables 112 Referencing fields from other tables 113 Nesting functions 115 Understanding Calculated Measures 116 Creating a calculated measure 116 Editing and deleting calculated measures 118 Free Your Data with Cube Functions 119 Chapter 7: Diving into DAX 121 DAX Language Fundamentals 121 Using DAX operators 125 Applying conditional logic in DAX 126 Working with DAX aggregate functions 128 Exploring iterator functions and row context 129 Understanding Filter Context 133 Getting context transitions with the CALCULATE function 135 Adding flexibility with the FILTER function 137 Part 2: Wrangling Data with Power Query 141 Chapter 8: Introducing Power Query 143 Power Query Basics 144 Starting the query 144 Understanding query steps 150 Refreshing Power Query data 152 Managing existing queries 153 Understanding Column-Level Actions 155 Understanding Table Actions 157 Chapter 9: Power Query Connection Types 159 Importing Data from Files 160 Getting data from Excel workbooks 160 Getting data from CSV and text files 161 Getting data from PDF files 163 Getting data from folders 164 Importing Data from Database Systems 165 A connection for every database type 165 Getting data from other data systems 167 Walk-through: Getting data from a database 168 Managing Data Source Settings 170 Data Profiling with Power Query 171 Data Profiling options 172 Data Profiling quick actions 173 Chapter 10: Transforming Your Way to Better Data 175 Completing Common Transformation Tasks 176 Removing duplicate records 176 Filling in blank fields 178 Concatenating columns 179 Changing case 181 Finding and replacing specific text 181 Trimming and cleaning text 183 Extracting the left, right, and middle values 184 Splitting columns using character markers 187 Pivoting and unpivoting fields 189 Creating Custom Columns 193 Concatenating with a custom column 195 Understanding data type conversions 196 Spicing up custom columns with functions 197 Adding conditional logic to custom columns 199 Grouping and Aggregating Data 201 Working with Custom Data Types 203 Chapter 11: Making Queries Work Together 207 Reusing Query Steps 208 Understanding the Append Feature 211 Creating the needed base queries 212 Appending the data 213 Understanding the Merge Feature 216 Understanding Power Query joins 216 Merging queries 217 Understanding Fuzzy Match 221 Chapter 12: Extending Power Query with Custom Functions 225 Creating and Using a Basic Custom Function 225 Creating a Function to Merge Data from Multiple Excel Files 229 Creating Parameter Queries 236 Preparing for a parameter query 236 Creating the base query 238 Creating the parameter query 239 Part 3: The Part of Tens 243 Chapter 13: Ten Ways to Improve Power Pivot Performance 245 Limit the Number of Rows and Columns in Your Data Model Tables 246 Use Views Instead of Tables 246 Avoid Multi-Level Relationships 246 Let the Back-End Database Servers Do the Crunching 247 Beware of Columns with Many Unique Values 248 Limit the Number of Slicers in a Report 248 Create Slicers Only on Dimension Fields 249 Disable the Cross-Filter Behavior for Certain Slicers 250 Use Calculated Measures Instead of Calculated Columns 250 Upgrade to 64-Bit Excel 251 Chapter 14: Ten Tips for Working with Power Query 253 Getting Quick Information from the Queries & Connections Pane 253 Organizing Queries in Groups 254 Selecting Columns in Queries Faster 255 Renaming Query Steps 256 Quickly Creating Reference Tables 257 Viewing Query Dependencies 258 Setting a Default Load Behavior 259 Preventing Automatic Data Type Changes 259 Disabling Privacy Settings to Improve Performance 261 Disabling Relationship Detection 261 Index 263

Read more less

Book SynopsisOne of the most influential data visualization booksupdated with new techniques, technologies, and examples Visualize This demonstrates how to explain data visually, so that you can present and communicate information in a way that is appealing and easy to understand. Today, there is a continuous flow of data available to answer almost any question. Thoughtful charts, maps, and analysis can help us make sense of this data. But the data does not speak for itself. As leading data expert Nathan Yau explains in this book, graphics provide little value unless they are built upon a firm understanding of the data behind them. Visualize This teaches you a data-first approach from a practical point of view. You'll start by exploring what your data has to say, and then you'll design visualizations that are both remarkable and meaningful. With this book, you'll discover what tools are available to you without becoming overwhelmed with options. You'll be exposed to a variety of software and code a

Read more less

Book SynopsisAI, Big Data and other 4th Industrial Revolution technologies are poised to wreak havoc in virtually every industry, unlocking huge productivity gains via automation of labor both manual and cognitive. Less discussed are the impacts on workers, who see the value of their skills erode, along with the menace of mass structural unemployment. How can workers assess their vulnerabilities? What can they do to improve their prospects, effective immediately? In this book, you will learn how to:- Survey new tech and decrypt their potential impacts on work - Assess your strengths and weaknesses in the face of AI, the shared economy, and other tech-propelled threats- Foment a battle plan to survive and thrive Ashley Recanati provides guidance for employees to rise above their peers and preserve their value, in a book that will interest managers and scholars, but foremost destined to ordinary workers. Trade Review“The real value of AI Battle Royale is that it casts more light than heat on a topic that is prone to sensationalism and doom-mongering in the mainstream media. … AI Battle Royale represents a huge step towards providing the measured tones we need to discuss societal issues – such as the interaction between technology evolution and employment – with a balanced, objective stance.” (E&T Engineering and Technology, November-December, 2023)Table of Contents

Read more less

Book Synopsis

Read more less

Book SynopsisTable of ContentsIntroduction 1 Part 1: Getting Started with Excel Dashboards and Reports 7 Chapter 1: Getting in the Dashboard State of Mind 9 Chapter 2: Building a Super Model 23 Chapter 3: The Pivotal Pivot Table 65 Chapter 4: Using External Data for Your Dashboards and Reports. 101 Part 2: Building Basic Dashboard Components 119 Chapter 5: Dressing Up Your Data Tables 121 Chapter 6: Sparking Inspiration with Sparklines 139 Chapter 7: Formatting Your Way to Visualizations 153 Part 3: Adding Charts to Your Dashboards 185 Chapter 8: Charts That Show Trending 187 Chapter 9: Grouping and Bucketing Data 211 Chapter 10: Displaying Performance against a Target 231 Part 4: Advanced Reporting Techniques 247 Chapter 11: Giving Users an Interactive Interface 249 Chapter 12: Adding Interactivity with Pivot Slicers 283 Chapter 13: Sharing Your Workbook with the Outside World 303 Part 5: The Part of Tens 323 Chapter 14: Ten Chart Design Principles 325 Chapter 15: Ten Questions to Ask Before Distributing Your Dashboard 339 Index 345

Read more less

Book SynopsisJoan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997, guiding the translation of technical information and requirements into useful, relevant, and measurable resources for people seeking certification of their computer skills or who simply want to get things done efficiently. She has written more than 50 books about Windows, Office, and SharePoint technologies, including dozens of Step by Step books and five generations of Microsoft Office Specialist certification study guides. Students who use the GO! with Microsoft Office textbook products may overhear her cheerfully demonstrating Office features in the videos that accompany the series. Table of ContentsIntroduction Part 1: Create and format workbooks 1 Set up a workbook 2 Work with data and Excel tables 3 Perform calculations on data 4 Change workbook appearance Part 2: Analyze and present data 5 Manage worksheet data 6 Reorder and summarize data 7 Combine data from multiple sources 8 Analyze alternative data sets 9 Create charts and graphics. 207 10 Create PivotTables and PivotCharts Part 3: Collaborate and share in Excel 11 Print worksheets and charts 12 Automate tasks and input 13 Work with other Microsoft 365 apps 14 Collaborate with colleagues Part 4: Perform advanced analysis 15 Perform business intelligence analysis 16 Create forecasts and visualizations

Read more less

Book SynopsisAbout the Author: Adam Freeman is an experienced IT professional who started his career as a programmer. He has held senior positions in a range of companies, most recently serving as Chief Technology Officer and Chief Operating Officer of a global bank. He has written 49 programming books, focusing mostly on web application development. This industry-leading guide to ASP.NET Core teaches you everything they need to know to create easy, extensible, and cloud-native web applications. For .NET web developers looking to learn about ASP.NET s key tools and techniques.

Read more less

Book SynopsisLarry Ullman is a writer, Web and software developer, trainer, instructor, speaker, and consultant. He has written more than 20 books, which have sold over 400,000 copies worldwide in more than 20 languages. As his readers, students, and co-workers can attest, Larry's strength is in translating geek into English: converting the technical and arcane into something comprehensible and useful. Table of Contents Chapter 1 Introduction to PHP Chapter 2 Programming with PHP Chapter 3 Creating Dynamic Web Sites Chapter 4 Introduction to MySQL Chapter 5 Introduction to SQL Chapter 6 Database Design Chapter 7 Advanced SQL and MySQL Chapter 8 Error Handling and Debugging Chapter 9 Using PHP with MySQL Chapter 10 Common Programming Techniques Chapter 11 Web Application Development Chapter 12 Cookies and Sessions Chapter 13 Security Methods Chapter 14 Perl-Compatible Regular Expressions Chapter 15 Introducing jQuery Chapter 16 An OOP Primer Chapter 17 Example–Message Board Chapter 18 Example–User Registration Appendix A Installation

Read more less

Book SynopsisTable of ContentsPreface xxxix Acknowledgments xliii 1 Basic Optical Calculations 1 1.1 Introduction 1 1.2 Wave Propagation 2 1.3 CalculatingWave Propagation in Real Life 7 1.4 Detection 26 1.5 Coherent Detection 26 1.6 Interferometers 29 1.7 Photon Budgets and Operating Specifications 30 1.8 Signal Processing Strategy 36 2 Sources And Illuminators 41 2.1 Introduction 41 2.2 The Spectrum 41 2.3 Radiometry 43 2.4 Continuum Sources 43 2.5 Interlude: Coherence 46 2.6 More Sources 50 2.7 Incoherent Line Sources 55 2.9 Lasers 57 2.10 Gas Lasers 59 2.11 Solid-State Lasers 59 2 Diode Lasers 61 2.13 Laser Noise 69 3 Optical Detection 81 3.1 Introduction 81 3.2 Signal-to-Noise Ratios 82 3.3 Detector Figures of Merit 83 3.5 Photomultipliers 100 3.6 Thermal Detectors 114 3.7 Image Intensifiers 115 3.9 How Do I Know Which Noise Source Dominates? 124 3.10 Hacks 129 4 Lenses, Prisms, and Mirrors 137 4.1 Introduction 137 4.2 Optical Materials 137 4.4 Surface Quality 141 4.5 Windows 142 4.6 Pathologies of Optical Elements 143 4.7 Fringes 143 4.8 Mirrors 147 4.10 Prism Pathologies 153 4.11 Lenses 154 2 Complex Lenses 158 3 Other Lenslike Devices 162 5 Coatings, Filters, and Surface Finishes 165 5.1 Introduction 165 5.2 Metal Mirrors 165 5.4 Simple Coating Theory 171 5.5 Moth-Eye Finishes 179 5.6 Absorptive Filters 180 5.7 Beam Dumps and Baffles 182 5.8 White Surfaces and Diffusers 186 6 Polarization 191 6.1 Introduction 191 6.2 Polarization of Light 191 6.3 Interaction of Polarization with Materials 193 6.4 Absorption Polarizers 197 6.5 Brewster Polarizers 197 6.6 Birefringent Polarizers 198 6.7 Double-Refraction Polarizers 199 6.8 TIR Polarizers 202 6.9 Retarders 203 6.10 Polarization Control 206 7 Exotic Optical Components 211 Introduction 211 Gratings 211 Grating Pathologies 214 Types of Gratings 215 Resolution of Grating Instruments 218 Fine Points of Gratings 219 Holographic Optical Elements 222 Photonic Crystals and Metamaterials 223 Retroreflective Materials 224 7.10 Scanners 225 7.11 Modulators 231 8 FiberOptics239 8.1 Introduction 239 8.2 Fiber Characteristics 239 8.3 Fiber Theory 242 8.4 Fiber Types 247 8.5 Other Fiber Properties 251 8.6 Working with Fibers 255 8.7 Fiber Devices 260 8.8 Diode Lasers and Fiber Optics 264 8.9 Fiber Optic Sensors 264 8.10 Intensity Sensors 265 8.11 Spectrally Encoded Sensors 266 8.12 Polarimetric Sensors 269 8.13 Fiber Interferometers 270 8.14 Two-Beam Fiber Interferometers 270 8.15 Multiple Beam Fiber Interferometers 272 8.17 Multiplexing and Smart Structures 276 8.18 Fiber Sensor Hype 276 9 Optical Systems 279 9.1 Introduction 279 9.2 What, Exactly, Does a Lens Do? 279 9.3 Diffraction 288 9.4 Aberrations 300 9.5 Representing Aberrations 303 9.6 Optical Design Advice 306 9.7 Practical Applications 308 9.8 Illuminators 311 10 Optical Measurements 315 10.1 Introduction 315 10.2 Grass on the Empire State Building 315 10.3 Detection Issues: When Exactly Is Background Bad? 318 1 Measure the Right Thing 322 10.5 Getting More Signal Photons 324 10.6 Reducing the Background Fluctuations 326 10.7 Optically Zero-Background Measurements 328 10.8 Spectrally Resolved Measurements 329 10.9 Electronically Zero-Background Measurements 333 10.10 Labeling Signal Photons 336 10.11 Closure 341 11 Designing Electro-Optical Systems 343 11.1 Introduction 343 11.2 Do You ReallyWant To Do This? 343 11.3 Very Basic Marketing 350 11.4 Classes of Measurement 352 11.5 Technical Taste 354 11.6 Instrument Design 357 11.7 Guiding Principles 361 11.8 Design for Alignment 364 11.9 Turning a Prototype into a Product 367 12 Building Optical Systems 371 12.1 Introduction 371 12.2 Construction Style 371 12.3 Build What You Designed 372 12.4 Assembling Lab Systems 373 12.6 Collimating Beams 381 12.7 Focusing 383 12.8 Alignment and Testing 385 12.9 Prototypes 386 12.10 Aligning Beams with Other Beams 387 12.11 Advanced Tweaking 390 12.13 Adhesives 397 12.14 Cleaning 400 12.15 Environmental Considerations 402 13 Signal Processing 405 13.1 Introduction 405 13.2 Analog Signal Processing Theory 406 13.4 Amplifiers 416 13.5 Departures From Linearity 416 13.6 Noise and Interference 420 13.7 Frequency Conversion 435 13.8 Filtering 438 13.9 Signal Detection 447 13.10 Reducing Interference and Noise 450 13.11 Data Acquisition and Control 452 14 Electronic Building Blocks 457 14.1 Introduction 457 14.2 Resistors 457 14.3 Capacitors 460 14.4 Transmission Lines 470 14.5 Transmission Line Devices 476 14.6 Diodes 477 14.7 Bipolar Junction Transistors 479 14.8 Field-Effect Transistors (FETs) 486 14.9 Heterojunction FETs 487 14.10 Signal Processing Components 488 14.11 Digitizers 496 14.12 Analog Behavior of Digital Circuits 505 15 Electronic Subsystem Design 507 15.1 Introduction 507 15.2 Design Approaches 507 15.3 Perfection 514 15.4 Feedback Loops 516 15.5 Local Feedback 522 15.6 Signal Detectors 522 15.7 Phase-Locked Loops 530 15.8 Calibration 535 15.9 Filters 537 15.10 Other Stuff 540 15.11 More Advanced Feedback Techniques 542 15.12 Hints 544 15.13 Linearizing 545 15.17 Bulletproofing 553 15.18 Interference 557 15.19 Reliable Designs 558 16 Electronic Construction Techniques 559 16.1 Introduction 559 16.2 Circuit Strays 559 16.3 Circuit Boards 560 16.4 Stray Coupling 563 16.5 Ground Plane Construction 563 16.6 Technical Noise and Interference 566 16.7 Product Construction 572 16.8 Getting Ready 574 16.9 Prototyping 576 16.10 Surface Mount Prototypes 582 16.11 Prototyping Filters 585 16.12 Tuning, or, You Can’t Hit What You Can’t See 587 17 Digital Signal Processing 591 17.1 Introduction 591 17.2 Elementary Operations 592 17.3 Dead Time Correction 595 17.4 Fourier Domain Techniques 595 17.5 The Fast Fourier Transform 602 17.6 Power Spectrum Estimation 608 17.7 Digital Filtering 612 17.8 Deconvolution 615 17.9 Resampling 617 17.10 Fixing Space-Variant Instrument Functions 618 17.11 Finite Precision Effects 619 17.12 Pulling Data Out of Noise 620 18 Front Ends 627 18.1 Introduction 627 18.2 Photodiode Front Ends 628 18.3 Key Idea: Reduce the Swing Across Cd 630 18.4 Transimpedance Amplifiers 631 18.5 External Input Stages 635 18.6 How to Go Faster 648 18.7 Advanced Photodiode Front Ends 652 18.8 Other Types of Front End 658 18.9 Hints 660 19 Bringing Up the System 665 19.1 Introduction 665 19.2 Avoiding Catastrophe 667 19.3 Debugging and Troubleshooting 670 19.4 Getting Ready 671 19.5 Indispensable Equipment 673 19.6 Debugging Pickup and Interference Problems 676 19.6.1 Test Setups 676 19.7 Digital Troubleshooting 677 19.8 Analog Electronic Troubleshooting 678 19.9 Oscillations 681 19.10 Other Common Problems 683 19.11 Debugging and Troubleshooting Optical Subsystems 685 19.12 Localizing the Problem 688 20 Thermal Control 695 20.1 Introduction 695 20.2 Thermal Problems and Solutions 696 20.3 Heat Flow 699 20.4 Insulation 705 20.7 Heat Sinks 716 23 Local Feedback Loops 723 20.9 Temperature Controllers 725 Appendix A Good Books 735 A.1 Why Books? 735 A.2 Good Books for Instrument Builders 735 Notation 743 Physical Constants and Rules of Thumb 745 Index 747

Read more less

Book SynopsisTable of ContentsIntroduction 1 About This Book 1 What’s Not in This Book 2 Foolish Assumptions 2 Icons Used in This Book 3 Beyond the Book 3 Where to Go from Here 4 Part 1: Getting Started with Project 5 Chapter 1: Project Management, MS Project, and You 7 Project Management Evolution 8 What’s in a Name: Projects, Project Management, and Project Managers 9 Project managers and Scrum masters 10 The role of the project manager 11 The role of the Scrum master 12 Introducing Microsoft Project 13 Getting to Know You 14 Navigating Ribbon tabs and the Ribbon 17 Displaying more tools 20 Tell Me What You Want to Do 22 Chapter 2: Starting the Project 23 Creating the Project Charter 24 Introducing the Work Breakdown Structure (WBS) 26 Organizing the Work 27 Starting the Project 28 Entering project information 29 Entering the WBS 31 Indenting and outdenting (a.k.a promoting and demoting) 32 Entering tasks 33 Weighing manual scheduling versus automatic scheduling 35 Inserting one project into another 37 Inserting hyperlinks 38 Chapter 3: Becoming a Task Master 41 Creating Summary Tasks and Subtasks 41 How many levels can you go? 43 The project summary task 43 Moving Tasks Up, Down, and All Around 45 Moving tasks with the drag-and-drop method 45 Moving tasks with the cut-and-paste method 46 Now You See It, Now You Don’t: Collapsing and Expanding the Task Outline 47 Showing Up Again and Again: Recurring Tasks 48 Setting Milestones 50 Deleting Tasks and Using Inactive Tasks 51 Making a Task Note 52 Chapter 4: The Codependent Nature of Tasks 55 How Tasks Become Dependent 56 Dependent tasks: Which comes first? 56 Dependency types 57 Allowing for Murphy’s Law: Lag and lead time 59 Setting the Dependency Connection 60 Adding the dependency link 60 Words to the wise 62 Understanding that things change: Deleting dependencies 64 Chapter 5: Estimating Task Time 67 You’re in It for the Duration 68 Tasks come in all flavors: Identifying task types 68 Effort-driven tasks: 1 + 1 = ½ 71 Estimating Effort and Duration 72 Estimating techniques 72 Setting the task duration 74 Controlling Timing with Constraints 76 Understanding how constraints work 76 Establishing constraints 76 Setting a deadline 78 Starting and Pausing Tasks 79 Entering the task’s start date 80 Taking a break: Splitting tasks 81 Chapter 6: Check Out This View! 83 A Project with a View 83 Navigating tabs and views 84 Scrolling around 86 Reaching a specific spot in your plan 87 More Detail about Views 88 Home base: Gantt Chart view 88 Resourceful views: Resource Sheet and Team Planner 89 Getting your timing down with the Timeline 90 Going with the flow: Network Diagram view 91 Calling up Calendar view 91 Customizing Views 92 Working with view panes 93 Modifying Network Diagram view 98 Resetting the view 100 Part 2: Managing Resources 103 Chapter 7: Creating Resources 105 Resources: People, Places, and Things 105 Becoming Resource-Full 106 Understanding resources 106 Resource types: Work, material, and cost 107 How resources affect task timing 108 Estimating resource requirements 109 The Birth of a Resource 110 Creating one resource at a time 110 Identifying resources before you know their names 112 Many hands make light work 113 Managing Resource Availability 113 Estimating and setting availability 114 When a resource comes and goes 115 Sharing Resources 116 Skimming from resource pools 116 Importing resources from Outlook 119 Chapter 8: Working with Calendars 121 Mastering Base, Project, Resource, and Task Calendars 122 Setting the base calendar for a project 122 Understanding the four calendar types 122 How calendars work 123 How one calendar relates to another 123 Scheduling with Calendar Options and Working Times 124 Setting calendar options 125 Setting exceptions to working times 126 Working with Task Calendars and Resource Calendars 128 Setting resource calendars 129 Making a change to a resource’s calendar 130 Creating a Custom Calendar Template 132 Sharing Copies of Calendars 134 Chapter 9: Assigning Resources 137 Finding the Right Resource 137 Needed: One good resource willing to work 138 Custom fields: It’s a skill 139 Making a Useful Assignation 140 Determining material and cost-resource units 140 Making assignments 141 Shaping the contour that’s right for you 145 Benefitting from a Helpful Planner 147 Chapter 10: Determining a Project’s Cost 149 How Do Costs Accrue? 150 Adding up the costs 150 When will these costs hit the bottom line? 151 Specifying Cost Information in the Project 152 You can’t avoid fixed costs 153 Entering hourly, overtime, and cost-per-use rates 154 Assigning material resources 156 Part 3: Before You Baseline 159 Chapter 11: Fine-Tuning Your Plan 161 Everything Filters to the Bottom Line 161 Setting predesigned filters 162 Putting AutoFilter to work 163 Creating do-it-yourself filters 166 Gathering Information in Groups 167 Applying predefined groups 169 Devising your own groups 169 Figuring Out What’s Driving the Project 171 Inspecting tasks 172 Handling task warnings, suggestions, and problems 173 Chapter 12: Negotiating Project Constraints 175 It’s about Time 176 Applying contingency reserve 176 Completing a task in less time 177 Getting What You Want for Less 180 The Resource Recourse 181 Checking resource availability 181 Deleting or modifying a resource assignment 183 Beating overallocations with quick-and-dirty rescheduling 184 Finding help 184 Leveling resources 185 Rescheduling the Project 188 Chapter 13: Making the Project Look Good 189 Looking Good! 190 Formatting the Gantt Chart 190 Formatting taskbars 190 Zeroing in on critical issues 194 Restyling the Gantt chart 194 Formatting Network Diagram Boxes 195 Adjusting the Layout 197 Modifying Gridlines 199 Recognizing When a Picture Can Say It All 201 Creating a Custom Text Field 202 Chapter 14: It All Begins with a Baseline 207 All about Baselines 208 Saving a baseline 208 Saving more than one baseline 210 Clearing and resetting a baseline 211 In the Interim 212 Saving an interim plan 213 Clearing and resetting an interim plan 214 Part 4: Staying on Track 217 Chapter 15: On the Right Track 219 Tracking Views 220 Setting the status date 220 Tracking status with the Task sheet 221 Using the Tracking table 221 Tracking buttons 222 Determining the percent complete 223 Tracking status with Task Usage view 224 Tracking status with Resource Usage view 224 Uh-oh — you’re in overtime 225 Specifying remaining durations for auto-scheduled tasks 226 Entering fixed-cost updates 227 Moving a Task 228 Update Project: Sweeping Changes 230 Tracking Materials 232 Tracking More than One Project 233 Chapter 16: Project Views: Observing Progress 235 Seeing Where Tasks Stand 236 Baseline versus actual progress 236 Lines of progress 236 Delving into the Detail 240 Tracking Progress Using Earned Value Management 242 Viewing the Earned Value table 244 Earned value options 244 Calculating behind the Scenes 246 An abundance of critical paths 246 Chapter 17: You’re Behind — Now What? 249 Using Project with Risk and Issue Logs 249 Documenting issues 250 Printing interim plans and baselines 250 What-If Scenarios 251 Sorting tasks 252 Filtering 253 Examining the critical path 254 Using resource leveling (again) 255 Determining which factors are driving the timing of a task 256 How Adding People or Time Affects the Project 257 Hurrying up and making modifications 257 Throwing resources at the problem 258 Shifting dependencies and task timing 259 When All Else Fails 261 Taking the time you need 261 Finding ways to cut corners 262 Chapter 18: Spreading the News: Reporting 265 Generating Standard Reports 266 What’s available on the Report tab 266 Dashboard reports 267 Creating New Reports 268 Gaining a new perspective on data with visual reports 270 Creating a visual report 270 Fine-Tuning a Report 271 Dragging, dropping, and sizing 272 Looking good! 273 Spiffing Things Up 274 Calling the Printer! 276 Working with Page Setup 277 Getting a preview 279 Finalizing your print options 280 Working on the Timeline 281 Adding tasks to the Timeline 281 Customizing the Timeline 283 Copying the Timeline 283 Part 5: Working with Sprints Projects 285 Chapter 19: Setting Up a Sprints Project 287 Creating a Sprints Project 287 Enjoying a Whole New View 290 The Task Board and Task Board sheet 291 The Sprint Planning Board and Sprint Planning sheet 292 The Current Sprint Board and Current Sprint sheet 293 The Backlog Board and the Backlog sheet 293 Adding Information to Tasks 294 Prioritizing Tasks 296 Inserting a Sprints Project into a Plan-Driven Project 296 Chapter 20: Tracking a Sprints Project 299 Viewing Your Sprints Project Data 299 Using filters to focus 300 Using tables to arrange data 300 Being a groupie 302 Sorting tasks 302 Creating Sprints Reports 303 Chapter 21: Getting Better All the Time 307 Reviewing the Project 308 Learning from your mistakes 308 Fine-tuning communication 309 Comparing Versions of a Project 310 Building on Success 312 Creating a template 312 Mastering the Organizer 314 Part 6: The Part of Tens 317 Chapter 22: Ten Golden Rules of Project Management 319 Roll with It 319 Put Your Ducks in a Row 320 Expect the Unexpected 321 Don’t Put Off until Tomorrow 322 Delegate, Delegate, Delegate 322 Document It 323 Keep the Team in the Loop 323 Measure Success 324 Maintain a Flexible Strategy 325 Learn from Your Mistakes 325 Chapter 23: Ten Cool Shortcuts in Project 327 Task Information 327 Resource Information 328 Frequently Used Functions 329 Subtasks 330 Quick Selections 330 Fill Down 331 Navigation 331 Hours to Years 331 Timeline Shortcuts 331 Quick Undo 332 Glossary 333 Index 341

Read more less

Book SynopsisMaster core Excel tools for building powerful, reliable spreadsheets with Excel 2019 Formulas and Functions. Excel expert Paul McFedries shows how to use Excel core features to solve problems and get the answers you need. Using real-world examples, McFedries helps you get the absolute most out of features and improvements ranging from AutoFill to Excel’s newest functions. Along the way, you discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation. Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions; insider insights; even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more. • Quickly create powerful spreadsheets with range names and array formulas • Use conditional formatting to instantly reveal anomalies, problems, or opportunities • Analyze your data with standard tables and PivotTables • Use complex criteria to filter data in lists • Understand correlations between data • Perform sophisticated what-if analyses • Use regression to track trends and make forecasts • Build loan, investment, and discount formulas • Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets Table of ContentsPart I—Mastering Excel formulas Chapter 1—Building basic formulas Chapter 2—Creating advanced formulas Chapter 3—Troubleshooting formulas Part II—Harnessing the power of functions Chapter 4—Understanding functions Chapter 5—Working with text functions Chapter 6—Working with logical and information functions Chapter 7—Working with lookup functions Chapter 8—Working with date and time functions Chapter 9—Working with math functions Part III—Building business formulas Chapter 10—Implementing basic business formulas Chapter 11—Building descriptive statistical formulas Chapter 12—Building inferential statistical formulas Chapter 13—Applying regression to track trends and make forecasts Chapter 14—Building loan formulas Chapter 15—Working with investment formulas Chapter 16—Building discount formulas Part IV—Building business models Chapter 17—Analyzing data with tables Chapter 18—Analyzing data with PivotTables Chapter 19—Using Excel's business modeling tools Chapter 20—Solving complex problems with Solver

Read more less

Book SynopsisTable of ContentsIntroduction 1 Part 1: Starting on a Good Note 5 Chapter 1: Introducing GarageBand for Macs and iDevices 7 Chapter 2: Equipping and Setting Up Your Recording Space 25 Chapter 3: Introducing Multitrack Recording with GarageBand 49 Part 2: Making Music on a Mac 77 Chapter 4: Getting Started 79 Chapter 5: Using Loops to Make Music 93 Chapter 6: Recording with MIDI and Software Instruments 113 Chapter 7: Recording Vocals and Acoustic Instruments with a Mic 139 Chapter 8: Recording Electric Guitars and Other Electronic Instruments 159 Part 3: Postproduction: Finishing Songs on a Mac 175 Chapter 9: Editing and Polishing Tracks 177 Chapter 10: Mixing Tracks into Songs 203 Chapter 11: Mastering Mastering 217 Part 4: Making Music with Your iDevice 229 Chapter 12: Getting Started 231 Chapter 13: Making Music with Live Loops 247 Chapter 14: Laying Down Software Instrument Tracks 263 Chapter 15: Recording Vocals and Acoustic Instruments with a Mic 279 Chapter 16: Recording Guitars and Basses 297 Part 5: Postproduction: Finishing Songs on an iDevice 313 Chapter 17: Editing and Polishing Tracks 315 Chapter 18: Mixing Tracks into Songs 333 Chapter 19: Mastering Mastering 347 Chapter 20: File Compression and Your Music 353 Part 6: The Part of Tens 365 Chapter 21: Ten Ways to Improve GarageBand’s Performance 367 Chapter 22: Ten Ways to Take Your Recordings to the Next Level 377 Chapter 23: Ten Useful Websites 385 Index 391

Read more less

Book SynopsisMaster the ins and outs of Google's free-to-use office and productivity software Teach Yourself VISUALLY Google Workspace delivers the ultimate guide to getting the most out of Google's Workspace cloud software. Accomplished author Guy Hart-Davis offers readers the ability to tackle a huge number of everyday productivity problems with Google's intuitive collection of online tools. With over 700 full-color screenshots included to help you learn, you'll discover how to: Manage your online Google CalendarMaster the files and folders in your Google Drive storageCustomize your folders and navigate your Gmail accountCreate perfect spreadsheets, presentations, and documents in Google Sheets, Slides, and Docs Perfect for anyone who hopes to make sense of Google's highly practical and free online suite of tools, Teach Yourself VISUALLY Google Workspace also belongs on the bookshelves of those who already find themselves using Workspace and just want to get more out of it.Table of ContentsChapter 1: Getting Started with G Suite Chapter 2: Managing Files and Folders in Drive Chapter 3: Performing Common Tasks in Docs, Sheets, and Slides Chapter 4: Inserting Objects in Docs, Sheets, and Slides Chapter 5: Working in Docs Chapter 6: Share and Collaborate on Files Chapter 7: Working in Sheets Chapter 8: Learning Advanced Sheets Features Chapter 9: Working in Slides Chapter 10: Sending and Receiving E-Mail Chapter 11: Organizing Your Life Chapter 12: Creating Forms

Read more less

Book SynopsisSay hello to Office productivity with this one-stop reference With Office 2021 All-in-One For Dummies, you can get up and running with Microsoft's legendary software suite. This update covers all the tweaks you can find in the latest version of Word, Excel, PowerPoint, Outlook, and Teams. You'll also learn how to make these apps work harder for you, because we dig deep into the tips and features that casual Office users might not know about. This edition also offers expanded coverage of Teams and other collaborative tools, so you can nail working from home, or just get a few of those meetings out of the way without having to leave your desk. How can you quickly give documents the same format in Word? What was that one useful Excel function, again? And how does setting up a meeting on Teams work? Office 2021 All-in-One For Dummies serves up quick and simple answers to these questions, along with hundreds of other answers you're expected to know when you work in Office. Learn how Microsoft Office works and get the most out of Word, Excel, PowerPoint, Outlook, and TeamsMake amazing charts and graphs that you can plug into your documents, spreadsheets, and presentationsGet better at working collaboratively with file sharing options and other neat featuresDo more, faster with expert tips and guidance on the full suite of Office software for 2021 Whether you're new to Office or just need a refresher for the newest updates, the nine mini-books inside are your keys to getting stuff done.Table of ContentsIntroduction 1 Book 1: Common Microsoft Office Tasks 5 Chapter 1: Office Nuts and Bolts 7 Chapter 2: Wrestling with the Text 27 Chapter 3: Speed Techniques Worth Knowing About 47 Book 2: Word 2021 55 Chapter 1: Speed Techniques for Using Word 57 Chapter 2: Laying Out Text and Pages 77 Chapter 3: Word Styles 103 Chapter 4: Constructing the Perfect Table 121 Chapter 5: Taking Advantage of the Proofing Tools 145 Chapter 6: Desktop Publishing with Word 165 Chapter 7: Getting Word's Help with Office Chores 183 Chapter 8: Tools for Reports and Scholarly Papers 203 Book 3: Excel 2021 227 Chapter 1: Up and Running with Excel 229 Chapter 2: Refining Your Worksheet 247 Chapter 3: Formulas and Functions for Crunching Numbers 261 Chapter 4: Making a Worksheet Easier to Read and Understand 293 Chapter 5: Advanced Techniques for Analyzing Data 311 Book 4: PowerPoint 2021 329 Chapter 1: Getting Started in PowerPoint 331 Chapter 2: Fashioning a Look for Your Presentation 353 Chapter 3: Entering the Text 367 Chapter 4: Making Your Presentations Livelier 385 Chapter 5: Delivering a Presentation 401 Book 5: Outlook 2021 421 Chapter 1: Outlook Basics 423 Chapter 2: Maintaining the People App 435 Chapter 3: Handling Your Email 445 Chapter 4: Managing Your Time and Schedule 467 Book 6: Access 2021 479 Chapter 1: Introducing Access 481 Chapter 2: Building Your Database Tables 497 Chapter 3: Entering the Data 525 Chapter 4: Sorting, Querying, and Filtering for Data 535 Chapter 5: Presenting Data in a Report 557 Book 7: Publisher 2021 563 Chapter 1: Introducing Publisher 565 Chapter 2: Refining a Publication 577 Chapter 3: Putting on the Finishing Touches 589 Book 8: Working with Charts and Graphics 601 Chapter 1: Creating a Chart 603 Chapter 2: Making a SmartArt Diagram 623 Chapter 3: Handling Graphics and Photos 643 Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects 659 Book 9: Office 2021: One Step Beyond 693 Chapter 1: Customizing an Office Program 695 Chapter 2: Ways of Distributing Your Work 709 Book 10: File Sharing and Collaborating 717 Chapter 1: Up and Running on OneDrive 719 Chapter 2: File Sharing and Collaborating 731 Index 739

Read more less

Book SynopsisThe easy way to get started with Minecraft Want to creep into the biggest video game of all time? Grab your pickaxe and let's go! Minecraft Basics For Dummies helps you (or your kids) get started and join the infinite online world that keeps millions of players of all ages engaged every day. Inside this portable-trim book, crafters will get all the tips and tricks needed to get startedon their own or with multiple playersin each of the three gameplay modes. Choose a platform and download the gameNavigate, collect resources, and build structuresDefend your creations against monstersManage parental controls to keep kids safe while playing onlineBecome a Minecraft master by defeating the Ender Dragon Unleash your creativity, elevate family game night, and have a ton of fun joining more than 141 million players in the online world of Minecraft!Table of ContentsIntroduction 1 Part 1: Getting Started with Minecraft 5 Chapter 1: Minecraft Is for Everyone — But What Is It? 7 Chapter 2: Scratching the Surface of Minecraft 21 Chapter 3: Let’s Go! Playing the Game and Surviving the First Night 33 Part 2: Getting a Handle on the Basic Skills 55 Chapter 4: Surviving Hunger 57 Chapter 5: Discovering Blocks and Items 63 Chapter 6: Exploring Biomes 79 Part 3: Expanding Your Skills 87 Chapter 7: Creating Farms in Your World 89 Chapter 8: Exploring the Minecraft Underground by Mining and Caving 107 Chapter 9: Leading Your Village 121 Chapter 10: Powering Up with Weapons and Potions 131 Chapter 11: Advancing to the Nether, The End, and Beyond 147 Chapter 12: Expanding Your Minecraft Experience 175 Part 4: The Part of Tens 187 Chapter 13: Ten Things Adults Should Try in Minecraft (Adults Only!) 189 Chapter 14: Ten Helpful Survival Tips 195 Glossary 201 Index 205

Read more less

Book SynopsisThis textbook offers students a systematic guide to how information systems underpin organisational activity in today's global information society, covering everything from ICT infrastructure and the digital environment to electronic marketing, mobile commerce and design thinking. While academically rigorous and underpinned by the author's deep knowledge of the subject, an engaging writing style combined with extensive pedagogical features, cases and innovative examples from around the world ensure that the text remains accessible to those approaching the topic for the first time. Taking an approach that views businesses as complex systems, the book illustrates how valuable systems thinking can be in our everyday working lives, while theoretical ideas are always supported by examples of their application in the real world. This text is the ideal course companion for all students studying business information systems or management information systems modules at undergraduate, postgradTrade ReviewThe author offers a clearly-organized and case study supported approach for real-world information system topics. The textbook bridges theory and practice in an intuitive und understandable manner. It is a must-read for every student in the field. * Dirk Drechsler, Offenburg University, Germany *Beynon-Davies’s updated classic provides a timely perspective on all elements of the modern ICT backbone that students and practitioners will find refreshing and useful in understanding the strategic role of IT in a data-driven decision making environment. * Nikolaos Korfiatis, University of East Anglia, UK *Business Information Systems provides an up-to-date and concise overview of a wide range of aspects related to the role of information in modern organisations, the increasing importance of electronic commerce and social media marketing as well as how to exploit digital opportunities for innovation. Relevant illustrations help to make it easier for students to understand the complexities of digital business. Exercises and Review Tests bring the subject matter to life even further. A balanced and usable book. * Markus Haag, University of Bedfordshire, UK *This third edition of Business Information Systems builds on previous editions by incorporating such key contemporary topics as big data; the internet of things; blockchain; social media; design thinking and cyber security. Importantly, considerations of sustainability and ethics also feature, as do reflections on contemporary technological trends and their impacts on business, organisations and society. This is essential reading, not just for those studying business information systems per se but for aspiring managers of all descriptions given the criticality and pervasiveness of digital technology both now and in the future. * Robert Galliers, Bentley University, USA *A very practical and up-to-date approach to business information systems. Grounded in principles of good teaching practice, this text is an excellent and accessible resource for both students and instructors. Terminology is contextually and gently introduced. The often-troublesome gap between theory and practice is effectively bridged through the extensive use of examples, stories and case studies, all highly relevant to the pervading digital environment. * Geraldine Torrisi-Steele, Griffith University, Australia *In a digital society it can be difficult to find a textbook that covers computer science and business in one place. However, Business Information Systems by Paul Beynon-Davies does just that and is a great book that simplifies the complicated and makes learning easy. I highly recommend this book. * Wayne Palmer, Buckinghamshire New University, UK *I have admired the work of Paul Beynon-Davies for years. His writing is of the highest standard and is truly engaging. That’s why I welcome the third edition of his textbook on Business Information Systems. It offers a comprehensive, up-to-date and rich learning experience for students of information systems. * Markus Lahtinen, Lund University, Sweden *Paul Beynon-Davies provides an engaging and comprehensive explanation of information systems and why they are important to business. It is grounded in a clear understanding of how technology is continuing to evolve and of the impact of this on how we live and work. It is illustrated by a range of excellent thought-provoking case studies. * Martin Rich, City University, London, UK *Business Information Systems is a comprehensive teaching aid for both undergraduate and postgraduate university courses which covers both the fundamentals and also some more cutting edge aspects of information systems. The text is engaging and encourages students to learn and reflect. * Philip Garnett, University of York, UK *Table of Contents1. Introduction: The domain of business information systems 2. Systems of organisation 3. Data and information 4. The infrastructure of organisation 5. ICT infrastructure 6. The digital environment 7. Digital business 8. Electronic marketing, procurement and government 9. Mobile commerce and social media 10. Designing digital organisation 11. Digital strategy and digital innovation 12. Managing and operating digital infrastructure 13. The changing nature of digital infrastructure.

Read more less

Book SynopsisThe latest and most authoritative version of the popular step-by-step tutorial for Revit Architecture The newly revised third edition of Revit 2024 for Architecture: No Experience Required is the latest update to the market-leading, real-world guide for learning and building with Revitthe powerful and sophisticated Building Information Modeling (BIM) software used by professionals around the world. This popular, user-friendly book teaches you the Revit interface and helps you understand the foundational concepts and features of the software. You'll learn to design, document, and present a 3D BIM project with a continuous, step-by-step tutorial that guides you through every phase of the project: from placing walls, doors, windows, structural elements, dimensions, and text, to generating documentation, advanced detailing, site grading, construction scheduling, material takeoffs, and more. In addition, this book helps you prepare for the Autodesk Revit ArchitectuTable of ContentsIntroduction xxiii Chapter 1 The Autodesk Revit World 1 The Revit Interface 1 The Revit Workflow 4 Using the Ribbon 6 The View Window 12 Object Selection 16 Modifying and Mirroring 17 Building on Existing Geometry 20 View Control and Object Display 22 The Project Browser 31 Views 33 File Types and Families 36 System and Hosted Families (.rfa) 37 Using Revit Template Files (.rte) 42 Using Revit Family Files (.rft) 43 Are You Experienced? 44 Now you can 44 Chapter 2 Creating a Model 45 Placing Walls 45 Adding Exterior Walls 45 Using Reference Planes 46 Adding More Walls 49 Adding Interior Walls 60 Using Temporary Dimensions to Gain Control of Your Model 62 Editing Wall Joins 82 Displaying Wall Joins 87 Disallowing Wall Joins 89 Adding Doors and Windows 94 Adding Doors 94 Placing Openings in Your Walls 100 Adding Windows 103 Are You Experienced? 110 Now you can 110 Chapter 3 Creating Views 111 Creating Levels 111 Adding Levels 114 Understanding the Composition of a Level 117 Making Other Level Adjustments 122 Creating and Modifying Building Sections 130 Adding a Building Section 130 Making Building Modifications in a Section 137 Adding Wall Sections 144 Creating Detail Sections 146 Using Crop Regions 149 Splitting a Section Segment 151 Creating Callouts 153 Creating and Modifying a Camera View 160 Adding a Camera View 160 Modifying the Camera 163 Creating an Elevation 164 Interior Elevations 168 Elevation Properties 172 Annotation Properties 174 Are You Experienced? 175 Now you can 175 Chapter 4 Working with the Autodesk Revit Tools 177 The Basic Edit Commands 178 The Move Command 178 The Copy Command 180 The Rotate Command 182 The Array Command 187 Radial Array 187 Linear Array 191 The Mirror Command 197 The Align Tool 201 The Split Element Command 205 The Trim/Extend Command 213 The Offset Command 216 Copy/Paste 219 Creating the Plans 221 Are You Experienced? 226 Now you can 226 Chapter 5 Dimensioning and Annotating 229 Dimensioning 229 Aligned Dimensions 230 Linear Dimensions 241 Angular Dimensions 243 Radial Dimensions 244 Arc Length Dimensions 246 Using Dimensions as a Layout Tool 248 Constraining the Model 253 Using Dimensions to Move Objects 257 Using Dimension Text Overrides 260 Placing Text and Annotations 264 Adding Leader Text 267 Changing the Leader Type 268 Modifying the Text Placement 269 Are You Experienced? 271 Now you can 271 Chapter 6 Floors 273 Placing a Floor Slab 273 Creating the Slab 274 Sketching the Slab 278 Building a Floor by Layers 287 Adding Materials 288 Adding a Layer 290 Pitching a Floor to a Floor Drain 299 Using the Shape Editing tools 309 Creating Shaft Openings 315 Are You Experienced? 320 Now you can 320 Chapter 7 Roofs 323 Placing Roofs by Footprint 323 Flat Roofs by Footprint 324 Pitched Roofs by Footprint 340 Creating a Sloping Roof 352 Creating Roofs by Extrusion 357 Adding a Roof Dormer 368 Are You Experienced? 372 Now you can 372 Chapter 8 Structural Items 375 Adding Structural Grids 375 Placing a Grid 376 Adding Structural Columns 388 Using Structural Framing 395 Adding a Beam System 400 Adding Bracing 403 Understanding Foundation Systems 410 Adding Structural Footings 414 Structural Slabs 416 Piers and Spread Footings 420 Are You Experienced? 426 Now you can 426 Chapter 9 Ceilings and Interiors 427 Creating Ceilings 427 Modifying Ceiling Grids 432 Setting Ceiling Element Properties 433 Creating a Plan Region 438 Creating a Custom Ceiling 440 Creating Ceiling Openings and Soffits 446 Creating a Ceiling Opening 446 Creating a Soffit 447 Adding Light Fixtures to Ceilings 456 Adding Interior Design 460 Adding Plumbing Fixtures and Furniture 461 Adding Parabolic Troffers 468 Adding Casework and Furniture 472 Adding Additional Floor Materials 483 Cutting and Adding the Floor 483 Creating a Tile Material 485 Are You Experienced? 490 Now you can 490 Chapter 10 Stairs, Ramps, and Railings 493 Creating Stairs by Using the Rise/Run Function 493 Modifying Boundaries 498 Configuring Railings 506 Creating a Winding Staircase 517 Stair and Railing Families 532 Creating a Custom Railing System 537 Creating Custom Stairs 542 Adding a Custom Landing 547 Adding a Gooseneck 548 Adding Ramps 556 Are You Experienced? 563 Now you can 563 Chapter 11 Detailing 565 Working with Line Weights 565 Drafting on Top of the Detail 569 Using Predefined Detail Components 569 Materials 571 Repeating Details 573 Modifying a Detail Component 577 Modifying Filled Regions 579 Specifying Drafting Line Weights 598 Adding Notes 600 Adding Textual Notations 600 Creating Blank Drafting Views 602 Creating a Detail Group 611 Adding a Section to Another View 617 Importing AutoCAD Files into a Drafting View 619 Adding 2D and 3D Lines to the Model 620 Are You Experienced? 622 Now you can 622 Chapter 12 Creating Specific Views and Match Lines 625 Duplicating Views 625 Creating Dependent Views 628 Adjusting the Crop Regions 630 Adjusting the Annotation Crop Region 633 Adding Match Lines 635 Match- Line Appearance 635 Adding View References to a Match Line 636 Using View Templates 640 Are You Experienced? 640 Now you can 640 Chapter 13 Creating Sheets and Printing 643 Creating and Populating Sheets 643 Sheet Organization 646 Modifying a Viewport 654 Viewport Properties 660 Adding Revisions to a Sheet 661 Addressing Project Information 665 Generating a Cover Sheet 667 Printing from Revit Architecture 674 Are You Experienced? 679 Now you can 679 Chapter 14 Creating Rooms and Area Plans 681 Creating Rooms 681 Configuring Properties 686 Placing and Manipulating Room Tags 690 Adding a Room Schedule 692 Adding a Color- Fill Plan 697 Adding Room Separators 700 Creating an Area Plan 701 Are You Experienced? 706 Now you can 706 Chapter 15 Advanced Wall Topics 707 Creating Compound Walls 707 Adding Layers to the Compound Wall 710 Adding Wall Sweeps 716 Modifying a Wall’s Profile in Place 722 Manually Adding Host Sweeps 727 Creating Stacked Walls 733 Creating Curtain Walls 738 Adding a Predefined Curtain Wall 738 Adding a Blank Curtain Wall 741 Creating Curtain Grids 744 Are You Experienced? 752 Now you can 752 Chapter 16 Schedules and Tags 755 Creating Schedules 755 Adding Fields to a Schedule 756 Sorting and Grouping 759 Controlling Headers 761 Modifying Elements in a Schedule 763 Modifying the Schedule’s Appearance 765 Creating Material Takeoffs 770 Creating a Calculated Value Field 774 Creating Key Legends 780 Adding Legend Components 780 Adding Tags 783 Adding Tags Individually 784 Using the Tag All Command 786 Tagging by Material 788 Using Multi- Category Tags 791 Keynoting 794 Keynoting by Element 794 Are You Experienced? 798 Now you can 798 Chapter 17 Rendering and Presentation 799 Creating an Interior Rendering 799 Creating Lighting Groups 806 Creating Walkthroughs 810 Exporting an Animation 817 Creating a Solar Study 818 Are You Experienced? 820 Now you can 820 Chapter 18 Creating Families 821 Creating a Basic Family 821 Adding Reference Planes to a Family 822 Adding Dimensions and Parameters to a Family 825 The Type Properties Dialog 830 Using Mathematical Expressions to Create an Arched Door 838 Creating 3D Sweeps in a Family 846 Creating a Casing Sweep 855 Creating an In- Place Family 869 Are You Experienced? 872 Now you can 872 Chapter 19 Project Management 873 Managing Project Phasing 873 Examining Graphic Overrides 878 Activating and Explaining Worksharing 879 Creating a Central Model 882 Creating a Local File 887 Loading or Not Loading a Workset during Open 889 Are You Experienced? 890 Now you can 890 Index 891

Read more less

Book SynopsisEasy advice for getting the most out of Google Workspace for school, work, or personal use Google Workspace For Dummies is here to show you the tips and tricks for upping your productivity with Google's cloud-based software suite. This book includes jargon-free instructions on using Gmail, Calendar, Docs, Sheets, Drive, Chat, and Meet. You'll learn about the AI features, updated security, compatibility with other apps, picture-in-picture capability for video meetings, and beyond. Plus, you'll get info on Google's Forms and Notes feature that makes it simple to gather and share data and stay up-to-date with your team. It's easier than ever to collaborate securely in the cloud, thanks to this Dummies book. Learn how to collaborate with colleagues in real time using the programs that come with Google WorkspaceCreate and edit contacts, and set up video meetingsWork on slides, spreadsheets, and documentsDiscover tips and tricks to increase productivity and keep your work secure Google Works

Read more less

Book SynopsisFeaturing numerous case examples from companies around the world, this second edition integrates theoretical advances and empirical data with practical applications, including in-depth discussion on the COBIT 5 framework which can be used to build, measure and audit enterprise governance of IT approaches. At the forefront of the field, the authors of this volume draw from years of research and advising corporate clients to present a comprehensive resource on enterprise governance of IT (EGIT).Information technology (IT) has become a crucial enabler in the support, sustainability and growth of enterprises. Given this pervasive role of IT, a specific focus on EGIT has arisen over the last two decades, as an integral part of corporate governance. Going well beyond the implementation of a superior IT infrastructure, enterprise governance of IT is about defining and embedding processes and structures throughout the organization that enable boards and business and IT people to execute their responsibilities in support of business/IT alignment and value creation from their IT-enabled investments.Featuring a variety of elements, including executive summaries and sidebars, extensive references and questions and activities (with additional materials available on-line), this book will be an essential resource for professionals, researchers and students alikeTrade Review“The seven chapters of content are intended to serve a large target audience from academic and industry fields including master’s students using it in conjunction with IT courses, executive students in business schools for MBA courses on IT management, and industry practitioners (IT managers, business managers) looking to design and implement an EGIT framework. … This very advanced and valuable book is a must-read for those who want to implement and manage a modern EGIT framework.” (Mihail Sadeanu, Computing Reviews, September, 2015)Table of ContentsPreface.- Acknowledgments.- Chapter 1 Enterprise Governance of IT, Alignment and Value.- Chapter 2 Enterprise Governance of IT.- Chapter 3 Business / IT Alignment.- Chapter 4 IT enabled Value.- Chapter 5 COBIT as a Framework for Enterprise Governance of IT.- Chapter 6 COBIT as a Framework for IT Assurance.- Chapter 7 Guidelines for the Implementation of Enterprise Governance of IT.

Read more less

Book Synopsis

Read more less

a huge range and FREE tracked UK delivery on ALL orders.

Read more less

Book SynopsisDoug Rose has been transforming organizations through technology, training, and process optimization for more than 25 years. He is the author of the Project Management Institute (PMI) first major publication on the agile framework, Leading Agile Teams. He is also the author of Data Science: Create Teams That Ask the Right Questions and Deliver Real Value and Enterprise Agility for Dummies. Doug has a master degree (MS) in information management, a law degree (JD) from Syracuse University, and a BA from the University of Wisconsin-Madison. He is also a Scaled Agile Framework Program Consultant (SPC), Certified Technical Trainer (CTT+), Certified Scrum Professional (CSP-SM), Certified Scrum Master (CSM), PMI Agile Certified Professional (PMI-ACP), Project Management Professional (PMP), and Certified Developer for Apache Hadoop (CCDH). You can attend his lively and engaging business and project management courses at the University of Chicago or oTable of ContentsForeword xv Preface xix PART I: Thinking Machines: An Overview of Artificial Intelligence 1 Chapter 1: What Is Artificial Intelligence? 3 What Is Intelligence? 4 Testing Machine Intelligence 6 The General Problem Solver 8 Strong and Weak Artificial Intelligence 11 Artificial Intelligence Planning 14 Learning over Memorizing 15 Chapter Takeaways 18 Chapter 2: The Rise of Machine Learning 19 Practical Applications of Machine Learning 22 Artificial Neural Networks 24 The Fall and Rise of the Perceptron 27 Big Data Arrives 30 Chapter Takeaways 33 Chapter 3: Zeroing in on the Best Approach 35 Expert System Versus Machine Learning 35 Supervised Versus Unsupervised Learning 37 Backpropagation of Errors 38 Regression Analysis 41 Chapter Takeaways 43 Chapter 4: Common AI Applications 45 Intelligent Robots 45 Natural Language Processing 48 The Internet of Things 50 Chapter Takeaways 51 Chapter 5: Putting AI to Work on Big Data 53 Understanding the Concept of Big Data 54 Teaming Up with a Data Scientist 54 Machine Learning and Data Mining: What’s the Difference? 55 Making the Leap from Data Mining to Machine Learning 56 Taking the Right Approach 57 Chapter Takeaways 59 Chapter 6: Weighing Your Options 61 Chapter Takeaways 64 PART II: Machine Learning 65 Chapter 7: What Is Machine Learning? 67 How a Machine Learns 71 Working with Data 74 Applying Machine Learning 77 Different Types of Learning 79 Chapter Takeaways 81 Chapter 8: Different Ways a Machine Learns 83 Supervised Machine Learning 83 Unsupervised Machine Learning 86 Semi-Supervised Machine Learning 89 Reinforcement Learning 91 Chapter Takeaways 93 Chapter 9: Popular Machine Learning Algorithms 95 Decision Trees 99 k-Nearest Neighbor 101 k-Means Clustering 104 Regression Analysis 108 Naive Bayes 110 Chapter Takeaways 113 Chapter 10: Applying Machine Learning Algorithms 115 Fitting the Model to Your Data 119 Choosing Algorithms 120 Ensemble Modeling 121 Deciding on a Machine Learning Approach 123 Chapter Takeaways 124 Chapter 11: Words of Advice 125 Start Asking Questions 125 Don’t Mix Training Data with Test Data 127 Don’t Overstate a Model’s Accuracy 127 Know Your Algorithms 128 Chapter Takeaways 128 PART III: Artificial Neural Networks 129 Chapter 12: What Are Artificial Neural Networks? 131 Why the Brain Analogy? 133 Just Another Amazing Algorithm 133 Getting to Know the Perceptron 135 Squeezing Down a Sigmoid Neuron 138 Adding Bias 141 Chapter Takeaways 142 Chapter 13: Artificial Neural Networks in Action 143 Feeding Data into the Network 143 What Goes on in the Hidden Layers 145 Understanding Activation Functions 149 Adding Weights 151 Adding Bias 152 Chapter Takeaways 153 Chapter 14: Letting Your Network Learn 155 Starting with Random Weights and Biases 156 Making Your Network Pay for Its Mistakes: The Cost Function 157 Combining the Cost Function with Gradient Descent 158 Using Backpropagation to Correct for Errors 160 Tuning Your Network 163 Employing the Chain Rule 164 Batching the Data Set with Stochastic Gradient Descent 166 Chapter Takeaways 167 Chapter 15: Using Neural Networks to Classify or Cluster 169 Solving Classification Problems 170 Solving Clustering Problems 172 Chapter Takeaways 174 Chapter 16: Key Challenges 175 Obtaining Enough Quality Data 175 Keeping Training and Test Data Separate 176 Carefully Choosing Your Training Data 177 Taking an Exploratory Approach 177 Choosing the Right Tool for the Job 178 Chapter Takeaways 178 PART IV: Putting Artificial Intelligence to Work 179 Chapter 17: Harnessing the Power of Natural Language Processing 181 Extracting Meaning from Text and Speech with NLU 183 Delivering Sensible Responses with NLG 184 Automating Customer Service 186 Reviewing the Top NLP Tools and Resources 187 NLU Tools 189 NLG Tools 190 Chapter Takeaways 191 Chapter 18: Automating Customer Interactions 193 Choosing Natural Language Technologies 195 Review the Top Tools for Creating Chatbots and Virtual Agents 196 Chapter Takeaways 198 Chapter 19: Improving Data-Based Decision-Making 199 Choosing Between Automated and Intuitive Decision-Making 201 Gathering Data in Real Time from IoT Devices 202 Reviewing Automated Decision-Making Tools 204 Chapter Takeaways 205 Chapter 20: Using Machine Learning to Predict Events and Outcomes 207 Machine Learning Is Really about Labeling Data 208 Looking at What Machine Learning Can Do 210 Predict What Customers Will Buy 210 Answer Questions Before They’re Asked 210 Make Better Decisions Faster 212 Replicate Expertise in Your Business 213 Use Your Power for Good, Not Evil: Machine Learning Ethics 214 Review the Top Machine Learning Tools 216 Chapter Takeaways 218 Chapter 21: Building Artificial Minds 219 Separating Intelligence from Automation 221 Adding Layers for Deep Learning 222 Considering Applications for Artificial Neural Networks 223 Classifying Your Best Customers 224 Recommending Store Layouts 225 Analyzing and Tracking Biometrics 226 Reviewing the Top Deep Learning Tools 228 Chapter Takeaways 229 Index 231

Read more less

Book SynopsisMaximize your Excel experience with VBA Excel 2019 Power Programming with VBAis fully updated to cover all the latest tools and tricks of Excel 2019. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features. Understanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produceand can help you take your career to the next level. Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniquesLeverage templates and worksheets that put your new knowledge in action, and reinforce theTable of ContentsIntroduction xxxiii Part I: Introduction to Excel VBA 1 Chapter 1: Essentials of Spreadsheet Application Development 3 What Is a Spreadsheet Application? 3 Steps for Application Development 4 Determining User Needs 5 Planning an Application That Meets User Needs 6 Determining the Most Appropriate User Interface 7 Concerning Yourself with the End User 12 Other Development Issues 17 Chapter 2: Introducing Visual Basic for Applications 19 Getting a Head Start with the Macro Recorder 19 Working with the Visual Basic Editor 32 VBA Fundamentals 43 Deep Dive: Working with Range Objects 48 Essential Concepts to Remember 52 Don’t Panic–You Are Not Alone 54 Chapter 3: VBA Programming Fundamentals 61 VBA Language Elements: An Overview 61 Comments 63 Variables, Data Types, and Constants 65 Assignment Statements 76 Arrays 78 Declaring Arrays 78 Object Variables 80 User-Defined Data Types 81 Built-in Functions 82 Manipulating Objects and Collections 85 Controlling Code Execution 88 Chapter 4: Working with VBA Sub Procedures 105 About Procedures 105 Executing Sub Procedures 108 Passing Arguments to Procedures 119 Error-Handling Techniques 123 A Realistic Example That Uses Sub Procedures 127 Utility Availability 140 Evaluating the Project 141 Chapter 5: Creating Function Procedures 143 Sub Procedures vs. Function Procedures 143 Why Create Custom Functions? 144 An Introductory Function Example 144 Function Procedures 148 Function Arguments 153 Function Examples 153 Emulating Excel’s SUM Function 167 Extended Date Functions 170 Debugging Functions 172 Dealing with the Insert Function Dialog Box 173 Using Add-Ins to Store Custom Functions 178 Using the Windows API 178 Chapter 6: Understanding Excel’s Events 183 What You Should Know About Events 183 Getting Acquainted with Workbook-Level Events 189 Examining Worksheet Events 197 Monitoring with Application Events 206 Chapter 7: VBA Programming Examples and Techniques 217 Learning by Example 217 Working with Ranges 218 Working with Workbooks and Sheets 246 VBA Techniques 251 Some Useful Functions for Use in Your Code 258 Some Useful Worksheet Functions 263 Windows API Calls 278 Part II: Advanced VBA Techniques 287 Chapter 8: Working with Pivot Tables 289 An Introductory Pivot Table Example 289 Creating a More Complex Pivot Table 295 Creating Multiple Pivot Tables 299 Creating a Reverse Pivot Table 302 Chapter 9: Working with Charts 305 Getting the Inside Scoop on Charts 305 Creating an Embedded Chart 308 Creating a Chart on a Chart Sheet 309 Modifying Charts 309 Using VBA to Activate a Chart 310 Moving a Chart 311 Using VBA to Deactivate a Chart 312 Determining Whether a Chart Is Activated 313 Deleting from the ChartObjects or Charts Collection 313 Looping Through All Charts 314 Sizing and Aligning ChartObjects 317 Creating Lots of Charts 318 Exporting a Chart 321 Changing the Data Used in a Chart 322 Using VBA to Display Custom Data Labels on a Chart 328 Displaying a Chart in a UserForm 331 Understanding Chart Events 334 Discovering VBA Charting Tricks 340 Working with Sparkline Charts 347 Chapter 10: Interacting with Other Applications 351 Understanding Microsoft Office Automation 351 Automating Access from Excel 354 Automating Word from Excel 356 Automating PowerPoint from Excel 360 Automating Outlook from Excel 365 Starting Other Applications from Excel 369 Chapter 11: Working with External Data and Files 377 Working with External Data Connections 377 Power Query Basics 377 Using ADO and VBA to Pull External Data 390 Working with Text Files 397 Text File Manipulation Examples 401 Performing Common File Operations 405 Zipping and Unzipping Files 413 Part III: Working with UserForms 417 Chapter 12: Leveraging Custom Dialog Boxes 419 Alternatives to UserForms 419 Using an Input Box 419 Using the VBA MsgBox Function 426 Using the Excel GetOpenFilename Method 431 Using the Excel GetSaveAsFilename Method 434 Prompting for a Folder 435 Displaying Excel’s Built-in Dialog Boxes 435 Displaying a Data Form 438 Chapter 13: Introducing UserForms 441 How Excel Handles Custom Dialog Boxes 441 Inserting a New UserForm 442 Adding Controls to a UserForm 443 Toolbox Controls 443 Adjusting UserForm Controls 448 Adjusting a Control’s Properties 450 Displaying a UserForm 456 Closing a UserForm 458 Creating a UserForm: An Example 460 Referencing UserForm Controls 473 Customizing the Toolbox 474 Creating UserForm Templates 477 A UserForm Checklist 478 Chapter 14: Looking at UserForm Examples 479 Creating a UserForm “Menu” 479 Selecting Ranges from a UserForm 481 Creating a Splash Screen 483 Disabling a UserForm’s Close Button 486 Changing a UserForm’s Size 487 Zooming and Scrolling a Sheet from a UserForm 488 Exploring ListBox Techniques 490 Using the MultiPage Control in a UserForm 512 Using an External Control 513 Animating a Label 516 Chapter 15: Implementing Advanced UserForm Techniques 519 A Modeless Dialog Box 519 Displaying a Progress Indicator 523 Creating Wizards 534 Emulating the MsgBox Function 541 A UserForm with Movable Controls 545 A UserForm with No Title Bar 546 Simulating a Toolbar with a UserForm 548 Emulating a Task Pane with a UserForm 550 A Resizable UserForm 551 Handling Multiple UserForm Controls with One Event Handler 556 Selecting a Color in a UserForm 559 Displaying a Chart in a UserForm 561 Making a UserForm Semitransparent 562 A Puzzle on a UserForm 563 Video Poker on a UserForm 565 Part IV: Developing Excel Applications 567 Chapter 16: Creating and Using Add-Ins 569 What Is an Add-In? 569 Understanding Excel’s Add-in Manager 572 Creating an Add-In 574 An Add-In Example 575 Comparing XLAM and XLSM Files 581 Manipulating Add-Ins with VBA 587 Optimizing the Performance of Add-Ins 593 Special Problems with Add-Ins 594 Chapter 17: Working with the Ribbon 599 Ribbon Basics 599 Customizing the Ribbon 601 Creating a Custom Ribbon 606 Using VBA with the Ribbon 628 Creating an Old-Style Toolbar 632 Chapter 18: Working with Shortcut Menus 637 CommandBar Overview 637 Referring to Controls in a CommandBar 640 Properties of CommandBar Controls 641 Displaying All Shortcut Menu Items 642 Using VBA to Customize Shortcut Menus 644 Resetting a shortcut menu 646 Shortcut Menus and Events 654 Chapter 19: Providing Help for Your Applications 659 Help for Your Excel Applications 659 Help Systems That Use Excel Components 661 Displaying Help in a Web Browser 670 Using the HTML Help System 672 Chapter 20: Leveraging Class Modules 679 What Is a Class Module? 679 Creating a NumLock Class 681 Coding Properties, Methods, and Events 685 Exposing a QueryTable Event 688 Creating a Class to Hold Classes 692 Chapter 21: Understanding Compatibility Issues 699 What Is Compatibility? 699 Types of Compatibility Problems 699 Avoid Using New Features 701 But Will It Work on a Mac? 703 Dealing with 64-Bit Excel 704 Creating an International Application 705 Multilanguage Applications 707 VBA Language Considerations 708 Using Local Properties 708 Identifying System Settings 709 Date and Time Settings 711 Part V: Appendix 713 Appendix: VBA Statements and Functions Reference 715 Index 725

Read more less

Book SynopsisCreate stunning infographics with this hands-on guide Infographics For Dummies is a comprehensive guide to creating data visualization with viral appeal.Table of ContentsIntroduction 1 Part I: Getting Started with Infographics 5 Chapter 1: Unlocking the Power of Infographics 7 Chapter 2: Exploring Infographics 19 Chapter 3: Designing Your Approach to Infographics 35 Part II: Starting with Data 57 Chapter 4: Informing Yourself 59 Chapter 5: Gathering Your Data 77 Chapter 6: Discovering the Story 93 Part III: Depicting with Delightful Design 115 Chapter 7: Creating Wireframes and Managing Mood Boards 117 Chapter 8: Designing Around a Theme 135 Chapter 9: Designing Infographics in Adobe Illustrator 153 Chapter 10: Designing Infographics in Photoshop 193 Chapter 11: Expanding Your Tools and Techniques 225 Part IV: Ready to Distribute 241 Chapter 12: Launching Your Infographic 243 Chapter 13: Promoting Your Infographic 255 Part V: The Part of Tens 273 Chapter 14: Ten Infographics Trends to Follow 275 Chapter 15: Ten Future Infographic Uses to Try Today 283 Index 291

Read more less

Book SynopsisNetSuite is an easy-to-use, customizable enterprise software for running your business. Part I explains NetSuite basics everyone should know. Part II focuses on tracking money (accounting, AR, AP, and managing inventory). Parts III, IV, and V explain how to sell and market your products, take care of customers, and sell goods online with NetSuite.Table of ContentsIntroduction. Part I: NetSuite Basics. Chapter 1: Peeking Under the NetSuite Hood. Chapter 2: Tailoring NetSuite to Your Company. Chapter 3: Personalizing Your Suite. Chapter 4: Grabbing Hold of the Dashboard. Part II: Tracking Money and Resources. Chapter 5: Bookkeeping Basics. Chapter 6: Invoicing Customers and Paying the Bills. Chapter 7: Managing Inventory. Part III: Marketing and Driving Sales. Chapter 8: Building a Campaign: Marketing Automation. Chapter 9 : Setting Up Sales Force Automation. Chapter 10: Turning Leads into Customers. Part IV: Taking Care of Your Partners and Customers. Chapter 11: Delivering the Goods: Fulfi llment and Shipping. Chapter 12: Managing Projects. Chapter 13: Providing Excellent Customer Service. Part V: Selling Online. Chapter 14: Planning Your Web Site. Chapter 15: Adding Content to Your Site. Chapter 16: Making Your Site Look Great. Chapter 17: Let the Shopping Begin. Chapter 18: Fine-Tuning Your Site. Part VI: Dashboards, Searches, and Analytics. Chapter 19: Realizing the Power of Saved Searches. Chapter 20: Exposing Metrics on Your Dashboard. Chapter 21: Reporting and Analytics. Part VII: The Part of Tens. Chapter 22: Ten-Plus Key Differentiators. Chapter 23: Ten Tips for a Successful Implementation. Chapter 24: Ten Frequently Asked Questions. Bonus Chapters on the Companion Web Site.... On the Web. Bonus Chapter 1: Managing Partner Relationships. Bonus Chapter 2: Hosting Your Site. Bonus Chapter 3: Integrating an External Site. Bonus Chapter 4: Creating Custom Fields, Tabs, and Tables. Bonus Chapter 5: Writing Your Own Ticket with SuiteScript. Bonus Chapter 6: Securing Your NetSuite Account. Bonus Chapter 7: Exploring Advanced Topics. http://www.dummies.com/go/netsuitefd Index.

Read more less

Book SynopsisBuild your first app in Flutterno experience necessary! Beginning Flutter: A Hands-On Guide to App Development is the essential resource for both experienced and novice developers interested in getting started with Flutterthe powerful new mobile software development kit. With Flutter, you can quickly and easily develop beautiful, powerful apps for both Android and iOS, without the need to learn multiple programming languages or juggle more than one code base. This book walks you through the process step by step. In Flutter, you'll be working with Dart, the programming language of choice for top app developers. Even if you're just starting out in your development career, you can learn Dart quickly, eliminating the barrier to entry for building apps. This is a more efficient way to develop and maintain cross-platform mobile apps, and this book makes the process even easier with a teach-by-example approach. Focus on providing quality content by Table of ContentsIntroduction xxi Part I: The Foundations of Flutter Programming Chapter 1: Introducing Flutter and Getting Started 3 Introducing Flutter 4 Defining Widgets and Elements 5 Understanding Widget Lifecycle Events 5 The StatelessWidget Lifecycle 6 The StatefulWidget Lifecycle 6 Understanding the Widget Tree and the Element Tree 8 Stateless Widget and Element Trees 9 Stateful Widget and Element Trees 10 Installing the Flutter SDK 13 Installing on macOS 13 System Requirements 13 Get the Flutter SDK 13 Check for Dependencies 14 iOS Setup: Install Xcode 14 Android Setup: Install Android Studio 14 Set Up the Android Emulator 15 Installing on Windows 15 System Requirements 15 Get the Flutter SDK 16 Check for Dependencies 16 Install Android Studio 16 Set Up the Android Emulator 17 Installing on Linux 17 System Requirements 17 Get the Flutter SDK 18 Check for Dependencies 19 Install Android Studio 19 Set Up the Android Emulator 19 Configuring the Android Studio Editor 20 Summary 20 Chapter 2: Creating a Hello World App 25 Setting Up the Project 25 Using Hot Reload 30 Using Themes to Style Your App 33 Using a Global App Theme 33 Using a Theme for Part of an App 35 Understanding Stateless and Stateful Widgets 37 Using External Packages 38 Searching for Packages 39 Using Packages 40 Summary 41 Chapter 3: Learning Dart Basics 43 Why Use Dart? 43 Commenting Code 44 Running the main() Entry Point 45 Referencing Variables 45 Declaring Variables 46 Numbers 47 Strings 47 Booleans 47 Lists 47 Maps 48 Runes 48 Using Operators 49 Using Flow Statements 51 if and else 51 ternary operator 52 for Loops 52 while and do-while 53 while and break 54 continue 54 switch and case 55 Using Functions 55 Import Packages 57 Using Classes 57 Class Inheritance 60 Class Mixins 60 Implementing Asynchronous Programming 61 Summary 62 Chapter 4: Creating a Starter Project Template 65 Creating and Organizing Folders and Files 65 Structuring Widgets 69 Summary 74 Chapter 5: Understanding the Widget Tree 77 Introduction to Widgets 77 Building the Full Widget Tree 79 Building a Shallow Widget Tree 85 Refactoring with a Constant 86 Refactoring with a Method 86 Refactoring with a Widget Class 91 Summary 99 Part II: Intermediate Flutter: Fleshing Out an App Chapter 6: Using Common Widgets 103 Using Basic Widgets 103 SafeArea 107 Container 108 Text 112 RichText 112 Column 114 Row 115 Column and Row Nesting 115 Buttons 119 FloatingActionButton 119 FlatButton 121 RaisedButton 121 IconButton 122 PopupMenuButton 123 ButtonBar 126 Using Images and Icons 130 AssetBundle 130 Image 131 Icon 132 Using Decorators 135 Using the Form Widget to Validate Text Fields 139 Checking Orientation 143 Summary 149 Chapter 7: Adding Animation to an App 151 Using AnimatedContainer 152 Using AnimatedCrossFade 155 Using AnimatedOpacity 160 Using AnimationController 164 Using Staggered Animations 170 Summary 175 Chapter 8: Creating an App’s Navigation 177 Using the Navigator 178 Using the Named Navigator Route 188 Using Hero Animation 188 Using the BottomNavigationBar 193 Using the BottomAppBar 199 Using the TabBar and TabBarView 203 Using the Drawer and ListView 207 Summary 217 Chapter 9: Creating Scrolling Lists and Effects 221 Using the Card 222 Using the ListView and ListTile 223 Using the GridView 230 Using the GridView.count 230 Using the GridView.extent 232 Using the GridView.builder 233 Using the Stack 237 Customizing the CustomScrollView with Slivers 243 Summary 250 Chapter 10: Building Layouts 253 A High-Level View of the Layout 253 Weather Section Layout 256 Tags Layout 256 Footer Images Layout 257 Final Layout 257 Creating the Layout 257 Summary 265 Chapter 11: Applying Interactivity 267 Setting Up GestureDetector: The Basics 267 Implementing the Draggable and Dragtarget Widgets 275 Using the GestureDetector for Moving and Scaling 278 Using the InkWell and InkResponse Gestures 289 Using the Dismissible Widget 296 Summary 303 Chapter 12: Writing Platform-Native Code 307 Understanding Platform Channels 307 Implementing the Client Platform Channel App 309 Implementing the iOS Host Platform Channel 313 Implementing the Android Host Platform Channel 318 Summary 322 Part III: Creating Production-Ready Apps Chapter 13: Saving Data with Local Persistence 327 Understanding the JSON Format 328 Using Database Classes to Write, Read, and Serialize JSON 330 Formatting Dates 331 Sorting a List of Dates 332 Retrieving Data with the FutureBuilder 333 Building the Journal App 335 Adding the Journal Database Classes 339 Adding the Journal Entry Page 344 Finishing the Journal Home Page 359 Summary 371 Chapter 14: Adding The Firebase and Firestore Backend 375 What are Firebase and Cloud Firestore? 376 Structuring and Data Modeling Cloud Firestore 377 Viewing Firebase Authentication Capabilities 380 Viewing Cloud Firestore Security Rules 381 Configuring the Firebase Project 383 Adding a Cloud Firestore Database and Implementing Security 391 Building the Client Journal App 395 Adding Authentication and Cloud Firestore Packages to the Client App 395 Adding Basic Layout to the Client App 403 Adding Classes to the Client App 406 Summary 409 Chapter 15: Adding State Management to the Firestore Client App 411 Implementing State Management 412 Implementing an Abstract Class 414 Implementing the InheritedWidget 415 Implementing the Model Class 416 Implementing the Service Class 417 Implementing the BLoC Pattern 417 Implementing StreamController, Streams, Sinks, and StreamBuilder 419 Building State Management 421 Adding the Journal Model Class 422 Adding the Service Classes 424 Adding the Validators Class 430 Adding the BLoC Pattern 432 Adding the AuthenticationBloc 432 Adding the AuthenticationBlocProvider 435 Adding the LoginBloc 436 Adding the HomeBloc 441 Adding the HomeBlocProvider 443 Adding the JournalEditBloc 444 Adding the JournalEditBlocProvider 447 Summary 449 Chapter 16: Adding Blocs to Firestore Client App Pages 453 Adding the Login Page 454 Modifying the Main Page 460 Modifying the Home Page 465 Adding the Edit Journal Page 472 Summary 484 Index 489

Read more less

Book SynopsisTable of ContentsIntroduction xxvii Part 1 The Basics 1 Chapter 1 Exploring the Interface 3 Taking a Guided Tour 3 Launching AutoCAD 4 The AutoCAD Window 5 Using the Application Menu 8 Using the Ribbon 10 Picking Points in the Drawing Area 15 Using the UCS Icon 16 Working in the Command Window 16 Working with AutoCAD 17 Opening an Existing File 17 Getting a Closer Look 18 Saving a File as You Work 22 Making Changes 23 Working with Multiple Files 24 Adding a Predrawn Symbol with the Tool Palettes 28 The Bottom Line 31 Chapter 2 Creating Your First Drawing 33 Getting to Know the Home Tab’s Draw and Modify Panels 33 Starting Your First Drawing 36 Specifying Exact Distances with Coordinates 41 Specifying Polar Coordinates 42 Specifying Relative Cartesian Coordinates 44 Interpreting the Cursor Modes and Understanding Prompts 45 Understanding Cursor Modes 46 Choosing Command Options 47 Selecting Objects 52 Selecting Objects in AutoCAD 53 Providing Base Points 55 Using Noun/Verb Selection 59 Editing with Grips 64 Stretching Lines by Using Grips 64 Moving and Rotating with Grips 66 Understanding Dynamic Input 69 Displaying Data in a Text Window 74 Displaying the Properties of an Object 75 Getting Help 78 Using the InfoCenter 78 Finding Additional Sources of Help 79 The Bottom Line 79 Chapter 3 Setting Up and Using the Drafting Tools 81 Setting Up a Work Area 81 Specifying Units 82 Fine-Tuning the Measurement System 84 Setting Up the Drawing Limits 85 Looking at an Alternative to Limits 87 Understanding Scale Factors 87 Using Polar Tracking 88 Setting the Polar Tracking Angle 90 Exploring the Drawing Process 91 Locating an Object in Reference to Others 92 Modifying an Object 93 Planning and Laying Out a Drawing 96 Making a Preliminary Sketch 98 Using the Layout 100 Erasing the Layout Lines 106 Putting on the Finishing Touches 108 Aligning Objects by Using Object Snap Tracking 109 Using the AutoCAD Modes as Drafting Tools 114 Using Grid Mode as a Background Grid 115 Using Snap Modes 117 The Bottom Line 118 Chapter 4 Organizing Objects with Blocks and Groups 121 Creating and Using a Symbol 121 Understanding the Block Definition Dialog Box 124 Inserting a Symbol 126 Scaling and Rotating Blocks 129 Using an Existing Drawing as a Symbol 131 Modifying a Block 133 Unblocking and Redefining a Block 134 Saving a Block as a Drawing File 136 Replacing Existing Files with Blocks 137 Understanding the Write Block Dialog Box Options 138 Other Uses for Blocks 138 Understanding the Annotation Scale 139 Grouping Objects 142 Modifying Members of a Group 144 Ungrouping, Adding, and Subtracting from a Group 147 Working with the Object Grouping Dialog Box 148 Working with the AutoCAD LT Group Manager 150 The Bottom Line 152 Chapter 5 Keeping Track of Layers and Blocks 153 Organizing Information with Layers 153 Creating and Assigning Layers 154 Working on Layers 162 Controlling Layer Visibility 166 Finding the Layers You Want 168 Taming an Unwieldy List of Layers 169 Assigning Linetypes to Layers 176 Adding a Linetype to a Drawing 177 Controlling Lineweights 182 Keeping Track of Blocks and Layers 182 Getting a Text File List of Layers or Blocks 183 The Bottom Line 185 Part 2 Mastering Intermediate Skills 187 Chapter 6 Editing and Reusing Data toWork Efficiently y 189 Creating and Using Templates 190 Creating a Template 190 Using a Template 191 Copying an Object Multiple Times 192 Making Circular Copies 193 Making Row and Column Copies 195 Fine-Tuning Your View 197 Finishing the Kitchenette 199 Array Along a Path 200 Making Changes to an Associative Array 201 Developing Your Drawing 205 Importing Settings 206 Using Osnap Tracking to Place Objects 209 Finding an Exact Distance Along a Curve 226 Changing the Length of Objects 228 Creating a New Drawing by Using Parts from Another Drawing 229 Eliminating Unused Blocks, Layers, Linetypes, Shapes, Styles, and More 230 The Bottom Line 232 Chapter 7 Mastering Viewing Tools, Hatches, and External References 235 Assembling the Parts 235 Taking Control of the AutoCAD Display 238 Understanding Regeneration and Redrawing 239 Saving Views 240 Understanding the Frozen Layer Option 244 Using Hatch Patterns in Your Drawings 246 Placing a Hatch Pattern in a Specific Area 246 Adding Predefined Hatch Patterns 248 Positioning Hatch Patterns Accurately 250 Updating a Block from an External File 251 Changing the Hatch Area 253 Modifying a Hatch Pattern 254 Understanding the Boundary Hatch Options 255 Controlling Boundaries with the Boundaries Panel 257 Fine-Tuning the Boundary Behavior 257 Controlling Hatch Behavior with the Options Panel 258 Controlling Hatch Default Layer, Layout Scale, and ISO Line Weight 259 Using Additional Hatch Features 259 Using Gradient Shading 260 Tips for Using Hatch 262 Space Planning and Hatch Patterns 262 Using External References 266 Attaching a Drawing as an External Reference 266 Other Differences Between External References and Blocks 270 Other External Reference Options 272 Clipping Xref Views and Improving Performance 274 Editing Xrefs in Place 277 Using the External Reference Tab 280 Adding and Removing Objects from Blocks and Xrefs 280 Understanding the Reference Edit Dialog Box Options 283 The Bottom Line 284 Chapter 8 Introducing Printing, Plotting, and Layouts 285 Plotting the Plan 285 Understanding the Plotter Settings 290 Paper Size 290 Drawing Orientation 291 Plot Area 291 Plot Scale 292 Shaded Viewport Options 295 Plot Offset 296 Plot Options 297 Exit Options 298 Plotting Using Layout Views 299 Setting Plot Scale in the Layout Viewports 302 Adding an Output Device 303 Editing a Plotter Configuration 306 Storing a Page Setup 308 Using Electronic Plots 312 Exporting to PDF Through the Plot Dialog Box 312 Exporting to PDF Through the Export To DWF/PDF Ribbon Panel 314 Exporting Autodesk DWF and DWFx Files 315 The Bottom Line 316 Chapter 9 Adding Text to Drawings 317 Preparing a Drawing for Text 317 Organizing Text by Styles 319 Getting Familiar with the Text and Annotation Scale Control Panels 320 Setting the Annotation Scale and Adding Text 321 Inserting Text 321 Exploring Text and Scale 323 Understanding the Text Style Dialog Box Options 326 Styles 326 Set Current/New/Delete 326 Font 326 Size 326 Effects 327 Exploring Text Formatting in AutoCAD 327 Adjusting the Text Height and Font 328 Understanding the Text Editor Tab 330 Adding Symbols and Special Characters 331 Setting Indents and Tabs 334 What Do the Fonts Look Like? 338 Adding Simple Single-Line Text Objects 340 Justifying Single-Line Text Objects 342 Using Special Characters with Single-Line Text Objects 343 Using the Check Spelling Feature 345 How Check Spelling Works 345 Choosing a Dictionary 346 Substituting Fonts 347 Finding and Replacing Text 349 The Bottom Line 353 Chapter 10 Using Fields and Tables 355 Using Fields to Associate Text with Drawing Properties 355 Adding Tables to Your Drawing 359 Creating a Table 360 Adding Cell Text 361 Adjusting Table Text Orientation and Location 363 Editing the Table Line Work 365 Adding Formulas to Cells 368 Using Formulas Directly in Cells 369 Using Other Math Operations 370 Importing and Exporting Tables 370 Importing a Table 371 Exporting Tables 373 Creating Table Styles 373 Adding or Modifying a Table Style 373 Exploring the Table Style Options 375 The Bottom Line 376 Chapter 11 Using Dimensions 377 Understanding the Components of a Dimension 377 Creating a Dimension Style 378 Setting Up the Primary Unit Style 380 Setting the Height for Dimension Text 382 Setting the Location and Orientation of Dimension Text 383 Choosing an Arrow Style and Setting the Dimension Scale 384 Setting Up Alternate Units 388 Setting the Current Dimension Style 389 Modifying a Dimension Style 390 Drawing Linear Dimensions 390 Understanding the Dimensions Panel 391 Placing Horizontal and Vertical Dimensions 392 Continuing a Dimension 393 Drawing Dimensions from a Common Base Extension Line 394 Adjusting the Distance Between Dimensions 396 Editing Dimensions 397 Appending Data to Dimension Text 397 Using Grips to Make Minor Adjustments to Dimensions 399 Changing Style Settings of Individual Dimensions 401 Associating Dimensions with Objects 405 Adding a String of Dimensions with a Single Operation 407 Adding or Removing the Alternate Dimensions 408 Dimensioning Nonorthogonal Objects 409 Dimensioning Nonorthogonal Linear Distances 409 Dimensioning Radii, Diameters, and Arcs 411 Skewing Dimension Lines 415 Using the Dimension Tool 416 Adding a Note with a Leader Arrow 419 Creating Multileader Styles 421 Editing Multileader Notes 424 Breaking a Dimension Line for a Leader 424 Applying Ordinate Dimensions 425 Adding Tolerance Notation 426 Inserting Tolerance and Datum Values 426 Adding Inspection Dimensions 427 The Bottom Line 429 Part 3 Mastering Advanced Skills 431 Chapter 12 Using Attributes 433 Creating Attributes 434 Adding Attributes to Blocks 434 Copying and Editing Attribute Definitions 437 Turning the Attribute Definitions into a Block 440 Inserting Blocks Containing Attributes 441 Editing Attributes 445 Editing Attribute Values One at a Time 445 Editing Attribute Text Formats and Properties 446 Making Global Changes to Attribute Values 447 Making Invisible Attributes Visible 449 Making Global Format and Property Changes to Attributes 450 Other Block Attribute Manager Options 452 Redefining Blocks Containing Attributes 453 Extracting and Exporting Attribute Information 454 Performing the Extraction 454 Extracting Attribute Data to an AutoCAD Table 459 The Bottom Line 461 Chapter 13 Copying Existing Drawings from Other Sources 463 Methods for Converting Paper Drawings to AutoCAD Files 463 Importing a Raster Image 464 Working with a Raster Image 466 Scaling a Raster Image 468 Controlling Object Visibility and Overlap with Raster Images 468 Adjusting Brightness, Contrast, and Fade 471 Clipping a Raster Image 472 Turning Off the Frame, Adjusting Overall Quality, and Controlling Transparency 473 Working with PDF Files 477 Importing a PDF 477 Scaling and Osnaps with PDFs 478 Controlling the PDF Display 481 Importing a PDF as an AutoCAD Drawing 483 Reconstructing Imported AutoCAD SHX Fonts 485 Coordinating Geographic Locations 486 Making Adjustments to the Map 489 Finding Measurements and Distances 491 The Bottom Line 492 Chapter 14 Advanced Editing and Organizing 493 Using External References 493 Preparing Existing Drawings for External Referencing 494 Assembling Xrefs to Build a Drawing 496 Updating Blocks in Xrefs 500 Importing Named Elements from Xrefs 502 Controlling the Xref Search Path 505 Managing Layers 507 Saving and Recalling Layer Settings 507 Other Tools for Managing Layers 510 Using Advanced Tools: Filter and Quick Select 513 Filtering Selections 513 Using Quick Select 518 Using the QuickCalc Calculator 520 Adding Foot and Inch Lengths and Finding the Sum of Angles 522 Converting Units with QuickCalc 525 Using QuickCalc to Find Points 526 Finding Fractional Distances Between Two Points 529 Using QuickCalc While in the Middle of a Command 532 Storing Expressions and Values 533 Guidelines for Working with QuickCalc 535 The Bottom Line 538 Chapter 15 Laying Out Your Printer Output 541 Understanding Model Space and Paper Space 541 Switching from Model Space to Paper Space 542 Setting the Size of a Paper Space Layout 544 Creating New Paper Space Viewports 546 Creating a Viewport from a Saved View 547 Reaching Inside Viewports 548 Working with Paper Space Viewports 551 Scaling Views in Paper Space 552 Setting Layers in Individual Viewports 554 Creating and Using Multiple Paper Space Layouts 558 Creating Odd-Shaped Viewports 560 Understanding Lineweights, Linetypes, and Dimensions in Paper Space 562 Controlling and Viewing Lineweights in Paper Space 562 Using the Lineweight Settings Dialog Box 565 Controlling Linetype Scales and Paper Space 565 Dimensioning in Paper Space Layouts 566 Other Uses for Paper Space 569 The Bottom Line 570 Chapter 16 Making “Smart” Drawings with Parametric Tools 571 Why Use Parametric Drawing Tools? 571 Connecting Objects with Geometric Constraints 573 Using AutoConstrain to Add Constraints Automatically 573 Editing a Drawing Containing Constraints 574 Using Other Geometric Constraints 578 Using Constraints in the Drawing Process 579 Controlling Sizes with Dimensional Constraints 579 Adding a Dimensional Constraint 580 Editing a Dimensional Constraint 581 Using Formulas to Control and Link Dimensions 583 Adding a Formula Parameter 584 Testing the Formula 586 Using Other Formulas 587 Editing the Constraint Options 588 Putting Constraints to Use 590 The Bottom Line 591 Chapter 17 Using Dynamic Blocks 593 Exploring the Block Editor 593 Opening the Block Editor 594 Editing a Block and Creating New Blocks 595 Creating a Dynamic Block 596 Adding a Parameter 597 Adding an Action 598 Adding an Increment Value 600 Editing Parameters and Actions 602 Keeping an Object Centered 602 Using Constraints in Dynamic Blocks 604 Adding a List of Predefined Options 608 Creating Multiple Shapes in One Block 612 Rotating Objects in Unison 617 Filling in a Space Automatically with Objects 621 Including Block Information with Data Extraction 623 The Bottom Line 625 Chapter 18 Drawing Curves 627 Introducing Polylines 627 Drawing a Polyline 627 Setting Polyline Options 629 Editing Polylines 630 Setting Pedit Options 634 Smoothing Polylines 635 Editing Vertices 636 Creating a Polyline Spline Curve 646 Using True Spline Curves 648 Drawing a True Spline 648 Understanding the Spline Options 650 Fine-Tuning Spline Curves 651 Marking Divisions on Curves 654 Dividing Objects into Segments of Equal Length 654 Dividing Objects into Specified Lengths 657 The Bottom Line 658 Chapter 19 Getting and Exchanging Data from Drawings 661 Finding the Area of Closed Boundaries 661 Finding the Area of an Object 662 Using Hatch Patterns to Find Areas 663 Adding and Subtracting Areas with the Area Command 665 Getting General Information 669 Determining the Drawing’s Status 669 Keeping Track of Time 671 Getting Information from System Variables 672 Keeping a Log of Your Activity 672 Capturing and Saving Text Data from the AutoCAD Text Window 673 Understanding the Command Window Context Menu 674 Storing Searchable Information in AutoCAD Files 675 Searching for AutoCAD Files 676 Recovering Corrupted Files 677 Using the DXF File Format to Exchange CAD Data with Other Programs 677 Exporting DXF Files 678 Opening or Importing DXF Files 679 Using AutoCAD Drawings in Page Layout Programs 681 Exporting Raster Files 681 Exporting Vector Files 685 Using OLE to Import Data 687 Editing OLE Links 690 Importing Worksheets as AutoCAD Tables 690 Understanding Options for Embedding Data 693 Using the Clipboard to Export AutoCAD Drawings 694 The Bottom Line 694 Part 4 3D Modeling and Imaging 697 Chapter 20 Creating 3D Drawings 699 Getting to Know the 3D Modeling Workspace 699 Drawing in 3D Using Solids 701 Adjusting Appearances 702 Creating a 3D Box 702 Editing 3D Solids with Grips 704 Constraining Motion with the Gizmo 705 Rotating Objects in 3D Using Dynamic UCS 706 Drawing on a 3D Object’s Surface 709 Pushing and Pulling Shapes from a Solid 710 Making Changes to Your Solid 712 Creating 3D Forms from 2D Shapes 715 Isolating Coordinates with Point Filters 720 Moving Around Your Model 723 Finding Isometric and Orthogonal Views 723 Rotating Freely Around Your Model 724 Changing Your View Direction 725 Using SteeringWheels 727 Changing Where You Are Looking 729 Flying Through Your View 730 Changing from Perspective to Parallel Projection 731 Getting a Visual Effect 732 Using Visual Styles 732 Creating a Sketched Look with Visual Styles 733 In-Canvas Viewport Controls 736 Turning a 3D View into a 2D AutoCAD Drawing 736 Using the Point Cloud Feature 738 The Bottom Line 739 Chapter 21 Using Advanced 3D Features 741 Setting Up AutoCAD for This Chapter 741 Mastering the User Coordinate System 742 Defining a UCS 743 Saving a UCS 746 Working in a UCS 746 Building 3D Parts in Separate Files 748 Understanding the UCS Options 750 UCS Based on Object Orientation 750 UCS Based on Offset Orientation 753 UCS Rotated Around an Axis 754 Orienting a UCS in the View Plane 756 Manipulating the UCS Icon 756 Saving a UCS with a View 757 Using Viewports to Aid in 3D Drawing 758 Using the Array Tools 762 Making Changes to an Associative Array 763 Creating Complex 3D Surfaces 764 Laying Out a 3D Form 764 Spherical and Cylindrical Coordinate Formats 765 Using a 3D Polyline 766 Creating a Curved 3D Surface 767 Converting the Surface into a Solid 772 Shaping the Solid 772 Finding the Interference Between Two Solids 774 Creating Tubes with the Sweep Tool 777 Using Sweep to Create Complex Forms 779 Creating Spiral Forms 781 Creating Surface Models 784 Slicing a Solid with a Surface 786 Finding the Volume of a Cut 787 Understanding the Loft Command 790 Moving Objects in 3D Space 793 Aligning Objects in 3D Space 793 Moving an Object in 3D 795 Rotating an Object in 3D 796 The Bottom Line 797 Chapter 22 Editing and Visualizing 3D Solids 799 Understanding Solid Modeling 799 Creating Solid Forms 802 Joining Primitives 802 Cutting Portions Out of a Solid 804 Creating Complex Solids 806 Tapering an Extrusion 807 Sweeping a Shape on a Curved Path 808 Revolving a Polyline 809 Editing Solids 812 Splitting a Solid into Two Pieces 812 Rounding Corners with the Fillet Tool 814 Chamfering Corners with the Chamfer Tool 815 Using the Solid-Editing Tools 816 Streamlining the 2D Drawing Process 826 Drawing Standard Top, Front, and Right-Side Views 827 Creating 2D Drawings with the Base View Command 830 Adding Dimensions and Notes in a Layout 836 Using Visual Styles with a Viewport 837 Visualizing Solids 839 The Bottom Line 849 Chapter 23 Exploring 3D Mesh and Surface Modeling 851 Creating a Simple 3D Mesh 851 Creating a Mesh Primitive 852 Understanding the Parts of a Mesh 853 Smoothing a Mesh 853 Editing Faces and Edges 855 Stretching Faces 857 Moving an Edge 860 Adding More Faces 862 Rotating an Edge 865 Adding a Crease 866 Splitting and Extruding a Mesh Face 868 Creating Mesh Surfaces 871 Revolved Surface 871 Edge Surface 873 Ruled Surface 874 Tabulated Surface 875 Converting Meshes to Solids 876 Understanding 3D Surfaces 877 Editing Surfaces 879 Using Extrude, Surface Trim, and Surface Fillet 881 Using Surface Blend, Patch, and Offset 883 Understanding Associativity 888 Editing with Control Vertices 891 Editing with the CV Edit Bar 895 Making Holes in a Surface with the Project Geometry Panel 897 Visualizing Curvature: Understanding the Analysis Panel 898 The Bottom Line 901 Part 5 Customization and Integration 903 Chapter 24 Customizing the Workspace Environment, Linetypes, and Hatch Patterns 905 Using Workspaces 905 Customizing the User Interface 907 Taking a Quick Customization Tour 907 Understanding the Customizations In All Files Panel 912 Getting the Overall View 915 Finding Commands in the Command List 916 Opening Preview, Button Image, and Shortcuts 916 Getting to the Core of Customization in the Properties Group 917 Creating Your Own Ribbon Panels and Menus 918 Customizing Ribbon Panel Tools 920 Creating Macros in Tools and Menus 923 Pausing for User Input 925 Opening an Expanded Text Box for the Macro Option 925 Editing Keyboard Shortcuts 926 Saving, Loading, and Unloading Your Customizations 929 Understanding the DIESEL Macro Language 932 Using DIESEL at the Command Line 932 Using DIESEL in a Custom Menu Macro 934 Using DIESEL as a Menu Bar Option Label 935 Using DIESEL and Fields to Generate Text 936 Creating Custom Linetypes 938 Viewing Available Linetypes 939 Creating a New Linetype 940 Understanding the Linetype Code 941 Creating Complex Linetypes 942 Creating Hatch Patterns 944 The Bottom Line 947 Chapter 25 Managing and Sharing Your Drawings 949 Sharing Drawings Online 949 Sharing Project Files with eTransmit 950 Creating Additional Transmittal Setup Options 952 Publishing Your Drawings 954 Exchanging Drawing Sets 954 Exploring Other Publish Options 957 Creating a PDF or DWF File by Using the Plot Dialog Box 959 Sharing Views for Commenting 961 Using the Shared Views Tool 961 Using the Autodesk Viewer Web Page 964 Adding Hyperlinks to Drawings 965 Creating Hyperlinks 965 Editing and Deleting Hyperlinks 968 Taking a Closer Look at the Hyperlink Options 968 Managing Your Drawings with DesignCenter and the Tool Palettes 969 Getting Familiar with DesignCenter 970 Opening and Inserting Files with DesignCenter 973 Finding and Extracting the Contents of a Drawing 974 Exchanging Data between Open Files 978 Loading Specific Files into DesignCenter 979 Customizing the Tool Palettes with DesignCenter 980 Comparing Drawing Versions to Discover Changes 985 Using the Drawing Compare Tool 985 Looking at the Compare Tab Tools 987 Establishing Office Standards 987 Establishing Layering and Text Conventions 987 Checking Office Standards 988 Converting Multiple Layer Settings 993 Exploring Other Layer Translator Options 995 The Bottom Line 996 Part 6 Appendices 999 Appendix A The Bottom Line 1001 Chapter 1: Exploring the Interface 1001 Chapter 2: Creating Your First Drawing 1001 Chapter 3: Setting Up and Using the Drafting Tools 1002 Chapter 4: Organizing Objects with Blocks and Groups 1003 Chapter 5: Keeping Track of Layers and Blocks 1003 Chapter 6: Editing and Reusing Data to Work Efficiently 1004 Chapter 7: Mastering Viewing Tools, Hatches, and External References 1005 Chapter 8: Introducing Printing, Plotting, and Layouts 1005 Chapter 9: Adding Text to Drawings 1006 Chapter 10: Using Fields and Tables 1007 Chapter 11: Using Dimensions 1007 Chapter 12: Using Attributes 1008 Chapter 13: Copying Existing Drawings from Other Sources 1009 Chapter 14: Advanced Editing and Organizing 1010 Chapter 15: Laying Out Your Printer Output 1010 Chapter 16: Making “Smart” Drawings with Parametric Tools 1011 Chapter 17: Using Dynamic Blocks 1012 Chapter 18: Drawing Curves 1012 Chapter 19: Getting and Exchanging Data from Drawings 1014 Chapter 20: Creating 3D Drawings 1015 Chapter 21: Using Advanced 3D Features 1016 Chapter 22: Editing and Visualizing 3D Solids 1017 Chapter 23: Exploring 3D Mesh and Surface Modeling 1018 Chapter 24: Customizing the Workspace Environment, Linetypes, and Hatch Patterns 1019 Chapter 25: Managing and Sharing Your Drawings 1020 Appendix B Installing and Setting Up AutoCAD 1021 Before Installing AutoCAD 1021 Proceeding with the Installation 1021 Configuring AutoCAD 1022 The Files Tab 1023 The Display Tab 1025 The Open And Save Tab 1027 The Plot and Publish Tab 1030 The System Tab 1030 The User Preferences Tab 1032 The Drafting Tab 1034 The 3D Modeling Tab 1035 The Selection Tab 1037 The Profiles Tab 1039 Turning On the Noun/Verb Selection Method 1040 Turning on the Grips Feature 1040 Setting Up the Tracking Vector Feature 1041 Adjusting the AutoCAD 3D Graphics System 1041 Finding Folders That Contain AutoCAD Files 1041 Setting Up AutoCAD with a White Background 1042 Appendix C The Autodesk AutoCAD 2021 Certification 1043 Index 1047

Read more less

Book SynopsisRichard Lawrence is co-owner of the consulting firm Agile For All. He trains and coaches people to collaborate more effectively with other people to solve complex, meaningful problems. He draws on a diverse background in software development, engineering, anthropology, and political science. Richard was an early adopter of behavior-driven development and led the development of the first .NET version of Cucumber, Cuke4Nuke. He is a popular speaker at conferences on BDD and Agile software development. Paul Rayner co-founded and co-leads DDD Denver. He regularly speaks at local user groups and at regional and international conferences. If you are looking for an expert hands-on team coach and design mentor in domain-driven design (DDD), BDD with Cucumber, or lean/agile processes, Paul is available for consulting and trainTable of Contents Chapter 1: Focusing on Value When Scrum Isn’t Enough Finding a High-Value Feature to Start With Before You Start with Cucumber Finding the First MMF Slicing an MMF into User Stories Summary Reference Chapter 2: Exploring with Examples BDD Is a Cooperative Game BDD Is a Whole Team Thing Allow Time and Space to Learn Flesh Out the Happy Path First Use Real Examples Example Mapping Gives the Discussion Structure Optimizing for Discovery Addressing Some Concerns Treat Resistance as a Resource Playing the BDD Game Opening Exploring Closing Summary References Chapter 3: Formalizing Examples into Scenarios Moving from Examples to Scenarios Feature Files as Collaboration Points BDD Is Iterative, Not Linear Finding the Meaningful Variations Gherkin: A Language for Expressive Scenarios Summary Resources Chapter 4: Automating Examples The Test Automation Stack Adjusting to Working Test-First Annotating Element Names in Mockups How Does User Experience Design Fit In to This? Did They Really Just Hard Code Those Results? Anatomy of a Step Definition Simple Cucumber Expressions Regular Expressions Anchors Wildcards and Quantifiers Capturing and Not Capturing Just Enough Custom Cucumber Expressions Parameter Types Beyond Ruby Slow Is Normal (at First) Choose Cucumber Based on Audience, Not Scope Summary Chapter 5: Frequent Delivery and Visibility How BDD Changes the Tester’s Role Exploratory Testing BDD and Automated Builds Faster Stakeholder Feedback How Getting to Done More Often Changes All Sorts of Things Frequent Visibility and Legacy Systems Documentation: Integrated and Living Avoiding Mini-Waterfalls and Making the Change Stick Summary References Chapter 6: Making Scenarios More Expressive Feedback About Scenarios How to Make Your Scenarios More Expressive Finding the Right Level of Abstraction Including the Appropriate Details Expressive Language in the Steps Refactoring Scenarios Good Scenario Titles Summary References Chapter 7: Growing Living Documentation What Is Living Documentation and Why Is It Better? Cucumber Features and Other Documentation Avoid Gherkin in User Story Descriptions The Unexpected Relationship Between Cucumber Features and User Stories Stable Scenarios Growing and Splitting Features Split When Backgrounds Diverge Split When a New Domain Concept Emerges Secondary Organization Using Tags Structure Is Emergent Summary Chapter 8: Succeeding with Scenario Data Characteristics of Good Scenarios Independent Repeatable Researchable Realistic Robust Maintainable Fast Sharing Data When to Share Data Raising the Level of Abstraction with Data Personas Data Cleanup Summary Reference Chapter 9: Conclusion 9780321772633 TOC 4/22/2019

Read more less

Book SynopsisA thorough update to the industry standard for designing, developing, and deploying data warehouse and business intelligence systems The world of data warehousing has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998.Table of ContentsChapter 1 Introducing the Kimball Lifecycle 1 Chapter 2 Launching and Managing the Project/Program 15 Chapter 3 Collecting the Requirements 63 Chapter 4 Introducing the Technical Architecture 109 Chapter 5 Creating the Architecture Plan and Selecting Products 179 Chapter 6 Introducing Dimensional Modeling 233 Chapter 7 Designing the Dimensional Model 287 Chapter 8 Designing the Physical Database and Planning for Performance 327 Chapter 9 Introducing Extract, Transformation, and Load 369 Chapter 10 Designing and Developing the ETL System 425 Chapter 11 Introducing Business Intelligence Applications 473 Chapter 12 Designing and Developing Business Intelligence Applications 505 Chapter 13 Deploying and Supporting the DW/BI System 541 Chapter 14 Expanding the DW/BI System 579

Read more less

Book SynopsisThis text provides solutions to the most labour and time intensive part of data warehouse development.Table of ContentsAcknowledgments. About the Authors. Introduction. Part I: Requirements, Realities, and Architecture. Chapter 1: Surrounding the Requirements. Chapter 2: ETL Data Structures. Part II: Data Flow. Chapter 3: Extracting. Chapter 4: Cleaning and Conforming. Chapter 5: Delivering Dimension Tables. Chapter 6: Delivering Fact Tables. Part III: Implementation and operations. Chapter 7: Development. Chapter 8: Operations. Chapter 9: Metadata. Chapter 10: Responsibilities. Part IV: Real Time Streaming ETL Systems. Chapter 11: Real-Time ETL Systems. Chapter 12: Conclusions. Index.

Read more less

Book SynopsisSuitable for readers intrigued by 3D video games as a hobby or a potential career, this book offers an introduction to the world of 3D game animation and provides step-by-step instructions on creating storyboards, scenery, characters, and even software. It covers topics such as working with 3D coordinates, keyframing, NURBS modeling, and lighting.Table of ContentsIntroduction 1 About This Book 1 Conventions Used in This Book 2 Foolish Assumptions 3 How This Book Is Organized 3 Part I: Creating 3D Content for Games 3 Part II: Creating Interfaces, Modeling Scenery, and Texturing Backgrounds 3 Part III: Designing, Modeling, and Animating Game Characters 4 Part IV: Animating Game Cut Scenes 4 Part V: The Part of Tens 4 Icons Used in This Book 4 Part I: Creating 3D Content for Games 5 Chapter 1: Getting Started with 3D Game Animation 7 This Whole Place Is Full of 3D — Identifying 3D Game Elements 8 User interfaces 8 Backgrounds 9 Scenery and props 10 Characters 10 Cut scenes 11 Opening the Toolbox — the Tools Used to Create 3D Game Animations 11 Modeling, rendering, and animation software 12 Paint and texturing software 15 Compositing software 15 Hardware requirements 15 Creating 3D Games — Slightly More Complicated Than a Connect-the-Dots Puzzle 16 Game design 16 Art design 17 Integration 17 Testing 17 Learning the Big Picture 17 Chapter 2: Game and Art Design, and Creating Storyboards 19 Documenting the Game Design: What Exactly Does This Game Do? 20 Brainstorming 20 Gathering feedback 20 Writing a Game Design Document 21 Adding flowcharts 21 Obtaining approval 23 Growing Ideas into Design — Beginning the Art Design Phase 23 Sketching inspirations: You didn’t throw away your pencils, did you? 23 Compiling reference materials 24 Fleshing out details, and producing final designs 25 Labeling details 25 Creating Storyboard Documents 25 Types of storyboards 26 Specifying logical flow paths 26 Storyboarding cut scenes 27 Creating a master storyboard 27 Who’s Talking Now? Adding Dialogue 27 Chapter 3: Starting with Traditional Animation Basics 29 Layering Images — the Simplest Animation Technique 30 Look at the Birdie and Smile — Focusing the Audience’s View 30 Avoid complex motions 31 Displaying anticipation of intended motion 31 Emphasizing motion with exaggeration 32 Making foreground objects stand out 32 Do You Have a Good Stopwatch? Controlling Timing and Pacing 32 Establishing correct timing 33 Establishing pacing 34 Do I Need to Draw Every Frame? Accomplishing Efficient Animation Techniques 34 Posing characters and in-betweening 34 Using animation loops 35 Panning images 35 Animating Realistic Motions 36 Animating physically realistic reactions 36 Making realistic motion with primary and secondary motion 36 Developing a Unique Style 37 Part II: Creating Interfaces, Modeling Scenery, and Texturing Backgrounds 39 Chapter 4: Creating Game User Interfaces 41 Understanding the Basics of Interface Design 41 Identifying interface information 42 Defining interface backgrounds 43 Using interface fade in and fade out 43 Making the interface easy to navigate 43 Including sounds 44 Making the game area as big as possible: Maximizing interface real estate 44 Starting with a Layout: The Process of Interface Design 44 Importing drawing files 45 Building a 2D layout 45 Adding 3D Effects 54 Enhancing with 3D objects 54 Embellishing with 3D text 55 Beveling the interface border 57 Chapter 5: Modeling Scenery and Props 59 Discovering 3D Space All Around You 60 Moving about 3D Coordinates 60 Selecting scene views 61 Navigating scene views 62 Using coordinate values 64 Exploring the Various Modeling Types 65 Polygon modeling for man-made models 65 NURBS modeling for natural flowing surfaces 65 Patch modeling for curved surfaces 66 Moving, Rotating, and Scaling Objects 66 Transforming objects 66 Snapping objects into place 67 Aligning objects 70 Using pivot points 72 Learning the Art of Modeling 73 Using the easiest way to model 73 Starting with building blocks 75 Editing primitives 77 Building surfaces from curves and splines 78 Creating Lo-Polygon Models That Won’t Choke a Game Engine 83 Tips for reducing polygon count 83 Automating polygon reduction 85 Chapter 6: Adding Details with Materials 87 Defining Materials 87 Color 88 Transparency 88 Reflectivity 88 Refraction 88 Luminosity 88 Specularity 88 Bump map 89 Assigning Material Properties to Objects 89 Changing the view shading 89 Using preset materials 90 Creating unique materials 93 Assigning Material Properties to Object Parts 95 Chapter 7: Mapping Textures 97 Wrapping Texture Maps about Objects without Messy Glues 98 Positioning Textures with UV Coordinates 100 Offsetting a texture 100 Scaling a texture 101 Rotating a texture 101 Tiling a texture 101 Creating Seamless Textures That Tile Together: Look Ma, No Seams 103 Creating noisy tiles 104 Filling a solid tile 104 Matching opposite edges 104 Creating Raised Texture with Bump and Displacement Maps 106 Using bump maps 106 Using displacement maps 107 Creating Realistic Environments with Textures 107 Using reflection maps 108 Adding a background image 109 Creating a skybox for backdrops 110 Painting on Textures to Add Dirt and Grime 111 Efficiently Coloring Objects with Vertex Colors 113 Baking Textures for Quick Model Loading 113 Chapter 8: Creating Effective Lighting 115 Starting with a Basic Three-Point Lighting Configuration 116 Exploring the Different Light Types 117 Point light 117 Area light 117 Direct light 117 Ambient light 117 Spot light 117 Creating Lights 118 Changing Light Properties 120 Using light color 120 Changing light intensity 120 Enabling shadows 122 Setting falloff 124 Using Light Special Effects 124 Adding lens flares 124 Adding fog 126 Making glowing lights 126 Creating Realistically Lighted Scenes with Raytracing, Radiosity, and Global Illumination 128 Raytracing 128 Radiosity 129 Global illumination 129 Creating a Prelighted Map for Quick Scene Loading 130 Part III: Designing, Modeling, and Animating Game Characters 131 Chapter 9: Techniques for Modeling Characters 133 Modeling Methods 134 Knowing when to buy instead of build 134 Creating low-polygon models 134 Using symmetry 134 Using a default stance 134 Using mesh smooth features 135 Modeling the Torso 135 Chamfering edges 137 Sculpting muscles 137 Cutting limb holes 141 Creating and Attaching Limbs 142 Tapering limbs 144 Lofting limbs 146 Connecting limbs 146 Bridging limbs 148 Modeling Hands and Feet 148 Extruding fingers 148 Adding a thumb 150 Modeling shoes 151 Creating toes 153 Adding nails 153 Connecting hands and feet 153 Mirroring the Body 155 Making the Body Proportional 156 Getting “Ahead”: Creating a Head 158 Extruding a neck 159 Using Booleans 160 Modeling the windows to the soul: Creating eyes 161 Creating a nose 164 Creating ears 166 Creating a mouth 166 Adding facial hair 168 Sculpting the head 168 Creating Hair 170 Adding Accessory Props 170 Modeling clothes 170 Dressing a head 171 Adding jewelry 171 Embedding weapons and props 171 Chapter 10: Discovering the Basics of 3D Animation 173 Pacing an Animation with Frame Rates: What’s the Going Rate? 174 Changing the frame rate 175 Setting the total number of frames 176 Moving the Time Slider to select a frame 176 Creating Simple Animations with Keyframes 177 Animating an object by creating position keyframes 177 Animating an object with rotation and scale keyframes 179 Creating an attribute keyframe 181 Locating keyframes with the Animation Controls 183 Copying and pasting keyframes 184 Automating the creation of keyframes with Auto Keyframing 184 Moving an Object Along a Path 184 Animating an object moving along a path 185 Tracking an object’s motion with trajectories 185 Ghosting objects to get a sense of their motion 186 Using Animation Editors 187 Viewing animation graphs 187 Synchronizing animation keys 188 Chapter 11: Animating Characters 193 Rigging Characters to Move Realistically 194 Creating a skeleton that lies under the character 194 Setting constraints so the object doesn’t move when it shouldn’t 198 Controlling character motion with kinematics 199 Creating a Realistic Skin 201 Skinning a character 201 Setting a bone’s influence 202 Adding deformations to create muscle bulges 203 Animating with Bones 204 Integrating Motion Capture for the Ultimate in Realistic Motion 207 Lots of dots: Motion capture hardware 207 Unique motion capture systems 208 Buying motion 208 Chapter 12: Animating Facial Movements 209 Creating Morph Targets: The Character of a Thousand Faces 210 Working on a clone 210 Creating a blend control 211 Learning to Talk: Speaking the Basic Phonemes 213 Syncing Facial Movements with a Soundtrack 213 Building Controls for Handling Eye Movements 214 Chapter 13: Automating Reactions with Dynamics 217 Incorporating Physics: I’m Glad I Don’t Have to Calculate This by Hand 217 Soft and rigid body objects 218 Special object types 218 Making objects immovable 218 Defining Physical Properties Such as Gravity and Friction 220 Defining object properties 221 Defining forces 221 Using constraints 223 Part IV: Animating Game Cut Scenes 227 Chapter 14: Animating Scene Elements 229 Using Cut Scenes: All the Stuff That Happens Between Game Levels 230 The pregame show 230 Introducing the game 230 Explaining the game 231 Tell a story with animation 231 Presenting High-Resolution Images: What to Do After the Animations Are Finished 231 Rendering backgrounds 231 Rendering a title screen 231 Rendering marketing materials 231 Animating Cut Scenes: No Limits 232 Modeling for cut scenes: I can use NURBS! 232 Animating cameras: I finally have a chance to control the camera! 234 Animating lights (and not just a flashlight) 236 Animating textures: Just like television 237 Chapter 15: Animating with Particles 241 Creating Special Effects with Particles: A Treat for All the Pyromaniacs 241 Creating smoke and dust 242 Creating fire 242 Creating clouds 242 Pinpointing a Particle’s Starting Location with Particle Emitters 244 Using emitter types 244 Using an object as an emitter 245 Configuring Particle Systems: Randomness Is the Name of the Game 246 Setting particle rate 246 Setting particle life span 247 Setting particle shape and size 247 Spawning new particles 247 Changing particle materials 247 Creating a Blizzard: Combining Particles with Dynamics 249 Creating a Custom Particle with Instanced Objects: When Simple Shaped Particles Aren’t Enough 251 Chapter 16: Rendering an Animation 253 Creating Test Renders: Try It before You Buy It 253 Using the Render View window 254 Rendering an area 255 Selecting a view and range 256 Making animation previews 256 Exploring the Rendering Options 257 Selecting a format 258 Setting resolution 258 Using network rendering 258 Adding Effects at the Last Minute 258 Enabling anti-aliasing 259 Using the depth of field effect 259 Adding atmospheric effects 260 Adding motion blur 260 Raytracing Images for Realism 261 Cartoon Rendering: Saturday Morning Will Never Be the Same 262 Part V: The Part of Tens 265 Chapter 17: Ten Types of Tools Used by Game Companies 267 Introducing Your New Best Friend: 3D Modeling, Rendering, and Animation Tools 268 Maya 269 3ds max 269 Softimage XSI 269 Lightwave 270 Remembering Your Old Friends: 2D Painting and Drawing Tools 270 Photoshop 271 Illustrator 271 Painter 271 Z-Brush 271 Getting a Little Extra Realism: 3D Rendering Systems 272 Brazil Rendering System 272 Mental Ray Rendering System 272 Putting All the Pieces Together: Compositing Packages 272 After Effects 273 Combustion 273 Digital Fusion 273 Removing What Shouldn’t Be There: Video Editing Tools 273 Premiere 274 Final Cut Pro 274 Taking Your Designs Online: Web Creation Tools 274 Flash 274 GoLive 274 Making Your Voice Heard: Audition, an Audio Editing Tool 275 Animating Characters the Easy Way: Motion Capture Systems 275 Vicon Motion Systems 275 Motion Analysis 276 Animating a Talking Face: Lip Synching Systems 276 LifeStudio: HEAD 276 LipSync 276 Speaking the Programmers’ Language: 3D Programming Tools 276 DirectX 277 OpenGL 277 Chapter 18: Ten Creative Jobs in the Animation Industry 279 Producer/Director 280 Game Designer 280 Game Artists 281 3D Modeler 282 Lighting Director 283 Animator 283 Special Effects Artist 284 Tester 284 Grunt 285 Trainer 285 Chapter 19: Ten Ways to Land a Job as a 3D Game Animator 287 Gaining the Necessary Experience: First Things First 288 Developing software skills 288 Getting involved in creating games 289 Studying games 290 Finding Animation Programs and Schools 290 Knowing which degree to earn 291 Knowing which courses to take 292 Showing Off: Creating an Awesome Demo Reel 293 Creating a demo reel 294 Labeling a demo reel 295 Sending out demo reels 295 Establishing a Web Presence 295 Securing a domain name 296 Building an amazing Web site 296 Adding your work to an online gallery 297 Getting Feedback and Exposure 298 Entering Web animation contests 298 Entering animation festivals 299 Improving Your Skills 299 Learning from books 299 Training by video 300 Using Web tutorials 300 Attending workshops 300 Joining a user group 300 Attending Animation Conferences 300 Joining a Professional Organization 301 Knowing the Right People 302 Working Your Way Up 302 Getting your foot in the door 302 Getting on a beta test team 303 Starting as a junior animator 303 Making an internal move 304 Being Persistent 304 Appendix A: Using Game Engine Tools 305 Selecting a Game Engine 305 Using Game Engine Tools 308 Creating a User Interface 308 Accessing the GUI Editor 309 Creating a new GUI page 310 Adding controls and commands to a GUI page 312 Using the Mission Editor 313 Accessing the Mission Editor 315 Creating a terrain 316 Adjusting the Terraform 318 Texturing the terrain 319 Populating the environment 321 Moving objects 323 Defining the Scene Environment 323 Loading Maya Files into the Game Engine 326 Installing a DTS Export Utility 326 Changing default units 327 Exporting a Maya object 328 Viewing exported objects 329 Exporting textured objects 330 Exporting animation sequences 332 Making models available in the Mission Editor 333 Creating Interiors 334 Appendix B: Glossary of Animation Terms 337 Appendix C: Directory of Animation Schools 351 The Art Institutes 351 Ringling School of Art and Design 351 Full Sail 352 California Institute of the Arts 352 Vancouver Film School 352 Sheridan College 352 Savannah College of Art and Design 352 DigiPen Institute of Technology 353 Parsons School of Design 353 Digital Media Arts College 353 Ex’pression College for Digital Arts 353 Vancouver Institute of Media Arts 353 Academy of Art University 354 Gnomon, School of Visual Effects for Film, Television and Games 354 Oregon3D 354 Index 355

Read more less

Book SynopsisThis bestselling guide to Microsoft Word is the first and last word on Word 2013 It's a whole new Word, so jump right into this book and learn how to make the most of it.Table of ContentsIntroduction 1 Part I: Getting Started with Word 2013 7 Chapter 1: Hello, Word! 9 Chapter 2: The Typing Chapter 21 Part II: Your Basic Word 31 Chapter 3: To and Fro in a Document 33 Chapter 4: Text Editing 41 Chapter 5: Search for This, Replace It with That 49 Chapter 6: Blocks o’ Text 61 Chapter 7: Spell It Write 73 Chapter 8: Document Calisthenics: New, Open, Save, and Close 83 Chapter 9: Publish Your Document 95 Part III: Fun with Formatting 107 Chapter 10: Character Formatting 109 Chapter 11: Paragraph Formatting 121 Chapter 12: Tab Formatting 133 Chapter 13: Page Formatting 149 Chapter 14: Document Formatting 161 Chapter 15: Style Formatting 173 Chapter 16: Template and Themes Formatting 185 Chapter 17: Sundry Formatting 195 Part IV: Spruce Up a Dull Document 205 Chapter 18: Lines and Shading 207 Chapter 19: Able Tables 215 Chapter 20: Columns of Text 227 Chapter 21: Lots of Lists 233 Chapter 22: Here Come the Graphics 241 Chapter 23: Fun with the Insert Tab 255 Part V: The Rest of Word 265 Chapter 24: Multiple Documents, Windows, and File Formats 267 Chapter 25: Word for Writers 275 Chapter 26: Let’s Work This Out 289 Chapter 27: Mail Merge Mania 299 Chapter 28: Labels of Love 315 Chapter 29: A More Custom Word 323 Part VI: The Part of Tens 331 Chapter 30: The Ten Commandments of Word 333 Chapter 31: Ten Cool Tricks 337 Chapter 32: Ten Bizarre Things 345 Chapter 33: Ten Avuncular Suggestions 351 Index 355

Read more less

Book SynopsisGet the most out of Excel 2013 with this exceptional advice from Mr. Spreadsheet himself! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka Mr.Table of ContentsIntroduction 1 What You Should Know 1 What You Should Have 1 Conventions in This Book 2 Formula listings 2 Key names 2 The Ribbon 2 Functions, procedures, and named ranges 3 Mouse conventions 3 What the icons mean 3 How This Book Is Organized 4 How to Use This Book 4 About the Power Utility Pak Offer 4 Part I: Workbooks and Files Tip 1: Changing the Look of Excel 7 Tip 2: Customizing the Quick Access Toolbar 10 Tip 3: Customizing the Ribbon 14 Tip 4: Understanding Protected View 17 Tip 5: Understanding AutoRecover 20 Tip 6: Using a Workbook in a Browser 22 Tip 7: Saving to a Read-Only Format 24 Tip 8: Generating a List of Filenames 27 Tip 9: Generating a List of Sheet Names 29 Tip 10: Using Document Themes 32 Tip 11: Understanding Excel Compatibility Issues 37 Tip 12: Where to Change Printer Settings 39 Part II: Formatting Tip 13: Working with Merged Cells 43 Tip 14: Indenting Cell Contents 48 Tip 15: Using Named Styles 50 Tip 16: Creating Custom Number Formats 54 Tip 17: Using Custom Number Formats to Scale Values 58 Tip 18: Creating a Bulleted List 60 Tip 19: Shading Alternate Rows Using Conditional Formatting 62 Tip 20: Formatting Individual Characters in a Cell 65 Tip 21: Using the Format Painter 66 Tip 22: Inserting a Watermark 68 Tip 23: Showing Text and a Value in a Cell 70 Tip 24: Avoiding Font Substitution for Small Point Sizes 72 Tip 25: Updating Old Fonts 75 Part III: Formulas Tip 26: Resizing the Formula Bar 81 Tip 27: Monitoring Formula Cells from Any Location 83 Tip 28: Learning Some AutoSum Tricks 85 Tip 29: Knowing When to Use Absolute and Mixed References 87 Tip 30: Avoiding Error Displays in Formulas 90 Tip 31: Creating Worksheet-Level Names 92 Tip 32: Using Named Constants 94 Tip 33: Sending Personalized E-Mail from Excel 96 Tip 34: Looking Up an Exact Value 99 Tip 35: Performing a Two-Way Lookup 101 Tip 36: Performing a Two-Column Lookup 103 Tip 37: Calculating Holidays 105 Tip 38: Calculating a Person’s Age 108 Tip 39: Working with Pre-1900 Dates 110 Tip 40: Displaying a Live Calendar in a Range 114 Tip 41: Returning the Last Nonblank Cell in a Column or Row 116 Tip 42: Various Methods of Rounding Numbers 118 Tip 43: Converting Between Measurement Systems 121 Tip 44: Counting Nonduplicated Entries in a Range 123 Tip 45: Using the AGGREGATE Function 125 Tip 46: Making an Exact Copy of a Range of Formulas 128 Tip 47: Using the Background Error-Checking Features 130 Tip 48: Using the Inquire Add-In 132 Tip 49: Hiding and Locking Your Formulas 135 Tip 50: Using the INDIRECT Function 138 Tip 51: Formula Editing in Dialog Boxes 141 Tip 52: Converting a Vertical Range to a Table 142 Part IV: Working with Data Tip 53: Selecting Cells Efficiently 147 Tip 54: Automatically Filling a Range with a Series 151 Tip 55: Fixing Trailing Minus Signs 154 Tip 56: Restricting Cursor Movement to Input Cells 155 Tip 57: Transforming Data with and Without Using Formulas 157 Tip 58: Creating a Drop-Down List in a Cell 160 Tip 59: Comparing Two Ranges by Using Conditional Formatting 162 Tip 60: Finding Duplicates by Using Conditional Formatting 165 Tip 61: Working with Credit Card Numbers 168 Tip 62: Identifying Excess Spaces 170 Tip 63: Transposing a Range 173 Tip 64: Using Flash Fill to Extract Data 176 Tip 65: Using Flash Fill to Combine Data 179 Tip 66: Inserting Stock Information 181 Tip 67: Getting Data from a Web Page 184 Tip 68: Importing a Text File into a Worksheet Range 188 Tip 69: Using the Quick Analysis Feature 190 Tip 70: Filling the Gaps in a Report 192 Tip 71: Performing Inexact Searches 194 Tip 72: Proofing Your Data with Audio 196 Tip 73: Getting Data from a PDF File 198 Part V: Tables and Pivot Tables Tip 74: Understanding Tables 205 Tip 75: Using Formulas with a Table 208 Tip 76: Numbering Table Rows Automatically 212 Tip 77: Identifying Data Appropriate for a Pivot Table 214 Tip 78: Using a Pivot Table Instead of Formulas 218 Tip 79: Controlling References to Cells Within a Pivot Table 222 Tip 80: Creating a Quick Frequency Tabulation 224 Tip 81: Grouping Items by Date in a Pivot Table 227 Tip 82: Creating Pivot Tables with Multiple Groupings 230 Tip 83: Using Pivot Table Slicers and Timelines 232 Part VI: Charts and Graphics Tip 84: Understanding Recommended Charts 239 Tip 85: Customizing Charts 241 Tip 86: Making Charts the Same Size 243 Tip 87: Creating a Chart Template 245 Tip 88: Creating a Combination Chart 247 Tip 89: Handling Missing Data in a Chart 250 Tip 90: Using High-Low Lines in a Chart 252 Tip 91: Using Multi-Level Category Labels 253 Tip 92: Linking Chart Text to Cells 255 Tip 93: Freezing a Chart 257 Tip 94: Creating a Chart Directly in a Range 260 Tip 95: Creating Minimalistic Charts 264 Tip 96: Applying Chart Data Labels from a Range 268 Tip 97: Grouping Charts and Other Objects 270 Tip 98: Taking Pictures of Ranges 273 Tip 99: Changing the Look of Cell Comments 276 Tip 100: Enhancing Images 279 Tip 101: Saving Shapes, Charts, and Ranges as Images 281 Index 283

Read more less

Book SynopsisTable of Contents Introduction 1 About This Book 1 Foolish Assumptions 2 Icons Used in This Book 2 Beyond the Book 3 Where to Go from Here 3 Part 1: Creating, Navigating, and Saving Projects 5 Chapter 1: Navigating Illustrator’s Interface 7 Surveying the Illustrator Universe 8 Launching Illustrator 8 Using and Customizing Toolbars 10 Accessing and Arranging Panels 11 Using the Control Panel or the Properties Panel 12 Choosing between the Control and Properties panels 13 Options on the Control and Properties panels 13 Chapter 2: Creating, Saving, Exporting, and Printing Files 15 Creating Documents 16 Making basic choices for a document 16 Using presets 17 Defining color mode, artboard size, and raster resolution 18 Deploying Artboards 20 Defining artboards 20 Using artboards for a multidimensional project 23 Exporting, Saving, and Printing 27 Saving Illustrator files 27 Exporting files 29 Using artboards and assets for output 29 Communicating with your printer 30 Chapter 3: Placing and Tracing Artwork 31 Placing Artwork 32 Embedding and linking files 32 Placing text in a shape or path 34 Cropping rasters 35 Using clipping masks 35 Importing Sketches from Adobe Illustrator Draw 37 Tracing Raster Images 38 Chapter 4: Drawing Lines and Shapes 43 Building Graphics with Basic Shapes 44 Generating shapes 45 Clicking to generate shapes 46 Drawing shapes interactively 51 Applying Shape Properties from the Control Panel 52 Reshaping Shapes 54 Building Complex Shapes 58 Creating a compound path 58 Using Pathfinder to combine shapes 59 Drawing Shapes with Perspective 63 Applying Isometric Effects to Shapes 66 Chapter 5: Selecting and Arranging Objects 69 Selecting in Illustrator 69 Selecting with tools 70 Using the Select menu 75 Grouping and Isolating Objects 77 Editing objects as groups 78 Editing objects within groups 79 Aligning and Spacing Objects 82 Locating objects with rulers, guides, and grids 82 Aligning with SmartGuides 85 Using the Align panel 85 Arranging Objects Front-to-Back 87 Chapter 6: Organizing Documents with Layers 89 Using a Template Layer 90 Organizing and Arranging Objects in Layers 92 Organizing Content within and between Layers 96 Locating objects in the Layers panel 96 Arranging objects within and between layers 97 Styling with Layers 97 Targeting layers 98 Changing the appearance of objects in layers 99 Applying Layers in Real-World Challenges 99 Part 2: Drawing and Editing Paths 101 Chapter 7: Wielding the Pen and Anchor Point Tools 103 Editing Anchors 104 Selecting and moving anchors 104 Converting open paths to closed paths and vice versa 106 Editing Curves with the Anchor Point Tool 107 Drawing with the Pen Tool 109 Creating curved, combination, and straight anchors with the Pen tool 109 Adding and deleting anchors 111 Wielding the Pen tool with shortcuts 112 Honing Pen tool skills with a waveform 113 Chapter 8: Creating Artwork with the Pencil, Curvature, and Blob Tools 117 Drawing with the Pencil Tool 118 Setting pencil curve smoothness 118 Managing the many modes of the Pencil tool 120 Setting Pencil tool options 121 Ironing Out Wrinkles with the Smooth Tool 122 Drawing and Editing Curves with the Curvature Tool 122 Drawing curves 123 Editing curves 123 Drawing Filled Paths with the Blob Brush Tool 124 Erasing with the Eraser Tool 127 Creating Shapes with the Shaper and Shape Builder Tools 127 Creating shapes with the Shaper tool 128 Combining shapes with Shape Builder 128 Animating with Puppet Warp 129 Fine-Tuning beyond Drawing Tools 131 Chapter 9: Painting with Brushes 133 Unleashing Your Creativity with Brushes 133 Painting with the Paintbrush 135 Applying Brushes to Paths 136 Working with the Brushes panel 136 Navigating the Brush libraries 137 Creating DIY Brushes 139 Editing existing bristle brushes to create new ones 139 Crafting calligraphic brushes 144 Applying or designing art brushes 146 Defining scatter brushes 149 Creating pattern brushes 151 Using Brushes with a Drawing Tablet 155 Chapter 10: Improving Workflow with Symbols 157 Rationalizing Workflow with Symbols 158 Using Illustrator’s preset symbols 158 Adding symbols to a document 159 Managing symbols 162 Getting Creative with Dynamic Symbols 163 Creating dynamic symbols 163 Orchestrating dynamic symbol instances 164 Spraying Symbols 166 Setting Symbol Sprayer options 167 Managing sets of sprayed symbols 168 Part 3: Applying Color, Patterns, and Effects 169 Chapter 11: Designing in Living Color 171 Understanding Print versus Screen Color 172 Defining color for print 172 Choosing RGB color for screens 175 Understanding web safe color 176 Configuring grayscale 177 Managing the Color of Strokes and Fills 177 Apply color from the Tools panel 177 Apply color from the Control or Properties panel 179 Using Color Guides and Color Themes 180 Getting color advice 180 Styling with Adobe color themes 182 Managing Color Swatches 185 Adding colors to the Swatches panel 186 Changing the display of swatches 187 Creating and Merging Live Paint Groups 188 Creating Live Paint groups 189 Coloring Live Paint faces 190 Editing Live Paint edges 190 Controlling Live Paint faces and edges 192 Chapter 12: Bringing Graphics to Life with Gradients, Blends, and Transparency 197 Merging Colors with Gradients 198 Applying gradients 200 Unleashing linear gradients 201 Radiating radial gradients 207 Transforming gradients with Gradient Annotator 208 Using freeform gradients 209 Blending for Beauty and Productivity 212 Setting blend options 213 Working with blends 213 Applying Transparency 214 Defining and applying transparency 215 Clipping with opacity masks 218 Chapter 13: Designing with Patterns 221 Applying Patterns 222 Applying a pattern to a fill 223 Applying patterns to strokes 224 Applying patterns to text 225 Creating Your Own Patterns 226 Transforming Patterns 227 Scaling a pattern and object together 228 Scaling patterns and objects separately 229 Rotating and moving patterns 230 Moving a pattern within a shape 230 Stacking patterns 231 Defining Pattern Options 233 Chapter 14: Styling with Effects 237 Navigating the Universe of Effects 237 Getting your money’s worth from effects 238 Using Photoshop effects with care 239 Appreciating SVG filters 240 Choosing and Applying Effects 240 Managing Effects 242 Using the Appearance panel 242 Expanding effects 244 Saving graphic styles 246 Generating 3D Effects and Mapping Artwork 247 Mapping artwork 247 Using Adobe Stock images 248 Exploring 3D effects and mapping 248 Part 4: Designing with Type 253 Chapter 15: Formatting Area Type 255 Editing Area Type in Illustrator 256 Generating an area type box 256 Getting type from other apps 258 Using Illustrator’s proofing tools 259 Styling Area Type 260 Choosing type font and style 260 Sizing, leading, kerning, and tracking type 262 Sizing headlines to fit 263 Scaling area type 263 Using character styles 264 Formatting Paragraphs 266 Laying Out Area Type in Columns 267 Shaping Area Type 268 Placing area type in a path 268 Wrapping type around an object 270 Flowing Type from Box to Box 272 Converting Area Type to Point Type and Vice Versa 274 Chapter 16: Getting Artistic with Point Type 275 Understanding How Point Type Works 275 Creating and Editing Point Type 276 Contorting Point Type 278 Scaling point type 278 Rotating point type 279 Interactive Styling with the Touch Type Tool 280 Placing Type on Paths 281 Changing baseline shift on aligned type 282 Moving type on a path 283 Applying effects to type on a path 284 Sharing Fonts and Outlining Type 285 Sharing fonts 285 Outlining type 286 Part 5: Handing Off Graphics for Print and Screen Design 287 Chapter 17: Exporting Raster Files 289 Exporting in a Hurry 290 Maximizing Illustrator’s Export Options 293 Understanding the vector to raster journey 293 Orchestrating vector to raster workflow 294 Defining raster dimensions 295 Defining raster resolution 295 Navigating Illustrator’s Raster Output Options 296 Exporting to Specific Raster Formats 297 Exporting PNGs 297 Optimizing JPEGS 300 Handing off TIFF artwork to print 301 Relying on Your Team 303 Chapter 18: Unleashing the Power of SVGs 305 Understanding the Role of Scalable Vector Graphics 306 Defining an SVG-friendly environment 308 Exporting versus saving 311 Preparing Artwork for SVG Output 312 Simplifying paths for screen output 312 Reducing the file size with symbols 313 Applying Transparency and Effects to SVGs 314 Outputting SVGs with transparent backgrounds 315 Applying transparency effects to SVG 318 Applying SVG filters 321 Creating SVGs with Scalable, Searchable Type 324 Exploiting the value of scalable, searchable type 324 Optimizing type functionality by saving SVGs 326 Adding code snippets to SVG graphics 328 Exporting or Saving SVGs 329 Exporting SVGs for screens 330 Managing raster objects in SVGs 331 Saving SVGs for digital development 332 Part 6: The Part of Tens 335 Chapter 19: Top Ten Illustrator Resources 337 This Book’s Unofficial Website 337 Adobe Illustrator Official Documentation 338 Using Illustrator to Create SVG for the Web 339 A Unique Resource for Artistic Fashion Designers 339 Going Crazy with Illustrator 340 Style Tile Templates 341 Follow Jean-Claude Tremblay @jctremblay 341 Technical Drawing in Illustrator 342 Online Tutorials from Adobe 342 Illustrator CC Digital Classroom 343 Chapter 20: Top Ten Productivity Tips 345 Generate Layers 345 Use Shapes for Guides 346 Generate Guides from Rulers 347 Place Multiple Files 348 Import Photoshop Files 349 Edit Placed Objects 350 Import Word Files 351 Crop a Placed Image 351 Play Actions 352 Use Shortcut Keys 353 Index 355

Read more less

Book SynopsisSave on expensive professionals with this trusted bestseller! Running your own business is pretty cool, but when it comes to the financial sideaccounts and payroll, for instanceit's not so cool! That's why millions of small business owners around the world count on QuickBooks to quickly and easily manage accounting and financial tasks and save big time on hiring expensive professionals. In a friendly, easy-to-follow style, small business guru and bestselling author Stephen L. Nelson checks off all your financial line-item asks, including how to track your profits, plan a perfect budget, simplify tax returns, manage inventory, create invoices, track costs, generate reports, and pretty much any other accounts and financial-planning task that turns up on your desk! Keep up with the latest QuickBooks changesUse QuickBooks to track profits and financesBalance your budgetBack up your data safely The fully updated new edition of QuickBooks For Dummies takes the sweat (and the expense) out Table of ContentsIntroduction 1 About This Book 1 Foolish Assumptions 2 Icons Used in This Book 3 Beyond the Book 3 Where to Go from Here 3 Part 1: Quickly into QuickBooks 5 Chapter 1: QuickBooks: The Heart of Your Business 7 Why QuickBooks? 7 Why you need an accounting system 8 What QuickBooks does 9 Why not QuickBooks online? 10 What Explains QuickBooks’ Popularity? 11 What’s Next, Dude? 12 How to Succeed with QuickBooks 13 Budget wisely, Grasshopper 13 Don’t focus on features 14 Outsource payroll 15 Get professional help 16 Use both the profit and loss statement and the balance sheet 16 Chapter 2: The Big Setup 17 Getting Ready for QuickBooks Setup 17 The big decision 18 The trial balance of the century 19 The mother of all scavenger hunts 21 Stepping through QuickBooks Setup 23 Starting QuickBooks 23 Using the Express Setup 25 The Rest of the Story 32 Should You Get Your Accountant’s Help? 33 Chapter 3: Populating QuickBooks Lists 35 The Magic and Mystery of Items 35 Adding items you might include on invoices 37 Creating other wacky items for invoices 45 Editing items 49 Adding Employees to Your Employee List 49 Customers Are Your Business 51 It’s Just a Job 55 Adding Vendors to Your Vendor List 59 The Other Lists 63 The Fixed Asset Item list 63 The Price Level list 64 The Billing Rate Levels list 64 The Sales Tax Code list 65 The Class list 65 The Other Names list 65 The Sales Rep list 66 Customer, Vendor, and Job Types lists 66 The Terms list 67 The Customer Message list 67 The Payment Method list 67 The Ship Via list 68 The Vehicle list 68 The Memorized Transaction list 68 The Reminders list 68 Organizing Lists 69 Printing Lists 69 Exporting List Items to Your Word Processor 70 Dealing with the Chart of Accounts List 70 Describing customer balances 70 Describing vendor balances 71 Camouflaging some accounting goofiness 71 Supplying the missing numbers 77 Checking your work one more time 80 Part 2: Daily Entry Tasks 81 Chapter 4: Creating Invoices and Credit Memos 83 Making Sure That You’re Ready to Invoice Customers 84 Preparing an Invoice 84 Fixing Invoice Mistakes 91 If the invoice is still displayed onscreen 91 If the invoice isn’t displayed onscreen 91 Deleting an invoice 92 Preparing a Credit Memo 92 Fixing Credit Memo Mistakes 96 Printing Invoices and Credit Memos 96 Loading the forms into the printer 97 Setting up the invoice printer 97 Printing invoices and credit memos as you create them 100 Printing invoices in a batch 101 Printing credit memos in a batch 103 Sending Invoices and Credit Memos via Email 104 Customizing Your Invoices and Credit Memos 105 Chapter 5: Reeling in the Dough 107 Recording a Sales Receipt 108 Printing a Sales Receipt 112 Special Tips for Retailers 114 Correcting Sales Receipt Mistakes 115 Recording Customer Payments 116 Correcting Mistakes in Customer Payments Entries 121 Making Bank Deposits 121 Improving Your Cash Inflow 124 Tracking what your customers owe 124 Assessing finance charges 125 Dealing with deposits 129 Chapter 6: Paying the Bills 131 Pay Now or Pay Later? 131 Recording Your Bills by Writing Checks 132 The slow way to write checks 132 The fast way to write checks 138 Recording Your Bills the Accounts Payable Way 140 Recording your bills 141 Entering your bills the fast way 145 Deleting a bill 146 Remind me to pay that bill, will you? 147 Paying Your Bills 149 Tracking Vehicle Mileage 152 Paying Sales Tax 153 Chapter 7: Inventory Magic 155 Setting Up Inventory Items 156 When You Buy Stuff 157 Recording items that you pay for up front 157 Recording items that don’t come with a bill 157 Paying for items when you get the bill 159 Recording items and paying the bill all at once 161 When You Sell Stuff 161 How Purchase Orders Work 162 Customizing a purchase order form 163 Filling out a purchase order 163 Checking up on purchase orders 166 Receiving purchase order items 166 Assembling a Product 167 Identifying the components 167 Building the assembly 168 Time for a Reality Check 169 Dealing with Multiple Inventory Locations 171 Manually keep separate inventory-by-location counts 171 Use different item numbers for different locations 172 Upgrade to QuickBooks Enterprise Solutions 172 The Lazy Person’s Approach to Inventory 173 How periodic inventory systems work in QuickBooks 173 The good and bad of a periodic inventory 174 Chapter 8: Keeping Your Checkbook 175 Writing Checks 175 Writing checks from the Write Checks window 176 Writing checks from the register 177 Changing a check that you’ve written 179 Packing more checks into the register 180 Depositing Money in a Checking Account 181 Recording simple deposits 181 Depositing income from customers 182 Transferring Money between Accounts 185 Setting up a second bank account 185 Recording deposits into the new account 185 About the other half of the transfer 187 Changing a transfer that you’ve already entered 187 Working with Multiple Currencies 188 To Delete or to Void? 188 Handling NSF Checks from Customers 190 The Big Register Phenomenon 190 Moving through a big register 191 Finding that darn transaction 191 Chapter 9: Paying with Plastic 193 Tracking Business Credit Cards 193 Setting up a credit card account 194 Selecting a credit card account so that you can use it 195 Entering Credit Card Transactions 196 Recording a credit card charge 197 Changing charges that you’ve already entered 199 Reconciling Your Credit Card Statement and Paying the Bill 200 So What about Debit and ATM Cards? 201 So What about Customer Credit Cards? 201 Part 3: Stuff You Do from Time to Time 203 Chapter 10: Printing Checks 205 Getting the Printer Ready 205 Printing a Check 208 A few words about printing checks 209 Printing a check as you write it 209 Printing checks by the bushel 211 What if I make a mistake? 214 Oh where, oh where do unprinted checks go? 215 Printing a Checking Register 215 Chapter 11: Payroll 219 Getting Ready to Do Payroll without Help from QuickBooks 219 Doing Taxes the Right Way 220 Getting an employer ID number 220 Signing up for EFTPS 221 Employees and employers do their part 221 Getting Ready to Do Payroll with QuickBooks 221 Paying Your Employees 223 Paying Payroll Liabilities 226 Paying tax liabilities if you use a full-meal-deal payroll service 226 Paying tax liabilities if you don’t use a full-meal-deal payroll service 226 Paying other nontax liabilities 227 Preparing Quarterly Payroll Tax Returns 228 Using the Basic Payroll service 228 Using a full-meal-deal payroll service 228 Using the QuickBooks Enhanced Payroll service 228 Filing Annual Returns and Wage Statements 229 The State Wants Some Money Too 230 Chapter 12: Building the Perfect Budget 231 Is This a Game You Want to Play? 231 All Joking Aside: Some Basic Budgeting Tips 232 A Budgeting Secret You Won’t Learn in College 233 Setting Up a Secret Plan 234 Adjusting a Secret Plan 237 Forecasting Profits and Losses 237 Projecting Cash Flows 238 Using the Business Planner Tools 238 Chapter 13: Online with QuickBooks 239 Doing the Electronic Banking Thing 239 So what’s the commotion about? 239 A handful of reasons to be cautious about banking online 240 Making sense of online banking 243 Signing up for the service 243 Making an online payment 243 Transferring money electronically 245 Changing instructions 246 Transmitting instructions 246 Message in a bottle 247 A Quick Review of the Other Online Opportunities 248 Part 4: Housekeeping Chores 249 Chapter 14: The Balancing Act 251 Balancing a Bank Account 251 Giving QuickBooks information from the bank statement 252 Marking cleared checks and deposits 254 Eleven Things to Do If Your Nononline Account Doesn’t Balance 258 Chapter 15: Reporting on the State of Affairs 263 What Kinds of Reports Are There, Anyway? 263 Creating and Printing a Report 266 Visiting the report dog-and-pony show 268 Editing and rearranging reports 269 Reports Made to Order 272 Processing Multiple Reports 275 Your Other Reporting Options 275 Last but Not Least: The QuickReport 276 Chapter 16: Job Estimating, Billing, and Tracking 279 Turning On Job Costing 279 Setting Up a Job 280 Creating a Job Estimate 281 Revising an Estimate 284 Turning an Estimate into an Invoice 284 Comparing Estimated Item Amounts with Actual Item Amounts 286 Charging for Actual Time and Costs 287 Tracking Job Costs 288 Chapter 17: File Management Tips 289 Backing Up is (Not That) Hard to Do 289 Backing up the quick-and-dirty way 291 Getting back the QuickBooks data you backed up 296 Using the Accountant’s Copy 298 Working with Portable Files 299 Using an Audit Trail 300 Using a Closing Password 300 Chapter 18: Fixed Assets and Vehicle Lists 303 What is Fixed-Assets Accounting? 303 Fixed-Assets Accounting in QuickBooks 305 Setting Up a Fixed Asset List 306 Adding items to the Fixed Asset list 306 Adding fixed-asset items on the fly 308 Editing items in the Fixed Asset list 309 Tracking Vehicle Mileage 310 Identifying your vehicles 310 Recording vehicle miles 312 Using the vehicle reports 313 Updating vehicle mileage rates 313 Part 5: The Part of Tens 315 Chapter 19: Tips for Handling (Almost) Ten Tricky Situations 317 Tracking Depreciation 317 Selling an Asset 318 Selling a Depreciable Asset 319 Owner’s Equity in a Sole Proprietorship 320 Owner’s Equity in a Partnership 320 Owner’s Equity in a Corporation 321 Multiple-State Accounting 322 Getting a Loan 323 Repaying a Loan 323 Chapter 20: (Almost) Ten Secret Business Formulas 325 The First “Most Expensive Money You Can Borrow” Formula 326 The Second “Most Expensive Money You Can Borrow” Formula 328 The “How Do I Break Even?” Formula 328 The “You Can Grow Too Fast” Formula 331 How net worth relates to growth 331 How to calculate sustainable growth 332 The First “What Happens If ?” Formula 333 The Second “What Happens If ?” Formula 335 The Economic Order Quantity (Isaac Newton) Formula 337 The Rule of 72 338 Part 6: Appendixes 341 Appendix A: Installing QuickBooks in Ten Easy Steps 343 Appendix B: If Numbers Are Your Friends 347 Appendix C: Sharing QuickBooks Files 365 Index 375

Read more less

Book SynopsisMaster one of the most popular word processors ever with this essential, visual reference Teach Yourself VISUALLY: Word 2019 provides readers with a thorough and visual exploration of the 2019 edition of Microsoft Word. Written by the celebrated author of over 100 books on computing, Guy Hart-Davis, Teach Yourself VISUALLY: Word 2019 allows you to quickly get up to speed with one of the most popular word processors on the planet. The book covers all the topics you'll need to comprehensively master Word 2019, and includes: Full-color, step-by-step instructions showing you how to perform all the essential tasks of Microsoft Word 2019How to set up and format documents, edit them, and add images and chartsHow to post documents online for sharing and reviewing and take advantage of all the newest features of Word Newly updated to include the latest features of Microsoft Word, like how to collaborate on documents in real time, draw and write with the digital pen, new accessibility options and the new Resume Assistant, Teach Yourself VISUALLY: Word 2019 belongs on the shelf of anyone who wants to improve their effectiveness with this essential word processor.Table of ContentsChapter 1 Getting Started with Word Open Word and Use the Start Screen 4 Understanding Office and the Cloud 6 Explore the Word Window 8 Sign In to Your Account 9 Work with Backstage View 10 Change the Color Scheme and Background 12 Locate Commands on the Ribbon 14 Give Commands Using the Keyboard and Mouse 16 Using Word on Tablets and Phones 18 Using Word in OneDrive and Microsoft Teams 20 Work with the Mini Toolbar and Context Menus 22 Enter Text in a Document 24 Move the Insertion Point Around a Document 26 Switch Document Views 28 Understanding Document Views 29 Work with the Navigation Pane 30 Using Focus Mode 32 Using Immersive Reader 33 Chapter 2 Creating and Saving Documents Start a New Document 36 Save a Document to Your Computer 38 Save a Document to the Cloud 40 Recover an Unsaved Document 42 Save a Document in a Different Format 44 Save a Document in PDF or XPS Format 45 Set Options for Saving Documents 46 Open a Word Document 48 Open a Document That Uses a Different Format 50 Open a Document from the Cloud 52 Switch Between Open Documents 54 Compare Two Documents Side by Side 56 Chapter 3 Entering Text in Documents Insert and Add Text 60 Insert Symbols and Special Characters 62 Create a Hyperlink 64 Delete Text 66 Insert Blank Lines 68 Undo, Redo, and Repeat Changes 69 Select Text 70 Mark and Find Your Place with Bookmarks 72 Move or Copy Text 74 Share Text Between Documents 76 Move or Copy Several Selections 78 Take Advantage of Paste Options 80 Chapter 4 Editing and Proofing Text Work in Read Mode View 84 Zoom In or Out 88 Translate Text 89 Set Options for Additional Actions 90 Using Additional Actions 91 Search for Text 92 Replace Text or Other Items 94 Count Words in a Document 96 Automatically Correct Mistakes 98 Automatically Insert Frequently Used Text 100 Check Spelling and Grammar 102 Find Synonyms, Antonyms, and Definitions 104 Chapter 5 Formatting Text Understanding How Word’s Formatting Works 108 Change the Font 110 Change the Font Size 111 Emphasize Information with Bold, Italic, or Underline 112 Create Superscripts and Subscripts 113 Change Text Case 114 Change Text Color 115 Apply Text Effects 116 Apply a Font Style Set 117 Apply Highlighting to Text 118 Apply Strikethrough to Text 119 Copy and Paste Text Formatting 120 Remove Text Formatting 121 Set the Default Font for All New Documents 122 Chapter 6 Formatting Paragraphs Change Text Alignment 126 Set Line Spacing Within a Paragraph 127 Set Line Spacing Between Paragraphs 128 Create a Bulleted or Numbered List 130 Display Formatting Marks 132 Hide or Display the Ruler 133 Indent Paragraphs 134 Set and Use Tabs 136 Add a Paragraph Border 140 Review and Change Formatting 142 Compare Formatting 144 Apply Formatting Using Styles 146 Switch Styles 148 Save Formatting in a Style 150 Expand or Collapse Document Content 152 Modify a Style 154 Add Paragraph Shading 155 Chapter 7 Formatting Pages Adjust Margins 158 Insert and Manage Page Breaks 160 Control Text Flow and Pagination 162 Align Text Vertically on the Page 164 Change Page Orientation 165 Insert a Section Break 166 Add Page Numbers to a Document 168 Add Line Numbers to a Document 170 Chapter 8 Reviewing and Finalizing Documents Track the Changes to a Document 196 Lock and Unlock Tracking 198 Review Tracked Changes 200 Collaborate in Real Time on a Document 202 Compare Two Versions of a Document 206 Combine Changes into a Single Document 208 Work with Comments 210 Work with Protected Documents 212 Inspect a Document Before Sharing It 214 Mark a Document as Final 216 Create a Master Document 218 Work in a Master Document 220 Using the Building Blocks Organizer 172 Add a Header or Footer 174 Vary Headers or Footers Within a Document 176 Add a Footnote 178 Add an Endnote 179 Find, Edit, or Delete Footnotes or Endnotes 180 Convert Footnotes to Endnotes or Vice Versa 182 Generate a Table of Contents 184 Add a Watermark 186 Add a Page Border 188 Apply Document Themes and Style Sets 190 Create Newspaper‐Style Columns 192 Chapter 9 Working with Tables and Charts Create a Table 224 Change the Row Height or Column Width 226 Move a Table 228 Resize a Table 229 Add or Delete a Row 230 Add or Delete a Column 232 Set Cell Margins 234 Add Space Between Cells 235 Merge Two or More Cells into a Single Cell 236 Split One Cell into Two or More Cells 237 Split a Table into Two 238 Add a Formula to a Table 239 Align Text in Cells 240 Add Shading to Cells 241 Change Cell Borders 242 Format a Table Using a Table Style 244 Add a Chart 246 Understanding Word’s Chart Types 248 Chapter 10 Working with Graphics Add Decorative Text Using WordArt 252 Add a Picture 254 Insert an Online Picture 256 Insert a Video 258 Add a Screenshot 260 Add a Shape 262 Add a Text Box 264 Move or Resize a Graphic 266 Understanding Graphics Modification Techniques 268 Understanding Text Wrapping and Graphics 270 Wrap Text Around a Graphic 271 Work with Diagrams 272 Chapter 11 Customizing Word Control the Display of Formatting Marks 278 Customize the Status Bar 279 Hide or Display Ribbon Buttons 280 Add a Predefined Group to a Ribbon Tab 282 Create Your Own Ribbon Group 284 Create Your Own Ribbon Tab 288 Customize the Quick Access Toolbar 292 Create Custom Keyboard Shortcuts 296 Create a Macro 298 Run a Macro 300 Chapter 12 Printing, Sharing, and Mail Merge Preview and Print a Document 304 Print on Different Paper Sizes 306 Print an Envelope 308 Set Up Labels to Print 310 Share a Word Document on OneDrive 312 Email a Document as an Attachment 314 Create Letters to Mass Mail 316 Create Labels for a Mass Mailing 322 Index 328

Read more less

Book SynopsisGet fast answers to yourG Suitequestionswith thisfriendlyresource G SuiteForDummiesis the funguidetothe productivity suite that's quickly winning over professional and personal users.Thisbookshares the steps onhow tocollaboratein the cloud, createdocuments and spreadsheets,build presentations, and connect with chat or video.Written in theeasy-to-followFor Dummiesstyle,G SuiteForDummiescoversthe essential components of Google'spopularsoftware, including: Google Docsfor word processingGmailfor emailGoogle Calendarfor scheduling and day planningGoogle Sheetsfor spreadsheet functionalityGoogle Drivefor data storageGoogle HangoutsandGoogle Meetfor videoconferencing and calling capability The bookhelps navigate theG Suitepaymentplansand subscriptionoptionsas well assettings thatensure your own privacy and security while operating in the cloud. Perfect for anyone hoping toget things done withthistool,G SuiteForDummiesbelongs on the bookshelf ofeveryG Suite user who needs help from time to timTable of ContentsIntroduction 1 About This Book 1 What You Can Safely Ignore 2 Foolish Assumptions 2 Icons Used in This Book 3 Beyond the Book 4 Where to Go from Here 4 Part 1: Keeping Your Affairs in Order 5 Chapter 1: G Suite: The 50¢ Tour 7 What is G Suite? 8 What You Get with G Suite 9 Using Apps Online — Really? Here are the FAQs 10 Introducing Online Collaboration 14 Going Mobile 15 Chapter 2: Taming the Email Beast 17 Rhymes with Email: Getting to Know Gmail 17 Touring the Gmail app 18 Touring the Gmail Inbox 19 Showing your good side: Adding a profile photo 20 The Outbox: Sending an Email Message 22 The basics: Composing and sending a message 22 Easier addressing: Using the Contacts app 24 Inserting attachments and other hangers-on 25 Creating a signature 25 Scheduling a send 27 Undoing a send 28 The Inbox: Handling Incoming Messages 29 Refreshing your messages 29 Reading your messages 29 Easier reading with the Reading pane 30 Attending to attachments 32 Responding to a message 33 Creating a task from a message 34 Setting up a vacation responder 34 Selecting messages 36 Dealing with the Onslaught 37 Cleaning out your inbox 37 Labeling your messages 38 Muting a conversation 42 Snoozing a conversation 42 Searching for messages 44 Filtering your messages 45 Chapter 3: Places to Go, People to See: Managing Your Calendar 47 Navigating the Calendar Window 48 Changing the Calendar View 50 Time Traveling: Changing the Date 51 Setting Your Social Schedule: Entering Events 52 Adding an event 53 Editing an event 55 Lather, rise, repeat: Creating a repeating event 56 Scheduling an all-day event 59 Psst: Setting up event notifications 60 Nudge, nudge: Creating a reminder 62 Things to do: Creating a task 63 Going Calendar Crazy: Adding Even More Calendars 66 Chapter 4: Friends, Romans, Countrymen: Managing Your Contacts 69 Eyeballing the Contacts App 70 What’s with those “other” contacts? 71 Configuring the Contacts columns 72 Changing the sort order 73 Populating Your Contacts List 74 Adding a contact from scratch 74 Adding a contact from Gmail 75 Going legit: Turning an “other” contact into a real contact 76 Adding multiple contacts all at once 77 Importing contacts 78 Managing Your Contacts 79 Editing a contact 80 Grouping contacts with labels 81 Merging duplicate contacts 82 Exporting contacts 83 Deleting contacts 84 Doing Stuff with Your Contacts 85 Emailing a contact 85 Emailing a contact who has multiple addresses 86 Emailing multiple contacts 86 Calling a contact 87 Surfing to a contact’s website 87 Part 2: Making Stuff: Documents, Spreadsheets, and More 89 Chapter 5: Getting Started with Docs 91 Opening Docs 92 Touring the Google Docs Home Page 92 Creating a Shiny, New Document 94 Checking Out the Document Screen 94 Dealing with Documents 96 Saving your work — just kidding! 96 Naming a new document 97 Opening an existing document 97 Saving a copy of a document 99 Learning Some Editing Basics 100 Navigating with the keyboard 100 Selecting text 102 Deleting stuff 102 Deleting characters 103 Fooling around with special characters 104 Stating your case: Uppercase versus lowercase 106 Adding links 106 Setting tab stops 107 Search and Ye Shall Replace 108 Finding stuff 108 Some notes on searching 109 Finding-and-replacing stuff 110 Checking Spelling and Grammar 111 Handling spelling slip-ups 111 Handling grammar gaffes 112 Chapter 6: Looking Good: Formatting Documents 115 Making Your Characters Look Good 115 Getting familiar with fonts 116 Formatting with fonts 118 Avoiding the ransom note look 120 Copy text formatting by “painting” it 121 Making Your Lines and Paragraphs Look Good 121 Getting your text ducks in a row: Aligning paragraphs 121 Breathing room: Changing the line spacing 123 Giving paragraphs some elbow room 125 Keeping stuff together 125 Indenting paragraphs 126 Using Styles to Make Looking Good Look Easy 128 Style advantages 129 Applying default Docs styles to avoid reinventing the style wheel 130 Updating a default style to taste 132 Saving your updated styles 132 Telling Docs to use your updated styles 133 Resetting the default styles 133 Making Lists, Checking Them Twice 133 Putting your affairs in order with numbered lists 133 Scoring points with bulleted lists 135 Image is Everything: Adding Graphics 137 Inserting an image from your PC 138 Inserting an image from the web 139 Inserting an image from Drive 139 Inserting an image from Photos 140 Inserting an image from a URL 140 Inserting a photo from your PC’s camera 140 Setting a few image options 141 Chapter 7: Fiddling with Document Layout 143 Building a Table with Your Bare Hands 143 What is a table? 144 Inserting a table 145 Populating a table 145 Adjusting column widths 146 Selecting table cells 147 Setting table properties 147 Inserting a new row or column 149 Deleting a row or column 150 Merging table cells 150 Headers and Footers from Head to Toe 151 Adding a header 151 Adding a footer 153 Opening the header or footer for editing 154 Creating a unique first-page header and footer 154 Creating unique odd and even page headers and footers 154 Changing the Page Setup 156 Setting the page margins 156 Changing the page orientation 158 Changing the paper size 158 Adding a page break 159 Adding a section break 159 Working with Columns, Just Like the Pros 161 Getting text into columns, Part 1: The easy way 161 Getting text into columns, Part 2: The ever-so-slightly-harder way 162 Entering text in columns 163 Show Your Work: Adding Footnotes 164 Chapter 8: Getting Started with Sheets 167 Opening Sheets 168 Touring the Google Sheets Home Page 168 Creating a New Spreadsheet 170 Checking Out the Spreadsheet Screen 170 Dealing with Spreadsheets 172 Sheets saves your work for you 172 Naming a new spreadsheet 173 Opening an existing spreadsheet 173 Saving a copy of a spreadsheet 174 Understanding Sheet Cells 174 Entering Data 175 Entering text 175 Entering numbers 176 Entering dates and times 177 Navigating a sheet 179 Editing cell contents 180 Working with Ranges 180 Understanding ranges 180 Selecting a range 181 Specifying a range input in a dialog box 184 Working with named ranges 185 Filling a range with data 187 Filling a range with a series of values 187 Copying a range 188 Moving a range 188 Formatting a Cell 189 Formatting the cell font 189 Aligning cell data 190 Applying a numeric, date, or time format 191 Using the Paint Format tool 192 Working with Columns and Rows 193 Adjusting the column width 193 Adjusting the row height 194 Hiding columns and rows 196 Inserting columns and rows 196 Deleting columns and rows 197 Chapter 9: Crunching Numbers 199 Building Formulas 199 Creating a simple formula 200 Understanding formula operators 201 Avoiding problems with cell references 202 Using Functions for More Powerful Formulas 206 Entering functions directly 207 Entering functions via the Function menu 208 Using a Range as a Database 209 Sorting a range 209 Filtering a range 211 Visualizing Data with Charts 213 Getting to know the chart elements 213 How Sheets converts sheet data into a chart 214 Creating a chart 216 Moving a chart to its own sheet 217 Editing the chart 217 Building Pivot Tables 218 Understanding pivot tables 219 Exploring pivot table features 220 Building a pivot table 221 Adding multiple fields to a pivot table area 224 Pivoting a field to a different area 225 Grouping pivot table values 225 Filtering pivot table values 227 Chapter 10: Creating Eye-Popping Presentations 229 Opening Slides 230 Touring the Google Slides Home Page 230 Creating a New Presentation 232 Checking Out the Presentation Screen 232 Dealing with Presentations 234 Slides saves your work for you 234 Naming a new presentation 234 Opening an existing presentation 234 Saving a copy of a presentation 235 Applying a presentation theme 235 Working with Slides 237 Adding a slide to the presentation 237 Adding data to a slide 239 Selecting slides 242 Rearranging slides 242 Changing the layout of a slide 242 Changing the slide background 243 Working with the Master Slide 243 Formatting Slide Text 245 Formatting with fonts 245 Aligning paragraphs 246 Slide formatting considerations 247 Animating Your Slides 249 Learning a few animation guidelines 249 Setting up a slide transition 250 Animating slide objects 252 Running a Slide Show 253 Starting the slide show 253 Navigating slides 253 Navigating the slide show from the keyboard 255 Part 3: Collaborating with Your Team 257 Chapter 11: Collaborating on Files 259 Sharing a File 259 Sharing a file for editing 261 Sharing a file for commenting and suggesting 262 Sharing a file for viewing 263 Sharing a link to a file 264 Emailing your collaborators 267 Setting an access expiration date 267 Changing a user’s sharing access 268 Removing a user’s sharing access 269 Dealing with Shared Files 269 Responding to a sharing invitation 269 Viewing which files have been shared with you 270 Working on a Shared File 271 Making suggested edits to a shared Docs document 273 Adding comments to a file 274 Requesting edit access 275 Chatting with your fellow collaborators 276 Viewing a file’s sharing activity 276 Reviewing a Shared File 278 Accepting or rejecting suggested changes in Docs 278 Working with comments 280 Chapter 12: Collaborating with Calendar 281 Inviting Guests to a Meeting 282 Inviting guests to a new meeting 282 Inviting guests to an existing meeting 283 Controlling your guest list 284 Coordinating attendee schedules 286 Getting suggested meeting times 287 Responding to a Meeting Invitation 288 Sharing Your Calendar 289 Controlling access to your calendar in your organization 289 Making your calendar available to the public 290 Making your calendar unavailable to other G Suite apps 291 Sharing your calendar on an ad hoc basis 291 Sharing your calendar with only specific people 292 Subscribing to a Shared Calendar 294 Importing Events 295 Exporting Events 296 Chapter 13: Setting Up Video Meetings 297 What Do You Need to Use Meet? 298 Allowing Meet to use your camera and microphone 299 Making sure Meet is using the equipment you want 300 Starting a Video Meeting 302 Starting a video meeting from the Meet home page 302 Starting a video meeting from Gmail 303 Adding people to your video meeting 305 Scheduling a video meeting with Calendar 306 Joining a Video Meeting 307 Joining a video meeting from the Meet home page 308 Joining a video meeting from Gmail 309 Dialing in to a video meeting and using the phone for audio 309 Customizing Video Meeting Settings 311 Changing the meeting layout 311 Messing around with meeting participants 312 Displaying captions 313 Sharing Resources During a Video Meeting 314 Chatting with meeting participants 314 Presenting your screen 315 Chapter 14: Chatting with Your Team 319 Chatting, G Suite Style 319 Chatting with Gmail 320 Chatting with Docs, Sheets, and Slides 320 Chatting with Meet 322 Chatting with Google Chat 322 Exchanging Messages 323 Formatting chat text 324 Messing around with messages 325 Collaborating with Chat 326 Chatting with a group 326 Uploading a file to a chat 327 Adding a video meeting to a chat 328 More Collaboration: Congregating in a Chat Room 329 Creating a room 330 Managing a room 331 Robotexting: Chatting with Bots 332 Adding a bot 333 GIPHY: Animated GIF fun and frivolity 334 Meet: Managing your meetings 335 Google Drive: Getting file alerts 337 Chapter 15: Collaborating with Groups 339 Why Create a Group? 340 Investigating the Groups Home Page 340 Understanding Group Roles 342 Finding a Group 344 Joining a Group 345 Joining a group directly 346 Asking to join a group 347 Leaving a group 348 Posting Messages 348 Responding to Posts 349 Creating a Group 350 Preparing to add a group 350 Creating the group 350 Adding more people directly to the group 354 Inviting people to your group 355 Managing group requests and invitations 355 Chapter 16: Collaborating with Forms and Notes 357 Gathering Info with Forms 358 Loading the Forms website 358 Touring the Forms home page 358 Creating a new form 360 Touring the form screen 360 Fabricating a form 360 Constructing a quiz 362 Adding form collaborators 362 Sending your form 363 Checking out the form responses 365 Sharing Notes 365 Checking out the Keep home page 365 Creating a new note 367 Adding note collaborators 368 Part 4: The Part of Tens 371 Chapter 17: Ten Tips for Working from Home 373 Set Your Working Hours 374 Show Your Availability 375 Tell Chat to Chill for a While 377 Keep Up the Face-to-Face Communication 378 Know Which Communications Tools to Use 379 Add Time Zones in Your Calendar 379 Configure Calendar for Speedy Meetings 381 Read Email from Another Account 382 Handle Microsoft Office Documents 385 Set Up Your Video Conference Space 387 Chapter 18: Ten Really Useful Gmail Settings 389 Five Splendiferous Send Settings 390 Sending a message as plain text 390 Setting the default reply behavior 391 Replying and archiving in one fell swoop 392 Setting the default text style 393 Preventing Gmail from creating contacts automatically 393 Five Stupendous Read Settings 394 Turning off Conversation view 394 Adding importance markers 395 Setting the maximum page size 396 Managing notifications 396 Indicating messages sent only to you 398 Chapter 19: Ten Ways to Enhance Privacy and Security 401 Make Sure Your Wi-Fi Network is Locked Up Tight 402 Secure Your Google Account with a Strong Password 404 Enable Google’s 2-Step Verification 406 Set Up Your Contact Verification Methods 407 Hide Images in Gmail Messages 409 Blocking Senders in Gmail 411 Choose Who Can See Your Personal Info 412 Manage Your Activity Controls 413 Manage Your Devices 415 Manage Third-Party Apps 416 Appendix: Glossary of G Suite Terms 419 Index 427

Read more less

Book SynopsisExpert guidance on how to use Amazon Web Services to supercharge your digital services business In Transforming Your Business with AWS: Getting the Most Out of Using AWS to Modernize and Innovate Your Digital Services, renowned international consultant and sought-after speaker Philippe Abdoulaye delivers a practical and accessible guide to using Amazon Web Services to modernize your business and the digital services you offer. This book provides you with a concrete action plan to build a team capable of creating world-class digital services and long-term competitive advantages. You''ll discover what separates merely average digital service organizations from the truly outstanding, as well as how moving to the cloud will enable your business to deliver your services faster, better, and more efficiently. This book also includes: A comprehensive overview of building industry-leading digital service delivery capabilities, including discussTable of ContentsIntroduction xxvii Part I Understanding the Digital Transformation Challenges 1 Chapter 1 The Digital Economy’s Challenges, Opportunities, and Relevance of AWS 3 Understanding the Digital Economy’s Impacts 4 Surviving Disruptions Are Your Business’s Primary Challenge 4 Understanding the Digital Economy’s Opportunities 4 Surviving the Disruptions: The AWS Solutions 5 The AWS Universal Architecture: Simplifying AWS Understanding 5 Navigating AWS IaaS Building Block 6 AWS Compute Resources 7 AWS Network Resources 8 AWS Storage Resources 9 Understanding Essential AWS PaaS Tools 10 AWS Elastic Beanstalk 10 AWS CodeDeploy 10 AWS CodePipeline 11 Understanding Innovation with AWS: Machine Learning, Internet of Things, and Elastic MapReduce 11 AWS Machine Learning 11 AWS Internet of Things 12 Amazon Elastic MapReduce 12 Understanding the AWS Integration Building Block 13 Site-to-Site VPN 13 Hybrid Cloud with VMware Cloud on AWS 13 Changes in the AWS Implementation Paradigm 14 Lift-and-Shift Migration is a Problem 14 Failure Factors Making Lift-and-Shift Irrelevant 14 Understanding the Benefits of Enterprise Architecture for AWS 15 Key Takeaways 16 References 16 Chapter 2 What is a Digital Product? 17 Differences Between Digital Products and Digital Services 17 Digital Service Delivers Information 18 Digital Product Exists in Intangible Formats 18 Anatomy of the Digital Product 18 The Digital Product’s Technology Stack 18 The 4G/5G Services 19 Cloud Computing Services: Innovation as a Service 20 Smart Mobile Devices 24 Impacts on Digital Product and Service Development 24 The Growing Complexity of the Technological Stack 24 Technology Innovation Alone Isn’t Enough Anymore 25 Key Takeaways 25 References 26 Chapter 3 Digital Product and Service Development Challenges 27 What is Digital Product and Service Development? 28 Digital Product and Service Development Defined 28 How is Digital Product and Service Development Performed? 28 Ideation 29 Concept 30 Business Case 30 Development 30 Testing 31 Launch 31 Digital Product and Service Development Approach Evaluation 31 Understanding the Digital Product and Service Development Assessment Framework 32 Assessment Framework Overview 32 The Context Elements 33 The Performance Enablers 33 The Digital Transformation Solutions 34 Assessing Current Digital Product and Service Development 35 What is a Digital Product and Service Development Platform? 35 Capturing Business Context 37 Evaluating Your Digital Operating Model 37 Evaluating Your Technical Platform 38 Evaluating Your Organizational Model 40 Assessing Your Human Capital 41 Challenges of Current Digital Product Development 42 Focus on Digital Product and Service Development 42 Accurate Customer Insights 43 Competitive Pricing 43 Premium Customer Experience 43 Rapid Go-to-Market 44 Key Takeaways 44 References 44 Chapter 4 Industrializing Digital Product and Service Development 47 The Total Quality Management and Mass Production Heritage 48 Total Quality Management Principles Defined 48 Customer Focus 48 Workforce Commitment 49 Process Approach 49 Integrated System 49 Continual Improvement 49 Transversal Communication 49 Mass Production Principles Defined 49 Assembly Line 50 Work Specialization 50 Automation 50 Industrialization Factors 50 Industrialization Factor Defined 50 Families of Industrialization Factors 51 Principles Family 51 Design Patterns Family 52 Methodology Family 52 Technology Family 53 Understanding DevOps as the Framework for Implementing Your Digital Product and Service Development Platform 54 DevOps Defined 54 Understanding DevOps Components 54 Software Delivery Lifecycle’s Importance 54 DevOps Practices Purpose 56 Methodologies Benefit 58 DevOps Toolchain Importance 63 AWS Industrialization Factors 64 Understanding AWS Design Patterns: The Enterprise Cloud Migration Pattern 64 Defining AWS Enterprise Cloud Migration Pattern 65 Understanding the Baseline Architecture Purpose 66 AWS Methodology 66 Defining AWS Well-Architected Framework 66 Understanding the Industrialization Matrix for AWS 70 Key Takeaways 73 References 73 Part II Digitizing the Business Model Using AWS 75 Chapter 5 The J&S Food Digital Transformation Project 77 History of J&S Food, Inc. 77 Company’s Evolution 78 Territorial Conquest 78 Diversification 79 Company’s Culture 79 Productivity 80 Effectiveness 80 Innovation 80 Technology 81 Transformation Journey’s First Stage: Planning the Transformation 81 The Kickoff Meeting 82 Understanding the Grocery Sector’s Digital Disruption Impacts on J&S Food 82 Capturing and Analyzing the Factors Driving the Grocery Sector Disruption 84 Discussing and Agreeing on the Factors Affecting J&S’s Food Business 87 Developing and Sharing J&S Food’s Digital Mission and Digital Strategy 90 Defining J&S Food’s Mission 90 Developing J&S Food’s Digital Strategy 91 Developing J&S Food’s Digital Transformation Roadmap 94 Digital Transformation Roadmap Defined 94 Developing a Digital Transformation Roadmap 96 Understanding J&S Food’s Digital Transformation Roadmap 98 The J&S Food Digital Transformation Project’s Statement of Work 99 The Statement of Work Defined 99 Introduction/Background 99 Scope of Work 100 Work Requirements 100 Schedule/Milestones 101 Acceptance Criteria 101 Other Requirements 101 The Next Step 102 Key Takeaways 102 References 102 Chapter 6 Rethinking J&S Food’s Business 103 Transformation Journey’s Second Stage: Rethinking the Business 104 Understanding J&S Food’s Current Business 105 Capturing the Current Business Model 105 Understanding Use Cases 106 Understanding Actors 106 Understanding Links 106 The Current Business Model Captured 106 Buy 107 Fulfill Order 108 Pay 109 Perform Customer Service 109 Manage Supply Chain 110 Maintain Website 111 Develop Food Product 112 Understanding J&S Food’s Current Data Model 112 Assessing the As-Is Operational Model 113 Digital Food Experience Defined 113 Assessing J&S Food’s Operational Model 114 Defining the Digital Smart Shopping Bag 116 Optimizing the Fulfill Order Experience Based on a Two-Sided Marketplace Platform 117 Enhancing Online Order Experience Using a Mobile App 118 Implementing a Digital Products and Services Development Platform 118 Defining the Future Digital Business Model 118 Reconfiguring J&S Food’s Operational Model 119 Understanding Michael Porter’s Value Chain 119 The Value Chain for Digital Business Defined 121 J&S Food’s Digital Business Model Defined 123 Understanding J&S Food’s Next Digital Value Chain 123 Support Digital Business Activities 123 Primary Digital Business Activities 124 Understanding J&S Food’s AWS Cloud Platform 126 J&S Food’s AWS Software as a Service 126 The J&S Food’s Platform as a Service 126 The J&S Food’s AWS Virtual Infrastructure 126 Integrating J&S Food’s Digital Operational Model with the Organization 127 The Digital Business Value Chain: A Shortcut to the Digital Business Organization 127 Digital Business Organizational Model Defined 127 Developing the Digital Business Organizational Model 128 The J&S Organizational Model Defined 130 Roles and Responsibilities 130 Interaction and Collaboration Mechanisms 132 Key Takeaways 132 References 133 Chapter 7 Digitizing J&S Food’s Business Model Using AWS—Implementing the VPC 135 Transformation Journey’s Third Stage: Digitizing the Business Model 136 Defining J&S Food’s AWS Migration Strategy 137 Sharing J&S Food’s Digital Business Model 138 Defining the J&S Food’s Digital Business Application Portfolio 139 Specifying J&S Food’s Virtual Private Cloud Architecture 141 Understanding the Enterprise Cloud Migration Model For AWS 141 J&S Food’s Virtual Private Cloud Specified 141 The Availability Zone 142 Amazon CloudFront and the Content Delivery Network 143 J&S Food’s Virtual Private Cloud 143 J&S Food’s Extended Elastic Compute Cloud Building Block 145 J&S Food’s Extended Storage Build Block 149 J&S Food’s Extended Fault Tolerance Building Block4 150 J&S Food’s Extended Security Build Block 151 Executing J&S Food’s AWS Migration Strategy 152 Understanding the AWS Application Migration Process 152 Discover 152 Design 152 Build 153 Integrate 153 Validate 153 Cutover 153 Migrating J&S Food’s Ecommerce Website Into a Two-Sided Marketplace Platform 154 Implementing J&S Food’s Virtual Private Cloud 154 Discovering the Ecommerce Website Three-Tier Architecture 155 Extending the Ecommerce Website Architecture to a Two-Sided Marketplace Platform 157 Implementing J&S Food’s Two-Sided Marketplace Platform 161 Validating the Two-Sided Marketplace Platform 165 Key Takeaways 165 References 166 Chapter 8 Implementing J&S Food’s DevOps Platform Using AWS PaaS 167 Transformation Journey’s Third Stage: Implementing J&S Food’s DevOps Platform 168 Understanding What J&S Food is Trying to Achieve 169 Understanding the DevOps Implementation in the AWS Computing Environment 169 Discussing the Challenges 170 Understanding the Common Mistakes 171 The DevOps Implementation Framework for AWS 171 The Digital Business Value Chain Primary Activities and AWS Modern Application Influence 172 The AWS CodePipeline Service 173 Understanding DevOps Implementation for AWS 175 Implementing J&S Food’s Digital Product and Service Development Platform 177 J&S Food’s Digital Product and Service Development Platform 177 J&S Food’s DevOps Toolchain 178 J&S Food’s Digital Business Primary Activities 180 Designing the Agile Operating Model 181 The Usual Challenges and Solutions 181 J&S Food’s Agile Operating Model Defined 182 Key Takeaways 183 References 184 Chapter 9 Developing J&S Food’s Innovation as a Service Platform Using AWS 185 Transformation Journey’s Third Stage: Developing J&S Food’s Innovation as a Service 185 Software Engineering Methodology for Innovations Development in the AWS Cloud 186 Software Engineering Methodology for Innovations Development 187 Driving Principles Explained 187 Key Concepts to Understand 189 Understanding the Innovative Digital Product Development Lifecycle 193 The Five-Step Development Lifecycle 193 Specifying the Innovative Digital Product Using a UML Use Case Diagram 194 Designing the Innovative Digital Product Using a UML Package Diagram 196 Prototyping the Microservices Using AWS Amplify 197 Developing and Deploying the Application Supporting the Innovative Digital Product 198 Implementing the Microservices Architecture of the Digital Product and Service 200 The User Interface Microservices 201 The Business Logic Microservices 201 The Technology Microservices 201 Key Takeaways 202 References 202 Part III Developing World-Class Digital Products and Services Using AWS 205 Chapter 10 J&S Food’s Smart Shopping Bag Digital Product Project 207 Transformation Journey’s Fourth Stage: Experimenting with the Digital Business Model 208 The Smart Shopping Bag Project Overview 208 The Smart Shopping Bag Project’s Organization 209 The Smart Shopping Bag Project’s Opportunity Statement 209 The Smart Shopping Bag Project’s Objectives 210 The Smart Shopping Bag Project’s Scope 210 The Pilot Project Management 211 Key Takeaways 211 References 212 Chapter 11 Specifying J&S Food’s Smart Shopping Bag Digital Product 213 Transformation Journey’s Fourth Stage: Specification of the Smart Shopping Bag Digital Product 213 Specifying the Smart Shopping Bag Digital Product’s Scope 214 Using Context Diagrams to Improve the Specification Process 215 Developing the Smart Shopping Bag’s Context Diagram 215 J&S Food’s Stores IoT Infrastructure 215 J&S Food’s AWS IoT Core Platform 216 Developing the Smart Shopping Bag Use Case Diagram 216 Identifying the Smart Shopping Bag’s Actors and Use Cases 218 Specifying the Smart Shopping Bag’s Functions Using Sequence Diagrams 221 Use Case Description: Press Start to Begin Shopping 221 Use Case Description: Respond to In-Store Customer Button Presses 222 Use Case Description: Detect Product Code Put in the Bag 223 Use Case Description: Send EEPROM Data to Billing System 225 Use Case Description: Respond to RFID Reader Queries 226 Use Case Description: Calculate the Bill Amount 226 Specifying the Smart Shopping Business Rules Using Class Diagram 228 The In-Store Customer 228 The Smart Shopping Bag 230 The RFID Reader 230 The Product RFID Tag 230 The Smart Mobile Device 231 The Shopping Session 231 The Smart Shopping Service 231 The Smart Shopping Bag Application 231 Key Takeaways 232 References 232 Chapter 12 Designing J&S Food’s Smart Shopping Bag Digital Product 233 Transformation Journey’s Fourth Stage: Designing the Smart Shopping Bag Digital Product 233 The Agile Operational Model Confirmed as the Foundation of J&S Food’s Work Organization 234 J&S Food’s New Organization of Work 234 The Princeton’s Digital Product Development Team Defined 235 UML Package Diagram Facilitates the Microservices Architecture Design Process 237 Lucidchart Confirmed as the Best Architecture Tool 237 Overall Feedback 237 The Resulting Smart Shopping Bag’s Architecture 238 The Smart Shopping Bag Blueprint 239 The In-Store Customer Package 240 The Shopping Session Package 240 The Smart Shopping Bag Package 241 Acquired Digital Business Competency: Digital Products and Services Architecture Design 241 Key Takeaways 241 References 242 Chapter 13 Prototyping J&S Food’s Smart Shopping Bag Using Innovation as a Service 243 Transformation Journey’s Fourth Stage: Prototyping the Smart Shopping Bag’s Application 244 Sharing the Prototyping Process Goal and Approach 245 Prototyping Using AWS Amplify Defined 245 The Prototyping Iterations Using AWS Amplify 245 The Prototyping Team 251 The Team’s Feedback 252 The Smart Shopping Bag Application Prototype 253 The Business Logic, Technological, and UI Microservices Prototyped 255 The Microservices Development Process in the AWS Amplify Context 255 Defining the Microservices Granularity 256 The Smart Shopping Bag Business Logic Microservices Implemented 257 The Smart Shopping Bag Business Logic Microservices Documented 257 The Smart Shopping Bag Technological Innovation Microservices Implemented 259 IoT Gateway Microservices 259 AWS IoT Core Microservices 261 RFID Reader Microservices 263 RFID Tag Microservices 265 The Smart Shopping Bag UI Microservices Implemented 265 Key Takeaways 266 References 267 Chapter 14 Implementing J&S Food’s Smart Shopping Bag Application 269 Transformation Journey’s Fourth Stage: Implementing the Smart Shopping Bag’s Production Release 270 The Smart Shopping Bag App: Production Release 270 Blueprint of the Smart Shopping Bag in Production 270 Understanding the Production Release Building Blocks 271 Application Layer 271 AWS Innovation Layer 273 AWS Virtual Infrastructure Layer 274 Understanding the Pivotal Role Played by Agile Methodologies 275 The Architectural Spike and Prototyping Benefits 275 The Importance of Scrum Sprints in the Incremental Development Effort 275 Understanding the Vital Role of the Daily Scrums 276 The Development Team’s Feedback: Lessons Learned 277 Key Takeaways 278 References 278 Chapter 15 Launching J&S Food’s First Digital Food Product 279 Transformation Journey’s Fourth Stage: Deploy J&S Food’s Digital Business 279 Defining J&S Food’s Go-To-Market Strategy 280 The Go-To-Market Strategy Defined 281 Articulating J&S Food’s Go-To-Market Strategy 281 The Objectives Questionnaire 282 The Value Propositions Questionnaire 282 The Key Processes to Stress Questionnaire 282 The Organizational and Technological Assets to Stress Questionnaire 282 J&S Food’s Go-To-Market Strategy Defined 282 Understanding J&S Food’s Go-To-Market Strategy 283 Declaring J&S Food’s Digital Business Opened 284 Key Takeaways 284 References 285 Chapter 16 Maintaining and Supporting J&S Food’s Digital Business on a Daily Basis 287 The New J&S Food Day-to-Day Business 287 J&S Food’s Customer Value Creation Virtuous Circle 288 J&S Food’s Virtuous Circle for Creating Customer Value 288 Customer Insights Management on a Daily Basis 289 J&S Food’s AWS EMR Infrastructure 289 Business Data Providers 290 Data Lake 290 Data Warehouse 290 Data Mart 290 The Big Data Analytics Activity in the Customer Insights Management Team 291 Customer Value Increase Management’s Day-to-Day Operations 292 J&S Food’s AI/ML Development Environment 292 Generate Data 293 Train Models 293 Deploy Models 294 The Customer Increase Value Management Team’s Activity 294 Digital Product and Service Releases Development 295 Defining Product Backlog 295 Sprint Planning 296 Sprint Execution 296 Key Takeaways 296 References 297 Index 299

Read more less

Book SynopsisTable of ContentsIntroduction 1 About This Book 1 Icons Used in This Book 2 Beyond the Book 3 Where to Go from Here 3 Part 1: Getting Started with Photoshop Elements 2024 5 Chapter 1: Getting Started with Image Editing 7 Getting Familiar with the Home Screen 7 Launching the Photo Editor 9 Making Basic Edits in Quick Mode 11 Sharing a Photo 13 Retracing Your Steps 15 Using the History panel 16 Reverting to the last save 17 Getting a Helping Hand 17 Saving Files with Purpose 19 Using the Save/Save As dialog box 19 Saving files for the web 21 Chapter 2: Basic Image-Editing Concepts 23 Grappling with the Ubiquitous Pixels 24 Understanding resolution 25 Understanding image dimensions 27 The Art of Resampling 27 Choosing a Resolution for Print or Onscreen 30 Working with File Formats 31 JPEG (*.jpg, *.jpeg, *.jpe) 32 PNG (*.png) 33 TIFF (*.tif, *.tiff) 33 Getting Familiar with Color 34 Getting Color Right 36 Color the easy way 36 Calibrating your monitor 36 Choosing a color workspace 37 Understanding how profiles work 38 Chapter 3: Exploring the Photo Editor 39 Examining the Photo Editor 39 Examining the image window 43 Uncovering the contextual menus 48 Selecting the tools 48 Selecting from the Tool Options 51 Playing with panels 51 Using the Photo Bin 55 Creating different views of an image 55 Viewing filenames 56 Using Photo Bin Actions 56 Using Some Creative Features 56 Using Guided Edits 57 Working with Adobe Stock images 58 Searching Guided Edits 60 Controlling the Editing Environment 61 Launching and navigating Preferences 62 Checking out all the Preferences panes 63 Perusing preset libraries 65 Part 2: Managing Media 67 Chapter 4: Navigating the Organizer 69 Organizing Photos and Media on a Hard Drive 70 Adding Images to the Organizer 72 Adding files from folders and removable media 72 Downloading camera images with the Elements Downloader 74 Importing additional photos from folders 76 Navigating the Media Browser 77 Using a Scanner 78 Understanding image requirements 79 Using scanner plug-ins (Windows) 79 Scanning on the Mac 80 Scanning many photos at a time 81 Phoning in Your Images 81 Setting Organizer Preferences 82 Chapter 5: Organizing Your Pictures 85 Touring the Organizer 85 Organizing Groups of Images with Tags 89 Creating and viewing a tag 89 Adding icons to tags 92 Working with custom tags 93 Working with default tags 94 Working with sub-categories 95 Sorting photos according to tags 96 Auto Generating Tags 96 Working with Auto Creations 97 Adding new Events 97 Rating Images with Stars 98 Adding Images to an Album 99 Creating an album 100 Using albums for temporary work 102 Editing an album 102 Finding out more about sharing your albums 103 Adding People in the Media Browser 103 Placing Pictures on Maps 105 Working with Events 107 Chapter 6: Viewing and Finding Your Images 109 Cataloging Files 109 Using the Catalog Manager 110 Working with catalogs 111 Backing up your catalog 112 Backing up photos and files 114 Switching to a Different View 114 Viewing Photos in Memories (Slideshow) 115 Searching for Photos 117 Using Search 117 Searching for untagged items 119 Searching captions and notes 119 Searching by history 120 Searching metadata 120 Searching similarities 121 Grouping Files That Get in the Way 123 Marking files as hidden 123 Stackin’ ’em up 123 Creating versions 125 Part 3: Selecting and Correcting Photos 127 Chapter 7: Editing Camera Raw Images 129 Launching the Camera Raw Editor 129 Understanding Camera Raw 130 Learning Raw file format attributes 131 Opening images in the Camera Raw Editor 132 Getting Familiar with the Raw Editor 133 Getting Familiar with the Panels 137 Using the Basic panel 138 Sharpening and reducing noise 141 Using the Calibration panel 144 Working with Filmstrips 144 Working with Profiles 146 Looking at the Adobe Camera Raw profiles 146 Managing profiles 148 Creating a Favorites list 148 Opening Non-Raw Images in the Camera Raw Editor 149 Changing Image Defaults 150 Working with XML Files and Preferences 150 Changing program defaults 150 Using Save Options 152 Using sidecar files 153 Chapter 8: Making and Modifying Selections 155 Defining Selections 155 Creating Rectangular and Elliptical Selections 156 Perfecting squares and circles with Shift and Alt (Option on the Mac) 158 Applying Marquee options 159 Making Freeform Selections with the Lasso Tools 161 Selecting with the Lasso tool 161 Getting straight with the Polygonal Lasso tool 162 Snapping with the Magnetic Lasso tool 164 Working Wizardry with the Magic Wand 166 Talking about Tolerance 167 Wielding the Wand to select 167 Modifying Your Selections 170 Adding to, subtracting from, and intersecting a selection 170 Avoiding key collisions 171 Painting with the Selection Brush 171 Painting with the Quick Selection Tool 173 Selecting with the Auto Selection Tool 175 Selecting Your Subject, Background, or Sky with One-Click Selecting 177 Fine-Tuning with the Refine Selection Brush 179 Working with the Cookie Cutter Tool 181 Eliminating with the Eraser Tools 182 The Eraser tool 183 The Background Eraser tool 184 The Magic Eraser tool 185 Using the Select Menu 185 Selecting all or nothing 186 Reselecting a selection 186 Inversing a selection 186 Feathering a selection 186 Refining the edges of a selection 187 Using the Modify commands 189 Applying the Grow and Similar commands 189 Saving and loading selections 190 Chapter 9: Working with Layers 191 Getting to Know Layers 191 Converting a background to a layer 192 Anatomy of the Layers panel 193 Using the Layer and Select menus 197 Working with Different Layer Types 198 Image layers 198 Adjustment layers 199 Fill layers 201 Shape layers 202 Type layers 203 Tackling Layer Basics 203 Creating a new layer from scratch 204 Using Layer via Copy and Layer via Cut 205 Duplicating layers 206 Dragging and dropping layers 206 Using the Paste into Selection command 207 Moving a Layer’s Content 208 Transforming Layers 209 Adding Layer Masks 210 Flattening and Merging Layers 212 Flattening layers 213 Merging layers 213 Chapter 10: Simple Image Makeovers 215 Cropping and Straightening Images 215 Cutting away with the Crop tool 216 Fixing distortion with the Perspective Crop tool 218 Cropping with a selection border 219 Straightening images 219 Recomposing Images 221 Employing One-Step Auto Fixes 224 Auto Smart Fix 224 Auto Smart Tone 225 Auto Levels 226 Auto Contrast 227 Auto Haze Removal 227 Auto Color Correction 227 Auto Sharpen 228 Auto Red Eye Fix 229 Editing in Quick Mode 230 Fixing Small Imperfections with Tools 234 Cloning with the Clone Stamp tool 234 Retouching with the Healing Brush 237 Zeroing in with the Spot Healing Brush 239 Repositioning with the Content-Aware Move tool 241 Lightening and darkening with Dodge and Burn tools 243 Smudging away rough spots 244 Softening with the Blur tool 246 Focusing with the Sharpen tool 247 Sponging color on and off 248 Replacing one color with another 249 Chapter 11: Correcting Contrast, Color, and Clarity 253 Editing Your Photos Using a Logical Workflow 254 Adjusting Lighting 255 Fixing lighting with Shadows/Highlights 255 Using Brightness/Contrast 256 Pinpointing proper contrast with Levels 257 Adjusting Color 260 Removing color casts automatically 260 Adjusting with Hue/Saturation 261 Eliminating color with Remove Color 263 Switching colors with Replace Color 264 Correcting with Color Curves 265 Adjusting skin tones 267 Defringing layers 269 Eliminating haze 270 Adjusting color temperature with photo filters 272 Mapping your colors 273 Adjusting Clarity 274 Removing noise, artifacts, dust, and scratches 274 Blurring when you need to 275 Sharpening for better focus 278 Opening closed eyes 280 Colorizing a photo 282 Smoothing skin 284 Adjusting facial features 285 Moving Overlays 285 Moving Photos 288 Moving Elements 288 Working Intelligently with the Smart Brush Tools 290 Part 4: Exploring Your Inner Artist 295 Chapter 12: Playing with Filters, Effects, Styles, and More 297 Having Fun with Filters 297 Applying filters 298 Corrective or destructive filters 299 One-step or multistep filters 299 Fading a filter 300 Selectively applying a filter 300 Working in the Filter Gallery 301 Distorting with the Liquify filter 303 Correcting Camera Distortion 305 Exploring Elements’ Unique Filters 306 Creating a comic 307 Getting graphic 308 Using the Pen and Ink filter 309 Dressing Up with Photo and Text Effects 310 Adding Shadows, Glows, and More 313 Applying styles 314 Working with styles 315 Using the Graphics panel 316 Mixing It Up with Blend Modes 317 General blend modes 317 Darken blend modes 318 Lighten blend modes 319 Lighting blend modes 321 Inverter blend modes 321 HSL blend modes 323 Using Photomerge 324 Photomerge Panorama 324 Photomerge Group Shot 327 Photomerge Scene Cleaner 328 Photomerge Exposure 329 Photomerge Compose 332 Chapter 13: Drawing and Painting 335 Choosing Color 335 Working with the Color Picker 336 Dipping into the Color Swatches panel 337 Sampling with the Eyedropper tool 339 Getting Artsy with the Pencil and Brush Tools 340 Drawing with the Pencil tool 341 Painting with the Brush tool 343 Using the Impressionist Brush 345 Creating your own brush 346 Filling and Outlining Selections 348 Fill ’er up 348 Outlining with the Stroke command 350 Splashing on Color with the Paint Bucket Tool 351 Working with Multicolored Gradients 352 Applying a preset gradient 352 Customizing gradients 353 Working with Patterns 357 Applying a preset pattern 357 Creating a new pattern 358 Creating Shapes of All Sorts 359 Drawing a shape 360 Drawing multiple shapes 361 Specifying Geometry options 362 Editing shapes 364 Chapter 14: Working with Type 365 Understanding Type Basics 365 Tools 366 Modes 366 Formats 367 Creating Point Type 367 Creating Paragraph Type 369 Creating Path Type 370 Using the Text On Selection tool 370 Using the Text On Shape tool 371 Using the Text On Custom Path tool 373 Specifying Type Options 374 Editing Text 376 Simplifying Type 377 Masking with Type 378 Stylizing and Warping Type 381 Adjusting type opacity 381 Applying filters to your type 382 Painting your type with color and gradients 383 Warping your type 384 Using Text Overlay Templates 385 Part 5: Printing, Creating, and Sharing 387 Chapter 15: Getting It on Paper 389 Getting Pictures Ready for Printing 390 Working with Color Printer Profiles 391 Printing a photo with the printer managing color 393 Printing a photo with Elements managing color 396 Printing a picture package or contact sheet 396 Getting Familiar with the Print Dialog Box 397 Using the Prints options 397 Creating transfers, borders, and more with More Options 399 Outsourcing Printing 400 Chapter 16: Sharing Your Work 401 Getting Familiar with the Elements Sharing Options 401 Planning ahead 402 Understanding photo sharing in Elements 403 Using the Share Panel 404 Emailing photos 405 Working with Adobe Premiere Elements 408 Sharing your photos on social networks 408 Chapter 17: Making Creations 411 Checking Out the Create Panel 411 Grasping Creation-Assembly Basics 414 Creating a Quote Graphic 418 Creating a Memories Video 421 Creating a PDF Slideshow 422 Making Additional Creations 422 Chapter 18: Creating and Sharing on Elements Web 423 Launching Elements Web 423 Uploading files from the Organizer 424 Uploading files from the Share menu 425 Uploading files from the Photo Editor 426 Sharing Photos 427 Sharing to Facebook 428 Sharing on Elements Web 431 Getting familiar with the Elements Web interface 431 Managing images 433 Making Creations 435 Working with slideshows 436 Viewing .mp4 video files 437 Making photo collages 439 Part 6: the Part of Tens 441 Chapter 19: The Ten Best Guided Edits 443 Correct Skin Tone 443 Sharpen 445 Object Removal 446 Perfect Portrait 448 Replace Background 451 Remove a Color Cast 453 Levels 454 Resize Your Photo 456 Recompose 457 Move & Scale Object 459 Chapter 20: Ten (or So) More Project Ideas 463 Screen Savers 463 Flyers, Ads, and Online Auctions 464 Clothes, Hats, and More 466 Posters 467 Household and Business Inventories 467 Project Documentation 467 School Reports and Projects 468 Blogs 468 Wait — There’s More 468 Index 469

Read more less

Book SynopsisSecuring against operational interruptions and the theft of your data is much too important to leave to chance. By planning for the worst, you can ensure your organization is prepared for the unexpected. Enterprise Architecture and Information Assurance: Developing a Secure Foundation explains how to design complex, highly available, and secure enterprise architectures that integrate the most critical aspects of your organization''s business processes.Filled with time-tested guidance, the book describes how to document and map the security policies and procedures needed to ensure cost-effective organizational and system security controls across your entire enterprise. It also demonstrates how to evaluate your network and business model to determine if they fit well together. The book's comprehensive coverage includes: Infrastructure security model components Systems security categorization Business impact analysis Risk manaTable of ContentsSetting the Foundation. Building the Enterprise Infrastructure. Infrastructure Security Model Components. Systems Security Categorization. Business Impact Analysis. Risk. Secure Configuration Management. Contingency Planning. Cloud Computing. Continuous Monitoring. Physical Security. Building Security. The Certification and Accreditation Process.

Read more less