9471 Office courses delivered Online

Are you looking to enhance your Microsoft Office and SQL skills? If yes, then you have come to the right place. Our comprehensive course on Microsoft Office and SQL will assist you in producing the best possible outcome by mastering the Microsoft Office and SQL skills. The Microsoft Office and SQL course is for those who want to be successful. This course will teach you the essential knowledge needed to become well-versed in Microsoft Office and SQL. Our course starts with Microsoft Office and SQL basics and gradually progresses towards advanced topics. Therefore, each lesson of this Microsoft Office and SQL course is intuitive and easy to understand. Why would you choose the Microsoft Office and SQL course from Compliance Central: Lifetime access to Microsoft Office and SQL course materials Full tutor support is available from Monday to Friday with the Microsoft Office and SQL course Learn Microsoft Office and SQL skills at your own pace from the comfort of your home Gain a complete understanding of Microsoft Office and SQL course Accessible, informative Microsoft Office and SQL learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Microsoft Office and SQL bundle Study Microsoft Office and SQL in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Microsoft Office and SQL Course Curriculum Breakdown of the Microsoft SQL and Office Course Introduction SQL Environment Setup Creating Database and Tables SQL Statement Basics GROUP BY Statements JOINS Advanced SQL Commands Databases and Tables+ Learning Outcomes Understand the fundamentals of SQL and its environment. Demonstrate proficiency in creating databases and tables. Apply basic SQL statements for data retrieval and manipulation. Utilise GROUP BY statements to aggregate and summarise data. Comprehend the concept of JOINS to combine data from multiple tables. Explore advanced SQL commands and techniques for complex queries. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Office and SQL course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Microsoft Office and SQL. It is also great for professionals who are already working in Microsoft Office and SQL and want to get promoted at work. Requirements To enrol in this Microsoft Office and SQL course, all you need is a basic understanding of the English Language and an internet connection. Career path The Microsoft Office and SQL course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Microsoft Office and SQL. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Are you looking to enhance your Office Skills : Secretarial & PA Training skills? If yes, then you have come to the right place. Our comprehensive course on Office Skills : Secretarial & PA Training will assist you in producing the best possible outcome by mastering the Office Skills : Secretarial & PA Training skills. The Office Skills : Secretarial & PA Training course is for those who want to be successful. In the Office Skills : Secretarial & PA Training course, you will learn the essential knowledge needed to become well versed in Office Skills : Secretarial & PA Training. Our Office Skills : Secretarial & PA Training course starts with the basics of Office Skills : Secretarial & PA Training and gradually progresses towards advanced topics. Therefore, each lesson of this Office Skills : Secretarial & PA Training course is intuitive and easy to understand. Why would you choose the Office Skills : Secretarial & PA Training course from Compliance Central: Lifetime access to Office Skills : Secretarial & PA Training course materials Full tutor support is available from Monday to Friday with the Office Skills : Secretarial & PA Training course Learn Office Skills : Secretarial & PA Training skills at your own pace from the comfort of your home Gain a complete understanding of Office Skills : Secretarial & PA Training course Accessible, informative Office Skills : Secretarial & PA Training learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Office Skills : Secretarial & PA Training Study Office Skills : Secretarial & PA Training in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Office Skills : Secretarial & PA Training Course Office Skills : Secretarial & PA Training Curriculum Breakdown of the Office Skills : Secretarial & PA Training Course Module 01: Introduction to Admin Support Assistant Module 02: Introduction to Personal Assistant Module 03: Introduction to Office Administration Module 04: Skills of an Effective Administrator Module 05: Introduction to Reception and Receptionist Module 06: Business Telephone Skills Module 07: Representing Your Boss and Company Module 08: Business Etiquette Module 09: Mail Services and Shipping Module 10: Travel Arrangements Module 11: Organising Meeting and Conferences Module 12: Diary Management and Note taking Module 13: Time Management Module 14: Record Keeping and Filing Systems Module 15: Business Writing Skills Module 16: Organisational Skills Module 17: Communication Skills Module 18: Customer Service Module 19: Effective Planning and Scheduling Module 20: Invoicing Petty Cash CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Office Skills : Secretarial & PA Training course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Office Skills : Secretarial & PA Training. It is also great for professionals who are already working in Office Skills : Secretarial & PA Training and want to get promoted at work. Requirements To enrol in this Office Skills : Secretarial & PA Training course, all you need is a basic understanding of the English Language and an internet connection. Career path The Office Skills : Secretarial & PA Training course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Office Skills : Secretarial & PA Training. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

