Spreadsheets: Unit Standard 2785

Create workbooks that include date, time, financial and logical functions. You will learn how to link worksheets with 3-D references, create macros and work with templates. This manual covers:

Creating formulas with absolute cell references
Working with and printing large worksheets
Date, time, financial and logical functions
Linking worksheets and workbooks
Charts, sorting, macros and templates
Creating a spreadsheet that solves a business problem

ISBN: 1-877350-62-1
Total pages: 160+
Qualification: NZQA Unit Standard 2785

Table of Contents

More from this collection

Extending Access

^$45

Extending Excel

from ^$19

Extending Publisher: Unit Standard 2789

^$45

Extending Word

^$50

Introducing Access

^$45

Introducing Microsoft Project

^$35

Introducing Publisher: Unit Standard 2788

^$45

Introducing Word

^$50

Presentations: Unit Standard 5940

^$42

Spreadsheets: Unit Standard 2784

^$42

Spreadsheets: Unit Standard 2785

^$42

Spreadsheets: Unit Standards 27642 and 27643

^$50

Word Processing: Unit Standard 111

^$45

Word Processing: Unit Standard 112

^$45