Business applications Books

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 SynopsisBill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 2,200 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 57 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. Before founding MrExcel.com, Bill Jelen spent 12 years in the trenchesworking as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives in Merritt Island, Florida, with his wife, Mary Ellen. Tracy Syrstad is a Microsoft Excel developer and author of nine Excel books. She has been helping people with Microsoft Office issues since 1997, when she discovered free online forums where anyone could ask and answer questions. Tracy found out she enjoyed teaching others new skills, and when she began working as a developer, she was able to integrate the fun of teaching with one-on-one online desktop sharing sessions. Tracy lives on an acreage in eastern South Dakota with her husband, one dog, two cats, one horse, and a variety of wild foxes, squirrels, and rabbits.Table of ContentsIntroduction 1. Unleash the Power of Excel with VBA 2. This Sounds Like BASIC, So Why Doesn't It Look Familiar? 3. Referring to Ranges 4. Looping and Flow Control 5. R1C1-style Formulas 6. Creating and manipulating Names in VBA 7. Event Programming 8. Arrays 9. Creating Classes and Collections 10. Userforms: An Introduction 11. Data Mining with Advanced Filter 12. Using VBA to Create Pivot Tables 13. Excel Power 14. Sample User-Defined Functions 15. Creating Charts 16. Data Visualizations and Conditional Formatting 17. Dashboarding with Sparklines in Excel 18. Reading from the Web using M and VBA 19. Text File Processing 20. Automating Word 21. Using Access as a Back End to Enhance Multiuser Access to Data 22. Advanced Userform Techniques 23. Windows Application Programming Interface (API) 24. Handling Errors 25. Customizing the Ribbon to Run Macros 26. Creating Excel Add-Ins 27. An Introduction to Creating Office Add-ins 28. What's New in Excel 365 and What's Changed

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 SynopsisAdaptive business intelligence systems combine prediction and optimization techniques to assist decision makers in complex, rapidly changing environments. These systems address fundamental questions: What is likely to happen in the future? What is the best course of action? Adaptive Business Intelligence explores elements of data mining, predictive modeling, forecasting, optimization, and adaptability. The book explains the application of numerous prediction and optimization techniques, and shows how these concepts can be used to develop adaptive systems. Coverage includes linear regression, time-series forecasting, decision trees and tables, artificial neural networks, genetic programming, fuzzy systems, genetic algorithms, simulated annealing, tabu search, ant systems, and agent-based modeling.Trade ReviewFrom the reviews: "In this book the authors explain the science and application of numerous prediction and optimization techniques as well as how these concepts can be used to develop adaptive decision-making systems. The book is suitable for business and IT managers who make decisions in complex industrial and service environments, non-specialists who want to understand the science behind better predictions and decisions, and students and researchers who need a quick introduction to the field." (OpenPR, December, 2006) "The authors want to explain why the business intelligence industry can rely on systems that can make good decisions … . The second aim is to point out the principles behind many prediction methods and optimization techniques in simple terms, so that any business manager could grasp and apply them. … The authors third goal is to underscore the enormous applicability of ABI … . the main features, characteristic aspects, and useful arguments that make this book a novelty work and valuable textbook." (Neculai Curteanu, Zentralblatt MATH, Vol. 1122 (24), 2007) "We believe that the authors have presented the selected material in a way that meets the interests of their targeted audience. ... These examples show the great potential of the approach that the book presents. ... If contemporary business managers read Adaptive Business Intelligence, we believe that they will become supporters of the proposed intelligent decision-making systems. We complete our review with the optimistic quotation from Chapter 13: "... the future of the business intelligence industry lies in systems that can predict, optimize, and adapt – put another way, the future of the industry lies in Adaptive Business Intelligence". Hopefully, this book will speed up our progress to such a future." (Antanas Zilinskas, Vilnius Pedagogical University, Interfaces – Int. J. of the Institute for Operations Research and the Management Sciences, 38(3) May–June 2008, pp. 212–220) Table of ContentsComplex Business Problems.- Characteristics of Complex Business Problems.- An Extended Example: Car Distribution.- Adaptive Business Intelligence.- Prediction and Optimization.- Prediction Methods and Models.- Modern Optimization Techniques.- Fuzzy Logic.- Artificial Neural Networks.- Other Methods and Techniques.- Adaptive Business Intelligence.- Hybrid Systems and Adaptability.- Car Distribution System.- Applying Adaptive Business Intelligence.- Conclusions.

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 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 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 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

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

Read more less

Book Synopsis

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 SynopsisPaul McFedries is an Excel expert and full-time technical writer. Paul has been authoring computer books since 1991 and has more than 100 books to his credit, which combined have sold more than 4 million copies worldwide. His titles include the Que Publishing books My Office 2016, Windows 10 In Depth (with coauthor Brian Knittel), and PCs for Grownups, as well as the Sams Publishing book Windows 7 Unleashed. Please drop by Paul's personal websiTable of ContentsPart 1: Mastering Excel formulas Chapter 1: Building basic formulas Chapter 2: Creating advanced formulas Chapter 3: Troubleshooting formulas Part 2: 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 3: 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 Synopsis

Read more less

Book SynopsisMake your 3D world a reality Some of the dramatic visual effects you''ve seen in top-grossing movies and heralded television series got their start in Blender. This book helps you get your own start in creating three-dimensional characters, scenes, and animations in the popular free and open-source tool. Author Jason van Gumster shares his insight as an independent animator and digital artist to help Blender newcomers turn their ideas into three-dimensional drawings. From exporting and sharing scenes to becoming a part of the Blender community, this accessible book covers it all! Create 3D charactersno experience required Build scenes with texture and real lighting features Animate your creations and share them with the world Avoid common rookie mistakes This book is the ideal starting place for newcomers to the world of 3D modeling and animation. Table of ContentsIntroduction 1 About This Book 2 Foolish Assumptions 2 Icons Used in This Book 4 Beyond the Book 4 Where to Go from Here 5 Part 1: Wrapping Your Brain Around Blender 7 Chapter 1: Discovering Blender 9 Getting to Know Blender 10 Discovering Blender’s origins and the strength of the Blender community 11 Making open movies and games 12 Getting to Know the Interface 15 Working with an interface that stays out of your way 17 Resizing areas 19 Maximizing an area 20 The menu that is a pie 22 Chapter 2: Understanding How Blender Thinks 25 Looking at Editor Types 25 General editors 26 Animation editors 28 Scripting editors 29 Data editors 29 Understanding the Properties editor 30 Navigating in Three Dimensions 32 Orbiting, panning, and zooming the 3D Viewport 32 Changing views 35 Selecting objects 40 Taking advantage of the 3D cursor 40 Extra Features in the 3D Viewport 44 Quad View 44 Regions 45 Collaborating (with others and yourself) with annotations 48 Don’t know how to do something? Hooray for fully Integrated search! 49 Customizing Blender to Fit You 50 Using preset workspaces 51 Blender workflows 55 Setting user preferences 57 Using custom event maps 58 Speeding up your workflow with Quick Favorites 61 Chapter 3: Getting Your Hands Dirty Working in Blender 63 Grabbing, Scaling, and Rotating 64 Differentiating Between Coordinate Systems 64 Transforming an Object by Using Object Gizmos 67 Activating object gizmos 68 Using object gizmos 69 Saving Time by Using Hotkeys 72 Transforming with hotkeys 73 Hotkeys and coordinate systems 73 Numerical input 76 The Sidebar 76 Chapter 4: Working in Edit Mode and Object Mode 77 Making Changes by Using Edit Mode 77 Switching between Object mode and Edit mode 78 Selecting vertices, edges, and faces 79 Working with linked vertices 84 Still Blender’s No 1 modeling tool: Extrude 85 Adding to a Scene 90 Adding objects 90 Meet Suzanne, the Blender monke 92 Joining and separating objects 93 Creating duplicates and links 95 Discovering parents, children, and collections 101 Saving, opening, and appending 108 Part 2: Creating Detailed 3D Scenes 111 Chapter 5: Creating Anything You Can Imagine with Meshes 113 Pushing Vertices 114 Getting familiar with Edit mode tools 116 Adding geometry by insetting 117 Cutting edges with the Knife 122 Rounding your corners by beveling 126 Spiraling new geometry into existence with the Spin tool 130 Working with Loops and Rings 131 Understanding edge loops and face loops 132 Selecting edge rings 134 Creating new loops 135 Simplifying Your Life as a Modeler with Modifiers 137 Understanding modifier types 140 Doing half the work (and still looking good!) with the Mirror modifier 147 Smoothing things out with the Subdivision Surface modifier 149 Using the power of Arrays 153 Chapter 6: Sculpting in Virtual Space 157 Adding Background Images in the 3D Viewport 158 Mastering the types of image objects 159 Changing image object properties 160 Adjusting your image objects 162 Setting Up Your Sculpting Workspace 163 Sculpting a Mesh Object 166 Understanding sculpt tool types 166 Tweaking brush properties 173 Refining control of your tools 174 Creating custom brushes 176 Using Blender’s texture system to tweak brushes 176 Sculpting with the Multiresolution modifier 177 Freeform Sculpting with Dynamic Topology (Dyntopo) 180 Understanding the Basics of Retopology 184 Chapter 7: Using Blender’s Non-Mesh Primitives 189 Using Curves and Surfaces 190 Understanding the different types of curves 192 Working with curves 193 Understanding the strengths and limitations of Blender’s Surfaces 212 Using Metaball Objects 213 Meta-wha? 214 What metaball objects are useful for 217 Adding Text 217 Adding and editing text 218 Controlling text appearance 219 Deforming text with a curve 227 Converting to curves and meshes 228 Chapter 8: Changing That Boring Gray Default Material 229 Understanding Materials and Render Engines 230 Quick ’n’ Dirty Coloring 233 Setting diffuse colors 233 Assigning multiple materials to different parts of a mesh 235 Using vertex colors 240 Setting Up Node Materials 247 Adjusting your workspace to work with materials 248 Working with nodes 249 Understanding shaders 250 Playing with Materials in Blender 251 Demystifying the Principled BSDF 252 Combining shaders with the Mix Shader node 258 Playing with the Shader to RGB node 263 Chapter 9: Giving Models Texture 267 Adding Textures 267 Using Procedural Textures 268 Understanding Texture Mapping 272 Making simple adjustments with the Texture Mapping panel 272 Using texture coordinates 273 Understanding Object coordinates and the UV Project modifier 278 Unwrapping a Mesh 281 Marking seams on a mesh 282 Adding a test grid 283 Generating and editing UV coordinates 284 Painting Textures Directly on a Mesh 287 Preparing to paint 288 Working in Texture Paint mode 290 Using textures on your Draw tool 292 Saving Painted Textures and Exporting UV Layouts 295 Chapter 10: Lighting and Environment 297 Lighting a Scene 297 Understanding a basic three-point lighting setup 298 Knowing when to use which type of light 301 Lighting for Speedy Renders 317 Working with three-point lighting in Blender 318 Using Look Dev to set up lighting 318 Setting Up the World 320 Changing the sky to something other than dull gray 320 Understanding ambient occlusion 325 Working with Light Probes in Eevee 328 Baking from your light probes 330 Understanding the limitations of light probes 332 Part 3: Get Animated! 333 Chapter 11: Animating Objects 335 Working with Animation Curves 336 Customizing your screen layout for Animation 338 Inserting keys 340 Working with keying sets 345 Working in the Graph Editor 351 Editing motion curves 352 Using Constraints Effectively 356 The all-powerful Empty! 357 Adjusting the influence of a constraint 360 Using vertex groups in constraints 361 Copying the movement of another object 361 Putting limits on an object 363 Tracking the motion of another object 365 Chapter 12: Rigging: The Art of Building an Animatable Puppet 367 Creating Shape Keys 368 Creating new shapes 368 Mixing shapes 370 Knowing where shape keys are helpful 372 Adding Hooks 373 Creating new hooks 373 Knowing where hooks are helpful 375 Using Armatures: Skeletons in the Mesh 375 Editing armatures 376 Putting skin on your skeleton 390 Bringing It All Together to Rig a Character 396 Building Stickman’s centerline 396 Adding Stickman’s appendages 397 Taking advantage of parenting and constraints 400 Comparing inverse kinematics and forward kinematics 403 Making the rig more user friendly 407 Chapter 13: Animating Object Deformations 411 Working with the Dope Sheet 411 Selecting keys in the Dope Sheet 412 Working with markers 415 Recognizing different kinds of keyframe indicators 416 Animating with Armatures 418 Principles of animation worth remembering 420 Making sense of quaternions (or, “Why are there four rotation curves?!”) 423 Copying mirrored poses 424 Doing Nonlinear Animation 425 Working with actions 426 Mixing actions to create complex animation 429 Taking advantage of looped animation 430 Chapter 14: Letting Blender Do the Work for You 433 Using Particles in Blender 435 Knowing what particle systems are good for 436 Using force fields and collisions 440 Using particles for hair and fur 442 Giving Objects Some Jiggle and Bounce 446 Dropping Objects in a Scene with Rigid Body Dynamics 449 Simulating Cloth 450 Splashing Fluids in Your Scene 452 Smoking without Hurting Your Lungs: Smoke Simulation in Blender 457 Creating a smoke simulation 457 Rendering smoke 458 Chapter 15: Making 2D and 2.5D Animation with Grease Pencil 461 Getting Started with the 2D Animation Workspace 462 Working with Grease Pencil tools 464 Drawing with Grease Pencil 465 Sculpting Grease Pencil objects 470 Editing Grease Pencil objects 472 Understanding Grease Pencil Materials 473 Mastering Grease Pencil Layers 478 Automating Your Drawings with Grease Pencil Modifiers 482 Animating with Grease Pencil 488 Using a hand-drawn animation workflow with Grease Pencil objects 488 Rigging Grease Pencil objects for animation 492 Integrating Grease Pencil with a 3D Scene 495 Part 4: Sharing Your Work with the World 497 Chapter 16: Exporting and Rendering Scenes 499 Exporting to External Formats 499 Rendering a Scene 502 Creating a still image 502 Creating a sequence of still images for editing or compositing 509 Chapter 17: Editing Video and Animation 513 Comparing Editing to Compositing 514 Working with the Video Sequencer 514 Adding and editing strips 518 Adding effects and transitions 525 Rendering from the Video Sequencer 527 Chapter 18: Compositing Images and Video 531 Understanding Nodes 531 Getting Started with the Compositor 534 Rendering in Passes and Layers 535 Discovering Passes Available in Eevee and Cycles 536 Understanding Cycles-only Light Passes 540 Meet Cryptomatte 542 Working with Nodes 544 Configuring the backdrop 545 Identifying Parts of a Node 547 Navigating the Compositor 548 Adding nodes to your compositing network 549 Grouping nodes together 550 Discovering the Nodes Available to You 550 Rendering from the Compositor 552 Chapter 19: Mixing Video and 3D with Motion Tracking 553 Making Your Life Easier by Starting with Good Video 554 Knowing your camera 554 Keeping your lighting consistent 556 Having images in good focus 557 Understanding the scene 558 Getting Familiar with the Motion Tracking Workspace 559 Tracking Movement in Blender 561 Adding markers and tracking 563 Solving camera motion from tracker data 569 Setting up your scene for integrating with your video footage 573 Where to Go from Here 575 Part 5: the Part of Tens 577 Chapter 20: Ten Tips for Working More Effectively in Blender 579 Use Tooltips and Integrated Search 579 Take Advantage of the Quick Favorites Menu 580 Look at Models from Different Views 580 Don’t Forget about Add-ons 582 Lock a Camera to an Animated Character 582 Name Everything 583 Do Low-Resolution Test Renders 583 Use Annotations to Plan 586 Ask for Help 586 Have Fun, but Take Breaks 587 Chapter 21: Ten Excellent Community Resources 589 Blender org 589 Blender ID 590 Blender manual 590 Developer blog 590 Bug reporting and developer discussions 590 builder blender org 591 Blender Cloud 592 BlenderArtists org 592 BlenderNation 592 BlenderBasics com 593 Blender Stackexchange com 593 CGCookie com 593 Blend Swap (blendswap com) 593 Blender community 594 Blender Today 594 Right-Click Select 594 Blender NPR 595 Social Media 595 Blender chat 596 Index 597

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 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 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 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 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 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 SynopsisDid you know that there is a technology inside Excel, and Power BI, that allows you to create magic in your data, avoid repetitive manual work, and save you time and money? Using Excel and Power BI, you can: Save time by eliminating the pain of copying and pasting data into workbooks and then manually cleaning that data. Gain productivity by properly preparing data yourself, rather than relying on others to do it. Gain effiiciency by reducing the time it takes to prepare data for analysis, and make informed decisions more quickly. With the data connectivity and transformative technology found in Excel and Power BI, users with basic Excel skills import data and then easily reshape and cleanse that data, using simple intuitive user interfaces. Known as “Get & Transform” in Excel 2016, as the “Power Query” separate add-in in Excel 2013 and 2010, and included in Power BI, you'll use this technology to tackle common data challenges, resolving them with simple mouse clicks and lightweight formula editing. With your new data transformation skills acquired through this book, you will be able to create an automated transformation of virtually any type of data set to mine its hidden insights.Table of Contents Section 1: Transforming Data Chapter 1: Introduction to Power Query Chapter 2: Basic Data Challenges Chapter 3: Combining Data from Multiple Sources Chapter 4: Unpivoting and Transforming Data Chapter 5: Pivoting & Handling Multiline Records Section 2: Exploring Data Chapter 6: Ad-Hoc Analysis Chapter 7: Using Query Editor to Further Explore Data Section 3: Scaling Up Queries for Production or Larger Data Sets Chapter 8: Introduction to the M Query Language Chapter 9: Lightweight modification of M formulas to improve query robustness Section 4: Real Life Challenges Chapter 10: Solving Real-Life Data Challenges Chapter 11: Social Listening Chapter 12: Text Analytics Chapter 13: Concluding Exercise – Hawaii Tourism Data

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 Synopsis

