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

3414 Office Skills & Productivity courses in Peacehaven delivered Online

Diploma in Office Admin and Legal Secretary Skills

1.0(1)

By Alpha Academy

This Diploma in Office Admin and Legal Secretary Skills course is especially suitable for Secretaries and Administrators enthusiastic to work within a legal environment. Throughout the course, you will be introduced to the techniques of becoming a good and efficient Legal Secretary. The course teaches you the fundamentals of the legal system including general duties of a legal secretary, managing meetings, keeping records with a different filing system, developing research skills, managing transcription for judges, etc. You will also learn tips for customer service and how to organize work using Microsoft Word. Finally, the course shows you how the legal system works the courts of the UK including Scotland and Northern Ireland. Course Highlights The price is for the whole course including final exam - no hidden fees Accredited Certificate upon successful completion at an additional cost Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat Diploma in Office Admin and Legal Secretary Skills has been given CPD accreditation and is one of the best-selling courses available to students worldwide. This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you're an individual looking to excel within this field then Diploma in Office Admin and Legal Secretary Skills is for you. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the full CPD accredited qualification. And, there are no hidden fees or exam charges. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at any time. So, why not improve your chances of gaining professional skills and better earning potential. Assessment and Certification At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path Not only does our CPD and CiQ accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. On successful completion of this course, you have the potential to achieve an estimated salary of £22,100. The sky really is the limit. Course Curriculum Admin Support Module One - Getting Started 00:30:00 Module Two - Getting Organized (I) 01:00:00 Module Three - Getting Organized (II) 01:00:00 Module Four - Managing Time 01:00:00 Module Five - Getting It All Done On Time 01:00:00 Module Six - Special Tasks 01:00:00 Module Seven - Verbal Communication Skills 01:00:00 Module Eight - Non-Verbal Communication Skills 01:00:00 Module Nine - Empowering Yourself 01:00:00 Module Ten - The Team of Two 01:00:00 Module Eleven - Taking Care of Yourself 01:00:00 Module Twelve - Wrapping Up 00:30:00 Administrative Management Module One - Getting Started 00:30:00 Module Two - Why Your Office Needs Administrative Procedures 01:00:00 Module Three - Gathering the Right Tools 01:00:00 Module Four - Identifying Procedures to Include 01:00:00 Module Five - Top Five Procedures to Record 01:00:00 Module Six - What to Include in Your Binder (I) 01:00:00 Module Seven - What to Include in Your Binder (II) 01:00:00 Module Eight - Organizing Your Binder 01:00:00 Module Nine - What Not to Include in the Procedure Guide 01:00:00 Module Ten - Share Office Procedure Guide 01:00:00 Module Eleven - Successfully Executing the Guide 01:00:00 Module Twelve - Wrapping Up 00:30:00 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 Organisational Skills Training for Administrator - Activities 00:00:00 Legal Secretary Introduction to Legal Secretary 00:15:00 Role of Legal Secretaries 00:15:00 General Duties and Day-to-Day Operations of a Legal Secretary 00:30:00 Record Keeping 00:30:00 Legal Writing Skills & Proofreading 00:15:00 Research Skills You Need to Know 00:30:00 Transcription, Editing & Correspondence to Judges 00:30:00 Legal System of UK 00:15:00 UK Court System 00:30:00 Meeting Management & Minute Taking Skills Meeting Management 00:15:00 The Role of a Minute-Taker 00:15:00 The Skills of a Minute-Taker 00:30:00 Meeting Agreements 00:15:00 Minute Styles 00:30:00 What Do I Record? 00:30:00 Techniques for Preparing Minutes 00:30:00 The Minute Book 00:15:00 What to include/what to ignore 00:30:00 Motions and Resolutions 00:15:00 Method of recording minutes 00:30:00 Reasons for Meeting 00:30:00 What is a decision? 00:15:00 Minute Taking tips 00:30:00 **Customer Service Role and Telephone Etiquette** Understanding Customer Service Understanding Customer Service 00:17:00 Identifying Customer Expectations 00:06:00 Providing Excellent Customer Service 00:07:00 Focusing on the Customer Focusing on the Customer 00:08:00 Customer Service and the Telephone Customer Service and the Telephone 00:08:00 Handling Complaints Handling Complaints 00:12:00 Enduring Stress Enduring Stress 00:13:00 Business Communication Identifying Basic Communication Techniques 00:09:00 Formal and Informal Communication 00:02:00 Verbal and Non-verbal Communication Describing Verbal and Non-verbal Communication 00:04:00 Understanding Body Language 00:05:00 Making Effective Presentations 00:10:00 Fundamentals of Productive Meetings 00:08:00 Written Communication Written Communication 00:13:00 Electronic Communication Electronic Communication 00:19:00 Communicating with Graphics Creating Graphics for Business Communication 00:04:00 Communicating Static Information 00:03:00 Communicating Dynamic Information 00:03:00 Effectively Working for Your Boss Representing Your Boss 00:06:00 Communicating Your Boss's Decisions 00:03:00 Supporting Your Boss and Colleagues 00:04:00 Building a Partnership with Your Boss 00:13:00 Identifying Goals Identifying Goals 00:10:00 Effective Energy Distribution Energy Distribution 00:09:00 Time Logs 00:11:00 Working with Your Personal Style Personal World View 00:10:00 Strengths 00:09:00 Building Your Toolbox A Building Your Toolbox 00:10:00 Establishing Your Action Plan Establishing Your Action Plan 00:11:00 **Organizing Work Using MS Word** Getting Started with Microsoft Word Understanding the Word Interface 00:05:00 Using the Backstage View 00:07:00 Opening Documents 00:02:00 Navigating Documents 00:04:00 Viewing Documents 00:04:00 Creating Documents 00:03:00 Entering Text 00:02:00 Selecting Text 00:03:00 Saving Documents 00:03:00 Checking Document Compatability 00:02:00 Converting to Updated File Format 00:02:00 Saving As a Different File Format 00:02:00 Understanding Document Properties 00:03:00 Using Versions 00:04:00

