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

  About John F. Lacher

  Excel Tutorials

  ROI and ROE Performance Measure

  files2000/lacher43.xls

  Forecasting Techniques

  files2000/lacher44.xls

  Comparative Ratio Analysis

  files2000/lacher45.xls

  GANTT Chart for Scheduling Resources

  gantt chart using times

  Data Input and Analysis

  files2000/lacher06.xls

  Number of Days, Months and Years Between Two Dates

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

  Pivot Table Multiple Consolidation Example

  files2000/lacher05.xls

  Custom Dialog and List Box

  lookup using list box

  Custom Visio Application Design and Development

• Benefits of On Line Consulting
• Business Solutions Tutorial

  PivotTable to Calculate Budget Variances

  Budget vs Actual Using Pivot Table

  PivotTables With Accounting Data

  Pivot Table Methods for Accounting Data

  IRR, XIRR, NPV, XNPV Functions

  examples of xiir xnpv irr and npv

  Maximum Sustainable Growth

  Calculate Maximum Sustainable Growth

  Highlight Exception Values

  exception color for date

  Using Built-In Workday Calculation Functions

  files2000/lacher39.xls

• 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

  Four Methods of Adding Totals to a List

  files2000/lacher37.xls

• Pivot Tables Tutorial

  Using a Pivot Table as Source for Chart

  Using a Pivot Table as Source for Chart

  Apply Styles to PivotTables

  Styles on Pivot Table

  PivotTable Tutorial

  files2000/lacher33.xls

  Creating an Automatic Copy of a PivotTable

  Copy of Pivot Table Data Changed via Pivot Table Wizard

• Chart and Graph Tutorial

  Using Custom Chart Markers in XY Chart

  examples/dot.gif

  Animated Line Chart

  animate chart

  Chart Controlled With Button

  Chart tools - insert trendline

  Link Chart to Worksheet Range

  pivot table,chart,chartwizard database example

  Click on Chart to Select a New Source Range

  select source range for chart

  Add Percent Labels to a Bar Chart

  stacked bar with percentage

  Chart Controlled With List Box

  files2000/lacher31.xls

  Copying an Embedded Chart to a Chart Sheet

  Plotting Zero and Missing (Empty) Values

  Plotting a Time Series of Data

  files2000/lacher40.xls

• 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

  List Box Lookup

  list box lookup based on edit field

  Change Cell Formatting

  Shading cells - example of modifying recorded macro

  Dialog Box to Filter Data

  filter using criteria range on hidden sheet

  Custom Dialog Example

  Custom dialog example

  Select Custom Header

  files2000/lacher20.xls

  Data Validation

  dialog box with error process

  Force Uppercase Entry

  Macro to force uppercase entry - using ONENTRY

  Pop Up List box

  files2000/lacher28.xls

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

  files2000/lacher35.xls

  Input Validation

  Week number code ww in VBA

  Displaying Sequence of Colors

  files2000/lacher42.xls

• Advanced VBA Tutorial

  Exporting Excel Data in Special Formats

  Importing Text Files into Open Workbook

  Importing Text Files into Open Workbook

  Comparison of Three Sort Methods

  three different sort methods

• Date and Time Tutorial

  User Defined Function for Week Number

  Week number code ww in VBA

  Entering Time Without the Colon

  Week number code ww in VBA

• Feet and Inches Tutorial

  Conversion of Feet and Inches to Decimal Values

  feet to inches with formula built in to VBA

Downloading Tips

Consulting | Excel Examples

Last modified: September 16, 2010