Course Outline
Excel Fundamentals
<\/h3>
-
Interface navigation
<\/li>
-
Data handling and modification
<\/li>
-
Utilizing formulas and cell references
<\/li>
-
Chart creation
<\/li>
<\/ul>
Advanced Excel <\/strong>
<\/h3>
-
Logical functions
<\/li>
-
Scenario modeling
<\/li>
-
Solver tool usage
<\/li>
-
Macro creation
<\/li>
-
Introductory coding with VBA
<\/li>
<\/ul>
VBA
<\/h3>
-
Data types
<\/li>
-
Function development
<\/li>
-
Program control: conditionals and loops
<\/li>
-
Debugging methods
<\/li>
<\/ul>
Data Analytics using R
<\/h3>
-
Overview of R
<\/li>
-
Variables and data types
<\/li>
-
Data processing in R
<\/li>
-
Function writing
<\/li>
-
Visualization via ggplot
<\/li>
-
Data wrangling with Dplyr
<\/li>
<\/ul>
Intro to Machine Learning with R
<\/h3>
-
Linear Regression
<\/li>
-
Classification and regression trees
<\/li>
-
Classification via Support Vector Machines and Random Forests
<\/li>
-
Clustering algorithms
<\/li>
<\/ul>
Advanced Excel <\/strong>
<\/h3>
-
Logical functions
<\/li>
-
Scenario modeling
<\/li>
-
Solver tool usage
<\/li>
-
Macro creation
<\/li>
-
Introductory coding with VBA
<\/li>
<\/ul>
VBA
<\/h3>
-
Data types
<\/li>
-
Function development
<\/li>
-
Program control: conditionals and loops
<\/li>
-
Debugging methods
<\/li>
<\/ul>
Data Analytics using R
<\/h3>
-
Overview of R
<\/li>
-
Variables and data types
<\/li>
-
Data processing in R
<\/li>
-
Function writing
<\/li>
-
Visualization via ggplot
<\/li>
-
Data wrangling with Dplyr
<\/li>
<\/ul>
Intro to Machine Learning with R
<\/h3>
-
Linear Regression
<\/li>
-
Classification and regression trees
<\/li>
-
Classification via Support Vector Machines and Random Forests
<\/li>
-
Clustering algorithms
<\/li>
<\/ul>
VBA
<\/h3>
-
Data types
<\/li>
-
Function development
<\/li>
-
Program control: conditionals and loops
<\/li>
-
Debugging methods
<\/li>
<\/ul>
Data Analytics using R
<\/h3>
-
Overview of R
<\/li>
-
Variables and data types
<\/li>
-
Data processing in R
<\/li>
-
Function writing
<\/li>
-
Visualization via ggplot
<\/li>
-
Data wrangling with Dplyr
<\/li>
<\/ul>
Intro to Machine Learning with R
<\/h3>
-
Linear Regression
<\/li>
-
Classification and regression trees
<\/li>
-
Classification via Support Vector Machines and Random Forests
<\/li>
-
Clustering algorithms
<\/li>
<\/ul>
Data Analytics using R
<\/h3>
-
Overview of R
<\/li>
-
Variables and data types
<\/li>
-
Data processing in R
<\/li>
-
Function writing
<\/li>
-
Visualization via ggplot
<\/li>
-
Data wrangling with Dplyr
<\/li>
<\/ul>
Intro to Machine Learning with R
<\/h3>
-
Linear Regression
<\/li>
-
Classification and regression trees
<\/li>
-
Classification via Support Vector Machines and Random Forests
<\/li>
-
Clustering algorithms
<\/li>
<\/ul>
Intro to Machine Learning with R
<\/h3>
-
Linear Regression
<\/li>
-
Classification and regression trees
<\/li>
-
Classification via Support Vector Machines and Random Forests
<\/li>
-
Clustering algorithms
<\/li>
<\/ul>
Requirements
No specific prior prerequisites are required to join this course. <\/p>
Testimonials (7)
Very practical
Deenan - Vodacom
Course - Data and Analytics - from the ground up
I really was benefit from the real life practical examples.
Wioleta
Course - Data and Analytics - from the ground up
I mostly liked the patience of Tamil.
Laszlo Maros
Course - Data and Analytics - from the ground up
Tamil is very knowledgeable and nice person, I have learned from him a lot.
Aleksandra Szubert
Course - Data and Analytics - from the ground up
Detailed and comprehensive instruction given by experienced and clearly knowledgeable expert on the subject.
Justin Roche
Course - Data and Analytics - from the ground up
The way the trainer made complex subjects easy to understand.
Adam Drewry
Course - Data and Analytics - from the ground up
Learning how to use excel properly.
