381 Personal Assistant courses in Cardiff delivered Online

Description:  Microsoft Office includes Access, Excel, Outlook, Power Point, Publisher and Word. The most widely used version is the desktop version. These versions are available on different operating systems. Through this course, you will learn the necessary skills, knowledge, and information about Microsoft Office. You will know the different components and parts of Microsoft Office that you need to learn to be able to utilise the programs. You will realise that you will not be able to work without it since it is very user-friendly and helpful in your career. Who is the course for? New staff or professionals who want to learn about the Microsoft Office Essentials People who have an interest in the basics and features of Microsoft Office 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. Assessment: 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. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Office Essentials course is a useful qualification to possess and would be beneficial for any type of professions or careers like: Account Manager Administrative Assistant Executive Assistant Office Administrator Office Manager Personal Assistant Secretary Supervisor Top Executive. Microsoft Word Module One - Getting Started 00:30:00 Module Two - Opening 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Word for Newbies - Activities 00:00:00 Microsoft Excel Module One - Getting Started 00:30:00 Module Two - Opening Excel 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Excel for Newbies - Activities 00:00:00 Microsoft PowerPoint Module One - Getting Started 00:30:00 Module Two - Opening PowerPoint 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 PowerPoint Essential Activities 00:00:00 Microsoft Access Module One - Getting Started 00:30:00 Module Two - Opening and Closing Access 01:00:00 Module Three - An Introduction to Databases 01:00:00 Module Four - Sharing Data Using Apps 01:00:00 Module Five - Working in Your App 01:00:00 Module Six - An Introduction to Desktop Databases 01:00:00 Module Seven - Performing Basic Table Tasks 01:00:00 Module Eight - Working with Fields 01:00:00 Module Nine - Working with Table Relationships 01:00:00 Module Ten - An Introduction to Queries, Forms, and Reports 01:00:00 Module Eleven - Protecting Your Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access for Beginners 00:00:00 Microsoft Outlook Module One - Getting Started 00:30:00 Module Two - Opening and Closing Outlook 01:00:00 Module Three - Understanding the Interface 01:00:00 Module Four - Working with the Message List and the Reading Pane 01:00:00 Module Five - Using Message List Commands 01:00:00 Module Six - Creating a New Email 01:00:00 Module Seven - Managing Email 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contact 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Outlook for Beginners 00:00:00 Microsoft Publisher Module One - Getting Started 00:30:00 Module Two - Opening Publisher 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Publication 01:00:00 Module Five - Working with Pictures 01:00:00 Module Six - Basic Editing Tasks 01:00:00 Module Seven - Formatting Fonts 01:00:00 Module Eight - Formatting Paragraphs 01:00:00 Module Nine - Working with Objects 01:00:00 Module Ten - Working with Pages 01:00:00 Module Eleven - Publishing Your Work 01:00:00 Module Twelve - Wrapping Up 00:30:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Microsoft Office Essentials 00:30:00 Final Exam Final Exam- Microsoft Office Essentials 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Learn the Latest Skills | Accredited by CPD | MCQ Based Exam & Tutor Support | Interactive Video Training  The Advanced Diploma in Office Administration is intended for ambitious individuals who are interested in either starting a new career or developing their current administrative position. This course is ideal for you if you’re looking to advance in your job. People will learn how to use the appropriate administrative tools, procedures, and instructions. Additionally, you will learn how to manage an office, comprehend bookkeeping and payroll, and write reports and letters. What Will You Learn? Learn the basic computer software you need to know to perform at your best on a daily basis Learn organisational, time management and meeting management skills Learn the basic principles of business writing Enrich your expertise in MS Word, PowerPoint, and Excel Learn to keep the books in order and proper telephone etiquette What classes are included in this package? Earn a digital certificate upon successful completion There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you’ll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? This course is ideal for those who want to work in administrative support roles in public or private sector organisations or those who wish to improve their managerial and supervisory skills. Career Path Training offered by the Advanced Diploma In Office Administration could potentially benefit a range of roles, but would particularly enhance careers in: Administrator Support Staff Personal Assistant Receptionist Office Administrator Secretary HR Personnel 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 assessments Assignment Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. 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 £99. Please note that overseas students may be charged an additional £10 for postage. 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 On successful completion of the Advanced Diploma in Office Administration, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. The assessment will be evaluated automatically and the results will be given to you immediately. Retake fee If you do not pass the exam first time, you can purchase the Retake Exam for £1.99 and try again. Course Contents Module 01: Introduction to Office Administration Module 02: Skills of an Effective Administrator Module 03: Business Writing Skills Module 04: Communication Skills Module 05: Meeting Management Module 06: Organisational Skills Module 07: Telephone Etiquette Module 08: Negotiation Techniques Module 09: Conflict Management Module 10: Stress Management Module 11: Time Management

