3187 Courses

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.

Description: This course follows up from the Beginners Excel 2010 course by delving even deeper into features and functions of this powerful spreadsheet software. This Microsoft Office 2010 Excel Advanced - Complete Video Course builds on the skills and concepts taught in Excel 2010: intermediate. In this series you will learn to work with advanced formulas, as well lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation and database functions such as DSUM. You will learn how to work with Pivot Tables and PivotCharts, how to import and export data, and how to query external databases. Finally, you will learn about the analytical features of Excel, running and recording macros, SmartArt graphics and conditional formatting with graphics, and more. Before you taking this course you should have a firm grasp of the basics. This course will pull up your basic knowledge. So join this course to be an expert. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. 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 £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2010 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Microsoft Office 2010 Excel Advanced - Complete Video Course 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 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. Logical and Statistical Functions Logical Functions FREE 00:17:00 Math and Statistical Functions 00:19:00 Financial and Date Functions Financial Functions 00:04:00 Date and Time Functions 00:10:00 Array Formulas 00:09:00 Displaying and Printing Formulas 00:08:00 Lookups and Data Tables Using Lookup Functions 00:14:00 Using MATCH and INDEX 00:06:00 Array Formulas 00:07:00 Advanced Data Management Validating Cell Entries 00:08:00 Exploring Database Functions 00:06:00 Exporting and Importing Exporting and Importing Text Files 00:11:00 Exporting and Importing XML Data 00:03:00 Querying External Databases 2 hours agoMore 00:09:00 Analytical Tools Goal Seek and Solver 00:15:00 The Analysis ToolPak 00:05:00 Scenarios 1 hour agoMore 00:06:00 Macros and Custom Functions Running and Recording a Macro 00:19:00 Working with VBA Code 00:07:00 Creating Functions 00:05:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

ESAG 7th World Congress 2023

Understand the principles of the “Visual Factory”, basic “Visual Management Systems” and how to apply it to your working environment This workshop introduces the tools and practices of Visual Management as one of the basic components of a Lean Management System. It shows how it can be used effectively to support standardization and problem solving across all functions, allowing the detection of product and process abnormalities in your value stream in real time. It also serves as a communication tool by visually defining for people what "good" is, what the "standard" is, and whether it is being maintained. It allows a proactive approach to data gathering, leading to rapid data analysis, and aids decision making that results in corrective actions being taken in a cost effective way. To achieve this, the workshop looks at how to identify critical product and process information, how to record and display it, who needs to see it, and how does it lead to action that resolves a problem or a non-conformance when it occurs. The workshop also details the principles used in designing and implementation a "Visual Management System" in order to migrate your organization from one of gathering and analysing data, and reacting to abnormalities, to one of seeing waste, managing exceptions, and improving processes in real time.

Project Management Office The goal of this course is to equip the participant with the necessary knowledge and skills to establish, improve, and support a project management office (PMO) that is the catalyst for portfolio and delivery management excellence. This course addresses the complexities of both understanding and choosing the correct PMO framework from among several alternatives. Additionally, the typical PMO supporting elements: domains of work, maturity level, and performance metrics, are elaborated. These elements position a PMO to realize and sustain the business value anticipated by the organization. What You Will Learn At the end of this program, you will be able to: Define a PMO and articulate on its benefits to an organization Explain how a PMO facilitates organizational success Differentiate among the varied PMO frameworks Apply to a PMO framework, domains of work, metrics, and organizational maturity Describe the competency frameworks for management functions within a PMO Plan for and implement a PMO to ensure it is of business value Foundation Concepts Definitions and concepts PMO frameworks PMO domains PMO benefits PMO Frameworks Organizational unit PMO Project-specific PMO Project support or services PMO Center of excellence Enterprise PMO PMO Domains I Strategic planning Standards, methodologies, and processes Governance and performance management Organizational change management PMO Domains II Portfolio management Project and program delivery management Administrative support, knowledge, and talent management PMO Metrics and Maturity PMO metrics PMO maturity PMO maturity assessments PMO Implementation Originating and initiating a PMO Developing a PMO implementation plan Implementing a PMO

KCCA Course teaches principles of candle making, including handmade techniques for 28 candle items. Association issues certification upon completion

Don't miss this opportunity to capture the beauty of Snowdonia National Park through your lens. Embark on a photographic journey like no other with our 4 day and 3 night workshop in the breathtaking Snowdonia National Park. Surrounded by stunning landscapes, you will have the opportunity to capture the beauty of this national park through your lens. With a small group of just 12 students (max), you will receive personalized instruction and guidance from Lisa and myself. This ticket includes: > Photographic and Editing 3-day Weekend Workshop. > Side-by-side tuition in the field > short 1-2-1 session with students during the weekend. > Post processing tuition in-between shoots and evenings at the lodge > Three nights luxury accommodation. (Options for both shared and single occupancy) > Camera Craft sessions and tutorials for explaining best in-camera practices and camera functions and features > Breakfast on Days 2, 3 and 4 > 3-course gourmet evening

This course takes you through the concepts of Alteryx from scratch. With the help of interesting case studies, you will learn how to use Alteryx for joining datasets, performing union operations, finding and replacing text, sorting and filtering data, and a lot more.

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

Red Hat training course description This three day hands on course provides a comprehensive coverage of core Linux administration tasks on Red Hat Linux. What will you learn Administer & configure Linux systems. Maintain Linux by handling disk space and taking regular backups. Manage software packages. Perform basic troubleshooting. Maintain a secure Linux system. Describe the organisation and implementation of the filesystem. Red Hat training course details Who will benefit: System administrators. Network administrators. Prerequisites: Linux fundamentals Duration 3 days Red Hat training course contents Managing software Package Concepts, RPM, rpm Commands, Yum, Dependencies and Conflicts, Startup Script Problems, Shared Libraries, Library Management, Managing Processes, the Kernel: The First Process, Process Lists, Foreground & Background Processes, Process Priorities, Killing Processes. Configuring hardware Configuring Firmware and Hardware, IRQs, I/O Addresses, DMA Addresses, Boot Disks, Coldplug and Hotplug Devices, Configuring Expansion Cards and PCI Cards, Kernel Modules, USB Devices, Linux USB Drivers, Configuring Hard Disks, Partitioning Systems, LVM, Common Layouts, Creating Partitions and Filesystems, Maintaining Filesystem Health, Tuning, Journals, Checking Filesystems, Monitoring Disk Use, Mounting and Unmounting Filesystems. Managing files File Management Commands, File Naming and Wildcards, File Archiving, Links, Directory Commands, File Ownership and Group, File access control, Permissions, chmod, Defaults, File Attributes, Disk Quotas, Enabling and setting Quotas, Locating Files, The FHS. Booting Linux and editing files Installing Boot Loaders, GRUB Legacy, GRUB 2, Alternative Boot Loaders, the Boot Process, Boot Messages, Runlevels and the Initialization Process, Runlevel Functions, Runlevel Services, Alternative Boot Systems , Upstart, system. Administering the system Managing Users and Groups, Tuning User and System Environments, Using System Log Files, Understanding syslogd , Setting Logging Options, Manually Logging Data, Rotating Log Files, Reviewing Log File Contents, Maintaining the System Time, Linux Time Concepts, Manually Setting the Time, Using NTP, Running Jobs in the Future, Understanding the Role of cron, Creating System cron Jobs, Creating User cron Jobs, Using anacron, Using at. Configuring basic networking TCP/IP, Network Hardware, Network Addresses, Hostnames, Network Ports, Configuring Linux for a Local Network, Configuring with DHCP, Static IP Address, Configuring Routing, Using GUI Configuration Tools, ifup and ifdown, Diagnosing Network Connections, Testing Connectivity, Tracing a Route, Checking Network Status , Examining Network Traffic, Additional Tools. Securing your systems Administering Network Security, Super Server Restrictions, Disabling Unused Servers, Administering Local Security, Securing Passwords, Limiting root Access, Setting Login, Process, SUID/SGID Files, Configuring SSH, Using GPG, Generating, Importing and Revoking Keys, Encrypting and Decrypting Data, Signing Messages and Verifying Signatures. Clustered File Systems Principles of cluster file systems. Create, maintain and troubleshoot GFS2 file systems in a cluster, create, maintain and troubleshoot OCFS2 file systems in a cluster, Integration of GFS2 and OCFS2 with Pacemaker, the O2CB cluster stack, other commonly used clustered file systems.