Lynda.COM Excel 2010 Essential Training

Bob Flisser

Software works on:

Windows only

Topics include:

• Copying and pasting techniques
• Working with formulas and functions
• Dealing with formula errors
• Creating lookup tables
• Naming cell ranges
• Formatting data and worksheets
• Finding and replacing data
• Creating SmartArt diagrams
• Creating charts and PivotTables
• Recording macros
• Sharing workbooks

Introduction
Welcome           00:57
Using the exercise files           00:38
19:31 1. Getting Started
Exploring three common uses for Excel           03:17
Touring the interface           03:38
Finding the commands you need           03:51
Using Backstage view or the File tab           03:25
Maintaining file compatibility           05:20
21:23 2. Worksheet Basics
Creating a worksheet           05:23
Techniques for copying and pasting           03:57
Entering data automatically with Auto Fill           04:37
Targeting large data groups           04:26
Changing a worksheet's structure           03:00
47:50 3. Excel Formula Basics
Understanding formulas and functions           04:41
Entering data in a worksheet           03:22
Adding numbers manually           05:01
Adding numbers using Sum and AutoSum           06:11
Adding a whole worksheet           01:48
Working with numbers in columns           04:53
Preventing errors using absolute references           05:57
Working with times and dates           03:08
Using IF           04:49
Using SUMIF and AVERAGEIF           04:15
Naming and using cell ranges           03:45
33:57 4. Essential Formatting
Formatting numbers and dates           07:06
Applying fonts, background colors, and borders           04:35
Adjusting columns, rows, and text           05:02
Using conditional formatting           04:06
Using custom conditional formatting           05:49
Adding pictures and shapes           07:19
25:27 5. Advanced Formatting
Inserting SmartArt           06:54
Coordinating a look using themes           03:22
Applying built-in styles           03:16
Creating and sharing styles           05:33
Using templates           04:09
Creating and using original templates           02:13
13:23 6. Printing Preparation
Making the pieces fit           04:57
Inserting headers and footers           03:51
Printing and PDFs           04:35
34:03 7. Large Excel Projects
Finding and replacing data           03:12
Freezing panes           03:00
Repeating row and column titles           03:34
Creating multiple custom worksheet views           05:18
Hiding or grouping rows and columns           05:31
Managing worksheets           07:23
Calculating formulas across worksheets           06:05
36:34 8. Collaborating with Others
Importing and exporting data in Excel           08:02
Setting workbook permissions           06:44
Inserting and editing comments           06:49
Sharing a workbook           01:25
Tracking changes           03:05
Saving files in shared locations           10:29
27:30 9. Exploring Excel's Database Features
Splitting cell data into multiple cells           02:22
Joining data from multiple cells           04:18
Basic and multi-field sorting           06:30
Using tables to sort and filter data           04:31
Inserting automatic subtotals           03:46
Creating lookup tables           06:03
32:56 10. Analyzing Data
Using auditing to diagram           06:03
Using evaluation in Excel           02:02
Working with Goal Seek           05:29
Using data tables in formulas           06:02
Using scenarios in formulas           05:28
Exploring the Analysis Toolpak           07:52
18:01 11. Advanced Analysis with PivotTables
Discovering PivotTables           02:22
Creating a basic PivotTable           02:46
Modifying a PivotTable           06:57
Creating and modifying a PivotChart           05:56
26:58 12. Creating and Using Charts
Choosing chart types           01:55
Inserting Sparklines           03:54
Creating a column chart           03:23
Modifying a column chart           05:47
Creating and modifying a pie chart           06:45
Placing Excel charts into other Office applications           05:14
21:53 13. Creating and Using Macros
Understanding macros           03:05
Recording and using a simple macro           11:58
Editing a macro           06:50
20:33 14. Customizing Excel
Customizing the Quick Access toolbar           03:30
Customizing the Ribbon bar           08:44
Setting Excel options           08:19
00:16 Conclusion
Goodbye           00:16