Course program and outlines |
Course Program |
|
|
Course outlines |
|
|
Two introductory Powerpoint presentations on Excel |
Create your first workbook |
|
|
Get up to speed |
|
|
Data on products |
|
|
An introductory exercise on formatting |
Area and population data |
|
|
Formatting an Excel 2007 worksheet |
|
|
Examples on number formatting |
|
|
A new tool: Tables |
Excel 2007 Tables |
|
|
Introductory exercises |
An introductory simple exercise |
|
|
Another introductory exercise |
|
|
Formulas |
Enter formulas |
|
|
Data for the presentation on formulas |
|
|
Some Excel functions |
|
|
List of Excel functions |
|
|
Naming ranges and referring to data in Tables |
Naming ranges |
|
|
An example of named ranges |
|
|
Referring to data in Tables |
|
|
Exercise: calculating averages and percentages |
Foreign students in Italy 1999 - 2000 |
|
|
Averages and percentages |
|
|
Percentages to total |
|
|
Summary |
|
|
Exercise: using functions requiring criteria |
Urban population in various ages |
|
|
Analysis n.1 of urban population |
|
|
Analysis n.2 of urban population |
|
|
Charts |
Create a chart |
|
|
A worksheet for the head of your office |
|
|
Data for the exercise |
|
|
An analysis of customers' arrivals using charts |
Analysing arrivals of customers |
|
|
Dates and time |
Dates and time in Excel |
|
|
Some examples on using dates and times in Excel |
|
|
Tutorial on Microsoft Excel on www.bettersolutions.com |
|
|
An exercise on date formulas in Excel |
|
|
Calculating an age between two dates using the DATEDIF function |
|
|
It's your birthday today! |
|
|
Exercises on dates and time |
Data for Exercise 1 |
|
|
Data for Exercise 2 |
|
|
Exercise 1 |
|
|
Exercise 2 |
|
|
Importing textual data |
Import text into Excel |
|
|
Proportion of European population aged 15-24 (txt) |
|
|
Proportion of European population aged 15-24 (csv) |
|
|
Proportion of European population aged 15-24 (prn) |
|
|
Using Excel functions to look up values |
Information about functions that look up values |
|
|
Some lookup examples |
|
|
Were the Beatles good students? |
|
|
The Goal Seek tool |
Building a wall |
|
|
How much can I spend? |
|
|
The Goal Seek tool |
|
|
Something magic: Pivot Tables |
Get started with Pivot Tables |
|
|
Data for the Pivot Tables presentation |
|
|
Some exercises |
Exercise n. 1 - Studying the European population |
|
|
Exercise n. 2 - U.S.A. president's popularity |
|
|
Data for exercise n. 2 (UPDATED!) |
|
|
Exercise n. 3 - Analysing the population of Trieste |
|
|
Data for Exercise n. 3 - Male population in Trieste |
|
|
Data for Exercise n. 3 - Female population in Trieste |
|
|
Exercise n. 4 - Travelling from London to Glasgow |
|
|
Exam - 08/01/2009 |
Instructions - 2009 01 08 |
|
|
Assignment 2009 01 08 |
|
|
Data on USA car crashes |
|
|
Exam - 22/01/2009 |
Instructions - 2009 01 22 |
|
|
Assignment - 2009 01 22 |
|
|
Data on Italian Superenalotto lottery |
|
|
Exam - 05/02/2009 |
Instructions - 2009 02 05 |
|
|
Assignment - 2009 02 05 |
|
|
Data on employees |
|
|
Exam - 03/06/2009 |
Instructions - 2009 06 03 |
|
|
Assignment - 2009 06 03 |
|
|
Data on players |
|
|
Exam - 17/06/2009 |
Instructions - 2009 06 17 |
|
|
Assignment - Tables - 2009 06 17 |
|
|
Assignment - Chart - 2009 06 17 |
|
|
Data on teams |
|
|
Exam - 30/06/2009 |
Instructions - 2009 06 30 |
|
|
Assignment - Tables - 2009 06 30 |
|
|
Assignment - Chart - 2009 06 30 |
|
|
Data on writers |
|
|
Exam - 09/09/2009 |
Instructions - 2009 09 09 |
|
|
Data on teams |
|