>> Deal Price is Active Now; Offer Ends Soon, Hurry Up!! << Are you looking to improve your current abilities or make a career move? Our unique Office Administration & Skills Course might help you get there! Expand your expertise with high-quality training - study the course and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the course. This Advanced Diploma in Office Administration & Skills at QLS Level 7 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 180 CPD points) to make your skill development & career progression more accessible than ever! Why Prefer This Office Administration & Skills Course? Opportunity to earn certificate a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS after completing the Office Administration & Skills course Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. The course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enroling on this course. With this comprehensive course, you can achieve your dreams and train for your ideal career. The course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enroling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enroling on the course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the program. Experts created the course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! *** Course Curriculum *** Here are the topics you will cover on the course: Module 01: Personal Assistant Module 02: Admin Support Module 03: Administrative Management Module 04: Organisational Skills Module 05: Telephone Etiquette Module 06: Business Writing Module 07: Time Management Module 08: Body Language and Effective Communication Module 09: Meeting Management Module 10: Excel Basics Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Module 11: PowerPoint Basic Customise the User Interface Set PowerPoint 2016 Options Modify Slide Masters and Slide Layouts Add Headers and Footers Modify the Notes Master and the Handout Master Create SmartArt Modify SmartArt Write Math Equations Add Audio to a Presentation Add Video to a Presentation Customise Animations and Transitions Review a Presentation Store and Share Presentations on the Web Annotate a Presentation Set Up a Slide Show Create a Custom Slide Show Add Hyperlinks and Action Buttons Record a Presentation Secure a Presentation Broadcast a Slide Show Create a Video or a CD Assessment Process After completing an online course module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. After passing the Advanced Diploma in Office Administration & Skills at QLS Level 7 exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Office Administration & Skills Course Right for You? Anyone interested in learning more about this subject should take this course. This Office Administration & Skills will help you grasp the basic concepts as well as develop a thorough understanding of the subject. All are welcome to take this course. There are no prerequisites for enrolment, and you can access the course materials from any location in the world. Requirements The Office Administration & Skills program does not require any prior knowledge; everyone may participate! This Office Administration & Skills course is open to anyone who is interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This Office Administration & Skills course allows you to study at your own speed and grow a quality skillset. Career path After completing this Office Administration & Skills Course, you are to start your career or begin the next phase of your career in this field. Our entire Office Administration & Skills course will help you to gain a position of respect and dignity over your competitors. The certificate enhances your CV and helps you find work in the field concerned. Certificates Certificate of completion Digital certificate - £10 Advanced Diploma in Office Administration & Skills at QLS Level 7 Hard copy certificate - £139 Show off Your New Skills with a Certificate of Completion After successfully completing the Advanced Diploma in Office Administration & Skills at QLS Level 7, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 139 GBP inside the UK 149 GBP (including postal fees) for International Delivery Certificate Accredited by CPDQS 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

The Microsoft Office Essentials - 3 Course Bundle has been expertly designed for you to complete through distance e-learning. Successful completion of the Microsoft Office bundle will see you achieve a CPD certified proficiency which will add significant weight to your CV and impress potential employers when applying for new jobs. Enrol now on the Microsoft Office Essentials - 3 Course Bundle and get access to top-quality training modules. Start studying Microsoft Office using any internet-enabled device including computers, tablets, and smartphones. With 24/7 student support, you can be sure of quick and comprehensive assistance whenever you need it. Why Choose Microsoft Office Essentials - 3 Course Bundle? Opportunity to boost your CV/Resume with CPD accredited proficiency Student ID card with amazing discounts - completely for FREE! (Postal charges will be applicable for international delivery) Certificates available in both PDF and hard copy format Interactive, high-quality course content with 24/7 online access Full tutor support and learning assistance included Course Curriculum Breakdown: Here are the topics you will cover on the Microsoft Office Essentials - 3 Course Bundle Course: Microsoft Excel 2022 New Features Introduction to Microsoft Excel 2019 New Features CONCAT IFS MAXIFS MINIFS SWITCH TEXTJOIN Map Chart Funnel Chart Better Visuals Pivot Table Enhancements Power Pivot Updates Getting Started with Microsoft Office Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Formatting a Worksheet Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Printing Workbooks Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Managing Workbooks Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Working with Functions Work with Ranges Use Specialized Functions Work with Logical Functions Work with Date & Time Functions Work with Text Functions Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Sharing and Protecting Workbooks Collaborate on a Workbook Protect Worksheets and Workbooks Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Creating Sparklines and Mapping Data Create Sparklines MapData Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends Excel Templates Excel Templates CPD 11 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Office Essentials - 3 Course Bundle has been professionally-designed for motivated learners who are looking to add a new skill to their CV and stand head and shoulders above the competition. Learn the latest industry-specific information with the Microsoft Office Essentials - 3 Course Bundle. Requirements Enrol on the Microsoft Office Essentials - 3 Course Bundle with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the Microsoft Office Essentials - 3 Course Bundle without any delay. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited Certificate Hard copy certificate - £29

