TeachExcel.com
Video Tutorials, Macros, Shortcuts, and More...
TE
Home Online Excel Classes Downloadable Tutorials & Guides Consulting Services Excel Help Now Contact Us
Excel Tips Excel Blog Excel Video Tutorials Excel Macros Forum
Video Tutorials
  • Free Macros
  • Excel 2007 Resources
  • Keyboard Shortcuts
  • Forum
  • Contact/About
  • 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
Tutorials
Category View   List All Tutorials
Tutorial Rating Legend
          
    Easy Assumes no previous knowledge; good for beginners.
    Easy Trickier than other easy tutorials but still good for the beginner.
    Intermediate Difficult but no specific prior knowledge is needed to follow along.
    Intermediate Assumes some prior knowledge of excel and basic formulas.
    Intermediate These tutorials involve complicated topics which require a lot of knowledge of excel or which utilize basic functions in an inconventional or complicated way.
    Advanced These will be the toughest tutorials. They are usually the most involved in terms of building a model in excel or using complex formulas which can be very confusing.
Excel Macro VBA Tip 1 - How to Write Your Very First Macro in Microsoft Excel  (Easy)
- This is a great introduction to macros and vba and Microsoft Excel macros. You
Excel Macro VBA Tip 2 - Using The Range Property to Select Cells in Excel  (Intermediate)
- This Excel Macro VBA tutorial shows you how to select a range of cells in Excel
Excel Macro VBA Tip 3 - Using The Range Property in Excel Macros to Select Columns and Rows  (Intermediate)
- This Excel VBA Macro tutorial includes a description of how to selection entire
Excel Macro VBA Tip 4 - Find Cells in Excel with Macros using the Find Method  (Intermediate)
- This tutorial shows you how to find a cell with a certain value anywhere through
Excel Macro VBA Tip 5 - Learn How to Input Values, Text, Numbers, and Formulas into Cells in Excel  (Intermediate)
- This tutorial shows you how to input values, text, numbers, and formulas into ce
Excel Macro VBA Tip 6 - IF Then Statement in Excel Macros and VBA  (Intermediate)
- Learn how to create and use an IF Then Statement in Microsoft Excel Macros and V
Excel Macro VBA Tip 7 - Check if a Cell in Excel is Empty Using Macros in Excel  (Intermediate)
- Learn how to check if a cell in Excel is empty using Macros in Excel. This tuto
Excel Macro VBA Tip 8 - Hide UnHide Rows and Columns in Excel with a Macro  (Intermediate)
- Learn to hide and unhide columns and rows in Microsoft Excel using a macro. Thi
Excel Macro VBA Tip 9 - Enter Formulas in Excel with a Macro  (Intermediate)
- Learn to enter formulas and values into Microsoft Excel with a macro. This tuto
Excel Macro VBA Tip 10 - Enter Array Formulas into Cells in Excel with a Macro  (Intermediate)
- Learn to input array formulas into cells using a macro in Excel. This is import
Excel Lookup & Search Tip 8 - Vlookup with Lookup Values that Have Extra Values in the Cell in Excel  (Intermediate)
- This Excel Video Tutorial shows you how to use the VLOOKUP() function with looku
Excel Lookup & Search Tip 9 - Vlookup to Return Prices with Quantity Discounts for Orders in Excel  (Intermediate)
- This Excel Video Tutorial will show you how to use the VLOOKUP() function in Exc
Excel Lookup/Search Tip 3 - Vlookup Explanation 2 - Vlookup to Search an Employee Database  (Intermediate)
- Learn how to use the VLOOKUP() function in Microsoft Excel in the second walk-th
Excel Lookup/Search Tip 4 - Vlookup Explanation 3 - Vlookup to Assign Grades to Students  (Intermediate)
- Traditional VLOOKUP() function example in Excel. This tutorial teaches you how
Excel Lookup/Search Tip 5 - Vlookup - IFERROR with Vlookup to Assign Values Instead of Errors  (Easy)
- Use the new IFERROR() function in Excel 2007 in conjunction with the VLOOKUP() f
Excel Lookup/Search Tip 6 - Vlookup with a Drop Down Menu and Data Validation  (Intermediate)
- Learn how to use the VLOOKUP function in Excel in conjunction with a data valida
Excel Lookup/Search Tip 7 - Vlookup on Data that has a Prefix before it  (Intermediate)
- Learn how to use the VLOOKUP function in Excel to search a database or table arr
Excel Lookup/Search Tip 1 - Using Index and Match - It's Better than Vlookup  (Intermediate)
- Learn how to use the Index and Match lookup functions in Microsoft Excel. They
Excel Lookup/Search Tip 2 - Vlookup Explanation 1 - Display Product Suppliers from a List/Database  (Easy)
- Learn how to use the VLOOKUP() function in Microsoft Excel. This tutorial will
View Live Stock Quotes in Microsoft Excel - MSN MoneyCentral Investor Stock Quotes  (Easy)
- Learn how to view Live Stock Quotes in Microsoft Excel. This tutorial shows you
Combine/Merge Cells in Microsoft Excel - Make Better Headers  (Easy)
- This Microsoft Excel video tutorial shows you how to merge a cell in Excel. Thi
Count Cells That Only Contain Text in Microsoft Excel  (Easy)
- This Excel video tutorial shows you how to write a formula which will count the
Create Dynamic Named Ranges in Excel which go Left-Right Across Columns  (Intermediate)
- This Excel video tutorial shows you how to make a named range within Excel dynam
Create Dynamic Named Ranges in Excel Across Rows Going Up/Down  (Intermediate)
- This is a great tutorial which shows you how to make a named range within Excel
Change Columns from Letters to Numbers in Excel 2007  (Easy)
- This free excel video tutorial shows you how to change the columns in excel 2007
Make Dynamic (Automatically Updating) References in Formulas and Functions in Excel  (Intermediate)
- This excel vidoe tutorial shows you how to make a truly dynamic range reference
Insert Macros into an Excel Workbook or File and Delete Macros from Excel  (Intermediate)
- This video tutorial shows you how to insert a macro you may find on the internet
Assign a Macro to a Button, Check box, or any object in Microsoft Excel  (Intermediate)
- This video tutorial shows you how to attach or assign a macro in excel to a butt
Generate Random Numbers with Decimals in Microsoft Excel  (Intermediate)
- This tutorial shows you how to generate random numbers which have decimals in ex
Dynamically Updated Vlookup Table in Microsoft Excel  (Intermediate)
- This Microsoft Excel tutorial shows you how to make a dynamically updating vlook
Prevent Duplicate Values being entered in a List in Excel - Allow only unique values to be entered.  (Intermediate)
- This Microsoft Excel video tutorial shows you how to make a list in excel where
Generate Random Numbers (Integers) in Microsoft Excel  (Easy)
- This Excel video tutorial shows you how to generate random numbers (integers) in
Create a Drop Down Menu with Data Validation in Microsoft Excel  (Easy)
- The Excel video tutorial shows you how to create a drop-down list/menu in excel.
Quickly Copy/Paste Data, Formulas, Text in Excel Using the Quick Fill Handle  (Easy)
- This Excel video tutorial shows you how to quickly copy and paste data and formu
Allow only values contained in a list to be entered into a cell - Data Validation  (Intermediate)
- This Excel video tutorial shows you how to use Data Validation to prevent a user
Extract Text from cells in Excel - How to get any word from a cell in Excel  (Intermediate)
- This Excel video tutorial shows you how to extract text from cells. Specificall
Dynamically Update a Drop Down Menu/List  (Intermediate)
- This Excel video tutorial shows you how to create a dynamically updating drop-do
Create a Two-Way Lookup in Excel  (Intermediate)
- This video tutorial will show you how to make a two-way lookup in excel. This tu
Extract Text from Cells - Intermediate Example  (Intermediate)
- This is a video tutorial that will show you how to use the FIND() LEN() LEFT() a
Remove #N/A Error Result from Empty VLOOKUP() Formulas  (Intermediate)
- This video tutorial will show you how to remove the #N/A error that results in a
Lookups With MATCH() and INDEX() Functions  (Intermediate)
- This video tutorial will show you how to use the MATCH() and INDEX() functions w
Introduction to Making Formulas in Excel  (Easy)
- Here, you will learn what formulas are and how they can benefit you in excel. Th
IF Statement Introduction & Using Nested IF's  (Easy)
- How to use a basic IF statement. If you've never used one before, this will show
HLOOKUP() Function - Introduction  (Intermediate)
- This is a video tutorial that shows you how to use the HLOOKUP() function in exc
Function and Formulas Lookup in Excel  (Easy)
- This video tutorial will show you how to use the insert function feature in exce
AND(), OR(), and IF() Statements/Formulas  (Intermediate)
- How to use AND() and OR() functions within and IF statement and also what the AN
Absolute and Relative Cell References
   - & INDIRECT() Function Introduction  (Easy)
- This is a video tutorial for Microsoft Excel which shows you how to make absolut
Link Cells Between Worksheets  (Easy)
- Here, you will see how to link cells between worksheets in excel. This will allo
Consolidate & Combine Data from Separate Worksheets or Workbooks(Excel Files)  (Intermediate)
- This video tutorial will show you how to combine data from separate worksheets,
How to record a Macro - And what One is  (Easy)
- This is an introduction to what Macros are and how they can make your life easie
Assign a Macro to a Button and Toolbar  (Intermediate)
- How to assign a recorded macro to a button and a toolbar at the top of excel. Al
Assign Keyboard Shortcuts to Macros  (Easy)
- How to assign a keyboard shortcut to a macro after is has been recorded. Good if
Formatting Worksheets for Printing in Excel  (Easy)
- This Excel video tutorial shows you how you can adjust how a worksheet will look
Printing Multiple Worksheets and Workbooks  (Easy)
- You will learn how to print multiple worksheets at one time, part of one workshe
How to 'Protect' a Worksheet and Workbook  (Easy)
- You can make it so that no one, or only a certain person or group of people, can
Password Protect Excel Workbook Files  (Easy)
- You can password protect your excel files and make it so that only one person or
Locking & Unlocking Cells to Protect Data in Excel  (Easy)
- This excel tutorial shows you how to lock and ulock cells in excel. This is a f
Hide Rows & Columns in Excel  (Easy)
- Here, you will learn how to protect data in your worksheets by hiding it. You ca
Group and Ungroup Cells in Excel  (Easy)
- This is a video tutorial for Microsoft Excel which will show you how to group an
Concatenate Data in Excel  (Easy)
- Here, you learn how to concatenate data in excel. This shows you how to take dat
Splitting Data from One Column into Multiple Columns  (Intermediate)
- How to break-up data from one column and transfer it to multiple columns in exce
Adjusting Multiple Rows & Columns Simultaneously  (Easy)
- Here, you will learn how to adjust and resize multiple columns and rows at one t
Goal Seek Feature in Excel  (Intermediate)
- The goal seek tool in Microsoft Excel allows you to use excel to figure out what
Net Present Value / Discounted Cash Flow Calculations  (Intermediate)
- This video tutorial for excel shows you how to compute the net present value and
FV() Find the Future Value of Cash Today
         -Savings/Retirement Plan Calculations  (Intermediate)
