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

419 Icon courses in Cardiff delivered Online

Nail Class

By KEMP CENTER

Nail technician and styling class with certificate, conducted by expert female nail artists Looking to become a highly skilled nail artist? 24/01/2024 384 Course Participants 4,9 average rating Nail styling and art is a trending fashion and profitable business. Nail technicians and artists earn money by simply providing manicures, pedicures, or a fresh coat of paint to their customers’ nails. Whether you want beautiful nail art for yourself or intended to learn these new skills for enhancing your salon business: This nail styling and technician course will teach you everything to become an expert nail technician. Following the course modules, one by one will enable you to create stunning nail designs and to provide professional nail care services to your clients. The course is professionally designed into modules by expert trainers to provide you with a premium learning experience. Whether you are a new nail fashionista or a veteran nail technician, the course is loaded with lots of knowledge, techniques, and researched-backed tips and tricks for you. The course also offers a completion certificate that will serve as proof of your competence. Create amazing nail art Learn to create beautiful nail art with gel and air-dry polish. Our experts will teach you both traditional and modern techniques for creating amazing nail art. Learn the chemistry behind colors Our instructors are not focused on simply teaching nail techniques, but the science behind them; understand the chemistry behind colors, their ingredients, and combinations to come up with wonderful nail designs. Get professional nail design skills Learn to win your client’s heart by giving them a highly professional manicure and pedicure. Meet the people behind your favorite celebrity nail art We believe in providing ‘the best, hence our trainers are famous nail technicians for well-known celebrities. Get a chance to learn from the one behind your favorite person. Learn with Flexibility The course content is optimized to provide you with the best learning experience. Assignments, quizzes, unlimited access, and quick-knowledge recap allow you to learn and evaluate yourself anywhere and anytime. Join the nail artist course and get the benefits: Learning from a professional nail artist24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee Your Singing Instructor: Brittany Pustelnik World class nail artist Brittany is a licensed nail artist and a certified trainer with over ten years of experience in the nail styling industry. She has been working as a nail technician for the last 14 years with a well-known celebrity makeup artist and has provided nail art services to famous celebrities. Since 2009, she has been successfully dedicating herself to the passion of professional nail styling. She is a graduate of first and second degree studies in cosmetology and runs her renowned salon. Every year, she shares her knowledge with dozens of individuals in personal training sessions. Her postgraduate education in Teaching Qualifications makes Brittany not only a virtuoso in nail styling, but also an outstanding theorist and trainer. As a lecturer in cosmetology studies, she shares her passion and knowledge. She is also the author of articles in the industry magazines, exploring the art of nail decoration. Anna Kanikowska World class nail artist Anna, a renowned figure in the beauty scene, owns a famous nail styling salon. With over a decade of expertise, she has become the go-to manicurist for celebrities. Since 2010, her salon has been a hub of creativity, producing numerous awe-inspiring nail designs. A graduate in Cosmetology, Anna’s work embodies classic elegance. She excels in creating flawless French manicures and striking compositions in bold reds and blacks. Anna is one of two seasoned experts whose contributions have enriched our nail styling course with extensive practical and industry insights. Her guidance not only nurtures passion but also paves the way for aspiring experts to join the elite circle of manicurists. Overview of the course: Detailed Video presentations 1. Essential knowledge for Nail class participants: ♦ Fundamentals of nail styling ♦ Health and safety while doing someone’s nails ♦ Exploring career opportunities and what this industry can offer ♦ How to be a successful nail artist 2. Various techniques of nail styling ♦ Mechanical manicure ♦ Hybrid manicure 3. Safety and taking care of nails ♦ Nails diseases ♦ How to clean your workspace and tools? ♦ How to care about natural nails? ♦ Tricks and tips for keeping your nails in good condition ♦ Safety procedures in a nail salon Training videos 1. Introduction to being a nail artist ♦ Summarizing the preparation for nail stylization ♦ Fundaments of nail styling ♦ Hand and nail care ♦ Fundamental knowledge about natural nails 2. Different techniques in nail art ♦ Gel nail painting ♦ Varnish nail painting ♦ Nail lamp 3. Manicure- basic techniques ♦ Japanese Manicure ♦ Mechanical Manicure ♦ Hybrid Manicure Tests 1. Tests and repetitions Test your knowledge and what you have learned with our specially designed test that will help you memorize all the information from the course. 2. Final Exam ♦ Final test Tasks Practical tasks: ♦ Analyzing and grasping client’s needs ♦ Preparing and setting up workspace ♦ Performing a classic manicure ♦ Performing an advanced manicure with tools ♦ Getting your first clients and creating a thriving business Course materials ♦ Nail design idea ♦ Viral trends in nail art ♦ What is the difference between holo, glitter, rainbow, and multi-chrome nail polishes Self-paced Course Learn how to perform professional nail designs with this unique nail class. You will see firsthand how professionals work and learn everything in practice. We reveal all the products, tools, techniques and professional methods and secrets in one comprehensive course. With interactive learning modules, exercise sessions and high quality video content available 24/7, you will be able to learn every detail of the best nail techniques. You will also have the opportunity to exercise and learn everything in practice. We will help you develop your practical skills – even if you’re just starting out.

