Excel Essentials For Analytics (A Concise Introduction)

Excel for Analytics

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 codingNo previous Excel experience is necessary.The only requirement is access to a computer with the Windows Excel program, preferably the 2016 version (or later).

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Input Data

Lecture 2 CSV Data Import

Lecture 3 Text File Data Import

Lecture 4 SQL Database (ODBC) Data Import

Section 3: Handy Cell Functions

Lecture 5 Sum IF / Count IF

Lecture 6 VLOOKUP

Lecture 7 HLOOKUP

Lecture 8 Index & Match

Lecture 9 IF Error

Lecture 10 IF NA

Lecture 11 Left / Mid / Right

Lecture 12 Table Sort

Lecture 13 Transpose

Lecture 14 Text to Columns

Lecture 15 Unique Records

Lecture 16 Search & Replace

Lecture 17 Conditional Formatting

Section 4: Analytical Functions

Lecture 18 Simple Linear Regression

Lecture 19 Multiple Linear Regression

Lecture 20 Test & Control Studies (Hypothesis Testing)

Section 5: Intro to Automation using Macros

Lecture 21 Introduction to Macros

Section 6: Introduction to Pivot Tables

Lecture 22 Intro to Pivot Tables

Section 7: Excel for SQL Coding

Lecture 23 Excel for SQL Coding

This course was designed for the busy professional or graduate entering the analytics profession.,The course includes demostrations on the most commonly used Excel features used in analytics.,Demostrations are concise and effective in order to save time.