The Essentials
Undo
Ctrl + Z
Select all data in a region
Ctrl + A
Save Workbook
Ctrl + S
This shortcut runs an Alteryx Workflow
Ctrl + r
Paste Special
Ctrl + Alt + V
Cut
Ctrl + X
Select Entire Row
Shift + Space
True or False:
There is an automation in Digital Lab that allows you to choose 2 excel workbooks and gives you a summary of all the differences between 2 workbooks. great for version control!
True
How do you apply Currency Format?
Ctrl + Shift + 4
Select Direct Precedents or Dependents.
Takes to you to linked cells
Ctrl + [ OR
Ctril + ]
Go to first cell in workbook
Ctrl + Home
True or False:
There are currently no ASM&T approved automations for C1 Provision audits. All automations used must by engagement leads and used when appropriate. Ultimate responsibility falls on the engagement teams.
FALSE! all the automations in the C1 Provision audit Collection in Digital Lab have been approved for use on C1!
Move to the end of a data region
Ctrl + Arrow key
Open Cell Formatting Options
Control + 1
Sum the Selected cells
Alt + =
True or False:
UiPath is best used for manual processes that are very complex and have a lot of variability.
False:
You can quickly create a bot in UiPath for small tasks that are highly repetitive.
This Shortcut adds a filter to your selected dataset
Ctrl + Shift + L
Insert new Worksheet
Shift + f11
Open Visual Basic
Alt + f11
FINAL JEOPARDY QUESTION:
How many hours were automated out of the provision season last year for 12/31 YE clients? Closest answer wins.
944 Hours!