• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

8967 Organisation courses

Diploma in Payroll (UK Payroll System, Payee, Tax, NI, Pension) at QLS Level 5

4.5(3)

By Studyhub UK

Stepping into the realm of payroll, our 'Diploma in Payroll (UK Payroll System, Payee, Tax, NI, Pension) at QLS Level 5' course offers an all-encompassing journey. Delve deep into the UK's meticulous payroll system, spanning from its foundational basics to the intricate legislation settings and the crucial year-end procedures. This course ensures you grasp every nook and cranny of the vast subjects like PAYE, tax, NI, and pension, setting you up for payroll success. Learning Outcomes Understand the intricacies of the UK Payroll System and its associated legislations. Confidently set up and manage both existing and new employee records. Master payroll processing, including understanding pay elements, payment updates, and reports. Gain proficiency in e-submissions, ensuring seamless digital communication. Efficiently handle unique payroll situations such as when an employee leaves or needs quick SSP. Why choose this Diploma in Payroll (UK Payroll System, Payee, Tax, NI, Pension) at QLS Level 5 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Diploma in Payroll (UK Payroll System, Payee, Tax, NI, Pension) at QLS Level 5 course for? Individuals aiming to embark on a career in payroll management. HR professionals seeking a deeper understanding of the payroll process. Business owners aiming to manage their company's payroll in-house. Accountants and finance professionals looking to expand their skill set. Students studying finance or HR, wanting a comprehensive grasp of the UK's payroll system. Career path Payroll Administrator: £18,000 - £25,000 Payroll Manager: £30,000 - £45,000 HR Officer: £22,000 - £30,000 Financial Controller: £40,000 - £60,000 Accountant: £25,000 - £50,000 Payroll Consultant: £35,000 - £55,000 Prerequisites This Diploma in Payroll (UK Payroll System, Payee, Tax, NI, Pension) at QLS Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Module 01: Payroll System in the UK Payroll System in the UK 01:05:00 Module 02: Payroll Basics Payroll Basics 00:10:00 Module 03: Company Settings Company Settings 00:08:00 Module 04: Legislation Settings Legislation Settings 00:07:00 Module 05: Pension Scheme Basics Pension Scheme Basics 00:06:00 Module 06: Pay Elements Pay Elements 00:14:00 Module 07: The Processing Date The Processing Date 00:07:00 Module 08: Adding Existing Employees Adding Existing Employees 00:08:00 Module 09: Adding New Employees Adding New Employees 00:12:00 Module 10: Payroll Processing Basics Payroll Processing Basics 00:11:00 Module 11: Entering Payments Entering Payments 00:12:00 Module 12: Pre-Update Reports Pre-Update Reports 00:09:00 Module 13: Updating Records Updating Records 00:09:00 Module 14: e-Submissions Basics e-Submissions Basics 00:09:00 Module 15: Process Payroll (November) Process Payroll (November) 00:16:00 Module 16: Employee Records and Reports Employee Records and Reports 00:13:00 Module 17: Editing Employee Records Editing Employee Records 00:07:00 Module 18: Process Payroll (December) Process Payroll (December) 00:12:00 Module 19: Resetting Payments Resetting Payments 00:05:00 Module 20: Quick SSP Quick SSP 00:09:00 Module 21: An Employee Leaves An Employee Leaves 00:13:00 Module 22: Final Payroll Run Final Payroll Run 00:07:00 Module 23: Reports and Historical Data Reports and Historical Data 00:08:00 Module 24: Year-End Procedures Year-End Procedures 00:09:00 Mock Exam Mock Exam - Diploma in Payroll (UK Payroll System, Payee, Tax, NI, Pension) at QLS Level 5 00:20:00 Final Exam Final Exam - Diploma in Payroll (UK Payroll System, Payee, Tax, NI, Pension) at QLS Level 5 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Diploma in Payroll (UK Payroll System, Payee, Tax, NI, Pension) at QLS Level 5
Delivered Online On Demand5 hours 26 minutes
£10.99

Advanced Diploma in Sage 50 Accounts at QLS Level 6

4.5(3)

By Studyhub UK

