Develop and Use Complex SpreadsheetsDevelop 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 ...

Author: Tilde Skills

Publisher:

ISBN: 0734608551

Category:

Page: 208

View: 827

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.

BSBITU402 Develop and Use Complex SpreadsheetsBSBITU402 Develop and Use Complex Spreadsheets



"This workbook covers the skills and knowledge required to use spreadsheet applications to complete business tasks and produce complex documents using Microsoft Excel 365 or Excel Professional Plus 2019." -- publisher website.

Author: Software publications writing team

Publisher:

ISBN: 1921971541

Category:

Page: 214

View: 260

"This workbook covers the skills and knowledge required to use spreadsheet applications to complete business tasks and produce complex documents using Microsoft Excel 365 or Excel Professional Plus 2019." -- publisher website.

Develop and Use Complex SpreadsheetsDevelop and Use Complex Spreadsheets



This text would also be of interest to any student undertaking a spreadsheet course in Excel 2016 which takes their skills to a complex level.

Author:

Publisher: Tilde Skills 2016

ISBN: 0734608861

Category:

Page:

View: 998

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 skills to a complex level.

Develop and Use Complex SpreadsheetsDevelop and Use Complex Spreadsheets



This learning guide addresses the Business Services Training Package (It Use Competency Standard Unit) BSBITU402A Develop and use complex spreadsheets.

Author: Brian Dawson

Publisher:

ISBN: 1864093722

Category:

Page: 214

View: 741

This learning guide addresses the Business Services Training Package (It Use Competency Standard Unit) BSBITU402A Develop and use complex spreadsheets. This learning guide is your guide to developing the required knowledge and skills for this unit, that is, the operation and use of a computer and spreadsheet technology to create complex worksheets. -- Publisher's website.

Develop and Use Complex SpreadsheetsDevelop and Use Complex Spreadsheets



Includes glossary, appendices and index. Fitzgerald is a teacher in the TAFE division of Swinburne University of Technology. Stephens is an information technology teacher and Symons runs a computer training and technical writing business.

Author: Mike Fitzgerald

Publisher:

ISBN: 0864582056

Category:

Page: 161

View: 322

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. Includes glossary, appendices and index. Fitzgerald is a teacher in the TAFE division of Swinburne University of Technology. Stephens is an information technology teacher and Symons runs a computer training and technical writing business.