1153 Logic courses

Description The Implementing Cisco IP Routing is a qualifying exam for the Cisco Certified Network Professional CCNP, Cisco Certified Internetwork Professional CCIP, and Cisco Certified Design Professional CCDP certifications. This Cisco CCNP Implementing Cisco IP Routing (Route) v2.0 Training will help you to be certified Successfully with all the important knowledge and skills necessary to use advanced IP addressing and routing in implementing scalable and secure Cisco ISR routers connected to LANs and WANs. The exam also covers configuration of secure routing solutions to support branch offices and mobile workers. This is an advanced course on Cisco routing configuration for both IPv4 and IPv6. In this course, you will gain the knowledge to configure and optimize a routing domain using OSPF, EIGRP, BGP, PBR, IP SLA and configure redistribution when needed. It also includes the configuration of highly secure routing solutions to support branch offices and mobile workers. Assessment & Certification To achieve a formal qualification, you are required to book an official exam separately with the relevant awarding bodies. However, you will be able to order a course completion CPD Certificate by paying an additional fee. Hardcopy Certificate by post - £19 Soft copy PDF via email - £10 Requirements Our Cisco CCNP Implementing Cisco IP Routing (Route) v2.0 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. Routing Services Complex Enterprise Network Frameworks, Architectures, and Models FREE 00:15:00 Creating, Documenting, and Executing an Implementation Plan 00:09:00 Overview of IP Routing 00:12:00 RIPNG 00:26:00 Configuring the Enhanced Interior Gateway Routing Protocol Understanding EIGRP Terminology and Operation 00:14:00 Planning EIGRP Routing Implementations 00:03:00 Configuring and Verifying EIGRP 00:03:00 Enable EIGRP Routing 00:01:00 Define EIGRP Networks 00:03:00 Define Bandwidth on Interfaces 00:01:00 Enable and Disable EIGRP Automatic Summarization 00:01:00 Passive Interface 00:02:00 IP Default Network 00:03:00 Configure a Router to Advertise a Default Route as the Gateway 00:02:00 Example of the IP Route Next Hop Command 00:01:00 Example of the IP Route Quad Zero Command 00:01:00 Summarization in Discontiguous Networks 00:01:00 Configuring and Verifying EIGRP in an Enterprise WAN 00:03:00 Disabling Automatic Summarization 00:01:00 Frame Relay Using Dynamic Mapping 00:03:00 EIGRP over Layer 3 MPLS VPNs 00:02:00 EIGRP over Layer 2 MPLS VPNs 00:04:00 Configuring and Verifying EIGRP Authentication 00:04:00 Configure Authentication Mode for EIGRP 00:02:00 Configure the Key Chain 00:01:00 Optimizing EIGRP Implementations 00:05:00 Enable Authentication to use the Key Chain 00:01:00 EIGRP 00:21:00 Configuring the Open Shortest Path First Protocol Understanding OSPF Terminology and Operation 00:20:00 OSPF Packets 00:11:00 Planning OSPF Routing Implementations 00:06:00 Basic OSPF Verification and Configuration 00:09:00 Configuring Single Area OSPF 00:02:00 Configuring Multi Area OSPF 00:01:00 EIGRP over Layer 3 MPLS VPNs 00:02:00 OSPF Network Types 00:11:00 Assigning Router Priority 00:02:00 Override the Default Interface Cost 00:01:00 Configure a Key for Simple Authentication 00:01:00 Configure the MD5 Key-ID and Key 00:02:00 Verifying Simple Password Authentication 00:01:00 OSPF 00:19:00 Manipulating Routing Updates Assessing Network Routing Performance Issues 00:05:00 Using Multiple Routing Protocols on a Network 00:09:00 Redistribution Supports All Routing Protocols 00:01:00 Implementing Route Redistribution 00:07:00 Redistribute Routes into RIP 00:03:00 Redistribute Routes into OSPF 00:04:00 Default Metric for Routing Protocols 00:02:00 Redistributing Routes into EIGRP 00:05:00 Applying Metric Values for EIGRP 00:03:00 Modifying the Administrative Distance for all Routing Protocols 00:06:00 Changing OSPF AD 00:15:00 Controlling Routing Update Traffic 00:11:00 Route Map 00:10:00 Using Distribute Lists and Filter Incoming Routing Updates 00:03:00 Defining a Filter for Outgoing Routing Commands 00:02:00 Distribute List In or Out and Examples 00:06:00 Distribute Lists to Avoid Route Feedback 00:05:00 Fallbacks of Distribute Lists 00:01:00 Using Prefix Lists 00:02:00 Implementing Path Control Understanding Path Control 00:05:00 Similarities of ACLs and Prefix Lists 00:01:00 Implementing Path Control using Offset-Lists 00:02:00 Configuring a Prefix List 00:04:00 Implementing Path Control Using Offset-Lists 00:03:00 Verify Offset-Lists 00:01:00 Implementing Path Control using IOS IP SLAs 00:10:00 Cisco IOS IP SLAs 00:01:00 IP SLAs Applications 00:01:00 Operations - Responders and Sources 00:01:00 IP SLAs Operations 00:01:00 Steps to Deploying IP SLAs 00:01:00 IP SLA - ICMP ECHO and ICMP ECHO Sub Commands 00:04:00 IP SLA Schedules 00:05:00 Define Tracking Objects to Track the State of IP SLAs Operations 00:02:00 Configuring Track Delay 00:01:00 Configure a Static Route for IP SLAs Tracking 00:03:00 Verify IP SLAs using Method 1 00:02:00 Verify IP SLAs using Method 2 00:02:00 Implement Path Control using Policy-Based Routing 00:09:00 Implement Path Control using Policy-Based Routing 00:01:00 Configure PBR 00:01:00 Logical PBR Operation 00:01:00 Route-Map Commands for PBR 00:03:00 Match Statements and Conditions 00:03:00 Match Commands Used in PBR 00:01:00 Specify Criteria to be Matched using Prefix Lists of ACLs 00:01:00 Specify Criteria to be Matched by Packet Length 00:01:00 Modify Matching Conditions using Set Statements 00:01:00 Set Conditions 00:03:00 Set Commands used in PBR 00:02:00 Specify the Next Hop IP Address for Matching Packets 00:01:00 Specify Interfaces Through which Packets Can be Routed 00:01:00 Specify a List of Default Next-Hop IP Addresses 00:02:00 Specify a List of Default Interfaces 00:02:00 Mark Packets Using the IP ToS Field 00:02:00 Set the 3 IP Precedence Bits in the IP Packet Header 00:01:00 Set IP Precedence Parameters 00:02:00 Identify a Route Map to Use for Policy Routing on an Interface 00:01:00 Various Methods to Verify PBR 00:02:00 Advanced Path Control Tools 00:02:00 Implementing a Border Gateway Protocol Solution for ISP Connectivity BGP Terminology, Concepts, and Operation 00:20:00 EGP and IGP 00:01:00 AS 00:02:00 IANA 00:01:00 RIRs 00:02:00 AS Numbers 00:03:00 Facts about BGP 00:03:00 BGP Neighbors 00:03:00 BGP Operational Overview 00:02:00 BGP Use between ASs 00:01:00 BGP and IGPs 00:01:00 Connecting Enterprise Networks to Internet Service Providers 00:02:00 Configuring BGP 00:12:00 Questions for Deploying Routing and Connection 00:02:00 Public IP Address Space 00:02:00 Configure Static Routes 00:02:00 Configure the Default Local Preference 00:01:00 Define BGP as the IP Routing Protocol 00:03:00 Router BGP Command Parameters 00:01:00 Identify Peer Router to Establish a BGP Session 00:02:00 Create a Peer Group 00:02:00 Assign Neighbors as Part of the Peer Group 00:02:00 Disable an Existing BGP Neighbor or Peer Group Relationship 00:02:00 Establish the IBGP Session Using a Loopback Interface 00:02:00 IBGP Source IP 00:03:00 Increase the TTL for EBGP Connections 00:03:00 Configure the Router as the Next Hop for a BGP Speaking Peer 00:02:00 Verifying and Troubleshooting BGP 00:01:00 Basic BGP Path Manipulation Using Route Maps 00:05:00 Filtering BGP Routing Updates 00:02:00 Implementing Routing Facilities for Branch Offices and Mobile Workers Planning the Branch Office Implementations 00:15:00 NAT 00:09:00 Planning for Mobile Worker Implementations 00:03:00 Routing Traffic to the Mobile Worker 00:02:00 Implementing IPv6 in the Enterprise Network Introducing IPv6 00:07:00 Configuring and Verifying IPv6 Unicast Addresses 00:06:00 Routing IPv6 Traffic 00:01:00 Configuring Static Routing 00:04:00 Configuring OSPFv3 00:07:00 OSPFv3 00:22:00 Configuring EIGRP for IPv6 00:03:00 EIGRP for IPv6 00:18:00 Multiprotocol BGP (MP-BGP) 00:03:00 Mock Exam Mock Exam- Cisco CCNP Implementing Cisco IP Routing (Route) v2.0 Training 00:20:00 Final Exam Final Exam- Cisco CCNP Implementing Cisco IP Routing (Route) v2.0 Training 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This course follows up from the Beginners Excel 2010 course by delving even deeper into features and functions of this powerful spreadsheet software. This Microsoft Office 2010 Excel Advanced - Complete Video Course builds on the skills and concepts taught in Excel 2010: intermediate. In this series you will learn to work with advanced formulas, as well lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation and database functions such as DSUM. You will learn how to work with Pivot Tables and PivotCharts, how to import and export data, and how to query external databases. Finally, you will learn about the analytical features of Excel, running and recording macros, SmartArt graphics and conditional formatting with graphics, and more. Before you taking this course you should have a firm grasp of the basics. This course will pull up your basic knowledge. So join this course to be an expert. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2010 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2010 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Logical and Statistical Functions Logical Functions FREE 00:17:00 Math and Statistical Functions 00:19:00 Financial and Date Functions Financial Functions 00:04:00 Date and Time Functions 00:10:00 Array Formulas 00:09:00 Displaying and Printing Formulas 00:08:00 Lookups and Data Tables Using Lookup Functions 00:14:00 Using MATCH and INDEX 00:06:00 Array Formulas 00:07:00 Advanced Data Management Validating Cell Entries 00:08:00 Exploring Database Functions 00:06:00 Exporting and Importing Exporting and Importing Text Files 00:11:00 Exporting and Importing XML Data 00:03:00 Querying External Databases 2 hours agoMore 00:09:00 Analytical Tools Goal Seek and Solver 00:15:00 The Analysis ToolPak 00:05:00 Scenarios 1 hour agoMore 00:06:00 Macros and Custom Functions Running and Recording a Macro 00:19:00 Working with VBA Code 00:07:00 Creating Functions 00:05:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2007 Excel Advanced - Complete Video Course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros. You will also learn to use key advanced financial, logical, text, statistical and math, and lookup functions, audit formulas for errors, analyze data using subtotals, goal seek and the scenario manager, use custom and conditional formatting, manage data with tables, filtering and sorting, create, edit and format PivotTables and PivotCharts, import and export date to and from a workbook, create and use macros. So, by taking this course you will have a complete understanding of the higher functions of Excel. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2007 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2007 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Advanced Functions Logical Functions FREE 00:08:00 Math and Statistical Functions 00:06:00 Financial Functions 00:03:00 Displaying and Printing Formulas 00:02:00 Lookups and Data Tables Using Lookup Functions 00:03:00 Using MATCH and INDEX 00:01:00 Creating Data Tables 00:03:00 Advanced List Management Validating Cell Entries 00:01:00 Exploring Database Functions 00:01:00 PivotTables and PivotCharts Working with PivotTables 00:04:00 Rearranging PivotTables 00:02:00 Formatting PivotTables 00:02:00 PivotCharts 00:01:00 Exporting and Importing Exporting and Importing Text Files 00:07:00 Exporting and Importing XML Data 00:02:00 Querying External Databases 00:03:00 Analytical Options Goal Seek and Solver 00:05:00 The Analysis ToolPak 00:01:00 Scenarios 00:02:00 Views 00:01:00 Macros and Custom Functions Running and Recording a Macro 00:02:00 Working with VBA Code 00:01:00 Creating Functions 00:05:00 Conditional Formatting and SmartArt Conditional Formatting with Graphics 00:03:00 SmartArt Graphics 00:02:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This Microsoft Power BI course will help you become a Power BI expert. It'll enhance your skills by offering you comprehensive knowledge on Power BI Desktop and Power BI Online, and unleash the capabilities of Power BI to perform a comprehensive analysis of data from multiple sources and present the data using the perfect visualization.

Technical Writing Online Course Overview Welcome to the Technical Writing Online Course, your comprehensive guide to mastering the art and science of effective technical communication. Whether you're a seasoned professional looking to enhance your skills or a newcomer to the field seeking a solid foundation, this course is designed to meet your needs. Module 1: Introduction to Technical Writing In Module 1, we lay the groundwork for your journey into the world of technical writing. You'll learn about the fundamental principles of technical communication, understanding its purpose, audience, and context. We'll explore the importance of clarity, conciseness, and accuracy in technical writing, setting the stage for your success in subsequent modules. Module 2: Writing for Different Audiences Effective communication hinges on understanding and adapting to your audience. Module 2 delves into the nuances of tailoring your writing to different readerships, whether they are technical experts, laypersons, or stakeholders with varying levels of expertise. You'll master strategies for conveying complex information in a clear and accessible manner, ensuring your message resonates with your target audience. Module 3: Researching and Gathering Information Technical writing is grounded in robust research and accurate data. Module 3 equips you with the skills to conduct thorough research, gather relevant information, and discern credible sources. From leveraging online databases to conducting interviews and surveys, you'll learn how to gather the data necessary to support your technical documents effectively. Module 4: Planning and Organizing Technical Documents Organizing technical content is crucial for facilitating comprehension and usability. Module 4 guides you through the process of structuring your documents for maximum clarity and coherence. You'll explore various organizational frameworks, such as hierarchical structures, chronological sequences, and logical flowcharts, to effectively present your information and guide your readers through complex technical material. Module 5: Writing Effective Technical Documents In the final module, we bring together everything you've learned to craft polished and impactful technical documents. From technical reports and manuals to user guides and specifications, you'll learn the principles of writing with precision, coherence, and persuasiveness. Through practical exercises and real-world examples, you'll hone your writing skills and gain the confidence to produce professional-grade technical documents. Throughout the course, you'll benefit from a blend of instructional materials, interactive exercises, and feedback from industry experts. By the end of the Technical Writing Online Course, you'll emerge equipped with the knowledge, skills, and confidence to excel in the dynamic field of technical communication. Course Curriculum Module 1_ Introduction to Technical Writing. Introduction to Technical Writing. 00:00 Module 2_ Writing for Different Audiences. Writing for Different Audiences. 00:00 Module 3_ Researching and Gathering Information. Researching and Gathering Information. 00:00 Module 4_ Planning and Organizing Technical Documents. Planning and Organizing Technical Documents. 00:00 Module 5_ Writing Effective Technical Documents. Writing Effective Technical Documents. 00:00

