Excel 2007 Intermediate
A one day course covering Microsoft Excel 2007 intermediate topics. Participants will learn a number of techniques for sorting, filtering and totalling and subtotalling data. How to use three dimensional formulas. Sharing and merging workbooks. How to password worksheets.
The course also covers advanced formatting and chart options.
The knowledge of basic Excel 2007 is required.
Duration: 1 day course
Using multiple worksheets and workbooks
Using multiple workbooks
Linking worksheets with 3-D formulas
Using special number formats
Using functions to format text
Working with styles
Working with themes
Other advanced formatting
Outlining and subtotals
Outlining and consolidating data
Cell and range names
Creating and using names
Lists and tables
Sorting and filtering lists
Working with tables
Web and Internet features
Saving workbooks as Web pages
Chart formatting options
Documenting and auditing
Comments in cells and workbooks
Templates and settings
Creating and managing templates
Email us about this courses Telephone on 01952 305730
Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.