345 Computing Skills courses delivered Online

🌟 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

Course Overview Julia is one of the highest performing programming languages. The Tutorials - The Julia Programming Language course is designed to train you in this valuable programing language. In this course, you will get equipped with the skills to code in Julia and add available skill sets to your resume. The Tutorials - The Julia Programming Language course will introduce you to the basic principles of Julia programming language. In this course, you will learn the steps to install Julia. You will get introduced to Julia variables, integers, sign function and more. The course will provide you with lectures based on Cher types and strings. You will start to understand all the functions of this programming language. The course will give you an extensive understanding of Julia Dict and type. By the end of the course, you will pick up all the valuable information and skills to use this language. Learn the ins and outs of Julia programming language from the Tutorials - The Julia Programming Language course. This course will increase your abilities and boost your employability in the relevant industry. Learning Outcomes Understand the process of installing Julia Familiarize yourself with Julia variables and functions Enrich your understanding of Cher types and strings Learn the details of conditional and non-conditional blocks Grasp the skills essential for Juila Dict operations Who is this course for? This Tutorials - The Julia Programming Language course is suitable for programmers, data scientists, or individuals who want to learn a new programming language. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Tutorials - The Julia Programming Language course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Programmer Data Scientist Introduction Learning Julia 00:01:00 Installing Julia 00:06:00 Installing Juno 00:04:00 Begin Dancing with Julia Julia Variables 00:05:00 Julia Integers and Floats 00:05:00 Julia Convert and Comparisons 00:03:00 Rounding Operations 00:05:00 Division Function 00:04:00 Sign Function and Power 00:05:00 Complex and Rational Numbers 00:05:00 Julia Chars and Strings Julia Char type 00:03:00 String Literals 00:02:00 Extract Char and String 00:02:00 Concatenate and Interpolate 00:03:00 isEqual and Comparisons 00:04:00 Find and OccursIn 00:05:00 Repeat and Regex 00:04:00 Julia Functions Julia Function Object 00:04:00 Function Return Type 00:06:00 Functions as Objects and Arguments 00:04:00 Operators as Functions 00:02:00 Anonymous Function 00:04:00 Function Arguments Tuples 00:05:00 Unpacking Tuples 00:02:00 Varargs 00:03:00 Optional Arguments 00:03:00 Keyword Arguments 00:03:00 Conditional and Non-Conditional Blocks Do Block 00:04:00 Compound Expression 00:02:00 If Statements 00:05:00 If Statement Return Value 00:02:00 Short Circuit Evaluation 00:03:00 Loops and Exceptions For Loop 00:02:00 Control and Nest For Loops 00:03:00 Exceptions 00:03:00 Julia Try and Catch 00:03:00 While Loop 00:02:00 Variable Scope 00:05:00 Arrays in Julia Arrays 00:04:00 Pop and Push 00:03:00 Multidimensional Arrays 00:03:00 Copying Arrays 00:02:00 Julia Dicts Dicts 00:02:00 Dict Operations 00:02:00 More Dict Operations 00:04:00 More Cool Dict Operations 00:03:00 One More Cool Dict Operation 00:04:00 Broadcasting 00:04:00 Julia Types Julia Types 00:01:00 Verify and Specify Types 00:03:00 More Verification and Specification 00:05:00 Julia Methods 00:02:00 Composite Types 00:05:00 Mutable Structs 00:02:00 Constructor Functions 00:04:00 Modules and Packages Julia Modules 00:02:00 Using Packages 00:04:00 User Defined Modules 00:05:00 Working with Text Files Reading Text Files 00:04:00 Writing To Text Files 00:03:00 Writing Collections To Files 00:02:00 Julia Date and Time Date And Time 00:03:00 Date Queries 00:02:00 Date Arithmetic 00:03:00 Meta Programming in Julia Meta Programming 00:02:00 Quoted Expression 00:04:00 Macros 00:02:00 REST APIs and MySQL Using Genie 00:04:00 Payloads and POST Requests 00:05:00 Julia and MySQL 00:08:00 DataFrames and Plots DataFrames 00:05:00 Plotting with Plots 00:02:00 Where to go from here 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Learning Objectives Introduction , Getting Started with Excel , Creating Workbooks and Using Templates , Entering Data , Excel Formula Basics , Adjusting a Worksheet , Formatting and Aligning Data , Using Cell Styles and Themes , Inserting Objects and Graphics , Proofing a Workbook , Printing an Excel File , Managing Worksheets , Navigating and Viewing Excel Files , Conclusion   Pre-Requisites Basic Computer Skills   Description Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks. Section 01 Lesson 01: What is Excel 00:03:00 Lesson 02: Opening Excel 00:04:00 Lesson 03: Navigating the Excel User Interface-v2 00:06:00 Lesson 04: Navigating the Excel User Interface 00:04:00 Lesson 05: Using the Excel Ribbon 00:07:00 Lesson 06: Understanding Excel Worksheet Components 00:07:00 Lesson 07: Using the Backstage View 00:06:00 Section 02 Lesson 01: Creating a New Workbook 00:06:00 Lesson 02: Saving an Excel Workbook 00:05:00 Lesson 03: Using the Accessibility Checker 00:04:00 Lesson 04: Using the Accessibility Checker-v3 00:04:00 Section 03 Lesson 01: Navigating a Worksheet by Mouse or Keyboard 00:05:00 Lesson 02: Understanding Excel Data Types 00:04:00 Lesson 03: Using the Inking Tools 00:05:00 Lesson 04: Using the Inking Tools-v3 00:03:00 Lesson 05: Working with Cell and Range Addressing 00:05:00 Lesson 06: Using Various Data Selection Techniques 00:05:00 Lesson 07: Working with Common Excel Commands 00:06:00 Lesson 08: Using Flash Fill and Autofill 00:06:00 Section 04 Lesson 01: What are Formulas and Functions 00:05:00 Lesson 02: Understanding the Components of a Formula 00:05:00 Lesson 03: Understanding Calculation Hierarchy and the Order of Operations 00:03:00 Lesson 04: Creating Basic Formulas 00:05:00 Lesson 05: Working with Basic Functions and AutoSum 00:06:00 Lesson 06: Using Cell References 00:05:00 Lesson 07: Using the Quick Analysis Tool 00:03:00 Section 05 Lesson 01: Modifying Columns and Rows 00:06:00 Lesson 02: Hiding and Unhiding Columns and Rows 00:06:00 Section 06 Lesson 01: Formatting and Aligning Data 00:07:00 Lesson 02: Merging Data 00:07:00 Lesson 03: Wrapping Text and Adjusting Orientation 00:06:00 Lesson 04: Formatting Numbers 00:05:00 Lesson 05: Using the Format Painter 00:04:00 Section 07 Lesson 01: Using Cell Styles 00:06:00 Lesson 02: Applying Themes 00:05:00 Section 08 Lesson 01: Inserting and Formatting Images and Shapes 00:08:00 Lesson 02: Inserting and Formatting SmartArt 00:05:00 Lesson 03: Working with Icons 00:04:00 Lesson 04: Inserting Hyperlinks 00:06:00 Lesson 05: Inserting Symbols and Equations 00:05:00 Lesson 06: Inserting WordArt and Text Boxes 00:05:00 Lesson 07: Inserting 3-D Models 00:04:00 Lesson 08: Arranging Objects 00:06:00 Section 09 Lesson 01: Using Find and Replace 00:05:00 Lesson 02: Using Go To and Go To Special 00:03:00 Lesson 03: Using the Spell Checker 00:05:00 Lesson 04: Using the Thesaurus and Translation Features 00:05:00 Lesson 05: Using the resolve Feature-v3 00:02:00 Section 10 Lesson 01: Printing and Previewing Excel Files 00:06:00 Lesson 02: Creating Custom Margins and Scaling 00:05:00 Lesson 03: Adding Headers and Footers 00:04:00 Lesson 04: Formatting a Page with the Page Layout Tab 00:06:00 Lesson 05: Printing Titles and Specific Worksheet Areas 00:03:00 Lesson 06: Exporting to PDF-v3 00:02:00 Lesson 07: Exporting to PDF and XPS 00:04:00 Section 11 Lesson 01: Renaming and Coloring Worksheet Tabs 00:03:00 Lesson 02: Adding, Deleting and Navigating Worksheets 00:03:00 Lesson 03: Hiding and Unhiding Worksheets 00:03:00 Section 12 Lesson 01: Viewing Workbooks 00:03:00 Lesson 02: Using Zoom Tools 00:03:00 Lesson 03: Configuring Sheet Options 00:05:00 Lesson 04: Using the Freeze Panes and Split Commands 00:04:00 Lesson 05: Adjusting Worksheet Properties 00:04:00 Lesson 06: Viewing Workbook Statistics-v3 00:02:00 Course Recap Recap 00:02:00 Final Exam Final Exam - Excel 365 Beginner 00:20:00