Diploma in Office Admin and Legal Secretary Skills
Delivered Online On Demand
£10.99

Level 5 Diploma in Admin, Secretarial & PA - QLS Endorsed

By Kingston Open College

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

Level 5 Diploma in Admin, Secretarial & PA - QLS Endorsed
Delivered Online On Demand19 hours
£105

Primavera P6 for Beginners - QLS Endorsed

By Kingston Open College

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

Primavera P6 for Beginners - QLS Endorsed
Delivered Online On Demand1 hour
£105

Google G Suite Connect and Access

4.3(43)

By John Academy

Description Learn the advanced features of Google G Suit with the Google G Suite Connect and Access course. Google G Suite is the productivity and collaboration tool that is comprised of Google Drive, Google Docs, Slides, Sheets, Gmail, Calendar, Forms, Google Hangouts, Google Plus, and more. The course is split into five sections that show you how to use the five applications of Google G Suit such as Gmail, Google Calendar, Google Forms, Google Hangouts, and Google Plus. At first, you will master how to receive, send and manage the email service of Google. Then, the course shows you how to manage your schedule on Google Calendar. Next, you will know how to create and manage forms by using Google Forms. After that, the course teaches you how to communicate effectively by using Google Hangouts. Finally, the course illustrates the techniques of using the social media platform of Google and helps you to manage your social presence with Google Plus. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Google G Suite Connect and Access is certified by CPD Qualifications Standards and CiQ. This makes it 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. Requirements Our Google G Suite Connect and Access 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. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Lesson 1: Google Gmail TOPIC A Getting Started with Gmail 00:15:00 TOPIC B Sending, Reading, and Replying to Messages 00:15:00 TOPIC C Organizing and Searching Mail 00:15:00 TOPIC D Managing Your Contacts 00:15:00 Lesson 2: Google Calendar TOPIC A Getting Started with Google Calendar 00:15:00 TOPIC B Create and Manage Events 00:15:00 TOPIC C Create Additional Calendars 00:15:00 TOPIC D Sharing Your Calendar 00:15:00 Lesson 3: Google Forms TOPIC A Getting Started with Google Forms 00:15:00 TOPIC B Build Forms 00:15:00 TOPIC C Work with Responses 00:15:00 Lesson 4: Google Hangouts TOPIC A Overview 00:15:00 TOPIC B Messaging and Text Hangouts 00:15:00 TOPIC C Video and Phone Hangouts 00:15:00 TOPIC D Hangouts Chat 00:15:00 Lesson 5: Google Plus TOPIC A Getting Started with Google Plus 00:15:00 TOPIC B Create and Optimize Your Profile 00:15:00 TOPIC C Creating Posts 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Google G Suite Connect and Access
Delivered Online On Demand4 hours 30 minutes
£18

