5812 Computing courses in New Mills delivered Online

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

This course is designed to guide you through Selenium WebDriver and Java, right from the basic to the advanced aspects. Loaded with exercises and examples, this course provides an interactive learning experience.

This is an introductory course on machine learning. The course covers a wide range of topics, from handling a dataset to model delivery. Some prior training in Python programming and basic calculus knowledge will help you get the best out of this course.

In this course, we will explore some features introduced recently in the language and a few important things that should be kept in mind while programming JavaScript. Learn some important JavaScript concepts and hacks to eliminate your fear of coding and improve your JavaScript coding skills. This course expects a fair understanding of JavaScript to start with.

Would you like to take your JavaScript knowledge to the next level? Would you like to become a master JavaScript programmer by mastering one of the most complex, but especially important, aspects of web development? Master asynchronous programming and stand out among your competitors with the help of this course. Level up your JavaScript coding skills.

This course extensively illustrates how to become a skilled JavaScript developer. Working from the fundamentals, you will learn what JavaScript is, what it can do, and why to use it. A range of topics is covered clearly and structured while building practical projects along the way, including real-world examples and mini-challenges.

A beginner's level course that will help you learn website development using HTML and its concepts from the start. Learn to create web pages by formatting text and adding images, links, and tables. In addition, gain knowledge about creating and functioning a website and web pages. You will also explore the CSS styles used in HTML webpage design.

This course will take you through the basic and advanced concepts of Linux. You will become familiar with shell scripting, file and user management, data streams, and Linux networking with the help of many interesting activities.

Embark on a transformative Python web development journey with this course and dive deep into creating a dynamic book rental system from scratch. Master Django's import-export capabilities, design elegant UI with Tailwind CSS, implement advanced features, and more. Elevate your skills and build real-world applications effortlessly!

A beginner-level course loaded with JavaScript coding examples so that you can learn the fundamentals of JavaScript code. Explore the fundamental core concepts of using JavaScript and how to apply JavaScript code to create interactive web applications with the help of this carefully structured course. The fundamentals of JavaScript are all you need to start coding today and build amazing things with JavaScript.