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

1895 Exercises courses in Cardiff delivered On Demand

Data Analysis with Pandas and Python

By Packt

This course offers an immersive experience in data analysis, guiding you from initial setup with Python and Pandas, through series and DataFrame manipulation, to advanced data visualization techniques. Perfect for enhancing your data handling and analysis skills.

Data Analysis with Pandas and Python
Delivered Online On Demand19 hours 26 minutes
£67.99

Electrical Engineering Course

5.0(1)

By LearnDrive UK

Master DC circuit analysis and troubleshooting with our comprehensive Electrical Engineering course. Learn to analyze series-parallel networks and solve practice problems to become a skilled troubleshooter in the field.

Electrical Engineering Course
Delivered Online On Demand1 hour
£5

Eloquence Course: Discover Your Confident and Powerful Voice

4.9(27)

By Apex Learning

Course Overview: Winston Churchill, whose powerful speeches during World War II rallied the British nation and inspired hope amidst the darkest times. His ability to choose words wisely and deliver them with conviction exemplified the transformative power of eloquence. So, let's unlock the power of your voice and embark on a transformative journey with our Eloquence Course: Discover Your Confident and Powerful Voice. Effective communication skills have become paramount for personal and professional success in today's fast-paced world. Through this comprehensive course, you will delve into the art of eloquence, learning how to captivate your audience, build relationships, and master the nuances of tone and body language. Developed by a team of experts with a deep understanding of the power of persuasive speech, this course offers a carefully crafted curriculum designed to transform your communication style. Key Features of the Course: CPD Certificate upon completion, enhancing your professional credentials 24/7 Learning Assistance from our dedicated support team, ensuring you receive guidance every step of the way Engaging and interesting learning materials, including videos, exercises, and quizzes, to keep you motivated and actively involved throughout the course Who is This Course For? This Eloquence Course: Discover Your Confident and Powerful Voice, is ideal for anyone looking to enhance their communication skills and gain confidence in expressing themselves effectively. What You Will Learn: In this Eloquence Course: Discover Your Confident and Powerful Voice, you will embark on a journey of self-discovery and develop essential skills through our meticulously designed modules. Let's take a closer look at what you will learn: Modules 1 and 2: Impress and Hook Your Audience Discover techniques to grab your audience's attention from the very beginning and leave a lasting impression. Modules 3 to 5: Choose Your Words Wisely Master the art of selecting the right words to convey your message effectively and persuasively. Modules 6 to 10: Build Relationships and Master Your Tone of Voice Learn how to forge meaningful connections with your audience and harness the power of tone in your delivery. Modules 11 and 12: Convince with Your Voice and Command with Your Body Develop the ability to persuade and influence others through the power of your voice and body language. Module 13: Answer Any Question Learn the art of confidently responding to questions, even in challenging situations. Why Enrol in This Course: Our Eloquence Course: Discover Your Confident and Powerful Voice, has received top reviews from previous learners, who have praised its effectiveness in transforming communication skills. We have meticulously updated the course to include the latest communication techniques and strategies, ensuring you receive the most relevant and up-to-date knowledge. Requirements: To fully engage in this Eloquence Course: Discover Your Confident and Powerful Voice, you only need a willingness to learn and a desire to enhance your communication skills. There are no specific prerequisites or prior experience required. Career Path: Upon completing this Eloquence Course: Discover Your Confident and Powerful Voice, you will be equipped with highly valuable skills to propel you towards various professions. Some of the career paths you can explore include: Public Speaker - Average UK Salary: £50,000 per year Sales Executive - Average UK Salary: £30,000 per year Marketing Manager - Average UK Salary: £45,000 per year Human Resources Manager - Average UK Salary: £40,000 per year Media Presenter - Average UK Salary: £35,000 per year Team Leader - Average UK Salary: £35,000 per year Customer Relationship Manager - Average UK Salary: £30,000 per year Certification: Upon completing the Eloquence Course: Discover Your Confident and Powerful Voice, you will receive a CPD (Continuing Professional Development) certificate, adding credibility to your newly acquired skills and enhancing your professional profile. Course Curriculum 1 sections • 13 lectures • 03:34:00 total length •Module 01: Introduction: 00:18:00 •Module 02: Impress Hook Your Audience: 00:26:00 •Module 03: Eloquence Choose Your Word Wisely Part 01: 00:18:00 •Module 04: Eloquence Choose Your Word Wisely Part 02: 00:20:00 •Module 05: Eloquence Choose Your Word Wisely Part 03: 00:14:00 •Module 06: Impress Build Relationships: 00:10:00 •Module 07: Eloquence Master Your Tone of Voice Part 01: 00:19:00 •Module 08: Eloquence Master Your Tone of Voice Part 02: 00:14:00 •Module 09: Eloquence Master Your Tone of Voice Part 03: 00:17:00 •Module 10: Eloquence Master Your Tone of Voice Part 04: 00:14:00 •Module 11: Impress Convince with Your Voice: 00:19:00 •Module 12: Impress Command with Your Body: 00:16:00 •Module 13: Impress Answer Any Question: 00:09:00