Read more less

Book SynopsisTracy Syrstad has been deeply immersed in the world of Excel programming for 20 years, acquiring a comprehensive skillset largely through independent learning. VBA is more than just a programming language for her; it's a tool to unlock efficiency. Tracy's passion for empowering clients through automated projects and one-on-one Excel programming instruction extends beyond personal development. This hands-on experience, combined with her proven track record of authoring seven previous VBA books for Microsoft Press, equips her with the unique ability to translate complex Excel concepts into clear and engaging content for a broad audience. Bill Jelen is the host of MrExcel.com and the author of 67 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Microsoft Excel Inside Out. He was an ESPN commentator for the World Excel Championships, has made over 80 guest appearances on TV's Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show. He writes the Excel column for Strategic Finance magazine. He has produced over 2400 episodes of his video podcast Learn Excel from MrExcel. Before founding MrExcel.com in 1998, Jelen spent twelve years in the trenches, as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company.

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 SynopsisPrivacyEngineering is a hands-on guide to building a modern and flexible privacy program for your organization. It helps map essential legal requirements into practical engineering techniques that you can implement right away. The book develops your strategic understanding of data governance and helps you navigate the tricky trade-offs between privacy and business needs. You'll learn to spot risks in your own data management systems and prepare to satisfy both internal and external privacy audits. There's no bureaucratic new processes or expensive new software necessary. You'll learn how to repurpose the data and security tools you already use to achieve your privacy goals. Preserving the privacy of your users is essential for any successful business. Well-designed processes and data governance ensure that privacy is built into your systems from the ground up, keeping your users safe and helping your organization maintain compliance with the law. Trade Review“A great high-level resource on privacy as it relates to the data collected by business software systems.” Joe Ivans “Provides a clear and thorough explanation of the how and the why of data privacy pitched at a level which isn't too technical, yet has a sufficient level of detail to allow for interpretation of implementation.” Matthew Todd “Really interesting subject matter. The author provides relevant examples and obviously has a lot of direct experience.” John Tyler “A great resource on approaching data privacy.” Doniyor Ulmasov “The best parts are the personal elements added to the narrative. I also enjoyed the case studies that help to illustrate the examples provided throughout.” Ayana Miller

Read more less