Nail Class
Delivered Online On Demand10 hours
£300

PowerPoint Presentation Skills

5.0(50)

By Pochat Training

POWERPOINT 🔸 A series of 1 hour sessions 🔸 Learn different aspects of PowerPoint and boost those presentations of yours! 🔸 Learn how to create stunning presentations that wow your audience 🔸 Do the sessions that are of most use to you! Or do them all, it's entirely up to you - and if you do, we have a 'Do all 6 and only pay for 5' offer for you! - we don't know how to run this offer via Eventbrite though, so contact us or book all of them via our website instead: https://pochattraining.co.uk/powerpoint/ 💦Session 1)  Text Formatting The skills learned in this session are useful for all Microsoft Office Products and most other Word Processing Apps 💦Session 2) Image Formatting & Effects  💦Session 3) Using and Formatting SmartArt 💦Session 4) Creating Slide Masters 💦Session 5) Animating Text and Images 💦Session 6) Page Design, Layout and Transitions Run by a friendly, patient trainer, these sessions will be held in small groups These are practical sessions, where you will practice what we're covering as we go along Ask as many questions as you like Many people are using PowerPoint but have never really learned how to use most of its features Learn how to do all those nifty tricks that you see other presenters using Spice up your presentations! Are you great with using text but don't really know a lot about image formatting, or general page design? Now is your chance to pick and choose and learn what you need

PowerPoint Presentation Skills
Delivered OnlineFlexible Dates
£12.50 to £125

Digital Marketing and Advertising Level 3

4.9(27)

By Apex Learning

