Search TeachExcel.com
Video Tutorials
Free Macros
Excel Help Directory
Excel 2007 Resources
Keyboard Shortcuts
Excel Forum
Contact/About
Free Excel Spreadsheets for the Excel Video Tutorials
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.
CSV-Sample---Sales-Demo.csv
1---Import-Stock-Quotes---Existing-Data-Connection---MSN-Quotes.xlsx
Consolidate-and-Link-Between-Multiple-Workbooks---Parts-List---1.xlsx
Consolidate-Duplicates-From-Worksheet.xlsx
Consolidate-and-Link-Between-Multiple-Workbooks---Parts-List---Consolidated.xlsx
Consolidate-Multiple-Entries-From-Multiple-Worksheets-in-Same-Workbook.xlsx
Excel-Tips--16---Add-Pictures-to-Comments-in-Excel.xlsx
Consolidate-and-Link-Between-Multiple-Workbooks---Parts-List---2.xlsx
Data-Analysis-1---Transpose-Data-in-Excel---Columns-to-Rows.xlsx
Excel-Formatting-5---Remove-Gridlines,-Column-Headings,-and-the-Formula-Bar-from-Excel-2007.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--13---Put-Text-into-Excel.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-6---Highlight-Cells-Greater-Than-a-Certain-Value-in-Excel---Conditional-Formatting.xlsx
Excel-Formatting-7---Angle-Cells-Diagonally-in-Excel.xlsx
Excel-Tips--17---Add-Headers-to-Pages-in-Excel.xlsx
Excel-Tips--20---Display-in-Cell-Messages-in-Excel---Data-Validation.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--10---Change-Default-Spreadsheet-Settings-on-Open.xlsx
Excel-Tips--11---Paste-Values---Turn-Formulas-into-The-Visible-Values.xlsx
Excel-Tips--12---Add-Background-Picture-to-Excel.xlsx
Excel-Tips--14---Use-Links-and-Buttons-to-Navigate-Excel-Workbooks.xlsx
Excel-Tips--15---Add-Comments-to-Cells-and-View-All-Comments-in-a-Worksheet-in-Excel.xlsx
Excel-Tips--18---Sort-Data-Alphabetically-and-Numerically-in-Excel.xlsx
Excel-Tips--19---Hide-and-Unhide-Worksheets-in-Excel.xlsx
Excel-Tips--2---Use-Autocorrect-to-change-what-someone-types..xlsx
Excel-Tips--21---Automatically-Display-the-Current-Date-in-Excel.xlsx
Excel-Tips--27---Quickly-Locate-All-Formulas-Functions-in-an-Excel-Worksheet-or-Workbook.xlsx
Excel-Tips--22---Keyboard-Shortcuts-for-Excel-2007---The-Easy-Way-to-Learn-Them.xlsx
Excel-Tips--23---Change-Column-Headings-from-Letters-to-Numbers-in-Excel.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
Functions-Formulas-in-Excel-1---Round-Numbers-in-Excel-with-the-Round-Function.xlsx
Excel-Tips--28---Display-Current-Time-in-Excel-Down-to-the-Second.xlsx
Excel-Tips--3---How-to-completely-hide-the-Ribbon-in-Excel-2007.xlsm
Excel-Tips--6---Resize-Columns-and-Rows-Quickly.xlsx
Excel-Tips--4---How-to-completely-hide-the-Ribbon-in-Excel-2007---Automatically-when-Excel-is-opened.xlsm
Excel-Tips--7---Turn-Off-Automatic-Updating-of-Formulas.xlsx
Excel-Tips--8---Quickly-Fill-100000-Cells-with-Numbers.xlsx
VBA-Ranges-in-VBA.xlsm
Excel-Tips--9---Change-Color-Scheme-of-Excel.xlsx
Excel-Tips-1---Advanced-tab---Display-options-for-this-workbook.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-4---Calculate-Straight-Line-Depreciation-in-Excel.xlsx
Functions-Formulas-in-Excel-8---Find-The-Most-Common-Value-in-a-List-in-Excel.xlsx
Finance-in-Excel-3---Import-Live-Stock-Quotes-into-Excel-and-Determine-Your-Portfolio-Value.xlsx
Finance-in-Excel-5---Calculate-Declining-Balance-Method-of-Depreciation-in-Excel.xlsx
Finance-in-Excel-6---Calculate-Double-Declining-Balance-Method-of-Depreciation-in-Excel.xlsx
Import-CSV-File-with-Excel.xlsx
Lookup-&-Search-1---Index-&-Match.xlsx
Lookup-&-Search-5---Vlookup---Use-IFERROR-with-Vlookup-to-Assign-Default-Values-When-Nothing-is-Found.xlsx
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-2---Round-Numbers-to-the-Nearest-Integer-in-Excel-with-the-INT-Function.xlsx
Functions-Formulas-in-Excel-5---Combine-Text-and-Formulas-in-a-Cell.xlsx
Functions-Formulas-in-Excel-7---Learn-the-IF-Statement-in-Excel.xlsx
Functions-Formulas-in-Excel-6---Use-Round-with-Rand-to-return-Random-Numbers-with-Only-2-Decimal-Places.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
Lookup-&-Search-8---Vlookup---Vlookup-with-Lookup-Values-that-Have-Extra-Values-Data-in-the-Cell-in-Excel.xlsx
Lookup-&-Search-6---Vlookup---Vlookup-with-a-Data-Validation-Drop-Down-Menu.xlsx
Lookup-&-Search-7---Vlookup---Vlookup-on-Data-that-has-a-Prefix-before-it.xlsx
Lookup-&-Search-9---Vlookup-to-Return-Prices-with-Quantity-Discounts-for-Orders-in-Excel.xlsx
VBA---Cell-Formatting,-Fonts,-and-Colors-in-VBA.xlsm
VBA---Check-if-Cell-is-Empty.xlsm
VBA---Clear-Cell-Contents-with-a-Macro.xlsm
VBA---Declaring-and-Using-Variables-in-Excel-Macros.xlsm
VBA---Find-Cells-in-Excel---Find-Method.xlsm
VBA---Get-Value-from-Spreadsheet.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---Ranges-in-VBA.xlsm
VBA---Write-Your-First-Macro.xlsm
VBA-14---Cells-Property-with-Variables-for-Cell-References.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
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-24---Learn-The-For-Next-Loop-in-Excel-Macros.xlsm
VBA-23---Put-a-Time-Delay-in-Macros---Pause-a-Macro-for-a-Given-Amount-of-Time---Excel.xlsm
VBA-Write-Your-First-Macro.xlsm
personal_loan_calculation.xls
VBA-25---Make-User-Input-Boxes-for-Excel-Macros---Set-User-Input-to-Variables-in-Macros.xlsm