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

57915 Courses

Psychology of Old Age Certificate

4.3(43)

By John Academy

Understand adult psychology and know how to deal with them in the Psychology of Old Age Certificate course. Throughout the course, you will understand adult psychology and explore whether the career in 'caring' or 'psychology' is for you or not. You will learn about 'Alzheimer's disease' and 'dementia' and also understand the difference between these two diseases. The course shows you how common people stereotype the older people and how it affects them. You will also learn about 'developmental psychology', and substance abuse in older people. Lastly, the course teaches you how to improve health and wellbeing of old people. Here, you will learn the effects of exercising, eating healthy in older age, caring for old people and more. Who is the course for? Anyone who wants to learn about 'old age' psychology Anyone who is interested in various topics related to psychology Anyone who is planning their career in psychology Anyone who is looking after the elderly and would like to learn theories of 'old age' 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 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. 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. About Your Course About your tutor FREE 00:02:00 About your course 00:03:00 Introduction to Psychology of Older Age What is 'Developmental Psychology'? 00:05:00 What is 'Gerontology'? 00:09:00 What we consider as 'old age' 00:09:00 What is 'ageing' and how it happens 00:08:00 Psychology of Older Age Common stereotypes of older people 00:08:00 How stereotyping affects older people 00:08:00 Life stages and Theories 00:11:00 What do we look forward to in our older age? 00:06:00 Mental Health and Old Age Memory-related issues 00:12:00 Learning disabilities 00:08:00 Alzheimer's disease and Dementia 00:09:00 Chronic illness and Disabilities 00:08:00 Substance abuse (addictions) 00:06:00 The Quality of Life What is 'Quality of Life'? 00:05:00 Loneliness factors in the elderly population 00:07:00 Coping with grief and bereavement 00:07:00 'Mild' and 'severe' depression 00:07:00 Fear of dying ('death anxiety') 00:09:00 Improving Health and Wellbeing The effects of exercising 00:09:00 Is it worth eating 'healthy' in older age? 00:09:00 What else affects 'health' and 'wellbeing'? 00:08:00 Caring for older people 00:06:00 Thank You & Good Bye! 00:02:00 Mock Exam Mock Exam - Psychology of Old Age Certificate 00:20:00 Final Exam Final Exam - Psychology of Old Age Certificate Training 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Psychology of Old Age Certificate
Delivered Online On Demand3 hours 41 minutes
£11.99

Voice Equipment Course

4.3(43)

By John Academy

Overview Learn how to record professional-quality voiceovers with this Voice Equipment Course. This course will introduce you to different types and functions of voiceover equipment and the latest voiceover software for your podcast.  To start a voiceover career, you need to be aware of the right recording equipment. The course will guide you through the essential tools for recording voiceovers. Here, you'll learn about different types of microphones and understand how to select the best one for your creative needs. In addition, the course will introduce you to many high-quality headphones and explain how to use them for recording and editing.  From this valuable training, you'll identify the elements of acoustic treatment to reduce unwanted reflections, echoes, and background noise and make a professional studio. The course will also teach you about different voiceover and editing tools and explain how to perform routine maintenance and simple repairs on voiceover equipment. Course Preview Learning Outcomes Familiarise yourself with different types of voice equipment Understand the role of an audio interface Gain valuable insights into the audio editing process Determine the importance of acoustic treatment for your studio Enrich your knowledge of equipment maintenance and troubleshooting Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. Who Should Take this Voice Equipment Course? This course is suitable for anyone interested in learning about different types of equipment and software for recording high-quality voiceovers. Whether you're a beginner or have some knowledge about voice equipment, you can take this course without any worries. In addition, the in-demand abilities gained from this training will provide excellent career opportunities. Are There Any Entry Requirements? This Voice Equipment Course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Assessment Method This course does not involve any assessment. Students can order their course completion Certificate at an additional cost of £14.99for hard copy and in PDF format at £11.99. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path​ The Voice Equipment Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Voice Actor Narrator Audiobook Narrator Commercial Voiceover Artist Video Game Voice Actor Animation Voice Actor Radio Presenter Voice Acting Coach Module 1: Introduction to Voice Over Equipment Introduction to Voice Over Equipment 00:17:00 Module 2: Microphones for Voice Over Microphones for Voice Over 00:21:00 Module 3: Headphones and Monitoring Headphones and Monitoring 00:22:00 Module 4: Audio Interfaces and Preamps Audio Interfaces and Preamps 00:23:00 Module 5: Acoustic Treatment and Studio Setup Acoustic Treatment and Studio Setup 00:23:00 Module 6: Voice Over Software and Editing Tools Voice Over Software and Editing Tools 00:22:00 Module 7: Equipment Maintenance and Troubleshooting Equipment Maintenance and Troubleshooting 00:22:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Voice Equipment Course
Delivered Online On Demand2 hours 30 minutes
£11.99

