Master data analysis and visualization in Excel to create stunning dashboards and automated reports.
Sub Category
- Microsoft
{inAds}
Objectives
- Introduction to Data Analysis Concepts
- Data Entry and Validation
- Data Cleaning and Transformation Techniques (Removing Duplicates, Handling Missing Values)
- Essential Excel Functions (SUM, AVERAGE, COUNT, IF, VLOOKUP, INDEX/MATCH)
- Array Formulas and Their Applications
- Creating and Customizing Pivot Tables
- Summarizing Data Using Different Aggregation Methods
- Filtering and Sorting Data in Pivot Tables
- Adding Conditional Formatting for Visual Insights
- Statistical Analysis Using Excel's Built-in Tools
- Data Mining Techniques (Basic Concepts)
- Correlation and Regression Analysis
- Recording and Editing Macros
- Creating Custom Functions Using VBA
- Creating Compelling Charts and Graphs
Pre Requisites
- You only need access to Microsoft Excel (Office 365, 2019, 2021 or recommended) and a computer.
- No microsoft excel experience needed
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)