Excel 2010 Essential Training by 
CHOOSE AN OPTION TO ACCESS THE ENTIRE LYNDA.COM TRAINING LIBRARY
or 
WATCH THESE 9 FREE VIDEOS FROM THE COURSE
Excel 2010 Essential Training - Welcome
Using Backstage view or the File tab - How to use Excel 2010 | Video Tutorials for Beginners
Adding numbers using Sum and AutoSum - How to use Excel 2010 | Video Tutorials for Beginners
Preventing errors using absolute references - How to use Excel 2010 | Video Tutorials for Beginners
Using templates - How to use Excel 2010 | Video Tutorials for Beginners
Freezing panes - How to use Excel 2010 | Video Tutorials for Beginners
Creating a basic PivotTable - How to use Excel 2010 | Video Tutorials for Beginners
Inserting Sparklines - How to use Excel 2010 | Video Tutorials for Beginners
Customizing the Ribbon bar - How to use Excel 2010 | Video Tutorials for Beginners
Using Backstage view or the File tab - How to use Excel 2010 | Video Tutorials for Beginners
Adding numbers using Sum and AutoSum - How to use Excel 2010 | Video Tutorials for Beginners
Preventing errors using absolute references - How to use Excel 2010 | Video Tutorials for Beginners
Using templates - How to use Excel 2010 | Video Tutorials for Beginners
Freezing panes - How to use Excel 2010 | Video Tutorials for Beginners
Creating a basic PivotTable - How to use Excel 2010 | Video Tutorials for Beginners
Inserting Sparklines - How to use Excel 2010 | Video Tutorials for Beginners
Customizing the Ribbon bar - How to use Excel 2010 | Video Tutorials for Beginners
If you wish to view the rest of the video tutorials from this training course on how to use Excel 2010, you can become a lynda.com member today or sign up for a FREE 7-day trial.
START LEARNING TODAY!
or Course Information
Training Provider: Lynda.com
Title: Excel 2010 Essential Training
Author: Bob Flisser
Duration: 6hrs 21mins
Date of release: 09 June 2010
Chapter 1: Getting Started
Exploring three common uses for Excel
Touring the interface
Finding the commands you need
Using Backstage view or the File tab
Maintaining file compatibility
Chapter 2: Worksheet Basics
Creating a worksheet
Techniques for copying and pasting
Entering data automatically with Auto Fill
Targeting large data groups
Changing a worksheet's structure
Chapter 3: Excel Formula Basics
Understanding formulas and functions
Entering data in a worksheet
Adding numbers manually
Adding numbers using Sum and AutoSum
Adding a whole worksheet
Working with numbers in columns
Preventing errors using absolute references
Working with times and dates
Using IF
Using SUMIF and AVERAGEIF
Naming and using cell ranges
Chapter 4: Essential Formatting
Formatting numbers and dates
Applying fonts, background colors, and borders
Adjusting columns, rows, and text
Using conditional formatting
Using custom conditional formatting
Adding pictures and shapes
Chapter 5: Advanced Formatting
Inserting SmartArt
Coordinating a look using themes
Applying built-in styles
Creating and sharing styles
Using templates
Creating and using original templates
Chapter 6: Printing Preparation
Making the pieces fit
Inserting headers and footers
Printing and PDFs
Chapter 7: Large Excel Projects
Finding and replacing data
Freezing panes
Repeating row and column titles
Creating multiple custom worksheet views
Hiding or grouping rows and columns
Managing worksheets
Calculating formulas across worksheets
Chapter 8: Collaborating with Others
Importing and exporting data in Excel
Setting workbook permissions
Inserting and editing comments
Sharing a workbook
Tracking changes
Saving files in shared locations
Chapter 9: Exploring Excel's Database Features
Splitting cell data into multiple cells
Joining data from multiple cells
Basic and multi-field sorting
Using tables to sort and filter data
Inserting automatic subtotals
Creating lookup tables
Chapter 10: Analyzing Data
Using auditing to diagram
Using evaluation in Excel
Working with Goal Seek
Using data tables in formulas
Using scenarios in formulas
Exploring the Analysis Toolpak
Chapter 11: Advanced Analysis with PivotTables
Discovering PivotTables
Creating a basic PivotTable
Modifying a PivotTable
Creating and modifying a PivotChart
Chapter 12: Creating and Using Charts
Choosing chart types
Inserting Sparklines
Creating a column chart
Modifying a column chart
Creating and modifying a pie chart
Placing Excel charts into other Office applications
Chapter 13: Creating and Using Macros
Understanding macros
Recording and using a simple macro
Editing a macro
Chapter 14: Customizing Excel
Customizing the Quick Access toolbar
Customizing the Ribbon bar
Setting Excel options
Training Provider: Lynda.com
Title: Excel 2010 Essential Training
Author: Bob Flisser
Duration: 6hrs 21mins
Date of release: 09 June 2010
Chapter 1: Getting Started
Exploring three common uses for Excel
Touring the interface
Finding the commands you need
Using Backstage view or the File tab
Maintaining file compatibility
Chapter 2: Worksheet Basics
Creating a worksheet
Techniques for copying and pasting
Entering data automatically with Auto Fill
Targeting large data groups
Changing a worksheet's structure
Chapter 3: Excel Formula Basics
Understanding formulas and functions
Entering data in a worksheet
Adding numbers manually
Adding numbers using Sum and AutoSum
Adding a whole worksheet
Working with numbers in columns
Preventing errors using absolute references
Working with times and dates
Using IF
Using SUMIF and AVERAGEIF
Naming and using cell ranges
Chapter 4: Essential Formatting
Formatting numbers and dates
Applying fonts, background colors, and borders
Adjusting columns, rows, and text
Using conditional formatting
Using custom conditional formatting
Adding pictures and shapes
Chapter 5: Advanced Formatting
Inserting SmartArt
Coordinating a look using themes
Applying built-in styles
Creating and sharing styles
Using templates
Creating and using original templates
Chapter 6: Printing Preparation
Making the pieces fit
Inserting headers and footers
Printing and PDFs
Chapter 7: Large Excel Projects
Finding and replacing data
Freezing panes
Repeating row and column titles
Creating multiple custom worksheet views
Hiding or grouping rows and columns
Managing worksheets
Calculating formulas across worksheets
Chapter 8: Collaborating with Others
Importing and exporting data in Excel
Setting workbook permissions
Inserting and editing comments
Sharing a workbook
Tracking changes
Saving files in shared locations
Chapter 9: Exploring Excel's Database Features
Splitting cell data into multiple cells
Joining data from multiple cells
Basic and multi-field sorting
Using tables to sort and filter data
Inserting automatic subtotals
Creating lookup tables
Chapter 10: Analyzing Data
Using auditing to diagram
Using evaluation in Excel
Working with Goal Seek
Using data tables in formulas
Using scenarios in formulas
Exploring the Analysis Toolpak
Chapter 11: Advanced Analysis with PivotTables
Discovering PivotTables
Creating a basic PivotTable
Modifying a PivotTable
Creating and modifying a PivotChart
Chapter 12: Creating and Using Charts
Choosing chart types
Inserting Sparklines
Creating a column chart
Modifying a column chart
Creating and modifying a pie chart
Placing Excel charts into other Office applications
Chapter 13: Creating and Using Macros
Understanding macros
Recording and using a simple macro
Editing a macro
Chapter 14: Customizing Excel
Customizing the Quick Access toolbar
Customizing the Ribbon bar
Setting Excel options
About Lynda.com
Lynda.com is an online video training provider with over 1000 courses covering a wide array of topics - 3D, video, business, the web, graphic design, programming, animation, photography, and more. They produce top quality video tutorials with the best industry experts as your instructors. With a subscription, you can log-in at any time, and learn at your own pace. New courses are added each week, and you will receive a certificate of completion for each course that you finish.
Start learning today!
If you enjoyed the sample videos above and want to access the entire Excel 2010 Essential Training course, you can sign up for a lynda.com membership. Your membership will allow you to access not only this course, but also the entire lynda.com library for as low as $25 for 1-month. Their training library has over 1000 courses with 50,000+ video tutorials. No long-term commitment required. You can cancel your membership at any time.
Not yet convinced? Try a FREE 7-day trial.
As a special promotion, visitors of this site can get a FREE 7-day trial to lynda.com. This free trial gives you access to their entire training library of over 1000 courses.
If you liked these great-quality Excel 2010 video tutorials for beginners, then sign-up for a lynda.com membership today to view this excellent training course on learning how to use Excel 2010!Lynda.com is an online video training provider with over 1000 courses covering a wide array of topics - 3D, video, business, the web, graphic design, programming, animation, photography, and more. They produce top quality video tutorials with the best industry experts as your instructors. With a subscription, you can log-in at any time, and learn at your own pace. New courses are added each week, and you will receive a certificate of completion for each course that you finish.
Start learning today!
If you enjoyed the sample videos above and want to access the entire Excel 2010 Essential Training course, you can sign up for a lynda.com membership. Your membership will allow you to access not only this course, but also the entire lynda.com library for as low as $25 for 1-month. Their training library has over 1000 courses with 50,000+ video tutorials. No long-term commitment required. You can cancel your membership at any time.
Not yet convinced? Try a FREE 7-day trial.
As a special promotion, visitors of this site can get a FREE 7-day trial to lynda.com. This free trial gives you access to their entire training library of over 1000 courses.
START LEARNING TODAY!
or 
No comments:
Post a Comment