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

47234 Courses delivered On Demand

Slack for Business Online Training

4.3(43)

By John Academy

Description Learn to use Slack and get your works done with your team by enrolling the Slack for Business Online Training course. Slack is a cloud-based team collaboration tool that is designed to hold all workplace communication in one place. It connects the team to fulfil and manage their projects. The course teaches you how to communicate effectively across all channels within your organization using the Slack platform. Throughout the course, you will learn how to set up a Slack account and teams and how to communicate with the team members using Slack's communication tools. Communication features such as mentions, announcements, and sharing will also be covered in the course. Then you will learn to search channel, invite members, join and leave channels, or how to rename or customize the channel. The course shows you the techniques of customizing Your Slack experience by creating and configuring notifications. Lastly, the course teaches you how to change users' roles, transferring ownership, exporting team data and deleting teams, etc. 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? Slack for Business Online Training 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 Slack for Business Online Training 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 TOPIC A: Getting to Know Slack 00:30:00 TOPIC B: Working with Slack Teams 00:30:00 TOPIC C: Creating Messages in Channels 00:30:00 TOPIC D: Editing Your Slack Profile 00:30:00 TOPIC: E Getting Help with Slack 00:30:00 Communicating In Channels TOPIC A: Managing Messages 00:30:00 TOPIC B: Doing More with Messages 00:30:00 TOPIC C: Using Threads 00:30:00 Working with Channels TOPIC A: Searching Channels 00:30:00 TOPIC B: Creating Channels 00:30:00 TOPIC C: Customizing Channels 00:30:00 TOPIC D: Managing Channels 00:30:00 Communicating With Slack TOPIC A: Using Direct Messages 00:30:00 TOPIC B: Creating Posts and Snippets 00:30:00 TOPIC C: Adding Files to Slack 00:30:00 TOPIC D: Managing Files 00:30:00 Customizing Your Slack Experience TOPIC A: Customizing Personal Slack Preferences 00:30:00 TOPIC B: Configuring Notifications 00:30:00 TOPIC C: Adding Apps to Slack 00:30:00 Working with Slack Teams TOPIC A: Customizing Your Team 00:30:00 TOPIC B: Customizing Team Settings and Permissions 00:30:00 TOPIC C: Managing Team Membership 00:30:00 TOPIC D: Managing Slack Teams 00:30:00 Assessment Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Slack for Business Online Training
Delivered Online On Demand11 hours 30 minutes
£18

Skype for Business Course

4.3(43)

By John Academy

Description: Skype for Business is a service by Microsoft that helps you to collaborate with anyone, anywhere at any time. This instant messaging collaborative tool is cost-effective and user-friendly. The Skype for Business Course will familiarise you with all the features of the tool. In the course, you will learn how to use Skype for business, the ways of setting location, managing contacts, setting alerts and alert sounds, the process of sending and receiving the instant message, etc. Finally, the course helps you to create audio and video calls, preparing business meetings, and creating the presentation for the conference, and the use of Skype notification area. Learning Outcomes: Discover how to open and close Skype for Business, also ways to sign in and out of your account Set your status on log in or while logged in, add personal notes and set location Manage your contacts by adding internal and external contacts, creating groups, move contacts within groups, add them to favourite groups, block certain contacts, use status and relationship view, and much more Manage alerts by disabling or changing alert sounds, setting up status change alerts, and configuring Do Not Disturb Utilize the instant messages (IM) services by sending and responding to them, using spellchecker, adding emoticons, changing the font and viewing conversation history Examine how to make an audio and video call, record audio or video calls, and change device settings Conduct business meetings using Skype meeting opting through Outlook, joining meetings, setting up impromptu meetings in Skype, and taking notes during a meeting with OneNote Show stakeholders your presentation by learning how to display a PowerPoint presentation, a whiteboard, share screens and programs, post polls and Q&A, send files to participants and share note through Microsoft OneNote Manage advanced settings by turning off all profile pictures, displaying Skype for Business window on top, using Microsoft Skype for Business Recording Manager, and stop Skype for Business from starting up automatically View Skype Notification Area icon, change presence status, sing in and out, and open and close the program 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? Skype for Business 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 Skype for Business 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. Skype for Business Course The Basics 00:30:00 Setting Your Presence and Location 00:45:00 Managing Contacts, Part One 00:45:00 Managing Contacts, Part Two 00:30:00 Alerts and Alert Sounds 00:30:00 Sending and Receiving Instant Messages (IM) 00:30:00 Audio & Video Calls 00:45:00 Skype Meetings 00:30:00 Presenting with Skype for Business, Part One 00:45:00 Presenting with Skype for Business, Part Two 00:45:00 Advanced Settings 00:30:00 Using Skype for Business in the Notification Area 00:30:00 Mock Exam Mock Exam- Skype for Business Course 00:20:00 Final Exam Final Exam- Skype for Business Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Skype for Business Course
Delivered Online On Demand7 hours 55 minutes
£18

