Knowhow
Bitcoin For Dummies
A PRIMER ON THE CURRENCY ALTERNATIVE THAT'S CHANGING THE WORLDBitcoin can be a bit puzzling to the uninitiated. Ledger? Blockchain? Mining? These cryptocurrency concepts aren't going away, and there are tremendous opportunities for those with some know-how to get onboard with the crypto culture. Bitcoin For Dummies helps you get un-puzzled, learn the Bitcoin basics, and discover the possibilities in the new world of digital currencies.With this 100% new edition, you can step into the fascinating culture of cryptocurrency and learn how to use Bitcoin as a currency or an investment vehicle. A little bit of knowledge will go a long way, and you’ll be ready to sail smoothly ahead as the crypto tsunami advances.* Demystify Bitcoin and learn how to buy and sell cryptocurrency* Create a digital wallet and make everyday purchases using Bitcoin* Discover the ins and outs of investing in Bitcoin and other up-and-coming cryptocurrencies* Participate in the cutting-edge culture of cryptoBitcoin For Dummies is great for beginning Bitcoin users and investors who need to know the basics about getting started with Bitcoin and cryptocurrency.PETER KENT is author of numerous technology titles as well as his own cryptocurrency video course, Get Crypto Clear: Bitcoin and Cryptocurrency Made Simple.TYLER BAIN is an engineer specializing in the electrical grid and keeping the lights on for all those Bitcoin miners, traders, and node runners. Peter and Tyler are also co-authors of Cryptocurrency Mining For Dummies.Preface xxxixAcknowledgments xliii1 BASIC OPTICAL CALCULATIONS 11.1 Introduction 11.2 Wave Propagation 21.3 CalculatingWave Propagation in Real Life 71.4 Detection 261.5 Coherent Detection 261.6 Interferometers 291.7 Photon Budgets and Operating Specifications 301.8 Signal Processing Strategy 362 SOURCES AND ILLUMINATORS 412.1 Introduction 412.2 The Spectrum 412.3 Radiometry 432.4 Continuum Sources 432.5 Interlude: Coherence 462.6 More Sources 502.7 Incoherent Line Sources 552.9 Lasers 572.10 Gas Lasers 592.11 Solid-State Lasers 592 Diode Lasers 612.13 Laser Noise 693 OPTICAL DETECTION 813.1 Introduction 813.2 Signal-to-Noise Ratios 823.3 Detector Figures of Merit 833.5 Photomultipliers 1003.6 Thermal Detectors 1143.7 Image Intensifiers 1153.9 How Do I Know Which Noise Source Dominates? 1243.10 Hacks 1294 LENSES, PRISMS, AND MIRRORS 1374.1 Introduction 1374.2 Optical Materials 1374.4 Surface Quality 1414.5 Windows 1424.6 Pathologies of Optical Elements 1434.7 Fringes 1434.8 Mirrors 1474.10 Prism Pathologies 1534.11 Lenses 1542 Complex Lenses 1583 Other Lenslike Devices 1625 COATINGS, FILTERS, AND SURFACE FINISHES 1655.1 Introduction 1655.2 Metal Mirrors 1655.4 Simple Coating Theory 1715.5 Moth-Eye Finishes 1795.6 Absorptive Filters 1805.7 Beam Dumps and Baffles 1825.8 White Surfaces and Diffusers 1866 POLARIZATION 1916.1 Introduction 1916.2 Polarization of Light 1916.3 Interaction of Polarization with Materials 1936.4 Absorption Polarizers 1976.5 Brewster Polarizers 1976.6 Birefringent Polarizers 1986.7 Double-Refraction Polarizers 1996.8 TIR Polarizers 2026.9 Retarders 2036.10 Polarization Control 2067 EXOTIC OPTICAL COMPONENTS 211Introduction 211Gratings 211Grating Pathologies 214Types of Gratings 215Resolution of Grating Instruments 218Fine Points of Gratings 219Holographic Optical Elements 222Photonic Crystals and Metamaterials 223Retroreflective Materials 2247.10 Scanners 2257.11 Modulators 2318 FIBEROPTICS2398.1 Introduction 2398.2 Fiber Characteristics 2398.3 Fiber Theory 2428.4 Fiber Types 2478.5 Other Fiber Properties 2518.6 Working with Fibers 2558.7 Fiber Devices 2608.8 Diode Lasers and Fiber Optics 2648.9 Fiber Optic Sensors 2648.10 Intensity Sensors 2658.11 Spectrally Encoded Sensors 2668.12 Polarimetric Sensors 2698.13 Fiber Interferometers 2708.14 Two-Beam Fiber Interferometers 2708.15 Multiple Beam Fiber Interferometers 2728.17 Multiplexing and Smart Structures 2768.18 Fiber Sensor Hype 2769 OPTICAL SYSTEMS 2799.1 Introduction 2799.2 What, Exactly, Does a Lens Do? 2799.3 Diffraction 2889.4 Aberrations 3009.5 Representing Aberrations 3039.6 Optical Design Advice 3069.7 Practical Applications 3089.8 Illuminators 31110 OPTICAL MEASUREMENTS 31510.1 Introduction 31510.2 Grass on the Empire State Building 31510.3 Detection Issues: When Exactly Is Background Bad? 3181 Measure the Right Thing 32210.5 Getting More Signal Photons 32410.6 Reducing the Background Fluctuations 32610.7 Optically Zero-Background Measurements 32810.8 Spectrally Resolved Measurements 32910.9 Electronically Zero-Background Measurements 33310.10 Labeling Signal Photons 33610.11 Closure 34111 DESIGNING ELECTRO-OPTICAL SYSTEMS 34311.1 Introduction 34311.2 Do You ReallyWant To Do This? 34311.3 Very Basic Marketing 35011.4 Classes of Measurement 35211.5 Technical Taste 35411.6 Instrument Design 35711.7 Guiding Principles 36111.8 Design for Alignment 36411.9 Turning a Prototype into a Product 36712 BUILDING OPTICAL SYSTEMS 37112.1 Introduction 37112.2 Construction Style 37112.3 Build What You Designed 37212.4 Assembling Lab Systems 37312.6 Collimating Beams 38112.7 Focusing 38312.8 Alignment and Testing 38512.9 Prototypes 38612.10 Aligning Beams with Other Beams 38712.11 Advanced Tweaking 39012.13 Adhesives 39712.14 Cleaning 40012.15 Environmental Considerations 40213 SIGNAL PROCESSING 40513.1 Introduction 40513.2 Analog Signal Processing Theory 40613.4 Amplifiers 41613.5 Departures From Linearity 41613.6 Noise and Interference 42013.7 Frequency Conversion 43513.8 Filtering 43813.9 Signal Detection 44713.10 Reducing Interference and Noise 45013.11 Data Acquisition and Control 45214 ELECTRONIC BUILDING BLOCKS 45714.1 Introduction 45714.2 Resistors 45714.3 Capacitors 46014.4 Transmission Lines 47014.5 Transmission Line Devices 47614.6 Diodes 47714.7 Bipolar Junction Transistors 47914.8 Field-Effect Transistors (FETs) 48614.9 Heterojunction FETs 48714.10 Signal Processing Components 48814.11 Digitizers 49614.12 Analog Behavior of Digital Circuits 50515 ELECTRONIC SUBSYSTEM DESIGN 50715.1 Introduction 50715.2 Design Approaches 50715.3 Perfection 51415.4 Feedback Loops 51615.5 Local Feedback 52215.6 Signal Detectors 52215.7 Phase-Locked Loops 53015.8 Calibration 53515.9 Filters 53715.10 Other Stuff 54015.11 More Advanced Feedback Techniques 54215.12 Hints 54415.13 Linearizing 54515.17 Bulletproofing 55315.18 Interference 55715.19 Reliable Designs 55816 ELECTRONIC CONSTRUCTION TECHNIQUES 55916.1 Introduction 55916.2 Circuit Strays 55916.3 Circuit Boards 56016.4 Stray Coupling 56316.5 Ground Plane Construction 56316.6 Technical Noise and Interference 56616.7 Product Construction 57216.8 Getting Ready 57416.9 Prototyping 57616.10 Surface Mount Prototypes 58216.11 Prototyping Filters 58516.12 Tuning, or, You Can’t Hit What You Can’t See 58717 DIGITAL SIGNAL PROCESSING 59117.1 Introduction 59117.2 Elementary Operations 59217.3 Dead Time Correction 59517.4 Fourier Domain Techniques 59517.5 The Fast Fourier Transform 60217.6 Power Spectrum Estimation 60817.7 Digital Filtering 61217.8 Deconvolution 61517.9 Resampling 61717.10 Fixing Space-Variant Instrument Functions 61817.11 Finite Precision Effects 61917.12 Pulling Data Out of Noise 62018 FRONT ENDS 62718.1 Introduction 62718.2 Photodiode Front Ends 62818.3 Key Idea: Reduce the Swing Across Cd 63018.4 Transimpedance Amplifiers 63118.5 External Input Stages 63518.6 How to Go Faster 64818.7 Advanced Photodiode Front Ends 65218.8 Other Types of Front End 65818.9 Hints 66019 BRINGING UP THE SYSTEM 66519.1 Introduction 66519.2 Avoiding Catastrophe 66719.3 Debugging and Troubleshooting 67019.4 Getting Ready 67119.5 Indispensable Equipment 67319.6 Debugging Pickup and Interference Problems 67619.6.1 Test Setups 67619.7 Digital Troubleshooting 67719.8 Analog Electronic Troubleshooting 67819.9 Oscillations 68119.10 Other Common Problems 68319.11 Debugging and Troubleshooting Optical Subsystems 68519.12 Localizing the Problem 68820 THERMAL CONTROL 69520.1 Introduction 69520.2 Thermal Problems and Solutions 69620.3 Heat Flow 69920.4 Insulation 70520.7 Heat Sinks 71623 Local Feedback Loops 72320.9 Temperature Controllers 725APPENDIX A GOOD BOOKS 735A.1 Why Books? 735A.2 Good Books for Instrument Builders 735Notation 743Physical Constants and Rules of Thumb 745Index 747
Excel Dashboards & Reports For Dummies
IT’S TIME FOR SOME TRULY “EXCEL-LENT” SPREADSHEET REPORTINGBeneath the seemingly endless rows and columns of cells, the latest version of Microsoft Excel boasts an astonishing variety of features and capabilities. But how do you go about tapping into some of that power without spending all of your days becoming a spreadsheet guru? It’s easy. You grab a copy of the newest edition of Excel Dashboards & Reports For Dummies and get ready to blow the pants off your next presentation audience! With this book, you’ll learn how to transform those rows and columns of data into dynamic reports, dashboards, and visualizations. You’ll draw powerful new insights from your company’s numbers to share with your colleagues – and seem like the smartest person in the room while you’re doing it. Excel Dashboards & Reports For Dummies offers:* Complete coverage of the latest version of Microsoft Excel provided in the Microsoft 365 subscription* Strategies to automate your reporting so you don’t have to manually crunch the numbers every week, month, quarter, or year* Ways to get new perspectives on old data, visualizing it so you can find solutions no one else has seen beforeIf you’re ready to make your company’s numbers and spreadsheets dance, it’s time to get the book that’ll have them moving to your tune in no time. Get Excel Dashboards & Reports For Dummies today. MICHAEL ALEXANDER is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community.INTRODUCTION 1About This Book 2Foolish Assumptions 4Icons Used in This Book 4Beyond the Book 4Where to Go from Here 5PART 1: GETTING STARTED WITH EXCEL DASHBOARDS AND REPORTS 7CHAPTER 1: GETTING IN THE DASHBOARD STATE OF MIND 9Defining Dashboards and Reports 10Defining reports 10Defining dashboards 11Preparing for Greatness 12Establish the audience for, and purpose of, the dashboard 12Delineate the measures for the dashboard 13Catalog the required data sources 14Define the dimensions and filters for the dashboard 15Determine the need for drill-down features 16Establish the refresh schedule 16A Quick Look at Dashboard Design Principles 16Rule number 1: Keep it simple 17Use layout and placement to draw focus 19Format numbers effectively 20Use titles and labels effectively 20CHAPTER 2: BUILDING A SUPER MODEL 23Data Modeling Best Practices 24Separating data, analysis, and presentation 24Starting with appropriately structured data 27Avoiding turning your data model into a database 30Using tabs to document and organize your data model 31Testing your data model before building reporting components on top of it 33Excel Functions That Really Deliver 34The VLOOKUP function 34The HLOOKUP function 38The SUMPRODUCT function 40The CHOOSE function 43Using Smart Tables That Expand with Data 45Converting a range to an Excel table 46Converting an Excel table back to a range 49Introducing Dynamic Arrays 49Getting the basics of dynamic arrays 49Understanding spill ranges 51Referencing spill ranges 53Exploring Dynamic Array Functions 54The SORT function 55The SORTBY function 56The UNIQUE function 57The FILTER function 58The XLOOKUP function 61CHAPTER 3: THE PIVOTAL PIVOT TABLE 65An Introduction to the Pivot Table 65The Four Areas of a Pivot Table 66Values area 66Row area 67Column area 67Filter area 68Creating Your First Pivot Table 69Changing and rearranging your pivot table 72Adding a report filter 73Keeping your pivot table fresh 74Customizing Pivot Table Reports 76Changing the pivot table layout 76Customizing field names 78Applying numeric formats to data fields 79Changing summary calculations 80Suppressing subtotals 81Showing and hiding data items 84Hiding or showing items without data 86Sorting your pivot table 88Creating Useful Pivot-Driven Views 89Producing top and bottom views 89Creating views by month, quarter, and year 93Creating a percent distribution view 95Creating a month-over-month variance view 97CHAPTER 4: USING EXTERNAL DATA FOR YOUR DASHBOARDS AND REPORTS 101Leveraging Power Query to Extract and Transform Data 102Reviewing Power Query basics 102Understanding query steps 109Importing Data from Files 111Getting data from Excel workbooks 111Getting data from CSV and text files 113Importing Data from Database Systems 114Importing data from Microsoft Access 114Managing data source settings 116PART 2: BUILDING BASIC DASHBOARD COMPONENTS 119CHAPTER 5: DRESSING UP YOUR DATA TABLES 121Table Design Principles 122Use colors sparingly 122De-emphasize borders 123Use effective number formatting 126Subdue your labels and headers 127Getting Fancy with Custom Number Formatting 129Number formatting basics 129Formatting numbers in thousands and millions 132Hiding and suppressing zeroes 134Applying custom format colors 135Formatting dates and times 136CHAPTER 6: SPARKING INSPIRATION WITH SPARKLINES 139Introducing Sparklines 139Understanding Sparklines 141Creating sparklines 142Understanding sparkline groups 144Customizing Sparklines 145Sizing and merging sparkline cells 145Handling hidden or missing data 146Changing the sparkline type 147Changing sparkline colors and line width 147Using color to emphasize key data points 147Adjusting sparkline axis scaling 148Faking a reference line 149Specifying a date axis 151Autoupdating sparkline ranges 152CHAPTER 7: FORMATTING YOUR WAY TO VISUALIZATIONS 153Enhancing Reports with Conditional Formatting 154Applying basic conditional formatting 154Adding your own formatting rules manually 162Showing only one icon 166Showing Data Bars and icons outside of cells 169Representing trends with Icon Sets 171Using Symbols to Enhance Reporting 173Wielding the Magical Camera Tool 176Finding the Camera tool 176Using the Camera tool 177Enhancing a dashboard with the Camera tool 179Enhancing Excel Reports with Shapes 180Creating visually appealing containers with shapes 180Layering shapes to save space 182Constructing your own infographic widgets with shapes 182PART 3: ADDING CHARTS TO YOUR DASHBOARDS 185CHAPTER 8: CHARTS THAT SHOW TRENDING 187Trending Dos and Don’ts 188Using chart types appropriate for trending 188Starting the vertical scale at zero 190Leveraging Excel’s logarithmic scale 192Applying creative label management 193Comparative Trending 196Creating side-by-side time comparisons 196Creating stacked time comparisons 198Trending with a secondary axis 199Emphasizing Periods of Time 202Formatting specific periods 202Using dividers to mark significant events 203Representing forecasts in your trending components 204Other Trending Techniques 206Avoiding overload with directional trending 206Smoothing data 207CHAPTER 9: GROUPING AND BUCKETING DATA 211Creating Top and Bottom Displays 211Incorporating top and bottom displays into dashboards 212Using pivot tables to get top and bottom views 213Top Values in Charts 216Using Histograms to Track Relationships and Frequency 220Using Excel’s Histogram statistical chart 220Creating a formula-driven histogram 223Adding a cumulative percent 226Using a pivot table to create a histogram 228CHAPTER 10: DISPLAYING PERFORMANCE AGAINST A TARGET 231Showing Performance with Variances 231Showing Performance against Organizational Trends 233Using a Thermometer-Style Chart 234Using a Bullet Graph 235Creating a bullet graph 236Adding data to your bullet graph 239Final thoughts on formatting bullet graphs 241Showing Performance against a Target Range 243PART 4: ADVANCED REPORTING TECHNIQUES 247CHAPTER 11: GIVING USERS AN INTERACTIVE INTERFACE 249Introducing Macros 249Why use a macro? 250Recording your first macro 251Running your macros 254Enabling and trusting macros 257Understanding macro-enabled file extensions 258Enabling macro content 258Setting up trusted locations 258Examining some macro examples 259Building navigation buttons 260Dynamically rearranging pivot table data 261Offering one-touch reporting options 262Getting Started with Form Controls 263Finding Form controls 263Adding a control to a worksheet 264Using the Button Control 266Using the Check Box Control 266Toggling a Chart Series On and Off 268Using the Option Button Control 270Showing Many Views through One Chart 272Using the Combo Box Control 274Changing Chart Data with a Drop-Down Selector 275Using the List Box Control 277Controlling Multiple Charts with One Selector 279CHAPTER 12: ADDING INTERACTIVITY WITH PIVOT SLICERS 283Understanding Slicers 283Creating a Standard Slicer 286Getting Fancy with Slicer Customizations 288Size and placement 288Data item columns 288Other slicer settings 289Creating your own slicer style 289Controlling Multiple Pivot Tables with One Slicer 293Creating a Timeline Slicer 294Using Slicers as Form Controls 296Using Slicers on Excel Table Objects 300CHAPTER 13: SHARING YOUR WORKBOOK WITH THE OUTSIDE WORLD 303Protecting Your Dashboards and Reports 303Securing access to the entire workbook 304Limiting access to specific worksheet ranges 307Protecting the workbook structure 310Linking Your Excel Dashboards to PowerPoint 311Creating a link between Excel and PowerPoint 312Manually updating links to capture updates 313Turning off automatic updating of links 314Distributing Your Dashboards via a PDF 316Distributing Your Dashboards to OneDrive 318Limitations When Publishing to the Web 321PART 5: THE PART OF TENS 323CHAPTER 14: TEN CHART DESIGN PRINCIPLES 325Avoid Fancy Formatting 325Skip the Unnecessary Chart Junk 327Format Large Numbers Where Possible 329Use Data Tables Instead of Data Labels 330Make Effective Use of Chart Titles 332Sort Your Data before Charting 333Limit the Use of Pie Charts 333Don’t Be Afraid to Parse Data into Separate Charts 334Maintain Appropriate Aspect Ratios 336Don’t Be Afraid to Use Something Other Than a Chart 337CHAPTER 15: TEN QUESTIONS TO ASK BEFORE DISTRIBUTING YOUR DASHBOARD 339Does My Dashboard Present the Right Information? 339Does Everything on My Dashboard Have a Purpose? 340Does My Dashboard Prominently Display the Key Message? 340Can I Maintain This Dashboard? 341Does My Dashboard Clearly Display Its Scope and Shelf Life? 341Is My Dashboard Well Documented? 341Is My Dashboard Overwhelmed with Formatting and Graphics? 342Does My Dashboard Overuse Charts When Tables Will Do? 343Is My Dashboard User-Friendly? 343Is My Dashboard Accurate? 344Index 345
Microsoft Project Fundamentals
GET A FIRM GRIP ON ONE OF THE MOST POPULAR PROJECT MANAGEMENT APPLICATIONS ON THE MARKET TODAYIn Microsoft Project Fundamentals: Microsoft Project Standard 2021, Professional 2021, and Project Online Editions, accomplished project management leader Teresa Stover delivers a hands-on introduction to Microsoft’s popular project management software filled with real-world examples and plain-language guidance. The book walks you through how to plan, schedule, manage resources, track progress, and more. In the book, you’ll:* Learn principles and best practices of project management while mastering Microsoft Project capabilities, calculations, and views* Understand how task durations, dependencies, and date constraints power the project schedule* Manage human, equipment, and material resources, including availability, cost, and task assignments* Adjust the project to optimize for the project finish date, budget, and resource allocation* Use Microsoft Project to manage waterfall or agile projectsIdeal for anyone seeking to unlock the potential of Microsoft’s leading project management software for their own project work, Microsoft Project Fundamentals is an essential resource for those new to Microsoft Project and project management, as well as previous users and seasoned project professionals looking for a refresher in the latest features of the newest version of Microsoft Project. TERESA S. STOVER is a project management consultant and award-winning author of 15 books. She has consulted with the Microsoft Project team since version 4 and has served as the project manager for projects ranging from online help system development and instructional design to needs assessments and content management.Introduction xivPART I: MANAGE YOUR PROJECTS WITH MICROSOFT PROJECT 1LESSON 1: PROJECT MANAGEMENT BASICS 3Projects and Project Managers 4What Is a Project? 4What Is a Project Manager? 5The Project Triangle 6Project Processes 7Initiating 7Planning 7Executing 8Monitoring and Controlling 8Closing 8Project Management Methodologies 9Waterfall Project Management 9Agile Project Management 10Other Methodologies 10More About Project Management 11Key Terms 11Review Questions 13LESSON 2: INTRODUCING MICROSOFT PROJECT 17How Microsoft Project Helps 18Manage the Schedule 18Calculate Costs 19Balance Resources 20Communicate Progress 21Respond to Changes 21Microsoft Project Solutions 22Touring the Microsoft Project App 24Browse Task and Resource Views 25Browse Reports 26Click Through the Ribbons 26Go Backstage 27Get Help with Project 29Help Within Project 29Help Outside Project 31Key Terms 32Review Questions 33PART II: PLAN YOUR PROJECT 35LESSON 3: ESTABLISH A STRONG FOUNDATION 37Initiate the Project 38Identify the Stakeholders and Project Sponsor 39Authorize the Project Charter 39Start Planning 40Collect Requirements 41Define the Scope 42Organize Project Plan Documents 43Key Terms 45Review Questions 46LESSON 4: SET UP THE PROJECT AND TASKS 47Start a New Project Plan 48Create a New Blank Project 48Copy an Existing Similar Project 49Adapt a Project Template 50Set the Project Start Date 51Enter Task Names 53Where Do Task Names Come From? 54Name Your Tasks 55Explore Task Views 56Work with Tasks in the Task Sheet 57Work with Tasks on the Task Board 60Sequence Tasks 62Reorder Tasks in the Task Sheet 62Reorder Tasks on the Task Board 63Organize the Task Outline 63Key Terms 67Review Questions 68LESSON 5: BUILD THE SCHEDULE 69Decide on Automatic Scheduling 70Change All Tasks to Automatic Scheduling 71Set Any New Tasks to Automatic Scheduling 72Switch from Automatic to Manual Scheduling 72Switch from Manual to Automatic Scheduling 72Get to Know the Gantt Chart 73Enter Task Durations 75Enter Durations in the Gantt Chart 76View Durations on the Task Board 77Set Milestones 79Link Dependent Tasks 80Set Up Task Dependencies 81View Dependencies on a Task Board 82Schedule Sprints for an Agile Project 83Add Sprints to Your Project 84Add Tasks to Your Sprints 85Modify Sprint Information 86Identify Any Hardwired Dates 87Enter Deadline Reminders 89Use Project and Task Calendars 90Review and Change the Project Calendar 91Apply a Task Calendar 91Key Terms 92Review Questions 93LESSON 6: SET UP RESOURCES 97Add Resources to the Plan 98Define Human and Equipment Resources 99Define Material Resources 99Define Cost Resources 100Enter Resource Costs 101Specify Work Resource Costs 102Specify Material Resource Costs 103Specify Cost Resource Costs 103Refine Resource Unit Availability 104Change Resource Units 105Specify Differing Availability Over Time 105Customize Resource Calendars 106Switch the Base Calendar 108Change the Work Week in a Resource Calendar 108Specify an Exception to a Resource Calendar 110Key Terms 112Review Questions 113LESSON 7: ASSIGN RESOURCES TO TASKS 115Assign Work Resources to Tasks 116Assign Material Resources to Tasks 118Assign Cost Resources to Tasks 120Review Resource Assignments 122See Task Costs from Assignments 125Review Task Costs 126Review Task Costs on an Agile Planning Board 127Review the Overall Project Cost Estimate 127Change Assignments 128Replace a Resource Assignment 129Add or Remove a Resource Assignment 129Change Duration on Tasks with Assignments 132Key Terms 133Review Questions 134LESSON 8: CHECK AND ADJUST THE PROJECT 137Check the Project Finish Date 138Review the Project Finish Date 139Bring In the Project Finish Date 142Check Costs 145Review the Total Project Cost 145Reduce Costs 146Check Resource Assignments 153Resolve Overallocations in a Task Sheet 154Resolve Assignment Problems in Team Planner 155Set the Project Baseline 157Key Terms 159Review Questions 161PART III: MONITOR AND CONTROL YOUR PROJECT 163LESSON 9: TRACK PROJECT INFORMATION 165Collect Progress Information 167Enter Actuals in a Waterfall Project 168Enter Progress as Expected 168Enter Different Types of Progress Information 169Distinguish Baseline, Scheduled, and Actual Values 170Update Status in an Agile Project 172Enter Progress on the Task Board 172Enter Progress in the Task Board Sheet 173Specify Percent Complete on the Task Board 174Enter Progress on the Current Sprint 176Move Tasks from One Sprint to Another 177Respond to Changes 178Check the Project Finish Date 178Check the Project Cost 179Check Resource Allocations 179Key Terms 180Review Questions 181LESSON 10: VIEW PROJECT INFORMATION 183See the Data You Need 184Zoom a View In or Out 184Adjust the Timescale 185Show a Specific Outline Level 186Sort Project Information 187Group Project Information 188Filter Project Information 188Highlight Project Information 189Change Columns in a Sheet View 190Add a Column 190Move a Column 192Hide a Column 192Print a View 193Work with More Views 194Browse Graphical Views 195Browse Combination Views 199Key Terms 202Review Questions 204LESSON 11: CUSTOMIZE PROJECT INFORMATION 207Customize a Sheet View 208Customize a Gantt View 210Customize a Board View 212Modify Board View Columns 212Modify Task Cards 213Set Options and Preferences 214Key Terms 215Review Questions 216LESSON 12: REPORT PROJECT INFORMATION 219Work with Reports 220Run a Report 221Adjust the Design of a Report 222Work with Dashboards 223Create a New Report or Dashboard 224Print a Report 226Key Terms 228Review Questions 229PART IV: CLOSE YOUR PROJECT 231LESSON 13: OBTAIN PROJECT ACCEPTANCE 233Present the Project to the Sponsor 234Secure Official Project Sign-Off 236Complete Final Refinements 236Have the Sponsor Sign Off on the Project 238Celebrate With Your Team 238Key Terms 239Review Questions 240LESSON 14: RETAIN PROJECT HISTORY 241Document Lessons Learned 242Identify the Information You Can Use 243Gather Lessons Learned 243Document and Share the Lessons Learned 244Archive Project History 245Clean Up Your Project Plan 245Add Key Documents to the Project Plan 247Organize the Archive File Structure 247Key Terms 248Review Questions 249Appendix Answers to the Review Questions 251Index 263
Praxiswissen Joomla! 4 - Das Kompendium
Das bewährte Standardwerk zu Joomla! jetzt aktualisiert auf Version 4Sie möchten Schritt für Schritt und ohne langwieriges Ausprobieren eine eigene Website mit Joomla! aufsetzen? Dann ist dieser praxisorientierte Leitfaden zur Joomla!-Version 4 genau das Richtige für Sie. Tim Schürmann führt Sie anhand eines Beispielprojekts in den Aufbau und die Pflege eines Webauftritts ein und behandelt dabei das komplette Joomla!-Themenspektrum von den Grundlagen bis hin zum Profiwissen. Sie erfahren, wie Sie Joomla! installieren, Bilder und Texte verwalten, Ihrer Webpräsenz mit Templates ein unverwechselbares Look-and-feel geben und Ihre Website um zusätzliche Funktionen wie einen Kalender, Kommentarmöglichkeiten oder eine eigene Erweiterung ergänzen. Kapitel zu Suchmaschinenoptimierung, Barrierefreiheit und Datenbankpflege runden das Handbuch ab. Es deckt umfassend die in Joomla! enthaltenen Funktionen ab und eignet sich daher sowohl als Einstieg als auch als Nachschlagewerk.Zielgruppe: Webentwickler*innenalle, die mit Joomla! eine eigene Webpräsenz aufbauen möchtenAutor: Tim Schürmann ist selbständiger Diplom-Informatiker und derzeit hauptsächlich als freier Autor unterwegs. Seine zahlreichen Artikel erscheinen in führenden Zeitschriften und wurden in mehrere Sprachen übersetzt. Er hat bereits einige erfolgreiche Bücher geschrieben, darunter mehrere Auflagen von Praxiswissen Joomla! oder WordPress komplett – Das Kompendium für Websites und Blogs (O’Reilly Verlag). Die Entwicklung von Joomla! verfolgt er nicht nur seit dessen Anfängen, er folterte das Content-Management-System selbstverständlich auch schon in der Praxis mit schwer verdaulichen Inhalten. Seine Steckenpferde sind die Programmierung, Algorithmen, freie Software, Computergeschichte, Schokoladeneis und der ganz alltägliche Wahnsinn.
Access für Einsteiger - für die Versionen 2021, 2019, 2016, 2013 & Microsoft 365
Für die Versionen 2021, 2019, 2016, 2013, 2010 & Microsoft 365.- Von der Planung bis zur fertigen Datenbank- Abfrage- und Auswertungstechniken- Formulare und Berichte- Mit praxisnahen Tipps und Beispielen zum DownloadLernen Sie Access von Grund auf verstehen und sicher nutzen! Leicht nachvollziehbare Anleitungen und anschauliche Beispiele helfen Ihnen dabei, Datenbanken anzupassen sowie selbst neu zu konzipieren. Systematisch erläutert die Autorin den Entwurf einer Tabelle und das Erstellen von Beziehungen zwischen Tabellen. Sie zeigt Ihnen, wie Sie Daten eingeben und verschiedene Abfragetechniken anwenden. Erfahren Sie, wie Sie mit Formularen, Steuerelementen und Makros eine benutzerfreundliche Oberfläche gestalten und professionelle Berichte drucken. Als Übungsbeispiel erstellen Sie selbst eine Datenbank zur Verwaltung von Kunden und erfassen deren Bestellungen. Mit Aufgaben am Ende jedes einzelnen Kapitels können Sie das Gelernte verinnerlichen und praktisch umsetzen.Profitieren Sie von Inge Baumeisters Know-how sowie ihrer langjährigen Erfahrung als Dozentin in der Erwachsenenbildung und werden Sie Schritt für Schritt zum Access-Könner!Aus dem Inhalt:- Aufbau und Planung einer Datenbank - Tabellen und Beziehungen- Tabellenentwurf und Datentypen- Daten eingeben, filtern und sortieren- Abfragetechniken und eine kleine Einführung in SQL- Formulare zur komfortablen Benutzerführung gestalten- Professionelle Berichte drucken- Steuerelemente einsetzen- Makros erstellen und nutzen- Datenimport und -export- Dokumentation und Wartung von Datenbanken
Salesforce Platform Governance Method
Accelerate your Salesforce implementation to provide benefits to your business more rapidly while maintaining control and improving quality.Salesforce has become one of the most influential business tools in our modern age. What started as the world's most comprehensive customer relationship management (CRM) system available in the market place has now morphed over the years into an ecosystem of tools and services that enable you to run your entire business platform.This book gives you a method (a set of governance processes) that provides a complete view of how to govern and manage any Salesforce implementation. It breaks the architectural components of the Salesforce platform into manageable sections, allowing you to navigate and understand how to govern your Salesforce implementation in a consistent manner with an approach that is structured, repeatable, and clearly defined.Salesforce Platform Governance Method is divided into nine distinct phases which have been chosen based on how the Salesforce platform is architected. This is relevant today because every organization that implements Salesforce will face the same issues around governance, integration, development, and security and the majority of organizations will find, through trial and error, a solution to govern these components. This book will help Salesforce professionals and enterprise organizations as well as small and mid-sized businesses (SMBs) navigate these topics and ultimately have a successful and fully integrated, secure Salesforce implementation.WHAT YOU WILL LEARN* Govern the application architecture on the Salesforce platform, including general architecture, localization and global deployments, workflow and process, formulas and files, and social* Govern the data architecture, including design and data optimization, performance, predictive and actual data volumes, and data movement* Govern the identity and access management aspects of the application and Salesforce platform* Govern the low-level platform capabilities delivered through Lightning, Visualforce, and Apex* Handle community implementations that bring specific features into the Salesforce platform for consideration and governance* Create checklists for the governance steps, laid out in the method, and for any tooling recommendations that can help simplify the process of governanceWHO THIS BOOK IS FORPeople responsible for maintaining a Salesforce SaaS instance or developing changes for that Salesforce instance. Readers should have a basic understanding of the Salesforce platform and a desire to introduce a level of control around the changes being made, reduce issues on their Salesforce instance, and improve quality while increasing the throughput of changes they want to introduce into the platform.LEE HARDING, formerly a Senior Program Architect at Salesforce, is the Technology Director at Harwoods Group, a large automotive retail company in the United Kingdom. Harwoods are using Salesforce's technology at the heart of their digital transformation and considers it a key enabler for their business in the future. Over the past 35 years in IT, Lee has used his skills and experience to help large and small enterprises deliver their business transformations. Lee has handled big transformational programs, involving tens of thousands of users and has helped customers get the most out of their investment in the Salesforce Cloud technologies. Using his experience in large-scale transformation projects Lee has helped many businesses accelerate their implementations and see the benefits sooner, rather than later. Having a broad knowledge base and a keen interest in technology and its governance, Lee has been able to help customers navigate the pros and cons of technology decisions and keeps an open mind as to how technology can benefit his customers at the earliest opportunity, while instilling the right processes to help his customers be successful.LEE BAYLISS, a Senior Program Architect at Salesforce, has worked in the IT industry for over 25 years and has held various positions in operations, engineering, product design, technical leadership, and various lead architect positions for large service providers such as DXC (formerly, EDS/HPES). During Lee’s extensive career in IT, he has worked across many industry sectors, including manufacturing, oil exploration, financial services, and health life sciences. Working with various enterprise businesses, Lee has amassed a wealth of experience delivering IT solutions ranging from lightweight projects to large scale business transformations. For the last 3 years, Lee has been working for Salesforce, a company which is diverse in nature, focused on customer success. Salesforce has created a huge ecosystem of products and services that can propel SME businesses to become trailblazers in their field. At Salesforce, Lee finds himself in a unique position providing guidance on all of the things that large (and small) organizations struggle with—how to implement the Salesforce platform and its components successfully, how to control all the moving parts, and how to drive value throughout the business in a world where digital transformation is a success imperative.CHAPTER 1: THE SALESFORCE LIGHTNING PLATFORM GOVERNANCE METHODThe content of this Chapter introduces the reader to the concepts of governance and how they need to construct their teams and processes to facilitate governance within their organisation. Additionally, the structure of our governance method is described, which sets the structure for the remainder of the book. The book is essentially split into two sections. The first section is the governance method, whilst the second section is the resources needed to perform the governance.Resource BaseKey PointsBasic StructureAdapting the SLPGMArchitecture GovernanceProcess ManagementScoping the Application Governance CyclePlatform TeamCHAPTER 2: APPLICATION ARCHITECTURE (PHASE A)Describes the method by which the application architecture is governed on the Salesforce platform. Areas covered are general architecture, localisation and global deployments, workflow and process, formulas and files and social.ObjectivesApproachInputsStepsOutputsCHAPTER 3: DATA ARCHITECTURE (PHASE B)Describes the method by which the data architecture is governed. Areas covered are design and data optimization, performance, predictive and actual data volumes and data movement.ObjectivesApproachInputsStepsOutputsCHAPTER 4: IDENTITY & ACCESS MANAGEMENT (PHASE C)This Chapter will focus on the governance of the identity and access management aspects of the application and Salesforce platform. These will form part of the technical standards and policies, but it is possible for an application to seek changes to these. For example, A Connected App (external to Salesforce) may be required that can only support a specific authentication solution, which is not part of the technical standards.ObjectivesApproachInputsStepsOutputsCHAPTER 5: SHARING & VISIBILITY (PHASE D)The Salesforce platform is very flexible and as such allows a “developer” to create applications with very little development experience. Obviously the more experience the developer, the more comprehensive the application can be. Salesforce has specifically focused on the ability to create applications and change configuration through “clicks”, negating in the majority of cases the need to actually write “code”. Creating applications and changing configuration via “clicks” is known as Declarative and the Salesforce platform has provided a significant amount of functionality and tailoring capability just through the declarative route. Declarative changes are stored in the metadata of the Org, and as such can be extracted (there are some limitations) and therefore analysed and governed. The approach to this phase is to describe how to take those declarative changes and assess them against the technical standards and policies.ObjectivesApproachInputsStepsOutputsCHAPTER 6: INTEGRATION (PHASE E)Salesforce provides numerous solutions to integration and the right solution will very much depend upon what the requirements are that underpin the integration. However, fundamentally this phase is looking to compare the integration techniques that are part of the technical standards and policies with those that have been used. Then, determine those that have been used, have they been used correctly.ObjectivesApproachInputsStepsOutputsCHAPTER 7: APEX, VISUALFORCE & LIGHTNING (PHASE F)On a shared platform, it is important that every developer takes maximum advantage of the platform to reduce the impact their application has on the overall platform. The phase focuses on governing the low-level platform capabilities delivered through Lightning, Visualforce and Apex.ObjectivesApproachInputsStepsOutputsCHAPTER 8: COMMUNITIES (PHASE G)This phase targets Community implementations specifically, which bring specific features into the Salesforce platform for consideration and governance. As Communities can target Customers, Employees and Partners it is important that any data held within the core Salesforce instance from which the Community is delivered is secured. Therefore, Communities brings about specific sharing capabilities and other considerations that should be reviewed.ObjectivesApproachInputsStepsOutputsCHAPTER 9: MOBILE SOLUTIONS (PHASE H)This phase targets the governance of deploying Salesforce to a mobile device. This will include the configuration and source code, any customization used and security implications.ObjectivesApproachInputsStepsOutputsCHAPTER 10: DEVELOPMENT LIFECYCLE & DEPLOYMENT (PHASE I)The development lifecycle will be well defined in terms of the environments and tooling and the “route to live” that an application will take. The purpose of this phase is to have a means of governing this. In the main, this should not change regularly, but within the enterprise it is not unimaginable that additional Salesforce instances may arise, or that external parties are engaged. In these scenarios, the organization will want to determine whether these situations are adhering to the standards.ObjectivesApproachInputsStepsOutputsCHAPTER 11: RESOURCE BASEThe Resource Base provides the reference material for all of the governance phases. This material is distilled to provide distinct references against which governance is simplified. Additionally, the Resource Base will form the basis for the documentation to support the development within the Salesforce platform. The purpose being, the reference material informs the developers on how to develop, as well as providing a reference to which governance can be performed. The subsequent Chapters within the Resource Base section have a consistent layout, which details the guidelines and best practices from Salesforce as well as a checklist to facilitate the governance process. In addition, any tooling that could be used to help accelerate the governance process is highlighted.OverviewCHAPTER 12: APPLICATION ARCHITECTURE (PHASE A) RESOURCE BASEGuidelines and best practices from Salesforce. Checklist for the governance steps laid out in the method and any tooling recommendations that can help simplify the process of governance.Guidelines & Best PracticesStandardsChecklistsToolingCHAPTER 13: DATA ARCHITECTURE (PHASE B) RESOURCE BASEGuidelines and best practices from Salesforce. Checklist for the governance steps laid out in the method and any tooling recommendations that can help simplify the process of governance.Guidelines & Best PracticesStandardsChecklistsToolingCHAPTER 14: IDENTITY & ACCESS MANAGEMENT (PHASE C) RESOURCE BASEGuidelines and best practices from Salesforce. Checklist for the governance steps laid out in the method and any tooling recommendations that can help simplify the process of governance.Guidelines & Best PracticesStandardsChecklistsToolingCHAPTER 15: SHARING & VISIBILITY (PHASE D) RESOURCE BASEGuidelines and best practices from Salesforce. Checklist for the governance steps laid out in the method and any tooling recommendations that can help simplify the process of governance.Guidelines & Best PracticesStandardsChecklistsToolingCHAPTER 16: INTEGRATION (PHASE E) RESOURCE BASEGuidelines and best practices from Salesforce. Checklist for the governance steps laid out in the method and any tooling recommendations that can help simplify the process of governance.Guidelines & Best PracticesStandardsChecklistsToolingCHAPTER 17: APEX, VISUALFORCE & LIGHTNING (PHASE F) RESOURCE BASEGuidelines and best practices from Salesforce. Checklist for the governance steps laid out in the method and any tooling recommendations that can help simplify the process of governance.Guidelines & Best PracticesStandardsChecklistsToolingCHAPTER 18: COMMUNITIES (PHASE G) RESOURCE BASEGuidelines and best practices from Salesforce. Checklist for the governance steps laid out in the method and any tooling recommendations that can help simplify the process of governance.Guidelines & Best PracticesStandardsChecklistsToolingCHAPTER 19: MOBILE SOLUTIONS (PHASE H) RESOURCE BASEGuidelines and best practices from Salesforce. Checklist for the governance steps laid out in the method and any tooling recommendations that can help simplify the process of governance.Guidelines & Best PracticesStandardsChecklistsToolingCHAPTER 20: DEVELOPMENT LIFECYCLE & DEPLOYMENT (PHASE I) RESOURCE BASEGuidelines and best practices from Salesforce. Checklist for the governance steps laid out in the method and any tooling recommendations that can help simplify the process of governance.Guidelines & Best PracticesStandardsChecklistsTooling
Machine Learning for Auditors
Use artificial intelligence (AI) techniques to build tools for auditing your organization. This is a practical book with implementation recipes that demystify AI, ML, and data science and their roles as applied to auditing. You will learn about data analysis techniques that will help you gain insights into your data and become a better data storyteller. The guidance in this book around applying artificial intelligence in support of audit investigations helps you gain credibility and trust with your internal and external clients. A systematic process to verify your findings is also discussed to ensure the accuracy of your findings.MACHINE LEARNING FOR AUDITORS provides an emphasis on domain knowledge over complex data science know how that enables you to think like a data scientist. The book helps you achieve the objectives of safeguarding the confidentiality, integrity, and availability of your organizational assets. Data science does not need to be an intimidating concept for audit managers and directors. With the knowledge in this book, you can leverage simple concepts that are beyond mere buzz words to practice innovation in your team. You can build your credibility and trust with your internal and external clients by understanding the data that drives your organization.WHAT YOU WILL LEARN* Understand the role of auditors as trusted advisors* Perform exploratory data analysis to gain a deeper understanding of your organization* Build machine learning predictive models that detect fraudulent vendor payments and expenses* Integrate data analytics with existing and new technologies* Leverage storytelling to communicate and validate your findings effectively* Apply practical implementation use cases within your organizationWHO THIS BOOK IS FORAI AUDITING is for internal auditors who are looking to use data analytics and data science to better understand their organizational data. It is for auditors interested in implementing predictive and prescriptive analytics in support of better decision making and risk-based testing of your organizational processes.MARIS SEKAR is a professional computer engineer, Certified Information Systems Auditor (ISACA), and Senior Data Scientist (Data Science Council of America). He has a passion for using storytelling to communicate on high-risk items within an organization to enable better decision making and drive operational efficiencies. He has cross-functional work experience in various domains such as risk management, data analysis and strategy, and has functioned as a subject matter expert in organizations such as PricewaterhouseCoopers LLP, Shell Canada Ltd., and TC Energy. Maris’ love for data has motivated him to win awards, write LinkedIn articles, and publish two papers with IEEE on applied machine learning and data science.PART I. TRUSTED ADVISORS1. Three Lines of Defense2. Common Audit Challenges3. Existing Solutions4. Data Analytics5. Analytics Structure & EnvironmentPART II. UNDERSTANDING ARTIFICIAL INTELLIGENCE6. Introduction to AI, Data Science, and Machine Learning7. Myths and Misconceptions8. Trust, but Verify9. Machine Learning Fundamentals10. Data Lakes11. Leveraging the Cloud12. SCADA and Operational TechnologyPART III. STORYTELLING13. What is Storytelling?14. Why Storytelling?15. When to Use Storytelling16. Types of Visualizations17. Effective Stories18. Storytelling Tools19. Storytelling in AuditingPART IV. IMPLEMENTATION RECIPES20. How to Use the Recipes21. Fraud and Anomaly Detection22. Access Management23. Project Management24. Data Exploration25. Vendor Duplicate Payments26. CAATs 2.027. Log Analysis28. Concluding Remarks
Raspberry Pi 400 Schnelleinstieg
Der Raspberry Pi 400 ist ein minimalistischer „All-in-one“-PC zu einem unschlagbaren Preis. Die gesamte Technik ist in der Tastatur verbaut und die gesamte Software auf einer SD-Karte gespeichert. Mit diesem Buch erhalten Sie eine einfache und kompakte Einführung für den Einsatz des Raspberry Pi 400 und erfahren alles, was Sie brauchen, um mit dem Betriebssystem, der Arbeitsumgebung und der Software zu arbeiten. Herbert Hertramph zeigt Schritt für Schritt, wie Sie den Raspberry Pi 400 einrichten, um ihn im Alltag, Homeoffice oder für das Homeschooling optimal einzusetzen. Außerdem erhalten Sie jede Menge Tipps und Tricks für Streaming, Fotobearbeitung und vieles mehr. Alle notwendigen Linux-Grundlagen werden für Ein- und Umsteiger ganz einfach erläutert. Der Autor erklärt die Vorteile des Systems und geht besonders auf Sicherheit und Backups ein. Mit diesem Buch werden Sie die Möglichkeiten des Raspberry Pi 400 voll ausschöpfen und den Mini-PC optimal an die eigenen Bedürfnisse anpassen.Aus dem Inhalt:Linux-GrundlagenRaspberry Pi 400 einrichtenArbeiten mit LibreOffice, GoogleOffice, Microsoft und iWorksBackup und SynchronisationFernzugriff und SicherheitPi-AppsWeitere BetriebssystemeMit der Kommandozeile arbeiten Über den Autor:Herbert Hertramph ist am Institut für Psychologie und Pädagogik der Universität Ulm als Sozialwissenschaftler mit aktuellen Fragestellungen des digitalen Lehrens und Lernens befasst.
Excel 2021 Alles-in-einem-Band für Dummies
Dieses Buch lässt keine Excel-Wünsche offen: Es beschreibt grundlegende Excel-Funktionen, wie das Erstellen und Bearbeiten von Arbeitsblättern, aber auch das Teilen und Überarbeiten von Dokumenten oder das Bearbeiten von Makros mit Visual Basic. Darüber hinaus: Arbeitsblätter formatieren und schützen, Formeln erstellen, Daten importieren, in Diagrammen darstellen und mit Statistikfunktionen auswerten, Pivot-Tabellen erzeugen, Was-wäre-wenn-Szenarien und Webabfragen durchführen, Datenbankfunktionen nutzen, Makros erstellen und ausführen, Excel in Verbindung mit Power BI nutzen und noch vieles mehr. Mit diesem Buch suchen Sie nicht mehr endlos nach Excel-Funktionen, sondern haben mehr Zeit für Ihre Projekte! Paul McFedries verbringt die meiste Zeit seines Lebens damit, Computerbücher zu schreiben. Er hat an über 160 Publikationen zu Themen wie Windows 10, Microsoft Office, Apple Gadgets und Amazon Alexa mitgewirkt.Greg Harvey schrieb vor mehr als zwanzig Jahren sein erstes Computerbuch und die Liste seiner Bestseller wurde immer länger, unter anderem gehen alle Ausgaben von »Excel für Dummies« auf sein Konto.Über die Autoren 13Einführung 29BUCH I: EXCEL- GRUNDLAGEN 37Kapitel 1: Excel – Der erste Eindruck 39Kapitel 2: Excel anpassen 69BUCH II: DESIGN VON ARBEITSBLÄTTERN 105Kapitel 1: Arbeitsblätter erstellen 107Kapitel 2: Arbeitsblätter formatieren 163Kapitel 3: Arbeitsblätter bearbeiten und prüfen 223Kapitel 4: Arbeitsblätter verwalten 267Kapitel 5: Arbeitsblätter drucken 305BUCH III: FORMELN UND FUNKTIONEN 333Kapitel 1: Einfache Formeln erstellen 335Kapitel 2: Logische Funktionen und Fehlersuche 379Kapitel 3: Datums- und Zeitformeln 405Kapitel 4: Abgezockte Finanzformeln 419Kapitel 5: Mathematische und statistische Formeln 435Kapitel 6: Nachschlage- , Informations- und Textformeln 453BUCH IV: ARBEITSBLÄTTER GEMEINSAM BEARBEITEN 481Kapitel 1: Arbeitsmappen und Arbeitsblattdaten schützen 483Kapitel 2: Arbeitsmappen für die Veröffentlichung vorbereiten 503Kapitel 3: Arbeitsmappen und Arbeitsblattdaten gemeinsam nutzen 515BUCH V: DIAGRAMME UND GRAFIKEN 543Kapitel 1: Diagramme für Arbeitsblattdaten 545Kapitel 2: Grafikobjekte hinzufügen 579BUCH VI: DATENVERWALTUNG 607Kapitel 1: Datentabellen erstellen und pflegen 609Kapitel 2: Tabellen filtern und abfragen 631BUCH VII: DATENANALYSE 665Kapitel 1: Was- wäre- wenn- Szenarien 667Kapitel 2: Durchführung einer groß angelegten Datenanalyse 691BUCH VIII: MAKROS UND VBA 735Kapitel 1: Makros aufzeichnen und ausführen 737Kapitel 2: VBA- Programmierung 751Abbildungsverzeichnis 775Stichwortverzeichnis 787
Excel Macros For Dummies
SAVE TIME AND BECOME AN EXCEL WIZARD WITH THE WORLD’S LEADING EXCEL MACRO GUIDEDo you love Excel and all the things you can do with it, but wish you could just work…faster? Excel macros—automated workflows that save you time and energy—might be just what you need. In Excel Macros For Dummies, you’ll learn over 70 of the most productive, time-saving macros in less time than it takes to back up the files on your computer! Every chapter in the book gives you practical info and exercises you can put to work immediately, alongside step-by-step instructions and guidance on how to customize Excel to fit your every need. Inside, you’ll find:* Automations that take your Excel productivity to the next level, and beyond* Fully updated macros compatible with the newest version of Excel included in Microsoft 365* Careful explanations of the basics as well as tips for the advanced userWith something for everyone, Excel Macros For Dummies is the productivity supercharger you’ve been waiting for. Grab a copy today! DICK KUSLEIKA has been helping users get the most out of Microsoft Office products for more than 25 years through online forums, blogging, books, and conferences.Introduction 1PART 1: HOLY MACRO BATMAN! 7Chapter 1: Macro Fundamentals 9Chapter 2: Getting Cozy with the Visual Basic Editor 29Chapter 3: The Anatomy of Macros 43PART 2: MAKING SHORT WORK OF WORKBOOK TASKS 57Chapter 4: Working with Workbooks 59Chapter 5: Working with Worksheets 81PART 3: ONE-TOUCH DATA MANIPULATION 107Chapter 6: Feeling at Home on the Range 109Chapter 7: Manipulating Data with Macros 129PART 4: MACRO-CHARGING REPORTS AND EMAILS 163Chapter 8: Automating Common Reporting Tasks 165Chapter 9: Sending Emails from Excel 199Chapter 10: Wrangling External Data with Macros 217PART 5: PART OF TENS 235Chapter 11: Ten Handy Visual Basic Editor Tips 237Chapter 12: Ten Places to Turn for Macro Help 247Chapter 13: Ten Ways to Speed Up Your Macros 253Index 263
Microsoft Excel 365 Bible
YOUR PERSONAL, HANDS-ON GUIDE TO THE LATEST AND MOST USEFUL FEATURES IN MICROSOFT EXCEL 365Excel 365 is Microsoft’s latest cloud-based version of its world-famous spreadsheet app. Powerful and user-friendly, it’s an ideal solution for businesses and people looking to make sense of—and draw intelligence from—their data.The Excel 365 Bible carries over the best content from the best-selling Excel 2019 Bible while reflecting how a new generation uses Excel in Excel 365. The authoring team with their decades of Excel and business intelligence experience and recognition from the Excel community as Excel MVPs delivers an accessible and authoritative roadmap to Excel 365. Interested in the basics? You’ll learn to create spreadsheets and workbooks and navigate the user interface. If you’re ready for more advanced topics you can skip right to the material on creating visualizations, crafting custom functions, and using Visual Basic for Applications to script automations.You’ll also get:* Over 900 pages of powerful tips, tricks, and strategies to unlock the full potential of Microsoft Excel 365* Guidance on how to import, manage, and analyze large amounts of data* Advice on how to craft predictions and "What-If Analyses" based on data you already havePerfect for anyone new to Excel, as well as experts and advanced users, the Excel 365 Bible is your comprehensive, go-to guide for everything you need to know about the world’s most popular, easy-to-use spreadsheet software.MICHAEL ALEXANDER is a senior consultant at Slalom Consulting with more than 15 year’s experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community.DICK KUSLEIKA has been working with Microsoft Office for more than 20 years. He was formerly a Microsoft MVP, having been awarded 12 consecutive years. Dick has written several books about Excel and Access. Introduction xxxixPART I: GETTING STARTED WITH EXCEL 1Chapter 1: Introducing Excel 3Chapter 2: Entering and Editing Worksheet Data 27Chapter 3: Performing Basic Worksheet Operations 53Chapter 4: Working with Excel Ranges and Tables 73Chapter 5: Formatting Worksheets 121Chapter 6: Understanding Excel Files and Templates 157Chapter 7: Printing Your Work 177Chapter 8: Customizing the Excel User Interface 199PART II: WORKING WITH FORMULAS AND FUNCTIONS 209Chapter 9: Introducing Formulas and Functions 211Chapter 10: Understanding and Using Array Formulas 247Chapter 11: Using Formulas for Common Mathematical Operations 271Chapter 12: Using Formulas to Manipulate Text 285Chapter 13: Using Formulas with Dates and Times 301Chapter 14: Using Formulas for Conditional Analysis 329Chapter 15: Using Formulas for Matching and Lookups 347Chapter 16: Using Formulas with Tables and Conditional Formatting 365Chapter 17: Making Your Formulas Error-Free 379PART III: CREATING CHARTS AND OTHER VISUALIZATIONS 399Chapter 18: Getting Started with Excel Charts 401Chapter 19: Using Advanced Charting Techniques 441Chapter 20: Creating Sparkline Graphics 475Chapter 21: Visualizing with Custom Number Formats and Shapes 489PART IV: MANAGING AND ANALYZING DATA 519Chapter 22: Importing and Cleaning Data 521Chapter 23: Using Data Validation 553Chapter 24: Creating and Using Worksheet Outlines 567Chapter 25: Linking and Consolidating Worksheets 577Chapter 26: Introducing PivotTables 595Chapter 27: Analyzing Data with PivotTables 617Chapter 28: Performing Spreadsheet What-If Analysis 651Chapter 29: Analyzing Data Using Goal Seeking and Solver 675Chapter 30: Analyzing Data with the Analysis ToolPak 697Chapter 31: Protecting Your Work 709PART V: UNDERSTANDING POWER PIVOT AND POWER QUERY 721Chapter 32: Introducing Power Pivot 723Chapter 33: Working Directly with the Internal Data Model 747Chapter 34: Adding Formulas to Power Pivot 757Chapter 35: Introducing Power Query 777Chapter 36: Transforming Data with Power Query 805Chapter 37: Making Queries Work Together 837Chapter 38: Enhancing Power Query Productivity 855PART VI: AUTOMATING EXCEL 867Chapter 39: Introducing Visual Basic for Applications 869Chapter 40: Creating Custom Worksheet Functions 899Chapter 41: Creating UserForms 913Chapter 42: Using UserForm Controls in a Worksheet 935Chapter 43: Working with Excel Events 949Chapter 44: Seeing Some VBA Examples 963Chapter 45: Creating Custom Excel Add-Ins 979Index 989
Games mit Roblox
* ALLES, WAS DU FÜR DEINE EIGENEN ROBLOX-SPIELE WISSEN MUSST* EINFÜHRUNG IN ROBLOX STUDIO, PROGRAMMIERUNG MIT LUA, SPIELPHYSIK, BENUTZUNGSOBERFLÄCHEN, ANIMATIONEN UND VIELES MEHR* MIT EINFACHEN SCHRITT-FÜR-SCHRITT-ANLEITUNGEN, TIPPS UND ÜBUNGSAUFGABENDER OFFIZIELLE ROBLOX-GUIDE ist der perfekte Begleiter für angehende Spieleentwickler, die Games für Roblox erstellen möchten. In diesem Buch erfährst du alles, was du brauchst, um spannende und erfolgreiche Spiele zu erstellen, die von Menschen auf der ganzen Welt gerne gespielt werden. Dafür brauchst du keine Vorkenntnisse.Leicht verständliche Schritt-für-Schritt-Anleitungen führen dich durch alle wichtigen Aufgaben bei der Spieleentwicklung mit Roblox Studio. Du lernst anhand vieler Beispiele, wie du die Möglichkeiten der kostenlosen Spiel-Engine voll ausschöpfst. Praktische Tipps helfen dir, Problemen von Anfang an aus dem Weg zu gehen und mit FAQs, Testfragen und Übungen am Ende jedes Kapitels festigst du dein Wissen.Wenn du dieses Buch gelesen hast, bist du ein echter Experte in der Roblox-Spieleentwicklung.AUS DEM INHALT:* Erste Schritte mit Roblox Studio* Einführung in die Programmierung mit Lua* Workflow bei der Spieleentwicklung* Spielphysik, Licht und Atmosphäre, Sounds und Effekte, Landschaften generieren* Models, Meshparts, Texturen und Import von Objekten* Programmierung von Spielmechanik, Animationen, Kamerabewegungen und grafischen Benutzungsoberflächen* Entwicklung für mobile Geräte und Konsolen* Geld verdienen: Consumables, einmalige Käufe, Premium-Version, neue Spieler gewinnen und WerbungFÜR PC UND MACRoblox hat die Mission, Menschen auf der ganzen Welt durch Spiele zu verbinden. Dabei ermöglicht es Roblox allen, der eigenen Fantasie freien Lauf zu lassen, etwas Neues zu erschaffen und Spaß mit Freunden zu haben, während sie Millionen von immersiven 3D-Welten erforschen. Roblox wird von einer internationalen Community von mehr als zwei Millionen Entwicklern gestaltet, die mit Roblox Studio ihre eigenen immersiven Multiplayer-Spiele erschaffen, und gehört zu den beliebtesten Online-Plattformen für Kinder und Jugendliche unter 18 Jahren, gemessen an den monatlichen Besucherzahlen und der Spielzeit (ComScore).
Smarte Services mit künstlicher Intelligenz
In diesem Buch erfährt der Leser, wie smarte Services mit künstlicher Intelligenz realisierbar sind und wie eine digitale Transformation gelingt, mit der sich die Kundenorientierung, Wettbewerbsfähigkeit, Widerstandsfähigkeit, Agilität und Nachhaltigkeit von Unternehmen verbessern lässt. Was sind smarte Services und wie sehen sie in der Praxis aus? Was beinhalten die dafür erforderlichen Komponenten Internet of Things, Data Lake und Advanced Analytics? Wofür lässt sich die künstliche Intelligenz einsetzen und wie erfolgt das in der Praxis? Wie entsteht Digital Trust? Wie lässt sich der digitale Reifegrad von Unternehmen ermitteln? Welches Vorgehen hat sich für die digitale Transformation in der Praxis bewährt? Wofür wird ein digitales Ecosystem benötigt und wie kann es aussehen? Was wird unter „New Work“ verstanden? Wie arbeiten datengetriebene Unternehmen und welche Vorteile hat das? Was ist ein Digital Use Case? Wie läuft ein Use-Case-Entwicklungs-Workshop ab? Wie lässt sich ein Digital Use Case strukturiert beschreiben? Welche interessanten, innovativen Beispiele für Digital Use Cases gibt es? Wie erfolgt ein Proof of Concept? Wie lassen sich die Kernprozesse Order to Cash (O2C), Procure to Pay (P2P), Design to Operate (D2O), Recruit to Retire (R2R) und Awareness to Advocacy (A2A) digitalisieren? Welche neuen digitalen Technologien und in ihrem Zusammenhang angewandte Verfahren existieren?DER AUTORDR.-ING. EGMONT FOTH war nach dem Studium der Informationstechnik und einer Promotion in der Nachrichtentechnik in zahlreichen Führungsfunktionen in der Industrie tätig. Seit 2017 hat er bei SPIE, dem unabhängigen europäischen Marktführer für Multitechnik-Dienstleistungen in den Bereichen Energie und Kommunikation, als Mitglied der Geschäftsleitung sowie CIO & CTO für Deutschland und Zentraleuropa den Einkauf, die Informationstechnologie, das Geschäftsprozessmanagement und die Digitalisierung verantwortet. Er ist Autor mehrerer Fachbücher und mehrfacher Preisträger der von Computerwoche und CIO-Magazin organisierten Wahl zum CIO des Jahres. 2017 gewann er mit seinem Team für SPIE den Digital Leader Award in der Kategorie "Spark Collaboration" und 2019 erhielt SPIE für die mit einem umfassenden Digital Ecosystem implementierte Digitalisierungsstrategie als Zweiter in der Kategorie "Strategy" erneut den Digital Leader Award. Eine Kontaktaufnahme mit ihm ist über seine Website www.changeprojekte.de möglich.Einleitung - Smarte Services - Digitale Transformation von Unternehmen - Digital Use Cases - Digitalisierung von Kernprozessen - Neue digitale Technologien und angewandte Verfahren - Schlusswort
Scrum Master Kompagnon
Mit agilen Teams starten, wachsen und Wirkung entfalten Scrum Master zu sein, ist nicht nur einer der herausforderndsten Jobs der Welt, sondern gleichzeitig einer der spannendsten und interessantesten. Dabei gibt es nicht den einen Tätigkeitsbereich des Scrum Masters, sondern es existieren – je nach Unternehmen und Kontext – viele verschiedene: Aufgaben als Trainer, als Coach, als Moderator, als Teammitglied und als Veränderungskraft in der Organisation. Der Scrum Master Kompagnon setzt den Fokus auf die Kernkompetenz des Scrum Masters: die Begleitung und Unterstützung eines Scrum-Teams. Dabei orientiert sich die Struktur des Buches an den typischen Entwicklungsphasen des Teams und dem Lebenszyklus der Zusammenarbeit zwischen Scrum Master und Team sowie Product Owner und Stakeholdern. Es werden relevante theoretische Modelle und Konzepte vorgestellt, die in den jeweiligen Prozessphasen hilfreich sein können, sowie ganz praktische und durchführbare Interventionen präsentiert.Die Themen im Einzelnen: Verantwortlichkeiten und Wirksamkeit als Scrum MasterGute Rahmenbedingungen für TeamarbeitTeams kennenlernen und startenTeams begleitenTeams verabschiedenOrganisationsstrukturen und -kulturPersönliche WeiterentwicklungZahlreiche Praxisbeispiele und Erfahrungsberichte sowie mehr als 20 konkrete Workshop-Designs machen das Buch zu einem unverzichtbaren Begleiter jedes Scrum Masters. Autor: Martin Heider hat über 10 Jahre Erfahrung in agiler Produktentwicklung in verschiedensten Branchen und Rollen. Er ist Co-Creator verschiedener Community-Intitiativen, wie Agile Coach Camp, Play4Agile, Coach Reflection Day sowie Agile Monday in Nürnberg. Als selbständiger Agile Coach und Trainer begleitet er Organisationen, Teams und Einzelpersonen. Ein besonderes Anliegen ist ihm die Aus- und Weiterbildung von wirkungsvollen Scrum Mastern. So war er bereits 2014 Mitbegründer der ersten berufsbegleitenden Scrum-Master-Ausbildung in Deutschland. Fabian Schiller hat über 10 Jahre Erfahrung in agiler Produktentwicklung in verschiedensten Branchen und Rollen. Derzeit arbeitet er selbständig als Coach und Trainer und berät vom 30 Mann Startup bis zum Großkonzern seine Kunden bei der Weiterentwicklung der Organisation und agiler Methoden. Er ist Sprecher auf nationalen und internationalen Konferenzen und einer der Gründer der CoReDay- (Coach Reflection Day-)Bewegung zur kontinuierlichen Weiterentwicklung von Scrum Mastern und Agile Coaches.Zielgruppe: Scrum MasterAgile CoachesTrainer*innenWorkshop-Leiter*innen
Einstieg in C# mit Visual Studio 2022
Ideal für ProgrammiereinsteigerC#-Programmierung leicht gemacht! An einfach nachvollziehbaren Beispielen lernen Sie alle wichtigen Themen rund um die Programmierung mit C#. Thomas Theis ist spezialisiert darauf, gerade Anfängern einen guten Einstieg zu ermöglichen. Das gelingt ihm dank anschaulicher Beispiele und klar verständlicher Sprache. Dieses Buch führt Sie von der Installation von Visual Studio 2022 zu den Sprachgrundlagen und stellt Ihnen objektorientierte Programmierung, Fehlerbehandlung, das Erstellen von Datenbankanwendungen sowie die Entwicklung von GUIs einsteigergerecht vor.Aus dem Inhalt:Einführung in Visual Studio 2022C#-SprachgrundlagenObjektorientiert programmierenGUIs entwickelnProgrammieren mit der WPFDatenbankanwendungenZeichnen mit GDI+Leseprobe (PDF)Autor:Thomas Theis, Dipl.-Ing. für Technische Informatik, verfügt über langjährige Erfahrung als EDV-Dozent, unter anderem an der Fachhochschule Aachen.
Windows 11
- PC, Laptop und Tablet von Anfang an sicher bedienen- Von A wie Apps bis Z wie Zwischenablage- Praktische Anleitungen mit zahlreichen AbbildungenLernen Sie das neue Windows 11 von Microsoft Schritt für Schritt kennen und werden Sie sicher im Umgang mit PC, Laptop und Tablet! Dieses Handbuch führt Sie systematisch und leicht nachvollziehbar durch alle wesentlichen Funktionen und Techniken. Für Einsteiger ist es ein hilfreicher Ratgeber, versierte Anwender nutzen es als praktisches Nachschlagewerk im Arbeitsalltag. Die Autorinnen starten mit der grundlegenden Bedienung Ihres Computers und gehen mit anschaulichen Anleitungen zu komplexen Themen über, z. B. individuelle Anpassungen der Benutzeroberfläche, Datenorganisation und -sicherung sowie Sicherheit und Datenschutz. Startmenü, Explorer und der Cloud-Speicher OneDrive sind Ihnen schon bald genauso vertraut wie der Umgang mit den vielen kostenlosen Apps, u. a. Kalender, Mail, Fotos und der Internetbrowser Edge. Dank der Tipps der erfahrenen Dozentinnen werden Sie schnell rundum fit in Windows 11.Aus dem Inhalt:- Was ist neu in Windows 11?- Grundlegende Bedienungs- und Eingabetechniken- So nutzen Sie Startmenü, Taskleiste und Info-Center- Die Benutzeroberfläche individuell anpassen- Apps mit wenigen Klicks installieren und deinstallieren- Dateien speichern und übersichtlich in Ordnern verwalten- Kommunikation mit den Apps Mail, Teams und Kontakte - Mit Microsoft Edge im Internet surfen- Bilder mit der App Fotos organisieren und bearbeiten- Datensicherung mit dem Cloud-Speicher OneDrive- Wichtige Einstellungen zu Sicherheit und Datenschutz
AutoCAD For Dummies
YOU’RE ONE STEP AWAY FROM CREATING CRYSTAL-CLEAR COMPUTER-AIDED DRAFTS IN AUTOCADEver started an AutoCAD project, only to give up when you couldn’t quite get the hang of it? Or do you have a project coming up that would really benefit from a few meticulously created drawings? Then you need the latest edition of AutoCAD For Dummies, the world’s bestselling retail book about the wildly popular program. With coverage of all the important updates to AutoCAD released since 2019, this book walks you through the very basics of pixels, vectors, lines, text, and more, before moving on to more advanced step-by-step tutorials on three-dimensional drawings and models. Already know the fundamentals? Then skip right to the part you need! From blocks to parametrics, it’s all right here at your fingertips. You’ll also find:* In-depth explanations of how to create and store your drawings on the web* Stepwise instructions on creating your very first AutoCAD drawing, from product installation and project creation to the final touches* An exploration of system variables you can tweak to get the best performance from AutoCADPerfect for the AutoCAD newbie just trying to find their way around the interface for the first time, AutoCAD For Dummies is also a must-read reference for the experienced user looking to get acquainted with the program’s latest features and essential drawing tips. Grab a copy today! RALPH GRABOWSKI is editor of upFront.eZine, a weekly e-newsletter that reports on the business of computer-aided design. He is the author of more than 240 books and e-books on CAD and other topics, and his renowned WorldCAD Access industry blog is widely respected in the industry.INTRODUCTION 1About This Book 2Foolish Assumptions 3Conventions Used in This Book 3Using the command line 3Using aliases 4Icons Used in This Book 4Beyond the Book 5Where to Go from Here 6PART 1: GETTING STARTED WITH AUTOCAD 7CHAPTER 1: INTRODUCING AUTOCAD AND AUTOCAD LT 9Launching AutoCAD 10Drawing in AutoCAD 11Understanding Pixels and Vectors 14The Cartesian Coordinate System 15CHAPTER 2: THE GRAND TOUR OF AUTOCAD 17Looking at AutoCAD’s Drawing Screen 18For your information 21Making choices from the Application menu 22Unraveling the Ribbon 24Getting with the Program 27Looking for Mr Status Bar 28Using Dynamic Input 28Let your fingers do the talking: The command line 29The key(board) to AutoCAD success 30Keeping tabs on palettes 34Down the main stretch: The drawing area 34Fun with F1 35CHAPTER 3: A LAP AROUND THE CAD TRACK 37A Simple Setup 38Drawing a (Base) Plate 43Taking a Closer Look with Zoom and Pan 52Modifying to Make It Merrier 53Crossing your hatches 53Now that’s a stretch 54Following the Plot 57Plotting the drawing 57Today’s layer forecast: Freezing 60CHAPTER 4: SETUP FOR SUCCESS 61A Setup Roadmap 62Choosing your units 62Weighing up your scales 65Thinking about paper 68Defending your border 69A Template for Success 69Making the Most of Model Space 72Setting your units 72Making the drawing area snap-py (and grid-dy) 73Setting linetype, text, and dimension scales 76Entering drawing properties 77Making Templates Your Own 77CHAPTER 5: A ZOOM WITH A VIEW 83Panning and Zooming with Glass and Hand 84The wheel deal 84Navigating a drawing 85Zoom, Zoom, Zoom 87A View by Any Other Name 88Degenerating and Regenerating 91PART 2: LET THERE BE LINES 93CHAPTER 6: ALONG THE STRAIGHT AND NARROW 95Drawing for Success 96Introducing the Straight-Line Drawing Commands 97Drawing Lines and Polylines 98Toeing the line 99Connecting the lines with polyline 100Squaring Off with Rectangles 105Choosing Sides with POLygon 106CHAPTER 7: DANGEROUS CURVES AHEAD 109Throwing Curves 109Going Full Circle 110Arc-y-ology 112Solar Ellipses 114Splines: Sketchy, Sinuous Curves 115Donuts: Circles with a Difference 117Revision Clouds on the Horizon 118Scoring Points 120CHAPTER 8: PRECISELINESS IS NEXT TO CADLINESS 123Controlling Precision 124Understanding the AutoCAD Coordinate Systems 127Keyboard capers: Coordinate input 128Introducing user coordinate systems 128Drawing by numbers 129Grabbing an Object and Making It Snappy 131Grabbing points with object snap overrides 132Snap goes the cursor 134Running with object snaps 135Other Practical Precision Procedures 137CHAPTER 9: MANAGE YOUR PROPERTIES 141Using Properties with Objects 142Using the ByLayer approach 142Changing properties 144Working with Layers 146Accumulating properties 148Creating new layers 149Manipulating layers 156Scaling an object’s linetype 158Using Named Objects 159Using AutoCAD DesignCenter 161CHAPTER 10: GRABBING ONTO OBJECT SELECTION 163Commanding and Selecting 164Command-first editing 164Selection-first editing 164Direct-object editing 164Choosing an editing style 165Selecting Objects 166One-by-one selection 167Selection boxes left and right 167Tying up object selection 169Perfecting Selecting 170AutoCAD Groupies 173Object Selection: Now You See It 173CHAPTER 11: EDIT FOR CREDIT 175Assembling Your AutoCAD Toolkit 175The Big Three: Move, COpy, and Stretch 178Base points and displacements 178Move 180COpy 181Copy between drawings 182Stretch 183More Manipulations 186Mirror, mirror on the monitor 186ROtate 188SCale 189-ARray 190Offset 192Slicing, Dicing, and Splicing 194TRim and EXtend 194BReak 196Fillet, CHAmfer, and BLEND 197Join 200Other editing commands 202Getting a Grip 203When Editing Goes Bad 206Dare to Compare 207CHAPTER 12: PLANNING FOR PAPER 209Setting Up a Layout in Paper Space 212The layout two-step 212Put it on my tabs 215Any Old Viewport in a Layout 216Up and down the detail viewport scales 216Keeping track of where you’re at 218Practice Makes Perfect 219Clever Paper Space Tricks 219PART 3: IF DRAWINGS COULD TALK 221CHAPTER 13: TEXT WITH CHARACTER 223Getting Ready to Write 224Creating Simply Stylish Text 226Font follies 227Get in style 228Taking Your Text to New Heights 230Plotted text height 230Calculating non-annotative AutoCAD text height 231Entering Text 232Using the Same Old Line 232Saying More in Multiline Text 235Making it with mText 235mText dons a mask 238Insert Field 239Doing a number on your mText lists 239Line up in columns — now! 242Modifying mText 243Turning On Annotative Objects 244Gather Round the Tables 247Tables have style, too 247Creating and editing tables 249Take Me to Your Leader 251Electing a leader 251Multi options for multileaders 254CHAPTER 14: ENTERING NEW DIMENSIONS 255Adding Dimensions to a Drawing 256Dimensioning the Legacy Way 257A Field Guide to Dimensions 260Self-centered 263Quick, dimension! 263Where, oh where, do my dimensions go? 264The Latest Styles in Dimensioning 266Creating dimension styles 269Adjusting style settings 271Changing styles 274Scaling Dimensions for Output 275Editing Dimensions 278Editing dimension geometry 278Editing dimension text 280Controlling and editing dimension associativity 281And the Correct Layer Is 282CHAPTER 15: DOWN THE HATCH! 283Creating Hatches 284Hatching Its Own Layer 287Using the Hatches Tab 287Scaling Hatches 290Scaling the easy way 291Annotative versus non-annotative 292Pushing the Boundaries of Hatch 292Adding style 293Hatches from scratch 294Editing Hatch Objects 296CHAPTER 16: THE PLOT THICKENS 299You Say “Printing,” I Say “Plotting” 300The Plot Quickens 300Plotting success in 16 steps 300Getting with the system 304Configuring your printer 305Preview one, two 307Instead of fit, scale it 307Plotting the Layout of the Land 309Plotting Lineweights and Colors 311Plotting with style 311Plotting through thick and thin 316Plotting in color 320It’s a (Page) Setup! 321Continuing the Plot Dialog 322The Plot Sickens 325PART 4: ADVANCING WITH AUTOCAD 327CHAPTER 17: THE ABCS OF BLOCKS 329Rocking with Blocks 330Creating Block Definitions 332Inserting Blocks 336Attributes: Fill-in-the-Blank Blocks 340Creating attribute definitions 341Defining blocks that contain attribute definitions 343Inserting blocks that contain attribute definitions 343Editing attribute values 344Extracting data 344Exploding Blocks 345Purging Unused Block Definitions 345CHAPTER 18: EVERYTHING FROM ARRAYS TO XREFS 347Arraying Associatively 349Comparing the old and new ARray commands 350Hip, hip, array! 351Associatively editing 356Going External 358Becoming attached to your xrefs 360Layer-palooza 362Editing an external reference file 362Forging an xref path 363Managing xrefs 365Blocks, Xrefs, and Drawing Organization 366Mastering the Raster 367Attaching a raster image 369Maintaining your image 370You Say PDF; I Say DWF 371Theme and Variations: Dynamic Blocks 373Now you see it 373Lights! Parameters! Actions! 377Manipulating dynamic blocks 379CHAPTER 19: CALL THE PARAMETRICS! 381Maintaining Design Intent 382Defining terms 384Forget about drawing with precision! 385Constrain yourself 386Understanding Geometric Constraints 386Applying a little more constraint 388Using inferred constraints 393You AutoConstrain yourself! 394Understanding Dimensional Constraints 395Practice a little constraint 396Making your drawing even smarter 398Using Parameters Manager 400Dimensions or constraints? Have it both ways! 403Lunchtime! 406CHAPTER 20: DRAWING ON THE INTERNET 407The Internet and AutoCAD: An Overview 407You send me 408Prepare it with eTransmit 408Rapid eTransmit 409Increasing cloudiness 411Bad reception? 411Help from Reference Manager 412The Drawing Protection Racket 413Outgoing! 414Autodesk weather forecast: Increasing cloud 414Your head planted firmly in the cloud 416AutoCAD Web and Mobile 417PART 5: ON A 3D SPREE 419CHAPTER 21: IT’S A 3D WORLD AFTER ALL 421The 3.5 Kinds of 3D Digital Models 422Tools of the 3D Trade 424Warp speed ahead 425Entering the third dimension 425Untying the Ribbon and opening some palettes 426Modeling from Above 428Using 3D coordinate input 428Using point filters 429Object snaps and object snap tracking 429Changing Work Planes 430Displaying the UCS icon 430Adjusting the UCS 431Orbit à go-go 437Taking a spin around the cube 438Grabbing the SteeringWheels 440Visualizing 3D Objects 440On a Render Bender 442CHAPTER 22: FROM DRAWINGS TO MODELS 443Is 3D for Me? 444Getting Your 3D Bearings 445Creating a better 3D template 445Seeing the world from new viewpoints 450From Drawing to Modeling in 3D 451Drawing basic 3D objects 452Gaining a solid foundation 453Drawing solid primitives 454Adding the Third Dimension to 2D Objects 455Adding thickness to a 2D object 455Extruding open and closed objects 455Pressing and pulling closed boundaries 456Lofting open and closed objects 456Sweeping open and closed objects along a path 457Revolving open or closed objects around an axis 458Modifying 3D Objects 458Selecting subobjects 459Working with gizmos 459More 3D variants of 2D commands 460Editing solids 461CHAPTER 23: IT’S SHOWTIME! 465Get the 2D Out of Here! 466A different point of view 470Additional 3D tricks 471AutoCAD’s top model 472Visualizing the Digital World 474Adding Lights 475Default lighting 475User-defined lights 476Sunlight 479Creating and Applying Materials 479Defining a Background 482Rendering a 3D Model 484CHAPTER 24: AUTOCAD PLAYS WELL WITH OTHERS 485Get Out of Here! 485Making a splash with PNG 486PDF to the rescue 488What the DWF? 4893D print 490But wait! There’s more! 491Open Up and Let Me In! 491Editing other drawing file formats 491PDF editing 491Translation, Please! 494The Importance of Being DWG 495PART 6: THE PART OF TENS 497CHAPTER 25: TEN AUTOCAD RESOURCES 499Autodesk Discussion Groups 499Autodesk’s Own Blogs 499Autodesk University 500Autodesk Channel on YouTube 500World Wide (CAD) Web 500Your Local Authorized Training Center 501Your Local User Group 501Autodesk User Groups International 502Books 502Autodesk Feedback Community 502CHAPTER 26: TEN SYSTEM VARIABLES TO MAKE YOUR AUTOCAD LIFE EASIER 503Aperture 504Dimassoc 505Menubar 505Mirrtext 505Osnapz 506Pickbox 506Rememberfolders 507Rollovertips And Tooltips 507Taskbar 508Visretain 508And the Bonus Round 508CHAPTER 27: TEN AUTOCAD SECRETS 511Sheet Sets 511Custom Tool Palettes 512Ribbon Customization 512Toolsets 512Programming Languages 512Vertical Versions 513Language Packs 513Multiple Projects or Clients 514Data Extraction and Linking 514Untying the Ribbon and Drawings 514Index 515
Der Weg zum Python-Profi
Ein Best-Practice-Buch für sauberes Programmieren. Der Brückenschlag zu einer anderen Ebene der Python-Programmierung.Sie haben ein grundlegendes Python-Programmiertutorial absolviert oder bereits erste Erfahrungen im Programmieren. Was ist der nächste Schritt auf dem Weg zur fähigen, kompetenten Softwareentwickler:in? Der Weg zum Python Profi ist mehr als eine bloße Sammlung meisterhafter Tipps für das Schreiben von sauberem Code. Es zeigt Ihnen, wie Sie die Kommandozeile bedienen und andere professionelle Tools wie Code-Formatierer, Type Checkers, Linters und Versionskontrolle verwenden können. Al Sweigart führt Sie durch bewährte Praktiken für die Einrichtung Ihrer Entwicklungsumgebung, die Benennung von Variablen und die Verbesserung der Lesbarkeit und geht dann auf Dokumentation, Organisation, Leistungsmessung, objektorientiertes Design und sogar Big-O-Algorithmus-Analyse ein. Die Hinweise und Anleitungen des Buchs werden Ihre Programmierfähigkeiten deutlich verbessern - nicht nur in Python, sondern in jeder Sprache.Sie werden lernen:wie Sie Pythons automatisches Formatierungswerkzeug Black für sauberen Code verwendenwie Sie häufige Fehlerquellen erkennen und sie mit Static analyzers aufspürenwie Sie die Dateien in Ihren Code-Projekten mit dem Cookiecutter-Template-Tool strukturierenerschließen Sie sich funktionale Programmiertechniken wie Lambda- und Funktionen höherer Ordnungwie Sie die Geschwindigkeit Ihres Codes mit den in Python integrierten Modulen timeit und cProfile verbessern könnenwie Sie Ihre Kommentare und Dokumentationsstrings informativ gestalten und wie oft Sie sie schreiben solltenAutor: Al Sweigart arbeitet als Softwareentwickler und bringt Jugendlichen und Erwachsenen das Programmieren bei. Er ist Autor mehrerer Bücher für Einsteiger, u.a. „Eigene Spiele programmieren mit Python“.
Blender 3
Das umfassende Handbuch. Blender verstehen und anwenden – aktuell zum großen Update 3!Das große Handbuch zu allen wichtigen Funktionen von Blender 3. Dieses Buch bietet einen soliden Einstieg in die 3D-Software und in die Grundlagen des 3D-Designs. Aber es geht noch weiter: Es begleitet Sie vom Modelling über Texturing und Shading, die Beleuchtung, Rigging und Animation bis hin zu Simulation, Rendering und Postproduktion. In Schritt-für-Schritt-Anleitungen konstruieren, texturieren und animieren Sie Ihre eigenen 3D-Objekte und setzen das Gelernte direkt in die Praxis um. Das verlässliche Lern- und Nachschlagewerk für alle Anwender! Aus dem Inhalt: Arbeitsoberfläche, Navigation und ObjekteModelling und SculptingShading, Texturing und MappingLichtquellen, Kameras und TrackingAnimationen mit Keyframes, Pfaden und DrivernPartikelsysteme, Haare und KollisionenRauch, Feuer und FlüssigkeitenDie neuen Geometry Nodes2D-Animationen mit Grease PencilRendering mit Eevee und CyclesCompositing, Schnitt und TonImport und Export Leseprobe (PDF-Link)Autor: Andreas Asanger ist als technischer Redakteur und Medienentwickler in den Bereichen Grafik, Visualisierung und 3D-Animation tätig.
Excel Power Pivot & Power Query For Dummies
LEARN TO CRUNCH HUGE AMOUNTS OF DATA WITH POWERPIVOT AND POWER QUERYDo you have a ton of data you need to make sense of? Microsoft’s Excel program can handle amazingly large data sets, but you’ll need to get familiar with PowerPivot and Power Query to get started. And that’s where Dummies comes in. With step-by-step instructions—accompanied by ample screenshots—Excel PowerPivot & Power Query For Dummies will teach you how to save time, simplify your processes, and enhance your data analysis and reporting. Use Power Query to discover, connect to, and import your organization’s data. Then use PowerPivot to model it in Excel. You’ll also learn to:* Make use of databases to store large amounts of data* Use custom functions to extend and enhance Power Query* Add the functionality of formulas to PowerPivot and publish data to SharePointIf you’re expected to wrangle, interpret, and report on large amounts of data, Excel PowerPivot & Power Query For Dummies gives you the tools you need to get up to speed quickly. MICHAEL ALEXANDER is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel and has been named Microsoft Excel MVP for his contributions to the Excel community.INTRODUCTION1About This Book 2Foolish Assumptions 3Icons Used in This Book 3Beyond the Book 4Where to Go from Here 4PART 1: SUPERCHARGED REPORTING WITH POWER PIVOT 5CHAPTER 1: THINKING LIKE A DATABASE 7Exploring the Limits of Excel and How Databases Help 7Scalability 8Transparency of analytical processes 9Separation of data and presentation 10Getting to Know Database Terminology 11Databases 11Tables 11Records, fields, and values 12Queries 13Understanding Relationships 13CHAPTER 2: INTRODUCING POWER PIVOT 17Understanding the Power Pivot Internal Data Model 18Linking Excel Tables to Power Pivot 20Preparing Excel tables 21Adding Excel Tables to the data model 22Creating relationships between Power Pivot tables 24Managing existing relationships 26Using the Power Pivot data model in reporting 27CHAPTER 3: THE PIVOTAL PIVOT TABLE 29Introducing the Pivot Table 30Defining the Four Areas of a Pivot Table 30Values area 30Row area 31Column area 31Filter area 32Creating Your First Pivot Table 33Changing and rearranging a pivot table 36Adding a report filter 37Keeping the pivot table fresh 38Customizing Pivot Table Reports 40Changing the pivot table layout 40Customizing field names 41Applying numeric formats to data fields 42Changing summary calculations 43Suppressing subtotals 44Showing and hiding data items 47Hiding or showing items without data 49Sorting the pivot table 51Understanding Slicers 52Creating a Standard Slicer 54Getting Fancy with Slicer Customizations 56Size and placement 56Data item columns 57Miscellaneous slicer settings 58Controlling Multiple Pivot Tables with One Slicer 58Creating a Timeline Slicer 59CHAPTER 4: USING EXTERNAL DATA WITH POWER PIVOT 63Loading Data from Relational Databases 64Loading data from SQL Server 64Loading data from Microsoft Access databases 70Loading data from other relational database systems 72Loading Data from Flat Files 75Loading data from external Excel files 76Loading data from text files 78Loading data from the Clipboard 81Loading Data from Other Data Sources 82Refreshing and Managing External Data Connections 83Manually refreshing Power Pivot data 83Setting up automatic refreshing 84Preventing Refresh All 85Editing the data connection 86CHAPTER 5: WORKING DIRECTLY WITH THE INTERNAL DATA MODEL 89Directly Feeding the Internal Data Model 89Managing Relationships in the Internal Data Model 95Managing Queries and Connections 96Creating a New Pivot Table Using the Internal Data Model 97Filling the Internal Data Model with Multiple External Data Tables 98CHAPTER 6: ADDING FORMULAS TO POWER PIVOT 103Enhancing Power Pivot Data with Calculated Columns 103Creating your first calculated column 104Formatting calculated columns 105Referencing calculated columns in other calculations 106Hiding calculated columns from end users 107Utilizing DAX to Create Calculated Columns 108Identifying DAX functions that are safe for calculated columns 108Building DAX-driven calculated columns 110Month sorting in Power Pivot–driven pivot tables 112Referencing fields from other tables 113Nesting functions 115Understanding Calculated Measures 116Creating a calculated measure 116Editing and deleting calculated measures 118Free Your Data with Cube Functions 119CHAPTER 7: DIVING INTO DAX 121DAX Language Fundamentals 121Using DAX operators 125Applying conditional logic in DAX 126Working with DAX aggregate functions 128Exploring iterator functions and row context 129Understanding Filter Context 133Getting context transitions with the CALCULATE function 135Adding flexibility with the FILTER function 137PART 2: WRANGLING DATA WITH POWER QUERY 141CHAPTER 8: INTRODUCING POWER QUERY 143Power Query Basics 144Starting the query 144Understanding query steps 150Refreshing Power Query data 152Managing existing queries 153Understanding Column-Level Actions 155Understanding Table Actions 157CHAPTER 9: POWER QUERY CONNECTION TYPES 159Importing Data from Files 160Getting data from Excel workbooks 160Getting data from CSV and text files 161Getting data from PDF files 163Getting data from folders 164Importing Data from Database Systems 165A connection for every database type 165Getting data from other data systems 167Walk-through: Getting data from a database 168Managing Data Source Settings 170Data Profiling with Power Query 171Data Profiling options 172Data Profiling quick actions 173CHAPTER 10: TRANSFORMING YOUR WAY TO BETTER DATA 175Completing Common Transformation Tasks 176Removing duplicate records 176Filling in blank fields 178Concatenating columns 179Changing case 181Finding and replacing specific text 181Trimming and cleaning text 183Extracting the left, right, and middle values 184Splitting columns using character markers 187Pivoting and unpivoting fields 189Creating Custom Columns 193Concatenating with a custom column 195Understanding data type conversions 196Spicing up custom columns with functions 197Adding conditional logic to custom columns 199Grouping and Aggregating Data 201Working with Custom Data Types 203CHAPTER 11: MAKING QUERIES WORK TOGETHER 207Reusing Query Steps 208Understanding the Append Feature 211Creating the needed base queries 212Appending the data 213Understanding the Merge Feature 216Understanding Power Query joins 216Merging queries 217Understanding Fuzzy Match 221CHAPTER 12: EXTENDING POWER QUERY WITH CUSTOM FUNCTIONS 225Creating and Using a Basic Custom Function 225Creating a Function to Merge Data from Multiple Excel Files 229Creating Parameter Queries 236Preparing for a parameter query 236Creating the base query 238Creating the parameter query 239PART 3: THE PART OF TENS 243CHAPTER 13: TEN WAYS TO IMPROVE POWER PIVOT PERFORMANCE 245Limit the Number of Rows and Columns in Your Data Model Tables 246Use Views Instead of Tables 246Avoid Multi-Level Relationships 246Let the Back-End Database Servers Do the Crunching 247Beware of Columns with Many Unique Values 248Limit the Number of Slicers in a Report 248Create Slicers Only on Dimension Fields 249Disable the Cross-Filter Behavior for Certain Slicers 250Use Calculated Measures Instead of Calculated Columns 250Upgrade to 64-Bit Excel 251CHAPTER 14: TEN TIPS FOR WORKING WITH POWER QUERY 253Getting Quick Information from the Queries & Connections Pane 253Organizing Queries in Groups 254Selecting Columns in Queries Faster 255Renaming Query Steps 256Quickly Creating Reference Tables 257Viewing Query Dependencies 258Setting a Default Load Behavior 259Preventing Automatic Data Type Changes 259Disabling Privacy Settings to Improve Performance 261Disabling Relationship Detection 261Index 263
Office 2021 All-in-One For Dummies
SAY HELLO TO OFFICE PRODUCTIVITY WITH THIS ONE-STOP REFERENCEWith Office 2021 All-in-One For Dummies, you can get up and running with Microsoft's legendary software suite. This update covers all the tweaks you can find in the latest version of Word, Excel, PowerPoint, Outlook, and Teams. You'll also learn how to make these apps work harder for you, because we dig deep into the tips and features that casual Office users might not know about. This edition also offers expanded coverage of Teams and other collaborative tools, so you can nail working from home, or just get a few of those meetings out of the way without having to leave your desk. How can you quickly give documents the same format in Word? What was that one useful Excel function, again? And how does setting up a meeting on Teams work? Office 2021 All-in-One For Dummies serves up quick and simple answers to these questions, along with hundreds of other answers you're expected to know when you work in Office.* Learn how Microsoft Office works and get the most out of Word, Excel, PowerPoint, Outlook, and Teams* Make amazing charts and graphs that you can plug into your documents, spreadsheets, and presentations* Get better at working collaboratively with file sharing options and other neat features* Do more, faster with expert tips and guidance on the full suite of Office software for 2021Whether you're new to Office or just need a refresher for the newest updates, the nine mini-books inside are your keys to getting stuff done. PETER WEVERKA is a long-time For Dummies technology author who’s written some of the series’ top-selling titles, including Office 365 All-in-One For Dummies.INTRODUCTION 1BOOK 1: COMMON MICROSOFT OFFICE TASKS 5Chapter 1: Office Nuts and Bolts 7Chapter 2: Wrestling with the Text 27Chapter 3: Speed Techniques Worth Knowing About 47BOOK 2: WORD 2021 55Chapter 1: Speed Techniques for Using Word 57Chapter 2: Laying Out Text and Pages 77Chapter 3: Word Styles 103Chapter 4: Constructing the Perfect Table 121Chapter 5: Taking Advantage of the Proofing Tools 145Chapter 6: Desktop Publishing with Word 165Chapter 7: Getting Word's Help with Office Chores 183Chapter 8: Tools for Reports and Scholarly Papers 203BOOK 3: EXCEL 2021 227Chapter 1: Up and Running with Excel 229Chapter 2: Refining Your Worksheet 247Chapter 3: Formulas and Functions for Crunching Numbers 261Chapter 4: Making a Worksheet Easier to Read and Understand 293Chapter 5: Advanced Techniques for Analyzing Data 311BOOK 4: POWERPOINT 2021 329Chapter 1: Getting Started in PowerPoint 331Chapter 2: Fashioning a Look for Your Presentation 353Chapter 3: Entering the Text 367Chapter 4: Making Your Presentations Livelier 385Chapter 5: Delivering a Presentation 401BOOK 5: OUTLOOK 2021 421Chapter 1: Outlook Basics 423Chapter 2: Maintaining the People App 435Chapter 3: Handling Your Email 445Chapter 4: Managing Your Time and Schedule 467BOOK 6: ACCESS 2021 479Chapter 1: Introducing Access 481Chapter 2: Building Your Database Tables 497Chapter 3: Entering the Data 525Chapter 4: Sorting, Querying, and Filtering for Data 535Chapter 5: Presenting Data in a Report 557BOOK 7: PUBLISHER 2021 563Chapter 1: Introducing Publisher 565Chapter 2: Refining a Publication 577Chapter 3: Putting on the Finishing Touches 589BOOK 8: WORKING WITH CHARTS AND GRAPHICS 601Chapter 1: Creating a Chart 603Chapter 2: Making a SmartArt Diagram 623Chapter 3: Handling Graphics and Photos 643Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects 659BOOK 9: OFFICE 2021: ONE STEP BEYOND 693Chapter 1: Customizing an Office Program 695Chapter 2: Ways of Distributing Your Work 709BOOK 10: FILE SHARING AND COLLABORATING 717Chapter 1: Up and Running on OneDrive 719Chapter 2: File Sharing and Collaborating 731INDEX 739
Microsoft 365 For Dummies
AMP UP YOUR COLLABORATION SKILLS AND ROCK THE MODERN WORKPLACE BY HARNESSING THE POWER OF MICROSOFT 365 WITH THIS ONE-STOP GUIDE TO THE WORLD'S LEADING PRODUCTIVITY PLATFORMThe Microsoft 365 productivity solution for the workplace is a cloud-based service with many features for effective and secure collaboration virtually or in person. Whether you start your day with meetings in Teams, respond to Outlook emails, create documents with Office apps, or even automate your work with artificial intelligence, Microsoft 365 has you covered. But first, you must unlock the potential of this powerful solution to showcase your ability to keep up with the modern workplace and make an impact in your organization. To do that, you need Microsoft 365 For Dummies!This book walks you through the steps to get your work done anytime, anywhere, on any device, with Microsoft Teams as the central hub. Discover how to chat online in real time; conduct online meetings; co-author documents in the cloud; develop no-code applications; and even prioritize your well-being. The insights and step-by-step guidance in Microsoft 365 For Dummies will help you stay connected and engaged with your colleagues.* Level up your teamwork game with the latest meeting and collaboration best practices from Microsoft Teams * Stretch your use of Office apps (Word, Excel, PowerPoint, Outlook, and OneNote) by infusing artificial intelligence into your everyday tasks * Save time (and look really smart) by automating your work with the Power Platform apps * Take a break from work and focus on your health and well-being at home or in the office Whether you’re a Microsoft 365 newbie or a superuser looking for details on what's new, Microsoft 365 For Dummies is the friendly and authoritative how-to book you need. Discover the benefits of cloud technology today!JENNIFER REED is Founder of Cloud61, a firm offering IT consulting products and services. She is the author of Office 365 For Dummies, Migrating to Office 365 For Dummies, Office 365 Backup For Dummies, and Office 365 for Higher Education. She recently launched a startup (www.hydrojennfarms.com) aimed at promoting locally grown food and regenerative farming practices using modern technologies like Microsoft 365.INTRODUCTION 1About This Book 1Foolish Assumptions 2Icons Used in This Book 2Beyond the Book 3Where to Go from Here 3PART 1: KEEPING UP WITH MICROSOFT 365 5CHAPTER 1: WHAT’S IN IT FOR YOU: OVERVIEW OF FEATURES 7Tasting the Flavors of Microsoft 365 8Understanding the versions for home 9Exploring the options for the workplace 9Honing in on the Workplace Features 11Reining in the apps and services 11No, the robots have not taken over 12Connecting the dots to get work done 13CHAPTER 2: WORK, MEET LIFE: THE NEW WORLD OF WORK 17Going Native, Digitally 18How to get your colleague’s attention 18Turn back the hands of time with version history 20Prioritizing Self-Care and Well-Being 21Viva la vida loca! 21Taming the “too-connected” beast 22Calling it a day with Virtual Commute 24PART 2: REIMAGINING TEAMWORK 25CHAPTER 3: UNLOCKING DIGITAL COLLABORATION 27There’s a Purpose for That App 28Office 365 versus Microsoft 365: What’s the diff? 28Installing the Office 365 apps 29The right tools for the right purpose 30Connecting Experiences Across Apps 32The lowdown on connected experiences 32Look Ma, no hands! Using the Dictation feature 34CHAPTER 4: ZOOMING IN ON TEAMS 37Getting to Know Teams 38Touring the Teams interface 38Co-authoring documents in Teams 41Don’t get ghosted — use Read Receipts 42Reading instead of listening to voicemail 43Creating a Humanistic Workplace 44To hide or not to hide the kids (or pets) 45The many ways to see each other 46Eat chips without being annoying 48CHAPTER 5: ROCKING YOUR MEETING LIKE A BOSS 51The Things You Do Before 52Get meeting insights from Outlook 52Chat with attendees to prep 54Preload agenda and documents 56The Stuff You Do During 57Present like a pro with one monitor 57Reporting live from your home office! 58Follow along with live captions or live transcriptions 60The Actions to Take After 62Play back the meeting 63Track action items 63Continue to engage via chat 64CHAPTER 6: FACILITATING MEETINGS AND BREAKOUT SESSIONS 67The Basics of Teams Meetings 68Scheduling a meeting 69Calling for an impromptu meeting 70Joining a meeting 71Meeting within a Meeting with Breakout Rooms 72Creating Breakout rooms 73Starting the breakout session 75Rejoining the main session 76CHAPTER 7: ALL ABOUT WEBINARS AND LIVE EVENTS 79Calling the Shots with a Webinar 80Preparing for a webinar 80Creating the webinar event 81Delivering the webinar 85So, You Want to be a Producer 86Getting ready to produce a live event 86Scheduling a live event 87Producing the live event 88PART 3: MODERNIZING THE WORKPLACE WITH OFFICE APPS 91CHAPTER 8: GETTING THE MOST OUT OF WORD 93It’s Alive! Your Document, That Is 94Jazz it up with pictures 94Your screen is paper, draw on it 97Immerse yourself in your reading 99Becoming a Better Writer 100Make your writing so much better 101Support your facts with Researcher 103That Time When Word Helped Your Career 104Sprucing up your resume 104Smashing the language barrier 105CHAPTER 9: STEPPING UP YOUR EXCEL CHOPS 107Excelling in Excel 108Everyday Excel tasks 108Get it all sorted out 110Talk to your team from your workbook 111Taking a Shortcut to Completing Tasks 114Get to know Office Scripts 114Stop the repetition; create a script 114Run and share your script 116So, You’re a Data Analyst Now? 118Around the world with data types 119Giving yourself permission to be curious 121You’ve got questions, Excel has answers 123CHAPTER 10: WOWING YOUR AUDIENCE WITH POWERPOINT 125More than Just the Basics of PowerPoint 126Navigating the web and desktop apps 127Have an interesting topic? There’s’ a deck for that! 128The Art of Creating a Deck 131Be artsy (even when you’re not) with Designer 131Mastering the Slide Master 133Reuse, recycle decks with templates 134The Science of Presenting a Deck 135Practice with AI makes perfect 135Give a unique experience with Live Presentations 138Experiencing Live Presentations as an audience 141CHAPTER 11: GOING DIGITAL WITH ONENOTE 145Exploring Basic Functions 146Understanding the different versions 146Getting around the user interface 149Creating a new notebook 150Moving a notebook to a new location 152Stepping Up the Notetaking Game 153Tagging content for later use 154Viewing and restoring page versions 155Sharing your notebook 156CHAPTER 12: STAYING CONNECTED WITH OUTLOOK 159The Not-Just-Basic of Outlook 160Just a few words will do 162My thoughts exactly: When AI reads minds 164Ask questions, naturally 167Schedule Management with the Calendar 168Click to meet from an email 168Color your world with categories 169Don’t get between your colleagues and their lunch 171Outlook Out of the Ball Park 173Sliding into a Teams chat from Outlook 173Notes and Sticky Notes integration 174Play my emails, please 175PART 4: STORING YOUR DATA IN THE CLOUD 177CHAPTER 13: CENTRALIZING DATA IN SHAREPOINT 179Getting to Know SharePoint Online 180No-code website in a flash? Yes you can! 181Who let the dogs in? Setting permissions 184The Wonders of Microsoft Lists 187Creating and editing a List 187A view for different points of view 189Never miss an update with alerts 191The Marvels of Document Libraries 192Contributing to a document library 192Help, I changed my mind! Versioning to the rescue 193CHAPTER 14: GOODBYE HARD DRIVE, HELLO ONEDRIVE 197Storing and Syncing Files in OneDrive 198Ready, get set, sync! Using the sync app 198What’s in a name? Work or School versus Home 201What’s the diff? OneDrive versus SharePoint 202The Many Ways to Share Files 204May I have a quick link, please? 204Managing access before it gets out of hand 206PART 5: GIVING POWER TO THE PEOPLE LIKE YOU AND ME 209CHAPTER 15: UNDERSTANDING THE POWER PLATFORM 211What Is the Power Platform? 212Creating Workflows with Power Automate 213Getting to Know Power Apps 214Telling a Story with Data in Power BI 217Advanced Concepts 218Meet the AI Builder 219About the Microsoft Dataverse 219CHAPTER 16: CREATING A POWER-AUTOMATED APPROVAL PROCESS 221Gathering What You need 222Nailing the scenario 222Building the library 223Picking the template 224All Systems Go, Let’s Flow! 226Building the flow, making the connections 226Testing the workflow 230Checking for approvals in Teams 231Turning off the flow 232CHAPTER 17: DEVELOPING YOUR FIRST APP WITH POWER APPS 233Before Building the App 234Creating the list to hold data 235Managing access to the list 236Fine-tuning the properties of the list 238Specifying the survey questions 240Building the App 243Designing the app 244Connecting the data source 244Building the Survey screen 247Adding buttons and labels to the form 250Building the Welcome screen 253Building the Thank You screen 255Finalizing the Survey screen 255Launching the App 256Saving and sharing the app 257Updating the app 257Reviewing the data 258CHAPTER 18: DASHBOARDING WITH POWER BI 259Understanding Power BI Concepts 260What’s in it for you? 261How Power BI is licensed 261It’s the elements, dear Watson 262Exploring a Sample Data Set 263Navigating the Power BI Service 263Loading the dataset 266Interacting with the dashboard 267PART 6: BEING YOUR OWN IT DEPARTMENT 271CHAPTER 19: GETTING UP CLOSE AND PERSONAL 273Let’s Get Personal 274Paint a thousand words with your picture 274Spice things up with a custom cover photo 276Don’t be shy, toot your own horn 276IT Tasks You’re Empowered to Do 277Updating your security information 278Changing your password 279Self-service password reset 280CHAPTER 20: REINING IN YOUR DEVICES 283Managing Your Devices 284Securing your devices 284Auditing and disabling devices 285Checking for impossible travel 287You Have Left the Building — Virtually 288Signing out from devices all at once 288Disconnecting a BYOD 289PART 7: THE PART OF TENS 293CHAPTER 21: TEN MORE APPS THAT GET THE WORK DONE 295People 296MyAnalytics 296Kaizala 297Stream 298Whiteboard 298Lists 299Forms 300Yammer 301Sway 302Planner 302CHAPTER 22: TEN WAYS TO ROCK DELVE 305Know Thyself with MyAnalytics 306Delve Away, Your Docs Are Safe 306Delve Consumes OneDrive and SharePoint data 307The Search Is On for People and Docs 308Act On a Document 309Favorite Documents for Later Use 309Group Documents in a Board 310Documents-at-a-Glance with Cards 311Popularity Contest for Documents 311Get to Know Your Colleagues 311CHAPTER 23: TEN MICROSOFT 365 REMOTE WORK TIPS 313Set Lunch Hours and Enjoy Your Meal 314Chill and Decompress: Go Meditate 315Start Your Zero-Carbon Commute 315Keep Your Promises with Help from AI 316Work Late but Let Others Not 316Make Your Meeting Worth Their Time 317Wrap It Up in Five Minutes 317Say Thanks with Praise 318Your Status Is Not Complicated 318Give a Heads Up with Signatures 319Index 321
Excel Tipps und Tricks für Dummies (4. Auflg.)
Erfahren Sie, wie Sie mit Excel noch schneller, besser und effizienter arbeiten! Zeigen Sie im Excel-Alltag richtiges Fachwissen. Verwenden Sie gelungene Mixturen aus raffinierten Formeln und Funktionen. Holen Sie zum Beispiel mehr aus WENN-Funktionen heraus, ohne dass es ein ABER gibt. Nutzen Sie im Programm Verborgenes. Dieses Buch zeigt Ihnen neben vielen Tipps, Tricks und Tastenkombinationen auch Top-Secrets für den direkten Einsatz, die nicht jeder kennt und im Geheimen schlummern.Rainer Schwabe sammelt akribisch Excel-Tipps, schreibt regelmäßig Excel-Artikel für Computerzeitschriften wie die c't und ist renommierter Autor zahlreicher Office-Bücher. Er führt bundesweit Schulungen durch und ist ein gefragter Ansprechpartner für Unternehmen, wenn es um praxisbezogene Lösungen in Excel geht.
Excel Data Analysis For Dummies
TURN JUMBLES OF NUMBERS INTO GRAPHICS, INSIGHTS, AND ANSWERS WITH EXCELWith Microsoft Excel, you can, well, excel at data analysis. And Excel Data Analysis For Dummies can help, with clear and easy explanations of the mountain of features for creating, visualizing, and analyzing data. PivotTables, charts, what-if analysis, statistical functions—it's all in here, with examples and ideas for Excel users of all skill levels. This latest edition covers the most recent updates to Excel and Microsoft 365. You'll beef up your data skills and learn powerful techniques for turning numbers into knowledge. For students, researchers, and business professionals, Excel is the spreadsheet and data application of choice—and Dummies is the best choice for learning how to make those numbers sing.* Learn how to use Excel's built-in data analysis features and write your own functions to explore patterns in your data* Create striking charts and visualizations, and discover multiple ways to tell the stories hidden in the numbers* Clean up large datasets and identify statistical operations that will answer your questions* Perform financial calculations, database operations, and more—without leaving ExcelExcel Data Analysis For Dummies is the go-to resource for Excel users who are looking for better ways to crunch the numbers. PAUL MCFEDRIES is the owner of Logophilia Limited, a successful technical writing firm. He has 25 years’ experience writing instructional computer books and is the author of over 100 books that have sold a combined 4 million copies worldwide.Introduction 1PART 1: GETTING STARTED WITH DATA ANALYSIS 5Chapter 1: Learning Basic Data-Analysis Techniques 7Chapter 2: Working with Data-Analysis Tools 31Chapter 3: Introducing Excel Tables 55Chapter 4: Grabbing Data from External Sources 77Chapter 5: Analyzing Table Data with Functions 99PART 2: ANALYZING DATA USING PIVOTTABLES AND PIVOTCHARTS 113Chapter 6: Creating and Using PivotTables 115Chapter 7: Performing PivotTable Calculations 137Chapter 8: Building PivotCharts 161PART 3: DISCOVERING ADVANCED DATA-ANALYSIS TOOLS 181Chapter 9: Dealing with Data Models 183Chapter 10: Tracking Trends and Making Forecasts 203Chapter 11: Analyzing Data Using Statistics 227Chapter 12: Analyzing Data Using Descriptive Statistics 245Chapter 13: Analyzing Data Using Inferential Statistics 261PART 4: THE PART OF TENS 279Chapter 14: Ten Things You Ought to Know about Statistics 281Chapter 15: Ten Ways to Analyze Financial Data 293Chapter 16: Ten Ways to Raise Your PivotTable Game 303Appendix: Glossary of Data Analysis and Excel Terms 317Index 327