| Microsoft Excel 2010 Tutorials Online |
 |
|
Description Microsoft Excel 2010
VTC's Microsoft Excel course is intended for users of all levels. Whether you are working on a simple spreadsheet or a complex analysis, it’s all covered. Learn how to master the wide array of tools contained in Excel with efficiency, accuracy, and productivity. This course will help students master the art of spreadsheet design. You will learn formulas and functions, along with the database-oriented features such as pivot tables and filters. Learn about the new features of Excel 2010 and tips to increase the readability of your spreadsheets. Although taught using Excel 2010, this course is appropriate for all versions of Excel. Work files are included. To begin learning today, simply click on the movie links. |
| Sample - Preview the First 3 chapters of Microsoft Excel 2010 video free. Free learning Microsoft Excel 2010 online. |
01 Welcome to Excel
0101 Introduction
0102 Course Objectives
02 Menus / Shortcuts / Commands
0201 Touring the Excel Screen
0202 Understanding the Backbone of File Management
0203 Compatibility with Earlier Versions
03 Getting Started
0301 Starting Excel
0302 Multiple Methods for Tasks
0303 Moving Around
04 Customizing Your Screen
0401 Customizing the Ribbon
0402 Quick Access Bar
0403 Quick View of Shortcuts
05 Building a Framework
0501 Creating a New Spreadsheet
0502 Table Features
0503 Saving / Sending / Publishing
06 Editing Techniques
0601 Home Ribbon pt. 1
0602 Home Ribbon pt. 2
0603 Adjusting Columns and Rows
0604 AutoCorrect and Spell Check
07 Manipulating Data
0701 Finding and Replacing Data
0702 Using AutoFill
0703 Customizing AutoFill
08 Adding Special Effects
0801 SmartArt pt. 1
0802 SmartArt pt. 2
0803 Shapes and Pictures
09 Using Different View
0901 Using Excel Options
0902 Options Continued
0903 The View Menu
0904 Splitting the Screen
0905 Arranging Multiple Workbooks
10 Visualizing Worksheets
1001 Conditional Formatting
1002 Setting Rules for Conditions
1003 Rules Continued
1004 Alignment and Text Customization
1005 More Customization
11 Protecting Your Work
1101 Hiding Cells and Worksheets
1102 Selecting Visible Cells
1103 Protection
1104 Validation
1105 Validation Messages
1106 Validating Dates
1107 The Trust Center
12 Linking with Paste Special
1201 Using Paste Special
1202 Linking Data between Worksheets
1203 Linking with Multiple Workbooks
1204 Linking to Other Applications
1205 Linking with a Formula
13 Printing
1301 The Page Layout Menu
1302 Headers and Footer
1303 Print Headings on All Pages
1304 Wrapping Up the Page Layout Menu
14 Templates
1401 Using Templates
1402 Creating a Custom Template
1403 Working with Comments
1404 Creating Hyperlinks
15 Cell References
1501 Understanding Addressing
1502 Absolute vs. Relative
16 Introducing Formulas
1601 The Formula Menu
1602 The Basics: Order of Operations
1603 Calculating Totals with AutoSum
1604 Printing vs. Viewing Calculations
1605 Basic Formula Examples
1606 Insert Function
17 Advance Formulas and Functions
1701 Functions vs. Formulas
1702 Creating Formulas (Countif)
1703 Names
1704 Creating Formulas with Names (Countif)
1705 The IF Statement
1706 Conditional Statement Examples
1707 Formulas Manipulating Text
1708 Formula and Function Errors
18 Working with Tables
1801 Working with Excel Tables
1802 Understanding Limitations and Compatibility
1803 Calculating Table Data Totals
19 Sorting and Filtering
1901 Sorting Data
1902 Using the Filter Tool
1903 Applying Advanced Filters
1904 Working with Subtotals
1905 Subtotals Continued
20 Charts and Graphics
2001 Creating a Chart
2002 The Design and Format Ribbons
2003 The Layout Ribbon
2004 More Editing Techniques
2005 Moving Charts
2006 Combination Charts
21 Creating a Specialty Chart
2101 Understanding Dialog Box Terminology
2102 Single Point Chart
2103 Detailing the Chart
2104 Recapping Wizards
22 Spicing Up Your Spreadsheets
2201 The Insert Menu
2202 Working with Graphics
2203 The Need for Color
23 Adding Objects
2301 Creating and Formatting AutoShapes
2302 Adding Photos and Shapes
2303 Move / Copy / Resize Graphics
24 Excel Integration
2401 Working with Word
2402 Excel and Other Office Applications pt. 1
2403 Excel and Other Office Applications pt. 2
2404 Creating PDF Files
25 Working with Pivot Tables
2501 What is a Pivot Table?
2502 Formatting Pivots
2503 More Formatting
2504 Calculations
2505 Pivot Charts
26 Working with Databases
2601 Flat vs. Relational Database
2602 Working with External Data
2603 What is a Query?
27 Automation and Macros
2701 Automating Routines
2702 Creating a Macro
2703 More Macros
2704 Macros from Buttons
2705 More Buttons
28 New Features for Your Work
2801 Using Comments
2802 Graphs in Comments
2803 Sparklines
2804 Slicers in Pivots
29 Final Tips
2901 Using Help
2902 Help and Formulas
2903 Work Files
30 Conclusion
3001 Wrap Up
31 Credits
3101 About the Author
sku |
|
