• New Excel Interface & Features
• Getting Started with Excel 2007
• Intro. to Formulas and Functions
• Intermediate Formulas/Functions
• Printing - Formatting - Saving
• Sorting, Filtering, & Tables
• Data Consolidation & Retrieval
• Security in Excel 2007

INTERNET EXPLORER TRIES TO OPEN THESE FILES AS ZIP FILES. DOWNLOAD AND UNZIP THE FILES IF USING IE OR USE OTHER BROWSERS SUCH AS FIREFOX.

Lookup-&-Search-9---Vlookup-to-Return-Prices-with-Quantity-Discounts-for-Orders-in-Excel.xlsx
Lookup-&-Search-8---Vlookup---Vlookup-with-Lookup-Values-that-Have-Extra-Values-Data-in-the-Cell-in-Excel.xlsx
personal_loan_calculation.xls
Consolidate-and-Link-Between-Multiple-Workbooks---Parts-List---1.xlsx
Consolidate-Duplicates-From-Worksheet.xlsx
Excel-Formatting-7---Angle-Cells-Diagonally-in-Excel.xlsx
Consolidate-and-Link-Between-Multiple-Workbooks---Parts-List---2.xlsx
Consolidate-Multiple-Entries-From-Multiple-Worksheets-in-Same-Workbook.xlsx
Data-Analysis-1---Transpose-Data-in-Excel---Columns-to-Rows.xlsx
Excel-Formatting-1---Conditional-Formatting---Data-Bars,-Color-Scales,-&-Icon-Sets.xlsx
Excel-Formatting-2---Highlight-Unique-or-Duplicate-Values-with-Conditional-Formatting.xlsx
Excel-Tips--10---Change-Default-Spreadsheet-Settings-on-Open.xlsx
Excel-Formatting-3---Prevent-Buttons-in-Excel-from-Changing-Shape-with-Cells.xlsx
Excel-Formatting-4---Add-Color-to-Tabs-in-Excel-and-Raname-Tabs-in-Excel.xlsx
Excel-Formatting-5---Remove-Gridlines,-Column-Headings,-and-the-Formula-Bar-from-Excel-2007.xlsx
Excel-Formatting-6---Highlight-Cells-Greater-Than-a-Certain-Value-in-Excel---Conditional-Formatting.xlsx
Excel-Formatting-8---Remove-Tabs-and-Scroll-Bars-from-Excel-2007.xlsx
Excel-Formatting-9---Freeze-Panes---Prevent-Headers-from-Moving-with-Cells-in-the-Spreadsheet-in-Excel.xlsx
Excel-Tips--15---Add-Comments-to-Cells-and-View-All-Comments-in-a-Worksheet-in-Excel.xlsx
Excel-Tips--16---Add-Pictures-to-Comments-in-Excel.xlsx
Excel-Tips--12---Add-Background-Picture-to-Excel.xlsx
Excel-Tips--13---Put-Text-into-Excel.xlsx
Import-CSV-File-with-Excel.xlsx
Excel-Tips--19---Hide-and-Unhide-Worksheets-in-Excel.xlsx
Excel-Tips--14---Use-Links-and-Buttons-to-Navigate-Excel-Workbooks.xlsx
Excel-Tips--11---Paste-Values---Turn-Formulas-into-The-Visible-Values.xlsx
Excel-Tips--18---Sort-Data-Alphabetically-and-Numerically-in-Excel.xlsx
Excel-Tips--17---Add-Headers-to-Pages-in-Excel.xlsx
Excel-Tips--2---Use-Autocorrect-to-change-what-someone-types..xlsx
Excel-Tips--6---Resize-Columns-and-Rows-Quickly.xlsx
Excel-Tips--8---Quickly-Fill-100000-Cells-with-Numbers.xlsx
Excel-Tips--20---Display-in-Cell-Messages-in-Excel---Data-Validation.xlsx
Excel-Tips--21---Automatically-Display-the-Current-Date-in-Excel.xlsx
Excel-Tips--22---Keyboard-Shortcuts-for-Excel-2007---The-Easy-Way-to-Learn-Them.xlsx
Excel-Tips--4---How-to-completely-hide-the-Ribbon-in-Excel-2007---Automatically-when-Excel-is-opened.xlsm
Excel-Tips--23---Change-Column-Headings-from-Letters-to-Numbers-in-Excel.xlsx
Lookup-&-Search-1---Index-&-Match.xlsx
Excel-Tips--24---Add-Buttons-to-the-Quick-Access-Toolbar.xlsx
Excel-Tips--25---Change-Direction-of-Active-Cell-after-Pressing-Enter.xlsx
Excel-Tips--26---Quickly-Search-for-Complicated-Functions-in-Excel.xlsx
Excel-Tips--28---Display-Current-Time-in-Excel-Down-to-the-Second.xlsx
Excel-Tips--27---Quickly-Locate-All-Formulas-Functions-in-an-Excel-Worksheet-or-Workbook.xlsx
Excel-Tips--3---How-to-completely-hide-the-Ribbon-in-Excel-2007.xlsm
Excel-Tips--7---Turn-Off-Automatic-Updating-of-Formulas.xlsx
Excel-Tips--9---Change-Color-Scheme-of-Excel.xlsx
Finance-in-Excel-1---Import-Stock-Quotes---Existing-Data-Connection---MSN-Quotes.xlsx
Finance-in-Excel-2---Import-and-Chart-Historical-Stock-Prices-in-Excel-with-Yahoo-Finance.xlsx
Finance-in-Excel-3---Import-Live-Stock-Quotes-into-Excel-and-Determine-Your-Portfolio-Value.xlsx
VBA---Check-if-Cell-is-Empty.xlsm
Finance-in-Excel-4---Calculate-Straight-Line-Depreciation-in-Excel.xlsx
Finance-in-Excel-5---Calculate-Declining-Balance-Method-of-Depreciation-in-Excel.xlsx
Excel-Tips-1---Advanced-tab---Display-options-for-this-workbook.xlsx
Finance-in-Excel-6---Calculate-Double-Declining-Balance-Method-of-Depreciation-in-Excel.xlsx
Functions-Formulas-in-Excel-1---Round-Numbers-in-Excel-with-the-Round-Function.xlsx
VBA---Clear-Cell-Contents-with-a-Macro.xlsm
Finance-in-Excel-7---Calculate-Depreciation-Using-the-Variable-Declining-Balance-Method-in-Excel.xlsx
Finance-in-Excel-8---Quickly-Import-Income-Statement,-Balance-Sheet,-&-Statement-of-Cash-Flows-into-Excel.xlsx
Functions-Formulas-in-Excel-5---Combine-Text-and-Formulas-in-a-Cell.xlsx
Functions-Formulas-in-Excel-6---Use-Round-with-Rand-to-return-Random-Numbers-with-Only-2-Decimal-Places.xlsx
VBA---Declaring-and-Using-Variables-in-Excel-Macros.xlsm
Functions-Formulas-in-Excel-7---Learn-the-IF-Statement-in-Excel.xlsx
Functions-Formulas-in-Excel-8---Find-The-Most-Common-Value-in-a-List-in-Excel.xlsx
Lookup-&-Search-2---Vlookup-Explanation-1---Vlookup-Intro-Example---Find-Product-Suppliers.xlsx
Lookup-&-Search-3---Vlookup-Explanation-2---Search-Employee-Database.xlsx
Lookup-&-Search-4---Vlookup-Explanation-3---Assign-grades-to-Students.xlsx
VBA---Cell-Formatting,-Fonts,-and-Colors-in-VBA.xlsm
Lookup-&-Search-6---Vlookup---Vlookup-with-a-Data-Validation-Drop-Down-Menu.xlsx
Lookup-&-Search-5---Vlookup---Use-IFERROR-with-Vlookup-to-Assign-Default-Values-When-Nothing-is-Found.xlsx
Lookup-&-Search-7---Vlookup---Vlookup-on-Data-that-has-a-Prefix-before-it.xlsx
VBA-14---Cells-Property-with-Variables-for-Cell-References.xlsm
VBA---Find-Cells-in-Excel---Find-Method.xlsm
VBA---Get-Value-from-Spreadsheet.xlsm
VBA---Ranges-in-VBA.xlsm
VBA---Hide-Unhide-Columns-and-Rows.xlsm
VBA---If-Then-Statement-Introduction.xlsm
VBA---Input-Formulas-and-Arrays-into-Cells.xlsm
VBA---Input-Value-into-Cell.xlsm
VBA---Loop-Through-Cells---For-Next-Loop.xlsm
VBA---Write-Your-First-Macro.xlsm
VBA-13---Cells-Property-Introduction.xlsm
VBA-15---Range-with-Cells-Property-for-Arguments.xlsm
VBA-16---Using-Offset-with-Range-in-VBA.xlsm
CSV-Sample---Sales-Demo.csv
VBA-17---Find-Last-Row-and-Last-Column-with-VBA.xlsm
VBA-18---Easily-Make-R1C1-References-in-Large-Formulas.xlsm
VBA-19---Speed-up-Macros---Turn-Screen-Updating-Off.xlsm
VBA-20---Rename-Modules-in-Excel-for-Macros.xlsm
VBA-21---Call-Macros-from-Other-Macros-in-Excel.xlsm
VBA-22---Open-Workbooks-with-Excel-Macros.xlsm
VBA-23---Put-a-Time-Delay-in-Macros---Pause-a-Macro-for-a-Given-Amount-of-Time---Excel.xlsm
VBA-Ranges-in-VBA.xlsm
VBA-24---Learn-The-For-Next-Loop-in-Excel-Macros.xlsm
VBA-25---Make-User-Input-Boxes-for-Excel-Macros---Set-User-Input-to-Variables-in-Macros.xlsm
1---Import-Stock-Quotes---Existing-Data-Connection---MSN-Quotes.xlsx
VBA-Write-Your-First-Macro.xlsm
Consolidate-and-Link-Between-Multiple-Workbooks---Parts-List---Consolidated.xlsx
Functions-Formulas-in-Excel-2---Round-Numbers-to-the-Nearest-Integer-in-Excel-with-the-INT-Function.xlsx