Be Competent in Producing Spreadsheets - Microsoft Excel 2010 contributes directly to achieving the unit of competency BSBITU304A Produce spreadsheets in the Business Services Training Package (BSB07). This book would also be of interest to any student requiring a spreadsheet course which encompasses formulas, functions, formatting and charts.
The Tilde Group
About the book
Table of Contents
Topic 1 - What is a spreadsheet?, Topic 2 - The Excel environment, Topic 3 - Basic operations in Excel, Topic 4 - Navigating your data, Topic 5 - Summing & editing your data, Topic 6 - More efficient data entry, Topic 7 - An introduction to formatting, Topic 8 - Mathematic principles, Topic 9 - Creating simple formulas, Topic 10 - More about cell references, Topic 11 - Working with functions, Topic 12 - Editing formulas & functions, Topic 13 - Organising your worksheets, Topic 14 - Viewing & printing your worksheet, Topic 15 - Creating a chart, Topic 16 - Modifying your worksheet, Topic 17 - More formatting, Topic 18 - Efficient text entry & correction, Topic 19 - Using pictures in your worksheets, Topic 20 - Storing your workbooks, Topic 21 - Securing and distributing data.
BSBITU304A Produce spreadsheets
About the authors
The Tilde Group is the authoring entity for Tilde Publishing and Distribution's TILDE skills imprint.