ExcelSkillsSociety.org
UPDATES FROM CURRENT ISSUE
 
 
 
 

Take a Free Test Drive

Name:  
E-mail:   
6 COMPELLING REASONS WHY YOU MUST JOIN ExcelSkillsSociety
Inside Microsoft Excel

Inside Microsoft Excel
You'll get, every month, a copy of the industry-trusted, Inside Microsoft Excel

Excel Spreadsheets

Excel Spreadsheets
Simplify your business and personal tasks with our spreadsheets

Excel Dashboards

Excel Dashboards
Calculate and report on complex data just by entering figures

Excel Stock Technicals

Excel Stock Technicals
Stay a step ahead of the yo-yo-ing stock market with our technical analyzers

Excel Beginner Tutorials

Excel Beginner Tutorials
Are you a beginner? Well, we've got over 200 basic tutorials for you

Access Beginner Tutorials

Access Beginner Tutorials
Are you an Excel expert who wants to move to Access? We've got Access covered too

 
Adobe PDF IconAdobe Acrobat Reader
(required to view PDFs)
 

 

Excel Skills Society delivers — FREE —personal and business-related spreadsheets every month!

 

So, what kind of an Excel spreadsheet are you looking for? One that will help you eliminate debt, or a spreadsheet that will help you decide whether to lease or buy an asset? Or, do you want one that calculates your 401(k) savings? Or one that helps you predict stock prices? Excel Skills Society brings you useful personal and financial spreadsheets for free. Check them out and download the ones you like.

 

Remember, we keep adding new spreadsheets every month, so why don't you suggest one? We'll develop it just for you!

 

 

Pareto Analysis

Downloads: 44

This tool uses Pareto Analysis which is a statistical technique that uses the Pareto principle – the idea that by doing 20% of work you can generate 80% of the advantage of doing the entire job. Or in terms of quality improvement, a large majority of problems (80%) are produced by a few key causes (20%).

Download Spreadsheets 2007  2003


Gantt Chart

Downloads: 47

A Gantt chart uses bar charts to illustrate project schedules in a pictorial format. These charts illustrate the start and finish dates of the terminal elements and summary elements of a particular project.

Download Spreadsheets 2007  2003


Net Worth Calculator

Downloads: 41

To calculate your company’s Net Worth using this calculator, you need to fill in the values of your various assets and liabilities under the different heads in this calculator.

Download Spreadsheets 2007  2003


Z-Score Bankruptcy Calculator

Downloads: 27

Calculate Altman’s Z-Score for your company and find out whether it is in the Safe; Gray; or Distress zone. All you have to do fill in the 7 variables [numbered (i)(vii) in the spreadsheet] and you come to know whether your company is in good financial health; whether solvency is predicted; or whether bankruptcy is on the cards.

Download Spreadsheets 2007  2003


Working Capital Need

Downloads: 34

Your working capital is used to pay your business’s running expenses such as purchases, salaries, general expenses, etc. You risk running out of cash If your working capital dips too low. Even very profitable businesses can run into trouble if they lose the ability to meet their working capital expenses. The calculator assists you in determining working capital needs for the next year.

Download Spreadsheets 2007  2003


Financial Ratios Calculator

Downloads: 49

Use our calculator for calculating the financial ratios (Short Term Solvency Ratio, Long Term Solvency Ratio, Assets Management Ratio and Profitability Ratio) of your business in a jiffy.

Download Spreadsheets 2007  2003


Depreciation Calculator

Downloads: 28

Use the Depreciation Calculator to calculate the decrease or loss in the monetary value of your asset because of age, wear, or market conditions. This calculator uses three methods — Straight Line, Double Decline Balance, and Sum-of-Years Digit — to calculate depreciation. All you need to do is fill in the Initial Value, Salvage Value, and No. of Years in the respective fields and the calculator gives you the Depreciation Values and the Book Values by all the three methods.

Download Spreadsheets 2007  2003