Microsoft Office Excel 2010: Intermediate

Name: Microsoft Office Excel 2010: Intermediate
Rating: 4.2 (14 reviews)

Created byStone River eLearning

Last updated 11/2018

English

What you'll learn

Use multiple worksheets and workbooks
Use special number formats
Outline and consolidate data
Define cell and range names
Sort and filter data in tables
Save workbooks as webpages
Learn advanced chart formatting
Perform worksheet audit
Insert comments in cells and workbooks
Use built-in templates
Learn about PivotTables and PivotCharts

Course content

11 sections • 245 lectures • 4h 11m total length

Course Introduction0:52
Instructor Introduction0:22
Instructor Introduction A0:10

Using Multiple Worksheets and Workbooks0:20
Topic A: Using Multiple Workbooks0:05
Switch Between Workbooks0:23
Demo - A-1: Switching Between Workbooks1:10
The Move or Copy Dialog Box1:19
Demo - A-2: Copying a Worksheet to Another Workbook1:28
Topic B: Linking Worksheets with 3-D Formulas0:09
Inserting a 3-D Reference0:59
Demo - B-1: Creating 3-D Formulas1:49
Adding a Watch Window0:42
Demo - B-2: Adding a Watch Window1:44
Topic C: Linking Workbooks0:05
Demo - C-1: Examining External Links in a Worksheet1:52
Syntax for External Links0:52
Creating External Links0:25
Demo - C-2: Creating External Links in a Worksheet1:22
Redirecting Links1:32
Demo - C-3: Editing Links2:51
Topic D: Managing Workbooks0:07
Creating a Workspace0:53
Demo - D-1: Creating a Workspace3:07
Unit 01 Review0:15
Review - Question

Advanced Formatting0:21
Topic A: Using Special Number Formats0:07
The Format Cells, Number Tab0:54
Demo - A-1: Applying Special Formats2:01
Hiding Zero Values0:33
Demo - A-2: Controlling the Display of Zero Values1:05
Customizing Number Formats0:55
Custom Number Formats0:40
Demo - A-3: Creating Custom Formats3:26
Topic B: Using Functions to Format Text0:08
Text Functions1:27
Demo - B-1: Using PROPER, UPPER, and LOWER3:27
The SUBSTITUTE Function1:08
Demo - B-2: Using SUBSTITUTE2:32
Topic C: Working with Styles0:10
The Cell Styles Gallery1:03
Creating Styles0:43
Demo - C-1: Creating and Applying Styles3:50
Modifying Styles0:51
Demo - C-2: Modifying Styles1:25
Topic D: Working with Themes0:07
Theme Colors1:27
Demo - D-1: Changing to a Different Theme4:17
Creating New Theme Colors0:48
Topic E: Other Advanced Formatting0:11
Merging Cells0:42
Wrap Text in a Cell0:41
Changing Orientation of Text0:49
Demo - E-1: Merging Cells0:59
Demo - E-2: Changing the Orientation of Text in a Cell0:46
Demo - E-3: Splitting Cells1:20
Transposing Data0:49
Demo - E-4: Transposing Data During a Paste1:23
Use Paste Special to Add Values0:40
Demo - E-5: Using Paste Special to Add Values2:10
Adding Backgrounds0:31
Demo - E-6: Adding and Deleting Backgrounds2:22
Adding a Watermark0:47
Demo - E-7: Adding a Watermark1:12
Unit 02 Review0:22
Review - Question

Outlining and Subtotals0:18
Topic A: Outlining and Consolidating Data0:05
The Expanded Outline Form0:47
The Collapsed Outline Form0:38
Demo - A-1: Creating an Outline2:49
Create a Custom View0:41
Switch Among Custom Views0:22
Demo - A-2: Creating Custom Views1:42
The Consolidate Dialog Box1:25
Demo - A-3: Using the Consolidate Command4:19
Topic B: Creating Subtotals0:04
The Subtotal Dialog Box1:25
Demo - B-1: Creating Subtotals in a List3:01
Demo - B-2: Using Multiple Subtotal Functions1:57
Unit 03 Review0:17
Review - Question

Cell and Range Names0:19
Topic A: Creating and Using Names0:05
Defining Names0:50
Demo - A-1: Naming and Selecting Ranges1:21
Using Names in Formulas0:51
Demo - A-2: Using Names in Formulas1:49
Using Create from Selection1:07
Demo - A-3: Using the Create from Selection Command2:12
Applying Names1:07
Demo - A-4: Applying Names to Existing Formulas4:14
Topic B: Managing Names0:05
The Name Manager Dialog Box0:43
Demo - B-1: Modifying and Deleting Named Ranges2:15
Creating a 3-D Name1:26
Demo - B-2: Defining and Applying 3-D Names2:26
Unit 04 Review0:15
Review - Question

Tables0:23
Topic A: Sorting and Filtering Data0:05
Structure of Organized Data1:24
Sorting Data Based on a Cell0:37
Sorting by Multiple Columns0:45
Demo - A-2: Sorting Data1:29
Filtering Data0:44
Sort and Filter by Color1:05
Demo - A-3: Filtering Data by Using AutoFilter2:23
Topic B: Advanced Filtering0:09
Custom AutoFilter Dialog Box0:56
Demo - B-1: Using Custom AutoFilter Criteria1:50
Creating a Criteria Range0:51
Demo - B-2: Using the Advanced Filter Dialog Box2:45
Copying the Filtered Data1:14
Topic C: Working with Tables0:04
Creating a Table1:02
Table Tools | Design Tab1:00
Adding to a Table0:35
Demo - C-1: Creating a Table0:51
Demo - C-2: Formatting a Table1:13
Demo - C-3: Adding and Deleting Rows and Columns1:35
Structured References1:07
Demo - C-4: Using Structured References1:17
Table Names0:28
The [@] Argument1:02
Unit 05 Review0:24
Review - Question

Web and Sharing Features0:20
Topic A: Saving Workbooks as Web Pages0:05
Customizing the Quick Access Toolbar0:27
Saving a Workbook as a Web Page0:38
Demo - A-2: Saving a Workbook as a Web Page1:42
Publishing a Web Page0:30
The Publish as Web Page Dialog Box0:54
Topic B: Using Hyperlinks0:05
Inserting a Hyperlink0:39
Demo - B-1: Inserting a Hyperlink2:21
Modify a Hyperlink0:47
Demo - B-2: Modifying and Deleting a Hyperlink2:02
Topic C: Sharing Workbooks0:05
File Save & Send Page Options0:14
Demo - C-1: Examining Workbook Sharing Options0:48
Save & Send Options1:29
Sharing Workbooks by Email0:23
Unit 06 Review0:20
Review - Question

Advanced Charting0:20
Topic A: Chart Formatting Options0:05
Format Axis: Axis Options0:52
Demo - A-1: Adjusting the Scale of a Chart1:14
Labeling a Data Point0:21
Demo - A-2: Formatting a Data Point2:07
Topic B: Combination Charts0:04
Combination Chart: Changing Chart Type0:23
Combination Chart: Adding a Secondary Axis0:22
Demo - B-1: Creating a Combination Chart1:20
Adding a Trendline0:22
Demo - B-2: Creating a Trendline0:43
Inserting Sparklines0:48
Sparklines in a Worksheet0:24
Demo - B-3: Inserting Sparklines1:39
Downloading a Chart Template1:44
Topic C: Graphical Elements0:07
Adding Shapes to Charts0:20
Demo - C-1: Adding Graphical Elements2:31
Formatting Graphical Elements0:25
Demo - C-2: Formatting a Graphical Element1:15
Inserting a Picture from a File0:26
Demo - C-3: Adding a Picture to a Worksheet0:56
The Adjust Group2:09
Demo - C-4: Modifying a Picture2:30
Unit 07 Review0:20
Review - Question