Description: To help people developing their skills in creating, editing, and deleting documents, you will need proper training to utilize it. They want to help people to improve their efficiency and effectiveness in different areas. In this course, you will learn the advanced skills, knowledge, and information about Microsoft Office apps. This course includes the advanced specifics of programs such as Word, Excel, PowerPoint, Access and Outlook 2007. Grabbing this chance to learn things related to Microsoft Office which will take your skills to an advanced level that could make you more progressive in your work and career. If you are someone who is working towards career advancement, then this is the Microsoft Office advanced skills training that you are looking for. Who is the course for? Professionals who want to learn about the Microsoft Office 2007 People who have an interest in the advanced features of the Microsoft Office 2007 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. Assessment: 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. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Office 2007 Advanced course is a useful qualification to possess and would be beneficial for any type of professions or careers such as: Account Manager Administrative Assistant Administrator Office Manager Personal Assistant Secretary. Microsoft Word 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Working with the Word Window 01:00:00 Module Three - Adding Pictures 01:00:00 Module Four - Adding Smart Art 01:00:00 Module Five - Adding Tables 01:00:00 Module Six - Advanced Table Tasks 01:00:00 Module Seven - Inserting Special Objects 01:00:00 Module Eight - Adding In-Document References 01:00:00 Module Nine - Advanced Research Tasks 01:00:00 Module Ten - Reviewing a Document 01:00:00 Module Eleven - Customizing Word 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft PowerPoint 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Adding Pictures 01:00:00 Module Three - Working with Text Boxes 01:00:00 Module Four - Adding SmartArt 01:00:00 Module Five - Adding Tables 01:00:00 Module Six - Inserting Advanced Objects 01:00:00 Module Seven - Advanced Drawing Tasks 01:00:00 Module Eight - PowerPoint's Research Tools 01:00:00 Module Nine - Creating Notes and Handouts 01:00:00 Module Ten - Using Slide Masters 01:00:00 Module Eleven - Advanced Presentation Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Access 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Advanced Table Tasks 01:00:00 Module Three - Advanced Form Tasks 01:00:00 Module Four - Advanced Reporting Tasks 01:00:00 Module Five - Understanding Relationships 01:00:00 Module Six - Advanced Query Tasks 01:00:00 Module Seven - Working with SQL 01:00:00 Module Eight - Linking Data 01:00:00 Module Nine - Importing Data 01:00:00 Module Ten - Exporting Data 01:00:00 Module Eleven - Advanced Database Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Outlook 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Customizing Outlook 01:00:00 Module Three - Adding Word Elements to an E-mail 01:00:00 Module Four - Customizing Your Profile 01:00:00 Module Five - Advanced E-Mail Tasks 01:00:00 Module Six - Advanced Calendar Tasks 01:00:00 Module Seven - Doing More with Tasks 01:00:00 Module Eight - Using Notes 01:00:00 Module Nine - Viewing RSS Feeds 01:00:00 Module Ten - Managing Outlook Data, Part One 01:00:00 Module Eleven - Managing Outlook Data, Part Two 01:00:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Mock Exam- Microsoft Office 2007 Advanced 00:30:00 Final Exam Final Exam- Microsoft Office 2007 Advanced 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Office is a group of different applications with different specific main functions that offer flexible and powerful tasks management. These applications can help you to organise, manage, and present information. Since the products of Microsoft Office are considered as the gold standard for businesses across the globe, knowing the functions of applications is a benefit for you. Through this course, you will learn all the essential skills, knowledge, and information about Microsoft Office 2007. You will know how to make use of all the programs and features of Microsoft Office. Who is the course for? New staff or workers who want to learn about the Microsoft Office 2007 Programs People who have an interest in all the features of the Microsoft Office 2007 Applications 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. Assessment: 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. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Office 2007 Essentials course is a useful qualification to possess and would be beneficial for any type of professions or career from any type of industry you are in, such as: Administrative Assistant Businessman Executive Assistant Office Administrator Office Manager Personal Assistant Secretary Senior Manager Staff. Microsoft Word 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Word 01:00:00 Module Three - Working with Documents 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Advanced Formatting Tasks 01:00:00 Module Eight - Formatting Paragraphs 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Adding the Finishing Touches 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Word 2007 for Beginners 00:00:00 Microsoft Excel 2007 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 for Beginners 00:00:00 Microsoft PowerPoint 2007 For Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing PowerPoint 01:00:00 Module Three - Working with Presentations 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Formatting Text 01:00:00 Module Six - Formatting Paragraphs 01:00:00 Module Seven - Working with Text 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Customizing Slide Elements 01:00:00 Module Ten - Setting up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft PowerPoint 2007 for Beginners 00:00:00 Microsoft Access 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening Access 01:00:00 Module Three - Using the Access Interface 01:00:00 Module Four - Working with Database Objects 01:00:00 Module Five - Creating Tables 01:00:00 Module Six - Working with Tables 01:00:00 Module Seven - Creating Forms 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Creating Reports 01:00:00 Module Ten - Creating Queries 01:00:00 Module Eleven - Managing Your Database 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activites- Microsoft Access 2007 for Beginners 00:00:00 Microsoft Outlook 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Outlook 01:00:00 Module Three - Working with E-mail 01:00:00 Module Four - Creating a New E-mail 01:00:00 Module Five - Managing E-mail 01:00:00 Module Six - Managing Junk Mail 01:00:00 Module Seven - Outlook's Organization Tools 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contacts 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Outlook 2007 for Beginners 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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

Description: The minute is an integral part of any meeting. In fact, the success of any meeting largely depends on the proper minute. The course covers the necessary techniques of minute preparing and the skills needed for secretarial roles. At first, you will explore the skills for taking minutes that will be followed by the roles and responsibilities of a secretary or PA. You will learn how to take minutes with OneNote. The course then focuses on the communication skill, negotiation and influencing skills, self-esteem and confidence building, time management and other skills related to the secretary. Finally, the course teaches how to prepare business writing and reports. Who is the course for? People interested in maximizing their efficiency in note taking for their jobs People interested in working as a stenotype operator or journalist 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. Assessment: 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. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. 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.   Minute Taking and Executive Secretarial Diploma - Updated Version Minute Taking Executive Training Introduction to Minute Writing 00:20:00 Preparation for Minute Taking 00:23:00 The Meeting Structure 00:16:00 Minute Meetings, Decisions and Actions 00:18:00 Roles and Responsibility of Minute Taker 00:27:00 Tips for Minute Taking 00:22:00 Technology in Minute Taking 00:12:00 Building Confidence 00:13:00 Executive PA Module 1: Introduction to Personal Assistant 00:20:00 Module 2: Business Telephone Skills 00:21:00 Module 3: Representing Your Boss and Company 00:37:00 Module 4: Mail Services and Shipping 00:28:00 Module 5: Travel Arrangements 00:27:00 Module 6: Organising Meeting and Conferences 00:28:00 Module 7: Time Management 00:38:00 Module 8: Record Keeping and Filing Systems 00:31:00 Module 9: Business Writing Skills 00:43:00 Module 10: Organisational Skills 00:28:00 Module 11: Communication Skills 00:28:00 Module 12: Customer Service 00:19:00 Module 13: Effective Planning and Scheduling 00:49:00 Module 14: Invoicing/Petty Cash 00:30:00 Module 15: Professional Conduct and Ethics 00:24:00 Minute Taking and Executive Secretarial Diploma - Old Version Minute Taking Basics What Minutes are 01:00: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 Taking Minutes with OneNote The Role of a Minute-Taker 00:30:00 The Skills of a Minute-Taker 00:15:00 Meeting Agreements 00:15:00 Minutes Styles 00:15:00 What Do I Record 00:30:00 Techniques for Preparing Minutes 00:30:00 Taking Minutes in an Interactive Meeting 00:30:00 The Minute Book 00:15:00 Secretarial Interpersonal Skills Module One - Getting Started 00:30:00 Module Two - Verbal Communication Skills 01:00:00 Module Three - Non-Verbal Communication Skills 01:00:00 Module Four - Making Small Talk and Moving Beyond 01:00:00 Module Five - Moving the Conversation Along 00:30:00 Module Six - Remembering Names 01:00:00 Module Seven - Influencing Skills 01:00:00 Module Eight - Bringing People to Your Side 01:00:00 Module Nine - Sharing Your Opinion 01:00:00 Module Ten - Negotiation Basics 01:00:00 Module Eleven - Making an Impact 01:00:00 Module Twelve - Wrapping Up 00:30:00 Developing Interpersonal Skills Course- Activities 00:00:00 Administrative Management skills 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 Business Writing Module One - Getting Started 00:30:00 Module Two - Working with Words 01:00:00 Module Three - Constructing Sentences 01:00:00 Module Four - Creating Paragraphs 01:00:00 Module Five - Writing Meeting Agendas 01:00:00 Module Six - Writing E-mails 01:00:00 Module Seven - Writing Business Letters 01:00:00 Module Eight - Writing Proposals 01:00:00 Module Nine - Writing Reports 01:00:00 Module Ten - Other Types of Documents 01:00:00 Module Eleven - Proofreading and Finishing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Self Esteem & Confidence Building Module One - Getting Started 01:00:00 Module Two - What Does Self-Confidence Mean To You 01:00:00 Module Three - Obstacles to Our Goals 01:00:00 Module Four - Communication Skills 01:00:00 Module Five - The Importance of Goal Setting 01:00:00 Module Six - Feeling the Part 01:00:00 Module Seven - Looking the Part 01:00:00 Module Eight - Sounding the Part 01:00:00 Module Nine - Powerful Presentations 00:30:00 Module Ten - Coping Techniques 01:00:00 Module Eleven - Dealing with Difficult Behavior 00:30:00 Module Twelve - Wrapping Up 00:15:00 Mock Exam Mock Exam - Minute Taking and Executive Secretarial Diploma 00:20:00 Final Exam Final Exam - Minute Taking and Executive Secretarial Diploma 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Looking to become the organisational backbone of any business? The Secretary: 20-in-1 Premium Online Courses Bundle is your gateway to admin-focused roles across corporate, legal, medical, and public service sectors. From communication to time mastery, this bundle signals one thing to employers: you’re ready to run the show behind the scenes. Description Employers don’t just need assistants—they need professionals who can manage information, support teams, and communicate with poise. This carefully curated bundle helps you stand out in administrative, executive support, virtual assistance, and office management roles. From handling documentation to mastering scheduling and digital tools, you’ll gain 20 certifications that make your profile pop in a crowded field. Whether you’re starting out, returning to work, or upskilling for a hybrid role, this bundle is a one-time investment with long-term career impact. Don’t wait for the perfect job to find you—make yourself the perfect candidate. FAQ Q: What roles is this bundle suitable for? A: Office secretary, virtual assistant, personal assistant, admin officer, executive assistant, and office coordinator. Q: What sectors does it apply to? A: Corporate offices, healthcare, law, finance, education, and remote support services. Q: Are the certifications separate? A: Yes, you’ll earn a certificate for each of the 20 courses, which you can add to your CV or LinkedIn profile. Q: Is any prior experience required? A: No experience needed—this is perfect for entry-level learners and professionals reskilling. Q: Can I study at my own pace? A: Absolutely. Full, flexible access means you can complete it around your schedule.

