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

1785 Dele courses delivered Online

Excel 2019 Introduction

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 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

Excel 2019 Introduction
Delivered Online On Demand5 hours 34 minutes
£11.99

Cake Decorating Training

4.7(47)

By Academy for Health and Fitness

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! Transform your passion for baking into a profession with our comprehensive Cake Decorating Training course. Whether you're a novice or have some experience, this comprehensive course on Cake Decoration will walk you through the newest methods and patterns in cake decorating. Join us today to explore your creativity and master the art of cake decorating. Master the art of cake decorating with a variety of methods, including fondant, buttercream, and gum paste, by learning from experienced professionals in the industry. You'll discover everything you need to know to make stunning and delectable cakes, from buttercream flowers to fondant figures. The modules cover the fundamentals of baking and cake decorating, including varieties of cakes and types of decorating materials, coating cakes with frosting, icing, and pastes, utilising glazes and stacking layers for the greatest effect, as well as piping, writing, and starting your own business. Additionally, thanks to our flexible online structure, you may learn at your own pace and on your own schedule. After this cake decorating training course, you will be able to learn: Learn the best-kept secrets for preparing desserts, and they'll stay in your digital file cabinet for you to use whenever you want Identify the equipment and ingredients required to bake, put together, and frost a cake Know how to glaze and frost a cake, as well as how to make chocolate decorations Learn how to make cake layers and put together a layer cake Become an expert in finishing touches for cake decoration Enrol right away to make your passion for cake decorating/ cake designing into a rewarding career! Why Prefer this Cake Decorating Training? Opportunity to earn a certificate accredited by CPD after completing this course Get a free student ID card! (£10 postal charge will be applicable for international delivery). Innovative and engaging content. Free assessments. 24/7 tutor support. Start your learning journey straight away with this Cake Decorating Training and take a step toward a brighter future! *** Course Curriculum *** Here is the curriculumn breakdown of this Cake Decorating Training: Module 1: Introduction to Cake Decorating Module 2: Baking the Cake Module 3: Cake Decorating Recipes Module 4: Types of Cakes Module 5: Frosting and Icing Module 6: Working with Different Paste Module 7: Working with Glazes Module 8: How to Stack a Cake Module 9: Piping and Writing Module 10: Health, Safety and Food Hygiene Module 11: Cake Decorating Business Assessment Process Once you have completed all the modules in the course, your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the Cake Decorating Training. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The purpose of this Cake Decorating Training is to introduce students to the process of making cakes and to improve their baking abilities. Everyone is welcome to take this course. Especially, For everyone who enjoys creating with joy in their kitchens and has a sweet tooth! Beginner to advanced cake decorators and bakers and Anyone who wants to learn more about the subject. Requirements You will not need any prior background or expertise to enrol in this course. Career path You can learn how to make a variety of cakes and professionally decorate them by finishing the course in the Cake Decorating Online Course. It might also offer the first steps toward launching a bakery company or employment in the baking department of a skilled catering crew. In the UK, cake bakers often make between £12,000 and £25,000 a year. 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.

Cake Decorating Training
Delivered Online On Demand5 hours
£12

SQL Programming Course

4.7(47)

By Academy for Health and Fitness

