Free Excel exercises

This page lists 146 Excel exercises. You can use the menu to show just exercises for a specific topic.

Software: Excel
Version: Excel 2010 and later
Topic: Charts
Level: Relatively easy
Course: Excel Introduction
Exercise: Selecting car sales data to compare sales for men and women, using various different chart types.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Charts
Level: Relatively easy
Course: Excel Introduction
Exercise: Creating a pie chart comparing survey data, and formatting this pie chart to look presentable.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Formatting worksheets
Level: Relatively easy
Course: Excel Introduction
Exercise: Formatting - Changing the appearance of your workbook before printing - buying toys exercise.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Formatting worksheets
Level: Relatively easy
Course: Excel Introduction
Exercise: Formatting - changing the appearance of your workbook before printing - credit payments.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Formatting worksheets
Level: Relatively easy
Course: Excel Introduction
Exercise: Formatting - changing the appearance of your workbook before printing - telephone call stats.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Absolute references
Level: Relatively easy
Course: Excel Intermediate
Exercise: Changing Sterling to Euros Using Absolute References.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced charts
Level: Relatively easy
Course: Excel Advanced
Exercise: Creating sparklines in cells to report on accidents involving animals.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Absolute references
Level: Relatively easy
Course: Excel Intermediate
Exercise: Use single cell input values in Microsoft Excel 2007 by using absolute cell references in your formulae.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Range names
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use range names instead of cell references in your Microsoft Excel 2007 formulae to make your spreadsheets much easier to understand.

Go to exercise ...

