Find and/change storage spots

Labels: Customize, General, Templates

Another year

Labels: General, Templates

Free business advice

SCORE's 10,500 volunteers have more than 600 business skills. Volunteers share their wisdom and lessons learned in business. Our volunteers are working/retired business owners, executives and corporate leaders.

• SCORE offers Ask SCORE email advice online.
  
• Face-to-face small business counseling at 389 chapter offices.
  
• Low-cost workshops at 389 chapter offices nationwide.
  
• "How to" articles and business templates

A Business Plan for a Start-up Business

Microsoft Word

A Business Plan for an Established Business

Microsoft Word

Bank Loan Request for Small Business

Microsoft Word

Break-Even Analysis

Excel

Competitive Analysis

Microsoft Word

Financial History & Ratios

Excel

Loan Amortization Schedule

Excel

Opening Day Balance Sheet

Excel

Personal Financial Statement
Excel

Projected Balance Sheet

Excel

Start-up Expenses

Excel

4-Year Profit Projection

Excel

12-Month Cash Flow Statement

Excel

12-Month Profit and Loss Projection

Excel

12-Month Sales Forecast

Excel

Labels: Templates

Financial enlightenment

Time Value (xls)

Introduction to time value concepts, such as present value, internal rate of return, etc.

Lease or Buy a Car (xls)

Basic spreadsheet for deciding to buy or lease a car.

Top Five NPV & IRR (xls

Explains Internal Rate of Return, compares projects, etc.

Statements (xls)

Generate a set of financial statements using two input sheets - operational data and financial data.

Business Financial Analysis Template

for start-up businesses from Small Business Technology Center

Income Statement

What If Analysis

Assessment Templates

Set of templates for assessing an organization based on the Malcolm Baldrige Quality Model.

Labels: Templates

One day at a time

Here are some links with downloadable examples, and some code that can be used to create calendars in Excel:

John Walkenbach:


Appointment Calendar

Andrew Engwirda's Excel tips:

Excel Calendar

Calendar Toolbar

Andrew has a calendar worksheet that can be downloaded:

Calendar.zip

He also suggests:

"Tushar Mehta has a very nice calendar too which can be found here:

Calendar"

"Create a Create a simple calendar for each month or a small calendar (pocket) for a whole year.

The calendar automatically formats some holidays (included Easter Sunday etc.), you might need to customize the workbook to suit your needs."

MakeCalendarPlanner()
(Evelyn Woolston scroll down to entry #5)

Microsoft Templates:

Calendar templates



See all Topics
excel

Labels: Templates

Still good after all these years

These detail the benefits and outline the steps of many Excel features. They are worth the download.

They are a great resource for learning advanced features, training, and tips on a great consistent presentation that you can use to format your workbooks.

While they were written for Microsoft Excel versions 5.0 and 7.0, they are still viable in Excel 200x.

These Experiences were developed for Microsoft Corporation by Baarns Publishing.

Here are the titles of the illustrated workbooks that are free to download:

• Subtotals Experience
  
• Group and Outline Experience
  
• Range Name Experience
  
• Functions Experience
  
• PivotTable Experience
  
• Auto Filter Experience
  
• Auto Format Experience
  
• Power Chart Experience
  
• Scenario Experience
  
• Solver Experience

Labels: General, Templates, Tips, Tutorials

Split the sheets (?)

Recently a large group of friends and I went on a multi-city tour of Europe that lasted a couple weeks. There was a lot of planning that went into this trip and responsibilities for booking different legs of the trip were spread out across the group. How do you efficiently handle paying back multiple people while getting reimbursed for your costs at the same time?

Split Costs

You can download the spreadsheet here:Split_Costs.zip




See all Topics
excel

Labels: General, Templates, Tips, Tutorials

Geek fame

"You probably have a document you use over and over again, something you created to solve a particular problem. You may even find yourself occasionally sending the document to others in e-mail because it's so useful. Now you can share your clever solution with everyone who uses the 2007 Microsoft Office system!

People like you all over the world are allowing others to download and use their document templates on Office Online. Some of these templates have tens of thousands of downloads. They were submitted by people who either wanted to help others or show their great solutions. You can, too.

Labels: General, Templates

It's that year again

One Month and One Year perpetual calendars are available.

These Excel file calendars do not use macros and can be used in OpenOffice or other Excel compatible software.

• Perpetual calendars with Week starting on Sunday
  
  
• Perpetual calendars with Week starting on Monday
  
  
• A simple "universal" one month calendar that will update for any month and any year (after 1900) just by changing a date cell.
  
  
• A "universal" one year calendar that will show 12 months starting with a user defined Month and Year.
  Start dates can at the beginning of any year and any month.

Microsoft:
How to make calendars



See all Topics
excel

Labels: Formulas, Templates

Free tax forms

"No PASSWORD is needed!

If a cell is protected, it is because it contains a calculated value.

Many times, a manual override cell is provided if you need to override the calculated value.

After a while, you will figure out that the spreadsheet is completely functional without needing to unprotect it."

Labels: Templates