What you will learn
This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, basic VBA programming, e vent handling, control structures, and debugging tools.
You will learn the following:
- Record and edit a Macro recorded within Excel/Word
- Use different techniques in order to run any macros available such as keyboard commands, the use of the Quick Access Toolbars or Buttons
- Use VBA and examine the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures
- Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope
- Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks
- Create an error handling routine in case things go wrong with VBA code
Microsoft Excel is the world’s most popular spreadsheet application included in all Microsoft Office Suites. When used effectively it is a powerful tool, allowing you to analyse data and so much more.
We are pleased to announce that our BRAND NEW Excel course is now available, designed to support you in using Excel to increase efficiency and produce invaluable insights for your schools.
Our Advanced Excel for Data Managers training course has been designed to support Data Managers and further staff in a school environment from beginners to more advanced users.
These one-day courses will empower you with the knowledge and skills to manipulate, analyse and summarise data.
Throughout the course, you will be gaining outstanding guidance and support from our senior consultants who will show you how you can use this tool.
This course will enable you to effectively navigate, interpret and evaluate the data provided to gain the highest possible knowledge from the data.
Excel – Advanced Course
Our advanced course is for Data Managers who can already perform basic calculations and want to take their Excel skills to the next level.
You will learn:
• Formulae and Functions
• Named Ranges
• Pivot Tables and Charts
• Linking multiple worksheets
• Conditional Formatting
• Paste Special
• Using Tables
• Macros
One of the most practical and relevant training sessions I have attended as a headteacher.
Course Fee at Training Locations
In-house Course Fee
| Full Day | £995* |
| Half Day | £675* |
*All prices are excluded from VAT.
For any in-house enquiries, please contact us on 020 7183 8357.
Agenda for Advanced Excel for Data Managers Course 9am – 3:30pm
Course Content
Introduction
- What is a Macro
- Recording a Macro
- Relative References
- Running A Macro
- Running A Macro From The Macros Dialog Box
- Editing A Macro With Visual Basic
Assigning Macros to buttons and objects
- Assigning a Macro to a Button on a Sheet
- Assigning a Macro to a Drawn Object on a Sheet
- Assigning a Macro to a Button on a Toolbar
- Creating A Short-Cut Key To Run A Macro
Visual Basic Editor
- Objects
- Methods
- Properties
- Programming Tools
- The Menu Bar
Editing Macros
- The Visual Basic Editor
- The Project Explorer
- The Code Window
- Procedures
- Inserting Comments
- Printing a Visual Basic Module
The Range Object
- The Cells Property
- The Range Property
- Flexible Ranges
- Range Contents
Building Formulae Control Structures
- If…Then Decision Structures
- Logical Operators
- For… Loops
- Do Loops
Event Handling
- Vba Editing & Debugging
- Auto Macros
- Error Handling
Controls, Dialogue
- Built-In Dialogue Boxes
- Predefined Dialogue Boxes
- Custom Forms and Worksheet Forms
- User-Defined Forms
- Adding Form Controls
- Form Control Properties
- Control and Dialogue Box Events
- Displaying and Dismissing a User Form
- Handling Form Controls
Control Structures
- Conditional Control Structures
- Looping Control Structures
- Non-Structured Statements
- Subprocedures
Workbooks and Sheets
- Activating a Workbook
- Activating a Worksheet
- ThisWorkBook, Running Code
- Run Mode And Design Mode
- Running Code From The Development Environment
The Project Explorer
- Using The Project Explorer
The Properties Window
- Changing A Property
Using Constants
- Excel Constants and Variable Constants
Objects Properties and Methods
- Controlling Objects with their Properties
- Performing Actions with Methods
- Performing Multiple Actions on an Object
Excel Objects
- Objects, Properties and Methods
- Getting & Setting Properties
Variables
- Using Variables In Routines
Using Basic Functions
- Inputbox Function
- Msgbox Function
- Using A Set Statement
Cluster of Schools
More than one school can gather to request an in-house training. Maximum number of delegates is 12 for a quality training session. We can organise sessions in the morning and afternoon if your request more than 12 delegates to attend.
Alternatively, contact us by telephone/email to speak to one of our consultants to discuss your school’s needs, options and request a Personalised Training package.
About Us
Since 2006, we have specialised in ASP (formerly RAISEonline Training) for all schools and local authorities to analyse your school’s performance and progress data with your colleagues.
Our mission is to provide quality and multifaceted consultancy in education and training in Early Years settings, Primary Schools, Secondary Schools, Special Schools, Church Schools and Independent Schools.
ASP training and consultancy sessions can be personalised to support the professional development needs of your school team and offer consultancy support to Head Teachers, Deputy Head Teachers, Senior Management Teams, Subject Leaders, SENCO’s, Gifted and Talented Leaders, Class teachers, Newly Qualified Teachers, Learning Support Assistants and Governors.
We are here to support you with using tools such as ASP, Ofsted IDSR’s, Excel, FFT and MIS Systems as well as provide guidance for Governing Bodies, creating your school’s data story, EYFS, SEN, Gifted and Talented, Leadership and Management, School Improvement and Ofsted Preparation.
You can select your audience – Training can be 1:1 for Headteachers and Deputies, for particular focus groups or whole staff teams.
Consultancy & Training
ASP & IDSR Primary
ASP & IDSR Secondary
ASP & IDSR Post 16
Microsoft Excel
Introduction
Intermediate
Advanced
Expert
Pivot Tables
Dashboards
Excel Charts
Excel VBA Introduction
Power BI
Introduction 1 Day
Introduction 2 Days
Intermediate 2 Days
Advanced 2 Days
Microsoft Word
Introduction
Intermediate
Advanced
Microsoft PowerPoint
Microsoft Teams
Microsoft Sharepoint – End User
Booking Form
If you would like to book a course or find out more about our bespoke training, please fill the contact form below and we will get back to you as soon as possible. Please contact us on 0207 183 8357, option 5.
Please note, the below booking form will not be available until you accept the use of cookies and refresh