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 International Research Conference Aims and Objectives
The International Research Conference is a federated organization dedicated to bringing together a significant number of diverse scholarly events for presentation within the conference program. Events will run over a span of time during the conference depending on the number and length of the presentations. With its high quality, it provides an exceptional value for students, academics and industry researchers.
ICAET 2021: 15. International Conference on Aviation Engineering and Technology aims to bring together leading academic scientists, researchers and research scholars to exchange and share their experiences and research results on all aspects of Aviation Engineering and Technology. It also provides a premier interdisciplinary platform for researchers, practitioners and educators to present and discuss the most recent innovations, trends, and concerns as well as practical challenges encountered and solutions adopted in the fields of Aviation Engineering and Technology
Venue: Suan Sampran Riverside Resort (one hour from Bangkok Suvarnabhumi Airport) Thailand
(SkillsFuture Credit of $500 can be applied)
Do you realise that there are psychosomatic effects when you are hurt, angry, anxious or stressed?You may experience physical symptoms such as aches, pains, muscle spasms and headaches.
In this retreat, you will learn to apply secular mindfulness and self-compassion practices to alleviate the symptoms and resolve the issues causing the stress. This retreat is appropriate for people suffering from anxiety or depression.
Recommend to attend Mindfulness Foundation Course or MBSR before going on this retreat for better results.
Dates: 21-25 December 2019 (Sat-Wed)
PROGRAM
21 December 2019 (Sat)Check in at Suan Sampran Riverside Resort2pm-7pm Check in, Free and Easy7pm -9pm Opening Session
22-24 December 2019 (Sun-Tue)
7am - 8am: Breakfast8am - 12pm Morning Session12pm - 2pm: Lunch Break2pm- 6pm Afternoon Session6pm onwards: Free and Easy
25 December 2019 (Wed)
7am - 8am: Breakfast8am - 1pm Morning Session1pm - Close
* Sessions include long and mindfulness practices, reflections and dyad/group discussions
This retreat is led by Brahm Centre's Principal Mindfulness Trainer, A/Prof Angie Chew. She is the founder and CEO of Brahm Centre - a registered charity dedicated to promoting happier and healthier living. She is a qualified Mindfulness-Based Stress Reduction teacher and is certified to teach mindfulness to teens and children. She teaches the "An Undefeated Mind" course for students at the National University of Singapore and is also a Ministry of Education registered mindfulness teacher. Angie has conducted mindfulness courses for more than 10,000 people including corporate clients from the financial, healthcare and education sectors. Prior to her joining Brahm Centre, she served in senior positions at Singapore Airlines, Visa International, Accenture, Hewlett-Packard and government agencies.
Retreat Package: $1,140 (Twin-Sharing) includes:
$770 Course Fee and $370 for Room with Breakfast, Lunch on 22-24 Dec
SkillsFuture credits can be applied to the Course Fee
If you have a roomate, please indicate his/her name during registration. Otherwise, you will be matched with a same-gender roommate or the option upgrade if you don't have a partner is $250 for a single room
One night extension on 20 Dec or 25 Dec: $170/night per room with breakfast only (subject to availability)
Limo one way to resort is 2,500 Baht (book directly with the resort) or a shared van will be arranged at $40 per person each way
What is not included? Air ticket, airport-hotel transfer, dinner and other personal incidentals
Shared van from Bangkok Suvarnabhumi Airport leaving at 1pm for the resort is available - S$35 per person
CANCELLATION POLICY: - ALL PAYMENTS ARE NON-REFUNDABLE, but you may transfer this booking to a friend should you not be able to attend. If there is a medical emergency, maximum refund will be 50% of the total paid.
Registration Process:- If you wish to use your SkillsFuture Credit (SFC) towards this course, please first register and pay a deposit online on Brahm Centre’s Eventbrite page. You will receive an Eventbrite Order Confirmation PDF, which you can then use to upload on the SFC website to make your claim submission. Your course deposit will be returned to your credit card (online payment) or by cheque (cash/nets payment) when Brahm Centre receives the funds from SFC, subject to the amount successfully claimed.- You should expect to receive your refund by the 3rd week from the course start date.
^ SkillsFuture Credit (SFC) Use:
- Log in to the SkillsFuture website http://www.skillsfuture.sg/credit to submit your claim using your Singpass, and upload the Eventbrite Order Confirmation PDF as supporting document. You may submit your claim up to 60 days before start of course till day of course commencement.
- A step-by-step guide for your SFC claim: https://www.skillsfuture.sg/-/media/SkillsFuture/Initiatives/Files/SFC_UserGuide.pdf?la=en
- You are responsible for making your claim submission within the eligible time frame stipulated by SkillsFuture.
- For more help on making SFC claim:• Please call the SkillsFuture Hotline: +65 6785 5785 • Or get help in person at the following Career Connect Centres:
@ Paya Lebar: 11 Eunos Road 8, #02-02 Lifelong Learning Institute, Singapore 408601@ Tampines: 1 Tampines Walk, #01-21 Tampines Hub Public Service Centre, Singapore 528523@ Woodlands: 900 South Woodlands Drive, #04-07 Woodlands Civic Centre, Singapore 730900 @ e2i Central: 490 Lorong 6 Toa Payoh, #07-11 (Life Lobby 1), HDB Hub Bizthree, Singapore 310490 @ e2i West: 80 Jurong East St 21, Level 2, Devan Nair Institute for Employment and Employability, Singapore 609607
Mondays to Fridays: 9:00 am to 5:00 pmSaturdays: 9:00 am to 1:00 pmClosed on Sundays & Public Holidays
Cash and All Major Credit Cards
Must have photo ID & credit card used to purchase tickets when picking up will call tickets
1-855-234-7469 1-866-574-3851 - Group Sales (10+)
10:00am - 8:00pm (show nights vary)
Accessible ramps to orchestra & mezzanine sections; Elevator service to balcony
This event will take place at the Church Health Center - 1350 Concourse Ave Ste 142, Memphis, TN 38104. The shifts will be 10am to 1pm and 1pm to 4pm on Tuesdays, Wednesdays, Thursdays, and Fridays. Volunteers will assist with the screening process for Covid19. This is an opportunity for students to volunteer and earn underserved hours. If you have any questions, email twisdom@uthsc.edu or mwrigh71@uthsc.edu. ***DISCLAIMER: DO NOT SIGN-UP FOR AN EVENT IF YOU ARE SUPPOSED TO BE IN CLASS! BEING LATE TO CLASS OR MISSING CLASS DUE TO A SERVICE EVENT IS NOT ACCEPTABLE AND WILL NOT BE EXCUSED. Supervisor 10am-1pm - $0.00 Volunteer 10am-1pm - $0.00