Course Outline

Basic Excel

  • Navigation
  • Manipulating data
  • Working with formulas and addresses
  • Charts

Advanced Excel 

  • Logical functions
  • Scenario analysis
  • Solver
  • Macros
  • First glimpse of code: VBA

VBA

  • Data types
  • Writing a function
  • Controlling a program: conditional evaluation and loops
  • Debugging techniques

Data Analytics with R

  • Introducing R
  • Variables and types
  • Data manipulation in R
  • Writing functions
  • Data visualization using ggplot
  • Data wrangling with Dplyr

Introduction to Machine Learning with R

  • Linear Regression
  • Classification and regression trees
  • Classification using Support Vector Machines and Random Forests
  • Clustering techniques

Requirements

There are no specific requirements needed to attend this course.

  42 Hours
 

Testimonials

Related Courses

SPSS Modeler

  14 hours

Databricks

  14 hours

Microsoft Power Platform Fundamentals

  14 hours

PL-900T00: Microsoft Power Platform Fundamentals

  7 hours

Data Cleaning

  7 hours

Sensu: Beginner to Advanced

  14 hours

Monitoring Your Resources with Munin

  7 hours

Automated Monitoring with Zabbix

  14 hours

Fluentd for Log Data Unification

  14 hours

Nagios Core

  21 hours

Nagios

  35 hours

Nagios XI Administration

  21 hours

Advanced Nagios

  21 hours

Zenoss Monitoring for Administrators

  21 hours

Netdata

  7 hours