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.
Cosmic Path-Weekly Ashtanga Yoga Inspired flow suitable for beginners with Adriana. 1 hour yoga class on Wednesdays at Art and Spirituality CIC, Edinburgh.
Join our free webinar to learn how to optimize the generic settings on any smartphone for creating high-quality videos. Perfect for small business owners and entrepreneurs looking to boost their online presence with professional video content.
CRR UK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.
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
The three day course allows us to focus on the more refined shapes of a knife specifically designed for cooking, on this course we will forge a matched pair of knives, a small pairing knife and a larger kitchen knife both with a hidden tang and two part handle in the Wa style. The extended length of the course allows students to focus on getting a clean shape and flowing lines as well as a thing and practical blade for cooking. Please note this course is only held three times a year. I run a strict cancellation policy. If you cannot attend the date you have booked please contact me within three weeks and I will rebook your course for free, If you contact me after this deadline you will lose your place. Refunds are not available. Courses dates can only be moved once. Courses valid for one year from date of purchase. No under 18s If you have a physical gift voucher it must be presented on the first day of a course. Course dates must be determines in advance. Vouchers not exchangeable for monetary value. If the course cost is larger than the face value of the voucher(s) the difference must be made up in advance, if it is less no change is given. Vouchers cannot be replaced if lost, stolen or destroyed. *Gift vouchers are valid for one year from date of purchase