FP&A professionals spend 70-80% of their time doing painful, manual work. Vareto pulls in data directly from your ERP, CRM, and more to automate your reporting processes, such as budget vs. actuals reporting, reducing human error and giving you time to do more impactful analysis. We’ve seen strategic finance professionals save 40 hours per person per month.
When you don’t have Vareto, you can use these keyboard shortcuts for FP&A professionals to work more efficiently and effectively in Excel:
- F9: Calculate the active worksheet
- F12: Save as
- Ctrl + Shift + F: Open the "Format Cells" dialog box
- Ctrl + Shift + P: Insert a new page break
- Ctrl + Shift + N: Create a new workbook
- Ctrl + Shift + B: Toggle the display of the Formula bar
- Ctrl + Shift + M: Enter a comment for the selected cell
- Ctrl + Shift + H: Apply the "General" number format to the selected cells
- Ctrl + Shift + G: Display the "Go To" dialog box
- Ctrl + Shift + O: Select all cells with comments
- Ctrl + Shift + R: Fill the selected cells with contents of the leftmost cell in the selection
- Ctrl + Shift + U: Expand or collapse the formula bar
- Ctrl + Shift + W: Close the current workbook
- Ctrl + Shift + Y: Repeat the last command or action
- Ctrl + Shift + Z: Redo the last action
- Ctrl + Alt + 1: Apply the "Comma Style" number format to the selected cells
- Ctrl + Alt + 2: Apply the "Time" format to the selected cells
- Ctrl + Alt + 3: Apply the "Date" format to the selected cells
- Ctrl + Alt + 4: Apply the "Currency" format to the selected cells
- Ctrl + Alt + 5: Apply the "Percentage" format to the selected cells
- Ctrl + Alt + 6: Apply the "Scientific" format to the selected cells
- Ctrl + Alt + 9: Hide the selected rows
- Ctrl + Alt + 0: Hide the selected columns
- Ctrl + Alt + -: Delete the selected cells
- Ctrl + Alt + +: Insert a new row or column
- Alt + F10: Display the "Menu" key (which can be used as an alternative to right-clicking)
