786 Courses in London

MS PowerPoint is really easy, but in this PowerPoint Training Courses, we cover most aspects in a fast-paced day, and attend the to more tricky aspects. This course is one-to-one to attend to specific aspects per delegate. Group training could be organised on request.

Who would find this course useful? This is useful if you have some coding skills already. This course is fast-paced, not quite at the basics level.

MS Word Advanced Course summary This MS Word Advanced Course, Private 1-to-1, covers advanced MS Word tools. Ideal for delegates who create long documents, manuals and manuscripts. MS Word styles and formats, help making formatting documents consistent and easy to maintain. Who Should Attend the MS Word Advanced Course: Delegates should have a working knowledge of the concepts covered in the Introduction and Intermediate courses. What is MS Word: Microsoft Word, or simply Word, is a word processing software package developed by Microsoft. Is is bundled within the Microsoft Office suite. It covers simple text editor capability through to desktop publishing features, suitable to creates professional documents for any purpose MS Word Advanced Course description Session 1:Managing and Reviewing Documents Using Comments Tracking changes, version control Session 2: Styles Creating an Outline Style Principles, Style Themes, Creating, Modifying, Using Styles, Styles menus and Styles Group on the Home Ribbon. Session 3: Sections Formatting, page layouts, page numbering, headers and footers with sections Session 4:MS Word Tables and Text Boxes Inserting, Editing, Formatting and positioning MS Word Tables and Text Boxes Session 5: MS Word Reference Tools Table of Contents References within a Document Bibliography Index Tabls Reference Tables References to Other Documents Session 6: MS Word Templates Creating, saving and using custom templates Session 7: Templates and Building Blocks Using Building Blocks and Quick Parts, Fill-In Merge for Templates Session 8: Graphics Creating Graphics, Equations and Charts, Using WordArt, Using SmartArt Session 9: MS Word Time Saving Tools MS Word Time Saving Tools Using Language Tools Inserting Pre-Defined Text Using the Navigation Pane What is included in the MS Word Advanced Courses: MS Word Advanced Course Certificate on completion MS Word Advanced Course notes Practical MS Word Advanced Course exercises, MS Word Advanced Course Homework / MS Word Advanced Course Revision work After the course, 1 free session for questions online MS Word Advanced Course via Gotomeeting.com. Max group size, online and in classroom, on this MS Word Advanced Course is 4.

Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. A comprehensive training course with up to date material to practice at home and during your class. You will also be provided a step by step manual of all the tricks you can do using Excel spreadsheets to gain better management reporting and budgeting skills. It is a fundamental programme for professional Accountants. Excel spread sheets are the most powerful tool, extensively used for reporting and analysis. Having advanced skills on excel can excel your career and help you to stand ahead of the competitive job market. Advanced skills on excel is a must for any potential professional accountants. You will receive an attendance certificate once you complete the course successfully. Excel Course Content Creating worksheets, formatting text Simple and complex formulas Handling rows and columns Autocomplete, using styles, headers and footers, Average, max and min functions and using charts. Use of IF Formula Summing Techniques Cell References Formula Linking Sumifs Tables and Bordering Look up References (Vlookup, Hlookup,etc) Data Validation Conditional Formatting Date & Time Formulas Charts & Graphs Protection & Security Creating Pivot Table Pivot Table Analysis

The Quintessential Customer Experience (QCx) Forum is a ‘peer advisory’ community of communications and Cx professionals whose primary objectives are: To help members keep abreast of the latest CX developments To share best practice across different industry sectors. To provide individual support, advice and guidance for members Membership includes quarterly meetings, team coaching, 1:1 mentoring and online resource. Benefits The QCx Forum benefits both the CX professional and the organisations they work for. Employer Benefits include: Benchmarking performance against organisations in different sectors Keeping up to date with latest trends Maintaining competitive advantage through exceptional customer experience. Individual Member Benefits include: Inspiration for new ideas and approaches Guidance and advice to implement new strategies Support and reassurance from peers What’s included: The current membership package* includes: Forum Meetings Quarterly ‘Mastermind Group’ gatherings in person at a London venue. Each meeting features a specialist speaker providing insights about new trends and best practice. Team Coaching Attendees have the opportunity to share and solve key CX-related challenges they face.  1:1 Mentoring Support Members have access expert mentors to develop new strategies, gain valuable new knowledge and enhance their professional growth. Online Resource Members have access to a dedicated portal providing access to useful templates, tools and articles. * The first annual conference is planned for 2024 Membership Fees and options Three options are available: Essentials - quarterly Forum meetings, team coaching and online resources. £1,400.00 (ex VAT) pa Standard annual membership - includes quarterly forum meetings, team coaching, 4 x 1:1 mentoring sessions and online resource.  £3,600.00 (ex VAT) per annum Platinum membership - over and above the standard membership, includes an intensive quarterly programme of bi-weekly coaching sessions  £4,700.00 (ex VAT) per annum Credentials The Chair of the QCx Forum is Quentin Crowe MA, FCIM. His CX consultancy journey began in 2001 working with clients in the fitness and education sectors. Using an adaptation of the SERVQUAL methodology, he and his team have worked with clients in the charity, quality assurance, construction and cutout sectors (including ISG). Quentin also mentors entrepreneurs, senior marketers and corporate executives. He also chairs a number of ‘mastermind’ groups.  Brands represented include Shell, Asahi, Reuters and St James’s Place Welsh Management.

Payroll courses in London | Online Courses | Distance Learning Course Overview: Broken down into practical modules this course is a very popular and well-received introduction to moving from manual payroll to computerised payroll, and it incorporates all the new government requirements for RTI reporting Payroll is a vital role within any organisation. A career in payroll means specialising in a niche field with excellent progression opportunities. What support is available? Free high-quality course materials Tutorial support Highly equipped IT lab Student Discount with NUS card Exam fees and exam booking service Personalised individual study plan Specialist Career Management service State of the Art Virtual Learning Campus Free Sage Payroll Software Duration 6 Weeks Study Options Classroom Based - Osborne Training offers Daytime and Weekend sessions for Payroll Training Course from London campus. Online Live - Osborne Training offers Live Online sessions for Sage Payroll Training Classes through the Virtual Learning Campus. Distance Learning - Self Study with Study Material and access to Online study Material through Virtual Learning Campus. Benefits for Trainees Sage Payroll Qualifications open new doors to exciting careers, as well as extending payroll skills if you are currently employed. State of the Art Virtual Learning Campus Start your own payroll bureau Work in small businesses A payroll career can lead to great things Update your knowledge of Sage payroll Improve your employability prospects A career path into payroll Ideal Continuing Professional Development course Gain a qualification to boost your CV Option to gain IAB accredited qualification Start your training immediately without having to wait for the new term to begin Certification You will receive a certificate from Osborne Training once you finish the course. You have an option to get an IAB Certificate subject to passing the IAB exam or Sage certified exam. Syllabus Advanced processing of the payroll for employees Preparation and use of period end HMRC forms and returns preparation of internal reports Maintaining accuracy, security and data integrity in performing payroll tasks. Deductions - Pension schemes and pension contributions Processing the payroll -complex income tax issues Processing Payroll Giving Scheme Processing Statutory Adoption Pay (SAP) Advanced Income tax implications for company pension schemes Student Loan repayments Processing Holiday Payments Processing Car Benefit on to the Payroll System Attachment of Earnings Orders & Deductions from Earnings Orders Leavers with complex issues Advanced processing of statutory additions and deductions Recovery of statutory additions payments - from HMRC Completing the processing of the payroll Complex Reports and payments due to HMRC Introduction to Auto-enrolment Cost Centre Analysis Advanced, routine and complex payroll tasks Calculation of complex gross pay

SSRS Report Builder Course Summary. Practical SSRS Report Builder course, to leavy you full conversant with queries, DML and DDL statements. Hands-on, Practical SSRS course. PCWorkshops SSRS Course Certificate. Max 4 people per course, we keep it personalised. Where is the SSRS Report Builder Course? Online: Instructor-led. Classroom: Request per email. SSRS Course Materials SSRS Coding Examples Manuals and Notes: In-depth reference materials Exercises: Practical exercises Payment Options → £600, Follow the booking link Arrange for installments Included with SSRS Report Builder Course: SSRS Course Certificate on completion. SSRS Course Manual. Practical SSRS Course exercises. SSRS Code Samples. After the course, 1 free session for questions. Max group size, online and in classroom, on this SSRS Course is 4. Course Topics SSRS Report Builder Course Topics SSRS Course topics: This course focus on producing reports using MS SQL SSRS Report Builder, to use the product features and tools related to data retrieval, visualisations and deployment. The Target Audience: end-users who will produce reports for their department or group using datasets. SSRS Course Topics Report Models: Data source views Creating a model Entities, attributes and roles Tables: Creating tables Interactive sorting Floating headers Grouping: Inserting groups Group headers/footers Displaying group totals Expanding and collapsing Expressions: The expression builder The Report Items collection Built-in fields Conditional formatting expressions Page headers and footers Page names and numbers Exporting reports: The various report formats Using RenderFormat. Parameters: Creating parameters Filtering using parameters Drop list parameters Coping with empty tables Matrices: Row and column groups Sorting and filtering matrices Creating subtotals Charts: Creating charts The parts of a chart Formatting charts Basic reports: Text boxes and images Selecting report items Formatting parts of a report Miniature charts Creating sparklines Creating data bars Graphical indicators Creating and customising indicators Linear and radial gauges Lists: Page-per-record lists Dashboard lists Other list ideas Subreports: Creating a child report Creating the main report Linking the two reports Report parts: Publishing report parts The report part gallery Updating report parts Book the SSRS Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

