3800 Office Skills courses

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

The Office Administrator Skills for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Office Administrator Skills consists of several modules that take around 3 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why Choose this Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full tutor support on weekdays Course Design 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 Certification 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. Course Content Module 01: Introduction to Office Administration Introduction to Office Administration 00:16:00 Module 02: Skills of an Effective Administrator Skills of an Effective Administrator 00:16:00 Module 03: What are Soft Skills? What are Soft Skills 00:10:00 Module 04: Communication Communication 00:08:00 Module 05: Teamwork Teamwork 00:07:00 Module 06: Problem-Solving Problem-Solving 00:08:00 Module 07: Time Management Time Management 00:08:00 Module 08: Attitude and Work Ethic Attitude and Work Ethic 00:08:00 Module 09: Adaptability/Flexibility Adaptability/Flexibility 00:08:00 Module 10: Self-Confidence (Owning It) Self-Confidence (Owning It) 00:09:00 Module 11: Ability to Learn from Ability to Learn from 00:08:00 Module 12: Networking Networking 00:08:00 Module 13: Negotiation Techniques Negotiation Techniques 00:17:00 Module 14: Conflict Management Conflict Management 00:15:00 Module 15: Stress Management Stress Management 00:17:00 Mock Exam Mock Exam - Office Administrator Skills 00:20:00 Final Exam Final Exam - Office Administrator Skills 00:20:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Learn to use Excel’s most powerful features on this 2-day advanced Excel training course. This course is hands-on. It includes plenty of time to experiment with what you are being taught and ask questions. By the time you finish, you’ll be an expert Excel user.  ✔ A complete course that covers all of Excel’s most advanced functions.  ✔ Friendly expert trainers, small groups and a comfortable place to learn.  ✔ Ongoing support & help with any issues you may have after the course. Our courses are delivered in Guildford, London, Online, or even on-site at your offices!

Are you looking to expand your skillset and excel in an administrative role? Our Secretarial & Shorthand online course provides you with the comprehensive training you need to become a successful personal assistant, admin support assistant, or office manager. Learning Outcomes of Secretarial & Shorthand Bundle Develop effective communication and interpersonal skills. Manage time efficiently and prioritise Secretarial & Shorthand tasks Maintain records and manage data in an organised manner Coordinate and organise meetings and conferences Write professional business emails and letters Provide excellent Secretarial & Shorthand service Arrange travel plans and itineraries Perform financial tasks such as invoicing and petty cash management This Secretarial & Shorthand course is perfect for anyone who wants to learn new skills or for those who want to update their knowledge in the field. Plus, with the flexibility of online learning, you can study at your own pace and on your own schedule. Upon completing the course, you'll receive a certificate of achievement indicating your proficiency in Secretarial & Shorthand. Furthermore, to help you showcase your expertise in Secretarial & Shorthand Training, 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 Secretarial & Shorthand Training Bundle Consists of the following Premium courses: Course 01: Secretarial & Shorthand Course 02: Admin, Secretarial & PA - Level 7 Course 03: Online Meeting Management Course 04: Professional Telephone Receptionist Course Course 05: Document Control Course 06: GDPR Data Protection Level 5 Course 07: Business Writing Course 08: Report Writing Course 09: Touch Typing Essentials Course 10: Customer Relationship Management Course 11: Email Writing Training Course 12: Public Speaking and Presentation Skill Course Course 13: Effective Communication Skills Course 14: Time Management Key features of this Secretarial & Shorthand course: This Secretarial & Shorthand bundle is CPD QS Accredited Learn from anywhere in the world Lifetime access Secretarial & Shorthand is entirely online 24/7 Learner support Enrol now in Secretarial & Shorthand Training to advance your career, and use the premium study materials from Apex Learning. The Secretarial & Shorthand bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Secretarial & Shorthand Training expertise and essential knowledge, which will assist you in reaching your goal. Course Curriculum of Secretarial & Shorthand Bundle: Course 01: Secretarial & Shorthand Module 01: Introduction to Minute Writing Module 02: Preparation for Minute Taking Module 03: The Meeting Structure Module 04: Minute Meeting, Decision and Action Module 05: Roles and Responsibility of Minute Taker Module 06: Tips for Minute Taking Module 07: Technology in Minute Taking Module 08: Building Confidence -------------- 13 additional Secretarial & Shorthand courses------------- How will I get my Secretarial & Shorthand Certificate? After successfully completing the Secretarial & Shorthand course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Secretarial & Shorthand Training bundle. Requirements Our Secretarial & Shorthand Training course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Secretarial & Shorthand Training expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course Admin, Secretarial & PA - Level 7 absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course Admin, Secretarial & PA - Level 7 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.

Any member of administration can only work effectively if they condition themselves to operate in an orderly and prepared fashion. By taking this course, you'll become aware of how to tidy your work area and prioritise your tasks. As you're taught how to schedule your time efficiently, make to-do lists, and fight procrastination, you'll find yourself becoming a naturally organised person and able to multitask efficiently without making mistakes or having to repeat tasks and becoming an invaluable administrator.  Learning Outcomes Learn how to organise your work life and also your personal life Develop your organisational skills in a structured manner Overcome your habitual procrastination Benefit from scheduling your workflow Maintain an efficient and tidy work area Prioritise your tasks accordingly Perform excellent time management Create to-do lists and update check lists Multitask without dropping standards or quality Why Choose this Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design 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 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.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. 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 In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Who is this Course for?  As organising comes in handy in every sphere of life, anybody can benefit from this course. This course is a one-stop solution for anyone looking to improve their organisational skills to enhance their expert life.  Career Path The course is suitable for those in the roles of; Executive Personal Assistant Secretary Administrator Receptionist Entrepreneur Executive/ Associate/ Manager of any department of an office Personal/ Business Assistant Requirements This Organisational Skills Course is fully compatible with any kind of device. Whether you are using Windows computer, 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. Course Content Organisational Skills Module One - Getting Started 00:30:00 Module Two - Remove the Clutter 01:00:00 Module Three - Prioritize 01:00:00 Module Four - Scheduling Your Time 01:00:00 Module Five - To Do Lists 01:00:00 Module Six - Paper and Paperless Storage 01:00:00 Module Seven - Organization in Your Work Area 01:00:00 Module Eight - Tools to Fight Procrastination 01:00:00 Module Nine - Organizing Your Inbox 01:00:00 Module Ten - Avoid the Causes of Disorganization 01:00:00 Module Eleven - Discipline is the Key to Stay Organized 01:00:00 Module Twelve - Wrapping Up 00:30:00 Assignment Assignment - Organisational Skills 3 weeks, 3 days Order Your Certificate Order your Certificate QLS 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Office and Reception Management Certification It takes specific skills and an understanding of the dynamics of people, in order to efficiently run an office. This Office & Reception Management Certificate course is designed to provide an employee with those exact skills. Demonstrating organisational competence in this field opens doors to advancing an employee's career in the business. This programme consists of 18 modules, designed to provide an insight into what is expected from a person working in an office environment. The industry-approved certificate provides the employee with confidence-building skills, to enable them to move up in their career. What's Covered in the Course? The 18 modules cover both office management and interpersonal problem-solving skills, as well as providing insight into the way in which the employee tends to react in these situations. The office receptionist performs a vital role as the 'face of the business', creating a first impression that influences visitors' perceptions of the organisation's culture. Communication skills, teamwork and office administrative systems, basic financial management - managing petty cash and office supplies - are also included, as well as the planning and scheduling of meetings, minute-taking and report-writing. As the person in this position usually deals with colleagues at all levels of the organisation, it is important that they understand managerial issues and responsibilities. Performance management and appraisals, staff promotions, recruitment and selection and compliance with equal opportunities and diversity in the workplace legislation are all covered, together with the importance of good health and safety practices. The use - and abuse - of social media and its role in the office environment brings the learner up-to-date with the current thinking in this field. The team member will learn: How to handle staff and understand their performance; The legal side of various policies and health and safety; Communication; How to deal with customers and colleagues; Financial aspects: petty cash and office supplies; Office layouts; The art of delegation; Social media; How to handle meetings, including chairing them. What are the Benefits of the Course? There are a number of clear benefits of completing this Office & Reception Management certificate, including: A professional front-line receptionist improves the image of your business; The ability to study at the employee's pace and in the comfort of their own home; Easy internet-based access to study material on any device; Short, sharp, structured organisation of learning materials; Industry-approved certification.

