3411 Office Skills & Productivity courses delivered Online

Overview This comprehensive course on Minute Taking for PA and Admin Assistants | Animated Online Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Minute Taking for PA and Admin Assistants | Animated Online Course comes with accredited certification, 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 Minute Taking for PA and Admin Assistants | Animated Online Course. It is available to all students, of all academic backgrounds. Requirements Our Minute Taking for PA and Admin Assistants | Animated Online Course 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 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 2 sections • 7 lectures • 00:27:00 total length •Module 01: Introduction to Minute Writing: 00:06:00 •Module 02: Preparation for Minute Taking: 00:05:00 •Module 03: The Meeting Structure: 00:04:00 •Module 04: Minute Meetings, Decisions and Actions: 00:03:00 •Module 05: Minute Taking Techniques: 00:04:00 •Module 06: Building Confidence: 00:05:00 •Additional Reading Materials - Minute Taking for PA and Admin Assistants: 00:00:00

>> 12-Hour Knowledge Knockdown! Prices Reduced Like Never Before << In the fast-paced business world of the UK, where document management is crucial for organisational efficiency, the demand for skilled professionals in document control has skyrocketed. According to a recent survey by PwC, companies with robust document control procedures experience up to 33% higher productivity and 28% better adherence to compliance regulations. However, are you equipped with the necessary knowledge and skills to navigate the complexities of document control? This Document Control bundle aims to unlock the secrets of effective document control, empowering you to streamline processes and drive organisational success. With a single payment, you will gain access to the Diploma in Document Control course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Document Control Bundle Package includes: Main Course: Certificate in Document Control at QLS Level 3 10 Additional CPDQS Accredited Premium Courses - Course 01: Office Admin and Receptionist Skills Course 02: Proofreading & Copyediting Course 03: Touch Typing Masterclass Course 04: Microsoft Excel - Beginner, Intermediate & Advanced Course 05: Excel Data Analysis Course 06: Workplace Confidentiality Course 07: Contract Management Course Level 5 Course 08: Mastering Organizational Chaos Course Course 09: Professional Diploma in Stress Management Course 10: Online Time Management Training This comprehensive Document Control Bundle equips you with the skills and knowledge needed to excel in a document control role. You'll gain a strong foundation in document control principles and best practices, learn how to effectively manage the document lifecycle, and develop essential skills like proofreading, copyediting, and data analysis in Microsoft Excel. Learning Outcomes of Document Control Develop comprehensive knowledge and skills in document control principles and practices. Master office administration and receptionist tasks for efficient document handling. Enhance proofreading and copyediting abilities to ensure document accuracy. Gain proficiency in touch typing for improved productivity and efficiency. Learn advanced Microsoft Excel techniques for data analysis and management. Understand the importance of workplace confidentiality and contract management. Invest in your future by enrolling today and gain a competitive edge in the ever-evolving world of document control. Why Choose Our Document Control Bundle? Get a Free QLS Endorsed Certificate upon completion of Document Control Get a free student ID card with Document Control Training The Document Control is affordable and simple to understand The Document Control is an entirely online, interactive lesson with voiceover audio Lifetime access to the Document Control course materials The Document Control comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Main Course: Certificate in Document Control at QLS Level 3 Introduction Principles and Elements of Document Control Environment Lifecycle Strategies & Instruments Document Management Quality Assurance & Controlling Quality of Documents Project Document Control Electronic Document Management Systems & Soft Copy Documentation Course 01: Office Admin and Receptionist Skills 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 Course 02: Proofreading & Copyediting Module 1: Proofreading Basics Module 2: Applying The Style Guide Module 3: Spelling And Grammar Module 4: Proofreading On Paper Module 5: Proofreading On-Screen Module 6: Copy-Editing Basics Module 7: Copy-Editing - The Use Of Language Module 8: Copy-Editing - Checking Accuracy And Facts Module 9: Copy-Editing - The Beginning And The End Module 10: Copy-Editing - Legal Checks =========>>>>> And 8 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*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £89) CPD 230 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Document Control is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Document Controllers Admin Staff Project Coordinators Business Professionals Recent Graduates Career Changers Requirements No prior background or expertise is required for this Document Control bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Document Controller Records Manager Information Specialist Project Management Business Analyst Compliance Officer Certificates Certificate Accredited by CPDQS 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. Certificate in Document Control at QLS Level 3 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

