7128 Courses

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use 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 ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

What Will I Learn? You will learn how to use the manual settings on your camera to properly expose a photo. You will learn basic composition rules that will automatically improve your photography. You will learn what aperture is, and how to use it creatively. You will learn what shutter speed is, and how to prevent common beginner mistakes. You will learn what ISO is, and how to prevent 'noisy' photos. You will learn about the different photo settings and resolutions. You will understand the basic settings and rules that all pro photographers once learned. Learn how to become a professional photographer with this Digital Photography for Beginners course. Upon completion, you will know how to take stunning photos. You will learn the key foundations of photography including various camera settings such as photo resolution, shutter speeds and more. Taking beautiful images could not be easier, with this course. You will learn how to creatively use aperture, different shutter speeds, lighting and filters to take the best photos. This course is great for anyone at any level who is interested in learning photography. Learn how to take high-quality professional photos today.

10 QLS Endorsed Courses for Web Developer | 10 Endorsed Certificates Included | Lifetime Access | Tutor Support

This course is designed for absolute beginners and explains even the most basic concepts in Tableau from scratch. By completing this course, you will be able to create rich visualizations easily and confidently and have the knowledge required to crack the Tableau Desktop Specialist Exam.

Do you want to learn Tableau and crack the Tableau Certified Data Analyst Exam? Then this course is for you! This course is designed for absolute beginners, and it is well equipped with detailed video tutorials, exam notes PDF, tips and tricks, and full practice tests in exam format along with solutions.

*** Don't Spend More; Spend Smart*** Tired of browsing and searching for a Autodesk Revit course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Autodesk Revit bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Autodesk Revit course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Autodesk Revit and help you along your learning journey. Advanced audio-visual learning modules of these Autodesk Revit courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Autodesk Revit, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Autodesk Revit Bundle Consists of the following Premium courses: Course 01: Autodesk Revit: Modeling & Rendering Course 02: Revit Architecture Ultimate Interior Design Course Course 03: Revit Architecture Ultimate Exterior Design for Beginners Course 04: Revit Architecture Advanced Exterior Design Course Course 05: Architectural Studies Course 06: AutoCAD VBA Programming - Beginner course Course 07: CAD Design Course: Assemblies, Modelling And Civil Drawings Course 08: Mastering Colour-Architectural Design & Interior Decoration Course 09: WELL Building Standard Course 10: LEED V4: Building Design and Construction Course 11: Building Surveyor Course 12: Solidworks Foundation Training Course 13: Digital Art - Sketching In Photoshop Course 14: Decision Making and Critical Thinking Benefits you'll get choosing Apex Learning: Pay once and get lifetime access to 14 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course ) Hard Copy Certificate: Free (For The Title Course ) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Autodesk Revit expertise and essential knowledge, which will assist you in reaching your goal. Curriculum of Bundle Course 01: Autodesk Revit: Modeling & Rendering Section 1: Modelling and Rendering Living Area Section 2: Modelling and Rendering Bedroom Section 3: modelling and Rendering Kitchen Course 02: Revit Architecture Ultimate Interior Design Course Module 01: Modelling and Rendering Office Interior Module 02: Modelling and Rendering Living Room Course 03: Revit Architecture Ultimate Exterior Design for Beginners Section 1: Modelling Gorki House Section 2: Mountain house Section 3: Modelling Blue Domed Mosque Section 4: Modelling Taj Mahal Section 5: Modelling Residential house Course 04: Revit Architecture Advanced Exterior Design Course Section 1: Sketch to 3D Project 1 Section 2: Sketch to 3D Project 2 Section 3: Sketch to 3D Project 3 Section 4: Sketch to 3D Project 4 Section 5: Sketch to 3D Project 5 Course 05: Architectural Studies Module-1: Introduction to Architectural Studies Module-2: Ancient Architecture Module-3: Architectural Ideas and Movements Module-4: Architectural Styles Module-5: Art Deco Architectural Style Module-6: Scandinavian Architectural Style Course 06: AutoCAD VBA Programming - Beginner course Unit 01: Introduction Unit 02: VBA Integrated Development Environment (IDE) Unit 03: Understanding AutoCAD Object Model in VBA Unit 04: Using Variables in VBA Unit 05: User Forms and Controls Course 07: CAD Design Course: Assemblies, Modelling And Civil Drawings Module 01: Introduction to Geometry and Modelling Module 02: CAD Design Assemblies Module 03: Introduction to Extrusion and Rotations Module 04: CAD Blending Operations Module 05: Civil Drawing Parameters Course 08: Mastering Colour-Architectural Design & Interior Decoration Module 1: Introduction Module 2: The Impact of Fashion and Colour Trends Module 3: Colour Terminology Module 4: Colour Basics and Neutral Colours Module 5: Warm vs. Cool Colours Module 6: Colour Schemes Course 09: WELL Building Standard Unit 1: Introduction Unit 2: Air Unit 3: Water Unit 4: Nourishment Unit 5: Light Unit 6: Fitness Unit 7: Comfort Unit 8: Mind Course 10: LEED V4: Building Design and Construction Unit 01: Introduction Unit 02: Integrative Process Unit 03: Location & Transportation Unit 04: Sustainable Sites Unit 05: Water Efficiency Unit 06: Energy & Atmosphere Course 11: Building Surveyor Module 01: Building Survey: An Introduction Module 02: Building Law Principles Module 03: Building Procurement and Contract Administration Module 04: Building Information Modelling Module 05: Building Technology Module 06: The Procedure of Building Survey and Surveys of Historic Buildings Course 12: Solidworks Foundation Training Unit 01 Introduction Unit 02 Material, Appearance and Scene Unit 03 Lights and Camera Course 13: Digital Art - Sketching In Photoshop Module 01: Introduction Module 02: Introduction to Photoshop Module 03: Customizing Your Workspace Module 04: Creating a New Document CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Autodesk Revit bundle. Requirements Our Autodesk Revit course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Autodesk Revit expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.

Learn the fundamentals of good violin playing in just 90 minutes! Duration: 90 minutes (10am to 11.30am) Day: Various Saturdays - see schedule Tutor: David Worswick Venue: Whitcomb Street Studio, WC2H 7DT Introduction  Welcome to our Introductory Class, a 90 minute in-person class which covers the first principles of good violin playing in a fun, activity-focused way. Whether you're a first-time beginner or already have some knowledge of how to play, this class will give you clarity about the core skills you need to play the violin in time, in tune, and with a beautiful sound. Class Curriculum In this 90-minute class, you will explore foundational principles of good violin playing, including: Posture and the Body How to Hold the Violin How to Hold the Bow How to Make a Good Sound! Musical Fundamentals Playing with the Fingers Performing! Who is this course for? The ‘Fundamentals’ class is perfect for anyone who wants to get started in the best possible way with the violin. It’s also ideal if you’d like to try the violin for the first time, to see if it’s the right instrument for you. Because the class covers foundations principles that are applicable at every level of violin playing, it is also a great choice for people returning to the violin after some time away, or for violinists who already play, but who would like a quick ‘refresher’ course covering the fundamental principles of good bowing and tone production. You don't need any previous musical experience to take this course, and you don’t need to be able to read music notation, as the entire session is taught by ear. Why take this class? Personal Development - Connect with your creative side, and develop practice methods and performance techniques that will can be transferred to many other areas of your life! Meet Likeminded Learners - London String School learners come from all sorts of backgrounds and walks of life, Take Time for Yourself! In our busy, connected, city lives, there's rarely a time to stop and disconnect. Switch off to focus entirely on the violin, and 90 minutes later you'll emerge refreshed and energised by the power of music! Course Requirements You don’t need anything, or any previous experience, to take part in an Introductory ‘Fundamentals’ Violin Class! everything is taught by ear, so you don’t need to read music as there is no sheet music notation to to follow.  We can also provide a violin and bow for you to use! Certification Upon successful completion of the class, you can request a record of achievement certifying that you have completed the Beginner Violin Class! Course Instructor David Worswick, the lead tutor of London String School, will guide you through this learning journey. David has years of experience both as a teacher and performer, and was previously a first violinist in the London Symphony Orchestra. He is a kind, caring teacher who brings a wealth of knowledge and practical insights to help you succeed. Course Reviews Here's what some of our past students have said about our courses: ”[You have] enabled me to relearn the violin! Over the last few years I’ve gone from playing open strings to grade 5, enjoying performing solos and a wide variety of group numbers along the way. With no auditions or minimum standard it really is open to all and a great supportive environment!” - Georgina “This violin school has the best teachers in the country!” - Domini Register for an Introductory ‘Fundamentals’ Violin Class today, or get in touch with us if you have any questions! Join hundreds of learners who have already benefited from this comprehensive and engaging course, and unlock your musical potential!

