1931 Courses

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

Online MHFA England mental health first aid course delivered by Registered Mental Health Nurses from Mindmaps Wellbeing. Why choosing Mindmaps Wellbeing is a good choice for your mental health training. The MHFA England RRP is £325pp, our rate is £300pp and our fee includes: ✅ Instructor led training sessions over two days ✅ Course Manual ✅ Workbook ✅ Handy Cue Card ✅ MHFAider Certificate upon completion Plus, exclusively when you choose Mindmaps Wellbeing, it also includes: ✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life). ✅ Access to our online MHFAider peer support groups moderated by the instructor team. ✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider. ✅ Advanced Delegate Plan – This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available. For a little extra: ✅ Quarterly Facilitated MHFAider Forum – to provide ongoing expert support and guidance. ✅ Organisational MINDWELL Companion tailored for your workplace / organisation.

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

Python Data Analytics boot camp. 12 1 day lessons, learn Python Basics through to machine learning and front-ends. With practical project to give you full confidence and credibility.

Python Data Analytics with Python using Numpy, Pandas, Dataframes. Most attendees are in-work Data Professional. Private individuals are very welcome. Our Style: Hands-on, Practical Location: Online, Instructor-led

Monthly Craft Club held on the last Thursday of the month. A self led session working on your own project. Everyone Welcome.

Python Unittest Course Summary. Testing plays a major role in software development. This course will explain Python Unit Testing using the unittest built-in module. We'll cover issues before going to the production itself and the basics of testing in Python. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Unittest Certification Duration: 1-Day, 10am-5pm Unittest topics UnitTest Framework - Home UnitTest Framework - Overview UnitTest - Framework UnitTest - API UnitTest - Assertion UnitTest - Test Discovery UnitTest - Skip Test UnitTest - Exceptions Test UnitTest - Time Test UnitTest - Unittest2 UnitTest - Signal Handling UnitTest - Doctest UnitTest - Doctest API UnitTest - Py.test Module Nose Testing - Framework Nose Testing - Tools Included with Python Unittest Course Python Unittest Certificate on completion Python Unittest Videos Python Unittest Notes Python Unittest Examples Practical Python Unittest exercises

Android Studio Taster Course. Brilliant for a beginner to get started quickly. introduction to the Android Studio environment, to get you started. An interesting and fun session. Hands-on, Practical Course, Instructor-led. 1 hour In our London classroom or online with Gotomeeting.com

Dashboards will summarize and present the key indications of large data in an attractive visual display, hightlighting the most important trends so the most imporatnf aspects of data could could be seen in a snap second by glancing at attractive, colourful charts. PowerPivot helps analyze the data and brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. Power Pivot help analyze and understand the growing quantities of data that are created on a daily basis.

Join us for our Friday Night Dine In - How to cook Filipino Food This hands on workshop led by our exprienced cookery chef, Nicola Becci will give you the skills and knowledge to cook 6 different recipes.  We'll enhance the evening with some history and cultural knowledge including Filipino eating etiquette.  The meals are based on a vegetarian diet which can be adapted at home and do contain allergens (soy, sesame). Please advise if you have a vegan diet or specific allergen. At the end of the cooking session we will eat together as a group This event includes full list of recipes for all meals and a free meal kit to cook at home. £10 per ticket