24 Hour Flash Deal **25-in-1 Computer Hardware Engineer Mega Bundle** Computer Hardware Engineer Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Computer Hardware Engineer package online with Studyhub through our online learning platform. The Computer Hardware Engineer bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Computer Hardware Engineer course provides complete 360-degree training on Computer Hardware Engineer. You'll get not one, not two, not three, but twenty-five Computer Hardware Engineer courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Computer Hardware Engineer courses are yours for as long as you want them once you enrol in this course This Computer Hardware Engineer Bundle consists the following career oriented courses: Course 01: Computer Operating System and Troubleshooting Course 02: IT Support Technician: Troubleshooting and Technical Expertise Course 03: Diploma in CompTIA A+ Course 04: CompTIA ITF+ (FCO-U61) Course 05: CompTIA Cloud+ (CV0-002) Course 06: CompTIA Security+ Course 07: Foundations of IT Security: Protecting Digital Assets Course 08: Computer Networks Security from Scratch to Advanced Course 09: CompTIA Network+ Certification (N10-007) Course 10: Internet of Things (IoT) Course 11: Data Center Training Essentials: General Introduction Course 12: Microcontroller Simulation Course 13: Solidworks: Beginner to Advanced Course 14: MATLAB Simulink for Electrical Power Engineering Course 15: Robotics - Sensors Course 16: Advanced Arduino for Embedded Systems Course 17: Electric Vehicle Battery Management System Course 18: Electronic & Electrical Devices Maintenance & Troubleshooting Course 19: Electrical Engineering for Electrical Substations Course 20: Electrical Power System and High Voltage Engineering Course 21: Electronic Device Maintenance and Troubleshooting Course Course 22: Engine Lubrication Systems Online Course Course 23: Electrical Engineering - Light Current System Course 24: Electrical Components And Circuits - Wiring & Busbars Course 25: Network Security and Risk Management The Computer Hardware Engineer course has been prepared by focusing largely on Computer Hardware Engineer career readiness. It has been designed by our Computer Hardware Engineer specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Computer Hardware Engineer Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Computer Hardware Engineer bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Computer Hardware Engineer Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Computer Hardware Engineer Elementary modules, allowing our students to grasp each lesson quickly. The Computer Hardware Engineer course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Computer Hardware Engineer bundle, you really hit the jackpot. Here's what you get: Step by step Computer Hardware Engineer lessons One to one assistance from Computer Hardware Engineer professionals if you need it Innovative exams to test your knowledge after the Computer Hardware Engineer course 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Computer Hardware Engineer courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Computer Hardware Engineer certificate and transcript on the next working day Easily learn the Computer Hardware Engineer skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Computer Hardware Engineer training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Computer Hardware Engineer Requirements To participate in this Computer Hardware Engineer course, all you need is - A smart device A secure internet connection And a keen interest in Computer Hardware Engineer Career path You will be able to kickstart your Computer Hardware Engineer career because this course includes various courses as a bonus. This Computer Hardware Engineer is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Computer Hardware Engineer career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