Book SynopsisSynthesizes systems theory and interactive design, providing an operational methodology for defining problems and designing solutions in an environment increasingly characterized by chaos and complexity. This title include chapters on self-organizing systems, holistic thinking, operational thinking, and design thinking.Trade Review"Einstein once wrote, "Without changing our pattern of thought, we will not be able to solve the problems we created with our current patterns of thought." Jamshid develops a pattern of thought that will yield solutions to those problems." --Russell Ackoff, Professor Emeritus, The Wharton School, University of Pennsylvania "Gharajedaghi challenged us to think backwards from an ideal competitive position instead of forwards from our existing position with all its constraints. The result was bolder thinking about change. Jamshid forces a realistic assessment of a company’s strengths and weaknesses, an idealistic view of what it could be, and creates the path from point A to point B." --Bill Tiefel, President, Marriott Lodging "Gharajedaghi was perfect! He had passion and brilliance. He could challenge our traditional thinking and make us see our actions and opportunities from a different perspective." --William G. Poist, President and CEO, Commonwealth Energy System "This volume on business management explores the development of complex systems and advocates for iterative design principles as a foundational philosophy for dealing with complex, chaotic systems. The volume discusses system theory and changes to traditional paradigms in light of emerging technologies and business methodologies and explores case studies from industry leaders that showcase these systems philosophies." --SciTech Book NewsTable of ContentsPart I: Systems Philosophy: The Name of the Devil 1. How the Game Is Evolving Part II Systems Theory: The Nature of the Beast 2. Systems Principles 3. Socio-cultural Systems 4. Socio-cultural System 2 Part III: Systems Methodology: Logic of the Madness 5. Holistic Thinking 6. Operational Thinking 7. Design Thinking 8. Design Thinking (2), Formulation of mess 9. Designing thinking (3), Business Architecture Part IV: Systems Practice: The Gutsy Few 10. Oneida Nation 11. Butterworth Health System 12. Marriott Corporation 13. Commonwealth Energy 14. Carrier Corporation

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 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 SynopsisPlan, create, and deliver amazing presentations! Alexei Kapterev's online presentation on presentations has seen more than one million views, all with no advertising or promotion.Trade ReviewA very likable book. It s lavishly illustrated with colour images explaining the art of giving speeches and presentations. (The Speech Writers Guild, January 2012)Table of ContentsRead This First xiii Chapter 1 3 What Is Presentation? 1 What Are Presentations? 2 Story 4 Slides 7 Delivery 13 The Three Principles of Presenting 14 Summary 22 Part I 3 Story 23 Chapter 2 3 The Story’s Focus 25 Not All Stories Are Created Equal 26 Focusing on One Idea 26 Setting the Goal 27 The Customer Isn’t Always Right 35 Gathering the Material 39 Inventing the Truth 47 Can You Sell Without Lying? 47 Summary 48 Chapter 3 3 The Story’s Contrast 51 Problems and Solutions 52 Hero and Villain 63 Summary 73 Chapter 4 3 The Story’s Unity 75 Making Your Story Unified 76 Case Study: The Story of Tomato Sauce 80 The Problem of Balance 82 Case Study: A Company Introduction 99 Summary 101 Part I I 3 Slides 103 Chapter 5 3 The Slides’ Focus 105 Producing Your Slides 106 Zen and Vajrayana 107 Designing Zen Slides 113 Summary 131 Chapter 6 3 The Slides’ Contrast 133 Energizing Lifeless Diagrams 134 Using Comparisons 136 Data Visualization 144 Lies, Damned Lies, and Statistics 155 A Word on Animation 159 Where to Go Next?—Visualization Resources 161 Summary 162 Chapter 7 3 The Slides’ Unity 163 Avoiding Ugly Slides 164 Slide Design for Non-Designers 165 Working with Pictures 188 United World in a Slide Deck 191 Summary 195 Part I I I 3 Delivery 197 Chapter 8 3 Focus in Delivery 199 What Should You Focus on During Delivery? 200 Clarity 202 Pace 205 Voice 207 Engaging with Your Audience 208 Making Eye Contact 212 Addressing Any Questions 218 Using Humor (or Not?) 218 Summary 220 Chapter 9 3 Contrast in Delivery 221 The Opposite of Monotony 222 Being Perfect Versus Being Passionate 223 Don’t Avoid Confrontation 226 Learning from Other People 232 Summary 241 Chapter 10 3 Unity in Delivery 243 Going with the Flow 244 The Pros and Cons of Improvisation 247 Relaxing Control 251 Summary 263 Chapter 11 3 Where to Go Next 265 Presentation Checklist 266 Taking Further Steps 269 General Presentation Resources 269 Storytelling Resources 270 Slide Resources 273 Delivery Resources 275 Presentations Transform 277 Index 279

Read more less

