| Training & Development - Technical Training Curriculum
[Back to course listing]
Microsoft Excel Basics: Creating Spreadsheets
This course is designed to teach you how to create, edit, format, and print a document in Excel. You will learn to copy, move, insert, and delete data. You will create your own formulas, and will learn how to use some of Excel's useful built-in formulas. You'll get your hands on timesaving ways to format text, numbers, and dates. Learn to increase the impact and clarity of your data by using charts.
Presenter(s): Frank Widman, Senior Technical Training Consultant
Prerequisite: Introduction to Macintosh or Windows or equivalent experience
Enrollment: Use our Online
Registration Form,
or call 459-5565.
Additional Information: This class is intended for users on either PC or Mac. The software, class, materials and user interface are interchangeable in both labs.
Related Courses:
| Schedule |
| Date |
Time |
Fee |
Location |
January 10, 2012
April 4, 2012
|
9am - 4pm
|
$25 |
Kerr Hall Room 8
|
Course Outline
- Getting Started
- Understanding pointer shapes
- Undo and redo
- Menus and toolbars
- Activating another cell
- Making selections
- Navigation keys
- Working with sheet tabls
- Creating a New Workbook
- Entering Data
- Understanding data types in Excel
- How Excel starts to assist with data entry
- Entering Formulas and Functions
- Calculation operators
- Order of operation precedence
- Using the AutoSum function
- Copying formulas using AutoFill
- Using AutoCalculate
- Formatting a Worksheet
- Formatting toolbar
- Format Cells command
- Editing Worksheets
- Moving and copying cells
- Using drag and drop
- AutoFilling a Series
- Excel's built-in AutoFill lists
- Creating a custom series
- Relative vs. Absolute References
- Relative references
- Absolute and mixed references
- Switching betwen absolute, relative and mixed references
- Preparing to Print
- Formatting the sheet onscreen
- Adding headers and footers
- Repeating titles on every page
- Changing the layout
- Previewing and adjusting margins
- Checking page breaks
- Charting Basics
- Anatomy of a chart
- Choosing the best chart type
- Selecting data
- Creating an embedded vs. a separate chart
- Editing Data
|
