Further improve your Microsoft Office skills by exploring more advanced topics in Word, Excel and Access. Avoid outsourcing projects such as newsletter and custom report programming and complete them using Microsoft office's tools.
Microsoft Word's built in templates can help you create professional newsletters and web pages.
Using Microsoft Word learn to:
- Create newsletters that can be easily updated monthly, quarterly, etc.
- Create web pages
- Create forms and master documents
- Create macros to automate your work
Microsoft Excel has advanced features that can help you create even the most complex spreadsheet models.
Using Microsoft Excel learn to:
- Create 3-D workbooks and link Excel files
- Manage data better and more efficiently
- Manage worksheets that contain databases
- Create formulas using the financial functions
- Track spreadsheet data using scenarios
- Write macros to automate repetitive tasks
Microsoft Access can help you retrieve information without duplication.
Using Microsoft Access learn to:
- Create relational databases
- Create queries, forms and reports that use relational databases
- Design forms with sub-forms and create queries that combine data from multiple tables
- Create macros and VBA applications to improve data entry and to automate tasks
- Use VBA to create message and input boxes
- Use VBA to create conditional and looping statements.
Create your own custom projects in this course.
Prerequisites
This course is a continuation of the
Microsoft Office for Beginners course. Students should have completed this course or be familiar with the topics covered in the course.
Requirements
Students will need a copy of Office 2007.
A trial version is available.