• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z

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.

Course Excel 2010 Essential Training Author Bob Flisser SKU ISBN Release Date 2010-06-09 Duration 6.21 hrs / 80 tutorials Work files Yes Price $ 59.95 Retail price $ 99.95 Language Tags Excel

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 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 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 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 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 6. Printing Preparation Making the pieces fit 04:57 Inserting headers and footers 03:51 Printing and PDFs 04:35 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 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 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 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 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 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 13. Creating and Using Macros Understanding macros 03:05 Recording and using a simple macro 11:58 Editing a macro 06:50 14. Customizing Excel Customizing the Quick Access toolbar 03:30 Customizing the Ribbon bar 08:44 Setting Excel options 08:19 Conclusion Goodbye 00:16