IS2000 | Principles of Information Science
  • Home
  • Schedule
  • Labs
    • Lab - SQL, SQLite
    • Lab - R
    • Lab - Decision Analysis
  • Assignments
    • Assignment 1
    • Assignment 2
    • Assignment 3
    • Assignment 4
    • Assignment 5
    • Portfolios & Blogs
  • Policies
    • Attendance
    • Collaboration
    • Exam Rules
    • Assessments
    • Grading
    • Academic Integrity
  • Resources
    • Lecture Notes >
      • Information Science as a Discipline
      • Information Architecture
      • Information Theory
      • Information Collection
      • Essential Excel
      • Essential R
      • Information Modeling
      • Information Representation in XML
      • Information Retrieval with XPath
      • Information Transformation with XSL
      • Information Storage in RDB
      • Information Retrieval with SQL
      • Information Processing in R
      • Information-Based Decision
      • Information Management & Policy
      • Information Security & Privacy
      • Information Transmission
      • Information Systems
      • Predictive Analytics
      • Process Analytics
      • Information Visualization
    • Text Books
    • Tools
    • Additional Readings
    • Archive
  • Help
    • Blog
    • Class Diary
    • Office Hours
    • Instructor

Essential Excel


Tutorials | Discussions

Information and data scientists often rely on Excel for essential data collection, manipulation, modeling, and analysis of data to derive information for decision makers. This unit provides an introduction to essential skills in Excel programming.

Objectives
Upon completion of this lesson, you will be able to
  • build models in Excel
  • use various counting, conditional, lookup, and rounding functions
  • format worksheets
Required Readings
  • Spreadsheet Fundamentals
  • Advanced Spreadsheet Techniques
  • Creating a Pareto Chart in Excel
Picture

Learning

Blackboard
Lynda.com

Support

Contact Instructor
FAQ
Terms of Use
© COPYRIGHT 2016-19 by Martin Schedlbauer
​FREE FOR ACADEMIC USE WITH ACKNOWLEDGEMENT AND NOTICE. 
ALL RIGHTS RESERVED.