Office 2013

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