Master Spreadsheet Skills with Step-by-Step Guidance on Formulas, Functions, and Data Analysis.
Sub Category
- Microsoft
{inAds}
Objectives
- Navigating Worksheets and Workbooks
- Cell Referencing: Relative, Absolute, and Mixed References
- Basic Operators: +, -, *, /, ^
- Common functions: SUM, AVERAGE, COUNT, MAX, MIN
- Text Formatting and Data Cleaning
- Conditional Formatting
- Calculating Durations and Deadlines
- VLOOKUP, HLOOKUP, INDEX, MATCH
- Data Analysis and Interpretation
- Formatting and Customizing Charts
- Filtering and Grouping Data
- Adding Data Labels and Legends
- Creating and Using Array Formulas
- Advanced Data Analysis Techniques
- Creating Drop-Down Lists
- Restricting Data Entry with Data Validation
Pre Requisites
- No 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)