Overview Become an expert in online marketing and learn how to turn brands and businesses into huge successes overnight. This popular Digital Marketing and Advertising Level 3 course is designed to teach anyone the fundamental knowledge needed to perform dynamic online advertising that works. The many online learning modules provide expert tuition for every aspect of Digital Marketing; from using SEO to target an audience, to utilising the power of social media to make a product go viral. You will also be taught how to use video and email marketing in order to maximise the recognition for your work and make everyone aware of your product. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Digital Marketing and Advertising Level 3. It is available to all students, of all academic backgrounds. Requirements Our Digital Marketing and Advertising Level 3 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 13 sections • 123 lectures • 11:23:00 total length •Welcome: 00:01:00 •How to register your company: 00:04:00 •How to see Email Sender's Company and Logo in Your Gmail: 00:02:00 •How to Generate sitemap of a website: 00:03:00 •How to protect a website from Spam on WordPress: 00:02:00 •Quick way to identify whether the website is Mobile optimized: 00:03:00 •How to identify registration data of website: 00:01:00 •How to identify duplicate content from the web: 00:03:00 •How to create google alerts: 00:03:00 •How to find the age of the domin: 00:02:00 •How to check if the website server is down: 00:01:00 •How to create text notes thatwill self destruct after being read: 00:02:00 •How to send google search information to your friends: 00:03:00 •How to find webhost of any website: 00:02:00 •Discover new sites that are similar to what you like alredy: 00:03:00 •How to easily highlight the important parts of a web page: 00:01:00 •How to share you email online without worrying about spam: 00:02:00 •How to get compute level answers without searching: 00:03:00 •The easiest way to setup email reminders: 00:03:00 •How to find the original URL tht's hiding behind a short URL: 00:02:00 •How to corrupt a file you shared online: 00:01:00 •How to create a throwaway email: 00:02:00 •How to check if your email account has been compromised: 00:01:00 •How to register website on Google search console: 00:06:00 •How to Optimize your website homepage: 00:06:00 •How to add a sitemap on google search: 00:07:00 •How to shortlist targeted keyword list in google keyword planner: 00:08:00 •How to set international targeting on google search: 00:02:00 •How to remove a URL from google search engine: 00:03:00 •How to identify competitors keyword: 00:08:00 •How to leverage top sites to get on google search results: 00:04:00 •Discover powerful data analytics to mesure SEO performance: 00:06:00 •How to do keyword research: 00:11:00 •How to write perfect title tags for search engines: 00:05:00 •How to optimise heading tags, external and internal links: 00:08:00 •What are backlinks & how to get them: 00:06:00 •How to write a perfect Meta description: 00:06:00 •How to enhance speed & performance of your website: 00:04:00 •Youtube account setup: 00:04:00 •Account optimization: 00:09:00 •How to create & setup Youtube channel banner: 00:05:00 •Youtube channel tags, thumbnails & custom thumbnails: 00:08:00 •Analyse Youtube keyword research: 00:05:00 •Youtube SEO techniques: 00:07:00 •What are Youtube cards & how does it work: 00:06:00 •How to optimise comments & reply them in bulk: 00:03:00 •How to grow your channel with competitor Analysis: 00:07:00 •How to manage multiple YouTube accounts: 00:02:00 •A simple yet powerful trick to increase your subscribers list: 00:03:00 •Youtube Paid Advertising: 00:13:00 •How to monetise your YouTube channel: 00:02:00 •What are Google Ads & how does it work: 00:16:00 •Account setup: 00:04:00 •Competitors analysis: 00:08:00 •Campaign types & how to select the right campaign: 00:07:00 •Bids & Budgets: 00:08:00 •How to target the right audience: 00:07:00 •Google Ads advance campaign settings: 00:07:00 •Choosing the right keywords: 00:05:00 •How to write ads that gets more clicks: 00:06:00 •How to install tracking code on your website: 00:04:00 •How to add filters & remove internal traffic: 00:04:00 •How to track paid campaigns: 00:04:00 •How to look and analyse different segment data: 00:06:00 •How to configure goals in google analysics: 00:05:00 •How to link google Adwords account: 00:03:00 •How to manage multiple analytics accounts: 00:02:00 •How to remove spam traffic: 00:04:00 •Email marketing tools set up ( Mailchimp and Gestresponse): 00:10:00 •How to install signup or popup forms on the website: 00:17:00 •How to collect email address without a wbsite: 00:05:00 •How to create a 'Hook' to your signup forms: 00:08:00 •Discover the psychology behind acquiring more leads: 00:09:00 •Email marketing automation process: 00:08:00 •Email analytics: 00:07:00 •How to increase your connections in no time: 00:08:00 •Secret of LinkedIn InMails: 00:05:00 •Discover the best ways to use Linkedin Groups: 00:09:00 •How to setup a company page on Linkedin: 00:04:00 •How to increase traffic to your website using Linkedin blog: 00:07:00 •Twitter Account setup: 00:03:00 •Knowing Twitter features: 00:06:00 •Following twitter accounts: 00:03:00 •Twitter profile optimisation: 00:06:00 •How to get Twitter followers: 00:10:00 •Posting first 5 tweets for engagement: 00:05:00 •Leveraging Hashtags to increase your tweets visibility: 00:04:00 •What are twitter polls & how do you use them: 00:05:00 •A powerful trick to acquire customers on twitter: 00:03:00 •How to get followers retweet your post: 00:03:00 •How to embed a twitter button to your website or post: 00:02:00 •Twitter analytics: 00:04:00 •Set your Facebook page: 00:05:00 •Facebook Icon, cover image & description: 00:06:00 •How to get your first page likes: 00:08:00 •Discover how to increase your page likes: 00:02:00 •How to manage multiple Facebook page: 00:03:00 •Facebook comments: 00:05:00 •Leveraging Facebook groups: 00:05:00 •Facebook Autoposting: 00:04:00 •Run a competition: 00:06:00 •Facebook Ads: 00:04:00 •How to get best out of Facebook: 00:15:00 •Facebook pixel & Re-marketing: 00:04:00 •How to setup a Instagram business profile: 00:07:00 •Set up Instagram bio & profile image: 00:03:00 •Leveraging Instagram accounts: 00:06:00 •A simple way to create free content on Instagram: 00:05:00 •Secret of hashtags on Instagram: 00:04:00 •Reposting Instagram App: 00:04:00 •How to get genuine Instagram followers: 00:05:00 •Discover how to grow your business through Instagram stories: 00:05:00 •How to get your posts reposted on Instgram by influncers: 00:05:00 •A quick way to do App store marketing research: 00:16:00 •How to discover the estimate size of your market: 00:08:00 •Discover the best ways to promote your app: 00:15:00 •App installs via Facebook Ads: 00:16:00 •App installs via Google Ads: 00:14:00 •How to make money from your app: 00:08:00 •How to optimise your App store listing ?: 00:14:00 •Discover growth hacking techniques for App downloads: 00:09:00 •Techniques to get to the top of App store ranking: 00:07:00 •Assignment - Digital Marketing and Advertising Level 3: 00:00:00