Diploma in Summer Dieting

4.3(43)

By John Academy

Description: You don't have to start a fad diet and starve yourself this summer to look good in your summer swimsuit. Start eating healthy and hit the beach with that perfect body. It is generally believed that summers are better for exercise routine as the basic metabolic rate is believed to go higher and foods are burned faster. However, it is very necessary to watch out to what you eat and how much exercise you do. Enrol in our diploma in summer dieting and learn not only how to control your calories this summer but also establish a healthy eating style. Who is the course for? Anyone who wants to loose weight and get in shape this summer 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: Nutritionist Weight adviser Healthy diet adviser Module: 01 Healthy Eating Pyramid 00:15:00 Healthy Diet Foods For This Summer 00:30:00 Health Diet Plans For The Summer 00:30:00 Great Diets For The Summer 00:15:00 Eat Right And Lose Those Extra Pounds This Summer 00:30:00 Eat Healthy This Summer And Hit The Beach With That Perfect Body 00:15:00 Diet This Summer For A Great Beach Body 00:15:00 Diet This Summer And Improve Your Fitness 00:30:00 Cool Salads For Your Summer Diet 00:30:00 A Simple Summer Detox Diet Plan 00:30:00 Your Summer Holiday Diet Tips 00:30:00 Your Diet Guide for the Summer 00:30:00 Module: 02 Weight Loss Tips for the Summer 00:30:00 Weight Loss Plans for the Summer 00:30:00 Tips on Maintaining a Healthy Diet 00:30:00 The Principles Of A Summer Diet 00:15:00 The Best Summer Foods For Weight Loss 00:15:00 Summer Weight Loss Diets For The Health Conscious 00:30:00 Summer Foods for Weight Loss 00:30:00 Summer Diet Tips for Women 00:30:00 Steps to a Healthy Summer Diet 00:30:00 Some Great Tips For A Summer Diet 00:15:00 Some Cool Diets For Summer 00:15:00 Raw Food Diets for Summer 00:15:00 Low Cal Recipes For A Summer Diet 00:30:00 Additional Supporting Material Additional Supporting Material : Healthy Eating A Practical Guide 00:00:00 Additional Supporting Material : Healthy Eating A Practical Guide 00:00:00 Mock Exam Mock Exam- Diploma in Summer Dieting 00:20:00 Final Exam Final Exam- Diploma in Summer Dieting 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Summer Dieting
Delivered Online On Demand10 hours 55 minutes
£11.99

Advanced Diploma in Financial Management

4.3(43)

By John Academy

