702 Courses delivered Online

Overview This comprehensive course on Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. It is available to all students, of all academic backgrounds. Requirements Our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 34 sections • 135 lectures • 08:20:00 total length •Introduction: 00:03:00 •Getting started on Windows, macOS, and Linux: 00:01:00 •How to ask great questions: 00:01:00 •FAQ's: 00:01:00 •Excel Overview: 00:05:00 •Start Excel Spreadsheet: 00:04:00 •Enter Text and Numbers: 00:07:00 •Relative References: 00:04:00 •Working with ranges: 00:07:00 •Save and Save as Actions: 00:08:00 •File Extensions, Share, Export, and Publish files: 00:06:00 •Adding Rows and Columns: 00:03:00 •Modifying Rows and Column lengths: 00:05:00 •Copy, Cut, and Paste: 00:07:00 •Copying Formulas: 00:03:00 •Page setup options: 00:06:00 •Fit to print on One Page: 00:03:00 •Print Workbooks: 00:03:00 •Sorting Data Ascending Order: 00:04:00 •Sorting Data Descending Order: 00:02:00 •Filter Data: 00:04:00 •Creating Basic Formulas: 00:06:00 •Datetime Formulas: 00:06:00 •Mathematical formulas phase1: 00:20:00 •Mathematical formulas phase2: 00:12:00 •VLOOKUP formula: 00:12:00 •HLOOKUP formula: 00:04:00 •XLOOKUP: 00:08:00 •Handling #NA and Approximates match in XLOOKUP: 00:11:00 •Split Text into columns: 00:07:00 •Flash Fill: 00:07:00 •Data Validation: 00:07:00 •Remove Duplicates: 00:08:00 •Import Data from Text files: 00:06:00 •Import Data from .CSV files: 00:03:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Numbers: 00:05:00 •Formatting Date: 00:03:00 •Formatting Tables: 00:05:00 •Pivot Tables: 00:07:00 •Pivot Charts: 00:02:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Creating Charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line Charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Overview: 00:04:00 •Start PowerPoint Presentation: 00:05:00 •Screen setting and Views: 00:05:00 •Presentation Tips and Guidelines: 00:06:00 •Creating a New Presentation: 00:04:00 •Working with Slides: 00:04:00 •Save a Presentation: 00:04:00 •Print Slides: 00:03:00 •Formatting Text: 00:05:00 •Slide Text Alignments: 00:03:00 •Multi-Column Text Alignments: 00:02:00 •Adding Bullets and Numbered List Items: 00:03:00 •Insert Shapes: 00:03:00 •Insert Icons: 00:03:00 •Insert Graphics: 00:04:00 •Add 3D Models: 00:03:00 •Insert Pictures: 00:03:00 •Picture Options: 00:04:00 •Picture Cropping: 00:03:00 •Applying Built-in Picture Styles: 00:04:00 •Add SmartArt Graphic: 00:03:00 •Modifying SmartArt: 00:03:00 •Creating a Target Chart using SmartArt: 00:03:00 •Create a Table on Slide: 00:04:00 •Formatting Tables: 00:02:00 •Inserting Tables: 00:02:00 •Table Layouts: 00:01:00 •Add a Chart: 00:02:00 •Formatting Charts: 00:02:00 •Insert Chart from Microsoft Excel: 00:03:00 •Adding Video to a Presentation: 00:03:00 •Adding Audio to a Presentation: 00:02:00 •Screen Recording and Adding: 00:02:00 •Applying Transitions to Presentation: 00:04:00 •Object Animation: 00:03:00 •Effect Options: 00:02:00 •Advanced Animation: 00:02:00 •Triggers to control animation: 00:02:00 •Onscreen Presentation: 00:02:00 •Hiding Slides: 00:02:00 •Changing Order of Slides: 00:02:00 •Copying Slides: 00:02:00 •Overview of MS Word: 00:04:00 •Start MS Word 2021: 00:05:00 •Create a new blank document: 00:04:00 •Creating a paragraph text: 00:05:00 •Non-printing characters: 00:03:00 •Save a document: 00:03:00 •Open a document: 00:01:00 •Find and replace: 00:04:00 •AutoCorrect options: 00:03:00 •Formatting text: 00:04:00 •Copy cut and paste: 00:04:00 •Character formatting: 00:02:00 •Format painter: 00:04:00 •Work with numbers: 00:02:00 •Add bullets: 00:03:00 •Outline creation: 00:04:00 •Creating a table: 00:03:00 •Adding rows and columns to a table: 00:02:00 •Formatting table data: 00:02:00 •Borders and shading: 00:02:00 •Sorting in a table: 00:04:00 •Draw a table: 00:04:00 •Convert text to table: 00:03:00 •Convert table to text: 00:02:00 •Insert a spreadsheet: 00:02:00 •Quick tables - readily available formats: 00:02:00 •Working with styles: 00:02:00 •Creating styles: 00:02:00 •Clear formatting: 00:01:00 •Margins: 00:02:00 •Orientation: 00:01:00 •Page size setting: 00:01:00 •Adding columns: 00:03:00 •Page break - section break: 00:02:00 •Adding watermark: 00:03:00 •Headers and footers: 00:03:00 •Create envelops: 00:02:00 •Creating labels: 00:02:00 •Creating a mail merge document: 00:03:00 •Thesaurus and spell check: 00:01:00 •Word count: 00:01:00 •Speech - read aloud: 00:01:00 •Language - translate: 00:01:00 •Tracking: 00:01:00

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £180 as a Gift - Enrol Now Give your career a boost and take it to the next level with the Bookkeeping Diploma for Accountants. This comprehensive program is designed to provide you with essential bookkeeping knowledge that will help you excel professionally. Whether you’re aiming to develop new skills for your next job or looking to enhance your expertise for a promotion, this diploma is your gateway to staying ahead of the competition. The Bookkeeping Diploma for Accountants covers everything from basic to advanced bookkeeping skills, offering in-depth training to illuminate your path and elevate your career. By strengthening your bookkeeping expertise, you’ll add significant value to your resume, making you stand out to potential employers. Throughout the program, you'll improve your competency in bookkeeping and gain valuable career insights that will help you see a clearer picture of your future growth. Enrol in the Bookkeeping Diploma for Accountants today and equip yourself with the critical bookkeeping skills needed to thrive in a competitive job market. Along with this course, you will get 10 premium courses, an originalHardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Bundle Consists of the following Premium courses: Course 01: Diploma in Accounting and Bookkeeping Course 02: Diploma in Quickbooks Bookkeeping Course 03: Introduction to Accounting Course 04: Level 3 Tax Accounting Course 05: Level 3 Xero Training Course 06: Payroll Management - Diploma Course 07: Diploma in Sage 50 Accounts Course 08: Advanced Diploma in MS Excel Course 09: Microsoft Excel Training: Depreciation Accounting Course 10: Team Management Course 11: Document Control So, enrol now to advance your career! Key Features of the Course: FREE Bookkeeping Diploma for Accountants CPD-accredited certificate Get a free student ID card with Bookkeeping Diploma for Accountants training (£10 applicable for international delivery) Lifetime access to the Bookkeeping Diploma for Accountants course materials The Bookkeeping Diploma for Accountants program comes with 24/7 tutor support Get instant access to this Bookkeeping Diploma for Accountants course Learn Bookkeeping Diploma for Accountants training from anywhere in the world The Bookkeeping Diploma for Accountants training is affordable and simple to understand The Bookkeeping Diploma for Accountants training is entirely online Learning Outcomes: Upon completing the course, you will be able to: Understand and apply core bookkeeping systems and principles. Utilize basic accounting skills for effective financial record-keeping. Set up and manage QuickBooks software for bookkeeping tasks. Handle nominal ledger, sales ledger, and purchases ledger entries. Implement accounting policies and procedures in financial management. Apply accounting fundamentals to real-world scenarios and decision-making. Description Curriculum of the Bundle Course 01: Diploma in Accounting and Bookkeeping Introduction to the course Bookkeeping systems Basics Functionality On a personal note Accounting Skills Course 02: 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 Course 03: Introduction to Accounting Accounting Fundamental Accounting Policies Course 04: 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 05: Level 3 Xero Training Introduction Getting Started Invoices and Sales Bills and Purchases Bank Accounts Products and Services Fixed Assets Payroll VAT Returns Course 06: 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 07: Diploma in Sage 50 Accounts Sage 50 Bookkeeper - Coursebook Introduction and TASK 1 TASK 2 Setting up the System TASK 3 a Setting up Customers and Suppliers TASK 3 b Creating Projects TASK 3 c Supplier Invoice and Credit Note TASK 3 d Customer Invoice and Credit Note TASK 4 Fixed Assets TASK 5 a and b Bank Payment and Transfer TASK 5 c and d Supplier and Customer Payments and DD STO TASK 6 Petty Cash TASK 7 a Bank Reconnciliation Current Account TASK 7 b Bank Reconciliation Petty Cash TASK 7 c Reconciliation of Credit Card Account TASK 8 Aged Reports TASK 9 a Payroll TASK 9 b Payroll TASK 10 Value Added Tax - Vat Return Task 11 Entering opening balances on Sage 50 TASK 12 a Year end journals - Depre journal TASK 12 b Prepayment and Deferred Income Journals TASK 13 a Budget TASK 13 b Intro to Cash flow and Sage Report Design TASK 13 c Preparation of Accountants Report & correcting Errors (1) Course 08: Advanced Diploma in MS Excel 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 Visualizing Data with Charts Using PivotTables and PivotCharts Working with Multiple Worksheets and Workbooks And many more... Course 09: 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 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 And many more... Course 11: Document Control Introduction to Document Control Principles of Document Control and Elements of Document Control Environment Document Control Lifecycle Document Control Strategies and Instruments Document Management Quality Assurance and Controlling Quality of Documents Project Document Control Electronic Document Management Systems and Soft Copy Documentation How will I get my Certificate? After successfully completing the Bookkeeping 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) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But with this special offer, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! 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? Anyone from any background can enrol in this Bookkeeping 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 Bookkeeping Diploma 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 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

