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

2556 Courses in London

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

ZUMBA LESSON IN HAMMERSMITH & CHISWICK EVERY WEDNESDAY @ 7PM

5.0(62)

By Club Azucar - Latin Dance

Zumba fitness in Hammersmith & Barnes with club Azucar – Latin dance taught by native instructor Patricia Nunez from Brazil every Monday @ 6 pm @ Rivercourt Methodist church, king st, w6 9jt nearest tube station Ravenscourt park (1-minute walk)

ZUMBA LESSON IN HAMMERSMITH & CHISWICK EVERY WEDNESDAY @ 7PM
Delivered In-Person in LondonWed, Nov 619:00 + more
£10 to £180

Spanish Conversational Club!

By Spanglish Languages and Culture

Spanish Conversational Club!
Delivered In-Person in LondonWed, Nov 619:30 + more
£10

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

Level 4 Sports Massage

5.0(11)

By MD Massage Therapies and Training

VTCT Level 4 Sports Massage

Level 4 Sports Massage
Delivered In-Person in LondonFri, Nov 810:30 + more
£250 to £1190

Java Basics Evening Course

4.6(12)

By PCWorkshops

Java Evenings Course. Basic Java syntax and principles of object-oriented programming. Our Style: Hands-on, Practical Course, Instructor-led Course. Level: From basics to fully functional. Who would benefit from the course: basics to Java, attend after work. Duration: one lesson of 2 hours per week for 6 weeks, from 6pm to 8pm.

Java Basics Evening Course
Delivered Online & In-Person in LondonThu, Nov 718:00 + more
FREE

Reiki Master Teacher

5.0(3)

By Stephanie Edwards

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.

Reiki Master Teacher
Delivered In-Person in LondonFri, Nov 809:30 + more
£180 to £400

Epoxy Resin Art Masterclass: Seascapes

By The River Shop

Join us for an afternoon in our studio to explore the joys of resin art seascapes.

Epoxy Resin Art Masterclass: Seascapes
Delivered In-Person in LondonSat, Nov 908:30 + more
£115

Excel Pivot Tables in 1 Hour, The Magic Data Cube

4.6(12)

By PCWorkshops

Pivot tables are really very easy to create, but very powerful. By using Excel pivot tables, one can get very interesting and valuable business intelligence from your data in very little time. This short session aims to give you the techniques to use this valuable Excel tool creatively. It is enough time to learn a lot about Excel Pivot Tables, but there is very little time for other questions.

Excel Pivot Tables in 1 Hour, The Magic Data Cube
Delivered Online & In-Person in LondonThu, Nov 710:00 + more
FREE

Excel Macros and VBA Course

4.6(12)

By PCWorkshops

For Excel users. Extend the capabilities of Excel with Macros and VBA code.

Excel Macros and VBA Course
Delivered Online & In-Person in LondonFri, Nov 811:00 + more
FREE