Scribd
Upload
6 views28 pages

Excel Data Analysis Guide

Uploaded by

bgkbec14
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views28 pages

Excel Data Analysis Guide

Uploaded by

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

1) INTRODUCTION TO DATA IMPORT

1.1 Student Details


1.2 Subject Marks
1.3 Weeks
1.4 Arithmetic Operations
1.5 Student Marks with Grade
2) Working with data
2.1 Importing data
2.2 Sorting of Data
2.21 Sorting by Name
2.22 Sorting by Salary
2.23 Filter
3. EMPLOYEE SALARY STATEMENT
3. Data Validation
3.1 Pivot Table
3.2 Pivot Chat
4.1) Conditional formatting
4.21)
Data
Bars

4.22)
Color
Scales
4.23)
Icon
Sets

4.24)
Clear
rules
4.3) What if analysis
5) Text function in Excel
6. Date Functions
7. Conditional Formatting
I) Formatting the table Alignment justification coloring and
formatting the cells
ii) Highlighting the data in the table during data analysis
iii) Parsing the text
1) Left() 2)Right() 3)Mid()

4) Find()
5)length()
8. Working with Multiple Sheets
a) Budget file

b) Task
file
c) Reports file
9. Worksheet with Mentioned Fields with appropriate
Formulas and calculate the scenario also analyze the data
using a chart
10. Worksheet on Inventory management with mentioned
fields and calculate the scenario and also analyze the data
using appropriate chart
Assignment 11
Assignment 12
Record Macros

View Macros

You might also like