Loading presentation...

Present Remotely

Send the link below via email or IM


Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.


IBM Excel session 2

No description

miguel salazar

on 24 October 2012

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of IBM Excel session 2

POPULAR QUOTES “The road to success is always under construction.”
Lily Tomlin “That sh*! is bananas yo!.”
sHAUN T (Insanity couch) S _ _ _ _ _ _ _ _ _ _ a s e m e d LET"S GOOGLE IT!
Participant code Toll free Num What to do? SEO misalaza@cr.ibm.com IBM EXCEL Training sessions Thank You for the inspiration
Protection of employee information
Internet privacy ITCS 300/ITCS 104
Computers locked
Laptop with cable lock Clean Desk
Documents unattended
Unattended cell phone Data privacy
Unattended badge Don't forget to ILC claim Help me! T H N A K Y O U P R E Z I MID Returns the characters from the middle of a text string, given a starting position and length Concatenate Joins several text strings into one text string TRANSPOSE Converts a vertical range of cells to a horizontal range, or vice versa SUMIF Adds the cells specified by a given condition or criteria SUMPRODUCT Returns the sums of products of corresponding range or arrays MATCH Returns the relative position of an item in an array that matches a specified value in a specified order COUNT Counts a number of cells in a range that contains numbers COUNTA Counts a number of cells in a range that are not empty COUNTBLANK Counts a number of empty cells in a specify range of cells COUNTIF Counts the number of cells within a range that meet the given condition IF Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE AND Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE OR Checks whether any of the arguments are TRUE, and returns TRUE or FALSE.
Returns FALSE only if all arguments are FALSE IF ERROR Returns value_if_error if expression is an error and the value of the expression itself otherwise Workbook Protection prevents others from making changes to the layout of the worksheets in a workbook. UNPROTECT WORKBOOK SHEET PROTECTION By default, all cells in an Excel spreadsheet are locked. This makes it very easy to protect all data in a single worksheet simply by applying the Protect Sheet option UNLOCK ALL CELLS LOCK THE CELLS YOU WANT PROTECT THE SHEET UNPROTECT THE SHEET Lists A drop down list allows you to enter data into an Excel spreadsheet from a preset list of entries. This can be done to make data entry easier or to limit the number of acceptable choices. Flowcharts A flow chart shows sequential steps in a task or process. BONUS Combine Cells in Excel (Other method
Full transcript