Excel Basics To Advanced Formulas, Functions, Data Analysis, PivotTables and Reporting Made Easy
Sub Category
- Microsoft
{inAds}
Objectives
- Navigating the Excel interface
- Understanding Workbooks, Worksheets, Rows, Columns, and Cells
- Using Basic Shortcuts for Efficiency
- Formatting Cells (font, size, color, borders)
- Adjusting Row and Column Sizes
- Data Validation Techniques (drop-down lists, data types)
- Using SUM, AVERAGE, COUNT, MIN, MAX
- Understanding Relative, Absolute, and Mixed References
- Logical Functions: IF, AND, OR
- Text Functions: CONCATENATE, LEFT, RIGHT, MID, LEN
- Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP
- Using Slicers and Timelines for Interactive Analysis
- Dynamic Charts Using Named Ranges and more
Pre Requisites
- No experience needed. You'll learn everything from the beginning.
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)