• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

11695 Video courses delivered Online

Microsoft Office 2016 Excel Intermediate - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2016 Excel Intermediate - Complete Video Course 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. If you have equivalent knowledge of Microsoft Excel 2016 Introduction then this course is perfect for you to expand your knowledge and skills. So, if you want to advance your skill set by learning to work with advanced formulas, lists, and illustrations you can join this course. You will also work with charts and advanced formatting including styles. So, why are you thinking? Come and be a part of this course now. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Excel Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Excel Intermediate - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Working with Functions Work with Ranges FREE 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 Working with Lists 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 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts 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 Mock Exam Mock Exam- Microsoft Office 2016 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2016 Excel Intermediate - Complete Video Course
Delivered Online On Demand4 hours 16 minutes
£22

Microsoft Office 2010 Access Intermediate - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2010 Access Intermediate - Complete Video Course builds on the skills and concepts taught in Access 2010: Basic. In this series, you will learn about relational databases, related tables, complex queries, advanced form design, reports and printing, charts, and PivotTables and PivotCharts. From building reports to using conditional formatting, you'll see how to present your data and gain techniques for using Visual Basic to automate common tasks. You will discover the fundamentals of database design and construction, which will allow you to construct a strong relational database that makes future modifications and data analysis easier. Do you want to take your Microsoft Access skills to the next level? In this course, you'll master more advanced techniques for this powerful database program and build an entire data project from scratch. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2010 Access Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2010 Access Intermediate - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Relational Databases Database Normalization 00:14:00 Table Relationships 00:13:00 Referential Integrity 00:12:00 Related Tables Creating Lookup Fields 00:11:00 Modifying Lookup Fields 00:06:00 Using Subdatasheets 00:04:00 Complex Queries Joining Tables in Queries 00:26:00 Using Calculated Fields 00:09:00 Summarizing and Grouping Values 00:08:00 Advanced Form Design Adding Unbound Controls 00:08:00 Adding Graphics 00:04:00 Adding Calculated Values 00:06:00 Adding Combo Boxes 00:04:00 Advanced Form Types 00:10:00 Reports and Printing Customized Headers and Footers 00:17:00 Calculated Values 00:08:00 Printing 00:03:00 Labels 00:05:00 Charts Charts in Forms 00:08:00 Charts in Reports 00:06:00 PivotTables and PivotCharts PivotTables 00:05:00 Modifying PivotTables 00:07:00 PivotCharts 00:04:00 PivotTable Forms 00:01:00 Mock Exam Mock Exam- Microsoft Office 2010 Access Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Access Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2010 Access Intermediate - Complete Video Course
Delivered Online On Demand3 hours 59 minutes
£22

Microsoft Office 2016 Excel Advanced - Complete Video Course

4.3(43)

By John Academy

Description: Nowadays Excel has become very much more than just a simple spreadsheet. Although its roots are still in number management, today Excel's uses cover a wide gamut - from simple data entry to complicated financial models and analysis. This Microsoft Office 2016 Excel Advanced - Complete Video Course is designed to help you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. You will learn Visualize data with charts, how to use PivotTables and PivotCharts, working with powerful Functions you need to know, and more. So, if you have intermediate skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface. Then this advanced level will be very helpful for you. So, be an expert by joining us. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Working with Multiple Worksheets and Workbooks Use Links and External References FREE 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data 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 Mock Exam Mock Exam- Microsoft Office 2016 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2016 Excel Advanced - Complete Video Course
Delivered Online On Demand3 hours 14 minutes
£21

Introduction to Roadbooks Training Video

By Rally Navigation Training Services

Learn how to read and use a roadbook in the style commonly used in many forms of rallying.

Introduction to Roadbooks Training Video
Delivered Online On Demand
£20

ZOOM: Master Video Conferencing in Just 40 minutes!

5.0(10)

By Apex Learning

