MS Excel Tutorial

  1. Introduction 12. The SUM Function (2) 22. Plotting equations
  2. Column Charts 13. The SUM Function (3) 23. Iteration
  3. X-Y Charts 14. Other Functions 24. Looking up data
  4. Pie Charts 15. Mathematical Modelling 25. Data Analysis
  5. Line Charts 16. The IF Function 26. Lookup
  6. Presenting Charts 17. The IF Function (2) 27. Goal Seek
  7. Formatting spreadsheets 18. RAND() & Simulation 28. Scenarios
  8. Numbers 1      Numbers 2 19. Interface 29. Solver
  9. Sequences   30. Databases
10. Formulae 20. Charts and Trends 1 31. Database Exercise
11. The SUM Function 21. Charts and Trends 2 32. Pivot Tables

Examples

Magic Squares Monkeys and Bananas Theatre seating
Pay and Tax 1 Kepler's Third Law Multiplication tables
Economic development Café Zero Square Roots
Iteration example Finding Pi Public Key Cryptography
Cube roots Cubes & Spheres Payroll & Tax 2
Lorenz Equations Population Biology Football Table
Projectiles Lemonade sales Electricity Simulation
Dice    

Projects

Population    
Climate    

Worksheets

Supermarket Calories and Nutrition Public Key Cryptography
World Population Data Kepler's Third Law Economic Development
Square Roots Planetary Moons Population By Continent
Cube Roots World Population  

VBA

Part 1: Macros Part 5: Conditionals, Loops Part 9: ActiveX Controls
Part 2: Objects, Locals Part 6: Examples Part 10: User Forms
Part 3: Series & Sequences Part 7: Functions Part 11: Parcels Example
Part 4: Ranges Part 8: Toolbars, Menus  

Other Web Sites

Mark's Excel Pages

Mandelbrot

  

Back to ICT Home Page