Colleges and Universities
Digital Technology
Textbook Publishers
ITI 080 MS Excel 2013 Level I
Course Outline:
Learn the basic features and functions of Excel 2013. After an introduction to spreadsheet terminology and Excels window components, learn how to use the Help system and navigate worksheets and workbooks. Then, learn how to enter and edit text, values, formulas, and pictures, and how to save workbooks in various formats. Work with absolute and relative references, and work with ranges, rows, and columns. Finally, create and modify charts. Simple functions, basic formatting techniques, and printing are also covered. This course follows the curriculum for the Microsoft Office Specialist core-level for Excel 2013 (exam 77-420) and the Microsoft Office Specialist Expert for Excel 2013 (exams 77-427 & 428). For comprehensive certification training, students should complete MS Excel—Levels I, II, and III.
Prerequisites:
Computer Basics and Working with Windows 7 or PC File Management experience.
Required Textbook & Materials
- Title: MICROSOFT EXCEL 2013:LEVEL 1 OF 3
- Author: Eric A. Weinstein
- ISBN-13: 978-1-59136-491-7
- Publisher: Labyrinth Books
Materials:
Please bring a Flash Drive/Memory Stick 512MB or larger to class which will enable you to save your class work.
Meeting Information:
Lesson Plan:
Session 1
- • Course Overview Presentation
- • Lesson 1 - Exploring Excel
- • Lesson 2 - Editing Worksheets
- • Lesson 3 - Changing the Appearance of Worksheets
Session 2
- • Lesson 4 - Working with Formulas and Functions
- • Lesson 5 - Formatting Cell Contents
- • Lesson 6 - Charting Worksheet Data
In-Class Material: