Advanced Excel and Basic MS Access

Why do I need to learn MS Excel and MS Office Access?

MS Excel is use to create spreadsheets and analyze data with charts and graphs. A "must know" program for anyone in the work force now, or soon to be! MS Access is a powerful program to create and manage your databases. It has many built in features to assist you in constructing and viewing your information. These two platforms when combined can resolve your information management challenges.

Designed For:

For those who would like to know how to manage and store information for reference, reporting and analysis. For those who would like to use Microsoft access to analyze large amounts of information, and manage related data more efficiently than Microsoft excel or other spreadsheet applications.

Course Overview:

MS Excel:

• Simple Functions
• Other advanced functions like: If, VLOOKUP, PMT, and other useful functions
• Managing Charts
• Using Sort and Filter
• Subtotals, custom views, comments
• Data Validation
• Pivot Tables and Pivot Charts
• Chart Tables, Consolidate
• Group and Outline
• Goal Seek, Scenarios
• Outsourcing Data
• Formula Auditing
• Conditional Formatting, Auto Correct Options
• Managing Multiple Documents
• Usage of Freeze Panes and Split
• Managing Tables
• MS Access
• MS Excel Migration
• MS Access Database creation and manipulation
  • Database Fundamentals
  • Tables
  • Queries
  • Forms