15713 Courses

Dive deep into the vast realm of Python data science with our meticulously crafted course: 'Python Data Science with Numpy, Pandas and Matplotlib'. Explore the intricate details of Python, setting the stage with Pandas and Numpy, before delving into the power of Python data structures. With topics ranging from Python Strings to Matplotlib Histograms, you'll gain a holistic insight, ensuring that every dataset you touch unveils its story compellingly. So, if you're keen on transmuting raw data into visual masterpieces or insights, this journey is tailor-made for you. Learning Outcomes Grasp foundational knowledge of Python and its data structures like strings, lists, and dictionaries. Understand the potential of NumPy, from basic array operations to handling multi-dimensional arrays. Master the versatility of Pandas, encompassing everything from dataframe conversions to intricate operations like aggregation and binning. Efficiently manage, manipulate, and transform data using Pandas' diverse functionalities. Create visually striking and informative graphs using the power of Matplotlib. Why buy this Python Data Science with Numpy, Pandas and Matplotlib course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Python Data Science with Numpy, Pandas and Matplotlib there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Python Data Science with Numpy, Pandas and Matplotlib course for? Beginners eager to jumpstart their journey in Python data science. Analysts looking to enhance their data manipulation skills using Python. Statisticians keen on expanding their toolset with Python-based libraries. Data enthusiasts desiring a deep dive into Python's data libraries and structures. Professionals aiming to upgrade their data visualisation techniques. Prerequisites This Python Data Science with Numpy, Pandas and Matplotlib does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Python Data Science with Numpy, Pandas and Matplotlib was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Scientist: £40,000 - £80,000 Python Developer: £35,000 - £70,000 Data Analyst: £30,000 - £55,000 Business Intelligence Analyst: £32,000 - £60,000 Research Analyst: £28,000 - £52,000 Data Visualization Engineer: £33,000 - £65,000 Course Curriculum Course Introduction and Table of Contents Course Introduction and Table of Contents 00:09:00 Introduction to Python, Pandas and Numpy Introduction to Python, Pandas and Numpy 00:07:00 System and Environment Setup System and Environment Setup 00:08:00 Python Strings Python Strings - Part 1 00:11:00 Python Strings - Part 2 00:09:00 Python Numbers and Operators Python Numbers and Operators - Part 1 00:06:00 Python Numbers and Operators - Part 2 00:07:00 Python Lists Python Lists - Part 1 00:05:00 Python Lists - Part 2 00:06:00 Python Lists - Part 3 00:05:00 Python Lists - Part 4 00:07:00 Python Lists - Part 5 00:07:00 Tuples in Python Tuples in Python 00:06:00 Sets in Python Sets in Python - Part 1 00:05:00 Sets in Python - Part 2 00:04:00 Python Dictionary Python Dictionary - Part 1 00:07:00 Python Dictionary - Part 2 00:07:00 NumPy Library - Introduction NumPy Library Intro - Part 1 00:05:00 NumPy Library Intro - Part 2 00:05:00 NumPy Library Intro - Part 3 00:06:00 NumPy Array Operations and Indexing NumPy Array Operations and Indexing - Part 1 00:04:00 NumPy Array Operations and Indexing - Part 2 00:06:00 NumPy Multi-Dimensional Arrays NumPy Multi-Dimensional Arrays - Part 1 00:07:00 NumPy Multi-Dimensional Arrays - Part 2 00:06:00 NumPy Multi-Dimensional Arrays - Part 3 00:05:00 Introduction to Pandas Series Introduction to Pandas Series 00:08:00 Introduction to Pandas Dataframes Introduction to Pandas Dataframes 00:07:00 Pandas Dataframe conversion and drop Pandas Dataframe conversion and drop - Part 1 00:06:00 Pandas Dataframe conversion and drop - Part 2 00:06:00 Pandas Dataframe conversion and drop - Part 3 00:07:00 Pandas Dataframe summary and selection Pandas Dataframe summary and selection - Part 1 00:06:00 Pandas Dataframe summary and selection - Part 2 00:06:00 Pandas Dataframe summary and selection - Part 3 00:07:00 Pandas Missing Data Management and Sorting Pandas Missing Data Management and Sorting - Part 1 00:07:00 Pandas Missing Data Management and Sorting - Part 2 00:07:00 Pandas Hierarchical-Multi Indexing Pandas Hierarchical-Multi Indexing 00:06:00 Pandas CSV File Read Write Pandas CSV File Read Write - Part 1 00:05:00 Pandas CSV File Read Write - Part 2 00:07:00 Pandas JSON File Read Write Pandas JSON File Read Write Operations 00:07:00 Pandas Concatenation Merging and Joining Pandas Concatenation Merging and Joining - Part 1 00:05:00 Pandas Concatenation Merging and Joining - Part 2 00:04:00 Pandas Concatenation Merging and Joining - Part 3 00:04:00 Pandas Stacking and Pivoting Pandas Stacking and Pivoting - Part 1 00:06:00 Pandas Stacking and Pivoting - Part 2 00:05:00 Pandas Duplicate Data Management Pandas Duplicate Data Management 00:07:00 Pandas Mapping Pandas Mapping 00:04:00 Pandas Grouping Pandas Groupby 00:06:00 Pandas Aggregation Pandas Aggregation 00:09:00 Pandas Binning or Bucketing Pandas Binning or Bucketing 00:08:00 Pandas Re-index and Rename Pandas Re-index and Rename - Part 1 00:04:00 Pandas Re-index and Rename - Part 2 00:05:00 Pandas Replace Values Pandas Replace Values 00:05:00 Pandas Dataframe Metrics Pandas Dataframe Metrics 00:07:00 Pandas Random Permutation Pandas Random Permutation 00:08:00 Pandas Excel sheet Import Pandas Excel sheet Import 00:07:00 Pandas Condition Selection and Lambda Function Pandas Condition Selection and Lambda Function - Part 1 00:05:00 Pandas Condition Selection and Lambda Function - Part 2 00:05:00 Pandas Ranks Min Max Pandas Ranks Min Max 00:06:00 Pandas Cross Tabulation Pandas Cross Tabulation 00:07:00 Matplotlib Graphs and plots Graphs and plots using Matplotlib - Part 1 00:06:00 Graphs and plots using Matplotlib - Part 2 00:02:00 Matplotlib Histograms Matplotlib Histograms 00:03:00 Resource File Resource File - Python Data Science with Numpy, Pandas and Matplotlib 00:00:00

