What you'll get

  • Govt. Verified Certification
  • Job Credibility
  • Certification Valid for Life
  • Lifetime Access To E-learning

Exam details

  • Mode of Exam : Online
  • Duration : 1 Hour
  • Multiple Choice Questions are asked
  • No. of Questions are asked : 50
  • Passing Marks : 25 (50%)
  • There is no negative marking

Course Content

Total: 54 lectures
  • Introduction
  • Structure of the course
  • Function Library Part 1
  • Function Library Part 2
  • AutoSum
  • How Date and Time Works
  • Basic Date and Time Functions
  • Complex Date and Time Functions
  • Text Functions Part 1
  • Text Functions Part 2
  • Logical Functions
  • Logical Functions Exercise
  • HLOOKUP
  • VLOOKUP
  • Lookup Functions Exercise
  • Financial Functions and Terminology
  • Personal Financial Functions
  • Professional Financial Functions
  • Depreciation
  • Financial Functions Exercise
  • Statistical Functions for Description Part 1 and Part 2
  • Statistical Functions for Forecasting Part 1 and Part 2
  • One Click Forcasting
  • Statistical Functions for Inference
  • Statistical Functions Exercise
  • Connect To Other Workbooks
  • Connect To Access Database
  • Connect To Web Data Sources
  • Get and Transform
  • External Data Exercise
  • Tables
  • Work With Tables
  • Table Reference
  • Table Styles
  • Tables Exercise
  • Pivot Tables
  • Work With Pivot Tables
  • Filters and Slicers
  • Pivot Charts
  • Pivot Tables Exercise
  • What If Analysis
  • Scenario Manager
  • Goal Seek
  • Solver
  • Data Analysis Exercise
  • Area Charts
  • Surface Charts
  • Radar Charts
  • Bubble Charts
  • Sparklines
  • Stock Charts
  • Graphs and Charts Exercise
  • Excel Web App
  • Use Excel Web App

Description

Reviews

Please login or register to review

Related Courses

BCC - Basic Computer Course

beginner

BCC - Basic Computer Course

4.4 (20)
₹1,534 ₹3,003
CCA - Certificate in Computer Application

beginner

CCA - Certificate in Computer Application

4.4 (20)
₹2,065 ₹3,157
Microsoft Excel

beginner

Microsoft Excel

4.4 (20)
₹1,770 ₹3,540
Data Analysts Toolbox - Excel, Python, Power BI

beginner

Data Analysts Toolbox - Excel, Python, Power BI

4.4 (20)
₹5,900 ₹35,400
Frequently Asked Questions