Accepts: cash, Visa, Mastercard, Discover, American Express
Located at main box office on Centennial Olympic Park Drive. Available for pickup beginning 1 1/2 hours prior to event. Closing time will vary by event. PLEASE BRING A PICTURE ID, THE ACTUAL CREDIT CARD USED TO PURCHASE THE TICKETS, AND YOUR ORDER NUMBER.
404-878-3000 - State Farm Arena Box Office 1-866-715-1500 - Atlanta Hawks
The Box Office is open on event days and for the first day of all on-sales. (Hours will vary based upon the events and time of on-sales).
Accessible seating is available in throughout the arena in various price categories. Seating for the sight/hearing impaired available in the lower level. All accessible seating is subject to availability. All levels of the Arena are accessible by elevator and escalator.
DevOpsDays Tokyo 2020
イベントサイト：https://www.devopsdaystokyo.org/
Programs and Session Proposals (プログラムとセッション提案はこちら)
https://sessionize.com/devopsdays-tokyo-2020/
Mit unserer Excel Schulung erhalten Ihre kaufmännischen Mitarbeiter umfassende Kompetenzen in den wichtigsten Anwendungsfällen zur effizienten Datenanalyse, zur sicheren Durchführung von Berechnungen und zur effektiven Datenvisualisierung.
Schulungsschwerpunkte:
1. Datenanalyse: Arbeiten mit Tabellen
Best Practices zur Tabellen Formatierung
Zeilen und Spalten fixieren
Gitternetzlinien ausblenden
Sortieroptionen, auch nach mehreren Kriterien
Autofilter
Filteroptionen mit und / oder
Zellen fixieren
Inhalte einfügen Optionen
Tabellen drehen
Alle Werte einer Spalte einer Berechnung multiplizieren / teilen
Spalten und Zeilen ausblenden
Zellen formatieren, z.B. Anzeigen als Währung, Datum oder Prozent
Bedingte Formatierung (Regel zum Hervorheben von Zellen, Icons einsetzen, Heatmaps)
Sparklines
Zellenformate übertragen
Autoausfüllen nutzen (Übersicht über die „Autofill-Funktionen“)
Was sind Zellbezüge? Das berühmte „Dollarzeichen“
Daten aus anderen Formaten (z.B. PDF) in Excel übernehmen
Pivot Tabellen erstellen und effektiv nutzen
Nützliche Shortcuts mit denen Sie viel Zeit sparen
2. Berechnungen: Arbeiten mit Funktionen
Wenn
Funktionen verschachteln (2. Wenn Funktion)
Zählen Wenn
Links
Rechts
Teil
Länge
Anzahl
Anzahl2
Verketten
Index und Vergleich
Dropdown Auswahlfelder erstellen
Text in Spalten
Häufigkeit
SVerweis
Zielwertsuche
Datentabelle / Break Even Analyse
Schätzer
Trend
Summenprodukt
3. Datenvisulisierung: Wie Sie das richtige Diagramm wählen und gestalten
Grundlagen der Diagrammerstellung: Übersicht über Diagrammarten, Empfehlungen wie Sie den jeweils geeignetsten Diagrammtyp wählen
Diagramme effektiv anpassen (Farbe, Schrift, Axenbeschriftungen, Skalen)
Reihenfolge der Balken im Diagramm ändern
Designprinzipien
Wasserfallmodell
Diagramme mit 2 Achsen (Sekundärachse) zum Darstellen einer dritten Dimension (z.B. einer Trendlinie)
Histogramme (Zusammenfassung von Daten)
Projektplan (Gantt Chart)
Voraussetzung für die Schulung
Keine. Wir stellen allen Teilnehmern einen Laptop mit Excel 2010 oder neuer zur Verfügung.
Für etwaige Fragen stehe ich Ihnen gerne zur Verfügung.
Mit herzlichem Gruß
Jörn Steinz
M 0175 566 4329
E joern@skillday.de
Impressum: http://skillday.de/impressum/
The Box Office accepts MasterCard, Visa, Discover, American Express, and Cash.
Box Office Phone Number: (313) 471-7929
The Box Office is open Monday through Friday 9:30 AM to 6:00 PM. On Saturday 9:30 AM to 4:00 PM. On event days, 10:00 AM until ½ hour before scheduled event end. Closed non-event Sundays.
Dates: Jan. 10, 11, 17, 18, 24, 25, 31, Feb. 1, 8, 9, 2020
Overview
Lean Six Sigma is a two-stage approach which drives continual improvement in organizations and strives towards greater than 99% efficiency. Lean refers to maximizing customer value and minimizing the areas of waste in processes; creating enhanced customer satisfaction and less wasted resources. Six Sigma is the ongoing effort to continually reduce product and process variation through a defined project approach. This is an 80-hour course that provides a structured approach in defining Six Sigma Project and measuring opportunities, robust problem solving, use statistical tests to measure and improve processes and tools to sustain performance.
Course Outline
· INTRODUCTIONo Innovationo Lean Six Sigma Green Belt Introductiono What is Lean Six Sigma?· DEFINE PHASEo Voice of the Customero Project Definitiono Introduction to Process Mappingo Identifying Quick Winso Define Case Study· MEASURE PHASEo What to Measureo Data Collection Plano Operational Definitiono Sampling Overviewo Measurement System Analysiso Concept of Stability & Normality· MEASURE PHASEo Statistical Summarizationo Baseline Capability – Sigma Levelo Measure Case Study· ANALYZE PHASEo Process Analysiso Cause & Effect Diagramo Pareto Analysiso FMEAo Hypothesis testingo Correlation Analysiso Regression Analysiso Analyze Case Studyo Box Plot Analysis· IMPROVE PHASEo Solution Identificationo Implement Solutiono Evaluate resultso Improve Case Study· CONTROL PHASEo Standardize & Sustaino Improvementso Confirm Goal Attainmento Project Closureo Control Case Studyo Final Test
Who Should Attend
- Executives, Managers, Supervisors, Reports Analysts
What Will I Learn
A structured approach to opportunity identification and problem-solving
Performance data collection, baselining and analytics
Targeted interventions and improvement strategies
A standard approach to sustain performance and best practices
How Will I Benefit
Understand Lean Six Sigma Methodology and its application in your workplace
Institutionalize usage of Lean Six Sigma
Build a culture of excellence across the organization
Improve bottom-line performance indicators
The Box Office accepts Visa, MasterCard, American Express, Discover Card, and cash.
Tickets can be picked up no earlier that three hours before the event. Patron must have a photo ID, the actual credit card, and confirmation number.
Box Office information: (309) 764-2000. TDD line for hearing impaired only (309) 764-2054. Group orders: (309) 277-1356.
Box Office hours: Monday through Friday - 10:00 AM to 5:30 PM Saturday - 10:00 AM to 2:00 PM Day of the event - 10:00 AM to showtime
Accessible seating varies by event.
Cash, Visa, MC, Discover, American Express
Available at Box Office during regular hours.
Holiday Box Office Hours: Christmas Eve (12/24/19) - 10:00am-2:00pm Christmas Day (12/25/19) - CLOSED New Year's Eve (12/31/19) - CLOSED New Year's Day (1/1/20) - 12:00pm-7:00pm Box office hours: Monday - Saturday 10:00am-8:00pm Sunday 11:00am - 7:00pm THE BOX OFFICE WILL BE OPEN FOR SALES IN PERSON ONLY.
There are no steps into the theatre from the sidewalk. Please be advised that where there are steps within the theatre we are unable to provide assistance. Orchestra: Seating is accessible to the Orchestra without steps, but there are 1-2 steps up to access rows Q-T in the Center and Right Orchestra. Wheelchair seating is in the Orchestra only. Mezzanine: On the 2nd Level: up 29 steps from the Orchestra. There is no elevator to the Mezzanine. Entrance is behind row F. There are approximately 2 steps up/down per row. There are handrails along both sides of every aisle in the mezzanine. Balcony: On the 3rd level: up 76 steps from the Orchestra. There is no elevator to the Balcony. There are approximately 2 steps up/down per row. There are handrails along both sides of every aisle in the Balcony.