Power Query and Power Pivot in Microsoft Excel: A Quickstart Guide Course Description Copyright Ross Maynard 2022 Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide. Key Learning Points On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points Pre-Course Requirements There are no pre-course requirements Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented. Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type
Overview This Excel spreadsheet for Beginner course will unlock your full potential and will show you how to excel in a career in Excel spreadsheet for Beginner. So upskill now and reach your full potential. Everything you need to get started in Excel spreadsheet for Beginner is available in this course. Learning and progressing are the hallmarks of personal development. This Excel spreadsheet for Beginner will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Mental Health skills to help you advance your career. Acquire a comprehensive understanding of various Mental Health topics and tips from industry experts. Learn in-demand Mental Health skills that are in high demand among UK employers, which will help you to kickstart your career. This Excel spreadsheet for Beginner course covers everything you must know to stand against the tough competition in the Excel spreadsheet for Beginner field. The future is truly yours to seize with this Excel spreadsheet for Beginner. Enrol today and complete the course to achieve a Excel spreadsheet for Beginner certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Excel spreadsheet for Beginner course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Excel spreadsheet for Beginner course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate. Certificate of Achievement Upon successfully completing the Excel spreadsheet for Beginner course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Excel spreadsheet for Beginner is suitable for anyone aspiring to start a career in Excel spreadsheet for Beginner; even if you are new to this and have no prior knowledge on Excel spreadsheet for Beginner, this course is going to be very easy for you to understand. And if you are already working in the Excel spreadsheet for Beginner field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. Taking this Excel spreadsheet for Beginner course is a win-win for you in all aspects. This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Excel spreadsheet for Beginner course has no prerequisite. You don't need any educational qualification or experience to enrol in the Excel spreadsheet for Beginner course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Excel spreadsheet for Beginner course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Excel spreadsheet for Beginner Tour of the Excel screen 00:10:00 Entering Data 00:13:00 Autofill Speedfill 00:09:00 Saving the file 00:02:00 Autosum 00:04:00 Formula Basics 00:11:00 Copying formulas - Relative Formulas 00:04:00 Totals and Averages 00:04:00 Formatting the Spreadsheet 00:07:00 Managing the Sheets 00:06:00 Copying formulas - absolute formulas 00:08:00 Linking the Sheets together 00:06:00 Introduction to Functions 00:05:00 Assignment Assignment - Excel spreadsheet for Beginner 00: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
Overview With the ever-increasing demand for Minute Taking 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 Minute Taking may be. Learning about Minute Taking 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 Minute Taking. 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 Minute Taking 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 Minute Taking Training 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 Minute Taking Training 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 Minute Taking Training 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 Minute Taking, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Minute Taking, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Minute Taking, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Minute Taking Training 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 of Minute Taking Introduction of Minute Taking 00:00 Module 2 - How to Write Effective Meeting Minutes How to Write Effective Meeting Minutes 00:00 Module 3 - How to Take Meeting Minutes How to Take Meeting Minutes 00:00 Module 4 - The Meeting Structure The Meeting Structure 00:00 Module 5 - Meeting Minutes' Functions, Format and Action Meeting Minutes' Functions, Format and Action 00:00 Module 6 - Tips for Minute Taking Tips for Minute Taking 00:00 Module 7 - Technology in Minute Taking Technology in Minute Taking 00:00 Module 8 - Building Confidence Building Confidence 00:00
Overview With the ever-increasing demand for Microsoft PowerPoint 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 Microsoft PowerPoint may be. Learning about Microsoft PowerPoint 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 Microsoft PowerPoint. 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 Microsoft PowerPoint 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 Microsoft PowerPoint 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 Microsoft PowerPoint 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 Microsoft PowerPoint 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 Microsoft PowerPoint, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Microsoft PowerPoint, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Microsoft PowerPoint, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Microsoft PowerPoint 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 Microsoft PowerPoint Introduction to Microsoft PowerPoint 00:00 Module 2 Setting up and Managing presentations Setting up and Managing presentations 00:00
Course Title: Basic Fundamentals of Electricity and DC Circuit Analysis Unlock the Power of Understanding with Our Comprehensive Course! Overview: Welcome to the 'Basic Fundamentals of Electricity and DC Circuit Analysis' course, where we demystify the world of electrical circuits and empower you with essential knowledge. Whether you're a novice looking to grasp the basics or a professional seeking a refresher, this course is designed to cater to all skill levels. Key Features: Foundational Understanding: We start at the very beginning, ensuring that you build a strong foundation in the principles of electricity. You'll gain insights into voltage, current, resistance, and the fundamental laws governing DC circuits. Practical Application: Theory comes to life through hands-on, practical exercises. Learn to analyze and troubleshoot DC circuits using real-world examples, enhancing your ability to apply knowledge in practical scenarios. Interactive Learning: Our engaging course structure incorporates multimedia elements, quizzes, and interactive sessions to keep you actively involved. We believe in making the learning process dynamic and enjoyable. Expert Instruction: Led by seasoned professionals with extensive experience in the field, our instructors are dedicated to ensuring that you not only understand the concepts but also gain valuable insights from their real-world expertise. Comprehensive Curriculum: From the basics of electrical components to in-depth DC circuit analysis, this course covers a wide spectrum. Topics include Ohm's Law, Kirchhoff's Laws, circuit theorems, and more. Industry-Relevant Skills: Equip yourself with skills directly applicable to various industries. Whether you're pursuing a career in electronics, electrical engineering, or simply want to enhance your DIY projects, this course provides the knowledge you need. Who Should Enroll: Students pursuing studies in electrical engineering or related fields. Professionals seeking a refresher on fundamental electrical concepts. Hobbyists and DIY enthusiasts looking to expand their skill set. Anyone curious about understanding the principles behind electrical circuits. Why Choose This Course: Versatile Skill Enhancement: Acquire skills applicable to a broad range of industries and personal projects. Career Advancement: For students, this course serves as a stepping stone to more advanced studies. Professionals can use the knowledge gained to excel in their current roles or explore new opportunities. Confidence in Handling Electrical Systems: Gain the confidence to handle electrical systems responsibly and troubleshoot issues effectively. Investment in Your Future: Electrical knowledge is a valuable asset. By investing in this course, you're investing in your personal and professional development. Don't miss out on the opportunity to master the 'Basic Fundamentals of Electricity and DC Circuit Analysis.' Enroll now and embark on a journey towards electrical expertise! Course Curriculum Introduction To Basic Fundamentals Of Electricity And Dc Circuit Analysis Course Introduction To Basic Fundamentals Of Electricity And Dc Circuit Analysis Course 00:00 The Nature Of Electricity The Nature Of Electricity 00:00 Conductors Insulators Conductors Insulators 00:00 Current And Electric Circuits Current And Electric Circuits 00:00 Ohm S Law Ohm S Law 00:00 Electric Power Electric Power 00:00 Series Parallel Circuits Series Parallel Circuits 00:00 Circuit Theorems Circuit Theorems 00:00 Electric Fields And Capacitance Electric Fields And Capacitance 00:00 Magnetism And Inductance Magnetism And Inductance 00:00 Transient Response Capacitors Inductors Transient Response Capacitors Inductors 00:00
ð Unlock the Power of Web Design with Fundamentals of CSS Course Are you ready to take your web design skills to new heights? Dive into the world of cascading style sheets (CSS) with our comprehensive course, Fundamentals of CSS. Whether you're a budding web developer, a seasoned programmer looking to enhance your skill set, or a creative individual eager to unleash your design potential, this course is your gateway to success in the digital realm. Why CSS Matters: CSS is the backbone of modern web design, allowing developers and designers to control the layout, presentation, and overall aesthetics of websites. With CSS, you can transform static web pages into dynamic, visually stunning experiences that captivate and engage users. By mastering CSS fundamentals, you'll gain the ability to create responsive designs, implement animations, and optimize user interfaces for maximum impact. What You'll Learn: In our Fundamentals of CSS course, you'll embark on a journey of discovery through key concepts such as selectors, properties, and values. You'll learn how to style text, manipulate images, and craft immersive layouts that adapt seamlessly to various screen sizes and devices. With hands-on exercises and real-world examples, you'll build a solid foundation in CSS that will empower you to tackle any design challenge with confidence. Benefits of Taking This Course: ð¨ Unleash Your Creativity: Learn how to express your unique vision through custom styles and design elements. ð Enhance Your Skill Set: Add valuable skills to your repertoire and stay ahead in today's competitive job market. ð¼ Boost Your Career Prospects: Open doors to exciting opportunities in web development, UI/UX design, and beyond. ð Increase Your Marketability: Stand out to employers and clients with a portfolio showcasing your CSS proficiency. ð©âð» Join a Thriving Community: Connect with like-minded individuals and expand your network within the tech industry. Who is This For? Our Fundamentals of CSS course is perfect for: Aspiring web developers eager to learn the building blocks of modern web design. Design enthusiasts looking to expand their skill set and create visually stunning websites. Programmers seeking to enhance their proficiency in front-end development technologies. No prior experience in web design or programming is required-all skill levels are welcome! Career Path: Upon completing the Fundamentals of CSS course, you'll be well-equipped to pursue a variety of exciting career paths, including: ð¨âð» Front-End Developer: Create captivating user experiences by translating design concepts into functional, responsive websites. ð¨ UI/UX Designer: Craft intuitive interfaces and optimize user interactions to deliver exceptional digital experiences. ð¼ Freelance Designer: Showcase your CSS expertise to clients and build a thriving freelance business offering web design services. ð Digital Marketing Specialist: Develop visually compelling websites and landing pages that drive conversions and engage audiences. Don't miss out on this opportunity to master the art of CSS and unlock a world of possibilities in web design and development. Enroll in our Fundamentals of CSS course today and take the first step towards transforming your creative vision into reality! FAQs (Frequently Asked Questions) Is this course suitable for beginners? Absolutely! Our Fundamentals of CSS course is designed to cater to learners of all skill levels, including those who are completely new to web design and programming. We provide step-by-step guidance and clear explanations to ensure that even beginners can grasp the core concepts of CSS with ease. Do I need any special software or tools to participate in the course? No, you don't need any specialized software or tools to enroll in our course. All you need is a computer with internet access and a modern web browser. We'll provide you with everything you need to get started, including access to online resources, code editors, and practice exercises. How long does it take to complete the course? The duration of the course can vary depending on your individual learning pace and schedule. On average, most students complete the Fundamentals of CSS course within [insert average duration here] weeks. However, you're free to study at your own pace and can access the course materials at any time, allowing you to tailor your learning experience to fit your needs. Will I receive a certificate upon completing the course? Yes, upon successfully completing the Fundamentals of CSS course, you'll receive a certificate of completion to showcase your achievement. This certificate can be added to your resume, LinkedIn profile, or portfolio to demonstrate your proficiency in CSS fundamentals to potential employers or clients. Are there any prerequisites for this course? While there are no strict prerequisites for enrolling in the Fundamentals of CSS course, having a basic understanding of HTML would be beneficial. However, we cover essential HTML concepts as part of the course curriculum, so you can still succeed even if you're not familiar with HTML beforehand. Is there any instructor support available during the course? Yes, we provide dedicated instructor support to assist you throughout your learning journey. Whether you have questions about course material, need clarification on a concept, or require additional assistance, our team of experienced instructors is here to help. You can reach out to us via email, discussion forums, or live chat for personalized support and guidance. Can I access the course content after completing it? Yes, once you've completed the Fundamentals of CSS course, you'll have lifetime access to the course materials. This means you can revisit the lessons, review the concepts, and continue honing your CSS skills whenever you like, even after completing the course. We hope these FAQs have addressed any concerns you may have had about our Fundamentals of CSS course. If you have any further questions or would like more information, feel free to reach out to our support team-we're here to help you succeed! Course Curriculum Chapter 1_ Introduction To CSS Chapter 1_ Introduction To CSS 00:00 Chapter 2_ Element Properties Chapter 2_ Element Properties 00:00 Chapter 3_ Colours Chapter 3_ Colours 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
Description: Computer Specialist Diploma Course is intended for those who wants to gain computer skills and knowledge. It has modules which will give you all the ins and outs of operating on a personal computer and its broad applications. First of all, it will cover all the fundamental computing terms, input, output, and storage devices. You will also learn about the operating systems, interface and its applications. As you step up through the hierarchy of the basic to intermediate to expert levels, you will be exposed to several contents which will teach you about networking, internet basic, ergonomics, safeguarding your data from malware, customization, etc. And the end, you will have a profound knowledge about computers. Learning Outcomes: Realise the common computing concepts Figure out the difference between hardware and software, as well as how they work Realise the operations of information networks Be conscious of security measures as well as learn working safely Obtain knowledge of the primary steps of operating a computer, involving using the keyboard,mouse, and Windows desktop Become competent to manage and use files and folders with proficiency Get knowledge of how to implement the fundamental Windows Applications,at the same time, learn Wordpad, Notepad, Task Manager, Calculator, Paint and Internet Explorer. Understand general computing concepts Understand the difference between hardware and software, and how each works Understand how information networks operate Become aware of security concerns and how to work safely Learn the first steps of using a computer, including using the keyboard, mouse, and Windows desktop Be able to effectively manage and use files and folders Learn how to use the basic Windows applications, including WordPad, NotePad, Task Manager, Calculator, Paint, and Internet Explorer Basic computing terms The fundamental computing skills Anatomy of a PC Input, output, and storage devices Operating systems and applications Legal issues, including licensing of software Networking and Internet basics Computers in the workplace Telecommuting and the electronic world Ergonomics, safety, and the environment Being proactive about security Protecting your data Understanding malware Using the mouse, keyboard, and desktop Customizing your computer Printing Understand and using files and folders Basic Windows applications Working with a window Working with applications Browsing the Web Realise the common computing concepts Figure out the difference between hardware and software, and how they function Interpret how information networks work Be alert of security measures as well as how you can work safely Acquire the knowledge of operating the first steps of a computer, learn how to use the keyboard, mouse, as well as Windows desktop Become competent to proficiently handle and apply files and folders Attain knowledge of operating fundamental Windows applications, along with Wordpad, Notepad, Task Manager, Calculator, Paint and Internet Explorer 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? Computer Specialist Diploma 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 Computer Specialist Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module 01 Basic Terms 00:15:00 Types of Computers 00:15:00 Anatomy of a PC 00:30:00 How a PC Works 00:15:00 CPU and Memory 00:30:00 Input Devices 00:15:00 Output Devices 00:15:00 Secondary Storage Devices 00:30:00 The Basics 00:15:00 Operating Systems and Applications 00:30:00 How is Software Built 00:15:00 Types of Software 00:15:00 Legal Issues 00:15:00 Module 02 Basic Terms 00:15:00 Advanced Terms 00:15:00 Networking Basics 00:15:00 Basic Internet Concepts 00:30:00 Internet Security 00:30:00 Computers in the Workplace 00:15:00 Tele-Commuting 00:15:00 The Electronic World 00:15:00 Ergonomics 00:15:00 Safety and the Environment 00:15:00 Being Proactive 00:15:00 Identifying Yourself 00:15:00 Protecting Your Data 01:00:00 Understanding Malware 00:15:00 Protecting Against Malware 00:15:00 Module 03 Application Basics 00:30:00 Basic Applications 01:00:00 Working with a Window 01:00:00 Working with WordPad 01:00:00 Working With Applications 01:00:00 Basics of Web Browsers 01:00:00 Browsing the Web 00:15:00 Working with Bookmarks 01:00:00 Working With Web Pages 01:00:00 Printing Web Pages 01:00:00 Module 04 First Steps 00:30:00 Basic Tasks 01:00:00 Using the Desktop 00:15:00 Customizing Your Computer 00:15:00 Printing 00:15:00 The Basics of Files and Folders 00:10:00 Managing Files and Folders, Part I 01:00:00 Managing Files and Folders, Part II 00:15:00 Viewing File or Folder Properties 00:30:00 Working With Files and Folders 00:30:00 Compressed Files 00:05:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00