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

Excel 2013 - Part 1*

kurz

Základní info

Duration
Classroom Learning - 1 Day(s)
Online LIVE - 1 Day(s)

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

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

Prerequisite(s) or equivalent knowledge

Using Microsoft Windows 8

Suggested Next Steps

Excel 2013 - Part 2

Outline

Lesson 1: Getting Started with Microsoft Office Excel 2013

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