-
-
Cart
Det finns inga varor i din kundvagn. Fortsätt handla på vår Kurskatalog sida.
DELTOTALBetala Nu -ELLER- betala Senare
Betala med kreditkort nu
-ELLER - betala mot faktura som vanligt.
-
Automating Excel with Macros Training
Nivå: Intermediate
Snittbetyg:
4,61/5 Based on 46 Reviews
Enhance your existing knowledge of Excel with the power of macros. In this Excel Macro training course, you will learn how to create a macro in Excel, then modify and enhance it to automate repetitive Excel-related tasks. You also learn how to troubleshoot code errors in existing macros, log data changes into multiple tables, implement code from the web, and design simple user interfaces to vastly improve your productivity.
Nyckelfunktioner:
- Attend online, in person, or bring this course to your facility
- After-course instructor coaching
Du kommer lära dig att:
- Develop macros to automate repetitive workbook processes
- Translate statements from Visual Basic for Applications into Excel actions
- Debug code in the Visual Basic Editor
- Modify code so that it can refer to dynamic ranges
Välj den utbildningsform som passar dig bäst
LIVE, LÄRARLEDD
I klass & Live, Online-utbildning
- 1-day instructor-led training course
- One-on-one after-course instructor coaching
- Tuition fee can be paid later by invoice -OR- at the time of checkout by credit card
FÖRETAGSINTERN UTBILDNING
Teamträning
- Använd denna eller någon annan utbildning i ditt företag
- Fullskalig programutveckling
- Levereras när, var och hur du vill
- Blandade utbildningsmodellerSkräddarsytt innehåll
- Coaching av ett expertteam
Anpassa kurs och innehåll efter teamets behov
Kontakta ossUtveckla dig och ditt team med anpassade eller öppna kurser alternativt e-learning
Learning Tree erbjuder kundanpassad utbildning hos er, öppna kurser i Stockholm, London eller Washington, möjlighet att delta via våra Anywhere centers (Malmö, Göteborg, Linköping, Stockholm eller Borlänge) eller olika former av e-learning med lärarstöd. Läs mer på www.learningtree.se/priser .
I klass & Live, Online-utbildning
Note: This course runs for 1 dag *
*Events with the Partial Day Event clock icon run longer than normal but provide the convenience of half-day sessions.
-
3 nov 9:00 - 4:30 EST Online (AnyWare)
Boka Din Kursplats -
1 feb 9:00 - 4:30 EST Online (AnyWare)
Boka Din Kursplats -
3 maj 9:00 - 4:30 EDT Online (AnyWare)
Boka Din Kursplats -
3 aug 9:00 - 4:30 EDT Online (AnyWare)
Boka Din Kursplats
Kurs med startgaranti
När du ser symbolen för “Guaranteed to Run” vid ett kurstillfälle vet du att kursen blir av. Garanterat.Partial Day Event
Learning Tree offers a flexible schedule program. If you cannot attend full day sessions, this option consists of four-hour sessions per day instead of the full-day session.Important Excel Macro Course Information
-
Requirements
- Knowledge of Excel at the level of:
- Course 1361, Microsoft Excel Introduction
- Knowledge of Excel at the level of:
-
Recommended Experience
- Experience at the level of:
- Course 195, Power Excel: Analysing Data to Make Business Decision
- Experience at the level of:
-
Software
- This course is applicable to all versions of Excel, from Excel 97 to Excel 2016
Excel Macro Course Outline
- Creating, modifying and enhancing macros
- Troubleshooting code errors in existing macros
- Logging data changes into multiples tables
- Implementing code from the web
Teamträning
Excel Macro Training FAQs
Can I learn to automate Excel tasks with macros online?
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want. This course is available live online and as Private Team Training.
Related Excel Training
Introduction to Microsoft ExcelAvancerad dataanalys med Excel
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.