Digital Marketing and Advertising Level 3
Delivered Online On Demand11 hours 23 minutes
£12

Digital Skills: Digital Marketing

4.7(47)

By Academy for Health and Fitness

Digital marketing is not just a "secure" professional route in today's economy, but it is also a flourishing employment market! Digital marketing is a terrific option because the need for it is growing every day in the UK. Companies used to promote on television, radio, and in newspapers, but now they are more focused on advertising on digital media. This course will get you up and running quickly in gaining the fundamental skills and training needed to establish your career as a digital marketer. Digital Skills: Digital Marketing is the best digital marketing course for people who want to learn how to leverage social media and popular online apps to increase product and service recognition. You'll be led through real-world instances and methods, as well as learning activities designed to help you create extremely successful commercials. After completing this course, you will be able to develop and execute first-rate marketing campaigns utilising email, SEO, and a variety of other tactics. This knowledge will be important for your CV when applying for senior positions in this industry. After this course, you will be able to: Learn the fundamentals of SEO Improve your understanding of Google AdWords and Google Analytics Learn efficient Facebook marketing strategies Learn about lead-creation tactics Discover the fundamentals of email marketing Learn about the Content Management System (CMS) Develop your knowledge of strategic marketing, sales growth, and other areas Discover the ideal step-by-step LinkedIn marketing strategy Learn how to create Instagram leads Discover how they increased their internet sales Learn how much money to put into internet marketing Discover how to boost their conversion rate and convert website visitors into paying clients Learn how Google, Facebook, Amazon, and other online "monsters" employ internet marketing methods Discover how to use a list-building method Why Prefer this Digital Skills: Digital Marketing Course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standards-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support Experts created the Digital Skills: Digital Marketing course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the course: Module 01: Introduction This module covers the following topics: Welcome Module 02: General Tips & Tricks Series This module covers the following topics: How to register your company How to see Email Sender's Company and Logo in Your Gmail How to Generate a sitemap of a website How to protect a website from Spam on WordPress Quick way to identify whether the website is Mobile optimized How to identify registration data of website How to identify duplicate content from the web How to create google alerts How to find the age of the domain How to check if the website server is down How to create text notes that will self destruct after being read How to send google search information to your friends How to find webhost of any website Discover new sites that are similar to what you like alredy How to easily highlight the important parts of a web page How to share you email online without worrying about spam How to get compute level answers without searching The easiest way to setup email reminders How to find the original URL tht's hiding behind a short URL How to corrupt a file you shared online How to create a throwaway email How to check if your email account has been compromised Module 03: SEO (Search Engine Optimisation) This module covers the following topics: How to register website on Google search console How to Optimize your website homepage How to add a sitemap on google search How to shortlist targeted keyword list in google keyword planner How to set international targeting on google search How to remove a URL from google search engine How to identify competitors keyword How to leverage top sites to get on google search results Discover powerful data analytics to mesure SEO performance How to do keyword research How to write perfect title tags for search engines How to optimise heading tags, external and internal links What are backlinks & how to get them How to write a perfect Meta description How to enhance speed & performance of your website Module 04: YouTube This module covers the following topics: Youtube account setup Account optimization How to create & setup Youtube channel banner Youtube channel tags, thumbnails & custom thumbnails Analyse Youtube keyword research Youtube SEO techniques What are Youtube cards & how does it work How to optimise comments & reply them in bulk How to grow your channel with competitor Analysis How to manage multiple YouTube accounts A simple yet powerful trick to increase your subscribers list Youtube Paid Advertising How to monetise your YouTube channel Module 05: Google AdWords This module covers the following topics: What are Google Ads & how does it work Account setup Competitors analysis Campaign types & how to select the right campaign Bids & Budgets How to target the right audience Google Ads advance campaign settings Choosing the right keywords How to write ads that gets more clicks Module 06: Google Analytics This module covers the following topics: How to install tracking code on your website How to add filters & remove internal traffic How to track paid campaigns How to look and analyse different segment data How to configure goals in google analysics How to link google Adwords account How to manage multiple analytics accounts How to remove spam traffic Module 07: Email Marketing This module covers the following topics: Email marketing tools set up ( Mailchimp and Gestresponse) How to install signup or popup forms on the website How to collect email address without a wbsite How to create a 'Hook' to your signup forms Discover the psychology behind acquiring more leads Email marketing automation process Email analytics Module 08: Linkedln This module covers the following topics: How to increase your connections in no time Secret of LinkedIn InMails Discover the best ways to use Linkedin Groups How to setup a company page on Linkedin How to increase traffic to your website using Linkedin blog Module 09: Twitter This module covers the following topics: Twitter Account setup Knowing Twitter features Following twitter accounts Twitter profile optimisation How to get Twitter followers Posting first 5 tweets for engagement Leveraging Hashtags to increase your tweets visibility What are twitter polls & how do you use them A powerful trick to acquire customers on twitter How to get followers retweet your post How to embed a twitter button to your website or post Twitter analytics Module 10: Facebook This module covers the following topics: Set your Facebook page Facebook Icon, cover image & description How to get your first page likes Discover how to increase your page likes How to manage multiple Facebook page Facebook comments Leveraging Facebook groups Facebook Autoposting Run a competition Facebook Ads How to get best out of Facebook Facebook pixel & Re-marketing Module 11: Instagram This module covers the following topics: How to setup a Instagram business profile Set up Instagram bio & profile image Leveraging Instagram accounts A simple way to create free content on Instagram Secret of hashtags on Instagram Reposting Instagram App How to get genuine Instagram followers Discover how to grow your business through Instagram stories How to get your posts reposted on Instgram by influncers Module 12: Mobile App This module covers the following topics: A quick way to do App store marketing research How to discover the estimate size of your market Discover the best ways to promote your app App installs via Facebook Ads App installs via Google Ads How to make money from your app How to optimise your App store listing ? Discover growth hacking techniques for App downloads Techniques to get to the top of App store ranking CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Digital Skills: Digital Marketing course is suitable for: Individuals who are seeking to acquire digital marketing skills and knowledge Professionals who want to improve their digital marketing skills Business owners who want to learn how to market their business online Individuals who are interested in pursuing a career in digital marketing Professionals who are looking to improve their digital marketing skills for career advancement or to increase their employability Entrepreneurs and small business owners who want to learn how to promote their products or services online effectively Marketing or business students looking to expand their skill set and stay up-to-date with the latest digital marketing trends and tools Non-marketing professionals who want to learn digital marketing skills to improve their job prospects or add value to their current role Requirements The program does not require any prior knowledge; everyone may participate! This course is open to anyone interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This Digital Skills: Digital Marketing course allows you to study at your speed and grow a quality skillset. Career path Marketing Executive (£20,000 to £50,000) Advertisers (£20,000 to £80,000) Market Researcher (£17,000 to £24,000) Advertising Media Buyer (£21,000 to £36,000) Brand Manager (£27,000 to £65,000) Advertising Media Planner (£18,000 to £50,000) Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Digital Skills: Digital Marketing
Delivered Online On Demand11 hours
£12