Book SynopsisFind the right big data solution for your business or organization Big data management is one of the major challenges facing business, industry, and not-for-profit organizations.Table of ContentsIntroduction 1 About This Book 2 Foolish Assumptions 2 How This Book Is Organized 3 Part I: Getting Started with Big Data 3 Part II: Technology Foundations for Big Data 3 Part III: Big Data Management 3 Part IV: Analytics and Big Data 4 Part V: Big Data Implementation 4 Part VI: Big Data Solutions in the Real World 4 Part VII: The Part of Tens 4 Glossary 4 Icons Used in This Book 5 Where to Go from Here 5 Part I: Getting Started with Big Data 7 Chapter 1: Grasping the Fundamentals of Big Data 9 The Evolution of Data Management 10 Understanding the Waves of Managing Data 11 Wave 1: Creating manageable data structures 11 Wave 2: Web and content management 13 Wave 3: Managing big data 14 Defining Big Data 15 Building a Successful Big Data Management Architecture 16 Beginning with capture, organize, integrate, analyze, and act 16 Setting the architectural foundation 17 Performance matters 20 Traditional and advanced analytics 22 The Big Data Journey 23 Chapter 2: Examining Big Data Types 25 Defining Structured Data 26 Exploring sources of big structured data 26 Understanding the role of relational databases in big data 27 Defining Unstructured Data 29 Exploring sources of unstructured data 29 Understanding the role of a CMS in big data management 31 Looking at Real-Time and Non-Real-Time Requirements 32 Putting Big Data Together 33 Managing different data types 33 Integrating data types into a big data environment 34 Chapter 3: Old Meets New: Distributed Computing 37 A Brief History of Distributed Computing 37 Giving thanks to DARPA 38 The value of a consistent model 39 Understanding the Basics of Distributed Computing 40 Why we need distributed computing for big data 40 The changing economics of computing 40 The problem with latency 41 Demand meets solutions 41 Getting Performance Right 42 Part II: Technology Foundations for Big Data 45 Chapter 4: Digging into Big Data Technology Components 47 Exploring the Big Data Stack 48 Layer 0: Redundant Physical Infrastructure 49 Physical redundant networks 51 Managing hardware: Storage and servers 51 Infrastructure operations 51 Layer 1: Security Infrastructure 52 Interfaces and Feeds to and from Applications and the Internet 53 Layer 2: Operational Databases 54 Layer 3: Organizing Data Services and Tools 56 Layer 4: Analytical Data Warehouses 56 Big Data Analytics 58 Big Data Applications 58 Chapter 5: Virtualization and How It Supports Distributed Computing 61 Understanding the Basics of Virtualization 61 The importance of virtualization to big data 63 Server virtualization 64 Application virtualization 65 Network virtualization 66 Processor and memory virtualization 66 Data and storage virtualization 67 Managing Virtualization with the Hypervisor 68 Abstraction and Virtualization 69 Implementing Virtualization to Work with Big Data 69 Chapter 6: Examining the Cloud and Big Data 71 Defining the Cloud in the Context of Big Data 71 Understanding Cloud Deployment and Delivery Models 72 Cloud deployment models 73 Cloud delivery models 74 The Cloud as an Imperative for Big Data 75 Making Use of the Cloud for Big Data 77 Providers in the Big Data Cloud Market 78 Amazon’s Public Elastic Compute Cloud 78 Google big data services 79 Microsoft Azure 80 OpenStack 80 Where to be careful when using cloud services 81 Part III: Big Data Management 83 Chapter 7: Operational Databases 85 RDBMSs Are Important in a Big Data Environment 87 PostgreSQL relational database 87 Nonrelational Databases 88 Key-Value Pair Databases 89 Riak key-value database 90 Document Databases 91 MongoDB 92 CouchDB 93 Columnar Databases 94 HBase columnar database 94 Graph Databases 95 Neo4J graph database 96 Spatial Databases 97 PostGIS/OpenGEO Suite 98 Polyglot Persistence 99 Chapter 8: MapReduce Fundamentals 101 Tracing the Origins of MapReduce 101 Understanding the map Function 103 Adding the reduce Function 104 Putting map and reduce Together 105 Optimizing MapReduce Tasks 108 Hardware/network topology 108 Synchronization 108 File system 108 Chapter 9: Exploring the World of Hadoop 111 Explaining Hadoop 111 Understanding the Hadoop Distributed File System (HDFS) 112 NameNodes 113 Data nodes 114 Under the covers of HDFS 115 Hadoop MapReduce 116 Getting the data ready 117 Let the mapping begin 118 Reduce and combine 118 Chapter 10: The Hadoop Foundation and Ecosystem 121 Building a Big Data Foundation with the Hadoop Ecosystem 121 Managing Resources and Applications with Hadoop YARN 122 Storing Big Data with HBase 123 Mining Big Data with Hive 124 Interacting with the Hadoop Ecosystem 125 Pig and Pig Latin 125 Sqoop 126 Zookeeper 127 Chapter 11: Appliances and Big Data Warehouses 129 Integrating Big Data with the Traditional Data Warehouse 129 Optimizing the data warehouse 130 Differentiating big data structures from data warehouse data 130 Examining a hybrid process case study 131 Big Data Analysis and the Data Warehouse 133 The integration lynchpin 134 Rethinking extraction, transformation, and loading 134 Changing the Role of the Data Warehouse 135 Changing Deployment Models in the Big Data Era 136 The appliance model 136 The cloud model 137 Examining the Future of Data Warehouses 137 Part IV: Analytics and Big Data 139 Chapter 12: Defining Big Data Analytics 141 Using Big Data to Get Results 142 Basic analytics 142 Advanced analytics 143 Operationalized analytics 146 Monetizing analytics 146 Modifying Business Intelligence Products to Handle Big Data 147 Data 147 Analytical algorithms 148 Infrastructure support 148 Studying Big Data Analytics Examples 149 Orbitz 149 Nokia 150 NASA 150 Big Data Analytics Solutions 151 Chapter 13: Understanding Text Analytics and Big Data 153 Exploring Unstructured Data 154 Understanding Text Analytics 155 The difference between text analytics and search 156 Analysis and Extraction Techniques 157 Understanding the extracted information 159 Taxonomies 160 Putting Your Results Together with Structured Data 160 Putting Big Data to Use 161 Voice of the customer 161 Social media analytics 162 Text Analytics Tools for Big Data 164 Attensity 164 Clarabridge 165 IBM 165 OpenText 165 SAS 166 Chapter 14: Customized Approaches for Analysis of Big Data 167 Building New Models and Approaches to Support Big Data 168 Characteristics of big data analysis 168 Understanding Different Approaches to Big Data Analysis 170 Custom applications for big data analysis 171 Semi-custom applications for big data analysis 173 Characteristics of a Big Data Analysis Framework 174 Big to Small: A Big Data Paradox 177 Part V: Big Data Implementation 179 Chapter 15: Integrating Data Sources 181 Identifying the Data You Need 181 Exploratory stage 182 Codifying stage 184 Integration and incorporation stage 184 Understanding the Fundamentals of Big Data Integration 186 Defining Traditional ETL 187 Data transformation 188 Understanding ELT — Extract, Load, and Transform 189 Prioritizing Big Data Quality 189 Using Hadoop as ETL 191 Best Practices for Data Integration in a Big Data World 191 Chapter 16: Dealing with Real-Time Data Streams and Complex Event Processing 193 Explaining Streaming Data and Complex Event Processing 194 Using Streaming Data 194 Data streaming 195 The need for metadata in streams 196 Using Complex Event Processing 198 Differentiating CEP from Streams 199 Understanding the Impact of Streaming Data and CEP on Business 200 Chapter 17: Operationalizing Big Data 201 Making Big Data a Part of Your Operational Process 201 Integrating big data 202 Incorporating big data into the diagnosis of diseases 203 Understanding Big Data Workflows 205 Workload in context to the business problem 206 Ensuring the Validity, Veracity, and Volatility of Big Data 207 Data validity 207 Data volatility 208 Chapter 18: Applying Big Data within Your Organization 211 Figuring the Economics of Big Data 212 Identification of data types and sources 212 Business process modifications or new process creation 215 The technology impact of big data workflows 215 Finding the talent to support big data projects 216 Calculating the return on investment (ROI) from big data investments 216 Enterprise Data Management and Big Data 217 Defining Enterprise Data Management 217 Creating a Big Data Implementation Road Map 218 Understanding business urgency 218 Projecting the right amount of capacity 219 Selecting the right software development methodology 219 Balancing budgets and skill sets 219 Determining your appetite for risk 220 Starting Your Big Data Road Map 220 Chapter 19: Security and Governance for Big Data Environments 225 Security in Context with Big Data 225 Assessing the risk for the business 226 Risks lurking inside big data 226 Understanding Data Protection Options 227 The Data Governance Challenge 228 Auditing your big data process 230 Identifying the key stakeholders 231 Putting the Right Organizational Structure in Place 231 Preparing for stewardship and management of risk 232 Setting the right governance and quality policies 232 Developing a Well-Governed and Secure Big Data Environment 233 Part VI: Big Data Solutions in the Real World 235 Chapter 20: The Importance of Big Data to Business 237 Big Data as a Business Planning Tool 238 Stage 1: Planning with data 238 Stage 2: Doing the analysis 239 Stage 3: Checking the results 239 Stage 4: Acting on the plan 240 Adding New Dimensions to the Planning Cycle 240 Stage 5: Monitoring in real time 240 Stage 6: Adjusting the impact 241 Stage 7: Enabling experimentation 241 Keeping Data Analytics in Perspective 241 Getting Started with the Right Foundation 242 Getting your big data strategy started 242 Planning for Big Data 243 Transforming Business Processes with Big Data 244 Chapter 21: Analyzing Data in Motion: A Real-World View 245 Understanding Companies’ Needs for Data in Motion 246 The value of streaming data 247 Streaming Data with an Environmental Impact 247 Using sensors to provide real-time information about rivers and oceans 248 The benefits of real-time data 249 Streaming Data with a Public Policy Impact 249 Streaming Data in the Healthcare Industry 251 Capturing the data stream 251 Streaming Data in the Energy Industry 252 Using streaming data to increase energy efficiency 252 Using streaming data to advance the production of alternative sources of energy 252 Connecting Streaming Data to Historical and Other Real-Time Data Sources 253 Chapter 22: Improving Business Processes with Big Data Analytics: A Real-World View 255 Understanding Companies’ Needs for Big Data Analytics 256 Improving the Customer Experience with Text Analytics 256 The business value to the big data analytics implementation 257 Using Big Data Analytics to Determine Next Best Action 257 Preventing Fraud with Big Data Analytics 260 The Business Benefit of Integrating New Sources of Data 262 Part VII: The Part of Tens 263 Chapter 23: Ten Big Data Best Practices 265 Understand Your Goals 265 Establish a Road Map 266 Discover Your Data 266 Figure Out What Data You Don’t Have 267 Understand the Technology Options 267 Plan for Security in Context with Big Data 268 Plan a Data Governance Strategy 268 Plan for Data Stewardship 268 Continually Test Your Assumptions 269 Study Best Practices and Leverage Patterns 269 Chapter 24: Ten Great Big Data Resources 271 Hurwitz & Associates 271 Standards Organizations 271 The Open Data Foundation 272 The Cloud Security Alliance 272 National Institute of Standards and Technology 272 Apache Software Foundation 273 Oasis 273 Vendor Sites 273 Online Collaborative Sites 274 Big Data Conferences 274 Chapter 25: Ten Big Data Do’s and Don’ts 275 Do Involve All Business Units in Your Big Data Strategy 275 Do Evaluate All Delivery Models for Big Data 276 Do Think about Your Traditional Data Sources as Part of Your Big Data Strategy 276 Do Plan for Consistent Metadata 276 Do Distribute Your Data 277 Don’t Rely on a Single Approach to Big Data Analytics 277 Don’t Go Big Before You Are Ready 277 Don’t Overlook the Need to Integrate Data 277 Don’t Forget to Manage Data Securely 278 Don’t Overlook the Need to Manage the Performance of Your Data 278 Glossary 279 Index 295

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 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 SynopsisThe final edition of the incomparable data warehousing and business intelligence reference, updated and expanded The Kimball Group Reader, Remastered Collection is the essential reference for data warehouse and business intelligence design, packed with best practices, design tips, and valuable insight from industry pioneer Ralph Kimball and the Kimball Group. This Remastered Collection represents decades of expert advice and mentoring in data warehousing and business intelligence, and is the final work to be published by the Kimball Group. Organized for quick navigation and easy reference, this book contains nearly 20 years of experience on more than 300 topics, all fully up-to-date and expanded with 65 new articles. The discussion covers the complete data warehouse/business intelligence lifecycle, including project planning, requirements gathering, system architecture, dimensional modeling, ETL, and business intelligence analytics, with each group of articles prefacedTable of ContentsIntroduction xxv 1 The Reader at a Glance 1 Setting Up for Success 1 1.1 Resist the Urge to Start Coding 1 1.2 Set Your Boundaries 4 Tackling DW/BI Design and Development 6 1.3 Data Wrangling 6 1.4 Myth Busters 9 1.5 Dividing the World 10 1.6 Essential Steps for the Integrated Enterprise Data Warehouse 13 1.7 Drill Down to Ask Why 22 1.8 Slowly Changing Dimensions 25 1.9 Judge Your BI Tool through Your Dimensions 28 1.10 Fact Tables 31 1.11 Exploit Your Fact Tables 33 2 Before You Dive In 35 Before Data Warehousing 35 2.1 History Lesson on Ralph Kimball and Xerox PARC 36 Historical Perspective 37 2.2 The Database Market Splits 37 2.3 Bringing Up Supermarts 40 Dealing with Demanding Realities 47 2.4 Brave New Requirements for Data Warehousing 47 2.5 Coping with the Brave New Requirements 52 2.6 Stirring Things Up 57 2.7 Design Constraints and Unavoidable Realities 60 2.8 Two Powerful Ideas 64 2.9 Data Warehouse Dining Experience 67 2.10 Easier Approaches for Harder Problems 70 2.11 Expanding Boundaries of the Data Warehouse 72 3 Project/Program Planning 75 Professional Responsibilities 75 3.1 Professional Boundaries 75 3.2 An Engineer’s View 78 3.3 Beware the Objection Removers 82 3.4 What Does the Central Team Do? 86 3.5 Avoid Isolating DW and BI Teams 90 3.6 Better Business Skills for BI and Data Warehouse Professionals 91 3.7 Risky Project Resources are Risky Business 93 3.8 Implementation Analysis Paralysis 95 3.9 Contain DW/BI Scope Creep and Avoid Scope Theft 96 3.10 Are IT Procedures Beneficial to DW/BI Projects? 98 Justification and Sponsorship 100 3.11 Habits of Effective Sponsors 100 3.12 TCO Starts with the End User 103 Kimball Methodology 108 3.13 Kimball Lifecycle in a Nutshell 108 3.14 Off the Bench111 3.15 The Anti-Architect112 3.16 Think Critically When Applying Best Practices 115 3.17 Eight Guidelines for Low Risk Enterprise Data Warehousing 118 4 Requirements Definition 123 Gathering Requirements 123 4.1 Alan Alda’s Interviewing Tips for Uncovering Business Requirements 123 4.2 More Business Requirements Gathering Dos and Don’ts 127 4.3 Balancing Requirements and Realities 129 4.4 Overcoming Obstacles When Gathering Business Requirements 130 4.5 Surprising Value of Data Profiling 133 Organizing around Business Processes 134 4.6 Focus on Business Processes, Not Business Departments! 134 4.7 Identifying Business Processes 135 4.8 Business Process Decoder Ring 137 4.9 Relationship between Strategic Business Initiatives and Business Processes 138 Wrapping Up the Requirements 139 4.10 The Bottom-Up Misnomer 140 4.11 Think Dimensionally (Beyond Data Modeling) 144 4.12 Using the Dimensional Model to Validate Business Requirements 145 5 Data Architecture 147 Making the Case for Dimensional Modeling 147 5.1 Is ER Modeling Hazardous to DSS? 147 5.2 A Dimensional Modeling Manifesto 151 5.3 There are No Guarantees 159 Enterprise Data Warehouse Bus Architecture 163 5.4 Divide and Conquer 163 5.5 The Matrix 166 5.6 The Matrix: Revisited 170 5.7 Drill Down into a Detailed Bus Matrix 174 Agile Project Considerations 176 5.8 Relating to Agile Methodologies 176 5.9 Is Agile Enterprise Data Warehousing an Oxymoron? 177 5.10 Going Agile? Start with the Bus Matrix 179 5.11 Conformed Dimensions as the Foundation for Agile Data Warehousing 180 Integration Instead of Centralization 181 5.12 Integration for Real People 181 5.13 Build a Ready-to-Go Resource for Enterprise Dimensions 185 5.14 Data Stewardship 101: The First Step to Quality and Consistency 186 5.15 To Be or Not To Be Centralized 189 Contrast with the Corporate Information Factory 192 5.16 Differences of Opinion 193 5.17 Much Ado about Nothing 198 5.18 Don’t Support Business Intelligence with a Normalized EDW 199 5.19 Complementing 3NF EDWs with Dimensional Presentation Areas 201 6 Dimensional Modeling Fundamentals 203 Basics of Dimensional Modeling 203 6.1 Fact Tables and Dimension Tables 203 6.2 Drilling Down, Up, and Across 207 6.3 The Soul of the Data Warehouse, Part One: Drilling Down 210 6.4 The Soul of the Data Warehouse, Part Two: Drilling Across 213 6.5 The Soul of the Data Warehouse, Part Three: Handling Time 216 6.6 Graceful Modifications to Existing Fact and Dimension Tables 219 Dos and Don’ts 220 6.7 Kimball’s Ten Essential Rules of Dimensional Modeling 221 6.8 What Not to Do 223 Myths about Dimensional Modeling 226 6.9 Dangerous Preconceptions 226 6.10 Fables and Facts 228 7 Dimensional Modeling Tasks and Responsibilities 233 Design Activities 233 7.1 Letting the Users Sleep 233 7.2 Practical Steps for Designing a Dimensional Model 240 7.3 Staffing the Dimensional Modeling Team 243 7.4 Involve Business Representatives in Dimensional Modeling 244 7.5 Managing Large Dimensional Design Teams 246 7.6 Use a Design Charter to Keep Dimensional Modeling Activities on Track 248 7.7 The Naming Game 249 7.8 What’s in a Name? 250 7.9 When is the Dimensional Design Done? 253 Design Review Activities 254 7.10 Design Review Dos and Don’ts 255 7.11 Fistful of Flaws 257 7.12 Rating Your Dimensional Data Warehouse 260 8 Fact Table Core Concepts 267 Granularity 267 8.1 Declaring the Grain 267 8.2 Keep to the Grain in Dimensional Modeling 270 8.3 Warning: Summary Data May Be Hazardous to Your Health 272 8.4 No Detail Too Small 273 Types of Fact Tables 276 8.5 Fundamental Grains 277 8.6 Modeling a Pipeline with an Accumulating Snapshot 280 8.7 Combining Periodic and Accumulating Snapshots 282 8.8 Complementary Fact Table Types 284 8.9 Modeling Time Spans 286 8.10 A Rolling Prediction of the Future, Now and in the Past 289 8.11 Timespan Accumulating Snapshot Fact Tables 293 8.12 Is it a Dimension, a Fact, or Both? 294 8.13 Factless Fact Tables 295 8.14 Factless Fact Tables? Sounds Like Jumbo Shrimp? 298 8.15 What Didn’t Happen 299 8.16 Factless Fact Tables for Simplification 302 Parent-Child Fact Tables 304 8.17 Managing Your Parents 304 8.18 Patterns to Avoid When Modeling Header/Line Item Transactions 307 Fact Table Keys and Degenerate Dimensions 309 8.19 Fact Table Surrogate Keys 309 8.20 Reader Suggestions on Fact Table Surrogate Keys 310 8.21 Another Look at Degenerate Dimensions 312 8.22 Creating a Reference Dimension for Infrequently Accessed Degenerates 313 Miscellaneous Fact Table Design Patterns 314 8.23 Put Your Fact Tables on a Diet 314 8.24 Keeping Text Out of the Fact Table 316 8.25 Dealing with Nulls in a Dimensional Model 317 8.26 Modeling Data as Both a Fact and Dimension Attribute 318 8.27 When a Fact Table Can Be Used as a Dimension Table 319 8.28 Sparse Facts and Facts with Short Lifetimes 321 8.29 Pivoting the Fact Table with a Fact Dimension 323 8.30 Accumulating Snapshots for Complex Workflows 324 9 Dimension Table Core Concepts 327 Dimension Table Keys 327 9.1 Surrogate Keys 327 9.2 Keep Your Keys Simple 331 9.3 Durable “Super-Natural” Keys 333 Date and Time Dimension Considerations 334 9.4 It’s Time for Time 335 9.5 Surrogate Keys for the Time Dimension 337 9.6 Latest Thinking on Time Dimension Tables 339 9.7 Smart Date Keys to Partition Fact Tables 341 9.8 Updating the Date Dimension 342 9.9 Handling All the Dates 343 Miscellaneous Dimension Patterns 345 9.10 Selecting Default Values for Nulls 345 9.11 Data Warehouse Role Models 347 9.12 Mystery Dimensions 350 9.13 De-Clutter with Junk Dimensions 353 9.14 Showing the Correlation between Dimensions 354 9.15 Causal (Not Casual) Dimensions 356 9.16 Resist Abstract Generic Dimensions 359 9.17 Hot-Swappable Dimensions 360 9.18 Accurate Counting with a Dimensional Supplement 361 Slowly Changing Dimensions 363 9.19 Perfectly Partitioning History with Type 2 SCD 363 9.20 Many Alternate Realities 364 9.21 Monster Dimensions 367 9.22 When a Slowly Changing Dimension Speeds Up 370 9.23 When Do Dimensions Become Dangerous? 372 9.24 Slowly Changing Dimensions are Not Always as Easy as 1, 2, and 3 373 9.25 Slowly Changing Dimension Types 0, 4, 5, 6 and 7 378 9.26 Dimension Row Change Reason Attributes 382 10 More Dimension Patterns and Considerations 385 Snowflakes, Outriggers, and Bridges 385 10.1 Snowflakes, Outriggers, and Bridges 385 10.2 A Trio of Interesting Snowflakes 388 10.3 Help for Dimensional Modeling 392 10.4 Managing Bridge Tables 395 10.5 The Keyword Dimension 399 10.6 Potential Bridge (Table) Detours 403 10.7 Alternatives for Multi-Valued Dimensions 405 10.8 Adding a Mini-Dimension to a Bridge Table 407 Dealing with Hierarchies 409 10.9 Maintaining Dimension Hierarchies 409 10.10 Help for Hierarchies 414 10.11 Five Alternatives for Better Employee Dimensional Modeling 417 10.12 Avoiding Alternate Organization Hierarchies 425 10.13 Alternate Hierarchies 426 Customer Issues 427 10.14 Dimension Embellishments 427 10.15 Wrangling Behavior Tags 429 10.16 Three Ways to Capture Customer Satisfaction 431 10.17 Extreme Status Tracking for Real-Time Customer Analysis 435 Addresses and International Issues 439 10.18 Think Globally, Act Locally 439 10.19 Warehousing without Borders 443 10.20 Spatially Enabling Your Data Warehouse 448 10.21 Multinational Dimensional Data Warehouse Considerations 452 Industry Scenarios and Idiosyncrasies 453 10.22 Industry Standard Data Models Fall Short 453 10.23 An Insurance Data Warehouse Case Study 455 10.24 Traveling through Databases 460 10.25 Human Resources Dimensional Models 463 10.26 Managing Backlogs Dimensionally 467 10.27 Not So Fast 468 10.28 The Budgeting Chain 471 10.29 Compliance-Enabled Data Warehouses 475 10.30 Clicking with Your Customer 477 10.31 The Special Dimensions of the Clickstream 482 10.32 Fact Tables for Text Document Searching 485 10.33 Enabling Market Basket Analysis 489 11 Back Room ETL and Data Quality 495 Planning the ETL System 495 11.1 Surrounding the ETL Requirements 495 11.2 The 34 Subsystems of ETL 500 11.3 Six Key Decisions for ETL Architectures 504 11.4 Three ETL Compromises to Avoid 508 11.5 Doing the Work at Extract Time 510 11.6 Is Data Staging Relational? 513 11.7 Staging Areas and ETL Tools 517 11.8 Should You Use an ETL Tool? 518 11.9 Call to Action for ETL Tool Providers 521 11.10 Document the ETL System 522 11.11 Measure Twice, Cut Once 523 11.12 Brace for Incoming 527 11.13 Building a Change Data Capture System 530 11.14 Disruptive ETL Changes 531 11.15 New Directions for ETL 533 Data Quality Considerations 535 11.16 Dealing With Data Quality: Don’t Just Sit There, Do Something! 535 11.17 Data Warehouse Testing Recommendations 537 11.18 Dealing with Dirty Data 539 11.19 An Architecture for Data Quality 545 11.20 Indicators of Quality: The Audit Dimension 553 11.21 Adding an Audit Dimension to Track Lineage and Confi dence 556 11.22 Add Uncertainty to Your Fact Table 559 11.23 Have You Built Your Audit Dimension Yet? 560 11.24 Is Your Data Correct? 562 11.25 Eight Recommendations for International Data Quality 565 11.26 Using Regular Expressions for Data Cleaning 568 Populating Fact and Dimension Tables 572 11.27 Pipelining Your Surrogates 572 11.28 Unclogging the Fact Table Surrogate Key Pipeline 576 11.29 Replicating Dimensions Correctly 579 11.30 Identify Dimension Changes Using Cyclic Redundancy Checksums 580 11.31 Maintaining Back Pointers to Operational Sources 581 11.32 Creating Historical Dimension Rows 582 11.33 Facing the Re-Keying Crisis 585 11.34 Backward in Time 587 11.35 Early-Arriving Facts 590 11.36 Slowly Changing Entities 591 11.37 Using the SQL MERGE Statement for Slowly Changing Dimensions 593 11.38 Creating and Managing Shrunken Dimensions 595 11.39 Creating and Managing Mini-Dimensions 597 11.40 Creating, Using, and Maintaining Junk Dimensions 599 11.41 Building Bridges 601 11.42 Being Offl ine as Little as Possible 605 Supporting Real Time 606 11.43 Working in Web Time 606 11.44 Real-Time Partitions 610 11.45 The Real-Time Triage 613 12 Technical Architecture Considerations 617 Overall Technical/System Architecture 617 12.1 Can the Data Warehouse Benefi t from SOA? 617 12.2 Picking the Right Approach to MDM 619 12.3 Building Custom Tools for the DW/BI System 625 12.4 Welcoming the Packaged App 626 12.5 ERP Vendors: Bring Down Those Walls 629 12.6 Building a Foundation for Smart Applications 632 12.7 RFID Tags and Smart Dust 637 12.8 Is Big Data Compatible with the Data Warehouse? 640 12.9 The Evolving Role of the Enterprise Data Warehouse in the Era of Big Data Analytics 641 12.10 Newly Emerging Best Practices for Big Data 659 12.11 The Hyper-Granular Active Archive 670 Presentation Server Architecture 672 12.12 Columnar Databases: Game Changers for DW/BI Deployment 672 12.13 There is no Database Magic 673 12.14 Relating to OLAP 676 12.15 Dimensional Relational versus OLAP: The Final Deployment Conundrum 679 12.16 Microsoft SQL Server Comes of Age for Data Warehousing 682 12.17 The Aggregate Navigator 686 12.18 Aggregate Navigation with (Almost) No Metadata 690 Front Room Architecture 697 12.19 The Second Revolution of User Interfaces 697 12.20 Designing the User Interface 700 Metadata 704 12.21 Meta Meta Data Data 704 12.22 Creating the Metadata Strategy 708 12.23 Leverage Process Metadata for Self-Monitoring DW Operations 709 Infrastructure and Security Considerations 712 12.24 Watching the Watchers 712 12.25 Catastrophic Failure 716 12.26 Digital Preservation 719 12.27 Creating the Advantages of a 64-Bit Server 722 12.28 Server Configuration Considerations 723 12.29 Adjust Your Thinking for SANs 726 13 Front Room Business Intelligence Applications 729 Delivering Value with Business Intelligence 729 13.1 The Promise of Decision Support 730 13.2 Beyond Paving the Cow Paths 733 13.3 BI Components for Business Value 736 13.4 Big Shifts Happening in BI 738 13.5 Behavior: The Next Marquee Application 740 Implementing the Business Intelligence Layer 743 13.6 Three Critical Components for Successful Self-Service BI 743 13.7 Leverage Data Visualization Tools, But Avoid Anarchy 745 13.8 Think Like a Software Development Manager 747 13.9 Standard Reports: Basics for Business Users 748 13.10 Building and Delivering BI Reports 753 13.11 The BI Portal 757 13.12 Dashboards Done Right 759 13.13 Don’t Be Overly Reliant on Your Data Access Tool’s Metadata 760 13.14 Making Sense of the Semantic Layer 762 Mining Data to Uncover Relationships 764 13.15 Digging into Data Mining 764 13.16 Preparing for Data Mining 766 13.17 The Perfect Handoff 770 13.18 Get Started with Data Mining Now 774 13.19 Leverage Your Dimensional Model for Predictive Analytics 778 13.20 Does Your Organization Need an Analytic Sandbox? 779 Dealing with SQL 781 13.21 Simple Drill Across in SQL 781 13.22 An Excel Macro for Drilling Across 783 13.23 The Problem with Comparisons 785 13.24 SQL Roadblocks and Pitfalls 789 13.25 Features for Query Tools 792 13.26 Turbocharge Your Query Tools 794 13.27 Smarter Data Warehouses 798 14 Maintenance and Growth Considerations 805 Deploying Successfully 805 14.1 Don’t Forget the Owner’s Manual 805 14.2 Let’s Improve Our Operating Procedures 809 14.3 Marketing the DW/BI System 811 14.4 Coping with Growing Pains 812 Sustaining for Ongoing Impact 816 14.5 Data Warehouse Checkups 816 14.6 Boosting Business Acceptance 822 14.7 Educate Management to Sustain DW/BI Success 825 14.8 Getting Your Data Warehouse Back on Track 828 14.9 Upgrading Your BI Architecture 829 14.10 Four Fixes for Legacy Data Warehouses 831 14.11 A Data Warehousing Fitness Program for Lean Times 835 14.12 Enjoy the Sunset 839 15 Final Thoughts 841 Key Insights and Reminders 841 15.1 Final Word of the Day: Collaboration 841 15.2 Tried and True Concepts for DW/BI Success 843 15.3 Key Tenets of the Kimball Method 845 A Look to the Future 847 15.4 The Future is Bright 847 Article Index 853 Index 861

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 byTable of Contents Introduction 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 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) outTable 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 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 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 Contents Introduction 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 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 SynopsisAbout our authors Ramesh Sharda (MBA, PhD, University of WisconsinMadison) is the Vice Dean for Research and Graduate Programs, Watson/ConocoPhillips Chair, and a Regents Professor of Management Science and Information Systems in the Spears School of Business at Oklahoma State University (OSU). He cofounded and directed OSU's PhD in Business for the Executives Program. About 200 papers describing his research have been published in major journals, including Operations Research, Management Science, Information Systems Research, Decision Support Systems, and the Journal of MIS. He cofounded the AIS SIG on Decision Support Systems and Knowledge Management (SIGDSA). Dr. Sharda serves on several editorial boards, including those of Decision Support Systems and ACM Data Base. He has authored and edited several textbooks and research books and serves as the coeditor of several Springer book series (Integrated S

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 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 Contents Setting 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