Flash Sale On | | 11-in-1 Exclusive Bundle | Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift | CPD QS Certified | 115 CPD Points | Lifetime Access

Microsoft Excel assists you to perform with different programs such as calculation, macro program language, pivot tablets, graphics tools, and various applications within time. Learn much more precise use of these functions with the easiest and effective method thorough Microsoft Office 2016 Excel Beginners course. The course teaches you the basic functions of Excel. It instructs you how to open Excel files, make a simple calculation, and save it. It also teaches you how to put data, extract data, analyze actionable information, and perform in different ways. The purpose of the course is to enhance your ability to kick-start your career in a sound bite. Who is this Course for? Microsoft Office 2016 Excel Beginners is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Beginners 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Beginners 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

This bundle course has been designed to give our learners a more in-depth understanding of general office procedures, codes of practice and required skills. It provides essential training on the Microsoft Office Suite for managing everyday clerical tasks and is ideal for entry-level learners. Fast track your career and be equipped with the skills and knowledge to manage everyday office tasks efficiently with the Admin, Secretarial & PA Diploma. This comprehensive course is a general introduction to office procedures and practices, exploring the basics of administrative management and admin support. You will develop essential business writing skills, improve your telephone etiquette, learn how to communicate professionally with clients and much more. This course also includes step-by-step guidance on Microsoft Word. Master Microsoft Office suite and boost your efficiency in general administrative tasks with the Microsoft Office Applications Training course. This introductory program is ideal for beginners who have little or no experience with Office programs. You will be guided step-by-step on how to use Word, Excel, PowerPoint, Outlook and Access. On completion, you will be able to create professional slideshow presentations, automate tasks, analyse numerical data and much more. Enrol today and add valuable transferable skills to your CV. Learning Outcomes: Gain a solid understanding of administrative management and admin support Learn the fundamental principles of business writing and improve your telephone etiquette Learn how to communicate effectively and develop your body language skills Familiarise with the day-to-day responsibilities of an administrative assistant, secretary & PA Get tips on how to organise your workload and manage your time efficiently Master Microsoft Office programs - Word, Excel, Powerpoint, Outlook & Access Share documents, automate tasks, analyse data, create slideshows & much more Gain valuable transferable skills to boost your professional development Be able to customise the user interface to your desire Discover time-saving techniques, tips & shortcuts to work faster and more efficiently Who is This Course for? This bundle course is ideal for anyone who wishes to boost their professional development in an office-based role. This training program is particularly suitable for those who are new to their profession and wish to gain the skills and knowledge to prepare them for their career. Method of Assessment: Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path On successful completion, learners will have a solid understanding of fundamental office procedures and practices, and will be equipped with the skills to pursue the following roles: Office Administrator Secretary Personal Assistant Receptionist Admin Assitant Data Entry Clerk