Overview In the digital age, mastering the intricacies of Sage 50 Accounts is paramount for businesses aiming to streamline their financial processes. The 'Advanced Diploma in Sage 50 Accounts at QLS Level 6' course is designed under the supervision of industry experts to guide learners through the multifaceted world of Sage 50 accounting. From setting up the system to intricate tasks like bank reconciliations and VAT returns, this course ensures that learners are well-equipped with sage 50 accounts essentials. Moreover, with a curriculum that delves deep into project creation and the preparation of accountant reports, learners are assured of comprehensive Sage 50 accounts help, making them proficient in managing business finances with precision. Learning Outcomes: Understand the foundational principles of Sage 50 Bookkeeper and its applications. Gain proficiency in setting up customers, suppliers, and creating projects within the Sage 50 environment. Master the processes of invoicing, credit notes, and bank payment transfers. Acquire skills in bank and petty cash reconciliations, including credit card account reconciliations. Develop expertise in advanced tasks such as VAT returns, year-end journals, and the preparation of accountant reports. Why buy this Advanced Diploma in Sage 50 Accounts at QLS Level 6? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Who is this Advanced Diploma in Sage 50 Accounts at QLS Level 6 course for? Individuals aiming to enhance their proficiency in Sage 50 accounting software. Business owners seeking to streamline their financial processes. Accountants and finance professionals looking to expand their skill set. Students of finance and accounting aiming to gain a competitive edge. Project managers desiring knowledge in financial project creation. Prerequisites This Advanced Diploma in Sage 50 Accounts at QLS Level 6 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Sage 50 Accounts Specialist: £30,000 - £40,000 Annually Financial Project Manager: £45,000 - £60,000 Annually Sage 50 Trainer: £35,000 - £50,000 Annually Financial Analyst with Sage 50 proficiency: £40,000 - £55,000 Annually Bookkeeper with Sage 50 expertise: £25,000 - £35,000 Annually Management Accountant with Sage 50 skills: £45,000 - £65,000 Annually Certification After studying the course materials of the Advanced Diploma in Sage 50 Accounts at QLS Level 6 you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £4.99. Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £125 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses.   Course Curriculum Sage 50 Accounts and Projects Creation Training Sage 50 Bookkeeper - Coursebook 00:00:00 Introduction and TASK 1 00:17:00 TASK 2 Setting up the System 00:23:00 TASK 3 a Setting up Customers and Suppliers 00:17:00 TASK 3 b Creating Projects 00:05:00 TASK 3 c Supplier Invoice and Credit Note 00:13:00 TASK 3 d Customer Invoice and Credit Note 00:11:00 TASK 4 Fixed Assets 00:08:00 TASK 5 a and b Bank Payment and Transfer 00:31:00 TASK 5 c and d Supplier and Customer Payments and DD STO 00:18:00 TASK 6 Petty Cash 00:11:00 TASK 7 a Bank Reconnciliation Current Account 00:17:00 TASK 7 b Bank Reconciliation Petty Cash 00:09:00 TASK 7 c Reconciliation of Credit Card Account 00:16:00 TASK 8 Aged Reports 00:14:00 TASK 9 a Payroll 00:07:00 TASK 9 b Payroll 00:10:00 TASK 10 Value Added Tax - Vat Return 00:12:00 Task 11 Entering opening balances on Sage 50 00:13:00 TASK 12 a Year end journals - Depre journal 00:05:00 TASK 12 b Prepayment and Deferred Income Journals 00:08:00 TASK 13 a Budget 00:05:00 TASK 13 b Intro to Cash flow and Sage Report Design 00:08:00 TASK 13 c Preparation of Accountants Report & correcting Errors (1) 00:10:00 Mock Exam Mock Exam - Sage 50 Accounts and Projects Creation Training 00:20:00 Final Exam Final Exam - Sage 50 Accounts and Projects Creation Training 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Advanced Diploma in Sage 50 Accounts at QLS Level 6
Delivered Online On Demand5 hours 28 minutes
£10.99

Business Finance Award - QLS Endorsed Course

5.0(2)

By Training Express

Take your understanding of business finance to new heights with this QLS-endorsed course, tailored to provide you with essential knowledge and insights into financial principles in a business context. Whether you're a budding entrepreneur or looking to expand your corporate skill set, this course offers an in-depth exploration of the financial concepts that form the backbone of any successful organisation. You'll delve into the fundamentals of financial management, from budgeting and cash flow management to understanding financial statements and ratios. With a clear, straightforward approach, this course ensures that complex finance terms and concepts are made accessible to all learners. It is ideal for those who wish to build their financial literacy without stepping into a classroom setting. Upon completion, you will gain the confidence to analyse financial reports and make informed decisions that support business growth and sustainability. The flexibility of this online course means that you can learn at your own pace, whenever it suits you. It’s a valuable resource for anyone keen to sharpen their financial acumen and move forward in their professional career with clarity and competence. Business Finance QLS Bundle Includes the following Courses Course 01: Award in Business Finance at QLS Level 2 Course 02: Financial Investigator Course 03: Investment Course 04: Tax Accounting Course 05: Budget & Forecast Key Features of Business Finance Eligibility for QLS endorsed certificate upon successful completion of the Business Finance course Free CPD Accredited Course Fully online, interactive Business Finance course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth Business Financetraining course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. Assessment At the end of the Business Finance course, we will provide assignment and quizzes. For each test, the pass mark will be set to 60%. Accreditation This Business Finance course is QLS - Quality Licence Scheme Endorsed and CPD Certified, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification CPD Certified: Once you've successfully completed your Business Finance course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). QLS Endorsed:After successfully completing the Business Finance course, learners will be able to order an endorsed certificate, titled: Award in Business Finance at QLS Level 2, as proof of their achievement. This certificate of achievement endorsed by the Quality Licence Scheme. CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Business Finance basics. Requirements No prior degree or experience is required to enrol in this Business Finance course. Career path This Business Finance Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

Business Finance Award - QLS Endorsed Course
Delivered Online On Demand1 hour
£150

Introduction to sales (In-House)

By The In House Training Company

When staff are new to sales it can seem daunting, especially when they have targets to meet. If the staff you need to promote your products and services get it wrong then it can knock their confidence and negatively impact how your customers see you as an organisation. This programme provides staff with the basic skills they need to sell. This course will help participants: Profile customers Research and identify potential new customers Use the consultative sales process Build effective rapport with customers Identify customer needs through effective questioning and listening Position products and services effectively Close the sale or gain commitment to further action Manage their customer portfolio to maximise sales 1 Introduction Aims and objectives of the training Personal introductions and objectives Self-assessment of existing sales skills Overview of content 2 Knowing your customers Who are your customers, and what do they want from you? What are your strengths, compared to your competitors? Who are your new potential customers? How do you communicate with new customers? What do you need to know about your customers before you start to sell? Making the initial approach Planning your pipeline - keeping the customers coming 3 The four-step sales process Overview of the consultative sales process Key benefits of using the consultative sales process Focusing on behaviours not targets The behaviours of a good salesperson Common pitfalls and mistakes Personal strengths and weaknesses 4 Building rapport First impressions - Mehrabian theory of communication Short cuts to building rapport Looking out for clues as to how the customer is thinking Looping back to keep the conversation flowing Acknowledging past communication Dealing with emotions such as anger Setting the agenda to keep control Getting past gatekeepers 5 Questioning and listening How to ask open questions to uncover information Left brain questions When closed question can be useful What stops us listening? The four levels of listening How to develop your listening skills 6 Presenting products and services to customers When to present Using benefits not features Making it personal Using reciprocity The tendency towards the middle Using consistency 7 Gaining commitment Testing the water Dealing with objections using ACLEO Asking for the business Getting referrals Ending with a personalised close Following-up 8 Managing your customer pipeline Spotting opportunities for cross-sales Managing your portfolio Maximising sales proactively Review meetings Customer satisfaction measures and surveys Mystery shopping 9 Putting it all together Skills practice Personal learning summary and action plans

