1294 Courses delivered Online

Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now! Why is Microsoft important in the workplace? From project management to office coordination, having a stronger command of Microsoft Word, Excel, PowerPoint, Teams, Power BI, OneDrive, and other programmes will benefit your organisation and your work. Also, Microsoft skills can make your work life so much easier that you can complete your tasks in minutes that would take others hours. So enhance your skills and become that go-to guy everyone envies. Industry experts have developed this bundle, which has already helped many learners like you. So, If you want to learn how to use the most popular Microsoft tools, you don't need to look any further than this bundle. This bundle is the only thing you need to go from a complete novice to a skilled Microsoft user. So, enrol in this all-in-one bundle and start learning today. Along with this course, you will get 10 premium courses, an original Hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Bundle Consists of the following Premium courses: Course 01: Microsoft SQL Server Development for Everyone Course 02: MS Word Diploma Course 03: Advanced Diploma in MS Excel Course 04: PowerPoint Diploma Course 05: The Complete Microsoft OneDrive Course Course 06: The Complete Microsoft Outlook Masterclass Course 07: New Functions in Microsoft Excel 2021 Course 08: Complete Microsoft Power BI 2021 Course 09: Microsoft Teams Course 10: Outlook Tips and tricks Course 11: Touch Typing Essentials How will I get my Certificate? After successfully completing the Course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Our course is suitable for all. Requirements This course has no prior requirements. Career path Having this various expertise will increase the value of your CV and open you up to multiple job sectors. Office Administrator PA Secretary Office Worker Manager And much more... Certificates Certificate of completion Digital certificate - Included

Start from the ground up and learn tips, tricks, shortcuts and build confidence in using Excel.

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR

Performance and efficiency-enhancing Excel skills for everyday users.

Learn Excel tricks of the trade and some quick easy wins, to make time spent on spreadsheets efficient, effective and painless!

Good leadership and management are essential for creating a productive work team. This Leadership and Management course will teach you all the skills and knowledge you need to develop your leadership style and abilities. Whether you're a line manager, coach, or entrepreneur, you will learn valuable strategies and techniques that will help you to create an unbeatable workforce, manage conflict, motivate teams, and ensure that each member is working to their full potential.  This course includes case studies and practical exercises that can be applied to a wide range of professions, covering different leadership models and theories. It covers a number of topics in relation to management, from talent acquisition to providing feedback. You'll also develop your proficiency in key Microsoft Office packages. By the end of this course, you'll not only be equipped with the skills to take your management to the next level, but will also have an excellent understanding of corporate responsibility and ethics, which will every senior member of staff must know. Learning Outcomes: Understand the fundamental differences between leadership and management Familiarise with different leadership theories and leadership models Learn techniques for motivating employees and providing constructive feedback Deepen your understanding of the talent management process Know how to deal with office politics effectively and manage workplace conflict Build your proficiency in Microsoft Office's leading packages Develop your understanding of corporate responsibility and ethics Gain valuable team-building skills to create an unbeatable workforce Course Design The 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 materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this Course for? This course is ideal for anyone in a management or leadership role who wants to develop their skill set and leadership style to manage teams more effectively. There are no specific entry requirements for this course, which can be studied on a part-time or full-time basis. Career Path On successful completion, learners will have a range of skills required to lead teams and individuals effectively, which apply to any management role. These skills are ideal for anyone pursuing any of the following professions: Business Owner Entrepreneur Line Manager Head of Department Project Manager Teacher Tutor Coach Mentor

Duration 2 Days 12 CPD hours This course is intended for 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. To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and function Overview #NAME? Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft© Excel© is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. 1 - DATA ANALYSIS FUNDAMENTALS Introduction to Data Science Create and Modify Tables Sort and Filter Data 2 - VISUALIZING DATA WITH EXCEL Visualize Data with Charts Modify and Format Charts Apply Best Practices in Chart Design 3 - ANALYZING DATA WITH FORMULAS AND FUNCTIONS Analyze Data with Formulas and Named Ranges Analyze Data with Functions Implement Data Validation, Forms, and Controls Create Conditional Visualizations with Lookup Functions 4 - ANALYZING DATA WITH PIVOTTABLES Create a PivotTable Analyze PivotTable Data 5 - PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL Visualize Data with PivotCharts Filter Data Using Slicers and Timelines Create a Dashboard in Excel 6 - CREATING GEOSPATIAL VISUALIZATIONS WITH EXCEL Create Map Charts in Excel Customize Map Charts in Excel 7 - PERFORMING STATISTICAL ANALYSIS Visualize Trendlines and Sparklines with Excel Analyze Data with the Data Analysis ToolPa 8 - GETTING AND TRANSFORMING DATA Connect to Data with Queries Clean and Combine Data Shape and Transform Data 9 - MODELING AND ANALYZING DATA WITH POWER PIVOT Install Power Pivot in Excel Create Data Models with Power Pivot Create Power Pivots Perform Advanced Data Analysis and Visualization 10 - PRESENTING INSIGHTS WITH REPORTS (OPTIONAL) Plan a Report Create a Report

