Akademik Dersler - İçerik

Creates workbook and works with data
Recognizes the spreadsheet program Interface.
Knows the use of Title bar, Tabs, Address Bar, Formula Bar, Scroll Bars, Gridlines, Status Bar.
Creates new workbook, saves, closes, opens saved workbooks.
Can add pages, rename pages, hide pages, delete pages, move and copy pages
Can use formulas to analyze data.
Changes data, Knows different selection techniques, Can delete data and cells, move and copy.
Understands the causes of formula errors
Understands the usage of ready-made functions in Excel
Applies mathematical, financial and IF functions on examples
Can work with worksheets and windows.
Print preview with Page settings and printing in Excel
Understands Split and Freeze Windows, Arrange and Hide Windows
Can draw graphs in Excel
Has knowledge of Chart types, Chart options, Chart formatting.
Analyzes data in Excel.
Sorts, filters data
Can sort, filter, subtotal by more than one field.
Knows advanced filtering methods
Quickly lists data that meets multiple conditions
Creates data validation rule with formula
Uses the Add Function option.
Performs operations on Sum, Average, If functions
Searches and references with Add Function
Recognizes financial functions.
Knows the use of some Statistical functions
Creates a pivot table
Can create pivot table for more than 3 fields
Can create pivot charts and scenarios