372 Computing courses in Bushey

A series of hourly small group sessions where we look at different aspects of Excel Duration: 1 hr sessions Alternatively, we can do you one-to-one sessions, either via virtual classroom or in person at our training course. These are £30 per hour, or £125 for 5-hour blocks.

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

Regardless of your computer experience, this class will help you become more aware of technology-related risks and what you can do to protect yourself and your organization from them.

In the past, popular thought treated artificial intelligence (AI) as if it were the domain of science fiction or some far-flung future. In the last few years, however, AI has been given new life. The business world has especially given it renewed interest. However, AI is not just another technology or process for the business to consider - it is a truly disruptive force.

Code the Hangman Game in a few hours, in our Taster Java Hangman Code course Basics made simple! Learn plenty in one day and apply techniques to a game by coding The Hangman Game. Get to know what is Java coding. Will you enjoy a coding career? Or for coders, simply fast-track crossing over to Java.

Java Threads Course Duration: 1 Day Who would find this course useful? Java coders Level: Not quite basics level. It specifically concentrates on Threads Principles (Threads) in Java. Download: Download Java JDK and Eclipse IDE. For classroom courses: Bring your own device. Java Threads Course description General Threads Concepts Java Threads Course Description General Threads Concepts Multithreading Cycle of a Thread Create a Thread by Implementing a Runnable Interface Create a Thread by Extending a Thread Class Major thread operations Processes and Threads, Thread Objects Thread Methods getName, getId, setName, etc Pausing Execution with Sleep Interrupts, Joins Thread Priorities Thread Pools Executors, Executor Interfaces, Thread Pools, Fork/Join Synchronozation What is thread synchronization? Thread Interference, Memory Consistency Errors, Synchronized Methods, Lock Objects, Intrinsic Locks and Synchronization, Handling interthread communication, Handling thread deadlock, Liveness, Starvation and Livelock, Atomic Access. Concurrent Collections Guarded Blocks, Immutable Objects. Strategy for Defining Immutable Objects, High Level Concurrency Objects, Java Threads Course, 1 Day What is included PCWorkshops Course Certificate on completion Java Threads Course Notes Java Threads Code Examples Practical exercises, Java Course Revision work After the course: 1-Hour personalised online revision session About us Our experienced trainers are award winners. More about us FAQ's Client Comments

MS Word Advanced Course summary This MS Word Advanced Course, Private 1-to-1, covers advanced MS Word tools. Ideal for delegates who create long documents, manuals and manuscripts. MS Word styles and formats, help making formatting documents consistent and easy to maintain. Who Should Attend the MS Word Advanced Course: Delegates should have a working knowledge of the concepts covered in the Introduction and Intermediate courses. What is MS Word: Microsoft Word, or simply Word, is a word processing software package developed by Microsoft. Is is bundled within the Microsoft Office suite. It covers simple text editor capability through to desktop publishing features, suitable to creates professional documents for any purpose MS Word Advanced Course description Session 1:Managing and Reviewing Documents Using Comments Tracking changes, version control Session 2: Styles Creating an Outline Style Principles, Style Themes, Creating, Modifying, Using Styles, Styles menus and Styles Group on the Home Ribbon. Session 3: Sections Formatting, page layouts, page numbering, headers and footers with sections Session 4:MS Word Tables and Text Boxes Inserting, Editing, Formatting and positioning MS Word Tables and Text Boxes Session 5: MS Word Reference Tools Table of Contents References within a Document Bibliography Index Tabls Reference Tables References to Other Documents Session 6: MS Word Templates Creating, saving and using custom templates Session 7: Templates and Building Blocks Using Building Blocks and Quick Parts, Fill-In Merge for Templates Session 8: Graphics Creating Graphics, Equations and Charts, Using WordArt, Using SmartArt Session 9: MS Word Time Saving Tools MS Word Time Saving Tools Using Language Tools Inserting Pre-Defined Text Using the Navigation Pane What is included in the MS Word Advanced Courses: MS Word Advanced Course Certificate on completion MS Word Advanced Course notes Practical MS Word Advanced Course exercises, MS Word Advanced Course Homework / MS Word Advanced Course Revision work After the course, 1 free session for questions online MS Word Advanced Course via Gotomeeting.com. Max group size, online and in classroom, on this MS Word Advanced Course is 4.

