Lesson plan / INFORMATION TECHNOLOGY-II

Lesson Information

Course Credit 2.0
Course ECTS Credit 2.0
Teaching Language of Instruction Türkçe
Level of Course Bachelor's Degree, TYYÇ: Level 6, EQF-LLL: Level 6, QF-EHEA: First Cycle
Type of Course Compulsory
Mode of Delivery Face-to-face
Does the course require compulsory or optional work experience? Z
Course Coordinator Instructor MURAT AKSEL AKÇAY
Instructor (s) Instructor MURAT AKSEL AKÇAY|Instructor DEVRAN KORKMAZ
Course Assistant

Purpose and Content

The aim of the course Advanced Ms Excel Learning- To be able to prepare and interpret the graphics based on numerical values in working tables with the basic principles of working table softwares and data saving properties
Course Content Advanced level usage of MS Excel, Using the formula

Weekly Course Subjects

1An overview of the screen, navigation and basic spreadsheet concepts Understand Excel terminology workbooks, worksheets, rows, columns, cells
2Various selection techniques Understanding the various mouse cursors Working with Ribbon Tabs, Groups and Dialog Boxes Standard and Contextual ribbons Use the task pane, Understand and use the File Tab Saving, File types, File compatibility (earlier versions), Useful keyboard commands
3Various ways to Enter, Edit and Delete information (Text, Numbers, Dates) Use Auto List feature Date and Time are storage in Excel Enter Dates and Times Date/time formatting Methods to Move and Copy data Use the Fill Handle to copy data and create simple lists Create series of information
4Insert, Delete and Hiding Rows & Columns Insert, Delete and Move Cells Insert, Delete, Move and Copy Sheets
5Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colours and Patterns Quick formats and themes Sheet tab formatting and Renaming Copy and Clear Formats
6Formatting and Proofing Merging cells Spell Check, Find & Replace and AutoCorrect
7Formatting and Proofing Page Orientation Add Headers and Footers Print a selection Set a print area Clear a print area
8Adjust page breaks within Page Break Preview Repeat columns and rows Print Gridlines Save print settings
9Processing Data in Excel Data Tables in Exce A Second Data Table Excel Scenarios Excel Pivot Tables Pivot Tables, Part Two
10Entering Simple Addition Formula The SUM Function in Excel The SUM Function Continued Copy and Paste 7 How to use Paste Special
11How to Multiply in Excel Entering Simple Addition Formula Finishing your spreadsheet for this section How to Add a Comment to a Cell Review Number Two
12The Average Function The Date Function Time Functions in Excel A TimeTable Project
13Ready Functions (min,max,if...)
14Review

Resources

1-Microsoft Yayınları