Get ready for an exceptional online learning experience with the Executive Management, MBA, Office Administration, PA & Legal Secretary bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Executive Management & Office Administration package is dynamic, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Executive Management & Office Administration package has something for everyone. As part of the Sales & Marketing, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Executive Management, MBA, Office Administration, PA & Legal Secretary bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following Executive Management, MBA, Office Administration, PA & Legal Secretary CPD-accredited courses: Course 01: Developing Strategic Executive Management Course 02: Administrative Management Course 03: Mini MBA Course 04: Office Administration Course 05: Legal Secretary and Office Skills Diploma Course 06: Business Law Course 07: Online Meeting Management Course 08: Diary Management Course 09: Document Control Course 10: Minute Taking Course Course 11: Personal Assistant Course 12: Business Writing Course 13: Touch Typing Essentials Course 14: Workplace Confidentiality Course 15: Mastering Organizational Chaos Course 16: Communication Skills Course 17: CV Writing and Job Searching Course 18: Learn to Level Up Your Leadership Course 19: Networking Skills for Personal Success Course 20: Ace Your Presentations: Public Speaking Masterclass What will make you stand out? Upon completion of this online Executive Management, MBA, Office Administration, PA & Legal Secretary bundle, you will gain the following: CPD QS Accredited Proficiency with this Executive Management & Office Administration bundle After successfully completing the Executive Management & Office Administration bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials in this Executive Management & Office Administration bundle The online test with immediate results You can study and complete the Executive Management & Office Administration bundle at your own pace. Study for the Executive Management & Office Administration bundle using any internet-connected device, such as a computer, tablet, or mobile device. Each course in this Executive Management, MBA, Office Administration, PA & Legal Secretary bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This Executive Management & Office Administration bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with Executive Management, MBA, Office Administration, PA & Legal Secretary , a rich anthology of 30 diverse courses. Our experts handpick each course in the Executive Management & Office Administration bundle to ensure a wide spectrum of learning opportunities. This Executive Management & Office Administration bundle will take you on a unique and enriching educational journey. The Executive Management, MBA, Office Administration, PA & Legal Secretary bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Executive Management & Office Administration bundle offers you the flexibility and convenience to learn at your own pace. Make the Executive Management & Office Administration package your trusted companion in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Executive Management, MBA, Office Administration, PA & Legal Secretarybundle is perfect for: Aspiring Executives: Individuals aiming to secure senior management roles or C-suite positions in various industries. MBA Graduates: Recent MBA graduates seeking to enhance their administrative and legal knowledge to complement their business acumen. Office Administrators: Experienced office administrators looking to upscale their expertise and advance into more senior roles. Personal Assistants (PAs): PAs wishing to deepen their organisational skills and understand more about legal requirements in business settings. Legal Secretaries: Legal secretaries seeking comprehensive training that combines management, administration, and legal expertise. Requirements You are warmly invited to register for this Executive Management, MBA, Office Administration, PA & Legal Secretary bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Upon Executive Management, MBA, Office Administration, PA & Legal Secretary course completion, you can expect to: Senior Office Manager Executive Assistant to CEO Legal Administrative Assistant Business Consultant Human Resources Manager Project Manager Operations Director Corporate Legal Secretary Entrepreneur Non-Profit Organisation Manager Certificates CPD Certificates Digital certificate - Included

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Awkward at the Office Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training employers seek in today's workplaces. The Awkward at the Office Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Awkward at the Office Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Awkward at the Office Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Awkward at the Office? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standards accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Awkward at the Office there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Awkward at the Office course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Awkward at the Office does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Awkward at the Office was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Awkward at the Office is a great way for you to gain multiple skills from the comfort of your home. Awkward at the Office Awkward at the Office 01:50:00 Assignment Assignment -Awkward at the Office

