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 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
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.
his course covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom. This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language. These concepts are daily used by programmers and is your first step to working as a programmer. By the end, you'll be comfortable in programming Python code. You will have done small projects. This will serve for you as examples and samples that you can use to build larger projects.
Understanding commodity codes is vital to internationally trading businesses. Commodity codes are used worldwide to determine the customs duty and other charges levied on the goods when importing and exporting. They also determine any preferential treatments or restrictions and prohibitions that may apply to the goods and are used for monitoring trade volumes and applying international trade measures. This virtual half-day course will provide an insight into what commodity codes are and how getting them wrong can have a big impact on your business. By attending this course, we will ensure you: Are aware of what a commodity code is and what it is used for Understand the process of how to classify goods Successfully classify a range of goods Understand the importance of getting your commodity codes correct. Please note: If you are working towards your British Chamber of Commerce (BCC) Foundation Award, this course will count towards 1 of your 6 modules. Please make sure you select the ‘Yes’ option in the dropdown option for BCC when booking.
The “ISO 42001:2023 Lead Auditor Course” integrates the principles of ISO 42001:2023, the International Standard for Artificial Intelligence Management, with the methodologies outlined in ISO 19011:2018, the Guidelines for Auditing Management Systems. The course equips participants with the skills and knowledge required to lead Artificial Intelligence audits effectively, ensuring compliance with ISO 42001:2023, and applies the principles of ISO 17011:2017 for conformity assessment bodies.
Recent changes to Forestry Commission policy recommend those who work in the Forestry industry attend training which includes additional topics relevant to the risks and nature or their work. The Forestry Commission recommend topics including: Crush Injuries Catastrophic bleeding including chainsaw including chainsaw injuries and gun shot wounds Hypothermia / Exposure Suspension injuries Lyme's Disease Lightning & High Voltage injuries Casualty evacuation planning These are in addition to the normal Emergency First Aid criteria. Who Should Attend? This course is ideal for those who work or intend to work in a forestry, agricultural or remote environment, such as tree surgeons and farmers. Emergency First Aid Course Content Health & Safety First Aid Kit Resuscitation/CPR AED Familiarisation Recovery Position Choking - Adult, Child, Baby Burns & Scalds Poisoning including Anaphylaxis Epilepsy Shock Bleeding including Catastrophic bleeding Asthma Head Injuries Breaks, Sprains & Strains Specific Conditions (Heart Attack) Assessment / Certification Independent qualified assessors carry out the assessments. Each delegate that passes will receive a Certificate valid for Three years. Please note those holding a valid Certificate, training can take place up to 3 months in advance of the expiry date & the new Certificate will be dated from the expiry date of the old Certificate.