Microsoft Excel Expert

Microsoft Office Specialist—Excel 2003 Expert
Overview

This course covers Microsoft Office Excel 2003 to expert level and will give the candidates further training in using some of the more advanced features.

Who is this course for?

This course is intended for individuals who are employed as or seeking employment in professions which require the use of Microsoft Office/Excel on a daily basis.

What exam does this course lead to?

Microsoft Office Specialist: Excel 2003 expert—Exam excel2003e

What are the prerequisites?

Microsoft Office Specialist: Excel 2003, or equivalent knowledge and skills.

CompTIA Strata certification, or equivalent knowledge and skills.

What will I achieve from this course?

After completing this course students will be able to:

  • Working with Lists and Databases
    • Using Excel Database Concepts/Terms
    • Using Lists and Filtering Information
    • Using Advanced Functions
    • Grouping and Outlining
    • Summarizing Data
  • Formatting Cells
    • Looking at Custom Cell Formats
    • Using Conditional Formatting
    • Modifying Drawing Objects
  • Customizing Charts
    • Customising/Modifying a Chart
    • Formatting Charts
    • Formatting Legends, Title etc
  • Templates and Data Validation
    • Using Built-in Templates
    • User-Defined Templates
    • Validating Data
    • Using Pick Lists
    • Circling Invalid Data
  • Managing your Workbook
    • Auditing a Worksheet
    • Correcting Worksheet Errors
    • Protecting Workbooks
    • Using Auto Recover
  • Using Analysis Tools
    • What-if, Goal Seek, Scenarios and Solver
    • Data Tables
    • Pivot Tables and Charts
  • Collaborating with Others
    • Consolidating Data
    • Merging
  • Importing and Exporting Data
    • Export as Webpage
    • Importing Data
  • Using Macros and Custom Forms
    • Customizing Excel
    • Using Macros
    • Digital Certificates
Is this course part of any other qualifications?

This course is part of the requirements for obtaining:
Microsoft Office Specialist Master (MOSM)
Microsoft Office Specialist Master Instructor (MOSMI)

Length

This course can be 1 or 2 days long.
1 day course includes a full day working through the course modules
2 day course includes the above, along with a 2nd days worth of revision, mock exams and certification exam if student feels ready—if not, the exam can be booked for another day

Extra Information

Lunch, tea and coffee is included in this price.
Exams are NOT included in 1 day course—price for exam is £45inc VAT directly from EMiTT