Software: Excel
Version: Excel 2013 and later
Topic: Absolute references
Level: Relatively easy
Course: Excel Intermediate
Exercise: Cake Friday - uses an absolute cell to always refer to the cakes per child figure.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Creating formulae
Level: Relatively easy
Course: Excel Introduction
Exercise: Use the inbuilt functions in Microsoft Excel 2007 to calculate basic statistics from a list of data.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Advanced lookup functions
Level: Relatively easy
Courses: Excel AdvancedExcel Business Modelling
Exercise: Add an input field to an Excel 2007 model saying what sort of celebrity you are, and use this to calculate income using a lookup formula.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Pivot tables
Level: Relatively easy
Course: Excel Advanced
Exercise: Use MS Excel 2007 Pivot Tables to filter your data and generate statistics.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Data validation
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use validation settings in Microsoft Excel 2007 to control the data that users can enter into a spreadsheet.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Absolute references
Level: Relatively easy
Course: Excel Intermediate
Exercise: For a movie tickets spreadsheet use absolute cell references in formulae.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Range names
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use range names in Excel 2007 movies workbook to make calculations much easier to create and use.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formulae
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use IF functions in Microsoft Excel 2007 to rate movies as a flop or success based on their profit.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Creating formulae
Level: Relatively easy
Course: Excel Introduction
Exercise: Use Microsoft Excel 2007 to create simple formulae and to calculate basic statistics about big budget movies.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced IFs
Level: Relatively easy
Course: Excel Advanced
Exercise: Using Nested If to Calculate Parking Charges.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Creating formulae
Level: Relatively easy
Course: Excel Introduction
Exercise: Use Microsoft Excel 2007 to create simple calculations that can be quickly copied to other cells.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Range names
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use range names in a Microsoft Excel 2007 Poohsticks workbooks to make calculations easier.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Absolute references
Level: Relatively easy
Course: Excel Intermediate
Exercise: Create absolute cell references for Poohsticks data in Excel.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formulae
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use an If function in Microsoft Excel 2007 to rate the players in a game of poohsticks.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Lookup functions
Level: Relatively easy
Courses: Excel AdvancedExcel Business Modelling
Exercise: Use a Vlookup function in Microsoft Excel 2007 to categorise a list of values using Poohsticks.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Basic printing
Level: Relatively easy
Course: Excel Introduction
Exercise: Printing Summer Sale Order worksheet.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Range names
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Create easy to read Microsoft Excel 2007 spreadsheets by using range names in your formulae.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Creating formulae
Level: Relatively easy
Course: Excel Introduction
Exercise: Use Microsoft Excel 2007 to create simple formulae and to calculate basic statiscs about the richest people in the world.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formatting
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use conditional formatting in Microsoft Excel 2007 to highlight successful salespeople.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formulae
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Using If to display different size text messages.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Creating formulae
Level: Relatively easy
Course: Excel Introduction
Exercise: Use functions in Microsoft Excel to calculate basic statistics about the tallest buildings in the world.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Range names
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Create easy to read formulae in Microsoft Excel 2007 by using range names instead of cell references.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Charts
Level: Average difficulty
Course: Excel Introduction
Exercise: A more complex exercise, asking you to change virtually every part of the appearance of a chart.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Basic printing
Level: Average difficulty
Course: Excel Introduction
Exercise: Printing - changing the print settings like headers and footers - MP expenses.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Basic printing
Level: Average difficulty
Course: Excel Introduction
Exercise: Changing the print settings like headers and footers - weight loss exercise.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Multiple worksheets
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using 3D sums to calculate totals across sheets.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Absolute references
Level: Average difficulty
Course: Excel Intermediate
Exercise: Calculate salesperson commission using absolute cell references.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Absolute references
Level: Average difficulty
Course: Excel Intermediate
Exercise: Price orders using absolute cell references.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Data validation
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Apply data validation and outlining to an existing Excel 2007 business model.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Basic printing
Level: Average difficulty
Course: Excel Introduction
Exercise: Set a header, footer and print area in an Excel worksheet.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Basic printing
Level: Average difficulty
Course: Excel Introduction
Exercise: Set a print area, print titles and a header and footer for an Excel sheet.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Building models
Level: Average difficulty
Course: Excel Business Modelling
Exercise: Create an Excel 2007 model for the expenditure and income of a celebrity, using range names, styles and best practice.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Use Vlookup functions in Microsoft Excel 2007 to calculate a total labour bill for different rates.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use an If function in Microsoft Excel 2007 to calculate total values based on different charge rates.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced charts
Level: Average difficulty
Course: Excel Advanced
Exercise: Creating combination charts for data where a secondary axis is required.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Use Vlookup functions in Microsoft Excel 2007 to quickly calculate car tax bands for a list of vehicles.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Cashflow calculations
Level: Average difficulty
Course: Excel Business Modelling
Exercise: Create a cashflow statement in an Excel 2007 model from some basic input assumptions, separating deposit and loan interest.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Create database lookup functions in Microsoft Excel 2007 to return specific items from a list.

Go to exercise ...

Software: Excel
Version: Excel 2013 and later
Topic: Charts
Level: Average difficulty
Course: Excel Introduction
Exercise: Selects part of the worksheet and creates a basic Column chart that has formats applied.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Charts
Level: Average difficulty
Course: Excel Introduction
Exercise: Use MS Excel 2007 to create a Pie Chart.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced charts
Level: Average difficulty
Course: Excel Advanced
Exercise: Adding stacked pictures to a chart series.

Go to exercise ...

