Home
About Us
Services
Training Calendar
Training Materials
FAQ's
Contact Us
×
Submission Preview
…
…
Excel Proficiency Test
Kindly Tick Appropriately
Formula Referencing
I understand relative, absolute and mixed cell addressing in formulas
*
Yes
No
May Be
I know how to create mixed references
*
Yes
No
May Be
Logical Functions
I know how to use IF to calculate values
*
Yes
No
May Be
I know how to nest IF functions
*
Yes
No
May Be
I know how to use IFERROR
*
Yes
No
May Be
I know how to use TRUE and FALSE
*
Yes
No
May Be
I know how to use the AND function
*
Yes
No
May Be
I know how to use the OR function
*
Yes
No
May Be
I know how to use the NOT function
*
Yes
No
May Be
Lookup Functions
I know how to use CHOOSE
*
Yes
No
May Be
I know how to use VLOOKUP
*
Yes
No
May Be
I know how to use HLOOKUP
*
Yes
No
May Be
I know how to use the INDEX function
*
Yes
No
May Be
I know how to use MATCH
*
Yes
No
May Be
Reference functions
I know how to use ADDRESS
*
Yes
No
May Be
I know how to use INDIRECT
*
Yes
No
May Be
I know how to use OFFSET
*
Yes
No
May Be
Data Consolidation and Analysis
I understand how to create work with PivotTable
*
Yes
No
May Be
I know how to work with Power Pivot
*
Yes
No
May Be
I can use Power Query for obtaining and transforming data
*
Yes
No
May Be
I know how to access the Excel Analysis ToolPack
*
Yes
No
May Be
I am proficient in Financial/ Data Modeling
*
Yes
No
May Be
I know how to prepare Excel Dashboards
*
Yes
No
May Be
I can use Power BI for Analytics & Data Visualization
*
Yes
No
May Be
Data Tables
I know how to use a simple what-if model
*
Yes
No
May Be
I know how to use one-variable data tables
*
Yes
No
May Be
I know how to create a two-variable data table
*
Yes
No
May Be
Working With Macros
I know how to record a Macro
*
Yes
No
May Be
I know how to run a Macro
*
Yes
No
May Be
I know how to edit a Macro
*
Yes
No
May Be
Excel Camera
I know how to access the Excel camera
*
Yes
No
May Be
I know how to use the Excel camera
*
Yes
No
May Be
Data Storytelling
I understand the elements of data storytelling
*
Yes
No
May Be
I can effectively use data storytelling to convey insights
*
Yes
No
May Be
Name
*
Position
*
Email
*
Which aspects of would you be mostly interested in?
1.
2.
3.
4.
5.
PREV
NEXT
PREVIEW
RESET
SUBMIT
About Us
Our Services
Training Calendar
Training Materials
Contact Us
Excelpro
Address:
St George's House, 4th Flr Parliament Road
Email:
training@excelpro.co.ke
Phone:
+254 721 793 599
Home
About Us
Services
Training Calendar
Training Materials
FAQ's
Contact Us