Help

Course Information

Spreadsheet Apps II MS Excel (BTEC 2140)

Term: 2019-2020 Certificate Seeker

Faculty

Emily Hudson
Email address is hidden, click here to email
Kristen Kae Bogue
Email address is hidden, click here to email
Email all faculty members

Description

Spreadsheet Apps II is a continuation from Spreadsheets Apps I and is designed to provide students with an advanced knowledge of formatting techniques, spreadsheet functions, analysis tools, and management techniques.
Objectives:
• Apply advanced formatting techniques, functions, and formulas
• Create, format, and filter Tables and PivotTables
• Use data analysis features to create scenarios, reports, and variable data tables
• Protect and share worksheets and workbooks
• Automate repetitive tasks and customize Excel workbooks
• Import, export, and distribute data