📄 Report Writing Training Course Overview: Transform Your Reports into Masterpieces Ready to take your report writing skills to the next level? Our comprehensive 'Report Writing Training' course is your key to crafting impactful and professional reports. From the fundamentals to advanced editing techniques, this course is designed to empower you with the skills needed to communicate information effectively through written reports. 📝 Module 1: Introduction to Report Writing Embark on your journey with a foundational understanding of the principles of effective report writing. Explore the purpose, significance, and various types of reports. Gain insights into tailoring your reports to different audiences and purposes, setting the stage for mastery in report creation. 🗂️ Module 2: Planning and Structuring a Report Learn the art of strategic planning and structuring for impactful reports. Discover how to outline your content, establish clear objectives, and create a logical flow of information. Master the skills to develop a well-organized structure that captivates your audience and enhances comprehension. 📊 Module 3: Collecting and Analyzing Data Delve into the core of report creation by understanding the importance of data collection and analysis. Learn effective methods for gathering relevant information, evaluating data accuracy, and drawing meaningful conclusions. Develop the skills to present data in a compelling and insightful manner. 📄 Module 4: Writing the Report Unlock the secrets to creating clear, concise, and compelling reports. Explore writing techniques that enhance readability, convey complex ideas, and maintain the interest of your audience. Master the art of using language effectively to convey your message with precision and impact. ️ Module 5: Editing and Proofreading Polish your reports to perfection with advanced editing and proofreading techniques. Learn how to review your work critically, identify errors, and refine your writing for clarity and coherence. Develop an eye for detail to ensure your reports meet the highest standards of professionalism. 🌐 Why Choose Our Report Writing Training Course? Practical Application: Hands-on exercises and real-world scenarios for practical skill development. Expert Guidance: Learn from seasoned writers and editors with extensive experience. Interactive Learning: Engage in activities designed to enhance your report writing dynamically. Career Advancement: Open doors to diverse opportunities where effective written communication is essential. 📈 Enroll Now and Transform Your Report Writing Skills! Don't miss the opportunity to become a skilled and influential report writer. Our Report Writing Training course is your gateway to mastering the art of effective written communication. Enroll now and unlock the keys to creating reports that stand out and make a lasting impact! Course Curriculum Module 1_ Introduction to Report Writing. Introduction to Report Writing. 00:00 Module 2_ Planning and Structuring a Report. Planning and Structuring a Report. 00:00 Module 3_ Collecting and Analyzing Data. Collecting and Analyzing Data. 00:00 Module 4_ Writing the Report. Writing the Report. 00:00 Module 5_ Editing and Proofreading. Editing and Proofreading. 00:00