Duration 4 Days 24 CPD hours This course is intended for Candidates should be familiar with Dynamics 365 Customer Insights and have firsthand experience with one or more additional Dynamics 365 apps, Power Query, Microsoft Dataverse, Common Data Model, and Microsoft Power Platform. They should also have working knowledge of practices related to privacy, compliance, consent, security, responsible AI, and data retention policy. Overview After completing this course, you will be able to: Clean, transform, and ingest data into Dynamics 365 Customer Insights Create a unified customer profile Work with Dynamics 365 Audience insights Enrich data and predictions Set up and manage external connections Administer and monitor Customer Insights Customer Data Platform specialists implement solutions that provide insight into customer profiles and that track engagement activities to help improve customer experiences and increase customer retention. In this course, students will learn about the Dynamics 365 Customer Insights solution, including how to unify customer data with prebuilt connectors, predict customer intent with rich segmentation, and maintain control of customer data. This specialty course starts with creating a unified profile and then working with customer data. Module 1: Get started with Dynamics 365 Customer Insights Introduction to the customer data platform Administer Dynamics 365 Customer Insights Explore user permissions in Dynamics 365 Customer Insights Module 2: Ingest data into Dynamics 365 Customer Insights Import and transform data Connect to data sources Work with data Module 3: Create a unified customer profile in Dynamics 365 Customer Insights Map data Match data Merge data Find customers Module 4: Work with Dynamics 365 Customer Insights Explore Audience insights Define relationships and activities Work with measures Work with segments Module 5: Enrich data and predictions with Audience insights Enrich data Use predictions Use machine learning models Module 6: Manage external connections with Customer Data Platform Export Customer Insights data Use Customer Insights with Microsoft Power Platform Display Customer Insights data in Dynamics 365 apps More ways to extend Customer Insights

Get ready for an exceptional online learning experience with the Forklift Training, Delivery Driver, Train Driver & Safety bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Forklift Training, Delivery Driver, Train Driver & Safety is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. This Forklift Training offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Forklift Training package has something for everyone. As part of the Forklift Training, Delivery Driver, Train Driver & Safety package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Forklift Training bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Forklift Training Bundle Comprises the Following CPD Accredited Courses: Forklift Training - Online Course Large Goods Vehicle (LGV) Transport Manager Port Management Diploma Airport Management Course Import/Export Trainee Train Driver Course Delivery Driver Training Delivery Manager Driver Safety Awareness Safeguarding for Taxi Drivers Operations and Warehouse Management with Transport Management Warehouse Safety Engine Lubrication Systems Online Course Power Tools and How to Use Them Manual Handling Training LOLER Training Health and Safety at Workplace Career Development Plan Fundamentals CV Writing and Job Searching Learning Outcome: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Forklift Training Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with Forklift Training. Build a strong knowledge base in your chosen course via Forklift Training. Benefit from the flexibility and convenience of online learning. With the Forklift Training package, validate your learning with a CPD certificate. Each course of this Forklift Training bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This Forklift Training bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Forklift Training, Delivery Driver, Train Driver & Safety, a rich anthology of 15 diverse courses. Each course in the Forklift Training bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisForklift Training, Delivery Driver, Train Driver & Safety bundle will take you on a unique and enriching educational journey. The Forklift Training bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Forklift Training, Delivery Driver, Train Driver & Safety bundle offers you the flexibility and convenience to learn at your own pace. Make the Forklift Training package your trusted companion in your lifelong learning journey. CPD 210 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Forklift Training, Delivery Driver, Train Driver & Safety bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Career path Unleash your potential with the Forklift Training, Delivery Driver, Train Driver & Safety bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Forklift Training bundle package. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

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

Java Front-ends for desktop and mobile With Java FX Programming Java Front-ends for desktop and mobile With Java FX In this course we create attractive, functional Front-ends using JavaFX. Prerequisites: Delegates already have basic Java Skills. Duration: 2 consecutive days, the first date shows as the booking date Where: Online with Gotomeeting.com Download: Download Java JDK and Eclipse IDE. London classroom: on request locations, bring you own device Location: Online Interactive Instructor-led Webinar. Our Style: This is a very practical course giving you hands-on practice. Included: Course exercises, notes, examples, computers, evaluations Certification: PCWorkshops JavaFX Qualification Java Intermediate and Front-end Course Description Database Concepts Revision: DataBase SQL, database principles and JDBC GUI's with Java FX Building Java FX GUI's Course Contents: GUI's with JavaFX Building Java GUI's. Create a front-end form interface for an application. Working with nodes, labels, inputboxes, prgress bars, etc. Formatting your front-end. Import a Java package to interact with the front-end. Interact with a database via the front-end. Practical Examine the Java SE event model. What is an event. What is event handling. Develop event handlers. Develop Lambda-style event handlers. Practical Create a quotation app. Create a movie booking app. How to create your installer and upload your app Webservices Java Web services What are Web Services? Why Java Web Services? Web Services - Characteristics Web Services - Architecture Web Services - Examples and exercises What is included PCWorkshops Course Certificate on completion Java Course Notes Java Code Examples Practical Java Course exercises, Java Course Revision work After the course: 1-Hour personalised online revision session Book the Java Intermediate and Front-end Course Powered by Eventbrite About us Our experienced trainers are award winners. More about us FAQ's Client Comments

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Ever wondered how goods get from factories to your doorstep? According to the Chartered Institute of Procurement & Supply (CIPS), the UK procurement and supply chain sector employs over 1.2 million people. This vast and ever-growing field offers exciting career opportunities for individuals with the right skills and knowledge. This Level 3 Procurement, Purchasing & Supply Chain Management Diploma bundle provides a structured learning pathway that equips you with the essential knowledge and skills needed to thrive in various roles within the procurement and supply chain sector. This training bundle will equip you with a thorough understanding of every step involved in getting a product from conception to the customer. You'll explore areas like strategic sourcing and international trade. By the course's end, you'll be able to identify cost-saving opportunities, streamline operations, and ensure quality throughout the supply chain. This Purchasing & Procurement at QLS Level 5 course is endorsed by The Quality Licence Scheme and accredited by CPD QS (with 150 CPD points) to make your skill development & career progression more accessible than ever! This Level 3 Procurement, Purchasing & Supply Chain Management Diploma Bundle Contains 20 of Our Premium Courses for One Discounted Price: Course 01: Diploma in Purchasing & Procurement at QLS Level 5 Course 02: Supply Chain Management Course 03: Material Management Course 04: Diploma in Operations Management Course 05: Logistics Management Course 06: Port Management Diploma Course 07: Transport and Logistics Management Course 08: Product Management Course 09: Lean Process and Six Sigma Training Course Course 10: Import/Export Processing Course 11: Cost Control Process and Management Course 12: Good Manufacturing Practices (GMP) Certification Course Course 13: Quality Assurance (QA) Manager Diploma Course 14: Purchase Ledger Training Course 15: Cost Control Process and Management Course 16: Retail Management Skills Course 17: Retail Assistant Course 18: Store Assistant Course 19: Manual Handling Training Course 20: Business Law Give your career a boost by enrolling today! Learn in-demand skills that are highly sought after by businesses across various industries. Learning Outcomes of Procurement, Purchasing & Supply Chain Management Gain a comprehensive understanding of procurement and purchasing processes. Develop expertise in logistics and supply chain management. Learn how to optimize inventory levels and reduce costs. Implement quality control measures to ensure product and service excellence. Master lean process and Six Sigma methodologies for continuous improvement. Gain the knowledge and skills required for a successful career in procurement, purchasing, or supply chain management. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Procurement Get a free student ID card with Procurement Training program (£10 postal charge will be applicable for international delivery) The Procurement is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Procurement course materials The Procurement comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Diploma in Purchasing & Procurement at QLS Level 5 Module 01: Why Supply Chain Management Module 02: Three Levels of Supply Chain Management Module 03: Five Stages of Supply Chain Management Module 04: The Flows of Supply Chain Management Module 05: Supply Chain Groups Module 06: Tracking and Monitoring Module 07: Role of Procurement in an Organisation Module 08 : The Purchasing Cycle Module 09: Purchasing Toolkits Module 10: Quality Management Module 11: Supplier Relationship Management Module 12: Category Management Module 13: Inventory Management Module 14: E-Procurement Course 02: Supply Chain Management Module 01: An Overview Of Supply Chain Management Module 02: Role Of Logistics Of Supply Chain Module 03: Customer Response Principles And Systems Module 04: Supply Chain System And Principles Module 05: Global Supply Chain Operations Module 06:Inventory Strategies For Supply Chain Module 07: Warehouse Management And Operations Module 08: Supply Chain Design And Monitoring Module 09: Supply Chain Network And Evaluating Module 10: Supply Chain Planning And New Business Concepts Module 11: Aligning Your Supply Chain Process With Your Business Course 03: Material Management Module 01: Introduction To Material Management Module 02: Purchasing And Supply Chain Management Module 03: Inventory Management, Planning And Control Module 04: Stores Management And Control Module 05: Forecasting Module 06: Material Requirements Planning Module 07: Materials Handling =========>>>>> And 17 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*20 = £260) CPD Hard Copy Certificate: Free ( For The First Course: Previously it was £29.99) CPD 350 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Procurement and purchasing professionals. Supply chain management aspirants. Operations and logistics managers. Quality assurance and compliance officers. Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Procurement Manager Supply Chain Analyst Logistics Coordinator Quality Assurance Specialist Operations Manager Compliance Officer Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. Diploma in Purchasing & Procurement at QLS Level 5 Hard copy certificate - £119 Please note that International students have to pay an additional £10 as a shipment fee.

