Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

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

    Excel 2010 Essentials

    Subscriber Reviews • Browse Similar Topics

    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.7142857142857144 out of 5 rating Based on 7 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