8909 Courses in Cardiff delivered On Demand

Discover the power of proofreading AI tools like Grammarly and ProWritingAid. Master your skills in editing and proofreading for any legal or official document.

Intermediate Microsoft Word 2016 Training Course Overview Are you looking to begin your Microsoft Word career or want to develop more advanced skills in Microsoft Word? Then this intermediate Microsoft Word 2016 online training course will set you up with a solid foundation to become a confident office admin and help you to develop your expertise in Microsoft Word. This intermediate Microsoft Word 2016 online training course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this intermediate Microsoft Word 2016 online training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as an office admin. The intermediate Microsoft Word 2016 online training course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as office admin. This comprehensive intermediate Microsoft Word 2016 online training course is the perfect way to kickstart your career in the field of Microsoft Word. This intermediate Microsoft Word 2016 online training course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as an office admin or want to learn more skills on Microsoft Word but unsure of where to start, then this intermediate Microsoft Word 2016 online training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This intermediate Microsoft Word 2016 online training course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who should take this course? This comprehensive intermediate Microsoft Word 2016 online training course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Word. Entry Requirement There are no academic entry requirements for this intermediate Microsoft Word 2016 online training course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Method of Assessment On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately. Career path This intermediate Microsoft Word 2016 online training course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Course Curriculum Organizing Content Using Tables and Charts Work With Tables - Introduction Sort Table Date Control Cell Layout Perform Calculations In A Table Add An Excel Table To A Word Document Work With Charts - Introduction Create A Chart Customizing Formats Using Styles and Themes Create And Modify Text Styles - Introduction Create And Modify Text Styles Create Custom Lists Or Table Styles - Introduction Create Custom Lists Or Table Styles Apply Document Themes - Introduction Apply Document Themes Inserting Content Using Quick Parts Automate Adding Text With Building Blocks - Introduction Insert Building Blocks Create And Modify Building Blocks Insert Fields Using Quick Parts - Introduction Insert Fields Using Quick Parts Using Templates to Automate Document Formatting Using Templates To Automate Document Formatting - Introduction Create A Document Using A Template Create A Template Modify A Templat Manage Templates With The Template Organizer Controlling the Flow of a Document Control The Flow Of A Document - Introduction Control Paragraph Flow Insert Section Breaks Insert Columns Link Text Boxes to Control Text Flow Simplifying and Managing Long Documents Simplify And Manage Long Documents - Introduction Insert Blank and Cover Pages Insert an Index Insert A Table Of Contents Insert A Table Of Figures Work With Table Of Authorities Manage Outlines - Introduction Manage Outlines Create A Master Document - Introduction Working With Master Documents Using Mail Merge to Create Letters, Envelopes and Label Mail Merge - Introduction Prepare For A Mail Merge Perform A Mail Merge Bonus Lecture Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Learning Objectives Introduction , Accessing PDFs , Creating PDFs , Navigating PDFs , Reviewing PDFs , Modifying PDFs , Optimizing PDFs , Exporting PDFs , Protecting PDFs , Conclusion Pre-Requisites Basic computer skills. Knowledge of PDF concepts is helpful but not required. Description Workplace demand for digital media skills including creating, managing, and integrating PDF documents is on the rise. Adobe Acrobat training is an excellent way to learn and validate your digital communication skills. This brings value to prospective clients and employers. Unit 1: Introduction to Adobe Acrobat Lesson 1-Introducing Acrobat and PDFs 00:03:00 Lesson 2-Opening a PDF and Navigating Acrobat 00:09:00 Lesson 3-Customizing Toolbars 00:03:00 Lesson 4-Changing Preferences 00:04:00 Unit 2: Introduction to Creating PDFs Lesson 1-Creating PDFs from Office 00:09:00 Lesson 2-Creating PDFs from Creative Cloud Apps 00:10:00 Lesson 3-Creating PDFs from the Document Cloud 00:04:00 Lesson 4-Storing PDFs 00:05:00 Lesson 5-Combining PDFs 00:05:00 Unit 3: Using Search, Bookmarks and Links Lesson 1-Using Search 00:06:00 Lesson 2-Creating Bookmarks 00:06:00 Lesson 3-Creating Links 00:10:00 Unit 4: Commenting Lesson 1-Commenting on a PDF 00:10:00 Lesson 2-Sending for Comments 00:07:00 Unit 5: Editing PDFs Lesson 1-Editing Text and Images 00:06:00 Lesson 2-Cropping Images 00:03:00 Lesson 3-Adding, Updating and Removing Headers and Footers 00:09:00 Lesson 4-Using Watermarks 00:07:00 Lesson 5-Organizing Pages 00:03:00 Lesson 6-Extracting Pages 00:03:00 Lesson 7-Inserting Pages 00:03:00 Lesson 8-Replacing Pages 00:03:00 Unit 6: Advanced Features Lesson 1-Reducing File Size 00:05:00 Lesson 2-Advanced Optimization 00:16:00 Lesson 3-Using Actions 00:04:00 Lesson 4-Creating Actions 00:08:00 Unit 7: Exporting Lesson 1-Exporting to Word 00:05:00 Lesson 2-Exporting to Excel 00:04:00 Lesson 3-Exporting to Rich Text Format 00:04:00 Unit 8: Protecting File Lesson 1-Redacting Content 00:08:00 Lesson 2-Protecting a PDF 00:15:00 Resource Resource - Adobe Acrobat Pro DC Beginner 00:00:00 Final Exam Final Exam - Adobe Acrobat Pro DC Beginner 00:20:00

