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: 162
Software versions: Microsoft Excel 2007
Qualification: NZQA Unit Standard 2785
Click here to view table of contents (pdf 132 kb)