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

15522 Courses delivered Online

Marketing Short Stories

4.3(43)

By John Academy

Description Master the secret ways of selling your short stories and fictions of the magazine in other platforms. Enroll the Marketing Short Stories course and explore various opportunities of making money through writing short stories. Selling short stories may sound difficult. However, with proper training, you can gain profit. The course helps you to choose the right magazines and other selling platforms for you. You will understand how to find and select the paying magazines and anthologies that are interested to buy your short stories. You will also learn to choose the right platform for you. The course also trains you how to avoid rejection and how to make your story accept by the magazines. The strategies of submitting your short stories will also be covered in the course. Having completed the course, you will able to learn how to make a profit by selling short stories on various platforms. 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? Marketing Short Stories 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 Marketing Short Stories 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 Introduction FREE 00:02:00 Overview 00:01:00 The Basics Why Short Stories 00:01:00 Benefits 00:02:00 Selling v Licensing 00:03:00 Types of licencing rights part 1 00:02:00 Types of licencing rights part 2 00:07:00 Copyright 00:02:00 How to Sell Your Stories Getting ready to sell 00:02:00 The common types of short fiction markets 00:03:00 Finding and choosing the right markets part 1 00:05:00 Finding and choosing the right markets part 2 00:04:00 Finding and choosing the right markets part 3 00:04:00 Finding and choosing the right markets part 4 00:02:00 Submitting Your Short Stories Submission basics- Research 00:08:00 Submission basics- Guidelines and Formatting 00:09:00 Types of submissions 00:04:00 Set up monitoring and keep writing 00:07:00 Dealing with rejections 00:04:00 Contracts Dealing with contracts 00:06:00 Making Your Stories Work Harder and Earn More Selling reprints 00:06:00 Selling foreign language rights 00:02:00 Selling audio rights 00:03:00 Publishing your stories independently 00:04:00 Putting it all together The story submission step-by-step process 00:04:00 Conclusion Final thoughts 00:01:00

Marketing Short Stories
Delivered Online On Demand1 hour 38 minutes
£21

Microsoft Office 2010 Excel Advanced - Complete Video Course

4.3(43)

By John Academy

Description: This course follows up from the Beginners Excel 2010 course by delving even deeper into features and functions of this powerful spreadsheet software. This Microsoft Office 2010 Excel Advanced - Complete Video Course builds on the skills and concepts taught in Excel 2010: intermediate. In this series you will learn to work with advanced formulas, as well lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation and database functions such as DSUM. You will learn how to work with Pivot Tables and PivotCharts, how to import and export data, and how to query external databases. Finally, you will learn about the analytical features of Excel, running and recording macros, SmartArt graphics and conditional formatting with graphics, and more. Before you taking this course you should have a firm grasp of the basics. This course will pull up your basic knowledge. So join this course to be an expert. 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 Excel Advanced - 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 Excel Advanced - 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. Logical and Statistical Functions Logical Functions FREE 00:17:00 Math and Statistical Functions 00:19:00 Financial and Date Functions Financial Functions 00:04:00 Date and Time Functions 00:10:00 Array Formulas 00:09:00 Displaying and Printing Formulas 00:08:00 Lookups and Data Tables Using Lookup Functions 00:14:00 Using MATCH and INDEX 00:06:00 Array Formulas 00:07:00 Advanced Data Management Validating Cell Entries 00:08:00 Exploring Database Functions 00:06:00 Exporting and Importing Exporting and Importing Text Files 00:11:00 Exporting and Importing XML Data 00:03:00 Querying External Databases 2 hours agoMore 00:09:00 Analytical Tools Goal Seek and Solver 00:15:00 The Analysis ToolPak 00:05:00 Scenarios 1 hour agoMore 00:06:00 Macros and Custom Functions Running and Recording a Macro 00:19:00 Working with VBA Code 00:07:00 Creating Functions 00:05:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2010 Excel Advanced - Complete Video Course
Delivered Online On Demand3 hours 48 minutes
£21

Professional Child Psychology Diploma

4.3(43)

By John Academy