Overview This comprehensive course on ZOOM: Master Video Conferencing in Just 40 minutes! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This ZOOM: Master Video Conferencing in Just 40 minutes! 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? After successfully completing the course 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 ZOOM: Master Video Conferencing in Just 40 minutes!. It is available to all students, of all academic backgrounds. Requirements Our ZOOM: Master Video Conferencing in Just 40 minutes! 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 1 sections • 17 lectures • 00:37:00 total length •Module 01: Intro: 00:01:00 •Module 02: Zoom Intro and signing up: 00:02:00 •Module 03: Hosting Your First Zoom Meeting: 00:01:00 •Module 04: Inviting Participants: 00:02:00 •Module 05: Manage Participants: 00:02:00 •Module 06: Sharing Screens and Whiteboards: 00:04:00 •Module 07: More Screen Share Options: 00:01:00 •Module 08: Chat, Recording and Reactions: 00:04:00 •Module 09: TIPS 01- Virtual Backgrounds: 00:02:00 •Module 10: TIPS 02 - Custom Virtual Background: 00:02:00 •Module 11: TIPS 03 - Video Settings: 00:02:00 •Module 12: TIPS 04 - Calendar Zoom Extension: 00:04:00 •Module 13: TIPS 05 - Hiding Floating Menu: 00:02:00 •Module 14: TIPS 06 - Mute All Shortcut: 00:02:00 •Module 15: TIPS 07 - New Share: 00:02:00 •Module 16: TIPS 08 - Pause Share: 00:02:00 •Module 17: TIPS 09 - Annotate: 00:02:00

ZOOM: Master Video Conferencing in Just 40 minutes!
Delivered Online On Demand37 minutes
£12

Microsoft Office 2016 PowerPoint Beginner - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2016 PowerPoint Beginners - Complete Video Course covers the basic functions and features of PowerPoint 2016. This series begins with an introduction in developing a PowerPoint presentation. Here, you will learn about advanced text editing, utilizing graphical elements, manipulate an existing PowerPoint presentation, create a new presentation based on a template and design a blank presentation selecting various slide layouts. Learn to print a presentation using special print options, modify a presentation using different outline views, edit and delete text in the title and bulleted placeholders etc. If you want to know more in details, join this course. You will get all the basic knowledge from this course. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 PowerPoint Beginner - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 PowerPoint Beginner - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module 01 Navigate the PowerPoint Environment FREE 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Module 02 Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Module 03 Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Module 04 Insert Images 00:10:00 Insert Shapes 00:15:00 Module 05 Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Module 06 Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Module 07 Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Module 08 Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Mock Exam Mock Exam- Microsoft Office 2016 PowerPoint Beginner - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 PowerPoint Beginner - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2016 PowerPoint Beginner - Complete Video Course
Delivered Online On Demand5 hours 27 minutes
£23

Dynamic 2D Video Game Animation

By iStudy UK

