Excel Shortcuts
Spell Check
fn + F7
Returns the sum of a supplied list of numbers
SUM (+)
Shortcuts: To open the access keys
Alt
Function: Performs a specified calculation (sum, average, max, etc...)
SUBTOTAL
This acronym refers to our time off policy at Grant Thornton.
FTO (Flexible Time Off)
To search for anything in the workbook
Adds the cells in a supplied range, that satisfy multiple criteria (New in Excel 2007)
SUMIFS
Functions: Joins together two or more text strings (Replaced by ____ function in Excel 2016)
CONCATENATE
This industry dominates the business landscape in Houston and makes up a significant percentage of our local clients.
Energy
In addition to Houston, GT has two other offices in the Texas in these two locations.
Dallas & Austin
To find and replace cell contents
Ctrl + H
Returns the absolute value
ABS
Shortcuts: Reference Lock cells when referencing other cells within a formula (ie. $I$3)
fn + F4
Shortcuts: To start a new line in a current cell.
Alt + Enter
This program is one of the primary ways we give back to the community at GT, by partnering with up-and-coming non-profit organizations.
Purple Paladin Program
To switch to the previous workbook
Ctrl + Shift + Tab
Returns a reference to a cell (or range of cells) for requested rows and columns within a supplied range
INDEX
Functions: Looks up a supplied value in the first column of a table, and returns the corresponding value from another column
VLOOKUP
Shortcuts: Enables filtering of selected cells
Ctrl + Shift + L
This culture concept represents the ability of GT employees to pursue their individual career interests and goals.
Captain Your Career
To change the view from displaying cell values to formulas
Ctrl + `(grave accent mark)
Looks up a supplied value in the first row of a table, and returns the corresponding value from another row
HLOOKUP
Functions: Tests if an initial supplied value (or expression) returns an error, and if so, returns a supplied value; Otherwise the function returns the initial value
IFERROR
The Grant Thornton culture is one of our most valuable assets, we are committed to these 6 values
CLEARR (Collaboration, Leadership, Excellence, Agility, Respect, Responsibility)
This program enables Audit Interns to participate in 2 internships at GT and have the opportunity to start with the firm as an Associate II.
Audit I2/A2 Program