John Lacher, MBA has
more than 10 years of experience as a developer of Microsoft Office
based computer applications. His Excel Examples and Tips offer a wealth
of free knowledge on how to effectively use many of
Excel’s intermediate and advanced features. For each example
he provides an instruction page and an Excel spreadsheet containing the
feature being demonstrated. Topics covered include forecasting, pivot
tables, business related formulas, advanced formulas, charts and
graphs, VBA coding, and dates and times. If you are having trouble
downloading the spreadsheets or files, here are some downloading tips.
Microsoft Excel Examples and Tips
- Excel Help Page
- Excel Search
- ROI and ROE Performance Measure
- Forecasting Techniques
- Comparative Ratio Analysis
- GANTT Chart for Scheduling Resources
- Data Input and Analysis
- Number of Days, Months and Years Between Two Dates
- Pivot Table Multiple Consolidation Example
- Custom Dialog and List Box
- Custom Visio Application Design and Development
- Business Solutions Tutorial
- Menu Options Tutorial
- Using Formulas Tutorial
- Advanced Formulas Tutorial
- Pivot Tables Tutorial
- Chart and
Graph Tutorial
- Using Custom Chart Markers in XY Chart
- Animated Line Chart
- Chart Controlled With Button
- Link Chart to Worksheet Range
- Click on Chart to Select a New Source Range
- Add Percent Labels to a Bar Chart
- Chart Controlled With List Box
- Copying an Embedded Chart to a Chart Sheet
- Plotting Zero and Missing (Empty) Values
- Plotting a Time Series of Data
- VBA
Fundamentals Tutorial
- Highlighting and Exporting Cell notes
- Learn How to Add Running Totals to a Worksheet
- List Box Lookup
- Change Cell Formatting
- Dialog Box to Filter Data
- Custom Dialog Example
- Select Custom Header
- Data Validation
- Force Uppercase Entry
- Pop Up List box
- Dialing Phone Numbers the Windows 95 Dialer and Windows3.11 Cardfile
- Input Validation
- Displaying Sequence of Colors
- Advanced VBA Tutorial
- Date and Time Tutorial
- Feet and Inches Tutorial
Popularity: 7% [?]
Related Posts:
Tags for this post>> Excel