Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Basic Information about Excel
- Data Types Excel – How Excel Handles Date and Time
- Finding and Highlighting Values in a Spreadsheet
- Protecting Worksheets
- Data Validation
- Creating Data Series
- Autocorrect
- Flash Fill
- Go To Special
- Paste Special
- Text to Columns
- Quick Access Toolbar
- Best Practices for Creating Spreadsheets
- Keyboard Shortcuts
- Cell Formatting
- Conditional Formatting
Creating Formulas
- Inserting Functions
- Editing Formulas
- Logical Functions
- Mathematical Functions
- Lookup Functions
- Text Functions
- Date and Time Functions
- Summing Cell Contents Using the Autosum Button
- Adding Functions Using a Dialog Box
- Estimating a Formula
- Determining the Location of a Value
- Naming a Range
- Modifying Named Ranges
- Using Named Ranges in Formulas
Creating a Pivot Table
- Basic Information about Pivot Tables
- Overview of Pivot Table Report Fields
Creating Charts and Pivot Charts
- Creating Pivot Charts
- Changing Chart Type
Requirements
Familiarity with the Windows system and basics of Ms Excel
14 Hours
Testimonials (7)
communication beween teacher and us
Julia Hudziak - LKQ Polska Sp. z o. o.
Course - Microsoft Office Excel - poziom średnio zaawansowany
I enjoyed the variety of practical exercises and Alex's patience.
Claudia - NEVEON Romania
Course - Microsoft Office Excel - intermediate level
Machine Translated
Module teaching, the fact that I received an answer to every question, practical exercises at the expense of theory.
Iuliana - NEVEON Romania
Course - Microsoft Office Excel - intermediate level
Machine Translated
The interaction of the trainer with the trainees
- NEVEON Romania
Course - Microsoft Office Excel - intermediate level
We have greatly appreciated the patience shown in working with us and the fact that the information presented has been relevant and will certainly facilitate our activity.
Adelina - NEVEON Romania
Course - Microsoft Office Excel - intermediate level
Machine Translated
Course OutlineModule TitleIntroduction to Machine LearningObjectiveThis module aims to provide students with a comprehensive understanding of the fundamental concepts and techniques in machine learning. By the end of this module, students will be able to apply machine learning algorithms to solve real-world problems and evaluate their performance.PrerequisitesBasic knowledge of programming in PythonFamiliarity with linear algebra and calculusCompletion of the course "Introduction to Data Science"Module Duration8 weeksWeek 1: Introduction to Machine Learning1.1 Course Overview1.2 What is Machine Learning?1.3 Types of Machine Learning1.4 Supervised Learning1.5 Unsupervised Learning1.6 Reinforcement LearningWeek 2: Data Preprocessing2.1 Data Collection2.2 Data Cleaning2.3 Data Transformation2.4 Feature Scaling2.5 Handling Missing ValuesWeek 3: Supervised Learning Algorithms3.1 Linear Regression3.2 Logistic Regression3.3 Decision Trees3.4 Support Vector Machines (SVM)3.5 K-Nearest Neighbors (KNN)Week 4: Evaluation Metrics4.1 Accuracy4.2 Precision and Recall4.3 F1 Score4.4 Confusion Matrix4.5 Cross-ValidationWeek 5: Unsupervised Learning Algorithms5.1 K-Means Clustering5.2 Hierarchical Clustering5.3 Principal Component Analysis (PCA)5.4 Association Rule Learning5.5 Anomaly DetectionWeek 6: Reinforcement Learning6.1 Introduction to Reinforcement Learning6.2 Markov Decision Processes (MDP)6.3 Q-Learning6.4 Deep Q-Networks (DQN)6.5 Policy Gradient MethodsWeek 7: Neural Networks and Deep Learning7.1 Introduction to Neural Networks7.2 Activation Functions7.3 Backpropagation7.4 Convolutional Neural Networks (CNN)7.5 Recurrent Neural Networks (RNN)Week 8: Project and Final Presentation8.1 Project Proposal8.2 Data Collection and Preprocessing8.3 Model Selection and Training8.4 Evaluation and Results8.5 Final PresentationAssessment1. Quizzes (20%)2. Midterm Project (30%)3. Final Project (50%)
Simona - NEVEON Romania
Course - Microsoft Office Excel - intermediate level
Machine Translated
I liked the presentation style for each module and the fact that it was very clear and easy for everyone to understand :)