Introduction to sales (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Classroom Assistant

4.7(160)

By Janets

Teaching is a profession where you have to conduct lessons, exams and other activities via effective classroom management. To teach, you must have excellent organisation, time management and classroom management skills, since it paves the way for the teachers to engage the students in learning. This Classroom Assistant course is designed to teach you how to plan lessons, assess learning development, manage challenging behaviour in the classroom, and much more.  This Classroom Assistant course will equip you with the skills you need to successfully and efficiently plan. Furthermore, you will learn how to develop plans with assessable results, effective classroom management approaches, how to conduct assessments, the principles of grading, and some best-known practices in the classroom. Enrol Now to start boosting your Classroom Assistant skills. Key topics to be covered Introduction to Teach Like a Champion Classroom Management Planning Assessments and Grading Relationship Management Learning Outcomes Learn how to stop students disrupting the class Know the process of how to stop disruptions once they begin Learn how to choose an appropriate seating arrangement, the best communication system for the class, and the critical importance of planning. Develop expert planning skills to prepare effective lessons for the whole semester Learn how to conduct effective assessments, utilise efficient grading techniques, and determine the strengths and weaknesses of summative assessment Gain a comprehensive understanding of developing healthy relationships with students, communicating effectively with parents, and managing management. This course provides ultimate behaviour management training for teachers. This Classroom Assistant course will teach you the psychological tools for becoming a champion teacher. Who is this course for? Anyone who is interested in a career in the education sector Students Those who wants to improve their Classroom Assistant skills Why Choose this Course? Earn a FREE e-certificate upon successful completion of the Classroom Assistant Course. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design This Classroom Assistant course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of- Video lessons Online study supplies Mock tests Multiple-choice evaluation Career path The Classroom Assistant course can be applied to  a range of roles, but would particularly enhance careers such as the following: Teaching Assistant Classroom Assistant SEN Teacher Education related other profession Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. A print copy by post is also available at an additional cost of £9.99 and a PDF Certificate at £4.99. What are you waiting for? Enrol this premium course NOW! 

Classroom Assistant
Delivered Online On Demand2 hours 46 minutes
£9.99

Copywriting - CPD Accredited Course

5.0(14)

By Training Express

Discover the art and craft of compelling copywriting with this expertly designed online course. Whether you're a budding writer or a marketing professional looking to sharpen your messaging, this course offers a deep dive into creating content that captures attention and drives results. From mastering the basics to crafting headlines that command interest, each module builds your confidence in writing clear, persuasive copy tailored to various media formats. Explore the nuances of writing for digital platforms, print, press, and mainstream outlets, ensuring your words resonate with diverse audiences. Along the way, you’ll refine essential skills that enhance clarity, creativity, and impact, all presented in a format that fits your schedule. By the end, you'll have a solid grasp of what makes copy effective and how to keep readers engaged—ready to take your writing to new heights. Course Curriculum: Module 01: Introduction to Copywriting Module 02: Basics of Copywriting Module 03: Eye-Catching Headlines Module 04: Attention-Grabbing Advertisements Module 05: Essential Copywriting Skills Module 06: Online Copywriting Module 07: Press Related Copywriting Module 08: Print Media Copywriting Module 09: Copywriting for Mainstream Media Module 10: Copywriting for Other Media Module 11: How to Write Better Copy Module 12: Making an Impact with Creative Copy Module 13: So You Want to be a Copywriter? Module 14: Final Tips 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%. Accredited Certificate After successfully completing this Copywriting - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Copywriting - CPD Accredited 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 Copywriting - CPD Accredited training.

Copywriting  - CPD Accredited Course
Delivered Online On Demand1 hour
£23

This course will provide an opportunity to begin to understand what commercial and financial awareness means and the importance of everyone in thinking commercially.

Thinking Commercially
Delivered in Loughborough or UK Wide or OnlineFlexible Dates
£1,068

Scenario Planning

By Emergent Learning

Course Overview This course provides participants with a structured approach to anticipating future uncertainties by identifying objective factors through horizon scanning, analysing risks and opportunities using PESTLE analysis, and developing robust scenarios. The course also covers intervention analysis and prioritisation, ensuring participants can create actionable plans to navigate potential futures effectively. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes -Conduct horizon scanning to identify objective factors influencing future scenarios. -Use PESTLE analysis to systematically identify risks and opportunities in various scenarios. -Develop plausible scenarios that consider key uncertainties and external factors. -Perform intervention analysis to assess the impact of different strategic actions. -Prioritise and plan interventions to ensure readiness for multiple future scenarios. Format F2F or Virtual Delivery Mode Closed Cohort or Occasional Limited Public Schedule Duration 2 Days Target Audience Business professionals, leaders & executives aiming to help their organisations prepare for uncertain futures by exploring multiple, plausible scenarios.

Scenario Planning
Delivered Online & In-PersonFlexible Dates
$1,900

Leadership Mastery

By Emergent Learning

Target Audience Mid-level managers, team leaders with several years of experience, and leaders looking to refine their skills and approach. Duration 2 Days Course Overview The Leadership Mastery course is a 2-day intensive program designed to equip participants with cutting-edge, evidence-based leadership skills tailored to the complexities of contemporary organisational environments. Drawing from interdisciplinary research in psychology, organizational behavior, neuroscience, and management science, the course integrates seminal and emerging leadership theories, models, and practical tools. Participants will enhance their strategic thinking, develop their ability to manage complex team dynamics, and foster a culture of innovation and continuous improvement. Participants will engage in interactive workshops, case studies, simulations, and reflective exercises to bridge theory and practice, fostering adaptive and strategic leadership capabilities. The course emphasizes real-world application, addressing challenges such as hybrid work, people and talent management, digital transformation, and ethical decision-making. The Leadership Tension Lens will be revisited to help leaders more critically analyse competing priorities and lead with greater confidence. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes Revisit the Leadership Tension Lens: Managing Complexity in Leadership Developing Vision and Strategy - Leading as part of a leadership team agenda Drive High Performance and exploring tools (OKR's, Scorecards) Apply Advanced People Management approaches: Motivating and Retaining Talent Demonstrate social and emotional intelligence in high stakes contexts Apply models and approaches to Leading Change: Managing Cultural Transformation Practice Learning from Success and Failure: Case Studies and Best Practices

Leadership Mastery
Delivered In-PersonFlexible Dates
$1,900

Excel for business professionals

By Nexus Human

Duration 2.25 Days 13.5 CPD hours This course is intended for The job roles best suited to the material in this course are: sales personnel, accountants, administrators, auditors, lab assistants, office job positions. Overview Work with functions. Work with lists. Analyze data. Visualize data with charts. Use PivotTables and PivotCharts. Work with multiple worksheets and workbooks. Share and protect workbooks. Automate workbook functionality. Use Lookup functions and formula auditing. Forecast data. Create sparklines and map data This course provides the knowledge to create advanced workbooks and worksheets that can deepen the understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it and present that information to decision makers. In addition this course will give you the ability to collaborate with colleagues, automate complex or repetitive tasks and use conditional logic to construct and apply elaborate formulas and functions which will allow you to work through a lot of data and generate the answers that your organisation needs. WORKING WITH FUNCTIONS Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date and Time Functions Topic E: Work with Text Functions WORKING WITH LISTS Topic A: Sort Data Topic B: Filter Data Topic C: Query Data with Database Functions Topic D: Outline and Subtotal Data ANALYZING DATA Topic A: Create and Modify Tables Topic B: Apply Intermediate Conditional Formatting Topic C: Apply Advanced Conditional Formatting VISUALIZING DATA WITH CHARTS Topic A: Create Charts Topic B: Modify and Format Charts Topic C: Use Advanced Chart Features USING PIVOTTABLES AND PIVOTCHARTS Topic A: Create a PivotTable Topic B: Analyze PivotTable Data Topic C: Present Data with PivotCharts Topic D: Filter Data by Using Timelines and Slicers WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS Topic A: Use Links and External References Topic B: Use 3-D References Topic C: Consolidate Data SHARING AND PROTECTING WORKBOOKS Topic A: Collaborate on a Workbook Topic B: Protect Worksheets and Workbooks AUTOMATING WORKBOOK FUNCTIONALITY Topic A: Apply Data Validation Topic B: Search for Invalid Data and Formulas with Errors Topic C: Work with Macros USING LOOKUP FUNCTIONS AND FORMULAS AUDITING Topic A: Use Lookup Functions Topic B: Trace Cells Topic C: Watch and Evaluate Formulas FORECASTING DATA Topic A: Determine Potential Outcomes Using Data Tables Topic B: Determine Potential Outcomes Using Scenarios Topic C: Use the Goal Seek Feature Topic D: Forecast Data Trends CREATING SPARKLINES AND MAPPING DATA Topic A: Create Sparklines Topic B: Map Data

Excel for business professionals
Delivered OnlineFlexible Dates
Price on Enquiry