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 BIT 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.)
http://webuser.bus.umich.edu/schriber/512-513FAQ.html |
