Excel Essentials for Analytics (A Concise Introduction)

Looking to master Excel for Analytics? This concise course, created by Julio Losada – a professional with postgraduate studies in Mathematics, Economics, and Computer Science and 9 years of experience in analytics within Banking and FMCG – provides a fast-track to essential Excel skills for data analysis.

Designed for graduates and busy professionals transitioning into analytics roles, this course focuses on the most practical Excel functionality used in the field. No prior Excel experience is required! You'll learn to quickly and effectively manipulate data and gain valuable insights.

Here's a breakdown of what you'll learn:

• Data Input: Learn to import data from various sources including:
  • CSV files
  • Text Files
  • SQL databases
• Handy Cell Functions: Become proficient with core functions like:
  • SUMIF / COUNTIF
  • VLOOKUP / HLOOKUP
  • LEFT / MID / RIGHT
  • Index & Match
  • IFERROR / IFNA
  • Sort / Transpose
  • Text to Columns
  • Unique Records
  • Search & Replace
  • Conditional Formatting
• Analytical Functions: Develop your analytical capabilities with:
  • Linear Regression
  • Multiple Linear Regression
  • Test & Control Studies (Hypothesis Testing)
• Automation with Macros: Automate repetitive tasks and boost efficiency.
• Pivot Tables: Master pivot tables for powerful data summarization and analysis.
• Excel for SQL Coding: Learn to integrate Excel with SQL for advanced data retrieval.

This course is built on simple, to-the-point demonstrations, ensuring you quickly acquire the Excel skills you need to succeed in analytics. You'll need access to a computer with Windows Excel (version 2016 or later).