3306 Security courses in Peterlee delivered On Demand

Description: Microsoft PowerPoint is one of the most abundantly used presentation program. The 2016 version has some revolutionary features that has made this program effortless to work with. Microsoft PowerPoint 2016 Beginner to Advanced will teach you all the aspects for making the best presentation. In this course, you will learn about the interface of the PowerPoint. After that, you will get accustomed on developing a PowerPoint Presentation, Performing advanced text editing, adding graphical elements to your presentation, modify objects, adding tables and charts and preparing to deliver your presentation. Advanced topics include customizing design templates and slide shows, working with media and animations, collaborating, securing and distributing a presentation. These skills will help you get most of the software. Learning Outcomes: Utilize the PowerPoint user interface, creating and saving presentations, and using help Making presentations through presentation options like selecting types, building it, layouts, text editing, viewing and navigation Discover methods for formatting characters, paragraphs, and text boxes Adding images, screenshots, screen recordings, shapes and WordArt Modifying options for objects and animation features Creating and formatting a table and integrating data from other Microsoft Office applications Create format and manipulate a chart PowerPoint environment and how to modify it according to needs Customizing user interface and setting up options Create and manage sections, modify slide masters and slide layouts, add headers and footers, modify notes master and handout master Creating and modifying SmartArt Adding audio video to presentations and customizing animations and transitions to enhance presentation Better collaboration by adding comments, reviews, storing and sharing presentations on the web Setting up and creating custom slide shows, adding hyperlink and action buttons, and recording a presentation Security and distribution of presentations through various outlets Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft PowerPoint 2016 Beginner to Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft PowerPoint 2016 Beginner to Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. PowerPoint Beginner Navigate the PowerPoint Environment 00:30:00 ACTIVITY - NAVIGATING THE POWERPOINT 2016 USER INTERFACE 00:05:00 Create and Save a PowerPoint Presentation 00:15:00 ACTIVITY - CREATING AND SAVING A POWERPOINT PRESENTATION 00:05:00 Use Help 00:15:00 ACTIVITY - USING POWERPOINT HELP 00:05:00 Select a Presentation Type 00:15:00 ACTIVITY - SELECTING A PRESENTATION TYPE 00:05:00 Build a Presentation 00:15:00 ACTIVITY - BUILDING A PRESENTATION 00:05:00 Lay Out a Presentation 00:15:00 ACTIVITY - LAYING OUT A PRESENTATION 00:05:00 Edit Text 00:15:00 ACTIVITY - EDITING TEXT 00:05:00 View and Navigate a Presentation 00:15:00 ACTIVITY - VIEWING A PRESENTATION 00:05:00 Format Characters 00:15:00 ACTIVITY - FORMATTING CHARACTERS 00:05:00 Format Paragraphs 00:30:00 ACTIVITY - FORMATTING PARAGRAPHS 00:05:00 Format Text Boxes 00:15:00 ACTIVITY - FORMATTING TEXT BOXES 00:05:00 Insert Images 00:30:00 ACTIVITY - INSERTING IMAGES 00:05:00 Insert Shapes 00:15:00 ACTIVITY - INSERTING SHAPES 00:05:00 Insert WordArt 00:15:00 ACTIVITY - INSERT WORDART 00:05:00 Edit Objects 00:30:00 ACTIVITY - EDITING OBJECTS 00:05:00 Format Objects 00:15:00 ACTIVITY - FORMATTING OBJECTS 00:05:00 Group Objects 00:15:00 ACTIVITY - GROUPING OBJECTS 00:05:00 Arrange Objects 00:15:00 ACTIVITY - ARRANGING OBJECTS 00:05:00 Animate Objects 00:15:00 ACTIVITY - ANIMATING OBJECTS 00:05:00 Create a Table 00:15:00 ACTIVITY - CREATING A TABLE 00:05:00 Format a Table 00:15:00 ACTIVITY - FORMATTING A TABLE 00:05:00 Insert a Table from Other Microsoft Office Applications 00:15:00 ACTIVITY - INSERTING A TABLE FROM MICROSOFT EXCEL 00:05:00 Create a Chart 00:15:00 ACTIVITY - CREATING A CHART 00:05:00 Format a Chart 00:15:00 ACTIVITY - FORMATTING A CHART 00:05:00 Manipulate a Chart 00:15:00 ACTIVITY - MANIPULATING A CHART 00:05:00 Insert a Chart from Microsoft Excel 00:15:00 ACTIVITY - INSERTING A CHART FROM MICROSOFT EXCEL 00:05:00 Review Your Presentation 00:30:00 ACTIVITY - REVIEWING YOUR PRESENTATION 00:05:00 Apply Transitions 00:15:00 ACTIVITY - APPLYING TRANSITIONS 00:05:00 Print Your Presentation 00:15:00 ACTIVITY - PRINTING YOUR PRESENTATION 00:05:00 Deliver Your Presentation 01:00:00 ACTIVITY - DELIVERING YOUR PRESENTATION 00:05:00 PowerPoint Intermediate Customize the User Interface 01:30:00 Set PowerPoint 2016 Options 00:45:00 Create and Manage Sections 01:00:00 Modify Slide Masters and Slide Layouts 01:15:00 Add Headers and Footers 00:30:00 Modify the Notes Master and the Handout Master 00:45:00 Create SmartArt 00:45:00 Modify SmartArt 01:00:00 Add Audio to a Presentation 00:45:00 Add Video to a Presentation 01:00:00 Customize Animations and Transitions 01:00:00 Add Comments to a Presentation 00:45:00 Store and Share Presentations on the Web 01:30:00 Annotate a Presentation 00:45:00 Set Up a Slide Show 00:45:00 Create a Custom Slide Show 00:30:00 Add Hyperlinks and Action Buttons 00:45:00 Record a Presentation 00:15:00 Secure a Presentation 01:30:00 Present a Slide Show Online 01:00:00 Create a Video or a CD 00:45:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Our Fire Warden Training Course is meticulously designed to equip you with essential knowledge and skills to play a vital role in ensuring workplace safety during fire emergencies. With fire safety being a top priority for any organisation, this course covers the key responsibilities of a fire warden, including identifying hazards, evacuation procedures, and emergency protocols. Whether you are in a small office or a large facility, the course provides you with all the tools necessary to take swift action when it matters most. The QLS-endorsed qualification ensures that you are prepared to manage fire safety in your organisation efficiently and confidently. The course content is structured to guide you through important aspects such as fire prevention strategies, understanding fire risk assessments, and the importance of effective communication during a fire emergency. With a focus on safeguarding both people and property, you’ll be ready to support your team in a critical situation. Through engaging and informative content, this training is your first step toward enhancing your organisation's fire safety standards. Fire Warden Training QLS Bundle Includes the following Courses Course 01: Diploma in Fire Warden Training at QLS Level 5 Course 02: Fire Safety Training Course 03: Emergency First Aid at Work (EFAW) Course 04: DSEAR Training Course 05: Ladder Safety Key Features of Fire Warden Training Eligibility for QLS endorsed certificate upon successful completion of the Fire Warden Training course Free CPD Accredited Course Fully online, interactive Fire Warden Training course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth Fire Warden Trainingtraining course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. Assessment At the end of the Fire Warden Training course, we will provide assignment and quizzes. For each test, the pass mark will be set to 60%. Accreditation This Fire Warden Training course is QLS - Quality Licence Scheme Endorsed and CPD Certified, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification CPD Certified: Once you've successfully completed your Fire Warden Training course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). QLS Endorsed:After successfully completing the Fire Warden Training course, learners will be able to order an endorsed certificate, titled: [Diploma in Fire Warden Training at QLS Level 5], as proof of their achievement. This certificate of achievement endorsed by the Quality Licence Scheme. CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Fire Warden Training basics. Requirements No prior degree or experience is required to enrol in this Fire Warden Training course. Career path This Fire Warden Training Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

