Day 1

Live interaction on course

Day 2

Lecture Series start….

Day 3

Lecture Series cont.…

Day 4

Lecture Series cont.…

Day 5

Lecture Series end.…

Day 6

Live interactions, Doubt Sessions and Feedback

Day 7

MCQ-based Quiz

1

Data Analysis using Microsoft Excel - 1

0

-

2

-

1

15

ACP

Course Objectives

i) To communicate clear and concise message through your charts

ii) To create dynamic reports by mastering one of the most popular tools like PivotTables.

iii) To automate tedious and time-consuming tasks using cell formulas and functions in Excel

iv) To develop automated dashboards, scrolling charts and dynamic formats.

PRE-REQUISITE

Basic Understanding of Statistics

Course Outcome

i) To organise data by applying specified formatting only when certain conditions are met

ii) To examine accuracy and quality of data before applying any statistical tool

iii) To summarize and analyze large dataset in excel

iv) To design charts that clarify and provide the right canvas for analysis

v) To develop a basic financial model in excel

Course Contents

Level 1 – Beginner: Excel for Beginners

i) Basic Formatting: Introduction to Excel, Basic Excel Formatting

ii) Print Options & Settings in Excel

iii) Excel Shortcuts

iv) Personal Finance Tracker with Date & Time Functions

v) Working with Data: Conditional Formatting, Removing Duplicates, Sorting, Filtering Data

vi) Conditional Logic: OR, AND, NOT etc,

Day 1

·         Basic Formatting: Introduction to Excel, Basic Excel Formatting

·         Print Options & Settings in Excel

Day 2

Excel Shortcuts

Day 3

Personal Finance Tracker with Date & Time Functions

(Part 1)

Day 4

Personal Finance Tracker with Date & Time Functions

(Part 2)

Day 5

Working with Data: Conditional Formatting, Removing Duplicates, Sorting, Filtering Data

Day 6

Conditional Logic: OR, AND, NOT etc.

(Part 1)

Day 7

Conditional Logic: OR, AND, NOT etc.

(Part 1)

Dr. Nikhil Kaushik

9896314170

nikhil.e11022@cumail.in