Child Psychology is the study of the mental states, processes, and psychological characteristics of infants and children. A child psychologist diagnoses and treats a wide range of psychological disorders children have faced. The Professional Child Psychology Diploma course deals with the child psychology and development and helps you to understand their behaviours and habits. The course helps you to understand the psychology of babies from zero to one year. Then, you will learn the stages and sequence of social and emotional development. Instead of these, the course also explains linguistic and language skills development and cognitive development. Parents or people who are working with kids such as babysitters, early school teachers will be highly benefited from the course. The course will help them to apply the psychological theories while they are dealing with the kids. Who is the course for? Individuals who would like to work with children (or working with them already) Parents or parents-to-be who want to learn about child's development and behaviour 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: To successfully complete the course you must submit assignments. After submission the instructor will check and assess your work. Certification: After completing 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. 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: 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. Babies from Birth to One Year About the Course and your Tutor FREE 00:02:00 The Importance of Bonding 00:08:00 The Social and Emotional development: from birth to 1 yr 00:06:00 The Innate Reflexes of Newborn Babies 00:07:00 The Benefits of Testing at 'Milestones' 00:07:00 Stages and Sequences of Social and Emotional Development The Importance of Social and Emotional Development 00:06:00 The Ages and Stages that Children go through 00:12:00 The Main theories in Developmental Psychology 00:07:00 The Importance of Positive Role Models 00:07:00 The Barriers to Achieving the 'Milestones' 00:07:00 The Importance of Unconditional Love 00:06:00 Language and Linguistic Skills Development Forms of communication 00:05:00 What is 'Pre-linguistic' form of communication 00:05:00 The Active and the Passive Communication 00:06:00 The Importance of Opportunities in Development of the Skills 00:05:00 The Importance of Body Language 00:06:00 Cognitive Development The Importance of Cognitive Development 00:03:00 The Main Psychological Theories in Cognitive Development 00:07:00 The Appropriate Opportunities for Cognitive Development 00:04:00 The Unconscious Mind: Id, Ego and Superego. Psychoanalytical Theory 00:06:00 Thank You and Good Bye! 00:02:00 Resources Resources - Professional Child Psychology Diploma 00:00:00 Assessment Assignment - Professional Child Psychology Diploma 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Professional Child Psychology Diploma
Delivered Online On Demand2 hours 4 minutes
£21

Microsoft Office 2013 PowerPoint Advanced - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2013 PowerPoint Advanced - Complete Video Course covers more advanced features of PowerPoint 2013. In this series, you will learn how to modify the PowerPoint environment, using methods like customizing design templates, working with media and animations, and adding SmartArt to a presentation, customizing a slide show and securing and distributing a presentation, use tables and spreadsheets to display data in a presentation, learn how to add, format and edit charts with the chart tools and quick clicks, design slide masters and apply slide transitions, apply animations to images in a slide show and edit the timing, add videos to a PowerPoint presentation and trim the media, practice delivering presentations with the presenter's tools, use the review tools to proof and protect presentations, and more. If, you have the basic skills with Microsoft Office 2013 PowerPoint and want to learn advanced-level skills then this course will be perfect for you. 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 PowerPoint Advanced - 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 PowerPoint Advanced - 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. Modifying the PowerPoint Environment Customize the User Interface FREE 00:12:00 Set PowerPoint 2013 Options 00:04:00 Customizing Design Templates Modify Slide Masters and Slide Layouts 00:12:00 Add Headers and Footers 00:06:00 Modify the Notes Master and the Handout Master 00:04:00 Adding SmartArt to a Presentation Create SmartArt 00:06:00 Modify SmartArt 00:07:00 Working with Media and Animations Add Audio to a Presentation 00:13:00 Add Video to a Presentation 00:12:00 Customize Animations and Transitions 00:14:00 Collaborating on a Presentation Review a Presentation 00:18:00 Store and Share Presentations on the Web 00:11:00 Customizing a Slide Show Annotate a Presentation 00:04:00 Set Up a Slide Show 00:04:00 Create a Custom Slide Show 00:04:00 Add Hyperlinks and Action Buttons 00:10:00 Record a Presentation 00:07:00 Securing and Distributing a Presentation Secure a Presentation 00:09:00 Broadcast a Slide Show 00:08:00 Create a Video or a CD 00:09:00 Mock Exam Mock Exam- Microsoft Office 2013 PowerPoint Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 PowerPoint Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2013 PowerPoint Advanced - Complete Video Course
Delivered Online On Demand3 hours 34 minutes
£21

Diploma in Team Building

4.3(43)

By John Academy

