Introducing Excel
Introducing Excel is perfect for anyone who is new to 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
- Create column and pie charts
- Edit chart data and customise charts
ISBN: 1-877350-57-5
Total pages: 220+
Qualification: NZQA Unit Standard 2784
More from this collection