Executive Secretary & PA Training Course Online For confident candidates with outgoing personalities and a relentless attention to detail, the field of Secretary & PA Diploma services is wide open. Professional personal assistants (PAs) are the ultimate multitaskers, hired to manage the personal affairs and activities of those they support. Some secretaries and PAs work for large corporations, while others are hired by a single executive, entrepreneur, or influential figure. Regardless of which path you take, becoming a trusted and respected PA or Secretary opens the door to a world of incredible career opportunities. Personal qualities and character, as well as hard skills, are important for success as a PA or secretary. It's simply a matter of learning the roles of PAs and secretaries in order to prepare for a rewarding career in the field. This Executive Secretary & PA Training could be the key to your dream job. Transform your ambition and enthusiasm into a rewarding career for life by studying from home at your own pace and time. Learn how to handle a wide range of essential office administration tasks, as well as how to write important business letters and handle complex mail and shipping requirements. Making travel arrangements on behalf of others, organising meetings and events, the importance of time management as a PA, and how to become a better communicator are also covered in the course. Why choose this Executive Secretary & PA Training Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Executive Secretary & PA Training Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Executive Secretary & PA Training Course.. Other Benefits of This Executive Secretary & PA Training Course FREE PDF Certificates Lifetime Access Free Retake Exam Expert Tutor Support Main Course: Executive Secretary & PA Training Course Free Courses Course 01: Level 2 Certificate in Law and Legal Work Course 02: Level 4 Diploma In Paralegal Studies [ Note: Free PDF certificate will provide as soon as completing the Executive Secretary & PA Training Course] Executive Secretary & PA Training Course Online Our Executive Secretary & PA Training course has been designed to equip you with the essential knowledge and skills needed to become an expert executive secretary or personal assistant and will give you all the practical knowledge & credentials that you need to excel in your new role. Enrol on our Executive Secretary & PA Training course today and begin your journey to improve your career prospects with the latest skills and the power of self-belief! Learning Outcomes After completing this Executive Secretary & PA Training course, learner will be able to: Understand personal assistant fundamentals Understand business telephone approaches Understand information regarding shipping and mail services Understand travel arrangements Understand outline setting up conferences and meetings Understand management of time Understand systems for record keeping and filing Understand business writing techniques Understand communication skills Understand customer service Understand basics of microsoft office skills Assessment Method of Executive Secretary & PA Training Course After completing Executive Secretary & PA Training Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Executive Secretary & PA Training Course After completing the Executive Secretary & PA Training course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Executive Secretary & PA Training Course Online This Executive Secretary & PA Training course is designed for existing secretarial/administrative workers seeking advancement or newcomers seeking their first professional position. Requirements Executive Secretary & PA Training Course Online To enrol in this Executive Secretary & PA Training Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Executive Secretary & PA Training Course. Be energetic and self-motivated to complete our Executive Secretary & PA Training Course. Basic computer Skill is required to complete our Executive Secretary & PA Training Course. If you want to enrol in our Executive Secretary & PA Training Course, you must be at least 15 years old. Career path Executive Secretary & PA Training Course Online After completing this Executive Secretary & PA Training course, you may able to pursue a formal position in professional Executive PA services such as: Personal Executive Assistant Receptionist Office Assistant Support Secretary Office Manager Personal Concierge Executive Assistant

