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. Automating Worksheet Functionality
Do you know how to update worksheet properties, create and edit a macro, apply conditional formatting, and add data validation criteria to a workbook?

Question Title

* 2. Auditing Worksheets
Do you know how to trace cells, troubleshoot invalid data and formula errors, watch and evaluate formulas, and create a data list online?

Question Title

* 3. Analysing and Presenting Data
Are you confident with how to create Sparklines, create scenarios, perform a what-if analysis, perform statistical analysis with the Analysis Tool Pack, and create interactive data with Power View?

Question Title

* 4. Working with Multiple Workbooks
Do you know how to consolidate data, link cells in different workbooks, and merge workbooks?

Question Title

* 5. Exporting Excel Data
Are you comfortable how to export Excel data, import a delimited text file, integrate Excel data with the web, and create a web query?

Question Title

* 6. Importing and Exporting XML Data
Do you know how to import and export XML data?

 
 50% of survey complete.
( Privacy & Cookie Notice

T