It is almost impossible to even imagine a corporate world without a healthy and trained group of people working together to achieve the tasks which would be unachievable otherwise. With this course, learn how to make a solid team-building strategy that can create an environment of greater collaboration and unity. Learn the concepts that make up a great team, the factors that help it to be successful and also how to be an inspiring team role model. You will also learn how to face obstacles as a team and overcome them. With teams at the heart of corporate strategy, your success as an organization can often depend on how well you and other team members operate together. This course can definitely help you get there! Learning Outcomes: The price of working as a team How to develop team standard, ground rules, and team contracts Their team player methods as well as how it can be applied effectively Mediums to create team belief The phases of team development and how to assist a team go through them The sensitive role communication skills will contribute to building and managing a team atmosphere Paths in which team members can get engaged in and boost in a team setting 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? Diploma in Team Building 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 Diploma in Team Building 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. Module: 1 Defining Teams 00:15:00 Establishing Team Norms 00:15:00 Working as a Team 00:15:00 Your Team Player Type 01:00:00 Building Team Trust 00:15:00 The Stages of Team Development 00:30:00 Communication 00:30:00 Becoming a Good Team Player 00:15:00 Module: 2 Types of Teams 00:15:00 The TORI Team Building Model 00:15:00 The Five Stages of Team Development 00:30:00 Characteristics of Great Teams 00:15:00 Clear Roles and Assignments 00:15:00 Team Player Types 00:30:00 The Trust/Relationship Model 00:05:00 Lateral and Vertical Thinking 00:05:00 Creative Team Thinking 00:45:00 Team Shaping Factors 00:15:00 Solving Problems 00:30:00 Interventions for Team Leaders 00:30:00 Resolving Conflict 00:15:00 SWOT Analysis 00:15:00 Developing Team Action Plans 00:15:00 Mock Exam Mock Exam- Diploma in Team Building 00:30:00 Final Exam Final Exam- Diploma in Team Building 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Team Building
Delivered Online On Demand9 hours 10 minutes
£21

Advanced Diploma in Personal Management

4.3(43)

By John Academy

Description: Personal Management is the practice that involves planning of your life goals, both short and long term. These goals could be achieved through proper ways of living and management of your life. These management ways could vary from personal, career, education, financial, and time. If you want to learn how to do proper personal management, then you also need to manage your attention and ego. This course will be able to provide you with all of these lessons and attain the personal management and success you desire. Who is the course for? Professionals who are helping people cope up with their drug addiction People who have the interest to learn the ways to cope with drug addiction 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: Advanced Diploma in Personal Management course is a useful qualification to possess, and would be beneficial for the following careers: Career Coach Guidance Counsellor Life Coach Mentors Psychologist Therapist. Managing Attention Module One - Getting Started 00:30:00 Module Two - Introduction to Attention Management 00:30:00 Module Three - Types of Attention 01:00:00 Module Four - Strategies for Goal Setting 01:00:00 Module Five - Meditation 01:00:00 Module Six - Training Your Attention 01:00:00 Module Seven - Attention Zones Model 01:00:00 Module Eight - SMART Goals 01:00:00 Module Nine - Keeping Yourself Focused 01:00:00 Module Ten - Procrastination 01:00:00 Module Eleven - Prioritizing Your Time 01:00:00 Module Twelve - Wrapping Up 00:30:00 Attention Management- Activities 00:00:00 Managing Ego Why You Need To Develop Your Ego 00:30:00 Work On Honesty 00:30:00 Work On Courage And Exploration 01:00:00 How To Build A Stronger Ego 01:00:00 Staying Engaged With Life 00:15:00 The Dangers Of A Damaged Ego 00:15:00 Personal Development Healthy Abundance Mindset 01:00:00 Meditation 01:00:00 Goal Setting 01:00:00 Center Yourself 01:00:00 Get Over Your Fear 01:00:00 Be Grateful 01:00:00 Visualize 01:00:00 Wrapping Up 00:15:00 Mock Exam Mock Exam- Advanced Diploma in Personal Management 00:30:00 Final Exam Final Exam- Advanced Diploma in Personal Management 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Diploma in Personal Management
Delivered Online On Demand22 hours 15 minutes
£21

Advanced Diploma in Performance Management and Employee Recognition

4.3(43)

By John Academy

