20317 Courses

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

One to one face to face Piano /Keyboard lessons Online Piano lessons(one to one)

This accredited qualification has been designed for delivery to all learners working or preparing to work in a customer service role or where using the telephone is a part of their role. This qualification covers the principles of customer service, including how to meet customer expectations, the importance of appropriate behaviour and communication techniques, as well as ways to deal with problem customers. How long will it take me to achieve this qualification? This qualification is classroom-based and usually achieved by taking a one-day course. However, it can also be achieved through a variety of other methods including blended and distance learning, as long as the recommended learning hours are completed. How is the qualification assessed? Through a 1-hour 30-question multiple-choice examination. Learners must achieve a score of at least 20 out of 30 in order to pass.

This accredited qualification is ideal for anyone who requires training in conflict management. It is appropriate for a wide range of sectors and is suitable for anyone who has a customer facing role, dealing with service users or the public. It is also a useful qualification for individuals who would like a better understanding of how to prevent conflict situations from arising and feel more confident in being able to deal with situations if they arise. Subjects covered include the role of communication and the assessment of risks in conflict situations and follow up practices after such events. How long will it take me to achieve this qualification? This qualification is usually achieved by taking a 2 day course. How is the qualification assessed? The qualification is assessed through a 1 hour, 30-question, multiple-choice question examination. Candidates must achieve a score of at least 20 out of 30 in order to pass.

Train to become a Driving Instructor with Driving Skills Academy and earn up to £40,000 + per annum after meeting all your business and car expenses. If you want to be your own boss and are looking for a well-paid job that you can fit in and around your lifestyle then becoming a driving instructor could be the ideal full time or part time career.

Have you ever felt that you are living life on autopilot? Going through the motions and being buffeted by life’s storms? If so, during this workshop, you will discover how to disengage your autopilot, to understand why we do what we do, gain clarity and a new perspective on what is happening in your life, plus explore the wonderful opportunities for positive change using NLP in order to take back the controls of your life.

This excellent Power BI covers the Query Editor and Dax Calculations in detail Online Instructor-led Classroom sessions available on request Practical, Hands-on, Interactive

(4-6yrs) Mini Movers is an introduction to more structured ballet dance and movement based class. The session includes Ballet and an introduction to JazzPops. TRIAL BOOKINGS: Of course you are welcome to watch the trial class but following the trial, WhizzDancers are expected to be independent in the room. TERM BOOKINGS: You are welcome to watch the first class but following this your WhizzDancer will be expected to go in the class independently. You will be expected to provide full uniform. Details will be sent following. We have lots of opportunities ahead for your WhizzDancer including exams and shows. We look forward to meeting them in the studio :) Please bring: - Comfortable clothes to move in (no zips or demin) - No ballet shoes required for the trial Please contact info@whizzdance.com for more information on how to book your free trial. 

This class is of a theatrical nature, all singing, all dancing and all acting! WhizzTheatrics is a Musical Theatre and performing arts class, promoting confidence, concentration, communication and coordination. TRIAL BOOKINGS: Of course you are welcome to watch the trial class but following the trial, WhizzDancers are expected to be independent in the room. TERM BOOKINGS: You are welcome to watch the first class but following this your WhizzDancer will be expected to go in the class independently. You will be expected to provide full uniform. Details will be sent following. We have lots of opportunities ahead for your WhizzDancer including exams and shows. We look forward to meeting them in the studio :) Upstairs Dance Studio Please bring: - Comfortable clothes to move in (no zips or demin) - No ballet shoes required for the trial Please contact info@whizzdance.com for more information on how to book your free trial. 

(4-6yrs) Mini Movers is an introduction to more structured ballet dance and movement based class. The session includes Ballet and an introduction to JazzPops. TRIAL BOOKINGS: Of course you are welcome to watch the trial class but following the trial, WhizzDancers are expected to be independent in the room. TERM BOOKINGS: You are welcome to watch the first class but following this your WhizzDancer will be expected to go in the class independently. You will be expected to provide full uniform. Details will be sent following. We have lots of opportunities ahead for your WhizzDancer including exams and shows. We look forward to meeting them in the studio :) Upstairs Dance Studio Please bring: - Comfortable clothes to move in (no zips or demin) - No ballet shoes required for the trial Please contact info@whizzdance.com for more information on how to book your free trial.