Jumpstart your creative journey with our Adobe After Effects Complete Guide for Beginners. Master the basics from importing footage to exporting videos, and learn key animation techniques to bring your visual concepts to life. Perfect for aspiring graphic artists and video editors.

If you are particular about word choice, and if typos and clunky sentences drive you to distraction, you may have what it takes to be a proofreader and editor. The Proofreading and Copy Editing Course is for those who want to work professionally in the proofreading and editing field. It also provides an excellent foundation for anyone who needs to Proofread and edit documents in the workplace. No manual, book, magazine, website, brochure, or business letter is sent out to an audience without Proofreading. This Proofreading and Copy Editing Bundle will prepare you for a lucrative and satisfying career in this fascinating area of business. You will be expertly trained to check, edit, and adapt the text to the highest of standards and earn yourself a substantial reputation. We'll help you gain the skills you need to get hired by publishers, business owners and curators of online content. Our professional Proofreader & editor will be there to guide you and assess your work every step of the way. Along with this Proofreading and Copy Editing Bundle, you will get an original hardcopy certificate, transcript and a student ID card. Courses are included with this Proofreading and Copy Editing Bundle Course 1: Proofreading & Copy Editing Course 2: Advanced Diploma in Copywriting Course 3: Writing Short Story Training Course 4: Certificate in CV Writing and Interview Skills Course 5: Functional Skills English Practice Level 2 Course 6: Improve English Spelling, Punctuation, Grammar and Pronunciation Course 7: Phonics Teaching Assistant Course 8: Touch Typing Essentials Course 9: Document Control Course 10: MS Word Diploma Course 11: Time Management All leading companies that produce content of any kind need to experience Proofreaders and Copy Editors. Become trained in this profession and secure rewarding roles. This Proofreading and Copy Editing Bundle Course is designed to train you quickly in all the abilities needed to perform quality control and amendments ahead of publishing. Proofreading and Copy Editing Bundle has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. Learning Outcomes of Proofreading & Copy Editing Copywriting: Learn about Proofreading terminology Deepen your understanding of language awareness and grammatical knowledge How to implement the style guide Learn how to spot and correct spell and grammatical errors How to master spelling and grammar How to identify the weaknesses in the text How to proofreading on paper, and proofreading on-screen Learn the different methods and techniques of proofreading The copy-editing basics, checking accuracy and facts, do legal checks, and much more Course Curriculum Proofreading & Copyediting Course 1: Proofreading & Copy Editing 01: Proofreading Basics 02: Applying the Style Guide 03: Spelling and Grammar 04: Proofreading on Paper 05: Proofreading On-Screen 06: Copy-Editing Basics 07: The Use of Language 08: Checking Accuracy and Facts 09: The Beginning and The End 10: Legal Checks 11: Finding Work and Developing Your Career ------- 10 more courses--------- 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 (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this Proofreading and Copy Editing Bundle. It is available to all students, of all academic backgrounds. Requirements Our Proofreading and Copy Editing Bundle 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 Proofreading and Copy Editing Bundle would be beneficial for any related profession or industry such as: Newspaper editor Copywriter Publishing Proofreading business Reporter English teacher Certificates Certificate of completion Digital certificate - Included

Master 75+ Excel tips and techniques and become a certified POWER USER, with unique hands-on demos and real-world projects to help you wrangle, analyze, and visualize your data in Excel.

Unlock the art of whiteboard animation with our beginner-friendly VideoScribe course. Learn to create engaging animations for business, education, or personal projects, and bring your stories to life visually.

