Home

www.xlmacros.com

 

 

Warm Welcome...

My name is Richard, and I am the webmaster and consultant at Xlmacros.com. This is primarily a tutorial website and aims to provide Excel Users (having little knowledge of Excel VBA), with the power to write efficient macros to supplement their efficiency while working on Excel.

At xlmacros.com  we understand the frustration you have to go through, while trying to make something work  in Excel and it just won’t work. We hereby try to make an attempt to compile various Excel tutorials, Excel VBA tutorials, Videos, a huge list of Excel Templates and Excel Addins for you to download and a Forum for you to chat and discuss about various issues you are facing in Excel.

Although, most of Excel users today are aware of something called VBA, there are not many who have taken advantage of this language to program Excel objects. Learning VBA, does not at all mean that you will become a programmer or you need to be one. VBA just helps you to save a lot of time by automating the repetitive tasks that you perform in Excel.

Please do remember, every thing ...Yes, everything that you do in Excel manually can be programmed, and it does not need you to be a programmer to do so.

Excel has built in features which help you record actions    and automatically generates the code for you.

 All you need to do is to  copy and paste these lines here and there and you get a program  which you can use at the click of a button.

Access Links

Excel Viewer 2003

Excess Formatting Cleaner

Remove Hidden Data

Save as PDF

Save as PDF or XPS

Save As XPS

Template Wizard with Tracking

Loan Assistant

Multi-Cell Goal Seeker

Risk Analyzer

Report Runner

Sensitivity Analyzer

Chart Assistant

Chart Labeler

Histogram Creator

Quick Chart Creator

Waterfall Chart Creator

XY Chart Labeller

Address Assistant

Consolidation Assistant

CSV File Creator

Data Assistant

Data Cleaner

Data Extraction Assistant

Data Loader

Duplicate Finder

Lookup Assistant

Merge Assistant

Name Splitter

Conditional Format Assistant

Directory Lister

Information Lister

Link Finder

Macro Button Assistant

Macro Remover

Password Assistant

Print Assistant

Random Number Generator

Random Sampler

Significant Digit Assistant

ASAP Utilities

Duplication Manager

Formula Reference Sheet Index Creator

Text Manager

Number Manager

Named Range Manager

Time, Pay And Wage Book

Excel Time Sheet Advanced

Excel Time Sheet Advanced

ComboBox Wizard

Advanced Excel Find

Advanced Excel Select

Forecaster Excel

Calendar

Chart Add-ins and Software

Chart Picture Digitizer

Charting Tools

Classifier

Code VBA

COMxL RS232C

COM Excel

Color Palette

Compare Excel Workbooks

Compare Suite

Construction Works Complete Package

Construction Estimator

Converters

Convert Excel to PDF COM

Convert Excel to PDF

Convert Excel to HTML

Convert Excel to csv

Convert

Convert MySSQL to Excel

Convert Excel to MySQL

Duplication Manager

Excel Chart Color Tool

Excel Data Cleaning

Excel Exchange Rates

Excel Everywhere HTML

Excel Explorer

Excel Import Contacts

Excel Print Data

Excel OCX

Excel Resource Manager

Excel Sho

Excel Sma

Excel Shortcuts

Excel Templates

Excel Trading

Excel Workbooks Compare

Excel-to-MySQL

Excel-to-MSSQL

Excel Stats

Find A

Financial Advisor for Excel

Forecasti

Formu

Formula Reference Sheet Index Creator

General Cost Estimator For Microsoft Excel

Home Cost Estimator For Microsoft Excel

JEM Plus (Excel Add-in)

Monte Carlo Add-In for Excel

MySQL-to-Excel

MySSQL-to-Excel

Neural Networks Signal For Microsoft Excel

NeuroXL Classifier For Excel

NeuroXL Predictor For Excel

Number Manager

O2OLAP for Excel

Online Functions Exchange Rates

Paint Cost Estimator For Microsoft Excel

Privacy Add-in

Rapid Data