The Microsoft Office Diploma Course Includes the following courses: Microsoft Excel for Beginners Certificate Microsoft Excel Advanced Certificate Microsoft Excel Intermediate Certificate Microsoft Outlook Certificate Microsoft PowerPoint Certificate Microsoft Word Certificate Please Note: This course uses the Microsoft 365 version of Office. Any other versions will have some differences in the functions. This comprehensive and all-encompassing course on the most popular and widely used Microsoft Office programs aims to provide you with thorough and detailed knowledge in all areas of Microsoft Office. In fact, this bumper course combines the content of six individual courses, making it the ideal package for those of you who want to solidify your learning on Microsoft Office, for either professional or personal reasons. Those who work in an office environment or who are re-entering the workplace after a break will really benefit from the structured learning that this course offers, allowing you to hit the ground running at work. However, the course is equally useful for those using Microsoft Office in a personal capacity, as many tasks that you need to do on your home PC will likely involve working on these programs. Each of the courses which make up this bumper course has been tailor-made to incorporate the key information and skills that you need in order to improve your proficiency in each area of Microsoft.  The courses are run with training videos, allowing you to work in an interactive way, and at your own pace. Let's take a more detailed look at what each course offers you: What You Will Learn The combined course covers the following courses in full: Microsoft Excel for Beginners Certificate Microsoft Excel Intermediate Certificate Microsoft Excel Advanced Certificate Microsoft Word Certificate Microsoft PowerPoint Diploma Microsoft Outlook Diploma. Microsoft Excel for Beginners Certificate Course The first of our Microsoft Excel courses is perfect for those individuals who are new to this program or who need to brush up their basic skills with more practice. Completion of this course also offers the ideal foundation before moving on to the more advanced units. It offers simple and clear definitions of some of the key terminology within Excel, such as cells, rows and columns and how to input, edit and delete data. There is also an introductory section on how to create and work with basic formulas and pivot tables, which will be covered in more detail in the Intermediate and Advanced units. The course also covers how to work with worksheets and tabs in Excel, such as renaming, deleting, hiding, moving and copying. Microsoft Excel Intermediate Certificate Course This unit builds upon the progress that you have made in the Beginners unit to look at more complex functions within Excel such as averages, medians, modes and roundings and the best methods to manipulate such functions to help you to get the information that you want out of the program. In addition, formatting methods within Excel are covered, including changing texts and backgrounds, adding special characters and using AutoFill options. Microsoft Excel Advanced Certificate Course This unit is the most comprehensive and detailed of the three and aims to prepare you for jobs or situations where you require a thorough and proficient level of Excel. This unit really gets into the detail of the analytical functions of Excel, including more complex formulas such as MATCH, INDEX and VLOOKUP and, crucially, how to decide upon the most appropriate formula for a particular calculation. After completing this unit, you should feel confident to use and manipulate the largest range of Excel formulas and be able to use Excel to its full functionality. Microsoft Word Certificate Course The ability to use Microsoft Word effectively is a crucial requirement of many office based roles. This course on Microsoft Word is an all-encompassing source of information which offers you the opportunity to enhance your skills in this widely-used program. You will learn a wide range of skills here, from the basics of entering text into a Word document, to how to use some of the editing and formatting tools available, including using the toolbars and various design features such as headers and hyperlinks, and many other aspects. Microsoft PowerPoint Diploma Course PowerPoint is a very useful program for those who are responsible for creating and delivering presentations in the workplace. By completing this course, you are taking a big step towards ensuring that your slideshows are professional and polished. The course starts from the beginning, assuming no prior knowledge of the area, and covers the creation of a PowerPoint presentation and the addition and editing of slides within it. You will also learn how to insert and format text, tables, images and graphics into your slides and how to effectively use SmartArt to give your presentations an extra special edge. You will learn effective methods to use linking and annotation features, as well as how to insert notes, comments and handout tools for your presentation. Microsoft Outlook Diploma Course Microsoft Outlook is very widely used as an email and organisation program in both professional and personal contexts and a solid familiarisation with its functionality will help you to really get the best out of using it. Our course will help you to get to grips with composing and responding to emails, including adding attachments and automatic signatures and creating out of office messages. It will help you to set up lists of contacts and create advanced rules to help Outlook work seamlessly for you. You will also learn all about the calendar functionalities, including how to set up meetings, navigating calendars and assigning tasks to others. The Benefits of our Microsoft Office Course Studying with us to achieve success in our Microsoft Office combined course can offer you many benefits; not least the confidence and ability to professionally and effectively work with some of the most frequently used administration and workplace systems in the world. Here are some of the other benefits that you can enjoy by undertaking this course: The course is intuitive and easy to follow, allowing you to work at your own pace and revisit key concepts or areas of difficulty as you need You can study at home, in your free time and on any compatible electronic device, making access simpler than ever The courses come complete with video training, helping you to solidify your learning We offer full online support from our specialists as you progress through the course There are no entry requirements - simply a willingness to learn You will receive an industry recognised certification upon successful completion of the course.

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

Overview This comprehensive course on Admin, Secretarial & PA - Level 7 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Admin, Secretarial & PA - Level 7 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 Admin, Secretarial & PA - Level 7. It is available to all students, of all academic backgrounds. Requirements Our Admin, Secretarial & PA - Level 7 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 21 sections • 21 lectures • 07:10:00 total length •Introduction to Personal Assistant: 00:20:00 •Introduction to Office Administration: 00:17:00 •Skills of an Effective Administrator: 00:18:00 •Introduction to Reception and Receptionist: 00:29:00 •Business Telephone Skills: 00:21:00 •Representing Your Boss and Company: 00:25:00 •Business Etiquette: 00:19:00 •Mail Services and Shipping: 00:26:00 •Travel Arrangements: 00:22:00 •Organising Meeting and Conferences: 00:19:00 •Diary Management and Note taking: 00:21:00 •Time Management: 00:25:00 •Record Keeping and Filing Systems: 00:24:00 •Business Writing Skills: 00:25:00 •Organisational Skills: 00:19:00 •Communication Skills: 00:19:00 •Customer Service: 00:22:00 •Effective Planning and Scheduling: 00:39:00 •Invoicing/Petty Cash: 00:20:00 •Assignment - Admin, Secretarial & PA - Level 7: 2 days •Workbook - Admin, Secretarial & PA - Level 7: 00:00:00

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

The comprehensive HR Management and Practices has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the HR Management and Practices today, and learn from the very best the industry has to offer! This best selling HR Management and Practices has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth HR Management and Practices is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The HR Management and Practices is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The HR Management and Practices is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the HR Management and Practices, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the HR Management and Practices will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the HR Management and Practices to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

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.

FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter