Главная
Study mode:
on
1
- Introduction
2
- DataCamp Sponsorship
3
- Excel Layout
4
- Excel for Mac vs PC
5
- My Opinion on VBA
6
- Google Sheets
7
- Excel File Formats
8
- Data Types
9
- Aggregate Functions SUM, MEDIAN, MIN, MAX
10
- Lookups VLOOKUP, HLOOKUP, INDEX + MATCH + MATCH
11
- IF Functions
12
- String Functions CONCAT, TRIM
13
- Formatting
14
- Importing CSVs Correctly
15
- Remove Duplicates
16
- Text to Columns
17
- Filters
18
- Tables
19
- Pivot Tables
20
- Goal Seek
21
- Excel Solver
22
- Macros
23
- Final Thoughts on Excel
Description:
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.

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

Shashank Kalanithi
Add to list
0:00 / 0:00