Introducing Excel

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

    Table of Contents