53587 Courses delivered Online

This course will teach you the fundamentals of HR management, employee relations, and talent acquisition. You will learn how to create effective recruitment strategies, handle employee issues, and develop your own HR career. This course is suitable for anyone who works in HR, wants to become an HR professional, or manages a team of employees. You will also receive a recognised CPD certificate upon completion of the course.

The Executive Mini MBA will teach you all those things you learn from an MBA course that too in a shorter period. From learning theories to implying it in practical life, the course plan carries all the important aspects. This beneficial program will help you to gain in-depth knowledge about Economics and business. The administrative and managerial aspects of the business will become clearer to you. The course will also familiarise yourself with a wide variety of topics such as strategy planning, marketing strategy, resource management, etc. Most importantly, the course will play a significant role to develop the required leadership skill to lead a business organisation. By completing this course, you will become efficient enough for securing a high position in a business organisation.  Who is this Course for? This Executive Mini MBA course is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. 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. Method of Assessment: Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly. 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. Certification After successfully completing the course, you will be able to obtain the certificates. You can claim a PDF certificate by paying a little processing fee of £2. There is an additional fee to obtain a hardcopy certificate which is £9. Course Curriculum Module 1:- Business Planning and Analysis Business Planning Basics 01:00:00 Market Evaluation 01:00:00 Analyze Competition 01:00:00 Determine A Marketing Strategy 01:00:00 Decide What Extras You May Need Like Staff etc 00:30:00 The Dangers In Not Making A Business Plan 00:15:00 Module 2: -Business Administration and Branding Introduction 00:15:00 Make Yourself Well Recognised Before Your Customers 00:30:00 Wow Your Customers 00:30:00 Develop a Personal Style 00:30:00 Use Creative Imageries to Catch the Attention 00:30:00 Be a Traditionalist, Not a Fad Chaser 00:15:00 Bringing Out the Purple Cow in Your Business 00:30:00 Conclusion 00:15:00 Module 3: - Business Succession Planning Getting Started 00:30:00 Succession Planning Vs. Replacement Planning 01:00:00 Preparing for the Planning Process 01:00:00 Initiating Process 00:00:00 The SWOT Analysis 01:00:00 Developing the Succession Plan 01:00:00 Executing the Plan 00:30:00 Gaining Support 00:30:00 Managing the Change 01:00:00 Overcoming Roadblocks 01:00:00 Reaching the End 01:00:00 Wrapping Up 00:15:00 Module 4: -Business Development Budgeting Businesses Budgeting Basics 00:15:00 Steps To Better Business Budgeting 00:15:00 How And What To Consider When Preparing A Business Plan And Budget 01:00:00 The Ins And Outs Of Corporate Budgeting 00:15:00 Including Social Business Budgets In The Plan 00:15:00 Impacts Of Debts On Business Budgets 00:15:00 Managing Business Budgets And Finances Together 01:00:00 Module 5: -Management Introduction 01:00:00 How to Build Trust and Confidence 01:00:00 A Manager's Pitfalls 01:00:00 How to Build Team Spirit 01:00:00 Dealing with Problem Employees 01:00:00 Using Your Emotional Intelligence 00:30:00 Conclusion to Management 00:15:00 Module 6:- Business Management Skills Business Plan Basics 00:30:00 The Executive Summary 01:00:00 The Mission Statement 00:30:00 Exploring Financial Needs 00:30:00 Evaluating Competition 01:00:00 The Troubles You Can Run Into Without The Proper Business Plan 00:30:00 Wrapping Up 00:15:00 Module 7: Project Management Introduction 01:00:00 Can You Manage Yourself Out Of A Paper Bag? 00:30:00 Setting the Stage for a Successful Project 01:00:00 The Importance of Developing and Managing A Budget 00:30:00 Taking Action - Execution of the Plan 01:00:00 Rules to Manage The Projects 01:00:00 Your Personality and Project Management Style 01:00:00 The Cycle of Decision Making 01:00:00 Getting Your Project Back On Track 01:30:00 Keeping It Moving Forward 01:00:00 Problems and Solutions in Project Management 01:00:00 Module 8: HR and Leadership Management Leader and HR Management 00:30:00 Commitment and HR Management 01:00:00 Team Management 00:30:00 Build A Mastermind Group 02:00:00 People Recognition in HR Management 00:30:00 Performance, Goals and Management 00:30:00 Think Outside The Box 00:30:00 Be Passionate about Your Work 00:30:00 The Importance Of A Good Team Leader 00:30:00 Module 9: Business Systemization Introduction 00:30:00 The Idea of Systemizing Your Business 01:00:00 Why You Should Systemize Your Business 01:00:00 A Lesson Learned From The Book 'The E-Myth' 01:00:00 So, How Do I Create This Wonderful Business System? 01:00:00 Outsourcing As a Way of Systemizing Your Business 00:30:00 How to Keep It Growing: The Systemized Business 01:00:00 Some General Ideas To Consider As You Systemize Your Business 00:30:00 Conclusion 00:15:00 Module 10: - Business Ethics Fundamentals Getting Started To Business Ethics 00:15:00 What is Ethics? 01:00:00 Implementing Ethics in the Workplace 00:30:00 Employer/Employee Rights 01:00:00 Business & Social Responsibilities 01:00:00 Ethical Decisions 01:00:00 Whistle Blowing 00:30:00 Managerial Ethics 00:30:00 Unethical Behavior 00:30:00 Ethics in Business (I) 01:00:00 Ethics in Business (II) 00:30:00 Wrapping Up 00:15:00 Module 11: Sales Analysis and Sales What Is A Sales Funnel? 00:30:00 What is Internet Commerce 00:30:00 What Can I Sell 00:30:00 Clickbank 00:30:00 Drop Shipping 00:30:00 Affiliate Marketing 00:30:00 The Link Between Products, Key Words and Prospects 00:15:00 The Front-end and Back-end of Sales Funnels 00:30:00 Sales Funnel Success 00:30:00 Sales Funnel Planning 00:30:00 Putting Your Theory to Practice 00:30:00 Content Marketing 00:30:00 Article Marketing 01:00:00 Google's Adwords Program 00:30:00 Marketing Offline 00:30:00 Blogs 00:30:00 Social Media 00:30:00 Auto Responders 00:30:00 The Joint Venture 00:30:00 Measuring Success 00:30:00 Top Sales Funnel Products 00:30:00 Mock Exam Mock Exam- Executive Mini MBA 00:30:00 Final Exam Final Exam - Executive Mini MBA 00:20:00 Recommended Readings Recommended Readings - Executive Mini MBA 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Master advanced Excel skills and boost your career with our Microsoft Excel Advanced Diploma Course. Gain proficiency in data analysis, understand advanced features, and develop practical expertise.