- This excel video tutorial shows you how to get the future value of a savings or
Bond Pricing Calculations for Simple Bonds
         - Future Value, Present Value, Interest Rate, etc.  (Intermediate)
- This video tutorial shows you how to value and price simple bonds through excel.
Using the Chart Wizard - How to Make Charts/Graphs  (Easy)
- Here, you will learn how to use the Chart Wizard within Microsoft Excel in order
How to Make a Histogram Chart in Excel  (Intermediate)
- This video tutorial shows you how to make a histogram chart in Microsoft Excel.
Graph Hidden Data in Excel  (Easy)
- Video tutorial explaining how to graph hidden data in excel. This teaches you ho
Format the X & Y Axes  (Easy)
- This tutorial will show you how to change the appearance and also order of the x
Format Graph/Chart Plot Area  (Easy)
- Here, you will learn everything you can do to format the Plot Area within your c
Format Data Series Points and Data Points in Excel  (Easy)
- Here, you will learn how to format data series points and data series which are
Formatting the Chart Area in Excel  (Easy)
- Here, you will learn everything that you can do to edit and change the appearanc
Introduction to Arrays  (Easy)
- Here, you will learn what a basic array is and what it can do. This includes an
Add Y-Error Bars to a Graph or Chart in Excel  (Easy)
- How to add Y-Error Bars to a chart or graph in excel. This allows you to show w
Add Trendlines to a Graph or Chart in Excel  (Easy)
- This Excel video tutorial shows you how to add a trendline to a graph or chart i
Make a Thermometer Style Chart in Excel  (Intermediate)
- This is a video tutorial which will show you how to make and modify a chart/grap
Random Tutorials
Format Graph/Chart Plot Area
(Easy)
Format Data Series Points and Data Points in Excel
(Easy)
Formatting the Chart Area in Excel
(Easy)
Net Present Value / Discounted Cash Flow Calculations
(Intermediate)
FV() Find the Future Value of Cash Today
         -Savings/Retirement Plan Calculations
(Intermediate)
Bond Pricing Calculations for Simple Bonds
         - Future Value, Present Value, Interest Rate, etc.
(Intermediate)
Contact | Privacy Policy | Disclaimer
Copyright© 2009 TeachExcel.com