Description: Performance management is the management that focuses on promoting and improving employee's effectiveness. It is important to know about performance management since this skill will help in assessing the performance of each worker and how productive they are. It is very important to analyze their performance to know which workers has been improving and contributing to the success or downfall of the business. Through this course, you will learn the necessary skills and knowledge on performance management. You will be given tips and advice on how to manage your department or business to help you in improving yours and the employee's performance. Who is the course for? Professionals who want to learn to assess performance in their organization. People who are interested in learning about performance management. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally 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 Advanced Diploma in Performance Management is a useful qualification to possess and would be beneficial for the following careers: Businessmen Business Development Officer Marketing Manager Performance Analyst Sales Specialist Strategist. Managing Performance Module One - Getting Started 00:30:00 Module Two - The Basics (I) 01:00:00 Module Three - The Basics (II) 01:00:00 Module Four - Goal Setting 01:00:00 Module Five - Establishing Performance Goals 01:00:00 Module Six - 360 Degree Feedback 01:00:00 Module Seven - Competency Assessments 01:00:00 Module Eight - Kolb's Learning Cycle 01:00:00 Module Nine - Motivation 01:00:00 Module Ten - The Performance Journal 01:00:00 Module Eleven - Creating a Performance Plan 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities 00:00:00 Employee Recognition Module One - Getting Started 00:30:00 Module Two - The Many Types of Incentive 01:00:00 Module Three - Designing Employee Recognition Programs 01:00:00 Module Four - How To Get The Buzz Out 01:00:00 Module Five - It Starts From The Top! 01:00:00 Module Six - Creating a Culture of Recognition 01:00:00 Module Seven - The Best Things In Life Are Free! 01:00:00 Module Eight - A Small Gesture Goes A Long Way 01:00:00 Module Nine - Pulling Out The Red Carpets 01:00:00 Module Ten - The Don'ts of Employee Recognition 01:00:00 Module Eleven - Maintaining Employee Recognition Programs 01:00:00 Module Twelve - Wrapping Up 00:30:00 Employee Recognition Training Course- Activities 00:00:00 Mock Exam Mock Exam- Advanced Diploma in Performance Management and Employee Recognition 00:30:00 Final Exam Final Exam- Advanced Diploma in Performance Management and Employee Recognition 00:30:00

Advanced Diploma in Performance Management and Employee Recognition
Delivered Online On Demand23 hours 30 minutes
£21

Microsoft Office 2007 Excel Advanced - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2007 Excel Advanced - Complete Video Course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros. You will also learn to use key advanced financial, logical, text, statistical and math, and lookup functions, audit formulas for errors, analyze data using subtotals, goal seek and the scenario manager, use custom and conditional formatting, manage data with tables, filtering and sorting, create, edit and format PivotTables and PivotCharts, import and export date to and from a workbook, create and use macros. So, by taking this course you will have a complete understanding of the higher functions of Excel. 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 Excel Advanced - 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 Excel Advanced - 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. Advanced Functions Logical Functions FREE 00:08:00 Math and Statistical Functions 00:06:00 Financial Functions 00:03:00 Displaying and Printing Formulas 00:02:00 Lookups and Data Tables Using Lookup Functions 00:03:00 Using MATCH and INDEX 00:01:00 Creating Data Tables 00:03:00 Advanced List Management Validating Cell Entries 00:01:00 Exploring Database Functions 00:01:00 PivotTables and PivotCharts Working with PivotTables 00:04:00 Rearranging PivotTables 00:02:00 Formatting PivotTables 00:02:00 PivotCharts 00:01:00 Exporting and Importing Exporting and Importing Text Files 00:07:00 Exporting and Importing XML Data 00:02:00 Querying External Databases 00:03:00 Analytical Options Goal Seek and Solver 00:05:00 The Analysis ToolPak 00:01:00 Scenarios 00:02:00 Views 00:01:00 Macros and Custom Functions Running and Recording a Macro 00:02:00 Working with VBA Code 00:01:00 Creating Functions 00:05:00 Conditional Formatting and SmartArt Conditional Formatting with Graphics 00:03:00 SmartArt Graphics 00:02:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2007 Excel Advanced - Complete Video Course
Delivered Online On Demand1 hour 51 minutes
£21

Professional Business Writing

4.3(43)

By John Academy

