FirstCity
Welcome to First City University College Library iPortal | library@firstcity.edu.my | +603-7735 2088 (Ext. 519)

Data analysis and business modeling with Excel 2013 : (Record no. 47161)

MARC details
000 -LEADER
fixed length control field 05334cam a2200709Ia 4500
001 - CONTROL NUMBER
control field ocn927159923
003 - CONTROL NUMBER IDENTIFIER
control field OCoLC
005 - DATE AND TIME OF LATEST TRANSACTION
control field 20200827105009.0
006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS
fixed length control field m o d
007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION
fixed length control field cr |n|||||||||
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 151030s2015 enk o 000 0 eng d
040 ## - CATALOGING SOURCE
Original cataloging agency IDEBK
Language of cataloging eng
Description conventions pn
Transcribing agency IDEBK
Modifying agency YDXCP
-- TEFOD
-- EBLCP
-- COO
-- OCLCO
-- OCLCA
-- OCLCF
-- OCLCQ
-- DEBBG
-- OCLCQ
-- FEM
-- IDB
-- N$T
-- UMI
-- DEBSZ
-- OCLCQ
-- MERUC
-- OCLCQ
-- VT2
-- OCLCO
-- CEF
-- NLE
-- NTG
-- AGLDB
-- UKMGB
-- OCLCQ
-- OCLCO
-- STF
-- UAB
-- G3B
-- UKAHL
-- RDF
-- OCLCQ
-- K6U
016 7# - NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER
Record control number 018010480
Source Uk
019 ## -
-- 928432055
-- 934650463
-- 968011051
-- 969076009
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 1785284037
Qualifying information (electronic bk.)
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 9781785284038
Qualifying information (electronic bk.)
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
Canceled/invalid ISBN 9781785289545
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
Canceled/invalid ISBN 1785289543
029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC)
OCLC library identifier AU@
System control number 000062335023
029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC)
OCLC library identifier DEBBG
System control number BV043627499
029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC)
OCLC library identifier DEBBG
System control number BV043967935
029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC)
OCLC library identifier DEBSZ
System control number 48578422X
029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC)
OCLC library identifier GBVCP
System control number 882745719
029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC)
OCLC library identifier UKMGB
System control number 018010480
035 ## - SYSTEM CONTROL NUMBER
System control number (OCoLC)927159923
Canceled/invalid control number (OCoLC)928432055
-- (OCoLC)934650463
-- (OCoLC)968011051
-- (OCoLC)969076009
037 ## - SOURCE OF ACQUISITION
Stock number 845914
Source of stock number/acquisition MIL
037 ## - SOURCE OF ACQUISITION
Stock number 017E8CDA-903E-4E28-83F8-E48FB8954CA9
Source of stock number/acquisition OverDrive, Inc.
Note http://www.overdrive.com
050 #4 - LIBRARY OF CONGRESS CALL NUMBER
Classification number HF5548.4.M523
072 #7 - SUBJECT CATEGORY CODE
Subject category code COM
Subject category code subdivision 054000
Source bisacsh
082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER
Classification number 005.369
Edition number 23
049 ## - LOCAL HOLDINGS (OCLC)
Holding library MAIN
100 1# - MAIN ENTRY--PERSONAL NAME
Personal name Rojas, David,
Relator term author.
245 10 - TITLE STATEMENT
Title Data analysis and business modeling with Excel 2013 :
Remainder of title manage, analyze, and visualize data with Microsoft Excel 2013 to transform raw data into ready to use information /
Statement of responsibility, etc. David Rojas.
260 ## - PUBLICATION, DISTRIBUTION, ETC.
Place of publication, distribution, etc. Birmingham :
Name of publisher, distributor, etc. Packt Publishing,
Date of publication, distribution, etc. 2015.
300 ## - PHYSICAL DESCRIPTION
Extent 1 online resource
336 ## - CONTENT TYPE
Content type term text
Content type code txt
Source rdacontent
337 ## - MEDIA TYPE
Media type term computer
Media type code c
Source rdamedia
338 ## - CARRIER TYPE
Carrier type term online resource
Carrier type code cr
Source rdacarrier
347 ## - DIGITAL FILE CHARACTERISTICS
File type text file
Source rda
490 1# - SERIES STATEMENT
Series statement Professional expertise distilled
588 0# - SOURCE OF DESCRIPTION NOTE
Source of description note Online resource, title from PDF title page (EBSCO, viewed April 23, 2017).
505 0# - FORMATTED CONTENTS NOTE
Formatted contents note Cover ; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Data into Excel ; Getting started with data; Gathering data; Preparing data; Analyzing data; Presenting data; Manually creating data; Importing data from various sources; Importing data from a text file; Importing a CSV file; Importing other Excel files; Importing data from the Web; Summary; Chapter 2: Connecting to Databases ; Reading a table from MSSQL -- the Microsoft SQL Server database; Reading multiple tables from MSSQL; Reading from MSSQL using SQL; Summary
505 8# - FORMATTED CONTENTS NOTE
Formatted contents note Chapter 3: How to Clean Texts, Numbers, and Dates Leading/trailing/in between spaces; Capitalization; Duplicates; Text to Columns; Combine data from multiple columns into one column ; Fixing similar words; Text to dates; Text to numbers; Summary; Chapter 4: Using Formulas to Prepare Your Data for Analysis ; How to create formulas; Combining strings and numbers; Using built-in functions; If/else/then statements; Comparing columns; Summary; Chapter 5: Analyzing Your Data Using Descriptive Statistics and Charts ; Gathering data; Preparing the data for analysis; Analyzing our data
505 8# - FORMATTED CONTENTS NOTE
Formatted contents note Question -- how many applications were processed in the year 2014?Summary; Chapter 6: Link Your Data Using Data Models ; Gathering data; Preparing data; Analyzing data; Data models; Summary; Chapter 7: A Primer on Using the Excel Solver ; Activating the Excel Solver; Modeling our linear programming problem; Using the Excel Solver; Summary; Chapter 8: Learning VBA -- Excel's Scripting Language ; What is VBA?; What is a macro?; Opening the VBA Editor; Your very first ""Hello World"" VBA script; Declaring variables; Conditional statements; Loops; Creating macros without any code
505 8# - FORMATTED CONTENTS NOTE
Formatted contents note Saving macro-powered spreadsheets Summary; Chapter 9: How to Build and Style Your Charts ; Quick analysis charts; Charting options; Chart elements; Chart styles; Chart filters; Additional design options ; Summary; Chapter 10: Creating Interactive Spreadsheets Using Tables and Slicers ; What are slicers?; How to create slicers; Styling slicers; Adding multiple slicers; Clearing filters; Final tweaks; Summary; Appendix: Tips, Tricks, and Shortcuts ; Shortcuts; Tips and tricks; Index
590 ## - LOCAL NOTE (RLIN)
Local note eBooks on EBSCOhost
Provenance (VM) [OBSOLETE] EBSCO eBook Subscription Academic Collection - Worldwide
630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE
Uniform title Microsoft Excel (Computer file)
Authority record control number or standard number http://id.loc.gov/authorities/names/n86025775
630 07 - SUBJECT ADDED ENTRY--UNIFORM TITLE
Uniform title Microsoft Excel (Computer file)
Source of heading or term fast
Authority record control number or standard number (OCoLC)fst01366659
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Electronic spreadsheets
General subdivision Computer programs.
Authority record control number or standard number http://id.loc.gov/authorities/subjects/sh86007613
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element COMPUTERS
General subdivision Desktop Applications
-- Spreadsheets.
Source of heading or term bisacsh
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Electronic spreadsheets
General subdivision Computer programs.
Source of heading or term fast
Authority record control number or standard number (OCoLC)fst00907465
655 #0 - INDEX TERM--GENRE/FORM
Genre/form data or focus term Electronic books.
655 #4 - INDEX TERM--GENRE/FORM
Genre/form data or focus term Electronic books.
830 #0 - SERIES ADDED ENTRY--UNIFORM TITLE
Uniform title Professional expertise distilled.
856 40 - ELECTRONIC LOCATION AND ACCESS
Uniform Resource Identifier <a href="https://libproxy.firstcity.edu.my:8443/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1087751">https://libproxy.firstcity.edu.my:8443/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1087751</a>
938 ## -
-- Askews and Holts Library Services
-- ASKH
-- AH29479752
938 ## -
-- EBL - Ebook Library
-- EBLB
-- EBL4191156
938 ## -
-- EBSCOhost
-- EBSC
-- 1087751
938 ## -
-- ProQuest MyiLibrary Digital eBook Collection
-- IDEB
-- cis32993931
938 ## -
-- YBP Library Services
-- YANK
-- 12675774
994 ## -
-- 92
-- MYFCU

No items available.