Description:  Financial Management is the efficient planning, organizing, controlling and monitoring financial resource to achieve the goals of an organization or business. You need to develop financial IQ to become an expert in financial management. Learn about budgeting and debt management which are essential in managing the business. These finance management lessons will be taught through this advanced diploma course in financial management. Who is the course for? Business professionals who want to learn more about financial management. Or anyone who is interested in attaining own financial security and for business. 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: This Advanced Diploma in Financial Management course will be useful and would be beneficial for people in the business or corporate world. It will also help to people who are in a financial-related career such as: Accountant Bookkeeper Consultant Financial Adviser Financial Analyst Public Accountant. Module 1: Developing Financial IQ Introduction To Financial IQ 01:00:00 Essential Ways To Build Wealth 01:00:00 When's The Right Time To Invest? 01:00:00 The Methods Of Financial Mess 01:00:00 Module 2: Finance and Budgeting Financing Basics 01:00:00 Record Your Income 01:00:00 Make a List of Expenses First and Put Them in Categories 01:00:00 Countdown & Adjust 01:00:00 Review Regularly 01:00:00 Module 3: Debt Management Where to Start When You Have to Start Over 00:30:00 Concept of Credit 01:00:00 Way To Become Debt-free - The Step-By-Step Plan 01:00:00 The Credit Counseling and Debt Settlement options 01:00:00 The Psychology of Money - Changing your mindset 01:00:00 Budegets 00:30:00 Module 4: Credit Card Management Quit Pointing the Finger 00:15:00 Getting A Grip On Priorities 00:15:00 Beginner Ways To Clear It Up 00:30:00 Do You Know About Snowballing? 00:15:00 Do It In Bits 00:15:00 Wrapping Up 01:00:00 Module 5: Managing Mortgage What Is Credit Rating Booster 00:30:00 How To Find Mortgage Lenders 00:30:00 Finding The Right Loans 00:30:00 Compare Mortgage Rates 00:30:00 How To Successfully Negotiate For Lower Prices 00:30:00 Common Mortgage Error And How To Avoid Them 00:30:00 Wrapping Up 00:15:00 Mock Exam Mock Exam- Advanced Diploma in Financial Management 00:30:00 Final Exam Final Exam- Advanced Diploma in Financial Management 00:30:00

Advanced Diploma in Financial Management
Delivered Online On Demand20 hours 45 minutes
£11.99

Advanced Diploma in Time and Priority Management

4.3(43)

By John Academy

Description: Learning both time and priority management at the same time is very practical since they are both related. This is an example of exercising time and priority management. In this course, not only you would not waste time, but it will maximize your efforts to know about how to manage your time and priorities wisely. This would help you figure out how to do priority management for yourself and your company or organization as well. Since this course could provide you with all of these, then you don't have to think about it and register now to start. This course will provide you with the skills, knowledge and information of effective time and priority management.  Who is the course for? Anyone is interested in learning about time and priority management. People who have an interest in knowing how managing time and priority works. 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 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 Time and Priority Management is a useful qualification to possess, and would be beneficial for the following careers: Businessmen Entrepreneur Executive Director Management Consultant Top Executive. Managing Time Module One - Getting Started 00:30:00 Module Two - Setting SMART Goals 01:00:00 Module Three - Prioritizing Your Time 01:00:00 Module Four - Planning Wisely 01:00:00 Module Five - Tackling Procrastination 01:00:00 Module Six - Crisis Management 01:00:00 Module Seven - Organizing Your Workspace 01:00:00 Module Eight - Delegating Made Easy 01:00:00 Module Nine - Setting a Ritual 01:00:00 Module Ten - Meeting Management 01:00:00 Module Eleven - Alternatives to Meetings 00:30:00 Module Twelve - Wrapping Up 01:00:00 Level 3 Diploma in Time Management- Activities 00:00:00 Priority Management Identify Your Priorities 01:00:00 The Difference Between Wants And Needs 01:00:00 Hot to Get Spending Under Control 01:00:00 You Have To Pay Yourself 00:30:00 Tips To Budgeting 01:00:00 Managing Time & Priority Where Do You Spend Your Time 01:00:00 Managing Tasks 01:00:00 Planning 01:00:00 Goals 01:00:00 Tips From The Gurus 01:00:00 Wrapping Up 00:15:00 Mock Exam Mock Exam - Advanced Diploma in Time Priority Management 00:20:00 Final Exam Final Exam - Advanced Diploma in Time Priority Management 00:20:00

Advanced Diploma in Time and Priority Management
Delivered Online On Demand21 hours 25 minutes
£11.99

Life Coaching

5.0(1)

By LearnDrive UK

The course will provide a comprehensive understanding of the coaching process and the skills required to influence positive changes in your professional and personal lives.

Life Coaching
Delivered Online On Demand1 hour
£5

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query

4.5(3)

By Studyhub UK

