LSN Developing the workforce - ITQ IT Skills resources contextualised for Teachers, Student Services & LRC Staff

Office Tutorials 2 - Excel

Links: Office Tutorials 2 | Access | Excel | PowerPoint | Word


Using Conditional Formatting in Microsoft Excel
This is a tutorial about how to use simple conditional formatting, as well as a Microsoft Excel spreadsheet with some advanced examples.

View   Download (3,126 KB) - zip archive


Protecting Worksheets and Changing Display Options in Microsoft Excel
A tutorial covering how to protect worksheets and modify their display settings.

View   Download (5,097 KB) - zip archive


Creating Macros and Quizzes in Microsoft Excel
This tutorial will take you through the basic steps needed to get started with macros. Including creating a quiz and recording a macro.

View   Download (17,401 KB) - zip archive


Create workspace files in Excel
A workspace file is a file that saves display information about open workbooks, so that you can later resume work with the same window sizes, print areas, screen magnification, and display settings.

View   Download (7,801 KB) - zip archive


Formatting Excel worksheets with VBA

A tutorial covering accessing the Control Toolbox, adding a Command Button to a worksheet, adding code to the Command Button and navigating between worksheet and code .

View   Download (19.342 KB) - zip archive


 

Visit www.learningtechnologies.ac.uk for other resources and details of training events.