Java Front-ends for desktop and mobile With Java FX Programming Java Front-ends for desktop and mobile With Java FX In this course we create attractive, functional Front-ends using JavaFX. Prerequisites: Delegates already have basic Java Skills. Duration: 2 consecutive days, the first date shows as the booking date Where: Online with Gotomeeting.com Download: Download Java JDK and Eclipse IDE. London classroom: on request locations, bring you own device Location: Online Interactive Instructor-led Webinar. Our Style: This is a very practical course giving you hands-on practice. Included: Course exercises, notes, examples, computers, evaluations Certification: PCWorkshops JavaFX Qualification Java Intermediate and Front-end Course Description Database Concepts Revision: DataBase SQL, database principles and JDBC GUI's with Java FX Building Java FX GUI's Course Contents: GUI's with JavaFX Building Java GUI's. Create a front-end form interface for an application. Working with nodes, labels, inputboxes, prgress bars, etc. Formatting your front-end. Import a Java package to interact with the front-end. Interact with a database via the front-end. Practical Examine the Java SE event model. What is an event. What is event handling. Develop event handlers. Develop Lambda-style event handlers. Practical Create a quotation app. Create a movie booking app. How to create your installer and upload your app Webservices Java Web services What are Web Services? Why Java Web Services? Web Services - Characteristics Web Services - Architecture Web Services - Examples and exercises What is included PCWorkshops Course Certificate on completion Java Course Notes Java Code Examples Practical Java Course exercises, Java Course Revision work After the course: 1-Hour personalised online revision session Book the Java Intermediate and Front-end Course Powered by Eventbrite About us Our experienced trainers are award winners. More about us FAQ's Client Comments

Database Design and Data Normalization Course Summary Relational Databases & Data Normalisation Overview Training Courses London. Learn how to decide which tables and columns are required for a database, plan relationships, how to decide on data types and how to relate tables. Database Design and Data Normalization Course Description Session 1: Introduction to Relational Databases The Database Approach Database Management Systems The function of a Database Management System The Processing Architecture The Schema Architecture The Storage Architecture An overview of Database System Development An overview of general database principles Session 2: Conceptual Data Models Overview of Entity Models Entities and how to identify them Attributes and how to identify them Relationships and their qualities Building an Entity Relationship Diagram Resolving many-to-many relationships Sub-type and Super-type Relationships Arc Relationships Recursive Relationships Constraints and Assumptions Normalization to the First Normal Form (1NF) Normalization to the Second Normal Form (2NF) Normalization to the Third Normal Form (3NF) Exercises: Analyzing a specification Creating an Entity Relationship Diagram from it Session 3: The Relational Model Relational Structure Relational Terminology Domains A Relational schema Candidate keys and Primary Keys Foreign Keys Key Constraints Attribute Constraints Implementing Sub-type/Super-type Relationships Views Denormalization using Pre-joined Tables Denormalization using Derived Data An Introduction to Structured Query Language (SQL) Simple Queries Simple Updates of the Data Included in the Database Design and Data Normalization Courses: Database Design and Data Normalization Course Certificate on completion Database Design and Data Normalization Course Manual Practical Database Design and Data Normalization Course exercises, Database Course Homework / Database Course Revision work After the course, 1 free session for questions online Database Course via Gotomeeting.com. Max group size, online and in classroom, on this Database Course is 4.

Java CrossOver Course for Coders 1-Day, 11am - 6pm Online, Instructor-led, Interactive, Practical Java Basics to coders who are converting to Java from a different coding language. You do not need much time to learn the syntax of Java, because you have done similar work in other programming languages Hands-on, Practical Course, Instructor-led Course. Online with Gotomeeting.com 1 day, from 11am - 6pm. In classroom at on request only. Locations Java CrossOver Course description Overview of Java: This course covers Java Object-Oriented Programming (OOP) principles. Java Data Types and using Variables in Java: Here we learn to code using data types and variables of different data types: Primitives; Characters; Boolean; Variables and variable scope; String class; Type conversion and casting. Java Operators and Expressions: What are operators and how to use them; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators. Decision Making: The Java Syntax for the If-statement; If,else; If,else if,else; Nested if; Switch Statements; Using Loops: For loops, while loops, do while, Enhanced for loop; Nesting loops; break, continue; The return statement. Arrays: Working with arrays, 2-d arrays, iterating arrays. Using the for-each loop with Arrays Lists: Working with lists. Lists vs Arrays. Files,streams with Java: Open, Read and Write to CSV Files, txt files and bin files. Exception Handling: Fundamentals of exception handling; Exception types; Using try and catch; Multiple catch clauses; Nested try statements; Throw and throws; The finally blocks Introduction to Classes and Objects: Creating a Class; Creating an Object; Using an Object; Adding Instance variables; Controlling accessibility; Naming conventions for class members. Class Constructors; Parameterized Constructors; Inheritance. Abstraction. Interfaces and implementing interfaces. Override. Polymorphism. The dot operator, this keyword, the static keywords, the super keyword. Using Methods: Introduction of methods; Creating a Method in class; Calling a Method; Returning value from a Method; Adding a Method that takes parameters; More in Methods and Classes: Overloading methods; Overloading Constructors; Using objects as parameters; Returning objects; Recursion; Access control : private, public and protected; The final keyword. What is included PCWorkshops Course Certificate on completion Java Course Notes Java Code Examples Practical Java Course exercises, Java Course Revision work After the course: 1-Hour personalised online revision session Book the Java CrossOver Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments