3451 Office Skills & Productivity courses in Mansfield delivered Online

Overview Learn how to become a valued financial expert and instantly boost your career prospects in any high-performing business. This Sage 50 Training course offers you all the training you will need to take a Payroll Administrator's role and establish your skills with Sage software. By becoming skilled in using Sage 50, you will be able to perform all the responsibilities and tasks assigned to a senior member of a company's fiscal department. So, you will be taught how to process employee payments, NIC contributions, calculate tax year-end figures and reports, and much more. You will also be familiarised with the UK payroll legislation. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Sage 50 Diploma. It is available to all students, of all academic backgrounds. Requirements Our Sage 50 Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 41 sections • 40 lectures • 07:03:00 total length •Module 1: Payroll Basics: 00:10:00 •Module 2: Company Settings: 00:08:00 •Module 3: Legislation Settings: 00:07:00 •Module 4: Pension Scheme Basics: 00:06:00 •Module 5: Pay Elements: 00:14:00 •Module 6: The Processing Date: 00:07:00 •Module 7: Adding Existing Employees: 00:08:00 •Module 8: Adding New Employees: 00:12:00 •Module 9: Payroll Processing Basics: 00:11:00 •Module 10: Entering Payments: 00:12:00 •Module 11: Pre-Update Reports: 00:09:00 •Module 12: Updating Records: 00:09:00 •Module 13: e-Submissions Basics: 00:09:00 •Module 14: Process Payroll (November): 00:16:00 •Module 15: Employee Records and Reports: 00:13:00 •Module 16: Editing Employee Records: 00:07:00 •Module 17: Process Payroll (December): 00:12:00 •Module 18: Resetting Payments: 00:05:00 •Module 19: Quick SSP: 00:09:00 •Module 20: An Employee Leaves: 00:13:00 •Module 21: Final Payroll Run: 00:07:00 •Module 22: Reports and Historical Data: 00:08:00 •Module 23: Year-End Procedures: 00:09:00 •Module 01: The Outline View and Criteria: 00:11:00 •Module 02: Global Changes: 00:07:00 •Module 03: Timesheets: 00:12:00 •Module 04: Departments and Analysis: 00:11:00 •Module 05: Holiday Schemes: 00:10:00 •Module 06: Recording Holidays: 00:12:00 •Module 07: Absence Reasons: 00:13:00 •Module 08: Statutory Sick Pay: 00:16:00 •Module 09: Statutory Maternity Pay: 00:17:00 •Module 10: Student Loans: 00:09:00 •Module 11: Company Cars: 00:13:00 •Module 12: Workplace Pensions: 00:21:00 •Module 13: Holiday Funds: 00:13:00 •Module 14: Process Payroll (November): 00:11:00 •Module 15: Passwords and Access Rights: 00:08:00 •Module 16: Options and Links: 00:10:00 •Module 17: Linking Payroll to Accounts: 00:08:00

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

Plan, deploy and monitor cloud solutions in Microsoft Azure's Infrastructure as a Service

Overview This Improve Your Body Confidence course will unlock your full potential and will show you how to excel in a career in Improve Your Body Confidence. So upskill now and reach your full potential. Everything you need to get started in Improve Your Body Confidence is available in this course. Learning and progressing are the hallmarks of personal development. This Improve Your Body Confidence will quickly teach you the must-have skills needed to start in the relevant industry. In This Improve Your Body Confidence Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Improve Your Body Confidence skills to help you advance your career. Acquire a comprehensive understanding of various Improve Your Body Confidence topics and tips from industry experts. Learn in-demand Improve Your Body Confidence skills that are in high demand among UK employers, which will help you to kickstart your career. This Improve Your Body Confidence course covers everything you must know to stand against the tough competition in the Improve Your Body Confidence field.  The future is truly yours to seize with this Improve Your Body Confidence. Enrol today and complete the course to achieve a Improve Your Body Confidence certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Improve Your Body Confidence course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Improve Your Body Confidence course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Improve Your Body Confidence course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Improve Your Body Confidence is suitable for anyone aspiring to start a career in Improve Your Body Confidence; even if you are new to this and have no prior knowledge on Improve Your Body Confidence, this course is going to be very easy for you to understand.  And if you are already working in the Improve Your Body Confidence field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Improve Your Body Confidence course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Improve Your Body Confidence course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Improve Your Body Confidence course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Improve Your Body Confidence course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Module 01: Positive Body Image 1.1 Positive Body Image 00:20:00 Module 02: Body Respect 2.1. Body Respect 00:19:00 2.2. Body Respect 00:15:00 Module 03: Body Acceptance 3.1. Build Body Acceptance 00:11:00 3.2. Build Body Acceptance 00:13:00 Module 04: Becoming Body Positive 4.1. Becoming Body Positive 00:17:00 4.2. Becoming Body Positive 00:15:00 Module 05: Body Mindfulness 5.1. Body Mindfulness 00:15:00 5.2. Body Mindfulness 00:15:00 5.3. Body Mindfulness 00:15:00 Additional Materials Resource - Improve Your Body Confidence 00:00:00

