310 Computing Skills courses in Nottingham delivered On Demand

Overview With the ever-increasing demand for History of Computer Games in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in History of Computer Games may be. Learning about History of Computer Games or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in History of Computer Games . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on History of Computer Games is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this History of Computer Games course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this History of Computer Games course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this History of Computer Games course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of History of Computer Games , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in History of Computer Games , Anyone looking for a certificate of completion on doing an online training on this topic, Students of History of Computer Games , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This History of Computer Games course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.  Course Curriculum Module 1-Introduction to the History of Computer Games Module 1-Introduction to the History of Computer Games 00:00 Module 2-Ancient age of Computer Games Module 2-Ancient age of Computer Games 00:00 Module 3- Rising of Computer Games Module 3- Rising of Computer Games 00:00 Module 4-Modern Period of Computer Games Module 4-Modern Period of Computer Games 00:00

Overview With the ever-increasing demand for SQL in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in SQL may be. Learning about SQL or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in SQL . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on SQL is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this SQL course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this SQL course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this SQL course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of SQL , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in SQL , Anyone looking for a certificate of completion on doing an online training on this topic, Students of SQL , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This SQL course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.  Course Curriculum Module 1- Introduction to SQL Introduction to SQL 00:00 Module 2 - SQL Installation SQL Installation 00:00 Module 3 - Beginner SQL Beginner SQL 00:00 Module 4 - Queries Queries 00:00 Module 5 - Intermediate SQL Intermediate SQL 00:00 Module 6 - Advanced SQL Operators Advanced SQL Operators 00:00

💻 Want to improve your IT skills? Compete High’s Functional Skills IT Training (ICT) course covers everything from basic computer use to cybersecurity! 📚 Learn online at your own pace and earn a certificate. Perfect for beginners and professionals alike! 🎓🚀

Overview With the ever-increasing demand for Functional Skills in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Functional Skills may be. Learning about Functional Skills or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Functional Skills . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Functional Skills is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Functional Skills course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Functional Skills course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Functional Skills course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Functional Skills , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Functional Skills , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Functional Skills , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Functional Skills course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.    Course Curriculum Functional Skills Maths Level 2 Module 01 Introduction Introduction 00:00 Functional Skills Maths Level 2 Module 2 Basic arithmetic Basic arithmetic 00:00 Functional Skills Maths Level 2 Module 3 Fractions Fractions 00:00 Functional Skills Maths Level 2 Module 4 Decimals Decimals 00:00 Functional Skills Maths Level 2 Module 5 Using a calculator Using a calculator 00:00 Functional Skills Maths Level 2 Module 6 Percentages Percentages 00:00 Functional Skills Maths Level 2 Module 7 Ratio and proportion Ratio and proportion 00:00 Functional Skills Maths Level 2 Module 8 Powers, roots and laws of indices Powers, roots and laws of indices 00:00 Functional Skills Maths Level 2 Module 9 Units, prefixes and engineering notation Units, prefixes and engineering notation 00:00

Overview With the ever-increasing demand for Computer Maintenance in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Computer Maintenance may be. Learning about Computer Maintenance or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Computer Maintenance . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Computer Maintenance is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Computer Maintenance course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Computer Maintenance course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Computer Maintenance course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Computer Maintenance , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Computer Maintenance , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Computer Maintenance , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Computer Maintenance course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.  Course Curriculum Computer Maintenance Module 01 - Introduction to Computers Module 01 - Introduction to Computers 00:00 Computer Maintenance Module 02 - Structure of Computers Module 02 - Structure of Computers 00:00 Computer Maintenance Module 03 - Hardware Module 03 - Hardware 00:00 Computer Maintenance Module 04 - Software and Interface Module 04 - Software and Interface 00:00 Computer Maintenance Module 05 - Viruses and Computer Maintenance Module 05 - Viruses and Computer Maintenance 00:00 Computer Maintenance Module 06 - Internet and IT Module 06 - Internet and IT 00:00 Computer Maintenance Module 07 - Cyber Security Module 07 - Cyber Security 00:00

🌟 Unlock the Full Power of Microsoft Excel 2019! 🌟 Ready to take your Excel skills to the next level? Dive into our comprehensive online course - 'Microsoft Excel 2019 - Advanced Level Training' - designed to transform you into an Excel maestro! 🚀 Here's What You'll Master: 📊 Section 1: Excel - Advanced - Get hands-on with advanced techniques and shortcuts to streamline your workflow. 📂 Section 2: Working with Multiple Workbooks - Seamlessly manage multiple workbooks and boost your productivity effortlessly. 🔒 Section 3: Protecting Worksheets and Workbooks - Learn how to safeguard your data with robust protection strategies. 📝 Section 4: Conditional Formulas - Unravel the power of conditional logic and unleash the true potential of formulas. 🧮 Section 5: Advanced Functions - Elevate your Excel expertise by mastering complex functions for data analysis. 📚 Section 6: Text Based Functions - Manipulate text effortlessly and efficiently with advanced text-based functions. 🔍 Section 7: What IF Tools - Explore the 'What If' analysis tools to make informed decisions and predictions. 🏁 Section 8: Excel Advanced - Conclusion - Wrap up with a comprehensive understanding and practical application of advanced Excel features. 🎁 Section 9: Bonus #1 - Advanced Pivot Tables - Delve into bonus content covering advanced techniques for Pivot Tables, a must-have skill for data analysis pros. 🌟 Why Choose Our Course? 🔐 Expert Guidance: Led by seasoned Excel professionals, ensuring clarity and depth in learning. 🔄 Practical Assignments: Apply your newfound skills through real-world exercises. 📈 Career Growth: Elevate your career prospects by mastering sought-after Excel abilities. 🌐 Accessible Learning: Study at your own pace from anywhere, anytime with our user-friendly online platform. 🤝 Join our vibrant community of learners dedicated to mastering Excel's advanced functionalities. 💡 Enroll now and revolutionize your Excel prowess with 'Microsoft Excel 2019 - Advanced Level Training'! Don't miss this chance to become an Excel wizard! 💡   Course Curriculum Section 1 - Excel - Advanced Excel Advanced Introduction 01:39 Advanced Shortcut Keys 02:58 Section 2 - Working with Multiple Workbooks Tracing Precedents 00:00 Tracing Dependants 00:00 Watch Window 00:00 Show Formulas 00:00 Section 3 - Protecting Worksheets and Workbooks Protecting Cells in a Worksheet 00:00 Protecting the Workbook Structure 00:00 Encryption with Passwords 00:00 Section 4 - Conditional Formulas Name Ranges 00:00 Simple IF Function 00:00 IF, AND 00:00 IF, OR 00:00 Nested Formulas 00:00 CountIF and CountIFs 00:00 SumIF and SumIFs 00:00 Section 5 - Advanced Functions Advanced VLookUp 00:00 IF and IS Error - Part 1 00:00 IF and IS Error - Part 2 00:00 Advanced Index Match 00:00 Dates - Part 1 00:00 Dates - Part 2 00:00 Replace and Substitute - Part 1 00:00 Replace and Substitute - Part 2 00:00 Section 6 - Text Based Functions Left, Right and Mid Function 00:00 Search Function 00:00 Concatenate and Search 00:00 Indirect - Static 00:00 Indirect - Dynamic 00:00 Section 7 - What IF Tools Goal Seek 00:00 Data Tables 00:00 Scenarios 00:00 Solver 00:00 Section 8 - Excel Advanced - Conclusion Excel Advanced - Conclusion 00:00 Section 9 - Bonus # 1 - Advanced Pivot Tables Building a Mini Dashboard 00:00