Description: Are you interested in a career in computer science? Programming is the art of writing useful, maintainable, and extensible source codes which can be read or compiled by a computer system to perform a significant task. Take your first step towards learning core programming concepts and equip yourself with the practical knowledge and skills to resolve complicated problems. Discover all you need to know about programming language with this computer science course. By learning the correct programming theory, you will be able to analyse a problem and identify suitable solutions to those problems, which is a key part of web development. Apart from the theories of Algorithm analysis, this computer programming course also teaches the number system, arrays and their advantages, the process of analysing a problem, nodes and their Importance, and various sorting algorithms and their comparisons. There are no entry requirements for this course and you can study from the comfort of your own home. Enrol in this Diploma in Computer Science and Programming course today and learn to write code like an expert. Who is the course for? Anyone who wants to become a Good Programmer Anyone interested in the Computer Science Discipline Anyone who wants to learn how to problem solve like a Computer Scientist Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After 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 £14.99 or in PDF format at a cost of £11.99. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Kurt Anderson - Promo FREE 00:02:00 Kurt Anderson - 1 Introduction 00:01:00 Kurt Anderson - 2 Binary System 00:11:00 Analyzing Algorithms Kurt Anderson - 3 Complexity Introduction 00:02:00 Kurt Anderson - 4 Math Refresher Logarithmic Functions 00:11:00 Kurt Anderson - 5 Math Refresher Factorial Functions.TS 00:03:00 Kurt Anderson - 6 Math Refresher Algebraic Expressions.TS 00:03:00 Kurt Anderson - 7 n-notation 00:18:00 Kurt Anderson - 8 Big O 00:13:00 Kurt Anderson - 9 Big O Real World Example 00:10:00 Arrays Kurt Anderson - 10 How is Data Stored 00:09:00 Kurt Anderson - 11 Fixed Arrays 00:20:00 Kurt Anderson - 12 Circular Arrays 00:08:00 Kurt Anderson - 13 Dynamic Arrays 00:16:00 Kurt Anderson - 14 Array Review 00:08:00 Kurt Anderson - 15 Array Real World Examples 00:06:00 Linked Lists Kurt Anderson - 16 Nodes 00:04:00 Kurt Anderson - 16 Linked List 00:14:00 Kurt Anderson - 17 Linked List Run Times 00:15:00 Kurt Anderson - 18 Doubly Linked Lists 00:08:00 Kurt Anderson - 19 Tail Pointer 00:05:00 Kurt Anderson - 20 Linked List Real World Examples 00:03:00 Kurt Anderson - 21 Linked List Review 00:04:00 Stacks and Queues Kurt Anderson - 22 Stacks 00:10:00 Kurt Anderson - 20 Stack Example 00:11:00 Kurt Anderson - 23 Queues 00:09:00 Kurt Anderson - 24 Queue Examples 00:10:00 Kurt Anderson - 25 Queue and Stack Run Times 00:06:00 Kurt Anderson - 26 Stack and Queues Real World Examples 00:07:00 Sorting Algorithms Kurt Anderson - 27 Sorting Algorithm Introdcution 00:02:00 Kurt Anderson - 28 Bubble Sort 00:10:00 Kurt Anderson - 29 Selection Sort 00:10:00 Kurt Anderson - 30 Insertion Sort 00:09:00 Kurt Anderson - 31 Quick Sort 00:15:00 Kurt Anderson - 32 Quick Sort Run Times 00:10:00 Kurt Anderson - 33 Merge Sort 00:12:00 Kurt Anderson - 34 Merge Sort Run Times 00:08:00 Kurt Anderson - 35 Stable vs Nonstable 00:07:00 Kurt Anderson - 36 Sorting Algorithm Real World Examples 00:04:00 Trees Kurt Anderson - 37 Basics of Trees 00:08:00 Kurt Anderson - 38 Binary Search Tree 00:09:00 Kurt Anderson - 39 BST Run Times 00:08:00 Kurt Anderson - 40 Tree Traversals 00:13:00 Kurt Anderson - 41 Tree Real World Examples 00:05:00 Heaps Kurt Anderson - 42 Heap Introduction 00:04:00 Kurt Anderson - 43 Heap Step by Step 00:12:00 Kurt Anderson - 44 Heap Real World Examples 00:07:00 Conclusion Kurt Anderson - 45 Thank You 00:01:00 Course Certification Order Your Certificates and Transcripts 00:00:00

Overview Functional maths and English skills are highly valued in a wide range of industries. From education to marketing, these skills can open career opportunities in a wide range of areas. Polish your maths and English skills with our Functional Skills Maths & English course. This course aims to help you develop both English and maths skills in one place. The modules will provide detailed lectures on the vital areas of maths such as fractions, percentages, probability, decimals and more. Then, you will learn the core concepts and rules of English grammar, sentence structure and punctuation. Here, you will also get the chance to work on your speaking and writing skills. If you are determined to take your maths and English skills to the next level, join today! Course Preview Learning Outcomes Familiarise yourself with the multiple factors Understand the core principles of fractions and power Get detailed lessons on percentages, averages, expressions and decimals Learn the fundamentals of English grammar, punctuation and spelling Improve your English-speaking skills Understanding the principles of English sentence structure Develop the skills required for English writing Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? Functional Maths Functional English Who Should Take This Functional Skills Maths & English Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Functional Skills Maths & English course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path​ This exclusive Functional Skills Maths & English course will equip you with effective skills and abilities and help you explore career paths such as  Maths Teacher English Teacher Online Tutor Teaching Assistant Module 01: Introduction to Numbers Introduction to Numbers 00:10:00 Module 02: Multiples Factors Multiples Factors 00:11:00 Module 03: Fractions and Power Fractions and Power 00:15:00 Module 04: Percentages and Averages Percentages and Averages 00:12:00 Module 05: Expressions Expressions 00:06:00 Module 06: Decimals Decimals 00:08:00 Module 07: Exponents and Radicals Exponents and Radicals 00:09:00 Module 08: Graphs Graphs 00:05:00 Module 09: The Profit and Loss The Profit and Loss 00:06:00 Module 10: Perimeter and Area Perimeter and Area 00:08:00 Module 11: Probability Probability 00:06:00 Module 12: Reading Reading 00:17:00 Module 13: Writing Writing 00:16:00 Module 14: Speaking Speaking 00:22:00 Module 15: Grammar, Spelling and Punctuation Grammar, Spelling and Punctuation 00:23:00 Module 16: Sentence Structure Sentence Structure 00:11:00 Module 17: Composition Writing Composition Writing 00:12:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Learning Objectives Introduction , Linking Workbooks and Worksheets , Working with Range Names , Sorting, Filtering, and Subtotaling , Analyzing and Organizing with Tables , Using Conditional Formatting , Displaying Data Graphically , Understanding PivotTables, PivotCharts, and Slicers , Working with Advanced PivotTables and PowerPivot Features , Conclusion   Pre-Requisites Excel 365 Introduction course or equivalent knowledge or experience.   Description In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features. Section 01 Lesson 01: Linking Workbooks and Worksheets 00:06:00 Lesson 02: Linking Workbooks with 3D References 00:05:00 Lesson 03: Understanding the Consolidate Feature 00:06:00 Section 02 Lesson 01: What are Range Names 00:04:00 Lesson 02: Creating Range Names Using the Name Box and Define Name 00:06:00 Lesson 03: Creating Range Names Using Create from Selection 00:03:00 Section 03 Lesson 01: Understanding the Differences Between Sorting and Filtering 00:03:00 Lesson 02: Sorting Lists 00:06:00 Lesson 03: Filtering Lists 00:08:00 Lesson 04: Creating Subtotals 00:06:00 Section 04 Lesson 01: Creating Tables and Understanding the Benefits 00:07:00 Lesson 02: Understanding the Elements of a Table 00:06:00 Lesson 03: Formatting a Table 00:08:00 Lesson 04: Sorting and Filtering Tables 00:03:00 Lesson 05: Filtering with Slicers 00:04:00 Lesson 06: Calculating with Tables 00:04:00 Lesson 07: Removing Erroneous Table Data 00:03:00 Lesson 08: Exporting, Refreshing, and Converting Tables 00:05:00 Section 05 Lesson 01: What is Conditional Formatting 00:04:00 Lesson 02: Conditional Formatting Highlight Cells and Top Bottom Rules 00:07:00 Lesson 03: Conditional Formatting Data Bars, Icon Sets, and Color Scales 00:06:00 Lesson 04: Using Custom Fonts and Colors 00:04:00 Lesson 05: Using Custom Conditional Formatting 00:06:00 Lesson 06: Modifying or Removing Conditional Formatting 00:05:00 Section 06 Lesson 01: What are Charts 00:05:00 Lesson 02: Creating Charts 00:06:00 Lesson 03: Understanding Chart Elements 00:05:00 Lesson 04: Modifying Chart Elements 00:09:00 Lesson 05: Changing and Moving Charts 00:04:00 Lesson 06: Filtering a Chart 00:04:00 Lesson 07: Formatting Charts 00:07:00 Lesson 08: Adjusting Numbering 00:06:00 Lesson 09: Creating Dual Axis Charts 00:05:00 Lesson 10: Forecasting with Trendlines 00:05:00 Lesson 11: Creating a Chart Template 00:04:00 Lesson 12: Displaying Trends with Sparklines 00:07:00 Section 07 Lesson 01: What is a PivotTable 00:06:00 Lesson 02: Creating a PivotTable 00:07:00 Lesson 03: Working with the PivotTable Fields Pane 00:09:00 Lesson 04: Basic Data Organization and Analysis with PivotTables 00:06:00 Lesson 05: Formatting PivotTables 00:06:00 Lesson 06: Creating a PivotChart 00:04:00 Lesson 07: Modifying and Formatting a PivotChart 00:04:00 Lesson 08: Adding Slicers and Timeline Slicers 00:03:00 Lesson 09: Formatting Slicers 00:04:00 Lesson 10: Using the Ideas Feature 00:03:00 Section 08 Lesson 01: Using the PivotTable and PivotChart Wizard 00:02:00 Lesson 02: Adding a Calculated Field 00:05:00 Lesson 03: Adding a Calculated Item 00:04:00 Lesson 04: Applying Conditional Formatting to a PivotTable 00:02:00 Lesson 05: Creating Filter Pages for a PivotTable_1 00:03:00 Lesson 06: Enabling the PowerPivot Add: In 00:06:00 Final Exam Final Exam - Excel 365 Intermediate 00:20:00

