Excel Video Tips
|   Home    |    Excel    |    Access   |   Word   |   Outlook   |  VBA   |   Downloads   |   Index   |
Excel Video Tips...

 

Excel Spreadsheet Techniques #1

This is the first part of a two-part tutorial illustrating a range of techniques useful for creating all kinds of spreadsheets in Excel. Starting with basic data entry and formatting this part goes on to build a simple interactive financial model. It includes formulas that use percentages. It uses the Autofill tool to simplify the entry of text and calculations, and illustrates the significance of absolute references in formulas. Finally, a drop-down list is added to create a simple interactive tool.

This video has an audio commentary and is best viewed at 720p (HD) quality. If you don't have an audio facility you can also view this video as a step-by-step viewlet with text annotations.

 

^ top