Excel Course Guide - Learnit Training

Your details (optional)

Your name:

Your email address:

Do you know where your worksheets go when you save them? In other words, do you understand the folder structure of Windows?

Yes No

Can you enter data (numbers and text) in Excel?

Yes No

Can you create simple formulas? (e.g. =B3/B2 and work with the AutoSum button?)

Yes No

Can you display text vertically in a cell?

Yes No

Can you create a chart?

Yes No

Can you make cells absolute (sometimes better known as the $ signs)?

Yes No

Can you create and use a simple macro?

Yes No

Can you create a pivot table?

Yes No

Can you work with VLOOKUP?

Yes No

Can you apply a filter?

Yes No

Can you work with the functions: OR, IF, AND?

Yes No

Can you calculate with dates and times?

Yes No

Are you familiar with the financial (business economics) capabilities of Excel?

Yes No

Can you nest functions (i.e. create functions within functions)?

Yes No

Can you work efficiently with large lists of data?

Yes No

Can you create subtotals?

Yes No

Can you work with Goal Seek and Solver?

Yes No

Can you work with scenarios?

Yes No

Can you edit macros?

Yes No

Can you create your own function?

Yes No