7418 Systems courses in London delivered Online

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type  

Duration 4 Days 24 CPD hours This course is intended for Security engineers Security administrators Security architects Operations engineers Network engineers Network administrators Network or security technicians Network managers System designers Cisco integrators and partners Overview After taking this course, you should be able to: Describe and administer the Cisco Email Security Appliance (ESA) Control sender and recipient domains Control spam with Talos SenderBase and anti-spam Use anti-virus and outbreak filters Use mail policies Use content filters Use message filters to enforce email policies Prevent data loss Perform LDAP queries Authenticate Simple Mail Transfer Protocol (SMTP) sessions Authenticate email Encrypt email Use system quarantines and delivery methods Perform centralized management using clusters Test and troubleshoot This course shows you how to deploy and use Cisco© Email Security Appliance to establish protection for your email systems against phishing, business email compromise, and ransomware, and to help streamline email security policy management. This hands-on course provides you with the knowledge and skills to implement, troubleshoot, and administer Cisco Email Security Appliance, including key capabilities such as advanced malware protection, spam blocking, anti-virus protection, outbreak filtering, encryption, quarantines, and data loss prevention. This course helps you prepare to take the exam, Securing Email with Cisco Email Security Appliance (300-720 SESA). Describing the Cisco Email Security Appliance Cisco Email Security Appliance Overview Technology Use Case Cisco Email Security Appliance Data Sheet SMTP Overview Email Pipeline Overview Installation Scenarios Initial Cisco Email Security Appliance Configuration Centralizing Services on a Cisco Administering the Cisco Email Security Appliance Distributing Administrative Tasks System Administration Managing and Monitoring Using the Command Line Interface (CLI) Other Tasks in the GUI Advanced Network Configuration Using Email Security Monitor Tracking Messages Logging Controlling Sender and Recipient Domains Public and Private Listeners Configuring the Gateway to Receive Email Host Access Table Overview Recipient Access Table Overview Configuring Routing and Delivery Features Controlling Spam with Talos SenderBase and Anti-Spam SenderBase Overview Anti-Spam Managing Graymail Protecting Against Malicious or Undesirable URLs File Reputation Filtering and File Analysis Bounce Verification Using Anti-Virus and Outbreak Filters Anti-Virus Scanning Overview Sophos Anti-Virus Filtering McAfee Anti-Virus Filtering Configuring the Appliance to Scan for Viruses Outbreak Filters How the Outbreak Filters Feature Works Managing Outbreak Filters Using Mail Policies Email Security Manager Overview Mail Policies Overview Handling Incoming and Outgoing Messages Differently Matching Users to a Mail Policy Message Splintering Configuring Mail Policies Using Content Filters Content Filters Overview Content Filter Conditions Content Filter Actions Filter Messages Based on Content Text Resources Overview Using and Testing the Content Dictionaries Filter Rules Understanding Text Resources Text Resource Management Using Text Resources Using Message Filters to Enforce Email Policies Message Filters Overview Components of a Message Filter Message Filter Processing Message Filter Rules Message Filter Actions Attachment Scanning Examples of Attachment Scanning Message Filters Using the CLI to Manage Message Filters Message Filter Examples Configuring Scan Behavior Preventing Data Loss Overview of the Data Loss Prevention (DLP) Scanning Process Setting Up Data Loss Prevention Policies for Data Loss Prevention Message Actions Updating the DLP Engine and Content Matching Classifiers Using LDAP Overview of LDAP Working with LDAP Using LDAP Queries Authenticating End-Users of the Spam Quarantine Configuring External LDAP Authentication for Users Testing Servers and Queries Using LDAP for Directory Harvest Attack Prevention Spam Quarantine Alias Consolidation Queries Validating Recipients Using an SMTP Server SMTP Session Authentication Configuring AsyncOS for SMTP Authentication Authenticating SMTP Sessions Using Client Certificates Checking the Validity of a Client Certificate Authenticating User Using LDAP Directory Authenticating SMTP Connection Over Transport Layer Security (TLS) Using a Client Certificate Establishing a TLS Connection from the Appliance Updating a List of Revoked Certificates Email Authentication Email Authentication Overview Configuring DomainKeys and DomainKeys Identified Mail (DKIM) Signing Verifying Incoming Messages Using DKIM Overview of Sender Policy Framework (SPF) and SIDF Veri?cation Domain-based Message Authentication Reporting and Conformance (DMARC) Verification Forged Email Detection Email Encryption Overview of Cisco Email Encryption Encrypting Messages Determining Which Messages to Encrypt Inserting Encryption Headers into Messages Encrypting Communication with Other Message Transfer Agents (MTAs) Working with Certificates Managing Lists of Certificate Authorities Enabling TLS on a Listener?s Host Access Table (HAT) Enabling TLS and Certi?cate Verification on Delivery Secure/Multipurpose Internet Mail Extensions (S/MIME) Security Services Using System Quarantines and Delivery Methods Describing Quarantines Spam Quarantine Setting Up the Centralized Spam Quarantine Using Safelists and Blocklists to Control Email Delivery Based on Sender Configuring Spam Management Features for End Users Managing Messages in the Spam Quarantine Policy, Virus, and Outbreak Quarantines Managing Policy, Virus, and Outbreak Quarantines Working with Messages in Policy, Virus, or Outbreak Quarantines Delivery Methods Centralized Management Using Clusters Overview of Centralized Management Using Clusters Cluster Organization Creating and Joining a Cluster Managing Clusters Cluster Communication Loading a Configuration in Clustered Appliances Best Practices Testing and Troubleshooting Debugging Mail Flow Using Test Messages: Trace Using the Listener to Test the Appliance Troubleshooting the Network Troubleshooting the Listener Troubleshooting Email Delivery Troubleshooting Performance Web Interface Appearance and Rendering Issues Responding to Alerts Troubleshooting Hardware Issues Working with Technical Support References Model Specifications for Large Enterprises Model Specifications for Midsize Enterprises and Small-to-Midsize Enterprises or Branch O?ces Cisco Email Security Appliance Model Specifications for Virtual Appliances

Duration 5 Days 30 CPD hours This course is intended for This course is intended for those who provide site collection and site administration and are power users or IT professionals who are tasked with supporting or working within the SharePoint 2016 environment on premise and/or in Office 365. Overview After completing this course, students will be able to: - Design and implement a company portal structure using SharePoint 2016 objects including sites, libraries, lists and pages - Explain the role of security and permissions throughout SharePoint 2016 - Implement guidelines for consistency in building a company portal to aid in the day-to-day administration of content in SharePoint 2016 - Enhance the design and content of a company portal using SharePoint 2016 pages and web parts - Explain the importance of governance for the planning and managing future growth of the - SharePoint 2016 implementation - Identify options to integrate data from other systems such as Microsoft Office, as well as preserve existing data - Explain the role of social networking in SharePoint 2016 and its impact on collaboration This course is intended for power users and IT professionals who are tasked with working within the SharePoint 2016 environment and conduct site collection and site administration. Getting Started with SharePoint 2016 Exploring SharePoint 2016 Site Collection and Site Administrator Roles Defining SharePoint Terminology Navigating a SharePoint Site Interacting with the Ribbon Creating and Editing Basic Content What is Metadata? Versions of SharePoint Standard Enterprise O365 Building a Site Collection with Apps The Structure of SharePoint Creating a Site What does a site template come with? Defining SharePoint Apps Customizing Lists and Libraries Creating/Managing Lists and Libraries through SharePoint Designer Explaining Views on Lists and Libraries Creating Views in Lists and Libraries Modifying Navigation Turning Site Features On/Off Reorganizing a Site using Site Content and Structure feature Lab 1: Creating a Structured Company Portal Lab 2: Creating a List Using SharePoint Designer (Optional) Creating Consistency across Sites Defining Site Columns Defining Content Types Implementing a Taxonomy Using Templates to Promote Consistency Lab 1: Creating Site Columns and Content Types Lab 2: Implementing a Taxonomy Lab 3: Configuring the Content Organizer SharePoint Permissions Explaining Permissions and Security in SharePoint Creating SharePoint Groups Managing Permissions within SharePoint Sharing versus Traditional Security Sharing as different permission levels Lab 1: Managing Permissions in SharePoint Working with Pages and Web Parts Changing the Appearance of the Portal Editing a Page wiki web part Working with Web Parts and App Parts App Parts Content Search Web Part Relevant Documents Content query Table of Contents Pictures Web Part Connections Filter web parts Web parts with Targeting Audience Lab 1: Adding and Configuring Web Parts Lab 2: Connecting Web Parts Lab 3: Applying Themes to Your Company Portal Document and Records Management Basic Content Approval Versioning Check In/Out Holds Retention Policy Document ID Content Organizer Compliance Policy Center Site Template EDiscovery Records Center Lab 1: Working with Advanced Document Management Features Lab 2: Leveraging Records Management to Preserve Data Workflow Alerts Out of the Box Workflow Activating Workflow Features Approval Workflow Creating a Workflow in SharePoint Designer Lab 1: Creating an Approval Workflow from SharePoint Lab 2: Creating a Custom Workflow in SharePoint Designer (Optional) Office Integration Outlook Calendar Contacts Excel Word PowerPoint OneDrive for Business OneNote Access Lab 1: Importing and Exporting Excel Data with SharePoint Lab 2: Linking Outlook and SharePoint Creating Publishing Sites Why use a publishing site? Publishing Pages Enabling Web Content Management Managing the Structure of Web Content Navigating a Site Using Managed Metadata Lab 1: Creating a Rich Publishing Sit Lab 2: Configuring a Publishing Approval Process Lab 3: Implementing a Managed Navigation Site Bridging the Social Gap My Sites Configuring Social Features in SharePoint Posts, Tags and Mentions Creating a Community Site Lab 1: Designing a Social Experience in SharePoint 2016 Lab 2: Creating a Community Site Finding Information Using Search Exploring the Search Features in SharePoint Configuring Search Settings Search Analytics Search Visibility Lab 1: Configuring an Advanced Search Center Planning a Company Portal Using SharePoint Defining SharePoint Governance Working with Information Architecture Implementing Site Hierarchies Discussing the Execution of Governance Site Collection Administrator Settings Exploring Settings for Site Collection Administrators Exploring Settings for Site Administrators Site Closure Policies Additional course details: Nexus Humans 55234 SharePoint 2016 Site Collections and Site Owner Administration training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55234 SharePoint 2016 Site Collections and Site Owner Administration course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

This Electrical Safety Management Training provides job-ready skills, expert insights, and a certification that helps you establish a safe and compliant working environment. Enrol now and take control of electrical safety in your workplace! 🚀

Hydrogen sulphide (H₂S) might not ring alarm bells at first, but this gas is no joke. Known for its pungent “rotten egg” smell, H₂S is both toxic and flammable—making awareness of it absolutely vital in industries like oil and gas, wastewater, mining, and chemical production. This course is tailored for individuals working in or around environments where hydrogen sulphide may be present, offering the essential safety knowledge to recognise hazards, respond swiftly, and reduce risks effectively. You’ll gain a solid understanding of how hydrogen sulphide behaves, where it’s typically found, and what to do when exposure becomes a threat. From warning systems to emergency actions, every key topic is covered in a clear, accessible way—no fluff, just the facts you need. Whether you're new to this or brushing up your knowledge, this course provides the confidence to navigate H₂S environments with the caution and awareness they demand. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01 : Introduction to H2S Awareness Module 02 : Hazards Associated with H2S Module 03 : Detection and Monitoring of H2S Module 04 : Safety Measures Module 05 : Emergency Response Learning Outcomes: Identify the characteristics of H2S and its risks. Recognize potential hazards associated with H2S exposure. Demonstrate proficiency in H2S detection and monitoring. Implement safety measures to prevent H2S incidents. Respond effectively to H2S-related emergencies. Safeguard yourself and others in hazardous environments. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Oil and gas industry workers Chemical plant employees Construction site personnel Environmental safety professionals Emergency responders Anyone working in H2S-prone areas Entry-level safety personnel Health and safety enthusiasts Career path Health and Safety Officer Environmental Compliance Specialist Emergency Response Coordinator Process Operator Chemical Plant Operator Industrial Safety Consultant Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

If chasing payments without sounding like a debt collector is your idea of a good time, this Credit Controller Training Course might just be your professional soulmate. Designed for those looking to refine their approach to credit control, this online course takes a structured look at the key responsibilities of credit controllers—from assessing credit risk to managing overdue accounts and improving cash flow. It’s all delivered in a format that fits neatly into your schedule, with no awkward role-plays or fluorescent-lit classrooms in sight. With a sharp focus on clarity, strategy, and communication, the course offers valuable insights into setting credit limits, working with accounting systems, and ensuring debt recovery remains firm but fair. You’ll gain confidence in crafting polite but persuasive correspondence, understanding credit policies, and handling disputes without raising blood pressure—yours or theirs. Whether you're new to credit control or want to polish up your existing approach, this course offers the knowledge you need, minus the fluff and buzzwords. Key Benefits Accredited by CPD Instant e-certificate Fully online, interactive course Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Curriculum Module 01: Introduction to Financial Management Module 02: Fundamentals of Budgeting Module 03: The Balance Sheet Module 04: The Income Statement Module 05: The Cash Flow Statement Module 06: Statement of Stockholders' Equity Module 07: Analysing and Interpreting Financial Statements Module 08: Inter-Relationship Between all the Financial Statements Module 09: International Aspects of Financial Management Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Certificate Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Credit Controller training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Credit Controller training. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included

Course Overview The Tax Accounting course provides a comprehensive introduction to the UK tax system, covering key areas such as income tax, corporation tax, VAT, and inheritance tax. Designed to equip learners with up-to-date knowledge of tax regulations and processes, this course offers valuable insights into tax administration, individual and corporate responsibilities, and submission of tax returns. Learners will develop a solid understanding of fundamental and advanced tax principles, payroll, and financial analysis. By the end of the course, participants will be able to navigate the complexities of taxation confidently and apply their knowledge in professional contexts. Whether aiming to launch a career in tax accounting or broaden existing financial expertise, this course supports learners in achieving their professional development goals and gaining skills that are in high demand across multiple sectors in the UK. Course Description This Tax Accounting course delves into the structure and operation of the UK tax system, offering detailed modules on personal and corporate taxation, VAT, capital gains, and national insurance contributions. Learners will explore both basic and advanced income tax calculations, understand payroll systems, and gain familiarity with self-assessment and double-entry accounting methods. The curriculum is structured to promote a clear and methodical understanding of tax reporting, compliance obligations, and financial analysis. With a strong emphasis on technical knowledge and regulatory frameworks, this course supports learners in building the analytical and accounting skills essential for a successful career in finance and taxation. Throughout the course, learners will benefit from clear explanations, real-world examples, and guided study that align with industry standards. By completion, participants will be well-prepared to pursue opportunities in accounting firms, corporate finance departments, and tax advisory roles. Course Modules Module 01: Tax System and Administration in the UK Module 02: Tax on Individuals Module 03: National Insurance Module 04: How to Submit a Self-Assessment Tax Return Module 05: Fundamentals of Income Tax Module 06: Advanced Income Tax Module 07: Payee, Payroll and Wages Module 08: Capital Gain Tax Module 09: Value Added Tax Module 10: Import and Export Module 11: Corporation Tax Module 12: Inheritance Tax Module 13: Double Entry Accounting Module 14: Management Accounting and Financial Analysis Module 15: Career as a Tax Accountant in the UK (See full curriculum) Who is this course for? Individuals seeking to develop a strong foundation in tax accounting. Professionals aiming to enhance their accounting and financial expertise. Beginners with an interest in taxation, finance, or business management. Entrepreneurs wanting to understand tax obligations for businesses. Students planning a career in accounting, auditing, or tax consultancy. Career Path Tax Accountant Payroll Administrator VAT Specialist Income Tax Advisor Financial Analyst Management Accountant Corporate Tax Consultant Self-Assessment Practitioner Tax Compliance Officer Accounting Technician

