Course Outline
[Pages:1]Course Outline
Excel ? Intermediate Part I
Versions 2007/2010/2013/2016
P.O. Box 225 East Petersburg, PA 17520
Phone:
717-560-3552
E-Mail: Registrar@
Program Objectives: Students will learn the skills and concepts necessary to create and use three-dimensional spreadsheets, use logical formulas, use Excel's database functions, and create charts.
Excel o Electronic Spreadsheet o Database o Charting Package
Selecting Cells Changing View Modes Centering Text Over Several Columns Numbering Items in a Spreadsheet Auto Fill Feature Customizing the Auto Fill Feature Range Names
o Moving Around With Their Help o Printing With Range Names o Building Formulas Using Range
Names Absolute Reference Logical Formulas ? "=IF" Conditional Formatting Auto Format Feature Removing Auto Formatting Freezing/Unfreezing Panes Page Breaks
o Inserting o Removing Print Titles Toolbars o Adding/Removing o Docking a Floating Toolbar
Database Function o Setting Up o Entering Dates o Data Sort/Find/Filter o Data Filter Customized Formulas o Displaying All Records o Removing the Auto Filter
Three-Dimensional Spreadsheets o Renaming Sheet Tabs o Adding Color to the Tabs o Building Formulas o Copying/Moving a Sheet o Inserting/Deleting a Sheet o Grouping/Ungrouping Sheets o Creating Same Header/Footer for Multiple Sheets
Charting o How to Create o Enhancing the Chart o Changing Chart Type o Changing Chart Colors o Fill Effects o Moving/Resizing Title/Legend o Printing the Chart o Removing the Chart o Chart Types
Exiting From Excel
Course Prerequisite
Must have Excel ? Basics or equivalent experience
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- 5 paragraph essay outline worksheet
- free financial management course online
- business plan outline for a startup business
- personal financial management course online
- law school outline example
- argumentative essay outline worksheet
- 5 paragraph essay outline pdf
- 5 paragraph essay outline printable
- essay outline template middle school
- microsoft word outline template download
- business outline template
- college essay outline format