Spreadsheets
Microsoft Excel – Introduction to Intermediate
Learn how to use the Excel programme for all your spreadsheet requirements from basic formulas to functions.
Our course is excellent preparation if you need to enter data or to keep track of clients or stock (such as storeroom-type work). Many businesses use Excel as an accounting system.
Microsoft Excel 18743
This Microsoft Excel NZQA Level 1 course introduces spreadsheet concepts to students. Participants learn how to make formatting adjustments, freeze columns and panes, basic formulas and charts.
Optimum Course Duration: 7 Hours + 2 ½ Hour Assessment (custom options available from as little as 2 hours, contact us for details)
Produce a spreadsheet from instructions. NZQA Credits: 2
Course covers
- Advantages of using spreadsheets
- Moving around spreadsheets & entering data
- Formulas and functions
- AutoSum and AutoSum options
- Worksheet data alignment
- SmartArt Diagrams and Organisational charts
Microsoft Excel 2784
This Microsoft Excel NZQA Level 2 course introduces more intermediate spreadsheet concepts to students. Participants learn how to create templates, follow a spreadsheet brief, more advanced formulas and formatting techniques.
Optimum Course Duration: 7 Hours + 4 Hour Assessment (custom options available from as little as 2 hours, contact us for details)
Create and use a computer spreadsheet to solve a problem. NZQA Credits: 3
Course covers
- Planning a spreadsheet
- Follwing a brief and drawing a specification plan
- More formulas and functions
- Appropriate legibility, presentation, accuracy & data integrity
- Organisational charts
Contact us to book today!