Data Analysis in Excel - Important Excel Skills for Data Analysts

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

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