Everywhere, from tiny businesses to major corporations, needs people skilled in SQL. In light of this, our online training course has been developed to help you succeed by equipping you with all the necessary skills. The importance of mastering SQL increases if you're looking for your first job in the data industry. You will learn about topics such as SQL fundamentals, data wrangling, SQL analysis, AB testing, distributed computing with Apache Spark, Delta Lake, and more through four increasingly more challenging SQL projects with data science applications. These subjects will equip you with the skills necessary to use SQL creatively for data analysis and exploration, write queries quickly, produce datasets for data analysis, conduct feature engineering, integrate SQL with other data analysis and machine learning toolsets, and work with unstructured data. This Specialisation is designed for a learner with little or no prior coding expertise who wants to become proficient with SQL queries. Experts have meticulously planned out the curriculum for the SQL Skills Training course with years of expertise. As a result, you will find it simple to learn the course material. Learning outcome After finishing the course, you'll Learn to utilise the tools for view creation Become familiar with updating columns and indexed views Be able to test and debug Be able to search a database using SQL Become more familiar with inline table-valued functions Learn the fundamentals of transactions and multiple statements Why Prefer US? 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 *** Course Curriculum *** SQL Programming Course Module 01: Course Introduction Introduction Course Curriculum Overview Overview of Databases Module 02: SQL Environment Setup MySQL Installation MySQL Workbench Installation Connecting to MySQL using Console Module 03: SQL Statement Basics Overview of Challenges SQL Statement Basic SELECT Statement SELECT DISTINCT Column AS Statement COUNT built-in Method usage SELECT WHERE Clause - Part One SELECT WHERE Clause - Part Two Statement Basic Limit Clause Statement Using BETWEEN with Same Column Data How to Apply IN Operator Wildcard Characters with LIKE and ILIKE Module 04: GROUP BY Statements Overview of GROUP BY Aggregation function SUM() Aggregation MIN() and MAX() GROUP BY - One GROUP BY - Two HAVING Clause Module 05: JOINS Overview of JOINS Introduction to JOINS AS Statement table INNER Joins FULL Outer Join LEFT Outer JOIN RIGHT JOIN Union Module 06: Advanced SQL Commands / Statements Timestamps EXTRACT from timestamp Mathematical Functions String Functions SUBQUERY Module 07: Creating Database and Tables Basic of Database and Tables Data Types Primary key and Foreign key Create Table in SQL Script Insert Update Delete Alter Table Drop-Table NOT NULL Constraint UNIQUE Constraint Module 08: Databases and Tables Creating a Database backup 10a Overview of Databases and Tables 10c Restoring a Database CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course can be helpful for anyone working in the SQL fields, whether self-employed or employed, regardless of their career level. Requirements You will not need any prior background or expertise to enrol in this course. Career path The vocation of SQL Skills Training moves very quickly but pays well. This position provides unparalleled satisfaction. This is your opportunity to learn more and start changing things. Query Language Developer Server Database Manager Python Developer Technical Consultant Project Implementation Manager Software Developer (SQL) Certificates Certificate of completion Digital certificate - £10

SQL Programming Course
Delivered Online On Demand8 hours
£12

HR & Leadership Management - CPD Certified

4.7(47)