🚀 Unleash the Power of C++ with our Exclusive Advanced Master Classes! 🚀 Ready to elevate your C++ skills to the next level? Dive deep into the world of Object-Oriented Programming (OOP) and Templates with our cutting-edge online course: 'Learn C++ Advanced: Master Classes on OOPs and Templates.'   🔥 What You'll Gain: ✅ Mastery of OOP Concepts: Go beyond the basics and discover advanced OOP principles that will make your code more robust, scalable, and maintainable. ✅ Template Magic: Unlock the true potential of C++ templates and learn how to leverage them for generic programming, creating flexible and efficient code. ✅ Real-world Applications: Gain practical insights by working on hands-on projects and real-world case studies, applying your newfound knowledge to solve complex problems. ✅ Expert Guidance: Learn from industry experts with years of experience in C++ development. Our instructors are dedicated to helping you grasp even the most challenging concepts. ✅ Comprehensive Curriculum: Cover a wide range of advanced C++ topics, from smart pointers and inheritance to template metaprogramming and design patterns. ✅ Lifetime Access: Get access to course materials, updates, and a vibrant community for a lifetime. Stay current with the latest C++ trends and technologies. ✅ Certification of Completion: Showcase your expertise with a prestigious certificate upon successfully completing the course. Stand out to employers and peers alike.   💡 Who Is This Course For? Whether you're a seasoned C++ developer looking to enhance your skills or a passionate learner eager to delve into advanced programming concepts, this course is tailored for you. It's the perfect stepping stone for those aiming to become elite C++ developers.   🌐 Why Choose Our Course? 🚀 Engaging Content: Our modules are designed for maximum engagement, combining video lectures, coding exercises, quizzes, and real-world projects.   🤝 Community Support: Join a thriving community of learners and interact with instructors and peers. Exchange ideas, seek help, and collaborate on projects.   🌟 Proven Results: Our students have reported increased confidence and success in their professional endeavors after completing our courses. Don't miss the opportunity to become a C++ master! Enroll now and unlock the full potential of your programming journey. Course Curriculum Module- 1 Introduction 00:00 Course Curriculum 00:00 Getting started on windows, mac or Linux 00:00 How to ask great questions 00:00 FAQ's 00:00 Get and Installing Visual Studio Editor 00:00 Creating First Project 00:00 C++ Hello World Program 00:00 Compile and Run a CPP Program 00:00 Module- 2 Introduction 00:00 What are oops 00:00 Data structures 00:00 What are access modifiers 00:00 Module- 3 Introduction 00:00 Creating a class 00:00 Creating an objects 00:00 Class methods 00:00 Adding parameters 00:00 Constructors 00:00 Constructor with parameters 00:00 Default constructor 00:00 The destructor 00:00 Get and set methods 00:00 Access modifiers 00:00 Static members 00:00 Module- 4 Introduction 00:00 Constant objects and functions 00:00 Pointers to class and object 00:00 Array of objects 00:00 Module- 5 Introduction 00:00 Overloading the equality operator 00:00 Overloading the stream insertion operator 00:00 Overloading the stream insertion operator 00:00 Overloading the binary arithmetic operators 00:00 Overloading the assignment operators 00:00 Overloading the unary operators 00:00 Overloading the subscript operator 00:00 Inline functions 00:00 Module- 6 Introduction 00:00 Inheritance 00:00 Protected members 00:00 Constructors and Inheritance 00:00 Destructors and Inheritance 00:00 Overriding methods 00:00 Polymorphism 00:00 Abstract classes 00:00 Final classes and methods 00:00 Deep inheritance and methods 00:00 Multiple Inheritance 00:00 Module- 7 Multiple Inheritance 00:00 What are exceptions 00:00 Throwing an exception 00:00 Catching an exception 00:00 Catching multiple exceptions 00:00 Create custom exceptions 00:00 Module- 8 Introduction 00:00 Creating a function template 00:00 Function template arguments 00:00 Overloading a function template 00:00 Creating a class template 00:00 Templates with multiple parameters 00:00

🌟 Unlock Your Excel Potential with Microsoft Excel 2019 - Intermediate Level Training! 🌟 Master the art of Excel with our comprehensive online course designed specifically for intermediate learners. Elevate your skills, boost productivity, and excel in spreadsheet management like never before. 📊 Course Curriculum 📊 🔹 Section 1 - Excel - Intermediate: Dive into the intermediate level of Excel functionalities, bridging the gap between basic and advanced techniques. 🔹 Section 2 - Lists: Learn the art of managing data efficiently with lists, organizing information for streamlined analysis and presentation. 🔹 Section 3 - DataBase Functions: Harness the power of database functions, empowering you to manipulate data with ease and precision. 🔹 Section 4 - Data Validation: Ensure data accuracy and integrity by implementing effective data validation techniques, preventing errors in your spreadsheets. 🔹 Section 5 - Importing and Exporting: Master the process of importing and exporting data seamlessly, integrating external information into your Excel sheets effortlessly. 🔹 Section 6 - Creating Basic Charts: Transform data into impactful visuals with basic chart creation, enhancing your ability to communicate insights effectively. 🔹 Section 7 - Pivot Tables: Unlock the potential of pivot tables, harnessing their analytical power to summarize and analyze complex data sets effortlessly. 🔹 Section 8 - Working with Large Data: Navigate and manipulate extensive data sets efficiently, optimizing your workflow with strategies tailored for large-scale information. 🔹 Section 9 - LookUp Functions: Explore lookup functions to search for and retrieve specific data, refining your ability to find information swiftly. 🔹 Section 10 - Advanced Functions: Elevate your Excel proficiency with advanced functions, expanding your capabilities to handle complex calculations and tasks. 🔹 Section 11 - Excel Intermediate - Conclusion: Wrap up your intermediate Excel journey, reinforcing key concepts and preparing you for further advancements. 🎓 Why Choose Our Course? 🎓 🚀 Comprehensive Learning: A structured curriculum tailored to the needs of intermediate Excel users, covering a wide array of functionalities. 👨‍🏫 Expert Guidance: Led by industry experts well-versed in Excel, ensuring a rich learning experience with practical insights. 🤝 Interactive Learning: Engage with interactive exercises and real-life examples, solidifying your understanding through hands-on practice. 📈 Career Growth: Acquire skills highly sought after in the job market, giving you a competitive edge in various professional domains. 🔓 Don't miss this opportunity to take your Excel skills to the next level! Enroll now and unleash your potential with Microsoft Excel 2019 - Intermediate Level Training. 🔓 Course Curriculum Section 1 - Excel - Intermediate Excel Intermediate Introduction 00:00 Intermediate Shortcut Keys 00:00 Section 2 - Lists What are Lists 00:00 Sorting a List 00:00 Sorting - Multiple Criteria 00:00 Custom Sort 00:00 What are Filters 00:00 Format a List as a Table 00:00 Section 3 - DataBase Functions Introduction to DataBase Functions 00:00 DSum Function 00:00 DSum Function - Single Criteria 00:00 DSum Function - Multiple Criteria 00:00 DAverage 00:00 DCount Function 00:00 Subtotal 00:00 Section 4 - Data Validation Data Validation - List 00:00 Data Validation - Decimal 00:00 Input and Error Messages 00:00 Section 5 - Importing and Exporting Importing Data from Text Files 00:00 Importing Data from MS Access 00:00 Exporting Data to a Text File 00:00 Section 6 - Creating Basic Charts Creating Basic Charts 00:00 The Chart Ribbon 00:00 Adding and Modifying Data on a Chart 00:00 Formatting Charts 00:00 Section 7 - Pivot Tables Understanding Pivot Tables 00:00 Creating Pivot Tables 00:00 Pivot Table Calculations 00:00 Grouping Pivot Table Data 00:00 Formatting Pivot Table Data 00:00 Drilling Down into Pivot Table Data 00:00 Creating Pivot Charts 00:00 Filtering Pivot Table Data 00:00 Filtering using the Slicer 00:00 Section 8 - Working with Large Data Grouping Data 00:00 Consolidating Data 00:00 Section 9 - LookUp Functions VLookUp 00:00 HLookUp 00:00 Index and Match 00:00 Section 10 - Advanced Functions FV Function 00:00 PMT Function 00:00 Hyperlinks 00:00 Text to Columns 00:00 Section 11 - Excel Intermediate - Conclusion Excel Intermediate - Conclusion 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