Level 3 Award in Education and Training AET Course is designed to give people the knowledge and confidence to teach adult in any specialty subject area. Learn More Academy has been delivering the Level 3 (12 Credits) Award in Education and Training AET formerly known (PTLLS) qualification. Level 3 AET course is designed to contribute towards the knowledge and understanding for Further Education National Training Organisation (FENTO) or the Employment National Training Organisation (EMPNTO) occupational standards in the United Kingdom.

CCTV Operator: CCTV Do you wish to become a better CCTV operator or launch a career in the field? We have created a fantastic CCTV Operator Training course to teach you about this device and its functions. You will learn all you need to enter an interesting and fulfilling career with our CCTV Operator Training. You will learn about the many kinds of CCTV systems and how to run them efficiently from the CCTV Operator Training. In addition, the CCTV Operator Training teaches students how to spot and report unusual activities. The legal and ethical aspects of CCTV operating are also explained in the CCTV Operator Training. All things considered, the CCTV Operator Training is ideal for understanding data protection techniques. Unlock your potential with our CCTV Operator Training to learn how to watch CCTV footage and report any suspicious behaviour with the right documentation. Special Offers of this CCTV: CCTV Operator Course This CCTV Operator Course includes a FREE PDF Certificate. Lifetime access to this CCTV Operator: CCTV Operator Course Instant access to this CCTV Operator: CCTV Operator Course Get FREE Tutor Support from Monday to Friday in this CCTV Operator: CCTV Operator Course Painting and CCTV: CCTV Operator Bundle Courses Course 01: CCTV Operator Training Course 02: AML ( Anti Money Laundering ) Course 03: Handyperson Training CCTV Operator: CCTV Industry Experts Designed this CCTV Operator course into 9 detailed modules. Course Curriculum of CCTV Operator Training Module 1: Introduction to CCTV Systems Module 2: CCTV Camera Technology Module 3: Video Signals and Transmission Module 4: CCTV Recording and Storage Module 5: Monitoring and Control Module 6: CCTV System Setup and Configuration Module 7: CCTV System Maintenance and Troubleshooting Module 8: Legal and Ethical Considerations Module 9: Emergency Response and Incident Handling Who is this course for? CCTV Operator: CCTV Anyone interested in learning about the complexities of CCTV: CCTV technology should take this CCTV: CCTV Operator Training. Career path CCTV Operator: CCTV Numerous work options will become available to you upon completion of the CCTV: CCTV Operator Training. For example, junior CCTV: CCTV operator, senior CCTV: CCTV operator, experienced CCTV: CCTV operator, and many more!

