4012 Courses near Bromley

Public Speaking Courses That Work Our public speaking courses are refreshingly different and transformative. Mindful presenting is the key to the future of high impact public speaking training. In fact, we are changing organisations one presentation at a time. We do that by providing training that empowers and equips professionals to present with greater confidence, clarity and impact.

Excel Advanced Course, 1-Day. Who should attend: Excel Advanced is for Excel Experts: Your work daily with Excel and your work revolves around spreadsheets and Excel databases. Course Details: Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Advanced Certification Hours: 1 Day, 10am-5pm Delivery Style: 1-1, because we understand that individuals have varying skill levels and varying applications. Excel Advanced Course Description General Editing Standard Formatting Rules Input Validate rules Using Formulas in Conditional Formatting Group and Outline Filter and Sorting Excel Tables and Advanced Filter Working with Excel tables Copy specific datasets from sheets, workbooks or external data Consilidate Goal seek, consolidate and scenarios Using Form Templates Creating Templates Advanced Excel Lookup Functions VLookup Function Hlookup Function Using the Index Function, Using the Match Function, Index and Match Together Using the Indirect Function Excel Advanced Functions Using Error Functions, Logical Functions, Array Functions, Rounding Functions Advanced Excel Pivot Table Tools Importing Pivot Table Data, Calculated Fields in Pivot Tables, Showing Pivot Data as a Percentage, Creating Custom Pivot Tables Styles Pivot Charts Excel Macros Creating, amending and deleting macros Running macros Macro menus, toolbars and shortcuts Alternative Excel Courses Inlcuded with the Excel Advanced Course PCWorkshops Excel Advanced Certificate on completion Excel Advanced Notes Excel Code Examples Practical Excel Advanced exercises Personalised attention in a 1-1 session About us Our experienced trainers are award winners. FAQ's Client Comments

Merging wellness, fitness and sensuality, London Bitty heels dance classes for beginners, provide a safe, supportive space for personal exploration, self love and confident liberation.

Join us for an immersive journey into Reiki Level 2, where you'll unlock the power of sacred symbols, master distant healing, and emerge as a certified Reiki professional.

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

The Generic Instructor Course trains future Instructors in the principles of adult learning. These skills can then be used to teach fellow healthcare professionals at a number of our courses, including ALS, EPALS and NLS.

The Generic Instructor Course trains future Instructors in the principles of adult learning. These skills can then be used to teach fellow healthcare professionals at a number of our courses, including ALS, EPALS and NLS.

You are only eligible to attend this course if you have been given Instructor Potential (IP'd) on the relevant provider course. You will not be eligible to attend this course without this.  **PLEASE ONLY APPLY FOR THE CORRECT ALLOCATION YOU HAVE BEEN GIVEN INSTRUCTOR POTENTIAL FOR!** The Generic Instructor Course trains future Instructors in the principles of adult learning. These skills can then be used to teach fellow healthcare professionals at a number of our courses, including ALS, EPALS and NLS. This course is a joint collaboration between Resuscitation Council UK and the Advanced Life Support Group (ALSG). Around 900 Instructors are trained on this course every year. This course consists of a day of e-learning followed by two days of face-to-face attendance, which will take place in a Resuscitation Council UK Course Centre.  Across the two day face-to-face sessions, Candidates will attend a lecture before taking part in practical sessions that cover the teaching modalities required to teach the provider courses. These include approaches to teaching skills acquisition, facilitating simulation, undertaking assessments and providing feedback to candidates. After successful completion of the GIC, Candidates must teach on two provider courses as an Instructor Candidate (IC) within two years of the GIC in order to complete their training and receive their qualification.