Nabídka tohoto termínu kurzu již není aktuální. Podobné kurzy naleznete zde.

Excel 2010 - Part 1

kurz

Základní info

Duration
Classroom Learning - 1 Day(s)
Mentored Learning - Flexible
Online LIVE - 1 Day(s)
Online ANYTIME - Self Paced

Overview
In this course, students will use Microsoft® Office Excel® 2010 to create spreadsheets and workbooks that they can use to store, manipulate, and share data.

Who Should Attend
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.

At Course Completion
Upon successful completion of this course, students will be able to: - create a basic worksheet using Microsoft® Office Excel® 2010. - perform calculations in an Excel worksheet. - modify an Excel worksheet. - format a worksheet. - print Excel workbook contents. - manage an Excel workbook.

Suggested Next Steps

Excel 2010 - Part 2

Outline

Lesson 1: Getting Started with Microsoft Office Excel 2010

Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Excel Help

Lesson 2: Performing Calculations

Create Worksheet Formulas
Insert Functions
Reuse Formulas

Lesson 3: Modifying a Worksheet

Insert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

Modify Fonts
Add Borders and Colors to Worksheets
Apply Number Formats
Align Cell Contents
Apply Styles and Themes
Apply Basic Conditional Formatting
Create and Use Templates

Lesson 5: Printing Workbooks

Preview and Print a Workbook
Define the Page Layout

Lesson 6: Managing Workbooks

Manage Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties