Excel 2010 Essentials

If you've never used Excel, this is your starting point. No prior experience is necessary. If you have used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so you become 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!

Click here to register

E1E01 GETTING COMFORTABLE WITH EXCEL 50:59

1 Introducing Excel

2 Recognizing Interface Features Unique to Excel

3 Understanding Workbook Structure

4 Navigating through Workbooks

5 Making Workbook Selections

E1E02 THE BASICS OF DATA 41:26

1 Entering Text

2 Entering Dates & Numbers

3 Editing Cell Entries

4 Copying & Moving Data

5 Filling a Series

E1E03 MANAGING WORKBOOK STRUCTURE 27:39

1 Modifying Workbook & Worksheet Structure

2 Resizing Worksheet Elements

3 Hiding Workbook Components

E1E04 CREATING FORMULAS 33:32

1 Excel Calculations 101

2 Entering Formulas

3 Enforcing Absolute Referencing

4 Controlling Calculation Options

E1E05 THE BASICS OF FUNCTIONS 25:50

1 The Foundation of Functions

2 Using AutoSum & the Formulas Tab

3 Using Function AutoComplete

E1E06 WHAT'S IN A NAME? 43:00

1 Creating Named Cells

2 Defining Names

3 Creating Names from Selections

4 Creating Named Formulas

5 Using Names as References

6 Managing & Displaying Names

E1E07 MAKING DATA LOOK GOOD 1:14:05

1 Applying Basic Formatting

2 Formatting Numbers

3 Exploring the Format Cells Dialog Box

4 Defining Custom Formats

5 Creating & Applying Cell Styles

6 Conditional Formatting

7 Applying & Editing Conditional Formatting Rules

E1E08 A PICTURE IS WORTH A 1000 WORDS 38:26

1 Getting In-Cell Summaries with Sparklines

2 Creating Charts

3 Modifying Chart Design

4 Working with Chart Layout & Format

5 Saving & Using a Chart Template

E1E09 THE SIMPLICITY OF TABLES 53:43

1 Converting Data Ranges to Tables

2 Modifying Table Formatting

3 Working with Table Records

4 Using Table Calculations

5 Sorting Data

6 Creating Custom Lists

7 Filtering Data

E1E10 MANAGING THE EXCEL ENVIRONMENT 20:00

1 Conguring Excel Options

2 Adjusting the View

3 Controlling Excel Windows

E1E11 PREPARING FILES FOR DISTRIBUTION 22:43

1 Print Area, Print Titles & Sheet Options

2 Renaming Sheets & Adding Headers/Footers

3 Printing Worksheets

4 Credits