Eloquence Course: Discover Your Confident and Powerful Voice
Delivered Online On Demand3 hours 34 minutes
£12

Voice Acting Training for Voice Actors

By Compliance Central

The MOST DEMANDED PATHWAY are WAITING for YOU Are you eager to explore the thrilling world of Voice Acting and become a real "Voice Actor"? This means that instead of just recording commercials, promos, and announcements as voiceovers for income, you can hone your vocal acting skills and gain the ability to act in various audio scenarios! Look no further - this comprehensive voice acting training course will provide you with everything you need to get ahead. From learning about dialects and accents to developing character voices, you'll be able to start your journey towards becoming an expert voice actor. With interesting activities, amusing examples, and constructive exercises designed to challenge your abilities, you're sure to find this voice acting course rewarding, invigorating, and truly captivating. Voice Acting Course Package: Course 01: Voice Actor Training Course 02: Public Speaking Voice Acting Training Learning Outcomes: Upon successful completion of this highly appreciated Voice Acting Training course, you'll be a skilled professional, besides- Discover your "business voice". Develop your marketing and branding skills. Determine the tools you'll need to construct your studio. Learn proper studio etiquette and recording techniques. Learn the fundamentals of audio editing for a clear sound. Find out how and where to land your first jobs. Create a character bag that contains a variety of personas. Along with the Voice Acting Training course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Embark on your next step in life today - enrol now and make yourself one step closer to success. Course contains advanced and latest curriculum study modules: Course 01: Voice Actor Training Module 01: Introduction Module 02: Voiceover Basics Module 03: Finding Your Voice Module 04: Using Your Instrument Module 05: Exercising Your Voice Module 06: Useful Tips Module 07: Plan Your Demo Module 08: The Audition Module 09: Record Your Voice Module 10: The Studio Module 11: Promoting Your Voice Module 12: UK Voice Acting Industry Course 02: Public Speaking Module 01: Hook Your Audience Module 02: Show Confidence Module 03: Overcome Nervousness Module 04: Tailor Your Approach Module 05: Speak Well Module 06: Body Language Module 07: Keep Their Attention Module 08: Maximize Media Impact Module 09: Manage Pace Module 10: Answer Questions Module 11: Make It Enjoyment Module 12: Handle Distractions Module 13: Close Well CPD 20 CPD hours / points Accredited by CPD Quality Standards Who is this course for? If you want to master professional acting abilities to turn your inherent talent in creating 'funny voices' into paid regular work, this is for you! Great for seasoned voice actors who want to increase their revenue by adding gaming and animation studios to their clientele! Ideal for trained actors who need to make money while waiting for stage bookings. All varieties of voices are required for voice acting job in video games and animation, therefore regardless of your age, this course is for you to help start your voice acting career! Requirements To enrol in this Voice Acting Training course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this Voice Acting course, you can explore trendy and in-demand jobs related to Voice Training, such as- Voiceover Artist: £20,000 to £50,000 per year Audiobook Narrator: £25,000 to £50,000 per year Commercial Voice Actor: £25,000 to £60,000 per year Video Game Voice Actor: £25,000 to £60,000 per year Animation Voice Actor: £25,000 to £60,000 per year Certificates 1 CPD Accredited Hard Copy Certificate Hard copy certificate - Included 1 CPD Accredited Hard Copy Certificate- Delivery charge: Inside the UK: £3.99, Outside of the UK: £9.99 Certificate of completion Digital certificate - Included CPD Accredited PDF Certificate Other CPD Accredited Hard Copy Certificate Hard copy certificate - £9.99 Other CPD Accredited Hard Copy Certificate for £9.99 Delivery charge: Inside the UK: Free Outside of the UK: £9.99

Voice Acting Training for Voice Actors
Delivered Online On Demand10 hours
£12

Functional Skills - Fitness

4.7(160)

By Janets

