Skip to Main Content
Data Science
General Resources from the Web
Analytics Vidhya is an well maintained blog with many contributors in the areas of Business Analytics, Business Intelligence, Big Data and Infographics. See their Simple Yet Powerful Excel Tricks for Analyzing Data for useful Excel for analytics advice.
Keep track of Excel enhanvements for BA by following their Blog. The entries What’s new for business analytics in Excel 2016 and Take control of data with Excel’s business analytics tools are good places to start.
Search for formulas or solutions to common problems at the Excel support site.
At then Udemy blog, Steve Quartrani does an great job covering basic formulas with his entry Excel Formulas: 10 Formulas That Helped Me Keep My Job.
Helpful TItles from Our Catalog
Statistics for People Who (Think They) Hate Statistics by Call Number: HA29 .S2365 2010Publication Date: 2009-04-02Statistics for People Who (Think They) Hate Statistics presents an often intimidating and difficult subject in a way that is clear, informative, and personable. Researchers and students will appreciate the book's unhurried pace and thorough, friendly presentation. Includes common formulas and how to install the Excel Data Analysis Tools option to access a host of useful analytical techniques. The book walks readers through various statistical procedures, beginning with simple descriptive statistics, correlations, and graphical representations of data, and ending with inferential techniques, analysis of variance, and a new introductory chapter on working with large datasets and data mining using Excel.
Data Analysis Using SQL and Excel by ISBN: 9780470228227Publication Date: 2007-10-23Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like.
