Skip to main content
Tutorial on Microsoft Excel on www.bettersolutions.com
◄ Some examples on using dates and times in Excel
Jump to...
Jump to...
Annunci
Course Program
Course outlines
Create your first workbook
Get up to speed
Data on products
Area and population data
Formatting an Excel 2007 worksheet
Examples on number formatting
Excel 2007 Tables
An introductory simple exercise
Another introductory exercise
Enter formulas
Data for the presentation on formulas
Some Excel functions
List of Excel functions
Naming ranges
An example of named ranges
Referring to data in Tables
Foreign students in Italy 1999 - 2000
Averages and percentages
Percentages to total
Summary
Urban population in various ages
Analysis n.1 of urban population
Analysis n.2 of urban population
Create a chart
A worksheet for the head of your office
Data for the exercise
Analysing arrivals of customers
Dates and time in Excel
Some examples on using dates and times in Excel
An exercise on date formulas in Excel
Calculating an age between two dates using the DATEDIF function
It's your birthday today!
Data for Exercise 1
Data for Exercise 2
Exercise 1
Exercise 2
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)
Information about functions that look up values
Some lookup examples
Were the Beatles good students?
Building a wall
How much can I spend?
The Goal Seek tool
Get started with Pivot Tables
Data for the Pivot Tables presentation
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
Instructions - 2009 01 08
Assignment 2009 01 08
Data on USA car crashes
Instructions - 2009 01 22
Assignment - 2009 01 22
Data on Italian Superenalotto lottery
Instructions - 2009 02 05
Assignment - 2009 02 05
Data on employees
Instructions - 2009 06 03
Assignment - 2009 06 03
Data on players
Instructions - 2009 06 17
Assignment - Tables - 2009 06 17
Assignment - Chart - 2009 06 17
Data on teams
Instructions - 2009 06 30
Assignment - Tables - 2009 06 30
Assignment - Chart - 2009 06 30
Data on writers
Instructions - 2009 09 09
Data on teams
An exercise on date formulas in Excel ►