Register on the Functional Skills - Fitness today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Functional Skills - Fitness is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Functional Skills - Fitness Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Functional Skills - Fitness, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction Introduction To Functional Fitness Training 00:01:00 What Is Functional Fitness 00:08:00 Benefits Of Functional Fitness Benefits Of Functional Fitness 00:08:00 Functional Fitness & Other Exercises 00:08:00 Common Mistakes With Functional Fitness 00:07:00 Functional Fitness Training Areas Functional Fitness & Power 00:08:00 Functional Fitness & Strength 00:07:00 Functional Fitness & Range Of Motion 00:06:00 Functional Fitness & Balance & Endurance 00:07:00 Conclusion to Functional Fitness Training Conclusion 00:01:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Functional Skills - Fitness
Delivered Online On Demand1 hour 1 minutes
£25

Up and Running with Concurrency in Go (Golang)

By Packt

Get ready to tackle one of the most exciting and prominent features of the Go language with the help of this comprehensive course. If you are looking forward to getting started with advanced topics such as concurrency and levelling up your Go(lang) skills, then you are in the right place.

Up and Running with Concurrency in Go (Golang)
Delivered Online On Demand2 hours 12 minutes
£44.99

Maths Teaching Assistant

4.7(160)

By Janets

Master basic maths and equip yourself with fundamental problem-solving skills with the Maths Teaching Assistant course. This course is the ultimate guide for maths teachers who want to boost their confidence in the classroom and introduce maths in an accessible way.  This maths training program will help you to develop essential numeracy skills and maths teaching skills, covering key topics such as algebra, fractions, percentages and complex equations. You will explore strategies to help your pupils interpret primary numerical data and break down complicated information into simple structures. This course includes practical video lessons and exercises to ensure a valuable learning experience, regardless of your academic background. Learning Outcomes of The Maths Teaching Assistant Develop your knowledge of integers, fractions, multiples, and factors Learn how to work with decimal numbers, percentages, rational numbers, ratio & proportions Develop transferable problem-solving and analytical skills to use in the office and beyond Be able to apply your newfound knowledge to everyday contexts and situations Master complex equations and algebraic expressions with our expert tips and techniques Boost your professional development with a recognised qualification Understand how to interpret basic numerical data Develop your confidence and abilities in everyday maths tasks Why choose this course Earn a free e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post.

Maths Teaching Assistant
Delivered Online On Demand7 hours 36 minutes
£9.99

Diploma in Freelance Photography

4.3(43)

By John Academy

Description: Do you have dreams of turning your creative passion into a full-time career? Whether you're a professional photographer or know how to get creative with a digital camera, having a business plan and ideas is the first step to becoming a freelance photographer. This Diploma in Freelance Photography course is for photographers of all levels who have at least a basic knowledge of photography. We expect that you know how to take proficient quality photographs, but need the extra help to get your photography business off the ground. In this masterclass, you will learn how to determine your niche, market your freelance business on social media and grow clients in no time. Throughout this professional photography course, you will receive tips on different types of photography, from online photography, to portrait photography, wedding photography and commercial photography. You will go through a series of practical exercises intended to set you up for success.  On completion, your work will be evaluated, and our experts will offer constructive feedback to help you to develop your photography skills even further. You will also learn how to budget for your business and studio, copyright your work, build a portfolio, and decide your business rates. Who is the course for? Professional photographers who want to venture into business. People who have an interest in business and photography at the same time. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Diploma in Freelance Photography is a useful qualification to possess and will be very helpful to have, especially for these careers: Events Photographer Professional Photographer And much more! Basics of Photography How to Become a Digital Photographer? 02:00:00 Getting into the Scene 02:00:00 Choosing the Right Camera 02:00:00 Making Pictures for a Living 03:00:00 The Tools and Software for Editing the Images 02:00:00 The Most Commonly Asked Questions 01:00:00 Freelance Photography Photography Basics 01:30:00 The Art of Photography 01:30:00 FREELANCE PHOTOGRAPHY AND YOU 00:30:00 SHOULD YOU BE IN THIS BUSINESS FOR YOURSELF? 01:00:00 WEDDINGS 01:00:00 PORTRAITS 01:00:00 CARDS 01:00:00 NEWSPAPERS 01:30:00 SPECIALTY PHOTOGRAPHY 01:00:00 COPYRIGHTING YOUR WORK 01:00:00 ESTABLISHING YOUR BUSINESS 00:30:00 Mock Exam Mock Exam- Diploma in Freelance Photography 00:20:00 Final Exam Final Exam- Diploma in Freelance Photography 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Freelance Photography
Delivered Online On Demand24 hours
£11.99

