YoVDO

Beginner's Excel Tutorial - Data Science-Analysis and Beyond

Offered By: Shashank Kalanithi via YouTube

Tags

Data Analysis Courses Data Science Courses Pivot Tables Courses Macros Courses Aggregate Functions Courses Goal Seek Courses

Course Description

Overview

Learn essential Excel skills for data analysis and data science in this comprehensive tutorial. Explore the Excel layout, file formats, and data types before diving into aggregate functions, lookups, and IF statements. Master string manipulation, formatting techniques, and data import processes. Discover powerful features like pivot tables, goal seek, and Excel solver. Gain insights on VBA, macros, and the differences between Excel versions. Perfect for beginners aspiring to become data analysts or data scientists, this course provides a solid foundation in Excel's capabilities for data manipulation and analysis.

Syllabus

- Introduction
- DataCamp Sponsorship
- Excel Layout
- Excel for Mac vs PC
- My Opinion on VBA
- Google Sheets
- Excel File Formats
- Data Types
- Aggregate Functions SUM, MEDIAN, MIN, MAX
- Lookups VLOOKUP, HLOOKUP, INDEX + MATCH + MATCH
- IF Functions
- String Functions CONCAT, TRIM
- Formatting
- Importing CSVs Correctly
- Remove Duplicates
- Text to Columns
- Filters
- Tables
- Pivot Tables
- Goal Seek
- Excel Solver
- Macros
- Final Thoughts on Excel


Taught by

Shashank Kalanithi

Related Courses

Microsoft Excel Pro Tips: Excel from Beginner to Advanced
Udemy
Excel Básico Avançado 5 Cursos - Formação Especialista
Udemy
Data Analytics for Pricing Analysts in Excel
LinkedIn Learning
Excel: Analytics Tips
LinkedIn Learning
Learning Excel What-If Analysis
LinkedIn Learning