Computer and Information Technology

COMPUTER APPLICATION
MICROSOFT OFFICE

GROUP 7
 INTRODUCING
GROUP 7
Irhan Jahan
Rabeya Islam Zebadiha
Yeana
Ohona Hossain Shaba
ID: 2285094
ID: 2285085 ID: 2285090

Hello!
Sumaiya Akter Alvina Khan Joyonti Rani
Shimu Nishi ID:2285095
ID: 2285086 ID: 2285091
Habiba Akter Nazmin Akter Taieba Ariana
ID:2285087 ID: 2285092 Kabir
ID: 2285097
Dipa Akter Umma Habiba
ID: 2285088 Anika Jannatul Ferdous
ID: 2285093 ID:2285098
Sweety Rani
ID: 2285089
 TOPIC SUMMARY

❑Introduction to MS Word, MS ❑PivotTable.

Excel , MS PowerPoint. ❑Data Validation.
❑Bulk Mailing Application in ❑VLOOKUP and HLOOKUP
MS Word. Function.
❑Application of Mathematical. ❑Financial analysis and Planning
❑Logical and Financial Templates in MS Excel.
Function in MS Excel. ❑Preparing Business
❑Sorting and Filtering. Presentation in MS PowerPoint.
❑Presenting Data Using Charts.
 USES
MICROSOFT WORD
▪ In Education: It is considered as one of the
simplest tools which can be used by both
Microsoft word is a word processing teachers and students. Creating notes is
program that allows for the creation of easier using MS Word as they can be made
more interactive by adding shapes and
both simple and complex document. It images. It is also convenient to make
is formerly developed by Charles assignments on MS Word and submitting
Simonyi and Rechard Brodie , software them online
engineers and it was released in 1983. ▪ In Workplace: Submitting letters, bills,
MS Word is one of the most widely creating reports, letterheads, sample
documents, can all easily be done using MS
used programs of Microsoft office Word
suite. It is also one of the office ▪ Creating & Updating Resume: One of the
productivity application involved in the best tools to create your resumes and is easy
Microsoft office suite. to edit and make changes in it as per your
experience.
▪ For Authors: Since separate options are
available for bibliography, table of contents,
etc., it is the best tool which can be used by
authors for writing books and adjusting it as
per the layout and alignment of your choice
 Insert
Tables, shapes,
images, charts, MS WORD
FEATURE
graphs, header,
footer, page number,
etc. can all be
entered in the
document. They are
included in the
“Insert” category.

Home References Review

Design
This has options like Page Layout This tab is the most Spell check, grammar,
The template or the
font color, font size, Under the Page useful for those who Thesaurus, word count,
design in which you
font style, alignment, Layout tab comes are creating a thesis language, translation,
want your document to
bullets, line spacing, options like margins, or writing books or comments, etc. can all
be created can be
etc. All the basic orientation, lengthy documents. be tracked under the
selected under the
elements which one columns, lines, Options like citation, review tab. This acts as
Design tab. Choosing an
may need to edit their indentation, spacing, footnote, table of an advantage for those
appropriate tab will
document is available etc. contents, caption, who get their
enhance the
under the Home bibliography, etc. can documents reviewed on
appearance of your
option. be found under this MS Word.
document.
tab.
 USES
