Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Tuesday, February 06, 2018 – Permalink –

More than Sudoku

Game with Excel


"IT may be the biggest tool in the Office, but Microsoft Excel can be cool too"

Here's an article on off-prescription Excel.

Play with Excel

Here are some of the games you can play for free:

  • Excel fun

  • 3D Viewer

  • Battleship

  • Blackjack

  • Breakout

  • Golf Stats

  • Mastermind

  • Maze

  • Minesweeper

  • Reversi

  • Rubix

  • Slots

  • Sudoku Solver

  • Tetris

  • Video Poker
ExcelTrick.com  

Mashable.com


See all Topics

Labels: , , , , ,


<Doug Klippert@ 3:06 AM

Comments: Post a Comment


  Tuesday, December 19, 2017 – Permalink –

Loan Payment

Basic tutorial


Microsoft provides a number of learning activities related to fundamental tasks.

Here's one that walks the student through a worksheet designed to calculate interest and total payment for a purchase, based on different loan terms.

"This practical spreadsheet lesson offers easy answers to life's perplexing math problems like How much will my dream car really cost after financing?

Students will calculate the cost of purchasing their very own Lamborghini sports car and determine if the ultimate price tag is really worth the investment. "

Dream Car
Also:
Basic Financial Calculations


See all Topics

Labels: , , , , , , ,


<Doug Klippert@ 3:23 AM

Comments: Post a Comment


  Friday, August 04, 2017 – Permalink –

Calendars - Perpetual

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 be at the beginning of any year and any month.

DotXLS.com: Perpetual calendars
 
Microsoft: How to make calendars


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:17 AM

Comments: Post a Comment


  Sunday, May 14, 2017 – Permalink –

1040 on a Spreadsheet

Free tax forms


All right, we spend our waking hours SUMming with Excel and then when one of the more stressful times of the year shows up, we turn it all over to TurboTax.

Here is a collection of IRS forms Glenn Reeves has done as interlocking spreadsheets.

The formulas are already set up; ready for data entry.
"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."



(Included on the site are forms back to 1996.)

http://www.excel1040.com


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:06 AM

Comments: Post a Comment


  Tuesday, January 03, 2017 – Permalink –

Spreadsheets in Education

Samples and papers


"SIE is an electronic journal devoted to the publication of quality refereed articles concerned with studies of the role that spreadsheets can play in education. Our aim is to provide a focus for advances in our understanding of the role that spreadsheets can play in constructivist educational contexts.
Spreadsheets in Education (eJSiE) is a free facility for authors to publish suitable, peer reviewed articles and for anyone to view and download articles."

eSIE


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:24 AM

Comments: Post a Comment


  Wednesday, September 28, 2016 – Permalink –

Where's the Template?

Find and/change storage spots



Describes the different template categories and the locations of templates in 2007 & 2010 Office programs. Also describes the registry settings that control where to find your custom templates.

Support.Microsoft.com


See all Topics

Labels: ,


<Doug Klippert@ 3:42 AM

Comments: Post a Comment


  Sunday, September 04, 2016 – Permalink –

New Calendars

Another year

Here are free Excel calendars for downloading.

Twelve months on one sheet or one month per tab.



DotXLS.com


See all Topics

Labels: , , ,


<Doug Klippert@ 3:29 AM

Comments: Post a Comment


  Friday, December 04, 2015 – Permalink –

Score Templates

Free business advice


SCORE is a nonprofit organization providing small business advice and training.

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
Here are some of the available 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

SCORE Template Gallery


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:03 AM

Comments: Post a Comment


  Sunday, November 15, 2015 – Permalink –

Free Excel Templates

Financial enlightenment


Matt H. Evans CPA. CMA, CFM has complied a list of 117 free Excel spreadsheets devoted to financial matters.

Here are a few of the entries:
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.


ExInfrm.com


See all Topics

Labels: , ,


<Doug Klippert@ 3:32 AM

Comments: Post a Comment


  Friday, August 14, 2015 – Permalink –

Calendar

One day at a time


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

Andrew Engwirda's Excel tips:

Excel Calendar

Calendar Toolbar

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

Calendar"

Erlandsen Data Consulting:
"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

Labels: , , , , , ,


<Doug Klippert@ 3:29 AM

Comments: Post a Comment


  Saturday, April 18, 2015 – Permalink –

Gantt-PERT

Project Charts


The Gantt chart was developed by Henry L. Gantt around 1910. The chart shows a project's status, but not how one task depends on another.

In the 1950's, the Navy developed PERT (Program Evaluation Review Technique) charts. A similar process is called the Critical Path Method (Analysis) or CPM (A).

The terms PERT, PERT/CPM, and CPM are often interchanged.

A PERT chart looks more like a flow chart than a graph.

BaRaN Systems has some clear examples:
Project for Excel

Here's an example of a Gantt chart being constructed using an open source product called GanttProject :
Flash Demo

John F. Lacher has created a nice example of how to create a Gantt chart.
This one is appropriate for scheduling rooms, resources, and time.

A sample can be downloaded and customized.
Lacher24.XLS


Gantt Chart

Also see:

Simple Gantt chart

And

Microsoft Knowledgebase:
How to Create a Gantt Chart Using Hours as the Scale
Visual Basic Module to Create Gantt Chart

Jon Peltier:
Advanced Gantt Charts
Gantt Googled


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:28 AM

Comments: Post a Comment