San Bernardino Adult School
San Bernardino Adult School
Home PageEmail PagePrint Page

Go To Search
Microsoft Excel 2010

Microsoft Excel 2010 course has three levels of books.  Students can take oe or all three levels.

The prerequisite for these courses is Microsoft Office Suite 2010.

Levels 2 and 3 require the previous level prior to enrollment.

Level 1 covers key introductory Microsoft Excel skills. Introductory topics covered include entering and editing entries, selecting cells and ranges, creating and modifying basic formulas, and more.

By the end of this course, you will be able to:

  • Enter text and numbers into cells

  • Clear cell contents, including formatting

  • Create, modify, and copy formulas

  • Format worksheets and apply workbook themes

  • Work with date functions

  • Modify column width and row heights

  • Much, much more!

Level 2 covers intermediate Microsoft Excel skills. Intermediate topics covered include formatting worksheets, importing web data, sorting worksheet rows, freezing headings, and more.

By the end of this course, you will be able to

  • Create a variety of different types of charts

  • Sort worksheet rows

  • Create formulas

  • Sort data using various specifications

  • Insert and modify pictures on worksheets

  • Protect workbooks and worksheet content

  •  Much, much more!

Level 3 covers advanced Microsoft Excel skills. Advanced topics covered include locking/unlocking cells, PivotTables and PivotCharts, PMT and FV functions, grouping worksheets, trendlines, creating shared workbooks, tracking changes, Windows Live SkyDrive, and integration with other Office applications.

By the end of this course, you will be able to:

  • Create PivotTables and PivotCharts

  • Create what-if models in the Scenario Manager

  • Use text functions to reformat data

  • Group worksheets

  • Manage and print comments in workbooks

  • Share workbooks using Windows Live SkyDrive

  • Integrate Excel with other Office applications

  • Much, much more!

 Syllabus  Lessons
 Level 1
 Level 1
 Level 2
 Level 2
 Level 3
 Level 3

If you have any questions, fell free to email me at:  or

San Bernardino Adult School, 1200 N E Street, San Bernardino, CA  92405    (909) 388-6000

Last Updated October 11, 2012

Home     /       Calendar     /       Contact Us     /       Print Page     /       Email Page     /            /       Español     /       Accessibility     /       Site Map     /       Copyright Notices