8201 Admin courses

Step confidently into office, administration, and junior management roles with the Excel Introduction Training Mini Bundle. Designed to equip you with sought-after skills in MS Excel, Communication Skills, MS Word, Payroll, and MS PowerPoint, this bundle ensures you stand out as a versatile professional ready to handle essential business tasks. Employers across sectors—from corporate offices to small businesses—actively seek candidates with a strong command of MS Excel, effective Communication Skills, proficiency in MS Word, knowledge of Payroll, and polished presentation skills through MS PowerPoint. This bundle makes you their first choice. Description Today's jobs demand more than spreadsheet know-how. With MS Excel as your core skill, this bundle expands your capability to include effective written and verbal communication through Communication Skills, professional document creation with MS Word, payroll basics for HR or finance roles, and compelling presentations using MS PowerPoint. From managing data to engaging colleagues and clients, your profile will resonate with employers who want well-rounded candidates. The combination of MS Excel, Communication Skills, MS Word, Payroll, and MS PowerPoint makes you the complete office professional. This is your chance to rise above the crowd with the right blend of technical and interpersonal skills. Don’t wait—hireability is just one bundle away. FAQ Q: What kinds of jobs is this bundle suited for? A: Entry-level admin, office assistant, HR support, junior management, and clerical roles requiring MS Excel, Communication Skills, MS Word, Payroll, and MS PowerPoint. Q: How do Communication Skills fit in with technical training? A: Effective communication complements technical skills, making you more impactful in team and client interactions. Q: Is Payroll knowledge important here? A: Yes. Even basic payroll understanding is highly valued in HR and admin roles. Q: Does this bundle cover presentation skills? A: Absolutely. MS PowerPoint is included to ensure you can create professional presentations. Q: Will this improve my job prospects quickly? A: Yes. These skills are frequently listed as essential in job descriptions across many industries. Q: Is buying this bundle a cost-effective option? A: Definitely. You get MS Excel, Communication Skills, MS Word, Payroll, and MS PowerPoint training all in one affordable package.

Overview This comprehensive course on Python for Data Analysis will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Python for Data Analysis comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Python for Data Analysis. It is available to all students, of all academic backgrounds. Requirements Our Python for Data Analysis is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 19 sections • 99 lectures • 00:08:00 total length •Welcome & Course Overview: 00:07:00 •Set-up the Environment for the Course (lecture 1): 00:09:00 •Set-up the Environment for the Course (lecture 2): 00:25:00 •Two other options to setup environment: 00:04:00 •Python data types Part 1: 00:21:00 •Python Data Types Part 2: 00:15:00 •Loops, List Comprehension, Functions, Lambda Expression, Map and Filter (Part 1): 00:16:00 •Loops, List Comprehension, Functions, Lambda Expression, Map and Filter (Part 2): 00:20:00 •Python Essentials Exercises Overview: 00:02:00 •Python Essentials Exercises Solutions: 00:22:00 •What is Numpy? A brief introduction and installation instructions.: 00:03:00 •NumPy Essentials - NumPy arrays, built-in methods, array methods and attributes.: 00:28:00 •NumPy Essentials - Indexing, slicing, broadcasting & boolean masking: 00:26:00 •NumPy Essentials - Arithmetic Operations & Universal Functions: 00:07:00 •NumPy Essentials Exercises Overview: 00:02:00 •NumPy Essentials Exercises Solutions: 00:25:00 •What is pandas? A brief introduction and installation instructions.: 00:02:00 •Pandas Introduction: 00:02:00 •Pandas Essentials - Pandas Data Structures - Series: 00:20:00 •Pandas Essentials - Pandas Data Structures - DataFrame: 00:30:00 •Pandas Essentials - Handling Missing Data: 00:12:00 •Pandas Essentials - Data Wrangling - Combining, merging, joining: 00:20:00 •Pandas Essentials - Groupby: 00:10:00 •Pandas Essentials - Useful Methods and Operations: 00:26:00 •Pandas Essentials - Project 1 (Overview) Customer Purchases Data: 00:08:00 •Pandas Essentials - Project 1 (Solutions) Customer Purchases Data: 00:31:00 •Pandas Essentials - Project 2 (Overview) Chicago Payroll Data: 00:04:00 •Pandas Essentials - Project 2 (Solutions Part 1) Chicago Payroll Data: 00:18:00 •Matplotlib Essentials (Part 1) - Basic Plotting & Object Oriented Approach: 00:13:00 •Matplotlib Essentials (Part 2) - Basic Plotting & Object Oriented Approach: 00:22:00 •Matplotlib Essentials (Part 3) - Basic Plotting & Object Oriented Approach: 00:22:00 •Matplotlib Essentials - Exercises Overview: 00:06:00 •Matplotlib Essentials - Exercises Solutions: 00:21:00 •Seaborn - Introduction & Installation: 00:04:00 •Seaborn - Distribution Plots: 00:25:00 •Seaborn - Categorical Plots (Part 1): 00:21:00 •Seaborn - Categorical Plots (Part 2): 00:16:00 •Seborn-Axis Grids: 00:25:00 •Seaborn - Matrix Plots: 00:13:00 •Seaborn - Regression Plots: 00:11:00 •Seaborn - Controlling Figure Aesthetics: 00:10:00 •Seaborn - Exercises Overview: 00:04:00 •Seaborn - Exercise Solutions: 00:19:00 •Pandas Built-in Data Visualization: 00:34:00 •Pandas Data Visualization Exercises Overview: 00:03:00 •Panda Data Visualization Exercises Solutions: 00:13:00 •Plotly & Cufflinks - Interactive & Geographical Plotting (Part 1): 00:19:00 •Plotly & Cufflinks - Interactive & Geographical Plotting (Part 2): 00:14:00 •Plotly & Cufflinks - Interactive & Geographical Plotting Exercises (Overview): 00:11:00 •Plotly & Cufflinks - Interactive & Geographical Plotting Exercises (Solutions): 00:37:00 •Project 1 - Oil vs Banks Stock Price during recession (Overview): 00:15:00 •Project 1 - Oil vs Banks Stock Price during recession (Solutions Part 1): 00:18:00 •Project 1 - Oil vs Banks Stock Price during recession (Solutions Part 2): 00:18:00 •Project 1 - Oil vs Banks Stock Price during recession (Solutions Part 3): 00:17:00 •Project 2 (Optional) - Emergency Calls from Montgomery County, PA (Overview): 00:03:00 •Introduction to ML - What, Why and Types..: 00:15:00 •Theory Lecture on Linear Regression Model, No Free Lunch, Bias Variance Tradeoff: 00:15:00 •scikit-learn - Linear Regression Model - Hands-on (Part 1): 00:17:00 •scikit-learn - Linear Regression Model Hands-on (Part 2): 00:19:00 •Good to know! How to save and load your trained Machine Learning Model!: 00:01:00 •scikit-learn - Linear Regression Model (Insurance Data Project Overview): 00:08:00 •scikit-learn - Linear Regression Model (Insurance Data Project Solutions): 00:30:00 •Theory: Logistic Regression, conf. mat., TP, TN, Accuracy, Specificityetc.: 00:10:00 •scikit-learn - Logistic Regression Model - Hands-on (Part 1): 00:17:00 •scikit-learn - Logistic Regression Model - Hands-on (Part 2): 00:20:00 •scikit-learn - Logistic Regression Model - Hands-on (Part 3): 00:11:00 •scikit-learn - Logistic Regression Model - Hands-on (Project Overview): 00:05:00 •scikit-learn - Logistic Regression Model - Hands-on (Project Solutions): 00:15:00 •Theory: K Nearest Neighbors, Curse of dimensionality .: 00:08:00 •scikit-learn - K Nearest Neighbors - Hands-on: 00:25:00 •scikt-learn - K Nearest Neighbors (Project Overview): 00:04:00 •scikit-learn - K Nearest Neighbors (Project Solutions): 00:14:00 •Theory: D-Tree & Random Forests, splitting, Entropy, IG, Bootstrap, Bagging.: 00:18:00 •scikit-learn - Decision Tree and Random Forests - Hands-on (Part 1): 00:19:00 •scikit-learn - Decision Tree and Random Forests (Project Overview): 00:05:00 •scikit-learn - Decision Tree and Random Forests (Project Solutions): 00:15:00 •Support Vector Machines (SVMs) - (Theory Lecture): 00:07:00 •scikit-learn - Support Vector Machines - Hands-on (SVMs): 00:30:00 •scikit-learn - Support Vector Machines (Project 1 Overview): 00:07:00 •scikit-learn - Support Vector Machines (Project 1 Solutions): 00:20:00 •scikit-learn - Support Vector Machines (Optional Project 2 - Overview): 00:02:00 •Theory: K Means Clustering, Elbow method ..: 00:11:00 •scikit-learn - K Means Clustering - Hands-on: 00:23:00 •scikit-learn - K Means Clustering (Project Overview): 00:07:00 •scikit-learn - K Means Clustering (Project Solutions): 00:22:00 •Theory: Principal Component Analysis (PCA): 00:09:00 •scikit-learn - Principal Component Analysis (PCA) - Hands-on: 00:22:00 •scikit-learn - Principal Component Analysis (PCA) - (Project Overview): 00:02:00 •scikit-learn - Principal Component Analysis (PCA) - (Project Solutions): 00:17:00 •Theory: Recommender Systems their Types and Importance: 00:06:00 •Python for Recommender Systems - Hands-on (Part 1): 00:18:00 •Python for Recommender Systems - - Hands-on (Part 2): 00:19:00 •Natural Language Processing (NLP) - (Theory Lecture): 00:13:00 •NLTK - NLP-Challenges, Data Sources, Data Processing ..: 00:13:00 •NLTK - Feature Engineering and Text Preprocessing in Natural Language Processing: 00:19:00 •NLTK - NLP - Tokenization, Text Normalization, Vectorization, BoW.: 00:19:00 •NLTK - BoW, TF-IDF, Machine Learning, Training & Evaluation, Naive Bayes : 00:13:00 •NLTK - NLP - Pipeline feature to assemble several steps for cross-validation: 00:09:00 •Resources- Python for Data Analysis: 00:00:00

Enhance your British Sign Language skills with our interactive BSL Level 2 course. Perfect for advancing from basic BSL, this course covers advanced grammar, vocabulary, and effective signing techniques. Led by a 20-year experienced instructor, you'll gain confidence in everyday conversations and emotional signs, preparing you for fluent communication with the deaf community. Enrol now and elevate your BSL proficiency!

Discover the art of furniture restoration and interior decorating with our comprehensive course. Master wood finishing techniques, explore historical furniture periods, and develop skills in room analysis and decor selection. Perfect for aspiring restorers, decorators, and DIY enthusiasts.

Database fundamentals training course description This three-day training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. What will you learn Describe core database concepts. Create database objects. Manipulate data. Describe data storage. Administer a database. Create a relational database consisting of 3 related tables. Database fundamentals training course details Who will benefit: Those working with databases. Prerequisites: None. Duration 3 days Database fundamentals training course contents Understanding core database concepts Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements. Creating database objects Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections. Manipulating data Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity. Understanding data storage Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table. Administering a Database Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.

MySQL Performance & Tuning training course description This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. What will you learn Develop a monitoring and tuning plan Use server configuration and status variables. Identify and improve problem queries. Make efficient use of indexes. Monitor and size memory caches and locks. Tune the MyISAM and InnoDB storage engine. Evaluate the use of partitioning for performance. MySQL Performance & Tuning training course details Who will benefit: Anyone who wishes to monitor and tune MySQL performance. Prerequisites: Delegates must have a working knowledge of MySQL Database Administration Duration 3 days MySQL Performance & Tuning training course contents Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.

Mobile IP training course description A detailed examination of the protocols and architecture of Mobile IP. What will you learn Recognise the benefits of ADSL. Configure and troubleshoot IS-IS. Explain how IS-IS works. Describe the use of Level 1 and Level 2. Design IS-IS networks. Mobile IP course details Who will benefit: Technical staff wanting to learn DNS.Network Administrators. Support personnel. Prerequisites: TCP/IP Foundation Duration 2 days Mobile IP course contents Introduction Quick review of IP, What is Mobile IP? What Mobile IP provides, Mobility requirements, Where Mobile IP is required, where mobile IP is not required, DHCP as an alternative, Proxy ARP as an alternative. Architecture Mobile node, home network, home agent, Foreign agent, Fixed home address, Care of address, Correspondent node, Tunnelling. How Mobile IP works Using two addresses, issues with TCP, discovering the care of address, registering care of address, tunnelling the care of address. The protocols involved. Issues with Mobile IP Routing inefficiencies, Security and firewalls, ingress filtering, QoS. MIP and IPv6 Stateless address configuration, Neighbour discovery, miscellaneous.