Whether you are 2D game developer, indy developer or you want to animate your creatures- this Dynamic 2D Video Game Animation is for you. If you are a hobby game creator or want to create easy games prototypes with animation, this animation course is going to help you a lot. Throughout this course, you'll learn to use Inkspace and DragonBones to design and animate characters for your game.  Inkspace and DragonBones are two free programs helpful for creating smooth and flexible 2D game character animations. Our Dynamic 2D Video Game Animation will have you combine these two incredible programs to develop versatile, ready to use character designs. You'll also learn to animate by importing the character parts & creating the bone system. This course will mostly focus on the DragonBones, so basic Inkspace knowledge will be needed to follow this animation course. What you'll learn You will be able to design, rig and animate your own 2D game character with free programs! You will have a basic character animation knowledge! You will be able to recreate my workflow and design and animate your own characters! You will create simple animations, that are ready to be used with ANY 2D game engine! Requirements Download the two free software we use in the course: Inkscape and Dragonbones The course is mainly about animation, have a very basic Inkscape knowledge to start the course! Optional: Have a character idea ready! You can use my character too, but you will learn more and have more fun designing and animating your very own creation! Who this course is for: This course is made for 2D game developers, indy developers or hobby game creators. This course is for character designers who want to learn to animate their creatures! The course is built for developers who want to create easy game prototypes with animation for free! This course is NOT for you if you are looking for 3D animation! Both programs are great for 2D design and animation but not 3D! This course is about game character animation, NOT about animating a full scene or animated movie! Before we start Introduction FREE 00:01:00 Before you start 00:02:00 Design your character in Inkscape Design the knight character in Inkscape - Part1 00:12:00 Design the knight character in Inkscape - Part 2 00:14:00 Design the knight character in Inkscape - Part 3 00:09:00 Prepare for animation! Exporting the design from Inkscape 00:07:00 Welcome to DragonBones! 00:02:00 Import and assemble your character to DragonBones 00:07:00 Animate your character in DragonBones! Create the bone system of your character 00:11:00 Using live video references 00:03:00 Our very first animation! 00:07:00 Idle animation 00:09:00 Creating a mesh! 00:11:00 Animating more soft parts with mesh editing 00:14:00 Character walk cycle in DragonBones - Part 1 the first steps! 00:19:00 Character walk cycle in DragonBones - Part2 move your arms! 00:12:00 Character walk cycle in DragonBones - Part 3 animating meshes! 00:07:00 Character walk cycle in DragonBones - Part 4 final touches 00:13:00 Creating an attack move - Part 1 00:13:00 Creating an attack move - Part 2 00:07:00 Dying animation sequence 00:15:00 Exporting animation and modular characters Export your animated sprites from DragonBones 00:04:00 Modular characters in DragonBones 00:07:00

Dynamic 2D Video Game Animation
Delivered Online On Demand3 hours 26 minutes
£25

CompTIA Certification - Complete Video Course

4.3(43)

By John Academy

Description: CompTIA or the Computing Technology Industry Association is a non-profit organisation that provides professional certificates for the IT industry. A license from CompTIA will increase your opportunity for career build-up. The CompTIA Certification - Complete Video Course course is the best choice for you if you want to obtain a professional degree in It. The course is taught in several sections and sub-sections. The CompTIA A+ 900 Certification series shows you the current knowledge and skills needed by today's IT professionals including configuring BIOS, motherboard, RAM types, PC installation, networking, etc. Then the CompTIA Network+ Certification provides in-depth information related to networking while the CompTIA Security+ section shows you how to secure your confidential data. Next, CompTIA Healthcare IT deals with the application of IT in the medical industry to provide excellent service to the patients while the CompTIA Linux+ course gives you a complete guide for the Linux Operating system. Finally, the CompTIA Advanced Security Practitioner (CASP) course will help you to know about the enterprise security architecture, security technology and resource technology so that you can determine the root of the security problem and solve the issues. CompTIA provides various certifications based on the different sectors of IT. The purpose of the bundled course is to prepare for those exams and at the same time to help you to gain the practical knowledge related to IT Sector. Assessment & Certification To achieve a formal qualification, you are required to book an official exam separately with the relevant awarding bodies. However, you will be able to order a course completion CPD Certificate by paying an additional fee. Hardcopy Certificate by post - £19 Soft copy PDF via email - £10 Requirements Our CompTIA Certification - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.

CompTIA Certification - Complete Video Course
Delivered Online On Demand4 days
£22

CompTIA Linux+ Certification - Complete Video Course

4.3(43)

By John Academy