Overview Become a skilled professional by enrolling in the Office Skills course.This comprehensive Office Skills is designed to cover all the key topics you need to excel in the field of office administration and reception. This extensive course will teach you how to handle a comprehensive range of essential office admin duties, compose critical business letters and handle complex mail and shipping requirements. It will provide you with technical skills to meet the dynamic challenges facing modern companies.Convert your passion and enthusiasm into a prosperous career by enrolling in the Office Skills course. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Office Skills. It is available to all students, of all academic backgrounds. Requirements Our Office Skills is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 16 sections • 56 lectures • 11:17:00 total length •Module 01: Introduction to Reception and Receptionist: 00:28:00 •Module 02: Business Telephone Skills: 00:21:00 •Module 03: Representing Your Boss and Company: 00:36:00 •Module 04: Mail Services and Shipping: 00:27:00 •Module 05: Travel Arrangements: 00:26:00 •Module 06: Organising Meeting and Conferences: 00:27:00 •Module 07: Time Management: 00:37:00 •Module 08: Record Keeping and Filing Systems: 00:30:00 •Module 09: Business Writing Skills: 00:42:00 •Module 10 :Organisational Skills: 00:27:00 •Module 11: Communication Skills: 00:27:00 •Module 12: Customer Service: 00:18:00 •Module 13: Effective Planning and Scheduling: 00:48:00 •Module 14: Invoicing/Petty Cash: 00:29:00 •Module 15: Business Environment: 00:18:00 •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:05: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

