PCWorkshops courses

...data Consilidate Goal seek, consolidate and scenarios Using Form Templates Creating Templates Advanced Excel Lookup Functions VLookup Function Hlookup... Learn about: MS Excel, Data Analytics, How to use Excel...

...Filters and Slicers Filtering PivotTables and PivotCharts Creating Hierarchies Excel techniques that are essential for Dashboards: Offset Lookup formulae (Vlookup... Learn about: Data Collection, Dashboards and servicing reports, MS Excel...

...wizard for statistical functions, using advanced filters and setting up criteria. Summarising and categorising data and finding trends with Excel Pivot tables... Learn about: Data trends, Data Analytics, Data Visualization...

...Immerse yourself in the Python world with this Python for Data Analysis, offered by PCWorkshops, that Emagister has added to its educational catalogue... Learn about: Data Collection, Data Mining, Data Analytics...

...data and communicate with the user Creating Sub and Function Procedures Declare and Use Variables Displaying Message to the User Getting Input from... Learn about: Microsoft Excel, Excel VBA, MS Excel...

...Using the View Tab, Managing a Single Window, Managing Multiple Windows, Printing your Workbook Working with Charts: Creating Charts, Selecting Chart... Learn about: Business Intelligence, MS Excel, Conditional Formatting...

...SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows... Learn about: Access Control, Database training, Data Types...

...The expression builder The Report Items collection Built-in fields Conditional formatting expressions Page headers and footers Page names and numbers Exporting... Learn about: Conditional Formatting, Data Analytics, Graphical Indicators...

...database principles and JDBC Frontends and GUI's: Building Java GUI's Define events and event handling Examine the Java SE event model Describe GUI behaviour... Learn about: Event based programming, GUI programming, Java Programming...

...Learn to create a database with Microsoft Access, to manage lists of clients, contacts, orders, sales, charities, event, in fact any large set of... Learn about: Database training, Data Retrieval, Sorting Data...

...Update and Delete Queries Data Importing Data Exporting Data Linking Data Creating Forms Creating forms, Form wizards Creating a Navigation Form Creating reports... Learn about: Data Retrieval, Database Concepts, Database training...

...PCWorkshops Beginners and Intermediate course or have experience in Access database MS Access Database Advanced Course Course Outline Advanced Data Management Database design... Learn about: Data Types, Access Macros, Database Design...

...Learn at your own pace, ask questions, just as if you were in the classroom. At the end of the day, you will be fully skilled with practical exercise... Learn about: Programming Application, Virtual classoom, Python operators...

...Jump statements : break, continue; The return statement; Session 2: Arrays: Working with arraysStreams: Streams to access data files.Exception Handling:Fundamentals... Learn about: Object oriented Programming, Java API, Oriented Programming...

...ones who are considering coding as a career choice. Coders or IT Professionals who want to migrate or cross-skill to Java. We will send an email with a booking... Learn about: Java 6, Operators and expressions, Data Types...