63008 Courses

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

The ACTIVE Coaching® system provides powerful, effective coaching to un-lock employee potential, improve motivation as well as build self-confidence.

This Creative Writing Course is the perfect starting point for anyone eager to dive into the world of storytelling. Whether you’ve always dreamed of writing a novel, crafting compelling short stories, or simply improving your writing skills for your blog, this course is designed to guide you through every step of the creative process.

You may be required to bring a model with you to this course. Part 1: Lash lift & tint A fully comprehensive course to teach the natural eyelashes lash lift treatment. Training includes all Anatomy, Physiology, Theory and practical work necessary to create beautifully lifted lashes, that look longer, thicker and more dramatic. It is often said that the eyes are the windows to the soul, and it is for this reason that women have paid close attention to how they are presented for centuries. This course will teach you about the technique, products and tools used to provide a professional Lash Lift and Tint treatment and includes a practical training session and assessment. Part 2: Lamination Brow Brow lamination realigns brow hairs into a new shape adding fullness and definition which can last up to 2 months. This course will teach you about the technique, products and tools used to provide a professional Brow lamination treatment and includes a practical training session and assessment. Includes: 2 Hard copy take home training manuals. Duration – Fast track one day practical classroom-based training plus online theory work. Theory work to be completed in your own time via The Guild student portal before your practical course date. Practical day – 10am-6pm. It is advisable that students arrive 15 mins early to ensure a prompt start. In a lot of cases the practical training can be finished earlier than expected depending on how many students there are, and the time taken on practical work. Widely recognisable and insurable qualification, allowing you to deliver this treatment on the paying general public. Class size - Maximum 8 students in a class

You may be required to bring a model with you to this course. Part 1: Lash lift & tint A fully comprehensive course to teach the natural eyelashes lash lift treatment. Training includes all Anatomy, Physiology, Theory and practical work necessary to create beautifully lifted lashes, that look longer, thicker and more dramatic. It is often said that the eyes are the windows to the soul, and it is for this reason that women have paid close attention to how they are presented for centuries.  Includes: 2 Hard copy take home training manuals. Duration – Fast track one day practical classroom-based training plus online theory work. Theory work to be completed in your own time via The Guild student portal before your practical course date. Practical day – 10am-6pm. It is advisable that students arrive 15 mins early to ensure a prompt start. In a lot of cases the practical training can be finished earlier than expected depending on how many students there are, and the time taken on practical work. Widely recognisable and insurable qualification, allowing you to deliver this treatment on the paying general public. Class size - Maximum 8 students in a class This course will teach you about the technique, products and tools used to provide a professional Lash Lift and Tint treatment and includes a practical training session and assessment. Part 2: Lamination Brow Brow lamination realigns brow hairs into a new shape adding fullness and definition which can last up to 2 months. This course will teach you about the technique, products and tools used to provide a professional Brow lamination treatment and includes a practical training session and assessment.

his course covers the technique for eyebrow tinting, eyebrow waxing, threading the eyebrows and surrounding area and the application of make-up to the eyebrow area. It also includes fantastic anatomy & physiology resources with clear diagrams. Reception, consultation and aftercare guidance is covered as well as contra-indications to treatment. Photographs and diagrams ensure this course is both engaging and informative to give you the confidence to perform this very popular treatment.  Includes: 2 Hard copy take home training manuals. Duration – Fast track two-day practical classroom-based training plus online theory work. Theory work to be completed in your own time via The Guild student portal before your practical course date. Practical day – 10.30am-4.30pm. It is advisable that students arrive 15 mins early to ensure a prompt start. In a lot of cases the practical training can be finished earlier than expected depending on how many students there are, and the time taken on practical work. Widely recognisable and insurable qualification, allowing you to deliver this treatment on the paying general public. Class size - Maximum 8 students in a class

his course covers the technique for eyebrow tinting, eyebrow waxing, threading the eyebrows and surrounding area and the application of make-up to the eyebrow area. It also includes fantastic anatomy & physiology resources with clear diagrams. Reception, consultation and aftercare guidance is covered as well as contra-indications to treatment. Photographs and diagrams ensure this course is both engaging and informative to give you the confidence to perform this very popular treatment.  Includes: 2 Hard copy take home training manuals. Duration – Fast track two-day practical classroom-based training plus online theory work. Theory work to be completed in your own time via The Guild student portal before your practical course date. Practical day – 10.30am-4.30pm. It is advisable that students arrive 15 mins early to ensure a prompt start. In a lot of cases the practical training can be finished earlier than expected depending on how many students there are, and the time taken on practical work. Widely recognisable and insurable qualification, allowing you to deliver this treatment on the paying general public. Class size - Maximum 8 students in a class

You may be required to bring a model with you to this course. Part 1: Lash lift & tint A fully comprehensive course to teach the natural eyelashes lash lift treatment. Training includes all Anatomy, Physiology, Theory and practical work necessary to create beautifully lifted lashes, that look longer, thicker and more dramatic. It is often said that the eyes are the windows to the soul, and it is for this reason that women have paid close attention to how they are presented for centuries. This course will teach you about the technique, products and tools used to provide a professional Lash Lift and Tint treatment and includes a practical training session and assessment. Part 2: Lamination Brow Brow lamination realigns brow hairs into a new shape adding fullness and definition which can last up to 2 months. This course will teach you about the technique, products and tools used to provide a professional Brow lamination treatment and includes a practical training session and assessment.  Includes: 2 Hard copy take home training manuals. Duration – Fast track one day practical classroom-based training plus online theory work. Theory work to be completed in your own time via The Guild student portal before your practical course date. Practical day – 10am-6pm. It is advisable that students arrive 15 mins early to ensure a prompt start. In a lot of cases the practical training can be finished earlier than expected depending on how many students there are, and the time taken on practical work. Widely recognisable and insurable qualification, allowing you to deliver this treatment on the paying general public. Class size - Maximum 8 students in a class

You may be required to bring a model with you to this course. Part 1: Lash lift & tint A fully comprehensive course to teach the natural eyelashes lash lift treatment. Training includes all Anatomy, Physiology, Theory and practical work necessary to create beautifully lifted lashes, that look longer, thicker and more dramatic. It is often said that the eyes are the windows to the soul, and it is for this reason that women have paid close attention to how they are presented for centuries. This course will teach you about the technique, products and tools used to provide a professional Lash Lift and Tint treatment and includes a practical training session and assessment. Part 2: Lamination Brow Brow lamination realigns brow hairs into a new shape adding fullness and definition which can last up to 2 months. This course will teach you about the technique, products and tools used to provide a professional Brow lamination treatment and includes a practical training session and assessment.  Includes: 2 Hard copy take home training manuals. Duration – Fast track one day practical classroom-based training plus online theory work. Theory work to be completed in your own time via The Guild student portal before your practical course date. Practical day – 10am-6pm. It is advisable that students arrive 15 mins early to ensure a prompt start. In a lot of cases the practical training can be finished earlier than expected depending on how many students there are, and the time taken on practical work. Widely recognisable and insurable qualification, allowing you to deliver this treatment on the paying general public. Class size - Maximum 8 students in a class

You may be required to bring a model with you to this course. Part 1: Lash lift & tint A fully comprehensive course to teach the natural eyelashes lash lift treatment. Training includes all Anatomy, Physiology, Theory and practical work necessary to create beautifully lifted lashes, that look longer, thicker and more dramatic. It is often said that the eyes are the windows to the soul, and it is for this reason that women have paid close attention to how they are presented for centuries. This course will teach you about the technique, products and tools used to provide a professional Lash Lift and Tint treatment and includes a practical training session and assessment. Part 2: Lamination Brow Brow lamination realigns brow hairs into a new shape adding fullness and definition which can last up to 2 months. This course will teach you about the technique, products and tools used to provide a professional Brow lamination treatment and includes a practical training session and assessment.  Includes: 2 Hard copy take home training manuals. Duration – Fast track one day practical classroom-based training plus online theory work. Theory work to be completed in your own time via The Guild student portal before your practical course date. Practical day – 10am-6pm. It is advisable that students arrive 15 mins early to ensure a prompt start. In a lot of cases the practical training can be finished earlier than expected depending on how many students there are, and the time taken on practical work. Widely recognisable and insurable qualification, allowing you to deliver this treatment on the paying general public. Class size - Maximum 8 students in a class