Become EXCEL-lent: Excel Tips & Tricks for Accountants Part 2
Have you seen that Excel hotshot in the office using fancy PivotTables and VLOOKUPs? If so, you know the power of what Excel can do and the hours of time it can save you everyday.
Join “Chief Excel Officer” Jim Cline for the Part Two conclusion of a two-part session featuring time-saving Excel tips and tricks for accounting professionals allowing you to better organize and understand your data quicker and easier.
In Part Two of this session, you will be able to:
- Recognize the proper use of LOGICAL and LOOKUP functions, including IF(), VLOOKUP(), LOOKUP(), and SUMIF()
- Identify the steps to next formulas and functions within formulas
- Find the Excel Options dialog box to display the DEVELOPER tab
- Choose and format the SPIN form control