ASP.Net MVC and Entity Framework Course - CPD Certified

4.5(3)

By Studyhub UK

24 Hour Flash Deal **25-in-1 ASP.Net MVC and Entity Framework Mega Bundle** ASP.Net MVC and Entity Framework Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the ASP.Net MVC and Entity Framework package online with Studyhub through our online learning platform. The ASP.Net MVC and Entity Framework bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This ASP.Net MVC and Entity Framework course provides complete 360-degree training on ASP.Net MVC and Entity Framework. You'll get not one, not two, not three, but twenty-five ASP.Net MVC and Entity Framework courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these ASP.Net MVC and Entity Framework courses are yours for as long as you want them once you enrol in this course This ASP.Net MVC and Entity Framework Bundle consists the following career oriented courses: Course 01: ASP.Net MVC and Entity Framework Course 02: Building a TodoMVC Application in Vue, React and Angular Course 03: Code Your Own Drawing Application in Android Studio Course 04: Penetration Testing with OWASP ZAP: Mastery course Course 05: Complete Web Development Course 06: Start Your Career as Web Developer Course 07: PHP Web Development with MySQL Course 08: Learn Spring & Angular Material with a Full Web Application Course 09: Node JS: API Development with Swagger Interface Description Language Course 10: Mobile and Web Development with Ionic & Angular JS Course 11: Web Applications for Specialisation on Development Course 12: Secure Programming of Web Applications Course 13: Web Application Penetration Testing Course 14: Web Design with Adobe XD Course 15: Responsive Web Design Course 16: JavaScript Functions Course 17: jQuery Masterclass Course: JavaScript and AJAX Coding Bible Course 18: C Programming Language Course 19: C++ Programming Course 20: Basics of WordPress Course 21: Flutter & Dart Development Course Course 22: Build Progressive Web Apps with Angular Course 23: Learn How To Create a Web App for iPad Course 24: Diploma in Front-End Web Development Course 25: Bash Scripting, Linux and Shell Programming The ASP.Net MVC and Entity Framework course has been prepared by focusing largely on ASP.Net MVC and Entity Framework career readiness. It has been designed by our ASP.Net MVC and Entity Framework specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The ASP.Net MVC and Entity Framework Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This ASP.Net MVC and Entity Framework bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This ASP.Net MVC and Entity Framework Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into ASP.Net MVC and Entity Framework Elementary modules, allowing our students to grasp each lesson quickly. The ASP.Net MVC and Entity Framework course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive ASP.Net MVC and Entity Framework bundle, you really hit the jackpot. Here's what you get: Step by step ASP.Net MVC and Entity Framework lessons One to one assistance from ASP.Net MVC and Entity Frameworkprofessionals if you need it Innovative exams to test your knowledge after the ASP.Net MVC and Entity Frameworkcourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five ASP.Net MVC and Entity Framework courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your ASP.Net MVC and Entity Framework certificate and transcript on the next working day Easily learn the ASP.Net MVC and Entity Framework skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This ASP.Net MVC and Entity Framework training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in ASP.Net MVC and Entity Framework Requirements To participate in this ASP.Net MVC and Entity Framework course, all you need is - A smart device A secure internet connection And a keen interest in ASP.Net MVC and Entity Framework Career path You will be able to kickstart your ASP.Net MVC and Entity Framework career because this course includes various courses as a bonus. This ASP.Net MVC and Entity Framework is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore ASP.Net MVC and Entity Framework career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

ASP.Net MVC and Entity Framework Course - CPD Certified
Delivered Online On Demand6 days
£279

Public administration, Public Policy & Public Services -CPD Certified

4.7(47)

By Academy for Health and Fitness

Ready to leverage a future in the vast expanse of public sector services? Dream of making a significant impact in society while earning a competitive salary? Look no further. The demand for skilled public administrators, policy analysts, and public service coordinators in the UK has never been higher, with an average annual income ranging from £30,000 to £50,000. Introducing the "Public Administration, Public Policy & Public Services - CPD Certified" course bundle. The bundle features six comprehensive courses, providing a rich theoretical exploration of public administration, policy, and services. From core principles in the "Administration Coordinator" and "Office Administration & Skills Diploma" courses to legal nuances in the "English Law Course" and "Legal Advisor Training Course", you'll gain crucial knowledge. The "Compliance Management Course" offers insight into compliance practices, while the "Effective Minute Taking Training" enhances your recording efficiency. Whether you're an ambitious newbie or a seasoned professional looking to brush up on your knowledge, this course bundle will leave no stone unturned. It paves the way for a holistic understanding of public administration, policy and services, sharpening your analytical skills and providing a solid theoretical understanding that's essential to excel in these professions. Don't miss out on this opportunity to supercharge your career. Sign up for the "Public Administration, Public Policy & Public Services - CPD Certified" course bundle today and empower yourself with the knowledge that can open doors to an array of opportunities in the public sector. This Public administration, Public Policy & Public Services -CPD Certified Bundle Contains 6 of Our Premium Courses for One Discounted Price: Course 01: Administration Coordinator Course 02: Office Administration & Skills Diploma Course 03: English Law Course Course 04: Legal Advisor Training Course Course 05: Compliance Management Course Course 06: Effective Minute Taking Training Learning Outcomes By the end of this Public administration, Public Policy & Public Services course, learners will be able to: Understand the core functions and responsibilities of public administration roles. Gain proficiency in office administration tools and techniques. Acquire foundational knowledge of the English legal system. Develop skills to advise on common legal matters in public service. Understand the significance and application of compliance management. Learn the techniques of efficient and effective minute-taking. Grasp the integration of legal knowledge in public administration and services. This bundle is meticulously crafted to provide learners with a well-rounded education in public administration, policy, and services. A deep dive into these courses will unravel the dynamics of administrative coordination, the importance of effective office management, the intricacies of English law, the role of legal advisors, the essence of compliance in the modern age, and the significance of minute-taking in official meetings. By embarking on this learning journey, you'll be adeptly preparing yourself to navigate and excel in the complex maze of public service, ensuring not just personal growth but also contributing significantly to societal development. The benefits of undertaking these courses extend beyond mere knowledge acquisition. You'll be endowed with the skills and comprehension to improve processes, enhance office efficiency, understand and implement legal and compliance guidelines, and ensure accurate documentation of crucial discussions. In essence, you become an asset to any organization, ready to shoulder responsibilities and drive results. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Public administration, Public Policy & Public Services bundle is ideal for: Aspiring public administration professionals. Legal enthusiasts aiming for a career in public services. Office administrators keen on honing their skills. Individuals interested in compliance and governance roles. Requirements You will not need any prior background or expertise to enrol in this Public administration, Public Policy & Public Services bundle! Career path Administration Coordinator Office Manager Legal Advisor in Public Sector Compliance Officer Minute Taker for high-level meetings Public Policy Developer Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

Public administration, Public Policy & Public Services -CPD Certified
Delivered Online On Demand25 hours
£40

Office Admin and Reception

4.5(3)

By Studyhub UK

