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 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