57842 Courses

Overview This comprehensive course on Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 76 lectures • 06:08:00 total length •Course Outline and Introduction: 00:04:00 •Minimum Requirements for the Course: 00:01:00 •Prepayments Introduction: 00:01:00 •Month End Date Prepaid Expenses Amortization Calculation: 00:00:00 •Exact Prepaid Expenses Payment Date Calculation: 00:00:00 •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 •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 •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 •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 •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 •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 •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 •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: 00:02:00 •Ultimate Prepaid Expenditure Model (Super Bonus): 00:02:00 •Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query: 00:00:00

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Do you want to capture or stimulate interest in a product or service to increase the sales pipeline? Are you interested to make a relationship with for creating better opportunities of highest sales? If so, the inevitable Prospecting and Lead Generation course is for you. The course assists you to learn further process and methods regarding the field step-by-step. Primarily, the course gives you a brief introduction about prospecting and led generation. Following that, it instructs you the relation between these two that brings the utmost profit of a business. Besides, it keeps guiding you to various effective ways of prospecting focusing on the outcome, good writing skills of scripts, and natural relationship over time to increase sales. Overall, the course teaches you all the marketing process and procedures along with effective instructions to build a relationship for the growth of a business. Who is this course for? Prospecting and Lead Generation is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Prospecting and Lead Generation is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Prospecting and Lead Generation Diploma Module One - Getting Started 00:30:00 Module Two - Prospecting 00:30:00 Module Three - Traditional Marketing Methods 01:00:00 Module Four - New Marketing Methods 01:00:00 Module Five - Generating New Leads 01:00:00 Module Six - Avoid Common Lead Generation Mistakes 00:30:00 Module Seven - Educate Prospects 00:30:00 Module Eight - The Pipeline 00:30:00 Module Nine - Follow up Communication 01:00:00 Module Ten - Track Activity 00:30:00 Module Eleven - Create Customers 01:00:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Mock Exam- Prospecting and Lead Generation 00:20:00 Final Exam Final Exam- Prospecting and Lead Generation 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Overview Master investing in the stock market by enrolling in our Stocks, Shares and Forex Trading- Level 3course.The exchange of equity securities in stocks for large publicly traded companies and smaller companies over stock markets is known as stock trading. Stock Traders advise shareholders and help manage portfolios, buying and selling bonds, stocks, and shares in hedge funds to make their clients profit. This Stocks, Shares and Forex Trading- Level 3 course is designed by industry experts and will give you an out-and-out understanding of stock trading. It will teach you the ABCs of stock trading, introducing top strategies used by the best traders to help you become a profitable trader without offering any get rich quick strategies. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Stocks, Shares and Forex Trading- Level 3. It is available to all students, of all academic backgrounds. Requirements Our Stocks, Shares and Forex Trading- Level 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 9 lectures • 02:20:00 total length •Introduction to Forex Trading: 00:11:00 •Major Currencies and Market Structure: 00:10:00 •Kinds of Foreign Exchange Market: 00:14:00 •Money Management: 00:11:00 •Fundamental Analysis: 00:21:00 •Technical Analysis: 00:32:00 •Pitfalls and Risks: 00:11:00 •Managing Risk: 00:16:00 •Trading Psychology: 00:14:00

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Google Classroom Masterclass course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Google Classroom Masterclass course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Google Classroom Masterclass and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Google Classroom Masterclass course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Google Classroom Masterclass course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The Google Classroom Masterclass will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Module 01: Setting up your Classroom Getting Google Account and Signing in 00:02:00 Creating a Class 00:04:00 Classroom Navigation 00:09:00 Class Settings 00:04:00 Add Co-Teacher and Students 00:09:00 Creating of Additional Class 00:02:00 Google Drive Structure & Class options 00:07:00 Module 02: Managing Google Classroom Topics 00:07:00 Assignment 00:14:00 Assignment Dashboard & Student Communication 00:06:00 To Do List and Calendar 00:05:00 Materials 00:06:00 Announcement 00:06:00 Quiz Assignments 00:17:00 Questions 00:03:00 Reusing Posts 00:05:00 Grade 00:05:00 Rubric 00:11:00 Module 03: Bonus (Update) Join Google Classroom using link 00:02:00 Google Classroom Home Page Changes 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Overview This comprehensive course on Level 2 HACCP Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Level 2 HACCP Training comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Level 2 HACCP Training. It is available to all students, of all academic backgrounds. Requirements Our Level 2 HACCP Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 1 sections • 5 lectures • 02:40:00 total length •Module 01: Introduction to HACCP and Legislation: 00:30:00 •Module 02: Food Safety Microbiological Hazards: 00:45:00 •Module 03: Food Safety: Allergenic, Chemical & Physical Hazards: 00:25:00 •Module 04: HACCP Prerequisites, Preliminary Steps and Creation of HACCP System: 00:20:00 •Module 05: The Seven HACCP Principles Explained: 00:40:00

Overview This comprehensive course on Social Science will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Social Science comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Social Science. It is available to all students, of all academic backgrounds. Requirements Our Social Science is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 15 sections • 15 lectures • 05:23:00 total length •Introduction to Social Science: 00:22:00 •Science and Social Science: 00:17:00 •Philosophy of Social Science: 00:23:00 •Sociology Part 1: 00:22:00 •Sociology Part 2: 00:30:00 •Economics: 00:23:00 •Anthropology and Archaeology: 00:23:00 •Political Science: 00:22:00 •Linguistics and Psychology: 00:19:00 •History: 00:19:00 •Geography: 00:20:00 •Communication and Media Studies: 00:29:00 •Research Methods: 00:35:00 •Social Science in Modern Times: 00:19:00 •Assignment - Social Science: 00:00:00

Newspapers are one of the most accessible and highly circulated popular mass media to convey news of all sorts. Newspaper journalism plays the key role in bringing news to the audience. The course, Newspaper Journalism has been developed to teach you the skills and knowledge a newspaper journalist needs to establish a career in Newspaper Journalism. This comprehensive Newspaper Journalism course is developed by industry-leading experts with the utmost care and thorough research. All the topics are broken down into simply digestible bite-sized modules, allowing our students to understand each lesson quickly. After completing the  Newspaper Journalism Course, you will acquire accurate knowledge and skills with proper confidence to enrich yourself. These skills will brighten up your career in the relevant job market. Get enrolled in the course and avail the opportunity to play and contribute a respective role in the field of journalism with our well-designed Newspaper Journalism course.  Get a certificate fast and boost your career as a  Newspaper Journalist or other relevant job sectors with our  Newspaper Journalism Course prepared by qualified professionals. You will receive an e-certificate immediately after completing the Newspaper Journalism course, which will help you find work in the sector and will boost your CV. Enrol in this  Newspaper Journalism course from Course Gate if you want to learn more about this skill and become an excellent journalist. Learning Objectives Learn about the history of newspaper journalism Familiarise with the basic principle and fundamentals of newspaper journalism Know about the roles and responsibilities of a newspaper journalist Learn how to identify real news Be able to remove misleading content from the news Understand the ethical and legal obligations for publishing a news Familiarise with different steps of newspaper journalism Be able to edit and report a news Who is this Course for? This introductory  Newspaper Journalism course is ideal for aspiring  Newspaper Journalists who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of the principles of  Newspaper Journalism, or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course; however, an eye for detail and a creative mind is essential. Entry Requirement This course is available to all learners of all academic backgrounds. A good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path On successful completion of the Newspaper Journalism course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Newspaper Journalists News Editors Proofreaders News Researchers Journalists Reporters Course Curriculum Module 01: Introduction and Principles of Newspaper Journalism Introduction and Principles of Newspaper Journalism 00:23:00 Module 02: History and Development of Newspaper Journalism History and Development of Newspaper Journalism 00:26:00 Module 03: Interviewing for Newspaper Journalism Interviewing for Newspaper Journalism 00:25:00 Module 04: News Writing News Writing 00:20:00 Module 05: News Production News Production 00:27:00 Module 06: News Reporting News Reporting 00:21:00 Module 07: Writing Skills for Newspaper Journalists Writing Skills for Newspaper Journalists 00:31:00 Module 08: Newspaper Journalism law Newspaper Journalism law 00:36:00 Module 09: Court Reporting Court Reporting 00:14:00 Module 10: Journalism Ethics Journalism Ethics 00:16:00 Module 11: Niche Journalism Niche Journalism 00:27:00 Module 12: Tips on Writing a Good Feature Story Tips on Writing a Good Feature Story 00:34:00 Module 13: Health and Safety for Journalists Health and Safety for Journalists 00:36:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Overview This comprehensive course on Adobe InDesign Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Adobe InDesign Training comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Adobe InDesign Training. It is available to all students, of all academic backgrounds. Requirements Our Adobe InDesign Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 5 sections • 47 lectures • 05:21:00 total length •1 Intro Indesign: 00:02:00 •2 - Course Downloadables: 00:01:00 •2 Conclusion InDesign: 00:02:00 •3 Let's Start Creating!: 00:14:00 •4 InDesign Workspace: 00:08:00 •5 The Workspace: 00:07:00 •6 Customize Your Workspace: 00:07:00 •7 Create a New Document: 00:06:00 •8 Navigating and Zooming: 00:03:00 •9 Setting up Your Document: 00:10:00 •10 Working with Pages: 00:08:00 •11 Working with Multiple Documents: 00:03:00 •12 Challenge: Create a Mock Setup Document: 00:01:00 •13 Assignment Solution: 00:02:00 •14 - Saving and Exporting: 00:05:00 •15 - Creating a Real Estate Listing: 00:01:00 •16- Placeing Image : 00:12:00 •17 - Placing Text: 00:10:00 •18 - Preflighting : 00:05:00 •19- Formatting and Flowing: 00:09:00 •20 Text Wrap: 00:11:00 •21 - Text on Paths: 00:09:00 •22 - Craislist Assignment : 00:02:00 •23 My Version: 00:14:00 •24 Intro Multi -Page Documents: 00:03:00 •25 - Master Pages: 00:09:00 •26 - Page Numbers: 00:04:00 •27 - Master Text Frames: 00:04:00 •28 - Threading Text: 00:08:00 •29 - Placeholder Frames: 00:04:00 •30 - Styles: 00:11:00 •31 - HyperLinks: 00:06:00 •32 - Layer Panel: 00:13:00 •33 - 4 Page Assignment: 00:01:00 •34 - My Version 5 Page: 00:21:00 •35 - Creating a Table: 00:12:00 •36 - Formatting table: 00:16:00 •37 - Assignment Report: 00:01:00 •38 - My Version: 00:18:00 •39 - Color Swatches: 00:07:00 •40 - Additional Tools: 00:10:00 •41- Shapes: 00:05:00 •42 - Keyboard Shortcuts: 00:04:00 •43 - Finishing Work: 00:04:00 •44 - Export Settings: 00:07:00 •45 - Final Project: 00:01:00 •Resource Files - Adobe InDesign Diploma: 00:00:00