New Horizons Courseware Outlines

| |Excel 2013 - Level 1 |Duration: 1 day | |
| |Overview: | |Lesson 1: Getting Started | |Lesson 5: Printing Workbook |
| | | |with Microsoft Excel 2013 | |Contents |
| |Excel can help you | | | | |
| |organise, calculate, | |Navigate the Excel User | |Preview and Print a Workbook|
| |analyse, revise, | |Interface | | |
| |update, and present | |Use Excel Commands | |Define the Page Layout |
| |your data in ways | |Create and Save a Basic | | |
| |that will help the | |Workbook | |Lesson 6: Managing Large |
| |decision makers in | |Enter Cell Data | |Workbooks |
| |your organisation | |Use Excel Help | | |
| |steer you in the | | | |Manage Worksheets |
| |right direction. Of | |Lesson 2: Performing | |Manage Workbook and |
| |course, knowing | |Calculations | |Worksheet Views |
| |exactly how to ask | | | |Manage Workbook Properties |
| |Excel the questions | |Create Worksheet Formulas | | |
| |that you need | |Insert Functions | |Appendix A: Microsoft Office|
| |answered, which | |Reuse Formulas | |Excel 2013 Exam 77-420 |
| |questions you can | | | | |
| |even ask, and how to | |Lesson 3: Modifying a | |Appendix B: Microsoft Office|
| |interpret the answers| |Worksheet | |Excel 2013 Expert Exams |
| |Excel gives is | | | |77-427 and 77-428 |
| |necessary before you | |Insert, Delete, and Adjust | | |
| |can even begin to | |Cells, Columns, and Rows | |Appendix C: Microsoft Excel |
| |embark on the journey| |Search for and Replace Data | |2013 Common Keyboard |
| |ahead. This course | |Use Proofing and Research | |Shortcuts |
| |aims to provide you | |Tools | | |
| |with the foundational| | | | |
| |Excel knowledge and | |Lesson 4: Formatting a | | |
| |skills necessary to | |Worksheet | | |
| |begin that journey. | | | | |
| |This course covers | |Modify Fonts | | |
| |Microsoft Office | |Add Borders and Colours to | | |
| |Specialist exam | |Worksheets | | |
| |objectives to help | |Apply Number Formats | | |
| |students prepare for | |Align Cell Contents | | |
| |the Excel 2013 Exam | |Apply Styles and Themes | | |
| |and the Excel 2013 | |Apply Basic Conditional | | |
| |Expert Exam. | |Formatting | | |
| | | |Create and Use Templates | | |
| |Target Audience: | | | | |
| | | | | | |
| |This course is | | | | |
| |intended for students| | | | |
| |who wish to gain the | | | | |
| |foundational | | | | |
| |understanding of | | | | |
| |Microsoft Office | | | | |
| |Excel 2013 that is | | | | |
| |necessary to create | | | | |
| |and work with | | | | |
| |electronic | | | | |
| |spreadsheets. | | | | |
| | | | | | |
| |Pre-requisites: | | | | |
| | | | | | |
| |To ensure success, | | | | |
| |students will need to| | | | |
| |be familiar with | | | | |
| |using personal | | | | |
| |computers and should | | | | |
| |have experience using| | | | |
| |a keyboard and mouse.| | | | |
| |Students should be | | | | |
| |comfortable in the | | | | |
| |Windows 8 | | | | |
| |environment, and be | | | | |
| |able to use Windows 8| | | | |
| |to manage information| | | | |
| |on their computers. | | | | |
| |Specific tasks the | | | | |
| |students should be | | | | |
| |able to perform | | | | |
| |include: launching | | | | |
| |and closing | | | | |
| |applications, | | | | |
| |navigating basic file| | | | |
| |structures, and | | | | |
| |managing files and | | | | |
| |folders. | | | | |
| | | | | | |
| |At Course Completion:| | | | |
| | | | | | |
| | | | | | |
| |After completing this| | | | |
| |course, students will| | | | |
| |be able to: | | | | |
| | | | | | |
| |Get started with | | | | |
| |Microsoft Office | | | | |
| |Excel 2013 | | | | |
| |Perform calculations | | | | |
| |Modify a worksheet | | | | |
| |Format a worksheet | | | | |
| |Print workbooks | | | | |
| |Manage workbooks | | | | |