Range Name Manager

Real Time Highlighter for Microsoft Excel

Real Time Quotes Excel

Real Estate helper

Remodel Cost Estimator For Microsoft Excel

Repair Cost Estimator For Microsoft Excel

Report Maker

Roof Cost Estimator For Microsoft Excel

Shift Scheduler Continuous Excel

Similar Data Finder For Excel

Short Cuts Microsoft Excel Add-In

Sensitivity Analyzer

Smart VB6 Code

Smart VBA Code

SparkMaker

Spreadsheet Auditor

Spreadshe

Statistical Quality Control

Spreadsheet QC

Spreadsheet Scheduler

SQC for Excel

Tools for Excel Tables

Time, Pay And Wage Book

Templates

Text Manager

Transform Tables In Excel

Universal Pricing

VBA Code

VBA Code Print

Workcell Planner

Worksheet Booster

Wage Calculator

Comment Control

Complete Excel Names

DiffEngineX

Easy Filter

ExcelCalcs

Excel Explosion

Excel Utilities

FaceID Values

Find Link

Flex Find

Google Search

Name Manager

Password Remover

QDE

Rays Tools

SendMail

XL Random Generator

Password Prompt Fixer

Information Lister

Backup Assistant

Cell color assistant

Colored cells assistant

Column navigator

File assistant

Filt asst

List assistant

Multi column sorter

Pivot Table Assistant

A\ssistnt

PivotPlay

PivotPower

Pivot Table Format Helper

Code Documenter

VBA Code Cleaner

Loan amortization schedule

Breakeven analysis

College comparison worksheet

Ratio analysis

Competitive market benchmark analysis for financial services

Sales compensation model

Sales compensation model

Job Decision MatrixRequires genuine Microsoft Office

TuitionEstimateRequires genuine Microsoft Office

Competitive analysis using SWOT

Operating expense analysis

Project earned value analysis

Customer profitability analysis

Competitive market benchmark analysis

Loan amortization scheduleRequires genuine Microsoft Office

Job applicant data and comparison table

Break-even analysis

Product profitability analysis

Market analysis

Treasury analysis worksheet

Bidder comparison worksheet and process

Debt ratio analysis worksheet

Procurement analysis worksheet

Due diligence assessment model

Debt ratio analysis worksheet

Partner marketing funds analysis

Accounts receivable aging workbook

Loan analysis worksheet

Cost of sales tool

Risk assessment and financial impact model

Prospect ranking tool

Prospect ranking tool

Training needs assessment

Competitive analysis

CD switch analysis

Operating lease vs. own analysis

Channel selection matrix

Supplier analysis worksheet

Return on marketing investment (ROMI) worksheet

Intellectual property analysis

Customer ranking tool

Law firm financial analysis worksheet

My Personal AccountRequires genuine Microsoft Office

Sales opportunity review worksheet

Competitive market benchmark analysis for manufacturing

ROMI hurdle-rate calculation

ARM vs. fixed mortgage comparison

Product sales sample

Portfolio analysis

Fitness chart for women

Calculation Practice

College Degree Course Credits Tracker

Loan calculator with extra payments

Loan calculator

Mortgage qualification worksheet

Employee Time Card Calculator

Daylight Calculator

Net worth calculator

Vehicle loan payment calculator

Consumer debt manager

Bathroom remodel cost calculator

Year-end tax planning calculator

TuitionEstimate

Payroll calculator

Stock investment performance

Currency rate calculator

Electoral College calculator

Biweekly mortgage payment amortization

Large number math checker

Buy vs. rent home calculator

Closing costs calculator

Multi-family garage sale calculator

Real estate commission calculator

Annuity investment calculator

Buy vs. lease car calculator

Sales commission calculator

Kitchen remodel cost calculator

Food fat percentage calculator

Bulk purchase depreciation calculator

College costs calculator

Depreciation methods comparison

Mortgage refinance calculator

Net present value calculator

Value analysis calculator for product or service