Course Description Get instant knowledge from this bite-sized Diploma in Personal Assistant and Minute Taking Part - 4 course. This course is very short and you can complete it within a very short time. In this Diploma in Personal Assistant and Minute Taking Part - 4 course you will get fundamental ideas of minute taking, the key understanding of minute meetings, building confidence and so on. Enrol in this course today and start your instant first step towards learning minute meetings, decisions and action. Learn faster for instant implementation. Learning Outcome Understand minute meetings, decisions and action Gain in-depth knowledge of the roles and responsibilities of minute taker Understand the technology in minute taking Learn about some tips for minute taking Know how to build confidence How Much Do Personal Assistants Earn? Senior - £38,000 (Apprx.) Average - £26,000 (Apprx.) Starting - £19,000 (Apprx.) Requirement Our Diploma in Personal Assistant and Minute Taking Part - 4 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Diploma in Personal Assistant and Minute Taking Part - 4 Module 01: Minute Meeting, Decision and Action 00:19:00 Module 02: Roles and Responsibility of Minute Taker 00:27:00 Module 03: Tips for Minute Taking 00:22:00 Module 04: Technology in Minute Taking 00:13:00 Module 05: Building Confidence 00:14:00 Assignment Assignment - Diploma in Personal Assistant and Minute Taking Part - 4 00:00:00

Course Description Get instant knowledge from this bite-sized Diploma in Personal Assistant and Minute Taking Part - 1 course. This course is very short and you can complete it within a very short time. In this Diploma in Personal Assistant and Minute Taking Part - 1 course you will get fundamental ideas of minute taking, the key understanding of business telephone skills, travel arrangements and so on. Enrol in this course today and start your instant first step towards learning about personal assistants. Learn faster for instant implementation. Learning Outcome Familiarise with personal assistant Understand business telephone skills Know how to represent your boss and company Understand the mail services and shipping Learn about travel arrangements Gain an excellent understanding of organising meetings and conferences How Much Do Personal Assistants Earn? Senior - £38,000 (Apprx.) Average - £26,000 (Apprx.) Starting - £19,000 (Apprx.) Requirement Our Diploma in Personal Assistant and Minute Taking Part - 1 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Diploma in Personal Assistant and Minute Taking Part - 1 Module 01: Introduction to Personal Assistant 00:18:00 Business Telephone Skills 00:19:00 Representing Your Boss and Company 00:34:00 Module 04: Mail Services and Shipping 00:25:00 Module 05: Travel Arrangements 00:24:00 Module 06: Organising Meeting and Conferences 00:26:00 Assignment Assignment - Diploma in Personal Assistant and Minute Taking Part - 1 00:00:00

Course Description Get instant knowledge from this bite-sized Diploma in Personal Assistant and Minute Taking Part - 3 course. This course is very short and you can complete it within a very short time. In this Diploma in Personal Assistant and Minute Taking Part - 3 course you will get fundamental ideas of minute taking, the key understanding of minute writing, customer service and so on. Enrol in this course today and start your instant first step towards learning customer service. Learn faster for instant implementation. Learning Outcome Familiarise with minute writing Understand customer service Gain in-depth knowledge of the invoicing Deepen your understanding of effective planning and scheduling Strengthen preparation for minute taking Learn about the meeting structure How Much Do Personal Assistants Earn? Senior - £38,000 (Apprx.) Average - £26,000 (Apprx.) Starting - £19,000 (Apprx.) Requirement Our Diploma in Personal Assistant and Minute Taking Part - 3 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Diploma in Personal Assistant and Minute Taking Part - 3 Module 01: Customer Service 00:16:00 Module 02: Effective Planning and Scheduling 00:47:00 Module 03: Invoicing/Petty Cash 00:27:00 Module 04: Introduction to Minute Writing 00:21:00 Module 05: Preparation for Minute Taking 00:24:00 Module 06: The Meeting Structure 00:17:00 Assignment Assignment - Diploma in Personal Assistant and Minute Taking Part - 3 00:00:00

Course Description Get instant knowledge from this bite-sized Admin, Secretarial and Personal Assistant Part - 1 course. This course is very short and you can complete it within a very short time. In this Admin, Secretarial and Personal Assistant Part - 1 course you will get fundamental ideas of personal assistant, the key understanding of admin support and so on. Enrol in this course today and start your instant first step towards learning about personal assistants. Learn faster for instant implementation. Learning Outcome Familiarise with personal assistant Understand admin support Gain in-depth knowledge of the administrative management Deepen your understanding of organisational skills Learn about telephone etiquette How Much Do Admin Assistants Earn? Senior - £42,000 (Apprx.) Average - £26,000 (Apprx.) Starting - £16,000 (Apprx.) Requirement Our Admin, Secretarial and Personal Assistant Part - 1 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Admin, Secretarial and Personal Assistant Part - 1 Module 01: Personal Assistant 00:18:00 Module 02: Admin Support 00:19:00 Module 03: Administrative Management 00:39:00 Module 04: Organisational Skills 00:25:00 Module 05: Telephone Etiquette 01:07:00 Assignment Assignment - Admin, Secretarial and Personal Assistant Part - 1 00:00:00

Course Description Get instant knowledge from this bite-sized Diploma in Personal Assistant and Minute Taking Part - 2 course. This course is very short and you can complete it within a very short time. In this Diploma in Personal Assistant and Minute Taking Part - 2 course you will get fundamental ideas of minute taking, the key understanding of business writing skills, time management and so on. Enrol in this course today and start your instant first step towards learning how to improve time management. Learn faster for instant implementation. Learning Outcome Familiarise with business writing skills Understand time management Gain in-depth knowledge of organisational skills Understand the record keeping and filing systems Learn about communication skills How Much Do Personal Assistants Earn? Senior - £38,000 (Apprx.) Average - £26,000 (Apprx.) Starting - £19,000 (Apprx.) Requirement Our Diploma in Personal Assistant and Minute Taking Part - 2 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Diploma in Personal Assistant and Minute Taking Part - 2 Module 01: Time Management 00:35:00 Module 02: Record Keeping and Filing Systems 00:28:00 Module 03: Business Writing Skills 00:40:00 Module 04: Organisational Skills 00:25:00 Module 05: Communication Skills 00:25:00 Assignment Assignment - Diploma in Personal Assistant and Minute Taking Part - 2 00:00:00