MICROSOFT EXCEL
▪ Since there is no limit to the amount of information
that can be saved in a spreadsheet, MS Excel is widely
MS Excel is a spreadsheet program used to save data or to analyse data. Filtering
information in Excel is easy and convenient.
where one can record data in the form ▪ If the information is written on a piece of paper, finding
of tables. It is easy to analyse data in it may take longer, however, this is not the case with
an Excel spreadsheet. Excel is the excel spreadsheets. Finding and recovering data is easy.
world’s most widely used spreadsheet ▪ Doing calculations has become easier and less time-
software and is part of the Microsoft taking with the formulas option in MS excel.
▪ These spreadsheets can be password secured in a
Office suite. Other spreadsheet laptop or personal computer and the probability of
software is available, but Excel is by far losing them is way lesser in comparison to data written
the most popular and has been the in registers or piece of paper.
world standard for many years. Much ▪ Earlier, data was to be kept in different files and
of the appeal of Excel is due to the fact registers when the paperwork was done. Now, this has
become convenient as more than one worksheet can be
that it’s so versatile. added in a single MS Excel file.
▪ When the data is saved in the form of a table, analysing
it becomes easier. Thus, information is a spreadsheet
that is more readable and understandable.
 Page Layout
Themes, orientation
MS EXCEL View

FEATURE
and page setup Different views in which we want
options are available the spreadsheet to be displayed
under the page layout can be edited here. Options to
option zoom in and out and pane
arrangement are available under
this category

Home Insert Formulas

Comprises options Comprises options Review
Since tables with a Data Proofreading can be
like font size, font like table format and large amount of data Adding external data
styles, font colour, style, inserting done for an excel
can be created in MS (from the web), sheet (like spell
background colour, images and figures, excel, under this filtering options and
alignment, adding graphs, check) in the review
feature, you can add data tools are category and a reader
formatting options charts and formulas to your available under this
and styles, insertion sparklines, header can add comments in
table and get quicker category this part
and deletion of cells and footer option, solutions
and editing options equation and
symbols
 USES
MICROSOFT
POWERPOINT ▪ Education – With e-learning and smart classes being
chosen as a common mode of education today,
PowerPoint presentations can help in making education
MS PowerPoint is a program that is more interactive and attract students towards the
modified version of studying
included in the Microsoft Office suite. ▪ Marketing – In the field of marketing, PowerPoint
It is used to make presentations for presentations can be extremely important. Using
personal and professional purposes. graphs and charts, numbers can be shown more
The program was created in a software evidently and clearly which may be ignored by the
company named Forethought, Inc. by viewer if being read
▪ Business – To invite investors or to show the increase or
Robert Gaskins and Dennis Austin. decrease in profits, MS PowerPoint can be used
It was released on April 20, 1987, and ▪ Creating Resumes – Digital resumes can be formed
after 3 months of its creation, it was using MS PowerPoint. Different patterns, photograph,
acquired by Microsoft. It is a etc. can be added to the resume
presentation-based program that uses ▪ Depicting Growth – Since both graphics and text can be
added in a presentation, depicting the growth of a
graphics, videos, etc. to make a company, business, student’s marks, etc. is easier using
presentation more interactive and PPT
interesting.
 Design
The design menu
offers the user with MS POWERPOINT View tab

FEATURE
ready-made templates In the View tab, a user can have a
& background designs Normal View of a presentation.
for slides that make This is also called the default view.
the presentation look It consists of slides where one can
very attractive. add content for the presentation

HOME
From the Home Insert Slideshow
menu, users can add From the Insert Animations Review tab
Finally, from the Transition & The various tools that
new slides, decide menu, the user can Slideshow menu, the
their sequence, add media like Animation are the one can use under
user can view the unique functions of this tab are; Spelling,
layout, design & pictures, symbols, final form of the
other word audio, video, header, PowerPoint. These Research, Thesaurus,
slideshow. Users can menus offer different Translate, Language
processing functions footer, shapes, etc. start the slideshow
like font change, size to the slides to options in which the
from the first slide or text appears on the
change, etc. enhance the user’s the slide that users
PowerPoint layout is presentation. slides & takes
are editing. transitions from one
used to change the
layout of the current slide to another.
slide.
 BULK MAILING APPLICATION

USES

Mail Merge is a handy feature that