Overview Learn how to become an exemplary Receptionist and positively represent your company when interacting with all clients and customers. Every business needs an efficient administrator to manage the Front-Office, along with providing support and assistance to their boss. We can coach you to become an excellent Receptionist and gain all the required business skills that you'll need to succeed, and the confidence with which to use them. Description The course has been compiled by industry experts and provides an overview of the responsibilities of a valued Receptionist. You will be tutored in a wide range of administrative practises, so that you can immediately start to use them in the office. It also includes training in customer-facing etiquette and suggestions on how to positively improve your company's reputation with clients. Various other crucial office aptitudes will be covered, such as; Time Management, Travel Arrangement, Record Keeping, and Business Writing. Make sure you present the efficiency of your company by enrolling now. Learning outcomes:  Understand the basic requirements needed to run receptions areas efficiently Gain the all-round skills to be a first-class Receptionist Learn how to represent your boss and company in reception Be skilled in organising travel and arranging executive meetings for others Attain the ability to file and retrieve essential company records Acquire the skills to apply excellent communicate practises at work Display great customer service for clients and colleagues Be trusted to handle internal finances and petty cash funding Why People Love And Enrol In The Receptionist Skills From Studyhub: Instantly accessible CPD-accredited certificate on successful completion of this Receptionist Skills 24/7 access to the course for 12 months Study at your own pace No hidden fees or exam charges Full Tutor support on weekdays (Monday - Friday) Efficient assessment and instant results Method of Assessment To assess your learning, you have to participate in an automated multiple-choice question exam. You have to score at least 60% to pass the exam and to qualify for CPD accredited certificates. After passing the exam, you will be able to apply for a certificate. To enhance your knowledge regarding the course and to further assess your learning, you are advised to complete the assignment questions provided at the end of the course, which you can complete anytime you wish.  After submitting the assignment, our expert tutor will assess your assignment and will give you feedback on your performance. Certification After completing the MCQ assessment, you will qualify for the CPD Certificate from Studyhub, as proof of your continued professional development. Certification is available in PDF format, for £9, or a hard copy can be sent to you via post, for just £15. Who is This course for? This course is primarily designed to provide coaching and training for those individuals who aspire to work as Receptionists or a similar role such as a Secretary or PA. Requirements There are no specific prerequisites to enrol in this Receptionist Skills. Anyone and everyone can take this course. The Receptionist Skills is fully accessible from any internet-enabled smart device. So, you can study from the comfort of your home! All you need is a passion for learning, literacy, and to be over the age of 16. Career Path This course provides training and a comprehensive overview of all the skills and knowledge that are needed by a Receptionist or a similar administrative role. As such, it will cover the following roles and careers:  Receptionist Administrative Manager Personal Assistant Private Secretary Human Resources staff Course Curriculum Office Admin and Reception Module 1: Introduction to Reception and Receptionist 00:11:00 Module 2: Business Telephone Skills 00:19:00 Module 3: Representing Your Boss and Company 00:34:00 Module 4: Mail Services and Shipping 00:25:00 Module 5: Travel Arrangements 00:24:00 Module 6: Organising Meeting and Conferences 00:25:00 Module 7: Time Management 00:35:00 Module 8: Record Keeping and Filing Systems 00:28:00 Module 9: Business Writing Skills 00:40:00 Module 10: Organisational Skills 00:25:00 Module 11: Communication Skills 00:25:00 Module 12: Customer Service 00:16:00 Module 13: Effective Planning and Scheduling 00:46:00 Module 14: Invoicing/Petty Cash 00:27:00 Module 15: Business Environment 00:19:00 Advanced MS Excel How to Get the most of the course 00:01:00 Text formulas in Excel 00:08:00 Text Formulas Exercise 00:01:00 Text Formulas Exercise (answers) 00:01:00 Mathematical Formulas In Excel 00:04:00 Mathematical Formulas Exercise 00:01:00 Mathematical Formulas Exercise (answers) 00:01:00 Date and Time Formulas In Excel 00:06:00 Date and Time Formulas Exercise 00:01:00 Date and Time Exercise Formulas (answers) 00:01:00 Logic Formulas In Excel 00:12:00 Logic Formula Exercise 00:01:00 Logic Formula Exercise (answers) 00:01:00 Financial Formula In Excel 00:06:00 Financial Formula Exercise 00:01:00 Financial Formula Exercise (answers) 00:02:00 Informational Formula In Excel 00:04:00 Informational Formula Exercise 00:01:00 Informational Formula Exercise (answers) 00:01:00 Getting Traffic To Your Site 01:00:00 Menu Example with Excel Vlookup 00:08:00 Wildcard Search with Excel Vlookup 00:09:00 Looking to the Left with Excel Vlookup 00:17:00 2-Way Lookup 00:14:00 Comparing Lists with Excel Vlookup 00:03:00 Microsoft Excel Vlookup Tips and Tricks 00:14:00 Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Enabling M in Power Query 00:02:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Simple Expressions 00:08:00 Simple Expressions - Nested Expressions 00:03:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Variables 00:08:00 Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05:00 Mock Exam Mock Exam - Office Admin and Reception 00:20:00 Final Exam Final Exam - Office Admin and Reception 00:20:00

Office Admin and Reception
Delivered Online On Demand11 hours 16 minutes
£10.99

Office 365 Planner

By iStudy UK

The Planner is a late addition to the Office 365 suite of productivity tools that makes it very easy for a team to work together more efficiently and productively. This Office 365 Planner course is perfect if you are looking forward to learning more about Office 365. By enrolling in this course, you'll equip with all the features and functionality of Planner. Following that, you'll learn how to create new plans, organize and assign tasks. Besides, you'll explore how to share files, chat, and get updates on project progress. In addition to that, you'll understand the interface of Planner, learn to create new plans, use Boards and Buckets to organize tasks. Creating and assigning tasks, adding new members, using notifications, and working with the different views also broadly explained in this course. Upon successful completion of this course, you'll be able to use Planner more confidently for organizing and managing tasks and projects related exercises. What Will I Learn? Get an Understanding of Planner Add and Edit Tasks Create a New Plan Work with Members in Planner Requirements Basic computer skills would be helpful Introduction Introduction 00:03:00 Working with Planner Overview of Planner 00:05:00 Creating a New Plan 00:05:00 Using Boards and Buckets 00:06:00 Working with Tasks 00:09:00 Working with Members 00:08:00 Editing Plan Settings 00:05:00 Changing Views 00:08:00 Exporting a Plan to Excel 00:04:00 Conclusion Course Recap 00:02:00 Course Certification

Office 365 Planner
Delivered Online On Demand55 minutes
£25

Office 2016 New Features

By iStudy UK

To explore the new features that have included in Microsoft Office 2016, enrolling in this Office 2016 New Features course will be perfect for you. Grab the opportunity to acquire knowledge of Microsoft Office 2016 which will allow you to take your skills to a higher level and become more confident and efficient in the workplace. Office 2016 includes multiple unique features and enhancements offered in Office 2013. Throughout the course, you'll gain invaluable insider tips and learn new techniques to work with office 2016. Additionally, you'll analyse the common changes across the suite of products, such as Tell Me, ink equations, new chart types, version history, and themes and review individual feature enhancements in Microsoft Word, Excel, PowerPoint, Outlook, and Access. What Will I Learn? Learn about the new features across Office 2016 Use Co-authoring in Word Explore the new features in Excel Create a screen recording in PowerPoint Be more productive with Outlook Explore the new features of Access Requirements Basic understanding of existing Microsoft Office features and functionality Introduction Introduction FREE 00:00:00 Overview of Common Changes Using the Tell Me Feature 00:04:00 Using Smart Lookup 00:04:00 Applying the New Colorful Theme 00:02:00 Working with Version History 00:03:00 Working with New Chart Types 00:04:00 Using Ink Equations 00:03:00 New Features in Word Using Co-Authoring 00:05:00 New Features in Excel Using the One-Click Forecast 00:03:00 Searching in the PivotTable Field List 00:01:00 Using Multi-Select with a PivotTable Slicer 00:01:00 Using Maps 00:01:00 Using Get and Transform Power Queries 00:03:00 Publishing and Sharing in Power BI 00:02:00 Using Power View 00:02:00 Working with PowerPivot Improvements 00:02:00 New Features in PowerPoint Using Preset Styles for Shapes 00:04:00 Creating a Screen Recording 00:05:00 New Features in Outlook Working with Groups 00:09:00 Working with Clutter 00:05:00 Searching with Keywords and People Suggestions 00:02:00 Working with Email Attachments 00:03:00 New Features in Access Exploring the New Environment 00:01:00 Exploring New Templates 00:02:00 Exporting Linked Information to Excel 00:01:00 Integrating with SharePoint 2016 00:01:00 Conclusion Course Recap 00:01:00 Course Certification

Office 2016 New Features
Delivered Online On Demand1 hour 14 minutes
£25

Office 365 OneNote Online

By iStudy UK

Microsoft OneNote is a free-form note-taking application helps to take digital notes and keep them organized. It also allows you to add images, diagrams, audios, videos, and so on. OneNote can access from both the desktop or mobile devices. The Office 365 OneNote Online course is intended for beginners to demonstrate the basics of OneNote Online in Office 365, including how to create a notebook and add content efficiently. This course teaches you everything from essential notes to drawings, links and embedded files and data. OneNote notebook contains pages and sections, related to a multi-subject notebook. You'll also learn to navigate and create notebooks, edit, share and print notes quite comfortably. What Will I Learn? Work with OneNote Create a New Notebook Add and Format Content Use Search Requirements Basic Computer Skills Introduction Introduction FREE 00:03:00 Working with OneNote Overview of OneNote 00:05:00 Creating a New Notebook 00:05:00 Navigating in OneNote 00:05:00 Adding Sections and Pages to a Notebook 00:05:00 Adding Content 00:08:00 Formatting Content 00:05:00 Using Tags 00:05:00 Using Search 00:04:00 Sharing & Printing a Notebook 00:06:00 Using Immersive Reader 00:05:00 Conclusion Course Recap 00:03:00 Course Certification

Office 365 OneNote Online
Delivered Online On Demand59 minutes
£25