Excel Course Introduction

Excel is a component of the Microsoft Office suite which supports Word, the famous word processor, Excel spreadsheets, Powerpoint to make great spreadsheetsand Outlook the mail system and agenda.

Excel allows you to create high quality spreadsheets that can solve all your basic and more advanced needs in calculation or data sorting. All the spreadsheets can be printed, projected on the screen or shared online and on the net.

Example of what Excel can do:

  • Data collection
  • To do Lists
  • Draw curves, charts, graphs, tables of numbers
  • Sort complex data or big data (where a lot of data is involved)
  • Solve problems, equations
  • Even games can be made with Excel
  • Calculate Loans, Budgets, ...
  • Basic drawing
  • ....and much more

Excel files are recognized by their characteristic icons or extension xls, xlsx, xlt, etc ...

Excel icon

Excel is used worldwide in universities, schools, companies, organizations, and of course in the private sector meaning your home.

This site is dedicated to explain the basics and more advanced sides of Excel so that you become a master in Excel.

Excel gives you the possibility to do millions of things....literally..., but to be able to start well, you need to cover the following basic topics.

 

Basic Excel Course

Here we go through the need to know features and functions of Excel. We give you this free Excel Course because we believeExcel is a very useful tool to know and that can give you a lot of advantagesin your carreer as well as save you a lot of time and money.

The ribbons: These are essential part of Excel. It is the old Excel Menu.All the Excel Ribbons are explained one by one.

Create your first Excel Budget: This is a step by step example of how to create an Excel budget

Sheets: this is the place where everything happens. The Excel sheets explained in details.

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: what are rows in Excel. We give you a short intro.

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

Basic Formulas on Numbers:  how to use formulas, sums, multiplication, divisions, substractions, or add up a row or column and other basic functions with numbers

Basic Formulas on Words: how to use formulas on words, how do you put words togethers, find words automatically, etc...

More Complex formulas: how to use complex formulas, they can be very useful for daily Excel usage, naming cells, creating arrays.

Graphs or charts: how to make an Excel charts and graphic is explained here

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

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.

Excel Vocabulary: In Excel is very important to know the specific words used in this program. It allows to better communicate with others about what you're doing and also better understanding when others communicate to you about Excel.

 

Advanced Excel Course

Here we will go through a few of the advanced features of Excel.

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.

Scientific Formulas: Excel is a great tool for scientist and here a glimpse of what it provides you.

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

Text Handling: We teach you here the basic functions that can handle strings and text in Excel