American Express, MasterCard, VISA, Discover Card
704-688-8600 For general group sales questions for Spectrum Center: 704.688.9047
Friday's 10AM - 2PM
This venue is accessible. For sight impaired and hearing patrons please contact the Box Office. Spectrum Center is committed to providing every guest with a comfortable and enjoyable experience. The arena is one of the most accessible arenas in the U.S. Seating throughout the venue allows guests with accessible needs flexibility in seat locations and price levels.
This course is ideal for
This course exposes several advanced features of Excel for What-if analysis, database analysis and how to build calculations using advanced functions as well as how to automate processes.
What you will learn
Build complex calculations with advanced functions.
Link, export and consolidate data.
Limit data entry and build complex models with Lookup functions.
Analyse data with simple PivotTables and PivotCharts.
Create and modify Macros.
Topics covered in this training course
Protecting your data
Workbook protection
Protecting cells
Protecting structure
Circular references
Locating and deleting circular references
When circular references are necessary
Formula error checking
Range names
Defining range names
Using names in formulas
Navigating with names
Using named constants
Documenting range names
Functions
Math and rounding functions
The AND function
The OR function
Nested IF function
The VLOOKUP function
The HLOOKUP function
Transposing data
Concatenating functions
INDEX and MATCH functions
Using help for functions
Data Validation
Limiting cell values
Creating drop-down cell lists
Validation error messages
What-if analysis tools
Using goal seek
Importing data
Importing CSV files
Text import wizard
Workbook linking
Workbook linking
Dealing with broken links
Data consolidation
Consolidation by cell position
Consolidation by headings
Exporting data
Saving as a different file type
Exporting to Word
Pasting data with a link
Copying a graph with a link
PivotTable reports
Create a PivotTable
Rearranging data
Applying filters
Adding fields
Modify field settings
Refreshing data
Formatting a PivotTable
PivotCharts
Creating a PivotChart
Filtering a PivotChart
Macros
Recording a Macro
Editing a Macro
Relative/Absolute Recording
Stepping through a Macro
Macro buttons
Customising the toolbar
Writing a line of code
Deleting a Macro
American Express, Discover, MasterCard, and Visa are accepted. Honda Center is a cashless venue.
A photo ID matching the name the tickets are placed under is required. VIP, Artist, Promoter, or other special will call requirements and locations are subject to change. Will call windows are located at the Box Office. Will call is generally available beginning 1-1/2 hours prior to the event, and closes after the start of the event (after the first intermission for Anaheim Ducks games). Late pick up will be available at the East Entrance after the box office closes.
Box office phones are answered during regular box office hours. Please note, the box office does not sell tickets by phone. Call (714) 704-2500 for general information
Monday through Friday 10am to 3pm. The box office will remain open through the beginning of weeknight events. On event Saturdays and event Sundays, the box office will open three (3) hours prior to the event and remain open through the beginning of the event. The box office is located on the east side of the building, near the East Entrance, facing the Santa Ana riverbed.
Wheelchair accessible seating is available in most areas of Honda Center including Plaza, Club, and Terrace levels. Availability of locations is dependent upon event seating configuration. For availability and exact locations based on a particular event, please toggle the Accessibility icon in the seat map filters on the Ticketmaster.com event page. The box office will have the same availability as Ticketmaster. Please note, semi-ambulatory or limited mobility seating is also available and requires the guest to navigate some steps. Wheelchair accessible seats have no steps. Hearing Impaired Guests: Assistive listening devices are available, with a picture ID as a deposit, at the Guest Services Desk located at Section 214. Requests for sign language interpreters must be received at least 14 business days prior to the event you are attending. To arrange for courtesy sign language interpreters, please either email accessibilityservices@hondacenter.com or call 714-704-2400. For a full list of ADA policies, please visit https://www.hondacenter.com/arena-info/ada-accessibility/
Mastercard, Visa, American Express, cash
Will Call will open at the Main Box Office, located at the intersection of Park Blvd and Imperial Ave three hours prior to show time. No outside will call will be accepted. Customers should bring their confirmation number with a photo I.D. and the credit card used to make the purchase to claim tickets.
Tickets for the concert are not available for purchase in person at the Petco Park Box Office prior to the show date. On the day of the show, tickets will be available at the Petco Park Box Office, should any remain. Tickets for Metallica can be purchased online or over the phone by calling 866-448-7849 anytime or you can speak to a customer service agent by calling Ticketmaster at 800-745-3000 Monday – Saturday: 9am – 6pm and Sunday: 12pm – 6pm Pacific Time.
WHEELCHAIR ACCESS: Entire venue is accessible. There are wheelchair and companion seats, armless aisle and transfer seats, please specify your request in your email if you purchase via online. PARKING: Public pay lots with accessible parking CANINE COMPANIONS ACCOMODATED: Yes
NEU: DIY Workshop Weben
Alles erfährt irgendwann seine DIY-Renaissance - so auch das klassische Weben, das dieses Jahr in Form von moderrnen "Wall Hangings" (= Wand-Teppiche) überall in den sozialen Medien zu sehen ist. Zurecht, denn Weben geht schnell, einfach und macht verdammt viel Spaß, wenn man mal seinen eigenen Rhythmus gefunden hat! Darum biete ich diesen After-Work Weben Workshop an, bei dem du deine Hände Bahn für Bahn entspannen und am Ende ein kleines Kunstwerk mit nach Hause nehmen kannst!
Der DIY Weben Workshop folgt keinem klassischen Workshop-Schema sondern es stehen dabei das gemeinsame Machen, der Austausch untereinander und die Inspiration von Anderen im Vordergrund. Zu Beginn werden die technischen Grundlagen sowie Tipps & Tricks zum Weben von kleinen Web-Teppichen vermittelt. Du lernst von mir Techniken wie Twists, Zöpfe und Fransen, wie du Muster und Farben am besten kombinierst und worauf du dabei achten solltest. Danach heißt es: ran an die Wollen und Webrahmen!
Der Kurs ist sowohl für Anfänger als auch für Fortgeschrittene geeignet.
AGENDA
Begrüßung/Intro
Material-Vorstellung
Web-Techniken
Der eigene Web-Teppich
DEIN TICKET
Die Teilnahmegebühr beinhaltet
1x Mini-Webrahmen
1x Webnadel
ausreichend Aida Stoff
eine Auswahl an verschiedenen Wollen in unterschiedlichen Farben
Vor Ort können außerdem zusätzlich Pompons und Holzperlen genutzt werden. Diverse Materialien und Werkzeuge für Lettering und Watercolor können während des gesamten Workshops in der "Show Wall" ausgiebig getestet werden (z.B. von STABILO, Faber-Castell, edding, Pentel, Ecoline, Kuretake, uniPosca, Karin Marker, Molotow u.v.m.). Der Workshop wird von unseren Partnern idee.Creativmarkt und Rico Design unterstützt.
Es stehen unbegrenzt Kaffee/Tee/Leitungswasser zur Verfügung sowie süße/salzige Snacks und Obst. Bei Fragen kannst du dich jederzeit an das Frau Hölle Team (hallo@frauhoelle.com) wenden. Wir freuen uns auf euch!
FAQs
Ist meine Registrierung/mein Ticket übertragbar?Ja, bitte teile mir den Namen der Person mit die stattdessen am Workshop teilnehmen wird. So kommt es zu keinen Verwechslungen.
Wie sehen die Rückerstattungsbedingungen aus?Die Teilnahmegebühr wird bei einer Stornierung nicht erstattet. Wenn der Gastgeber den Termin absagt (das passiert hoffentlich nicht!), erhältst du jedoch die volle Rückerstattung.
Gibt es weitere Workshops in Frau Hölle Studio?Es wird 2019 verschiedene Lettering und Watercolor Workshops geben. Über den Newsletter, auf der Website oder über alle Social Media Kanäle von Frau Hölle bleibst du zu neuen Workshop Angeboten immer auf dem Laufenden.
Headerbild: idee.Creativmarkt / Rico Design
Join us for our exclusive retreat at the amazing, luxurious accomodationThe Greenhouse Retreat in Avoca, one hour drive from Sydney on the waters.
Be part of this unique German Retreat connecting thru "Wochenende", the one of a kind retreat, exclusive created for you. Find rest and take some time out, connect with yourself and others at "Wochenende".
We sourced the best native German Wellness Therapists and Movement Therapists to offer you a loving, caring and supporting place for you to relax and renew.
A weekend hostd by Germans living in Australia for Germans in Australia.