Software: Excel
Version: Excel 2013 and later
Topic: Absolute references
Level: Average difficulty
Course: Excel Intermediate
Exercise: Uses absolute cell references to refer to the ticket prices in the formulae.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formatting
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Using conditional formatting to highlight values according to criteria.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formatting
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Colour and format rows of data according to the values in cells.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Calculate conditional counts and sums of data using Excel functions.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Data validation
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use Microsoft Excel 2007 to provide a drop-down list within your spreadsheet. Additionally, protect the sheet against update, amendment and the viewing of sensitive data.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Masking
Level: Average difficulty
Course: Excel Business Modelling
Exercise: Use a mask in an Excel 2007 spreadsheet model to create a tax calculation which omits one specified month, when you can choose to take a tax holiday.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Working with dates
Level: Average difficulty
Course: Excel Intermediate
Exercise: Create a variety of date series, using a combination of AutoFill and date formatting.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Masking
Level: Average difficulty
Course: Excel Business Modelling
Exercise: Create a mask to turn off a revenue stream in an Excel 2007 model when a person is in jail - the start and end period for this jail term are variable.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Formatting numbers and dates
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Create a variety of number series automatically, using AutoFill.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using a Lookup Table To display a curry rating in text.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Data tables
Level: Average difficulty
Course: Excel Business Modelling
Exercise: Create a one-way data table in an Excel 2007 model to show the effect of a change in initial investment on the NPV for a project.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Data validation
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Set data validation on cells to stop invalid entries.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formatting
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use Microsoft Excel 2007 to conditionally format your dates.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Formatting numbers and dates
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use Excel functions and number formatting to enter dates.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using a VLOOKUP to display a text message (dog jacket size).

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Advanced lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Use the MATCH/INDEX functions to work out when a drawdown fee is exceeded in an Excel 2007 model.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using exact match look-ups to search on ISBN codes.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using exact match on site codes to return matching data.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Data validation
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Apply data validation and protection to an Excel 2007 model for the London Olympics.

Go to exercise ...

Software: Excel
Version: Excel 2013 and later
Topic: Charts
Level: Average difficulty
Course: Excel Introduction
Exercise: Selects all the data and creates a 3D pie chart with an exploded segment and labels with %.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using MATCH and INDEX to find Flight Times.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use an If function in Microsoft Excel 2007 to calculate a bonus based on whether targets have been met.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Formatting worksheets
Level: Average difficulty
Course: Excel Introduction
Exercise: Use the formatting tools in Microsoft Excel 2007 to make your data look more professional and presentable.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Pracises using nested =IF to decide on the fine a player gets.

Go to exercise ...

Software: Excel
Version: Excel 2013 and later
Topic: Range names
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Creates Range names and uses them in formulae.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Formatting numbers and dates
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use a custom number format to change the appearance of dates/numbers.

Go to exercise ...

Software: Excel
Version: Excel 2013 and later
Topic: Range names
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Uses a range name in the formula to calculate the holiday costs in UK £.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Use Vlookup functions in Microsoft Excel 2007 to create an enquiry system for a simple database.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Basic printing
Level: Average difficulty
Course: Excel Introduction
Exercise: Use Microsoft Excel 2007 to specify your print settings for a small amount of data, ensuring that it is suitably aligned and sized upon the page.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Calculate commission using conditional formulae.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Calculate parking fees using an IF function.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced IFs
Level: Average difficulty
Course: Excel Advanced
Exercise: Using the IF function to calculate different interest rates and messages.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Scenarios
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Creating scenarios for different input changes for an investment model.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Investment appraisal
Level: Average difficulty
Course: Excel Business Modelling
Exercise: Calculate the NPV and IRR for an investment in an Excel 2007 model, and decide if you would make it!.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formatting
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use the Conditional Formatting within Microsoft Excel 2007 to visually transform your data.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Nesting =MATCH inside =VLOOKUP.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Basic tables
Level: Average difficulty
Course: Excel Intermediate
Exercise: Filter your data in Microsoft Excel 2007 to retrieve customised results.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Building models
Level: Average difficulty
Course: Excel Business Modelling
Exercise: Create a model in Excel 2007 to forecast costs and revenue for the London Olympics, given some very basic assumptions.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Formatting worksheets
Level: Average difficulty
Course: Excel Introduction
Exercise: A formatting exercise, making metals appear in their given colours.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Data validation
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use validation and protection settings in Microsoft Excel 2007 to create a robust spreadsheet model.

Go to exercise ...

