Index

B

• built-in functions
  • using / Using built-in functions

C

• cells
  • capitalizing / Capitalization
• charting options
  • about / Charting options
  • chart elements / Chart elements
  • chart styles / Chart styles
  • chart filters / Chart filters
• column charts / Adding multiple slicers
• columns
  • comparing / Comparing columns
• conditional statements
  • about / If/else/then statements

D

• dashboard
  • final tweaks / Final tweaks
• data
  • creating manually / Manually creating data
  • importing, from sources / Importing data from various sources
  • importing, from text file / Importing data from a text file
  • importing, from CSV file / Importing a CSV file
  • importing, from Web / Importing data from the Web
  • combining from multiple columns to one column / Combine data from multiple columns into one column
  • gathering / Gathering data, Gathering data
  • preparing, for analysis / Preparing the data for analysis
  • preparing / Preparing data
  • analyzing / Analyzing data
• data analysis
  • about / Analyzing our data
  • applications, processing / Question – how many applications were processed in the year 2014?
• data analysis life cycle
  • about / Getting started with data
  • data, gathering / Gathering data
  • data, preparing / Preparing data
  • data, analyzing / Analyzing data
  • data, presenting / Presenting data
• database
  • about / Reading a table from MSSQL – the Microsoft SQL Server database
• data models
  • about / Data models
• domain knowledge
  • about / Preparing the data for analysis
• duplicate data
  • about / Duplicates
  • removing / Duplicates
  • identifying / Duplicates

E

• Excel files
  • importing / Importing other Excel files
• Excel macro
  • about / What is a macro?
• Excel Solver
  • about / Activating the Excel Solver
  • activating / Activating the Excel Solver
  • using / Using the Excel Solver
• extra spaces, in between strings
  • about / Leading/trailing/in-between spaces

F

• formulas
  • creating / How to create formulas

H

• Hello World VBA script
  • about / Your very first "Hello World" VBA script
  • variables, declaring / Declaring variables
  • conditional statements / Conditional statements
  • loops / Loops
  • macros, creating without code / Creating macros without any code
  • macro powered spreadsheets, saving / Saving macro-powered spreadsheets

L

• leading spaces
  • about / Leading/trailing/in-between spaces
• linear programming
  • about / Modeling our linear programming problem
• linear programming problem
  • modeling / Modeling our linear programming problem

M

• Microsoft SQL Server database
  • about / Reading a table from MSSQL – the Microsoft SQL Server database
• MPG (miles per gallon) / What are slicers?
• MSSQL
  • Fast forms / Reading a table from MSSQL – the Microsoft SQL Server database
  • table, reading from / Reading a table from MSSQL – the Microsoft SQL Server database
  • users / Reading a table from MSSQL – the Microsoft SQL Server database
  • multiple tables, reading from / Reading multiple tables from MSSQL
  • reading from, SQL used / Reading from MSSQL using SQL

Q

• quick analysis charts
  • about / Quick analysis charts
• Quick Analysis feature / Quick analysis charts
• Quick Layout option
  • about / Additional design options

S

• shortcut keys / Shortcuts
• similar words
  • fixing / Fixing similar words
• slicers
  • about / What are slicers?
  • creating / How to create slicers
  • styling / Styling slicers
  • multiple slicers, adding / Adding multiple slicers
  • filters, clearing / Clearing filters
• strings
  • and numbers, combining / Combining strings and numbers

T

• text to columns
  • about / Text to Columns
• text to dates
  • about / Text to dates
• text to numbers
  • about / Text to numbers
• tips and tricks / Tips and tricks
• trailing spaces
  • about / Leading/trailing/in-between spaces

V

• VBA Editor
  • opening / Opening the VBA Editor
  • about / Opening the VBA Editor
• VLOOKUP function
  • about / Preparing data