Learn the advanced techniques of HTML 5, CSS 3, and Bootstrap for designing excellent and professional web pages with the Web Design with HTML5, CSS3 and Bootstrap course. HTML 5, and CSS 3 are the basic building blocks of the websites. And with the help of Bootstrap, you will be able to design and develop responsive and mobile-ready websites. The course is designed for the people who want to know the strategies of building a stunning website. Throughout the course, you will learn to build custom websites using HTML 5, and CSS 3. Then, you will learn to make the websites responsive using Bootstrap. The course includes three real-world projects and guides you to design a landing page, a business website and portfolio sites, After finishing the course, you will be able to design any types of responsive websites using HTML 5, CSS 3, and Bootstrap. What Will I Learn? You will learn how to build a custom website with HTML, CSS, and Bootstrap You will learn real-world skills to build professional and modern websites You will learn the basic building blocks to becoming a web developer You will learn to build websites while you learn each building block - HTML, CSS, Bootstrap You will get bonus downloadable cheat sheets and guides to help you quickly design your websites You will learn how to use each skill in the real world with case studies You will learn basic web design tips so your websites look and act professionally Requirements No coding experience necessary Seriously, you don't need to know anything about websites or coding! Any computer will be fine - Windows, OSX or Linux We'll show you free tools that you can use to follow along and build your own websites in the course Module: 01 1.1 Intro FREE 00:03:00 1.2 Install the Tools and Get Started 00:05:00 Module: 02 2.1 Intro to HTML FREE 00:01:00 2.2 What is HTML 00:11:00 2.3 Start a New HTML File & Use Tags 00:12:00 2.4 Header Tags 00:05:00 2.5 Edit Text 00:09:00 2.6 Links 00:09:00 2.7 Images 00:10:00 2.8 Lists 00:04:00 2.9 Challenge 1 00:16:00 2.10 HTML Outro 00:01:00 Module: 03 3.1 CSS Intro 00:04:00 3.2 Add CSS Styles 00:16:00 3.3 Classes and IDs 00:07:00 3.4 Borders 00:06:00 3.5 Sizing 00:04:00 3.6 Padding and Margin 00:07:00 3.7 Text Styles 00:04:00 3.8 DIVs 00:08:00 3.9 Postioning 00:08:00 3.10 Hover 00:03:00 3.11 Easily Center Elements 00:03:00 3.12 Fonts 00:06:00 3.13 Challenge 00:23:00 3.14 CSS Outro 00:01:00 Module: 04 4.1 Intro to Bootstrap 00:02:00 4.2 Install Bootstrap 00:10:00 4.3 Indenting and Containers 00:07:00 4.4 The Grid System 00:16:00 4.5 Images 00:07:00 4.6 Buttons 00:06:00 4.7 Challenge 3 00:11:00 4.8 Bootstrap Outro 00:01:00 Module: 05 5.1 Landing Page Intro 00:01:00 5.2 Sketch Your Landing Page 00:05:00 5.3 The Top Section 00:16:00 5.4 Polish the Top Section 00:06:00 5.5 Adding Images 00:11:00 5.6 The Main Points Section 00:14:00 5.7 Collecting Emails With an Opt-In Form 00:11:00 5.8 Challenge 4 00:03:00 5.9 Landing Page Outro 00:02:00 Module: 05 6.1 Business Site Intro 00:01:00 6.2 Sketch Up 00:03:00 6.3 Using Fancy Font Logo 00:07:00 6.4 Carousel Basics 00:10:00 6.5 Carousel Extras 00:09:00 6.6 Text on Images 00:15:00 6.7 Phone Number Icon 00:04:00 6.8 Google Maps 00:13:00 6.9 Font Awesome 00:09:00 6.10 Challenge 4 00:08:00 6.11 Business Site Outro 00:01:00 Module: 07 7.1 Intro 00:01:00 7.2 Portfolio Sketch 00:08:00 7.3 Jumbotron 00:10:00 7.4 Nav Bar 00:24:00 7.5 Panels 00:11:00 7.6 Challenge 5 00:13:00 7.7 Portfolio Outre 00:01:00 Module: 08 8.1 Hosting 00:01:00 8.2 Bluehost 00:06:00 8.3 Uploading 00:05:00 8.4 Tips 00:11:00 8.5 Hosting Outro 00:01:00

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.

Overview Learn to use the full power and functionality of Microsoft's Excel and deliver impressive charts and analysis work. This Advanced Diploma in MS Excel course allows you to exploit the full abilities of Microsoft's best-selling tool and become capable of providing higher-quality results from it. You may use Excel every day in your work or business, but are you really using it to its full potential? With the advanced training from this course, you will quickly produce stunning spreadsheets and visually perfect graphs that will showcase business data to a much more professional degree. Use Excel to make your customer service excellent. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Advanced Diploma in MS Excel. It is available to all students, of all academic backgrounds. Requirements Our Advanced Diploma in MS Excel 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 21 sections • 90 lectures • 22:14:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:08:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Work with Ranges: 00:18:00 •Use Specialized Functions: 00:11:00 •Work with Logical Functions: 00:23:00 •Work with Date & Time Functions: 00:08:00 •Work with Text Functions: 00:11:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00 •Create a Macro Using the Macro Recorder: 01:00:00 •Edit a Macro: 01:00:00 •Debug a Macro: 00:30:00 •Customize the Quick Access Toolbar and Hotkeys: 00:30:00 •Set Macro Security: 01:00:00 •Insert Text: 00:30:00 •Format Text: 00:30:00 •Sort Data: 00:30:00 •Duplicate Data: 01:00:00 •Generate a Report: 01:00:00 •Determine the Dialog Box Type: 00:15:00 •Capture User Input: 01:00:00 •Insert, Copy, and Delete Worksheets: 00:30:00 •Rename Worksheets: 00:30:00 •Modify the Order of Worksheets: 00:15:00 •Print Worksheets: 00:30:00 •Create User-Defined Functions: 00:30:00 •Automate SUM Functions: 00:30:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Advanced Diploma in MS Excel: 00:05:00