Software: Excel
Version: Excel 2013 and later
Topic: Range names
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Creates 3 range names and uses them to calculate the revenue, costs and profit.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Formatting worksheets
Level: Average difficulty
Course: Excel Introduction
Exercise: Formatting exercise, incorporating cell-merging and muppet-colouring.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using MATCH in an Exact Match Lookup.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Charts
Level: Average difficulty
Course: Excel Introduction
Exercise: Use the Charting Tools in Microsoft Excel 2007 to convert a selection of your data into a customised chart.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced pivot tables
Level: Average difficulty
Course: Excel Advanced
Exercise: Creating frequency pivot tables and using the show values as options.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced tables
Level: Average difficulty
Course: Excel Advanced
Exercise: Adding Subtotals to a table of data.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced pivot tables
Level: Average difficulty
Course: Excel Advanced
Exercise: Using Slicers, Timelines and Report Filter pages in Pivot tables.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Pivot tables
Level: Average difficulty
Course: Excel Advanced
Exercise: Creating a pivot table to analyse the results of a house search.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Protection
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use Excel protection to stop people accidentally overwriting cells.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Range names
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Calculate part time pay rates using range names in Excel.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Range names
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Creating range names for input cells.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Pivot tables
Level: Average difficulty
Course: Excel Advanced
Exercise: Use Microsoft Excel to generate useful statistics from Pivot Tables.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Basic tables
Level: Average difficulty
Course: Excel Intermediate
Exercise: Use Tables in Microsoft Excel 2007 to filter large amounts of data to retrieve specific information.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Basic tables
Level: Average difficulty
Course: Excel Intermediate
Exercise: Use the Custom Sort Tool in a Microsoft Excel 2007 Table to rearrange a large table of data into a more user-friendly view.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formatting
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use Microsoft Excel 2007 to conditionally format your data.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced charts
Level: Average difficulty
Course: Excel Advanced
Exercise: Creating Scatter charts with regression trendlines.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formatting
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use the updated Conditinal Formatting features of MS Excel 2007 to apply a Traffic Light Scheme to your Sales Reps Percentages.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Scenarios
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Create 3 scenarios for an investment appraisal Excel 2007 spreadsheet, and create a summary showing the NPV/IRR for each.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: If functions to calculate different order discounts.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Using IF to calculate different voucher rates.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Using If to Calculate different parking charges.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Basic tables
Level: Average difficulty
Course: Excel Intermediate
Exercise: Sort a list of courses by level, time and cost, then filter them.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Basic tables
Level: Average difficulty
Course: Excel Intermediate
Exercise: Sort and filter a table of data in Excel.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using lookup formulae to calculate staff bonuses.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced IFs
Level: Average difficulty
Course: Excel Advanced
Exercise: Nested IF calculates different % for staff bonuses as well as a text message.

Go to exercise ...

Software: Excel
Version: Excel 2013 and later
Topic: Absolute references
Level: Average difficulty
Course: Excel Intermediate
Exercise: Uses absolute cell references to calculate store bonuses.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Basic printing
Level: Average difficulty
Course: Excel Introduction
Exercise: Transform the way your Printouts appear using Microsoft Excel 2007. This exercise will ensure you never come back from the printer with those extra few sheets that you did not anticipate !.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Text functions
Level: Average difficulty
Course: Excel Advanced
Exercise: Using various text functions in Excel to parse film names.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Formatting worksheets
Level: Average difficulty
Course: Excel Introduction
Exercise: An exercise to dramatically improve the formatting of some box office data.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced IFs
Level: Average difficulty
Course: Excel Advanced
Exercise: Using a nested =IF function to calculate different discounts.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using a lookup table to calculate different discounts.

Go to exercise ...

Software: Excel
Version: Excel 2013 and later
Topic: Charts
Level: Average difficulty
Course: Excel Introduction
Exercise: Selects all the data and creates a line chart which has to be formatted to display time across X axis.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use an If function in Microsoft Excel 2007 to calculate different order totals based on the quantity of items ordered.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Use a vlookup function in Microsoft Excel 2007 to calculate unit costs based on order quantities.

