Mar 29, 2024  
2019-2020 Undergraduate Catalog 
    
2019-2020 Undergraduate Catalog [ARCHIVED CATALOG]

BIA 3801 - Excel: Expert Certification


(3)
This course will be a continuation of Electronic Spreadsheet Using Excel (BIA 1800 ). Students will learn advanced techniques for data processing (formatting, locking, using templates, advanced copying, etc.) The course will focus on complex formulas and functions belonging to the date & time and text categories, as well as the logical, financial, and database functions. Students will learn how to filter lists on a sheet and create pivot tables. They will also practice advanced chart editing. The course will focus on how to work with the advanced Microsoft Excel functions for data manipulation and analysis. They will be familiarized with macro creation, with the SML format and its use in MS Excel, with protecting and managing permissions for accessing workbooks.