Course Overview The Restaurant Management Level 3 course offers a comprehensive exploration of the skills and strategies required to successfully manage a restaurant. Covering key areas such as menu planning, staff recruitment, financial management, and customer relations, this course prepares learners to navigate the dynamic restaurant industry with confidence. Whether aspiring to open a new venue or improve existing operations, learners will gain valuable insights into creating efficient layouts, maintaining safety standards, managing inventory, and implementing effective marketing strategies. The course blends theoretical knowledge with real-world industry standards, equipping participants to handle the complexities of restaurant management. By completing this course, learners will be able to develop structured plans for running a successful restaurant, cultivate a strong team culture, and deliver exceptional customer experiences. This qualification provides a valuable stepping stone towards achieving career goals in the vibrant hospitality sector. Course Description The Restaurant Management Level 3 course delves into the essential elements that underpin a thriving restaurant business. Topics covered include restaurant selection and set-up, legal and health regulations, drinks and food management, technology integration, financial planning, staff training, and customer engagement. Learners will explore how to create compelling menus, implement inventory systems, and foster teamwork within a restaurant environment. Emphasis is placed on strategic decision-making, operational efficiency, and building a reputable brand image. The course is structured to support learners in developing managerial skills, with a strong focus on leadership, communication, and customer satisfaction. Designed for those seeking a detailed understanding of the restaurant business, this programme empowers learners with the knowledge needed to excel in both operational and supervisory roles. Upon completion, learners will possess the expertise to contribute significantly to any restaurant’s success or embark on entrepreneurial ventures in the food and hospitality industry. Course Modules Module 01: An Overview of the Restaurant Industry Module 02: Choosing Your Restaurant Module 03: Restaurant Layout Management and Legal Requirements Module 04: Menu Planning Module 05: Drinks Management Module 06: Purchasing, Receiving, Inventory, and Storage Module 07: Financing Your Business Module 08: Finding, Recruiting, and Training Employees Module 09: Running a Safe and Clean Restaurant Module 10: Handling Service Using Technology Module 11: Teamwork and Daily Routine of a Restaurant Module 12: Customer Relations and Marketing Policy (See full curriculum) Who is this course for? Individuals seeking to pursue a career in restaurant management. Professionals aiming to enhance their leadership skills within the hospitality industry. Beginners with an interest in understanding restaurant operations. Entrepreneurs planning to open or manage a restaurant business. Hospitality staff looking to transition into management roles. Career Path Restaurant Manager Assistant Restaurant Manager Hospitality Supervisor Food and Beverage Manager Front of House Manager Catering Manager Restaurant Owner or Entrepreneur Operations Manager in Hospitality Businesses