incorporates data from both Microsoft ▪ It is often used by organizations to send out
Word and Microsoft Excel and allows you coupons for different products or services.
to create multiple documents at once, ▪ Other than commercial use.
such as letters, saving you the time and ▪ Religious organizations.
effort of retyping the same letter over ▪ Educational institutions.
and over. Bulk mail is generally used for ▪ Libraries or clubs may use this method to send
advertising campaigns where a company information or invitations to their audiences and
or organization may send out information many others way.
about a new product, invitation to a
product launch, promotional offers, deals
or sales pitches, etc.
 MATHEMATICAL
APPLICATION

Mathematics has various applications across different fields. Some

notable applications include:
1. Physics:*
Mathematical models [Link]
and equations are Sciences:*
fundamental to Mathematics is
8.*Environmen applied in
understanding and [Link]: tal Science:*
describing physical psychology,
*Mathematics Mathematical
phenomena. 3. *Computer 7. *Medicine:* sociology, and
is essential in [Link]:* models aid in
Science:* [Link]:* [Link]:* Statistics and political science
designing and Mathematical studying and
Algorithms, Mathematics Mathematical mathematical for data analysis
analyzing models help in predicting
data is used in risk modeling is models are and modeling.
structures, analyzing environmental
structures, assessment, employed to used in
circuits, and economic changes,
and portfolio study medical
systems. trends, making climate
cryptography optimization, biological research, drug
predictions, patterns, and
heavily rely on and pricing processes, development,
and optimizing ecological
mathematical financial population and
decision- systems.
concepts. instruments. dynamics, and epidemiology.
making.
genetics.
 LOGICAL FUNCTION IN MS EXCEL

FUNCTION
Microsoft Excel provides 4 logical functions to work with the logical
[Link] functions are AND, OR, XOR, [Link] use these functions when
we carry out more than one comparison in our formula or test multiple
Logical function are used in spreadsheets to conditions instead of just one.
test whether a situation is true or [Link]
decisions can be used to display information, AND (Returns True if all of the argument evaluate to True) :Formula:
perform different calculations, or to perform =AND(A2>=10, B2<5)
The formula returns True if a value in cell A2 is greater than or equal to 10, and a
further tests. value in B2 is less than 5, False otherwise.

OR (Returns True if any argument evaluates to True) :Formula: =OR(A2>=10, B2<5)

The formula returns True if A2 is greater than or equal to 10 or B2 is less than 5, or both
conditions are [Link] neither of the conditions are met, the formula returns False.

XOR (Returns a logical Exclusive or of all arguments) :Formula: =XOR(A2>=10, B2<5)

The formula returns True if either A2 is greater than or equal to 10 or B2 is less than 5, if
neither of the conditions are met, the formula returns False.

NOT (Returns the reversed logical value of It's argument. I.e. if the argument if False, then True
is returned and vice-versa) : Formula: =NOT(A2>=10)
The formula return False if a value in cell A1 is greater than or equal to 10 True otherwise
 FINANCIAL FUNCTION IN MS EXCEL
FUNCTION
PV ( Present Value) Formula:PV (rate, nper, pmt, [fv], [type])
The PV function calculate the present value of an investment or a stream of
cash flows, considering the discount rate and the period.
FV (Future Value) Formula:FV ( rate, nper, pmt, [pv], [type])
Financial function in MS Excel are predefined FV helps determine the future value of an investment or a series of payments,
formulas specifically that perform financial accounting for the interest rate and the number of periods.

[Link] enable finance professionals NPV (Net Present Value) NPV measures the net present value of an investment by
to analyze financial data, make investment discounting the cash inflows and outflows at a specified rate.
decisions, calculate interest rates, determine This argument signifies the discount rate or the required rate of return for the investment.
payment schedules and evaluate risk and IRR ( Internal Rate of Return) Formula: IRR (values, [guess])
When the present value of cash inflows and outflows are equal, the internal rate of return, or
return profits.
IRR is calculated.

PMT (Payment)Formula: PMT (rate, nper,pv,[fv], [type])