By Academy for Health and Fitness

Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Management and Leadership Development Programme course might help you get there! Expand your expertise with high-quality training - study the Management and Leadership Development Programme course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through theonline training course. The HR & Leadership Management Diploma Offers the Following Courses with Free Certificate: Course 01: Strategic Business Management Course 02: Financial Management Course 03: Diploma in Performance Analysis The Management and Leadership Development Programme course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Management and Leadership Development Programme course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Management and Leadership Development Programme training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Management and Leadership Development Programme course: Introduction to Manager: Management Course Objectives Module 01: Grooming a New Manager Set Specific Goals Authority (What They Can and Can't Do) Create a Shared Vision The More They Learn, the More Responsibility They Get Module 02: Coaching and Mentoring (I) Writing Performance Reviews Provide Clear and Timely Feedback Praise in Public, Criticize in Private Make Sure Your Door is Always Open Module 03: Coaching and Mentoring (II) Offer Advice, Not the Solution Create a Supportive Environment Build Ownership 360 Degree Feedback Module 04: Measuring Performance Staying Within Their Budget Setting Measurable Objectives Skip Level Feedback Collaborate on Criteria to be Evaluated Module 05: Motivating Managers Provide the Needed Resources Bonuses and Incentives Give Credit for Good Work Keep Them Challenged Module 06: Signs of Poor Management Missed Deadlines Team Turnover Losing Customers Little or No Growth Module 07: Trust Your Team of Managers Do Not Micromanage Promote Open and Honest Communication Reward Initiative Trust, But Verify Module 08: When an Employee Complains About Their Manager Keep the Information Confidential Gather Information from Both Sides Coach or Delegate the Solution Follow-up with the Manager or Employee Module 09: When Do You Step In? Unsafe or Dangerous Events Legal Ramifications Severe Financial Costs Repeated Failures after Coaching Has Occurred Module 10: Remember These Basic Qualities Express Confidence in Their Abilities Practice What You Preach Have an Open Door Their Success is Your Success Assessment Process Once you have completed all the modules in the Management and Leadership Development Programme course, you can assess your skills and knowledge with an optional assignment. Certificate of Completion The learners have to complete the assessment of this Management and Leadership Development Programme course to achieve the CPDQS accredited certificate. Hard Copy Certificate: £29 (Inside UK) Hard Copy Certificate: £39 (for international students) CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Management and Leadership Development Programme course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career.

HR & Leadership Management - CPD Certified
Delivered Online On Demand1 hour
£12

Microsoft Office Essentials - 3 Course Bundle

4.7(47)

By Academy for Health and Fitness

The Microsoft Office Essentials - 3 Course Bundle has been expertly designed for you to complete through distance e-learning. Successful completion of the Microsoft Office bundle will see you achieve a CPD certified proficiency which will add significant weight to your CV and impress potential employers when applying for new jobs. Enrol now on the Microsoft Office Essentials - 3 Course Bundle and get access to top-quality training modules. Start studying Microsoft Office using any internet-enabled device including computers, tablets, and smartphones. With 24/7 student support, you can be sure of quick and comprehensive assistance whenever you need it. Why Choose Microsoft Office Essentials - 3 Course Bundle? Opportunity to boost your CV/Resume with CPD accredited proficiency Student ID card with amazing discounts - completely for FREE! (Postal charges will be applicable for international delivery) Certificates available in both PDF and hard copy format Interactive, high-quality course content with 24/7 online access Full tutor support and learning assistance included Course Curriculum Breakdown: Here are the topics you will cover on the Microsoft Office Essentials - 3 Course Bundle Course: Microsoft Excel 2022 New Features Introduction to Microsoft Excel 2019 New Features CONCAT IFS MAXIFS MINIFS SWITCH TEXTJOIN Map Chart Funnel Chart Better Visuals Pivot Table Enhancements Power Pivot Updates Getting Started with Microsoft Office Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Formatting a Worksheet Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Printing Workbooks Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Managing Workbooks Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Working with Functions Work with Ranges Use Specialized Functions Work with Logical Functions Work with Date & Time Functions Work with Text Functions Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Sharing and Protecting Workbooks Collaborate on a Workbook Protect Worksheets and Workbooks Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Creating Sparklines and Mapping Data Create Sparklines MapData Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends Excel Templates Excel Templates CPD 11 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Office Essentials - 3 Course Bundle has been professionally-designed for motivated learners who are looking to add a new skill to their CV and stand head and shoulders above the competition. Learn the latest industry-specific information with the Microsoft Office Essentials - 3 Course Bundle. Requirements Enrol on the Microsoft Office Essentials - 3 Course Bundle with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the Microsoft Office Essentials - 3 Course Bundle without any delay. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited Certificate Hard copy certificate - £29

Microsoft Office Essentials - 3 Course Bundle
Delivered Online On Demand11 hours
£12

Team Building Training

4.7(47)

By Academy for Health and Fitness

Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! Every manager knows that one of the most important aspects of the role is to ensure that your team is working together in a way that facilitates maximum productivity. When a group feels motivated and has shared values and goals to work towards, great work can be accomplished. If you are a manager, supervisor or group leader, who wishes to gain a better understanding of the steps to effective team building, then this course is for you. Through this Team Building course, you will learn about the importance and benefits of teamwork, teaching you everything you need to know to foster a positive and productive working environment. This Team Building course also covers the steps to overcoming obstacles in teamwork such as conflict management, equipping you with the tools to motivate employees, provide constructive feedback and implement shared organisational goals. Key Topics to Be Covered by Team Building Course: The benefits of teamwork and the importance of fostering teamwork Teambuilding strategies and techniques for managers and leaders How to use games and activities in teambuilding Managing conflict and conflict resolution strategies How to foster a positive and productive working environment Tips for motivating employees and providing feedback Teambuilding skills every manager should have Mastering goal setting and introducing shared values The Team Building course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Team Building course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this Team Building course. This Team Building training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join the Team Building course today and gear up for excellence! Start your learning journey straight away with this diploma and take a step toward a brighter future! Skills You Will Gain by This Diploma Team-building Business communication Goal-setting Motivation Leadership and management Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. *** Course Curriculum *** Here is the curriculum breakdown of the Team Building course: Module 01: What Are the Benefits? Better Communication and Conflict Resolution Effectiveness Motivation Camaraderie Module 02: Types Activities Games Activities Education Social Gatherings Module 03: Games Games for Introductions Games to Build Camaraderie Games for Problem-Solving Games to Stimulate Interaction Module 04: More Team Building Games Games to Build Trust Games to Motivate Games to Build Communication Games for Conflict Resolution Module 05: Activities Activities to Build Camaraderie Activities for Idea Sharing Activities to Build Trust Activities to Stimulate Interaction Module 06: More Team Building Activities Activities to Motivate Activities to Improve Working Together Activities to Build Communication Activities for Conflict Resolution Module 07: Social Gatherings Singing/Karaoke Dinner/Potlucks Physical Activities Meetings Module 08: Common Mistake Allowing Cliques to Develop Not Delegating Tasks Rewarding in Private/Criticizing in Public Disjointed Plans of Grandeur Module 09: Formatting a Plan Define the Goal Consult Team Members Research and Create Structure Keep It Fun Module 10: Evaluate Was the Goal Met? Was the Team Building Cohesive? What Did the Team Think of the Team Building? How Can the Team Building Be Improved for Next Time? Assessment Process Once you have completed the modules in the Team Building Diploma , your skills and knowledge will be tested with an automated multiple-choice assessment, after which you will receive instant results. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody. Career path This course is a must for managers and leaders looking to develop the essential skills to lead groups more effectively. It particularly applies to those in the following professions:

Team Building Training
Delivered Online On Demand1 hour
£12

Diploma in Office Admin and Reception

4.7(47)

By Academy for Health and Fitness

The UK's demand for office administration and receptionist roles has generally been increasing over the past few years. And with this Diploma in Office Admin and Reception, you can jumpstart your career and find yourself in a well-paying position with opportunities for advancement. Office Admin and Reception skills give you the flexibility to work in a variety of positions. For example, you may specialise as a Medical or Legal Secretary, go into HR or finance, or even become a personal assistant. This Diploma in Office Admin and Reception is an excellent place to start whether you have some expertise or are a newbie because these are all fantastic, lucrative possibilities. The Diploma in Office Admin and Reception is broken up into handy, simple-to-understand segments so you may learn as you go. Everything is covered, including how to properly organise business documents and communicate at work. Learning Outcome Gain sufficient knowledge of the role and responsibilities of office administrators and receptionists Be trained in the role of an office administrator and receptionist to fast-track your career Familiarise with administrative and reception duties to ensure the smooth running of an office Learn how to motivate your team and provide them with the right tools to achieve common work goals Develop your knowledge of telephone etiquette and understand how to respond to difficult customers Why Choose a Diploma In Office Admin And Reception - Level 3? Opportunity to earn a certificate which is accredited by CPDQS. Get a free student ID card! (£10 postal charge will be applicable for international delivery). Innovative and engaging content. Free assessments. 24/7 tutor support. ****Course Curriculum**** Here are the topics you will cover on the Diploma In Office Admin And Reception - Level 3 Course: Module 01: Personal Assistant Module 02: Admin Support Module 03: Administrative Management Module 04: Organisational Skills Module 05: Telephone Etiquette Module 06: Business Writing Module 07: Time Management Module 08: Body Language and Effective Communication Module 09: Meeting Management Module 10: Excel Basics Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Module 11: PowerPoint Basic Customize the User Interface Set PowerPoint 2016 Options Modify Slide Masters and Slide Layouts Add Headers and Footers Modify the Notes Master and the Handout Master Create SmartArt Modify SmartArt Write Math Equations Add Audio to a Presentation Add Video to a Presentation Customize Animations and Transitions Review a Presentation Store and Share Presentations on the Web Annotate a Presentation Set Up a Slide Show Create a Custom Slide Show Add Hyperlinks and Action Buttons Record a Presentation Secure a Presentation Broadcast a Slide Show Create a Video or a CD Assessment Process Once you have finished the learning stages in the Diploma in Office Admin and Reception , your abilities will be assessed by an automated multiple-choice question session, after which you will receive the results immediately. CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Office Admin and Reception course does not require you to have any prior qualifications or experience. Anybody who wants to start a career as an office admin. Anybody who wants to learn basic receptionist skills. Requirements You will not need any prior background or expertise to enrol in this course. Career path Receptionist Telephonist School Secretary Office Admin Health Record Clerk Receptionists in the UK earn around 15K - 22K per annum. Certificates CPDQS Accredited Certificate Digital certificate - £10 CPDQS 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.

Diploma in Office Admin and Reception
Delivered Online On Demand19 hours
£12

SQL Server : Basic Microsoft SQL Server

4.7(47)

By Academy for Health and Fitness

**Trust The 35000+ Students Who Are Learning with Us & Kick Starting Their Career!** Deal Price is Active; Save Now- £405! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Basic Microsoft SQL Server Course might help you get there! Expand your expertise with high-quality training - study the Basic Microsoft SQL Server and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the online training course. This Basic Microsoft SQL Server online training course is accredited by CPD with 10 CPD points for professional development. Students can expect to complete this training course in around 4 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course. The Basic Microsoft SQL Server course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enroling on this Basic Microsoft SQL Server course. With this comprehensive Basic Microsoft SQL Server course, you can achieve your dreams and train for your ideal career. The course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enroling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enroling on the course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with this program. Learning Outcomes of Basic Microsoft SQL Server: Instant access to verified and reliable information Participation in inventive and interactive training exercises Quick assessment and guidance for all subjects CPD accreditation for proof of acquired skills and knowledge Freedom to study in any location and at a pace that suits you Expert support from dedicated tutors committed to online learning Why Prefer thisBasic Microsoft SQL Server 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 Basic Microsoft SQL Server 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 Basic Microsoft SQL Server course and take a step toward a brighter future! ****Course Curriculum**** ***Basic Microsoft SQL Server*** Introduction Introduction Setup SQL server setup SQL server management studio setup Databases and tables Basic queries INSERT SELECT UPDATE DELETE Filter and sort Variables Logic Security Authentication Connection strings Vulnerability assessment MSSQL an different drivers Stored procedure Example: attendee registry c# Python Files File table Stored procedures General Functions Import data Export data Jobs Backup Database email Job notifications Assessment Process Once you have completed all the modules in the Basic Microsoft SQL Server course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. Show off Your New Skills with a Certification of Completion The learners have to complete the assessment of this Basic Microsoft SQL Server course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. The learner can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career.

SQL Server : Basic Microsoft SQL Server
Delivered Online On Demand4 hours
£12

Level 3 Coaching & Mentoring

4.7(47)

By Academy for Health and Fitness

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! Our coaching & mentoring course is perfect for professionals looking to develop their skills and take their careers to the next level. This comprehensive coaching & mentoring course covers everything you need to know to be an effective coach or mentor, including building trust, active listening, goal setting, and giving feedback. You'll learn how to work with individuals or groups and how to use a variety of coaching & mentoring techniques to help others achieve their goals. So whether you're a manager looking to support your team, or a consultant looking to add coaching & mentoring to your services, this course has something for you. Our coaching & mentoring course is designed to be flexible, so you can study at your own pace and fit your learning into your busy schedule. In addition, you'll have access to a wide range of interactive learning materials, including videos, quizzes, and other exercises, so you can put your new skills into practice right away. So don't wait - enrol in our coaching & mentoring course today and start building the foundation for a rewarding career in this exciting field. Learning Outcomes This Level 3 Coaching & Mentoring course will cover topics such as: Gain an understanding of the principles, duties and responsibilities of a coach. Learn techniques for overcoming barriers Describe ethical aspects of coaching & mentoring Learn about various coaching models Gain knowledge about effective communication skills Understand various personal skills Learn about various management skills Gain an understanding of functional skills Key Features Opportunity to boost your CV/ Resume with CPD accredited proficiency Student ID card with amazing discounts - completely for FREE! (Postal charges will be applicable for international delivery) Access this course through our dedicated online learning platform This course is stuffed with interactive course content Instant results upon completion of each assessment Affordable prices and high-quality training Certificates available in both PDF and hard copy format with course This Coaching and Mentoring Diploma program is accredited by the UK's top awarding bodies Complete the course 100% online, from anywhere via an internet Flexible course deadlines with full access to the course for one year Full tutor support and learning assistance included in course This Level 3 Coaching & Mentoring course consists of the following modules: ****Course Curriculum of Coaching & Mentoring Diploma**** Module 1: Introduction What is Coaching? The Five Principles of Coaching Definition of a Coach The Duties of a Coach Characteristics of A Successful Coach Coaching Traps and Problems Definition of Mentor and Mentee Roles & Responsibilities of A Mentor Module 2: Objectives & Processes Objectives Processes Techniques for Overcoming Barriers Module 3: Ethical Aspects of Coaching & Mentoring Association for Coaching's Guiding Principles 'AC' and 'EMCC's Code of Ethics International Coach Federation(ICF) Standards of Ethical Conduct Module 4: Models Coaching Models: An Introduction The GROW Model The OUTCOMES Model The JOHARI Window The FLOW Model The SOS Model Module 5: Effective Communication Skills Creating a Good Coaching & Mentoring Relationship Using Appropriate Language Listening at A Deep Level Asking Effective Questions Limiting Beliefs/Assumptions Giving Effective Feedback Communicating Non-Verbally Presence and Silence Module 6: Personal Skills Time Management Stress Management Emotional Management and Happiness Maintenance Assertiveness Negotiation Module 7: Management Skills Motivating Leading Delegation Decision Making and Problem Solving Project Management Module 8: Functional Skills Sales Skills Sales Management Marketing Management Financial Management Production Management Assessment Process Once you have finished the learning stages, your abilities will be assessed by an automated multiple-choice question session, after which you will receive the results immediately. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Level 3 Coaching & Mentoring course is for: Anybody wishing to become Supervisors Anybody who wants to be Human Resource Managers Anybody who wants to be in managerial positions Anybody who wants to be in life coaching Anybody who wants to be in sales Requirements Enrol on the Coaching & Mentoring course with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register for this course without any delay. We only ask that all students have a passion for learning and literacy and be over the age of 16. Complete this online from your computer, tablet, or smartphone, and learn in a way that suits you. Browse this 100% online course from any internet device and study at your own pace. Earn an industry Skillset with this course. Career path After completing the Level 3 Coaching & Mentoring course, you will be eligible for: Life coach Learning mentor (Salary: £14,500 to £25,000) Business adviser (Salary: £25,000 to £54,000) Careers adviser (Salary: £21,000 to £35,000) Sales manager (Salary: £22,000 to £70,000) Training manager (Salary: £25,000 to £45,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.

Level 3 Coaching & Mentoring
Delivered Online On Demand5 hours
£12

Xero Accounting - CPD Certified

4.7(47)

By Academy for Health and Fitness

Understanding the Xero accounting and bookkeeping software is essential for developing into a competitive profession and landing more jobs. Xero is one of the top programs that provide a dependable accounting package for all requirements as accounting is quickly moving into the digital realm, including tax submissions directly to your tax office. To give you the most comfortable and rich learning experience possible, this Xero Accounting course is divided into a number of in-depth segments. This master class in Xero accounting covers all necessary functions, including opening balances, posting customer invoices and credit notes to the sales and purchase ledger, entering supplier checks and recording customer receipts, submitting VAT returns, setting up and managing projects, and understanding debits and credits, so that anyone with any skill level could use the program with assurance. When you work as a Xero accountant or bookkeeper, there are constantly new skills to pick up and new knowledge to assemble. This course on the fundamentals of Xero accounting will adequately equip you to embrace all of the necessary skills and knowledge in this sector. Enrol today to begin your journey towards enhancing your possibilities by learning new skills and gaining knowledge. Learning Outcome Upon successful completion of the course, you will, Learn Xero at every level, from beginner to expert Understand to import or create contacts, input financial data, and switch from another program Be able to begin working with bills, bank accounts, fixed assets, invoices and other items straightway Resolve a bank account and learn how to set up petty cash Know how to prepare and check your VAT returns before submitting them manually or electronically Experts created the 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 Xero Accounting Complete Training materials. Then, from any internet-enabled device, access the training 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! Why Prefer this 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 this course in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** Module 01: Getting Started Setting up / Creating Company Module 02: Setting up of the System Virtual Tour of Xero Accounts Add Business Bank Accounts and Cash Account Chart of Accounts and conversion balances Creating/Deleting (Tracking categories) Module 03: Customers and Suppliers Setting up Customers and Suppliers (Apply default settings) Create a Project Entering Purchase (Supplier Invoice), Purchase Credit Note, Purchase Order Entering Sales (Customer Invoice), Sales Credit Note, Sales Order Module 04: Fixed Assets Entering Fixed Assets (Asset Register) Inventory Module 05: Bank Payments and Receipts Bank Feed or Import a Statement Entering Bank Payments, Bank Receipts Internal Bank Transfer/Petty Cash Transfer/CC Payment Adding Repeating bill (DD/STO etc.) Cash Coding Module 06: Petty Cash Petty Cash Module 07: Bank Reconciliation Bank Reconciliation Module 08: Business Credit Card Account Business Credit Card Account Module 09: Aged Reports Aged Reports Module 10: Payroll and Journals Payroll and Journals Module 11: Vat Return Vat Return Module 12: Correction of Error Correction of Errors Assessment Process Once you have completed all the modules in the course, your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the course. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course should be taken by anyone who wants to understand more about Xero. You will gain a solid comprehension of the subject and improve your ability to understand the fundamental ideas. You can enrol in the course without any prerequisites, and you can access the course materials from anywhere in the world. This Xero accounting software training program has been created to develop your Xero accounting skills and the overall understanding of the software. It has no association with Xero Limited and operates independently. Please note, that the certificate you receive upon completion is CPD accredited and not an official Xero certification. Requirements The training program does not require any prior knowledge; everyone may participate! This Xero Accounting Complete Training 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 course allows you to study at your speed and grow a quality skillset. Career path This Course is a valuable skill to have and is advantageous for professionals or careers in any field, including: Accounting Managers Accountants Bankers Finance Officer Payroll Officer In the UK, these professionals typically earn between £20,000 and £50,000 per year. 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.

Xero Accounting - CPD Certified
Delivered Online On Demand4 hours
£12