EXCEL: DATA: HOME
NAVIGATION:
Autofill Charts Exercises Filter Format Formulas Functions Macros Misc
DATA:
65000 ROWS
255 COLUMNS
W325: write in Name Box, press Enter
or Goto
Data Formatting
Format/Cells
Number: Use 1000 Separator
Date
Percentage: Decimal Places
Insert/Rows
Shade 2 cells: Insert Rows: 2 cells are created
Format/Row/Height
To enlarge a cell: Double-click on separating line between cells
Format/Column/Autofit Selection
Format Cells/Alignment/Merge Cells
Format Cells/Alignment/Text Alignment/Horizontal/Center Across Selection
Alignment: Horizontal or Bottom
Select Text: drag row: double arrow in vertical position with line in the middle
=A1+B1: in English
=SUM(A1+B1)
=SUM(A1:B1)
=A1: press + A2 Enter // press *
=SUM: select cells to be used for computation
black cross with thick edges: for cell expansion
ΑΥΤΟMATH ΣΥΜΠΛΗΡΩΣΗ
LISTS:
Monday
January
Black Cross: +
1/1/2006 1/2/2006: analogy for autofill
1 3 5...7 9
Tools/Options/NEW LIST
Select Cells: Tools/Options/Import
Sum
Average
Count
Max
Min
More Functions
if(F5>550000;"HIGH";"LOW"
G6="HIGH"
AVERAGE(B6:F6)
MIN(B6:F6)
SECOND IF
IF(B1>=30;2*B1;IF(B1>=20;1,5*B1;B1))
Press F4 to create absolute reference
10000*10%+(sum(C2:E2)-10000)*15%
=SUM(C2:D2)*118%
Math & Trig
=SUMIF(B2:B9,"Αττική",C2:C9)
ROUND
SQRT: result in adjacent cell
TODAY
NOW
NETWORKDAYS: business days
WEEKNUM
WORKDAY
Chart Options: Title, Axes
Overlap -40
3D View
Elevation: προοπτική
Rotation: περιστροφή
Data/Filter
Data/Filter/Advanced Filter
List range
Criteria range
Copy to
Data/Subtotals
File/Page Setup/Sheet/Row and Column Headings
Page Setup/Scaling/Adjust to ... % normal size
Insert/Page Break
Insert/Name/Label
GoTo ... name of label
Tools/Macro
Mouse on Menu Bar: Customize/Macros/Mouse on Icon
Modify Selection (to relate icon to macro)
Save/WebPage/Add Interactivity
Data Validation
Format/Conditional Formatting: Add (for new condition)
Workbook/Worksheet
Increase of row
Autocalculate
Templates: View/Task Pane