Overview This comprehensive course on Tutorial For Inkscape - Learn Vector Graphics Design will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Tutorial For Inkscape - Learn Vector Graphics Design 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 Tutorial For Inkscape - Learn Vector Graphics Design. It is available to all students, of all academic backgrounds. Requirements Our Tutorial For Inkscape - Learn Vector Graphics Design 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 7 sections • 37 lectures • 04:00:00 total length •Introduction: 00:02:00 •The user interface: 00:05:00 •Draw your first object: 00:04:00 •Saving your work and exporting: 00:03:00 •Select and transform objects: 00:04:00 •Dealing with multiple objects: 00:07:00 •Let's color it! - the basics of color usage: 00:09:00 •Shape and path: 00:08:00 •Groups and basic drawings: 00:07:00 •Edit path by nodes: 00:12:00 •Another view on colors: 00:06:00 •Gradients: 00:07:00 •Going for the 3D look - gradients and blur: 00:09:00 •Clipping and masking: 00:10:00 •Working with text: 00:11:00 •Layers: 00:05:00 •Guidelines, rulers, align and distribute: 00:06:00 •The spray tool: 00:08:00 •The pencil tool - create custom brushes: 00:08:00 •Sculpt tool: 00:05:00 •Pattern along path: 00:05:00 •Filters and extensions: 00:04:00 •Import photos and tracing: 00:08:00 •How to create patterns: 00:06:00 •Blending modes: 00:06:00 •Create a Christmas card: 00:04:00 •Draw a funny elf character: 00:18:00 •Finish your character and create falling snow: 00:15:00 •Finalize and export your drawing: 00:01:00 •Why Inkscape 0.91 What is new: 00:05:00 •New way to deal with gradients!: 00:04:00 •Powerstroke and the symbol library: 00:05:00 •Change canvas color: 00:04:00 •Use Find and replace to manage multiple objects: 00:06:00 •Tips for creating a good pattern: 00:06:00 •How to create mandala: 00:06:00 •Bonus lecture - check this out!: 00:01:00

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

Dive into the world of coding! Learn Python from scratch, solve real-world problems, make cool projects. No prior experience needed. Start your coding journey now!

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access