Excel Tutorials and Tips

• Add-Ins for Excel - Information about available add-ins for Excel, where to get them and how to use them.
• Charts and Graphing in Excel - Information to assist in Charting and Graphing -from preparation to completion.
• Drawing Objects in Excel - How to use Drawing Objects in Excel.
• Excel 2007 Features - What's New in Excel 2007.
• Formulas in Excel -Information to assist in creating, using and understanding formulas in Excel.
• General Excel Topics - From Games to Shortcuts in Excel. Covers Basic to Advanced topics.
• Links and Hyperlinks in Excel - Information on working with Links and Hyperlinks in Excel.
• 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.
• Pivot Tables - Those two words say it all. Information that will take you from preparation to completion.
• Reference Resources for Excel - Other online references, tutorials and tips on working with Excel.
• VBA (Visual Basic for Applications) in Excel - How To-s and Macros (VBA Code) with instructions for use.
• The Excel Environment - Information on Excel's inherent environ and the integration of other processes.

Add-Ins for Excel

•  Add-Ins - Free, Third-Party Add-Ins
•  Add-Ins-Free, Third-Party Add-Ins
•  Analysis Tool Pack-Excel
•  Cool accessories for Excel
•  Drawing '98 for Excel '97
•  Empower Excel with the amazing DigDB Add-In
•  Games in Excel
•  The Spreadsheet Assistant for Excel
•  Use MathEasy Add-In to simplify entering math formulas
•  Using the Analysis ToolPack
•  Using the Small Business Financial Manager in Excel with Quickbooks Data

Back to top

Charts and Graphing in Excel

•  Add a Trendline with 3 clicks
•  Business Diagrams & Org Charts
•  Charting with Time on the X-axis
•  Charting Tips
•  Create a Chart with 1 Keystroke
•  Create a Time Line
•  Creating a thermometer style chart
•  Creating a transparent chart series
•  Creating combination charts
•  Demonstrate fractions with a pie chart
•  Drawing with Excel - grid paper
•  Expand the Chart Range
•  Extending with Data Points
•  Histogram - Create a Dual Sided Histogram in Excel
•  Gantt Chart with Conditional Formatting
•  Handle missing data in a line chart
•  In-cell Column Chart
•  Layouts for column charts
•  Multiple charts on a single Chart sheet
•  Non-graphic chart directly in a range
•  Saving a chart as a GIF file
•  SmartArt Graphics in Excel 2007
•  Create Sparklines - Tiny, Word-sized Charts in Excel with SparkMaker
•  Speedometer Charts in Excel
•  Students creating bar charts for survey data
•  Summarize Data using a Pivot Charts
•  Tips for the 'Perfect Chart'
•  Track Progress Towards a Goal
•  Track Student Reading Progress with a Dynamic Chart
•  Thermometer Charts

Back to top

Drawing Objects in Excel

•  Displaying a value in an AutoShape
•  Rotating text with an AutoShape

Back to top

Excel 2007 New Features

•  Document Themes in Office 2007
•  Duplicates - Remove Duplicates in Excel 2007
•  SmartArt Graphics in Excel 2007
•  Learn a New Excel 2007 Trick every Tuesday and Thursday with the MrExcel Podcast.

Back to top

Formulas in Excel