Description: We all know the importance of good writing. In business writing, the language is concrete, the point of view is clear and well expressed. This course will help you will get all the tools to become a good writer, and how to use writing skills for the improvement of your business. Report writing is a skill you will use again and again in your business. Here, you will learn how to write reports and proposal's, you will get a writing skill to present information in formal, informal, and proposal style. This Professional Business Writing will brush up your writing skills more if you are already a good writer. So, thinking to get an improvement in your writing skills? Join this course now. Learning Outcomes: The worth of accurate, written communication Learn how to write proofread your task so that it is clear, accomplished and correct How to exploit your skills in the realistic circumstances The correct format for memos, letters, as well as e-mails Prepare reports and proposals that inform, persuade, and provide information. Review your work so that it is clear, concise, complete, and correct. Apply these skills in real work applications. 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? Professional Business Writing 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 Professional Business Writing 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. Module 01 Active and Passive Voice 00:15:00 Be Clear 00:15:00 Be Concise 00:00:00 Be Correct 00:05:00 Inclusive Language 00:05:00 Manners and Courtesy 00:05:00 Practical Language 00:15:00 Punctuation 00:15:00 Readability Index 00:15:00 Reviewing Your Writing 00:15:00 Sentence Construction 00:05:00 Sentences and Sentence Types 00:15:00 Spelling and Proofreading 00:15:00 Why Write? 00:15:00 Word Agreement 00:05:00 Writing Business Letters 00:15:00 Writing Effective E-mails 00:15:00 Module 02 The Stages of Report Writing 00:15:00 The First Stage - Investigating 00:15:00 The Second Stage - Planning 00:15:00 The Third Stage - Writing 00:15:00 The Fourth Stage - Revising 00:15:00 Using Headings 00:15:00 Using Charts and Graphs 00:15:00 The Proposal 00:15:00 Persuasion 00:30:00 Giving Credit 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Professional Business Writing
Delivered Online On Demand5 hours 55 minutes
£21

Microsoft PowerPoint 2016 Advanced

4.3(43)

By John Academy

Description: Microsoft Office PowerPoint 2016 is the latest version of Microsoft's ubiquitous presentation software. This Microsoft PowerPoint 2016 Advanced is designed for them who have basic skills with Microsoft PowerPoint 2016 and want to learn advanced-level skills or want to learn the topics covered in this course in the 2016 interface. You will learn to modify the PowerPoint environment, customizing design templates, working with media and animation, and much more. So if you want to develop your skills and knowledge in this program, you should join this course now. Learning Outcomes: PowerPoint environment and how to modify it according to needs Customizing user interface and setting up options Create and manage sections, modify slide masters and slide layouts, add headers and footers, modify notes master and handout master Creating and modifying SmartArt Adding audio video to presentations and customizing animations and transitions to enhance presentation Better collaboration by adding comments, reviews, storing and sharing presentations on the web Setting up and creating custom slide shows, adding hyperlink and action buttons, and recording a presentation Security and distribution of presentations through various outlets 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 PowerPoint 2016 Advanced 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 PowerPoint 2016 Advanced 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. Modifying the PowerPoint Environment Customize the User Interface 01:30:00 Set PowerPoint 2016 Options 00:45:00 Customizing Design Templates Create and Manage Sections 01:00:00 Modify Slide Masters and Slide Layouts 01:15:00 Add Headers and Footers 00:30:00 Modify the Notes Master and the Handout Master 00:45:00 Adding SmartArt to a Presentation Create SmartArt 00:45:00 Modify SmartArt 01:00:00 Working with Media and Animations Add Audio to a Presentation 00:45:00 Add Video to a Presentation 01:00:00 Customize Animations and Transitions 01:00:00 Collaborating on a Presentation Add Comments to a Presentation 00:45:00 Review a Presentation 00:45:00 Store and Share Presentations on the Web 01:30:00 Customizing a Slide Show Annotate a Presentation 00:45:00 Set Up a Slide Show 00:45:00 Create a Custom Slide Show 00:30:00 Add Hyperlinks and Action Buttons 00:45:00 Record a Presentation 00:15:00 Securing and Distributing a Presentation Secure a Presentation 01:30:00 Present a Slide Show Online 01:00:00 Create a Video or a CD 00:45:00 Activities Activities - Microsoft PowerPoint 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft PowerPoint 2016 Advanced 00:20:00 Final Exam Final Exam- Microsoft PowerPoint 2016 Advanced 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft PowerPoint 2016 Advanced
Delivered Online On Demand20 hours 10 minutes
£21