Microsoft Office Courses
Microsoft Office Excel (2007 and 2010)
Microsoft Excel courses at the NPTC IT Academy are designed to help candidates produce professional looking charts by using a variety of tools and features within Microsoft Excel, whether it is creating a table or writing a formula.
Microsoft Office Excel is a powerful tool you can use to create and format spreadsheets, and analyse and share information to make more informed decisions.
Excel enables you to share a spreadsheet and with Excel Services; you can navigate, sort, filter, input parameters and interact with PivotTables, which can be viewed directly on the Web browser.
The MS Excel courses at the IT Academy are available at three levels: Introduction, Intermediate and Advanced for Microsoft Excel 2007 and 2010.
All Microsoft Excel courses at the IT Academy lead to the Microsoft Office Specialist (MOS) certification for Microsoft Access.
Introduction - £95
Intermediate - £105
Advanced - £125
Microsoft Office Specialist Exam (MOS) - £65
Special Offer Bundle - Save £40 (Introduction, Intermediate, Advanced plus exam) - £350
MOS Qualification Fast Track - 2 Day Workshop plus exam - £340
- Level 1
- Level 2
- Level 3
Introduction Level
Getting started
Spreadsheet terminology
Exploring the Excel window
Getting help
Navigating workbooks
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
Using functions
Entering functions
AutoSum
Other useful functions
Formatting worksheets
Formatting text
Formatting rows and columns
Formatting numbers
Conditional formatting
Copying formats and applying table formats
Printing
Preparing to print
Page Setup options
Printing worksheets
Creating charts
Chart basics
Modifying charts
Printing charts
Managing large workbooks
Viewing large worksheets
Printing large worksheets
Using multiple worksheets
Intermediate Level
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
Lists and tables
Examining lists
Sorting and filtering lists
Advanced filtering
Working with tables
Web and Internet features
Saving workbooks as Web pages
Using hyperlinks
Distributing workbooks
Advanced charting
Chart formatting options
Combination charts
Graphic elements
Documenting and auditing
Auditing features
Comments in cells and workbooks
Protection
Workgroup collaboration
Templates and settings
Application settings
Built-in templates
Creating and managing templates
Advanced Level
Advanced functions
Logical functions
Math and statistical functions
Financial functions
Displaying and printing formulas
Lookups and data tables
Using lookup functions
Using MATCH and INDEX
Creating data tables
Advanced list management
Validating cell entries
Exploring database functions
PivotTables and PivotCharts
Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
PivotCharts
Exporting and importing
Exporting and importing text files
Exporting and importing XML data
Querying external databases
Analytical options
Goal Seek and Solver
The Analysis ToolPak
Scenarios
Views
Macros and custom functions
Running and recording a macro
Working with VBA code
Creating functions
Conditional formatting and SmartArt
Conditional formatting with graphics
SmartArt graphics