Course Overview: The "Technical Analysis Masterclass for Trading & Investing" is a comprehensive course designed to equip learners with the essential skills to make informed trading and investment decisions using technical analysis. Covering a wide range of topics, from candlestick patterns to advanced trading strategies, this course empowers learners to interpret market data and identify trends effectively. By the end of the course, participants will have a solid understanding of how to analyse price movements, recognise key patterns, and apply strategies to improve their decision-making. With an emphasis on real-world applicability, learners will be prepared to confidently navigate the markets and pursue trading and investment opportunities. Course Description: This in-depth course dives into the core concepts and techniques used in technical analysis, ideal for those looking to sharpen their trading and investment skills. Learners will explore topics such as candlestick patterns, chart patterns, and volume analysis to understand market behaviours. Key focus areas also include tape reading strategies and technical trading systems, which are critical for timing market entries and exits. The course provides a structured learning experience, guiding participants through different methods of interpreting market data and applying analytical strategies to both short- and long-term trading. By mastering these techniques, learners will develop the skills to assess market conditions, identify profitable trends, and execute informed investment decisions with confidence. Course Modules: Module 01: Introduction to Technical Analysis Overview of technical analysis and its importance in trading and investing Key concepts and tools used in technical analysis Market data types and interpretation Module 02: Candlestick Patterns and Analysis Introduction to candlestick charting Key candlestick patterns and their significance Identifying trends and reversals Module 03: Trade and Investment Chart Patterns Common chart patterns: head and shoulders, triangles, and more How to interpret chart patterns for trade signals Setting up price targets using chart patterns Module 04: Volume Analysis Understanding volume and its role in market analysis Volume indicators and their applications Volume-based trading strategies Module 05: Tape Reading Strategies Introduction to tape reading and its historical significance Techniques for interpreting market order flow Understanding supply and demand through tape reading Module 06: Technical Trading Strategies Popular technical analysis strategies for trading Risk management and strategy development Implementing strategies for both short and long positions Module 07: Trading Platform and Practice Overview of different trading platforms and their features Using charting tools and indicators in platforms Best practices for executing trades and managing portfolios (See full curriculum) Who is this course for? Individuals seeking to enhance their trading and investment knowledge. Professionals aiming to refine their analytical skills for better decision-making. Beginners with an interest in financial markets and technical analysis. Investors wanting to better understand charting techniques and market trends. Career Path: Stock Trader Investment Analyst Financial Consultant Portfolio Manager Market Research Analyst Risk Manager

Learn how to create fully relational databases and how to input, extract and report on data. Course overview Duration: 2 days (13 hours) Our Access Database Design and reporting course looks at the key elements to building fully relational databases and entering and extracting information from them. This course is designed for new users who need to build relational database systems. Objectives  By the end of the course you will be able to: Create a new database Create data tables Set field validation and properties Enter data and manage data Create forms Use queries to extract data Create parameter queries Create calculations in queries Build relational databases Use sub datasheets Build multi table queries Use advanced form and report design techniques Content Creating a database Creating a new database Database elements Creating a data table Setting field properties Using input masks Using input masks Validation rules Default values Setting a primary key Creating lookup fields Data entry Adding data Deleting data Quick keys for data entry Working with data Sorting data Filtering data Finding information Navigation Creating data form Creating quick forms The form wizard Amending forms Formatting Setting the tab order Entering data using forms Creating queries Creating a query Setting criteria Using the expression builder Creating parameter queries Using wildcards Using more than one parameter Using calculations in queries Adding a totals row Formatting results Adding calculations Printing and reporting Printing tables and queries Creating reports Building and amending reports Adding headers and footers Working with relational databases Relational database principles Importing data from other sources Linking information between tables One-to-one and one-to-many links Defining referential integrity Amending links Deleting links Sub datasheets Viewing a subdatasheet Removing a subdatasheet Connecting a subdatasheet Multiple table queries Deciding which tables to use Adding tables to the query Creating links between tables Setting join properties Advanced form design Field properties Creating lookup fields Adding calculated fields Applying conditional formatting Advanced report design Field properties Report properties Alternate colour bandings Concatenating fields Adding calculated fields Sorting and grouping Grouping settings Adding headers and footers Adding dates, times, page numbers