Microsoft Excel VBA Programming Training

By Compete High

🚀 Unlock the Power of Microsoft Excel with Our Excel VBA Programming Training Course! 📊 Are you ready to take your Excel skills to the next level? Dive deep into the world of Excel VBA programming and unleash the full potential of this powerful tool! Our comprehensive online course, 'Microsoft Excel VBA Programming Training,' is designed to equip you with the expertise needed to automate tasks, streamline processes, and boost productivity within Excel. Here's what you'll learn in this dynamic course: 📌 Section 1: Introduction Get acquainted with the fundamentals of Excel VBA programming. Understand its significance and explore the vast possibilities it offers to transform your Excel experience. 📌 Section 2: Macros Master the art of creating and executing macros to automate repetitive tasks and significantly reduce manual work. Learn to streamline your workflow like a pro! 📌 Section 3: VBA Editor Navigate the VBA Editor seamlessly. Gain proficiency in using this interface to write, edit, and debug your VBA code effectively. 📌 Section 4: Variables and Procedures Understand the concept of variables and procedures in VBA. Learn how to declare, assign, and utilize them efficiently to optimize your coding process. 📌 Section 5: Loops and IF Statements Discover the power of loops and conditional IF statements. Harness these constructs to create dynamic and responsive Excel applications. 📌 Section 6: Error Handling Learn robust error-handling techniques to troubleshoot issues and create resilient VBA programs. 📌 Section 7: User Defined Functions Unlock the potential of creating custom functions tailored to your specific needs, enhancing Excel's capabilities beyond its default functions. 📌 Section 8: Assignments Apply your newfound knowledge through hands-on assignments and practical exercises to reinforce your skills. 📌 Section 9: Creating Forms Explore the creation of user-friendly forms and interfaces within Excel, making interactions more intuitive and efficient. Whether you're a beginner or have some experience in Excel, this course is tailored to suit your learning needs. With comprehensive modules, real-world examples, and expert guidance, you'll gain the confidence to create powerful VBA scripts and automate Excel operations like never before! Join us today and embark on a transformative journey in mastering Microsoft Excel VBA programming. Elevate your Excel skills and become a proficient VBA programmer! Enroll now and excel in Excel VBA programming! 💡📈✨ Course Curriculum Section 1 - Introduction What is VBA 00:00 Object Orientated Programming 00:00 Section 2 - Macros Macros Initial Setup 00:00 Recording a Macro 00:00 Saving a Macro 00:00 Section 3 - VBA Editor Launching VBA 00:00 VB Editor 00:00 Custom Menu 00:00 Naming Projects 00:00 Modules 00:00 Code Window 00:00 Comments 00:00 Section 4 - Variables and Procedures Introduction 00:00 Vraibales 00:00 Variable Exercise 00:00 What are Procedures 00:00 What are Procedures - Part Two 00:00 What are Procedures - Part Three 00:00 Message Boxes 00:00 Input Box 00:00 Input Box - Part Two 00:00 Basic Navigation 00:00 Sheets 00:00 Draft LessonCell Navigation 00:00 Advanced Sheets 00:00 Offset 00:00 Section 5 - Loops and IF Statements Introduction 00:00 Operators 00:00 Using Variables 00:00 What is Automation 00:00 For Loop 00:00 Do Loops 00:00 IF Statements 00:00 IF Statements - Part Two 00:00 Select Case 00:00 Section 6 - Error Handling Debugging 00:00 Section 7 - User Defined Functions UDFs 00:00 Section 8 - Assignments Introduction 00:00 Exercise 1 - Record a Macro 00:00 Exercise 2 - Duplicating Data 00:00 Exercise 3 - Generate a Report 00:00 Generate a Report - Part Two 00:00 Exercise 4 - Inner and Outer Loops 00:00 Inner and Outer Loops - Part Two 00:00 Inner and Outer Loops - Part Three 00:00 Inner and Outer Loops - Part Four 00:00 Inner and Outer Loops - Part Five 00:00 Section 9 - Creating Forms Form Controls 00:00 Building the Form 00:00 Initialize the Form 00:00 Command Buttons 00:00 Command Buttons - Part Two 00:00

Microsoft Excel VBA Programming Training
Delivered Online On Demand6 hours 17 minutes
£25

Microsoft Excel 2019 - Intermediate Level Training

By Compete High

