Microsoft Excel 2010 Advanced Level - Step By Step Learning

Current Status

Not Enrolled

Price

$29.95

Get Started

Course Content

Expand All

Intermediate Level

Lesson 1 Multiple Pages, Worksheets and Workbooks 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

1.1 Introduction (Intermediate L1)

1.2 Viewing and Arranging Multiple Worksheet Windows

1.3 Linking Data Between Worksheets

1.4 Navigating in Multiple Workbooks

1.5 Linking Workbooks

1.6 Selecting Multiple Workbooks

1.7 Creating and Opening a Workspace

1.8 Freezing Panes

Lesson 2 Creating Charts 11 Topics

Expand

Lesson Content

0% Complete 0/11 Steps

2.1 Introduction (inter L2)

2.2 Creating a Chart with Consecutive Data

2.3 Creating a Chart with Non-Consecutive Data

2.4 Moving and Resizing chart Objects

2.5 Deleting Chart Objects

2.6 Adding Titles and Legends to the Chart

2.7 Changing the Chart Type

2.8 Changing the Chart Colors

2.9 Displaying the Data Table

2.10 Using the Charting Tools

2.11 Printing Charts

Lesson 3 Intermediate Formula Techniques 11 Topics

Expand

Lesson Content

0% Complete 0/11 Steps

3.1 Introduction (Inter L3)

3.2 Using Named Ranges in Formulas

3.3 Using Absolute and Relative Cell References

3.4 Copying Formulas and Functions

3.5 Linking Worksheets with 3-D Formulas

3.6 Creating the PMT Function

3.7 Using the IF Function

3.8 Using the V-Lookup Functions

3.9 Using Nested Functions

3.10 Auditing Worksheets

3.11 Utilizing the Watch Window

Lesson 4 Applying Additional Formatting Techniques 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

4.1 Introduction (Inter L4)

4.2 Using Comments in a Worksheet

4.3 Modifying Existing Styles

4.4 Using Special Number Formats

4.5 Using Themes

Lesson 5 Organizing Worksheet and Table Data 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

5.1 Introduction to Lesson 5

5.2 Creating a Custom AutoFill

5.3 Creating Excel Tables

5.4 Sorting and Filtering Table Data

5.5 Sorting Data Based on Options

5.6 Removing Duplicate Records

5.7 Converting a Table Back to a Normal Cell Range

Lesson 6 Inserting Graphic Objects 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

6.1 Introduction to Lesson 6

6.2 Inserting Pictures and ClipArt

6.3 Modifying Pictures and ClipArt

6.4 Drawing and Modify Shapes

6.5 Using SmartArt Graphics

6.6 Formatting Graphics Objects

6.7 Layering and Grouping Graphic Objects

6.8 Using the Screenshot Tool

Lesson 7 Analyzing Data with Pivot Tables and Pivot Charts 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

7.1 Introduction (Inter L7)

7.2 Creating a Pivot Table

7.3 Modifying the Pivot Table

7.4 Filtering Data Using Slicers

7.5 Analyzing Data Using Pivot Charts

Lesson 8 Finishing Details 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

8.1 Introduction to Lesson 8

8.2 Setting the Print Area

8.3 Hyperlinking to Other Locations

8.4 Saving the Workbook as a Template

8.5 Changing Excel Properties

8.6 Customizing the Quick Access Toolbar

Advanced Level

Lesson 1 Recording and Using Macros 13 Topics

Expand

Lesson Content

0% Complete 0/13 Steps

1.1 Introduction (Adv L1)

1.2 Showing the Developer Tab

1.3 Opening Workbooks containing Macros

1.4 Enabling Macro Security in Excel

1.5 Recording a Macros

1.6 Running a Macros

1.7 Understanding Absolute vs. Relative Recording

1.8 Viewing and Modifying Macros

1.9 Assigning Macros to shortcut Keys or to the Quick Access Toolbar

1.10 Assigning Macro to Buttons and Shapes

1.11 Creating a Macro to Automatically Run when the Workbook Opens

1.12 Deleting Macros

1.13 Saving a Workbook Containing Macros

Lesson 2 Advanced Functions 11 Topics

Expand

Lesson Content

0% Complete 0/11 Steps

2.1 Introduction (Adv L2)

2.2 Logical Functions

2.3 Nesting Logical Functions

2.4 Eliminating Extra Spaces within Data

2.5 Changing Text to Proper Case

2.6 Combining Cells using Concatenate

2.7 Extracting a Portion of Text from a Field

2.8 Changing a formula to a Value

2.9 Using the SUMIF Function

2.10 Database Functions

2.11 Displaying and Printing Formulas

Lesson 3 Collaborating with Others 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

3.1 Introduction (Adv L3)

3.2 Protecting Worksheets

3.3 Protecting Workbooks

3.4 Sharing Workbooks

3.5 Setting Revision Tracking

3.6 Reviewing Tracked Revisions

3.7 Merging Workbooks

Lesson 4 Working with Data Tools 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

4.1 Introduction (Adv L4)

4.2 Turning Text into Columns

4.3 Validating Data

4.4 Creating a Data Validation List for Data Entry

4.5 Consolidating Data from Multiple Locations

4.6 Working with Scenarios

4.7 Goal Seek

4.8 Solver

4.9 Creating Sparkline

4.10 Installing the Analysis ToolPak

Lesson 5 Managing Data 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

5.1 Introduction (Adv L5)

5.2 Importing Data into Excel

5.3 Exporting Data from Excel

5.4 Creating Advanced Filters

5.5 Grouping Data

5.6 Ungrouping Data

5.7 Creating an Auto Outline

5.8 Clearing Groups and Outlines

5.9 Using the Subtotal Feature