Situational Leadership Diploma

4.3(43)

By John Academy

Course Overview Learn all the essential skills to become an expert in Situational Leadership. From this comprehensive Situational Leadership Diploma course, you will be able to understand the principles of Situational Leadership. In the step-by-step training process, you will acquire practical skills along with theoretical knowledge. The Qualified professionals will assist you throughout this learning process. This Situational Leadership Diploma is structured to ensure you have all the adequate skills to secure a position in this competitive industry. You will achieve the confidence and competency to bear all the responsibilities of this profession. The course will add all the right credentials to your resume and increase your employability in this growing industry. Learning Outcomes Be able to identify what each person needs to succeed in their role Be able to apply day-to-day leadership with minimum fuss Choose the best, simple and effective leadership style Be able to set clear and easy-to-follow goals Gain applicable skills to lead a team Who is this course for? Anyone who is now employed in this field or who aspires to be one should take this course. Your knowledge will grow through taking this course, which will also strengthen your resume. To demonstrate your newly gained knowledge, develop crucial abilities and receive a professional credential. 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. Certification After you have successfully completed the course, 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 the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Situational Leadership Diploma course is intended to assist you in obtaining the dream job or maybe the promotion you've always desired. With the assistance and direction of our Situational Leadership Diploma course, learn the vital abilities and knowledge you require to succeed in your life. Unit 01: Introduction to this Course Introduction to Leadership Styles 00:03:00 Exercise 1: What Concerns You Most about Leading Your People? 00:01:00 The Leadership Challenges before You 00:02:00 The Three Types of Leadership Model 00:05:00 Unit 02: Introduction to Situational Leadership The Principle behind Situational Leadership 00:03:00 Exercise 2: Four People 00:02:00 How did You Do? 00:01:00 Exercise 3: How have You been Led in the Past? 00:01:00 The Tannenbaum & Schmidt Leadership Continuum 00:04:00 The Three Factors that Determine Leadership Style 00:03:00 Simplifying your Leadership Model 00:02:00 Unit 03: A Practical Model for Day-to-Day Leadership How you Learned to Drive: The 'Conscious-Competence' Model 00:06:00 Applying Conscious-Competence to Leadership Styles 00:03:00 The First Two Skills You'll Need 00:02:00 Four Leadership Styles for Different Situations 00:06:00 Exercise 4: Put the Model to Work with Four More People 00:01:00 How did You Do? Feedback on Exercise 4 00:06:00 Exercise 5: Briefing 00:01:00 How did You Do? Feedback on Exercise 5 00:06:00 Unit 04: The Skills for Day-to-Day Leadership Styles Three More Skills You'll Need 00:01:00 Task and Goal Setting 00:05:00 Leadership is a Partnership 00:05:00 How to Offer Feedback 00:06:00 Positive Feedback or Negative Feedback 00:03:00 Exercise 6: Skills Audit 00:01:00 Unit 05: Bonus Content Applying Day-to-Day Leadership Skills to a Team 00:05:00 How to Lead a Team through a Transformation 00:02:00 Another Leadership Styles Model 00:09:00 Unit 06: Closing Section Exercise 7: What have You Learned? 00:02:00 Wishing You Well 00:02:00 Assignment Assignment - Situational Leadership Diploma 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Situational Leadership Diploma
Delivered Online On Demand1 hour 39 minutes
£18

Site Management Safety Training

4.3(43)

By John Academy

Course overview Learn the essential site management and security technique from this Site Management Safety Training course and ensure the best and safest working environment for your team. This course will assist you to maintain all the regulation of site management and boost your productivity in no time. The Site Management Safety Training course is one of the most demanding course about site management. You'll get to know abut the skills you need to have to work in the construction sector. You'll learn the rules and regulations of site management, best practices and safety measures. This course will strengthen your basics and enhance your understanding about site management. The interactive and easily understandable lessons will teach you site management techniques effectively. Please Note: This Site Management Safety Training Course isn't endorsed or related to CITB. Therefore, the certificate issued after the successful completion of the course won't be recognised by CITB. Learning outcomes Learn about the principles of site management Know about the safety procedures and its importance in site management Ensure the safety of the staffs while working in a site Be able to assess risk Familiarise with risk management procedures Be able to mitigate risks when working with electricity and scaffolding Learn about the safety in excavation areas and confined spaces Who Is This Course For? Anyone interested in learning site management most efficiently can take this Site Management Safety Training course. The skills gained from this training will provide excellent opportunities for career advancement.  Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £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 and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognised accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Site Management Safety Training 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: Site Managers Property Supervisors Project Managers Site Instructors Security Professionals Site Supervisors Site Management Safety Training Module 01: Health and Safety at Work 00:22:00 Module 02: Site Set-Up 00:34:00 Module 03: Construction Design and Management (CDM) Regulations 00:17:00 Module 04: Risk Identification, Assessment and Management 00:31:00 Module 05: Behavioural Safety 00:22:00 Module 06: Management of Occupational Health 00:34:00 Module 07: Electricity 00:31:00 Module 08: Working at Height 00:29:00 Module 09: Scaffolding 00:21:00 Module 10: Excavations and Confined Space 00:37:00 Module 11: Demolition 00:24:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Site Management Safety Training
Delivered Online On Demand5 hours 2 minutes
£18

