Microsoft Excel Training
Microsoft Excel is a spreadsheet application used for storing, organizing and manipulating data.
Our standard course outline for this course is shown below, however, we are able to adapt the contents to suit your specific needs as required.
Please contact us for more details
Enquire about Microsoft Excel »Introductory Level
- Introduction to Microsoft Excel
- What Is Excel?
- Excel File Types
- Excel Environment
- Toolbars
- Office Assistant
- Workbooks and Worksheets
- Creating And Opening Workbooks
- Working With Workbooks
- Working With Worksheets
- Working With Cells
- Navigating Within A Worksheet
- Navigating The Workbook
- Spreadsheet Data
- Entering Data
- Using Time Saving Features
- Checking The Spelling
- Formatting and Customising Data
- Selecting Items In Excel
- Formatting Text
- Formatting Numbers
- Manipulating Data
- Formatting Columns And Rows
- Formatting With Colours And Patterns
- Adding And Editing Borders
- Using Autoformat
- Editing Spreadsheets
- Cutting, Copying, And Pasting
- Inserting And Deleting
- Using Find And Replace
- Using Undo And Redo
- Formulas and Functions
- Entering Formulas
- Entering Functions
- Using Named Cells And Ranges In Formulas
- Printing
- Using Page Setup
- Margins
- Headers And Footers
- Printing A Spreadsheet
Intermediate Level
- Viewing Worksheets
- Customising View Options
- Displaying And Customising Toolbars
- Hiding Workbooks And Worksheets
- Freezing Panes
- Grouping And Ungrouping Worksheets
- More Formatting Techniques
- Using Styles
- Conditional Formatting
- Using The Format Painter
- Using Guidelines
- Hiding And Displaying Cells
- More Formulas and Functions
- Using The Series Command
- Using The Insert Function Wizard
- Using The Excel Function Categories
- Correcting Formulas
- Using The Formula Error Checker
- Using The Formula Auditing Toolbar
- Using The Watch Window
- Database and List Management
- Using Databases
- Creating And Editing A Database
- Sorting A Database
- Using Autofilters
- Advanced Filters
- Working With Filtered Data
- Using Data Forms
- Charts
- Chart Wizard
- Chart Toolbar
- Working With Charts
- Formatting The Chart
- Drawing and Picture Objects
- Drawing Toolbar
- Working With Autoshapes
- Creating Text Boxes
- Adding Pictures
- Layering Objects
- Grouping And Ungrouping Objects
- Excel 2003/2007/2010 and Other Applications
- Converting Files From Other Applications
- Copying Data From Another Application
- Embedding And Linking Objects
- Hyperlinks
- Managing Links
Advanced Level
- Importing Data
- Importing Data From External Sources
- Importing Text Files
- Using Microsoft Query
- Querying Data From The Web
- Refreshing Data
- Templates and Styles
- Working With Templates
- Working With Styles
- Analysing Data
- What-If Analysis
- Goal Seek
- Data Tables
- Scenario Manager
- Solver
- Using Pivot Tables
- Using VLookup
- Macros and Custom Controls
- Working With Macros
- Running Macros
- Adding Custom Controls
- Security and Proofing
- Security Features
- Protecting Excel Files
- Worksheet Protection
- Working With Digital Signatures
- Checking Spelling
- Using Data Validation
- Using Text To Speech
- Documentation
- Customising Excel 2003/2007
- Configuring Excel 2003/2007 Options
- Customising The Excel Environment
- Working With Workspaces
- Collaboration and Consolidation
- Sharing Workbooks
- Sending Workbooks
- Consolidation