Lynda.COM Excel 2010 Essential Training

Author:
Bob Flisser

Duration:
06h 21m

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


Introduction
Welcome           00m 57s
Using the exercise files           00m 38s

1. Getting Started
Exploring three common uses for Excel           03m 17s
Touring the interface           03m 38s
Finding the commands you need           03m 51s
Using Backstage view or the File tab           03m 25s
Maintaining file compatibility           05m 20s

2. Worksheet Basics
Creating a worksheet           05m 23s
Techniques for copying and pasting           03m 57s
Entering data automatically with Auto Fill           04m 37s
Targeting large data groups           04m 26s
Changing a worksheet's structure           03m 00s

3. Excel Formula Basics
Understanding formulas and functions           04m 41s
Entering data in a worksheet           03m 22s
Adding numbers manually           05m 01s
Adding numbers using Sum and AutoSum           06m 11s
Adding a whole worksheet           01m 48s
Working with numbers in columns           04m 53s
Preventing errors using absolute references           05m 57s
Working with times and dates           03m 08s
Using IF           04m 49s
Using SUMIF and AVERAGEIF           04m 15s
Naming and using cell ranges           03m 45s

4. Essential Formatting
Formatting numbers and dates           07m 06s
Applying fonts, background colors, and borders           04m 35s
Adjusting columns, rows, and text           05m 02s
Using conditional formatting           04m 06s
Using custom conditional formatting           05m 49s
Adding pictures and shapes           07m 19s

5. Advanced Formatting
Inserting SmartArt           06m 54s
Coordinating a look using themes           03m 22s
Applying built-in styles           03m 16s
Creating and sharing styles           05m 33s
Using templates           04m 09s
Creating and using original templates           02m 13s

6. Printing Preparation
Making the pieces fit           04m 57s
Inserting headers and footers           03m 51s
Printing and PDFs           04m 35s

7. Large Excel Projects
Finding and replacing data           03m 12s
Freezing panes           03m 00s
Repeating row and column titles           03m 34s
Creating multiple custom worksheet views           05m 18s
Hiding or grouping rows and columns           05m 31s
Managing worksheets           07m 23s
Calculating formulas across worksheets           06m 05s

8. Collaborating with Others
Importing and exporting data in Excel           08m 02s
Setting workbook permissions           06m 44s
Inserting and editing comments           06m 49s
Sharing a workbook           01m 25s
Tracking changes           03m 05s
Saving files in shared locations           10m 29s

9. Exploring Excel's Database Features
Splitting cell data into multiple cells           02m 22s
Joining data from multiple cells           04m 18s
Basic and multi-field sorting           06m 30s
Using tables to sort and filter data           04m 31s
Inserting automatic subtotals           03m 46s
Creating lookup tables           06m 03s

10. Analyzing Data
Using auditing to diagram           06m 03s
Using evaluation in Excel           02m 02s
Working with Goal Seek           05m 29s
Using data tables in formulas           06m 02s
Using scenarios in formulas           05m 28s
Exploring the Analysis Toolpak           07m 52s

11. Advanced Analysis with PivotTables
Discovering PivotTables           02m 22s
Creating a basic PivotTable           02m 46s
Modifying a PivotTable           06m 57s
Creating and modifying a PivotChart           05m 56s

12. Creating and Using Charts
Choosing chart types           01m 55s
Inserting Sparklines           03m 54s
Creating a column chart           03m 23s
Modifying a column chart           05m 47s
Creating and modifying a pie chart           06m 45s
Placing Excel charts into other Office applications           05m 14s

13. Creating and Using Macros
Understanding macros           03m 05s
Recording and using a simple macro           11m 58s
Editing a macro           06m 50s

14. Customizing Excel
Customizing the Quick Access toolbar           03m 30s
Customizing the Ribbon bar           08m 44s
Setting Excel options           08m 19s

Conclusion
Goodbye           00m 16s