Skip to main content
IIE-Elearning
BSBITU402 Develop and use complex spreadsheets
0%
Previous
Course data
BSBITU402-Develop and Use Complex Spreadsheets
BSBITU402-Discussion Forum
Trainers Resources
Student Assessment tools
BSBITU402-Assessment 1 Submission Link
BSBITU402-Assessment 2 Submission Link
Re-Assessment Submission Link
BSBITU402 Student Assessment Tools
BSBITU402 Student Resources
Face To Face Activity
BSBITU402 Self-Study Guide 10-9-19
Conditional formatting
Absolute cell references
Relative Cell Refrence
What is a cell reference in Excel?
Utilise spreadsheet design software functions and formula
Identify Organisational Requirement
INTRODUCTION TO THE EXCEL SPREADSHEET
Link Multiple Spreadsheet Video Tutorial
Planning Spreadsheet
Analyse task and determine specification for spreadsheets
Organise personal work environment in accordance with ergonomic requirements
Test formulae to confirm output meets task requirements
Link Spreadsheet
Create, use and edit macros to fulfil requirements of task and automate spreadsheet operation
Maintain Consistency of Design
Formulas & Functions in Microsoft Excel
BSBITU402 Slideshow 27-3-19
BSBITU402 Student Guide 27-3-19
Next
IIE-Elearning
Side panel
Categories
All categories
School Of Accounting
School Of Accounting/FNS40217-Certificate IV of ...
School Of Accounting/FNS50222 Diploma of Account...
School Of Accounting/FNS50217-Diploma of Account...
School Of Accounting/FNS60217 Advanced Diploma O...
School Of Accounting/FNS40222 Certificate IV in ...
School Of Information Techn...
School Of Information Techn.../ICT40120 Certificate IV of ...
School Of Information Techn.../ICT50120 Diploma of Informa...
School Of Information Techn.../ICT60220 Advanced Diploma o...
School Of Information Techn.../ICT50220 Diploma of Informa...
School of Child Care
School of Child Care/CHC30113 Certificate III i...
School of Child Care/CHC50113 Diploma of Early ...
School of Child Care/CHC30121 Certificate III in...
School of Child Care/CHC50121 Diploma of Early C...
School Of Business and Mana...
School Of Business and Mana.../BSB50420-Diploma Of Leaders...
School Of Business and Mana.../BSB60420 Advanced Diploma o...
School Of Business and Mana.../BSB80615 Graduate Diploma o...
School Of Business and Mana.../BSB80120 Graduate Diploma o...
School Of Hospitality Manag...
School Of Hospitality Manag.../SIT40516 Certificate IV In ...
School Of Hospitality Manag.../SIT50416 Diploma Of Hospita...
School Of Hospitality Manag.../SIT60316 Advanced Diploma o...
School Of Hospitality Manag.../SIT40521 Certificate IV in ...
School Of Hospitality Manag.../SIT50422 Diploma of Hospita...
School Of Hospitality Manag.../SIT60322 Advanced Diploma o...
School of Telecommunication...
School of Telecommunication.../ICT51015 Diploma of Telecom...
School of Telecommunication.../ICT60615 Advanced Diploma o...
IIE Admission
International Marketing
School of Community Service
School of Community Service.../CHC52015 Diploma of Commun...
School of Community Service.../CHC52021 - Diploma of Commu...
School Of Health and Scienc...
School Of Health and Scienc.../CHC43115 Certificate IV in ...
School Of Health and Scienc.../CHC43015 Certificate IV in ...
School Of Health and Scienc.../CHC53315 Diploma of Mental ...
Home
More
Log in
Categories
Collapse
Expand
All categories
School Of Accounting
School Of Accounting/FNS40217-Certificate IV of ...
School Of Accounting/FNS50222 Diploma of Account...
School Of Accounting/FNS50217-Diploma of Account...
School Of Accounting/FNS60217 Advanced Diploma O...
School Of Accounting/FNS40222 Certificate IV in ...
School Of Information Techn...
School Of Information Techn.../ICT40120 Certificate IV of ...
School Of Information Techn.../ICT50120 Diploma of Informa...
School Of Information Techn.../ICT60220 Advanced Diploma o...
School Of Information Techn.../ICT50220 Diploma of Informa...
School of Child Care
School of Child Care/CHC30113 Certificate III i...
School of Child Care/CHC50113 Diploma of Early ...
School of Child Care/CHC30121 Certificate III in...
School of Child Care/CHC50121 Diploma of Early C...
School Of Business and Mana...
School Of Business and Mana.../BSB50420-Diploma Of Leaders...
School Of Business and Mana.../BSB60420 Advanced Diploma o...
School Of Business and Mana.../BSB80615 Graduate Diploma o...
School Of Business and Mana.../BSB80120 Graduate Diploma o...
School Of Hospitality Manag...
School Of Hospitality Manag.../SIT40516 Certificate IV In ...
School Of Hospitality Manag.../SIT50416 Diploma Of Hospita...
School Of Hospitality Manag.../SIT60316 Advanced Diploma o...
School Of Hospitality Manag.../SIT40521 Certificate IV in ...
School Of Hospitality Manag.../SIT50422 Diploma of Hospita...
School Of Hospitality Manag.../SIT60322 Advanced Diploma o...
School of Telecommunication...
School of Telecommunication.../ICT51015 Diploma of Telecom...
School of Telecommunication.../ICT60615 Advanced Diploma o...
IIE Admission
International Marketing
School of Community Service
School of Community Service.../CHC52015 Diploma of Commun...
School of Community Service.../CHC52021 - Diploma of Commu...
School Of Health and Scienc...
School Of Health and Scienc.../CHC43115 Certificate IV in ...
School Of Health and Scienc.../CHC43015 Certificate IV in ...
School Of Health and Scienc.../CHC53315 Diploma of Mental ...
Home
×
School Of Accounting
Summary
Course info
BSBITU402 Develop and use complex spreadsheets
BSBITU402 Develop and use complex spreadsheets
Teacher:
Leela Bhandari
Skill Level
:
Beginner