The event management and planning industry is growing and reshaping swiftly every day. If you find your passion attached to this field, then the Event Planner course can help you bring a spectacular opportunity to you. Learn the ins and outs and the different crucial aspects of event management from our on-demand-course Event Planner and take the first step to be an event planner. Our Event Planner course lessons are prepared by industry-leading experts with feature interactive activities. You'll learn how you can use various devices effectively from industry experts. This Event Planner course has been divided into understandable and manageable sections that we feel will help you grasp each concept- from the basic to advanced course components. Learn from industry experts today and enhance your skills and knowledge so that you can lead tomorrow. This Event Planner course will increase your possibility to get your desired job and boost your personal growth. Enjoy a pleasant and professional 100% online learning experience and enrol in our Event Planner course today and take control of your career! Learning Objectives Learn the principles of event management Understand how to choose the perfect place for your event Get to know about interior and outdoor designing Be able to use lighting to create beautiful designs Understand how to deal with difficult clients Acquire the skills to plan food menus and entertainments based on that type of event Be able to manage after-event residue Understand the importance of recycling and cleaning Who is this Course for? The Event Planner course is ideal for highly aspiring individuals who wish to enhance their professional skills and train for the job they want! Also, this course is highly beneficial for people who want to have some in-depth knowledge on this topic and keep up to date with the latest information. So, you can enrol in this course if you are: Organisers Event Planners Event Managers Personal Assistants Designers Study the Event Planner course today and enhance your professional skillset from the comfort of your home! Entry Requirements There are no formal entry requirements for the Event Planner course; with enrollment, this course is open to anyone! Anyone with a passion for learning about event management can enrol in this course without any hesitation. Although, the learner needs to have a good understanding of the English language to attend this course and understand what this course is about. 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 £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path This Event Planner course will help you gain all the necessary theoretical knowledge to excel in the relevant field. Enrol on our event management course now and get started on the journey of taking your career to the next level. Course Curriculum Module 1: Introduction to Event Management Introduction to Event Management 00:24:00 Module 2: Role of an Event Planner Role of an Event Planner 00:31:00 Module 3: Event Classification Event Classification 00:28:00 Module 4: Events and Clients Events and Clients 00:18:00 Module 5: Steps to Plan an Event Steps to Plan an Event 00:27:00 Module 6: Invitation to the Event Invitation to the Event 00:25:00 Module 7: Event Marketing Event Marketing 00:31:00 Module 8: Catering at Events Catering at Events 00:22:00 Module 9: Event Decorations Event Decorations 00:25:00 Module 10: Cleaning and Waste Disposal Cleaning and Waste Disposal 00:20:00 Module 11: Event Security Event Security 00:16:00 Module 12: Developing an Event Planning Business Developing an Event Planning Business 00:23:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Event and Hospitality Management will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Event and Hospitality Management will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Event and Hospitality Management and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Event and Hospitality Management is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Event and Hospitality Management. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. 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 The Event and Hospitality Management will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Event Planner Event Planning 01:33:00 Steps for Planning an Event 02:24:00 Invitations, Greetings, and Dress Code 01:09:00 Table Manners and Table Settings 01:51:00 The Event 01:09:00 What is Event Management 01:48:00 Types of Events 01:57:00 Hospitality Management Introduction to Hospitality 00:15:00 Characteristics of the Hospitality Industry 00:15:00 Relationship Between the Hospitality Industry and Tourism 00:15:00 Types of Accommodation 00:15:00 Types of Room 00:30:00 Types of Hotel Guests 00:15:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Do you love horses? Or like to build up a friendly relationship with your horse? Then learning about equine psychology is the perfect choice for you. We designed an Equine Psychology course that will help you to understand the behaviour of horses and how to train them.  This Equine Psychology course will teach you basic horse training, their behavioural changes and how to build a strong and healthy relationship between humans and horses. Learn all the necessary skills and knowledge about horse grooming and equine psychology from this equine psychology course. Lessons of Equine Psychology were prepared by experts and feature interactive activities and assessments to ensure that all vital equine procedures are taught promptly. By enrolling in this extensive Equine Psychology course, you'll learn how to establish yourself as a valuable asset in any challenging environment.  This Equine Psychology course has been divided into several easy-to-digest, manageable sections that will help you grasp each concept- from the basic to advanced course components. Get skilled in our comprehensive Equine Psychology course and start your career as an equine therapist. Learning Objectives Learn the basics and fundamentals of equine psychology Understand the evolution of horse behaviour Be able to communicate with your horse and understand their needs Get to know about the development of horses from young to adult Know how to develop a strong and trustworthy relationship between horse and human Familiarise with the learning theory of equine psychology Know about the scientific methods of training horses Who is this Course for? This Equine Psychology course is ideal for aspiring horse trainers who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of the principles of Equine Psychology or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course; however, an eye for detail and a creative mind is essential. Entry Requirement Anyone interested in learning more about this subject should take this Equine Psychology course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. 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 £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path On successful completion of the Equine Psychology course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Horse Trainers Horse Instructors Equine Therapists Course Curriculum Module 01: Introduction to Equine Psychology Introduction to Equine Behaviour and Psychology 00:29:00 Module 02: Equine Communicative Behaviour Equine Communicative Behaviour 00:23:00 Module 03: Reproduction and Stallion Behaviour Reproduction and Stallion Behaviour 00:36:00 Module 04: Behaviour of Foals and Ponies Behaviour of Foals and Ponies 00:23:00 Module 05: Training Horses Training Horses 00:26:00 Module 06: Horse-Human Relationships Horse-Human Relationships 00:19:00 Module 07: Equines Environmental and Social Behaviour Equines Environmental and Social Behaviour 00:22:00 Module 08: Equine Locomotive Behaviour Equine Locomotive Behaviour 00:25:00 Module 09: Unusual and Problematic Behaviour Unusual and Problematic Behaviour 00:31:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

