MS Excel Essentials

Catalog description

This is a comprehensive spreadsheet class using Microsoft Excel to create a variety of spreadsheets with emphasis on business applications. Introductory, intermediate, and advanced topics are covered. Introductory topics include entering, editing, and formatting data, creating basic formulas using arithmetic operator and functions, creating charts, saving and printing worksheets. Intermediate topics include using Excel's Table features for sorting filtering and summarizing data, creating PivotTables, working with multiple worksheets and workbooks, naming cells, data validation, recording macros, and protecting worksheets. Advanced topics include using financial functions such as PMT, RATE, FV, creating nested IFs, using VLOOKUP and HLOOKUP functions, using What-If analysis tools such as Goal Seek, one and two variable Data Tables, and Scenario Manager, sharing workbooks, and integrating Excel with other Office applications. Students who have completed or are enrolled in APAT 53 may not receive credit. 54 hours lecture, 54 hours laboratory. Transfer: CSU.