Excel Examples Table of Contents

You can visit each tutorial page or jump directly to an example page in a tutorial.

Table of Contents for Excel Examples

• Excel Help Page

  Excel Search

  About John F. Lacher

  Excel Tutorials

  ROI and ROE Performance Measure

  files/lacher43.xls

  Files2000/lacher43.exe

  Forecasting Techniques

  files/lacher44.xls

  Files2000/lacher44.exe

  Comparative Ratio Analysis

  files/lacher45.xls

  Files2000/lacher45.exe

  GANTT Chart for Scheduling Resources

  gantt chart using times

  gantt chart using times

  Data Input and Analysis

  files/lacher06.xls

  Files2000/lacher06.exe

  Number of Days, Months and Years Between Two Dates

  Calculation number of days, months and years from start date to end date

  Files2000/lacher09.exe

  Pivot Table Multiple Consolidation Example

  files/lacher05.xls

  Files2000/lacher05.exe

  Custom Dialog and List Box

  lookup using list box

  lookup using list box

  images/ehlpw.gif

  images/jflw.gif

  Custom Visio Application Design and Development

• Excel Help Bookshelf
• Benefits of On Line Consulting
• Business Solutions Tutorial

  PivotTable to Calculate Budget Variances

  Budget vs Actual Using Pivot Table

  Files2000/lacher13.exe

  PivotTables With Accounting Data

  Pivot Table Methods for Accounting Data

  Files2000/lacher27.exe

  IRR, XIRR, NPV, XNPV Functions

  examples of xiir xnpv irr and npv

  Files2000/lacher22.exe

  Maximum Sustainable Growth

  Calculate Maximum Sustainable Growth

  Files2000/lacher26.exe

  Highlight Exception Values

  exception color for date

  Files2000/lacher23.exe

  Using Built-In Workday Calculation Functions

  files/lacher39.xls

  Files2000/lacher39.exe

• Menu Options Tutorial

  Inserting Automatic Page Breaks

• Using Formulas Tutorial

  Use SUMIF instead of D... functions

• Advanced Formulas Tutorial

  Using a List Box to Change Data Displayed in a Workbook

  Using a List Box to Change Data Displayed on a Worksheet

  Files2000/lacher01.exe

  Four Methods of Adding Totals to a List

  files/lacher37.xls

  Files2000/lacher37.exe

• Pivot Tables Tutorial

  Using a Pivot Table as Source for Chart

  Using a Pivot Table as Source for Chart

  Files2000/lacher04.exe

  Apply Styles to PivotTables

  Styles on Pivot Table

  Files2000/lacher30.exe

  PivotTable Tutorial

  files/lacher33.xls

  Files2000/lacher33.exe

  Creating an Automatic Copy of a PivotTable

  Copy of Pivot Table Data Changed via Pivot Table Wizard

  Files2000/lacher36.exe

• Chart and Graph Tutorial

  Using Custom Chart Markers in XY Chart

  examples/dot.gif

  Animated Line Chart

  animate chart

  Files2000/lacher12.exe

  Chart Controlled With Button

  Chart tools - insert trendline

  Files2000/lacher14.exe

  Link Chart to Worksheet Range

  pivot table,chart,chartwizard database example

  Files2000/lacher15.exe

  Click on Chart to Select a New Source Range

  select source range for chart

  Files2000/lacher16.exe

  Add Percent Labels to a Bar Chart

  stacked bar with percentage

  stacked bar with percentage

  Chart Controlled With List Box

  files/lacher31.xls

  Files2000/lacher31.exe

  Copying an Embedded Chart to a Chart Sheet

  Plotting Zero and Missing (Empty) Values

  Plotting a Time Series of Data

  files/lacher40.xls

  Files2000/lacher40.exe

• VBA Fundamentals Tutorial

  Highlighting and Exporting Cell notes

  Learn How to Add Running Totals to a Worksheet

  Learn How to Add Running Totals to a Worksheet

  Learn How to Add Running Totals to a Worksheet

  List Box Lookup

  list box lookup based on edit field

  Files2000/lacher08.exe

  Change Cell Formatting

  Shading cells - example of modifying recorded macro

  Files2000/lacher10.exe

  Dialog Box to Filter Data

  filter using criteria range on hidden sheet

  Files2000/lacher11.exe

  Custom Dialog Example

  Custom dialog example

  Custom dialog example

  Select Custom Header

  Custom Header Selection

  Files2000/lacher20.exe

  Data Validation

  dialog box with error process

  Files2000/lacher21.exe

  Force Uppercase Entry

  Macro to force uppercase entry - using ONENTRY

  Files2000/lacher25.exe

  Pop Up List box

  files/lacher28.xls

  Files2000/lacher28.exe

  Dialing Phone Numbers the Windows 95 Dialer and Windows3.11 Cardfile

  files/lacher35.xls

  Files2000/lacher35.exe

  Input Validation

  Week number code ww in VBA

  Files2000/lacher41.exe

  Displaying Sequence of Colors

  files/lacher42.xls

  Files2000/lacher42.exe

• Advanced VBA Tutorial

  Exporting Excel Data in Special Formats

  Importing Text Files into Open Workbook

  Importing Text Files into Open Workbook

  Files2000/lacher02.exe

  Comparison of Three Sort Methods

  three different sort methods

  Files2000/lacher17.exe

• Date and Time Tutorial

  User Defined Function for Week Number

  Week number code ww in VBA

  Files2000/lacher32.exe

  Entering Time Without the Colon

  Week number code ww in VBA

  Files2000/lacher34.exe

• Feet and Inches Tutorial

  Conversion of Feet and Inches to Decimal Values

  feet to inches with formula built in to VBA

  Files2000/lacher18.exe

Downloading Tips

Consulting | Excel Examples | Bookshelf | Tutorials | Search

Last modified: July 03, 2001