Excel Skills TestTake our quick skills test to discover your current level and find the right course for you. Section 1 - Excel Skills Beginner QuestionsCan you open Excel, create a new workbook, and save it to your computer?(Required) Yes No Do you know how to add a new row or column to an existing worksheet?(Required) Yes No Can you copy and paste data or formulas from one cell to another?(Required) Yes No Do you know how to change the format of a cell (for example, from number to date or text)?(Required) Yes No Can you wrap text or merge cells to make a heading across columns?(Required) Yes No Do you know how to total or average a list of numbers using a simple formula?(Required) Yes No Can you sort or filter data by column (for example, by date, name, or amount)?(Required) Yes No HiddenSection 1 Calculation We recommend you book into the Excel Beginner Course – Learn the basics of navigation, data entry, formulas, and charts. Learn More Section 2 - Excel Skills Intermediate QuestionsHave you created a simple chart to display information visually, such as a column or bar chart?(Required) Yes No Do you know how to apply colour rules or conditional formatting to highlight important data?(Required) Yes No Can you link data from one sheet to another or use formulas like SUM or AVERAGE across sheets?(Required) Yes No Have you used formulas like IF, VLOOKUP, or INDEX-MATCH to find or calculate data?(Required) Yes No Do you know how to use data validation to control what users can type into a cell?(Required) Yes No Have you used PivotTables or PivotCharts to summarise large amounts of data?(Required) Yes No Do you know how to combine data from more than one workbook or sheet for reporting?(Required) Yes No HiddenSection 2 Calculation We recommend you book into the Excel Intermediate Course – Perfect for users who understand the basics and want to build confidence with formulas, PivotTables, and reports. Learn More Section 3 - Excel Advanced CourseHave you used tools like Goal Seek or Scenario Manager to test “what-if” situations?(Required) Yes No Can you use Excel to create forecasts or financial models based on existing data?(Required) Yes No Have you recorded or used a macro to automate repetitive tasks?(Required) Yes No Do you know how to edit a macro or assign it to a button?(Required) Yes No Have you used Power Query or Power Pivot to clean, transform, or analyse data?(Required) Yes No Have you built dashboards or reports that include interactive charts or slicers for analysis?(Required) Yes No HiddenSection 3 Calculation We recommend you book into the Excel Advanced Course – Ideal for users ready to explore automation, data modelling, and advanced analysis tools. Learn More You’ve already mastered Excel – we currently don’t offer a course beyond your skill level. Explore Other Courses 16006