604 Courses in Liverpool delivered Online

5-in-1 Exclusive Microsoft Excel Bundle Course!!! Come and join in, on this exceptionally designed Microsoft Excel bundle course to transform yourself into an Excel wizard, regardless of your current skill level. With over 80% of jobs now requiring Excel skills in the UK, the ability to navigate and master this tool is more than just a resume booster-it's a necessity. From basics to advanced formulas, and even automated dashboards, this bundle is your golden ticket to unlocking the full potential of Excel, making data analysis and presentation not just easier, but a true delight. This comprehensive bundle starts by guiding you through Beginner, Intermediate, and Advanced levels of Excel. You'll then explore the Newest Functions and dive deep into 25 Must-know Formulas and Functions that are game-changers. But we don't stop there; you'll learn to create Automated Dashboards using Advanced Formulas, VBA, and Power Query, and even get a mastery tour of the entire Microsoft Office Suite, including Word, PowerPoint, and 365. It's a well-rounded education designed to make you proficient and efficient in handling any task Excel throws your way. The Microsoft Excel Course includes these 5 Premium Courses: Course 01: Microsoft Excel - Beginner, Intermediate & Advanced Course 02: New Functions in Microsoft Excel Course 03: Microsoft Excel - 25 Must-Know Formulas and Functions Course 04: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 05: Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Streamline your business processes, or just attempt to upskill for personal satisfaction, our Microsoft Excel Bundle Course is the leap forward you've been waiting for. In today's data-driven world, being Excel-savvy isn't just an asset; it's a must-have skill. Join us on this journey to becoming an Excel expert and open doors to endless career opportunities. Enrol now! Learning Outcomes of Microsoft Excel Course: Navigate Excel from basic operations to advanced functionalities confidently. Master new functions and 25 essential formulas in Excel. Design and implement automated dashboards with VBA and Power Query. Utilise the full suite of Microsoft Office for professional use. Analyse and present data effectively using Excel. Increase workplace productivity with advanced Excel skills. Why Choose Our Microsoft Excel Course? Get a Free CPD Accredited Certificate upon completion of Microsoft Excel course. Get a free student ID card with Microsoft Excel Training. Get instant access to this Microsoft Excel course. Learn Microsoft Excel from anywhere in the world. This Microsoft Excel course is affordable and simple to understand. The Microsoft Excel course is an entirely online, interactive lesson with voiceover audio. Lifetime access to the Microsoft Excel course materials. The Microsoft Excel course comes with 24/7 tutor support. Start your learning journey straight away! Course 01: Microsoft Excel - Beginner, Intermediate & Advanced Module 01: Excel From A-Z Course Introduction Module 02: Getting Started With Excel Module 03: Values, Referencing And Formulas Module 04: Intro To Excel Functions Module 05: Adjusting Excel Worksheets Module 06: Visually Pleasing Cell Formatting Module 07: How To Insert Images And Shapes! Module 08: Visualize Data With Charts Module 09: Excel's Printing Options Module 10: Benefits Of Using Excel Templates Module 11: Working With Excel Datasets Module 12: Excel Database Functions Module 13: Excel Data Validation Module 14: Excel PivotT ables Module 15: Excel's Power Pivot Add-In Module 16: Excel's Conditional Functions Module 17: Excel's Lookup Function Module 18: Text Based Functions In Excel Module 19: Auditing Formulas And Views In Excel Module 20: Excel's 'What If?' Tools Module 21: Welcome To Excel VBA Module 22: The VBA Language Module 23: Writing VBA Code Module 24: Important VBA Tools And Logic Module 25: Excel VBA Lopps Module 26: Triggering Macros Module 27: Excel User Forms Module 28: Starting A Career In Excel Course 02: New Functions in Microsoft Excel Module 01: Introduction and Agenda Module 02: RANDARRAY Module 03: UNIQUE Module 04: SEQUENCE Module 05: SORT and SORTBY Module 06: SORT A Practical Example Module 07: FILTER Module 08: FILTER A Practical Example Module 09: Other Useful New Functions Module 10: Using the New Functions in Reports Course 03: Microsoft Excel - 25 Must-Know Formulas and Functions Module 01: 25 Must-Know Formulas and Functions =========>>>>> And 2 More Courses <<<<<========= This course's curriculum has been designed by Microsoft Excel experts with years of Microsoft Excel experience behind them. The Microsoft Excel course is extremely dynamic and well-paced to help you understand Microsoft Excel with ease. You'll discover how to master the Microsoft Excel skill while exploring relevant and essential topics. 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 50 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: Job seekers Office professionals Data analysts Business owners Students Career improvers Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Data Analyst - £30,000 to £50,000 Financial Analyst - £35,000 to £60,000 Administrative Assistant - £20,000 to £30,000 Project Manager - £40,000 to £70,000 Business Analyst - £35,000 to £65,000 Accountant - £25,000 to £50,000 Certificates CPD Accredited Certificate Digital certificate - Included Upon passing the Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD. CPD Accredited Certificate Hard copy certificate - £29 Upon passing the Bundle, you need to order to receive a Hard copy Certificate for each of the courses inside this bundle. If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