Fall into Savings. Enjoy the biggest price fall this Autumn! Life Just Got Better This Summer! Get Hard Copy + PDF Certificates + Transcript + Student ID Card as a Gift - Enrol Now Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Xero and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all in one Xero bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Xero course that will enhance your skills and prepare you for the competitive job market. Also, our Xero experts are available for answering your queries and help you along your learning journey. Advanced audiovisual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Xero, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Xero Bundle Consists of the following Premium courses: Course 01: Level 3 Xero Training Course 02: Payroll Management - Diploma Course 03: Introduction to Accounting Course 04: Accounting and Bookkeeping Level 2 Course 05: Managerial Accounting Masterclass Course 06: Diploma in Quickbooks Bookkeeping Course 07: Theory of Constraints, Throughput Accounting and Lean Accounting Course 08: Internal Audit Training Diploma Course 09: Level 3 Tax Accounting Course 10: Team Management Course 11: Business Analysis Level 3 Course 12: GDPR Data Protection Level 5 Course 13: Microsoft Excel Training: Depreciation Accounting Course 14: Microsoft Excel Level 3 Benefits you'll get choosing Apex Learning for this Xero: Pay once and get lifetime access to 14 CPD courses Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Curriculum of Xero Bundle Course 01: Level 3 Xero Training Introduction Getting Started Invoices and Sales Bills and Purchases Bank Accounts Products and Services Fixed Assets Payroll VAT Returns Course 02: Payroll Management - Diploma Sage 50 Payroll for Beginners Module 1: Payroll Basics Module 2: Company Settings Module 3: Legislation Settings Module 4: Pension Scheme Basics Module 5: Pay Elements Module 6: The Processing Date Module 7: Adding Existing Employees Module 8: Adding New Employees Module 9: Payroll Processing Basics Module 10: Entering Payments Module 11: Pre-Update Reports Module 12: Updating Records Module 13: e-Submissions Basics Module 14: Process Payroll (November) Module 15: Employee Records and Reports Module 16: Editing Employee Records Module 17: Process Payroll (December) Module 18: Resetting Payments Module 19: Quick SSP Module 20: An Employee Leaves Module 21: Final Payroll Run Module 22: Reports and Historical Data Module 23: Year-End Procedures Sage 50 Payroll Intermediate Level Module 1: The Outline View and Criteria Module 2: Global Changes Module 3: Timesheets Module 4: Departments and Analysis Module 5: Holiday Schemes Module 6: Recording Holidays Module 7: Absence Reasons Module 8: Statutory Sick Pay Module 9: Statutory Maternity Pay Module 10: Student Loans Module 11: Company Cars Module 12: Workplace Pensions Module 13: Holiday Funds Module 14: Roll Back Module 15: Passwords and Access Rights Module 16: Options and Links Module 17: Linking Payroll to Accounts Course 03: Introduction to Accounting Accounting Fundamental What is Financial Accounting Accounting Double Entry System and Fundamental Accounting Rules Financial Accounting Process and Financial Statements Generates Basic Accounting Equation and Four Financial Statements Define Chart of Accounts and Classify the accounts External and Internal Transactions with companies Short Exercise to Confirm what we learned in this section Accounting Policies What are Major Accounting Policies need to be decided by companies Depreciation Policies Operational Fixed Asset Controls Inventory Accounting and Controls Revenue Accounting and Controls Course 04: Accounting and Bookkeeping Level 2 Introduction to the course Introduction to Bookkeeping Bookkeeping systems Basics of Bookkeeping The functionality of bookkeeping On a personal note Course 05: Managerial Accounting Masterclass Setion 1 Manaerial Accounting Defined Financial Accounting Compared to Managerial Accounting Trends Foundation Concepts Setion 2 Process costing vs Job Cost Job cost part 1 Job cost part 2 Allocating costs to multiple products Departmental Overhead Rate Activity-Based Costing Setion 3 Cost Behavior Cost Behavior Continued Break Even Point Break Even Point Changes Sales Mix Pricing Short Term Decisions Section 4 Budgeting Intro Budgetin continued Operating Budgets Cash Budget Budgeted Balance Sheet Performance Evaluation Performance Evaluation Cont Standards Standard Costs Continued Setion 5 Capital Investment Decisions Capital Investment Analysis Course 06: Diploma in Quickbooks Bookkeeping Getting prepared - access the software and course materials Getting started Setting up the system Nominal ledger Customers Suppliers Sales ledger Purchases ledger Sundry payments Sundry receipts Petty cash VAT - Value Added Tax Bank reconciliation Payroll / Wages Reports Tasks Course 07: Theory of Constraints, Throughput Accounting and Lean Accounting The Theory of Constraints and Throughput Accounting Lean Accounting Summary and Lean Accounting Assignment Course 08: Internal Audit Training Diploma Auditing as a Form of Assurance Internal Audit Procedures Technology-based Internal Audit Internal Control and Control Risk Audit Interviews Reporting Audit Outcome UK Internal Audit Standards Career as an Auditor Course 09: Level 3 Tax Accounting Tax System and Administration in the UK Tax on Individuals National Insurance How to Submit a Self-Assessment Tax Return Fundamentals of Income Tax Advanced Income Tax Payee, Payroll and Wages Capital Gain Tax Value Added Tax Import and Export Corporation Tax Inheritance Tax Double Entry Accounting Management Accounting and Financial Analysis Career as a Tax Accountant in the UK Course 10: Presenting Financial Information Presenting Financial Information The Hierarchy of Performance Indicators The Principle of Effective Reports Guidelines for Designing Management Reports Methods of Presenting Performance Data The Control Chart: Highlighting the Variation in the Data The Pareto Chart: Highlighting Priorities Exercise: The Control Chart An Example Management Report Interpreting Performance Data Supporting Colleagues by Giving Feedback Data Visualisation Final Thoughts on Presenting Financial Information Course 11: Business Analysis Level 3 Introduction to Business Analysis Business Processes Business Analysis Planning and Monitoring Strategic Analysis and Product Scope Solution Evaluation Investigation Techniques Ratio Analysis Stakeholder Analysis and Management Course 12: GDPR Data Protection Level 5 GDPR Basics GDPR Explained Lawful Basis for Preparation Rights and Breaches Responsibilities and Obligations Course 13: Microsoft Excel Training: Depreciation Accounting Introduction Depreciation Amortization and Related Terms Various Methods of Depreciation and Depreciation Accounting Depreciation and Taxation Master Depreciation Model Conclusion Course 14: Microsoft Excel Level 3 Microsoft Excel 2019 New Features Getting Started with Microsoft Office Excel Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Working with Functions Working with Lists Analyzing Data CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Xero bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Xero is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so that you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course; it can be studied in your own time at your own pace. Career path Having this various expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Level 3 Xero Training) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! According to recent statistics, the IT sector is one of the fastest-growing industries in the UK, and it shows no signs of slowing down. As technology continues to transform the way we live and work, there is an ever-increasing demand for skilled IT professionals who can keep up with the pace of change. If you're looking to enter this exciting field or advance your existing IT skills, our Essential IT Training course is the perfect starting point. Our comprehensive Essential IT Training course covers everything from the basics of information technology (IT) to more advanced topics such as project management and database storage. You'll learn how to use word processing, presentation, and spreadsheet software, and gain valuable insights into communication and network technologies. In addition, you'll develop future skills that are essential for success in the fast-paced world of IT. By the end of this Essential IT Training, you'll have a solid foundation in IT and be able to navigate the latest software with ease. You'll also have the skills to manage IT projects, work with databases, and communicate effectively in a technology-driven environment. Whether you're just starting out or looking to advance your career, our Essential IT Training course will provide you with the skills you need to succeed. After this Essential IT Training, you will be able to learn: Understand the importance of IT in today's world. Develop essential skills in word processing, presentation, and spreadsheet software. Learn how to store and manage data effectively using databases. Develop communication and network skills essential for working in the IT industry. Learn about project management in an IT context. Gain future skills that are essential for success in the fast-paced world of IT. Why Prefer this Course? Opportunity to earn a certificate accredited by CPD after completing this IT Training Course Student ID card with amazing discounts - completely for FREE! (£10 postal charge will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Each of our students gets full 24/7 tutor support *** Course Curriculum *** Module 01: Introduction: A Transforming Technology Toward A Brave New World Attitudes And Phobias Technology As Progress Critical Approaches To Technology What Is Information? What Is Information Technology? Characteristics Of Information Technology Module 02: Importance Of Information Technology The Use Of Information Technology Business Information Technology Use In Organisations Benefits Of The Use Of Information Technology In Business Information Technology Use In Education Information Technology In Health Module 03: Communication And Network Types Of Communication Communication Systems Communication Channels Wireless Connections Connection Devices Data Transmission Mobile Internet Networks Network Types Module 04: Future Skills Required In Information Technology Future Trends Drivers Impact On Employment And Skills Short /Immediate Issues And The Impact On Skills Medium Term Issues And The Impact On Skills Long Term Issues And The Impact On Skills Module 05: Technology As A Foundation Skill Area The Development And Impact Of Technology Culture Schooling A New Learning Environment Using Information Technology An Integrated Approach Information Technology Literacy Outcomes Enhancing Classrooms With Information Technology Module 06: Word Processing Software History Of Word Processing Standard Features Of Word Processors Full-Featured Word Processors Introduction To Microsoft Office Scrolling A Document Moving The Insertion Pointer Moving In Small Increments (Basic Arrow Keys) Getting Lost And Going Back Editing Text Deleting Stuff Splitting And Joining Mistakes? Mistakes? Undo Them With Haste Module 07: Presentation Software Starting And Exiting PowerPoint Understanding The Screen Elements Working With The Ribbon Working With Collapsible Tab Groups Working With Backstage View Changing The View Normal View Notes Page View Zooming In And Out Enabling Optional Display Elements Gridlines Opening A New Display Window Using The Help System Using PowerPoint Support Resources Understanding Product Activation Adjusting Privacy Settings Module 08: Creating And Editing Spreadsheet (Part 1: The Basics Of Spreadsheets) Typing Data Into A Single Cell Typing Data In Multiple Cells Typing In Sequences With Autofill Formatting Numbers And Labels Formatting Numbers Displaying Negative Numbers Formatting Decimal Numbers Formatting Cells Formatting Fonts And Text Styles Formatting With Colour Adding Borders Module 09: Creating And Editing Spreadsheet (Part 2: Navigation And Edit) Navigating A Spreadsheet Using The Keyboard To Move Around A Spreadsheet Naming Cells Searching A Spreadsheet Searching For Formulas Editing A Spreadsheet Changing The Size Of Rows And Columns With The Mouse Typing The Size Of Rows And Columns Adding And Deleting Rows And Columns Adding Sheets Renaming Sheets Rearranging Sheets Clearing Data Printing Workbooks Adding A Header Or Footer Printing Gridlines Defining A Print Area Inserting And Removing Page Breaks Printing Row And Column Headings Defining Printing Margins Defining Paper Orientation And Size Printing In Excel Module 10: Storing Database Database Basics Designing A Database Editing And Modifying A Database Adding And Deleting A Field Defining The Type And Size Of A Field Typing Data Into A Database Using Datasheet View Using Form View Creating A Form Editing A Form Adding A Field Closing And Saving A Database Exiting Access Module 11: Information Technology Project Management Introduction To Project Management What Is Project? What Is Project Management? Project Stakeholders Project Management Tools And Techniques Project Scope Management Project Time Management Project Cost Management Assessment Process Once you have completed all the course modules, your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the course. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Essential IT Training is ideal for: Students who are interested in pursuing a career in IT. Professionals who want to upskill and stay up-to-date with the latest IT technologies and trends. Anyone who wants to learn how to use common software tools used in the workplace. Career path After completing this Essential IT Training, you are to start your career or begin the next phase of your career in following fields: IT Support Specialist: £25,000 - £35,000 Database Administrator: £35,000 - £50,000 Network Administrator: £30,000 - £45,000 IT Project Manager: £45,000 - £60,000 Software Developer: £30,000 - £60,000 Business Analyst: £30,000 - £50,000 Certificates CPDQS Accredited Certificate Digital certificate - £10 CPDQS Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.