CourseForMe

Excel 2010 - Introduction

CompuWorks
CompuWorks

Detailed information

Type:Courses
Method:Online
Duration:4 Hour

Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to register, enrollment limit, availability and more.

Request information

Course program

Table of Contents:


Introduction

Getting Started

Overview

Three Primary Functions of Excel

Spreadsheet Terminology

Overview of the Excel Screen

Open a Workbook

Navigate a Worksheet




Basic Worksheet Skills

Overview

Create a New Workbook

Enter Data

Selecting: Range, Column, Row, Cells

Use a Different Worksheet

Rename Worksheets

Add New Worksheets

AutoFill

Delete Worksheets

Save a Workbook




Creating Formulas

Overview

Understand the Order of Operations

Simple Formulas

Cell Addresses in a Formula

SUM Function

AutoSum

Function Library

MAX Function

MIN Function

Average with AutoSum

COUNT Function

Date Arithmetic

Number Formats in Cells

Relative v. Absolute Cell Addressing

AutoCalculate




Editing a Workbook

Overview

Delete a Range

Undo and Redo

Cut, Copy and Paste

Paste Options

Clipboard Task Pane

Find and Replace




Formatting the Worksheet

Overview

Insert and Delete Columns and Rows

Column Widths and Row Heights

Hide Rows and Columns

Numeric Formats

Text Formats

Align Data

Borders and Shading

Draw Border

Format Painter

Cell Styles

Modify a Cell Style

Create New Cell Styles

Design Theme




Working with Large Worksheets and Multiple Workbooks

Overview

Zoom

Split a Window

Freeze and Unfreeze Panes

Multiple Workbooks

Tile Workbooks

Side-by-Side View

Move and Resize Windows




Using Protection and Comment Boxes

Overview

Comments

Protect a Worksheet




Printing and Page Setup

Overview

Print Preview

Page Break Preview

Printing Options

Page Setup

Headers And Footers

Sheet Options

Print Titles

Print Area

Page Layout Tab




Conclusion

Course location

CompuWorks

When it comes to finding the best training in New England and across the country, CompuWorks is the hands down leader.

For over 23 years CompuWorks has been creating some of the most successful award-winning training programs in the country.

Our goal is to provide our customers with the best training solution possible. This means we don’t use a cookie cutter approach but customize a learning plan that is designed to fit each organization’s unique business needs. Our ability to be innovative, adaptable and creative in handling challenges is the key to our success.

CompuWorks is proud to be both SOMWBA-certified as a woman-owned business and a Microsoft Gold Certified Partner with competencies in Learning Solutions & Information Worker Solutions.

Search similar to IT, ICT and Computing

Courses similar to IT, ICT and Computing

Sponsored links