Quiz - Excel

Introduction

This page contains a little quiz to see what you learned from this site. They are all multiple choice questions. Only one answer is correct. The answers come after all the questions. Good luck!

The quiz

Introduction

You read all the documentation that offers this site and you completed you the exercises. It's now time to put into practice what you read and tried. This page is an exercise to create a model. You should have to, from the initial data, create a model that will help you to estimate the trends for quarter. To facilitate the learning, there is only a variable: the monthly growth rate that's initially estimated at 25 %.

Introduction

Excel offers you a fascinating tool to create a synthesized view from a vast pool of data called a pivot table. As the name indicates, Excel generates a table that allows you to see the contents of one or several variables at the same time. Furthermore, the table is dynamic. It means that you can add, remove and change the location of elements in the table Excel will automatically give you a new view on your data.

Introduction

Even if Excel is a spreadsheet, it offers you several tools to manage a small database. The term used in Excel is a data list. You can enter, change and remove data. The software offers also options to quickly find the data that you wish. There are also functions to analyze the mass of data that you accumulated.

Introduction

The comments allow the users to quickly recall important information about the worksheet or to place comments for others to read and react to. It can be an important communication tool for a group working on the same worksheet. They are usually hidden until you need to see them. But you can also see them at all times if desired. This page will show you how to get the most out of this tool.

Introduction

You created your own decision-making model and now you want Excel to help you find the best solution for your situation. The software possesses several analysis tools that can help you. This page explains three of these tools: target value, the scenario manager and the solver. Each answers your needs in different situations.

Introduction

A macro command is a series of instructions that are always executed one after the other in the same order. They're very practical to automate repetitive tasks. The exercise that follows will demonstrate how to create a macro command. The next macro basically changes the background color of the selected cells. It contains only that single command. But after you've finished, you will be able create your own "macros" and insert as many instructions as you need.

Introduction

Why use a chart?

To simplify the analysis of a mass of data.

To be able to compare the data.

To quickly analyze the trends in data series.

To analyze proportions among different data series.

Introduction

To effectively use a spreadsheet, you must be able to create formulas to calculate automatically any change that you could bring to your model. Because some of these formulas are alike, it's very effectient to copy them than to rewrite them. This page demonstrates how to copy formulas and also looks at the very important point of relative and absolute references. You must master these notions to properly use a spreadsheet.

Introduction

The biggest advantage of functions is that they are ready to be used. You don't have to recreate them or to look for them in books to find the one that you need. Excel's help file can help you find what you need. You just need to press the F1 key to have access to it.

Introduction

Excel allows you to print your document as well as to add additional page layout options to your presentation. You can add a header or footer to a page, change the margins as well as several other options. This page shows you how to set-up your printout as well as the options for printing.

Improving the presentation of your worksheet

Often, you will have to present the results of your spreadsheet to many people. There are several possibilities available for improving the presentation. Excel offers you these options in two different ways: by using the Format toolbar or the main menu under the Format and Cell options.

Introduction

Excel is a spreadsheet. It's role is the creation and analysis of decision-making models. Every document, or file, consists of several worksheets containing 256 columns (named A to IV) and of 65536 rows filled with cells in which you can enter either text, numbers or formulas.

Introduction

There is just a kind of graphic format that is capable of having animated images. It's about a format of chart GIF 89a. It's a sequence of images the time of exhibition of that one controls. It looks a little like a series of cards with different images

Before we begin

This page was recently restructured. The contents on the World Wide Web are now divided into several pages. The page of introduction to the World Wide Web contains an introduction and a description of the elements that one finds on Web pages and Web sites. There is also a page containing advices for the conception of Web pages,

Introduction

There is a code HTML that allows to create a link on an address of E-mail. The only problem with this command is that the user should previously have supplied with the data to the Browser that he uses. He should supply his name, his address of E-mail

Introduction

World Wide Web entered in a big way in 1995. Since then, everybody wants to create his or her own Web page and to "publish" their work. This page shows you the basic concepts on how to use Microsoft Word to realize a Web page.

Creating Web pages with Netscape Composer

Before we begin
This page was recently restructured. The contents on the World Wide Web are now divided into several pages. The page of introduction to the World Wide Web contains an introduction and a description of the elements that one finds on Web pages and Web sites.

Advice on creating Web pages and sites

Introduction

World Wide Web entered in our vocabulary in 1995. Since then, everybody wants to create his or her own Web page and "to publish" it. This page give you some advice, tricks and hints on creating your Web pages and Web site.

Introduction

Contrary to the E-mail and Newsgroups, or you can wait for hours and even sometimes for days before having an answer, the IRC allows the communication in real time. You connect to a server IRC. Then you enter one of the " rooms of conversation " according to the subject that is shown. If there is no subject interests you, you can always create your own room of conversation and wait that the another person appears.

Introduction

Several persons would like to have a table of content in their document but believe that it is too difficult to create as well as to update. Word helps you in the creation of the table of content, thanks to the styles. Furthermore, it's very easy to update.

Creating a table of contents

Introduction

Word offers you tools to verify the contents of your document. It can verify the spelling as well as the grammar of your text. This page show you how to use these tools as well as their limitations.
All the examples of this page will be based on this sentence: " Jeremys' gellly falls on my pents. " Naturally, there are several errors. It is to demonstrate you the functioning of each of these tools.

Introduction

Word allows you to insert pictures into your document such as logos of companies, photos and other pictures to give more interest or a more professional speed(look) to your document. This page how shows to insert a picture that is on a floppy disk or a hard drive. You can also take a picture located in the bookshop of picture of Microsoft. To have a beautiful picture is not enough. It's necessary that it has the right size. Furthermore, the picture should be placed well in the document.

Introduction

It's preferable by moments to present the data on tabular form. The instructions that follow will demontrate you how to create a table and how to take advantage of it. The first thing, to be known is that you can enter several rows of text in the same cell of the table. It's not necessary to count the number of rows that will go to a table but a number of "cells". For example, the advantages and the disadvantages or to compare several options.

Insert a table

Page setup

Word offers you several options to change the presentation of the text such as to put the text in bold, in italic or in underlined. It's also possible to change the font as well as cuts it letters and its colors from the others. The pagination allows you to control the options of presentation of your document on paper. You can change the margins, the size(format) of the paper, the orientation of the paper and the other options that will be explained more low on this page.

Introduction

You will find on this page, the basic instructions to use Word. This page will show you how to do various tasks.

Change the row spacing

Introduction

Although the content of the document is the most important element, Word offers you several options to improve the presentation of the text. In this page, you will learn the various options that are generally used for presentations.

Demonstrations files

Here is the list of the files used during my demonstrations and the exercises on this site. You can select them and copy them to your computer.

excel2007-2010-exercises.xlsx

Excel file with the data required to do the exercises on creating a model, AutoSum, conditional formatting, data tables, charts, goal seek, scenario manager, solver.

General Information

Introduction
This section of the web site gives you general data on what you should know before using applications. It shows you the workings of the keyboard, the mouse and the basic operations for your floppy disks and of Windows. Furthermore, there are three pages that show you how to insert charts, organization charts and various objects into your documents.

Microsoft Access

Introduction
Before we begin, let's look at some of the advantages of a database.

+Access data more quickly and easily.

Microsoft PowerPoint

Introduction
At one point in time, you'll be asked to present or to try to sell your ideas to somebody. Whether it be a business presentations, a progress report to your superiors, a business plan, for a scientific or other conferences, presenting is always

Microsoft Excel

Introduction
Excel, like Lotus 1-2-3 and Quattro pro among others, is a spreadsheet. It's used to make calculations, create models and simulations. When a model is completed, you can try out what will happen to your budget if you buy a BMW instead of a Yugo (not for your picture, just your budget). How much manoeuvring room do you have in your budget?

Microsoft Word

Introduction
A word processor serves for drafting and writing documents. It's also easier to correct or to change the contents of a document with a word processor then by using a typewriter or even writing. Besides the text, these documents can also include pictures, charts,

Newsgroups

Introduction
The E-mail is advantageous when you know the address of the addressee. But what to make when you want to meet the other persons on the Internet who have the same interests as you?

FTP (File Transfer Protocol)

Introduction
FTP (File Transfer Protocol) is used to transfer documents or software of a site to your account of Internet or to your floppy disk. Several companies and universities have sites FTP

E-mail under the Merlin server

Introduction
The E-mail allows you to communicate with the other persons on the Internet. You can leave them messages and them the another message can afterward return you.

Netiquette

Introduction
Netiquette is simply some guidelines on good ways to help you communicate and interact with others on the Internet.

World Wide Web

Before we begin
This page was recently restructured. The contents on the World Wide Web are now divided into several pages. The page of introduction to the World Wide Web ( this page) contains an introduction and a description of the elements that one finds on Web pages and Web sites.

What is the Internet?

The Internet is a communication system that allows computers around the world to communicate and to exchange of the data with each other.