Standard Edition of the Deep Dive into Core Java Programming. An approach to learning Java that is both practical and effective. Become an expert in Java.

🚀 Unleash Your Excel Mastery with 'Microsoft Excel 2016 (Basic to Advanced)' Course! 🚀 Are you tired of spending hours grappling with Excel, only to end up with frustrating and inefficient solutions? Do you dream of becoming the Excel wizard in your workplace, effortlessly creating powerful and efficient solutions? Look no further! Introducing our groundbreaking online course: 'Microsoft Excel 2016 (Basic to Advanced).'   🌟 Why Choose 'Microsoft Excel 2016 (Basic to Advanced)'? ✅ Master Advanced Excel Techniques: Dive deep into the world of Excel with our comprehensive modules that cover everything from advanced formulas and functions to data visualization and analysis. ✅ Practical Real-World Applications: Say goodbye to theoretical lessons! We focus on real-world scenarios, ensuring you can immediately apply your newfound skills to solve complex problems in your professional life. ✅ Build Efficiency: Learn the secrets of crafting efficient and streamlined Excel solutions. From automating repetitive tasks to optimizing complex workflows, you'll become a productivity powerhouse. ✅ Expert-Led Instruction: Our experienced instructors are Excel aficionados with a passion for teaching. Benefit from their wealth of knowledge and insider tips, ensuring you stay ahead of the curve. ✅ Interactive Learning: Engage with hands-on exercises, quizzes, and projects that reinforce your understanding and transform you into a confident Excel pro. ✅ Lifetime Access: Gain unlimited access to the course content, updates, and a supportive community. Your learning journey doesn't end - it evolves.   🎓 What You'll Learn: Advanced Formulas and Functions: Supercharge your spreadsheet skills with complex formulas and functions, unlocking Excel's true potential. Data Visualization Mastery: Transform raw data into visually stunning charts and graphs, making your reports and presentations more impactful. Automation Techniques: Streamline your work by mastering Excel's automation features, saving time and reducing errors. Data Analysis Strategies: Unlock the power of PivotTables, data models, and analysis tools to gain valuable insights from your data. Optimizing Workflows: Learn to design efficient workflows and templates that enhance collaboration and productivity.   🌐 Who Is This Course For? Professionals aiming to boost their Excel proficiency. Entrepreneurs seeking to optimize business processes. Students preparing for a data-driven career. Anyone who wants to stay ahead in today's competitive workplace.   Don't miss out on this opportunity to elevate your Excel skills and stand out in the crowd. Join 'Microsoft Excel 2016 (Basic to Advanced)' today and pave the way for a successful and efficient future! Course Curriculum Microsoft Excel 2016 Basic Pre Sell Video 00:00 Lesson 1 - Overview 00:00 Lesson 2 - Interface 00:00 Lesson 3 - File Menu - Part 1 00:00 Lesson 4 - File Menu - Part 2 00:00 Lesson 5 - Home Menu 00:00 Lesson 6 - Insert Menu 00:00 Lesson 7 - Page Layout Menu 00:00 Lesson 8 - Formulas Menu 00:00 Lesson 9 - Data Menu - Part 1 00:00 Lesson 10 - Data Menu - Part 2 00:00 Lesson 11 - Review Menu 00:00 Lesson 12 - View Menu 00:00 Lesson 13 - Templates 00:00 Lesson 14 - Dates 00:00 Lesson 15 - Numbers 00:00 Lesson 16 - Text 00:00 Lesson 17 - B - Calculations-Manual 00:00 Lesson 18 - Calculations 00:00 Lesson 19 - Page Set Up 00:00 Lesson 20 - Print Settings 00:00 Lesson 21 - Conclusion 00:00 Microsoft Excel 2016 Advanced Lesson 1 - Overview 00:00 Lesson 2 - Calculations - Absolute References 00:00 Lesson 3 - Calculations - Relative References 00:00 Lesson 4 - Using Logical Formulas 00:00 Lesson 5 - Using Text Formulas 00:00 Lesson 6 - Using Lookup Formulas 00:00 Lesson 7 - Using Financial Formulas 00:00 Lesson 8 - Using Date and Time Formulas 00:00 Lesson 9 - Sorting Data 00:00 Lesson 10 - Formatting Data into Tables 00:00 Lesson 11 - Using Pivot Tables - Part 1 00:00 Lesson 12 Using Pivot Tables - Part 2 - Design 00:00 Lesson 13 - Formatting Data as Charts 00:00 Lesson 14 - Formatting As Data as Maps 00:00 Lesson 15 - Formatting Data as Formal Reports 00:00 Lesson 16 - Formatting Data for Other Office Documents 00:00 Lesson 17 - Cell Protection and Collaboration 00:00 Lesson 18 - Cell Protection and Collaboration - Part 2 00:00 Lesson 19 - Interface with Google Sheets 00:00 Lesson 20 - Conclusion 00:00

Overview Making Budget & Forecast Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Making Budget & Forecast Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Unit-1. Introduction Lecture-1 - Why Budget And Forecasts 00:11:00 Lecture-2- Is Budget Planning A Paper Exercise 00:05:00 Lecture-3- Operational And Financial Budget 00:07:00 Unit-2. Detail Budget Requirement Lecture-4 - Components - Revenue Budgets 00:05:00 Lecture-5 - Components - Cost Budget 00:11:00 Lecture-6 - Qualitative Aspects 00:05:00 Unit-3. Process Of Making Budget Lecture-7- Process Of Budgeting - Logical Steps 00:09:00 Lecture-8 - Revenue Budget - What Information We Need To Make Revenue Budgets 00:08:00 Lecture-9- Example We Used In Class To Demonstrate A Broad Process In Budget And Planning 00:17:00 Lecture-10 - Cost Budget Process - Link From Revenue And Operational Plan 00:05:00 Lecture-11-Cost Budget Process - Other Aspects 00:10:00 Assignment Assignment - Making Budget & Forecast 00:00:00

🚀 Unlock Your Excel Potential with the Microsoft Excel Crash Course 2024: Masterclass for Weekend! 🚀 Are you tired of spending endless hours trying to figure out Microsoft Excel on your own? Do you want to boost your skills and become an Excel pro without sacrificing your entire weekend? Look no further - our Microsoft Excel Crash Course 2024 is here to revolutionize the way you work with spreadsheets!   🔥 Why Excel Matters: In today's data-driven world, Excel proficiency is a non-negotiable skill. Whether you're a student, a professional, or someone looking to enhance your productivity, mastering Excel can open doors to new opportunities.   💡 What Sets Our Masterclass Apart: ✅ Weekend-Friendly Format: We get it - your time is precious! That's why our course is designed to be completed over a weekend, giving you the skills you need without disrupting your busy schedule. ✅ Hands-On Learning: Forget boring lectures! Dive straight into hands-on, practical exercises that reinforce your learning. Our step-by-step approach ensures you grasp each concept thoroughly. ✅ Up-to-Date Content: Excel evolves, and so do we! Our 2024 edition is packed with the latest features and best practices, ensuring you're on the cutting edge of spreadsheet mastery. ✅ Expert Guidance: Learn from seasoned Excel experts who've cracked the code to efficient and effective spreadsheet use. Benefit from their real-world insights and insider tips that go beyond basic functions. ✅ Lifetime Access: Purchase once, benefit forever! Gain access to our course materials, updates, and a supportive community, ensuring you stay on top of your Excel game for years to come.   📚 Course Highlights: 👉 Essential Excel Functions: From basic formulas to advanced functions, we cover it all. 👉 Data Visualization: Transform your data into impactful charts and graphs. 👉 Pivot Tables Mastery: Unlock the power of data analysis with Pivot Tables. 👉 Time-Saving Shortcuts: Work smarter, not harder, with keyboard shortcuts. 👉 Advanced Formulas: Impress your colleagues with advanced calculations. 👉 Automation with Macros: Streamline your tasks with Excel automation. 👉 Error Handling: Learn how to troubleshoot and avoid common mistakes.   🎓 Who Should Enroll: Professionals looking to enhance their spreadsheet skills. Students aiming to boost their academic performance. Entrepreneurs and business owners seeking data-driven insights. Anyone wanting to save time and increase productivity.   🌟 Get Ready to Excel! Don't miss out on this opportunity to become an Excel maestro in just one weekend! Enroll now in the Microsoft Excel Crash Course 2024: Masterclass for Weekend and empower yourself with the skills that will set you apart. 👉 Limited seats available. Secure your spot now! 👈 Disclaimer: Results may vary based on individual commitment and practice. Course Curriculum Module- 1 Introduction 00:00 Getting started on Windows, macOS, Android, and IOS 00:00 How to ask great questions 00:00 FAQ 00:00 Start Excel 00:00 Module- 2 Overview of top Excel tips 00:00 Add numbers like a pro 00:00 Save time by filling cells automatically 00:00 Did data enter into one column - Split it 00:00 Switch data around by transposing it 00:00 Sort and filter for quick results 00:00 Create a data table for tasks to make it easy 00:00 Make drop-down list 00:00 Quick Data Analysis 00:00 Great charts for your visualization 00:00 Pivot Tables for Data Analytics 00:00 Module- 3 Introduction 00:00 Basic formula operations 00:00 Mathematical functions level1 00:00 Mathematical functions level2 00:00 Text functions level1 00:00 Text functions level2 00:00 Logical functions 00:00 Date time functions 00:00 V Lookup formula 00:00 HLookup formula 00:00 HLookup Match formula 00:00 Match Index formula 00:00 Module- 4 Introduction 00:00 XLookup 00:00 Handling NA and Approximates match in XLookup 00:00 Wildcard matching in XLookup 00:00 Module- 5 Introduction 00:00 Split Text into columns 00:00 Flash Fill 00:00 Remove Duplicates 00:00 Data Validation 00:00 Get - import Data from Text 00:00 Get - import Data from CSV 00:00 Module- 6 Introduction 00:00 Creating Pivot Table 00:00 Value field settings 00:00 Number format 00:00 Pivot Table Design 00:00 Excel Exercise 00:00 Solution for Excel Exercise 00:00 Module- 7 Introduction 00:00 Excel Charts - Categories 00:00 Elements of a chart 00:00 Easy way to create charts 00:00 Column or Bar charts 00:00 Formatting charts 00:00 Line charts 00:00 Area charts 00:00 Pie and Doughnut charts 00:00 Format Area Plot or XY chart 00:00 Scatter or bubble charts 00:00