Lynda.com Excel 2010 Essential Training

Author: Bob Flisser
Duration (hr:min): 06:21
Released on: 6/9/2010
Exercise files: Yes
Software works on: Windows only

In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.

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

Content:

Introduction - 01:35

    Welcome - 0:57 - 7.3 MB
    Using the exercise files - 0:38 - 0.7 MB

1. Getting Started - 19:31

    Exploring three common uses for Excel - 3:17 - 3.3 MB
    Touring the interface - 3:38 - 7.2 MB
    Finding the commands you need - 3:51 - 5.0 MB
    Using Backstage view or the File tab - 3:25 - 3.9 MB
    Maintaining file compatibility - 5:20 - 7.2 MB

2. Worksheet Basics - 21:23

    Creating a worksheet - 5:23 - 5.4 MB
    Techniques for copying and pasting - 3:57 - 4.3 MB
    Entering data automatically with Auto Fill - 4:37 - 5.8 MB
    Targeting large data groups - 4:26 - 6.1 MB
    Changing a worksheet's structure - 3:00 - 3.7 MB

3. Excel Formula Basics - 47:50

    Understanding formulas and functions - 4:41 - 4.6 MB
    Entering data in a worksheet - 3:22 - 3.2 MB
    Adding numbers manually - 5:01 - 4.9 MB
    Adding numbers using Sum and AutoSum - 6:11 - 6.7 MB
    Adding a whole worksheet - 1:48 - 1.9 MB
    Working with numbers in columns - 4:53 - 5.1 MB
    Preventing errors using absolute references - 5:57 - 6.1 MB
    Working with times and dates - 3:08 - 3.4 MB
    Using IF - 4:49 - 4.8 MB
    Using SUMIF and AVERAGEIF - 4:15 - 5.6 MB
    Naming and using cell ranges - 3:45 - 4.1 MB

4. Essential Formatting - 33:57

    Formatting numbers and dates - 7:06 - 7.8 MB
    Applying fonts, background colors, and borders - 4:35 - 5.4 MB
    Adjusting columns, rows, and text - 5:02 - 5.6 MB
    Using conditional formatting - 4:06 - 5.5 MB
    Using custom conditional formatting - 5:49 - 7.7 MB
    Adding pictures and shapes - 7:19 - 9.8 MB

5. Advanced Formatting - 25:27

    Inserting SmartArt - 6:54 - 8.6 MB
    Coordinating a look using themes - 3:22 - 4.8 MB
    Applying built-in styles - 3:16 - 4.7 MB
    Creating and sharing styles - 5:33 - 7.3 MB
    Using templates - 4:09 - 4.6 MB
    Creating and using original templates - 2:13 - 3.1 MB

6. Printing Preparation - 13:23

    Making the pieces fit - 4:57 - 6.1 MB
    Inserting headers and footers - 3:51 - 4.4 MB
    Printing and PDFs - 4:35 - 5.1 MB

7. Large Excel Projects - 34:03

    Finding and replacing data - 3:12 - 4.0 MB
    Freezing panes - 3:00 - 4.9 MB
    Repeating row and column titles - 3:34 - 4.3 MB
    Creating multiple custom worksheet views - 5:18 - 8.8 MB
    Hiding or grouping rows and columns - 5:31 - 7.5 MB
    Managing worksheets - 7:23 - 7.8 MB
    Calculating formulas across worksheets - 6:05 - 7.1 MB

8. Collaborating with Others - 36:34

    Importing and exporting data in Excel - 8:02 - 10.1 MB
    Setting workbook permissions - 6:44 - 7.4 MB
    Inserting and editing comments - 6:49 - 8.5 MB
    Sharing a workbook - 1:25 - 1.8 MB
    Tracking changes - 3:05 - 3.6 MB
    Saving files in shared locations - 10:29 - 12.1 MB

9. Exploring Excel's Database Features - 27:30

    Splitting cell data into multiple cells - 2:22 - 3.0 MB
    Joining data from multiple cells - 4:18 - 5.2 MB
    Basic and multi-field sorting - 6:30 - 8.3 MB
    Using tables to sort and filter data - 4:31 - 6.7 MB
    Inserting automatic subtotals - 3:46 - 4.7 MB
    Creating lookup tables - 6:03 - 6.8 MB

10. Analyzing Data - 32:56

    Using auditing to diagram - 6:03 - 7.1 MB
    Using evaluation in Excel - 2:02 - 2.2 MB
    Working with Goal Seek - 5:29 - 5.8 MB
    Using data tables in formulas - 6:02 - 6.5 MB
    Using scenarios in formulas - 5:28 - 5.9 MB
    Exploring the Analysis Toolpak - 7:52 - 9.0 MB

11. Advanced Analysis with PivotTables - 18:01

    Discovering PivotTables - 2:22 - 2.3 MB
    Creating a basic PivotTable - 2:46 - 3.0 MB
    Modifying a PivotTable - 6:57 - 7.6 MB
    Creating and modifying a PivotChart - 5:56 - 7.1 MB

12. Creating and Using Charts - 26:58

    Choosing chart types - 1:55 - 1.7 MB
    Inserting Sparklines - 3:54 - 4.5 MB
    Creating a column chart - 3:23 - 3.7 MB
    Modifying a column chart - 5:47 - 6.8 MB
    Creating and modifying a pie chart - 6:45 - 8.1 MB
    Placing Excel charts into other Office applications - 5:14 - 5.8 MB

13. Creating and Using Macros - 21:53

    Understanding macros - 3:05 - 2.8 MB
    Recording and using a simple macro - 11:58 - 14.1 MB
    Editing a macro - 6:50 - 7.2 MB

14. Customizing Excel - 20:33

    Customizing the Quick Access toolbar - 3:30 - 4.3 MB
    Customizing the Ribbon bar - 8:44 - 13.2 MB
    Setting Excel options - 8:19 - 9.7 MB

Conclusion - 00:16

    Goodbye - 0:16 - 0.2 MB