Excel 2010 Level 1
CLASS DATE(s):
Request a Class

COURSE LENGTH: 1 Day

COURSE COST: $295

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print

COURSE OVERVIEW

Recommended for individuals who are new to Microsoft Excel or need a brush up on the basics, this hands on instructor-led course will provide an introduction to spreadsheets and the practical uses and versatility of Excel. Students will learn time saving features and tips for using Excel effectively. This is a good foundational course that will provide you a solid knowledge base before attending other Excel courses.

AUDIENCE AND PREREQUISITES

This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2010 that is necessary to create and work with electronic spreadsheets.

This course requires you to be familiar with using personal computers and have used a mouse and keyboard.

  • You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.
  • The ability to launch and close programs.
  • Navigate to information stored on the computer.
  • Manage files and folders, is highly recommended.
  • A familiarity with other Microsoft Office applications (e.g., Word) will be helpful.

FOLLOW UP COURSES  

*Course cost listed does not include the cost of courseware or lunch. Course is subject to minimum enrollment. Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions.

COURSE TOPICS:


Lesson 1: Getting Started with Excel
Identify the Elements on the Excel Interface
The Ribbon & Backstage View
The Quick Access & Formula Toolbar
Lab: Identifying Elements of the User Interface
Navigate and Select Cells in Worksheets
Lab: Working with Cells
Customize the Excel Interface
Lab: Customizing the Excel User Interface
Create a Basic Worksheet
Data Types
Commands
Lab: Entering Data in an Excel Worksheet

Lesson 2: Performing Calculations in an Excel Worksheet
Create Formulas in a Worksheet
Insert Functions in a Worksheet
Reuse Formulas
Create Basic Calculations
Lab: Creating Formulas
Insert Functions in a Worksheet
Function Categories
Commonly Used Functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA
Lab: Calculating Values Using Functions
Reuse Formulas
Relative and Absolute References
Lab: Copying Formulas and Functions

Lesson 3: Modifying an Excel Worksheet
Edit Worksheet Data
Undo and Redo Commands
Auto Fill Feature and Options
The Transpose Option
Lab: Manipulating Data
Find and Replace Data and Advanced Search Option
The Replace Command and Spelling Dialog Box
Lab: Searching for Data in a Worksheet
Lab: Checking a Worksheet for Spelling Errors
Manipulate Worksheet Elements
Insert and Delete, Column Width and Row Height Alternation Methods
Lab: Adjusting Columns

Lesson 4: Modifying the Appearance of a Worksheet
Apply Font Properties
The Font Group and Format Cells Dialog Box
Lab: Modifying Fonts
Add Borders and Colors to Cells
Lab: Adding Borders and Colors to Cells
Align Content in a Cell
Alignment Options and Indent Command
The Wrap Text, Orientation and Merge Options
Lab: Positioning the Content in a Cell
Apply Number Formatting
Lab: Applying a Number Format
Apply Cell Styles and Lab: Applying Cell Styles

Lesson 5: Managing an Excel Workbook
Manage Worksheets
Insertion and Deletion Options
Worksheet Repositioning Methods
Tab Formatting Option
Hide and Unhide Option
Lab: Formatting Worksheet Tabs
Lab: Organizing a Workbook
View Worksheets and Workbooks
Freeze Panes Options
The Split, Arrange All and View Side by Side Commands
The Switch Windows and New Window Commands
Lab: Viewing a Large Worksheet

Lesson 6: Printing Excel Workbooks
Define the Page Layout
Headers and Footers
Page Margins and Page Orientation
The Print Titles Commands
Page Breaks and Options
Lab: Adding Headers and Footers
Lab: Setting the Page Layout and Previewing a Worksheet
Print a Workbook
The Print Area and Scaling Options
Lab: Setting the Print Area

Appendix A: Microsoft Office Excel 2010 Exam 77-882

Appendix B: Microsoft Office Excel 2010 Expert Exam 77-888