I am a certified Microsoft Office instructor. Microsoft Access is a relational database that is primarily used to store and retrieve information.
After taking this course you should be able to:
*Create and design an Access database
*Working with Access tables, relationships, keys and constraints
*Query a database
*Manage and design interfaces to the database using Access Forms
*Create professional looking Access Reports
*Automate tasks with Macros and VBA
This course is designed for students at different skill levels. Whether you wish to learn the basic operations of the Microsoft Access database program to perform your day-to-day responsibilities or you want to use the application to be more productive at work, taking this course will get you there by providing you with the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications.
For those with a higher level of proficiency, whose job responsibilities include working with heavily related tables, a component of this course teaches you how to create advanced queries, forms, and reports, write macros to automate common tasks, and performing general database maintenance.
Interested in how to deploy a relational database such as Access in a client-server environment? There is an administrative level component of the course that may pique your interest.
Excel is a spreadsheet application that is primarily designed to perform calculations or data analysis. There are various topics that can be covered depending on your level of proficiency.
*Getting Started with Excel
*Performing Calculations in an Excel Worksheet
*Modifying an Excel Worksheet
*Modifying the Appearance of a Worksheet
*Managing an Excel Workbook
*Printing Excel Workbooks
*Calculating Data with Advanced Formulas
*Organizing Worksheet and Table Data
*Presenting Data Using Charts
*Analyzing Data Using PivotTables and PivotCharts
*Inserting Graphic Objects
*Customizing and Enhancing the Excel Environment
*Collaborating with Other Users
*Working with Multiple Workbooks
*Importing and Exporting Data
*Integrating Excel Data with the Web
Automation (Macros and VBA-Visual Basic for Applications) in Excel
*Formatting Worksheets Using Macros
*Creating an Interactive Worksheet
*Working with Multiple Worksheets
*Performing Calculations (writing your own functions)
You may mix and match topics depending on your needs.
I am a Microsoft certified Trainer (MCT) who has been teaching Excel for about 9 years. I have taken both the Specialist and Expert levels of the Microsoft Office Specialist (MOS) exams for the Excel component for the various versions of the software (2003,2007, 2010). Simply put, you’re in good hands. For further inquiries or details concerning the course outline feel free to contact me.
I am Microsoft Office Specialist (MOS) Master certified trainer who will provide you with quality training.
Microsoft Outlook is often thought to be an email client. It can also be used as a Personal Information Manager as a result of its other components such as calendars, contacts and so on.
Topics that may be covered include: Exploring the Outlook environment, Composing, Organizing, and Locating Messages, Managing Contacts, Scheduling Appointments & Meetings, Managing Tasks and Notes. Students will also learn how to Customize Message Options, Setting Calendar Options, Tracking Activities using the Journal, Sharing Folder Information and Customizing the Outlook Environment.
Advanced users who are also interested may opt for topics such as Customizing Email, Saving and Archiving Contacts and Creating a Custom Form.
PowerPoint is designed to help create/develop professional looking presentations.
With over 9 years of training experience and also possessing a certification in the course, I will provide you with a learning experience to remember.
Topics covered include: Exploring the environment, Creating a basic presentation, Formatting Text on slides, Adding Graphics, Modifying graphics, working with tables, Working with charts, Preparing to deliver a presentation, Customizing the environment, Customizing a design template, Adding SmartArt graphics, Customizing a Slide Show, Collaborating on a Presentation, Securing and Distributing a Presentation.
Microsoft Project is application software that is primarily designed to manage Projects. Whether you are in the construction industry, deploying a new platform or transitioning to a new version of an application suite, Microsoft Project can be used to help you schedule tasks, assign resources and track the progress of your project.
Beginners will benefit from the following topics:
•Exploring the Project environment
•Creating a Project Plan
•Managing Tasks in a Project Plan
•Managing Resources in a Project Plan
•Finalizing a Project Plan
Intermediate users will benefit from the following topics:
•Exchanging Project Plan Data with Other Applications
•Updating a Project Plan
•Managing Project Costs
•Reporting Project Data Visually
•Reusing Project Plan Information
It is possible to mix and match topics.
I have an extensive training background and am an MCTS in Project, so rest assured that you are in good hands.
Microsoft Windows is an operating system. It has various versions, the most common being Windows XP, Windows Vista and Windows 7. Without an operating system you would not be able to store files on a computer, interact with other applications or successfully print out a file you are working on.
Windows comes built in with a variety of new fun features and utilities that make using your computer that much easier.
In this course you will:
*Explore Windows environment
*Work with the Desktop and Taskbar
*Manage Folders and Files
*Create and manage user accounts
*Browse the Internet
I am a Microsoft certified trainer (MCT). Whether you are brand new to computers or just having trouble transitioning from Windows XP to Windows 7 and would like to explore the new features, I would be glad to be of assistance.
Please note: I teach Windows from an end-user perspective, not from a deployment perspective.
Microsoft Word is an application software that is primarily designed for document creation, be it letters, memos, brochures, manuals and more, Microsoft Word is the application for you.
Given my 9 years of experience in the training industry, I can guarantee you will get a bang for your buck.
These are the pool of topics you may choose from: Exploring the Word environment, Editing text, Formatting text and working with styles, Inserting symbols and graphical objects, Organizing data into tables, Proofing a document, Controlling the appearance of pages in a document, Printing documents, Working with lists, Controlling text flow, Working with templates, Performing Mail Merge, Automating tasks using macros, Integrating word with other programs, Collaborating with others, Adding reference marks and notes, Making long documents easier to use and Securing a document.
Feel free to make a selection as the need arises.