Computers in Business: K201

Kelley School of Business Faculty (Autor)

Buch | Softcover

426 Seiten

2016 | Second Edition
Indiana University Press (Verlag)
978-0-253-02653-8 (ISBN)

Titel erscheint in neuer Auflage

Artikel merken

Faculty at Indiana University's world-renowned Kelley School of Business present this essential introductory guide to the role of computers and other information technologies in business. Highlights include instruction and applied practice in two of the most widely used commercial software packages: Microsoft Access and Microsoft Excel. Students learn, via hands-on examples, many of the powerful tools contained in these two platforms, with emphasis on how to analyze real business problems to help make important decisions.

Kelley School of Business Faculty

Chapter 1 K201 Introduction

Microsoft Access
Chapter 2 Access Introduction
Chapter 3 Importing Data, Keys, and Relationships
Chapter 4 Data Types and Basic Field Settings
Chapter 5 Data Entry, Lookup Fields, and Field Properties
Chapter 6 Basic Select Query Design, Criteria, and Total Row
Chapter 7 Concatenation, Calculated Fields, and Aggregate Functions
Chapter 8 Parameter Query and Query on Queries
Chapter 9 Query Wizard, and Action Queries
Chapter 10 The IIF Function and Intro to Forms
Chapter 11 Mulitple Page and Navigation Forms

Microsoft Excel
Chapter 12 The Power of Excel
Chapter 13 Cell Referencing and Named Ranges
Chapter 14 Conditional Aggregate and Date Functions
Chapter 15 Financial Analysis
Chapter 16 Logical Functions
Chapter 17 Compound Nested IFs
Chapter 18 Data Retrieval: VLOOKUP, HLOOKUP, MATCH
Chapter 19 Data Retrieval: INDEX and MATCH
Chapter 20 Spreadsheet Models and Data Tables
Chapter 21 Data Validation
Chapter 22 Working with Text Data
Chapter 23 Tables and Charts
Chapter 24 PivotTable and Power View Reports

Appendix
Box at IU
Query Guide
Reports in Access
Automating Tasks with Macros

Erscheinungsdatum	17.08.2016
Verlagsort	Bloomington, IN
Sprache	englisch
Maße	216 x 279 mm
Gewicht	953 g
Themenwelt	Sachbuch/Ratgeber ► Beruf / Finanzen / Recht / Wirtschaft
	Mathematik / Informatik ► Informatik ► Datenbanken
	Sozialwissenschaften ► Pädagogik ► Berufspädagogik
	Wirtschaft ► Betriebswirtschaft / Management ► Allgemeines / Lexika
	Wirtschaft ► Betriebswirtschaft / Management ► Personalwesen
ISBN-10	0-253-02653-9 / 0253026539
ISBN-13	978-0-253-02653-8 / 9780253026538
Zustand	Neuware