375 Courses in London

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access

Autocad and Sketchup face to face training customised and bespoke.

Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data and visualize data and insights using advanced visualizations in charts and dashboards in Excel.

Students will learn and develop skills needed for a range of financial processes, including maintaining cost accounting records, advanced bookkeeping and the preparation of financial reports and returns.  Course Overview This qualification covers a range of essential and higher-level accounting techniques and disciplines. Students will learn and develop skills needed for a range of financial processes, including maintaining cost accounting records, advanced bookkeeping and the preparation of financial reports and returns. Study the Level 3 Diploma to learn higher accounting techniques and disciplines and qualify for AAT bookkeeping membership (AATQB). The jobs it can lead to: • Accounts assistant • Accounts payable clerk • Audit trainee • Credit controller • Payroll administrator/supervisor • Practice bookkeeper • Finance assistant • Tax assistant • Accounts payable and expenses supervisor Entry requirements: Students can start with any qualification depending on existing skills and experience. For the best chance of success we recommend that students begin their studies with a good standard of English and maths. Course Content: Business Awareness: This unit provides students with an understanding of the business, its environment and the influences that this has on an organisation’s structure, the role of its accounting function and its performance. Students will examine the purpose and types for businesses that exist and the rights and responsibilities of the key stakeholders, as well as gain an understanding of the importance of professional ethics and ethical management within the finance function. Learning outcomes: • Understand business types, structure and governance and the legal framework in which they operate. • Understand the impact of the external and internal environments on business, their performance and decisions. • Understand how businesses and accounts comply with principles of professional ethics. • Understand the impact of new technologies in accounting and the risks associated with data security. • Communicate information to stakeholders. Financial Accounting: Preparing Financial Statements: This unit provides students with the skills required to produce statements of profit or loss and statements for financial position for sole traders and partnerships, using a trial balance. Students will gain the double-entry bookkeeping skills needed to record financial transactions into an organisation’s accounts using a manual bookkeeping system. Learning outcomes: • Understand the accounting principles underlaying final accounts preparation. • Understand the principles of advanced double-entry bookkeeping. • Implement procedures for the acquisition and disposal of non-current assets. • Prepare and record depreciation calculations. • Record period end adjustments. • Produce and extend the trial balance. • Produce financial statements for sole traders and partnerships. • Interpret financial statements using profitability ratios. • Prepare accounting records from incomplete information. Management Accounting Techniques: This unit provides students with the knowledge and skills needed to understand the role of management accounting in an organisation, and how organisations use such information to aid decision making. Students will learn the principles that underpin management accounting methodology and techniques, how costs are handled in organisations and why organisations treat costs in different ways. Learning outcomes: • Understand the purpose and use of management accounting within organisations. • Use techniques required for dealing with costs. • Attribute costs according to organisational requirements. • Investigate deviations from budgets. • Use spreadsheet techniques to provide management accounting information. • Use management accounting techniques to support short-term decision making. • Understand principles of cash management. Tax Processes for Businesses: This unit explores tax processes that influence the daily operations of businesses and is designed to develop students’ skills in understanding, preparing and submitting Value Added Tax (VAT) returns to HM Revenue and Customs (HMRC). The unit provides students with the knowledge and skills that are needed to keep businesses, employers and clients compliant with laws and practices that apply to VAT and payroll. Learning outcomes: • Understand legislation requirements relating to VAT. • Calculate VAT. • Review and verify VAT returns. • Understand principles of payroll. • Report information within the organisation. DURATION 250-300 Hours WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

Enhance your knowledge of natural gas and LNG sales agreements with EnergyEdge course. Enroll now to gain valuable industry knowledge and skills.

Being safe at the workplace should be a priority for any business. Come to Knight Training to train with us and start working safe with our IOSH Managing and Working Safely Course!

Take your knowledge to the next level with EnergyEdge course on Layer of Protection Analysis (LOPA). Enroll now to advance your career.

Your puppy training journey can begin before you even bring your puppy home. By ensuring you have the basics covered such as puppy crate training and puppy toilet training, you can start your journey off with your puppy in the best possible way.    Focusing on you and your puppy outside of a group class setting, in a 1-2-1 puppy training session, can be really useful for you and your puppy. We can focus on specific goals you may have, from teaching a puppy a new game such as retrievals or flirt pole, to training for specific situations such good puppy manners when guests come to our house. 1-2-1 puppy training sessions are typically 1 hour. Training can be carried out in your home/ garden or out at an agreed location, such as a local park, if suitable for you and your puppy goals. I am also happy for you to travel to me to train your dog at an agreed location. 1-2-1 puppy training prices: 1 hour = £60, including follow up report. Pre-arrival session= £30 (half hour) (Longer sessions can be arranged by agreement, priced on an individual basis.) Above prices are based on Dog Training being in and around Bishop's Stortford (IE Sawbridgeworth, Much Hadham, Little Hallingbury, Harlow, Puckeridge, Standon, Manudon), I am happy to travel, subject to agreed travel costs.

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson