[Free] Excel Essentials For Analytics (A Concise Introduction)

Excel for Analytics – Free Course

What you’ll learn

  • Learn how to input data into Excel from different sources (CSV, Text, SQL databases)
  • Learn key Excel functions used in analytics
  • Introduction to Excel Macros
  • Introduction to Pivot Tables
  • Learn how Excel can save you time writting SQL code
  • Become familar with key Excel functionalities used in analytics in under 2 hours.

Requirements

  • Requirements include Excel 2016 (or greater).

Description

My name is Julio Losada. I have postgraduate studies in Mathematics, Economics and Computer Science. For the past nine years I have worked in analytics across the Banking and FMCG industries.

Over this time, I have helped very busy colleges acquire essential Excel skills by keeping demonstrations simple and to the point. With this experience, I have identified the most commonly used Excel functionality applied in Analytics and created this course.

Excel Essential for Analytics (A Concise Introduction) is primarily geared towards graduates or busy professionals moving into an analytics role and needing to very quickly acquire relevant Excel skills.

The course centres around six key learning areas being: Handy cell functions, analytical functions, macros, pivot tables and Excel for SQL. Sub topics are listed below.

Input data

o CSV

o Text Files

o SQL databases

Handy cell functions

o SUMIF / COUNTIF

o VLOOKUP

o HLOOKUP

o LEFT / MID / RIGHT

o Index & Match

o IFERROR

o IFNA

o Sort

o Transpose

o Text to Columns

o Unique records

o Search & Replace

o Conditional Formatting

o Analytical Functions

o Linear Regression

o Multiple Linear Regression

o Test & Control Studies (Hypothesis Testing)

Automation with Macros

Pivot Tables

Excel for SQL coding

No previous Excel experience is necessary.

The only requirement is access to a computer with the Windows Excel program, preferably the 2016 version (or later).

Author(s): Julio Hernan Losada Perez
Coupon Scorpion
Coupon Scorpion

The Coupon Scorpion team has over ten years of experience finding free and 100%-off Udemy Coupons. We add over 200 coupons daily and verify them constantly to ensure that we only offer fully working coupon codes. We are experts in finding new offers as soon as they become available. They're usually only offered for a limited usage period, so you must act quickly.

Coupon Scorpion
Logo