WISE OWL EXERCISES

EXCEL EXERCISES

EXCEL EXERCISES

- Creating formulae (5)
- Formatting worksheets (7)
- Basic printing (7)
- Charts (10)
- Absolute references (9)
- Range names (13)
- Conditional formulae (16)
- Conditional formatting (7)
- Basic tables (6)
- Formatting numbers and dates (3)
- Working with dates (1)
- Data validation (6)
- Protection (1)
- Advanced IFs (5)
- Lookup functions (14)
- Advanced lookup functions (9)
- Text functions (1)
- Advanced charts (4)
- Multiple worksheets (1)
- Advanced tables (2)
- Pivot tables (3)
- Advanced pivot tables (3)
- Scenarios (2)
- Data tables (2)
- Array formulae (2)
- Building models (2)
- Masking (2)
- Cashflow calculations (1)
- Investment appraisal (1)

# Free Excel exercises

This page lists 145 **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. |

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 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 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 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: | 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 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 commission using conditional formulae. |

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 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.