Gestion de projet
Sébastien D
Bureautique - Confluence
homme/Bureautique - Gestion de projet
View full profile
VBA Training – Automation and Macros | Continuing Education |
Excel
This training is now available only in private session, 5 hours of course for 3 days in your company.
Contact us for more details
Updated on
The VBA Training course at a glance
- Length
- 3 days
- Schedule
- 9:00 a.m. to 4:30 p.m.
- Format
- Live virtual class or in person in Montreal and Quebec City
- Audience
- Tous
- Price
- $1,301 per participant, or $1,105 for public bodies and non-profits (plus taxes)
- Language
- English
Doussou Formation and VBA Training: key facts
- Since 2016Doussou Formation has been delivering professional training in Quebec
- 300+specialized courses in our catalogue
- 97 %satisfaction according to client evaluations
- RAP · CPMTAccredited supplier and recognized training organization
Upcoming VBA Training sessions
VBA Training course outline
Excel Fundamentals
- Interface description (Ribbon, Quick Access Toolbar, etc.)
- Structure of a file (workbooks, sheets and cells)
- Modify your data: Increment series and Fix flaps
- Overviews of the main shortcuts and tips for saving time
- Customizing the Ribbon and Quick Access Toolbar
- Creating and managing tabs
Using reference names
- Create reference names
- Go to a named item
- Use the Name Manager
- Use a reference name in a formula
Tables and Layout
- Automatic formatting of tables
- Create a custom style and apply to a table
- Conditional formatting
- Database functions: Filter and Sort
- Cell format and formatting
- Print the table
Exploiting Formulas in Excel
- Relative and absolute references
- Find and enter a function
- Use basic formulas: Sum, Average, Max, Date
- Use logical functions (SI), text and date
- Use search functions (VLOOKUP, HLOOKUP)
Creating Graphical Representations
- Select the data to be included in the graph
- graph type: histogram, curve, sector in 2D or 3D
- Choose a chart type as needed
- Apply a style
PivotTable / PivotChart
- Understand the usefulness of a PivotTable (examples)
- Create a PivotTable
- Formatting a PivotTable
- Use of segments
- Editing source data and updating
- To highlight the desired statistics in relation to its table
- Customize a PivotTable
- Creating a PivotChart
- Customize a PivotChart
Getting Started with Macros
- Principle of operation of a macro
- Save, write, execute macros
- Run a macro via shortcuts (in ribbon, button, etc.)
- Manage macros
Your VBA Training trainer
Prices and practical information
Preferred rate
$1,105 / participant
Public bodies and non-profits · plus taxes
Standard price
$1,301 / participant
Businesses and individuals · plus taxes
Practical information
- Length: 3 days
- Schedule: 9:00 a.m. to 4:30 p.m.
- Format: Live virtual class or in person in Montreal and Quebec City
- Payment: online (PayPal or card) when registering, or by invoice for organizations
Corporate VBA Training training
Train your whole team as a private group, on your own documents, at your premises or in a virtual class, on the dates that suit you.
Participant reviews
97% satisfaction (end-of-course evaluations, 120 evaluations) · Read all testimonials
Why take this VBA Training course
Objectives: what you will be able to do
- Know the basics Excel
-Use reference names
-To manage tables and layout
-Exploit formulas in Excel
-Create a PivotTable
-Create a PivotChart
-Discover macros
Prerequisites
Good knowledge of a PC or a Max
What is included
- Course materials and exercise files for each participant
- Certificate of attendance
- Optional personalized coaching after the course
- In public in-person sessions:
- Tea and coffee
- Lunch at a nearby restaurant
- Parking (in some cities)
- Wi-Fi access