Back To Busn 216 Class Content Home Page

Excel Class Content

Excel Chapter 01:

Handouts (Reading) To Download:
Office2010ExcelIntroProject01VideoProject18.docx
Office2010ExcelIntroProject02VideoProject19.docx

Start Files (Use For Video Projects) To Download:
    Example of Finished Files As Seen In Video:
        Gradebook(IntroProject01).xlsx
        NetIncomeProjections(IntroProject2).xlsm
Extra file for (1+%) example:
WorkbookExcelMagicTricks597-603StartFile&FinishedFile (Trick #603)

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

Videos To Watch:
 Office 2010 Class #18: Excel Intro Project 01: Data, Formatting, Formulas, Page Setup
Office 2010 Class #19: Excel Intro Project 02: Formulas, Charts, Page Setup Net Income
Extra file for (1+%) example:
Excel Magic Trick 603: Why 100*1.1 = 110 Means Increase by 10%

 

 

Excel Is Fun Book:

Handouts (Reading) To Download:
        Book: Free Excel2010IsFun!.pdf book by Michael Girvin (large file - 140 page pdf file - download and then print out)

Handouts that go with Videos: Office2010ExcelVideoProject20-40.docx

 

Start Files (Use For Video Projects) To Download:
Excel2010IsFun!START.xlsm (This is the one you use while doing the video projects)
Excel2010IsFun!FINISHED.xlsm  (This is the finished workbook file - exactly like was dome in the video)

Files for Computer Lab 29-308 (download only if in-class class and you are downloading under guidance of Michael Girvin):
Excel2010IsFun!START.xlsx
Excel2010IsFun!FINISHED.xlsx

Videos To Watch:
 Office 2010 Class #20 What Is Excel?, Editing Ribbons & Quick Access Toolbar, File Extensions  (20 mins)
Office 2010 Class #21: Excel Formulas & Functions: Formula Inputs Numbers or Cell References?  (32 mins)
Office 2010 Class #22: Excel Formulas: Math Operators and Order Of Operations  (9 mins)
Office 2010 Class #23: Excel Functions & Defined Names, SUM, COUNT, COUNTA, SUMIF, COUNTIF  (23 mins)
Office 2010 Class #24: Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria)  (18 mins)
Office 2010 Class #25: Excel Cell References: Relative, Absolute, Mixed  (35 mins)
Office 2010 Class #26: Excel Assumption Tables (Formula Inputs) & Cell Ranges in Functions (22 mins)
Office 2010 Class #27: Excel Stylistic Formatting & Page Setup For Reports  (16 mins)
Office 2010 Class #28: Excel Number Formatting: Formatting As Façade  (23 mins)
Office 2010 Class #29: Excel ROUND Function How And When To Use It.  (13 mins)
Office 2010 Class #30: Excel Date Formulas: Days Invoice Past Due, Loan Maturity Date, Project Days  (4 mins)
Office 2010 Class #31: Excel Time Number Format & Payroll Time Sheet Calculations  (9 mins)
Office 2010 Class #32: Excel Percentage Number Format (6 Examples)  (7 mins)
Office 2010 Class #33: Excel Charts: Column, Bar, Pie, Line, X-Y Scatter, Sparklines Formatting  (34 mins)
Office 2010 Class #34: How Data Must Be Setup To Use Excel Data Analysis Features  (6 mins)
Office 2010 Class #35: Excel Sort and Filter (Data Analysis)  (19 mins)
Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)  (24 mins)
Office 2010 Class #37: Excel Table Feature For Dynamic Ranges in Functions, Charts, PivotTables  (6 mins)
Office 2010 Class #38: Excel IF Function Formula Made Easy (7 examples)  (12 mins)
Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)  (15 mins)
Office 2010 Class #40: Excel SUM Function Keyboard Shortcut for 5000 Rows of Data  (3 mins)

Excel Chapter 02 & 03:

All work is in Textbook - see schedule.

 

 

 

 

 

 

 

In Class File Only (for 11/14/2012): YourName-PivotTableAndIFandVLOOKUP.xlsx