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
Kyle D Saunders
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