Back To Busn 210 Home Page

Files To Download for Chapter 00:

Excel file: Busn210Excel2010Chapter00ExcelBasics.xlsm

If Excel file downloads as ".zip", watch this video: Download Excel File Shows Up As Zip?

PDF file: Busn210Excel2010ChartsAndWhenToUseThem.pdf <<== Right-click and point to "Save Target As"

Videos To Watch:

Excel 2010 Statistics 01: Introduction To Excel 2010 For Statistics (19 mins)

Excel 2010 Statistics 02: Excel 2010 Data Analysis Add-in (2 mins)

Excel 2010 Statistics 03: Calculations, Formulas, Functions, Math & Comparative Operators (30 minutes)

Excel 2010 Statistics 04: Number Formatting As Façade Accounting Percentage Proportion Probability (15 mins)

Excel 2010 Statistics 05: Data Sets How They Are Setup & Terminology In Statistics & Data Analysis (5 minutes)

Excel 2010 Statistics 06: Data Analysis: Sorting and PivotTables (24 mins)

Excel 2010 Statistics 07: Charts Basics: Pie, Column, Bar, Line and X-Y Scatter  (32 mins)

If you are using Excel 2013, watch this extra video that shows how to make charts in Excel 2013:
Office 2013 Class 43, Excel Basics 25, Excel 2013 Charts: Chart Types, Chart Formatting, more  (43:38 mins)
Here is workbook to download and follow along: Video43-Excel2013Basics25-Charts.xlsm

Excel 2010 Statistics 08: Cell References In Formulas: Relative and Absolute (12 mins)

Excel 2010 Statistics 09: Proportions, Probabilities and Percentages: Formulas and Formatting (11 mins)