You will learn how to develop reliable and scalable serverless applications, following the microservices architecture. We will develop event-driven microservices with AWS serverless services that come with the power of the cloud, high availability and high scalability by nature following serverless design patterns and best practices.

Learn the secrets of self defence and take back your power! Become confident, empowered and prepared for a safe and fun university experience

Overview Having a foundational understanding of IT components is essential. Did you know that by 2023, an estimated 2.5 million new IT positions will be available globally? The CompTIA A+ (220-1001) course offers a comprehensive dive into the world of computer technology.  Designed to shape the professionals of tomorrow, this course meticulously covers the gamut of fundamental IT knowledge. Ranging from RAM technology to the vast world of cloud computing, the curriculum is structured to foster a comprehensive understanding. With modules such as 'Inside the PC' and 'Understanding Virtualization', learners will be adept at navigating the complex terrains of the modern IT environment. Ready to steer your career into the future of IT? Enrol now and become a part of the technological revolution! How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this CompTIA A+ (220-1001). It is available to all students, of all academic backgrounds. Requirements Our CompTIA A+ (220-1001) is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 24 sections • 132 lectures • 17:30:00 total length •CompTIA A+ 2019 Core 1 (220-1001) Course Introduction: 00:02:00 •What is the CompTIA A+?: 00:02:00 •Why Get A+ Certified?: 00:03:00 •What is on the CompTIA A+ Core 1 (220-1001) Exam?: 00:09:00 •How to Pass the A+ Exam: 00:04:00 •How to Use This Video Course: 00:03:00 •Tools of the Trade: 00:06:00 •Troubleshooting Theory: 00:10:00 •Primary PC Connections: 00:05:00 •External Connections: 00:11:00 •Inside the PC: 00:08:00 •What is a Computer?: 00:07:00 •What is a CPU?: 00:15:00 •CPU Speeds and Cores: 00:12:00 •Caching: 00:07:00 •CPU Sockets: 00:12:00 •Installing a CPU: 00:11:00 •Liquid Cooling: 00:04:00 •RAM Technology: 00:11:00 •RAM Capacity: 00:08:00 •RAM Features: 00:07:00 •Installing RAM: 00:07:00 •What is the BIOS?: 00:06:00 •POST: 00:09:00 •System Setup: 00:09:00 •Troubleshooting Firmware: 00:12:00 •Form Factors: 00:06:00 •Chipsets: 00:05:00 •Touring the Motherboard: 00:14:00 •Touring the Case: 00:07:00 •Installing a Motherboard: 00:09:00 •The Power Supply: 00:09:00 •Mounting a Power Supply: 00:05:00 •Choosing a Power Supply: 00:08:00 •Cooling Your PC: 00:11:00 •Troubleshooting Power Supplies: 00:09:00 •Troubleshooting Core Components: 00:14:00 •Introduction to Mass Storage: 00:13:00 •Magnetic Disk Drives: 00:08:00 •Solid State Drives: 00:08:00 •SCSI: 00:03:00 •Boot Order: 00:07:00 •New Installation - First Drive: 00:05:00 •RAID: 00:11:00 •Hardware RAID: 00:07:00 •Mass Storage Troubleshooting: 00:08:00 •Optical Media: 00:10:00 •USB Standards: 00:10:00 •Understanding USB: 00:11:00 •Configuring USB: 00:07:00 •Thunder and Lightning: 00:06:00 •Keyboards and Mice: 00:08:00 •Sight and Sound: 00:07:00 •Readers and Scanners: 00:08:00 •Using Expansion Cards: 00:08:00 •The Right PC for the Job: 00:13:00 •Monitor Technologies: 00:08:00 •LCD Breakdown: 00:04:00 •Graphics Cards and Connections: 00:13:00 •Installing a Graphics Card: 00:07:00 •Projectors: 00:05:00 •Troubleshooting Monitors: 00:06:00 •Introduction to Networking: 00:08:00 •Hubs vs. Switches: 00:05:00 •Hexadecimal: 00:07:00 •WANs and Routers: 00:09:00 •Cables and Connectors: 00:11:00 •Crimping Cables: 00:10:00 •Structured Cabling: 00:11:00 •Introduction to TCP/IP: 00:14:00 •Network IDs and Subnet Masks: 00:05:00 •Special IP Addresses: 00:09:00 •NAT: 00:07:00 •Dynamic IP Addressing: 00:10:00 •IPv6: 00:07:00 •Port Numbers: 00:12:00 •TCP, UDP, and ICMP: 00:06:00 •Understanding DNS: 00:09:00 •Working with DNS: 00:07:00 •Windows Naming: 00:08:00 •Routers: 00:12:00 •Basic Router Configuration: 00:12:00 •Advanced Router Configuration: 00:06:00 •VLANs: 00:07:00 •Network Troubleshooting: 00:05:00 •Wireless Network Hardware: 00:11:00 •Wi-Fi Standards: 00:10:00 •Basic WAP Setup: 00:11:00 •Connecting to a Wi-Fi Network: 00:09:00 •It's a Huge Mesh: 00:04:00 •Beyond Wi-Fi: 00:07:00 •Troubleshooting Wireless Connections: 00:07:00 •Beyond the LAN: 00:03:00 •Internet Tiers: 00:06:00 •Dial-up Connections: 00:08:00 •Broadband Connections: 00:10:00 •Firewalls and Servers: 00:06:00 •FTP: 00:07:00 •E-Mail: 00:08:00 •Proxy Servers: 00:06:00 •Virtual Private Networks (VPNs): 00:08:00 •Internet of Things (IoT): 00:04:00 •Understanding Virtualization: 00:10:00 •Your First Virtual Machine: 00:11:00 •Advanced Virtualization Setup: 00:10:00 •Cloud Computing: 00:08:00 •Cloud Ownership: 00:03:00 •Cloud-Based Applications: 00:06:00 •Laptop Features: 00:08:00 •Laptop Hardware Troubleshooting - The Tools: 00:05:00 •Laptop Hardware - Core Hardware: 00:04:00 •Laptop Hardware - CPU and Motherboard: 00:07:00 •Touring Your Laptop Display: 00:04:00 •What is a Mobile Device?: 00:09:00 •Mobile Connections: 00:10:00 •Touring Android: 00:10:00 •Touring iOS: 00:08:00 •Virtual Reality: 00:03:00 •Maintaining Mobile Devices: 00:11:00 •Mobile Devices and E-mail: 00:10:00 •Mobile Synchronization: 00:08:00 •Laser Printers: 00:13:00 •Inkjet Printers: 00:08:00 •Impact Printers: 00:04:00 •Thermal Printers: 00:04:00 •Installing a Local Printer: 00:14:00 •Sharing Printers: 00:08:00 •Installing Wireless and Cloud Printers: 00:10:00 •Troubleshooting Printers: 00:10:00 •3D Printing: 00:07:00 •Dealing with Threats: 00:07:00 •Assignment - CompTIA A+ (220-1001): 00:00:00

Gain the skills and credentials to kickstart a successful career in the technology industry and learn from the

PTLLS is a teacher training qualification for those new to teaching / training industry or wanting to start out as associate teachers, or currently teaching. Learn More Academy has been delivering the Level 3 Preparing to Teach in the Lifelong Learning Sector (PTLLS) or newly branded AET course. Level 3 Award in Education and Training (AET) course is designed to contribute towards the knowledge and understanding for Further Education National Training Organisation (FENTO) or the Employment National Training Organisation (EMPNTO) occupational standards in the United Kingdom. This course is designed for anyone wishing to enter in the adult training and teaching industry in this country and even some other country too.

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