Enable Technology

Excel 

Excel MOS 2010




Course Overview


This course assumes no prior knowledge, introduces candidates to Excel 2010 and moves onto advanced topics within the two training days. The syllabus is mapped against the Microsoft Office Specialist (MOS) qualification and gives a detailed overview of the Excel 2010 application.

Duration: 2 day course



Course Content


Getting started
Spreadsheet terminology
The Excel environment
Getting help navigating a worksheet 

Entering and editing data
Entering and editing text and values
Entering and editing formulas
Working with pictures
Saving and updating workbooks 

Modifying a worksheet
Moving and copying data
Moving and copying formulas
Absolute and relative references
Inserting and deleting ranges, rows, and columns

Functions
Entering functions
AutoSum
Other common functions
 
Formatting
Text formatting
Row and column formatting
Number formatting
Conditional formatting
Additional formatting options
 
Printing
Preparing to print
Page Setup options
Printing worksheets 

Charts
Chart basics
Formatting charts

Managing large workbooks
Viewing large worksheets
Printing large worksheets
Working with multiple worksheets

Graphics and screenshots
Conditional formatting with graphics
SmartArt graphics
Screenshots
Graphics and screenshots

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

Logical and statistical functions
Logical functions
Math and statistical functions 

Financial and date functions
Financial functions
Date and time functions
Array formulas
Displaying and printing formulas 

Lookups and data tables
Using lookup functions
Using MATCH and INDEX
Creating data tables 

Advanced data management
Validating cell entries
Exploring database functions 

Exporting and importing
Exporting and importing text files
Exporting and importing XML data
Getting external data 

Analytical tools
Goal Seek and Solver
The Analysis ToolPak
Scenarios 

Macros and custom functions
Running and recording a macro
Working with VBA code
Creating functions






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;