Receptionist: Office Admin and Reception No matter the type or the size of an organisation, every office needs a receptionist and someone to take care of the administrative tasks. Therefore, if you can train yourself in administrative and receptionist work, you will have a lot of job opportunities knocking at your door. The Office Admin and Receptionist bundle will provide you with quality training. It will equip you with the essential skills and confidence to carry out the responsibilities. The Office Admin and Receptionist Course will help you acquire the essential skills to become a proficient receptionist or an office admin. In this bundle, you will learn how to represent your company in the best possible manner. The easy-to-follow modules will help you in developing your telephone skills. Furthermore, you will become competent in record keeping and filing. In addition, this valuable bundle will teach you organisation skills, communication skills, time management skills, and more. Most importantly, this bundle will provide you with quality training in MS Excel. Along with this Receptionist: Office Admin and Reception Training course, you will get 10 additional premium courses, Course 01: Office Admin and Reception Course 02: Conflict Management Course 03: Minute Taking Essentials Level 2 Course 04: Document Control Course 05: Effective Communication Skills Course 06: GDPR Course 07: MS Word Diploma Course 08: Facilities Management Level 3 Course 09: IT Support Technician Training Course 10: Leadership & Management Diploma Course 11: Workplace Health and Safety Diploma Course 12: Time Management Whether you are looking to brighten up your CV, just starting out in the industry, looking for a career change or just fancy learning something new, this online Receptionist: Office Admin and Reception is perfect! The Receptionist: Office Admin and Reception bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Receptionist: Office Admin and Reception expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn Receptionist: Office Admin and Reception from any place in your own time without travelling for classes. SO enrol now in this Receptionist: Office Admin and Reception bundle to advance your career! Receptionist: Office Admin and Reception You'll discover how to master the Receptionist skill while exploring relevant and essential topics. Course Curriculum of Receptionist: Office Admin and Reception Bundle Course 01: Office Admin and Reception Business Telephone Skills Representing Your Boss and Company Mail Services and Shipping Travel Arrangements Organizing Meetings and Conferences Time Management Record Keeping and Filing Systems Business Writing Skills Organizational Skills Communication Skills Customer Service Effective Planning and Scheduling Invoicing/Petty Cash Business Environment Advanced MS Excel How will I get my Receptionist: Office Admin and Reception Certificate? After successfully completing the Receptionist: Office Admin and Reception course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Receptionist: Office Admin and Reception bundle. Requirements Receptionist: Office Admin and Reception This Receptionist : Office Admin and Reception bundle has been designed to be fully compatible with tablets and smartphones. Career path Having this Receptionist: Office Admin and Reception expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Office Admin and Reception) 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. Certificate of completion Digital certificate - Included Certificate of completion is included in course price

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Ever feel like there's a secret handshake you need to know to break into the world of administration? We've all been there. But the truth is, with the right skills and training, you can be that friendly face greeting clients and the organised whiz behind the scenes any office needs. According to the UK's Office for National Statistics, the employment of receptionists is projected to grow by 8% from 2020 to 2030, significantly faster than the average for all occupations. This Receptionist program equips you with the essential knowledge and practical skills to excel in today's demanding workplace. Our comprehensive bundle equips you with the skills to excel as a receptionist and office administrator. Master communication, phone etiquette, and visitor management. Learn administrative tasks, UK employment law, customer service, minute-taking, and Microsoft Office. Become a highly sought-after professional! With a single payment, you will gain access to the Receptionist: Office Admin and Reception Training course, including 5 premium courses, and 5 PDF certificates for Absolutely Free. This Receptionist: Office Admin and Reception Training Bundle Contains 05 of Our Premium Courses for One Discounted Price: Course 01: Diploma in Receptionist Skills at QLS Level 5 Course 02: Administrative Receptionist Course 03: UK Employment Law Course 04: Customer Service Training & Minute-Taking Administrator Course 05: Complete Microsoft Office Enrolling in this bundle could be the key to unlocking a rewarding career path. Think receptionist, office administrator, personal assistant - the options are endless! So, what are you waiting for? Sign up today and watch your office skills take flight! Learning Outcomes of Receptionist: Office Admin and Reception Master professional communication for clear and impactful interactions. Develop exceptional telephone etiquette for a positive first impression. Gain a strong understanding of UK employment law and best practices. Enhance customer service skills to build strong client relationships. Learn effective minute-taking techniques for accurate meeting records. Achieve proficiency in Microsoft Office applications for efficient workflow. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Receptionist: Office Admin and Reception Get a free student ID card with Receptionist: Office Admin and Reception Training program (£10 postal charge will be applicable for international delivery) The Receptionist: Office Admin and Reception is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Receptionist: Office Admin and Reception course materials The Receptionist: Office Admin and Reception comes with 24/7 tutor support Course 01: Diploma in Receptionist Skills at QLS Level 5 Introduction to Reception and Receptionist Business Telephone Skills Representing Your Boss and Company Mail Services and Shipping Travel Arrangements Organising Meetings and Conferences Time Management Record Keeping and Filing Systems Business Writing Skills Organisational Skills Communication Skills Customer Service Effective Planning and Scheduling Invoicing/Petty Cash Business Environment Course 02: Administrative Receptionist Module 01: Introduction To Reception And Receptionist Module 02: Business Telephone Skills Module 03: Representing Your Boss And Company Module 04: Mail Services And Shipping Module 05: Travel Arrangements Module 06: Organising Meeting And Conferences Module 07: Time Management Module 08: Record Keeping And Filing Systems Module 09: Business Writing Skills Module 10 :Organisational Skills Module 11: Communication Skills Module 12: Customer Service Module 13: Effective Planning And Scheduling Module 14: Invoicing/Petty Cash Module 15: Business Environment Module 16: Advanced MS Excel Course 03: UK Employment Law Module 01: Basic Of Employment Law Module 02: Legal Recruitment Process Module 03: Employment Contracts Module 04: Employee Handbook Module 05: Disciplinary Procedure Module 06: National Minimum Wage & National Living Wage Module 07: Parental Right, Sick Pay & Pension Scheme Module 08: Discrimination In The Workplace Module 09: Health & Safety At Work Module 10: Dismissal, Grievances And Employment Tribunals Module 11: Workplace Monitoring & Data Protection =========>>>>> And 2 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*5 = £65) CPD Hard Copy Certificate: £29.99 CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Newcomers to office administration Career changers Individuals seeking upskilling Requirements You will not need any prior background or expertise to enrol in this bundle. Career path This Receptionist: Office Admin and Reception bundle will allow you to kickstart or take your career to the next stage in the related sector. Office Administrator Receptionist Manager Executive Assistant Customer Service Representative Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.