Enable Technology

Excel 

Excel 2010 Intermediate




Course Overview


A one day intensive course covering Microsoft Excel 2010 intermediate topics.  Participants will learn a number of techniques for sorting, filtering and totalling and subtotalling data. The course covers the use of PivotTables and Tables. The use of  three dimensional formulas. How to share and merge workbooks.  Password protecting worksheets.

The course also covers advanced formatting and chart options.

The knowledge of basic Excel is required.

Duration: 1 day course



Course Content


Using multiple worksheets and workbooks
Using multiple workbooks
Linking worksheets with 3-D formulas
Linking workbooks
Managing workbooks 

Advanced formatting
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
Creating subtotals 

Cell and range names
Creating and using names
Managing names

Tables
Sorting and filtering data
Advanced filtering
Working with tables 

Web and sharing features
Saving workbooks as Web pages
Using hyperlinks
Sharing workbooks 

Advanced charting
Chart formatting options
Combination charts
Graphical elements 

Documenting and auditing
Auditing features
Comments in cells and workbooks
Protection
Workgroup collaboration 

Templates and settings
Changing application settings
Using built-in templates
Creating and managing templates 

PivotTables and PivotCharts
Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
Using PivotCharts






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.




West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;