Microsoft Excel Data Analyze Faster and Smarter with Excel Functions—Perfect for Students, Analysts, and Professionals
Sub Category
- Microsoft
{inAds}
Objectives
- Entering and Editing Data in Cells
- Data Alignment and Text Wrapping
- Formatting Cells (number formats, fonts, colors)
- Arithmetic Operators (+, -, *, /)
- Using Functions with Cell References
- Sorting Data in Ascending/Descending Order
- Filtering Data Based on Criteria
- Creating Data Validation Rules
- Understanding Logical Tests and Cconditions
- Using IF Function for Decision Making
- Looking up Values in a Table
- Adding Fields, Filters, and Calculations to Pivot tables
- Understanding the Purpose of Pivot Tables
- Conditional Calculations with SUMIF, COUNTIF, AVERAGEIF
- Text Functions (LEFT, RIGHT, MID, CONCATENATE)
- Different Chart Types (bar charts, line graphs, pie charts)
- Customizing Chart Appearance
- Adding Data Labels and Legends
- Performing Regression Analysis
Pre Requisites
- No Prior Microsoft Excel Knowledge 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)