Excel Data Analysis: Learn to clean, analyze and visualize financial & business data using Excel’s most powerful tools.
Sub Category
- Microsoft
{inAds}
Objectives
- Understanding the Excel Interface.
- Navigating Workbooks, Worksheets, and Ribbons.
- Saving, Sharing, and Printing Excel Files.
- Using Basic Formulas and Functions (SUM, AVERAGE, COUNT).
- Understanding Relative, Absolute, and Mixed References.
- Sorting and Filtering Data.
- Conditional Formatting and Rules.
- Using Logical Functions (IF, AND, OR).
- Lookup and Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH).
- Creating Slicers for Dynamic Filtering.
- Advanced Filtering Techniques.
- Using What-If Analysis (Goal Seek, Scenario Manager, Data Tables).
- Creating advanced charts (Waterfall, Histogram, Pareto).
- Designing professional dashboards.
- Customizing chart elements.
- Using sparklines and data bars.
Pre Requisites
- A basic understanding of Excel (no advanced experience required)
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)