PG DEPARTMENT OF COMMERCE
Register Number :
Name of the student :
Name of the Programme :
Course Title :
Course Code :
Year/Semester :
Certificate
This is to certify that the bona fide record of Practical work done by the above student in
……………………………………………………………………… Laboratory during the
academic year ………………….
Faculty Incharge Head of the Department
******************************************************************************
The lab record submitted by ……………………. in …………………………………….
is evaluated on …………………….. by:
Internal Examiner External Examiner
, TABLE OF CONTENT
S.
DATE SYLLABUS MARK SIGNATURE
NO.
1. Prepare a simple monthly budget spreadsheet and
visualization
2. Students performance analysis
3. Time value of money analysis (Investment
opportunity analysis)
4. Develop a loan amortization schedule
5. Comprehensive financial analysis in excel
6. Creating an interactive financial dashboard
in excel
Prepare pivot tables to analyze and summarize
7.
financial data
8. Build a spreadsheet to calculate interest rates and
visualize it
9. Perform a comprehensive statistical analysis of
financial data
10. Apply macros to automate repetitive tasks
in excel
11. Combine data from multiple excel workbooks
using power query
12. Comprehensive text manipulation and analysis
in excel
, Ex.No. 01
Date: Prepare a Simple Monthly Budget Spreadsheet and
Visualization
Prepare a basic monthly budget spreadsheet, apply formatting for visual appeal,
Utilize basic formula to calculate total income, total expenditures and savings and also create a
bar chart to display a budget data.
AIM:
To create a monthly budget spreadsheet with visualization to effectively manage income,
expenditure and savings.
PROCEDURE:
Step 1: Start All programs MS office MS Excel for opening a spreadsheet.
Step 2: Enter a value for expenditures with items.
Step 3: Enter a value for income with items.
Step 4: Calculate total expenditure and total income by using formula
enter
Step 5: To find out the savings
, Step 6: To calculate savings percentage
Step 7: Add the visual representation for the value using conditional formatting function.
Home conditional formatting data bars color
Register Number :
Name of the student :
Name of the Programme :
Course Title :
Course Code :
Year/Semester :
Certificate
This is to certify that the bona fide record of Practical work done by the above student in
……………………………………………………………………… Laboratory during the
academic year ………………….
Faculty Incharge Head of the Department
******************************************************************************
The lab record submitted by ……………………. in …………………………………….
is evaluated on …………………….. by:
Internal Examiner External Examiner
, TABLE OF CONTENT
S.
DATE SYLLABUS MARK SIGNATURE
NO.
1. Prepare a simple monthly budget spreadsheet and
visualization
2. Students performance analysis
3. Time value of money analysis (Investment
opportunity analysis)
4. Develop a loan amortization schedule
5. Comprehensive financial analysis in excel
6. Creating an interactive financial dashboard
in excel
Prepare pivot tables to analyze and summarize
7.
financial data
8. Build a spreadsheet to calculate interest rates and
visualize it
9. Perform a comprehensive statistical analysis of
financial data
10. Apply macros to automate repetitive tasks
in excel
11. Combine data from multiple excel workbooks
using power query
12. Comprehensive text manipulation and analysis
in excel
, Ex.No. 01
Date: Prepare a Simple Monthly Budget Spreadsheet and
Visualization
Prepare a basic monthly budget spreadsheet, apply formatting for visual appeal,
Utilize basic formula to calculate total income, total expenditures and savings and also create a
bar chart to display a budget data.
AIM:
To create a monthly budget spreadsheet with visualization to effectively manage income,
expenditure and savings.
PROCEDURE:
Step 1: Start All programs MS office MS Excel for opening a spreadsheet.
Step 2: Enter a value for expenditures with items.
Step 3: Enter a value for income with items.
Step 4: Calculate total expenditure and total income by using formula
enter
Step 5: To find out the savings
, Step 6: To calculate savings percentage
Step 7: Add the visual representation for the value using conditional formatting function.
Home conditional formatting data bars color