Title: Mastering the Future: Digital Electrical Circuits and Intelligence Electrical Devices Course   Overview: Welcome to a transformative journey into the cutting-edge realm of 'Digital Electrical Circuits and Intelligence Electrical Devices.' In today's rapidly evolving technological landscape, the demand for skilled professionals who can navigate the complexities of digital circuits and intelligent devices is greater than ever. This comprehensive course is designed to equip you with the knowledge and skills needed to not only understand but also master the intricacies of digital electrical circuits and harness the power of intelligent electrical devices.   Key Features: Comprehensive Curriculum: Our course covers a wide spectrum of topics, from the fundamentals of digital electrical circuits to the advanced principles behind intelligent electrical devices. You'll delve into topics such as digital signal processing, microcontrollers, embedded systems, and more. Hands-On Learning: Theory comes to life through hands-on projects and practical exercises. You'll have the opportunity to apply your knowledge in real-world scenarios, ensuring that you not only understand the concepts but can also implement them effectively. Cutting-Edge Technologies: Stay ahead of the curve by learning about the latest advancements in digital circuits and intelligent devices. Explore the world of artificial intelligence, machine learning, and the Internet of Things (IoT) to understand how they intersect with electrical engineering. Expert Instruction: Benefit from the guidance of experienced instructors who bring a wealth of industry knowledge to the classroom. Our instructors are dedicated to your success, providing support and insights throughout the course. Industry-Relevant Projects: Gain practical experience by working on projects that mirror real-world challenges faced by professionals in the field. Build a portfolio that showcases your abilities and sets you apart in a competitive job market. Networking Opportunities: Connect with like-minded individuals and industry experts through networking events, forums, and collaborative projects. Expand your professional network and open doors to new opportunities. Flexible Learning: Designed to accommodate various schedules, our course offers flexibility through online lectures and resources. Access course materials at your own pace, allowing you to balance your learning with other commitments. Certification: Upon successful completion of the course, receive a recognized certification that validates your expertise in digital electrical circuits and intelligent electrical devices, enhancing your credibility in the job market.   Whether you're a seasoned professional looking to upskill or a student aspiring to enter the field of electrical engineering, our 'Digital Electrical Circuits and Intelligence Electrical Devices' course provides the knowledge and practical experience needed to thrive in the dynamic world of technology. Enroll now to embark on a journey towards mastering the future of electrical engineering! Course Curriculum Introduction To Digital Electric Circuits Introduction To Digital Electric Circuits 00:00 Numbering Systems Numbering Systems 00:00 Binary Arithmetic Binary Arithmetic 00:00 Logic Gates Logic Gates 00:00 Flip-Flops Flip-Flops 00:00 Counters Shift Registers Counters Shift Registers 00:00 Adders Adders 00:00