# Free Excel exercises

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

This page lists 151 Excel exercises. You can use the menu above 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.
 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.
 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.
 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.
 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.
 Software: Excel Version: Excel 2016 and later Topic: Absolute references Level: Relatively easy Course: Excel Intermediate Exercise: Changing Sterling to Euros Using Absolute References.
 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.
 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.
 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.
 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.
 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.
 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.
 Software: Excel Version: Excel 2016 and later Topic: Excel basics Level: Relatively easy Course: Excel Introduction Exercise: Adding new data, editing and copying and changing column widths.
 Software: Excel Version: Excel 2016 and later Topic: Formatting worksheets Level: Relatively easy Course: Excel Introduction Exercise: Formatting basics.
 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.
 Software: Excel Version: Excel 2016 and later Topic: Formatting worksheets Level: Relatively easy Course: Excel Introduction Exercise: Easy formatting changes.
 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.
 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.
 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.
 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.
 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.
 Software: Excel Version: Excel 2016 and later Topic: Advanced IFs Level: Relatively easy Course: Excel Advanced Exercise: Using Nested If to Calculate Parking Charges.
 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.
 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.
 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.
 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.
 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.
 Software: Excel Version: Excel 2016 and later Topic: Basic printing Level: Relatively easy Course: Excel Introduction Exercise: Printing Summer Sale Order worksheet.
 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.
 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.
 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.
 Software: Excel Version: Excel 2016 and later Topic: Conditional formulae Level: Relatively easy Courses: Excel Business ModellingExcel Intermediate Exercise: Single IF simple to calculate engineer callout charge at 2 different rates.
 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.
 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.
 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.
 Software: Excel Version: Excel 2016 and later Topic: Conditional formulae Level: Relatively easy Courses: Excel Business ModellingExcel Intermediate Exercise: Uses single =IF.
 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.
 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.
 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.
 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.
 Software: Excel Version: Excel 2016 and later Topic: Absolute references Level: Average difficulty Course: Excel Intermediate Exercise: Calculate salesperson commission using absolute cell references.
 Software: Excel Version: Excel 2016 and later Topic: Absolute references Level: Average difficulty Course: Excel Intermediate Exercise: Price orders using absolute cell references.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 Software: Excel Version: Excel 2016 and later Topic: Advanced charts Level: Average difficulty Course: Excel Advanced Exercise: Adding stacked pictures to a chart series.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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).
 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.
 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.
 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.
 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.
 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 %.
 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.
 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.
 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.
 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.
 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.
 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.
 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 £.
 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.
 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.
 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.
 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.
 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.
 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!.
 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.
 Software: Excel Version: Excel 2016 and later Topic: Advanced lookup functions Level: Average difficulty Courses: Excel AdvancedExcel Business Modelling Exercise: Nesting =MATCH inside =VLOOKUP.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 Software: Excel Version: Excel 2016 and later Topic: Advanced IFs Level: Average difficulty Course: Excel Advanced Exercise: Uses nested =IF to calculate overdue project charges.
 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.
 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.
 Software: Excel Version: Excel 2016 and later Topic: Advanced tables Level: Average difficulty Course: Excel Advanced Exercise: Adding Subtotals to a table of data.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 Software: Excel Version: Excel 2016 and later Topic: Advanced charts Level: Average difficulty Course: Excel Advanced Exercise: Creating Scatter charts with regression trendlines.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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 !.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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 !.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 Software: Excel Version: Excel 2016 and later Topic: Advanced IFs Level: Harder than average Course: Excel Advanced Exercise: Combining nested =IF and =AND functions.
 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.

You can search our full list of Excel exercises here. Or why not learn to do them the right way on one of our classroom Excel training courses in the UK, or on one of our live online Excel courses wherever you are in the world?