Unit Standard Editions

Spreadsheets for Business

Spreadsheets for Business
This manual is written for people who use Excel in their everyday work and who have had little recent training. It's written for Excel 2013 so you'll learn about the newest features as well as the spreadsheet tools that have been around for generations. We've included real world exercises so you'll be able to apply your new knowledge to your everyday work. You'll learn about:
  • Creating basic Excel workbooks
  • Linking worksheets and workbooks
  • Relative, absolute and mixed cell references
  • Summarising data with SUMIF and COUNTIF
  • Validating data as it is entered
  • Creating charts (including using a secondary axis)
  • Working with data lists
  • Conditional formatting
  • Subtotals
  • IF functions
  • Nested functions
  • Entering and calculating dates and times
  • Tables and filters
  • Planning a spreadsheet solution
  • Templates
  • Financial functions
  • Summarising data with pivot tables
  • Filtering pivot tables with slicers and timelines
  • Creating pivot charts
ISBN: 1877350-12-5
Pages: 360+
Table of contents