5982 Courses delivered Online

This course has been designed to provide you with the fundamental principles all successful managers use, practical insight from an experienced practitioner, tips that can be applied to any management challenge and expert advice. Description: This course is wisely designed for leaders who are looking forward to becoming successful. Through this course, you will learn to decide whether you as a boss want to be loved or feared. You as students will also learn about the importance of knowing your employees more carefully. You will also learn about the significance of motivation at the workplace and how will the business benefit from it. You will also be taught about the fundamental of a good leadership and how to imply these on your business. Who is the course for? Leaders who are looking forward to becoming successful. 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: Management Training: How to Be a Better Boss course will be very beneficial and helpful especially to the following careers: Leadership development program manager. Business owners. Business managers. Team leaders. Instructor. Counsellor. And much more. Management Training: How to Be a Better Boss - Updated Version Module 1: Understanding Management and Leadership 00:40:00 Module 2: Leadership Theories 00:25:00 Module 3: Improving Management and Leadership Performance 00:15:00 Module 4: High Performance Teams 00:32:00 Module 5: Motivating Employees 00:26:00 Module 6: Organisational Skills 00:26:00 Module 7: Talent Management 00:37:00 Module 8: Succession Planning 00:24:00 Module 9: Business Process Management 00:29:00 Module 10: Communication Skills 00:28:00 Module 11: Negotiation Techniques 00:15:00 Module 12: Managing Meetings and Giving Feedback 00:22:00 Module 13: Managing Change 00:22:00 Module 14: Time Management 00:37:00 Module 15: Stress Management 00:15:00 Module 16: Emotional Intelligence in Leadership 00:32:00 Module 17: Managing Conflict 00:14:00 Module 18: Dealing with Office Politics 00:34:00 Module 19: Risk Management 00:35:00 Module 20: Corporate Responsibility and Ethics 00:14:00 Management Training: How to Be a Better Boss - Old Version Module One - Getting Started 01:00:00 Module Two - Is it Better to be Loved or Feared 00:30:00 Module Three - Leadership as Service 01:00:00 Module Four - Leadership by Design 00:30:00 Module Five - Understanding Motivation 00:30:00 Module Six - Constructive Criticism 01:00:00 Module Seven - The Importance of Tone 00:30:00 Module Eight - Trusting Your Team 01:00:00 Module Nine - Earning the Trust of Your Team 01:00:00 Module Ten - Building and Reinforcing Your Team 01:00:00 Module Eleven - You are the Boss of You 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities Management Training: How to Be a Better Boss- Activities 00:00:00 Mock Exam Mock Exam- Management Training: How to Be a Better Boss 00:20:00 Final Exam Final Exam- Management Training: How to Be a Better Boss 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Julia is one of the highest performing programming languages. The Tutorials - The Julia Programming Language course is designed to train you in this valuable programing language. In this course, you will get equipped with the skills to code in Julia and add available skill sets to your resume. The Tutorials - The Julia Programming Language course will introduce you to the basic principles of Julia programming language. In this course, you will learn the steps to install Julia. You will get introduced to Julia variables, integers, sign function and more. The course will provide you with lectures based on Cher types and strings. You will start to understand all the functions of this programming language. The course will give you an extensive understanding of Julia Dict and type. By the end of the course, you will pick up all the valuable information and skills to use this language. Learn the ins and outs of Julia programming language from the Tutorials - The Julia Programming Language course. This course will increase your abilities and boost your employability in the relevant industry. Learning Outcomes Understand the process of installing Julia Familiarize yourself with Julia variables and functions Enrich your understanding of Cher types and strings Learn the details of conditional and non-conditional blocks Grasp the skills essential for Juila Dict operations Who is this course for? This Tutorials - The Julia Programming Language course is suitable for programmers, data scientists, or individuals who want to learn a new programming language. 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 Tutorials - The Julia Programming Language course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Programmer Data Scientist Introduction Learning Julia 00:01:00 Installing Julia 00:06:00 Installing Juno 00:04:00 Begin Dancing with Julia Julia Variables 00:05:00 Julia Integers and Floats 00:05:00 Julia Convert and Comparisons 00:03:00 Rounding Operations 00:05:00 Division Function 00:04:00 Sign Function and Power 00:05:00 Complex and Rational Numbers 00:05:00 Julia Chars and Strings Julia Char type 00:03:00 String Literals 00:02:00 Extract Char and String 00:02:00 Concatenate and Interpolate 00:03:00 isEqual and Comparisons 00:04:00 Find and OccursIn 00:05:00 Repeat and Regex 00:04:00 Julia Functions Julia Function Object 00:04:00 Function Return Type 00:06:00 Functions as Objects and Arguments 00:04:00 Operators as Functions 00:02:00 Anonymous Function 00:04:00 Function Arguments Tuples 00:05:00 Unpacking Tuples 00:02:00 Varargs 00:03:00 Optional Arguments 00:03:00 Keyword Arguments 00:03:00 Conditional and Non-Conditional Blocks Do Block 00:04:00 Compound Expression 00:02:00 If Statements 00:05:00 If Statement Return Value 00:02:00 Short Circuit Evaluation 00:03:00 Loops and Exceptions For Loop 00:02:00 Control and Nest For Loops 00:03:00 Exceptions 00:03:00 Julia Try and Catch 00:03:00 While Loop 00:02:00 Variable Scope 00:05:00 Arrays in Julia Arrays 00:04:00 Pop and Push 00:03:00 Multidimensional Arrays 00:03:00 Copying Arrays 00:02:00 Julia Dicts Dicts 00:02:00 Dict Operations 00:02:00 More Dict Operations 00:04:00 More Cool Dict Operations 00:03:00 One More Cool Dict Operation 00:04:00 Broadcasting 00:04:00 Julia Types Julia Types 00:01:00 Verify and Specify Types 00:03:00 More Verification and Specification 00:05:00 Julia Methods 00:02:00 Composite Types 00:05:00 Mutable Structs 00:02:00 Constructor Functions 00:04:00 Modules and Packages Julia Modules 00:02:00 Using Packages 00:04:00 User Defined Modules 00:05:00 Working with Text Files Reading Text Files 00:04:00 Writing To Text Files 00:03:00 Writing Collections To Files 00:02:00 Julia Date and Time Date And Time 00:03:00 Date Queries 00:02:00 Date Arithmetic 00:03:00 Meta Programming in Julia Meta Programming 00:02:00 Quoted Expression 00:04:00 Macros 00:02:00 REST APIs and MySQL Using Genie 00:04:00 Payloads and POST Requests 00:05:00 Julia and MySQL 00:08:00 DataFrames and Plots DataFrames 00:05:00 Plotting with Plots 00:02:00 Where to go from here 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Windows 10 comes with different and effective features. But most often users get in trouble. Don't worry. Our Windows 10 End User course will assist you to learn all the difficulties in very easy ways. The Windows 10 End User course incorporates some basic issues of Microsoft Windows 10 operating methods to make you acquainted with its functions. The course assists you to know how to customize, personalize, and execute different areas of Windows 10. It teaches you also how to explore files, maps, operate mail, calendar, and weather features. It also teaches how to update, install, and find out troubleshoot from the applications. He makes you familiar with different programs like Microsoft Word, Excel, and PowerPoint etc. it teaches you internet browsing and other effective relevant features. 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? Windows 10 End User 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 Windows 10 End User 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:01:00 Logging In 00:02:00 The Startup Screen 00:03:00 Exploring the Desktop 00:02:00 General Navigation 00:04:00 Introducing the Action Center and Control Panel 00:02:00 Launching Applications 00:03:00 Interacting with Windows 00:06:00 Quitting Applications 00:04:00 Pinning Applications 00:03:00 Customizing the Start Menu 00:03:00 Module: 02 Customizing the Task Bar 00:02:00 Multitasking to Switch Between Multiple Applications 00:03:00 Managing several deskstops Using Task View 00:03:00 Overview of the drive and folder structure 00:04:00 Using Navigation Pane, Details Pane, Preview Pane 00:04:00 Menus and Ribbons 00:03:00 Viewing and Editing File Properties_Revised 00:04:00 Creating Files 00:06:00 Selecting, Moving, and Copying Files_Revised 00:06:00 Renaming Files and Folders 00:03:00 Deleting and Restoring from the Recycle Bin 00:05:00 Module: 03 Create and use shortcuts_Revised 00:05:00 Zip and Unzip 00:07:00 Changing the Sort and Group by 00:06:00 Add Columns to the Explorer View 00:04:00 Creating and Using a Library 00:07:00 Pin Frequent Places Customizing File Explorer 00:04:00 Configuring Files and Explore Options 00:03:00 Logging In or Setting Up OneDrive 00:02:00 Storing and acessing files on OneDrive 00:03:00 Sharing Files Through OneDrive 00:05:00 Syncing Files on OneDrive 00:03:00 Module: 04 Browsing the Web 00:02:00 Customize Top Sites 00:02:00 Using Tabs 00:03:00 Add and Use Favorites 00:03:00 Organize Favorites with Folders 00:02:00 Background Settings 00:04:00 Lock Screen 00:02:00 Change Windows Themes 00:02:00 Personalize Start 00:04:00 Change Screen Resolution 00:02:00 Module: 05 Adjust Notifications and Actions 00:02:00 Course Recap Complete 00:01:00 Course Recap Complete 00:01:00 Mail Send a Message 00:04:00 Adding & Editing- Contacts & Accounts 00:05:00 People Search Link and Share Contacts 00:04:00 Calendar Configuring and Viewing 00:04:00 Calendar Changing Views Creating and Editing Events 00:07:00 Weather Add Favorite Locations and Viewing the Weather 00:04:00 Adjust Audio Settings 00:02:00 Managing Accounts and Sign In Options 00:03:00 Module: 06 Weather- Viewing Historical Data nad Weather Maps 00:03:00 Installing Applications from the Windows Store 00:03:00 Tablet Mode 00:03:00 Using Saving Sharing Web Notes 00:04:00 Downloading Files 00:02:00 Viewing and Clearing History 00:02:00 Cortana Setup 00:03:00 Using Cortana 00:03:00 Maps- Search Get Directions Choose View 00:04:00 Maps- Search Tips and Favorites 00:04:00 Module: 07 Maps- More Search Tips and Map Settings 00:03:00 Photos - Browsing_REVISED 00:05:00 Photos - Using Editing Tools_REVISED 00:04:00 Mail- Add Accounts 00:05:00 Mail- Personalizing and Configuring- 00:04:00 Installing Applications From the Web 00:03:00 Setting Application Defaults 00:03:00 Setting App Privacy and Permissions 00:02:00 Uninstalling Applications 00:01:00 Configure Windows Defender and Windows Updates 00:02:00 Module: 08 Backing Up and Restoring Files and Using Recover to Reset Your PC 00:07:00 Access Task Manage 00:02:00 Accessing the Action Center to View Messages 00:02:00 Manage Sleep and Screen Saver 00:03:00 Managing Devices 00:03:00 Change Type Settings 00:01:00 Adjust Mouse and Touchpad Settings 00:03:00 Adjust Autoplay Settings 00:02:00 Adding Files to a Library 00:09:00 Change Default Storage Locations 00:02:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Master the art of Virtual Team Building & Management, fostering collaboration and efficiency in remote work environments. Equip yourself with essential skills for leading virtual teams.

