Microsoft Office Level Assessments

These assessments are designed as a way to test your knowledge of a particular Office program. By taking an assessment, you will get an idea of what you may learn by taking a certain level of a course, and even what level may be right for you. Please understand that by obtaining any score, we do not guarantee that it is the correct level for you, but rather, a recommendation will be made when you receive your results.

Click the link for a particular level to be taken to that test. Below each assessment link, you can view a brief course description, and also click a link to view the full course outline, which will open in a new window.

We hope you enjoy testing your skills, and should you have further questions, you can always contact us!

Assessment Quicklinks

Jump to:

| Microsoft Word | | Microsoft Excel | | Microsoft Outlook | | Microsoft PowerPoint | | Microsoft Access |

Word logoMicrosoft Word

Word processing is the use of computers to create, revise, and save documents for printing and future retrieval. This course is the first in a series of three Microsoft® Office Word courses. It will provide you with the basic concepts required to produce basic business documents. (see full course outline)

In the first course in this series, Microsoft® Office Word: Level 1, you gained all the basic skills that you need to create a wide range of standardized business documents. If you use Microsoft Word on a regular basis, then once you have mastered the basic skills, the next step is to improve your proficiency. To do so, you can customize and automate the way Microsoft Word works for you. You can also improve the quality of your work by enhancing your documents with customized Microsoft Word elements. In this course, you will create complex documents in Microsoft Word by adding components such as, customized lists, tables, charts, and graphics. You will also create personalized Microsoft Word  efficiency tools. (see full course outline)

You know to use Microsoft® Office Word  to create and format typical business documents. Now, you may need to work on more complex documents. In this course, you will use Word to create, manage, revise, and distribute long documents and forms. (see full course outline)

excel logoMicrosoft Excel

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. (see full course outline)

In Microsoft® Office Excel®: Level 1, you created edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.(see full course outline)

Your training in and use of Microsoft® Office Excel® has provided you with a solid foundation in the basic and intermediate skills for working in Excel. You have used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications. (see full course outline)

If you need to do more with your spreadsheet functions than SUM, AVERAGE and COUNT, this is the class for you. If you are required to do more advanced analysis with your data this class will introduce you to advanced functions in Excel. A solid foundation in building formulas and using Excel functions will help strengthen your analysis skills. (see full course outline)

outlook logoMicrosoft Outlook

This course is the first in a series of three Microsoft® Office Outlook® courses. It will provide you with the skills you need to start sending and responding to email in Microsoft® Office Outlook®, as well as maintaining your Calendar, scheduling meetings, and working with tasks and notes. In this course, you will compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes. (see full course outline)

If you have been using Microsoft® Office Outlook® as a communications tool, then you know how to send a mail message; schedule appointments and meetings; and create contacts, tasks, and notes. This course is the second in a series of three Microsoft Office Outlook courses. In this course, you will customize your Outlook environment, Calendar, mail, folders, and also track, share, assign, and quickly locate various Outlook items. (see full course outline)

This course is the third in a series of Microsoft® Office Outlook® courses. It builds on the email and calendaring skills you have already obtained and will provide you with the skills needed to personalize email, organize Outlook items, manage Outlook data files, share and link contacts, save and archive email, create forms, and work offline and remotely. (see full course outline)

powerpoint logoMicrosoft PowerPoint

In today's work environment, presentations have moved far beyond flip charts and overhead projectors. Audiences not only expect that your presentations are in an electronic format, but they also demand that your presentations be unique and sophisticated in their use of such formats. In this course, you will work with Microsoft® Office PowerPoint® to create electronic presentations. (see full course outline)

As a Microsoft® Office PowerPoint® user, you are familiar with the basics of creating a presentation and you are able to convey information effectively in a simple way. Static content in presentation, however, will not keep your audience interested. In this course, you will enhance presentations with feature that will transform basic presentations into a powerful means of communication. (see full course outline)

access logoMicrosoft Access

Not quite sure if it’s time to move your data from Excel to Access? Interested in learning how databases can help save you time? In this class, we will discuss the differences between Excel and Access, how to navigate and create items in Access, and how databases can save you time. We will focus on planning a database, creating tables, and building relationships. Even if you don’t need to design and build your own database, this class will demystify the underlying architecture of a database so that even someone tasked with data entry and running reports will feel more comfortable with MS Access. (see full course outline)

You will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Office Access™ 2007 with other applications. (see full course outline)

Topics for this course include advanced forms and reports. (see full course outline)

Topics for this course include Macros, Security, and Database Management. (see full course outline)

Executive Training Solutions • Computer Training • Phoenix, AZ • 602-955-7787