2297 Learning & Development courses delivered Online

Overview This comprehensive course on XLOOKUP and VLOOKUP will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This XLOOKUP and VLOOKUP comes with accredited certification from CPD, 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 XLOOKUP and VLOOKUP. It is available to all students, of all academic backgrounds. Requirements Our XLOOKUP and VLOOKUP 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 20 lectures • 01:52:00 total length •What is XLOOKUP?: 00:01:00 •XLOOKUP Syntax: 00:08:00 •XLOOKUP Rules: 00:05:00 •XLOOKUP NA Error: 00:03:00 •XLOOKUP match_mode: 00:09:00 •XLOOKUP search_mode: 00:06:00 •XLOOKUP Wildcards: 00:11:00 •XLOOKUP Horizontal Lookup: 00:04:00 •XLOOKUP Across Different Spreadsheets: 00:03:00 •XLOOKUP Final Example: 00:07:00 •Introduction: 00:02:00 •What is VLOOKUP?: 00:01:00 •VLOOKUP Syntax: 00:06:00 •VLOOKUP - Range_lookup FALSE: 00:06:00 •VLOOKUP - Range_lookup TRUE: 00:06:00 •VLOOKUP Rules: 00:06:00 •VLOOKUP NA Errors: 00:06:00 •VLOOKUP Wildcards: 00:11:00 •VLOOKUP Insert Function: 00:04:00 •VLOOKUP Across Different Tabs: 00:07:00

Overview This comprehensive course on Unconscious Bias Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Unconscious Bias Training comes with accredited certification from CPD, 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 Unconscious Bias Training. It is available to all students, of all academic backgrounds. Requirements Our Unconscious Bias Training 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 6 sections • 6 lectures • 01:02:00 total length •Understanding Unconscious Bias: 00:10:00 •Sources and Causes of Bias: 00:10:00 •Unconscious Biases in the Workplace: 00:11:00 •Avoiding Unconscious Biases at Work: 00:10:00 •How Culture and Perception Influences Bias: 00:10:00 •Making the World a Fairer Place: 00:11:00

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Unlock the secrets of Wills and Probate Law. Navigate the complexities of estate planning and probate proceedings with expertise.

