YoVDO

Data Analysis in Excel - Important Excel Skills for Data Analysts

Offered By: Great Learning via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses Data Visualization Courses Data Cleaning Courses Pivot Tables Courses

Course Description

Overview

Learn essential Excel skills for data analysis in this comprehensive tutorial video. Explore the phases of data analytic projects, master data cleaning functions, and dive into crucial Excel functions like COUNTIF, LEFT/RIGHT, CONCATENATE, and TRIM. Discover the power of conditional formatting, LOOKUP functions (VLOOKUP & HLOOKUP), and pivot tables. Gain hands-on experience with data visualization techniques using various chart types, including pie, bar, line, tree, and map charts. Enhance your data analysis capabilities and learn how to effectively visualize data using Excel's powerful features.

Syllabus

- Phases of Data Analytic projects
- Data Cleaning Functions
- Excel Functions
- COUNTIF Function
- LEFT/RIGHT Function
- CONCATENATE Function
- TRIM Function
- Conditional Formatting
- LOOKUP Functions VLOOKUP & HLOOKUP
- Pivot Tables
- Data Visualization Using Excel Pie Chart, Bar Chart, Line Chart, Tree Chart, Map Chart
- How to Visualize Data Using Excel


Taught by

Great Learning

Related Courses

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX