• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

3805 Courses in London delivered Live Online

VBA in Excel - Part 2

By Underscore Group

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

VBA in Excel - Part 2
Delivered in Horsham or OnlineFlexible Dates
Price on Enquiry

Snowboard Instructor Training Course

By EA Ski & Snowboard

Improve your riding and gain world-class qualifications as a snowboard instructor. With 4 - 11 week training options, you can ride for a month or a whole season.

Snowboard Instructor Training Course
Delivered OnlineFlexible Dates
Price on Enquiry

THE MENOPUASE LIFESTYLE PROJECT

By Eat Train Love

WANT TO LOSE WEIGHT, HAVE MORE ENERGY AND FEEL MORE HAPPY? The Menopause Lifestyle Project is a group programme and an opportunity to work with me in person, in the studio. The 4 week course is educational and will introduce you to what menopause is, why it happens, symptoms related to it and how you can best manage your lifestyle during this period. There is also be an introduction to strength training and a video programme to follow, either at home or in the gym. For more details on the next programme please get in touch.

THE MENOPUASE LIFESTYLE PROJECT
Delivered in Bolton or UK Wide or OnlineFlexible Dates
Price on Enquiry

SB Wellbeing - Corporate Training

By Eat Train Love

CORPORATE TRAINING There are currently 13 million women going through menopause in the UK. 4.3 million of them are aged between 45-55 years old, which is the fastest growing demographic in the workforce SB Wellbeing provides training for companies who are serious about providing support for their female staff going through menopause. Also, up-skilling managers and leaders on what they need to know.  Manager training includes what menopause is, how it can affect the individual at work, as well as the bigger picture of how it can impact the business, and how best to support them.    Colleague training is for anyone going through menopause or supporting someone who is. It's fully inclusive and highly interactive.  The two programmes can be run back to back or separately and be delivered via webinar or in-person. For more information and to book your training please get in touch. Here's what people are saying... " Thank you Sally for an amazing presentation yesterday – I had lots of the team say how good it was and how much they had learnt." - Leonard Design Architects, Nottingham "Just to say everyone absolutely loved training session 1!! The feedback from the second session was ace!! - Co-op Academy, Failsworth   "Open & frank conversation. Very factual and a great all round guide" - tp bennett, London   "The more staff that have this training the better, especially principle/director level." - tp bennett, London

SB Wellbeing - Corporate Training
Delivered in Bolton or UK Wide or OnlineFlexible Dates
Price on Enquiry

Supporting employees with chronic health conditions

By WorkLifePsych

Learn how to support employees living with chronic health conditions and get answers to your workplace wellbeing questions from recognised experts in the field.

Supporting employees with chronic health conditions
Delivered OnlineJoin Waitlist
FREE

Educators matching "TA"

Show all 2352
Vassilis Lazouras | Bass Guitar Lessons - London

vassilis lazouras | bass guitar lessons - london

5.0(4)

London

Bespoke bass guitar and music theory & harmony lessons for young students and adults in a friendly environment by a professional bass player. Whether you're a Beginner, Intermediate or Advanced player, I can give you the proper tools to take your bass playing to the next level. I provide tailored lessons to the individual that are specifically designed to enhance the right skills and to help you achieve your goals as a player and a musician.  Musical Subjects Being Taught: • Bass Technique and Fretboard Knowledge • Sight Reading • Music Theory & Harmony • Ear Training • Styles & Bassline Creation • Groove, Feel & Timing • Bass Gear & Tone Tips • Exam Preparation - ABOUT ME: Vassilis Lazouras is a professional bass player and music tutor that has dedicated his life’s works to music and performance. He got involved with music at young age and he is now working in London as a professional musician and a freelance bassist, after graduating from the Institute of Contemporary Music Performance. Over the last years, he has performed live at many different venues in venues in London such as the 100 Club, The Borderline, the O2 Kentish Town, the O2 Academy Islington, the Tramp Members Club, the Albert’s Members Club and many more. By recording and playing with many artists he became able to adapt in a variety of different styles of music. Most recently he had the opportunity to work with well known music producers/engineers such as Sam Miller (Paloma Faith, Christina Aguilera, PJ Harvey, The Temperance Movement, One Direction, Razorlight, The Magic Numbers) and Steve Lyon (Depeche Mode, The Cure, Paul McCartney, George Best, Laura Pausini) and to perform next to great musicians such as the session guitarist Joon Switon (The Roots, Compton, Les Nubians, Ayo, Eric Roberson and more), the L.A. based jazz singer Tricia Tahara (Patrice Rushen, Alphonso Johnson, Lenny White, Nungu Chancler), percussionist João Caetano (Incognito, Chaka Khan, Mario Biondi, Omar, PB Underground) and guitarist Tolis Zavaliaris (Pete Lockett, Laurence Cottle, Neil Angilley, Vanessa Mae). In addition, he also had the chance to open for artists such as LP, Steve Cradock (Paul Weller, Ocean Colour Scene) and Finley Quaye. He is now continuing to work in London as a professional musician and his aim is to become a versatile bassist and to gain as much experience as possible.