Ascend to the next level of Excel proficiency with our comprehensive Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course. This in-depth training will equip you with the skills to create sophisticated dashboards using advanced Excel formulas, VBA, and Power Query, empowering you to transform raw data into actionable insights. Master the art of financial modeling with our prepaid expenses models, learning how to calculate amortization schedules and create detailed summaries using Excel formulas. Delve into the power of Power Query to effortlessly manipulate and analyze large datasets, building dynamic dashboards without the limitations of formulas. Learning Outcomes Gain proficiency in creating automated dashboards using advanced Excel formulas, VBA, and Power Query Develop expertise in financial modeling using prepaid expenses models Master the calculation of amortization schedules and prepaid expenses summaries Implement Power Query to manipulate and analyze large datasets Create dynamic dashboards without the limitations of formulas Enhance your Excel skills and data analysis capabilities Why choose this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course for? Accounting and finance professionals seeking to enhance their Excel skills for financial modeling and dashboard creation Business analysts and data analysts aiming to expand their expertise in data manipulation and visualization Excel enthusiasts interested in mastering advanced Excel formulas, VBA, and Power Query Individuals seeking to create interactive and insightful dashboards for data-driven decision-making Anyone seeking to elevate their Excel skills and become a proficient data analyst Career path Financial Analyst (£35,000 - £55,000) Business Analyst (£40,000 - £60,000) Data Analyst (£45,000 - £65,000) Management Accountant (£40,000 - £60,000) Business Intelligence Analyst (£45,000 - £65,000) Senior Financial Analyst (£50,000 - £70,000) Prerequisites This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thank you Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Assignment Assignment - Microsoft Excel: Automated Dashboard Using Advanced Formula VBA Power Query 00:00:00

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Delivered Online On Demand6 hours 8 minutes
£10.99

Phlebotomist

5.0(1)

By LearnDrive UK

Phlebotomist course will teach you step-by-step how to do phlebotomy so you can master it.

Phlebotomist
Delivered Online On Demand1 hour
£5

Career Planning: The Right Way to Develop Your Career

5.0(1)

By LearnDrive UK

Throughout this career planning course, comprehensive career development guidelines will help you achieve your desired career goal.

Career Planning: The Right Way to Develop Your Career
Delivered Online On Demand1 hour
£5

Microsoft Office 2013 PowerPoint Beginners - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2013 PowerPoint Beginners - Complete Video Course covers the basic functions and features of PowerPoint 2013. This series begins with an introduction in developing a PowerPoint presentation. With this course you will learn about advanced text editing and how to utilize graphical elements, manipulate an existing PowerPoint presentation, create a new presentation based on a template, design a blank presentation selecting various slide layouts, print a presentation using special print options, modify a presentation using different outline views, edit and delete text in the title and bulleted placeholders, modify the presentation through choosing a color scheme and formatting the background, change all slides using the slide master, change alignment, header, footer and objects with the slides, work with drawing, sizing, moving and grouping objects, and much more. If you want to know more detail you have to be a part of this course. You will get all the basic knowledge from this course. 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 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 2013 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 with PowerPoint Navigate the PowerPoint Environment FREE 00:17:00 Create and Save a PowerPoint Presentation 00:09:00 Use Help 00:04:00 Developing a PowerPoint Presentation Select a Presentation Type 00:07:00 View and Navigate a Presentation 00:10:00 Edit Text 00:16:00 Building a Presentation 00:21:00 Performing Advanced Text Editing Format Characters 00:14:00 Format Paragraphs 00:19:00 Format Text Boxes 00:10:00 Adding Graphical Elements to Your Presentation Insert Clip Art and Images 00:09:00 Insert Shapes 00:11:00 Modifying Objects in Your Presentation Edit Objects 00:16:00 Format Objects 00:07:00 Group Objects 00:05:00 Arrange Objects 00:07:00 Animate Objects 00:06:00 Adding Tables to Your Presentation Create a Table 00:05:00 Format a Table 00:06:00 Insert a Table from Other Microsoft Office Applications 00:05:00 Adding Charts to Your Presentation Create a Chart 00:07:00 Format a Chart 00:09:00 Insert a Chart from Microsoft Excel 00:04:00 Preparing to Deliver Your Presentation Review Your Presentation 00:08:00 Applying Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:07:00 Mock Exam Mock Exam- Microsoft Office 2013 PowerPoint Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 PowerPoint Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2013 PowerPoint Beginners - Complete Video Course
Delivered Online On Demand4 hours 49 minutes
£11.99