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

5607 Courses delivered On Demand

Affiliate Marketing Online Certificate Course

4.3(43)

By John Academy

Description: Affiliate marketing is one of the solid ways of earning money. If you are interested in learning a solid strategy for building an affiliate marketing enterprise, then enrol the Affiliate Marketing Online Certificate Course and explore the secret techniques of earning money. The course starts by explaining the concept of affiliate marketing that is followed by the methods of boosting your website. The course can be divided into two parts: starting an affiliate website and marketing the website through proper channels. At first, you will learn the procedures of setting a WordPress website, choosing niches and products for reviews, writing honest reviews, etc. The next part deals with the marketing strategies including email marketing, and creating 'pre-sales video'. In short, the course prepares you to start your affiliate business. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Affiliate Marketing Online Certificate Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Affiliate Marketing Online Certificate Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction To The Course Introduction 00:11:00 Your Home Base Home Base 00:05:00 Start Now 00:06:00 Know Numbers 00:05:00 Audience Relationships 00:06:00 Authority by Association 00:05:00 Value, Value, Value 00:05:00 Networking 00:05:00 Build your list 00:07:00 Create Products 00:06:00 Where the heck is the money 00:05:00 The Secret to Scaling 00:04:00 How the heck do I get started? 00:06:00 Step Two Find a high converting product on Munch Eye 00:02:00 Contact the product creator and get the Sales Page and product access 00:04:00 Go through the product and make a quick presell video prior to launch 00:05:00 Make a 5-10 minute review video showing the sales page and product 00:03:00 Show the review to the product creator and ask if you can add a bonus 00:05:00 Send the presell video to your list the night before 00:01:00 Send your review video to your list when the product launches 00:04:00 Repeat 00:04:00 Taking it to the next level 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Affiliate Marketing Online Certificate Course
Delivered Online On Demand1 hour 48 minutes
£22

Microsoft Office 2016 Excel Intermediate - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2016 Excel Intermediate - Complete Video Course will teach you to create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at high level. If you have equivalent knowledge of Microsoft Excel 2016 Introduction then this course is perfect for you to expand your knowledge and skills. So, if you want to advance your skill set by learning to work with advanced formulas, lists, and illustrations you can join this course. You will also work with charts and advanced formatting including styles. So, why are you thinking? Come and be a part of this course now. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Excel Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Excel Intermediate - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Working with Functions Work with Ranges FREE 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2016 Excel Intermediate - Complete Video Course
Delivered Online On Demand4 hours 16 minutes
£22

Productivity Habits Development Certificate

4.3(43)

By John Academy

Description Learn the practical strategies to increase your productivity and embrace the habits of successful people with the Productivity Habits Development Certificate course. Psychology can help you to increase your productivity and get more work done. In the course, at first, you will gain an understanding of the concepts of productivity and habits of successful people. Then, the course discusses Parkinson's Law to increase productivity so that you can apply the Law in your real world. The concepts of busy people vs. productive people, taking responsibilities to make a better decision and project planning will be discussed in the course. Apart from these, the course explains the habits that you should avoid and teaches you how to overcome challenges. Shortly, you will be more productive and creative if you follow the instructions properly. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Productivity Habits Development Certificate is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Productivity Habits Development Certificate is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Section 01 - Leverage Long Term Success Habits of Highly Productive People FREE 00:03:00 Create an Asset 00:03:00 Embrace Constraints 00:04:00 The 80-20 Principle 00:03:00 Analyze Responsibilities 00:03:00 Make Better Decisions 00:01:00 Leverage Current Situations 00:02:00 Section 02 - Mastering Workflow Productive Action Planning 00:03:00 Good Project Planning 00:04:00 Mastering Workflow 00:02:00 Managing Commitments 00:02:00 Reviewing Tasks 00:02:00 Parkinson's Law 00:02:00 Batch Small Tasks 00:01:00 Email Productivity 00:04:00 Section 03 - Everyday Productivity Habits for Success Productive Routines for Morning and Night People 00:03:00 Routines to Decrease Working Hours 00:03:00 Busy People vs. Productive People 00:05:00 Things That Aren't Actually Productive 00:07:00 Habits to Avoid 00:03:00 More Habits to Avoid 00:04:00 Overcoming Concepts to Become Successful 00:03:00 Section 04 - Lessons to Learn to Maximize Probability Become More Productive 00:03:00 Power of Less 00:05:00 Interruption is the Killer of Productivity 00:03:00 Inspiration is Perishable 00:01:00 Money Mistakes Successful People Avoid 00:04:00 Avoid Zero Sum Games 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Productivity Habits Development Certificate
Delivered Online On Demand1 hour 25 minutes
£22