This Microsoft Excel Training Bundle will teach you to create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at high level. Also, our Excel experts are available to answer your queries and help you along your learning journey. Advanced audiovisual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Excel, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Bundle Consists of the following Premium courses: Course 01: Microsoft Excel Level 3 Course 02: New Functions in Microsoft Excel 2021 Course 03: Microsoft Excel Sheet Comparison with VBA Course 04: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 05: Microsoft Excel Master Power Query in 120 Minutes! Course 06: Microsoft Excel Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07: Financial Modeling Using Excel Course 08: Business Analysis Level 3 Course 09: Touch Typing Essentials Course 10: Information Management Course 11: Data Protection and Data Security Level 2 Course 12: Microsoft Teams Course 13: Office Skills and Administration Management Diploma Course 14: Creativity and Problem-Solving Skills Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 14 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. Curriculum of Bundle Course 01: Microsoft Excel Level 3 Microsoft 019 New Features Getting Started Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and Pivot Charts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparkline's and Mapping Data Forecasting Data Templates Course 02: New Functions in Microsoft 021 Introduction and Agenda RANDARRAY UNIQUE SEQUENCE SORT and SORTBY SORT A Practical Example FILTER FILTER A Practical Example Other Useful New Functions Using the New Functions in Reports Course 03: Microsoft Excel Sheet Comparison with VBA Introduction to Compare Data Workbook Comprehensive Introduction to Compare Data Excel VBA Workbook Modify VBA Codes to Suit Your Needs Data Cleaning, Format and Structure Your Datasets with Power Query Practical and Real world application of Compare Data Workbook Conclusion Course 04: Top 50 Microsoft Excel Formulas in 50 Minutes! promo Getting the most of the course How to Get the most of the course Text formulas Text Formulas Exercise Text Formulas Exercise (answers) and many more... Course 05: Microsoft Master Power Query in 120 Minutes! Power Query Intro and version Introduction Query Editor Ribbon Trim in Excel Power Query Format Dates and Values and many more... Course 06: Automated Dashboard Using Advanced Formula, VBA, Power Query Introduction Prepaid Expenses Models: Resources Download Accounting for Prepaid Expenses Formulas Detailed: Introduction to three Models and many more... Course 07: Financial Modeling Using Excel Welcome to the Course! Get the Overview of What You'll Learn Planning your Financial Model Building a Model Template Projecting the Income Statement and many more... Course 08: Business Analysis Level 3 Introduction to Business Analysis Business Processes Business Analysis Planning and Monitoring Strategic Analysis and Product Scope Solution Evaluation and many more... Course 09: Touch Typing Essentials Introduction How to Set up Your Computer How to type the letters F and J How to type the letters D and K How to type the letters S and L How to type the letter A and ; (semicolon) How to type the letters E and I And Many More... Course 10: Information Management Introduction to Information Management Information Management Strategy Databases and Information Management Management Information Systems (MIS) Auditing Information Systems Ethical and Social Issues and Data Protection Course 11: Data Protection and Data Security Level 2 GDPR Basics GDPR Explained Lawful Basis for Preparation Rights and Breaches Responsibilities and Obligations Course 12: Microsoft Teams MS Teams - Introduction Mastering MS Teams Top MS Teams Tips Course 13: Office Skills and Administration Management Diploma Personal Assistant Admin Support Administrative Management Organisational Skills Telephone Etiquette and many more... Course 14: Creativity and Problem Solving Skills CPD 150 CPD hours / points Accredited by CPD Quality Standards Certificates Certificate of completion Digital certificate - Included

