3385 Courses in Cheshunt

Excel Intermediate Course, 1-Day. This course covers the essential Excel Intermediate, in our interactive, instructor led Live Virtual Classroom. You already know your way around Excel e.g. you understand some of the functionality on the Home Ribbons, can move around and format cells. etc. In the Excel intermediate course we cover in-depth functions and Formulae so that you will be able to create fantastic spreadsheets like budgets, forecasts, and more. You will be able to understand and unravel the complicated formulae created by your colleagues. During the course you will excellent spreadsheets so that you have examples to take away. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Intermediate Certification Hours: 1 Day, 10am-5pm Excel Intermediate Course, Course Outline. Working with Functions and Formulas The Function Wizard Using Functions in Excel: The 5 Popular functions If-else function Working with Names and Ranges Copying formulae Creating Formulae in Excel, general calculations. Lookups: Vlookup, Hlookup, Index, Match. Formatting a Range as a Table: Properties and behaviour of a table. Managing Tables: Working with Tables. Working with Tables: Working with Records and Fields. Filters and Sorting, Freeze panes, split, protecting and unprotecting. Using Excel as a Database: Advanced filter: copy only specified rows and columns from a large data set, auto mate this selective copy. Pivot-tables: Create Pivot Table, Refresh Data. Amend, Filter, Sort, Format Pivot Tables, Add additional Pivot formulae. Pivot Charts: Excel Pivot Charts and Sparklines. Examples and exercises with Pivot Charts and Sparklines. Other Excel Courses Inlcuded with the Excel Intermediate Course PCWorkshops Excel Intermediate Certificate on completion Excel Intermediate Notes Excel Code Examples Practical Excel Intermediate exercises Personal attention in a small group of up to 4 delegates Book the Excel Intermediate Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

Java Webinar Course summary In this Java Webinar Course you will learn Java Basics and OOP Principles. Java Webinar Course description This Java Course is Online, instructor-led, practical attended via Gotomeeting.com. When we receive your booking, we email a connection invitation. This Java Course Webinar will allow you to learn flexibly and commute-free from home. There is no need for attending face-to-face, all advantages of the classroom in built-in and planned for during the delivery of this webinar. We teach online with excellent instruction and targetted well-planned practicals that will clearly illustrate techniques and accurately develop your skills. Question time is built in. Session 1: Data Types, Variables, and Arrays: Primitive types; Characters; Boolean; Working with variables and its scope; Type conversion and casting; Introduction to String class; Working with arrays Session 2: Operators and Expressions Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators; More in operators Session 3: Decision Making If statement; If - else statement; If- else if - else statement; Nested if - else; Switch Statements Session 4: Using Loops The while, do-while and the for loop; Enhanced for loop; Jump statements : break, continue; The return statement; Nesting loops; Using the for-each loop with Arrays Session 5: Methods Introduction of methods; Creating a Method in class; Calling a Method; Returning value from a Method; Adding a Method that takes parameters Session 6: Classes Creating an Object; Using an Object. Adding Instance variables; Controlling accessibility; Class Constructors; Parameterized Constructors; Inheritance. Abstraction. Interfaces and implementing interfaces. Override. Polymorphism. The dot operator, this, static, super, final keywords More in Methods and Classes: Overloading methods; Overloading Constructors; Using objects as parameters; Returning objects; Recursion Java Access control: private, public and protected; Java Nested and inner classes; A stack class Session 7: Java Data structures Files, Streams, Collections. Session 8: Java Exception Handling Fundamentals of exception handling; Exception types; Using try and catch; Multiple catch clauses; Nested try statements; Throw and throws; Finally Blocks Included in the Java Webinar Courses: Java Webinar Course Certificate on completion Java Webinar Course Manual Practical Java Webinar Course exercises, Java Webinar Code Samples/ Java Webinar Course Revision work After the course, 1 free session for questions online Java Webinar Course via Gotomeeting.com. Max group size, online and in classroom, on this Java Webinar Course is 4.

This MS Access Advanced Course mostly covers creating advanced MS Access reports, forms, and macros. Create and amend Advanced Forms and Advanced Reports. Macro buttons. This assists you to build user-friendly forms to facilitate effective navigation, effective data capture and effective viewing and querying data This course will help you to structure MS Access tables, import, and manage your data effectively.

This Access Course concentrates on using creative queries, to extract data from large data sets to get insight from your data and report it. Learn and explore various query techniques from where clauses, to aggregation, joins and more. This private style tuition helps to maximise the value you get from the day.

MS PowerPoint is really easy, but in this PowerPoint Training Courses, we cover most aspects in a fast-paced day, and attend the to more tricky aspects. This course is one-to-one to attend to specific aspects per delegate. Group training could be organised on request.

This course in Visual Data With Tableau covers the Fundamentals of Tableau Desktop. Tableau is brilliant software, very intuitive, for this purpose of data visualization. It is powerful in transforming data to reflect the insights that you plan to visualise

Java Evenings Course. Basic Java syntax and principles of object-oriented programming. Our Style: Hands-on, Practical Course, Instructor-led Course. Level: From basics to fully functional. Who would benefit from the course: basics to Java, attend after work. Duration: one lesson of 2 hours per week for 6 weeks, from 6pm to 8pm.

Who would find this course useful? This is useful if you have some coding skills already. This course is fast-paced, not quite at the basics level.

dvanced Course This MS Project Advanced course is an intensive, hands-on, one-day training course, concentrating on complex calendars, complex costs, multiple baselines, multiple projects and other advanced MS Project features. This is a one day course, one a one-to-one basis, attending to individual questions and issues. Group bookings could be requested

Publisher Courses. With MS Publisher, combine text and photos illustrations to make professional newsletters publications. At our MS Publisher course, learn how to.