Microsoft Office 2010 Word Intermediate - Complete Video Course

4.3(43)

By John Academy

Description: If you already have the basic skills and knowledge of Microsoft Word 2010 and you are able to create, edit, and print word documents on Windows then this [course_tite] is designed for you. This series builds on the skills and concepts taught in Word 2010 Basic. You will learn advanced formatting, use Word's drawing tools, create and manage tables, and work with column layouts. Here, you will work with styles, sections, and columns and will use the Navigation pane to work with outlines. By this course, you will learn to use Word's advanced editing tools, work with images, including placing and sizing images, wrapping text around images, and using borders and effects, how to adjust page orientation an layout, how to work with columns and with page and section breaks, and more. This intermediate level will pull up your basic knowledge and skills so don't delay to try this. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2010 Word Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2010 Word Intermediate - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Styles and Outlines Examining Formatting FREE 00:07:00 Creating Styles 00:17:00 Modifying Styles 00:11:00 Working with Outlines 00:13:00 Sections and Columns Creating and Formatting Sections 00:13:00 Working with Columns 00:08:00 Formatting Tables Table Formatting Basics 00:09:00 Borders and Shading 00:06:00 Table Data 00:10:00 Table Styles 00:09:00 Printing Labels and Envelopes Labels 00:06:00 Envelopes 00:05:00 Templates and Building Blocks Template Basics 00:11:00 Building Blocks 00:02:00 Document Properties 00:14:00 Graphics Creating Diagrams 00:02:00 Using the Drawing Tools 00:13:00 Formatting Text Graphically 00:06:00 Managing Document Revisions Tracking Changes 00:21:00 Working with Comments 00:02:00 Web Features Web Pages 00:03:00 Hyperlinks 00:10:00 Mock Exam Mock Exam- Microsoft Office 2010 Word Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Word Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2010 Word Intermediate - Complete Video Course
Delivered Online On Demand3 hours 58 minutes
£22

Microsoft Project 2010 Beginners - Complete Video Course

4.3(43)

By John Academy

Description: Microsoft Project 2010 is the latest version of Project, a companion project management application for Microsoft Office. This Microsoft Project 2010 Beginners - Complete Video Course teaches the basic commands and features of Microsoft Project 2010. Here, you will learn how to create and modify task lists, establish a project schedule, create calendars, assign resources to tasks, track costs, and work with different views and tables. You will also learn how to apply filters and groups, and sort task and resource data. This version includes a wide range of changes, including the new ribbon interface. Microsoft Project integrates with all the other Office application you regularly use. You will finish up the course with learning how to resolve resource conflicts. If you want to know more detail about Microsoft Project you have to be a part of this course. You will get all the basic knowledge from here, which will help you to pull up ahead. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Project 2010 Beginners - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Project 2010 Beginners - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started Project Management Concepts FREE 00:12:00 The Project Window 00:15:00 Project Files 00:10:00 The Help Window 00:02:00 Tasks Creating a Task List 00:10:00 Modifying a Task List 00:07:00 The Work Breakdown Structure 00:13:00 Tasks Scheduling Task Links 00:16:00 Task Relationships 00:09:00 Task Options 00:05:00 Resource Management The Base Calendar 00:07:00 Resources and Calendars 00:14:00 Project Costs 00:08:00 Views and Tables Working with Views 00:12:00 Working with Tables 00:04:00 Filters, Groups, and Sorting Filters 00:10:00 Groups 00:05:00 Sorting Tasks and Resources 00:05:00 Finalizing the Task Plan Finalizing Schedules 00:09:00 Handling Resource Conflicts 00:11:00 Mock Exam Mock Exam- Microsoft Project 2010 Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Project 2010 Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Project 2010 Beginners - Complete Video Course
Delivered Online On Demand3 hours 44 minutes
£22

DIY: Professional Repair Expert

4.3(43)

By John Academy

Description: Do it yourself is a popular trend these days, which not only helps you develop skills but also save tons of money. If these things intrigue you, then you should definitely consider getting this DIY: Professional Repair Expert course for your house. This course teaches you the basics of repairing. You will be able to know the essential tools for a professional handyman. This course will be discussing the top skills for woodworking, and brush up on topics such as bandsaw and router. Then you will focus on plumbing and find out how a plumbing system actually works. Additionally, you will be taught all about basic electronics and how to repair old ceilings in this course. At the end of this course, you will also be taught how to protect yourself from injuries that are almost always inevitable. The course is a nice blend of different topics and helps you learn about the basics around the house. If you get this course now, along with the main course material you will also get access to additional reading material that could help your journey to become more of an expert. Who is the course for? Professionals who are helping people in their repairs and maintenance concern People who have the interest to learn how to do repair Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: DIY: Professional Repair Expert is a useful qualification to possess, and would be beneficial for the following careers: Handyman Educator Repairs and Maintenance Manager Guidance Counsellors Technicians. Chapter-01 Essential Tools For Your Toolbox 00:30:00 Chapter-02 Woodworking Ideas And Skills 00:30:00 Bandsaw 01:00:00 Router 01:00:00 Chapter-03 Basic Ideas Of Plumbing 00:30:00 Basic Plumbing 01:00:00 Chapter-04 Basic Ideas Of Electronics 01:00:00 Chapter-05 Repairing an old ceiling 01:00:00 Chapter-06 How To Protect Yourself From Injuries 01:00:00 Additional Supporting Material Maintenance Tools and their Uses 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam-DIY: Professional Repair Expert 00:20:00 Final Exam Final Exam-DIY: Professional Repair Expert 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

DIY: Professional Repair Expert
Delivered Online On Demand8 hours 10 minutes
£22

Advanced Diploma in Canvas Painting

4.3(43)

By John Academy

Are you a painter who are interested in canvas painting? Or are you someone who paints during your leisure time and wants to improve their skills? Learn how to create canvas painting in this Advanced Diploma Course in Canvas Painting. Description: Individuals have been conveying everything that needs to be conveyed through painting for the longest time. Indeed, even some of the prehistoric men demonstrated extraordinary cases or different occasions with paints that are produced using berries and plants. There just is by all accounts a natural need to show others our considerations, sentiments, and thoughts through pictures. The reason behind this is that with hues and outline you can express every feeling you feel. On the other hand, the majority of this being refined on a clear canvas with paint is very effective in conveying what needs to be conveyed. And this course is an advanced course designed to guide you through the basics of Canvas Painting and you could utilize your skills in creating a beautiful art while expressing yourself in your chosen subject. Who is the course for? Painters who have a potential in upgrading their painting skills and turn canvas painting into more beautiful painting. People who have an interest in the expressing art through canvas painting Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Advanced Diploma in Canvas Painting is a useful qualification to possess, and would be beneficial for the following careers: Book Illustrator Painters Portrait Artist And Other Paint-related Careers. Module 01 Painting 101 00:30:00 Understanding Paints 00:30:00 Choosing Your Brushes 00:30:00 Color Your World 00:30:00 Light Sources in Painting 00:30:00 What Type of Painter are you? 00:30:00 Module 02 Choosing A Subject 00:30:00 Setting Up Your Studio 00:30:00 Art Supply Resources 00:30:00 Clean Up Time 00:30:00 Free Art Lessons 01:00:00 Take Care of Your Creation 00:30:00 Module 03 Pay Attention to Detail 01:00:00 Enjoy Your Subject 00:30:00 Frequently Asked Questions 00:30:00 Art Schools 00:30:00 Museums of Fine Art 00:30:00 One Final Word 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Diploma in Canvas Painting
Delivered Online On Demand10 hours
£22

Real Estate Bundle Course

4.3(43)

By John Academy

Description: Real estate is the properties comprised of land and the buildings erected on it. If you want to have a career in real estate, then you have to also learn about property management. Property management is the operation of real estate. In this course, you will be provided with both lessons on real estate business and property management. Learning these two lessons will not only help you know about real estate, but it would also be helpful in building your professional career in the real estate industry. If you are passionate about real estate business and want to conquer this profession successfully, then you must start your real estate journey know. Who is the course for? Employees of the business industry and other businessmen who want to learn how to become successful in real estate People who have an interest in Real Estate and how to become successful on this Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Real Estate Bundle Course will be very beneficial and helpful, especially to the following careers: Businessman Marketing and Promotions Specialist Marketing Manager Product Creator Realtor Real Estate Agents Sales Manager Sales and Promotions Specialist. Real Estate Investor Training Property Development 00:19:00 Different Types of Property 00:15:00 Land Law Principles- Rights and Interests 00:18:00 Ownership, Co-ownership and Possession of the Property 00:30:00 Lease Bailment, License, Mortgage and Insurance Related Law 00:53:00 Real Estate Investment 00:20:00 Strategies for a Real Estate Investor 00:21:00 Property Development Property Research 00:16:00 Property and the Law 00:18:00 Different Methods of Finance Option 00:16:00 Building Regulation 00:14:00 The Planning Process 00:14:00 Project Management 00:16:00 Marketing Your Property 00:16:00 Property Management Introduction to Property Management 00:12:00 The Role and Responsibilities of a Property Manager 00:11:00 Listing Properties and Marketing 00:26:00 The Letting Process and Tenancy Agreement 00:26:00 The Property Management Process 00:32:00 Keeping Tenants Long Term 00:10:00 Regulations of Property Management 00:11:00 Changes in the UK Property Market: An Opportunity 00:13:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Real Estate Bundle Course
Delivered Online On Demand7 hours 7 minutes
£22

Microsoft Office 2013 Excel Intermediate - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2013 Excel Intermediate - Complete Video Course covers the intermediate functions and features of Excel 2013. You will learn about creating formulas, inserting graphics and enhancing workbooks. You will also learn how to organize worksheet data with tables and charts and how to analyze data using PivotTables, Slicers and PivotCharts. In this course creating advanced formulas, you will learn how to apply range names and how to use specialized functions. Once you are comfortable with the basics, you will be ready for this intermediate level. Here, you will explore more advanced formatting with terms, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas and applying conditional formatting to your worksheet, and more. If you want to take your Microsoft Excel 2013 skills to the next level, you'll learn how to use this program's advanced features to build a fully functional database from scratch. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 Excel Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 Excel Intermediate - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Creating Advanced Formulas Apply Range Names FREE 00:18:00 Use Specialized Functions 00:14:00 Analyzing Data with Logical and Lookup Functions Leverage Questions and Testing to Write Formulas 00:01:00 Use Logical and Lookup Functions to Find Answers to Questions 00:25:00 Organizing Worksheet Data with Tables Create and Modify Tables 00:09:00 Sort and Filter Data 00:27:00 Use Summary and Database Functions to Calculate Data 00:25:00 Visualizing Data with Charts Create Charts 00:05:00 Modify and Format Charts 00:25:00 Create a Trendline 00:10:00 Create Advanced Charts 00:09:00 Analyzing Data with PivotTables, Slicers, and PivotCharts Create a PivotTable 00:24:00 Filter Data by Using Slicers 00:09:00 Analyze Data by Using PivotCharts 00:07:00 Inserting Graphics Insert and Modify Graphic Objects 00:10:00 Layer and Group Graphic Objects 00:12:00 Incorporate SmartArt 00:06:00 Enhancing Workbooks Customizing Workbooks 00:08:00 Manage Themes 00:06:00 Create and Use Templates 00:06:00 Protect Files 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2013 Excel Intermediate - Complete Video Course
Delivered Online On Demand5 hours 4 minutes
£22

Microsoft Office 2007 PowerPoint Beginners - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2007 PowerPoint Beginners - Complete Video Course will provide you with an overview of the features and functions of Microsoft Office PowerPoint 2007. By taking this course you will learn to work with PowerPoint environment, open move around in, and close a presentation, display different views of a presentation, save a presentation, quickly create a presentation, create a presentation based on a ready-made design, convert an outline to a presentation, reuse existing slides, create a photo album, enter text, edit text, add and manipulate text boxes, correct and size text boxes, correct and size text while typing, check spelling and choose the best words, find and replace text while typing, change the size, alignment, spacing, apply a theme, rearrange slides in a presentation, switch to a different color scheme, and more.  So, if you are interested to learn all the basics of Microsoft Office PowrPoint 2007, then you should join this course now. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2007 PowerPoint Beginners - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2007 PowerPoint Beginners - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started The PowerPoint Window FREE 00:17:00 Getting Help 00:01:00 New Presentations Creating New Presentations 00:09:00 Saving Presentations 00:03:00 Rearranging and Deleting Slides 00:03:00 Using Slides from Other Presentations 00:02:00 Formatting Slides Text Formatting 00:18:00 Modifying Text 00:10:00 Paragraph Formatting 00:03:00 Drawing Objects Shapes 00:05:00 Modifying Objects 00:16:00 Text in Shapes 00:12:00 Graphics WordArt 00:07:00 Pictures 00:10:00 Clip Art 00:07:00 Tables and Charts Tables 00:10:00 Charts 00:06:00 Diagrams 00:06:00 Modifying Presentations Templates and Themes 00:06:00 Slide Masters 00:17:00 Transitions and Timings 00:07:00 Speaker Notes 00:04:00 Setting Up Slide Shows 00:05:00 Proofing and Delivering Presentations Proofing Presentations 00:07:00 Running Presentations 00:02:00 Printing Presentationsns 00:07:00 Mock Exam Mock Exam- Microsoft Office 2007 PowerPoint Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 PowerPoint Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2007 PowerPoint Beginners - Complete Video Course
Delivered Online On Demand4 hours
£22