Documenting and Auditing0:27
Topic A: Auditing Features0:05
Dependent and Precedent Cells0:29
Demo - A-1: Tracing Precedent and Dependent Cells2:17
Tracing Errors in a Worksheet0:16
Demo - A-2: Tracing Errors1:22
Topic B: Comments in Cells and Workbooks0:06
Viewing Comments0:25
Demo - B-1: Viewing Comments in a Worksheet1:02
Adding Cell Comments0:13
Demo - B-2: Adding a Comment to a Cell1:57
The Document Panel0:35
Topic C: Protection0:06
Password-Protect a Worksheet0:25
Demo - C-1: Password-Protecting a Worksheet1:42
Protect Parts of a Worksheet0:46
Demo - C-2: Unlocking Cells and Protecting Part of a Worksheet1:05
Protect the Workbook Structure1:09
Demo - C-3: Protecting the Workbook Structure2:42
Using Digital Signatures0:38
Topic D: Workgroup Collaboration0:10
Sharing a Workbook0:31
Demo - D-1: Sharing a Workbook0:47
Share Workbook: Advanced Tab0:41
Tracking Changes0:32
Accepting and Rejecting Changes0:35
Demo - D-3: Tracking Changes in a Workbook2:01
Using the Document Inspector1:05
Marking a Workbook as Final0:33
Demo - D-5: Marking a Workbook as Final1:41
Unit 08 Review0:25
Review - Question

Templates and Settings0:21
Topic A: Application Settings0:06
The Excel Options Dialog Box0:57
Demo - A-1: Changing Application Settings3:52
The Customize Ribbon Page0:43
Demo - A-2: Customizing the Ribbon2:05
Topic B: Built-in Templates0:07
Available Templates1:00
Using the Sales Invoice Template0:22
Demo - B-1: Using a Downloaded Template2:17
Topic C: Creating and Managing Templates0:06
Creating a Template0:38
Demo - C-1: Creating a Template1:36
Modifying a Template0:21
Demo - C-2: Modifying a Template1:36
Using an Alternate Template Location0:27
Unit 09 Review0:21
Review - Question

Requirements

The course requires the students to have hands-on experience and knowledge of Microsoft Office 2007 or any other older version of Microsoft Office especially Microsoft Office Excel.
In addition to that, a good knowledge of getting around with Microsoft Windows operating system is required as well.
The students should also complete the previous level course before registering for this course.

Description

The Microsoft Excel 2010 L2 course is the second course in a three course series on Microsoft Office Excel 2010 that covers the intermediate-level topics regarding Microsoft Excel 2010. The course builds on the concepts learnt in the L1 course and covers the more advanced concepts like 3D formulas, advanced formatting, using trend lines, worksheet auditing and protection. The course also provides a smooth transition opportunity to students to upgrade to Microsoft Office Excel 2010.

Microsoft Office Excel 2010 is an essential application for students, office workers, executives, accountants and financial analysts. This course helps the candidates to get started with the latest version of Microsoft Office Excel. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Excel 2010 to achieve excellence in the daily routine tasks.

Who this course is for:

Candidates planning to upgrade to Microsoft Office Excel 2010
Candidates responsible to manage and maintain Excel workbooks at their workplaces
Accounting and finance professionals
University students

Microsoft Office Excel 2010: Intermediate

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 1min

Unit 01 - Using Multiple Worksheets and Workbooks22 lectures • 23min

Unit 02 - Advanced Formatting40 lectures • 49min

Unit 03 - Outlining and Subtotals15 lectures • 20min

Unit 04 - Cell and Range Names16 lectures • 21min

Unit 05 - Tables27 lectures • 27min

Unit 06 - Web and Sharing Features18 lectures • 14min

Unit 07 - Advanced Charting26 lectures • 24min

Unit 08 - Documenting and Auditing31 lectures • 27min

Unit 09 - Templates and Settings17 lectures • 17min

Requirements

Description

Who this course is for: