ACCTG 31B - Advanced Excel for Accounting

    Recent Professors
    Valdivia O.
    Recent Semesters
    Fall 2026
    Class Size
    Not published
    Credits
    3
    Fall 2026 Sections
    View Fall 2026 sections of ACCTG 31B
    Transfers To
    CSU
    Description
    This course includes the advanced application of Excel for accounting features. Topics include the use of complex Excel functions and formulas, advanced Charts, advanced database features, Consolidation, Data Validation, PivotTables and PivotCharts, an introduction to Visual Basic, Dashboards and Power BI, and other advanced Excel features with emphasis on accounting as a financial analysis tool. This class will prepare students for the Microsoft Office Expert certification exam. This course uses Microsoft Office 365 and Power BI.