Excel Basics:
Summary

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



Grouping similar data lets you create subtotals for each group. The data must be sorted first. You can sort on more than one column. A custom list can only be applied to the first column.

Moving or inserting cells can scramble formulas. You can repair the broken formulas with AutoFill or by editing the cell references to include the new cells.


Where you are:
JegsWorks > Lessons > Numbers

Before you start...

Project 1: Excel IntroTo subtopics

Project 2: Excel BasicsTo subtopics    

Project 3: Format & ArrangeTo subtopics    

Project 4: Groups & Formulas To subtopics
    SubtotalsTo subtopics
    Images & DrawingsTo subtopics
    Changes & FormulasTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 5: DesignTo subtopics


Search 
Appendix



Important Terms

absolute reference

AutoCalculate

AutoSum

collapse group

custom list

expand group

group

insert

merge

Sort

Subtotal

Ungroup


LessonsWorking with Numbers Previous Page Next Page




Teachers: Request permission to use this site with your class

Copyright Š 1997-2012 Jan Smith   <jegs1@jegsworks.com>
All Rights Reserved

Icon: DonwloadIcon: CDWant a local copy with no ads? - Download/CD
Want to help?


~~  1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~


Last updated: 02 May 2012