Skip to main contentUniversity of Michigan Business School Skip to site wide navigation barSkip to page navigation bar
Faculty & ResearchAcademicsAdmissionsStudent Career ServicesStudent LifeAlumniVisit
TechnologyRecruiter InformationCalendars & EventsNews RoomDirectories & Contacts
Home Academics
Search
Back to Section Homepage Back to Academics
YOU ARE HERE: Home > Academics > Curriculum > Course Descriptions 
Course Descriptions
Course catalog descriptions for courses offered in the W07(A) term.
 

Business Information Technology
 
BIT 512 Decision Support with Spreadsheets
  1.5 hours Elective Terms Offered: W07(A)
  Course Prerequisites: No credit in BIT 511/CIS 511 
   
  This course covers what-if analysis; charting; functions (e.g., financial; time and date; lookup; and others); one-variable and two-variable data tables; working with internal and external databases; sorting, querying and extracting; pivot tables; using information across multiple worksheets and workbooks; spreadsheet-based access to information on the World Wide Web; scenarios and scenario management; introductory optimization using Solver; and introductory material on the creation of macros in Visual Basic. Students can complete all assignments in this course on their own computer. (Microsoft certifies the CIS 512 textbook "Expert Level". This means that mastering the material in the book makes it possible to pass the MOUS - Microsoft Office User Specialist - Excel exam at the level of Expert.)
 
Search / SitemapAccessibility FeaturesPrivacy StatementUM Home