Course Overview Do you want to master the fascinating skill of landscape photography and establish your career as a nature photographer? Learn landscape photography from the Landscape Photography Advanced Diploma course and take the first step towards starting your promising career as a landscape photographer.  The Landscape Photography Advanced Diploma course is one of the most demanding courses for photographers. You will learn about the equipment, basics of landscape and nature photography, different lighting conditions, basic and advanced composition, different strategies and tips to skyrocket your learning ability. This is helpful for anyone to understand the basics of landscape photography and practice them. This course will teach you how to capture stunning landscape pictures from scratch. The course is ideal for nature photographers, photo editors, travelers, travel vloggers, bloggers, videographers or anyone who wants to learn the skill of landscape photography. Who is this course for? This online course is for anyone who wants to learn more about landscape photography. This course will help learners from any level to learn landscape photography. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. A good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. You can also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at £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 Landscape Photography Advanced Diploma is a useful qualification to possess and would be beneficial for any related profession or industry such as: Nature Photography Photo Editing Travel Vlogging Blogging Videography Unit 01: Introduction Module 01: Introduction to Nature Photography 00:02:00 Module 02: What Is Landscape Photography? 00:01:00 Unit 02: Photography Equipment Module 01: Overall 00:01:00 Module 02: Camera 00:02:00 Module 03: Sensors 00:02:00 Module 04: Lenses 00:03:00 Module 05: Pro vs Budget Lenses 00:03:00 Module 06: Prime Lenses 00:02:00 Module 07: Tripod 00:03:00 Module 08: Filters 00:02:00 Module 09: Other Accessories 00:04:00 Unit 03: Camera Basic Module 01: Introduction 00:01:00 Module 02: ISO 00:03:00 Module 03: ISO Practical 00:03:00 Module 04: ISO Practical Night 00:02:00 Module 05: Shutter Speed 00:01:00 Module 06: Practical of Shutter Speed 00:03:00 Module 07: Shutter Speed Waterfall 00:04:00 Module 08: Aperture 00:03:00 Module 09: Practical Aperture 00:05:00 Module 10: Aperture Low Light Photography 00:03:00 Module 11: Exposure Triangle 00:03:00 Module 12: Aperture Priority 00:03:00 Unit 04: Advanced Camera Basics Module 01: Introduction 00:02:00 Module 02: Histogram 00:03:00 Module 03: Expose to the Right 00:02:00 Module 04: Metering Modes 00:02:00 Module 05: Exposure Compensation 00:02:00 Module 06: RAW vs JPEG 00:03:00 Module 07: What is RAW? 00:02:00 Module 08: Dynamic Range 00:03:00 Module 09: White Balance 00:03:00 Unit 05: Focusing Module 01: Introduction to Focusing 00:01:00 Module 02: Hyperfocal Distance vs Single Point 00:03:00 Module 03: Aperture in Focusing 00:02:00 Module 04: Aperture, Focusing & Lens 00:03:00 Module 05: Focusing with a Wide-Angle Lens 00:05:00 Module 06: Focusing For Telephoto Photography 00:04:00 Unit 06: Filters Module 01: What is a Polarizing Filter? 00:02:00 Module 02: How a Polarizer Works Near Waterfalls 00:03:00 Module 03: How a Polarizer Works Reducing Haze 00:03:00 Module 04: What is Nd Filter? 00:02:00 Module 05: Nd Filter to Achieve Silky Water 00:04:00 Module 06: What is Color Cast? 00:02:00 Unit 07: Exposure Module 01: Introduction to Exposure 00:01:00 Module 02: Dynamic Range & Expose to the Right 00:04:00 Module 03: The Impact of Light in Photography 00:03:00 Module 04: Finding the Correct Light 00:04:00 Module 05: Single Exposure Sunset 00:04:00 Module 06: Why Exposure Bracketing Helps You to Take Better Image 00:05:00 Unit 08: Composition Module 01: Introduction 00:01:00 Module 02: Element of Composition 00:03:00 Module 03: Rules of Third 00:04:00 Module 04: Farming a Subject 00:02:00 Module 05: Leading Lines 00:05:00 Module 06: Diagonals 00:03:00 Module 07: Using S and Z curves 00:05:00 Module 08: Changing Perspective with Different Focal Ranges 00:05:00 Module 09: Changing Perspective through Framing 00:02:00 Module 10: Simple Reflection Photography 00:03:00 Unit 09: Advanced Composition Module 01: Wide-Angle Photography 00:04:00 Module 02: Telephoto Photography 00:06:00 Module 03: Focus Stacking 00:12:00 Module 04: Panoramic 00:07:00 Module 05: Creating Scales 00:03:00 Module 06: Minimalist Nature Photography 00:04:00 Module 07: Creating Leading Lines from Long Exposure 00:04:00 Unit 10: Photo Editing Module 01: Introduction to Photo Editing 00:01:00 Module 02: Editing in Lightroom 00:06:00 Module 03: Global Adjustment 00:21:00 Module 04: Local Adjustment 00:12:00 Module 05: Histogram (Expose to the Right) 00:07:00 Module 06: Grab Filter Effect 00:12:00 Module 07: Editing an Image like a Professional 00:17:00 Module 08: How to Focus Stack 00:12:00 Module 09: How to Remove Color Cast 00:04:00 Module 10: How to Blend Multiple Image 00:05:00 Module 11: How to Stitch a Pano 00:07:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Math is one of the most essential skills in all aspects of our lives. However, it can be one of the most difficult for many of us to master. Learning math can be a daunting task when you do not have the right tools or the right materials, especially if you grew up believing that math is hard and that you will never understand it. The Mathematics for Beginners is designed to teach the elementary skills necessary to manipulate algebraic expressions and equations, and also places a strong emphasis on conceptual understanding. You will learn the connection between everyday life problems and the abstract world of mathematics. Using applied examples from a wide variety of topics ranging from finance to physics and life sciences, you will gain the ability to transform problems from a verbal description into the language of mathematics and solve them confidently by applying the rules of algebra. 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? Mathematics for Beginners 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 Mathematics for Beginners 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. Integers ( Directed Numbers) Lecture 1 Introduction 00:02:00 Lecture 2 Quick glance at number system 00:05:00 Lecture 3 Integers and ordering of integers 00:06:00 Lecture 4 Addition and Subtractions of Integers 00:07:00 Lecture 5 Operations on Integers 00:04:00 Lecture 6 Multiplication and Division of Integers 00:04:00 Lecture 7 Powers of Integers (Exponents) 00:04:00 Factors and Multiples Lecture 8 Complete knowledge about factors and multiples 00:06:00 Lecture 9 Divisibility tests for 2,3,4,5,6 00:07:00 Lecture 10 Divisibility rules 7,8,9,10,11 00:06:00 Lecture 11 Prime Factorization 00:06:00 Lecture 12 Highest Common Factor HCF 00:10:00 Lecture 13 Least Common Multiple LCM 00:16:00 Lecture 14 Relation between LCM and HCF 00:04:00 Fractions Lecture 15 Classification of Fractions 00:04:00 Lecture 16 Convert mixed to improper and improper to mixed fractions 00:03:00 Lecture 17 Equivalent Fractions 00:04:00 Lecture 18 Comparing Fractions after converting to like fractions 00:09:00 Lecture 19 Reducing a fraction to lowest term 00:04:00 Lecture 20 Addition and subtraction OF fractions 00:08:00 Lecture 21 Multiplication and division of fractions 00:11:00 Lecture 22 Word problems on fractions 00:16:00 Simplification Rule : BODMAS Lecture 23 BODMAS and rules to remove brackets 00:03:00 Lecture 24 Simplify expressions using BODMAS rules 00:05:00 Lecture 25 Simplify expressions involving fractions using BODMAS 00:07:00 Decimal numbers Lecture 26 Decimal numbers in relation to fractions 00:08:00 Lecture 27 Like and unlike Decimals 00:05:00 Lecture 28 Ordering of Decimal numbers 00:10:00 Lecture 29 Addition and subtraction of Decimal 00:07:00 Lecture 30 Multiplication of Decimal 00:03:00 Lecture 31 Division of Decimal 00:05:00 Rational Numbers Lecture 32 Rational number 00:02:00 Lecture 33 Representation of Rational Numbers on Number line 00:04:00 Lecture 34 Determining which fraction is terminating or non terminating 00:05:00 Lecture 35 shortcut method of writing decimal expansion of fraction to decimal 00:08:00 Approximation Lecture 36 Rounding to whole number 00:06:00 Lecture 37 Rounding to required number of decimals (1 d.p. ) 00:05:00 Lecture 38 rounding to significant digits 00:07:00 Lecture 39 Practice question on three methods of approximation 00:05:00 Estimation and Scientific Notation or Standard form Lecture 40 Estimation 00:05:00 Lecture 41 Scientific Notation 00:07:00 Lecture 42 Operation on numbers when they are in scientific notation 00:06:00 Percentage Lecture 43 Percentage to fraction and fraction to percentage 00:06:00 Lecture 44 Percentage of a quantity and conversation to decimal 00:06:00 Lecture 45 Expressing one quantity as percentage of another quantity 00:06:00 Lecture 46 Finding increase decrease percent 00:05:00 Lecture 47 Uses of percentages-Word Problems 00:09:00 Ratio and Proportion Lecture 48 Ratio- How to express as simple ratio 00:09:00 Lecture 49 How to compare Ratios 00:04:00 Lecture 50 Word problems on finding ratios 00:07:00 Lecture 51To divide a given quantity into a given Ratio 00:11:00 Lecture 52 Proportion 00:04:00 Lecture 53 Practice problems on Proportion 00:06:00 Lecture 54 Continued proportion 00:06:00 Unitary Method and its Applications Lecture 55 Direct Variation ( or proportion) 00:04:00 Lecture 56 Problems based on Direct proportion 00:10:00 Lecture 57 Inverse Variation ( or proportion) 00:10:00 Lecture 58 Multiple Ratios 00:10:00 Profit , Loss, discount and Tax Lecture 59 Basics - Profit and Loss 00:04:00 Lecture 60 More practice problems on Profit & Loss 00:06:00 Lecture 61 Selling price formula and Problems 00:04:00 Lecture 62 Cost price formula and Problems 00:03:00 Lecture 63 Higher problems on Profit and Loss 00:08:00 Lecture 64 Basics - Discount.mp4 00:05:00 Lecture 65 Practice problems on Discount 00:04:00 Lecture 66 Tax 00:06:00 Resources Resources - Mathematics for Beginners 00:00:00 Mock Exam Mock Exam - Mathematics for Beginners 00:20:00 Final Exam Final Exam - Mathematics for Beginners 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Description: Beats Electronics - popularly known for selling headphones - spend ninety percent of their budget in marketing. That is why they have great sales year after year, and why they can sell their products at a high price for the brand alone. If you want to keep up with trends and reach billions of people with the ease of the internet, this CPD Certified Diploma in Digital Marketing course is for you. The course is divided into multiple sections, wherein the first section you learn about sales and marketing. You also learn about the nature of internet marketing, affiliate marketing, competition, research and niches. You then move to the second portion of the course, where you discover more about traffic, article marketing and search engine optimization. Next, you look further into marketing using Blogs in WordPress, through emails and strategies towards internet marketing. Finally, you explore the possibilities of digital marketing using social media sites like LinkedIn, Twitter, Facebook, etc. This course is going to help you understand the basic ideas behind digital marketing and discover more ways for you to spread your brand worldwide. Gain your accreditation today! Who is the course for? Businesses who want to take advantage of the internet in order to push for digital marketing Professional marketers looking to expand their knowledge in digital marketing 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 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: Diploma in Digital Marketing is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Marketing and Promotion Specialists Entrepreneurs Sales Managers Marketing Managers Module 01 Sales and Marketing 00:30:00 How Internet Marketing Works 01:00:00 How To Make Money With Internet Marketing 01:00:00 What is Affiliate Marketing 00:30:00 Competition in Internet Marketing 00:30:00 Researching in Internet Marketing 01:00:00 Desperate Niches 00:30:00 Profitable Niches 00:30:00 Module 02 Clickbank 00:30:00 What is Traffic? 00:30:00 Traffic vs. Relevance 00:30:00 Article Marketing 01:00:00 Paid forms of Traffic - 1 01:00:00 Paid forms of Traffic - 2 01:00:00 Search Engine Optimization 00:30:00 Search Engine Optimization 2 00:30:00 Module 03 Best SEO Practice 02:00:00 Blogs - WordPress 01:00:00 Blogs - WordPress II 03:00:00 Email Marketing I 00:30:00 Email Marketing II 01:00:00 Internet Marketing Strategy I 01:00:00 Your own website vs free options online I 00:30:00 Your own website vs free options online II 01:00:00 Module 04 What Are Niche Website? 01:00:00 The Role Of Visualization In Education 00:15:00 Identify Your Best Platform Or Software 01:00:00 Select A Web Host 01:00:00 Collect Your Site 00:15:00 Building A Content Rich Website 00:15:00 Build Backlinks 00:30:00 Use SEO, Multimedia And Social Sites 01:30:00 Use Analytics 01:00:00 Wrapping Up 00:15:00 Module 05 Introduction 00:30:00 Understanding the Value of Social Media Buzz and What It Can Do For Your Business 01:00:00 Developing a Winning Social Media Marketing Plan 01:00:00 Setup and Manage a Facebook Page That Works 01:00:00 Tweet Your Way to Online Prominence 01:00:00 Build Your Network with LinkedIn 01:00:00 Captivate Your Audience with YouTube 01:00:00 Conclusion 00:15:00 Module 06 Introduction to Email Marketing 00:30:00 Using Email Marketing Software 00:30:00 Building Email Lists by Quantity 00:30:00 Building Email Lists by Quality 00:30:00 Crafting an Email 01:00:00 Analyzing and Tracking Your Email Marketing Strategy 00:30:00 Module 07 Introduction to Facebook 00:15:00 Why You Should Care 00:15:00 Setting up a Facebook Page 00:30:00 How to Get More Likes for Your Facebook Page 00:30:00 Facebook Advertising 00:30:00 How Much Does Facebook Advertising Cost? 00:30:00 Marketing on Facebook 01:00:00 Create a Content Calendar 00:15:00 Understanding Edge Rank & the Art of Engagement 00:15:00 Module 08 TWITTER FOR BUSINESS 00:15:00 TOP TWITTER TIPS 00:15:00 TWITTER IS 00:15:00 BUSINESS TERMS 00:15:00 WHY USE TWITTER FOR MARKETING 00:15:00 TWITTER MARKETING BASICS 01:00:00 TWITTER METRICS 00:30:00 YOUR BIO 00:15:00 WHEN TO TWEET 00:15:00 BUILDING YOUR COMMUNITY 00:15:00 GENERATING LEADS 00:15:00 REAL-TIME TWITTER MARKETING 00:15:00 ENGAGEMENT 00:15:00 TWETIQUETTE (TWEETING ETIQUETTE) 00:15:00 Module 09 What is Instagram? 00:15:00 Instagram for Business 00:15:00 Instagram & Community 00:15:00 Recommended Reading Recommended Reading: Diploma in Digital Marketing 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Diploma in Digital Marketing 00:30:00 Final Exam Final Exam- Diploma in Digital Marketing 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Be an expert in MS SharePoint knowing the key issues of this app from the MS SharePoint 2016 Site User course. The course can solve your different problems in MS SharePoint and make you an efficient in this field.   The MS SharePoint 2016 Site User course incorporates some effective methods of SharePoint interface and functions to teach the students easily. The course assists the students to know how to identify sites, run libraries and lists, and work with library documents. The course enables them to know about library setting incorporating the ideas of alert, check in and out of documents, and creation of calendar list, contact lists, and task list along with the relevant work of list setting. The purpose of the course is to enhance the SharePoint expertise knowing the fact of different views, use of newsfeed, and other MS office products. 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? MS SharePoint 2016 Site User 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 MS SharePoint 2016 Site User is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:01:00 SharePoint Overview SharePoint Overview 00:04:00 Accessing SharePoint Sites 00:02:00 Sharepoint Interface and Navigation 00:08:00 Using the Open Menu 00:02:00 Using the Details Pane 00:01:00 Overview of SharePoint Permissions for Site Users 00:05:00 Locating Sites, Libraries, and Lists 00:04:00 Searching for SharePoint Content 00:04:00 Working with Document Libraries SharePoint Library Overview 00:04:00 Viewing and Downloading a Document from a Library 00:03:00 Uploading Items to a Document Library 00:03:00 Syncing a Library 00:03:00 Creating and Saving New Documents 00:04:00 Editing a Document 00:03:00 Creating a New Folder 00:03:00 Uploading and Moving Document into a Folder 00:01:00 Moving Document to Another Library 00:01:00 Pin to Top 00:02:00 Renaming Documents or Folders 00:02:00 Deleting Documents or Folders 00:02:00 Restoring a Document from the Recycle 00:02:00 Working with Document Library Settings Viewing Permissions for a Document 00:03:00 Version History Overview 00:03:00 Viewing, Comparing, and Restoring Prior Document Versions 00:04:00 Check In or Check Out Overview 00:03:00 Checking Out or Checking In a Document 00:03:00 Editing a Document with Check In or Check Out Enabled 00:03:00 Uploading a File to a Library with Check In or Check Out Enabled 00:02:00 Discarding a Check Out 00:02:00 Setting an Alert on a Document 00:03:00 Setting an Alert on a Library 00:03:00 Modifying or Deleting Alert Subscriptions 00:03:00 Changing View Column Settings 00:03:00 Sorting and Filtering Library Content 00:03:00 Sharing Links Including Durable Links 00:04:00 Working with Properties 00:02:00 Adding and Editing Properties 00:03:00 Adding and Editing Properties while Editing in Office 00:02:00 Narrowing a Document Search Result by Properties 00:02:00 Working with SharePoint Lists SharePoint List Overview 00:03:00 Adding an Item to a List 00:02:00 Adding an Item to a Contact List 00:01:00 Adding an Item to a Calendar 00:02:00 Creating a Recurring Calendar Event 00:02:00 Adding an Item to a Task List 00:03:00 Adding an Item to a Links List 00:02:00 Adding an Announcement 00:03:00 Attaching Content to an Announcement 00:04:00 Editing or Deleting a List Item 00:02:00 Editing or Deleting a Contact 00:02:00 Editing or Deleting a Calendar Event 00:04:00 Editing or Deleting a Task 00:03:00 Editing or Deleting an Announcement 00:02:00 Editing or Deleting a Link 00:01:00 Working with List Settings Adding and Editing Items Using Quick Edit 00:04:00 Sorting and Filtering List Items 00:03:00 Copying and Pasting Excel Info into a List 00:03:00 Exporting List Data into Excel 00:03:00 Creating an Alert for a List Item 00:03:00 Creating an Alert for a List 00:04:00 Enhancing the SharePoint Experience Working with Library or List Views 00:05:00 Creating Public or Personal Standard Views 00:10:00 Using Task Views 00:04:00 Creating a Views 00:04:00 Modifying or Deleting a View 00:04:00 Creating a Grouped View 00:06:00 Creating a Datasheet View 00:03:00 Creating a View to Display Items without Folders 00:03:00 Creating a View to Display Items Checked Out to Me 00:04:00 Sharing Documents and Sites 00:03:00 Coauthoring 00:02:00 Integration with Microsoft Office Integration with Office Online 00:03:00 Checking In or Checking Out Documents via Microsoft Office 00:02:00 Accessing and Uploading Properties from Microsoft Office 00:02:00 Accessing Prior Versions from Microsoft Office 00:02:00 Saving a Document to SharePoint from Microsoft Office 00:03:00 Syncing a Calendar to Outlook 00:02:00 Syncing a Library To Outlook 00:02:00 Integration with Office 365 00:04:00 Personal Profile and Newsfeed Updating Your Profile 00:04:00 Following Sites 00:03:00 OneDrive Overview 00:03:00 Uploading Documents to OneDrive 00:02:00 Sharing Content in OneDrive 00:04:00 Newsfeed Overview 00:06:00 Creating a Blog 00:04:00 Editing and Replying to Blogs 00:03:00 Conclusion Course Recap 00:01:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Algebra is an area of mathematics that uses symbols to represent numbers in formulas and equations. Understanding these symbols and how they work together and provide structure to equations allows mathematicians to more efficiently write formulas and solve math problems.  This Algebra for Beginners is an introduction to the basic principles and skills of algebra. Topics include Variables, Grouping Symbols, Equations, Translating Words Into Symbols, and Translating Sentences Into Equations. With this course you will learn to manipulate and solve basic algebraic expressions, solve rational expressions, changing the subject of formulae and using formulae. You will learn to work with integers, decimals and fractions, how to evaluate powers and roots and how to solve single and multi-variable equations and inequalities. Learn how to apply algebra to a wide range of real-world problems and study critical algebraic concepts like functions, domains and ranges. 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? Algebra for Beginners 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 Algebra for Beginners is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Lecture 1 Intro video Algebra Introduction final 00:02:00 Fundamental concepts on Algebraic Expressions Lecture 2 Terminology used in Algebra 00:05:00 Lecture 3 Language of Algebra 00:06:00 Lecture 4 Practice Questions 00:06:00 Lecture 5 Finding numerical value of an algebraic expression 00:14:00 Operations on Algebraic Expressions Lecture 6 Revision of Directed number ( integers 00:06:00 Lecture 7 Addition and subtraction of monomial expressions 00:06:00 Lecture 8 Addition of algebraic expressions with many terms 00:10:00 Lecture 9 Subtraction of algebraic expressions 00:10:00 Indices ( Exponents) Lecture 10 The rules of Indices in algebra 00:11:00 Lecture 11 Fractional indices 00:10:00 Lecture 12 Understanding indices (practice questions) 00:07:00 Lecture 13 Problems from IGCSE Last year papers 00:05:00 Multiplication and Division of Algebraic expressions Lecture 14 Multiplication of monomial algebraic expressions 00:05:00 Lecture 15 Multiplication of monomial with binomials and trinomials 00:11:00 Lecture 16 Division of algebraic expression by a monomial 00:07:00 Lecture 17 Division of algebraic expression by another polynomial 00:09:00 Lecture 18 Division of a polynomial by another polynomial with remainder 00:11:00 Brackets in Algebra Lecture 19 Rules of brackets 00:04:00 Lecture 20 Simplification by removing brackets 00:11:00 Linear equations in one variable Lecture 21 Simplification of algebraic fractions 00:07:00 Lecture 22 Rules to solve linear equations in one variable 00:03:00 Lecture 23 Solving linear equations in one variable 00:07:00 Lecture 24 Solving complex linear equations in one variable 00:10:00 Lecture 25 Word problems on linear equations in one variable 00:13:00 Algebraic Identities Lecture 26 Standard Identities (a + b )² and (a - b )² identities 00:11:00 Lecture 27 Standard Identity ( a - b ) ( a + b) = a ² - b ² 00:08:00 Lecture 28 Standard Identities ( a + b + c ) ² = a ² + b ² + c ² + 2 a b + 2 a c +2 b c 00:07:00 Lecture 29 Standard Identities ( a + b ) ³ and ( a - b ) ³ 00:09:00 Lecture 30 Standard Identities a ³ + b ³ and a ³ - b ³ 00:06:00 Lecture 31 Standard Identities a ³ + b ³ + c ³ - 3 a b c 00:10:00 Formula : Change of subject of formula Lecture 32 -Changing the subject of formula 00:08:00 Linear Inequalities Lecture 33 Linear Inequalities 00:12:00 Resolve into factors Lecture 34 Factorization by taking out common factor 00:10:00 Lecture 35 Factorization by grouping the terms 00:09:00 Lecture 36 Factorize using identity a ² - b ² 00:07:00 Lecture 37 Factorize using identity (a + b )² and (a - b )² 00:08:00 Lecture 38 Factorize using identity ( a + b + c ) ² 00:05:00 Lecture 39 Factorization by middle term split 00:12:00 Algebraic Fractions Lecture 40 Simplification of algebraic fractions 00:06:00 Coordinate axis - points and Line graph Lecture 41 All that you need to know about co ordinate axis 00:04:00 Lecture 42 Some important facts needed to draw line graph 00:03:00 Lecture 43 How to draw a line graph on coordinate plane 00:03:00 Lecture 44 Drawing line graphs 00:06:00 System of simultaneous linear equations in two variables Lecture 45 Simultaneous Linear Equations in two variables- intro 00:03:00 Lecture 46 Graphical method of solving linear equations 00:06:00 Lecture 47 Graphical method - more sums 00:10:00 Lecture 48 Method of Elimination by substitution 00:09:00 Lecture 49 Method of Elimination by Equating coefficients 00:11:00 Lecture 50 Method of Elimination by cross multiplication 00:07:00 Lecture 51 Equations reducible to simultaneous linear equations 00:12:00 Lecture 52 Word Problems on Linear equations 00:18:00 Polynomials Lecture 53 Polynomials and Zeros of polynomials 00:10:00 Lecture 54 Remainder Theorem 00:04:00 Lecture 55 Factor Theorem 00:08:00 Lecture 56 Practice problems on Remainder and Factor Theorem 00:09:00 Lecture 57 Factorization using factor Theorem 00:10:00 Quadratic Polynomials Lecture 58 Zeros of polynomials α, β & γ 00:10:00 Lecture 59 Relation between zeros and coefficients of a polynomials 00:13:00 Lecture 60 Writing polynomials if zeros are given 00:06:00 Lecture 61 Practice problems on zeros of polynomials 00:10:00 Lecture 62 Problems solving with α and β (part 1) 00:11:00 Lecture 63 Problems solving with α and β (part 2) 00:10:00 Quadratic Equations Lecture 64 what are Quadratic equations 00:03:00 Lecture 65 Solutions by factorization method 00:12:00 Lecture 66 Solutions by completing square formula 00:06:00 Lecture 67 Deriving Quadratic formula 00:05:00 Lecture 68 Practice problems by Quadratic formula 00:07:00 Lecture 69 Solving complex quadratic equations by Quadratic Formula 00:11:00 Lecture 70 Solutions of reducible to Quadratic Formula 00:09:00 Lecture 71 Skilled problems on Quadratic Equations 00:07:00 Lecture 72 Exponential problems reducible to Quadratic Equations 00:06:00 Lecture 73 Nature of Roots of Quadratic Equations 00:09:00 Lecture 74 Word problems on quadratic Equations Part 1 00:13:00 Lecture 75 Word problems on quadratic Equations Part 2 00:11:00 lecture 76 word problems on Quadratic 00:12:00 Mock Exam Mock Exam - Algebra for Beginners 00:20:00 Final Exam Final Exam - Algebra for Beginners 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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