SSRS Report Builder Course Summary. Practical SSRS Report Builder course, to leavy you full conversant with queries, DML and DDL statements. Hands-on, Practical SSRS course. PCWorkshops SSRS Course Certificate. Max 4 people per course, we keep it personalised. Where is the SSRS Report Builder Course? Online: Instructor-led. Classroom: Request per email. SSRS Course Materials SSRS Coding Examples Manuals and Notes: In-depth reference materials Exercises: Practical exercises Payment Options → £600, Follow the booking link Arrange for installments Included with SSRS Report Builder Course: SSRS Course Certificate on completion. SSRS Course Manual. Practical SSRS Course exercises. SSRS Code Samples. After the course, 1 free session for questions. Max group size, online and in classroom, on this SSRS Course is 4. Course Topics SSRS Report Builder Course Topics SSRS Course topics: This course focus on producing reports using MS SQL SSRS Report Builder, to use the product features and tools related to data retrieval, visualisations and deployment. The Target Audience: end-users who will produce reports for their department or group using datasets. SSRS Course Topics Report Models: Data source views Creating a model Entities, attributes and roles Tables: Creating tables Interactive sorting Floating headers Grouping: Inserting groups Group headers/footers Displaying group totals Expanding and collapsing Expressions: The expression builder The Report Items collection Built-in fields Conditional formatting expressions Page headers and footers Page names and numbers Exporting reports: The various report formats Using RenderFormat. Parameters: Creating parameters Filtering using parameters Drop list parameters Coping with empty tables Matrices: Row and column groups Sorting and filtering matrices Creating subtotals Charts: Creating charts The parts of a chart Formatting charts Basic reports: Text boxes and images Selecting report items Formatting parts of a report Miniature charts Creating sparklines Creating data bars Graphical indicators Creating and customising indicators Linear and radial gauges Lists: Page-per-record lists Dashboard lists Other list ideas Subreports: Creating a child report Creating the main report Linking the two reports Report parts: Publishing report parts The report part gallery Updating report parts Book the SSRS Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

This workshop will provide participants with the insight and skills to be more effective business networkers, face-to-face and online. The approach taken is to build on the strengths people already have and their successes. It is easier to develop what you already have than to try and develop skills that do not come easily. Being yourself is the most effective tool for business networking and building relationships. This course will help those attending: Appreciate the importance of networking, and different forms of networking Understand the dynamics of communication that are specific to networking Become more confident and assured when 'working' a room Improve their influencing skills, especially with people who are experts and in positions of authority 'Sell' themselves and promote their company Identify and manage their profiles using online social networking sites Use effective follow-up to maintain active contacts and connections Select the correct networking groups, clubs and events Create their own personal network 1 The importance, and different types, of networking Personal objectives and introductions Test networking session Examples of the importance, purpose and format of various types of networking, and benefits you can expect 2 How to work a room - preparation and strategy Three things to know before you attend any event Non-verbal communication and art of rapport Breaking the ice - worked examples with practical demonstration 3 Communication dynamics in networking - the power of the listening networker Why it is better to listen than talk Effective questioning and active listening Creating a natural and engaging conversation, 1-2-1 and in a larger group 4 Assumptions when networking How to use the 'instant judgement' of others to your advantage What assumptions are you making? How to keep an open mind 5 Business networking etiquette Meeting and greeting at a business networking event - approaching complete strangers and introducing yourself Socialising: joining and leaving groups easily Making a good first impression in 30 seconds The use of status when networking 6 Making connections Asking for cards, contact details and referrals Gaining a follow-up commitment Some tips and tricks 7 Business networking rehearsals Practice sessions 8 Personal business networking online Overview of different types of networking sites - there is a lot more out there than just Facebook! Examples of creating an effective profile Using social networking effectively - case studies and application 'Advanced' applications - blogs, articles, twitter, feeds, etc. Online demonstration and examples 9 Building relationships - follow-up and follow-through Maintaining a good database Developing a contact strategy with different types and levels of contact How to analyse your contact base

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