Excel 2007 Level 3

Dynamic Web Training Pty Ltd.
Adelaide, Brisbane, Canberra, Melbourne, Sydney, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building and formatting simple workbooks.
Students should of already completed Excel Level 1 & 2 courses or should know how to create and save excel workbooks, create formulas, use functions and perform simple formatting of the data before doing this course.
About the course:
This course covers aspects of Microsoft Excel beyond building basic workbooks and deals with workbook automation and productivity features. It includes Advanced analysis tools, especially pivot tables, Solver, outlining and summarising and automating workbook operations using macros.

Learning outcomes:
Upon successful completion of this course, students will be able to:

* use a range of lookup and reference functions
* modify Excel options
* create and use labels and names in a workbook
* protect data in worksheets and workbooks
* summarise data using subtotals and relative range naming
* use data linking to create more efficient workbooks
* use the Data Consolidation feature to combine data from several workbooks into one
* understand and create simple PivotTables
* construct and operate PivotTables using some of the more advanced techniques
* use goal seeking to determine the values required to reach a desired result
* group cells and use outlines to manipulate the worksheet
* use Solver to solve more complex and intricate problems
* create recorded macros in Excel
* use the macro recorder to create a variety of macros

...''

Phone:1300 888 724, +61 2 9957 1366

School Address:

Level 11
32 Walker Street
North Sydney NSW 2060

Level 12
379 Collins Street
Melbourne VIC 3000

C/- Support Technology
Level 6, 371 Queen St
Brisbane QLD 4000

C/- Training Choice
Level 12, 15 London Circuit
Canberra ACT 2600

C/- Hire Intelligence
Level 4, 74 Pirie Street
Adelaide SA 5000

Jobs & Resumes: Adelaide, Brisbane, Canberra, Melbourne, Sydney
Houses & Roommates: Adelaide, Brisbane, Canberra, Melbourne, Sydney
Travel Agencies: Brisbane, Melbourne, Sydney

Search other schools for Excel 2007 Level 3 training resources.

PHP & MySQL
Advanced PHP Web Development
Advanced Website Design Using CSS
CSS Masterclass
Acrobat 8
Photoshop CS3
Illustrator CS3
InDesign CS3
Excel 2007 Level 1
Excel 2007 Level 2
Excel 2003 VBA
Word 2007 Level 1
Word 2007 Level 2
Word 2007 Level 3
Access 2003
Access 2003 VBA
PowerPoint 2003 Level 1
PowerPoint 2003 Level 2
Outlook 2007 Level 1

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.