Integrity Training – Microsoft Office Excel 2010: Intermediate
This very basic training course on Microsoft Windows 7 is part of the two course series on Microsoft Windows 7 operating system. The course gives an overview of the new features in Microsoft Windows 7 operating system and enables the students to navigate through Windows 7 interface by learning the basic concepts. This basic course is designed for inexperienced professionals who are beginning to use personal computers at their home, office or educational institute.
Microsoft Windows is the most widely used personal computer operating system in the world. Anyone who wants to use computers should have a little know-how of this operating system. This course develops the essential skills of navigation and usage of Windows 7 so that the beginners get the feel of the interface and the features it has to offer.
Course Curriculum
- Start
Course Introduction (0:52)
- Start
Instructor Introduction (0:22)
- Start
Instructor Introduction A (0:10)
- Start
Using Multiple Worksheets and Workbooks (0:20)
- Start
Topic A: Using Multiple Workbooks (0:05)
- Start
Switch Between Workbooks (0:23)
- Start
Demo – A-1: Switching Between Workbooks (1:10)
- Start
The Move or Copy Dialog Box (1:19)
- Start
Demo – A-2: Copying a Worksheet to Another Workbook (1:28)
- Start
Topic B: Linking Worksheets with 3-D Formulas (0:09)
- Start
Inserting a 3-D Reference (0:59)
- Start
Demo – B-1: Creating 3-D Formulas (1:49)
- Start
Adding a Watch Window (0:42)
- Start
Demo – B-2: Adding a Watch Window (1:44)
- Start
Topic C: Linking Workbooks (0:05)
- Start
Demo – C-1: Examining External Links in a Worksheet (1:52)
- Start
Syntax for External Links (0:52)
- Start
Creating External Links (0:25)
- Start
Demo – C-2: Creating External Links in a Worksheet (1:22)
- Start
Redirecting Links (1:32)
- Start
Demo – C-3: Editing Links (2:51)
- Start
Topic D: Managing Workbooks (0:08)
- Start
Creating a Workspace (0:53)
- Start
Demo – D-1: Creating a Workspace (3:07)
- Start
Unit 01 Review (0:15)
- Start
Unit 01 Quiz
- Start
Advanced Formatting (0:21)
- Start
Topic A: Using Special Number Formats (0:07)
- Start
The Format Cells, Number Tab (0:54)
- Start
Demo – A-1: Applying Special Formats (2:01)
- Start
Hiding Zero Values (0:33)
- Start
Demo – A-2: Controlling the Display of Zero Values (1:05)
- Start
Customizing Number Formats (0:55)
- Start
Custom Number Formats (0:40)
- Start
Demo – A-3: Creating Custom Formats (3:26)
- Start
Topic B: Using Functions to Format Text (0:08)
- Start
Text Functions (1:27)
- Start
Demo – B-1: Using PROPER, UPPER, and LOWER (3:27)
- Start
The SUBSTITUTE Function (1:08)
- Start
Demo – B-2: Using SUBSTITUTE (2:32)
- Start
Topic C: Working with Styles (0:10)
- Start
The Cell Styles Gallery (1:03)
- Start
Creating Styles (0:43)
- Start
Demo – C-1: Creating and Applying Styles (3:50)
- Start
Modifying Styles (0:51)
- Start
Demo – C-2: Modifying Styles (1:25)
- Start
Topic D: Working with Themes (0:07)
- Start
Theme Colors (1:27)
- Start
Demo – D-1: Changing to a Different Theme (4:17)
- Start
Creating New Theme Colors (0:48)
- Start
Topic E: Other Advanced Formatting (0:11)
- Start
Merging Cells (0:42)
- Start
Wrap Text in a Cell (0:41)
- Start
Changing Orientation of Text (0:49)
- Start
Demo – E-1: Merging Cells (0:59)
- Start
Demo – E-2: Changing the Orientation of Text in a Cell (0:46)
- Start
Demo – E-3: Splitting Cells (1:20)
- Start
Transposing Data (0:49)
- Start
Demo – E-4: Transposing Data During a Paste (1:23)
- Start
Use Paste Special to Add Values (0:40)
- Start
Demo – E-5: Using Paste Special to Add Values (2:10)
- Start
Adding Backgrounds (0:31)
- Start
Demo – E-6: Adding and Deleting Backgrounds (2:22)
- Start
Adding a Watermark (0:47)
- Start
Demo – E-7: Adding a Watermark (1:12)
- Start
Unit 02 Review (0:22)
- Start
Unit 02 Quiz
Get Integrity Training – Microsoft Office Excel 2010: Intermediate at tenco.pro
Reviews
There are no reviews yet.