This bundle course has been designed to give our learners a more in-depth understanding of general office procedures, codes of practice and required skills. It provides essential training on the Microsoft Office Suite for managing everyday clerical tasks and is ideal for entry-level learners. Fast track your career and be equipped with the skills and knowledge to manage everyday office tasks efficiently with the Admin, Secretarial & PA Diploma. This comprehensive course is a general introduction to office procedures and practices, exploring the basics of administrative management and admin support. You will develop essential business writing skills, improve your telephone etiquette, learn how to communicate professionally with clients and much more. This course also includes step-by-step guidance on Microsoft Word. Master Microsoft Office suite and boost your efficiency in general administrative tasks with the Microsoft Office Applications Training course. This introductory program is ideal for beginners who have little or no experience with Office programs. You will be guided step-by-step on how to use Word, Excel, PowerPoint, Outlook and Access. On completion, you will be able to create professional slideshow presentations, automate tasks, analyse numerical data and much more. Enrol today and add valuable transferable skills to your CV. Learning Outcomes: Gain a solid understanding of administrative management and admin support Learn the fundamental principles of business writing and improve your telephone etiquette Learn how to communicate effectively and develop your body language skills Familiarise with the day-to-day responsibilities of an administrative assistant, secretary & PA Get tips on how to organise your workload and manage your time efficiently Master Microsoft Office programs - Word, Excel, Powerpoint, Outlook & Access Share documents, automate tasks, analyse data, create slideshows & much more Gain valuable transferable skills to boost your professional development Be able to customise the user interface to your desire Discover time-saving techniques, tips & shortcuts to work faster and more efficiently Who is This Course for? This bundle course is ideal for anyone who wishes to boost their professional development in an office-based role. This training program is particularly suitable for those who are new to their profession and wish to gain the skills and knowledge to prepare them for their career. Method of Assessment: Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path On successful completion, learners will have a solid understanding of fundamental office procedures and practices, and will be equipped with the skills to pursue the following roles: Office Administrator Secretary Personal Assistant Receptionist Admin Assitant Data Entry Clerk

