How to use Excel 2010 | Video Tutorials for Beginners

or

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

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

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.

or

Tweet