Microsoft computer training exercises (page 6 of 41)

Showing exercises 101-120 (out of 813)

Category: Advanced VBA
Topic: Class modules
Level: Average difficulty
Course: Advanced VBA
Exercise: An exercise to create a game class, such that when you set the home/away team name and score, an Add method adds the result to a table.

Go to exercise ...

Category: Advanced VBA
Topic: Advanced class modules topics
Level: Harder than average
Course: Advanced VBA
Exercise: An exercise to create a Holiday class and a strongly-typed Holidays collection, and test that these work.

Go to exercise ...

Category: Advanced VBA
Topic: Linking to data
Level: Average difficulty
Course: Advanced VBA
Exercise: Create an input form for Beatles, linking Excel to Access using ADO, then read Beatles back into an array using REDIM PRESERVE.

Go to exercise ...

Category: Advanced VBA
Topic: Passing arguments
Level: Relatively easy
Course: Advanced VBA
Exercise: Create a routine to send an Outlook message. The argument list should vary according to whether you are copying the message to anyone.

Go to exercise ...

Category: Advanced VBA
Topic: Passing arguments
Level: Relatively easy
Course: Advanced VBA
Exercise: Create a couple of simple macros taking arguments - one to display a message, and one to protect or unprotect a worksheet.

Go to exercise ...

Category: Advanced VBA
Topic: Passing arguments
Level: Average difficulty
Course: Advanced VBA
Exercise: Create a function to calculate Olympic medal points - this should take 3 arguments and return a single points total.

Go to exercise ...

Category: Advanced VBA
Topic: Passing arguments
Level: Average difficulty
Course: Advanced VBA
Exercise: An exercise to add records to a database, using an optional argument for the postcode and also showing enumerations.

Go to exercise ...

Category: Advanced VBA
Topic: Passing arguments
Level: Average difficulty
Course: Advanced VBA
Exercise: Writing a program to calculate the factorial of a number without loopin, using recursive programming.

Go to exercise ...

Category: Advanced VBA
Topic: Passing arguments
Level: Harder than average
Course: Advanced VBA
Exercise: Write a macro to work out Yahoo-style breadcrumbs given a table of regions. Each region record contains the region id and name and the id of the parent region.

Go to exercise ...

Category: Advanced VBA
Topic: Working with shapes
Level: Relatively easy
Course: Advanced VBA
Exercise: Write a macro to put block arrow shapes into different cells.

Go to exercise ...

Category: Advanced VBA
Topic: Working with shapes
Level: Average difficulty
Course: Advanced VBA
Exercise: Write a macro to generate all of the autoshapes in a worksheet.

Go to exercise ...

Category: Advanced VBA
Topic: Working with shapes
Level: Harder than average
Course: Advanced VBA
Exercise: Draw car shapes using a macro, and use them to simulate a race.

Go to exercise ...

Category: Excel 2010
Topic: Formatting your work
Level: Relatively easy
Courses: Excel IntroductionAdvanced ExcelExcel Business Modelling
Exercise: Formatting - changing the appearance of your workbook before printing - telephone call stats.

Go to exercise ...

Category: Excel 2010
Topic: Formatting your work
Level: Relatively easy
Courses: Excel IntroductionAdvanced ExcelExcel Business Modelling
Exercise: Formatting - changing the appearance of your workbook before printing - credit payments.

Go to exercise ...

Category: Excel 2010
Topic: Formatting your work
Level: Relatively easy
Courses: Excel IntroductionAdvanced ExcelExcel Business Modelling
Exercise: Formatting - Changing the appearance of your workbook before printing - buying toys exercise.

Go to exercise ...

Category: Excel 2010
Topic: Formatting your work
Level: Average difficulty
Courses: Excel IntroductionAdvanced ExcelExcel Business Modelling
Exercise: A formatting exercise, making metals appear in their given colours.

Go to exercise ...

Category: Excel 2010
Topic: Formatting your work
Level: Average difficulty
Courses: Excel IntroductionAdvanced ExcelExcel Business Modelling
Exercise: An exercise to dramatically improve the formatting of some box office data.

Go to exercise ...

Category: Excel 2010
Topic: Formatting your work
Level: Average difficulty
Courses: Excel IntroductionAdvanced ExcelExcel Business Modelling
Exercise: Formatting exercise, incorporating cell-merging and muppet-colouring.

Go to exercise ...

Category: Excel 2010
Topic: Formatting your work
Level: Average difficulty
Courses: Excel IntroductionAdvanced ExcelExcel Business Modelling
Exercise: Use the formatting tools in Microsoft Excel 2007 to make your data look more professional and presentable.

Go to exercise ...

Category: Excel 2010
Topic: Basic formulae
Level: Relatively easy
Courses: Excel IntroductionAdvanced ExcelExcel Business Modelling
Exercise: Use Microsoft Excel 2007 to create simple formulae and to calculate basic statiscs about the richest people in the world.

Go to exercise ...

This page has 0 threads Add post