Ever wondered how the legal world really works behind the scenes? Whether you're helping draft documents, managing court dates, or keeping solicitors one step ahead, roles like paralegal or legal secretary are essential. This course walks you through the nuts and bolts of legal support work and the everyday skills needed in a legal office—from legal terms and document prep to professional communication and time management. It doesn’t fluff things up—it gets straight to what you need to know to confidently support a legal team from your desk. The UK legal support sector continues to grow, with more firms looking for office-based staff who can handle the pace and precision of the legal environment. This course also includes an easy-to-follow career guide with helpful insights into different job routes and what they typically pay. Whether you’re exploring legal admin for the first time or switching from another office-based role, this is a smart step into a well-structured profession with a strong future. And no, you won’t need a wig or gown—just an eye for detail and a willingness to learn. Key Features: CPD Certified Paralegal, Legal Secretary and Office Skills With Complete Career Guide 10 Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum: Module 01: Introduction to Legal Secretary Module 02: English Law & Legal Systems Module 03: The Legal Workplace & Professionals Module 04: Law of Contract & Law of Tort Module 05: Wills, Probate and Estate Law Practice Module 06: Property Law & Conveyancing Practice Module 07: Family Law and Insurance Practice Module 08: Professional Writings and Documents Module 09: Document Proofreading and Editing Module 10: Meeting Management & Minute Taking Module 11: Customer Service and Telephone Handling Skills Module 12: Data Management and Record-Keeping Module 13: Other Essential Skills for Secretarial Role Module 14: Professional Conduct and Ethics Module 15: Microsoft Word Essentials Module 16: Microsoft Powerpoint Essentials Module 17: Microsoft Outlook Essentials Module 18: Microsoft Excel - Top 50 Keyboard Shortcuts ________________________________________________________________________ Complete Career Guide for Paralegal, Legal Secretary and Office Skills (A to Z) This isn't just a course; it's your ticket to thriving in the sector and your roadmap to the Legal Secretary. In addition to mastering the essentials of Legal Secretary, you'll also gain valuable skills in CV writing, job searching, communication, leadership, and project management. These 9 complementary courses are designed to empower you at every stage of your journey. Stand out in your career, from crafting a winning CV to excelling in interviews. Develop the leadership skills to inspire your team and efficiently manage projects. This holistic approach ensures you're not just job-ready but career-ready. Enrol today, and let's build your success story together in Health and Legal Secretary. Your dream career starts here! List of career guide courses included in Paralegal, Legal Secretary and Office Skills With Complete Career Guide: Course 01: Professional CV Writing and Job Searching Course 02: Communication Skills Training Course 03: Career Development Training Course 04: Time Management Course 05: Returning to Work Training Course 06: Level 3 Diploma in Project Management Course 07: Leadership Skills Course 08: Body Language Course 09: Interview and Recruitment ________________________________________________________________________ Learning Outcomes: Understand the role and responsibilities of a legal secretary. Gain knowledge of English law, legal systems, and workplace dynamics. Master contract, tort, property, family law, and insurance practices. Develop proficiency in drafting professional documents and proofreading. Acquire essential office skills, including meeting management and minute-taking. Demonstrate competence in using Microsoft Office applications for legal tasks. Accreditation All of our courses, including the Paralegal, Legal Secretary and Office Skills With Complete Career Guide course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Paralegal, Legal Secretary and Office Skills With Complete Career Guide, you will immediately be sent your digital certificates. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we recommend renewing them every 12 months. Assessment At the end of the courses, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring to become legal secretaries or paralegals. Those seeking a comprehensive understanding of legal practices in the UK. Professionals looking to enhance their office and document management skills. Anyone interested in a career involving customer service and legal support. Individuals aiming to boost their employability in legal administrative roles. Requirements There are no formal requirements for this bundle courses to be enrolled. Career path Legal Secretary - £22K to 35K/year. Paralegal - £24K to 40K/year. Office Administrator - £20K to 30K/year. Customer Service Representative - £18K to 25K/year. Document Specialist - £25K to 35K/year. Certificates 10 CPD Accredited e-Certificates Digital certificate - Included 10 CPD Accredited Hard Copy Certificates Hard copy certificate - Included

