No Cost
- MS Excel Reference
- Working with Math Functions
- Working with Sumif & Sumifs
- Working with String Functions
- Working with Date Functions
- Working with IF based Conditions
- Working with VLookup Function
- Working with HLookup function
- Working with Data Filters
- Working with Advanced Data Filter
- Working with Data Sorting
- Working with Data Validation
- Working with Sparklines
- Working with Conditional Formatting
- Working with What-If Analysis Goalseek
- Scenario Manager-
- DataTable
- Working Pivot Table for Data Summarization
- Working with Line Chart
- Working with Pie Chart
- Working with Scatter chat
- Working with Bubble chart
- Working with Raddar chart
- Implementing Security in Excel File
- Excel Dashboard -Case Study (Solution)
- MS Excel Reference
- Working with Math Functions
- Working with Sumif & Sumifs
- Working with String Functions
- Working with Date Functions
- Working with IF based Conditions
- Working with VLookup Function
- Working with HLookup function
- Working with Data Filters
- Working with Advanced Data Filter
- Working with Data Sorting
- Working with Data Validation
- Working with Sparklines
- Working with Conditional Formatting
- Working with What-If Analysis Goalseek
- Scenario Manager-
- DataTable
- Working Pivot Table for Data Summarization
- Working with Line Chart
- Working with Pie Chart
- Working with Scatter chat
- Working with Bubble chart
- Working with Raddar chart
- Implementing Security in Excel File
- Excel Dashboard -Case Study (Solution)
- MS Excel Cell Reference
- Working with Math Functions
- Working with Sumif & Sumifs
- Working with String Functions
- Working with Date Functions
- Working with IF based Conditions
- Working with VLookup Function
- Working with HLookup function
- Working with Data Filters
- Working with Advanced Data Filter
- Working with Data Sorting
- Working Pivot Table for Data Summarization
- Working with Data Validation
- Working with Sparklines
- Working with Conditional Formatting
- Working with What-If Analysis -Goalseek
- Working with What-If Analysis -Scenario Manager
- Working with What-If Analysis - DataTable
- Working with Line Chart
- Working with Pie Chart
- Working with Scatter chat
- Working with Bubble chart
- Working with Raddar chart
- Implementing Security in Excel File
| Exam Code | DF-CL-EXL-01 |
| Exam Name | Foundation Certificate on Data Analytics & Reporting using MS Excel 2016 |
| Difficulty Level | Foundation |
| Nos. of Questions | 20-30 |
| Exam Duration | 40-50 Minutes |
| Exam Mode | Online |
| Proctoring | NA |
| Exam Fees | Free |
| Passing Criteria | 80% or above in online assessments |
| Register Now Login Now |