🌟 Unlock Your Excel Potential with Microsoft Excel 2019 - Intermediate Level Training! 🌟 Master the art of Excel with our comprehensive online course designed specifically for intermediate learners. Elevate your skills, boost productivity, and excel in spreadsheet management like never before. 📊 Course Curriculum 📊 🔹 Section 1 - Excel - Intermediate: Dive into the intermediate level of Excel functionalities, bridging the gap between basic and advanced techniques. 🔹 Section 2 - Lists: Learn the art of managing data efficiently with lists, organizing information for streamlined analysis and presentation. 🔹 Section 3 - DataBase Functions: Harness the power of database functions, empowering you to manipulate data with ease and precision. 🔹 Section 4 - Data Validation: Ensure data accuracy and integrity by implementing effective data validation techniques, preventing errors in your spreadsheets. 🔹 Section 5 - Importing and Exporting: Master the process of importing and exporting data seamlessly, integrating external information into your Excel sheets effortlessly. 🔹 Section 6 - Creating Basic Charts: Transform data into impactful visuals with basic chart creation, enhancing your ability to communicate insights effectively. 🔹 Section 7 - Pivot Tables: Unlock the potential of pivot tables, harnessing their analytical power to summarize and analyze complex data sets effortlessly. 🔹 Section 8 - Working with Large Data: Navigate and manipulate extensive data sets efficiently, optimizing your workflow with strategies tailored for large-scale information. 🔹 Section 9 - LookUp Functions: Explore lookup functions to search for and retrieve specific data, refining your ability to find information swiftly. 🔹 Section 10 - Advanced Functions: Elevate your Excel proficiency with advanced functions, expanding your capabilities to handle complex calculations and tasks. 🔹 Section 11 - Excel Intermediate - Conclusion: Wrap up your intermediate Excel journey, reinforcing key concepts and preparing you for further advancements. 🎓 Why Choose Our Course? 🎓 🚀 Comprehensive Learning: A structured curriculum tailored to the needs of intermediate Excel users, covering a wide array of functionalities. 👨‍🏫 Expert Guidance: Led by industry experts well-versed in Excel, ensuring a rich learning experience with practical insights. 🤝 Interactive Learning: Engage with interactive exercises and real-life examples, solidifying your understanding through hands-on practice. 📈 Career Growth: Acquire skills highly sought after in the job market, giving you a competitive edge in various professional domains. 🔓 Don't miss this opportunity to take your Excel skills to the next level! Enroll now and unleash your potential with Microsoft Excel 2019 - Intermediate Level Training. 🔓 Course Curriculum Section 1 - Excel - Intermediate Excel Intermediate Introduction 00:00 Intermediate Shortcut Keys 00:00 Section 2 - Lists What are Lists 00:00 Sorting a List 00:00 Sorting - Multiple Criteria 00:00 Custom Sort 00:00 What are Filters 00:00 Format a List as a Table 00:00 Section 3 - DataBase Functions Introduction to DataBase Functions 00:00 DSum Function 00:00 DSum Function - Single Criteria 00:00 DSum Function - Multiple Criteria 00:00 DAverage 00:00 DCount Function 00:00 Subtotal 00:00 Section 4 - Data Validation Data Validation - List 00:00 Data Validation - Decimal 00:00 Input and Error Messages 00:00 Section 5 - Importing and Exporting Importing Data from Text Files 00:00 Importing Data from MS Access 00:00 Exporting Data to a Text File 00:00 Section 6 - Creating Basic Charts Creating Basic Charts 00:00 The Chart Ribbon 00:00 Adding and Modifying Data on a Chart 00:00 Formatting Charts 00:00 Section 7 - Pivot Tables Understanding Pivot Tables 00:00 Creating Pivot Tables 00:00 Pivot Table Calculations 00:00 Grouping Pivot Table Data 00:00 Formatting Pivot Table Data 00:00 Drilling Down into Pivot Table Data 00:00 Creating Pivot Charts 00:00 Filtering Pivot Table Data 00:00 Filtering using the Slicer 00:00 Section 8 - Working with Large Data Grouping Data 00:00 Consolidating Data 00:00 Section 9 - LookUp Functions VLookUp 00:00 HLookUp 00:00 Index and Match 00:00 Section 10 - Advanced Functions FV Function 00:00 PMT Function 00:00 Hyperlinks 00:00 Text to Columns 00:00 Section 11 - Excel Intermediate - Conclusion Excel Intermediate - Conclusion 00:00

Microsoft Excel 2019 - Intermediate Level Training
Delivered Online On Demand2 hours 34 minutes
£25