132 More Excel Tutorials and Tips

Here is a rich group of 132 Excel tutorials and tips covering the Excel Environment, Excel’s Menus, Other Applications and Excel, Reference Resources for Excel. These free training Excel pages are offered by MrExcel, Chip Pearson, and John Walkenbach, which, as a whole, provide over 500 Excel Articles and Tutorials.

These Excel Tutorials and Tips are shown here in the following categories:

• The Excel Environment – Information on Excel’s inherent environ and the integration of other processes
• Menus - Working with Excel’s Menus – Covers anything found in Excel menus, Plus tips on customizing your own menus
• Other Applications and Excel – Integrate other applications with, or enhance Excel workbooks
• Reference Resources for Excel – Other online references, tutorials and tips on working with Excel

• Add buttons to a toolbar
• Analysis Tool Pack
• API-What is it?
• Application Procedures
• Basic Excel Tips to make life easier
• Close all workbooks quickly
• Colored Worksheet tabs – Excel 2002
• Dates - Before 1900
• Deleting Code-VBE
• Differences in Excel versions
• Event Procedures
• Excel Help text size
• Helpful Keyboard shortcuts common to Excel
• Increase Columns and/or Rows
• Issues with Data Validation and Freeze Pane
• Keep Excel in focus
• Keyboard Shortcuts
• MapInfo Pro Tables with Excel Data Map (Pre-Office XP)
• Message in Status bar
• Move the cell pointer right after hitting enter
• Navigating Excel Worksheets
• Print the Excel Help File
• Quickly Navigate to Any worksheet
• Serial Dates
• Show full menus all the time
• Solve common set up issues in Excel
• Sort Using a Formula – Build a Report to Recognize the Top 5 Sales Reps
• Switching between active worksheets
• Turn off Gridlines
• VBA Modules
• VBE-Using the Visual Basic Editor
• Very Hidden worksheet
• Web Query to Refresh Internet Data into Excel
• Web Query to harvest info from 4000+ web pages
• KwMap.net - browse the Keyword Map of MrExcel.com

• Add a Certain Number to All Numbers in a Range Using Paste Special Add
• Add a percentage to all cells in a range
• Change cell values using Paste Special
• Change the default number of worksheets
• Change the format of subtotal rows
• Close All Workbooks
• Color - with Conditional Formatting
• Conditional Formatting
• Conditional Formatting
• Conditional Formatting for Due Dates
• Conditional Formatting to compare lists
• Conditional Formatting to shade rows
• Conditional Formatting: Considering the ’4th’ option
• Consolidation to summarize data
• Converting non-numbers to actual values
• Copy page set up settings to other sheets
• Copying Subtotaled Data
• Count Auto Filtered rows
• Creating Custom Menus in Excel
• Customizing Menu Items
• Data Validation
• Data Validation to check for repeated values
• Delete values, but keep the formulas
• Display Fractions with Format Menu
• Dropdowns using Data Validation
• Duplicate repeated entries
• Edit-GoTo to copy visible cells
• Eliminating the ‘Enable Macros’ messagebox in Excel
• Excel Function Help
• Filter with Ease using DigDB Add-in
• Format to Create Batting Averages
• Format to display in thousands
• Freeze pane for select rows and columns
• Freeze the Headers so they are always visible as the cell pointer scrolls deeper into the worksheet
• Getting Rid of Broken Links
• Getting Rid of Broken Links
• Graphing - Changing Default Settings
• How to easily ‘unmerge’ cells
• How to filter out duplicate data
• Identify formulas using Conditional Formatting
• Import a text file to a worksheet
• Incorrect decimal place fixes
• Keeping Excel from changing data to dates
• Linking comboboxes with Data Validation
• Locking cells to protect critical data
• Make the Header Row stay visible as you scroll through data
• Merging rows
• Moving Subtotaled Data
• Multiple lines of Text
• No Text Import Wizard
• Non-printing rows
• Pasted Text is Inexplicably automatically parsed
• Paste-Special Uses
• Perform math operations without formulas
• Prevent Duplicate Values with Data Validation
• Protection - cells, sheets, workbooks and files
• Recently used filelist – increase the number of files available in the list
• Removing hyperlinks from a worsheet
• Setting a print area
• Special Characters
• Split the contents of one column into two columns
• Splitting the contents of a cell/column into two distinct cells/columns
• Stop Duplicate Entry
• Subtotals to summarize data
• Subtotal without grouping
• Tabbing through specific cells
• Time - Negative values
• Use a number format to make zeroes not appear
• Use Edit / Replace to Remove Decimal Points
• Workspace File? What is it and how can I use it?

• Changing the default cell comment formatting
• Convert PDF to Excel
• Convert PDF to Excel as shown on TechTV
• Discover New Excel sites with Del.icio.us
• Excel Wiki
• Get a list of file names
• Google Spreadsheets
• Import data from the web
• Import your AOL File Cabinet to Outlook
• Importing CSV files from Other Applications
• Mail Merge Excel Data to Word Labels
• Map your Excel data with MapPoint
•  MapPoint and Excel – Many Great Articles at MP2K Magazine
• MrExcel’s Recommendations: Access help
• MrExcel’s Recommendations: Word help
• Post to MrExcel.com Message Board
• OneNote Overview
• Push Excel data to OneNote SP1
• Resize Excel’s sheet tabs
• Search MrExcel.com Message board for Keywords
• Updating Distribution Lists
• Watch a dozen websites in minutes using a FeedReader 

Reference Resources for Excel

• Colors in Excel – Anything you every wanted to know
• Excel 2000 – Tutorials c/o James Madison Univ.
• Excel Function Dictionary – website by Peter Noneley (150 + functions in Excel)
• Excel Reference by Category – website by Pierre Leclerc M.Sc.
• Excel Resources – website by Mark Henri (Technical Support Specialist for Microsoft
• Excel Tips and Tricks – website by Aaron Blood

Popularity: 2% [?]