SEO Keyword Research Course

4.3(43)

By John Academy

Description Keyword research is the first step in the SEO copywriting process and an essential part of any SEO strategy. Before you write your website content you need to think about which search terms you want to be found for and this means getting inside people's heads to find out which words they use when searching.  The SEO Keyword Research Course starts with the fundamentals and work our way into the advanced (and underutilized) strategies that will give your business an edge over the competition. Through the course you'll have a complete keyword list. You'll know what keywords your audience uses to find you. You'll optimize for the keywords you have the best chances of ranking top 3 with. You'll be able to analyze keyword data and fine-tune your strategy. You will learn pr 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? SEO Keyword Research 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 SEO Keyword Research 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. Module: 01 Introduction FREE 00:02:00 Difference Between Short & Longtail Keywords 00:06:00 What Are Local Keywords 00:02:00 Research vs Buyer Keywords 00:06:00 Google Auto Complete Search Engine 00:02:00 Module: 02 Free Software Walkthrough 00:03:00 Using Keyword Planner 00:05:00 Keyword Planner Sorting 00:10:00 LongTail Pro Keyword Research 00:10:00 KW Finder Keyword Research 00:05:00 Free Keyword Search Volume Tool 00:01:00 Mouse Recorder 00:04:00 Module: 03 How to Deliver Keyword Research as a Freelancer 00:10:00 Optimize an Article 00:20:00 Optimize Readability 00:08:00 WordPress Permalink Settings 00:01:00 Yoast Real-Time Analysis for Any Site 00:02:00 Real-Time Ranking Case Study 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

SEO Keyword Research Course
Delivered Online On Demand1 hour 45 minutes
£18

SEO Google Image Training Course

4.3(43)

By John Academy

Description The SEO Google Image Training Course is designed to teach you 3 new ways to get traffic to your website: 1) You will be able to rank every one of the pages on your website a little higher by doing correct SEO tagging of your images. 2) You will be able to rank in image search and get traffic from Google image search. 3) You will understand how image size inside your web pages affects the image rendering, and you will be able to make ideal social media posts that render perfectly no matter which social network you are posting on, and by rendering perfectly, you'll have a nicer post which gets more engagement and more traffic to your website. Through the course, you will be able to understand the benefits of image SEO. You will discover the Most Important Ranking Factors for Image SEO. You will learn how to Perform Image Optimization (including removing EXIF data, compressing file sizes and more!) 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? SEO Google Image Training 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 SEO Google Image Training 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. Module: 01 1. Introduction FREE 00:01:00 2. Traditional SEO vs Image SEO 00:05:00 3. What is EXIF Data and How to Remove It 00:08:00 4. Image File Size Optimization 00:11:00 5. JPG vs PNG 00:02:00 Module: 02 6. GIF Images 00:02:00 7. Captions for Conversion Optimization 00:06:00 8. Name and ALT SEO 00:05:00 9. Adding ALT Tags to Images 00:01:00 10. Create a Sitemap for Images 00:04:00 Module: 03 11. Using KW Planner 00:06:00 12. The Goal of Image SEO 00:04:00 13. Google Image Off-Page SEO 00:07:00 14. WP Fastest Cache Settings 00:05:00 15. WordPress Cache Speed Test 00:01:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

SEO Google Image Training Course
Delivered Online On Demand1 hour 8 minutes
£18

SEO Auditing Training Course

4.3(43)

By John Academy

Description If you are looking to perform an SEO Site Audit and want to grasp everything about it from A to Z, then you may have a look at this SEO Auditing Training Course. An SEO Audit covers essential components of a website such as content-related issues, indexing, site architecture, backlink analysis, social-media engagement, etc. Learn to evaluate your website's search engine kindliness and visibility with an SEO Audit. This course is a step by step guide to arrange your entire site and create a spreadsheet of all your pages and their SEO elements. You will gain an understanding of your share of the SEO market while recognizing how influential your website is optimized to achieve an added market share. This course will be ideal to understand the complex process of SEO Audits in a simplistic way. 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? SEO Auditing Training 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 SEO Auditing Training 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. Module: 01 Starting Your SEO Audit FREE 00:47:00 SEO Audit Software Walkthrough 01:02:00 Keyword Planner 00:08:00 Free Keyword Research Tool 00:06:00 Paid Keyword Research Tool 00:07:00 Module: 02 WordPress Fastest Cache Settings 00:05:00 Yoast Real-Time Analysis for Any Site 00:02:00 WordPress Cache Speed Test 00:01:00 Real-Time Ranking Case Study 00:08:00 All In One SEO Plugin 00:03:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

