Enable Technology

Excel 

Excel MOS 2013




Course Overview


This course assumes no prior knowledge, introduces candidates to Excel 2013 and moves onto advanced topics within the two training days. The syllabus is mapped against the Microsoft Office Specialist (MOS) exam.

Duration: 2 day course



Course Content


Getting started 
Spreadsheet terminology 
The Excel environment 
Navigating a worksheet 
Using a template 

Entering and editing data 
Entering and editing text and values 
Entering and editing formulas 
Saving and updating workbooks 

Modifying a worksheet 
Moving and copying data 
Moving, copying, and viewing 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 

Charts 
Chart basics 
Formatting charts 

Graphics 
Working with pictures 
Conditional formatting with graphics 
SmartArt graphics

Printing 
Preparing to print 
Page Setup options 
Printing worksheets

Managing workbooks and worksheets 
Viewing large worksheets 
Printing large worksheets 
Working with multiple worksheets 
Linking worksheets with 3-D formulas 
Using multiple workbooks 
Linking workbooks 

Advanced formatting 
Using special number formats 
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 

Data structure and tables 
Sorting and filtering data 
Working with tables 

Web and sharing features 
Saving workbooks as Web pages 
Using hyperlinks 

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

Application settings and templates 
Application settings 
Working with templates

Advanced functions and formulas 
Logical functions 
Conditional functions 
Financial functions 
Text functions 
Date and time functions 
Array formulas 
Calculation options 

Lookups and data tables 
Using lookup functions 
Creating data tables 

Advanced data management 
Validating cell entries 
Advanced filtering 

Advanced charting 
Chart formatting options 
Combination charts 
Graphical objects 

PivotTables and PivotCharts 
Working with PivotTables 
Modifying PivotTable data 
Formatting PivotTables 
Using PivotCharts 
PowerPivot 

Exporting and importing data 
Exporting and importing text files 

Analytical tools 
Goal Seek 
Scenarios 
Instant data analysis 

Macros and Visual Basic 
Running and recording a macro 
Working with VBA code 

Accessibility and language features 
Accessibility considerations 
Internationalization






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;