Outsourced e-Learning, south african content, course development

Excel 2007

Course Information:

Course Duration:	8 h	Supplier
Main Audience:	General Staff
Other Audiences:	-
Credit Cost: *	10
NQF Alignment:	No
NQF Level (approx)	3-5 (What is this?)

Course Details:

Microsoft’s Excel 2007 is a powerful spreadsheet program used predominantly to manage numerical data - organising it in a logical way, automatically calculating figures, graphically representing this information and a host of other functions. This has uses in business in such circumstances as preparing budgets, analysing trends, summarising results, assisting with common calculations and even as a database for storing information.

Excel 2007 expands on the power the previous release of the software brought to spreadsheeting. Incorporating the new Ribbon navigation feature, standard across the Office 2007 range of software, Excel 2007 can be daunting to both new and existing users of Excel.

This course on Excel gets learners well acquainted with the software and will be appreciated by both those with no experience of Excel and those wanting to expand on their existing knowledge. The course covers a huge range of practical skills and a full list of the course’s lessons together with the topics covered in each lesson is provided to learners so that they may focus their attention on those areas of greatest need.

The course’s author follows an extremely methodical approach and uses and creates working Excel files that are made available to learners to practice as they learn.

Learning Outcomes :

Features new to Excel in the 2007 release
How to work within the ribbon - the new navigation standard across all Office 2007 products
How to access the help functions of Excel
Basic editing of data in Excel including using the Paste Special command
Basic formatting of data in Excel including number formats, conditional formatting and the application of styles and themes
How to populate a spreadsheet with import data from an external file
Managing multiple worksheets
Printing and editing print settings
Using the Autofill feature to make your Excel work more efficient
Working with the many view options in Excel including Split Screen and Freeze Pane
Using common formulae and functions including creating nested functions
Using relative and absolute cell referencing and linking between different worksheets and workbooks
Formula error checking and troubleshooting
Working with tables to display data logically
Using data validation to limit types of data entry
Creating, editing, formatting and inserting charts and images
Using Excel output in other Office suite products such as Word and Powerpoint
Creating and applying worksheet and chart templates
Extracting information from databases for use in Excel

* Excludes official 3rd party assessment costs for qualifications

Go Back

Find out more
Related Topics: + Become a Courseware Provider + See a List of Our Partners + Our Outsourced e-Learning Service + Frequently Asked Questions + Read the Bridgewater Learning Blog >> LOGIN to Bridgewater Learning Contact us for more Information