Computer und IT
Excel 2024
Plötzlich wird Excel ganz leicht. Was immer Sie tun wollen, in diesem Buch finden Sie die passende Anleitung. Rechnen, Tabellen gestalten, Daten sortieren, Diagramme erstellen, Formeln und Funktionen nutzen, Tabellen ausdrucken und vieles andere mehr. Sie sehen Bild für Bild, was zu tun ist. Zusätzlich gibt es eine Menge Vorlagen und Beispiele, die Sie direkt für Ihre Arbeit übernehmen können. So erreichen Sie Ihr Ziel. Garantiert. Aus dem Inhalt: Mit Tabellen arbeitenBereiche kopieren, verschieben, löschenTabellen professionell gestaltenSchnelles Arbeiten mit DesignsZahlen formatierenBedingte FormatierungSchriftarten, -größen und -farben ändernDruckenSeitenumbrüche festlegen und löschenFormeln und FunktionenSumme, Mittelwert, Datum und UhrzeitDiagramme und GrafikenSparklines oder Mini-DiagrammeGrafiken einfügenArbeitsblätter einfügen, umbenennen, verschieben, kopierenListen gekonnt auswertenFenster, Zeilen, Spalten fixierenPDFs erstellen und Daten aus Excel in Word einfügenSerienbriefe auf Basis von Excel-ListenNützliche Vorlagen: Sparplan, Fahrtenbuch, Musterrechnung u. v. m. Vorwort ... 10 Vorlagen und Beispieldateien ... 11 Kapitel 1. Ein erster Überblick ... 12 Excel starten und beenden ... 14 Was ist wo in Excel 2024? ... 16 Das Anwendungsfenster ... 18 Was möchten Sie suchen? ... 20 Befehle über das Menüband aufrufen ... 22 Kontextmenüs nutzen ... 24 Effektiv mit Smarttags arbeiten ... 26 Tastenkombinationen gezielt einsetzen ... 28 Excel auf dem Touchdisplay bedienen ... 30 Die Registerkarte »Zeichnen« ... 32 Kapitel 2. Mit Tabellen arbeiten ... 34 Im Tabellenblatt bewegen ... 36 Daten eingeben, ändern, löschen ... 38 Excel als Taschenrechner ... 42 Einfache Formeln eingeben ... 44 Tipparbeit durch Zeigen reduzieren ... 46 Arbeitsergebnisse speichern ... 48 Eine Arbeitsmappe öffnen ... 50 Eine neue Arbeitsmappe erzeugen ... 52 Kapitel 3. Es geht noch viel schneller! ... 56 Weniger Aufwand durch Autoausfüllen ... 58 Benutzerdefinierte Datenreihen ... 60 Blitzvorschau (Flash Fill) ... 64 Bereiche markieren ... 66 Bereiche kopieren, ausschneiden und löschen ... 68 Drag and Drop ... 70 Zeilen und Spalten einfügen ... 72 Zeilen und Spalten löschen ... 74 Spaltenbreite und Zeilenhöhe ändern ... 76 Überblick: Excel-Cursor ... 80 Kapitel 4. Tabellen professionell gestalten ... 82 Zellen formatieren ... 84 Zellinhalte ausrichten ... 86 Zellen verbinden und Textumbrüche vornehmen ... 88 Zahlen formatieren ... 90 Schriftart, -größe und -farbe von Text ändern ... 94 Rahmenlinien verwenden ... 98 Hintergrundfarbe von Zellen festlegen ... 102 Die Zellformatierung übertragen ... 104 Tabelle drehen ... 106 Einheitliche Gestaltung mit Zellenformatvorlagen ... 108 Intelligente Tabellen mit »Als Tabelle formatieren« ... 110 Mit Designs die gesamte Arbeitsmappe gestalten ... 112 Highlights setzen mit der bedingten Formatierung ... 114 Eigene Regel für die bedingte Formatierung erstellen ... 120 Verbesserung der Barrierefreiheit ... 122 Kapitel 5. Drucken ... 126 Ein erster Druckversuch ... 128 Die Arbeitsmappen-Ansichten ... 130 Die Seitenansicht kontrollieren ... 132 Die Ausrichtung -- hoch oder quer? ... 134 Seitenränder einstellen ... 136 Kopf- und Fußzeilen einfügen ... 138 Seitenumbrüche festlegen und löschen ... 144 Zeilen oder Spalten wiederholen ... 148 Kapitel 6. Formeln und Funktionen ... 150 Formeln als Text wiedergeben mit FORMELTEXT ... 152 Formeln per Ausfüllfunktion erzeugen ... 154 Relative und absolute Adressierung ... 156 Die Funktionsbibliothek ... 160 Sich vom Funktionsassistenten helfen lassen ... 162 Summe, Mittelwert und Co. ... 164 Statistik mit ZÄHLENWENN ... 172 Jahre, Monate, Tage ... 174 Arbeitstage ... 180 Mit dem Datum rechnen ... 182 Eine Geburtstagsliste erstellen ... 186 Mit Zeitangaben rechnen ... 190 Die WENN-Funktion am Beispiel erklärt ... 194 Funktionen verschachteln ... 198 Die Funktionen SVERWEIS und XVERWEIS ... 200 Finanzmathematik? RMZ hilft! ... 206 Einsatz von Variablen für Formeln ... 210 Übersicht über weitere Funktionen ... 214 Kapitel 7. Diagramme und Grafiken ... 224 Diagramme erstellen ... 226 Diagrammelemente bearbeiten und ergänzen ... 232 Den richtigen Diagrammtyp wählen ... 236 Diagramme für besondere Anlässe ... 240 Sparklines oder Minidiagramme ... 242 Der Einsatz von Grafiken ... 246 Einen Screenshot einfügen ... 252 Ein Piktogramm einfügen ... 256 Ein 3D-Modell einfügen und drehen ... 258 Analoge Tabellen per Foto digitalisieren ... 260 Kapitel 8. Arbeitsmappen umfangreich nutzen ... 262 Mehrere Arbeitsmappen verwenden ... 264 Mit Tabellenblättern umgehen ... 266 Der Gruppenmodus ... 272 Tabellenblattübergreifende Formeln ... 276 Arbeitsblätter und Zellen schützen ... 280 Excel im Team nutzen ... 286 Kapitel 9. Listen gekonnt auswerten ... 288 Daten sortieren ... 290 Den AutoFilter anwenden ... 292 Listen gekonnt aufbereiten ... 294 Fenster fixieren -- Zeilen und Spalten feststellen ... 298 Statistik ohne Formeln mithilfe der Pivot-Tabelle ... 300 Daten in der Pivot-Tabelle neu anordnen ... 304 Auswertung nach Jahren und Monaten ... 306 PivotCharts anlegen ... 308 Automatisch erstellte Pivot-Tabellen ... 312 Datenanalyse ... 314 Einen Datenschnitt einfügen ... 316 Neue Datentypen ... 320 Kapitel 10. Zusammenarbeit mit anderen Apps ... 322 Eine PDF der Arbeitsmappe erstellen ... 324 Intelligente Tabellen in Word ... 326 Serienbriefe auf Basis von Excel-Listen ... 330 Kapitel 11. Nützliche Vorlagen ... 336 Persönlicher Jahreskalender ... 338 Sparplan ... 340 Taschengeldverwaltung ... 342 Nordic-Walking-Laufkalender ... 344 Fahrtenbuch ... 346 Turniertabelle ... 348 Musterrechnung allgemein ... 350 Gemischte Musterrechnung mit 7 % und 19 % MwSt. ... 352 Musterrechnung für Kleinunternehmer ... 354 Musterrechnung für Kleinbeträge bis 150 Euro ... 356 Arbeitszeitentabelle ... 358 Stundenplan ... 360 Wichtige Tasten und Tastenkombinationen ... 362 Glossar ... 363 Stichwortverzeichnis ... 377
Excel 2024
Ein Handbuch randvoll mit praktischen Lösungen zu allen nur denkbaren Aufgaben mit Excel 2024 und Excel 365! Sie erfahren unter anderem, wie Sie Tabellen gestalten, Formeln zur Berechnung einsetzen, Analysen erstellen und Ihre Daten und Ergebnisse grafisch aufbereiten und mit anderen teilen. Auch Einsteiger werden hier Schritt für Schritt von den allerersten Grundlagen und Funktionen bis zu den anspruchsvollen Anwendungen angeleitet. Somit eignet sich das Handbuch gleichermaßen zum Erlernen des Programms wie als zuverlässiges Nachschlagewerk für die tägliche Arbeit. Auch für Excel 2021, 2019 und 2016 geeignet. Aus dem Inhalt: Basiswissen für die Arbeit mit Excel 2024Excel auf dem Touchscreen bedienenAufbau von KalkulationstabellenMit Formeln arbeitenTabellenblätter gestaltenAuswertungen und Was-wäre-wenn-AnalysenZielwertsuche und Solver nutzenDaten grafisch präsentierenDiagramme optimal einsetzenDatenvisualisierung mit SparklinesTabellen grafisch aufbereitenDokumente für die Veröffentlichung vorbereitenArbeitsmappen veröffentlichenExcel-Daten im WebArbeit im TeamTabellenfunktionenInformationen als Tabellen ordnen und verwaltenDatenabfragen und -auszügePivot-Tabellen und -DiagrammeArbeit mit externen DatenDaten mit anderen Anwendungen austauschenDen neuen Copiloten richtig einsetzenRoutineaufgaben mit Makros automatisierenVisual Basic für ApplikationenExcel-App Vorwort ... 27 1. Basiswissen für die Arbeit mit Excel ... 30 1.1 ... Einsteigen mit einem Kostenvergleich ... 30 1.2 ... Ein paar Grundbegriffe vorweg ... 40 1.3 ... Excel starten und beenden ... 45 1.4 ... Baustelle für Tabellen und Diagramme ... 50 1.5 ... Dateiformate ... 80 1.6 ... Optionen für die Arbeit mit Excel ... 88 1.7 ... Add-Ins für Office ... 100 1.8 ... Umgang mit Dokumenten ... 102 1.9 ... Speichern in der Cloud ... 135 1.10 ... Hilfe in Excel ... 138 2. Aufbau von Kalkulationstabellen ... 141 2.1 ... Planung und Design von Kalkulationsmodellen ... 141 2.2 ... Navigation und Bereichsauswahl ... 146 2.3 ... Effektive Dateneingabe und Datenänderung ... 159 2.4 ... Daten automatisch erzeugen ... 179 2.5 ... Prüfung der Dateneingabe ... 190 2.6 ... Arbeitsblätter neu organisieren und umbauen ... 196 2.7 ... Effektiver Umgang mit Arbeitsmappen ... 223 3. Mit Formeln arbeiten ... 241 3.1 ... Der Aufbau von Formeln ... 241 3.2 ... Eingabe von Formeln und Funktionen ... 250 3.3 ... Relative und absolute Bezüge ... 268 3.4 ... Beschreibende Bereichsnamen ... 275 3.5 ... Matrixformeln ... 288 3.6 ... Qualität sichern und Fehler vermeiden ... 295 3.7 ... Tabellen mit Formeln verknüpfen ... 309 3.8 ... Auswirkung der Entfernung von Zellen ... 314 3.9 ... Kontrolle der Neuberechnung ... 314 4. Tabellenblätter gestalten ... 321 4.1 ... Wahl des Zahlenformats ... 324 4.2 ... Schriftgestaltung und Ausrichtung ... 342 4.3 ... Rahmen und Muster ... 358 4.4 ... Blätter mit Designs schmücken ... 368 4.5 ... Blätter und Mappen schützen ... 373 4.6 ... Einheitliche Gestaltung mit Formatvorlagen ... 377 4.7 ... Tabellenformatvorlagen ... 385 4.8 ... Datenanalyse mit bedingten Formaten ... 390 4.9 ... Mehr Übersicht durch Gliederungsebenen ... 401 4.10 ... Dateneingabe über Steuerelemente ... 408 5. Auswertung und Prognose ... 411 5.1 ... Berechnungen ohne Formeln ... 411 5.2 ... Ergebnisse konsolidieren ... 413 5.3 ... Add-In für statistische Datenanalyse ... 418 5.4 ... Was wäre, wenn ... ... 421 5.5 ... Planspiele mit Szenarios ... 425 5.6 ... Prognose aufgrund vorhandener Daten ... 436 5.7 ... Automatische Datenanalyse ... 440 6. Optimierung ... 442 6.1 ... Zielwertsuche ... 442 6.2 ... Lösungen mit dem Solver suchen ... 444 7. Daten grafisch präsentieren ... 458 7.1 ... Grafische Auswertung mit Diagrammen ... 458 7.2 ... Diagrammtypen in Excel ... 463 7.3 ... Von der Tabelle zum Diagramm ... 465 7.4 ... Zur Verknüpfung von Tabelle und Diagramm ... 477 7.5 ... Diagramme optimieren ... 480 7.6 ... Diagramme gestalten ... 488 8. Diagramme optimal einsetzen ... 519 8.1 ... Standarddiagramme ... 519 8.2 ... Wertdifferenzierung mit Flächen- und Spannweitendiagrammen ... 527 8.3 ... Mehrfachverteilung und Zyklen -- Ring- und Netzdiagramme ... 530 8.4 ... Wertebeziehungen -- xy-Diagramme und Blasendiagramme ... 533 8.5 ... Kombidiagramme ... 536 8.6 ... 3D-Optik und echte 3D-Diagramme ... 538 8.7 ... 3D-Oberflächendiagramme -- für kontinuierliche Darstellungen ... 545 8.8 ... Neuere Diagrammtypen ... 547 8.9 ... Dreidimensionale Karten ... 553 9. Datenvisualisierung mit Sparklines ... 557 9.1 ... Merkmale und Verwendungsmöglichkeiten ... 557 9.2 ... Einfügen von Sparklines ... 558 9.3 ... Darstellungsvarianten ... 561 9.4 ... Bearbeiten von Sparklines ... 562 10. Tabellenblätter grafisch aufbereiten ... 567 10.1 ... Vorgegebene und freie Formen zeichnen ... 568 10.2 ... Feinarbeit an grafischen Objekten ... 578 10.3 ... Organigramme im Schnellgang ... 596 10.4 ... Grafiken übernehmen und bearbeiten ... 597 10.5 ... Piktogramme nutzen ... 609 10.6 ... 3D-Modelle und 3D-Karten ... 611 10.7 ... Freihandzeichnen ... 615 10.8 ... Bilder aus dem Netz fischen ... 618 10.9 ... Schnappschüsse von Tabellen ... 619 11. Dokumente für die Veröffentlichung vorbereiten ... 621 11.1 ... Dokumentinspektion ... 621 11.2 ... Dokumente verschlüsseln ... 629 12. Arbeitsmappen veröffentlichen ... 630 12.1 ... Vorbereitung von Arbeitsblättern zum Druck ... 630 12.2 ... Druckerauswahl und Druckereinstellungen ... 653 12.3 ... Tabellen per E-Mail versenden ... 658 12.4 ... Erstellen einer PDF- oder XPS-Kopie ... 659 13. Excel-Daten im Web ... 661 13.1 ... Von Excel zu HTML und zurück ... 662 13.2 ... Daten für das Web bereitstellen ... 664 13.3 ... Dokumente mit Hyperlinks verknüpfen ... 667 13.4 ... Verarbeiten von XML-Daten ... 676 14. Gemeinsame Arbeit an Arbeitsmappen ... 687 14.1 ... Teamarbeit in lokalen Netzen ... 687 14.2 ... Teamarbeit über OneDrive ... 693 15. Tabellenfunktionen ... 699 15.1 ... Mit Excel 2013 eingeführte Funktionen ... 699 15.2 ... Neue Funktionen seit Excel 2016 ... 701 15.3 ... Neue Funktionen seit Excel 2021 ... 701 15.4 ... Aufbau und Einsatz von Funktionen ... 702 15.5 ... Finanzmathematische Funktionen ... 704 15.6 ... Datums- und Zeitfunktionen ... 716 15.7 ... Mathematische Funktionen ... 722 15.8 ... Statistische Funktionen ... 737 15.9 ... Nachschlage- und Verweisfunktionen ... 757 15.10 ... Datenbankfunktionen ... 775 15.11 ... Cube-Funktionen ... 777 15.12 ... Textfunktionen ... 779 15.13 ... Logische Funktionen ... 788 15.14 ... Informationsfunktionen ... 801 15.15 ... Technische Funktionen ... 803 15.16 ... Webfunktionen ... 810 16. Informationen als Tabellen ordnen und verwalten ... 812 16.1 ... Möglichkeiten für den Einsatz von Tabellen ... 813 16.2 ... Die Struktur von Tabellen definieren ... 814 16.3 ... Tabellenbereiche ... 818 16.4 ... Daten sortieren ... 828 16.5 ... Daten in Gruppen zusammenfassen ... 838 17. Datenabfragen und Datenauszüge ... 843 17.1 ... Relevante Daten herausfiltern ... 843 17.2 ... Komplexe Abfragen mit Spezialfiltern ... 857 17.3 ... Weiterverarbeitung gefilterter Daten ... 866 17.4 ... Berechnungen mit Datenbankfunktionen ... 867 18. Pivot-Tabellen und -Diagramme ... 869 18.1 ... Datenanalyse mit Pivot-Tabellen ... 872 18.2 ... Dynamische Diagramme aus Pivot-Tabellen ... 922 18.3 ... Datenmodelle mit mehreren Tabellen ... 925 18.4 ... Power Pivot ... 929 18.5 ... Veröffentlichen auf Power BI ... 940 19. Arbeit mit externen Daten ... 941 19.1 ... Access-Daten importieren ... 944 19.2 ... Zugriff auf SQL-Server-Datenbanken ... 949 19.3 ... Abfrage von XML-Dateien ... 952 19.4 ... Einlesen einer CSV-Datei ... 955 19.5 ... Arbeit mit verknüpften Datentypen ... 958 19.6 ... Daten aus Bildern übernehmen ... 963 19.7 ... Direkte Abfragen im Internet ... 965 20. Export und Import von Dateien ... 968 20.1 ... Unterstützte Dateiformate ... 968 20.2 ... Import von Textdateien ... 973 20.3 ... Texte auf Spalten verteilen ... 978 21. Daten mit anderen Anwendungen austauschen ... 979 21.1 ... Austausch über die Zwischenablage ... 979 21.2 ... Dateien dynamisch verknüpfen ... 984 21.3 ... Einsatz von verknüpften Objekten ... 986 22. Routineaufgaben mit Makros automatisieren ... 988 22.1 ... Makros aufzeichnen ... 988 22.2 ... Makros in den Arbeitsablauf einbinden ... 996 22.3 ... Eine Tabelle per Makro kippen ... 1000 22.4 ... Makros für die Diagrammgestaltung ... 1004 22.5 ... Makros von älteren Excel-Versionen ... 1005 23. Visual Basic für Applikationen ... 1006 23.1 ... Grundlagen von VBA ... 1006 23.2 ... Die Entwicklungsumgebung ... 1026 23.3 ... Ein- und Ausgabe ... 1045 23.4 ... Entwurf von Formularen ... 1054 23.5 ... Tabellenfunktionen in VBA ... 1064 24. Preview ... 1069 24.1 ... Office-Skripts: Die Alternative zu Makros ... 1069 24.2 ... Copilot: Der nützliche Begleiter ... 1072 Anhang ... 1075 A ... Funktionstasten, Tasten und Tastenkombinationen ... 1075 Stichwortverzeichnis ... 1083
Office 2024
Alle Office-Programme auf einen Blick! Dieses Buch führt Sie durch Ihre tägliche Arbeit mit Word, Excel, PowerPoint und Outlook und erklärt unter anderem auch, wie Sie mit Teams an einer Videokonferenz teilnehmen. Direkt am Bild sehen Sie Schritt für Schritt, wie Sie die Programme gekonnt für sich nutzen. E-Mails verschicken, Kalkulationen erstellen, Briefe schreiben, Präsentationen gestalten: Folgen Sie einfach Klick für Klick den Anleitungen. Aus dem Inhalt: Maus und Touchpad bedienenProgramme aufrufen und schließenEin Dokument anlegen und bearbeitenDokumente speichern und druckenTexte in Word schreiben und formatierenDie Rechtschreibprüfung einsetzenSchnellbausteine nutzenEine Tabelle einfügen und bearbeitenEin Inhaltsverzeichnis erstellenSchicke Layouts mit WordFotos und Videos einfügenMit Excel rechnenText und Zahlen in Zellen eingebenFormeln und FunktionenAbsolute und relative ZellbezügeDiagramme mit Excel erstellenListen und Datenbanken in ExcelDaten in ein Universalformat exportierenE-Mails schreiben mit OutlookEin E-Mail-Konto einrichten und testenSignaturen einrichten und Designs verwendenSchutz vor Phishing und SpamMit Outlook Termine planenSich an Termine erinnern lassenKontakte und Adressen in Outlook verwaltenMit PowerPoint präsentierenVon der Gliederung zur FoliePräsentationen kreativ gestaltenPräsentationen speichern und druckenEine Präsentation erfolgreich vorführenEine Präsentation als Video für das Web erstellenSeriendruck in OfficeOffice-Dokumente online bearbeitenVideokonferenzen mit Teams führenDen neuen Copiloten gezielt einsetzen 1. Start mit Office ... 10 Programme aufrufen und schließen ... 12 Das Office-Fenster kennenlernen ... 18 Das Fenster vergrößern und verkleinern ... 20 Ein neues Dokument anlegen ... 22 Die Ansicht des Dokuments anpassen ... 24 Ein Dokument speichern ... 26 Dokumente in der Cloud speichern ... 28 Dokumente drucken oder exportieren ... 32 Ein Dokument schließen ... 34 Dateien organisieren und wiederfinden ... 36 2. Texte schreiben in Word ... 38 Word optimal einstellen ... 40 Der Bildschirm im Touchmodus ... 44 Papierformat und Seitenrand einstellen ... 46 Text eingeben ... 48 Im Text bewegen -- mit der Maus oder den Fingern ... 50 Textpassagen markieren ... 52 Text löschen, ändern und ergänzen ... 54 Text ausschneiden, kopieren und einfügen ... 56 Verschieben und kopieren mit Drag & Drop ... 58 Text von Hand korrigieren ... 60 Die Rechtschreibprüfung einsetzen ... 62 Arbeitserleichterung durch die AutoKorrektur ... 66 Schnellbausteine nutzen ... 68 Datum per Tabulator ausrichten ... 70 Automatisches Datum per Feldbefehl ... 72 Dokumente im Team bearbeiten ... 74 3. Texte in Word perfekt formatieren ... 78 Text ausrichten: rechts, links oder zentriert ... 80 Schriftart und -größe einstellen ... 82 Schriftformate festlegen: fett, kursiv und unterstrichen ... 84 Schriftzüge mit Farben und Texteffekten gestalten ... 86 Textpassagen einrücken ... 88 Eine Tabelle einfügen ... 90 Eine Tabelle bearbeiten und attraktiv gestalten ... 92 Mit Formatvorlagen arbeiten ... 96 Formatvorlagen anpassen ... 98 Überschriften nummerieren ... 100 Ein Inhaltsverzeichnis erstellen ... 102 Kopf- und Fußzeilen anlegen ... 104 Seitenzahlen einfügen ... 106 Das aktuelle Datum per Feldbefehl einfügen ... 108 Silbentrennung ... 110 Ein Dokument ausdrucken ... 112 PDF-Dateien in Word öffnen und bearbeiten ... 114 4. Schicke Layouts mit Word ... 116 Aufzählungen und Listen formatieren ... 118 Rahmen und Rahmenlinien einfügen ... 122 Dokumente mit Design ... 124 Fotos einfügen und anordnen ... 126 3D-Modelle einfügen ... 130 Mehr Pep mit WordArt und SmartArt ... 132 Eine eigene Dokumentvorlage erstellen ... 134 5. Mit Excel rechnen ... 136 Der Excel-Bildschirm ... 138 Text und Zahlen in Zellen eingeben ... 140 Tabellenblätter nutzen ... 142 Datenreihen für die rationelle Dateneingabe ... 144 Markieren und gestalten ... 146 Zellinhalte löschen und korrigieren ... 150 Zeilen und Spalten einfügen ... 152 Tabellen mit Flash Fill vervollständigen lassen ... 154 Summen erzeugen ... 156 Formeln für die Grundrechenarten ... 158 Mittelwert und Minimal-/Maximalwerte ... 162 Die WENN-Funktion nutzen ... 164 Funktionen für Datum und Uhrzeit ... 168 Absolute und relative Zellbezüge ... 170 Zellinhalte verknüpfen ... 172 6. Diagramme mit Excel erstellen ... 174 Ein Säulendiagramm erzeugen ... 176 Ein Säulendiagramm nachbearbeiten ... 178 Anteile in Kreisdiagrammen darstellen ... 182 Ein »Tortenstück« herausrücken ... 186 Kleine Diagramme mit Sparklines ... 188 7. Listen und Datenbanken in Excel ... 190 Daten in eine Liste eintragen ... 192 Daten in Listen sortieren ... 194 Auswählen und filtern ... 196 Eine Datenbanktabelle planen ... 200 Daten in ein Universalformat exportieren ... 204 8. E-Mails schreiben mit Outlook ... 208 Den Outlook-Bildschirm kennenlernen ... 210 Die Ordner und Ansichten von Outlook ... 212 Ein E-Mail-Konto einrichten ... 216 E-Mails lesen -- der Posteingang ... 218 E-Mails schreiben und versenden ... 220 E-Mails mit Anlagen versenden ... 224 Neue E-Mails abrufen ... 226 E-Mails beantworten ... 228 Signaturen einrichten ... 230 Schutz vor Phishing und Spam ... 232 E-Mails archivieren ... 236 9. Mit Outlook Termine planen ... 238 Termine eintragen, verschieben und löschen ... 240 Termine nachbearbeiten und weiterleiten ... 242 Wiederkehrende Termine ... 244 Sich an Termine erinnern lassen ... 246 Eine Notiz anlegen ... 250 10. Kontakte und Adressen in Outlook verwalten ... 252 Die verschiedenen Ansichten für Kontakte ... 254 Einen neuen Kontakt anlegen ... 256 Kontaktdaten ändern ... 258 Kontakte sortieren und gruppieren ... 260 Eine E-Mail an mehrere Kontakte schreiben ... 262 Das Adressbuch ausdrucken ... 264 Adressen exportieren ... 266 11. Mit PowerPoint präsentieren ... 268 Die schnelle Präsentation per Assistent ... 270 Das passende Layout für eine Folie finden ... 272 Text einfügen und bearbeiten ... 274 Attraktive Folienübergänge erzeugen ... 276 Ein anderes Design auswählen ... 278 Von der Gliederung zur Folie ... 280 12. Präsentationen kreativ gestalten ... 282 Online-Grafiken suchen und einfügen ... 284 Bilddateien einfügen und anordnen ... 286 Linien, Rechtecke, Pfeile und andere Formen ... 288 Objekte färben und füllen ... 290 Objekte kopieren und gruppieren ... 292 Schrift- und andere Animationseffekte ... 294 Musik für Ihre Präsentation ... 298 Ein Video in die Präsentation einbetten ... 300 Präsentationen speichern und drucken ... 302 Eine Präsentation erfolgreich vorführen ... 304 Eine Präsentation als Video erstellen ... 306 13. Seriendruck in Office ... 308 Die Serienbrieffunktion von Word ... 310 Die Seriendruckfelder einfügen ... 312 Das Outlook-Adressbuch als Datenquelle nutzen ... 316 Eine Excel-Adressliste als Datenquelle nutzen ... 318 Daten filtern und sortieren ... 320 Den Serienbrief drucken ... 322 14. Office und das Internet ... 324 Ein Office-Dokument per E-Mail versenden ... 326 Office-Dokumente online bearbeiten ... 328 15. Teamarbeit mit Teams ... 330 Mit Teams chatten ... 332 Eine Konferenz mit Teams abhalten ... 334 Eine Besprechung planen ... 340 Glossar ... 342 Stichwortverzeichnis ... 353
Adobe Firefly
KI ist das Zukunftsthema für alle Gestalter und Gestalterinnen: Dieses Buch bringt Ihnen die Welt von KI im Grafikdesign nahe und legt dabei einen besonderen Schwerpunkt auf die Adobe-Programme. Die beiden Autorinnen vermitteln Ihnen grundlegende Konzepte, die Einbindung von KI in den kreativen Prozess sowie die Kunst des effektiven Promptings. Vor allem aber erleben Sie Adobe Firefly in der Praxis: Sie erstellen effektive Text- oder Bildprompts, die exakt die gewünschten Bilder liefern. Sie fügen Objekte ein oder entfernen störende Elemente und wandeln einfache Skizzen in professionelle Grafiken um. Auch der Einsatz von KI in Photoshop, Illustrator und Adobe Express wird ausführlich behandelt, und zwar mit einem besonderen Fokus auf das Generative Füllen, Erweitern und Neufärben. Praxisbeispiele runden das Buch ab. Lassen Sie Ihre Ideen Wirklichkeit werden! Aus dem Inhalt: KI im Kreativprozess anwenden für Ideenfindung, Research, Komposition u. a.Grundlagen von Adobe Firefly und die Integration in den eigenen WorkflowGrundlagen des PromptingsProfessionelle Prompts mit Firefly, Text zu Bild, negative PromptsVerwenden von Referenzbildern zum Anpassen an einen StilVarianten über Seitenverhältnis, Stil, Stilreferenzen, Farbe, Effekte und Beleuchtung erstellenTexteffekte und das Hinzufügen von Formen und ElementenEinführung in die KI-Funktionen von Adobe ExpressInteraktion von Firefly mit Photoshop und Illustrator: Generatives Füllen, Erweitern und NeufärbenTeilen von KI-Werken in Galerie und Creative Cloud Einleitung ... 15 1. Grundwissen KI ... 21 1.1 ... Definition von künstlicher Intelligenz ... 21 1.2 ... Grundlegende Konzepte von Data Science bis generative KI ... 24 1.3 ... Rechtliche Grundlagen ... 36 1.4 ... Ethische Grundsätze bei der Nutzung von KI ... 44 2. KI für Kreative: Werkzeuge und Möglichkeiten ... 55 2.1 ... Kreative und die KI ... 56 2.2 ... KI in der Ideenfindung ... 63 2.3 ... KI und Research ... 71 2.4 ... KI revolutioniert die Komposition ... 80 2.5 ... KI in der Reinzeichnung ... 84 2.6 ... KI auch in der Distribution ... 87 3. Einführung in das Prompting ... 97 3.1 ... Arten von Prompts ... 97 3.2 ... Einen Prompt aufbauen in Firefly ... 101 3.3 ... Probleme beim Prompting ... 108 3.4 ... Praktische Hilfen zur Erstellung von Prompts ... 114 4. Adobe Firefly ... 121 4.1 ... Überblick über Firefly ... 121 4.2 ... Die Oberfläche von Adobe Firefly ... 129 4.3 ... Die Funktion »Text zu Bild« ... 133 4.4 ... Tipps für gelungene Prompts in Adobe Firefly ... 161 4.5 ... Schriftzüge und Texteffekte ... 171 4.6 ... Generative Bearbeitung bestehender Bilder ... 176 4.7 ... Exportieren und Teilen von generierten Bildern ... 188 4.8 ... Adobe Firefly im Kreativprozess ... 192 4.9 ... Künftige Anwendungen von Adobe Firefly ... 196 5. Einsatz von KI in Adobe Stock ... 207 5.1 ... Grundlegende Funktionen in Adobe Stock ... 208 5.2 ... Überblick über die KI-Funktionen in Adobe Stock ... 215 5.3 ... Prompting in Adobe Stock ... 219 6. Einsatz von KI in Adobe Express ... 227 6.1 ... Überblick über die Basisfunktionen in Adobe Express ... 227 6.2 ... Überblick über die KI-Funktionen in Adobe Express ... 239 6.3 ... Texteffekte generieren ... 252 7. Einsatz von KI in Adobe Photoshop ... 261 7.1 ... KI-Funktionen in Dialogfeldern und Optionsleisten ... 261 7.2 ... KI-Funktionen zur Bearbeitung von Hintergründen in Photoshop ... 265 7.3 ... Entfernen von Objekten ... 281 7.4 ... Generieren von Objekten in Photoshop über generatives Füllen ... 285 7.5 ... Die Funktion »Bild generieren« ... 294 7.6 ... Prompting-Tipps für Adobe Photoshop ... 300 8. Einsatz von KI in Adobe Illustrator ... 309 8.1 ... Workflow-Optimierung durch KI-Funktionen ... 309 8.2 ... Vektorgrafiken generieren ... 311 8.3 ... Generative Neufärbung ... 326 8.4 ... Generative Formfüllung ... 329 8.5 ... Muster generieren ... 338 8.6 ... Prompting-Tipps für Adobe Illustrator ... 341 9. Einsatz von KI in Adobe InDesign ... 351 9.1 ... Zugriff auf die KI-Funktionen in Adobe InDesign ... 351 9.2 ... Bilder generieren ... 352 9.3 ... Bilder erweitern ... 360 9.4 ... Prompting-Tipps für Adobe InDesign ... 362 Index ... 364
Natural Language Processing for Software Engineering
DISCOVER HOW NATURAL LANGUAGE PROCESSING FOR SOFTWARE ENGINEERING CAN TRANSFORM YOUR UNDERSTANDING OF AGILE DEVELOPMENT, EQUIPPING YOU WITH ESSENTIAL TOOLS AND INSIGHTS TO ENHANCE SOFTWARE QUALITY AND RESPONSIVENESS IN TODAY’S RAPIDLY CHANGING TECHNOLOGICAL LANDSCAPE.Agile development enhances business responsiveness through continuous software delivery, emphasizing iterative methodologies that produce incremental, usable software. Working software is the main measure of progress, and ongoing customer collaboration is essential. Approaches like Scrum, eXtreme Programming (XP), and Crystal share these principles but differ in focus: Scrum reduces documentation, XP improves software quality and adaptability to changing requirements, and Crystal emphasizes people and interactions while retaining key artifacts. Modifying software systems designed with Object-Oriented Analysis and Design can be costly and time-consuming in rapidly changing environments requiring frequent updates. This book explores how natural language processing can enhance agile methodologies, particularly in requirements engineering. It introduces tools that help developers create, organize, and update documentation throughout the agile project process. RAJESH KUMAR CHAKRAWARTI, PHD, is a dean and professor in the Department of Computer Science and Engineering at Sushila Devi Bansal College, Bansal Group of Institutions, India. He has over 20 years of professional experience in academia and industry. Additionally, he has organized and attended over 200 seminars, workshops, and conferences and has published over 100 research papers and book chapters in nationally and internationally revered publications. RANJANA SIKARWAR is currently pursuing a PhD from Amity University, Gwalior. She completed her Bachelor of Engineering in 2006 and Master of Technology in Computer Science and Engineering in 2015. Her research interests include social network analysis, graph mining, machine learning, Internet of Things, and deep learning. SANJAYA KUMAR SARANGI, PHD, is an adjunct professor and coordinator at Utkal University with over 23 years of experience in the academic, research, and industry sectors. He has a number of publications in journals and conferences, has authored many textbooks and book chapters, and has more than 30 national and international patents. He is an active member and life member of many associations, as well as an editor, technical program committee member, and reviewer in reputed journals and conferences. He has dedicated his career to advancing information and communication technology to enhance and optimize worldwide research and information dissemination, leading to improved student learning and teaching methods. SAMSON ARUN RAJ ALBERT RAJ, PHD, is an assistant professor and placement coordinator in the Division of Computer Science and Engineering, School of Computer Science and Technology, Karunya Institute of Technology and Sciences, Tamil Nadu, India. His research is focused on smart city development using drone networks and energy grids with various applications, and his areas of expertise include wireless sensor networks, vehicular ad-hoc networks, and intelligent transportation systems. SHWETA GUPTA is an assistant professor in the Computer Science and Engineering Department at Medicaps University, Indore (M.P.), India. She focuses on natural language processing, data mining, and machine learning. She aims to close the knowledge gap between theory and real-world applications in the tech sector through her passion for research and teaching. Her approach centers on encouraging creativity and motivating students to strive for technological excellence. KRISHNAN SAKTHIDASAN SANKARAN, PHD, is a professor in the Department of Electronics and Communication Engineering at Hindustan Institute of Technology and Science, India. He has been a senior member of the Institute of Electrical and Electronics Engineers for the past ten years and has published more than 70 papers in refereed journals and international conferences. He has also published three books to his credit. His research interests include image processing, wireless networks, cloud computing, and antenna design. ROMIL RAWAT has attended several research programs and received research grants from the United States, Germany, Italy, and the United Kingdom. He has chaired international conferences and hosted several research events, in addition to publishing several research patents. His research interests include cybersecurity, Internet of Things, dark web crime analysis and investigation techniques, and working towards tracing illicit anonymous contents of cyber terrorism and criminal activities.
AWS Certified Developer Study Guide
THE AWS CERTIFIED DEVELOPER EXAM HAS BEEN UPDATED. YOUR STUDY GUIDE SHOULD BE, TOO.The AWS Certified Developer Study Guide–Associate (DVA-C02) Exam is your ultimate preparation resource for the latest exam! Covering the exam objectives, this invaluable resource provides expert guidance, clear explanations, and the wisdom of experience with AWS best practices. You’ll master core services and basic architecture, and equip yourself to develop, deploy, and debug cloud-based applications using AWS.The AWS Developer certification is earned by those who demonstrate the technical knowledge and skill associated with best practices for building secure, reliable cloud-based applications using AWS technology. This book is your exam prep companion, providing everything you need to know to pass with flying colors.* Study the AWS Certified Developer Exam objectives* Gain expert insight on core AWS services and best practices* Test your understanding of key concepts with challenging chapter questions* Access online study tools including practice questions, electronic flashcards, a searchable glossary, and moreWhen you’re ready to get serious about your cloud credentials, the AWS Certified Developer Study Guide–Associate Exam is the resource you need to pass the exam with flying colors.
A Beginner's Guide To Web Application Penetration Testing
A HANDS-ON, BEGINNER-FRIENDLY INTRO TO WEB APPLICATION PENTESTINGIn A Beginner's Guide to Web Application Penetration Testing, seasoned cybersecurity veteran Ali Abdollahi delivers a startlingly insightful and up-to-date exploration of web app pentesting. In the book, Ali takes a dual approach—emphasizing both theory and practical skills—equipping you to jumpstart a new career in web application security. You'll learn about common vulnerabilities and how to perform a variety of effective attacks on web applications. Consistent with the approach publicized by the Open Web Application Security Project (OWASP), the book explains how to find, exploit and combat the ten most common security vulnerability categories, including broken access controls, cryptographic failures, code injection, security misconfigurations, and more. A Beginner's Guide to Web Application Penetration Testing walks you through the five main stages of a comprehensive penetration test: scoping and reconnaissance, scanning, gaining and maintaining access, analysis, and reporting. You'll also discover how to use several popular security tools and techniques—like as well as:* Demonstrations of the performance of various penetration testing techniques, including subdomain enumeration with Sublist3r and Subfinder, and port scanning with Nmap* Strategies for analyzing and improving the security of web applications against common attacks, including* Explanations of the increasing importance of web application security, and how to use techniques like input validation, disabling external entities to maintain securityPerfect for software engineers new to cybersecurity, security analysts, web developers, and other IT professionals, A Beginner's Guide to Web Application Penetration Testing will also earn a prominent place in the libraries of cybersecurity students and anyone else with an interest in web application security. ALI ABDOLLAHI is a cybersecurity researcher with over 12 years of experience. Currently, he is the application and offensive security manager at Canon EMEA. He studied computer engineering, published articles, and holds several professional certificates. Ali is a Microsoft MVP and regular speaker or trainer at industry conferences and events. Foreword xviiIntroduction xixCHAPTER 1 INTRODUCTION TO WEB APPLICATION PENETRATION TESTING 1The Importance of Web Application Security 3Overview of Web Application Penetration Testing 6The Penetration Testing Process 8Methodologies 12Tools and Techniques 14Reporting 16Types of Web Application Vulnerabilities 17Key Takeaways 25CHAPTER 2 SETTING UP YOUR PENETRATION TESTING ENVIRONMENT 27Setting Up Virtual Machines 28Container Option 29Kali Linux Installation 30PentestBox 34Installing DVWA 35OWASP Juice Shop 40Burp Suite 41OWASP ZED Attack Proxy 46WILEY Preconfigured Environment 49Key Takeaways 49CHAPTER 3 RECONNAISSANCE AND INFORMATION GATHERING 51Passive Information Gathering 52Automating Subdomain Enumeration 61Active Information Gathering 64Open-Source Intelligence Gathering 77Key Takeaways 88CHAPTER 4 CROSS-SITE SCRIPTING 89XSS Categories 90Reflected XSS 91Stored XSS 93Automatic User Session Hijacking 94Website Defacement Using XSS 96DOM-Based XSS 97Self-XSS 98Browser Exploitation Framework 100XSS Payloads and Bypasses 102XSS Mitigation Techniques 105Reflected XSS Bypass Techniques 107Stored XSS Bypass Technique 110Key Takeaways 112CHAPTER 5 SQL INJECTION 113What Is SQL Injection? 113Types of SQL Injection 114Error-Based SQL Injection 117Union-Based SQL Injection 117Blind SQL Injection 123SQLMap 126SQL Injection Payloads with ChatGPT 140SQL Injection Prevention 142Key Takeaways 145CHAPTER 6 CROSS-SITE REQUEST FORGERY 147Hunting CSRF Vulnerability 149CSRF Exploitation 149XSS and CSRF 151Clickjacking 152Generating an Effective Proof of Concept Using ChatGPT 154Tips for Developers 157Key Takeaways 158CHAPTER 7 SERVER-SIDE ATTACKS AND OPEN REDIRECTS 159Server-Side Request Forgery 159SSRF in Action 160SSRF Vulnerability 162Blind SSRF 164Local File Inclusion 166Remote File Inclusion 170Open Redirect 173Server-Side Attacks Differences 177Security Mitigations 178Key Takeaways 181CHAPTER 8 XML-BASED ATTACKS 183XML Fundamentals 183XXE Exploitation 185Hunting XML Entry Points 187SSRF Using XXE 192DoS Using XXE 193XXE Payload and Exploitation with ChatGPT 195XML-Based Attacks Countermeasures 196Key Takeaways 198CHAPTER 9 AUTHENTICATION AND AUTHORIZATION 201Password Cracking and Brute-Force Attacks 205Credential Stuffing Attack 211Password Spraying 213Password Spraying Using Burp Suite Intruder 214Other Automated Tools for Password Attacks 215JSON Web Token 223Key Takeaways 225CHAPTER 10 API ATTACKS 227OWASP API Top 10 228API Enumeration and Discovery 230API Discovery Using ChatGPT 231API Broken Object-Level Authorization Exploitation 235Rate Limiting 240API Penetration Testing Tools 242API Security Tips 244Key Takeaways 245APPENDIX A BEST PRACTICES AND STANDARDS 247Information Gathering 248Configuration and Deployment Management Testing 251Identity Management Testing 254Authentication Testing 256Authorization Testing 261Session Management Testing 265Input Validation Testing 273Testing for Error Handling 285Testing for Weak Cryptography 286Business Logic Testing 290Client-Side Testing 297APPENDIX B CWE AND CVSS SCORE 307Base Score 308Temporal Score 308Environmental Score 309APPENDIX C WRITING EFFECTIVE AND COMPREHENSIVE PENETRATION TESTING REPORTS 311Table of Contents (ToC) 311Project History and Timeline 311Scope 312Testing Approach 312Executive Summary 312Industry Standard 312Findings Table 312Findings Details 313Key Takeaways 315Index 317
AWS Certified Developer Study Guide
THE AWS CERTIFIED DEVELOPER EXAM HAS BEEN UPDATED. YOUR STUDY GUIDE SHOULD BE, TOO.The AWS Certified Developer Study Guide–Associate (DVA-C02) Exam is your ultimate preparation resource for the latest exam! Covering the exam objectives, this invaluable resource provides expert guidance, clear explanations, and the wisdom of experience with AWS best practices. You’ll master core services and basic architecture, and equip yourself to develop, deploy, and debug cloud-based applications using AWS.The AWS Developer certification is earned by those who demonstrate the technical knowledge and skill associated with best practices for building secure, reliable cloud-based applications using AWS technology. This book is your exam prep companion, providing everything you need to know to pass with flying colors.* Study the AWS Certified Developer Exam objectives* Gain expert insight on core AWS services and best practices* Test your understanding of key concepts with challenging chapter questions* Access online study tools including practice questions, electronic flashcards, a searchable glossary, and moreWhen you’re ready to get serious about your cloud credentials, the AWS Certified Developer Study Guide–Associate Exam is the resource you need to pass the exam with flying colors.
A Beginner's Guide To Web Application Penetration Testing
A HANDS-ON, BEGINNER-FRIENDLY INTRO TO WEB APPLICATION PENTESTINGIn A Beginner's Guide to Web Application Penetration Testing, seasoned cybersecurity veteran Ali Abdollahi delivers a startlingly insightful and up-to-date exploration of web app pentesting. In the book, Ali takes a dual approach—emphasizing both theory and practical skills—equipping you to jumpstart a new career in web application security. You'll learn about common vulnerabilities and how to perform a variety of effective attacks on web applications. Consistent with the approach publicized by the Open Web Application Security Project (OWASP), the book explains how to find, exploit and combat the ten most common security vulnerability categories, including broken access controls, cryptographic failures, code injection, security misconfigurations, and more. A Beginner's Guide to Web Application Penetration Testing walks you through the five main stages of a comprehensive penetration test: scoping and reconnaissance, scanning, gaining and maintaining access, analysis, and reporting. You'll also discover how to use several popular security tools and techniques—like as well as:* Demonstrations of the performance of various penetration testing techniques, including subdomain enumeration with Sublist3r and Subfinder, and port scanning with Nmap* Strategies for analyzing and improving the security of web applications against common attacks, including* Explanations of the increasing importance of web application security, and how to use techniques like input validation, disabling external entities to maintain securityPerfect for software engineers new to cybersecurity, security analysts, web developers, and other IT professionals, A Beginner's Guide to Web Application Penetration Testing will also earn a prominent place in the libraries of cybersecurity students and anyone else with an interest in web application security. ALI ABDOLLAHI is a cybersecurity researcher with over 12 years of experience. Currently, he is the application and offensive security manager at Canon EMEA. He studied computer engineering, published articles, and holds several professional certificates. Ali is a Microsoft MVP and regular speaker or trainer at industry conferences and events. Foreword xviiIntroduction xixCHAPTER 1 INTRODUCTION TO WEB APPLICATION PENETRATION TESTING 1The Importance of Web Application Security 3Overview of Web Application Penetration Testing 6The Penetration Testing Process 8Methodologies 12Tools and Techniques 14Reporting 16Types of Web Application Vulnerabilities 17Key Takeaways 25CHAPTER 2 SETTING UP YOUR PENETRATION TESTING ENVIRONMENT 27Setting Up Virtual Machines 28Container Option 29Kali Linux Installation 30PentestBox 34Installing DVWA 35OWASP Juice Shop 40Burp Suite 41OWASP ZED Attack Proxy 46WILEY Preconfigured Environment 49Key Takeaways 49CHAPTER 3 RECONNAISSANCE AND INFORMATION GATHERING 51Passive Information Gathering 52Automating Subdomain Enumeration 61Active Information Gathering 64Open-Source Intelligence Gathering 77Key Takeaways 88CHAPTER 4 CROSS-SITE SCRIPTING 89XSS Categories 90Reflected XSS 91Stored XSS 93Automatic User Session Hijacking 94Website Defacement Using XSS 96DOM-Based XSS 97Self-XSS 98Browser Exploitation Framework 100XSS Payloads and Bypasses 102XSS Mitigation Techniques 105Reflected XSS Bypass Techniques 107Stored XSS Bypass Technique 110Key Takeaways 112CHAPTER 5 SQL INJECTION 113What Is SQL Injection? 113Types of SQL Injection 114Error-Based SQL Injection 117Union-Based SQL Injection 117Blind SQL Injection 123SQLMap 126SQL Injection Payloads with ChatGPT 140SQL Injection Prevention 142Key Takeaways 145CHAPTER 6 CROSS-SITE REQUEST FORGERY 147Hunting CSRF Vulnerability 149CSRF Exploitation 149XSS and CSRF 151Clickjacking 152Generating an Effective Proof of Concept Using ChatGPT 154Tips for Developers 157Key Takeaways 158CHAPTER 7 SERVER-SIDE ATTACKS AND OPEN REDIRECTS 159Server-Side Request Forgery 159SSRF in Action 160SSRF Vulnerability 162Blind SSRF 164Local File Inclusion 166Remote File Inclusion 170Open Redirect 173Server-Side Attacks Differences 177Security Mitigations 178Key Takeaways 181CHAPTER 8 XML-BASED ATTACKS 183XML Fundamentals 183XXE Exploitation 185Hunting XML Entry Points 187SSRF Using XXE 192DoS Using XXE 193XXE Payload and Exploitation with ChatGPT 195XML-Based Attacks Countermeasures 196Key Takeaways 198CHAPTER 9 AUTHENTICATION AND AUTHORIZATION 201Password Cracking and Brute-Force Attacks 205Credential Stuffing Attack 211Password Spraying 213Password Spraying Using Burp Suite Intruder 214Other Automated Tools for Password Attacks 215JSON Web Token 223Key Takeaways 225CHAPTER 10 API ATTACKS 227OWASP API Top 10 228API Enumeration and Discovery 230API Discovery Using ChatGPT 231API Broken Object-Level Authorization Exploitation 235Rate Limiting 240API Penetration Testing Tools 242API Security Tips 244Key Takeaways 245APPENDIX A BEST PRACTICES AND STANDARDS 247Information Gathering 248Configuration and Deployment Management Testing 251Identity Management Testing 254Authentication Testing 256Authorization Testing 261Session Management Testing 265Input Validation Testing 273Testing for Error Handling 285Testing for Weak Cryptography 286Business Logic Testing 290Client-Side Testing 297APPENDIX B CWE AND CVSS SCORE 307Base Score 308Temporal Score 308Environmental Score 309APPENDIX C WRITING EFFECTIVE AND COMPREHENSIVE PENETRATION TESTING REPORTS 311Table of Contents (ToC) 311Project History and Timeline 311Scope 312Testing Approach 312Executive Summary 312Industry Standard 312Findings Table 312Findings Details 313Key Takeaways 315Index 317
Windows 11 All-in-One For Dummies, 2nd Edition
A DEEP DIVE INTO THE WINDOWS, FOR BEGINNERS AND ADVANCED USERS ALIKEWindows 11 All-in-One For Dummies, 2nd Edition is your most thorough source of information on the world's #1 computer operating system. This 800+ page reference guides you through the art of navigating the Windows interface, setting up personal accounts, and digging into the menus, settings, and features that you need to become a power user. With this jargon-free guidebook, you've got access to tips, tricks, and how-tos from a Windows insider, including how to take advantage of artificial intelligence tools built into Windows. Discover how to get your apps working across multiple devices, manage your data, enhance your copy of Windows with apps and add-ons, and keep everything secure and running smoothly. This Dummies guide is packed with what you need to know to take control of your Windows experience.* Get started with Windows 11, customize your operating system, and learn your way around* Find, install, and manage third-party apps, so you can work and play how you want to* Share files and documents, backup your data online, and manage wi-fi connections* Discover how Microsoft's artificial intelligence tool, Copilot, makes working with Windows even easier.Windows 11 All-in-One For Dummies, 2nd Edition provides the deepest dive into Windows on the market. Customize and troubleshoot as needed, with 10 books in 1! CIPRIAN ADRIAN RUSEN is cofounder of Digital Citizen (digitalcitizen.life), a tech blog that posts daily how-to articles on consumer technologies. Ciprian is also co-author of Windows 10 All-in-One For Dummies, 4th Edition, and author of Windows 10 At Work For Dummies.
Julia Quick Syntax Reference
Learn the Julia programming language as quickly as possible. This book is a must-have reference guide that presents the essential Julia syntax in a well-organized format, updated with the latest features of Julia’s APIs, libraries, and packages.This book provides an introduction that reveals basic Julia structures and syntax; discusses data types, control flow, functions, input/output, exceptions, metaprogramming, performance, and more. Additionally, you'll learn to interface Julia with other programming languages such as R for statistics or Python. At a more applied level, you will learn how to use Julia packages for data analysis, numerical optimization, symbolic computation, and machine learning, and how to present your results in dynamic documents.The Second Edition delves deeper into modules, environments, and parallelism in Julia. It covers random numbers, reproducibility in stochastic computations, and adds a section on probabilistic analysis. Finally, it provides forward-thinking introductions to AI and machine learning workflows using BetaML, including regression, classification, clustering, and more, with practical exercises and solutions for self-learners.WHAT YOU WILL LEARN* Work with Julia types and the different containers for rapid development* Use vectorized, classical loop-based code, logical operators, and blocks* Explore Julia functions: arguments, return values, polymorphism, parameters, anonymous functions, and broadcasts* Build custom structures in Julia* Use C/C++, Python or R libraries in Julia and embed Julia in other code.* Optimize performance with GPU programming, profiling and more.* Manage, prepare, analyse and visualise your data with DataFrames and Plots* Implement complete ML workflows with BetaML, from data coding to model evaluation, and more.WHO THIS BOOK IS FORExperienced programmers who are new to Julia, as well as data scientists who want to improve their analysis or try out machine learning algorithms with Julia.Antonello Lobianco, PhD is a research engineer employed by a French Grande É cole (polytechnic university). He works on the biophysical and economic modelling of the forest sector and is responsible for the lab models portfolio. He does programming in C++, Perl, PHP, Visual Basic, Python, and Julia. He teaches environmental and forest economics at undergraduate and graduate levels and modelling at PhD level. For a few years, he has followed the development of Julia as it fits his modelling needs. He is the author of a few Julia packages, particularly on data analysis and machine learning (search sylvaticus on GitHub).Part 1. Language Core.- 1. Getting Started.- 2. Data Types and Structures.- 3. Control Flow and Functions.- 4. Custom Types.- E1: Shelling Segregation Model - 5. Input – Output.- 6. Metaprogramming and Macros.- 7. Interfacing Julia with Other Languages.- 8. Efficiently Write Efficient Code. - 9 Parallel Computing in Julia - Part 2. Packages Ecosystem.- 10. Working with Data.- 11. Scientific Libraries.- E2: Fitting a forest growth model - 12 – AI with Julia – E3. Predict house values - 13. Utilities. Appendix: Solutions to the exercises.
Natural Language Processing for Software Engineering
DISCOVER HOW NATURAL LANGUAGE PROCESSING FOR SOFTWARE ENGINEERING CAN TRANSFORM YOUR UNDERSTANDING OF AGILE DEVELOPMENT, EQUIPPING YOU WITH ESSENTIAL TOOLS AND INSIGHTS TO ENHANCE SOFTWARE QUALITY AND RESPONSIVENESS IN TODAY’S RAPIDLY CHANGING TECHNOLOGICAL LANDSCAPE.Agile development enhances business responsiveness through continuous software delivery, emphasizing iterative methodologies that produce incremental, usable software. Working software is the main measure of progress, and ongoing customer collaboration is essential. Approaches like Scrum, eXtreme Programming (XP), and Crystal share these principles but differ in focus: Scrum reduces documentation, XP improves software quality and adaptability to changing requirements, and Crystal emphasizes people and interactions while retaining key artifacts. Modifying software systems designed with Object-Oriented Analysis and Design can be costly and time-consuming in rapidly changing environments requiring frequent updates. This book explores how natural language processing can enhance agile methodologies, particularly in requirements engineering. It introduces tools that help developers create, organize, and update documentation throughout the agile project process. RAJESH KUMAR CHAKRAWARTI, PHD, is a dean and professor in the Department of Computer Science and Engineering at Sushila Devi Bansal College, Bansal Group of Institutions, India. He has over 20 years of professional experience in academia and industry. Additionally, he has organized and attended over 200 seminars, workshops, and conferences and has published over 100 research papers and book chapters in nationally and internationally revered publications. RANJANA SIKARWAR is currently pursuing a PhD from Amity University, Gwalior. She completed her Bachelor of Engineering in 2006 and Master of Technology in Computer Science and Engineering in 2015. Her research interests include social network analysis, graph mining, machine learning, Internet of Things, and deep learning. SANJAYA KUMAR SARANGI, PHD, is an adjunct professor and coordinator at Utkal University with over 23 years of experience in the academic, research, and industry sectors. He has a number of publications in journals and conferences, has authored many textbooks and book chapters, and has more than 30 national and international patents. He is an active member and life member of many associations, as well as an editor, technical program committee member, and reviewer in reputed journals and conferences. He has dedicated his career to advancing information and communication technology to enhance and optimize worldwide research and information dissemination, leading to improved student learning and teaching methods. SAMSON ARUN RAJ ALBERT RAJ, PHD, is an assistant professor and placement coordinator in the Division of Computer Science and Engineering, School of Computer Science and Technology, Karunya Institute of Technology and Sciences, Tamil Nadu, India. His research is focused on smart city development using drone networks and energy grids with various applications, and his areas of expertise include wireless sensor networks, vehicular ad-hoc networks, and intelligent transportation systems. SHWETA GUPTA is an assistant professor in the Computer Science and Engineering Department at Medicaps University, Indore (M.P.), India. She focuses on natural language processing, data mining, and machine learning. She aims to close the knowledge gap between theory and real-world applications in the tech sector through her passion for research and teaching. Her approach centers on encouraging creativity and motivating students to strive for technological excellence. KRISHNAN SAKTHIDASAN SANKARAN, PHD, is a professor in the Department of Electronics and Communication Engineering at Hindustan Institute of Technology and Science, India. He has been a senior member of the Institute of Electrical and Electronics Engineers for the past ten years and has published more than 70 papers in refereed journals and international conferences. He has also published three books to his credit. His research interests include image processing, wireless networks, cloud computing, and antenna design. ROMIL RAWAT has attended several research programs and received research grants from the United States, Germany, Italy, and the United Kingdom. He has chaired international conferences and hosted several research events, in addition to publishing several research patents. His research interests include cybersecurity, Internet of Things, dark web crime analysis and investigation techniques, and working towards tracing illicit anonymous contents of cyber terrorism and criminal activities.
Windows 11 All-in-One For Dummies, 2nd Edition
A DEEP DIVE INTO THE WINDOWS, FOR BEGINNERS AND ADVANCED USERS ALIKEWindows 11 All-in-One For Dummies, 2nd Edition is your most thorough source of information on the world's #1 computer operating system. This 800+ page reference guides you through the art of navigating the Windows interface, setting up personal accounts, and digging into the menus, settings, and features that you need to become a power user. With this jargon-free guidebook, you've got access to tips, tricks, and how-tos from a Windows insider, including how to take advantage of artificial intelligence tools built into Windows. Discover how to get your apps working across multiple devices, manage your data, enhance your copy of Windows with apps and add-ons, and keep everything secure and running smoothly. This Dummies guide is packed with what you need to know to take control of your Windows experience.* Get started with Windows 11, customize your operating system, and learn your way around* Find, install, and manage third-party apps, so you can work and play how you want to* Share files and documents, backup your data online, and manage wi-fi connections* Discover how Microsoft's artificial intelligence tool, Copilot, makes working with Windows even easier.Windows 11 All-in-One For Dummies, 2nd Edition provides the deepest dive into Windows on the market. Customize and troubleshoot as needed, with 10 books in 1!
Teach Yourself VISUALLY Windows 11
A FULLY ILLUSTRATED, UP-TO-DATE, AND START-TO-FINISH GUIDE TO USING WINDOWS 11 DEVICESTired of tech books that tell you what to do but never actually show you how to use your latest devices? Then Teach Yourself VISUALLY Windows 11, 2nd Edition is for you. This book walks you through exactly how to get things done in Microsoft's newest Windows updates with crystal-clear, high-resolution screenshots and pictures that won't leave you scratching your head and wondering, “Why didn't that work?” Teach Yourself Visually Windows 11 is a complete, start-to-finish visual tour of Windows 11. It will take you from “What do I do first?” to Windows guru, one picture and instruction at a time. Looking for help on how to set up your Windows 11 tablet, laptop, or desktop computer for the first time? Teach Yourself Visually Windows 11 has got you covered with the visual interface explanations, Wi-Fi connection assistance, and Microsoft account setup directions you need to make that PC come alive. And that's just chapter one. Teach Yourself VISUALLY Windows 11 will also guide you through how to customize your PC, get connected to—and stay safe on—the web, message and email your friends and family, find specific files on your hard drive, check the weather forecast, secure your device against hackers and looky-loos, and pretty much everything else you can think of. You'll find:* Hundreds of hi-res, full-page images and screenshots that demonstrate basic and advanced Windows 11 tasks you'll use every day* Techniques for making your PC easier to use, including changing the font size, using your voice to active your computer, and more* Ways to share your photos, videos, voice notes, and messages with your loved ones* See Microsoft's new Copilot AI in action and use generated text and images in your documents, emails, and chatsTeach Yourself VISUALLY Windows 11 is the easiest, most intuitive, most fun, and most effective guide for everyone who prefers “show” over “tell” and who's ready to master their Windows 11 tablet, laptop, or desktop PC.
Microsoft 365 Access For Dummies
JOIN THE MILLIONS OF PEOPLE ALREADY USING MICROSOFT ACCESS AND BECOME A DATABASE POWER-USER IN NO TIME!In the newly revised edition of Microsoft Access For Dummies, professional database developer and Access extraordinaire Laurie Ulrich-Fuller walks you through the ins-and-outs of one of the world's most popular database platforms. This is the perfect beginner's guide to Microsoft Access, showing you how to create databases, extract data, create reports, and more. The author demonstrates a ton of tips, tricks, and best practices you can use immediately to create, maintain, and improve your databases. You'll also find:* Updates outlining edge browser controls in forms* Step-by-step guides explaining how to import, export, and edit data* Easy-to-follow query-writing tutorials to help you find the exact data you're looking for when you need itWhether you're a database novice or a data science whiz, Microsoft Access For Dummies has the info you need to supercharge your database skills. It's the perfect, how-to guide to get you up-to-speed on everything you need to know to get started with Microsoft's world-famous database app. LAURIE A. ULRICH is a professional author and technology educator who has also written books about Microsoft Office, including Excel, and about Adobe Photoshop. KEN COOK is an experienced database developer and author who has written on the subjects of Microsoft Access and Excel.
Microsoft 365 Outlook For Dummies
GET UP TO SPEED ON MICROSOFT'S WORLD-FAMOUS EMAILING, SCHEDULING, COLLABORATING, AND ORGANIZING SUPER-APPMicrosoft Outlook can do pretty much anything for you—short of cooking you a steak dinner. It can deliver and sort your email, filter out the junk, help you organize your life, send data to the cloud, sync up your various devices, and even integrate with iOS and Android. And in the latest edition of Microsoft Outlook For Dummies you'll learn how to do all of that, and more! Discover how to create automated mail-handling rules, translate messages into English or other languages, and share your calendar with other people. This latest edition even walks you through each of the four different versions of Outlook and their ideal use cases. You'll also find:* Straightforward content that shows you how to draft and send emails, organize your calendars, and set up to-do lists, tasks, and reminders* Easy explanations of hidden and advanced features that very few people know about or use, setting you up to impress your coworkers!* Navigation tips for the Microsoft Outlook interfacePerfect for novices who are brand-new to Outlook, Microsoft Outlook For Dummies is also a must-buy resource for email veterans looking to pick up the latest tips for the newest versions of Microsoft's world-famous email software. FAITHE WEMPEN, M.A., is a Microsoft Office Master Instructor, an instructional designer, and the author of over 160 books—including Computers For Seniors For Dummies—that empower consumers to make the most of their personal computers and applications.
Microsoft 365 PowerPoint For Dummies
PRESENT LIKE A PRO, WITH THE TOP-SELLING POWERPOINT BOOK ON THE MARKETSince 1999, PowerPoint For Dummies has been giving readers a jargon-free way to compose compelling presentations. This update covers the latest release of Office and Office 365. Learn the basics of creating a slide deck in PowerPoint, then discover the dynamic features you can use to give your slides a bit of pizazz. Import data from other applications, collaborate in the cloud, and incorporate charts, graphics, and videos into your presentations. Plus, learn how to use Microsoft's new Copilot AI tool—integrated right into the application. Consider this book your first step to making a splash with PowerPoint!* Create your first PowerPoint slide deck and add presentation notes* Improve the design of your slides with templates and best-practice tips* Add animations, change your font style, and insert images and drawings* Share your presentation with audiences in a virtual settingNew and not-so-new PowerPoint users who need a guide to the basics of building a successful presentation will love this up-to-date, beginner-friendly book. DOUG LOWE is the information technology director for a civil engineering firm. He has been managing networks for more than 20 years and is the best-selling author of more than 30 For Dummies books, including Networking For Dummies and Networking All-in-One For Dummies.
Microsoft 365 Excel VBA Programming For Dummies
YOUR STEP-BY-STEP GUIDE TO DOING MORE WITH MICROSOFT EXCELFully updated for the latest version of Office 365, Excel VBA Programming For Dummies will take your Excel knowledge to the next level. With a little background in Visual Basic for Applications (VBA) programming, you can go well beyond basic spreadsheets and functions. Learn the coding basics and syntax you need to write simple or complex macros that can automate your routine Excel tasks. Become an Excel power user by automating data management, user forms, pivot tables, and beyond. When you use VBA to perform Excel operations, you can reduce errors, save time, and integrate with other Microsoft applications. This handy guide also teaches you how to control the security settings for your macros and save macros to use across files and apps. Plus, you'll get updated coverage of Copilot AI integration. Your spreadsheets are about to get much more powerful.* Get stared with VBA coding to create macros and automate tasks in Excel* Follow step-by-step instructions to write and execute your first scripts* Learn about the advanced functions available with the VBA language* Perform tasks faster and integrate excel with other Microsoft appsThis Dummies guide is right up your alley if you're an Excel user looking to learn some next-level features. Students and professionals alike will reap the benefits of automation, thanks to Excel VBA Programming For Dummies.DICK KUSLEIKA has more than 25 years’ experience helping Office users get the most out of Microsoft’s bestselling software. From online forums to blogs, books, and conferences, he delivers sound and straightforward advice to readers of all skill levels.
Microsoft 365 Word For Dummies
TAKE A DEEP DIVE INTO THE MOST POPULAR WORD PROCESSOR ON THE PLANETWord, Microsoft's powerful and popular word processor, is capable of extraordinary things. From template building to fancy formatting and even AI-powered editing and proofing, your copy of Word stands ready to help you supercharge your productivity and save you time and energy. You just need to learn how it's done. And, thanks to this easy-to-understand book, learning is the easy part!This latest edition of Word For Dummies is packed with the essentials you need to turn any old copy of the famous word processor into a document-creating, table-formatting, graphics-editing super app. You'll even learn how to customize your version of Microsoft Word so it's absolutely perfect for you, at home and at work. You'll also find out how to:* Navigate the Word interface and menus and figure out a ton of hotkey shortcuts* Edit, format, and comment documents to make team collaboration a breeze* Use the new Microsoft Copilot's AI capabilities to make Word even more powerfulSo, grab your copy of the latest edition of Word For Dummies today. It's perfect for casual users interested in upgrading their knowledge of this ubiquitous app as well as power users looking for the latest productivity tips and tricks. DAN GOOKIN wrote the first-ever For Dummies book in 1991. The author of several bestsellers, Dan’s books have been translated into 32 languages and have more than 11 million copies in print. Dan is the bestselling author of all editions of Word For Dummies.
Microsoft Copilot For Dummies
STRAIGHTFORWARD GUIDANCE ON THE AI TOOL THAT'S BUILT INTO WINDOWS, MICROSOFT 365, AND MOREMicrosoft is enhancing all its most widely used productivity software—including Windows and apps like Word and Excel—with the power of AI. And now you can learn to make the most of this revolutionary new tool with Microsoft Copilot For Dummies!You'll discover how to write Copilot-friendly prompts, enhance output with integrated Copilot tools, and how to apply Copilot functions to project management and other specific tasks and disciplines. In the book, you'll find out how to:* Use text or your voice to prompt reliable results from Microsoft Copilot* Customize Microsoft Copilot to respond to your unique needs and demands* Add plug-ins to the Microsoft Copilot service to extend its functionality even moreLearn to supercharge your efficiency with Microsoft Copilot For Dummies. This book is perfect for professional and home users of Windows, Microsoft 365, and other Microsoft products and software who want to increase their productivity. Grab a copy today! CHRIS MINNICK is an accomplished author, teacher, and programmer. Minnick has authored or coauthored over 20 books, including titles in the For Dummies series. He has developed video courses for online training providers, and he teaches programming and machine learning to professional developers at leading companies globally. He is author of Coding with AI For Dummies and JavaScript All-in-One For Dummies.
Principles and Applications of Blockchain Systems
TECHNICAL THEORY, KEY TECHNOLOGIES, AND PRACTICAL APPLICATIONS FOR CONSORTIUM BLOCKCHAINS, WITH A SOLUTION TO THE CAP TRILEMMA PROBLEMPrinciples and Applications of Blockchain Systems provides a comprehensive introduction to consortium blockchains, including the physical, network, consensus, and contract layers, covering technical theory, key technologies, and practical applications. Beyond the technical side, this book visually showcases the application potential of consortium blockchains, with information on implementation cases in network management (Multi-Identifier System) and secure storage (Mimic Distributed Storage System). This book thoroughly addresses the CAP trilemma problem for consortium blockchains, a major barrier to scalability, by presenting a novel quantifiable impossibility triangle with a solution. Additionally, optimization techniques in consortium blockchains, such as P2P protocols for future networks and consensus algorithms, are discussed in detail. Written by two highly qualified academics with significant experience in the field, Principles and Applications of Blockchain Systems discusses topics such as:* Peer-to-peer networks in consortium blockchains, covering P2P network architecture and node discovery, data synchronization, and gossip protocols* Basic concepts of distributed consistency, including the SMR model in blockchain systems, assumptions for distributed networks, and the Byzantine Generals problem* Consensus mechanisms evolution process from voting-based, including PBFT, RPCA, SCP, and CoT; to proof-based including PoW, PoS, and PoX; finally optimized by fusion both voting-based and proof-based, including PoV, PPoV, HotStuff* Types of vulnerability for smart contracts, covering solidity code, EVM execution, and blockchain system layers* Historical trend of upgrade from electronic consensus to quantum consensusWith highly comprehensive coverage of the subject, Principles and Applications of Blockchain Systems serves as an ideal textbook for blockchain students and researchers, and a valuable reference book for engineers and business leaders involved in developing real-world blockchain systems. HUI LI, School of Electronic and Computer Engineering, Peking University Shenzhen Graduate School, Shenzhen, China. Li received the World Leading Internet Scientific and Technological Achievements award at the 6th World Internet Conference in 2019. His research interests include network architecture, cyberspace security, distributed storage, and blockchain. HAN WANG, School of Electronic and Computer Engineering, Peking University Shenzhen Graduate School, Shenzhen, China.
Der andere Sport
Nicht nur die Corona-Pandemie hat die Zuschauerzahlen im Esports beflügelt. Weltweit zählt das Publikum inzwischen rund 532 Millionen Menschen, und die Esports-Branche ist zu einer bedeutenden, profitablen Industrie herangewachsen. Im Mittelpunkt steht dabei die Esports-Community, deren Bedürfnisse die Branche stark prägen. Dieses Buch zielt darauf ab, die zentralen Strukturen dieser Zielgruppe zu beleuchten. Die zugrunde liegende Forschungsfrage lautet: „Können durch Künstliche Intelligenz neue Erkenntnisse über die Esports-Zielgruppe gewonnen und gesellschaftliche Strukturen offengelegt werden? Und falls ja, wie beeinflussen diese Ergebnisse das Esport-Marketing?“ Ziel ist es, innovative Ansätze im Esport-Marketing zu fördern, da das Wissen über die facettenreiche Esports-Zielgruppe bislang noch begrenzt ist.
Securing an Enterprise
Dive into the world of digital security and navigate its intricate landscape. In an era where digital reliance is ubiquitous, the need for robust cybersecurity measures has never been more pressing. Part of author Saurav Bhattacharya’s trilogy that covers the essential pillars of digital ecosystems—security, reliability, and usability—this book sheds light on the dynamic challenges posed by cyber threats, advocating for innovative security solutions that safeguard users while upholding their digital freedoms. Against the backdrop of rapid technological advancement and escalating cyber threats, this book addresses pressing security concerns at the forefront of our digital era. You’ll learn that trust plays a pivotal role in fostering a secure digital environment, enabling individuals and organizations to flourish without fear of malicious exploits. With transformative technologies like AI, blockchain, and quantum computing on the horizon, understanding and addressing cybersecurity fundamentals is essential for traversing the evolving digital landscape. Securing an Enterprise is your roadmap towards a future where technology aligns with humanity, fostering a more equitable, secure, and interconnected world. What You will Learn Explore advanced methodologies and innovative approaches to bolster cybersecurityUnderstand the potential impacts of the advancements on securityProvide strategic guidance on adapting to security changes to ensure sustainabilityTake a holistic approach in reviewing security Who This Book Is For Cybersecurity Professionals, Technology Developers and Engineers
Terraform Made Easy
Explore the transformative benefits of Infrastructure as Code (IaC) and understand why Terraform is the go-to tool for managing cloud infrastructure efficiently. This book is your ultimate guide to mastering Terraform on Google Cloud Platform, providing you with the tools and knowledge to automate and optimize your cloud infrastructure with confidence. You’ll start by reviewing the traditional approach to managing infrastructure, common challenges, and the benefits of adopting IaC and Terraform. You’ll then learn how to install Terraform on various operating systems and get familiar with its configuration language, basic commands, and syntax. The book then turns to provisioning infrastructures on GCP, managing secrets and enhancing security, and concludes with integrating collaboration and DevOps using Terraform. The power of cloud platforms is growing, providing numerous ways to manage infrastructures more efficiently. While the traditional approach to infrastructure management works well on a smaller scale, it becomes a challenge when dealing with complex or extensive projects. From installation and configuration to advanced provisioning and security practices, this book provides a clear, step-by-step approach to mastering Terraform. You will: * Explore providers, variables, modules, state management, and dependencies. * Master encryption methods and IAM policies. * Secure remote state management to protect sensitive data and ensure compliance. * Discover frameworks, tools, and best practices for testing IaC code. * Automate provisioning with CI/CD pipelines. * Provision a comprehensive suite of infrastructure resources on Google Cloud Platform. Explore the transformative benefits of Infrastructure as Code (IaC) and understand why Terraform is the go-to tool for managing cloud infrastructure efficiently. This book is your ultimate guide to mastering Terraform on Google Cloud Platform, providing you with the tools and knowledge to automate and optimize your cloud infrastructure with confidence. You’ll start by reviewing the traditional approach to managing infrastructure, common challenges, and the benefits of adopting IaC and Terraform. You’ll then learn how to install Terraform on various operating systems and get familiar with its configuration language, basic commands, and syntax. The book then turns to provisioning infrastructures on GCP, managing secrets and enhancing security, and concludes with integrating collaboration and DevOps using Terraform. The power of cloud platforms is growing, providing numerous ways to manage infrastructures more efficiently. While the traditional approach to infrastructure management works well on a smaller scale, it becomes a challenge when dealing with complex or extensive projects. From installation and configuration to advanced provisioning and security practices, this book provides a clear, step-by-step approach to mastering Terraform. What You Will Learn * Explore providers, variables, modules, state management, and dependencies. * Master encryption methods and IAM policies. * Secure remote state management to protect sensitive data and ensure compliance. * Discover frameworks, tools, and best practices for testing IaC code. * Automate provisioning with CI/CD pipelines. * Provision a comprehensive suite of infrastructure resources on Google Cloud Platform. Who This Book Is For Cloud engineers and architects, admin engineers, and CTOs familiar with programming languages and basic IT applications. Ivy Wang is a distinguished Data Scientist and Cloud Architect, celebrated for her deep expertise and impactful contributions to the tech industry. As an honored Google Women Techmakers Ambassador, Ivy's leadership and dedication to advancing technology have earned her widespread recognition. With a passion for innovation, Ivy excels in simplifying complex systems and automating processes in big data and AI projects. Her ability to turn intricate challenges into streamlined, efficient solutions consistently drives enhanced performance and operational excellence. Preface.- Chapter 1. Introduction to Infrastructure as Code (IaC) and Terraform.- Chapter 2. Getting started with Terraform.- Chapter 3: Key Concepts of Terraform.- Chapter 4. Provisioning Infrastructure on GCP.- Chapter 5. Managing Secrets, Enhancing Security, and Ensuring Resilience.- Chapter 6. Testing and Automation.