If you're after a no-fuss way to upgrade essential workplace and personal skills, this Functional Skills bundle brings together everything that actually gets used. You’ll find maths and English made useful (not just algebraic acrobatics), along with IT skills from Word to Excel, and a dash of PowerPoint confidence for good measure. Topped off with communication and negotiation techniques, the bundle fits just as well for job hunters as it does for those managing office life or everyday tasks. It’s the learning equivalent of a well-organised spreadsheet—useful, neat, and quietly satisfying. Learning Outcomes: Strengthen grammar, spelling, and sentence construction abilities. Use Microsoft Word, Excel, and PowerPoint effectively. Improve arithmetic, percentages, and data handling techniques. Develop confident written and verbal communication skills. Apply negotiation skills to everyday and workplace situations. Understand basic IT systems used across different industries. Who is this Course For: Adults returning to education or upskilling. Job seekers brushing up core workplace skills. School leavers preparing for employment or training. Admin professionals seeking smoother office workflows. Parents wanting to support children's learning confidently. Retail staff looking to progress into office roles. Hospitality workers managing everyday digital tasks. Anyone needing sharp, simple, everyday life skills. Career Path: Administrative Assistant – £23,000/year Customer Service Advisor – £22,000/year Data Entry Clerk – £21,000/year Retail Supervisor – £24,000/year Office Manager – £30,000/year Personal Assistant – £29,000/year

First impressions matter—and receptionists are often the first and most important face of any business. This 20-in-1 Receptionist: Office Admin and Reception Bundle is built to make you confident, organised, and hireable in front-desk, admin, or customer-facing roles across multiple industries. From corporate reception desks to healthcare clinics or virtual assistant positions, this bundle prepares you to shine in the roles that keep businesses running smoothly. Description Reception and admin roles require much more than a friendly smile. Employers look for candidates who are fast, professional, organised, and tech-capable—and this bundle proves you’re all of the above. You’ll walk away with 20 certifications covering critical areas like document handling, Microsoft Office tools, communication, GDPR, virtual meeting management, HR fundamentals, and professional etiquette. It’s ideal for receptionists, front desk support, admin assistants, and even remote workers handling client-facing responsibilities. With job-ready proof of your skills and the ability to juggle multiple tasks with composure, this bundle gives you an edge in a competitive field—and all at a fraction of the cost of standalone courses. Start now. Doors open when you’re qualified—and employers won’t wait. FAQ Q: What job titles does this support? A: Receptionist, front desk officer, office assistant, virtual assistant, personal assistant. Q: Is this bundle beginner-friendly? A: Yes, it’s perfect for newcomers and also helps experienced staff formalise their skillset. Q: Are the courses available online? A: Yes, all courses are fully online and accessible at your convenience. Q: Will I get separate certificates for each course? A: Yes—you’ll receive 20 digital certificates to showcase your skills and boost your CV. Q: What industries is this bundle relevant to? A: Corporate offices, clinics, hospitality, government, education, or remote support services. Q: Is this a limited-time offer? A: Yes—enrol today to take advantage of current pricing before it increases.