Our practical Excel exercises are much more than just exercises! We design our exercises in such a way that they provide the user with a mapping of the Excel features that can be used in order to complete the appropriate task in the most efficient manner possible. We also reference each step in each exercise to the appropriate tutorial that needs to be studied in order to be able to complete the step.
The solutions to our comprehensive exercises are only available to customers who have purchased an Excel training package. If you have not purchased an Excel training package, we unfortunately cannot provide you with any of the solutions or assist you with any of the steps that are included in the appropriate exercise. Click here to register for an Excel training package.
This basic Excel exercise tests whether users understand how to enter & edit data on a worksheet, format cells, insert & delete rows & columns, copy & paste data, rename & delete worksheets and use a basic mathematical function.
This Excel exercise tests whether users understand how to customize the default Excel settings, customize the Quick Access Toolbar, use themes to format cells, use special paste features and how to customize & use the status bar.
This Excel exercise tests whether users understand how to link cells, copy & paste cell formulas, use relative & absolute cell references, enter formulas, insert & use Excel tables and enter & use a basic IF function.
This Excel exercise tests whether users understand how to create an Excel chart; customize the chart area, chart plot area, title, legend, axes and gridlines; insert a chart based on multiple source data cell ranges and how to use a secondary axis.
This Excel exercise tests whether users understand how to insert a pivot table, refresh a pivot table, drill down to the source data of a pivot table, change the pivot table layout and how to use pivot table slicers.
This Excel exercise tests whether users understand how to use financial functions to calculate monthly & annual loan repayment amounts, how to use the goal seek feature and how to insert a two variable data table.
This Excel exercise tests whether users can define named ranges, format dates with a custom date format, sum cells based on multiple sum criteria and use names in function arguments in order to create a monthly sales report.
This Excel exercise tests whether users can define named ranges, edit named ranges, sum cells based on criteria and use names in function arguments in order to create a daily sales report.
This Excel exercise tests whether users can define named cell ranges, insert a list box, use lookup functions, sum cells based on criteria and use wildcards in formulas in order to compile a monthly & year-to-date income statement.
This Excel exercise tests whether users can use data validation to control user input, apply conditional formatting, define named ranges and sum cells based on multiple criteria in order to compile a monthly cashbook summary.