Microsoft office is used for documentation, writing, and many other activities. It brings a new dimension to this technology-based competitive world. It has vivid functions and much more use. If you want to learn all its advanced functions, look at our Microsoft Office 2016 Advanced course. This course introduces to the function of ribbon that incorporates many tabs such as Insert, design, animation, slides, show, review, and home. It also guides you step by step how to insert a picture, change design lay order, add a hyperlink, watch video from youtube, create CV, cash memo, payment sleep, many more things. Overall the course teaches you all the efficient use of Microsoft Office to be expert in it. Who is this Course for? Microsoft Office 2016 Advanced is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Microsoft Word 2016 Modify User Information 00:15:00 Share a Document 00:30:00 Work with Comments 00:15:00 Compare Document Changes 00:15:00 Review a Document 00:15:00 Merge Document Changes 00:15:00 Coauthor Documents 00:15:00 Add Captions 00:15:00 Add Cross-References 00:15:00 Add Bookmarks 00:15:00 Add Hyperlinks 00:15:00 Insert Footnotes and Endnotes 00:15:00 Add Citations 00:30:00 Insert a Bibliography 00:15:00 Insert Blank and Cover Pages 00:15:00 Insert an Index 00:30:00 Insert a Table of Contents 00:30:00 Insert an Ancillary Table 00:15:00 Manage Outlines 00:30:00 Create a Master Document 00:30:00 Suppress Information 00:30:00 Set Editing Restrictions 00:30:00 Add a Digital Signature to a Document 00:15:00 Restrict Document Access 00:15:00 Create Forms 00:30:00 Manipulate Forms 00:15:00 Form Data Conversion 00:15:00 Create a New Document Version 00:30:00 Compare Document Versions 00:15:00 Merge Document Versions 00:15:00 Activities - Microsoft Word 2016 Advanced 00:00:00 Microsoft Excel 2016 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Integrate Excel Data with the Web 00:15:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Microsoft PowerPoint 2016 Customize the User Interface 01:30:00 Set PowerPoint 2016 Options 00:45:00 Create and Manage Sections 01:00:00 Modify Slide Masters and Slide Layouts 01:15:00 Add Headers and Footers 00:30:00 Modify the Notes Master and the Handout Master 00:45:00 Create SmartArt 00:45:00 Modify SmartArt 01:00:00 Add Audio to a Presentation 00:45:00 Add Video to a Presentation 01:00:00 Customize Animations and Transitions 01:00:00 Add Comments to a Presentation 00:45:00 Review a Presentation 00:45:00 Store and Share Presentations on the Web 01:30:00 Annotate a Presentation 00:45:00 Set Up a Slide Show 00:45:00 Create a Custom Slide Show 00:30:00 Add Hyperlinks and Action Buttons 00:45:00 Record a Presentation 00:15:00 Secure a Presentation 01:30:00 Present a Slide Show Online 01:00:00 Create a Video or a CD 00:45:00 Activities - Microsoft PowerPoint 2016 Advanced 00:00:00 Microsoft Outlook 2016 Insert Advanced Characters and Objects 01:30:00 Modify Message Settings, Properties, and Options 01:30:00 Use Automatic Replies 01:30:00 Sort Messages 00:45:00 Filter Messages 01:00:00 Organize Messages 02:00:00 Search Messages 01:30:00 Manage Junk Mail 01:00:00 Manage Your Mailbox 02:00:00 Manage Advanced Calendar Options 00:45:00 Manage Additional Calendars 01:00:00 Manage Meeting Responses 00:45:00 Assign and Manage Tasks 01:00:00 Edit an Electronic Business Card 01:00:00 Manage Advanced Contact Options 01:30:00 Forward Contacts 00:30:00 Export Contacts 01:00:00 Delegate Access to Mail Folders 01:00:00 Share Your Calendar 00:30:00 Share Your Contacts 00:15:00 Back Up Outlook Items 00:45:00 Change Data File Settings 00:45:00 Configure E-mail Message Security Settings 00:30:00 Activities - Microsoft Outlook 2016 Advanced 00:00:00 Microsoft Access 2016 Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Mock Exam Mock Exam - Microsoft Office 2016 Advanced 00:20:00 Final Exam Final Exam - Microsoft Office 2016 Advanced 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

This Microsoft Office 2007 Excel Intermediate will provide you with experience at creating more elaborate worksheet and workbooks n Microsoft Office Excel 2007 to display data in more effective ways. In this series you will work with multiple worksheets and workbooks, you will learn how to switch between workbooks and even copy worksheets, you will also get 3D formulas: 3D formulas will allow you to link the worksheets, and also add something call the Watch-Window. You will learn to create and manage all these linked workbooks as well as creating workspaces which will allow you to manage the workbook as well. Before getting this course you must have the basic skills of Microsoft Excel 2007. This level will give you an advanced knowledge you need to know about Microsoft Excel. Who is this Course for? Microsoft Office 2007 Excel Intermediate is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Course Curriculum Using Multiple Worksheets and Workbooks Using Multiple Workbooks 00:04:00 Linking Worksheets with 3-D Formulas 00:06:00 Linking Workbooks 00:11:00 Managing Workbooks 00:04:00 Advanced Formatting Using Special Number Formats 00:17:00 Using Functions to Format Text 00:13:00 Working with Styles 00:07:00 Working with Themes 00:11:00 Other Advanced Formatting 00:13:00 Outlining and Subtotals Outlining and Consolidating Data 00:11:00 Creating Subtotals 00:06:00 Cell and Range Names Creating and Using Names 00:12:00 Managing Names 00:04:00 Lists and Tables Examining Lists 00:03:00 Sorting and Filtering Lists 00:07:00 Advanced Filtering 00:12:00 Working with Tables 00:22:00 Web and Internet Features Saving Workbooks as Web Pages 00:11:00 Using Hyperlinks 00:04:00 Distributing Workbooks 00:03:00 Advanced Charting Chart Formatting Options 00:08:00 Combination Charts 00:05:00 Graphic Elements 00:09:00 Documenting and Auditing Auditing Features 00:05:00 Creating A Body Of Work 00:03:00 Protection 00:05:00 Workgroup Collaboration 00:13:00 Templates and Settings Application Settings 00:05:00 Built-in Templates 00:07:00 Creating and Managing Templates 00:10:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before ***Best Deal of the Market. Offer Ends Today*** In today's fast-paced business world, administrative roles require diverse skills to thrive and succeed. Our Complete Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) course equips you with the essential knowledge and abilities needed to excel in the field. Whether you're an entry-level professional seeking to kickstart your career or an experienced administrator looking to upskill, this course is your pathway to success. The Complete Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) now comes to you accompanied by a 7 Premium Courses Bundle. Enrol now in this Microsoft Office Complete bundle & get access to the following Office Skills: Admin, Secretarial & PA (Executive PA) with Microsoft Office courses: Course 01: Microsoft Office Skills (Word, Powerpoint, Microsoft Excel) - CPD Certified Course 02: Admin, Secretarial & PA at QLS Level 7 Course 03: Legal Secretary Course 04: UK Employment Law Course 05: Organisational Skills Course for Administrator Course 06: GDPR Course 07: Communication Skills Our Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 course is endorsed by The Quality Licence Scheme & accredited by CPDQS (with 250 CPD points) to make your skill development & career progression more accessible than ever! This Complete Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) course can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Student Testimonials - What Our Students Say! ''Comprehensive course on Microsoft Office and administrative skills. Highly recommended!'' Reviewed by Walker ''Great Course and great Customer service. Very Informative'' Reviewed by Bab ''Excellent content. Very well explained. Certainly recommended.'' Reviewed by Denis Jackson Microsoft Office Skills (Excel, Word, Access) with Admin, Secretarial & PA Why Choose Our Office Skills: Admin, Secretarial & PA (Executive PA) Course: Get instant access to this Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) course. Learn Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) essentials from anywhere in the world Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) Course is affordable and simple to understand Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) Course is entirely online, interactive lesson with voiceover audio Lifetime access to the Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) materials Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) comes with 24/7 tutor support. CPD 220 CPD hours / points Accredited by CPD Quality Standards Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 (Promo Videos) 13:54 1: Introduction Video Preview 01:10 2: Introduction Preview 02:58 3: Excel Overview Preview 05:20 4: Start Excel Spreadsheet Preview 04:26 Module 01 - Introduction to Personal Assistant 10:33 5: Introduction to Personal Assistant Preview 10:33 Module 02 - Introduction to Office Administration 07:17 6: Introduction to Office Administration 07:17 Module 03 - Skills of an Effective Administrator 09:19 7: Skills of an Effective Administrator 09:19 Module 04 - Introduction to Reception and Receptionist 14:09 8: Introduction to Reception and Receptionist 14:09 Module 05 - Business Telephone Skills 11:04 9: Business Telephone Skills 11:04 Module 06 - Representing Your Boss and Company 23:02 10: Representing Your Boss and Company 23:02 Module 07 - Business Etiquette 11:26 11: Business Etiquette 11:26 Module 08 - Mail Services and Shipping 17:15 12: Mail Services and Shipping 17:15 Module 09 - Travel Arrangements 14:20 13: Travel Arrangements 14:20 Module 10 - Organising Meeting and Conferences 17:24 14: Organising Meeting and Conferences 17:24 Module 11 - Diary Management and Note taking 14:56 15: Diary Management and Note taking 14:56 Module 12 - Time Management 23:16 16: Time Management 23:16 Module 13 - Record Keeping and Filing Systems 17:30 17: Record Keeping and Filing Systems 17:30 Module 14 - Business Writing Skills 28:36 18: Business Writing Skills 28:36 Module 15 - Organisational Skills 17:06 19: Organisational Skills 17:06 Module 16 - Communication Skills 16:21 20: Communication Skills 16:21 Module 17 - Customer Service 09:54 21: Customer Service 09:54 Module 18 - Effective Planning and Scheduling 33:19 22: Effective Planning and Scheduling 33:19 Module 19 - Invoicing/Petty Cash 18:39 23: Invoicing/Petty Cash 17:39 24: Final Words 01:00 Assessment (Optional) 02:00 25: Assignment on- Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 02:00 Order Your Certificate 02:00 26: Order Your CPD Certificate 01:00 27: Order Your QLS Endorsed Certificate 01:00 Free Course No 01: Legal Secretary 4:00:14 28: Module 01: Understanding the Concept of Paralegal 14:11 29: Module 02: Key Legal Terminology 10:47 30: Module 03: Effective Communication Skills for Paralegals 22:43 31: Module 04: The Legal Workplace & Professionals 28:06 32: Module 05: Law & Legal Systems 22:59 33: Module 06: Contract & Business Law 34:56 34: Module 07: Property Law 11:50 35: Module 08: Wills, Probate, Estate Law 07:59 36: Module 09: Criminal Law 16:32 37: Module 10: Common Paralegal Legal Matters 23:34 38: Module 11: Human Rights 09:56 39: Module 12: Conflict and Conflict Resolution 13:16 40: Module 13: Professional Conduct and Ethics of Paralegals 15:03 41: Module 14: Mandatory Knowledge Fields and Survival Tips for Paralegals 08:22 Free Course No 02: GDPR 1:04:50 42: Module 01: GDPR Basics 10:32 43: Module 02: GDPR Explained 09:51 44: Module 03: Lawful Basis for Preparation 14:13 45: Module 04: Rights and Breaches 14:04 46: Module 05: Responsibilities and Obligations 16:10 Free Course No 03: UK Employment Law 3:23:15 47: Module 01: Basic of Employment Law 16:18 48: Module 02: Legal Recruitment Process 26:45 49: Module 03: Employment Contracts 14:06 50: Module 04: Employee Handbook 13:03 51: Module 05: Disciplinary Procedure 13:56 52: Module 06: National Minimum Wage & National Living Wage 21:58 53: Module 07: Parental Right, Sick Pay & Pension Scheme 31:14 54: Module 08: Discrimination in the Workplace 27:43 55: Module 09: Health & Safety at Work 10:21 56: Module 10: Dismissal, Grievances and Employment Tribunals 20:52 57: Module 11: Workplace Monitoring & Data Protection 06:59 Free Course No 04: Organisational Skills Course for Administrator 43:28 58: Module 01: Remove the Clutter 05:41 59: Module 02: Prioritise 04:16 60: Module 03: Scheduling Your Time 04:21 61: Module 04: To Do Lists 03:35 62: Module 05: Paper and Paperless Storage 04:26 63: Module 06: Organisation in Your Work Area 04:05 64: Module 07: Tools to Fight Procrastination 04:22 65: Module 08: Organizing Your Inbox 04:21 66: Module 09: Avoid the Causes of Disorganization 04:18 67: Module 10: Discipline is the Key to Stay Organized 04:03 Who is this course for? Microsoft Office Skills (Excel, Word, Access) Anyone interested in learning more about the topic is advised to take this Microsoft Office Skills (Excel, Word, Access) with Admin, Secretarial & PA course. This Microsoft Office Skills (Excel, Word, Access) with Admin, Secretarial & PA course is open to everybody. Requirements Microsoft Office Skills (Excel, Word, Access) Anyone interested in learning more about the topic is advised to take this Microsoft Office Skills (Excel, Word, Access) with Admin, Secretarial & PA course. This Microsoft Office Skills (Excel, Word, Access) with Admin, Secretarial & PA course is open to everybody. Our Microsoft Office Skills (Excel, Word, Access) with Admin, Secretarial & PA Course is suitable for anyone interested in: Microsoft Office Specialist (MOS) Microsoft Office Specialist (MOS) Expert Microsoft Office Specialist (MOS) Master Microsoft Specialist certification in Office 365 MS Office User Touch Typing Worker Career path Microsoft Office Skills (Excel, Word, Access) The Microsoft Office Skills (Excel, Word, Access) course teaches you essential skills to help you be more productive in your career. Our Course is suitable for the following: Office Administrator Data Analyst HR Admin Microsoft Office Specialist Receptionist Audio Typist Certificates CPD Accredited Digital Certificate Digital certificate - Included Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 Hard copy certificate - £139 Please note that International students have to pay an additional £10 as a shipment fee.