Exploring Microsoft Excel and Microsoft Access

Exploring Microsoft Excel and Microsoft Access

Microsoft Excel is a spreadsheet application, which will enable the

analysis of data because it is able to perform calculations and

routine mathematical operations for example a cash flow forecast.

Spreadsheet files are known as workbooks, in which you work and store

your data. Because each workbook can contain many sheets, you can

organise various kinds of related information in a single file.

Simple formula such as using Sum will add up column or rows of data

quite easily, while more complicated formulas using IF statements can

compare different values and then inserts the appropriate result.

Worksheets are able to list and analyse data. You can enter and edit

data on several worksheets simultaneously and perform calculations

based on data from multiple worksheets. When you create a chart, you

can place the chart on the worksheet with its related data or on a

separate chart sheet. The names of the sheets appear on tabs at the

bottom of the workbook window. To move f...