Loughborough University
Leicestershire, UK
LE11 3TU
+44 (0)1509 263171
Loughborough University

IT Services

Excel 2007 Factsheets / Courses

Screen shot: Excel 2007.

Excel 2007 Courses

The course notes refer to documents etc. which are available in the course materials - download these, open, and select Extract to obtain several documents at once. Some courses have only one document in their materials.

If you cannot access this you are deemed to not be a member of the University (e.g. a member of an external organisation with a user id starting ou). If you believe this not to be the case, please contact our Service Desk.

Administrative Staff (in particular)

It's often difficult to get time to work on self-paced courses (compared with scheduled training courses have a set time and location). Why not book an hour or so in your diary, and do the work away from the telephone and other interruptions in one of our Computer Labs. For locations see Computer Labs on Campus Map. These are mostly available 24 hours a day / 7 days a week, except when booked for teaching - see Lab booking details.

Windows Labs run Office 2010.

Excel 2007 Courses

Excel 2007 courses
Course Course notes Course materials
E701 Getting to Know Excel Getting to Know Excel notes. Getting to Know Excel materials.
E710 Formulae and Functions Formulae notes. Formulae materials.
E715 Tables and Lookup Lookup notes. Lookup materials.
E722 Formatting with Excel Formatting notes. Formatting materials.
E727 Conditional Formatting with Excel Conditional Formatting notes. Conditional Formatting materials.
E733 Workbooks in Excel Workbooks notes. Workbooks materials.
E737 Find and Replace Find and Replace notes. Find and Replace materials.
E738 Printing and Headers & Footers Printing and Headers & Footers notes. Printing and Headers & Footers materials.
E742 Sorting and Filtering Sorting and Filtering notes. Sorting and Filtering materials.
EK745 Picture and Clip Art Images notes. Images materials.
E760 Graphs and Charts Graphs notes. Graphs materials.
EXR Regression - Line of Best Fit Regression notes. Regression materials.
E763 Setting Excel Options Options notes. n/a
E765 Validation Validation notes. Validattion materials.
E766 Protecting Data Protection notes. Protection materials.
E767 Data Consolidation Consolidation notes. Consolidation materials.
E768 Data Linking Linking notes. Linking materials.
E769 Grouping and Outlining Grouping and Outlining notes. Grouping and Outlining materials.
EK770 Scenarios Scenarios notes. Scenarios materials.
E772 PivotTables and PivotCharts PivotTables and PivotCharts notes. PivotTables and PivotCharts materials.
E775 Labels and Names Names notes. Names materials.
E776 Macros Macros notes. Macros materials.
E789 Solver Solver notes. Solver materials.
E791 Summarising Data Summarising notes. Summarising materials.
E792 Goal Seek Goal Seek notes. Goal Seek materials.
E793 Data Tables Data Tables notes. Data Tables materials.
E794 Custom Views Custom Views notes. Custom Views materials.
E795 Comments Comments notes. Comments materials.
E784 Getting Help Help notes. n/a
E790 General Computer Operation General Computer Operation notes. n/a

SmartArt Movie

SmartArt Handout

Staff Development Introduction Course

Staff Development Excel 2007 Introduction course
Course Course notes Course materials
EX01 Introduction - Staff Development Course EX01 Introduction P.D. course notes. EX01 Introduction P.D. course materials.
E760 Graphs and Charts Graphs notes. Graphs materials.
EXR Regression - Line of Best Fit Regression notes. Regression materials.

Staff Development Intermediate Course

Staff Development Excel 2007 Intermediate course
Course Course notes Course materials
E772 PivotTables and PivotCharts PivotTables and PivotCharts notes. PivotTables and PivotCharts materials.

Staff Development Advanced Course

Staff Development Excel 2007 Advanced course
Course Course notes Course materials
E800 Tables and Lookup E800 Tables and Lookup notes. E800 Tables and Lookup materials.
EX-CAA Putting it Together Putting it Together notes. Putting it Together materials.

Search

Getting Help

IT Service Desk
Tel: 01509 222333
IT.Services@lboro.ac.uk

8:30 a.m. to 5:00 p.m.
Monday to Friday.

Quick Service Availability Check

In Person Service
PC Clinic in the
Haslegrave Building
Level 0 (Ground Floor)
Monday to Friday
10:00 a.m. to 5:30 p.m.
or 11:30 a.m. to 2:30 p.m. outside term.

You can also seek help at any time via our Getting Help section.