TY  - BOOK
AU  - Rojas,David
TI  - Data analysis and business modeling with Excel 2013: manage, analyze, and visualize data with Microsoft Excel 2013 to transform raw data into ready to use information 
T2  - Professional expertise distilled
SN  - 1785284037
AV  - HF5548.4.M523 
U1  - 005.369 23
PY  - 2015///
CY  - Birmingham
PB  - Packt Publishing
KW  - Microsoft Excel (Computer file)
KW  - fast
KW  - Electronic spreadsheets
KW  - Computer programs
KW  - COMPUTERS
KW  - Desktop Applications
KW  - Spreadsheets
KW  - bisacsh
KW  - Electronic books
N1  - 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; 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; 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; 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
UR  - https://libproxy.firstcity.edu.my:8443/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1087751
ER  -