TeachExcel.com
Video Tutorials, Macros, Shortcuts, and More...
TE
TeachExcel HD Video Tutorials for Microsoft Office Consulting Services Excel Help Now Contact Us
Excel Tips Excel Video Tutorials HD Video Tutorials for Excel Free Excel Macros
Video Tutorials
  • Free Macros
  • Excel 2007 Resources
  • Keyboard Shortcuts
  • 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.

Charts & Graphs in Excel  -  Definition
    Any data, numbers, or set of ranges within excel can be graphed and charted. There are many different types of graphs and charts available as well as many different ways to format and present them.
    New:    Create a Dynamic Gantt Chart  (Intermediate)
    New:    Formatting Chart Area  (Easy)
    New:    Formatting Data Series and Data Points  (Easy)
    New:    Formatting Plot Area  (Easy)
    New:    Formatting X & Y Axes  (Easy)
    New:    Intro to Chart Making  (Easy)
Financial Functions & Models  -  Definition
    There are many financial functions in excel which allow you to create many complex financial models and analysis. In this section, you will learn how to use many financial functions within excel as well as how to build some financial models with those functinos.
    New:    ########  (Intermediate)
Formatting in Excel  -  Definition
    You can format cells, rows, columns, graphs, text, numbers, etc. to the point that you can change almost any visual aspect of the excel spreadsheet.
    New:    Splitting Data from One Column into Multiple Columns  (Intermediate)
    New:    Formatting Text Cells as Upper, Lower, or Proper Case Using Formulas  (Easy)
    New:    Adjust Multiple Rows or Columns Simultaneously  (Easy)
    New:    How to use Conditional Formatting  (Easy/Intermediate)
Formulas and Functions in Excel  -  Definition
    Formulas in excel allow you to calculate averages, sums, standard deviations, loan payment amounts, interest rates, etc. As well, they allow you to manipulate the data in spreadsheets and to create complex financial statements and models.
    New:    Your First Formula - Introduction to Formulas  (Easy)
Data Analysis in Excel  -  Definition
    Excel allows you to perform data analysis including: statistical analysis, regressions, goal seek, solver, etc. These functions allow you to analyze complex decisions in order to determine the best course of action.
    New:    Goal Seek  (Easy/Intermediate)
Import, Export, & Link Data  -  Definition       
    You can bring many different types of data into excel from many different locations including: Microsoft Word and Access and also web pages. You can also export data from excel into many formats including an XML format.
    New:    How to link cells from different excel workbooks and files.  (Easy/Intermediate)
    New:    Importing Data from Websites  (Easy)
Lists & Forms  -  Definition
    This section is as of yet empty. Consideration is being given to postponing the addition of this section to a later date. Sorry for the inconvenience.
Lookup & Search Functions in Excel - NEW SECTION

Macros  -  Definition
    Macros allow you to perform a large number of operations or actions very quickly and with little effort. We show you how to make them and how to use them as well as offering free macros for you to use.
    New:    Recording a Macro - Intro to Macros  (Easy)
    New:    Assign Keyboard Shortcuts to Macros  (Easy)
    New:    Assign Toolbar Buttons to Macros  (Easy)
    New:    How to edit Macros - Dynamic Cell Refences  (Intermediate)
Printing in Excel  -  Definition
    Here you will learn everything there is to know about printing in excel. You can print considerable amounts of data on one page; print multiple worksheets at once; or even print multiple workbooks at once as well as much more.
    New:    Formatting for Printing  (Easy/Intermediate)
    New:    Printing Multiple Worksheets & Workbooks etc.  (Easy)
Security in Excel  -  Definition
    Whether trying to prevent sensitive information from getting into the wrong hands, preventing someone from messing up your worksheet, or just 'idiot-proofing' your worksheets, you will learn all of this here.
    New:    Password Protection and Removing Personal Information  (Easy)
    New:    Hide Rows, Columns, & Tabs  (Easy)
Tips & Tricks  -  Definition
    Saving time, workarounds for excel's limitations, or just cool things you can do in excel are just some of the topics presented here.
Random Tutorials
Lookups With MATCH() and INDEX() Functions
(Intermediate)
Function and Formulas Lookup in Excel
(Easy)
Absolute and Relative Cell References
   - & INDIRECT() Function Introduction
(Easy)
Consolidate & Combine Data from Separate Worksheets or Workbooks(Excel Files)
(Intermediate)
How to record a Macro - And what One is
(Easy)
Assign a Macro to a Button and Toolbar
(Intermediate)
Contact | Privacy Policy | Disclaimer
Copyright© 2009 TeachExcel.com