Description Linux has grown into an industry-leading software and service delivery platform that is used for everything from super computers and Web servers to virtualized systems and your Android phone. This growth creates a high demand for qualified Linux professionals. This CompTIA Linux+ Certification - Complete Video Course is designed to prepare you for the CompTIA Linux+ certification exam. It will provide you a comprehensive look at common tasks performed by system administrators. This includes installation, Management of Linux systems from the command line and the GUI, user administration, file permissions, customization, software configuration, Management of Linux-based clients, troubleshooting, and much more. Expanded coverage of networking and security are covered, which is in step with the CompTIA exam objectives. With this course, you'll acquire the fundamental skills and knowledge you need to successfully configure, manage and troubleshoot Linux systems. Assessment & Certification To achieve a formal qualification, you are required to book an official exam separately with the relevant awarding bodies. However, you will be able to order a course completion CPD Certificate by paying an additional fee. Hardcopy Certificate by post - £19 Soft copy PDF via email - £10 Requirements Our CompTIA Linux+ Certification - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Installation Linux Introduction FREE 00:25:00 Pre-installation Tasks 00:09:00 Linux Installation 00:18:00 Using Linux Graphical User Interfaces 00:26:00 Command Line Linux 00:56:00 File and Directory Management Directory Organization 00:33:00 File Management 00:58:00 Removable Storage 00:19:00 System Administration Users and Groups 00:57:00 File and Directory Permissions 00:53:00 User Environment Configuration 00:29:00 GUI Configuration 00:18:00 Application Management Packages and Package Managers 00:30:00 Source Code Software 00:20:00 System Configuration Disk Management 00:46:00 File System Management 00:29:00 Device Management 00:13:00 Process and Module Management Process Management 00:35:00 Process Priority and Execution 00:12:00 Kernel Modules 00:24:00 System Maintenance Backup and Restore 00:38:00 Scheduling Tasks 00:14:00 Performance Monitoring 00:26:00 Logging 00:39:00 Networking Networking Basics 00:58:00 Network Services 00:36:00 Domain Name Services 00:29:00 File Sharing and Printing Network File Resources 00:25:00 Printing 00:16:00 Interoperability Network Interoperability 00:18:00 Remote Desktop Access 00:08:00 Security System Security 00:23:00 Network Security 00:32:00 Web Environment Web Services 00:43:00 MySQL Services 00:13:00 FTP and Email Services FTP Services 00:36:00 Mail Services 00:05:00 Troubleshooting and Maintenance Booting Linux 00:28:00 Network Troubleshooting 00:11:00 Scripting Basics 00:08:00 Mock Exam Mock Exam- CompTIA Linux+ Certification - Complete Video Course 00:20:00 Final Exam Final Exam- CompTIA Linux+ Certification - Complete Video Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

CompTIA Linux+ Certification - Complete Video Course
Delivered Online On Demand19 hours 16 minutes
£23.99

Microsoft Office 2013 Excel Advanced - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2013 Excel Advanced - Complete Video Course covers the advanced functions and features of Excel 2013. You will learn about working with multiple worksheets and automating and auditing worksheets, how to update workbook properties, and how to apply conditional formatting. You will also learn how to export, analyze and present Excel data. This Advanced level is designed for you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. This course is intended for them who have intermediate skills with Microsoft Excel 2013, and want to learn more advanced skills or want to learn the topics covered in this course in the 2013 interface. So, brush up your basic and intermediate knowledge and be an expert with the help of this course. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Automating Worksheet Functionality Update Workbook Properties FREE 00:07:00 Create and Edit a Macro 00:15:00 Apply Conditional Formatting 00:09:00 Add Data Validation Criteria 00:10:00 Auditing Worksheets Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:12:00 Watch and Evaluate Formulas 00:10:00 Create a Data List Outline 00:09:00 Analyzing and Presenting Data Create Sparklines 00:13:00 Create Scenarios 00:12:00 Perform a What If Analysis 00:19:00 Perform a Statistical Analysis with the Analysis ToolPak 00:06:00 Create Interactive Data with Power View 00:10:00 Working With Multiple Workbooks Consolidate Data 00:10:00 Link Cells in Different Workbooks 00:10:00 Merge Workbooks 00:08:00 Exporting Excel Data Export Excel Data 00:06:00 Import a Delimited Text File 00:09:00 Integrate Excel Data with the Web 00:11:00 Create a Web Query 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2013 Excel Advanced - Complete Video Course
Delivered Online On Demand3 hours 59 minutes
£21