Develop and Use Complex Spreadsheets

Topic 1 - Spreadsheet skills reviewed Topic 2 - Formulas in Excel Topic 3 - Functions in Excel Topic 4 - Using statistical functions Topic 5 - Viewing and adjusting worksheets Topic 6 - Using date & time functions Topic 7 - Using logical ...

Develop and Use Complex Spreadsheets

Author: Tilde Skills

Publisher:

ISBN: 9780734608550

Page: 208

View: 603

Topic 1 - Spreadsheet skills reviewedTopic 2 - Formulas in ExcelTopic 3 - Functions in ExcelTopic 4 - Using statistical functionsTopic 5 - Viewing and adjusting worksheetsTopic 6 - Using date & time functionsTopic 7 - Using logical functionsTopic 8 - Creating and editing templatesTopic 9 - Using lookup functionsTopic 10 - Using maths functionsTopic 11 - Charting and pictures in ExcelTopic 12 - Using financial functionsTopic 13 - Useful text functionsTopic 14 - Working with data in tablesTopic 15 - Creating PivotTables and PivotChartsTopic 16 - Useful database functionsTopic 17 - Importing & exporting dataTopic 18 - Linking Excel data to other programsTopic 19 - Tools for summarizing dataTopic 20 - Conditional formattingTopic 21 - Creating macros.

Related Books:

Develop and Use Complex Spreadsheets
Language: un
Pages: 208
Authors: Tilde Skills, Tilde Publishing and Distribution
Categories: Computers
Type: BOOK - Published: 2014 - Publisher:

Topic 1 - Spreadsheet skills reviewedTopic 2 - Formulas in ExcelTopic 3 - Functions in ExcelTopic 4 - Using statistical functionsTopic 5 - Viewing and adjusting worksheetsTopic 6 - Using date & time functionsTopic 7 - Using logical functionsTopic 8 - Creating and editing templatesTopic 9 - Using lookup functionsTopic
Develop and Use Complex Spreadsheets
Language: un
Pages:
Authors: Tilde Skills, Tilde Publishing and Distribution
Categories: Business & Economics
Type: BOOK - Published: 2017-04-19 - Publisher: Tilde Skills 2016

Develop and Use Complex Spreadsheets: Getting Results - Excel 2016 contributes directly to achieving the unit of competency BSBITU402 Develop and use complex spreadsheets in the Business Services Training Package. This text would also be of interest to any student undertaking a spreadsheet course in Excel 2016 which takes their
Develop and Use Complex Spreadsheets
Language: un
Pages: 161
Authors: Mike Fitzgerald, Ann Stephens, Judy Symons
Categories: Electronic spreadsheets
Type: BOOK - Published: 2002 - Publisher:

TAFE level textbook providing a step-by-step guide to the advanced features of Microsoft Excel 2000 for students with an existing knowledge of computer spreadsheets. Topics covered include sorting, lists, outlining, data tables, data validation, analysis tools, linking and embedding, pivot tables, creating and managing templates, and creating and managing macros.
Develop and Use Complex Spreadsheets
Language: un
Pages: 560
Authors: Greg Pazmandy
Categories: Microsoft Excel (Computer file)
Type: BOOK - Published: 2012 - Publisher:

Books about Develop and Use Complex Spreadsheets
Develop and Use Complex Spreadsheets
Language: un
Pages:
Authors: Greg Pazmandy
Categories: Electronic spreadsheets
Type: BOOK - Published: 2005 - Publisher:

Books about Develop and Use Complex Spreadsheets