Examples, Templates and Sample Files: Target 1000

Here you will find other examples of files, templates and also links to other sites with example.

Our target is to reach 1000 files that you can select from. Please help us and send us your examples to admin at excelmadeeasy.com

Useful

1) TOP 10 used formulas and functions



Budget, Mortgage, Money Management

1) Bank Loan: you want to know how much you will have to pay for this loan. Let's do it together.

2) Bank Interest: you want to know how rich you will be in 5 months or 50 years from now. Let's do it together.

3) Expense Tracking Template: Lets make an expense tracking sheet together.

4) Budget template: Lets make a simple budget together.

5) Hello Kitty Budget: Lets add some Hello Kitty background or any other background (movies, sport, nature, etc...)

More Templates, examples and tutorials to come with your help....

 

 

Time Management, Gantt Chart, Project Management, Open Topic Lists, To Do List

1) Gantt Charts, Time Line, Project Management: Get our free Gantt Chart timing. There is also a professional version here.

2) Open Topic List: how useful is it to have this reminder. Track your TASKS. Get reminded.

3) All our calendar templates or individually here under

4) A calendar template for 2015.

5) A calendar template for 2016.

6) A calendar template for 2017.

7) A calendar template for 2018.

8) Time Tracking Sheet template for your business or personal work tracking

9) Manage your life, this will help you sort out and prioritize all these impossible tasks.

10) Daily Schedule Template to plan your days and weeks well in advance.

11) Visualize you life goals, achievement, life targets, endeavors

More Templates, examples and tutorials to come with your help....

 

 

Company Business Management, Billing, Invoicing, Receipts, Personal Finances

1) Employee evaluation system for QA (quality) purposes

2) An invoice template with tax and no tax spreadsheets.

3) A purchase order template. Great for small businesses, freelancers, consultant.

4) To do List: how useful is it to have this reminder. Track your TASKS. Get reminded.

5) Percent Change in series of numbers or business or sales.

6) Time Tracking Sheet template for your business or personal work tracking

7) newTravel Expense Report Template to record and get your travel accounting in order.

8) Business Plan Support and templates: advice on how to start a business plan.

9) Business Model Template: great template to define the business model of your company.

10) SWOT Matrix Template Analysis (Strengths, Weaknesses, Threats, Opportunities)

11) Classic looking Purchase order for classic company or family business

More Templates, examples and tutorials to come with your help....

 



 

To Do List, Task List, Personal Organization

1) To do List: how useful is it to have this reminder.

2) Hello Kitty To Do List: again lets put a nice HK background to it.

3) Employment Search Tracking List. Lets you manage and track your new Job searches.

4) Collection Template: Track and keep record of all the items you collect. Stamps, Tools, Art, everything can be tracked, and with photos.

5) New year Resolution: here a great list to make and follow your new year resolutions.

More Templates, examples and tutorials to come with your help....  

 

Health, Fitness, Weight Tracking, Exercise, Health Calculators

1) A Weight Tracking Chart template (in Kg or Lb.)

2) List of nutritional values for various food items.

3) BMI calculator. This tells you if you are overweight, underweight or normal.

4) BMR calculator. How many calories (kcal) can you eat per day.

5) How long are you going to live according to the latest statistics. Here a life expectancy chart.

6) With our Weightwatchers Point Calculator, calculate the number of points you are allowed.

7) Here an Exercise tracking sheet for Weekly and Daily tracking to do your workout plan.

More Templates, examples and tutorials to come with your help....

 

Birthdays and Calendars

1) A calendar template for 2016.

2) A calendar template for 2017.

3) A calendar template for 2018.

4) if you still need, the calendar template for 2015.

More Templates, examples and tutorials to come with your help....

 

VBA, Data Analysis, Tutorials and various functions and formulas

1) Curves: draw some nice curves. A picture is worth 1000 words. Same for curves and graphs.

2) Product Sum:FunctionsSum and products and the same time: Sumproduct function

3) Copy, Move and delete Sheets with one click.

4) Date Formatting: change the date format in your cells.

5) Text formatting with keyboard shortcuts

6) How to Convert a Formula to a Static Value in Excel 2013  (CTRL+C, CTRL+V....& F9)

7) VBA Button to go from one sheet to another. Very useful when you want to redirect to other sheets.

8) Use of the RAND() function in this spreadsheet to create random numbers

9) Nice table with full date in .... narrow columns how to do this?

10) in a list of dates keep only the first day of the month displayed. This makes the list much more readable. Here the example.

11) how to autofill a formula over many empty cells. Here the example.

12) Recovering Protected Sheet Password.

13) Lowest or Top 10 items in a list

14) Draw a circle in Excel

15) Sort Positive and Negative Values into a new sheet (2014/12/11)

16) In complex formulas, naming the cells is essential. Look here how this is done (2014/12/12)

17) How to handle the error messages (like #VALUE, etc...) you get and replace them with other messages.

18) Use SUMIF and SUMIFS to get the right data out of a table.

19) Select random names in a table (RAND)

20) Add Buttons to move around

21) Top 10 formulas used in Excel

22) VBA: Buttons to move you from one section to another.

23) Lookup for data in a table  (LOOKUP)

24) Find the position of a value or data in a table  (MATCH, INDEX)

25) Test the world by using the IF function.



26) Display a message box with a Visual Basic Macro: MsgBox. The Message Box is a dialog box create in Excel VBA that you can you can use to inform the users.

27) Add Worksheets, Count Worksheets and workbooks.

28) The Indirect function allows you to refer to a cell by using a text. Look at our example to call out result from different sheets.

29) Move to the extreme right, left, top or bottom of the spreadsheet.

30) Date text formatting explained. Create the format you want.

31) Time and Hours formulas, use the time, hour, minute and second formulas.

32) Want to know how much of a year is between two dates. Use YEARFRAC()

33) ADDRESS, ROWS, COLUMNS, ROW and COLUMN are newly explained.

34) Embed an EXCEL table into WORD or POWERPOINT.

35) How to reverse the order of rows rapidly (vertical transpose)

36) How to remove all hyperlinks in an excel spreadsheet

37) Insert a picture into a cell or inserting into a table

38) Add or subtract one or more months to a date

39) Add or subtract one or more years to a date

 

More Templates, examples and tutorials to come with your help....

 

Mathematics, Sciences formulas, examples and templates

1) The Fibonacci Sequence is explained and created: it is seen everywhere in nature and the universe. Near approximation of the golden angle (linked to the golden ratio)

2) Percent Change in series of numbers or business or sales.

 

Games, Fun, Hobbies, FAQ and others

1) Love Phrase generator: You are unsure about what to say to your loved one. Let's do a love phrase generator together.

2) Timer (exercise Timer): You set a time in minutes and it will remind you to stand up and exercise. Very useful.  (contains a macro to count time passing). It will also record all the time you are in front of the computer and add it to the list. It is also a useful template if you suffer from RSI (repeated stress injury, carpal sysndrom, ...)

3) Psychedelic spreadsheet: Beware your eyes....welcome in the 60s. This sheet uses the RAND function to make a colour show.

4) FAQ: here the list of some Frequently Asked Questions.

5) Lets Calculate the value of PI (3.1415926....) by using the Excel Pi calculation template and lets graph it.

6) The F4 key, lets you change from absolute to relative referencing ($A$1 to A1)

7) Select random names in an excel table, very useful.

8) LiPo Battery energy per weight calculator. Is you LiPo Battery the right weight?

More Templates, examples and tutorials to come with your help....

....

With you help we will be getting there... (;-)

 

Thanks for watching and helping...