Skip to main content

ILG Courses

**Miss a webinar or are unable to attend one? You can request a recording to view at a later time! Email Alisha at alisha.adolf@ndaco.org to request a recording.

**More courses will be posted as soon as dates are confirmed!

Basic Excel in MS Office 2010 (TCH)

Image related to Basic Excel in MS Office 2010 (TCH)

LAB IS FULL. 

Presenter:  Debbie Mantz, BSC Certified Technology Instructor

Location: Bismarck State College, National Energy Center of Excellence, Room 104
 
Lab Fee: $170 per person    Earn 8.5 TCH (technology) Credits!!
 

Description: Join us to learn to create, manage, enhance, and print worksheets using MS Excel. This course is always a favorite with participants! Prerequisites: Windows XP: Basic or equivalent experience

PREVIEW OF OUTLINE BELOW.....

Getting started
Topic A: Spreadsheet terminology
Topic B: The Excel environment
Topic C: Getting help
Topic D: Navigating a worksheet

Entering and editing data
Topic A: Entering and editing text and values
Topic B: Entering and editing formulas
Topic C: Working with pictures
Topic D: Saving and updating workbooks

Modifying a worksheet
Topic A: Moving and copying data
Topic B: Moving and copying formulas
Topic C: Absolute and relative references
Topic D: Inserting and deleting ranges, rows, and columns

Functions
Topic A: Entering functions
Topic B: AutoSum
Topic C: Other common functions

Formatting
Topic A: Text formatting
Topic B: Row and column formatting
Topic C: Number formatting
Topic D: Conditional formatting
Topic E: Additional formatting options

Printing
Topic A: Preparing to print

Topic B: Page Setup options
Topic C: Printing worksheets

Charts
Topic A: Chart basics
Topic B: Formatting charts

Managing large workbooks
Topic A: Viewing large worksheets
Topic B: Printing large worksheets
Topic C: Working with multiple worksheets