This course is a short and crisp introduction to those who do not have any prior knowledge of scripting or any programming basics. The instructor has tried to explain the concepts in such a simple terminology that even non-technical people will find it very easy to grasp the various Windows PowerShell concepts.
Overview Acquire the language of databases with this SQL Programming Complete Bundlecourse. In this data-driven world, data is used to make strategies, find solutions and do a thousand other tasks. Businesses across the world are using big and related data, which makes a basic knowledge of SQL a remarkable skill not only for data scientists but for everyone. This SQL Programming Complete Bundlecourse will teach you the language of databases, SQL, and help you gain proficiency in SQL tools. 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 SQL Programming Complete Bundle. It is available to all students, of all academic backgrounds. Requirements Our SQL Programming Complete 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 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 9 sections • 53 lectures • 07:50:00 total length •Introduction: 00:04:00 •Course Curriculum Overview: 00:05:00 •Overview of Databases: 00:10:00 •MySQL Installation: 00:16:00 •MySQL Workbench Installation: 00:09:00 •Connecting to MySQL using Console: 00:09:00 •Overview of Challenges: 00:04:00 •SQL Statement Basic: 00:16:00 •SELECT Statement: 00:09:00 •SELECT DISTINCT: 00:05:00 •Column AS Statement: 00:12:00 •COUNT built-in Method usage: 00:11:00 •SELECT WHERE Clause - Part One: 00:05:00 •SELECT WHERE Clause - Part Two: 00:11:00 •SQL Statement Basic: 00:16:00 •SQL Limit Clause Statement: 00:09:00 •SQL Using BETWEEN with Same Column Data: 00:11:00 •How to Apply IN Operator: 00:11:00 •Wildcard Characters with LIKE and ILIKE: 00:11:00 •Overview of GROUP BY: 00:06:00 •Aggregation function SUM(): 00:09:00 •Aggregation MIN() and MAX(): 00:05:00 •GROUP BY - One: 00:09:00 •GROUP BY - Two: 00:12:00 •HAVING Clause: 00:05:00 •Overview of JOINS: 00:04:00 •Introduction to JOINS: 00:04:00 •AS Statement table: 00:03:00 •INNER Joins: 00:14:00 •FULL Outer Join: 00:11:00 •LEFT Outer JOIN: 00:08:00 •RIGHT JOIN: 00:08:00 •Union: 00:07:00 •Timestamps: 00:12:00 •EXTRACT from timestamp: 00:10:00 •Mathematical Functions: 00:12:00 •String Functions: 00:22:00 •SUBQUERY: 00:13:00 •Basic of Database and Tables: 00:06:00 •DataTypes: 00:10:00 •Primarykey and Foreignkey: 00:06:00 •Create Table in SQL Script: 00:13:00 •Insert: 00:11:00 •Update: 00:07:00 •Delete: 00:04:00 •Alter Table: 00:09:00 •Drop Table: 00:05:00 •NOT NULL Constraint: 00:08:00 •UNIQUE Constraint: 00:09:00 •Creating a Database backup: 00:12:00 •10a Overview of Databases and Tables: 00:05:00 •10c Restoring a Database: 00:07:00 •Assignment - SQL Programming Complete Bundle: 00:00:00
Duration 3 Days 18 CPD hours This course is intended for This course is designed for IoT practitioners who are looking to improve their skills and knowledge of IoT security and privacy. This course is also designed for students who are seeking the CertNexus Certified Internet of Things Security Practitioner (CIoTSP) certification and who want to prepare for Exam ITS-110. Overview This program will validate that the candidate has the knowledge, skills, and abilities to secure network environments for IoT devices, analyze vulnerabilities and determine reasonable controls against threats, and effectively monitor IoT devices and respond to incidents. This course is designed for practitioners who are seeking to demonstrate a vendor-neutral, cross-industry skill set that will enable them to design, implement, operate, and/or manage a secure IoT ecosystem. Managing IoT Risks Map the IoT Attack Surface Build in Security by Design Securing Web and Cloud Interfaces Identify Threats to IoT Web and Cloud Interfaces Prevent Injection Flaws Prevent Session Management Flaws Prevent Cross-Site Scripting Flaws Prevent Cross-Site Request Forgery Flaws Prevent Unvalidated Redirects and Forwards Securing Data Use Cryptography Appropriately Protect Data in Motion Protect Data at Rest Protect Data in Use Controlling Access to IoT Resources Identify the Need to Protect IoT Implement Secure Authentication Implement Secure Authorization Implement Security Monitoring on IoT Systems Securing IoT Networks Ensure the Security of IP Networks Ensure the Security of Wireless Networks Ensure the Security of Mobile Networks Ensure the Security of IoT Edge Networks Ensuring Privacy Improve Data Collection to Reduce Privacy Concerns Protect Sensitive Data Dispose of Sensitive Data Managing Software and Firmware Risks Manage General Software Risks Manage Risks Related to Software Installation and Configuration Manage Risks Related to Software Patches and Updates Manage Risks Related to IoT Device Operating Systems and Firmware Promoting Physical Security Protect Local Memory and Storage Prevent Physical Port Access
24 Hour Flash Deal **40-in-1 Level 5 Diploma in Cyber Security Mega Bundle** Level 5 Diploma in Cyber Security 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 Level 5 Diploma in Cyber Security package online with Studyhub through our online learning platform. The Level 5 Diploma in Cyber Security bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Level 5 Diploma in Cyber Security course provides complete 360-degree training on Level 5 Diploma in Cyber Security. You'll get not one, not two, not three, but forty Level 5 Diploma in Cyber Security courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Level 5 Diploma in Cyber Security courses are yours for as long as you want them once you enrol in this course This Level 5 Diploma in Cyber Security Bundle consists the following career oriented courses: Course 01: Cyber Security Level 5 Advanced Training Course 02: CompTIA Security+ Course 03: AWS Certified Solutions Architect Associate Preparation Course 04: CEH: Learn Ethical Hacking From A-Z: Beginner To Expert Course 05: CompTIA Cloud+ (CV0-002) Course 06: Security Analyst Course 07: CompTIA CySA+ Cybersecurity Analyst Course Course 08: Cyber Security Awareness Training Course 09: Web Application Penetration Testing Course 10: Cyber Security Incident Handling and Incident Response Course 11: Data Protection Level 3 and Data Security (GDPR) Training Certification Course 12: Cyber Security Law Course 13: Information Governance and Data Management Training Course 14: Network Security and Risk Management Course 15: Computer Networks Security from Scratch to Advanced Course 16: Data Center Training Essentials: Mechanical & Cooling Course 17: IT Administration and Networking Course 18: CompTIA Network+ Certification (N10-007) Course 19: CompTIA Network Course 20: Diploma in CompTIA A+ Course 21: CompTIA PenTest+ (Ethical Hacking) course Course 22: CompTIA ITF+ (FCO-U61) Course 23: CompTIA Healthcare IT Technician Course 24: Foundations of IT Security: Protecting Digital Assets Course 25: Digital Forensic Science: Unraveling Cybercrime Mysteries Course Course 26: IT Support Technician: Troubleshooting and Technical Expertise Course 27: SQL Database Management Course 28: Quick Data Science Approach from Scratch Course 29: Deep Learning Neural Network with R Course 30: Computer Workstation Safety Training Course 31: Foundations of Artificial Intelligence: Building Intelligent Systems Course 32: Functional Skills IT/ ICT Level 2 Course 33: Internet of Things (IoT) Course 34: AutoCAD Programming using with Windows Forms Course 35: Ransomware Uncovered Specialist Certificate Course 36: Security Management and Fraud Prevention Training Course 37: Financial Statements Fraud Detection Training Course 38: Transaction Monitoring in Financial Services: Ensuring Security Course 39: Machine Learning Basics Course 40: Electronic Device and Circuits Protection Training In this exclusive Level 5 Diploma in Cyber Security bundle, you really hit the jackpot. Here's what you get: Step by step Level 5 Diploma in Cyber Security lessons One to one assistance from Level 5 Diploma in Cyber Security professionals if you need it Innovative exams to test your knowledge after the Level 5 Diploma in Cyber Security course 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all forty Level 5 Diploma in Cyber Security courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Level 5 Diploma in Cyber Security certificate and transcript on the next working day Easily learn the Level 5 Diploma in Cyber Security skills and knowledge you want from the comfort of your home The Level 5 Diploma in Cyber Security course has been prepared by focusing largely on Level 5 Diploma in Cyber Security career readiness. It has been designed by our Cyber Security 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 Level 5 Diploma in Cyber Security Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Level 5 Diploma in Cyber Security bundle course has been created with forty premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Level 5 Diploma in Cyber Security Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Level 5 Diploma in Cyber Security Elementary modules, allowing our students to grasp each lesson quickly. The Level 5 Diploma in Cyber Security 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. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Level 5 Diploma in Cyber Security 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 Level 5 Diploma in Cyber Security Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this Level 5 Diploma in Cyber Security course, all you need is - A smart device A secure internet connection And a keen interest in Level 5 Diploma in Cyber Security Career path You will be able to kickstart your Level 5 Diploma in Cyber Security career because this course includes various courses as a bonus. This Level 5 Diploma in Cyber Security is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Level 5 Diploma in Cyber Security 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
Description: This Microsoft Office 2013 Excel Intermediate - Complete Video Course covers the intermediate functions and features of Excel 2013. You will learn about creating formulas, inserting graphics and enhancing workbooks. You will also learn how to organize worksheet data with tables and charts and how to analyze data using PivotTables, Slicers and PivotCharts. In this course creating advanced formulas, you will learn how to apply range names and how to use specialized functions. Once you are comfortable with the basics, you will be ready for this intermediate level. Here, you will explore more advanced formatting with terms, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas and applying conditional formatting to your worksheet, and more. If you want to take your Microsoft Excel 2013 skills to the next level, you'll learn how to use this program's advanced features to build a fully functional database 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 2013 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 2013 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. Creating Advanced Formulas Apply Range Names FREE 00:18:00 Use Specialized Functions 00:14:00 Analyzing Data with Logical and Lookup Functions Leverage Questions and Testing to Write Formulas 00:01:00 Use Logical and Lookup Functions to Find Answers to Questions 00:25:00 Organizing Worksheet Data with Tables Create and Modify Tables 00:09:00 Sort and Filter Data 00:27:00 Use Summary and Database Functions to Calculate Data 00:25:00 Visualizing Data with Charts Create Charts 00:05:00 Modify and Format Charts 00:25:00 Create a Trendline 00:10:00 Create Advanced Charts 00:09:00 Analyzing Data with PivotTables, Slicers, and PivotCharts Create a PivotTable 00:24:00 Filter Data by Using Slicers 00:09:00 Analyze Data by Using PivotCharts 00:07:00 Inserting Graphics Insert and Modify Graphic Objects 00:10:00 Layer and Group Graphic Objects 00:12:00 Incorporate SmartArt 00:06:00 Enhancing Workbooks Customizing Workbooks 00:08:00 Manage Themes 00:06:00 Create and Use Templates 00:06:00 Protect Files 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description: This Microsoft Office 2010 Excel Intermediate - Complete Video Course builds on the skills and concepts taught in Excel 2010: Basic. You will learn how to use multiple worksheets and workbooks efficiently, and you will start working with more advanced formatting options including styles, themes, and backgrounds, create informative, eye-catching charts and harness the power of Excel's data analysis and filtering tools, how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. You will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. In addition, you'll find out how easy it is to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll set yourself apart from the casual Excel user by adding time-saving functions to your repertoire. 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 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 2010 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. Using Multiple Worksheets and Workbooks Using Multiple Workbooks 00:05:00 Linking Worksheets with 3-D Formulas 00:05:00 Linking Workbooks 00:09:00 Managing Workbooks 00:04:00 Advanced Formatting Using Special Number Formats 00:10:00 Using Functions to Format Text 00:09:00 Working with Styles 00:08:00 Working with Themes 00:07:00 Other Advanced Formatting 00:17:00 Outlining and Subtotals Outlining and Consolidating Data 00:13:00 Creating Subtotals 00:06:00 Cell and Range Names Creating and Using Names 00:14:00 Managing Names 00:07:00 Tables Sorting and Filtering Data 00:09:00 Advanced Filtering 00:08:00 Working with Tables 00:10:00 Web and Sharing Features Saving Workbooks as Web Pages 00:05:00 Using Hyperlinks 00:06:00 Sharing Workbooks 00:03:00 Advanced Charting Chart Formatting Options 00:05:00 Combination Charts 00:08:00 Graphical Elements 00:11:00 Documenting and Auditing Auditing Features 00:05:00 Comments in Cells and Workbooks 00:04:00 Protection 00:08:00 Workgroup Collaboration 00:09:00 Templates and Settings Application Settings 00:08:00 Built-in Templates 00:04:00 Creating and Managing Templates 00:05:00 PivotTables and PivotCharts Working with PivotTables 00:14:00 Rearranging PivotTables 00:06:00 Formatting PivotTables 00:03:00 Using PivotCharts 00:04:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
24 Hour Flash Deal **25-in-1 IT Procurement Specialist Mega Bundle** IT Procurement Specialist 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 IT Procurement Specialist package online with Studyhub through our online learning platform. The IT Procurement Specialist bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This IT Procurement Specialist course provides complete 360-degree training on IT Procurement Specialist. You'll get not one, not two, not three, but twenty-five IT Procurement Specialist courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these IT Procurement Specialist courses are yours for as long as you want them once you enrol in this course This IT Procurement Specialist Bundle consists the following career oriented courses: Course 01: IT Skills for IT / Non - IT Professionals Course 02: Python Basic Programming for Absolute Beginners Course 03: Microsoft Excel Complete Course 2019 Course 04: SQL for Data Science, Data Analytics and Data Visualization Course 05: Microsoft PowerPoint for Beginners Course 06: AutoCAD VBA Programming Course 07: Cyber Security Awareness Training Course 08: Web Application Penetration Testing Course 09: Build Progressive Web Apps with Angular Course 10: Web Design Course Course 11: Basic HTML 5 Course 12: CSS Fundamentals Course 13: HTML and CSS Coding: Beginner to Advanced Course 14: JavaScript Functions Course 15: Refactor Javascript Course Course 16: JavaScript Foundations Course 17: jQuery Masterclass Course: JavaScript and AJAX Coding Bible Course 18: ASP.Net MVC and Entity Framework Course 19: Info Graphics Web Design - Affinity Designer Training Course 20: Diploma in Adobe Illustrator Course 21: Information Architecture (IA) Fundamentals for Website Design Course 22: Basics of WordPress Course 23: Learn MySQL from Scratch Course 24: PHP Web Development with MySQL Course 25: Learn Spring & Angular Material with a Full Web Application The IT Procurement Specialist course has been prepared by focusing largely on IT Procurement Specialist career readiness. It has been designed by our IT Procurement Specialist 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 IT Procurement Specialist Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This IT Procurement Specialist 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 IT Procurement Specialist Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into IT Procurement Specialist Elementary modules, allowing our students to grasp each lesson quickly. The IT Procurement Specialist 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 IT Procurement Specialist bundle, you really hit the jackpot. Here's what you get: Step by step IT Procurement Specialist lessons One to one assistance from IT Procurement specialists if you need it Innovative exams to test your knowledge after the IT Procurement Specialistcourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five IT Procurement Specialist courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your IT Procurement Specialist certificate and transcript on the next working day Easily learn the IT Procurement Specialist 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 IT Procurement Specialist 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 IT Procurement Specialist Requirements To participate in this IT Procurement Specialist course, all you need is - A smart device A secure internet connection And a keen interest in IT Procurement Specialist Career path You will be able to kickstart your IT Procurement Specialist career because this course includes various courses as a bonus. This IT Procurement Specialist is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore IT Procurement Specialist 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
In this course, you will learn the advanced features and functions of Microsoft Excel 2010. You will learn how to plan your worksheet and be clear on your objectives and the importance of saving as much as possible. You will know how to use macros to automate repetitive tasks, What If Analysis and how to outline to quickly manage detail data. You will also know the guided exercises provided in this course to refresh your skills. Course Highlights Certified Microsoft Excel 2010 Advanced Level is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Microsoft Excel 2010 Advanced Level into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 10 hours, 40 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Microsoft Excel 2010 Advanced Level Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Microsoft Excel 2010 Advanced Level is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Certified Microsoft Excel 2010 Advanced Level 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Certified Microsoft Excel 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with PivotTables and PivotCharts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 00:30:00 Module Eleven - Grouping and Outlining Data 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Certified Microsoft Excel 2010 Advanced Level- CPD & IAO Accredited 00:00:00 Mock Exam Mock Exam-Certified Microsoft Excel 2010 Advanced Level- CPD & IAO Accredited 00:20:00 Final Exam Final Exam-Certified Microsoft Excel 2010 Advanced Level- CPD & IAO Accredited 00:20:00