Advanced Tips & Tricks in Excel 2003. This seminar teaches individuals to use advanced function formulas such as IF, ROUND, ROUNDUP, LOOKUP, VLOOKUP, HLOOKUp and the LOOKUP wizard. You will also learn to create, modify, and format pivot table reports and charts, and record and run macros to automate repetitive tasks. Additional topics include auditing worksheets and workbooks, creating styles and templates, protecting worksheets and workbooks, and incorporating custom number formats. Tips & Tricks in Excel 2003 and Intermediate Tips & Tricks in Excel 2003 are the recommended prerequisites.
[Back to Form]