Here is an excellent set of 84 Excel
articles, tutorials, and tips
covering Excel 2007 New Features, Links and Hyperlinks,
Drawing Objects in Excel,
and General Excel Topics. These tips and tutorials are
provided by these well developed Excel tutorial sites: MrExcel, Chip
Pearson, and John
Walkenbach, hosting a total of over 500
Excel Tutorials.
These Excel
Tutorials and Tips are listed below in these categories:
- Excel 2007 Features – What’s New in Excel 2007
- Links and Hyperlinks in Excel – Information on working with Links and Hyperlinks in Excel
- Drawing Objects in Excel – How to use Drawing Objects in Excel
- General Excel Topics – From Games to Shortcuts in Excel. Covers Basic to Advanced topics
Excel 2007 New Features
Links and Hyperlinks in Excel
- Creating a linked picture of a range
- Locate phantom links in a workbook
- Removing external links
- Unlink a chart series from its data range
General Excel Topics
- 5 Tips to Eliminate Redundant Data
- Absolute Reference Uses
- Add graphics to your page header
- Add subtotals automatically
- Automatic Subtotals
- Autocorrect shortcuts
- Autoformat Reports
- Car Loan Payments in Excel with =PMT() function.
- Calculating with Feet and Inches
- Collaborate on an Excel worksheet by opening it in Google Spreadsheets
- Conditional Formatting to Higlight Items Due Today
- Copy Range formulas
- Creating Dice in Excel
- Cursor in unprotected cells only
- Degrees, Minutes and Seconds
- Discover New Excel sites with Del.icio.us
- Entering data in Excel - preselect the range
- Excel 12 Preview
- Excel Wiki
- Fill Handle trick – Ctrl+Drag to extend 1 to 1, 2, 3
- Floating Points
- Formatting External Data for Excel
- Freeze Panes So You Can Always See Row 1
- Function? What’s that?
- Games in Excel
- Gradebook in Excel
- Greenbar Formatting – 3 Methods
- Have a picture pop-up when you hover over a cell
- Highlight Current Row and Column: From the MrExcel Message Board ‘Hall of Fame’
- Highlight Maintenance Due Dates that Are Due Today.
- History of Spreadsheets
- Identify Cells with Formulas
- Inserting an image into a worksheet footer
- Inventor of VisiCalc – Dan Bricklin
- Keep page numbers consistent by printing the entire workbook at once.
- Keep Score with Excel
- Keyboard Shortcuts
- Limitations of Excel
- Locate Duplicates with Conditional Formatting
- Macro? What’s that?
- MrExcel “Challenge of the Month’ Winners
- No Automatic hyperlinks
- Not Enough Memory message
- Pop-Up Pictures Attached to a Cell
- Print page numbers at the bottom of each page
- Print titles at the top of each page
- Print titles starting on page 2
- Proofread with Text-To-Speech
- Quick Answers for Basic Questions
- Rational Databases in Excel
- Shift Rows up & down Quickly
- Shortcuts - Excel Keyboard Shortcuts
- Shortcut key to repeat last command
- Solve Sudoku with Excel
- Sort data with one click
- Sort in a Custom Sequence
- Sort Randomly
- Spreadsheet Programs
- Spreadsheets on the internet
- Subscribe to the MrExcel Video Podcast using iTunes
- Sudoku Solver using Excel
- Symbols - Special Characters in Excel
- Text-To-Speech Feature to Read Cells to You
- Track Progress Towards a Goal
- Track softball stats with Excel
- Track Your Collection in Excel
- UDF -Calculated Range in a Standard Function: From the MrExcel Message Board ‘Hall of Fame’
- Updating old information
- Use a Data Form for Data Entry
- Use AutoFilter to See Matching Records
- Validation to help people fill out your spreadsheets correctly
- Versions of Excel
- VLOOKUP Example
- What if I don’t like fishing?
- What is RSS, XML, and FeedReader?
- Working with fractional values in Excel
- Excel Training Sources
Popularity: 2% [?]
Related Posts:
Tags for this post>> Excel