Each of these Excel tutorials is designed as two Modules. In the first tutorial Module, you’ll learn how to create a spreadsheet, enter data and work with formulas. In the second tutorial Module you’ll learn how to format, print, and create and print graphs from the spreadsheet. The individual areas, covered in each Module, are furnished below. All of the tutorials follow the same theme – creating a personal budget spreadsheet, so as you progress to newer versions of Excel, the same tutorial theme will help you feel more comfortable with learning the features and functions of Excel. Each succeeding tutorial is enhanced to incorporate new features in Excel and also covers added features requested by users.
Excel Features and Topics in Training Module 1:
- Getting Started with Excel (Menu bars, buttons, toolbars, moving around Excel)
- Creating Worksheets (Entering data, numbers and dates, Saving)
- Manipulating Worksheet Data (Copying, Cutting, Pasting data)
- Working with Basic Formulas and Functions (Formulas, Functions, Auto Calculate, Absolute referencing, and Wizards)
Excel Features and Topics in Training Module 2:
- Printing Worksheets
- Formatting Worksheets (Inserting, Deleting, Widths of rows and columns, Using number formats, Aligning data)
- Enhancing Worksheets (Changing Text Fonts, Borders, Shading, Gridlines)
- Using Styles and AutoFormats
- Finding and Replacing Data
- Creating Graphs
Microsoft Excel Tutorials:
www.7hillsmediagroup.com/officetutorials.com/exceltutorials.htm
Excel 97 Introductory Tutorial:
www.7hillsmediagroup.com/officetutorials.com/Excl97tu.doc
(312 KB – 28 Page Word Document)
Excel 97 Income Statement Tutorial:
www.7hillsmediagroup.com/officetutorials.com/Income%20Statement%20Tutorial.doc
(168 KB – 12 Page Word Document)
Excel 97 Balance Sheet Tutorial:
www.7hillsmediagroup.com/officetutorials.com/Balance%20Sheet%20Tutorial.doc
(172 KB – 13 Page Word Document)
Excel 2000 Introductory Tutorial:
www.7hillsmediagroup.com/officetutorials.com/Excel2000tu.doc
(395 KB – 32 Page Word Document)
Excel XP/2002 Introductory Tutorial:
www.7hillsmediagroup.com/officetutorials.com/Excel%20XP%20tut.doc
(517 KB – 34 Page Word Document)
Excel 2003 Introductory Tutorial:
www.7hillsmediagroup.com/officetutorials.com/Excel%202003%20tut.doc
(1.03 MB – 38 Page Word Document)
Spreadsheets Created by Tutorials
The individual spreadsheets, created by each tutorial, are furnished below if you would like to download them.
Excel 97 spreadsheet:
www.7hillsmediagroup.com/officetutorials.com/mybudget%2097.xls
(38 KB database file)
Excel 97 Income Statement spreadsheet:
www.7hillsmediagroup.com/officetutorials.com/Davis%20Shoe%20Income%20Statement.xls
(17 KB database file)
Excel 97 Balance Sheet spreadsheet:
www.7hillsmediagroup.com/officetutorials.com/Davis%20Shoe%20Balance%20Sheet.xls
(18 KB database file)
Excel 2000 spreadsheet:
www.7hillsmediagroup.com/officetutorials.com/mybudget%202000.xls
(17 KB database file)
Excel XP/2002 spreadsheet:
www.7hillsmediagroup.com/officetutorials.com/mybudget%20xp.xls
(19 KB database file)
Excel 2003 spreadsheet:
www.7hillsmediagroup.com/officetutorials.com/mybudget%202003.xls
(19 KB database file)
Popularity: 2% [?]
Related Posts:15 Microsoft Excel Lessons with ExercisesMicrosoft Excel Workshop Training HandoutsFree Microsoft Excel Video TrainingSofware Help Guides for Word, Excel, and PowerPointFree Microsoft Excel Ebook