Excel Spreadsheet Training Course Overview Tired of staring at endless rows and columns in frustration? Would you like to transform your data into insights that impress your boss and streamline your work? Then welcome to Excel Spreadsheet Training: Your Journey from Spreadsheet Novice to Spreadsheet Ninja! At the beginning of the Excel Spreadsheet Training course, you will acquire a thorough understanding of the Excel interface, confidently navigating and leveraging its features for efficient spreadsheet management. Besides, you will learn to enter and manipulate various data types, including text, numbers, time, logical values, and graphics, ensuring accurate and diverse information representation. This course will help you increase your productivity as you master Autofill and Speedfil functionalities, streamlining your workflow and saving valuable time during data entry. Additionally, this Excel Spreadsheet Training course will assist you in developing the skills to save files effectively, ensuring data security and accessibility while maintaining a well-organized digital workspace. Expertise in formulas increases Excel efficiency. In this Excel Spreadsheet Training course, you will gain a solid foundation in Formula Basics, understand the mathematical order behind formulas, and confidently create and manipulate them to suit your analytical needs. Furthermore, you will learn the art of copying relative and absolute formulas, facilitating efficient replication of calculations across your spreadsheet. As you move deeper into the Excel Spreadsheet Training course, you will learn the tricks and techniques to manage the sheets efficiently. When you finish the course, you will be introduced to the functions enabling you to harness Excel's full potential for complex data analysis and decision-making. Without any further delay, enrol in the Excel Spreadsheet Training course to make a fast progression in your career.  Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Excel spreadsheet for Beginner Tour of the Excel screen 00:10:00 Entering Data 00:13:00 Autofill Speedfill 00:09:00 Saving the file 00:02:00 Autosum 00:04:00 Formula Basics 00:11:00 Copying formulas - Relative Formulas 00:04:00 Totals and Averages 00:04:00 Formatting the Spreadsheet 00:07:00 Managing the Sheets 00:06:00 Copying formulas - absolute formulas 00:08:00 Linking the Sheets together 00:06:00 Introduction to Functions 00:05:00

🚀 Unleash Your Excel Mastery with 'Microsoft Excel 2016 (Basic to Advanced)' Course! 🚀 Are you tired of spending hours grappling with Excel, only to end up with frustrating and inefficient solutions? Do you dream of becoming the Excel wizard in your workplace, effortlessly creating powerful and efficient solutions? Look no further! Introducing our groundbreaking online course: 'Microsoft Excel 2016 (Basic to Advanced).'   🌟 Why Choose 'Microsoft Excel 2016 (Basic to Advanced)'? ✅ Master Advanced Excel Techniques: Dive deep into the world of Excel with our comprehensive modules that cover everything from advanced formulas and functions to data visualization and analysis. ✅ Practical Real-World Applications: Say goodbye to theoretical lessons! We focus on real-world scenarios, ensuring you can immediately apply your newfound skills to solve complex problems in your professional life. ✅ Build Efficiency: Learn the secrets of crafting efficient and streamlined Excel solutions. From automating repetitive tasks to optimizing complex workflows, you'll become a productivity powerhouse. ✅ Expert-Led Instruction: Our experienced instructors are Excel aficionados with a passion for teaching. Benefit from their wealth of knowledge and insider tips, ensuring you stay ahead of the curve. ✅ Interactive Learning: Engage with hands-on exercises, quizzes, and projects that reinforce your understanding and transform you into a confident Excel pro. ✅ Lifetime Access: Gain unlimited access to the course content, updates, and a supportive community. Your learning journey doesn't end - it evolves.   🎓 What You'll Learn: Advanced Formulas and Functions: Supercharge your spreadsheet skills with complex formulas and functions, unlocking Excel's true potential. Data Visualization Mastery: Transform raw data into visually stunning charts and graphs, making your reports and presentations more impactful. Automation Techniques: Streamline your work by mastering Excel's automation features, saving time and reducing errors. Data Analysis Strategies: Unlock the power of PivotTables, data models, and analysis tools to gain valuable insights from your data. Optimizing Workflows: Learn to design efficient workflows and templates that enhance collaboration and productivity.   🌐 Who Is This Course For? Professionals aiming to boost their Excel proficiency. Entrepreneurs seeking to optimize business processes. Students preparing for a data-driven career. Anyone who wants to stay ahead in today's competitive workplace.   Don't miss out on this opportunity to elevate your Excel skills and stand out in the crowd. Join 'Microsoft Excel 2016 (Basic to Advanced)' today and pave the way for a successful and efficient future! Course Curriculum Microsoft Excel 2016 Basic Pre Sell Video 00:00 Lesson 1 - Overview 00:00 Lesson 2 - Interface 00:00 Lesson 3 - File Menu - Part 1 00:00 Lesson 4 - File Menu - Part 2 00:00 Lesson 5 - Home Menu 00:00 Lesson 6 - Insert Menu 00:00 Lesson 7 - Page Layout Menu 00:00 Lesson 8 - Formulas Menu 00:00 Lesson 9 - Data Menu - Part 1 00:00 Lesson 10 - Data Menu - Part 2 00:00 Lesson 11 - Review Menu 00:00 Lesson 12 - View Menu 00:00 Lesson 13 - Templates 00:00 Lesson 14 - Dates 00:00 Lesson 15 - Numbers 00:00 Lesson 16 - Text 00:00 Lesson 17 - B - Calculations-Manual 00:00 Lesson 18 - Calculations 00:00 Lesson 19 - Page Set Up 00:00 Lesson 20 - Print Settings 00:00 Lesson 21 - Conclusion 00:00 Microsoft Excel 2016 Advanced Lesson 1 - Overview 00:00 Lesson 2 - Calculations - Absolute References 00:00 Lesson 3 - Calculations - Relative References 00:00 Lesson 4 - Using Logical Formulas 00:00 Lesson 5 - Using Text Formulas 00:00 Lesson 6 - Using Lookup Formulas 00:00 Lesson 7 - Using Financial Formulas 00:00 Lesson 8 - Using Date and Time Formulas 00:00 Lesson 9 - Sorting Data 00:00 Lesson 10 - Formatting Data into Tables 00:00 Lesson 11 - Using Pivot Tables - Part 1 00:00 Lesson 12 Using Pivot Tables - Part 2 - Design 00:00 Lesson 13 - Formatting Data as Charts 00:00 Lesson 14 - Formatting As Data as Maps 00:00 Lesson 15 - Formatting Data as Formal Reports 00:00 Lesson 16 - Formatting Data for Other Office Documents 00:00 Lesson 17 - Cell Protection and Collaboration 00:00 Lesson 18 - Cell Protection and Collaboration - Part 2 00:00 Lesson 19 - Interface with Google Sheets 00:00 Lesson 20 - Conclusion 00:00

Expand your Excel knowledge and learn how to structure and analyse large data sets.

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

Overview This comprehensive course on Office Admin and Reception will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Office Admin and Reception comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. 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 Admin and Reception. It is available to all students, of all academic backgrounds. Requirements Our Office Admin and Reception is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 17 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

Master Microsoft Excel with this comprehensive online certification bundle. Learn advanced formulas, data analysis, automation, and visualizations for professional success.

Comprehensive documentation of procedures, formulas, work instructions, and specifications, and thorough recording of batch data, are fundamental requirements of GMP. In this short course we explain why documentation is so important, identify different types of document required, and set out some simple rules for recording and correcting data.

The Executive Secretarial & PA Course is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Executive Secretarial & PA Course consists of several modules that take around 11 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why Choose this Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full tutor support on weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 1: Introduction to Personal Assistant Introduction to Personal Assistant 00:18:00 Module 2: Business Telephone Skills Business Telephone Skills 00:20:00 Module 3: Representing Your Boss and Company Representing Your Boss and Company 00:37:00 Module 4: Mail Services and Shipping Mail Services and Shipping 00:28:00 Module 5: Travel Arrangements Travel Arrangements 00:27:00 Module 6: Organising Meeting and Conferences Organising Meeting and Conferences 00:28:00 Module 7: Time Management Time Management 00:38:00 Module 8: Record Keeping and Filing Systems Record Keeping and Filing Systems 00:31:00 Module 9: Business Writing Skills Business Writing Skills 00:43:00 Module 10: Organisational Skills Organisational Skills 00:28:00 Module 11: Communication Skills Communication Skills 00:28:00 Module 12: Customer Service Customer Service 00:19:00 Module 13: Effective Planning and Scheduling Effective Planning and Scheduling 00:49:00 Module 14: Document Proofreading and Editing Document Proofreading and Editing 00:08:00 Module 15: Advanced MS Excel Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! 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 VLOOKUP: Master Excel Formula VLOOKUP in 60 minutes! 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 Microsoft Excel: Master Power Query in 120 Minutes! 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:06:00 Microsoft Excel Keyboard Shortcuts 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 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.