### FREE BASIC/LEVEL 1 EXCEL TRAINING INDEX

Excel Lesson 1: **The Fundamentals of Excel **

Excel Lesson 2: **How to Start Excel, Creating and Saving Workbooks **

Excel Lesson 3: **Toolbars and Task Panes in Excel **

Excel Lesson 4: **Insert/Delete/Name/Move Worksheets **

Excel Lesson 5: **Cells, Moving Around Workbooks, Exiting **

Excel Lesson 6: **Basic Copy/Cut & Paste **

Excel Lesson 7: **Quick Copying Using the Fill Handle **

Excel Lesson 8: **Pasting Using Paste Special **

Excel Lesson 9: **Inserting Rows, Columns and Cells **

Excel Lesson 10: **Changing the Standard Default Options in Excel **

Excel Lesson 11: **Using the Undo and Redo Feature **

Excel Lesson 12: **Using the Format Painter to Copy a Cells Format **

Excel Lesson 13: **Using Dates and Times in Excel **

Excel Lesson 14: **Working with Custom Formats in Excel **

Excel Lesson 15: **The Basics of Excel Formulas **

Excel Lesson 16: **Excel Cell References. Relative and Absolute Cell References **

Excel Lesson 17: **Avoid Typing Whenever Possible. Use Your Mouse Pointer **

Excel Lesson 18: **Excel Arguments and Syntax in Formulas **

Excel Lesson 19: **Excel AutoSum Function/Formula **

Excel Lesson 20: **Excel Auto Calculate. Calculate Without Formulas **

Excel Lesson 21: **How to Use the Insert Function Feature to Create Formulas **

Excel Lesson 22: **Using Some of Excel's most Common Functions **

Excel Lesson 23: **Using Named Ranges in Excel as an Alternative to Cell References **

Excel Lesson 24: **Using Constants to Name Values and the Paste Name Dialog **

Excel Lesson 25: **Excel Calculations/How Excel Calculates/The Order of Calculations **

Excel Lesson 26:**Excel Cell Comments **

Excel Lesson 27:**Excel Find & Replace **

Excel Lesson 28:**Different Methods of Clearing Cell Contents **

Excel Lesson 29:**Effective Printing in Excel 1**

Excel Lesson 30:**Effective Printing in Excel 2**

Excel Lesson 31:**Sorting Data in Excel **

Excel Lesson 32:**Hide/Show Rows/Columns in Excel **

Excel Lesson 33:**Excel AutoFormats **

Excel Lesson 34:**Creating a Basic Spreadsheet **

Excel Lesson 35:**Charting the Basic Spreadsheet **

Excel Lesson 36:**Excel Worksheet Protection **

Excel Lesson 37:**Excel IF Formula/Function **

Excel Lesson 38:**Volatile Functions-Now & Today **

Got any Excel Questions? **Free Excel Help **

**Some of our more popular products are below...**

**Convert** Excel** Spreadsheets To Webpages** | **Trading** In Excel | Construction **Estimators** | **Finance** Templates & Add-ins **Bundle **| Code-**VBA**** **| Smart-**VBA** | **Print**-VBA | Excel **Data Manipulation & Analysis** | **Convert** MS Office Applications To...... | **Analyzer** Excel | **Downloader** Excel | **MSSQL Migration** Toolkit | ** Monte Carlo** Add-in | Excel ** Costing Templates**