SNMPc training course description A hands on course providing a solid foundation on network management using SolarWinds. The course specifically focusses on SolarWinds Orion Network Performance Monitor. The course starts with configuring agents and device discovery, onto exploiting SNMP with SolarWinds and then Alerts, reports and customisation of menus, views and maps. What will you learn Discover devices using Solarwinds. Use Solarwinds. Poll and monitor devices using Solarwinds. Create Alarms and reports. Diagnose faults using Solarwinds. SNMPc training course details Who will benefit: Technical staff working with Solarwinds. Prerequisites: None. Duration 2 days SNMPc training course content Getting started with SNMPc Manual discovery, automatic discovery, controlling IP discovery, mapping network devices. Hands on Using SNMPc. Agents Configuring Cisco devices for SNMP support, communities, traps, syslog. MIBs. Hands on Device discovery. Adding devices. Customising maps. Using SNMPc Polling, obtaining MIB information, MIB walking. Compiling MIBs. Hands on Monitoring devices. Groups. MIB walking. SNMP traps. Alarms Events and alarms, thresholds, event actions. Hands on Automatic alarms. Reports Creating reports, trend reports, customising reports. Hands on Performance reports. Graphs. Administration Users, customised views, backups, the database. Hands on Adding a user. Backups.

NNMi for engineers training course description A hands on course focusing on network management using Network Node Manager (NNMi) on Microsoft Windows or UNIX. What will you learn Describe the network management architecture. Use NNMi. Diagnose faults using NNMi. Recognise the MIB structure. NNMi for engineers training course details Who will benefit: Network administrators. Network operators. Those wishing to find out more about how their NNMi works. Prerequisites: TCP/IP foundation for engineers Duration 2 day NNMi for engineers training course content Network management What is network management? Benefits, issues, demonstration. Getting started with NNMi Starting NNMi, IP discovery, IP monitoring, controlling IP discovery. Using NNMi Mapping devices, map layouts, maps and submaps, objects and symbols, object attributes, colour codings, polling. Agents Configuring Cisco devices for SNMP support, communities, traps, syslog. Parts of SNMP SNMP architecture, MIBs, The protocol. NNMi SNMP configuration NNMi alarm browser NNMi alarms, alarm categories, filtering alarms, alarm details window. MIBs MIB1, MIB2, The MIB2 groups, additional MIBs, MIB compilers, vendor MIBs. NNMi MIB loader and browser. Monitoring devices Polling, obtaining MIB information. Diagnostic tools Poll node, the ping window, protocol test, locate route NNMi fault management Alarms, polling, fault management, setting thresholds and configuring traps.

HP iMC for engineers training course description A hands on course focusing on network management using HP iMC on Microsoft Windows or UNIX. What will you learn Describe the network management architecture. Use HP NNMi. Diagnose faults using HP iMC. Recognise the MIB structure. HP iMC for engineers training course details Who will benefit: Network administrators. Network operators Those wishing to find out more about how their NMS works Anyone wishing to implement NFV using OpenStack. Prerequisites: Introduction to Virtualization Duration 2 day HP iMC for engineers training course content Network management What is network management? Benefits, issues. Getting started with HP iMC Starting HP iMC, IP discovery, IP monitoring, controlling IP discovery. Hands on Initial HP iMC configuration. Using HP iMC Viewing devices, Device view, IP view, network view, polling. Hands on Using HP iMC. Agents Configuring Cisco devices for SNMP support, communities, traps, syslog. Hands on Configuring network devices for HP iMC. Parts of SNMP SNMP architecture, MIBs, The protocol. HP iMC SNMP configuration. Hands on HP iMC SNMP configuration. MIBs The MIB2 groups, additional MIBs, MIB compilers, vendor MIBs. HP iMC MIB loader and browser. Hands on MIB browsing. Monitoring devices Polling, obtaining MIB information. Hands on HP iMC performance management. Configuration and change management Configuration templates, software library, configuration compare, configuration audit and reports. Hands on Using the configuration center. Reports Report templates, Real time reports, scheduling reports. Hands on Using real time reports. HP iMC fault management Alarms, polling, fault management, setting thresholds and configuring traps. Syslog. Hands on Working with alarms. Security alarms.