CIS 54 - MS Excel Essentials

    Recent Professors
    DEBBIE FIELDS, ANITA BHATIA
    Recent Semesters
    Fall 2026, Spring 2026, Fall 2025, Spring 2025, Fall 2024
    Class Size
    30–46 students
    Credits
    4
    Prerequisite
    Recommended Course Preparation: CIS 50
    Fall 2026 Sections
    View Fall 2026 sections of CIS 54
    Transfers To
    CSU
    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.
    Usually Held
    Tue 9:30am–12:00pm, Tue 9:30am–12:20pm, Tue 9:40am–12:50pm