Menu
Advance Excel With PowerBi
Advanced Excel with PowerBI
(Duration : 2 Months)
- Introduction to MS Excel
- Working with cells, Rows, Columns and Sheets
- Working with Formulas/ Functions
Lookup and Reference functions:
VLOOKUP, HLOOKUP, Etc.,
Logical Functions:
If/ Else, And, Or, Nested If etc.,
Date and Time Functions:
Date, days360 etc.,
Text Functions:
Left, Trim, Concatenate, etc.,
Information Functions:
Cell, Isblank, etc.,
Math Functions:
Round, sumif, etc.,
Financial and Banking Functions:
- PMT, Solver, etc.,
- Working with Chart
- Conditional Formatting
- Data Sorting and Filtering
- Data Consolidation
- Data Validation
- Pivot Tables
- Pivot Charts
- VBA Macro
- File and Data Securities
- Practical Corporate Project
Power BI (Business Intelligence):
- Data Management
- Interactive Data Visualization
- Analytics reporting
- Create Interactive Dashboard
- Power Query
- Question Box
- Power Reports