• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

62409 Courses

Excel Intermediate Course, 1-Day

4.6(12)

By PCWorkshops

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

Excel Intermediate Course, 1-Day
Delivered Online & In-Person in LondonWed, Nov 611:00 + more
FREE

ONLINE - WSET Level 1 Award in Wines - Evenings

By Manchester Wine School

ONLINE - WSET Level 1 Award in Wines - Evenings
Delivered OnlineWed, Nov 619:00 + more
£165

Excel Advanced Course, 1-Day

4.6(12)

By PCWorkshops

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

Excel Advanced  Course, 1-Day
Delivered Online & In-Person in LondonThu, Nov 711:00 + more
£200

Dance Technic class Open level ( Online )

5.0(4)

By Pirita Tuisku

Build Strength & Confidence: Improve core strength, leg alignment, balance to elevate your dance skills! Join now to Pirita Tuisku´s Dance technic class and keep on dancing!

Dance Technic class Open level  ( Online )
Delivered OnlineWed, Nov 617:45 + more
£7 to £9.5

Professional Certificate in Content Design

By UX Design Institute

Professional Certificate in Content Design
Delivered OnlineThu, Nov 709:00 + more
£1750

e-ALS Q&A Online session

5.0(2)

By Hunter Clinical Training

Are you thinking of booking an e-ALS course or have already booked one? Want to know what to expect? Join us for a live Q&A session online (it's free!) We will go through the programme and explain what to expect from each session of the day and also give you a chance to ask questions.

e-ALS Q&A Online session
Delivered OnlineWed, Nov 618:00 + more
FREE

Professional Certificate in User Research

By UX Design Institute

Professional Certificate in User Research
Delivered OnlineThu, Nov 709:00 + more
£1575 to £1750

Level 4 Certificate in Leading IQA

By Panda Education and Training Ltd

Leading Internal Quality Assurance; Leading IQA

Level 4 Certificate in Leading IQA
Delivered OnlineThu, Nov 709:30 + more
£450

CITB SSSTS (Site Supervisor Safety Training Scheme)

By 2020 Training

This two-day Site supervision safety training scheme (SSSTS) course is designed for those who have, or are about to acquire, supervisory responsibilities. The course covers all relevant legislation and other aspects which affect safe working in the building, construction and civil engineering industries. It is delivered interactively including group and individual activities. It highlights the need for risk assessment in the workplace, the implementation of the necessary control measures, and adequate communication to sustain a health and safety culture among the workforce. The Aim of the course is to help site supervisors to supervise health and safety on site in accordance with current legal provisions and within the context of their role. They should develop an understanding of responsibility and accountability for site health, safety and welfare of workers on site and be able to recognise that a safe site is efficient, economical, productive and environmentally friendly. At the start of each course, delegates will be provided with their own copy of the mandatory publications: (Construction site supervision and Toolbox talks) The course is broken down into 5 learning areas Legal and management Health and welfare General safety High risk activities Environment

CITB SSSTS (Site Supervisor Safety Training Scheme)
Delivered In-Person in Hull + 2 moreThu, Nov 708:30 + more
£268

Project Scope and Schedule Management

By Nexus Human

Project Scope and Schedule Management
Delivered OnlineThu, Nov 713:00
£1190