English has emerged as the global language of trade and commerce in the past few decades and also become the standard for all vital official communications. This English As A Second or Foreign Language course is an ideal course designed to improve your communicative ability and provide you with useful lessons for promoting the strength to communicate during socialising, delivering speeches, telephoning, emailing, marketing to important business contracts or even taking part in business meetings and negotiating. This comprehensive course also intends to build your confidence and fluency by assisting you to analyse tasks and take part in practice activities that progressively promote listening and speaking skills. By the time you complete this course, you'll have an outstanding command of English which required for any prominent jobs these days. Who is this course for? English As A Second or Foreign Language 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 English As A Second or Foreign Language 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 English As A Second or Foreign Language Module 1_ Introduction to ESL_EFL 00:30:00 Module 2_ GREETINGS AND INTRODUCTIONS 00:20:00 Module 3_ INVITATIONS 00:30:00 Module 4_ SMALL TALK 00:30:00 Module 5_ SOCIALIZING 00:20:00 Module 6_ EATING OUT 00:30:00 Module 7_ TELEPHONING 00:30:00 Module 8_ CORRESPONDENCE 00:30:00 Module 9_ GETTING A NEW JOB 00:30:00 Module 10_ LOCATION 00:20:00 Module 11_ SHAPES & TRENDS 00:30:00 Module 12_ NUMBERS 00:30:00 Module 13_ Ideas for Practising English 00:30:00 Mock Exam Mock Exam - English As A Second or Foreign Language 00:20:00 Final Exam Final Exam - English As A Second or Foreign Language 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

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 Introduction 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 Introduction 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 Introduction Introduction 00:01:00 Section 01 What is Excel 00:04:00 Opening Excel 00:07:00 Navigating the Excel User Interface 00:10:00 Using the Excel Ribbon 00:07:00 Understanding Excel Worksheet Components 00:07:00 Using the Backstage View 00:09:00 Section 02 Creating a New Workbook 00:06:00 Creating Workbooks Using Templates 00:03:00 Saving an Excel Workbook 00:05:00 Using the Accessibility Checker 00:04:00 Section 03 Navigating a Worksheet by Mouse or Keyboard 00:05:00 Understanding Excel Data Types 00:06:00 Using the Inking Tools 00:06:00 Working with Cell and Range Addressing 00:03:00 Using various Data Selection Techniques 00:03:00 Working with Common Excel Commands 00:05:00 Using the Autofill Handle 00:04:00 Using Flash Fill 00:02:00 Section 04 What are Formulas and Functions 00:04:00 Understanding the Components of a Formula 00:06:00 Understanding Calculation Hierarchy and the Order of Operations 00:03:00 Creating Basic Formulas 00:03:00 Working with Basic Functions and AutoSum 00:06:00 Using Cell References 00:05:00 Using the Quick Analysis Tools 00:03:00 Section 05 Modifying Columns and Rows 00:06:00 Hiding and Unhiding Columns and Rows 00:04:00 Section 06 Formatting and Aligning Data 00:11:00 Merging Data 00:08:00 Wrapping Text and Adjusting Orientation 00:07:00 Formatting Numbers 00:08:00 Using Borders and Shading 00:07:00 Using the Format Painter 00:04:00 Removing Formatting Quickly 00:05:00 Section 07 Using Cell Styles 00:06:00 Applying Themes 00:04:00 Section 08 Inserting and Formatting Images 00:06:00 Inserting and Formatting Shapes 00:06:00 Inserting and Formatting SmartArt 00:09:00 Working with Icons 00:06:00 Working with 3-D Models 00:05:00 Inserting Screenshots 00:05:00 Inserting Hyperlinks 00:05:00 Inserting Symbols and Equations 00:05:00 Inserting WordArt and Text Boxes 00:08:00 Inserting Other Excel Objects 00:06:00 Arranging Objects 00:05:00 Section 09 Using Find and Replace 00:03:00 Using Go To and Go To Special 00:03:00 Using the Spell Checker 00:05:00 Using the Thesaurus and Translation Features 00:05:00 Section 10 Printing and Previewing Excel Files 00:05:00 Creating Custom Margins and Scaling 00:05:00 Adding Headers and Footers 00:05:00 Exporting to PDF and XPS 00:04:00 Section 11 Renaming and Coloring Worksheet Tabs 00:04:00 Adding, Deleting, and Navigating Worksheets 00:05:00 Section 12 Viewing Workbooks 00:05:00 Using Zoom Tools 00:02:00 Configuring Sheet Options 00:04:00 Using the Freeze Panes and Split Commands 00:06:00 Working with Window Commands 00:03:00 Adjusting Workbook Properties 00:06:00 Recap Recap 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

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

Learn the art of floristry and flower arrangement with our comprehensive training course. Gain practical skills in creating stunning floral designs for weddings, events, and more. Perfect for aspiring florists and entrepreneurs alike.