1 / 14

Mastering Excel: Conditional Functions, Formatting, and Backstage Features

Unlock the full potential of Excel with our comprehensive guide to conditional functions, formatting, and the Backstage view. Learn how to create logical statements with IF functions and utilize comparison operators to evaluate conditions. Discover the power of conditional formatting to visually enhance your data based on logical tests, along with effective use of the Transpose feature for data organization. Gain insights into managing comments within your worksheets and explore Backstage view for streamlined operations like saving and options management. Perfect for Excel users at any level!

lucine
Télécharger la présentation

Mastering Excel: Conditional Functions, Formatting, and Backstage Features

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel 4 Conditional Functions, Formats, and Backstage

  2. A Logical statement has one of two results, True or False Conditional Functions

  3. Logical Statements • To create a logical statement, you must use a Comparison operator. • The following are comparison operators:

  4. If Functions • An IF Function uses a logical test to determine between two possible answers. • The Path to the IF function isFormulas-Function Library-Logical-IF • Parts of the IF function • Logical Test • Value if True • Value if False

  5. IF Functions • When the IF function appears in a cell or the Formula bar, the structure is as follows: =IF (logical test, value if true, value if false) • Numbers in IF functions cannot contain symbols or commas • Text that is a result in IF functions must be surrounded by Quote Marks

  6. Conditional formatting allows you to show different formatting based on a Logical Test Conditional Formatting

  7. Conditions • Conditions are either True or False • When you use a highlight rule, type the Condition to be compared • Then choose the Format • You can use a preset format or define a custom format. • Conditional Formatting also includes data bars, color scales and icon sets.

  8. The Transpose feature switches data in rows and columns Transpose

  9. Transpose • The path to Transpose is Home-Clipboard group-Paste Arrow-Paste Special • Before you can Transpose you must either Copy or Cut the data.

  10. Comments can be made to individual cells in a worksheet. Comments

  11. Comments • The path to insert a comment isReview-Comments Group-New Comment • Comments do not print when the Worksheet is printed. • To show all comments on the screen at once, go to the Review Tab and choose Show All Comments.

  12. The File Tab is considered Backstage View Backstage View

  13. Backstage View • Several commands found in Backstage view are:Save, Save As, Open, New, Print, Options • The Exit command in Backstage View closes the program • The Options button takes you to the Excel Options Dialog Box

  14. Excel Options • Excel Options contains many tools for changing how Excel operates • AutoCorrect is found in the Proofing page • Default file locations are found in the Save page • The General page has options like Color Scheme, Default Font, and Username • Changes in Options are erased at school when your computer is Shut Down or Restarted

More Related