Certified Kanban System Design – KMP I - 17-19 December

By Tom Reynolds

Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company

Certified Kanban System Design – KMP I - 17-19 December
Delivered OnlineFlexible Dates
£1,074 to £1,194

Certified Kanban System Design – KMP I - 19-21 November

By Tom Reynolds

Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company

Certified Kanban System Design – KMP I - 19-21 November
Delivered OnlineFlexible Dates
£1,074 to £1,194

Certified Kanban System Design – KMP I - 24-26 September

By Tom Reynolds

Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company

Certified Kanban System Design – KMP I - 24-26 September
Delivered OnlineFlexible Dates
£1,074 to £1,194

Excel 2019 Intermediate

5.0(1)

By Course Gate

The Professional Presenter Training provides you with the knowledge and skill building in the planning, preparation and delivery of truly engaging presentations. Exploring all aspects of concept, design and delivery, you will gain a range of tools and techniques to help you plan and deliver engaging and effective presentations to a range of audiences. You'll learn how to use specific tools and techniques for presentation creation and delivery which will enable you to conduct powerful presentations that engage your audience every time. This course will give you the framework needed to develop and deliver an effective, memorable presentation. You will learn proven tips and examples that will guide you through the presentation process no matter how large the audience. Who is this course for? Excel 2019 Intermediate is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Excel 2019 Intermediate is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Intro Introduction 00:01:00 Section 01 Linking Worksheets and Workbooks 00:07:00 Linking Worksheets with 3D References 00:05:00 Understanding the Consolidate Feature 00:06:00 Section 02 What are Range Names 00:06:00 Creating Range Names Using the Name Box and Define Name 00:06:00 Creating Range Names Using Create from Selection 00:03:00 Section 03 Understanding the Differences Between Sorting and Filtering 00:03:00 Sorting Lists 00:07:00 Filtering Lists 00:06:00 Creating Subtotals 00:05:00 Section 04 Creating Tables and Understanding the Benefits 00:06:00 Understanding the Elements of a Table 00:05:00 Formatting a Table 00:05:00 Sorting and Filtering Tables 00:04:00 Filtering with Slicers 00:07:00 Calculating with Tables 00:06:00 Removing Erroneous Table Data 00:05:00 Exporting, Refreshing, and Converting Tables 00:05:00 Section 05 What is Conditional Formatting 00:03:00 Conditional Formatting-HIghlight Cells and Top Bottom Rules 00:06:00 Conditional Formatting-Data Bars, Icon Sets, and Color Scales 00:06:00 Using Custom Fonts and Colors 00:03:00 Using Custom Conditional Formatting 00:05:00 Modyfing or Removing Conditional Formatting 00:04:00 Section 06 What are Charts 00:06:00 Forecasting with Trendlines 00:05:00 Creating a Chart Template 00:04:00 Displaying Trends with Sparklines 00:08:00 Creating Charts 00:05:00 Understanding Chart Elements 00:05:00 Modifying Chart Elements 00:05:00 Changing and Moving Charts 00:03:00 Filtering a Chart 00:04:00 Formatting Charts 00:13:00 Adjusting Numbering 00:06:00 Creating Dual Axis Charts 00:05:00 Section 07 What is a PivotTable 00:05:00 Creating a PivotTable 00:07:00 Working with the PivotTable Fields Pane 00:10:00 Basic Data Organization and Analysis with PivotTables 00:08:00 Formatting PivotTables 00:05:00 Creating a PivotChart 00:04:00 Modifying and Formatting a PivotChart 00:04:00 Using Slicers and Timeline Slicers 00:08:00 Section 08 Using the PivotTable and PivotChart Wizard 00:03:00 Adding a Calculated Field 00:04:00 Adding a Calculated Item 00:04:00 Applying Conditional Formatting to a PivotTable 00:06:00 Creating Filter Pages for a PivotTable 00:04:00 Enabling the PowerPivot Add-in 00:11:00 Recap Recap 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Excel 2019 Intermediate
Delivered Online On Demand4 hours 39 minutes
£11.99

The Comprehensive Android Developer Bootcamp

By Packt

Learn new Android APIs such as RoomDatabase, ML Kit for face recognition, Cloud Firestore, Firebase, Maps, and the Android Studio IDE (integrated development environment)

The Comprehensive Android Developer Bootcamp
Delivered Online On Demand43 hours
£93.99

Stress management & building resilience - 1 Day Online Workshop

By Haptivate

Discover practical ways to reduce stress, improve motivation and handle challenges with greater ease.

Stress management & building resilience - 1 Day Online Workshop
Delivered OnlineFlexible Dates
£249