5585 Courses

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

Understand the Terminology of Modern Project Management with this Handy Guide and Glossary

Learn how to use this powerful tool to import and clean data and create some amazing visuals. Course overview Duration: 2 days (13 hours) Power BI Desktop is a powerful tool for working with your data. It enables you to import multiple data sources and create effective visualisations and reports. This course is an introduction to Power BI to get you started on creating a powerful reporting capability. You should have a good working knowledge of Excel and managing data before attending. Objectives  By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Create reports Create different visualisations Create data models Build data relationships Use the drill down features Create measures Use the Power BI Service Build dashboards Use the mobile app Content Essentials Importing Data Power BI Overview Data sources Importing data Transforming Your Data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Creating Reports Creating and saving reports Adding pages Renaming pages Interactivity Refreshing your data Adding Columns Columns from example Custom columns Conditional columns Append Queries Importing folders Setting up and using append queries Creating Chart Visualisations Adding chart elements Choosing chart types Setting properties Setting values, axis and legends Using tooltips Visual filters Setting page and report filters Creating Tables, Cards, Gauges and Maps Adding table elements Adding maps Working with cards Working with matrices KPIs and Gauges Conditional Formatting Setting rules Removing conditional formatting   Working with Data Models Merge Queries Setting up and using merge queries Merging in columns of data Creating a Data Model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Unpivoting Data Working with summary data Unpivoting data Using Hierarchies Using built in hierarchies Drill down Drill up See next level Expand a hierarchy Create a new hierarchy Grouping Grouping text fields Grouping date and number fields Creating Measures DAX functions DAX syntax Creating a new measure Using quick measures Using the PowerBI Service Shared workspaces My workspace Dashboards Reports Datasets Drill down in dashboards Focus mode Using Q&A Refreshing data Using Quick Insights Power BI Mobile App Using the Power BI Mobile App

Project Management Template Kit and Checklists

Our classes operate seven days a week in Surrey and Sussex across several different venues. See ‘Our Venues’ page for more information. Below you will find our Class Schedule with information on where each of our classes run. Please send an enquiry to our friendly office team to check availability. Please note: Some of our classes do have a waiting list. Oakwood Sports Centre, Horley DAY TIME ACTIVITY LEVEL Monday 6:00pm to 7:00pm Boys Gymnastics School Starting Age Monday 7:00pm to 8:00pm Freestyle Gymnastics School Starting Age Monday 8:00pm to 9:00pm Adult Combined Class (Gymnastics and Trampoline) Ages 16+ Wednesday 6:00 pm to 7:00 pm Youth Gymnastics Ages 10-19 yrs Wednesday 7:00 pm to 8:00 pm Freestyle Gymnastics School Starting Age Wednesday 8:00 pm to 9:00 pm Freestyle Gymnastics Ages 10+ Thursday 5:00pm to 6:00pm Boys Gymnastics School Starting Age Thursday 6:00pm to 8:00pm Elite Gymnastics By Invitation Only Thursday 8:00pm to 9:00pm Adult Gymnastics Adults Friday 5:00pm to 6:00pm Gymnastics Beginners. School Starting Age Friday 6:00pm to 7:00pm Gymnastics Improvers Friday 7:00pm to 8:30pm Gymnastics Advanced Saturday 9:00am to 10:00am FunFit Ages 2+ Saturday 10:00am to 11:00am FunFit Ages 2+ Saturday 11:00am to 12:00pm Gymnastics Beginners. School Starting Age Saturday 12:00pm to 1:00pm Gymnastics Improvers Saturday 1:00pm to 2:00pm Gymnastics Advanced Sunday 9:00am to 10:00am FunFit Ages 2+ Sunday 10:00am to 11:00am FunFit Ages 2+ Sunday 11:00am to 12:00pm Gymnastics Beginners. School Starting Age Hazelwick School, Crawley Day Time Activity Level Friday 5:30pm to 6:30pm Gymnastics Beginners. School Starting Age Friday 6:30pm to 7:30pm Gymnastics Improvers Friday 7:30pm to 9:00pm Gymnastics Advanced Saturday 9:00am to 10:00am FunFit Ages 2+ Saturday 10:00am to 11:00am FunFit Ages 2+ Saturday 11:00am to 12:00pm Gymnastics Beginners. School Starting Age Saturday 12:00pm to 1:00pm Gymnastics Beginners. School Starting Age Saturday 1:00pm to 2:00pm Gymnastics Improvers St Bedes School, Redhill Location Day Time Activity Level Gymnasium Monday 6:00pm - 7:00pm Gymnastics Beginners. School Starting Age Gymnasium Monday 7:00 pm - 8:00pm Gymnastics Advanced Gymnasium Wednesday 6:00 pm - 7:00 pm Gymnastics Beginners. School Starting Age Gymnasium Wednesday 7:00 pm - 8:00 pm Gymnastics Improvers Jubilee Centre, East Grinstead Day Time Activity Level Tuesday 10:00 am - 11:00 am FunFit (Preschool) Ages 2+ Tuesday 11:00 am - 12:00 pm FunFit (Preschool) Ages 2+ Tuesday 4:00 pm - 5:00 pm Gymnastics Beginners. School Starting Age Tuesday 5:00 pm - 6:00 pm Gymnastics Beginners. School Starting Age Tuesday 6:00 pm - 7:00 pm Gymnastics Improvers Tuesday 7:00 pm - 8:00 pm Gymnastics Advanced Thursday 4:00 pm - 5:00 pm Gymnastics Beginners. School Starting Age Thursday 5:00 pm - 6:00 pm Gymnastics Improvers Thursday 6:00 pm - 7:00 pm Gymnastics Advanced Copthorne Parish Hub, Copthorne Day Time Activity Level Monday 4:30pm to 5:30pm Gymnastics Improvers Monday 5:30pm to 6:30pm Gymnastics Advanced Tuesday 3:30pm to 4:30pm Gymnastics Beginners. School Starting Age Tuesday 4:30pm to 5:30pm Gymnastics Improvers Tuesday 5:30pm to 6:30pm Gymnastics Advanced Thursday 5:00pm to 6:00pm Gymnastics Beginners. School Starting Age Thursday 6:00pm to 7:00pm Gymnastics Improvers Friday 5:30pm to 6:30pm Gymnastics Beginners. School Starting Age Friday 6:30pm to 8:00pm Gymnastics Advanced Saturday 9:00am to 9:45am Kinder Gym (Preschool Gymnastics) Ages 2+ Saturday 9:45am to 10:30am Kinder Gym (Preschool Gymnastics) Ages 2+ Saturday 10:30am - 11:15pm Kinder Gym (Preschool Gymnastics) Ages 2+ Saturday 11:15pm - 12:15pm Gymnastics Beginners. School Starting Age Saturday 12:15pm - 1:15pm Gymnastics Improvers Oxted School, Oxted Day Time Activity Level Friday 5:30pm to 6:30pm Gymnastics Beginners. School Starting Age Friday 6:30pm to 7:30pm Gymnastics Improvers Friday 7:30pm to 8:30pm Gymnastics Advanced St Margaret's School, Crawley Day Time Activity Level Tuesday 3:30pm to 4:30pm Gymnastics Beginners. School Starting Age Tuesday 4:30pm to 5:30pm Gymnastics Improvers Thursdays 3:30pm to 4:30pm Gymnastics Beginners. School Starting Age Thursdays 4:30pm to 5:30pm Gymnastics Improvers Club Closure Dates Our classes operate all year round except for two weeks over Christmas and New Year. We are also closed on Easter Weekend and Bank Holidays