Introducing Excel will show you how to create and edit basic Excel spreadsheets. You will learn how to apply formats to workbooks, enter formulas, plan and create a worksheet, change a worksheet and chart worksheet data.
-
The elements of the Excel window
-
Updating existing workbooks
-
Adjust column widths
-
Apply formats to text labels and values
-
Apply borders, fills and fonts
-
Enter basic spreadsheet formulae: add, subtract, divide, multiply
-
Calculate totals with AutoSum
-
Find averages, minimum values and maximum values
-
Plan and create a worksheet
-
Budgets, cashflow and income statements
-
Ensure data accuracy and integrity
-
Change the page orientation
-
Insert and delete rows and columns
-
Clear cell contents
-
Move and copy cell contents
-
Correct spelling and typing errors
-
Manage files
-
Create column and pie charts
-
Add and delete data series
-
Customise charts
-
Create a chart template
ISBN: 1-877350-57-5
Total pages: 220
Qualification: NZQA Unit Standard 2784
Click here to view table of contents (pdf 150 kb)