Overview This comprehensive course on Data Science & Machine Learning with Python will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Science & Machine Learning with Python comes with accredited certification from CPD, 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 Data Science & Machine Learning with Python. It is available to all students, of all academic backgrounds. Requirements Our Data Science & Machine Learning with Python 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 90 lectures • 10:24:00 total length •Course Overview & Table of Contents: 00:09:00 •Introduction to Machine Learning - Part 1 - Concepts , Definitions and Types: 00:05:00 •Introduction to Machine Learning - Part 2 - Classifications and Applications: 00:06:00 •System and Environment preparation - Part 1: 00:08:00 •System and Environment preparation - Part 2: 00:06:00 •Learn Basics of python - Assignment 1: 00:10:00 •Learn Basics of python - Assignment 2: 00:09:00 •Learn Basics of python - Functions: 00:04:00 •Learn Basics of python - Data Structures: 00:12:00 •Learn Basics of NumPy - NumPy Array: 00:06:00 •Learn Basics of NumPy - NumPy Data: 00:08:00 •Learn Basics of NumPy - NumPy Arithmetic: 00:04:00 •Learn Basics of Matplotlib: 00:07:00 •Learn Basics of Pandas - Part 1: 00:06:00 •Learn Basics of Pandas - Part 2: 00:07:00 •Understanding the CSV data file: 00:09:00 •Load and Read CSV data file using Python Standard Library: 00:09:00 •Load and Read CSV data file using NumPy: 00:04:00 •Load and Read CSV data file using Pandas: 00:05:00 •Dataset Summary - Peek, Dimensions and Data Types: 00:09:00 •Dataset Summary - Class Distribution and Data Summary: 00:09:00 •Dataset Summary - Explaining Correlation: 00:11:00 •Dataset Summary - Explaining Skewness - Gaussian and Normal Curve: 00:07:00 •Dataset Visualization - Using Histograms: 00:07:00 •Dataset Visualization - Using Density Plots: 00:06:00 •Dataset Visualization - Box and Whisker Plots: 00:05:00 •Multivariate Dataset Visualization - Correlation Plots: 00:08:00 •Multivariate Dataset Visualization - Scatter Plots: 00:05:00 •Data Preparation (Pre-Processing) - Introduction: 00:09:00 •Data Preparation - Re-scaling Data - Part 1: 00:09:00 •Data Preparation - Re-scaling Data - Part 2: 00:09:00 •Data Preparation - Standardizing Data - Part 1: 00:07:00 •Data Preparation - Standardizing Data - Part 2: 00:04:00 •Data Preparation - Normalizing Data: 00:08:00 •Data Preparation - Binarizing Data: 00:06:00 •Feature Selection - Introduction: 00:07:00 •Feature Selection - Uni-variate Part 1 - Chi-Squared Test: 00:09:00 •Feature Selection - Uni-variate Part 2 - Chi-Squared Test: 00:10:00 •Feature Selection - Recursive Feature Elimination: 00:11:00 •Feature Selection - Principal Component Analysis (PCA): 00:09:00 •Feature Selection - Feature Importance: 00:07:00 •Refresher Session - The Mechanism of Re-sampling, Training and Testing: 00:12:00 •Algorithm Evaluation Techniques - Introduction: 00:07:00 •Algorithm Evaluation Techniques - Train and Test Set: 00:11:00 •Algorithm Evaluation Techniques - K-Fold Cross Validation: 00:09:00 •Algorithm Evaluation Techniques - Leave One Out Cross Validation: 00:05:00 •Algorithm Evaluation Techniques - Repeated Random Test-Train Splits: 00:07:00 •Algorithm Evaluation Metrics - Introduction: 00:09:00 •Algorithm Evaluation Metrics - Classification Accuracy: 00:08:00 •Algorithm Evaluation Metrics - Log Loss: 00:03:00 •Algorithm Evaluation Metrics - Area Under ROC Curve: 00:06:00 •Algorithm Evaluation Metrics - Confusion Matrix: 00:10:00 •Algorithm Evaluation Metrics - Classification Report: 00:04:00 •Algorithm Evaluation Metrics - Mean Absolute Error - Dataset Introduction: 00:06:00 •Algorithm Evaluation Metrics - Mean Absolute Error: 00:07:00 •Algorithm Evaluation Metrics - Mean Square Error: 00:03:00 •Algorithm Evaluation Metrics - R Squared: 00:04:00 •Classification Algorithm Spot Check - Logistic Regression: 00:12:00 •Classification Algorithm Spot Check - Linear Discriminant Analysis: 00:04:00 •Classification Algorithm Spot Check - K-Nearest Neighbors: 00:05:00 •Classification Algorithm Spot Check - Naive Bayes: 00:04:00 •Classification Algorithm Spot Check - CART: 00:04:00 •Classification Algorithm Spot Check - Support Vector Machines: 00:05:00 •Regression Algorithm Spot Check - Linear Regression: 00:08:00 •Regression Algorithm Spot Check - Ridge Regression: 00:03:00 •Regression Algorithm Spot Check - Lasso Linear Regression: 00:03:00 •Regression Algorithm Spot Check - Elastic Net Regression: 00:02:00 •Regression Algorithm Spot Check - K-Nearest Neighbors: 00:06:00 •Regression Algorithm Spot Check - CART: 00:04:00 •Regression Algorithm Spot Check - Support Vector Machines (SVM): 00:04:00 •Compare Algorithms - Part 1 : Choosing the best Machine Learning Model: 00:09:00 •Compare Algorithms - Part 2 : Choosing the best Machine Learning Model: 00:05:00 •Pipelines : Data Preparation and Data Modelling: 00:11:00 •Pipelines : Feature Selection and Data Modelling: 00:10:00 •Performance Improvement: Ensembles - Voting: 00:07:00 •Performance Improvement: Ensembles - Bagging: 00:08:00 •Performance Improvement: Ensembles - Boosting: 00:05:00 •Performance Improvement: Parameter Tuning using Grid Search: 00:08:00 •Performance Improvement: Parameter Tuning using Random Search: 00:06:00 •Export, Save and Load Machine Learning Models : Pickle: 00:10:00 •Export, Save and Load Machine Learning Models : Joblib: 00:06:00 •Finalizing a Model - Introduction and Steps: 00:07:00 •Finalizing a Classification Model - The Pima Indian Diabetes Dataset: 00:07:00 •Quick Session: Imbalanced Data Set - Issue Overview and Steps: 00:09:00 •Iris Dataset : Finalizing Multi-Class Dataset: 00:09:00 •Finalizing a Regression Model - The Boston Housing Price Dataset: 00:08:00 •Real-time Predictions: Using the Pima Indian Diabetes Classification Model: 00:07:00 •Real-time Predictions: Using Iris Flowers Multi-Class Classification Dataset: 00:03:00 •Real-time Predictions: Using the Boston Housing Regression Model: 00:08:00 •Resources - Data Science & Machine Learning with Python: 00:00:00

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Elite EA/PA Forum We are delighted to announce three dates for our exclusive Elite EA/PA Forum. Facilitated by Facilitator Keynote 1 Keynote 2 Our aims for this workshop: Build and maintain resilience in the face of ever-increasing demands on time and energy Add to best-practice strategies for strengthening relationships online with colleagues, clients and key stakeholders Develop influencing skills to confidently handle difficult front-line situations and people Topic 1 Handling pressure with resilience Recognise what's within your control and how to let go of what's not Learn the science behind negative thinking and how to retrain your brain for maximum impact Explore how to find the bright spot in your ever-changing workstack for motivation Topic 2 Strengthening working relationships online Understand why online working makes it difficult to get people to do what you need Discover how best to build trust and connection when working remotely and in hybrid environments Learn the key do's and don'ts for virtual communication Topic 3 Managing time and boundaries Use conflict-handling strategies confidently for long-term benefits Practice ways to hold your ground without damaging your reputation Create and maintain boundaries for personal effectiveness Keynote Address with Q&A from the audience: Keynote from Chynna Clayton former assistant to First Lady of the United States, Michelle Obama. Opportunity for the audience to take part in a Q&A with Chynna on how to excel within an administration role Who will attend? Executive Assistant (EA) Personal Assistant (PA) Virtual Assistant (VA) Legal Secatary Legal Executive Assistant Administrative Assistant Office Manager Health Care Office Manager Chief of Staff Additional roles may be relevant depending on role responsibilities along with development opportunities. This workshop is open to females, male including trans women/males and non-binary professionals. Group Rate Discounts Group discounts are on request - see below group rate discount brackets: To discuss our group rates in more detail, please email support@elite-forums.com and provide the following: Group Number (How many would like to attend) Event Date (If numerous dates, please advise if we are splitting attendees across multiple dates) Attendee Contact details (Or request our and send back our Group Rates Attendee Document) Keynote 1 Keynote Bio 1 Keynote Speaker Empathetic, strategic, and meticulous about the details, Chynna Clayton has built a career enabling some of the world’s most influential leaders to excel in high-stress environments. Chynna is the founder and CEO of Matriarch Made Development, a consulting firm that helps organizations develop high performing administrative teams and identify and address overall operating structure and events logistics inefficiencies. From helping leaders figure out their onboarding, communication flow, event logistics and how to further develop the talents of their teams, Chynna supports leading organizations in creating a systematic approach to tackling business/events challenges and bottlenecks. Prior to Matriarch Made, Chynna worked in the personal office of Barack and Michelle Obama as their Director of Travel and Event Operations. Her career also includes administrative roles at Disney and the White House where she served as “body woman” to Mrs. Obama during the Obama Administration. Chynna graduated from University of Florida with a B.S. in Event Management and Political Science and a minor in Business. She currently resides in Washington, DC with her wife, Retired Naval Chief Petty Officer, Katina Hoyles. Chynna was featured in Michelle Obama’s latest book, The Light We Carry “She could adapt in all types of environments, remain­ing unflappable in the face of change. On any given day, I might go from having a conversation with a group of students at a school to filming a television show or recording a podcast. I could meet with a world leader or the head of a philanthropic organization and then have dinner with A-list celebrities. It was Chynna facilitating every move.” — Direct Quote from Michelle Obama in The Light We Carry Chynna Featured on The Michelle Obama's Podcast Facilitator Workshop Facilitator Kate is a business owner, qualified coach, consultant, facilitator, trainer, podcaster and public speaker with a background in learning & development, employee engagement strategy, continuous improvement, communications and marketing. After 25 years working across the board in blue-chip, non-profit and civil service organisations she now provides support to businesses looking to evolve and become great places for people to work in and with. Having worked with a wide variety of clients from school-age students to senior executives, she has been designing and running workshops, seminars and classes in person or via web events since she left long commutes and corporate roles behind in 2014 when she created her first two businesses. Her passion is in improving working relationships between roles and functions, supporting people to discover how to be their best selves at work. She does this in the auto-motive industry, financial services, medical teams, charities, global media, retail, education systems and the arts. When she’s not working, she and her classic car Monty Morgan can be found zipping around the English countryside. Kate's training & qualifications CTI Co-Active certified coach, ICF registered (CPCC) (PCC) Coach supervisor (ESQA) (EMCC) Lean Six Sigma Black Belt Lumina Sparks practitioner Hay Group Leadership Styles & Climate accredited coach Human Capital Institute certified in human capital strategy Sheppard Moscow advanced business consulting Conflict management trained (Thomas-Kilman instrument) Chartered Institute of Marketing Diploma So, will you be joining us? 🤔

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Gain the skills and credentials to kickstart a successful career in the technology industry and learn from the