The Computer Science and Programming Diploma course covers the fundamental theories of Algorithm Analysis. If you want to explore the concepts and methods that make a good programmer, then the course is designed for you. Programming is all about how to solve a problem. Programming theory is not confined to a single language; rather it applies to all programming languages. By understanding the right programming theory, you will be able to analyse a problem and also able to find out the probable solution. The course teaches you these Programming theories covering Algorithm analysis, Binary Number System, Arrays and their Advantages, the process of analysing a problem, Nodes and their Importance, various sorting algorithms and their comparisons, and more. Upon completion, you will be able to understand the core theories of computer science. What Will I Learn? Understand the Fundamental Theories of Algorithm Analysis Be able to Compare Various Algorithms Understand When to use Different Data Structures and Algorithms Understand the Fundamentals of Computer Science theory Requirements A Willingness to Learn New Topics! No Prior Experience or Knowledge is Needed! Module: 01 Kurt Anderson - 1 Introduction FREE 00:01:00 Kurt Anderson - 2 Binary System FREE 00:11:00 Kurt Anderson - 3 Complexity Introduction 00:02:00 Kurt Anderson - 4 Math Refresher Logarithmic Functions 00:11:00 Kurt Anderson - 5 Math Refresher Factorial Functions.TS 007 00:03:00 Kurt Anderson - 6 Math Refresher Algebraic Expressions.TS 00:03:00 Kurt Anderson - 7 n-notation 00:19:00 Kurt Anderson - 8 Big O 00:13:00 Kurt Anderson - 9 Big O Real World Example 00:10:00 Module: 02 Kurt Anderson - 10 How is Data Stored 00:09:00 Kurt Anderson - 11 Fixed Arrays 00:20:00 Kurt Anderson - 12 Circular Arrays 00:08:00 Kurt Anderson - 13 Dynamic Arrays 00:16:00 Kurt Anderson - 14 Array Review 00:08:00 Kurt Anderson - 15 Array Real World Examples 00:06:00 Kurt Anderson - 16 Linked List 00:12:00 Kurt Anderson - 16 Nodes 00:04:00 Kurt Anderson - 17 Linked List Run Times 00:15:00 Kurt Anderson - 18 Doubly Linked Lists 00:08:00 Kurt Anderson - 19 Tail Pointer 00:05:00 Module: 03 Kurt Anderson - 20 Linked List Real World Examples 00:03:00 Kurt Anderson - 20 Stack Example 00:11:00 Kurt Anderson - 21 Linked List Review 00:04:00 Kurt Anderson - 22 Stacks 00:10:00 Kurt Anderson - 23 Queues 00:09:00 Kurt Anderson - 24 Queue Examples 00:10:00 Kurt Anderson - 25 Queue and Stack Run Times 00:06:00 Kurt Anderson - 26 Stack and Queues Real World Examples 00:07:00 Kurt Anderson - 27 Sorting Algorithm Introdcution 00:02:00 Kurt Anderson - 28 Bubble Sort 00:10:00 Kurt Anderson - 29 Selection Sort 00:10:00 Module: 04 Kurt Anderson - 30 Insertion Sort 00:09:00 Kurt Anderson - 31 Quick Sort 00:15:00 Kurt Anderson - 32 Quick Sort Run Times 00:10:00 Kurt Anderson - 33 Merge Sort 00:12:00 Kurt Anderson - 34 Merge Sort Run Times 00:08:00 Kurt Anderson - 35 Stable vs Nonstable 00:07:00 Kurt Anderson - 36 Sorting Algorithm Real World Examples 00:04:00 Kurt Anderson - 37 Basics of Trees 00:08:00 Kurt Anderson - 38 Binary Search Tree 00:09:00 Kurt Anderson - 39 BST Run Times 00:08:00 Module: 05 Kurt Anderson - 40 Tree Traversals 00:13:00 Kurt Anderson - 41 Tree Real World Examples 00:05:00 Kurt Anderson - 42 Heap Introduction 00:04:00 Kurt Anderson - 43 Heap Step by Step 00:12:00 Kurt Anderson - 44 Heap Real World Examples 00:07:00 Kurt Anderson - 45 Thank You 00:01:00

