Nov 28, 2024  
2018-19 Undergraduate Catalog 
    
Catalog Navigation
  Catalog Home
  Mission, Vision, Values and History of Rockhurst University
  Rockhurst University Learning Themes
  Rockhurst Community
  Admission
  The Liberal Core Curriculum
  Schools, Colleges & Departments
  Programs of Study
  Course Descriptions
  Academic Policies and Procedures
  Special Undergraduate Academic and Co-Curricular Programs
  Tuition and Fees
  Financial Aid Programs and Policies
  Campus Life
  Campus Facilities
  Rockhurst Traditions
  Endowments and Scholarships
HELP
2018-19 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.