Excel Intro:
Common Tasks

Title: Jan's Illustrated Computer Literacy 101
Did you want Working with Numbers: 2007,2010,2013,2016  or españolIcon: Change web



Now that you can get around in an existing spreadsheet, you can look at some buttons that help with common tasks. You will continue working with the budget.xls spreadsheet while you learn how some of Excel's basic features work. 

Autosum AutoSum - offers a quick way to add up a column or row. Excel will make a guess as to what cells you want to add. It is easy to change the cell references.

Sort Ascending and Descending Sort - rearranges the selected cells in alphabetical and numerical order, or in reverse order.

Chart Wizard Chart Wizard - turns your numbers into bars, pies, lines, or dots so you can see quickly how they relate to each other

Number Formats Format Numbers - assigns standard number styles to your data: Currency, Percentage and Comma. Other styles are available from a dialog.


Where you are:
JegsWorks > Lessons > Numbers

Before you start...

Project 1: Excel Intro
    InterfaceTo subtopics
    Select & Navigate To subtopics
    Common Tasks To subtopics
     footprintAutoSum
     footprintSort
     footprintChart Wizard
     footprintNumber Formats
    Summary
    Quiz
    ExercisesTo subtopics

Project 2: Excel BasicsTo subtopics

Project 3: Format & ArrangeTo subtopics

Project 4: Groups & FormulasTo subtopics

Project 5: DesignTo subtopics


Search
Glossary
Appendix