Scribd
Upload
8 views1 page

Data Analysis With Excel

The document outlines a training module on Excel, covering topics such as the Excel interface, sorting and filtering data, formatting, and security features. It includes practical skills like using formulas, creating charts, and working with Pivot Tables. Each topic is designed to enhance users' proficiency in Excel for data management and analysis.

Uploaded by

maithili hedaoo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
8 views1 page

Data Analysis With Excel

The document outlines a training module on Excel, covering topics such as the Excel interface, sorting and filtering data, formatting, and security features. It includes practical skills like using formulas, creating charts, and working with Pivot Tables. Each topic is designed to enhance users' proficiency in Excel for data management and analysis.

Uploaded by

maithili hedaoo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Modul

Topic Description
e No.
Introduction to the Excel Overview of Excel window, ribbons, menus and
1
Interface navigation
Sorting data, using filters to narrow down
2 Sort and Filter
information
Data Type Selection, Number Setting data types, applying currency,
3
Formatting percentage, date formats
4 Freeze Panes Keeping headers visible while scrolling
5 Conditional Formatting Highlighting data using rules
Wrap Text, Printing and Page Text wrapping, print preview, setting print area
6
layout and layout
7 Security – Password Setting passwords to open/modify Excel files
Delimited Files CSV, TSV,
8 Importing and handling delimited text files
Semi-Colon
9 Formulas in Excel Basic formulas: SUM, AVERAGE, IF, etc.
Functions like LEFT, RIGHT, MID, LEN,
10 Text Functions
CONCATENATE
11 Pivot Tables Summarizing data with Pivot Tables
12 Creating Charts in Excel Generating pie, bar, and line charts
13 Using VLOOKUP Finding values using VLOOKUP

You might also like