Economize 8%
PCWorkshops

Excel Macro and VBA course

5.0 excelente 11 opiniões
PCWorkshops
Em London, Birmingham, Manchester e 3 sedes mais (England)

Preço para verificar

Informação importante

Tipologia Short course
Nível Advanced
Local Em 6edes (England)
Duração 1
Início Datas a escolher
Descrição

Many Excel tasks become tedious and repetitive. To create macros will automate these repeated actions and saves you the time of doing it. You will learn to record Excel macros, create macros in Excel by coding in Excel VBA. The we add the macros to icons on a custom toolbar, and you have transformed your work in Excel to the click of a button.

Informação importante
Quais são os objetivos da formação?


Spreaddsheet automation. Saving time. Getting more from Excel.

Esta formação é para mim?


Intermediate to advanced Excel users

Desconto por inscrição antecipada:

Requisitos: Excel intermediate

Instalações (6)
Instalações e datas
Início Localização
Datas a escolher
Birmingham
One Victoria Square, B1 1BD, West Midlands, England
Ver mapa
Datas a escolher
London
8 Duncannon Street, WC2N 4JF, London, England
Ver mapa
Datas a escolher
Manchester
Pall Mall, 82 King Street, M2 4WQ, Greater Manchester, England
Ver mapa
Datas a escolher
Milton Keynes
Exchange House, 494 Midsummer Boulevard, MK9 2EA, Buckinghamshire, England
Ver mapa
Datas a escolher
Portsmouth
Lakeside North Harbour Western Road Building 1000 Ground Floor, PO6 3EZ, Hampshire, England
Ver mapa
Datas a escolher
Southend-on-Sea
The Forum Southend, Elmer Square, SS1 1NS, Essex, England
Ver mapa
Ver todas (6)
Início Datas a escolher
Localização
Birmingham
One Victoria Square, B1 1BD, West Midlands, England
Ver mapa
Início Datas a escolher
Localização
London
8 Duncannon Street, WC2N 4JF, London, England
Ver mapa
Início Datas a escolher
Localização
Manchester
Pall Mall, 82 King Street, M2 4WQ, Greater Manchester, England
Ver mapa
Início Datas a escolher
Localização
Milton Keynes
Exchange House, 494 Midsummer Boulevard, MK9 2EA, Buckinghamshire, England
Ver mapa
Início Datas a escolher
Localização
Portsmouth
Lakeside North Harbour Western Road Building 1000 Ground Floor, PO6 3EZ, Hampshire, England
Ver mapa
Início Datas a escolher
Localização
Southend-on-Sea
The Forum Southend, Elmer Square, SS1 1NS, Essex, England
Ver mapa

Opiniões

5.0
excelente
Avaliação do curso
100%
O recomendam
5.0
excelente
Avaliação do Centro

Opiniões sobre este centro

Z
Zaid Desai
26/08/2017
O melhor: Very informative, learnt a lot thanks!
A melhorar: nothing
Curso realizado: Agosto 2017
Você recomendaria esse centro?: sim
G
Greya Taylor
05/06/2017
O melhor: I really enjoyed the course. Sarah teaches very well and makes hard things seem easy. Thank you!
A melhorar: nothing
Curso realizado: Junho 2017
Você recomendaria esse centro?: sim
V
Vaida Peldene
15/01/2018
O melhor: I'm sure many people have said this but Sarah really is an excellent teacher. She doesn't give up on you and makes sure you understand any concept.
A melhorar: .
Curso realizado: Janeiro 2018
Você recomendaria esse centro?: sim
C
Craig Johnson
19/03/2018
O melhor: Good explanation from the teacher and good exercises.
A melhorar: .
Curso realizado: Março 2018
Você recomendaria esse centro?: sim
R
Reka Musan
17/04/2018
O melhor: I am more confident with macros now thank you!
A melhorar: .
Curso realizado: Abril 2018
Você recomendaria esse centro?: sim
* Opiniões recebidas pela Emagister e iAgora

O que se aprende nesse curso?

Excel
Microsoft Excel
Spreadsheet
MS Excel
Spreadsheets
VBA
Macros
Automation
Coding
Calculation
Excel
Excel VBA
Excel
Calculation
Calculation

Programa

Recording and Running Macros in Excel
Create simple macros using the macro recorder and run them from shortcuts or buttons on the ribbon
Setting Excel Macro Options
Record and Run Simple Macros
Assign Macros to the Quick Access Toolbar
Introduction to the Excel VBA Editor
Use the VBA Editor to navigate projects and explore object properties. Create, copy and import/export modules
Starting the Visual Basic Editor
Using the Project Explorer
Using the Properties Window
Creating, Importing and Exporting Modules
Explore Recorded Macros
Creating Procedures and Functions
Create simple macro procedures in code that use variable to store data and communicate with the user
Creating Sub and Function Procedures
Declare and Use Variables
Displaying Message to the User
Getting Input from the User
Working with the Excel Object Model
Explore a variety of ways our code can manipulate data within cells, create and navigate around worksheets and workbooks
Understanding Objects, Properties and Methods
Interacting with the spreadsheet :
Referencing Cells and Ranges
Gathering Cell and Range Information
Using the Offset Method
Using With Blocks
Referencing Workbooks and Worksheets
Updating values in the spreadsheet and putiing values into the spreadsheet
Functions
Using standard Excel functions in VBA
Creating new custom functions
Controlling Program Flow
Using decision making and looping structures to control the way your program works
Using the IF Statement
Using the Select Case Statement
Using For Next Loops
Using Do Loops
Using For Next Loops
Practical project and examples