PMT calculates tge periodic payment required to repay a loan or an investment, considering the
interest rate, the number of periods and principle amount.
Rate Formula: Rate ( nper, pmt, pv, [fv], [type], [guess])
Rate helps determine the interest rate per period for a loan or investment based on the number
of periods and the payment amount.
NPER (Number of Periods) Formula: NPER ( rate, pmt, pv, [fv], [type])
NPER calculates the periods required to repay a loan or investment, considering the interest
rate, the payment amount and the principle.
 SORTING and FILTERING
Sorting and filtering are tools that let you organize your data, you are putting it in order. Filtering data lets you hide unimportant data
and focus only on the data your interested in. when sorting information in a worksheet, you can rearrange the data to find values
quickly.

SORTING FILTERING
▪ Sorting is the process of arranging data into ▪ Filtering is commonly used within web-based
meaningful order so that you can analyze it more applications to narrow the users. List of choices to a
effectively. more manageable and usable number.
▪ In shorting we can short employees first by ▪ A filter can use machine learning or artificial
department and then by last name. intelligence to remove choices in order to simplify
▪ A list of words could be sorted alphabetically or by tasks or eliminate in appropriate options .
lenth . ▪ Filtering reduce the number of options to contain
▪ Sorting allows users to systematically work through only those matching user-selected criteria . These
the product list in an order they understand. include the characteristics to the products : color ,size
of type .

Sorting and filtering are two key and powerful capabilities of microsoft excel that help users to rapidly and effectively analyze ,organize ,
and interpret their data.
 Presenting Data Using Charts

Step 1: Create a basic chart Step 2: Change the layout or

style of a chart. Step 3: Add or remove titles or
o Insert a chart by embedding it
o Apply a predefined chart data labels.
into your document.
layout. o Add a chart title.
o Paste a linked Excel chart into
o Apply a predefined chart o Add axis titles.
your document.
style. o Add data labels.
o Arrange the Excel worksheet
data. o Change the format of chart
elements manually

Step 6: Move or resize a chart.

o Move a chart. Step 5: Display or hide primary
Step 4: Show or hide a legend
o Resize a chart chart axes or gridlines

Step 7: Save a chart as a

template
 Pivot Table

ADVANTAGES
A Pivot Table is used to summaries, sort,
reorganize, group, count, total or average
data stored in a table. It allows us to o Summarize large data sets quickly and
transform columns into rows and rows into easily.
columns. Also grouping by any field o Flexibility in data analysis.
(columns) and using advanced calculations o Ability to create interactive dashboards.
on them. o Automatic updates.
Pivot Tables work a little bit differently o Improved data accuracy.
depending on what platform we are using o Efficient report generation.
to run Excel . There are four areas (Filters, o Summary.
Columns, Rows and Values) where various
field names can be placed to create a Pivot
Table
 Pivot Table

STEPS TO CHANGE
STEPS
SUMMARY CALCULATION

Click any single cell

inside the data set.
Choose the type of
Click any cell calculations, we want
inside the sum of to use . For example ,
Amount column. click Count.
On the insert tab, in
the Tables group,
click Pivot Table.

Right click and click

on Value Field
Then click OK. Settings.
Then click OK.
 TYPES OF DATA
DATA VALIDATION VALIDATION

The process in which the perfection and

Most of the data validation procedures will run 1 or more of
classification of source data is been checked
this text to ensure that the data is correct before it is stored
before using importing and processing data is
in the database. There are some common data validation
called data validation. Various kinds of data
types-
validation can be operated depending on goal
▪ Data types check= A “ data type check” confirms that
contracts or objectives. The goal is to generate
data entered into a field is the correct data types.
data that is accurate and complete to avoid loss
▪ Code check= A “ code check “ confirms that a field is
and errors. It is cost effective because it saves
chosen from a vailed list of values or that certain
time and money. It removes duplication from the
formatting rules are followed.
data set. It’s also improves information collection
▪ Range check= A “ range check “ will determine wheather
for business. Data validation provides us with a
the input data falls within a given range.
consistence and religible solution told manage
▪ Consistency check= A “ consistency check” is a type of
data transfer between a variety of sources.
logical check that ensures data entered in a logically
consistent manner.
Also there are some types od data validation as example:
length check, lookup, uniqueness check etc.
 DATA VALIDATION

