Showing posts with label Microsoft Excel. Show all posts

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.

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?

Computer Internet Tutorial

Quiz - Excel

Introduction

The quiz

Exercises on Excel

Introduction

Pivot tables

Introduction

Data lists

Introduction

Comments

Introduction

Analysis tools

Introduction

Using macros

Introduction

Charts (Graphs)

Introduction

Copy, Paste and Reference

Introduction

Functions

Introduction

Page setup and printin

Introduction

Presentation

Improving the presentation of your worksheet

Basic operations

Introduction

Microsoft Excel

Most Visited

Read More..