Featured Video

Formatting and Format Painter (4:21)

Free Webinars

CAUTION! The free webinar that we offer may be hazardous to your health. In our Excel Tips and Tricks webinar, we teach you things that many of the "experts" don't know how to do, and some of them are SO EXCITING that some people experience things like a racing heart, uncontrollable sweating, and your mind suddenly thinks of all the different things you can do with this newfound knowledge. So to prepare to take the webinar, make sure you take your nitroglycerin, get in a comfortable chair, and be prepared to learn A LOT of things you didn't know about Excel.

To view a pre-recorded webinar from ExcelCEO, you can click the link to the right for a basic presentation as given to previous audiences. If you are not yet registered with ExcelCEO, click on the Buy It Now button above and register for a free course. This will create an ExcelCEO account for you.

Free Excel Test

Instructions

Before clicking the Begin Test button, make sure the only two programs open on the computer are Excel and this Internet session. Make sure you will be able to work undisturbed during the length of the exam. We recommend you allow approximately 30 minutes to take the exam. You are allowed and encouraged to toggle back and forth between this test and Excel to answer the test questions. All questions are in a multiple choice format. Note that once you click the Finish button, you cannot go back to review the questions or change your answers. After you finish the exam, you will see a summary of the grade you made for each section. You will be prompted to print that page for your records. Please use the buttons provided to navigate within the test, and not the Back button on your browser. Topics in each category include the following:

  • Beginning Excel: Print Preview, Working with Dates, General and Custom Formatting, The Format Cells Dialog Box, Subtotals, Sorting, Find and Replace, AutoFilters, Shapes.

  • Intermediate Excel (Using Functions and Writing Formulas): Arithmetic, Text and Comparison Operators, Concatenation, Named Ranges, Data Validation, Functions (Text, Financial, Logical, Math, Date, Statistical, Lookup).

  • Advanced Excel: PivotTables, External Data Sources, Macros, Protection, Conditional Formatting, Graphs and Charts, Views.

Choose the BEST answer from the available choices. Once you finish the test, you will see a report containing feedback on your response to each question. You will also receive a grade in each section (Beginning, Intermediate, and Advanced), and an overall grade and how your grade compares with the thousands of others who have taken the test. Instructions on how to access the completed test will also be emailed to your email address, so please make sure the email address you input is correct. If you have any comments for me about the test, please email Customer.Service@ExcelCEO.com.