0 (0 Ratings)

MS-Excel

S
by Swastika1
Course Duration: 3h
Enrolled:0

Topics for this course

MS-EXCEL

  • MS Excel Basics
    06:56
  • Worksheet Basics
    14:22
  • Entering Values and Formulas
    06:38
  • Data Formats
    07:01
  • Cut Copy & Paste
    12:24
  • Saving And Printing
    07:59
  • Basic Formula Operations
    10:15
  • Mathematical Functions
    15:22
  • Textual Funtions
    14:10
  • Logical Formulas
    10:31
  • Date Time Functions
    06:20
  • Lookup Functions (V lookup , H Lookup)
    08:33
  • Data Tools
    18:20
  • Formatting Data Tables
    16:06
  • Pivot Tables
    07:57
  • Excel Charts
    04:04
  • Elements of Charts
    04:26
  • The Easy Way of Creating Charts
    03:10
  • Bar and Column Charts
    11:13
  • Formatting Charts
    13:06
  • Line Charts
    07:44
  • Area Charts
    04:42
  • Pie and Doughnut Charts
    10:48
  • Scatterplot or XY chart
    11:37
  • Frequency Distribution and Histograms
    11:56
  • Pivot Charts
    04:17
  • Waterfall Charts
    11:37
  • Mini charts Sparklines
    05:08
  • Macros
    09:33
  • Named Ranges – Excel
    09:26
  • Indirect Function – Excel
    05:11
  • Excel Shortcuts
    11:39
  • Advanced Excel
    15:34
  • MS Excel Quiz

Description

This MS Excel course provides a complete foundation in spreadsheet management, data analysis, and reporting. It starts with Excel basics, worksheets, data entry, formatting, and essential formulas. Learners progress to mathematical, text, logical, date-time, and lookup functions. The course covers data tools, pivot tables, pivot charts, and a wide variety of charts for visual analysis. Advanced topics include macros, named ranges, indirect functions, shortcuts, and advanced Excel features. Through hands-on practice, learners gain practical skills to analyze data, automate tasks, and create professional reports for business and analytical use.

What I will learn?

  • Understand Excel interface, worksheets, data entry, formatting, saving, printing, and essential spreadsheet management techniques.
  • Apply basic and advanced formulas including mathematical, text, logical, date-time, and lookup functions effectively.
  • Use data tools to clean, organize, and manage large datasets efficiently.
  • Create and analyze pivot tables and pivot charts for quick data summarization.
  • Design professional charts including bar, line, pie, scatter, waterfall, and sparklines for insights.
  • Perform frequency distribution, histograms, and analytical reporting using Excel tools.
  • Automate tasks using macros, named ranges, shortcuts, and advanced Excel features.
₹1,998.00 ₹2,999.00
  • Level
    Intermediate
  • Duration
    3 hours
  • Last Updated
    January 7, 2026
  • Certificate
    Certificate of completion

Tags

Marketing

Target Audience

  • Students learning spreadsheets for academic and professional purposes.
  • Beginners wanting to learn Microsoft Excel from scratch.
  • Data analysts requiring Excel skills for data handling.
  • Business professionals working with reports and data analysis.
  • Accountants and finance professionals using Excel daily.
  • Working professionals improving productivity through advanced Excel features.
  • Entrepreneurs managing business data and performance reports.
  • Trainers and educators teaching Excel and data analysis tools.

Requirements

  • Basic computer knowledge and familiarity with Windows operating system usage.
  • MS Excel installed on laptop or desktop computer.
  • Willingness to practice formulas, functions, and data analysis tasks.
  • No prior Excel experience required for this course.

IICS India is an online training programme for digital economy skills that aims to provide students the knowledge and abilities they need to succeed in the sector.

About Us

Product

Important Pages

For Affiliates

Contact

iicscomputereducation@gmail.com

+91-9540299944

IICS India © 2023 All Rights Reserved.