Cursor Insert India

Excel Expert

Excel Expert

Course Description

Module 1: Excel Essentials

  • Introduction to Excel Interface

  • Workbook & Worksheet Basics

  • Data Entry, Formatting, and Editing

  • Basic Calculations and Formulas

  • Number, Date & Text Formatting

  • Working with Rows, Columns, and Ranges

  • Basic Printing and Page Setup

Module 2: Advanced Formulas & Functions

  • Logical Functions: IF, IFS, AND, OR, NOT

  • Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH

  • Text Functions: LEFT, RIGHT, MID, TEXT, CONCAT, TEXTJOIN, TRIM, SUBSTITUTE

  • Date & Time Functions: TODAY, NOW, DATEDIF, NETWORKDAYS

  • Math Functions: SUMIF, COUNTIF, SUMIFS, COUNTIFS, ROUND, RANK, MOD

  • Dynamic Array Functions: FILTER, SORT, UNIQUE, SEQUENCE

Module 3: Data Tools & Data Validation

  • Data Sorting & Custom Sorting

  • Advanced Filtering

  • Data Validation Rules (Dropdowns, Lists, Restrictions)

  • Remove Duplicates

  • Text to Columns

  • Flash Fill

  • What-If Analysis: Goal Seek, Scenario Manager, Data Tables

Module 4: Charts & Data Visualization

  • Chart Types: Column, Bar, Line, Pie, Doughnut, Combo

  • Customizing Chart Elements (Titles, Legends, Data Labels)

  • Conditional Formatting (Color Scales, Data Bars, Icon Sets)

  • Sparklines

  • Dynamic Charts using Named Ranges & Tables

  • Best Practices for Data Visualization

Module 5: PivotTables & PivotCharts

  • Introduction to PivotTables

  • Grouping, Sorting, and Filtering Data in PivotTables

  • Calculated Fields & Items

  • Slicers & Timelines

  • PivotCharts

  • Drill-down and Report Layout Options

  • Advanced PivotTable Design

Module 6: Excel Tables & Structured References

  • Creating and Managing Excel Tables

  • Table Styles and Formatting

  • Using Structured References in Formulas

  • Table-based Data Analysis

  • Dynamic Ranges using Tables

Module 7: Automation with Macros & VBA (Optional/Advanced)

  • Recording Macros

  • Macro Security Settings

  • Introduction to VBA Editor

  • Writing Basic VBA Code

  • Automating Repetitive Tasks

  • Creating User-defined Functions (UDFs)

  • Building Interactive Forms with VBA

Module 8: Power Query & Data Modeling

  • Introduction to Power Query

  • Connecting to Multiple Data Sources

  • Cleaning, Transforming, and Merging Data

  • Loading Data to Excel or Data Model

  • Introduction to Power Pivot

  • Creating Relationships between Tables

  • DAX Basics (Data Analysis Expressions)

Module 9: Dashboard Design

  • Dashboard Design Principles

  • KPI Indicators

  • Using Form Controls for Interactivity

  • Linking PivotTables/Charts with Slicers

  • Combining Multiple Data Visualizations

  • Publishing & Sharing Dashboards

Module 10: Practical Business Projects

  • Sales and Revenue Dashboard

  • HR Employee Database Management

  • Inventory & Stock Tracking

  • Financial Budgeting and Forecasting

  • Marketing Campaign Tracking

  • Custom Reports with Interactive Filters

 

 

Course Syllabus

Module 1: Excel Essentials

Module 2: Advanced Formulas & Functions

Module 3: Data Tools & Data Validation

Module 4: Charts & Data Visualization

Module 5: PivotTables & PivotCharts

Module 6: Excel Tables & Structured References

Module 7: Automation with Macros & VBA (Optional/Advanced)

Module 8: Power Query & Data Modeling

Module 9: Dashboard Design

Module 10: Practical Business Projects


Duration: 2 Months
(8 Reviews)
Share on:

Search box

Categories

Advertisements

Popup Image Offer

Tags

Computer Science Business Management Arts & Design Personal Development Data Science Marketing Business & Finance Graphics Designer Financial Markets Fundamental Analysis Technical Analysis Commodity and Currency Excel and MS Office Financial Planning Banking and Credit Web Development Mobile Development Programming Language Database Design & Development No-Code Development Entrepreneurship Communication Management Sales Business Strategy Operations Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Accounting & Bookkeeping Money Management IT Certificates Network & Security Hardware Operating Systems & Server Microsoft Google SAP
Admission Query

Microsoft Office 365
6 Months
Excel and MS Office
Microsoft Office 365
(4.9 /19 Rating)
₹ 15000.00
  • Duration 6 Months
Excel and MS Office
Microsoft Office 365
(4.9 /13 Rating)
  • 13 Lessons
  • 28 Students
View Details
Microsoft Excel
3 Months
Excel and MS Office
Microsoft Excel
(4.9 /10 Rating)
₹ 10000.00
  • Duration 3 Months
Excel and MS Office
Microsoft Excel
(4.9 /4 Rating)
  • 13 Lessons
  • 28 Students
View Details
Microsoft Office 2024
6 Months
Excel and MS Office
Microsoft Office 2024
(4.9 /18 Rating)
₹ 20000.00
  • Duration 6 Months
Excel and MS Office
Microsoft Office 2024
(4.9 /11 Rating)
  • 13 Lessons
  • 28 Students
View Details
Advanced Excel
6 Months
Excel and MS Office
Advanced Excel
(4.9 /4 Rating)
₹ 25000.00
  • Duration 6 Months
Excel and MS Office
Advanced Excel
(4.9 /15 Rating)
  • 13 Lessons
  • 28 Students
View Details
Google Sheets (Google Excel)
3 Months
Excel and MS Office
Google Sheets (Google Excel)
(4.9 /18 Rating)
₹ 10000.00
  • Duration 3 Months
Excel and MS Office
Google Sheets (Google Excel)
(4.9 /4 Rating)
  • 13 Lessons
  • 28 Students
View Details
Microsoft Office 2021
6 Months
Excel and MS Office
Microsoft Office 2021
(4.9 /18 Rating)
₹ 20000.00
  • Duration 6 Months
Excel and MS Office
Microsoft Office 2021
(4.9 /19 Rating)
  • 13 Lessons
  • 28 Students
View Details
Start a ConversationStart a Conversation

Use this feature to chat with our agent.