Microsoft Excel 2016 - Part 2 - Self Assessment

Welcome to Scomis Microsoft Training.

Is this the correct level for you?
In order for us to deliver training at the correct level for all delegate abilities. Please answer the following questions honestly so that we can make sure that we book you on the correct course based on your current ability. Please note that not all the topics below are covered in the course.

Question Title

* 1. Creating Advanced Formulas
Do you know how to use range names in formulas and functions, as well as how to use specialised functions?

Yes

Not Sure

Question Title

* 2. Analysing Data with Logical and Lookup Functions
Do you know how to analyse data by using text, logical, lookup, date and financial functions?

Yes

Not Sure

Question Title

* 3. Organising and Analysing Datasets and Tables
Are you confident with how to create and modify tables, sort and filter data, use subtotal features, and work with database functions?

Yes

Not Sure

Question Title

* 4. Visualising Data with Charts
Do you know how to create charts, as well as how to modify and format existing charts, create a trend line and advanced charts?

Yes

Not Sure

Question Title

* 5. Analysing Data with PivotTables, Slicers, and Pivot Charts
Are you comfortable with creating a PivotTable, filtering data using slicers and, analysing data using Pivot Charts?

Yes

Not Sure

Question Title

* 6. Inserting Graphics
Do you know how to insert, modify, layer and group graphical objects and how to incorporate SmartArt into workbooks?

Yes

Not Sure

Question Title

* 7. Enhancing Workbooks
Do you know how to customise workbooks, manage themes and create and use templates? Do you know about protecting files and preparing a workbook for multiple audiences?

Yes

Not Sure

Question Title

* 1. Creating Advanced FormulasDo you know how to use range names in formulas and functions, as well as how to use specialised functions?

Question Title

* 2. Analysing Data with Logical and Lookup FunctionsDo you know how to analyse data by using text, logical, lookup, date and financial functions?

Question Title

* 3. Organising and Analysing Datasets and TablesAre you confident with how to create and modify tables, sort and filter data, use subtotal features, and work with database functions?

Question Title

* 4. Visualising Data with ChartsDo you know how to create charts, as well as how to modify and format existing charts, create a trend line and advanced charts?

Question Title

* 5. Analysing Data with PivotTables, Slicers, and Pivot ChartsAre you comfortable with creating a PivotTable, filtering data using slicers and, analysing data using Pivot Charts?

Question Title

* 6. Inserting GraphicsDo you know how to insert, modify, layer and group graphical objects and how to incorporate SmartArt into workbooks?

Question Title

* 7. Enhancing WorkbooksDo you know how to customise workbooks, manage themes and create and use templates? Do you know about protecting files and preparing a workbook for multiple audiences?

* 1. Creating Advanced Formulas
Do you know how to use range names in formulas and functions, as well as how to use specialised functions?

* 2. Analysing Data with Logical and Lookup Functions
Do you know how to analyse data by using text, logical, lookup, date and financial functions?

* 3. Organising and Analysing Datasets and Tables
Are you confident with how to create and modify tables, sort and filter data, use subtotal features, and work with database functions?

* 4. Visualising Data with Charts
Do you know how to create charts, as well as how to modify and format existing charts, create a trend line and advanced charts?

* 5. Analysing Data with PivotTables, Slicers, and Pivot Charts
Are you comfortable with creating a PivotTable, filtering data using slicers and, analysing data using Pivot Charts?

* 6. Inserting Graphics
Do you know how to insert, modify, layer and group graphical objects and how to incorporate SmartArt into workbooks?

* 7. Enhancing Workbooks
Do you know how to customise workbooks, manage themes and create and use templates? Do you know about protecting files and preparing a workbook for multiple audiences?