Excel
Word
Outlook
Systems
100

It allows you to keep certain rows or/and columns visible when scrolling across the worksheet.

Freeze Pane

100

This keyboard shortcut will allow you to copy and paste.

What is CTRL+C and CTRL+V?

100

This button in Outlook allows one to include all contacts within the email in a reply message.

What is Reply All?

100

A system where you can view patient's account and the expected reimbursement.

What is PIC?

200

This tool allows you to duplicate all the formatting edits of one cell into another cell.

What is Format paint/painter

200

This keyboard shortcut will allow you to redo an action

What is CTRL + Y?

200

It is a way to convey your professionalism to your readers and give them the information they need to contact you.

What is Signature?

200

This Optum system allows you to send tasks, view and use hold or finish codes to post notes for an account.

What is eFR?

300

This allows you to create a new line of text within a cell.

Alt + enter

300

This keyboard shortcut will allow you to insert a hyperlink

What is CTRL + K?

300

Field in which you can specify people who will receive the email secretly.

What is BCC?

300

A system where you can change/update patient's and insurance information.

What is a host system?

400

It is a built-in Excel function that helps you look for a specified value by searching for it vertically across the sheet.

What is VLookUp

400

This keyboard shortcut can change the text from uppercase to lowercase or a capital letter at the beginning of a word.

What is Shift + F3?

400

This will help you organize your incoming email messages, and receive updates when items are added, changed or removed.

What is Rules and Alerts function for?

400

A billing system where you can copy, validate and bill a claim.

What is Claims Administrator?

500

It is an interactive way to quickly summarize large amounts of data. You can use this to analyze numerical data in detail, and answer unanticipated question about your data.

What is Pivot?

500

It is a series of commands and instructions that you group together as a single command to accomplish a task automatically. You can create this thru recording.

What is Macro?

500

This tool allows you to automate common or repetitive tasks or actions to email messages. Such as shortcut to create a team email one would send out each week.

What is Quick Steps?

500

A web based system where we do our reviews and rebuttals. We also have a view of our QA metrics/dashboard in this system.

What is EQT?