•  Absolute References
•  Adding every other cell in a column with =SUM(MOD…
•  Array to Columns
•  Array-CSE Further Uses
•  Array-CSE Uses
•  Array-CSE Entering using Conditional Sum Wizard
•  Arrays-CSE
•  Attendance Tracker using COUNTIF
•  AutoAverage - using the dropdown next to AutoSum to access other functions
•  Automatically add a character in a cell
•  Automatically get the date and time with =NOW() Function
•  Auto-Update Charts upon entering new data
•  Averaging Highest-Lowest
•  Averaging Range Values
•  Avoid error displays in formulas
•  Avoiding error displays in formulas
•  Calculating a conditional average
•  Calculating Age and Birthdays
•  Car Loan Payments in Excel with =PMT() function.
•  Calling a Function
•  Cell Value vs. Displayed Text
•  Change a Cell Value without Changing the Formula
•  Changing #N/A to "Your Response" text with =IF()
•  Changing 'All Caps' to proper text with =PROPER()
•  Changing Cell References
•  Changing grades (in numeric format) to Letter Grades with =VLOOKUP
•  Changing Numbers to Text
•  Color -Shading Cells
•  Compare ranges by using an array-CSE-formula
•  Concatenate values: (Bringing two cell Values together as one)
•  Concatenating a cell with text and a cell with a date
•  Concatenation
•  Conditional Formatting - Referencing another sheet
•  Conditional Sum Wizard
•  Convert 11.5 to 11 minutes and 30 seconds
•  Convert Text to Proper Case
•  Coordinates - Degrees, Minutes, Seconds
•  Count Between Two Values
•  Count Text or Numeric Entries with COUNTA instead of COUNT
•  CountIF in an Array-CSE
•  CountIf or Sumif with two conditions
•  Counting Cells with specific content with =COUNT
•  Counting distinct entries in a range
•  Creating a "Mega-formula"
•  Creating proper names format with =PROPER()
•  Custom Function: Parsing with characters
•  Dates in Excel from TechTV
•  DATEDIF to find the difference between dates
•  Dates -Adding and Subtracting
•  Dates -As Intervals
•  Dates - Calculating # of Days from Today
•  Dates -Creating a Series
•  Dates -DATEDIF Function
•  Dates -Day of the Week(Month)
•  Dates -Day of the Week(Year)
•  Dates -Determining Quarters
•  Dates -Difference Between
•  Dice in Excel using RANDBETWEEN
•  Dates -Distributing
•  Dates -Easter Calculation
•  Fill a Range with Weekdays
•  Dates -First and Last Day of the Month
•  Dates -First Monday
•  Dates -Julian
•  Dates -Leap Years
•  Dates -Number of days in a month
•  Dates -Thanksgiving Calculation
•  Dates -The day of the year and days remaining
•  Dates - Live formula to calculate Today
•  Dates -Two Digit Year
•  Dates -Week Numbers (ISO)
•  Duplicate Entry - Identify
•  Duplicate Tooltip over DDE Formula
•  Dynamic Range
•  Find and Replace
•  Find the elapsed time between two time entries
•  Find the longest entry in a range of text entries
•  Finding an average between two data sets
•  Finding Minimum and Maximum Values
•  Force a global recalculation
•  Formatting Time Values
•  Formula Auditing
•  Formula to add years to a given date
•  Fractions in Excel
•  Grades -Calculating and Converting
•  Have an IF statement return "Yes"-"No" with =IF
•  Hiding your formulas
•  High and Low Values - =MAX
•  Holidays -Calculating
•  How to calculate and display the largest value with =MAX
•  How to create a "Top 9"
•  How to Reverse the Sign on a Difference
•  INDEX(MATCH())
•  INDIRECT
•  Joining two Columns
•  Joining Text in two columns with the Concatenation Operator
•  Keeping a running total in an adjacent column with =SUM
•  Latitude and Longitude
•  Lists -Auto-Numbering
•  Lists -Common to Two Lists
•  Lists -Minimum and Maximum Values
•  Lists -Transpose (Reverse) Order
•  Lists -Unique to One of Two
•  Loan Payments in Excel with =PMT() function.
•  Lookup -Closest Match
•  Lookup -Multiple Criteria
•  Lookup -Return Value to Left
•  Magic Squares in Excel
•  Math Exercise Sheets in Excel using RANDBETWEEN
•  Matching Lists vith VLOOKUP
•  Merge Values to One (using Area Code and Phone Number)
•  Most or Least Common Value
•  Multiply Hours by Rate
•  Named Range
•  Naming a Worksheet as the value of a target cell with =INDIRECT Function
•  Nested Function
•  No Blank Cells
•  Ordinal Numbers
•  Parsing Dates with =MID Function
•  Parsing -Names
•  Parsing -Phone Numbers
•  Parsing phone numbers with =MID Function
•  Paste Special Values to prevent #REF! errors
•  Perform two-way table lookups
•  Pricing -Bracketing and Progressive
•  Proper Case - Changing a Name to Proper Case
•  PROPER() function to convert text to upper and lower case
•  Random Samples with RAND
•  Range -Convert to Columns
•  Range -Dynamic
•  Range -Named
•  Range -Transpose
•  Range -Used Cells
•  Range -Variable
•  Ranking Data
•  Ranking without repetitive ranks with =RANK and =COUNTIF
•  Referencing a sheet indirectly
•  Referencing Cells
•  Relative Cell References
•  Return End Of Month Date with =DATE
•  Return File Name
•  Return Nth Value
•  Returning specific data on examining a range
•  Returning Zero instead of #N/A with =IF()
•  Round time to the nearest quarter hour
•  Round values to the nearest fraction
•  Rounding Numbers with =CEILING
•  Rounding numbers with =ROUND
•  Rounding time to a specific value
•  Rounding to n significant digits
•  select Random numbers from a column with =RAND()
•  Show Formulas
•  Splitting the contents of a cell/column into two distinct cells/columns
•  Strings -Counting Characters
•  Strings -Counting Characters
•  Strings -Extracting Words from a String
•  Strings -Most or Least Common
•  Sum Every Nth Value
•  Sum only the visible cells
•  Sum the largest values in a range
•  SUMIF in an Array - CSE
•  SUMIF to conditionally sum data
•  SumIf with two conditions
•  Summing times that exceed 24 hours
•  Text and values in one cell
•  Text value response to input with =IF
•  Time -Adding and Subtracting
•  Time - Adding When Total is over 24 hours
•  Time -Between Two Dates
•  Time -Calculating Overtime
•  Time -Quick Entry Method
•  Time -Range last Updated(Not available after Excel '97)
•  Time -Rounding
•  Transforming Data With Formulas
•  Transpose a Range
•  Unique Entries -Counting
•  Unique Entries -Extracting
•  Unique Entries -Ranking
•  Use Index and Match to lookup a cell to the left of your key cell
•  VLOOKUP
•  Use absolute references when tracking student grades
•  Working with Dates with =DATE
•  Working with time formats with =TEXT
•  Worksheets -Referencing Previous and Next
•  Worksheets -Return Sheet Name
•  Write a Formula that always points to the same column, but is free to move to different rows as it is copied
•  Zero Values-Ignoring

Back to top

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
•  Duplicates - Remove Duplicates in Excel 2007
•  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
•  Looking for links removed from the home page?
•  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
•  Remove Duplicates in Excel 2007
•  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
•  Take a fun poll: when will you upgrade to Excel 2007?
•  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
•  Unique Values - Find Unique Values in Excel 2007
•  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

Back to top

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

Back to top

Menus - Working with Excel's Menus

•  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?

Back to top

Other Applications and Excel

•  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

Back to top

Pivot Tables

•  Access Data with Pivot Tables to Break Through Excel's 65,536 row limit
•  Add Median to Pivot Tables with DigDB's One-Step-Summary
•  Advanced Pivot Table Tips
•  Cursor Meaning when Dropping Fields on a Pivot Table
•  GetPivotData Function
•  Monthly Summarizing
•  Pareto Analysis with Pivot Tables
•  Percent of Total in a Pivot Tables
•  Pivot Charts
•  Pivot Table: Use the Group Feature to Change to Monthly or Annual Output
•  Pivot Tables: Consistent Colors on all Charts
•  Pivot Tables: Correct Out-of-Sequence Data
•  Pivot Tables: Group Daily Report up to Months
•  Pivot Tables: Top 10 Customer Report with Top 10 AutoShow
•  Pivot Tables: Use AutoFormat with Pivot Tables
•  Pivot Tables: Use VBA to Print All Page Fields
•  Pivot Tables: Use VBA to Transform Data for Optimal Analysis
•  Pivot Tables to analyze market research data
•  Pivot Tables to Summarize Data
•  Produce a report for every department with Show Pages
•  Replace Pivot Tables with DigDB's One-Step-Summary
•  Summarize Data by the Hour( =Hour() )
•  Summarizing data with a pivot table
•  Seasonality Analysis with a Pivot Tables
•  Summary Table to Database Table
•  Unique list of customers with a Pivot Tables
•  Using Edit - GoTo to Clean up your Pivot Table
•  What is a Pivot Table?

Back to top

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

Back to top

VBA (Visual Basic for Applications) in Excel

•  Add a Module with VBA
•  Add Row while copying and manipulating data
•  Add the Path to your Worksheet Footer when Printing
•  Add today's entries to the next empty row on a master sheet
•  Adding and Deleting with VBA
•  Animation in Excel
•  Application Events
•  Application-Level Names (Hidden Name Space)
•  Arrays - CSEs - in Excel Visual Basic
•  Audio - Playing Sounds in Excel
•  Automate a tedious process with VBA Macros
•  Bypass Delete Confirmation
•  Change Name Box List width
•  Change recorded macro to import text file in next available row instead of using A1 every day.
•  Change the worksheet tab name to reflect the value in cell A1
•  Changing a cell's background color
•  Changing Tab Color
•  Color - Counting based on Interior or Font Color
•  Color - Counting by and Summing By Color
•  Color - Highlight Duplicate Entries
•  Color - Highlighting an Active Cell
•  Color - RGB Values
•  Convert Text to Lower Case
•  Converting Measurements To and From
•  Copy a Macro to Another Workbook Automatically
•  Copy Sheet, Preserving all Formatting
•  Copy the Previous row into the Next Blank Row
•  Counting cells by interior color using VBA
•  Create 78 Unique Sheet Names with Identical Data
•  Create a TOC (Table of Contents) for your workbook
•  Create a unique record number
•  Create a Word Document from a Row of Data
•  Create and name a new worksheet with VBA
•  Creating multiple lines of text in a messagebox
•  Creating Page Breaks in Excel-automaticaly
•  Custom Document Properties
•  Custom Functions
•  Custom Menus in the Visual Basic Editor(VBE)
•  Daily Import Automation with Unique Sheet IDs
•  Data Validation - Use a Defined Name to validate with data on another worksheet
•  Dates - Day of the Week with VBA
•  Dates - Find with VBA
•  Declaring a Variable in VBA
•  Declaring an Object
•  Default Properties of a Class
•  Delete a worksheet in a macro without having to see the "This worksheet will be permanently deleted"
•  Deleting VBA
•  Display Screensaver in Excel
•  Displaying AutoFilter criteria
•  Document Properties
•  Downloading Files using Excel
•  Duplicate Entries - Replace
•  Eliminate "/" from File Names when Saving with a Macro
•  Email a Worksheet From Within Excel
•  Emulate Lotus' Print Suppression
•  Excel Crash on Mouse-over of object
•  Exit a worksheet with or without saving
•  Export VBA Code to a Text File
•  Exporting to Text
•  Fill Next Row with Previous Row's Data
•  Find the last row of data in a range
•  First Monday of the Year
•  Formatting Time Values
•  FTP within Excel
•  Headers and Footers - with VBA
•  Headers and Footers in Excel
•  Hidden Name Space - Application-Level Names
•  Hiding a range depending upon user selections
•  Highlight Active Cell Location
•  Highlight Cells with Today's Date
•  Highlight the active cell
•  How do I get rid of a Macro?
•  Importing - Text Files to Excel
•  Increment a Counter everytime a Userform is opened
•  Inputbox to accept specific data
•  Link back to original workbook
•  Maximized view on open
•  Mailing Labels in Excel with VBA Utility
•  Module-What is it?
•  No Blank Rows
•  No Duplicate Rows
•  OnTime Method
•  Open Other Applications from Excel
•  Opening Chm (or HTML Type Help) files
•  Optimize Your Code!
•  Phone Calls within Excel
•  Phone Numbers - Splitting(Parsing)
•  Play a MIDI File when Value Exceeds Set Limit
•  Printing - Cell Comments
•  Printing - Cell Formulas
•  Programming a messagebox for user responses
•  PROPER - Converting Text Case
•  Proper Text
•  Protecting specified data using VBA
•  Quicken and Excel: Streamline Categories on Copied Reports
•  Range - Bringing a Range Center Screen with VBA
•  Range - Referring to Cells in Another Range
•  Range - Reverse a Range with VBA
•  Range - Reverse Cell Order
•  Range - Select the Current Named Range
•  Ranges - VBA for Named Ranges
•  Record/Playback a WAV file in Excel
•  Record a Macro using Relative References (TechTV)
•  Recycle Bin
•  Removing a set number of characters from a cell
•  Removing hyperlinks from a worsheet
•  Removing text-string characters
•  Reset Application.ScreenUpdating for forward compatibility with Excel XP
•  RGB Colors
•  Run a Macro Automatically When the Workbook Opens
•  Run a Macro Following Cell Value Change
•  Run a Macro from a Command Button
•  Run a Macro from a Cell
•  Save - Save and Return to Selection
•  Save a Workbook with Cell A1's Data
•  Scheduled Procedure - Using OnTime
•  Select Current Array
•  Selecting files within VBA
•  Selection Change to Highlight Current Row and Column
•  Setting a font name with VBA
•  Sorting - Worksheets
•  Stopping an Endless Loop
•  Testing Anti Virus Applications using Excel
•  Text - Converting to Upper or Lower Case
•  Text to Columns using VBA
•  Time - Working with Time Zones
•  Time: Military Time with No Colon
•  Timers
•  UDF(User Defined Function)-Use a Calculated Range in a Standard Function
•  Unselect a Cell or Area
•  Upper Case - Converting To/From
•  Use Cells(Row, Column) instead of Range() when looping through several columns
•  Use Cells(Row, Column).Name = "MyRange" to Simplify Naming a Range
•  Use Set to create an Object Variable instead of a regular variable when referencing cells
•  Use Workbook_Open to open a Userform when a workbook is opened
•  Userforms - Modeless
•  Userforms in Excel '97 and beyond
•  Using Inputboxes
•  Variable - Declare
•  VBA How to: Macros on the Web
•  VBA How To: Record and Customize your own macros
•  WAV Files in Excel
•  What is a Code Module?
•  What is a Module?
•  Workbook - Close All
•  Workbook - Returning Properties
•  Workbook - Save All
•  Workbook Object - Document Properties
•  Working with Functions in a Macro
•  Working with Userform controls
•  Worksheet - Call a Macro from a Worksheet
•  Worksheet - Returning Sheet Name
•  Worksheet Protection after Sorting
•  Worksheets - Referencing from a Formula
•  Worksheets - Sorting
•  Zoom - To a Range
•  Oracle Data in Excel
•  Excel Macros
•  Excel VBA Macros

Back to top

The Excel Environment

•  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
• Even more articles are indexed at ExcelUser.com.

Back to top