Go to exercise ...

Software: Excel
Version: Excel 2013 and later
Topic: Range names
Level: Harder than average
Courses: Excel Business ModellingExcel Intermediate
Exercise: Creates range names for the archery scoring and uses them in the formula.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formulae
Level: Harder than average
Courses: Excel Business ModellingExcel Intermediate
Exercise: Using =IF and Concatenation to display different text messages.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Advanced lookup functions
Level: Harder than average
Courses: Excel AdvancedExcel Business Modelling
Exercise: Show a cash position at the end of every second month for an Excel 2007 model in 3 different ways, using INDEX, OFFSET and INDIRECT.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Array formulae
Level: Harder than average
Course: Excel Business Modelling
Exercise: Using an array function in an Excel 2007 workbook to multiply matrices.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Charts
Level: Harder than average
Course: Excel Introduction
Exercise: Create a Line Chart in Microsoft Excel 2007 to reflect fluctuations in a variable over a period of time.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Basic tables
Level: Harder than average
Course: Excel Intermediate
Exercise: Filter a Microsoft Excel 2007 Table to obtain specific information.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Basic printing
Level: Harder than average
Course: Excel Introduction
Exercise: Insert your own Page Breaks in Microsoft Excel 2007. No need to go to Page Break Preview, as you can add them in Normal View now !.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Advanced lookup functions
Level: Harder than average
Courses: Excel AdvancedExcel Business Modelling
Exercise: Use the INDIRECT function in an Excel 2007 model to allow a user to specify a line item and show its total.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Array formulae
Level: Harder than average
Course: Excel Business Modelling
Exercise: Understanding how range names work with multiple sheets in Excel 2007, using array formulae and other titbits.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Lookup functions
Level: Harder than average
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using an exact match lookup and HLOOKUP with music exam data.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Charts
Level: Harder than average
Course: Excel Introduction
Exercise: Use the charting tools in Microsoft Excel 2007 to give a graphical representation of some Population statistics.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced tables
Level: Harder than average
Course: Excel Advanced
Exercise: Using Advanced Filters in Tables with multiple criteria and extract ranges.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced pivot tables
Level: Harder than average
Course: Excel Advanced
Exercise: Use grouping to create a whole new group in a pivot table.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formulae
Level: Harder than average
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use a nested If function in Microsoft Excel 2007 to translate codes into full text descriptions.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Range names
Level: Harder than average
Courses: Excel Business ModellingExcel Intermediate
Exercise: Calculate ticket prices bands using range names in Excel.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Range names
Level: Harder than average
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use range names instead of absolute references in Microsoft Excel 2007 to make creating formulae easier.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Advanced lookup functions
Level: Harder than average
Courses: Excel AdvancedExcel Business Modelling
Exercise: When a user looks up a month and week number in an Excel 2007 spreadsheet, show the corresponding value by using MATCH and INDEX.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formulae
Level: Harder than average
Courses: Excel Business ModellingExcel Intermediate
Exercise: Create nested If functions in Microsoft Excel 2007 to categorise lists of data.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Lookup functions
Level: Harder than average
Courses: Excel AdvancedExcel Business Modelling
Exercise: Use a Vlookup function in Microsoft Excel 2007 to categorise a list of values - Teletubbies.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Data tables
Level: Harder than average
Course: Excel Business Modelling
Exercise: Create a two-way data table in an Excel 2007 model, comparing the NPV for an investment for different discount rates and different initial outlays.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Advanced IFs
Level: Harder than average
Course: Excel Advanced
Exercise: Combining nested =IF and =AND functions.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Advanced lookup functions
Level: Harder than average
Courses: Excel AdvancedExcel Business Modelling
Exercise: Create INDEX array functions to show rows and columns from a table for a choice of row/column.

Go to exercise ...

You can search our full list of Excel exercises here.

This page has 0 threads Add post