1 / 12

Beginning Excel

Beginning Excel. KASBO. Agenda. Customizing Excel Copying and Moving Data Entering Data Formatting Data Selecting and Navigating Data Filtering, Sorting, and Subtotaling Formulas Graphics Charts Printing. Customizing Excel. Customize the Quick Access Toolbar Minimizing the Ribbon

nitza
Download Presentation

Beginning Excel

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. Beginning Excel KASBO

  2. Agenda • Customizing Excel • Copying and Moving Data • Entering Data • Formatting Data • Selecting and Navigating Data • Filtering, Sorting, and Subtotaling • Formulas • Graphics • Charts • Printing

  3. Customizing Excel • Customize the Quick Access Toolbar • Minimizing the Ribbon • Customize the Ribbon

  4. Copying and Moving Data • Paste Special • Copy/Move Worksheets

  5. Entering Data • Insert/Delete Cells, Rows, and Columns • Find and Replace • Merge/Split Cells • Grouping Rows and Columns

  6. Formatting Data • Cell Borders • Text Colors • Cell Shading • Position Data in a Cell • Formatting Numbers • Wrap Text • Spelling and Grammar • Show/Hide Gridlines • Conditional Formatting

  7. Selecting and Navigating Data • Select Cells • Find Cells that Meet Specific Requirements • Navigating a Worksheet

  8. Filtering, Sorting, and Subtotaling • AutoFilter • Sort Data • Insert Subtotals

  9. Formulas • Basic Formulas • Functions in a Formula • Commonly Used Functions

  10. Graphics • SmartArt • WordArt • ClipArt • Pictures

  11. Charts • Creating • Formatting

  12. Printing • Set Print Area • Page Break • Preview • Orientation • Margins • Headers and Footers • Repeat Rows or Columns

More Related