345 Courses in London

Employee Engagement 1 Day Training in London

Sales Management 2 Days Training in Bromley

Sales Management 2 Days Training in Heathrow

Employee Engagement 1 Day Training in Bromley

Employee Engagement 1 Day Training in Heathrow

Excel Intermediate Course, 1-Day. This course covers the essential Excel Intermediate, in our interactive, instructor led Live Virtual Classroom. You already know your way around Excel e.g. you understand some of the functionality on the Home Ribbons, can move around and format cells. etc. In the Excel intermediate course we cover in-depth functions and Formulae so that you will be able to create fantastic spreadsheets like budgets, forecasts, and more. You will be able to understand and unravel the complicated formulae created by your colleagues. During the course you will excellent spreadsheets so that you have examples to take away. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Intermediate Certification Hours: 1 Day, 10am-5pm Excel Intermediate Course, Course Outline. Working with Functions and Formulas The Function Wizard Using Functions in Excel: The 5 Popular functions If-else function Working with Names and Ranges Copying formulae Creating Formulae in Excel, general calculations. Lookups: Vlookup, Hlookup, Index, Match. Formatting a Range as a Table: Properties and behaviour of a table. Managing Tables: Working with Tables. Working with Tables: Working with Records and Fields. Filters and Sorting, Freeze panes, split, protecting and unprotecting. Using Excel as a Database: Advanced filter: copy only specified rows and columns from a large data set, auto mate this selective copy. Pivot-tables: Create Pivot Table, Refresh Data. Amend, Filter, Sort, Format Pivot Tables, Add additional Pivot formulae. Pivot Charts: Excel Pivot Charts and Sparklines. Examples and exercises with Pivot Charts and Sparklines. Other Excel Courses Inlcuded with the Excel Intermediate Course PCWorkshops Excel Intermediate Certificate on completion Excel Intermediate Notes Excel Code Examples Practical Excel Intermediate exercises Personal attention in a small group of up to 4 delegates Book the Excel Intermediate Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

Complete VBA programming training course description This course helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience, you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. We start at the beginning to get you acquainted with VBA so you can start recording macros right away. You'll then build upon that foundation to utilize the full capabilities of the language in Word, Excel, Outlook, and PowerPoint. What will you learn Record, write and run macros. Work with VBA Editor. Use the huge library of built-in functions. Create simple dialog boxes and complex forms. Customize Word, Excel, PowerPoint, Outlook, and Access. Program the Office 2016 ribbon. Complete VBA programming training course details Who will benefit: Anyone looking to extend the capabilities of the entire Office suite using VBA. Prerequisites: None. Duration 5 days Complete VBA programming training course contents Macros and getting started in VBA VBA syntax, variables, constants, and enumerations, array variables, finding objects, methods, and properties. Working with VBA 1 VBA syntax, variables, constants, and enumerations, array variables, finding objects, methods, and properties. Decisions, loops and functions Built-in functions, creating your own functions, making decisions in your code, using loops to repeat actions. Using message boxes, input boxes, and dialog boxes Getting user input with message boxes and input boxes, creating simple custom dialog boxes, creating complex forms. Creating effective code Building modular code and using classes, debugging your code and handling errors, building well-behaved code, exploring VBA's security features. Programming the Office applications The Word object model and key objects, working with widely used objects in Word, the Excel object model and key objects, working with widely used objects in Excel, the PowerPoint object, model and key objects, working with shapes and running slide shows, the Outlook object model and key objects, working with events in Outlook, the Access object model and key objects, manipulating the data in an Access database via VBA, accessing one application from another application, programming the Office 2016 ribbon.

City & Guilds 18th edition course with 2382-22 final exam only £234.00. Exams available every week across the UK, same day results, quick certificate, best prices..

Upon successful completion of the course, you will be awarded the nationally recognised VTCT/ NVQ Level 3 Beauty Therapy Diploma. This comprehensive program is perfect for individuals seeking a rewarding career in the competitive and lucrative beauty industry, particularly in London. Throughout the beauty course, you will receive unparalleled support from our team of highly experienced tutors. Our goal is to equip you with the necessary skills to excel in the beauty industry. To achieve this, we provide additional beauty training and skills, ensuring that you are up-to-date with the latest industry trends and techniques. At the Cosmetic College, we are committed to fostering the well-being and growth of all our students. We strive to help our students succeed from the moment they begin their beauty career. Our courses are carefully selected to enhance career development and equip our students with the necessary skills and confidence to excel in the competitive beauty industry. As a result of our unwavering commitment to excellence, our beauty therapy graduates are highly sought after by top spas and salons worldwide. Our teaching methods and courses are continuously refined to ensure that we are always providing the highest level of expertise to our students. We take pride in the success of our students and are dedicated to helping them achieve their full potential. By choosing to train at the Cosmetic College, you can be confident that you will receive the best education and training in the beauty industry, preparing you for a successful and fulfilling career.

Basic diabetes management Diabetes management course Diabetes management training Diabetes care for healthcare professionals Diabetes education program Blood glucose monitoring techniques Balanced nutrition for diabetes Medications for diabetes Insulin therapy basics Lifestyle modifications in diabetes Diabetic complications prevention Patient education in diabetes care Diabetes technology advancements Hands-on diabetes practice CPD accredited diabetes course Healthcare professional diabetes training Understanding diabetes types Practical skills in diabetes management Real-world diabetes scenarios Evidence-based diabetes intervention