25645 TEC courses delivered Online

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

FREE Welcome class, introduction to the Foundation and Diploma in Clinical Hypnotherapy and to your journey into the study and practice of Clinical Hypnotherapy. This induction session will give you a Course Overview and show you where to find all you need to support your learning experience. 

Learn how to drive innovation in your organisation and foster a creative, adaptive and sustainable work environment.

Join FlashAcademy and GEMS FirstPoint School Dubai, as we explore how we can empower multilingual learners.

Is learning to paint on your bucket list? This FREE beginner's class to experiment with watercolour paints, and have fun making a floral abstract greeting card. Learn to paint and draw a lovely floral greeting card in a more abstract, non-representational style!

The use of biomarkers is increasingly important in detection of disease in a variety of species, but, to date, these biomarkers are protein-based disease indicators. To truly detect disease at the earliest stage, understanding DNA/RNA expressions, prior to onset of pathology, would be groundbreaking. In this CPD session, Dr Eve Hanks will explore the use of microRNAs for diagnostic purposes and explain how this pioneering new testing technology can benefit your practice with the recent launch of the NEMO Companion Animal Heart Disease test.

Students will learn how easy it is to use 3D design software (Blender) to create personalised jewellery using Parametric Smart Objects

Start Your Happiness Journey with Our Free Bonus Course Today! Join our Happiness Bonus Course and discover scientifically backed practices to cultivate joy, resilience, and well-being. Dive into modules covering neurotransmitters, mindfulness, gratitude, self-compassion, ACT, and more. Create your personalized happiness plan and balance peace, play, and purpose in your life. Don't wait for one day, start today! #HappinessCourse #Mindfulness #WellBeing #SelfCompassion #Resilience #Gratitude #ACT #Joy #MentalHealth #FreeCourse

Understanding a buildings heat loss for heating engineers

A free sampler for the Motorcycle Skills - Improve your Riding in Eight Weeks online e-course from Survival Skills Rider Training