Excel for Analytics

What you will 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.

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


Get Instant Notification of New Courses on our Telegram channel.


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).

English
language

Content

Introduction

Introduction

Input Data

CSV Data Import
Text File Data Import
SQL Database (ODBC) Data Import

Handy Cell Functions

Sum IF / Count IF
VLOOKUP
HLOOKUP
Index & Match
IF Error
IF NA
Left / Mid / Right
Table Sort
Transpose
Text to Columns
Unique Records
Search & Replace
Conditional Formatting

Analytical Functions

Simple Linear Regression
Multiple Linear Regression
Test & Control Studies (Hypothesis Testing)

Intro to Automation using Macros

Introduction to Macros

Introduction to Pivot Tables

Intro to Pivot Tables

Excel for SQL Coding

Excel for SQL Coding