Share Description
In this course, you will learn:-
- The students will learn the fundamentals of working with Excel.
Syllabus:-
- Creating a Loan Calculator-1
- Creating a Loan Calculator-2
- Creating a Loan Calculator-3
- Function Basics
- Logical Functions
- Mathematical Functions
- Lookup and Reference Functions
- LOOKUP, VLOOKUP, and HLOOKUP Functions
- Introduction to Advanced charts
- Line chart
- Column chart
- Pie chart
- Area Chart
- Converting area chart into line chart
- What is regression analysis?
- What are chart templates
- What are sparklines
- Sparklines vs charts
- Data in hidden rows and columns
- Introduction to Pivot chart and tables
- Creating pivot charts
- Creating pivot table
- Multiple fields in a row, column, or data section
- Creating pivot charts
- Creating and using calculated fields