METHODS STEPS

▪ Validation by Scripts = In this method

the validation process is carried out Determine Data
Database
using a scripting language such as data format
validation
Python which is used to write the sample valuation
entire script for the validation process.
▪ Validation buy Programs= Many
you must ensure that Determine the overall
software programs are available to If you have a large data capability and the
all requirements are
help you validate data, because this amount of data to variation that requires
met with the existing
programs have been developed told validate, need a source data for the
database during the
understand your rules and files sample rather than targeted validation.
database validation
structures you are working with. the entire dataset.
process.
 VLOOKUP FUNCTION

The value you want to look up

VLOOKUP stands for ‘Vertical The range in which you want to

Lookup’. It is a function that makes find the value and the return
value
Excel search for a certain value in a Component
column (the so called ‘table array’), The number of the column
in order to return a value from a within your defined range, that
different column in the same row. contains the return value
This article will teach you how to 0 or FALSE for an exact match
use the VLOOKUP function. with the value your are looking
for; 1 or TRUE for an
approximate match.

Syntax: VLOOKUP([value], [range], [column

number], [false or true])
 HLOOKUP FUNCTION

The value you want to look up

HLOOKUP stands for Horizontal The range in which you want to

Lookup and can be used to retrieve find the value and the return
value
information from a table by Component
searching a row for the matching The number of the column
data and outputting from the within your defined range, that
corresponding column. While contains the return value
VLOOKUP searches for the value in 0 or FALSE for an exact match
a column, HLOOKUP searches for with the value your are looking
for; 1 or TRUE for an
the value in a row. approximate match.

Syntax: HLOOKUP([value], [range], [row number],

[false or true])
 Financial Analysis and Planning
Templates in MS Excel

Financial analysis and planning templates in MS Excel are pre-designed spreadsheets that help individuals and businesses analyze their financial
data and plan for the future. Here are some common types of financial analysis and planning templates you might find in Excel:

- Track income and - Display the financial - Evaluate a company's - Assess the viability of
expenses to create a position of a company Financial Ratio financial performance Investment potential investments.
Budget Balance Sheet using key ratios. - Calculate metrics such
comprehensive budget. at a specific point in Analysis Analysis
Templates Templates - Includes ratios like as NPV (Net Present
- Plan for monthly or time. Templates Templates
annual spending in - Show assets, liabilities, liquidity, profitability, Value) and IRR (Internal
different categories. and equity. and solvency. Rate of Return).

- Summarize revenues, - Monitor the inflow and - Predict future financial - Provide a visual
Income costs, and expenses Cash Flow outflow of cash over a performance based on summary of key
Statement over a specific period. Statement given period. Forecasting historical data. Dashboard financial metrics.
Templates - Calculate net income Templates - Classify cash activities Templates - Project income, Templates - Use charts and graphs
and analyze into operating, expenses, and cash to represent data for
profitability. investing, and flows. easy interpretation.
financing.
 Preparing Business Presentation
in MS PowerPoint

A business presentation can be defined as a formal introduction or information about new business products , ideas or practices . With MS PowerPoint , we can easily prepare
and create professional business presentations containing our Excel data . PowerPoint is a software program that allows users to create audiovisual slide presentations.

The following steps can be adapted in order to procure a presentation on standby:-

Launch a new/empty Include slides in the Personalize the slides Add slideshow transitions
presentation presentation with content or animations:

Contemplate about
Share your presentation Archive the presentation including presenter's
notes
Thank you