Excel Made Easy

Welcome to Excel Made Easy

We are offering Excel Tutorials and Templates. You can learn Excel from school level to university level, Basics to Advanced levels including VBA (Visual Basic for Applications), functions & formulas (time, conditional, mathematics, financial, ...), sorting data, analyzing data, making templates that are useful to you. It gives you for hundreds of templates that are free as well as useful spreadsheet like task lists, todo list weight tracking charts, purchase orders and invoices templates.

Here are some main topics if you look for information or templates quickly.

Tip of the day: To add a column, use the Layout ribbon in the Table Tools Ribbons (top right of the screen), and press insert right ot left to insert a column.

Here under our Free Excel Course and Free VBA Tutorial. It is made for beginners and more advanced users.

Most downloaded files:

• Open topic list: manage all your task, easy overview of what you have to do on a daily bases, reminders in colour and alarm if you start to be late.

• Purchase order template: get your purchase orders done in a professional manner

• INVOICE, PURCHASE ORDERS, BUSINESS PLANS: You are looking for useful templates of purchase orders, invoice or even are in the process of rethinking your company's business plan then you could look at our business model template and advises about business  re-organization. See also our SWOT Matrix Template.

NEWS :  PROJECT MANAGEMENT GANTT CHART: we have made a many chapters about project management, business plan and every activity around managing companies and projects. Try the GANTT PRO Version of our Project Management Gantt Chart for USD 25.- Otherwise you can try the light version in the free project management Gantt Chart is here.

On this site you will find a tutorial and a learning guide to Excel 2007, 2010, 2013, 2016, Excel 365 and Office and Excel for ANDROID. It is intended for both beginners and experienced users. It includes an introduction, explanation of all menus, functions available and the tricks of the professionals and also many examples and templates to download.

At the end you will be perfectly able to do yourselves stunning spreadsheets. If you want to go to the older version of ExcelMadeEasy (1997 to 2003) that was covering Excel before the Ribbon era, then follow this link. But this site, will have many examples and templates that can be used in any version of Excel.

For Tutorials, just go down or use the search on the top right. On our site the content is completely free and you can download also our examples and templates for free.

Introduction on the Excel Course

The introduction is for people who do not know Excel so well and would like to go step by step through each menu and receive detailed explanations.

Excel is a component of the Microsoft Office suite that also comprises Word, the famous word processor, PowerPoint to do great presentation and Outlook the mail system and agenda. It is used by millions of people worldwide.

Excel allows you to create high quality spreadsheets that can be printed, projected on the screen, or shared online.

The ribbons in Excel as in all the 2007, 2010 and 2013 office versions are explained here.

Learn by doing in this Example as foretaste. We will go through the basic steps to create a first spreadsheet. Learn how to use formulas. We will create a quick spreadsheet in minutes. It will include a graph and a color table too. This will help you feel better what Excel can do.  If you read the part 1 already, this is the second part.

The Basics

The vocabulary page teaches you some of the main words used in Excel.

Sheets: this is the place where everything happens. The sheets in detail.

Cells: all about Cells, how to enter text, modify it, enter formulas, etc...

Columns: what are columns, how to select them, move them, etc...

Rows: same as previous but rows.

Select, Copy and Paste: the essentials in order to get quickly around.

Basic Formulas and Functions on Numbers: Learn how to use formulas, how do you make sums, multiplication, divisions, subtractions, or add up a row or column and other basic functions with numbers

Basic Formulas and Functions on Words: how do you put words together, find words automatically, etc...

More Complex Formulas and Functions: you will see how more complex operations very useful for daily Excel usage

Make nice tables: how to put headers on rows and columns, color the cells, etc...

Graphs or charts: how to make a graphic or chart is explained here

Saving: essential to your sanity, is to know how to save properly your work.

Printing: and then how to print it correctly. Not ending with a table spreading over 5 sheets.

Advanced

In this advanced section you will discover more advanced tools and functions of Excel. They will contain the following items:

Sorting data: How to sort a bunch of numbers or words and make them look tidy or extract what you are looking for.

Filtering: similar to sorting but here you get only what you want and what you do not want is not shown on the screen.

Automatic Highlighting or conditional formatting: to find one word or number in one big table can be very difficult. Here we show how highlight these. Also, how to change automatically the color of a cell depending on the value.

Pivot Table are so useful when it comes to aggregate data and sort it.

Solver: an convenient way to find the solution to complex problems (like shortest path, etc...)

Financial Formulas: we will look into the most used financial equation given by Excel.

Math, Scientific and Engineering Formulas: Excel is a great tool for scientist and Engineers. Here a glimpse of what it provides you.

Date, Time: how to get todays dates or change the date format, etc... is done here.

Text handling: these functions allow to work with text like adding letter, putting words together, finding words, etc...

All other Functions: here a list of all the Excel functions and formulas (Text Handling, LookUp Function, Database, Logical, Cells Information, ...)

Mini-Exercises, examples and templates

In this section we will do a few exercises or projects together.

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

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

Curves: Graph functions in Excel. Graph a Linear Function In Excel. Plot a Function among the ones given in the example. Draw some nice curves and functions. A picture is worth 1000 words. Same for curves and graphs. Here a great spreadsheet

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

Budget: Lets make a simple budget together.

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

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

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

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

Useful Links

In this page we will give you some important links because the web is full of great resources.

VBA or programming in Excel

What is Visual Basic?

In the basic Pages you will discover some important concepts and tools to start with Excel.

In the advanced Pages: we will go through the fundamentals of VBA. Always following the principle, learning VBA must be fun and useful.

Tips and Tricks, FAQ

The Tips, Tricks and other useful things to make your life easier.

The Tips and Tricks Pages :some important tricks to discover.

Simplify your life with shortcuts

Personalize the Ribbon: very useful to put some frequently used buttons in the top ribbon.  (to come)

Multiple spreadsheets: how to move from one spreadsheet to another.

Correct your mistakes: it is very important to correct your spelling errors as well as the grammatical errors. (to come)

Find Text: easily find a word, a phrase that you wrote in your spreadsheet but cannot remember where it was.

Replace text: replace a word with another word, a phrase by another phrase. This very easily.

Some explanations about the differences between Excel or Office 2013 and Office 365.

Diploma, Master ès Excel

Print your Diploma. Of course only once you have gone through all the website and understood most of it. We trust you will use it wisely.

1000 Examples, FAQ

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

What are you looking for? Type in if it is something specific like tables, charts, project management, budget, .....