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 Part One 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 One of this session, you will be able to:
- Recognize the proper use of TEXT functions to manipulate text without manual editing, including LEFT(), MID(), FIND(), TRIM(), and PROPER()
- Create a PivotTable and customize by adding fields to the ROWS, COLUMNS, FILTERS, and VALUES sections in the PivotTable Fields list. Attendees will also learn how to create a Calculated Field within a PivotTable and use the Design tab to change the Report Layout of a PivotTable.