Software
Microsoft Project For Dummies
BLOW PAST THE JARGON AND GET HANDS-ON, PRACTICAL GUIDANCE ON MANAGING ANY PROJECT WITH MICROSOFT PROJECTLean. Agile. Hybrid. It seems that project management these days comes with more confusing buzzwords than ever. But you can make managing your next project simple and straightforward with help from Microsoft Project For Dummies.This book unpacks Microsoft’s bestselling project management platform and walks you through every important feature, step-by-step, until you’re ready to take on virtually any project, no matter the size. From getting set up for the first time to creating tasks, managing resources and working with time management features, you’ll learn everything you need to know about managing a project in Microsoft’s iconic software.You’ll also find:* Totally updated guidance that applies to both the desktop version and Microsoft’s new subscription-based Microsoft Project Online * Helpful information on integrating Agile practices and techniques into your project * “Golden rules” that keep a project on-track and on-time * Ways to effectively manage your resources with Microsoft Project’s built-in functionality Managing a project, big or small, is no easy task. Luckily, Microsoft Project For Dummies can take a lot of the hassle out of your day-to-day life. Learn how to take advantage of this powerful software today!CYNTHIA SNYDER DIONISIO is a project anagement consultant with a passion for curriculum design and online training. Author of Microsoft Project 2019 For Dummies, she’s helped thousands of employees find success in their project management careers.INTRODUCTION 1About This Book 1What’s Not in This Book 2Foolish Assumptions 2Icons Used in This Book 3Beyond the Book 3Where to Go from Here 4PART 1: GETTING STARTED WITH PROJECT 5CHAPTER 1: PROJECT MANAGEMENT, MS PROJECT, AND YOU 7Project Management Evolution 8What’s in a Name: Projects, Project Management, and Project Managers 9Project managers and Scrum masters 10The role of the project manager 11The role of the Scrum master 12Introducing Microsoft Project 13Getting to Know You 14Navigating Ribbon tabs and the Ribbon 17Displaying more tools 20Tell Me What You Want to Do 22CHAPTER 2: STARTING THE PROJECT 23Creating the Project Charter 24Introducing the Work Breakdown Structure (WBS) 26Organizing the Work 27Starting the Project 28Entering project information 29Entering the WBS 31Indenting and outdenting (a.k.a promoting and demoting) 32Entering tasks 33Weighing manual scheduling versus automatic scheduling 35Inserting one project into another 37Inserting hyperlinks 38CHAPTER 3: BECOMING A TASK MASTER41Creating Summary Tasks and Subtasks 41How many levels can you go? 43The project summary task 43Moving Tasks Up, Down, and All Around 45Moving tasks with the drag-and-drop method 45Moving tasks with the cut-and-paste method 46Now You See It, Now You Don’t: Collapsing and Expanding the Task Outline 47Showing Up Again and Again: Recurring Tasks 48Setting Milestones 50Deleting Tasks and Using Inactive Tasks 51Making a Task Note 52CHAPTER 4: THE CODEPENDENT NATURE OF TASKS55How Tasks Become Dependent 56Dependent tasks: Which comes first? 56Dependency types 57Allowing for Murphy’s Law: Lag and lead time 59Setting the Dependency Connection 60Adding the dependency link 60Words to the wise 62Understanding that things change: Deleting dependencies 64CHAPTER 5: ESTIMATING TASK TIME67You’re in It for the Duration 68Tasks come in all flavors: Identifying task types 68Effort-driven tasks: 1 + 1 = ½ 71Estimating Effort and Duration 72Estimating techniques 72Setting the task duration 74Controlling Timing with Constraints 76Understanding how constraints work 76Establishing constraints 76Setting a deadline 78Starting and Pausing Tasks 79Entering the task’s start date 80Taking a break: Splitting tasks 81CHAPTER 6: CHECK OUT THIS VIEW!83A Project with a View 83Navigating tabs and views 84Scrolling around 86Reaching a specific spot in your plan 87More Detail about Views 88Home base: Gantt Chart view 88Resourceful views: Resource Sheet and Team Planner 89Getting your timing down with the Timeline 90Going with the flow: Network Diagram view 91Calling up Calendar view 91Customizing Views 92Working with view panes 93Modifying Network Diagram view 98Resetting the view 100PART 2: MANAGING RESOURCES 103CHAPTER 7: CREATING RESOURCES 105Resources: People, Places, and Things 105Becoming Resource-Full 106Understanding resources 106Resource types: Work, material, and cost 107How resources affect task timing 108Estimating resource requirements 109The Birth of a Resource 110Creating one resource at a time 110Identifying resources before you know their names 112Many hands make light work 113Managing Resource Availability 113Estimating and setting availability 114When a resource comes and goes 115Sharing Resources 116Skimming from resource pools 116Importing resources from Outlook 119CHAPTER 8: WORKING WITH CALENDARS121Mastering Base, Project, Resource, and Task Calendars 122Setting the base calendar for a project 122Understanding the four calendar types 122How calendars work 123How one calendar relates to another 123Scheduling with Calendar Options and Working Times 124Setting calendar options 125Setting exceptions to working times 126Working with Task Calendars and Resource Calendars 128Setting resource calendars 129Making a change to a resource’s calendar 130Creating a Custom Calendar Template 132Sharing Copies of Calendars 134CHAPTER 9: ASSIGNING RESOURCES 137Finding the Right Resource 137Needed: One good resource willing to work 138Custom fields: It’s a skill 139Making a Useful Assignation 140Determining material and cost-resource units 140Making assignments 141Shaping the contour that’s right for you 145Benefitting from a Helpful Planner 147CHAPTER 10: DETERMINING A PROJECT’S COST149How Do Costs Accrue? 150Adding up the costs 150When will these costs hit the bottom line? 151Specifying Cost Information in the Project 152You can’t avoid fixed costs 153Entering hourly, overtime, and cost-per-use rates 154Assigning material resources 156PART 3: BEFORE YOU BASELINE 159CHAPTER 11: FINE-TUNING YOUR PLAN 161Everything Filters to the Bottom Line 161Setting predesigned filters 162Putting AutoFilter to work 163Creating do-it-yourself filters 166Gathering Information in Groups 167Applying predefined groups 169Devising your own groups 169Figuring Out What’s Driving the Project 171Inspecting tasks 172Handling task warnings, suggestions, and problems 173CHAPTER 12: NEGOTIATING PROJECT CONSTRAINTS175It’s about Time 176Applying contingency reserve 176Completing a task in less time 177Getting What You Want for Less 180The Resource Recourse 181Checking resource availability 181Deleting or modifying a resource assignment 183Beating overallocations with quick-and-dirty rescheduling 184Finding help 184Leveling resources 185Rescheduling the Project 188CHAPTER 13: MAKING THE PROJECT LOOK GOOD189Looking Good! 190Formatting the Gantt Chart 190Formatting taskbars 190Zeroing in on critical issues 194Restyling the Gantt chart 194Formatting Network Diagram Boxes 195Adjusting the Layout 197Modifying Gridlines 199Recognizing When a Picture Can Say It All 201Creating a Custom Text Field 202CHAPTER 14: IT ALL BEGINS WITH A BASELINE 207All about Baselines 208Saving a baseline 208Saving more than one baseline 210Clearing and resetting a baseline 211In the Interim 212Saving an interim plan 213Clearing and resetting an interim plan 214PART 4: STAYING ON TRACK 217CHAPTER 15: ON THE RIGHT TRACK 219Tracking Views 220Setting the status date 220Tracking status with the Task sheet 221Using the Tracking table 221Tracking buttons 222Determining the percent complete 223Tracking status with Task Usage view 224Tracking status with Resource Usage view 224Uh-oh — you’re in overtime 225Specifying remaining durations for auto-scheduled tasks 226Entering fixed-cost updates 227Moving a Task 228Update Project: Sweeping Changes 230Tracking Materials 232Tracking More than One Project 233CHAPTER 16: PROJECT VIEWS: OBSERVING PROGRESS235Seeing Where Tasks Stand 236Baseline versus actual progress 236Lines of progress 236Delving into the Detail 240Tracking Progress Using Earned Value Management 242Viewing the Earned Value table 244Earned value options 244Calculating behind the Scenes 246An abundance of critical paths 246CHAPTER 17: YOU’RE BEHIND — NOW WHAT?249Using Project with Risk and Issue Logs 249Documenting issues 250Printing interim plans and baselines 250What-If Scenarios 251Sorting tasks 252Filtering 253Examining the critical path 254Using resource leveling (again) 255Determining which factors are driving the timing of a task 256How Adding People or Time Affects the Project 257Hurrying up and making modifications 257Throwing resources at the problem 258Shifting dependencies and task timing 259When All Else Fails 261Taking the time you need 261Finding ways to cut corners 262CHAPTER 18: SPREADING THE NEWS: REPORTING 265Generating Standard Reports 266What’s available on the Report tab 266Dashboard reports 267Creating New Reports 268Gaining a new perspective on data with visual reports 270Creating a visual report 270Fine-Tuning a Report 271Dragging, dropping, and sizing 272Looking good! 273Spiffing Things Up 274Calling the Printer! 276Working with Page Setup 277Getting a preview 279Finalizing your print options 280Working on the Timeline 281Adding tasks to the Timeline 281Customizing the Timeline 283Copying the Timeline 283PART 5: WORKING WITH SPRINTS PROJECTS 285CHAPTER 19: SETTING UP A SPRINTS PROJECT 287Creating a Sprints Project 287Enjoying a Whole New View 290The Task Board and Task Board sheet 291The Sprint Planning Board and Sprint Planning sheet 292The Current Sprint Board and Current Sprint sheet 293The Backlog Board and the Backlog sheet 293Adding Information to Tasks 294Prioritizing Tasks 296Inserting a Sprints Project into a Plan-Driven Project 296CHAPTER 20: TRACKING A SPRINTS PROJECT 299Viewing Your Sprints Project Data 299Using filters to focus 300Using tables to arrange data 300Being a groupie 302Sorting tasks 302Creating Sprints Reports 303CHAPTER 21: GETTING BETTER ALL THE TIME 307Reviewing the Project 308Learning from your mistakes 308Fine-tuning communication 309Comparing Versions of a Project 310Building on Success 312Creating a template 312Mastering the Organizer 314PART 6: THE PART OF TENS 317CHAPTER 22: TEN GOLDEN RULES OF PROJECT MANAGEMENT 319Roll with It 319Put Your Ducks in a Row 320Expect the Unexpected 321Don’t Put Off until Tomorrow 322Delegate, Delegate, Delegate 322Document It 323Keep the Team in the Loop 323Measure Success 324Maintain a Flexible Strategy 325Learn from Your Mistakes 325CHAPTER 23: TEN COOL SHORTCUTS IN PROJECT 327Task Information 327Resource Information 328Frequently Used Functions 329Subtasks 330Quick Selections 330Fill Down 331Navigation 331Hours to Years 331Timeline Shortcuts 331Quick Undo 332Glossary 333Index 341
Numerical Methods Using Java
Implement numerical algorithms in Java using NM Dev, an object-oriented and high-performance programming library for mathematics.You’ll see how it can help you easily create a solution for your complex engineering problem by quickly putting together classes.Numerical Methods Using Java covers a wide range of topics, including chapters on linear algebra, root finding, curve fitting, differentiation and integration, solving differential equations, random numbers and simulation, a whole suite of unconstrained and constrained optimization algorithms, statistics, regression and time series analysis. The mathematical concepts behind the algorithms are clearly explained, with plenty of code examples and illustrations to help even beginners get started.WHAT YOU WILL LEARN* Program in Java using a high-performance numerical library* Learn the mathematics for a wide range of numerical computing algorithms* Convert ideas and equations into code* Put together algorithms and classes to build your own engineering solution* Build solvers for industrial optimization problems* Do data analysis using basic and advanced statisticsWHO THIS BOOK IS FORProgrammers, data scientists, and analysts with prior experience with programming in any language, especially Java.HAKSUN LI, PHD, is founder of NM Group, a scientific and mathematical research company. He has the vision of “Making the World Better Using Mathematics”. Under his leadership, the firm serves worldwide brokerage houses and funds, multinational corporations and very high net worth individuals. Haksun is an expert in options trading, asset allocation, portfolio optimization and fixed-income product pricing. He has coded up a variety of numerical software, including SuanShu (a library of numerical methods), NM Dev (a library of numerical methods), AlgoQuant (a library for financial analytics), NMRMS (a portfolio management system for equities), and supercurve (a fixed-income options pricing system). Prior to this, Haksun was a quantitative trader/quantitative analyst with multiple investment banks. He has worked in New York, London, Tokyo, and Singapore.Additionally, Haksun is the vice dean of the Big Data Finance and Investment Institute of Fudan University, China. He was an adjunct professor with multiple universities. He has taught at the National University of Singapore (mathematics), Nanyang Technological University (business school), Fudan University (economics), as well as Hong Kong University of Science and Technology (mathematics). Dr. Haksun Li has a B.S. and M.S. in pure and financial mathematics from the University of Chicago, and an M.S. and a PhD in computer science and engineering from the University of Michigan, Ann Arbor.Table of ContentsAbout the Authors...........................................................................................................iPreface............................................................................................................................ii1. Why Java?..............................................................................................................61.1. Java in 2020.....................................................................................................61.2. Java vs. C++....................................................................................................61.3. Java vs. Python................................................................................................61.4. Java in the future .............................................................................................62. Data Structures.......................................................................................................72.1. Function...........................................................................................................72.2. Polynomial ......................................................................................................73. Linear Algebra .......................................................................................................83.1. Vector and Matrix ...........................................................................................83.1.1. Vector Properties .....................................................................................83.1.2. Element-wise Operations.........................................................................83.1.3. Norm ........................................................................................................93.1.4. Inner product and angle ...........................................................................93.2. Matrix............................................................................................................103.3. Determinant, Transpose and Inverse.............................................................103.4. Diagonal Matrices and Diagonal of a Matrix................................................103.5. Eigenvalues and Eigenvectors.......................................................................103.5.1. Householder Tridiagonalization and QR Factorization Methods..........103.5.2. Transformation to Hessenberg Form (Nonsymmetric Matrices)...........104. Finding Roots of Single Variable Equations .......................................................114.1. Bracketing Methods ......................................................................................114.1.1. Bisection Method ...................................................................................114.2. Open Methods...............................................................................................114.2.1. Fixed-Point Method ...............................................................................114.2.2. Newton’s Method (Newton-Raphson Method) .....................................114.2.3. Secant Method .......................................................................................114.2.4. Brent’s Method ......................................................................................115. Finding Roots of Systems of Equations...............................................................125.1. Linear Systems of Equations.........................................................................125.2. Gauss Elimination Method............................................................................125.3. LU Factorization Methods ............................................................................125.3.1. Cholesky Factorization ..........................................................................125.4. Iterative Solution of Linear Systems.............................................................125.5. System of Nonlinear Equations.....................................................................126. Curve Fitting and Interpolation............................................................................146.1. Least-Squares Regression .............................................................................146.2. Linear Regression..........................................................................................146.3. Polynomial Regression..................................................................................146.4. Polynomial Interpolation...............................................................................146.5. Spline Interpolation .......................................................................................147. Numerical Differentiation and Integration...........................................................157.1. Numerical Differentiation .............................................................................157.2. Finite-Difference Formulas...........................................................................157.3. Newton-Cotes Formulas................................................................................157.3.1. Rectangular Rule....................................................................................157.3.2. Trapezoidal Rule....................................................................................157.3.3. Simpson’s Rules.....................................................................................157.3.4. Higher-Order Newton-Coles Formulas..................................................157.4. Romberg Integration .....................................................................................157.4.1. Gaussian Quadrature..............................................................................157.4.2. Improper Integrals..................................................................................158. Numerical Solution of Initial-Value Problems....................................................168.1. One-Step Methods.........................................................................................168.2. Euler’s Method..............................................................................................168.3. Runge-Kutta Methods...................................................................................168.4. Systems of Ordinary Differential Equations.................................................169. Numerical Solution of Partial Differential Equations..........................................179.1. Elliptic Partial Differential Equations...........................................................179.1.1. Dirichlet Problem...................................................................................179.2. Parabolic Partial Differential Equations........................................................179.2.1. Finite-Difference Method ......................................................................179.2.2. Crank-Nicolson Method.........................................................................179.3. Hyperbolic Partial Differential Equations.....................................................1710..................................................................................................................................1811..................................................................................................................................1912. Random Numbers and Simulation ....................................................................2012.1. Uniform Distribution .................................................................................2012.2. Normal Distribution...................................................................................2012.3. Exponential Distribution............................................................................2012.4. Poisson Distribution ..................................................................................2012.5. Beta Distribution........................................................................................2012.6. Gamma Distribution ..................................................................................2012.7. Multi-dimension Distribution ....................................................................2013. Unconstrainted Optimization ............................................................................2113.1. Single Variable Optimization ....................................................................2113.2. Multi Variable Optimization .....................................................................2114. Constrained Optimization .................................................................................2214.1. Linear Programming..................................................................................2214.2. Quadratic Programming ............................................................................2214.3. Second Order Conic Programming............................................................2214.4. Sequential Quadratic Programming...........................................................2214.5. Integer Programming.................................................................................2215. Heuristic Optimization......................................................................................2315.1. Genetic Algorithm .....................................................................................2315.2. Simulated Annealing .................................................................................2316. Basic Statistics..................................................................................................2416.1. Mean, Variance and Covariance................................................................2416.2. Moment......................................................................................................2416.3. Rank...........................................................................................................2417. Linear Regression .............................................................................................2517.1. Least-Squares Regression..........................................................................2517.2. General Linear Least Squares....................................................................2518. Time Series Analysis ........................................................................................2618.1. Univariate Time Series..............................................................................2618.2. Multivariate Time Series ...........................................................................2618.3. ARMA .......................................................................................................2618.4. GARCH .....................................................................................................2618.5. Cointegration .............................................................................................2619. Bibliography .....................................................................................................2720. Index .....................................................................................................
Pro Jakarta Persistence in Jakarta EE 10
Learn to use the Jakarta Persistence API and other related APIs as found in the Jakarta EE 10 platform from the perspective of one of the specification creators. A one-of-a-kind resource, this in-depth book provides both theoretical and practical coverage of Jakarta Persistence usage for experienced Java developers.Authors Lukas Jungmann, Mike Keith, Merrick Schincariol, Massimo Nardone take a hands-on approach, based on their wealth of experience and expertise, by giving examples to illustrate each concept of the API and showing how it is used in practice. The examples use a common model from an overarching sample application, giving you a context from which to start and helping you to understand the examples within an already familiar domain.After completing this in-depth book, you will have a full understanding of persistence and be able to successfully code applications using its annotations and APIs. The book also serves as an excellent reference guide.WHAT YOU WILL LEARN* Use Jakarta Persistence in the context of enterprise applications* Work with object relational mappings (ORMs), collection mappings and more* Build complex enterprise Java applications that persist data long after the process terminates* Connect to and persist data with a variety of databases, file formats, and more* Use queries, including the Jakarta Persistence Query Language (Jakarta Persistence QL)* Carry out advanced ORM, queries and XML mappings* Package, deploy and test your Jakarta persistence-enabled enterprise applicationsWHO THIS BOOK IS FORExperienced Java programmers and developers with at least some prior experience with Jakarta EE or Java EE platform APIs.LUKAS JUNGMANN is the specification project co-lead for Jakarta Persistence, and the lead for a number of other Jakarta Specification projects including Jakarta Activation, Mail, XML Binding, SOAP with Attachments, and XML Web Services. He is a contributor to Jakarta Platform, JSON Processing, JSON Binding specification projects and is lead for a number of implementation projects of various Jakarta specifications including EclipseLink, Eclipse Metro and Eclipse Angus. He holds a Bachelor’s degree in Applied Informatics from University of Finance and Administration in Prague, Czech Republic, and has over 15 years’ experience working with Enterprise Java related technologies. He has spoken at numerous conferences around the world. He is employed as a software developer at Oracle in Prague, Czech Republic, and is married with three kids and one cat.MIKE KEITH is a co-specification lead for JPA 1.0 and a member of the JPA 2.0 and JPA 2.1 expert groups. He sits on a number of other Java Community Process expert groups and the Enterprise Expert Group (EEG) in the OSGi Alliance. He holds a Masters degree in Computer Science from Carleton University, and has over 20 years experience in persistence and distributed systems research and practice.He has written papers and articles on JPA and spoken at numerous conferences around the world. He is employed as an architect at Oracle in Ottawa, Canada,and is married with four kids and two dogs.MERRICK SCHINCARIOL is a senior engineer for the Oracle OC4J Java EE Container. He was a lead engineer for Oracle's EJB 3.0 release and co-author of Pro EJB 3: Java Persistence API. Before joining Oracle, Merrick developed enterprise and large-scale systems for the telecommunications industry.MASSIMO NARDONE has more than 23 years of experiences in Security, Web/Mobile development, Cloud and IT Architecture and has been programming and teaching how to program with Android, Perl, PHP, Java, VB, Python, C/C++ and MySQL for more than 20 years. He currently works as Chief Information Security Office (CISO) for Cargotec Oyj and he is member of the ISACA Finland Chapter Board. Massimo has provided technical review for more than 40 IT books, and is the coauthor of Pro Android Games (Apress, 2015).* Introduction * Getting Started * Enterprise Applications * Object Relational Mapping * Collection Mapping * Entity Manager * Using Queries * Java Persistence Query Language * Criteria * Advanced Object Relational Mapping * Advanced Queries * Advanced Topics * XML Mapping Files * Packaging and Deployment * Testing
Ada und Zangemann
Ein Märchen über Software, Skateboards und Himbeereis. Ein Buch über den selbstbestimmten Umgang mit Technik.In einer riesigen Villa hoch oben über der Stadt lebt der berühmte Erfinder Zangemann. Erwachsene wie Kinder lieben seine Erfindungen und wollen sie unbedingt haben. Doch dann geschieht etwas: Zangemann kommt in die Stadt, um seine Erfindungen wieder einmal aus der Nähe zu betrachten und – RUMMS! – ein Kind fährt ihm mit seinem Skateboard gegen das Schienbein. Wutentbrannt trifft der Erfinder eine Entscheidung und dann passieren merkwürdige Dinge ... Aber das kluge Mädchen Ada durchschaut, was vor sich geht. Gemeinsam mit ihren Freund:innen schmiedet sie einen Plan.Das illustrierte Kinderbuch erzählt die Geschichte vom berühmten Erfinder Zangemann und dem Mädchen Ada, einer neugierigen Tüftlerin. Ada beginnt mit Hard- und Software zu experimentieren und erkennt dabei, wie wichtig der eigenständige, freie Umgang mit Software für sie und andere ist.Ein Buch für Kinder ab 6 Jahren, das Freude am Tüfteln vermittelt und zum selbstbestimmten Umgang mit Technik aufruft. Leseprobe 1 (PDF-Link)Leseprobe 2 (PDF-Link)Über die Autoren:Matthias Kirschner ist Präsident der FSFE. 1999 begann er, GNU/Linux zu nutzen und realisierte, dass Software tief in allen Bereichen unseres Lebens verwurzelt ist. Er ist davon überzeugt, dass diese Technik unsere Gesellschaft nicht einschränken, sondern sie befähigen muss. Seit 2004, während seines Studiums der Politik- und Verwaltungswissenschaft, engagiert er sich bei der FSFE und arbeitet dort seit 2009 Vollzeit.Er unterstützt unterschiedliche Organisationen, Unternehmen und die Öffentliche Verwaltung dabei, von Freier Software zu profitieren und er erklärt, wie die grundlegenden Rechte von Freier Software – das Recht sie zu verwenden, zu verstehen, zu verbreiten und zu verbessern – die Meinungsfreiheit, Pressefreiheit oder Privatsphäre fördern.Matthias ist im Advisory Board von unterschiedlichen Freien-Software-Organisationen, war Sachverständiger im Bundestag und anderen Gremien, gibt regelmäßig Interviews und hält Vorträge zum Thema Freie Software.Sandra Brandstätter ist österreichische Wahlberlinerin und arbeitet als Illustratorin, Comicautorin und Character Designerin für Trickfilme und -serien, zum Beispiel für die Serie „Trudes Tier“ (Sendung mit der Maus).Folgende ihrer Kinderbücher und -comics sind auch im Handel erhältlich: „Paula: Liebesbrief des Schreckens“ (Reprodukt Verlag/2016), „Ben & Teo: Zwei sind einer zuviel“ (Beltz & Gelberg/ Autor: Martin Baltscheit/2020).
Lightroom Classic und Photoshop (4. Auflage)
Bilder organisieren, entwickeln und kreativ bearbeiten. Ideal für das Foto-Abo der Adobe Creative Cloud! In 4. aktualisierter und erweiterter Auflage.Holen Sie das Optimum aus Ihren Bildern heraus! Dieses Buch zeigt Ihnen, wie Sie das Power-Duo Lightroom Classic und Photoshop bestmöglich einsetzen und welche vielfältigen Möglichkeiten das verzahnte Zusammenspiel dieser beiden Programme bietet. Angefangen mit dem Bildimport wird ein nahtloser und effizienter Foto-Workflow über Bildorganisation, Bildentwicklung, kreative Retusche und Ausgabe aufgebaut.Sie lernen, wie Sie Ihren Bildbestand optimal verwalten, vorentwickeln und die Weichen für die finale Bearbeitung und Retusche in Photoshop und anschließende perfekte Ausgabe stellen. Ausführliche Erklärungen, attraktive Workshops, Tipps und Tricks, verständlich erklärtes Hintergrundwissen und praktisches Know-how bringen Sie hierbei zum perfekten Ergebnis. Ideal für das Foto-Abo der Adobe Creative Cloud!Aus dem Inhalt:Bildimport und -verwaltungMetadaten nutzen und pflegenRAW-EntwicklungFoto-Workflow optimierenSchnell und effizient arbeiten: Stapelverarbeitung, Vorgaben, AutomatikenSchwarzweiß, Farbe, TonungenBildkorrekturenProfessionelle RetuscheArbeiten mit Smart ObjectsAusgabe und PräsentationLightroom für MobilgerätePhotoshop für das iPadLeseprobe (PDF-Link)
Handbuch für Softwareentwickler (2. Auflage)
Das Standardwerk für professionelles Software Engineering. Jeder Entwickler weiß, dass es mit der Kenntnis von Sprachen und Programmierplattformen nicht getan ist. Wer erfolgreich Software entwickeln möchte, sollte mit vielen Fachgebieten und Methoden vertraut sein – von der Architektur über Datenhaltung, Anforderungsmanagement, Sicherheitsfragen bis zum Projektmanagement. Hier finden Sie eine umfassende Behandlung dieser Themenvielfalt. Das Autorenteam gibt praktische Empfehlungen zu grundlegenden und aktuellen Fragen der professionellen Softwareentwicklung. Das theoretische Fundament und die gut erläuterten Fachbegriffe sind dabei niemals Selbstzweck, sondern stehen im Dienst der Kunst, für Ihre Kunden gute Software zu entwickeln. Aus dem Inhalt: Algorithmen und DatenhaltungAnforderungsanalyse, Planung und EntwurfGelungene User InterfacesBenutzerfreundlichkeit und KundenzufriedenheitMigration – vom Altsystem zur zeitgemäßen AnwendungDatensicherheit, Datenschutz und VerschlüsselungÜberblick über Werkzeuge, Entwicklungsumgebungen und VersionsverwaltungGuter Code und QualitätsmaßstäbePlattformübergreifende EntwicklungAutoren: Prof. Dr. Veikko Krypczyk lehrt u.a. Informatik und Wirtschaftsinformatik. Darüber hinaus ist er Softwareentwickler mit Leidenschaft und begeistert sich für moderne Technologien und Vorgehensweisen.Elena Bochkor hat Betriebswirtschaft mit dem Schwerpunkt Wirtschaftsinformatik studiert. Ihr Arbeitsschwerpunkt ist der Entwurf und das Design moderner und kundengerechter Benutzeroberflächen. Leseprobe (PDF-Link)
Handbuch für Softwareentwickler
Das Standardwerk für professionelles Software Engineering. Jeder Entwickler weiß, dass es mit der Kenntnis von Sprachen und Programmierplattformen nicht getan ist. Wer erfolgreich Software entwickeln möchte, sollte mit vielen Fachgebieten und Methoden vertraut sein – von der Architektur über Datenhaltung, Anforderungsmanagement, Sicherheitsfragen bis zum Projektmanagement. Hier finden Sie eine umfassende Behandlung dieser Themenvielfalt. Das Autorenteam gibt praktische Empfehlungen zu grundlegenden und aktuellen Fragen der professionellen Softwareentwicklung. Das theoretische Fundament und die gut erläuterten Fachbegriffe sind dabei niemals Selbstzweck, sondern stehen im Dienst der Kunst, für Ihre Kunden gute Software zu entwickeln Aus dem Inhalt: Grundlagen: Algorithmen und DatenstrukturenAnforderungsanalyse, Planung und EntwurfGelungene User InterfacesKundenzufriedenheit und BenutzerfreundlichkeitMigration – vom Altsystem zur zeitgemäßen AnwendungDatensicherheit, Datenschutz und VerschlüsselungGuter Code und QualitätsmaßstäbePlattformübergreifende EntwicklungParallelprogrammierungSoftwaretestingMobile Computing im Enterprise-UmfeldÜberblick über Werkzeuge wie Entwicklungsumgebungen und Versionsverwaltung Materialien zum Buch ... 20 Vorwort ... 21 TEIL I. Überblick ... 23 1. Überblick ... 25 1.1 ... Berufswunsch Softwareentwickler ... 25 1.2 ... Über dieses Buch ... 32 1.3 ... Quellen der zitierten Statistiken ... 37 2. Programmierung als Kern der Softwareentwicklung ... 39 2.1 ... Die Programmierung ... 39 2.2 ... Paradigmen der Softwareentwicklung ... 43 2.3 ... Objektorientierte Programmentwicklung ... 44 2.4 ... Programmiersprachen ... 66 2.5 ... Essenzielle Sprachmerkmale ... 76 2.6 ... Fazit und Ausblick ... 106 2.7 ... Literatur und Links ... 107 3. Algorithmen und Datenstrukturen ... 109 3.1 ... Algorithmen als Kernelemente des Programms ... 110 3.2 ... Entwurf von Algorithmen ... 115 3.3 ... Sortieren und Suchen als Basisalgorithmen ... 128 3.4 ... Elementare Datenstrukturen ... 148 3.5 ... Zusammenfassung und Ausblick ... 170 3.6 ... Literatur und Links ... 172 TEIL II. Der Softwarelebenszyklus ... 175 4. Softwareprojekte professionell planen ... 177 4.1 ... Der Wasserfall ... 178 4.2 ... Iterative Entwicklung -- schrittweise zum Ziel ... 183 4.3 ... Das V-Modell -- eine Struktur hauptsächlich für Projekte der öffentlichen Hand ... 185 4.4 ... Bessere Risikobeherrschung durch das Spiralmodell ... 186 4.5 ... Agile Ansätze -- der Komplexität und Unsicherheit mit Flexibilität begegnen ... 187 4.6 ... Softwareentwicklung und die Schnittstellen zum Projektmanagement ... 199 4.7 ... Ist Agilität heute alternativlos? ... 207 4.8 ... Literatur und Links ... 209 5. Die Anforderungsanalyse -- Startpunkt der Entwicklung ... 211 5.1 ... Überblick und Zielstellung ... 211 5.2 ... Ausgangssituation und Notwendigkeit ... 214 5.3 ... Anforderungen ermitteln ... 218 5.4 ... Klassische Anforderungsanalyse ... 237 5.5 ... Agile Anforderungsanalyse ... 248 5.6 ... Toolunterstützung ... 252 5.7 ... Fazit ... 256 5.8 ... Literatur und Links ... 256 6. Der Entwurf des Softwaresystems ... 259 6.1 ... Die Softwarearchitektur als Basis für Erfolg und Wartbarkeit eines Softwaresystems ... 260 6.2 ... Architekturparadigmen ... 266 6.3 ... Entwurfsmuster als Baupläne ... 291 6.4 ... Entwurfsunterstützung durch grafische Modellierung ... 297 6.5 ... Weitere Entwurfsentscheidungen ... 301 6.6 ... Erfolgreiche Entwürfe mithilfe von Prototypen ... 304 6.7 ... Zusammenfassung und Fazit ... 312 6.8 ... Literatur und Links ... 313 7. Die Implementierung schafft den Kern der Anwendung ... 315 7.1 ... Die Entwicklung der Benutzerschnittstelle ... 316 7.2 ... Die Businesslogik umsetzen ... 346 7.3 ... Die Datenwelt anbinden ... 348 7.4 ... Zusammenfassung und Fazit ... 351 7.5 ... Literatur und Links ... 351 8. Testen als Voraussetzung für fehlerarme Software ... 353 8.1 ... Zur Notwendigkeit von Softwaretests ... 354 8.2 ... Testgetriebene Entwicklung ... 355 8.3 ... Ein Überblick über wichtige Testarten ... 357 8.4 ... Testmethoden ... 361 8.5 ... Testebenen ... 369 8.6 ... Technik des Testens ... 387 8.7 ... Fazit und Zusammenfassung ... 391 8.8 ... Literatur und Links ... 391 9. Distribution -- das Produkt muss zum Kunden ... 393 9.1 ... Die Softwaredistribution im Überblick ... 394 9.2 ... Automatisierte Softwareverteilung ... 405 9.3 ... Verbesserte Zusammenarbeit durch DevOps ... 408 9.4 ... Die Nutzung der App Stores ... 411 9.5 ... Die Technik der Softwarebereitstellung ... 417 9.6 ... Fazit ... 437 9.7 ... Literatur und Links ... 437 10. Vom Altsystem zur zeitgemäßen Anwendung ... 439 10.1 ... Technologien im Wandel ... 440 10.2 ... Notwendigkeit einer Softwaremigration ... 442 10.3 ... Ziele einer Softwaremigration ... 444 10.4 ... Planung der Migration ... 444 10.5 ... Migrationsstrategien ... 447 10.6 ... Arten der Migration ... 451 10.7 ... Wirtschaftlichkeitsbetrachtungen ... 453 10.8 ... Stolpersteine ... 454 10.9 ... Eine Fallstudie ... 455 10.10 ... Literatur und Links ... 473 TEIL III. Technologien und Methoden ... 475 11. Webtechnologien ... 477 11.1 ... Einführung ... 477 11.2 ... Zusammenspiel von HTML, CSS und JavaScript ... 478 11.3 ... Die Struktur einer Webseite mit HTML ... 480 11.4 ... HTML Basics ... 481 11.5 ... Das Layout und das Design einer Webseite mit CSS ... 487 11.6 ... Logik und Interaktion mit JavaScript ... 504 11.7 ... Klassenbibliotheken und Frameworks ... 519 11.8 ... Fazit ... 529 11.9 ... Literatur und Links ... 529 12. Apps für mobile Systeme ... 531 12.1 ... Arten von Apps ... 533 12.2 ... Native Apps ... 535 12.3 ... Web-Apps ... 553 12.4 ... Hybride Apps ... 555 12.5 ... Plattformübergreifende Ansätze ... 557 12.6 ... Auswahlkriterien ... 571 12.7 ... Sensoren ... 577 12.8 ... Emulation und Simulation ... 584 12.9 ... Backend as Service ... 591 12.10 ... Fazit ... 599 12.11 ... Literatur und Links ... 599 13. Plattform- und geräteübergreifende Entwicklung ... 601 13.1 ... Nutzerinnen und Nutzer im Fokus ... 602 13.2 ... Ansätze für die plattformübergreifende Entwicklung ... 604 13.3 ... Ein Beispiel mit RAD Studio ... 614 13.4 ... Fazit ... 617 13.5 ... Literatur und Links ... 618 14. Parallelprogrammierung ... 619 14.1 ... Systemtechnische Ebene ... 620 14.2 ... Anwendungsebene ... 626 14.3 ... Programmiertechnische Ebene ... 634 14.4 ... Zusammenfassung ... 638 14.5 ... Literatur und Links ... 638 15. Kundenzufriedenheit durch Nutzerorientierung ... 641 15.1 ... Die Nutzer im Fokus ... 644 15.2 ... Benutzerschnittstellen im Wandel ... 648 15.3 ... Gestaltung von Benutzeroberflächen ... 660 15.4 ... Literatur und Links ... 668 16. Datensicherheit und Datenschutz ... 671 16.1 ... Begriffe und Angrenzungen ... 674 16.2 ... Überblick über die Datenschutz-Grundverordnung ... 676 16.3 ... Datenschutz und Cloud-Computing ... 679 16.4 ... Technischer Datenschutz ... 681 16.5 ... Fazit ... 697 16.6 ... Literatur und Links ... 697 17. Grundlagen der Datenhaltung ... 699 17.1 ... Datenbank -- ein Ort, um Ordnung zu halten ... 699 17.2 ... Phasen der Datenbankentwicklung ... 708 17.3 ... Relationale Datenbanken ... 711 17.4 ... NoSQL-Datenbanken ... 726 17.5 ... Fazit und Ausblick ... 735 17.6 ... Literatur und Links ... 735 18. Werkzeugunterstützung ... 737 18.1 ... Die Rolle von Werkzeugen ... 738 18.2 ... Integrierte Entwicklungsumgebungen als Multifunktionswerkzeuge ... 739 18.3 ... Versionsverwaltungen als Voraussetzung für eine erfolgreiche Entwicklung ... 744 18.4 ... Weitere Softwaretools für die Entwicklung ... 754 18.5 ... Fazit und Ausblick ... 758 18.6 ... Literatur und Links ... 759 19. Qualitätssicherung und Clean Code Development ... 761 19.1 ... Das Verständnis von Softwarequalität ... 761 19.2 ... Ansätze zur Bestimmung der Softwarequalität ... 764 19.3 ... Softwarequalität zwischen Nutzen und Kosten ... 769 19.4 ... Qualität verbessern ... 771 19.5 ... Eine gesunde Fehlerkultur ... 786 19.6 ... Fazit und Zusammenfassung ... 793 19.7 ... Literatur und Links ... 793 TEIL IV. Trends ... 795 20. Enterprise Mobile Computing ... 797 20.1 ... Einsatzszenarien ... 798 20.2 ... Bring Your Own Device ... 807 20.3 ... Technische Aspekte für Enterprise Mobile Computing ... 817 20.4 ... Fazit und Ausblick ... 829 20.5 ... Literatur und Links ... 829 21. Internet of Things ... 831 21.1 ... Stand heute und Zukunftsszenarien ... 832 21.2 ... IoT-Infrastruktur ... 841 21.3 ... Hardware auf kleinstem Raum ... 850 21.4 ... Fallbeispiel: Windows 10 auf dem Raspberry Pi ... 854 21.5 ... Fazit und Ausblick ... 866 21.6 ... Literatur und Links ... 867 22. Cloud-Computing ... 869 22.1 ... Grundlagen des Cloud-Computings ... 870 22.2 ... Ökonomische Gesichtspunkte ... 876 22.3 ... Cloud-Computing als Werkzeug der Softwareentwicklung ... 881 22.4 ... Fazit ... 885 22.5 ... Literatur und Links ... 885 Index ... 887
Excel 2021
Ein Handbuch randvoll mit praktischen Lösungen zu allen nur denkbaren Aufgaben mit Excel 2021 und Excel 365! Sie erfahren unter anderem, wie Sie Tabellen gestalten, Formeln zur Berechnung einsetzen, Analysen erstellen und Ihre Daten und Ergebnisse grafisch aufbereiten und mit anderen teilen. Auch Einsteiger werden hier Schritt für Schritt von den allerersten Grundlagen und Funktionen bis zu den anspruchsvollen Anwendungen angeleitet. Somit eignet sich das Handbuch gleichermaßen zum Erlernen des Programms wie als zuverlässiges Nachschlagewerk für die tägliche Arbeit. Auch für Excel 2019, 2016, 2013 und 2010 geeignet. Aus dem Inhalt: Basiswissen für die Arbeit mit Excel 2021Excel auf dem Touchscreen bedienenAufbau von KalkulationstabellenMit Formeln arbeitenTabellenblätter gestaltenAuswertungen und Was-wäre-wenn-AnalysenZielwertsuche und Solver nutzenDaten grafisch präsentierenDiagramme optimal einsetzenDatenvisualisierung mit SparklinesTabellen grafisch aufbereitenDokumente für die Veröffentlichung vorbereitenArbeitsmappen veröffentlichenExcel-Daten im WebArbeit im TeamTabellenfunktionenInformationen als Tabellen ordnen und verwaltenDatenabfragen und -auszügePivot-Tabellen und -DiagrammeArbeit mit externen DatenDaten mit anderen Anwendungen austauschenRoutineaufgaben mit Makros automatisierenVisual Basic für ApplikationenExcel-App Vorwort ... 27 1. Basiswissen für die Arbeit mit Excel ... 30 1.1 ... Einsteigen mit einem Kostenvergleich ... 30 1.2 ... Ein paar Grundbegriffe vorweg ... 42 1.3 ... Excel starten und beenden ... 48 1.4 ... Baustelle für Tabellen und Diagramme ... 52 1.5 ... Dateiformate ... 82 1.6 ... Optionen für die Arbeit mit Excel ... 89 1.7 ... Add-Ins für Office ... 102 1.8 ... Umgang mit Dokumenten ... 104 1.9 ... Speichern in der Cloud ... 136 1.10 ... Besonderheiten der 64-Bit-Version ... 139 1.11 ... Hilfe in Excel ... 140 2. Aufbau von Kalkulationstabellen ... 143 2.1 ... Planung und Design von Kalkulationsmodellen ... 143 2.2 ... Navigation und Bereichsauswahl ... 148 2.3 ... Effektive Dateneingabe und Datenänderung ... 161 2.4 ... Daten automatisch erzeugen ... 182 2.5 ... Prüfung der Dateneingabe ... 193 2.6 ... Arbeitsblätter neu organisieren und umbauen ... 198 2.7 ... Effektiver Umgang mit Arbeitsmappen ... 225 3. Mit Formeln arbeiten ... 244 3.1 ... Der Aufbau von Formeln ... 244 3.2 ... Eingabe von Formeln und Funktionen ... 253 3.3 ... Relative und absolute Bezüge ... 271 3.4 ... Beschreibende Bereichsnamen ... 278 3.5 ... Matrixformeln ... 291 3.6 ... Qualität sichern und Fehler vermeiden ... 297 3.7 ... Tabellen mit Formeln verknüpfen ... 311 3.8 ... Auswirkungen der Zellbearbeitung auf Formeln ... 317 3.9 ... Kontrolle der Neuberechnung ... 319 4. Tabellenblätter gestalten ... 326 4.1 ... Wahl des Zahlenformats ... 329 4.2 ... Schriftgestaltung und Ausrichtung ... 347 4.3 ... Rahmen und Muster ... 363 4.4 ... Blätter mit Designs schmücken ... 371 4.5 ... Blätter und Mappen schützen ... 376 4.6 ... Einheitliche Gestaltung mit Formatvorlagen ... 381 4.7 ... Tabellenformatvorlagen ... 388 4.8 ... Datenanalyse mit bedingten Formaten ... 394 4.9 ... Mehr Übersicht durch Gliederungsebenen ... 403 4.10 ... Dateneingabe über Steuerelemente ... 411 5. Auswertung und Prognose ... 414 5.1 ... Berechnungen ohne Formeln ... 414 5.2 ... Ergebnisse konsolidieren ... 416 5.3 ... Add-In für statistische Datenanalyse ... 420 5.4 ... Was wäre, wenn ... ... 424 5.5 ... Planspiele mit Szenarios ... 428 5.6 ... Prognose aufgrund vorhandener Daten ... 439 5.7 ... Automatische Datenanalyse ... 443 6. Optimierung ... 445 6.1 ... Zielwertsuche ... 445 6.2 ... Lösungen mit dem Solver suchen ... 447 7. Daten grafisch präsentieren ... 461 7.1 ... Grafische Auswertung mit Diagrammen ... 461 7.2 ... Diagrammtypen in Excel ... 466 7.3 ... Von der Tabelle zum Diagramm ... 468 7.4 ... Zur Verknüpfung von Tabelle und Diagramm ... 480 7.5 ... Diagramme optimieren ... 482 7.6 ... Diagramme gestalten ... 490 8. Diagramme optimal einsetzen ... 521 8.1 ... Standarddiagramme ... 521 8.2 ... Wertdifferenzierung mit Flächen- und Spannweitendiagrammen ... 529 8.3 ... Mehrfachverteilung und Zyklen -- Ring- und Netzdiagramme ... 531 8.4 ... Wertebeziehungen -- xy-Diagramme und Blasendiagramme ... 534 8.5 ... Kombidiagramme ... 537 8.6 ... 3D-Optik und echte 3D-Diagramme ... 540 8.7 ... 3D-Oberflächendiagramme -- für kontinuierliche Darstellungen ... 547 8.8 ... Neuere Diagrammtypen ... 549 8.9 ... Dreidimensionale Karten ... 555 9. Datenvisualisierung mit Sparklines ... 559 9.1 ... Merkmale und Verwendungsmöglichkeiten ... 559 9.2 ... Einfügen von Sparklines ... 560 9.3 ... Darstellungsvarianten ... 563 9.4 ... Bearbeiten von Sparklines ... 564 10. Tabellenblätter grafisch aufbereiten ... 569 10.1 ... Vorgegebene und freie Formen zeichnen ... 570 10.2 ... Feinarbeit an grafischen Objekten ... 580 10.3 ... Organigramme im Schnellgang ... 598 10.4 ... Grafiken übernehmen und bearbeiten ... 599 10.5 ... Piktogramme nutzen ... 607 10.6 ... 3D-Modelle und 3D-Karten ... 609 10.7 ... Freihandzeichnen ... 613 10.8 ... Bilder aus dem Netz fischen ... 616 10.9 ... Schnappschüsse von Tabellen ... 617 11. Dokumente für die Veröffentlichung vorbereiten ... 619 11.1 ... Dokumentinspektion ... 619 11.2 ... Dokumente verschlüsseln ... 626 12. Arbeitsmappen veröffentlichen ... 627 12.1 ... Vorbereitung von Arbeitsblättern zum Druck ... 627 12.2 ... Druckerauswahl und Druckereinstellungen ... 650 12.3 ... Tabellen per E-Mail versenden ... 654 12.4 ... Erstellen einer PDF- oder XPS-Kopie ... 656 13. Excel-Daten im Web ... 658 13.1 ... Von Excel zu HTML und zurück ... 659 13.2 ... Daten für das Web bereitstellen ... 661 13.3 ... Dokumente mit Hyperlinks verknüpfen ... 664 13.4 ... Verarbeiten von XML-Daten ... 673 14. Gemeinsame Arbeit an Arbeitsmappen ... 686 14.1 ... Teamarbeit in lokalen Netzen ... 686 14.2 ... Teamarbeit über OneDrive ... 693 15. Tabellenfunktionen ... 698 15.1 ... Mit Excel 2013 eingeführte Funktionen ... 698 15.2 ... Neue Funktionen seit Excel 2016 ... 700 15.3 ... Aufbau und Einsatz von Funktionen ... 701 15.4 ... Finanzmathematische Funktionen ... 703 15.5 ... Datums- und Zeitfunktionen ... 715 15.6 ... Mathematische Funktionen ... 721 15.7 ... Statistische Funktionen ... 735 15.8 ... Nachschlage- und Verweisfunktionen ... 755 15.9 ... Datenbankfunktionen ... 767 15.10 ... Cube-Funktionen ... 770 15.11 ... Textfunktionen ... 772 15.12 ... Logische Funktionen ... 778 15.13 ... Informationsfunktionen ... 787 15.14 ... Technische Funktionen ... 788 15.15 ... Webfunktionen ... 795 16. Informationen als Tabellen ordnen und verwalten ... 797 16.1 ... Möglichkeiten für den Einsatz von Tabellen ... 798 16.2 ... Die Struktur von Tabellen definieren ... 799 16.3 ... Tabellenbereiche ... 803 16.4 ... Daten sortieren ... 813 16.5 ... Daten in Gruppen zusammenfassen ... 823 17. Datenabfragen und Datenauszüge ... 828 17.1 ... Relevante Daten herausfiltern ... 828 17.2 ... Komplexe Abfragen mit Spezialfiltern ... 842 17.3 ... Weiterverarbeitung gefilterter Daten ... 851 17.4 ... Berechnungen mit Datenbankfunktionen ... 852 18. Pivot-Tabellen und -Diagramme ... 854 18.1 ... Datenanalyse mit Pivot-Tabellen ... 857 18.2 ... Dynamische Diagramme aus Pivot-Tabellen ... 904 18.3 ... Datenmodelle mit mehreren Tabellen ... 907 18.4 ... Power Pivot ... 910 18.5 ... Veröffentlichen auf Power BI ... 921 19. Arbeit mit externen Daten ... 923 19.1 ... Access-Daten importieren ... 926 19.2 ... Zugriff auf SQL-Server-Datenbanken ... 931 19.3 ... Abfrage von XML-Dateien ... 934 19.4 ... Einlesen einer CSV-Datei ... 937 19.5 ... Arbeit mit verknüpften Datentypen ... 940 19.6 ... Direkte Abfragen im Internet ... 944 20. Export und Import von Dateien ... 954 20.1 ... Unterstützte Dateiformate ... 954 20.2 ... Import von Textdateien ... 958 20.3 ... Texte auf Spalten verteilen ... 963 21. Daten mit anderen Anwendungen austauschen ... 964 21.1 ... Austausch über die Zwischenablage ... 964 21.2 ... Dateien dynamisch verknüpfen ... 969 21.3 ... Einsatz von verknüpften Objekten ... 971 21.4 ... Ausgeliehene Leistungen mit eingebetteten Objekten ... 972 22. Routineaufgaben mit Makros automatisieren ... 977 22.1 ... Makros aufzeichnen ... 977 22.2 ... Makros in den Arbeitsablauf einbinden ... 985 22.3 ... Eine Tabelle per Makro kippen ... 989 22.4 ... Makros für die Diagrammgestaltung ... 992 22.5 ... Makros von älteren Excel-Versionen ... 994 23. Visual Basic für Applikationen ... 995 23.1 ... Grundlagen von VBA ... 995 23.2 ... Die Entwicklungsumgebung ... 1015 23.3 ... Ein- und Ausgabe ... 1035 23.4 ... Entwurf von Formularen ... 1043 23.5 ... Tabellenfunktionen in VBA ... 1054 Anhang. Funktionstasten, Tasten und Tastenkombinationen ... 1059 A.1 ... Allgemeine Tastenfunktionen im Überblick ... 1059 A.2 ... Editiertasten und -tastenkombinationen ... 1064 A.3 ... Navigations- und Markierungstasten ... 1065 Stichwortverzeichnis ... 1067
Office 2021
Alle Office-Programme auf einen Blick! Dieses Buch führt Sie durch Ihre tägliche Arbeit mit Word, Excel, PowerPoint und Outlook und erklärt unter anderem auch, wie Sie mit Teams an einer Videokonferenz teilnehmen. Direkt am Bild sehen Sie Schritt für Schritt, wie Sie die Programme gekonnt für sich nutzen. E-Mails verschicken, Kalkulationen erstellen, Briefe schreiben, Präsentationen gestalten: Folgen Sie einfach Klick für Klick den Anleitungen. Aus dem Inhalt: Maus und Touchpad bedienenProgramme aufrufen und schließenEin Dokument anlegen und bearbeitenDokumente speichern und druckenTexte in Word schreiben und formatierenDie Rechtschreibprüfung einsetzenSchnellbausteine nutzenEine Tabelle einfügen und bearbeitenEin Inhaltsverzeichnis erstellenSchicke Layouts mit WordFotos und Videos einfügenMit Excel rechnenText und Zahlen in Zellen eingebenFormeln und FunktionenAbsolute und relative ZellbezügeDiagramme mit Excel erstellenListen und Datenbanken in ExcelDaten in ein Universalformat exportierenE-Mails schreiben mit OutlookEin E-Mail-Konto einrichten und testenSignaturen einrichten und Designs verwendenSchutz vor Phishing und SpamMit Outlook Termine planenSich an Termine erinnern lassenKontakte und Adressen in Outlook verwaltenMit PowerPoint präsentierenVon der Gliederung zur FoliePräsentationen kreativ gestaltenPräsentationen speichern und druckenEine Präsentation erfolgreich vorführenEine Präsentation als Video für das Web erstellenSeriendruck in OfficeOffice-Dokumente online bearbeitenVideokonferenzen mit Teams führen 1. Start mit Office ... 10 Programme aufrufen und schließen ... 12 Das Office-Fenster kennenlernen ... 18 Das Fenster vergrößern und verkleinern ... 20 Ein neues Dokument anlegen ... 22 Die Ansicht des Dokuments anpassen ... 24 Ein Dokument speichern ... 26 Dokumente in der Cloud speichern ... 28 Dokumente drucken oder exportieren ... 32 Ein Dokument schließen ... 34 Dateien organisieren und wiederfinden ... 36 2. Texte schreiben in Word ... 38 Word optimal einstellen ... 40 Der Bildschirm im Touchmodus ... 44 Papierformat und Seitenrand einstellen ... 46 Text eingeben ... 48 Im Text bewegen -- mit Maus oder Fingern ... 50 Textpassagen markieren ... 52 Text löschen, ändern und ergänzen ... 54 Text ausschneiden, kopieren und einfügen ... 56 Verschieben und kopieren mit Drag und Drop ... 58 Text von Hand korrigieren ... 60 Die Rechtschreibprüfung einsetzen ... 62 Arbeitserleichterung durch die AutoKorrektur ... 66 Schnellbausteine nutzen ... 68 Datum per Tabulator ausrichten ... 70 Automatisches Datum per Feldbefehl ... 72 Dokumente im Team bearbeiten ... 74 3. Texte in Word perfekt formatieren ... 78 Text ausrichten: rechts, links oder zentriert ... 80 Schriftart und -größe einstellen ... 82 Schriftformate festlegen: fett, kursiv und unterstrichen ... 84 Schriftzüge mit Farben und Texteffekten gestalten ... 86 Textpassagen einrücken ... 88 Eine Tabelle einfügen ... 90 Eine Tabelle bearbeiten und attraktiv gestalten ... 92 Mit Formatvorlagen arbeiten ... 96 Formatvorlagen anpassen ... 98 Überschriften nummerieren ... 100 Ein Inhaltsverzeichnis erstellen ... 102 Kopf- und Fußzeilen anlegen ... 104 Seitenzahlen einfügen ... 106 Das aktuelle Datum per Feldbefehl einfügen ... 108 Silbentrennung ... 110 Ein Dokument ausdrucken ... 112 PDF-Dateien in Word öffnen und bearbeiten ... 114 4. Schicke Layouts mit Word ... 116 Aufzählungen und Listen formatieren ... 118 Rahmen und Rahmenlinien einfügen ... 122 Dokumente mit Design ... 124 Fotos einfügen und anordnen ... 126 3D-Modelle einfügen ... 130 Mehr Pep mit WordArt und SmartArt ... 132 Eine eigene Dokumentvorlage erstellen ... 134 5. Mit Excel rechnen ... 136 Der Excel-Bildschirm ... 138 Text und Zahlen in Zellen eingeben ... 140 Tabellenblätter nutzen ... 142 Datenreihen für die rationelle Dateneingabe ... 144 Markieren und gestalten ... 146 Zellinhalte löschen und korrigieren ... 150 Zeilen und Spalten einfügen ... 152 Tabellen mit Flash Fill vervollständigen lassen ... 154 Summen erzeugen ... 156 Formeln für die Grundrechenarten ... 158 Mittelwert und Minimal-/Maximalwerte ... 162 Die WENN-Funktion nutzen ... 164 Funktionen für Datum und Uhrzeit ... 168 Absolute und relative Zellbezüge ... 170 Zellinhalte verknüpfen ... 172 6. Diagramme mit Excel erstellen ... 174 Ein Säulendiagramm erzeugen ... 176 Ein Säulendiagramm nachbearbeiten ... 178 Anteile in Kreisdiagrammen darstellen ... 182 Ein »Tortenstück« herausrücken ... 186 Kleine Diagramme mit Sparklines ... 188 7. Listen und Datenbanken in Excel ... 190 Daten in eine Liste eintragen ... 192 Daten in Listen sortieren ... 194 Auswählen und filtern ... 196 Eine Datenbanktabelle planen ... 200 Daten in ein Universalformat exportieren ... 204 8. E-Mails schreiben mit Outlook ... 208 Den Outlook-Bildschirm kennenlernen ... 210 Die Ordner und Ansichten von Outlook ... 212 Ein E-Mail-Konto einrichten ... 216 E-Mails lesen -- der Posteingang ... 218 E-Mails schreiben und versenden ... 220 E-Mails mit Anlagen versenden ... 224 Neue E-Mails abrufen ... 226 E-Mails beantworten ... 228 Signaturen einrichten ... 230 Schutz vor Phishing und Spam ... 232 E-Mails archivieren ... 236 9. Mit Outlook Termine planen ... 238 Termine eintragen, verschieben und löschen ... 240 Termine nachbearbeiten ... 242 Wiederkehrende Termine ... 244 Sich an Termine erinnern lassen ... 246 Eine Notiz anlegen ... 250 10. Kontakte und Adressen in Outlook verwalten ... 252 Die verschiedenen Ansichten für Kontakte ... 254 Einen neuen Kontakt anlegen ... 256 Kontaktdaten ändern ... 258 Kontakte sortieren und gruppieren ... 260 Eine E-Mail an mehrere Kontakte schreiben ... 262 Das Adressbuch ausdrucken ... 264 Adressen exportieren ... 266 11. Mit PowerPoint präsentieren ... 268 Die schnelle Präsentation per Assistent ... 270 Das passende Layout für eine Folie finden ... 272 Text einfügen und bearbeiten ... 274 Attraktive Folienübergänge erzeugen ... 276 Ein anderes Design auswählen ... 278 Von der Gliederung zur Folie ... 280 12. Präsentationen kreativ gestalten ... 282 Online-Grafiken suchen und einfügen ... 284 Bilddateien einfügen und anordnen ... 286 Linien, Rechtecke, Pfeile und andere Formen ... 288 Objekte färben und füllen ... 290 Objekte kopieren und gruppieren ... 292 Schrift- und andere Animationseffekte ... 294 Musik für Ihre Präsentation ... 298 Ein Video in die Präsentation einbetten ... 300 Präsentationen speichern und drucken ... 302 Eine Präsentation erfolgreich vorführen ... 304 Eine Präsentation als Video erstellen ... 306 13. Seriendruck in Office ... 308 Die Serienbrieffunktion von Word ... 310 Die Seriendruckfelder einfügen ... 312 Das Outlook-Adressbuch als Datenquelle nutzen ... 316 Eine Excel-Adressliste als Datenquelle nutzen ... 318 Daten filtern und sortieren ... 320 Den Serienbrief drucken ... 322 14. Office und das Internet ... 324 Ein Office-Dokument per E-Mail versenden ... 326 Office-Dokumente online bearbeiten ... 328 15. Teamarbeit mit Teams ... 330 Teams Chat nutzen ... 332 Eine Konferenz mit Teams starten ... 338 Glossar ... 340 Stichwortverzeichnis ... 352
Excel VBA Programming For Dummies
FIND OUT WHAT EXCEL IS CAPABLE OF WITH THIS STEP-BY-STEP GUIDE TO VBAShort of changing the tires on your car, Microsoft Excel can do pretty much anything. And the possibilities are even more endless when you learn to program with Excel Visual Basic for Applications (VBA). Regardless of your familiarity with Excel VBA, Excel VBA Programming For Dummies can enhance your experience with the popular spreadsheet software. Pretty soon, you'll be doing things you didn't think were possible in Excel, from automating processes to writing your own worksheet functions. You'll learn how to:* Understand the basic tools and operations of Visual Basic for Applications* Create custom spreadsheet functions that make life easier for you and the people maintaining your spreadsheets* Deal with errors and exceptions and eliminate the bugs in your codePerfect for anyone who's never even heard of Excel VBA, Excel VBA Programming For Dummies is also a fantastic resource for intermediate and advanced Excel users looking for a heads-up on the latest features and newest functionality of this simple yet powerful scripting language. DICK KUSLEIKA has over 25 years’ experience helping Office users get the most out of Microsoft’s bestselling software. From online forums to blogs, books, and conferences, he delivers sound and straightforward advice to readers of all skill levels.Introduction 1PART 1: STARTING EXCEL VBA PROGRAMMING 7Chapter 1: Getting to Know VBA 9Chapter 2: Building Simple Macros 17PART 2: EMPLOYING VBA WITH EXCEL 29Chapter 3: Working in the Visual Basic Editor 31Chapter 4: Introducing the Excel Object Model 51Chapter 5: VBA Sub and Function Procedures 67Chapter 6: Using the Excel Macro Recorder 83PART 3: PROGRAMMING CONCEPTS 97Chapter 7: Essential VBA Language Elements 99Chapter 8: Working with Range Objects 119Chapter 9: Using VBA and Worksheet Functions 135Chapter 10: Controlling Program Flow and Making Decisions 151Chapter 11: Automatic Procedures and Events 171Chapter 12: Error-Handling Techniques 193Chapter 13: Bug Extermination Techniques 205Chapter 14: VBA Programming Examples 219PART 4: COMMUNICATING WITH YOUR USERS 243Chapter 15: Simple Dialog Boxes 245Chapter 16: UserForm Basics 263Chapter 17: Using UserForm Controls 281Chapter 18: UserForm Techniques and Tricks 301Chapter 19: Accessing Your Macros through the User Interface 329PART 5: PUTTING IT ALL TOGETHER 343Chapter 20: Creating Worksheet Functions 345Chapter 21: Creating Excel Add-Ins 365PART 6: THE PART OF TENS 377Chapter 22: Ten Handy Visual Basic Editor Tips 379Chapter 23: Resources for VBA Help 389Chapter 24: Ten VBA Do’s and Don’ts 395Index 401
Windows 11 Reparaturhandbuch
- Windows 11 aktivieren, optimieren, absichern und reparieren- Fehler im Betriebssystem finden, beiseitigen und umgehen- Sicherheit: den Computer vor Viren und Hackern schützenSeit dem Windows 11-Update läuft Ihr PC oder Laptop nicht mehr so "rund" wie bisher und es ist einfach der Wurm drin? Ihr Windows braucht ewig zum Starten und Ihr Netzwerk ist viel langsamer als gewöhnlich? Oder haben Sie Ihr Windows-Passwort vergessen? Dann ist dieses Handbuch der ideale Helfer für Sie! Der Experte Christian Immler kennt alle Kniffe, Schwachstellen und auch die verstecktesten Checkboxen von Windows 11. Übersichtlich gegliedert führt er Sie durch die Fallstricke des Betriebssystems und zeigt systematisch, wie Sie jedes Problem identifizieren und schnell wieder in den Griff bekommen. Freuen Sie sich auf 270 leicht verständliche Schritt-für-Schritt-Anleitungen sowie auf praktische Tipps und Tricks zur Selbsthilfe, mit denen Sie Windows 11 entmüllen, optimieren und reparieren. Selbst Änderungen an der Registry werden kein Hindernis mehr darstellen: Denn die wichtigsten .reg-Dateien zur Verbesserung Ihres Systems stehen zum kostenlosen Download bereit.Aus dem Inhalt:- Alle Neuerungen von Windows 11- Vertraute Komponenten aus Windows 10 wiederfinden und nachinstallieren- Windows 11 reparieren und optimieren- Gewohnte Desktop-Optik wiederherstellen - Systembremsen erkennen- Einstellungen optimieren und richtige Konfigurationen vornehmen- Probleme beim Booten beheben- Hardware und Treiber korrekt einrichten- Netzwerkfunktionen optimieren und Fallstricke umgehen- Festplattenfehler beheben und Daten retten- Sicherheitssperren und Passwörter richtig verwenden
PyTorch kompakt
Syntax, Design Patterns und Codebeispiele für Deep-Learning-Modelle Mit diesem benutzerfreundlichen Nachschlagewerk zu PyTorch haben Sie kompaktes Wissen zu einem der beliebtesten Frameworks für Deep Learning immer zur Hand. Der Autor Joe Papa bietet Ihnen mit dieser Referenz den sofortigen Zugriff auf Syntax, Design Patterns und gut nachvollziehbare Codebeispiele. Sie erhalten eine Fülle an gesammelten Informationen, die Ihre Entwicklungsarbeit beschleunigen und die Zeit minimieren, die Sie mit der Suche nach Details verbringen. Leseprobe (PDF-Link)Inhaltsverzeichnis (PDF-Link)Zielgruppe:Data ScientistsSoftwareentwickler*innenDatenanalyst*innenStudierende der Informatik Autor: Joe Papa verfügt über 25 Jahre Erfahrung in Forschung und Entwicklung und ist Gründer von TeachMe.AI. Seinen Abschluss „Master of Science in Electrical Engineering“ hat er an der Universität Rutgers erworben. Bei Booz Allen Hamilton und Perspecta Labs hat er KI-Forschungsteams mit PyTorch geleitet. Joe hat Hunderte von Datenwissenschaftlern als Mentor betreut und mehr als 6.000 Studenten auf der ganzen Welt auf Udemy unterrichtet.
Beginning VFX with Autodesk Maya
Dive into the nuances of visual effects (VFX) design, from planning to execution, using Autodesk Maya. This book introduces the methods and techniques required for your first foray into 3D FX generation from scratch.You will start with the fundamentals of visual effects, including a history of VFX, tools and techniques for creating believable visual effects, and popular tools used in the industry. Next, you are introduced to Autodesk Maya and its various components that make it a favorite among professionals. You will learn how to create rigid body collisions and simulate realistic particles such as dust, fire, water, and more.This book also presents strategies for creating a vortex, rain, hair, fluids, and other soft body simulations and also demonstrates nature element simulations for computer-generated production.At the end of the book, there is a capstone project to make your own visual effects scene in a practical way. After going through this book, you will be able to start building computer-generated visual effects from your imagination through to production.WHAT YOU WILL LEARN* Understand the basic physics behind effect creation* Create 3D visual effects scenes from scratch* Know the details of dynamic simulation in the computer generation space using various functionalities available in Autodesk MayaWHO THIS BOOK IS FORBeginning-level users; students from the field of visual effects design, 3D modeling, and simulation; game designers; those creating computer graphics; FX artists and aspirants looking for a career in the field of 3DDR ABHISHEK KUMAR is an Apple Certified Associate, Adobe Education Trainer, and certified by Autodesk. He received a PhD in computer applications and a master’s degree in animation and computer science. He also received a post-doctoral fellowship at Imam Mohammad Ibn Saud Islamic University, Saudi Arabia.Dr Kumar is actively involved in course development in animation and design engineering for various institutions and universities. He has published a number of research papers and covered a wide range of topics in various digital scientific areas (image analysis, visual identity, graphics, digital photography, motion graphics, 3D animation, visual effects, editing, composition). He holds 10 patents in the field of AI, design, and IoT.Dr Kumar has completed professional studies related to animation, computer graphics, virtual reality, stereoscopy, filmmaking, visual effects, and photography from Norwich University of Arts, University of Edinburg, and Wizcraft MIME & FXPHD, Australia. He is passionate about the media and entertainment industry and has directed two animation short films. Dr Kumar has trained more than 100,000 students across the globe from 153 countries (top five: India, Germany, USA, Spain, Australia). His alumni have worked for national and international movies.Dr Kumar has delivered sessions for more than 100 workshops and seminars as a subject matter expert and resource person at universities, institutes, and colleges such as Delhi University, GGU Central University, Savitribai Phule University, Anna University, Rajiv Gandhi Central University, Allahabad University, Banaras Hindu University, MANNU Hyderabad, Gujrat Technological University ,TMU, GIET University, NIT’s, IIT’s, and several international institutes and universities to make career opportunities and immersive technology opportunities for educators in awareness about the future of elearning, MOOCs, virtual reality, animation design, and the VFX industry.Chapter 1: Introduction to Visual Effects• Scope of this book• Topics to be covered• The importance of Visual Effects• The need for the creation of the visual magicChapter 2: History of VFX• The Evolution of Science in visual design• The State of Art technology in the Digital EraChapter 3: Industrial application for VFX• How to approach the planning of a VFX shot• Industry practices• Software, tools, and techniques used in the rendition of the visual splendor on ScreenChapter 4: Introduction to FX in Maya• Maya Nucleus• nParticle System• Fluids• ncloth • nHairChapter 5: Working with nParticle FX• Fun with Emitter• nParticle tool• Identical object creation with InstancerChapter 6: Creating effects with Particle Emission, Fields/Solvers• Real-life simulation with Gravity• Creation of galaxy• Tinker bell magical dust particle generationChapter 7: Maya Rigid and Soft Body Systems• Introduction to Rigid Body and Constraints• Rigid & Soft Body exampleChapter 8: Working with Maya Fluids• Introduction to fluid -working with container• Working with 2D container• Working with 3D containerChapter 9: Maya Effects• Get Effect Asset Library• Collision with effects• Creating fire, fireworks, lightening, shatter, and smoke effectsChapter 10: Playing with MAYA nucleus Cloth & nConstraint• Creating nCloth• Working with passive collider• Play with nCloth Attributes• Power of nConstraints for effective and efficient simulation.Chapter 11: Working with Hair and Fur Styling• Foundation concept of hair and fur creation• Long hair creation and simulation• Maya Hair libraryChapter 12: Technical Fluid Simulation with Bifrost• Importance of Bifrost Fluids• Working with Bifrost library• Learn to compute and execute water simulation shot EfficientlyChapter 13: FX Capstone Project• Creating a 3D Scene• Integrating the 2D and the 3D worlds• Render FX scene• Conclusion
Microsoft 365 - Das Praxisbuch für Anwender
SO GEHT »IM TEAM ARBEITEN« HEUTE: MODERN UND PRODUKTIV IN DER CLOUD * Lernen Sie Microsoft Teams sowie die anderen Online-Apps und ihre Möglichkeiten kennen * Erfahren Sie, wie Sie welche Apps für welche Aufgaben einsetzen * Entdecken Sie, wie Sie effektiv online im Team an Projekten und Dokumenten zusammenarbeiten Sie stehen vor der Aufgabe, Microsoft 365 (ehemals Office 365) in Ihrem Team für die Online-Zusammenarbeit einzuführen, oder nutzen es bereits als Anwender? Dieses Praxisbuch unterstützt Sie dabei als Anleitung, Ratgeber und Nachschlagewerk. Microsoft 365- und SharePoint-Expertin Melanie Schmidt zeigt Ihnen in diesem Buch, welche Anwendungen wie Teams, SharePoint Online und OneDrive for Business Ihnen mit Microsoft 365 im Unternehmen zur Verfügung gestellt werden, wofür Sie welche App nutzen und worin ihre Unterschiede bestehen. Sie lernen nicht nur das Microsoft 365-Portal kennen, sondern erkunden die bereitgestellten Tools und deren Einsatz anhand von einfachen Schritt-für-Schritt-Anleitungen und vielen Praxisbeispielen, sodass Sie die für Sie relevanten Anwendungen schnell auswählen und meistern können. Mit zahlreichen nützlichen Tipps und Empfehlungen steht Ihnen die Autorin beim Einsatz von Microsoft 365 im Unternehmen zur Seite, ganz gleich, ob am Windows-PC, Mac, Smartphone oder Tablet, im Büro, im Homeoffice oder von unterwegs, sodass Sie effektiv und erfolgreich am Arbeitsplatz 4.0 mit Ihrem Team, Ihrer Arbeitsgruppe, Ihrer Abteilung oder Ihrem Fachbereich zusammenarbeiten können. Aus dem Inhalt: - Microsoft 365 im Überblick - OneDrive for Business - SharePoint Online - Office Online: Word, Excel und PowerPoint - OneNote - Outlook im Web - Microsoft 365-Gruppen - Teams - Planner - Yammer - Forms, Stream und PowerApps
Scott Kelbys 7-Punkte-System für die perfekte RAW-Entwicklung in Lightroom
SO ENTWICKELN SIE IHRE BILDER EFFIZIENT UND ZIELSICHER * Kelbys 7-Schritte-System gibt Ihnen Orientierung und Sicherheit * Herunterladbare Beispielbilder erlauben Ihnen das genaue Nachvollziehen aller Entwicklungsschritte * Die Workshops behandeln viele Foto-Genres und auch komplexe Bearbeitungen Ihre Bilder zielsicher und effizient in Lightroom entwickeln – das lernen Sie mit diesem Buch. Scott Kelbys einfach zu merkendes 7-Schritte-System gibt Ihnen Orientierung und Sicherheit, damit Sie in Zukunft bei der Bearbeitung Ihrer Bilder optimale Ergebnisse erhalten. In 21 Workshops wenden Sie Scott Kelbys 7-Schritte-System in ganz unterschiedlichen Genres an – von Reise- und Landschaft- über Porträt- bis zu Hochzeits- und Nachthimmelfotorafie. Dabei lernen Sie die Funktionen von Lightrooms Entwicklungsmodul nacheinander kennen und setzen sie auch für fortgeschrittene Bearbeitungen wie Schwarzweiß-Konvertierung oder Color-Grading ein. Jeder Workshop zeigt genau, wie Sie die 7 Schritte durchlaufen und vom Ausgangsbild zum Ergebnis gelangen. Die Bildbeispiele aus jedem Workshop können Sie herunterladen, alle Bearbeitungsschritte selbst nachvollziehen und so das Gelernte üben und festigen. Alle Workshops bauen aufeinander auf, so dass Sie am Ende des Buches auch komplexe Bearbeitung vornehmen können – sogar in Photoshop.
Financial Modeling in Excel For Dummies
TURN YOUR FINANCIAL DATA INTO INSIGHTFUL DECISIONS WITH THIS STRAIGHTFORWARD GUIDE TO FINANCIAL MODELING WITH EXCELInterested in learning how to build practical financial models and forecasts but concerned that you don’t have the math skills or technical know-how? We’ve got you covered! Financial decision-making has never been easier than with Financial Modeling in Excel For Dummies. Whether you work at a mom-and-pop retail store or a multinational corporation, you can learn how to build budgets, project your profits into the future, model capital depreciation, value your assets, and more.You’ll learn by doing as this book walks you through practical, hands-on exercises to help you build powerful models using just a regular version of Excel, which you’ve probably already got on your PC. You’ll also:* Master the tools and strategies that help you draw insights from numbers and data you’ve already got * Build a successful financial model from scratch, or work with and modify an existing one to your liking * Create new and unexpected business strategies with the ideas and conclusions you generate with scenario analysis Don’t go buying specialized software or hiring that expensive consultant when you don’t need either one. If you’ve got this book and a working version of Microsoft Excel, you’ve got all the tools you need to build sophisticated and useful financial models in no time!DANIELLE STEIN FAIRHURSTis a Sydney-based financial modeling consultant who helps her clients create meaningful financial models for business analysis. She is regularly engaged around Australia and globally as a speaker and course facilitator. She received the Microsoft MVP Award in 2021 in recognition of her technical expertise and contributions to the community.INTRODUCTION 1About This Book 1Foolish Assumptions 2Icons Used in This Book 2Beyond the Book 3Where to Go from Here 3PART 1: GETTING STARTED WITH FINANCIAL MODELING 5CHAPTER 1: INTRODUCING FINANCIAL MODELING 7Defining Financial Modeling 7What it is 8Who uses it 9Why it matters 10Looking at Examples of Financial Models 10Project finance models 11Pricing models 12Integrated financial statement models 12Valuation models 12Reporting models 13CHAPTER 2: GETTING ACQUAINTED WITH EXCEL 15Making Sense of the Different Versions of Excel 15A rundown of recent Excel versions 16Focusing on file formats 23Defining Modern Excel 23Recognizing the Dangers of Using Excel 25Capacity 26Lack of discipline 27Errors 28Looking at Alternatives and Supplements to Excel 31CHAPTER 3: PLANNING AND DESIGNING YOUR FINANCIAL MODEL 35Identifying the Problem That Your Financial Model Needs to Solve 35Designing How the Problem’s Answer Will Look 39Gathering Data to Put in Your Model 45Documenting the Limitations of Your Model 46Considering the Layout and Design of Your Model 47Structuring your model: What goes where 49Defining inputs, calculations, and output blocks 50Determining your audience 51CHAPTER 4: BUILDING A FINANCIAL MODEL BY THE RULEBOOK 53Document Your Assumptions 53Create Dynamic Formulas Using Links 59Only Enter Data Once 61Model with Consistent Formulas 62Build in Error Checks 64Allowing tolerance for error 66Applying conditional formatting to an error check 67Format and Label for Clarity 68CHAPTER 5: USING SOMEONE ELSE’S FINANCIAL MODEL 71Considering Templates for Building a Financial Model 72Why templates can be appealing 72What’s wrong with using templates 72Why you should build your own model 74Inheriting a File: What to Check For 75Meeting a model for the first time 76Inspecting the workbook 77Using Audit Tools to Find and Correct Errors 84Checking a model for accuracy 85Making sense of the formulas 88Sharing and Version Control 95PART 2: DIVING DEEP INTO EXCEL 97CHAPTER 6: EXCEL TOOLS AND TECHNIQUES FOR FINANCIAL MODELING 99Referencing Cells 100Relative cell referencing 101Absolute cell referencing 103Mixed cell referencing 106Naming Ranges 109Understanding why you may want to use a named range 109Creating a named range 110Finding and using named ranges 111Editing or deleting a named range 113Dynamic Ranges 113Linking in Excel 114Internal links 115External links 117Using Shortcuts 120Restricting and Validating Data 123Restricting user data entry 124Creating drop-down boxes with data validations 125Protecting and locking cells 126Goal Seeking 127Limiting project costs with a goal seek 128Calculating a break-even point with a goal seek 129CHAPTER 7: USING FUNCTIONS IN EXCEL 131Identifying the Difference between a Formula and a Function 131Finding the Function You Need 132Getting Familiar with the Most Important Functions 133SUM 134MAX and MIN 135AVERAGE 139COUNT and COUNTA 140ROUND, ROUNDUP, and ROUNDDOWN 146IF 153COUNTIF and SUMIF 156Reporting sales with SUMIF 158VLOOKUP, HLOOKUP, and XLOOKUP 161Being Aware of Advanced Functions and Functionality 170CHAPTER 8: APPLYING SCENARIOS TO YOUR FINANCIAL MODEL 173Identifying the Differences among Types of Analysis 174Building Drop-Down Scenarios 175Using data validations to model profitability scenarios 175Applying formulas to scenarios 178Applying Sensitivity Analysis with Data Tables 181Setting up the calculation 181Building a data table with one input 182Building a data table with two inputs 184Applying probability weightings to your data table 186Using Scenario Manager to Model Loan Calculations 189Setting up the model 189Applying Scenario Manager 191CHAPTER 9: CHARTING AND PRESENTING MODEL OUTPUT 195Deciding Which Data to Display 196Conveying Your Message by Charting Scenarios 198Deciding Which Type of Chart to Use 200Line charts 201Bar charts 206Combo charts 209Pie charts 211Charts in newer versions of Excel 214Dynamic Charting 219Building the chart on formula-driven data 219Linking the chart titles to formulas 220Creating dynamic text 221Preparing a Presentation 225PART 3: BUILDING YOUR FINANCIAL MODEL 227CHAPTER 10: BUILDING AN INTEGRATED FINANCIAL STATEMENTS MODEL 229Getting to Know the Case Study 230Entering Assumptions 231Revenue assumptions 232Expense assumptions 233Other assumptions 234Calculating Revenue 234Projecting sales volume 235Projecting dollar sales 237Calculating Expenses 238Staff costs 238Other costs 239Depreciation and amortization 240Building the Income Statement 243Building the Cash Flow Statement 248Building the Balance Sheet 252Building Scenarios 258Entering your scenario assumptions 258Building a drop-down box 259Building the scenario functionality 260CHAPTER 11: BUILDING A DISCOUNTED CASH FLOW VALUATION 263Understanding How the Discounted Cash Flow Valuation Works 264Step 1: Calculating Free Cash Flow to Firm 265Step 2: Calculating Weighted Average Cost of Capital 268Step 3: Finding the Terminal Value 269Discounting Cash Flows and Valuation 270CHAPTER 12: BUDGETING FOR CAPITAL EXPENDITURE AND DEPRECIATION 273Getting Started 274Making a reusable budget model template 274Creating dynamic titles 277Output 1: Calculating Cash Required for Budgeted Asset Purchases 277Output 2: Calculating Budgeted Depreciation 282Useful life 283Written-down date 284The depreciation schedule for the current year 285Depreciation in prior periods 287Output 3: Calculating the Written-Down Value of Assets for the Balance Sheet 288PART 4: THE PART OF TENS 291CHAPTER 13: TEN STRATEGIES FOR REDUCING ERROR 293Using the Enter Key 293Checking Your Work 294Checking It Again 295Getting Someone Else to Check Your Work 296Documenting Assumptions 297Documenting Methodology with a Flowchart 297Stress-Testing with Sensitivity Analysis 298Conducting a Scenario Analysis 299Taking Note of Excel Error Values 300Including Error Checks 302CHAPTER 14: TEN COMMON PITFALLS TO AVOID 303The Numbers Don’t Add Up 303You’re Getting #REF! Errors 304You Have Circular References 304The Model Has Too Much Detail 307The File Size Is Out of Control 307Your Model Is Full of “Spaghetti” Links 309The Formulas Are Unnecessarily Long and Complicated 311No One Is Paying Attention to the Model 312You Don’t Want to Let Go 313Someone Messes Up Your Model 313Index 315
Microsoft 365 - Das Praxisbuch für Anwender (2. Auflg.)
Die Zusammenarbeit mit Teams, SharePoint Online, OneDrive for Business, Outlook und Co. Sie stehen vor der Aufgabe, Microsoft 365 in Ihrem Team für die Online-Zusammenarbeit einzuführen, oder nutzen es bereits als Anwender? Dieses Praxisbuch unterstützt Sie dabei als Anleitung, Ratgeber und Nachschlagewerk. Microsoft 365- und SharePoint-Expertin Melanie Schmidt zeigt Ihnen in diesem Buch, welche Anwendungen wie Teams, SharePoint Online und OneDrive for Business Ihnen mit Microsoft 365 im Unternehmen zur Verfügung gestellt werden, wofür Sie welche App nutzen und worin ihre Unterschiede bestehen. Sie lernen nicht nur das Microsoft 365-Portal kennen, sondern erkunden die bereitgestellten Tools und deren Einsatz anhand von einfachen Schritt-für-Schritt-Anleitungen und vielen Praxisbeispielen, sodass Sie die für Sie relevanten Anwendungen schnell auswählen und meistern können. Mit zahlreichen nützlichen Tipps und Empfehlungen steht Ihnen die Autorin beim Einsatz von Microsoft 365 im Unternehmen zur Seite, ganz gleich, ob am Windows-PC, Mac, Smartphone oder Tablet, im Büro, im Homeoffice oder von unterwegs, sodass Sie effektiv und erfolgreich am Arbeitsplatz 4.0 mit Ihrem Team, Ihrer Arbeitsgruppe, Ihrer Abteilung oder Ihrem Fachbereich zusammenarbeiten können. Zielgruppe: Anwender*innenBerater*innenTrainer*innenAutorin: Melanie Schmidt ist seit 1991 in der IT-Branche tätig. Sie arbeitet freiberuflich als Business Consultant für Microsoft 365 und SharePoint für zahlreiche IT-Dienstleister und Kunden. Außerdem verfasst sie anwenderspezifische Fachbücher und Videotrainings für Microsoft-Produkte, in denen sie ihr Praxiswissen an alle Anwendergruppen weitergibt.
Java 17 for Absolute Beginners
Write your first code in Java 17 using simple, step-by-step examples that model real-word objects and events, making learning easy. With Java 17 for Absolute Beginners you’ll be able to pick up the concepts without fuss. It teaches Java development in language anyone can understand, giving you the best possible start.You’ll see clear code descriptions and layout so that you can get your code running as soon as possible. Author Iuliana Cosmina focuses on practical knowledge and getting you up to speed quickly—all the bits and pieces a novice needs to get started programming in Java.First, you’ll discover what type of language Java is, what it is good for, and how it is executed. With the theory out of the way, you’ll install Java, choose an editor such as IntelliJ IDEA, and write your first simple Java program. Along the way you’ll compile and execute this program so it can run on any platform that supports Java. As part of this tutorial you’ll see how to write high-quality code by following conventions and respecting well-known programming principles, making your projects more professional and efficient.Java 17 for Absolute Beginners gives you all you need to start your Java programming journey. No experience necessary. After reading this book, you'll come away with the basics to get started writing programs in Java.WHAT YOU WILL LEARN* Get started with Java 17 from scratchUse data types, operators, and the stream API * Install and use the IntelliJ IDEA and the Gradle build tool* Exchange data using the new JSON APIs * Play with images using multi-resolution APIs* Implement the publish-subscribe architectureWHO THIS BOOK IS FORThose who are new to programming and who want to start with Java.IULIANA COSMINA is currently a software engineer for NCR Edinburgh. She has been writing Java code since 2002 and contributed to various types of applications such as experimental search engines, ERPs, track and trace, and banking. During her career, she has been a teacher, a team leader, software architect, DevOps professional, and software manager. She is a Spring-certified Professional, as defined by Pivotal, the makers of Spring Framework, Boot, and other tools, and considers Spring the best Java framework to work with. When she is not programming, she spends her time reading, blogging, learning to play piano, travelling, hiking, or biking.Chapter 1: An Introduction to Java- When every version was released, how were they called and what were the particularities- What is Java, how it is executed, what type of language it is and what is it good for-Chapter 2: Preparing your development environment- Installing Java, choosing an editor, choosing a build tool-Chapter 3: Getting your feet wet- Writing a simple program, compile and execute- Adding a dependency of somebody else’s code through dependencies of existing libraries- Mention best tools for java and most used frameworks like SpringChapter 4: Java syntax- what is a package, module- class- enums- interface ( private methods & default methods)- class, constructor, methods… etc- removal of _Chapter 5: Data Types- primitive, object types (emphasis on String, Collections, Calendar API)- String – compact Strings- Collections: Immutable collections, factory methods for Collections(JEP 269)- mention Generics- optional – enhancements- threads, futures – CompletableFuture (JEP 266)Chapter 6: Operators- unary, binary, ternary, logic, and the diamond operator (used in conjunction with anonymous inner classes)Chapter 7: Controlling the flow- if, loops- try catch (try with resources with managed variables)- recursionChapter 8: The Stream API- streams , optional to Stream, enhancementsChapter 9: Debugging , testing and documenting- what is a break point- loggers : unified JVM logging (JEP 264)- mocks and stubs- jmc, jps, jcmd – JDK utilities- The new Doclet API- the JShell Command Line Tool- accessing the process API- @Deprecated enhancements (JEP 277)Chapter 10: Making your application interactive- request data with System.in- Swing- Web applications (use the new HTTP client)- JavaFX UI (JEP 253)- Internationalization (JEP 267)Chapter 11: Writing files- storing data to files, reading it from them- serialization to Binary, XML, JSON, YML (JEP290)- playing with images – multi-resolution APIChapter 12: Publish-Subscribe Framework- reactive streamsChapter 13: Garbage Collection- JEP 214,248,271,291
Excel Workbook For Dummies
GET PRACTICAL WALKTHROUGHS FOR THE MOST USEFUL EXCEL FEATURESLooking for easy-to-understand, practical guidance on how to go from Excel newbie to number crunching pro? Excel Workbook For Dummies is the hands-on tutorial you've been waiting for.This step-by-step guide is packed with exercises that walk you through the basic and advanced functions and formulas included in Excel. At your own speed, you'll learn how to enter data, format your spreadsheet, and apply the mathematical and statistical capabilities of the program.Work through the book from start to finish or, if you'd prefer, jump right to the section that's giving you trouble, whether that's data visualization, macros, analysis, or anything else. You can also:* Brush up on and practice time-saving keyboard shortcuts for popular commands and actions* Get a handle on multi-functional and practical pivot tables with intuitive practice exercises* Learn to secure your data with spreadsheet password protectionsPerfect for new users of Excel, Excel Workbook For Dummies is also the ideal resource for those who know their way around a spreadsheet but need a refresher on some of the more advanced features of this powerful program.PAUL MCFEDRIES has published over 100 books, with topics ranging from Windows 10 to Microsoft Office, Apple gadgets, and Amazon Alexa. He is the author of the recently released Excel Data Analysis For Dummies and Google’s G Suite For Dummies.GREG HARVEY, PHD was author of over 30 For Dummies titles covering Excel. Introduction 1PART 1: BUILDING WORKSHEETS 5Chapter 1: Getting Familiar with the Excel Interface 7Chapter 2: Entering the Worksheet Data 21Chapter 3: Formatting the Worksheet 37Chapter 4: Printing Worksheet Reports 59Chapter 5: Modifying the Worksheet 79PART 2: USING FORMULAS AND FUNCTIONS 101Chapter 6: Building Formulas 103Chapter 7: Copying and Correcting Formulas 123Chapter 8: Creating Date and Time Formulas 145Chapter 9: Financial Formulas and Functions 155Chapter 10: Using Math Functions 167Chapter 11: Using Common Statistical Functions 179Chapter 12: Using Lookup Functions 187Chapter 13: Using Logical Functions 197Chapter 14: Text Formulas and Functions 209PART 3: WORKING WITH GRAPHICS 217Chapter 15: Charting Worksheet Data 219Chapter 16: Adding Graphics to Worksheets 231PART 4: MANAGING AND SECURING DATA 249Chapter 17: Building and Maintaining Tables 251Chapter 18: Protecting Workbooks and Worksheet Data 271PART 5: DOING DATA ANALYSIS 283Chapter 19: Performing What-If Analysis 285Chapter 20: Generating PivotTables 299PART 6: MACROS AND VISUAL BASIC FOR APPLICATIONS 315Chapter 21: Using Macros 317Chapter 22: Using the Visual Basic Editor 327PART 7: THE PART OF TENS 341Chapter 23: Top Ten Features in Excel 343Chapter 24: Top Ten Tips for Using Excel Like a Pro 347Index 355
Nature-Inspired Optimization Algorithms with Java
Gain insight into the world of nature-inspired optimization techniques and algorithms. This book will prepare you to apply different nature-inspired optimization techniques to solve problems using Java.You'll start with an introduction to the hidden algorithms that nature uses and find the approximate solutions to optimization problems. You'll then see how living creatures such as fish and birds are able to perform computation to solve specific optimization tasks. This book also covers various nature-inspired algorithms by reviewing code examples for each one followed by crisp and clear explanations of the algorithm using Java code. You'll examine the use of each algorithm in specific industry scenarios such as fleet scheduling in supply chain management, and shop floor management in industrial and manufacturing applications.Nature-Inspired Optimization Algorithms with Java is your pathway to understanding a variety of optimization problems that exist in various industries and domains and it will develop an ability to apply nature-inspired algorithms to find approximate solutions to them.WHAT YOU'LL LEARN* Study optimization and its problems* Examine nature-inspired algorithms such as Particle Swarm, Gray wolf, etc.* See how nature-inspired algorithms are being used to solve optimization problems* Use Java for solving the different nature-inspired algorithms with real-world examplesWHO THIS BOOK IS FORSoftware developers/architects who are looking to hone their skills in area of problem solving related to optimization with Java.Shashank Jain has been working in the IT industry for about 20 years, mainly in areas of cloud computing and distributed systems. He has a keen interest in virtualization techniques, security, and complex systems. Shashank has 32 software patents (many yet to be published) in the area of cloud computing, IoT, and machine learning. He is a speaker at multiple reputed cloud conferences. Shashank holds Sun, Microsoft, and Linux kernel certifications. He is also the author of the book "Linux Containers and Virtualization" published by Apress.1. Intro to Optimization Problems2. Nature Inspired Optimization Methods3. Birdsa. Particle swarm Optimizationb. Cuckoo search algorithmc. Pigeon inspired optimization4. Mammalsa. Grey wolf optimizerb. Lion Pride optimizerc. Cat swarm optimizationd. Bat algorithme. Monkey algorithm5. Insectsa. Ant colony optimizationb. Artificial Bee colonyc. Grasshopper optimizationd. Pigeon inspired algorithme. Social spider optimizationf. Mosquito host seeking optimization6. Sea Creaturesa. Whale optimization algorithmb. Artificial fish swarm algorithmc. Fish school search7. Simple Organismsa. Bacteria foraging optimizationb. Slime mould optimization
Introducing Qt 6
Get started quickly with Qt, the popular open source C++ framework for building C++-based applications and games. This book will have you building both fully functional desktop and mobile applications in no time, including some simple game applications.Introducing Qt 6 begins by guiding you in setting up your tools and environment, and then walks you through the first "baby steps" of Qt framework. Next, you'll learn the basics of how project and app structure are set up using Qt. Then, you’ll begin your first real hands-on projects using Qt, including a task and problem management application and two games.As you progress, you can enhance these apps and games using additional Qt components and features. The book then delves into advanced topics in Qt, learning above and beyond what the Qt docs can offer, including local storage, C++ integration, deployment to Windows and Android, custom components and how to work with them.Upon completing this book, you'll come away knowing how to build a C++ application from design to deployment, top to bottom. And, you'll have actual application and game examples that you can apply to your own work or hobby.WHAT YOU WILL LEARN* Learn to build your first applications and games using Qt 6 framework* Design, create, build and deploy your first Qt applications or games as finished products* Explore local storage integration in theory and practice* Cover deployment on Windows and on Android* Integrate with C++ language to leverage additional functionality* Dive into Custom Components and how to work with them* Explore different project structures and moreWHO THIS BOOK IS FORSoftware programmers, developers who are new to C++ or the Qt framework. Some prior programming experience though may be helpful.Ben Cöppicus is a software developer, trainer, and author specializing in native C++ development as well as some web development. He builds mostly web, mobile and desktop applications. It is his hope that his work and writing can help you learn new things, experience the wonderful world of programming and maybe make you a better programmer, developer as well. Part 11. IntroductionPart 2 - Content2. Setting up the Tools3. First Baby Steps with Qt4. Explaining the Basics of Project and App Structure5. First Real Projects6. Taskmaster7. Hang-Man Game8. Rock, Paper, Scissors GamePart 3 - Components, Features and Things9. Components10. Features11. Writing Diagrams in Qt12. Advanced Topics in Qt
Software-Architekturen dokumentieren und kommunizieren
Dokumentation wird oft als lästige Pflicht angesehen und in vielen Softwareprojekten stark vernachlässigt, die Architektur wird manchmal überhaupt nicht beschrieben. Damit das in Ihren Projekten nicht passiert, schlägt dieses Buch praxiserprobte und schlankere Bestandteile für eine wirkungsvolle Architekturdokumentation vor.Anhand eines durchgängigen Beispiels erfahren Sie, wie Sie architekturrelevante Einflussfaktoren erfassen und Ihre Softwarelösung angemessen und ohne Ballast festhalten. Sie lernen nicht nur die Vorgehensweise für das Dokumentieren während des Entwickelns kennen, sondern auch, wie Sie bestehende Systeme im Nachhinein beschreiben. Neben der Methodik diskutiert das Buch auch typische Formate und Werkzeuge wie Wikis, UML-Werkzeuge unter anderem, mit denen Sie Architekturdokumentation erfassen, verwalten und verbreiten kann.Checklisten und Übungsaufgaben geben Ihnen die nötige Sicherheit, um die Architekturdokumentation zu einem integralen Bestandteil Ihres Softwarevorhabens zu machen. Autor:Stefan Zörner arbeitet als Softwarearchitekt und Berater bei embarc in Hamburg. Er wirkt bei Entwurfs- und Umsetzungsfragen mit, unterstützt beim Festhalten von Architektur und beleuchteten Lösungsansätzen in Bewertungen. Sein Wissen und seine Erfahrung teilt er regelmäßig in Vorträgen, Artikeln und Workshops.
Practical C++ Design
Go from competent C++ developer to skilled designer or architect using this book as your personal C++ design master class. Updated for the C++20 standard, this title will guide you through the design and implementation of an engaging case study that forms the backdrop for learning the art of applying design patterns and modern C++ techniques to create a high quality, robust application.Starting with a quick exploration of the requirements for building the application, you'll delve into selecting an appropriate architecture, eventually designing and implementing all of the necessary modules to meet the project’s requirements. By the conclusion of Practical C++ Design, you'll have constructed a fully functioning calculator capable of building and executing on any platform that supports both Qt and C++20. Access to the complete source code will help speed your learning.Utilize the Model-View-Controller pattern as the basis for the architecture of the calculator; the observer pattern to design an event system; the singleton pattern as you design the calculator’s central data repository, a reusable stack; the command pattern to design a command system supporting unlimited undo/redo; the abstract factory pattern to build a cross-platform plugin infrastructure for extensibility; coroutines to implement a command line interface with a lazy tokenizer; and more.After reading and using this book, you’ll have begun the transition from C++ programmer to architect.WHAT YOU WILL LEARN* Read a specification document and translate it into a practical C++ design using some of the latest language features from C++20* Understand trade-offs in selecting between alternative design scenarios* Gain practical experience in applying design patterns to realistic development scenarios* Learn how to effectively use language elements of modern C++ to create a lasting design* Develop a complete C++ program from a blank canvas through to a fully functioning, cross platform application* Read, modify, and extend existing, high quality code* Learn the fundamentals of API design, including class, module, and plugin interfacesWHO THIS BOOK IS FORThe experienced C++ developer ready to take the next step to becoming a skilled C++ designer.ADAM B. SINGER graduated first in his class at the Georgia Institute of Technology in 1999 with a bachelors degree in chemical engineering. He subsequently attended the Massachusetts Institute of Technology on a National Defense, Science, and Engineering Graduate Fellowship. He graduated from MIT with a Ph.D. in chemical engineering in 2004 after defending his thesis titled Global Dynamic Optimization. Since graduation, Adam has been a member of the research and engineering staff at an oil and gas major, where he has worked in software development, design, and project management in areas such as optimization, reservoir simulation, decision support under uncertainty, basin modeling, well log modeling, and stratigraphy. He has also served on and chaired committees designing in-house training in the areas of technical software development and computational and applied mathematics. He currently holds a research supervisory position. Adam additionally held the title of adjunct assistant professor in the Department of Computational and Applied Mathematics at Rice University from 2007-2012. In both 2006 and 2007, he taught a graduate level course, CAAM 520, on computational science. The course focused on the design and implementation of high performance parallel programs.Preface (5 pages)The preface details my motivation for writing the book, the target audience for the book, thegeneral structure of the book, and how to contact the author. Of particular importance is therationale behind choosing the case study, the target language (C++), and the GUI toolkit (Qt).Chapter 1: Defining the Case Study (6 pages)The first chapter describes, in detail, the case study to be examine in the book. The chapterdiscusses requirements in the abstract and then transitions to the calculator’s specific requirements.This sets the stage for the remainder of the book, which describes, in detail, the design andimplementation of the calculator, pdCalc, proposed in Chapter 1.1. A Brief Introduction2. A Few Words About Requirements3. Reverse Polish Notation (RPN)4. The Calculator’s Requirements5. The Source Code1The advice, information, and conclusions discussed in this book are those of the author and have not beenendorsed by, or reflect the opinions or practices of, ExxonMobil Corporation or its affiliates.5Chapter 2: Decomposition (18 pages)In this chapter, I explain the elements of a good decomposition and strategies for decomposing aproblem into manageable pieces. Subsequently, an architecture for pdCalc is selected, the calculatoris modularized, and use cases are used to develop interfaces for the high level calculator modules.The four high level modules are the stack, the command dispatcher, the user interface (subdividedinto a command line interface and a graphic user interface), and a plugin manager.1. The Elements of a Good Decomposition2. Selecting An Architecture3. Interfaces4. Assessment of Our Current Design5. Next StepsChapter 3: The Stack (20 pages)The stack is the first module discussed in detail. The stack is the fundamental data repositoryof the calculator. As part of the calculator’s design and implementation, the singleton pattern isexplored. The stack also affords the first opportunity to discuss an event system for the calculator,which provides a backdrop for exploration of the observer pattern, including the design andimplementation of reusable publisher and observer abstract classes.1. Decomposition of the Stack Module2. The Stack Class3. Adding Events4. A Quick Note on TestingChapter 4: The Command Dispatcher (32 pages)This chapter describes the design and implementation of the command dispatcher, the module ofthe calculator responsible for the creation, storage, and execution of commands. Of particular notein this chapter is the exposition on the command pattern and how it can be used to implement apractical undo/redo framework. In addition to exploring a traditional deep hierarchy method forimplementing commands, a C++11 alternative using lambda expressions and the standard functiontemplate are presented as a modern alternative design.1. The Decomposition of the Command Dispatcher2. The Command Class3. The Command Repository4. The Command Manager5. The Command Dispatcher6. Revisiting Earlier Decisions6Chapter 5: The Command Line Interface (14 pages)This chapter marks an important milestone, the creation of the first user executable program.In addition to building a simple command line interface, we’ll explore how to create an abstractsoftware interface suitable for both a command line interface and a graphical user interface. Withinthe context of the command line interface, we’ll learn techniques for simple parsing and tokenizingof input text streams.1. The User Interface Abstraction2. The Concrete CLI Class3. Tying It Together: A Working ProgramChapter 6: The Graphical User Interface (24 pages)In this chapter, we build the Qt-based graphical user interface for the calculator. Here, we’llexamine different strategies for building GUIs, abstraction of GUI elements, and modularization ofthe overall GUI design. Included in the discussion is design for the separation of on-screen widgetsfrom look-and-feel.1. Requirements2. Building GUIs3. Modularization4. A Working Program5. A Microsoft Windows Build NoteChapter 7: Plugins (38 pages)In this chapter, I describe how to build a cross-platform plugin system. This system includes theabstract interface for C++ plugins as well as the operating system specific mechanics involved withloading plugins and executing plugin functions. In the concrete case of the plugin loader, I explainthe many build tricks that can be used to handle cross-platform code and demonstrate how theabstract factory pattern provides an elegant design solution to this problem.1. What Is a Plugin?2. Problem 1: The Plugin Interface3. Problem 2: Loading Plugins4. Problem 3: Retrofitting pdCalc5. Incorporating Plugins6. A Concrete Plugin7. Next Steps7Chapter 8: New Requirements (24 pages)Any developer who has ever worked on a production software project quickly learns that newrequirements are always added late in the development cycle. In this chapter, we explore theaddition of new user requests after the original requirements have already been satisfied. Thediscussion progresses from fully implemented solutions to design only solutions to vague ideas forthe reader to explore on her own.1. Fully Designed New Features2. Designs Toward a More Useful Calculator3. Some Interesting Extensions for Self-ExplorationAppendix A: Acquiring, Building, and Executing pdCalc (4 pages)This appendix explains how to download the source code from GitHub and how to build the casestudy on Linux and Windows. Once the program is built, readers will want to execute the codeand its included test suite; execution instructions are therefore provided.1. Getting The Source Code2. Dependencies3. Building pdCalc4. Executing pdCalcAppendix B: Organization of the Source Code (6 pages)This appendix simply explains the organization of the source tree for pdCalc. This appendix isuseful for finding the locations for the source files referenced in the text.1. The src Directory2. The test DirectoryReferences (2 pages)This section lists twenty-nine references cited in the book.Index (3 pages)This section is a complete index for the book.
Hands-On Guide to AgileOps
Discover the best practices for transforming cloud and infrastructure operations by using Agile, Scrum, Kanban, Scrumban and Spotify models. This book will help you gain an in-depth understanding of these processes so that you can apply them to your own work.The book begins by offering an overview of current processes and methods used in IT Operations using ITIL and IT4IT. The Authors provide a background of the Agile, Scrum, Kanban, SaFe, Scrumban, and Spotify models used in software development. You’ll then gain in-depth guidance and best practices to implement Agile in the Operations world. You’ll see how Agile, Site Reliability Engineering and DevOps work in tandem to provide the foundation for modern day infrastructure and cloud operations. The book also offers a comparison of various agile processes and their suitability to the infrastructure and cloud operations world.After completing this is hands-on guide, you’ll know how to adopt Agile, DevOps and SRE and select the most suitable processes for your organization to achieve higher reliability, agility and lower costs while running cloud and infrastructure operations.WHAT YOU WILL LEARN* Understand how cloud computing and microservices architecture are changing operations dynamics* Understand ITIL, IT4IT, and Lean* Learn how Site Reliability Engineering, Agile and DevOps work in tandem* Leverage Agile, Scrum, Kanban, Scrumban, and Spotify models to run cloud operations* Use Site Reliability techniques along with Agile and DevOps* Study the different agile frameworks (Spotify, SAFe, LeSS, DAD, Nexus), their purpose, benefits and implementation approaches.* Learn a step-by-step process to identify and implement these frameworks in your organizationWHO THIS BOOK IS FORInfrastructure architects, DevOps architects, Agile practitioners, DevSecOps Experts, Product Managers/Scrum Masters, DevOps Engineers.NAVIN SABHAWAL, currently is the Chief Architect and Head of Strategy for Autonomics, named ‘DRYiCE’ at HCL Technologies. He is responsible for innovation, presales, and delivery of award-winning autonomics platforms for HCL Technologies.He is an innovator, thought leader, author and a consultant in areas of AI and Machine Learning, Cloud Computing, Big Data Analytics, Software Product Development, Engineering and R&D. He is responsible for IP Development & Service Delivery in the Areas of AI and Machine Learning, Automation products, Cloud Computing, Public Cloud AWS, Microsoft Azure, VMWare Private Cloud, Microsoft Private Cloud, Data Center Automation, Analytics for IT Operations, IT Service Management.RAMINDER RATHORE , an enthusiastic IT Practitioner with close to about two decades of work experience ranging from research and development to product management, to enabling organizations towards digitalization through agile ways of working. She currently leads the DevOps Centre of Excellence (CoE) at HCL Technologies, Canada.She holds a Master’s degree in Computer Science and is certified in a couple of areas on IBM Rational tools, Microsoft Azure, Scrum and ITIL methodologies. She started her career as a developer and progressed into product lifecycle management and consulting. She has been driving enterprise transformative programs on Automation (CI/CD), Cloud and DevOps for multiple customers. She has strong expertise in analyzing ecosystems, designing transformation roadmaps with milestones, building, and implementing accelerators / tools that drive end to end product traceability with agility and resiliency.UDITA AGRAWAL , an agile and automation transformation expert with over seventeen years of work experience, working with HCL Technologies. She holds a Master's degree in Business Administration in Information Technology and is also a PMP certified professional. She has wide experience in managing and leading engagements across different domains that includes Java, Data science and Automation. She is a passionate consultant running digital transformation programs for various customers. She also delivers enablement sessions on Agile and DevOps and works closely with product teams to practice agile methods. She also runs workshops on planning and implementing automated pipelines using various tools that includes COTS and open-source tools.Chapter 1: IntroductionCHAPTER GOAL: UNDERSTANDING THE AGILE JOURNEY AND THE NEED TO BRIDGE DEVELOPMENT AND OPERATIONS AREANO OF PAGES 17SUB -TOPICS1. Agile History2. Evolving software teams3. Bridging the gap4. Complementing Agile5. Agile in InfraOps6. Agile ManifestoChapter 2: Traditional Infrastructure OperationsCHAPTER GOAL: QUICK BRIEF ON TRADITIONAL ITSM APPROACH AND THE NEED TO TRANSITION TO AGILE OPERATIONS.No of pages: 20SUB - TOPICS1. ITSM and its phase2. Drawbacks3. Need to changeChapter 3: Agile and DevOpsCHAPTER GOAL: INTRODUCE CORE CONCEPTS TO AGILE AND DEVOPS AND UNDERSTAND ITS RELEVANCE IN THE PRODUCT LIFECYCLE.NO OF PAGES : 13SUB - TOPICS:1. When to adopt Agile2. Agile principles and values3. Scaling Agile with DevOps4. When to adopt DevOps5. DevOps in product lifecycleChapter 4: Factors leading to Agile OperationsCHAPTER GOAL: GET TO LEARN THE FACTORS THAT ARE MOTIVATING ORGANIZATIONS TO TRANSITION THEIR INFRASTRUCTURE OPERATIONS TO AGILE OPERATIONSNO OF PAGES: 29SUB - TOPICS:1.Shift towards Agile2.Benefits with Agility3.Cloud Computing4. Microservices5. Deployment patterns6. Shift left testing7. Changes in architectureChapter 5: Introduction to Agile MethodsCHAPTER GOAL: Introduce agile methods, roles, ceremonies and best practicesNO OF PAGES: 40SUB - TOPICS:1. Scrum2. Kanban3. ScrumbanChapter 6: Introduction to Agile FrameworksChapter Goal: INTRODUCE AGILE FRAMEWORKS, ROLES, AND STUDY THEIR COMPARISON.NO. OF PAGES : 47SUB - TOPICS:1. Agile ITSM2. IT4IT3. Lean IT4. SAFe5. Spotify6. LeSS7. Nexus8. DAD9. Site Reliability EngineeringChapter 7: Using Agile for Infrastructure OperationsCHAPTER GOAL:WITH THE BASIC UNDERSTANDING ON AGILE, THIS CHAPTER FOCUSES ON THE STRATEGY FOR ADOPTING AGILE IN INFRASTRUCTURE OPERATIONS SPACE.NO. OF PAGES : 22SUB - TOPICS:1. Adopting the right agile method2. Identify the right tools3. Upskill teams4. Redefine roles and responsibilities5. Continuously monitoring team performance6. Pilot-Expand-SustainChapter 8: Infrastructure as CodeCHAPTER GOAL:LEARN HOW TO LEVERAGE AGILE METHODS WHILE IMPLEMENTING INFRASTRUCTURE AS CODE PIPELINES AND EXTEND ITS INTEGRATION WITH DEVELOPMENT PIPELINES.NO. OF PAGES : 21SUB - TOPICS:1. Getting started with Scrum2. Estimating stories3. Defining acceptance criteria4. Integrating IaC with development pipelines5. IaC ExampleChapter 9: Success PathCHAPTER GOAL:THIS CHAPTER SHARES THE JOURNEY OF AN IMAGINARY COMPANY ON HOW THEY TRANSITION INTO AGILE OPS WITH A WELL-DEFINED TRANSFORMATION MAP AND MILESTONES.NO. OF PAGES : 7SUB - TOPICS:1. Enterprise Alpha2. New operating model3. OutcomesChapter 10: Learnings and Way forwardCHAPTER GOAL:AS ORGANIZATIONS ADOPT AGILE, THEY ALSO NEED TO PLAN FOR THE TRENDING TECHNOLOGIES THAT WILL BENEFIT THEM. THIS LAST CHAPTER SUMMARIZES THE LEARNINGS FROM THE EARLIER CHAPTERS AND SHARES UPCOMING TRENDS AND NEXT STEPS TO CONSIDER.NO. OF PAGES : 6SUB - TOPICS:1. Our Learnings2. Emerging Trends3. Next Steps