Follow your dreams by enrolling on the Microsoft Excel course today and develop the experience, skills and knowledge you need to enhance your professional development. Microsoft Excel will help you arm yourself with the qualities you need to work towards your dream job.

🚀 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

Introduction to Computer & Building PC Overview Ever felt like your computer is a mystery box? Ever wished you could build your own, super-powered machine, exactly the way you want it? This 'Introduction to Computer & Building PC' course is your key to tech freedom! Forget boring, pre-built computers. This course dives deep into the cool stuff inside them, teaching you what everything does and how it works together. No geek talk, just clear explanations and fun exercises. By the end, you'll be a whiz at picking the right parts and putting them together like a pro, building a PC that's perfect for you, whether you're a gamer, a creative whizz, or just someone who wants a computer that works the way you do. This course is made for people who are new to computers, so don't worry if you're starting from scratch. With easy-to-follow videos, interactive quizzes, and friendly experts to guide you, you'll learn at your own pace and have a blast doing it. Imagine the satisfaction of building your own computer and the endless possibilities it unlocks! Learning Outcomes: Master the key terminology associated with computer hardware and software, empowering you to make informed decisions and confidently navigate the tech world. Gain the practical skills to meticulously assemble your own PC, from selecting compatible parts to carefully installing them within the case. Craft a machine that perfectly aligns with your needs and budget, whether you're a gamer, a creative professional, or simply a tech enthusiast. Learn how to optimize your PC's configuration for maximum speed and efficiency, ensuring a seamless and enjoyable computing experience. Equip yourself with the knowledge to identify and resolve common computer issues, maintaining your machine in top condition. Why You Should Choose Introduction to Computer & Building PC Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Introduction to Computer & Building PC is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Introduction to Computer & Building PC 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Introduction to Computer & Building PC Module 01: Introduction to Computer & Building PC Introduction to Computer & Building PC 00:17:00 Module 02: Overview of Hardware and Parts Overview of Hardware and Parts 00:27:00 Module 03: Building the Computer Building the Computer 00:25:00 Module 04: Input and Output Devices Input and Output Devices 00:22:00 Module 05: Software Installation Software Installation 00:35:00 Module 06: Computer Networking Computer Networking 00:21:00 Module 07: Building a Gaming PC Building a Gaming PC 00:19:00 Module 08: Maintenance of Computers Maintenance of Computers 00:19:00