10 QLS Endorsed Courses for Pentest Programmer | 10 Endorsed Certificates Included | Life Time Access

Give a compliment to your career and take it to the next level. This Java Certification Training Course bundlewill provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Java Certification Training Coursebundle will help you stay ahead of the pack. Throughout the Java Certification Training Courseprogramme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Java Certification Training Course course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Java Certification Training Course Bundle Consists of the following Premium courses: Course 01: Java Certification Cryptography Architecture Course 02: jQuery: JavaScript and AJAX Coding Course 03: SQL Programming Masterclass Course 04: Ultimate PHP & MySQL Web Development Course & OOP Coding Course 05: Cocos2d-x v3 JavaScript: Game Development Course 06: jQuery: JavaScript and AJAX Coding Bible Course 07: Intermediate Python Coding Course 08: Mastering Java for Beginners & Experts Course 09: Coding with HTML, CSS, & Javascript Course 10: WordPress Website Creation and Hosting System with Affiliate Marketing! Course 11: Front End Web Development Diploma Course 12: Learn Ethical Hacking From A-Z: Beginner To Expert Course 13: Master JavaScript with Data Visualization Course 14: Creative Thinking for Everyday Life Course 15: Stress Management Training Enrol now in Java Certification Training Course to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Java Certification Training Course expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Course Curriculum: (Title Course Only) Section 01: Introduction Introductory Lecture Setup Section 02: Java Cryptography Architecture: MessageDigest, MAC & PBKDF2 Simple Hashing Example Real-world Hashing Example Efficient Stream-Based Hashing Message Authentication Code (MAC) Secure Password Hashing with PBKDF2/PKCS#5 Section 03: Outro Commercial Wrapper Libraries: Demo JCE Unlimited Strength Policy File Installation CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Java Certification Training Course bundle. Requirements This Java Certification Training Course course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Cost of PDF Certificates is included in course price Certificate of completion Hard copy certificate - £9.99 You will get the Hard Copy certificate for the title course (Title Course) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

1 DAY FABRIC PRINTING WORKSHOP £75.00 The perfect introduction to fabric screen printing, our beginner workshop is ideal for anyone interested in learning the complete screen printing process or simply looking to print some tea towels or cushion covers with their own design for a special occasion. The sessions will run from 10am – 4:00pm (subject to class size) with a 30 min break for lunch. The day will be split as follows: Morning After a short intro into the studio and the process you’ll guided through how to coat and expose your design onto your screen. Afternoon After lunch we’ll decide on colours and select print pastes and go through the process of setting up the fabric tables ready for printing. When the screens are dry everyone will have a go at printing their fabric. Each person will walk away with 1 metre of fabric printed with their own 1 or 2 colour design. Outcome You will take away 1 meter of fabric with an experimental 1 to 2 colour printed design. — To book please scroll through the calendar and click the available date (highlighted in green) that you’d like to attend. All materials are provided including white/natural fabric, if you’d like to supply you own fabric please check with us first to make sure that it’s suitable for screen printing with our inks. Terms and conditions apply. Cancellation Policy: Please notice that we can’t reschedule or refund a workshop if it is requested 10 or less days before the date of the workshop. We regret we will not be able to replace or rearrange missed sessions either or exchange the price of the workshop for a voucher or another product. Please do not ask us to make exceptions and please understand we cannot accommodate everyones diary changes and sudden change of circumstances.