Back to Courses
Basic Computing

Advanced Excel & Data Analysis

6 Months  ·  2 Modules

Course Overview

Master advanced Excel skills and data analysis. Learn formulas, pivot tables, macros, Power Query, and business analytics.

Course Curriculum

1
Advanced Excel Fundamentals (4 Months)
Master Excel basics to advanced
Introducing Excel
Entering and Editing Worksheet Data
Essential Worksheets Operations
Working with Cell and Ranges
Introducing Table
Worksheet Formatting
Understanding Excel Files
Using and Creating Templates
Printing Your Work
Introducing Formulas and Functions
2
Data Analysis (6 Months)
Advanced data analysis techniques
Creating Formulas that Manipulate Text
Working with Dates and Times
Creating Formulas the Count and Sum
Creating Formulas that Look Up Values
Creating Formulas for Financial Applications
Performing Magic with Array Formulas
Creating Chart and Graphics
Creating Sparking Line Graphics
Using Custom Number Formats
Using Data Validation
Protecting Your Work
Importing & Cleaning Data
Introducing Pivot Tables
Performing Spreadsheet What if Analysis
Analyzing Data Using Goal Seeking, Solver and Consolidate
Macro & VBA with Macro
Power Query

Why Take This Course?

  • Industry-relevant curriculum designed by experts
  • Hands-on training with real-world projects
  • Personalized guidance from experienced instructors
  • Placement assistance after course completion
  • Lifetime access to course materials
  • Certificate of completion included
₹8,500
Course Fee

Course Details

Duration 6 Months
Modules 2
Category Basic Computing
Certification Included

Have questions? We're happy to help.

Contact Us
Related

Similar Courses

Basic Computer Skills
Learn computer fundamentals. Master Windows, MS Office, and Internet skills.…
4 Weeks ₹2,000
View Details

Student Testimonials

Success Stories from Our Students