Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

This series is for anyone who wants to know Excel in a non-intimidating, soup-to-nuts manner. If you've never used Excel, this is your starting point. No prior experience is necessary. If you've used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so you are efficient and accurate. If you've used previous versions of Excel (prior to Office 2007) then there are a lot of features and changes you need to be aware of to fully utilize this software. In this course we take you from start to finish including entering data, configuring workbooks, working with calculations, applying regular and conditional formatting, creating custom formats, using names, leveraging the power of tables and charts and outputting your work. These are the skills every Excel user needs to know no matter how new or how experienced you may be!

Subscriber Reviews

Average Rating: 3.875 out of 5 rating Based on 8 Ratings

"Excel 2010 Basics" - by Entire course on 08-FEB-2013
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
This course is very useful and great.
Report as Inappropriate

Table of Contents

Chapter/Selection

Time

GETTING COMFORTABLE WITH EXCEL

Introduction

Preview

00:00:05

Introducing Excel

Preview

00:12:26

Recognizing Interface Features Unique to Excel

Preview

00:05:17

Understanding Workbook Structure

Preview

00:10:28

Navigating through Workbooks

Preview

00:10:22

Making Workbook Selections

Preview

00:12:18

THE BASICS OF DATA

Introduction

Preview

00:00:05

Entering Text

Preview

00:09:46

Entering Dates & Numbers

Preview

00:08:12

Editing Cell Entries

Preview

00:07:01

Copying & Moving Data

Preview

00:07:29

Filling a Series

Preview

00:08:51

MANAGING WORKBOOK STRUCTURE

Introduction

Preview

00:00:05

Modifying Workbook & Worksheet Structure

Preview

00:14:10

Resizing Worksheet Elements

Preview

00:05:58

Hiding Workbook Components

Preview

00:07:25

CREATING FORMULAS

Introduction

Preview

00:00:05

Excel Calculations 101

Preview

00:07:27

Entering Formulas

Preview

00:07:25

Enforcing Absolute Referencing

Preview

00:11:32

Controlling Calculation Options

Preview

00:07:02

THE BASICS OF FUNCTIONS

Introduction

Preview

00:00:05

The Foundation of Functions

Preview

00:06:10

Using AutoSum & the Formulas Tab

Preview

00:09:32

Using Function AutoComplete

Preview

00:10:02

WHAT'S IN A NAME?

Introduction

Preview

00:00:05

Creating Named Cells

Preview

00:07:47

Defining Names

Preview

00:05:55

Creating Names from Selections

Preview

00:05:06

Creating Named Formulas

Preview

00:05:21

Using Names as References

Preview

00:08:37

Managing & Displaying Names

Preview

00:10:06

MAKING DATA LOOK GOOD

Introduction

Preview

00:00:05

Applying Basic Formatting

Preview

00:14:20

Formatting Numbers

Preview

00:08:40

Exploring the Format Cells Dialog Box

Preview

00:13:44

Defining Custom Formats

Preview

00:12:22

Creating & Applying Cell Styles

Preview

00:07:07

Conditional Formatting

Preview

00:06:40

Applying & Editing Conditional Formatting Rules

Preview

00:10:52

A PICTURE IS WORTH A THOUSAND WORDS

Introduction

Preview

00:00:05

Getting In-Cell Summaries with Sparklines

Preview

00:11:03

Creating Charts

Preview

00:03:06

Modifying Chart Design

Preview

00:10:45

Working with Chart Layout & Format

Preview

00:07:57

Saving & Using a Chart Template

Preview

00:05:26

THE SIMPLICITY OF TABLES

Introduction

Preview

00:00:05

Converting Data Ranges to Tables

Preview

00:06:16

Modifying Table Formatting

Preview

00:05:30

Working with Table Records

Preview

00:06:05

Using Table Calculations

Preview

00:06:39

Sorting Data

Preview

00:11:44

Creating Custom Lists

Preview

00:07:11

Filtering Data

Preview

00:10:10

MANAGING THE EXCEL ENVIRONMENT

Introduction

Preview

00:00:05

Configuring Excel Options

Preview

00:04:48

Adjusting the View

Preview

00:07:18

Controlling Excel Windows

Preview

00:07:47

PREPARING FILES FOR DISTRIBUTION

Introduction

Preview

00:00:05

Print Area, Print Titles & Sheet Options

Preview

00:08:04

Renaming Sheets & Adding Headers/Footers

Preview

00:08:28

Printing Worksheets

Preview

00:05:52

Credits

Preview

00:00:12

Extras

The publisher has provided additional content related to this title.


Description
Content

Exercise file

  • TXL10ES-P01-PF.zip