Significance of Good Housekeeping at Work Certification Everybody is by all accounts mindful of their commitment to keep a working environment clean. This is the reason organization proprietors regularly employ experts to scour workplaces around evening time or go through intermittent closures. In any case, great housekeeping at work requires significantly more than essentially utilizing cleaning items. It likewise implies keeping your own workspace liberated from hindrances and garbage that could cause trips or different risks. Rehearsing great housekeeping at work guarantees that the work environment is more secure and as liberated from wounds as could be expected. This course expounds on the significance of rehearsing great housekeeping at work, while likewise giving you directions on the best way to do as such. We start by evaluating what helpless housekeeping is, just as featuring the dangers implied with working in that sort of climate. We additionally audit the critical advantages of utilizing great housekeeping systems at work. Then, we examine why you need to build up a housekeeping program paying little heed to your industry. At long last, we survey why you need to assess your housekeeping endeavors on a progressing premise. You Will Learn: How helpless housekeeping places you and others in your working environment in danger Instances of helpless housekeeping, including normal errors made by numerous organizations How utilizing great housekeeping abilities can build profitability and diminish the quantity of days off taken The things that numerous individuals ignore when building up a housekeeping program The means you can take to guarantee that your working environment stays clean Advantages of Taking This Course Having the option to appreciate a more secure working environment, as liberated from risks as is feasible for your industry Understanding the job representatives play in keeping zones perfect, flawless and liberated from trash Figuring out how to stay away from normal mix-ups made when executing housekeeping strategies Understanding that great housekeeping is a continuous assignment, not something that you just need to stress over once Figuring out how to urge your representatives to keep their space perfect and liberated from flotsam and jetsam

Agenda Setting Certification A plan is basically a gathering plan that diagrams key things and subjects to be talked about, and in what request. Contingent upon the motivation behind the gathering and nature of your business, the plan might be basic, containing a couple of things, or it could be more inside and out. The principle objective, in any case, is consistently something very similar - to illuminate and plan meeting members ahead of time, and to guarantee a smooth gathering measure. This course will give an outline of plan setting, why it's significant, how to make a compelling plan, just as how to utilize a plan to run a fruitful gathering. You Will Learn: About the capacity of plan setting Why plan setting is significant The most effective method to make an all around arranged plan Instructions to utilize a plan to run a more compelling gathering Advantages of Taking This Course: You will better comprehend the job plan setting plays in planning for a gathering You will figure out how an all around arranged plan can profit the coordinator and members of a gathering Your insight into plan setting will outfit you with the apparatuses expected to lead more beneficial and successful gatherings You will actually want to guarantee that colleagues are solid and steady and urged to join in

Introduction: Employees work better and more efficiently when their workspaces are well laid out. On the other hand, offices that are cluttered or chaotic tend to promote similar working environments. This principle extends beyond the workstation into how the office itself is organized. A well planned office leads to greater productivity with fewer interruptions and less time wasted each day. As a result, it is well worth your time to learn more about how to plan for the perfect office for your company's needs. This course gives you detailed information about how to properly plan your office layout. We begin by talking about the layout of an office in general terms. Next, we move on to talk about the individual considerations you need to remember when planning your next office layout. We also review the principles of office layout, giving you more information you can use to properly plan your own. Finally, we talk about factors that may affect your own office layout plan.   What You Will Learn: The objectives you should keep in mind when thinking about your office's floor plan The benefits of paying attention to office layout The individual factors that go into creating a well-organised office What the principles of office layout are The factors that go into how you should lay out your office Benefits of Taking This Course: Learning how to create a workspace that is functional as well as attractive Understanding how an office layout can have such an impact on employees Understanding why you should think about the physical location of the building as well as how it is laid out inside Learning how to create a workspace that is comfortable as well as efficient for each one of your employees Learning how to consider your company's needs in light of the available space when planning out an office Course Modules: Module 01: The Office Layout Module 02: The Principles and Importance of an Office Layout Module 03: Factors Affecting Office Layout Module 04: The Most Popular Types of Office Layout

Office Etiquette Certification Understanding the implicit principles of the working environment will expand your opportunity of getting an advancement. Office decorum guarantees that everybody profits by a charming working climate liberated from provocation and uncivil conduct. In this course, you will become familiar with the major office manners that everybody needs to follow. You will find how to introduce yourself at work, how to communicate with others, how to determine troubles, and how to construct a standing as a significant colleague. You Will Learn: Step by step instructions to show thought for others' time The most effective method to be a decent cooperative person The most effective method to keep an expert picture at work The most effective method to send suitable messages Step by step instructions to behave at office parties and other unique occasions Advantages of Taking This Course: On the off chance that you need to progress in your profession, a sound handle of office manners is fundamental On the off chance that you oversee or direct others at work, this course will help you show others how its done In the event that you are liable for assembling official approach archives at work, this course will help you cover rules relating to office lead This course will help you construct positive associations with your colleagues, which will make your work life more pleasant