Biyernes, Enero 23, 2015

Jayson's Blog #10 In CompSci for 3rd Rating

Macros


Macros are recorded activities.
With a single keystroke, we can do it again faster than when we do it manually.
With this we can eliminate wasting time and the possibility of having typographical errors in performing repetitive tasks.

Creating Macros
Record Macro Dialog Box
www.fgcu.edu


Recording a Macro
To record a Macro:
  • Click the View tab on the Ribbon
  • Click Macros
  • Click Record Macro
  • Enter a name (without spaces)
  • Enter a Shortcut Key
  • Perform the Macro
  • Click Macros
  • Click Stop Recording
  • Running a Macro
    To run a Macro from the Keyboard shortcut, simply press the keys that you have programmed to run the Macro.  Or you can view all macros and run by:
    • Click Macros
    • Click View Macros
    • Choose the Macro and click Run

Jayson's Blog #9 In CompSci for 3rd Rating

Macros


Macros are recorded activities.
With a single keystroke, we can do it again faster than when we do it manually.
With this we can eliminate wasting time and the possibility of having typographical errors in performing repetitive tasks. 






Jayson's Blog #8 In CompSci for 3rd Rating

Data Representation



Pie Chart
Shows the proportion and size of items in one representation.


Bar charts 

Shows comparisons for individual things.


Area charts 

Used to draw attention to the total value across a trend.

Jayson's Blog #7 In CompSci for 3rd Rating

Data Representation



Column charts 

Useful for showing data changes and also for data comnparisons.

Line charts

Shows continuous data.

Jayson's Blog #6 In CompSci for 3rd Rating

Conditional Formatting

Color Scales



Icon Sets


Adding New Rule
- add a formula that contains a 
condition and add new formatting

Jayson's Blog #5 In CompSci for 3rd Rating

Conditional Formatting

- apply unique cell formatting 
based on a certain condition 


Highlight Rules



Top/Bottom Rules




Data Bars

Jayson's Blog #4 In CompSci for 3rd Rating

IF



If Function
-  returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE.

IF(logical_test, [value_if_true], [value_if_false])
=IF(A1>=True,“True",“False")

Example (single range) 
=IF(AND(G1>60,G1<100),“passed",“failed")

Nested IF (exact value) 
=IF(J1=29,“Twenty- nine", IF(J1=0,“Zero",”Invalid”)) 

Nested IF (ranges) 
=IF(AND(A1>0,A1<11),“One to Ten", 
IF(AND(A1>15,A1<30), 
“Fifteen to Thirty",“Invalid")) 

Jayson's Blog #3 In CompSci for 3rd Rating

Cell Reference


- name of a cell.
- can be used in formulas.

Cell and Range
J1 – single cell
• J7,J14 – cell J7 and cell J14
• J7:J14 – range from J7 to J14 (same col)
• A11:Z11 – range from A7 to Z7 (same row)
• A7:Z17 – range from columns A to Z and
rows 10 through 20



Reference Types

     Relative -  changes when the 
formula is copied down.
Absolute - fixed, doesn’t 
              change when copied to other cells.
                                      - Uses $ sign like: $A$1 
                         Mixed - has either an absolute column and 
                         a relative row, or an absolute row and a 
relative column.
                              - Like A$1 or $A1 

Jayson's Blog #2 In CompSci for 3rd Rating

Functions And Formulas

Formula - is used to perform calculations.
             - begins with an equal ( = ) sign.
                              - contain constants, cell references, ranges, 
and grouping symbols.



Operator Precedence in Excel Formulas


Function - predefined formula.
       - returns a value.
                                              - can be used together with other functions 
and other operations.




Errors

#NAME? - undefined range or cell name,
#REF! - invalid cell reference.
 #DIV/0!
• #N/A – missing data



Jayson's Blog #1 In CompSci for 3rd Rating

MICROSOFT EXCEL




Worksheet - page where you work on.
Selected/Active cell - where you type data or formulas.
Formula bar - can also be used in adding data or formulas to a cell.
Name Box - Have or holds the cells reference number.
Sheet tab - displays the number of sheets you have or created.


Tips

Alt + Enter = Adds up a new line in a cell.
Ctrl + ; = Enters the date.
 Ctrl + Shift + ; = enters the time based on your computer.