Learnit Training

Course Guide

Your details (optional)

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

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

Can you create simple formulas? Bv. = B3/B2 and work with the Autosoma button?)

Can you display text in a cell vertically?

Can you create a chart?

Can you make cells absolutely (sometimes better known as the $ characters)?

Can you create and use a simple macro?

Can you create a pivot table?

Can you work with vertical search?

Can you set a filter?

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

Can you count on dates and times?

Do you know the financial (business) possibilities of Excel?

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

Can you work efficiently with large lists data?

Can you create subtotals?

Can you work with goal Seek and solver?

Can you work with scenarios?

Can you customize macros?

Can you make a function yourself?