Feb 18, 2019  
2018-19 Undergraduate Catalog 
    
2018-19 Undergraduate 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.