286 Courses in London

This course covers the essential Excel data skills. Our course is interactive, instructor-led. This Excel Data course is on offered on intermediate level of Excel and concentrates on the Data Analytical capabilities of Excel. These concepts are daily used by data analysts and is a basic essential skill for data professionals. By the end, you'll be able to use Excel for analytics, data summaries, trends and statistics. You will create Excel data analytical spreadsheets and samples that you can use as examples at work.

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

At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. Course level is beginners to intermediate.

Please read the full description!  Spanish Conversational Club.  Club de conversación en ESPAÑOL How does it work? The Spanglish club is for all people wanting to improve their Spanish outside of a class room. Depending on numbers, there are going to be groups of max 6 people, the group will be Beginners (A2), Intermediate and Advance. Each group will have a Spanish native speaker who can help you with your Spanish :) We will first meet our table amig@s and socialise, then we will make a fun and interesting activity for you to have a better Spanish speaking experience. Please book only if you are 100% sure to attend as there will be other Spanglishers waiting for you.  Where? Time? Royal Festival Hall, Riverside Bar (inside) Southbank Centre, Belvedere Rd, London SE1 8XX 19:30 to 21:00 Note: We will be at the second floor inside front of the Riverside Bar. Although, this might change depending on tables’ availability. Please look for Spanglish Flag/t-shirt or simply call us +447870776718, this is a public space, we don't have a private room.  Why should I come?  You should come if you want to be immersed in a Spanish conversation with native speakers for 90 mins and more! You should also come if you want to make new friends and learn about different cultures at the same time. Can we have a drink during the session?  Of course, it is all about feeling comfortable and we all know that a drink help us with fluency, there is a coffee shop and a bar at the center. Can I suggest topics or just make an open suggestion?  Of course, just bring your suggestions to the session or send us an email. Your event planner will ensure your suggestion has the right execution. We are here to help and provide you guys with the best environment possible for you to have fun and improve your Spanish speaking. Note: This event is not suggested for beginners A1 Zero Spanish learners. Please get in touch if you need some lessons. Suggestions or Qs Just drop me a WhatsApp, message or email. Our events are advertised on different platforms. For this event we expect around 12 people. Whatsapp, Calls or MSNs +447870776718 Instagram and Facebook as @spanglishlc We have more events and great teachers to enhance your learning, check all our events and teachers.

Salsa lesson for couples & singles in Hammersmith, Chiswick & Barnes with Club Azucar – Latin Dance taught by native instructor Ginu Nunez from Colombia every Monday @ 7 (Beginners) & 8:00 PM (Intermediate & Adv) @ Rivercourt Methodist church, king st, W6 9JT nearest tube station Ravenscourt Park (1-minute walk)

Intermediate/Advanced Lindy Hop class for experienced dancers! The class will kick off with footwork and partnered drills for connection & frame followed by building better basics. The second half of the class will focus on one topic which will vary from week to week and allow plenty of time for supervised practice and feedback.

This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements. Hands-on, Practical SQL course. You will get the PCWorkshops SQL Course Certificate. Max 4 people per course, to keep it personalised.

Practical MySQL Course Intermediate, to leave you fully conversant with queries, DML and DDL statements. Hands-on, Practical MySQL Course Intermediate. PCWorkshops MySQL Course Intermediate Certificate. Max 4 people per course, we keep it personalised.

This BigQuery Conversion course is for users of SQL. We cover the interface and licensing differences and additional capabilities. Highlights of BigQuery. We will cover the general SQL topics ( see our intermediate outline ) and point out where the differences are. You would be able to move to this platform easily.

Junos Intermediate Routing training course description This course provides students with intermediate routing knowledge and configuration examples. The course includes an overview of protocol-independent routing features, load balancing and filter-based forwarding, OSPF, BGP, IP tunneling, and high availability (HA) features. Junos Intermediate Routing (JIR) is an intermediate-level course. What will you learn Describe typical uses, configure & monitor static, aggregate, and generated routes. Configure and share routes between routing instances. Explain the operations of OSPF. Describe BGP and its basic operations. Configure and monitor GRE and IP-IP tunnels. Junos Intermediate Routing training course details Who will benefit: Engineers responsible for configuring and monitoring devices running the Junos OS. Prerequisites: Intro to the Junos Operating System Duration 2 days Junos Intermediate Routing training course contents Protocol-Independent Routing Static Routes Aggregated Routes Generated Routes Martian Addresses Routing Instances Lab 1 Protocol-Independent Routing Load Balancing and Filter-Based Forwarding Overview of Load Balancing Configuring and Monitoring Load Balancing Overview of Filter-Based Forwarding Configuring and Monitoring Filter-Based Forwarding Lab 2 Load Balancing and Filter-Based Forwarding Open Shortest Path First Overview of OSPF Adjacency Formation and the Designated Router Election OSPF Scalability Configuring and Monitoring OSPF Basic OSPF Troubleshooting Lab 3 Open Shortest Path First Border Gateway Protocol Overview of BGP BGP Attributes IBGP Versus EBGP Configuring and Monitoring BGP Lab 4 Border Gateway Protocol IP Tunneling Overview of IP Tunneling GRE and IP-IP Tunnels Implementing GRE and IP-IP Tunnels Lab 5 IP Tunneling High Availability Overview of High Availability Networks Graceful Restart Graceful RE Switchover Nonstop Active Routing BFD VRRP Lab 6 High Availability Appendix A: IPv6 Introduction to IPv6 Routing Protocol Configuration Examples Tunneling IPv6 over IPv4 Lab 7 (Optional) IPv6 Appendix B: IS-IS Overview of IS-IS Overview of IS-IS PDUs Adjacency Formation and DIS Election Configuring and Monitoring IS-IS Basic IS-IS Troubleshooting Lab 8 (Optional) IS-IS Appendix C: Routing Information Protocol Introduction to RIP RIP Configuration Examples Monitoring and Troubleshooting RIP