SEO Auditing Training Course
Delivered Online On Demand2 hours 29 minutes
£18

Advanced Excel Models using Formulas, VBA & Power Query

4.3(43)

By John Academy

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £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 and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query 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: Data Analyst System Support and Reporting Analyst 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 Thankyou 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 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Excel Models using Formulas, VBA & Power Query
Delivered Online On Demand6 hours 8 minutes
£18

Advanced Business Productivity Training Course

4.3(43)

By John Academy

Course overview We often start a workday with a plan but find ourselves distracted while working. Sometimes, we fail to take back control of time which decreases productivity. If you wish to overcome such issues, take the Advanced Business Productivity Training Course and discover the secret to exceptional business productivity. This Advanced Business Productivity Training Course will guide you in every possible way to help you make the most out of your workday. You will get excellent training on productivity, project management, teamwork, and communication. You will identify what factors can cause productivity to fall and how to overcome them for business growth. You will be able to form productive teams and take all necessary steps to ensure the success of your business.  Enroll right now and elevate your business to the next level! Learning outcomes Identify what factors increase business productivity Determine the causes of low productivity and their impact on business growth Be able to improve staff involvement Gain the skills in project management Understand the importance of communication in business Learn how to improve team efficiency Who Is This Course For? This Advanced Business Productivity Training Course is highly beneficial for anyone interested in learning the excellent techniques to drive business productivity. The skills gained from this training will provide excellent opportunities for career advancement.  Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £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 and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Business Productivity Training 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: Leader Manager Team Leader Module 01: Introduction Prof. Paul Course Intro 00:03:00 Module 02: Productivity Training Productivity Part 1 00:12:00 Productivity Part 2 00:12:00 Productivity Part 3 00:13:00 Module 03: Project Management Training Project Management Part 1 00:15:00 Project Management Part 2 00:17:00 Module 04: Teamwork Training Teamwork Stats & Beginning Concepts 00:09:00 Teamwork - Part 1 00:09:00 Teamwork - Part 2 00:09:00 Teamwork - Part 3 00:13:00 Module 05: Communication Training Communication Stats & Beginning Concepts 00:09:00 Communication - Part 1 00:09:00 Communication - Part 2 00:09:00 Communication - Part 3 00:09:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Business Productivity Training Course
Delivered Online On Demand2 hours 28 minutes
£18

Advanced Business Networking & MLM Course

4.3(43)

By John Academy

Do you have a desire to meet new people and form beneficial business relationships? If yes, then enrol now and benefit from this course. Description: If you are in business you require every one of the customers you can get, am I right? If you want to do your best in your professional career then you have to meet and connect with the right people, am I right? You know very well that networking can enable you to do various things, that is why you're taking a look at this outline. This course will provide you with an overview, of a networking procedure. It will also introduce you to some excellent tips and techniques that will help you gain more clients make more money and progress further in your professional career. Who is this course for? Technical or professional - who do not feel entirely comfortable in networking situations. Network marketers with frequent customer contact who require better aptitudes to use potential business openings without selling. Managers with new duties around customer confronting activities who lack confidence. 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: Advanced Business Networking Course is a useful qualification to possess, and would be beneficial for the following professionals: Secretary. Receptionist. Office Administrator. Personal Assistant. Office supervisor. Team leader. Office Manager. Advanced Business Networking Course Introduction To Business Networking 00:15:00 How To Run A Successful Multilevel Marketing Business 01:00:00 Tips For Network Marketing Success 01:00:00 Benefits Of Outsourcing 01:00:00 Advantages Of Outsourcing Your Prospecting Efforts In MLM 01:00:00 Process Of Online Outsourcing Work 00:30:00 Outsourcing Tips For Network Marketers 01:00:00 Upgrade Your MLM Campaign With Outsourcing 00:30:00 Where Do Marketers Outsource Their Jobs? 01:00:00 Way To Start With Outsourcing A Job 00:30:00 Way To Pay Your Hired Staff When You Outsource 00:30:00 Building A Team Through Outsourcing Business 01:00:00 How To Make The Most Of Your Outsourcing 01:00:00 About Getting Revisions For Your Outsourced Work 00:30:00 What You Must Never Outsource 00:30:00 Important Tips For Outsourcing 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Business Networking & MLM Course
Delivered Online On Demand11 hours 45 minutes
£18