Home > Excel Business Solutions > Excel Productivity > Training and Tutorials > 2010 Training Courses Share

2010 Training Courses

Excel 2010 training courses for training and tutorials


Excel 2010 Training Courses

Rate this solution:
(3/5 from 2 votes)
2010 Training Courses screenshot
The Excel 2010 training courses provide and interactive environment to learn and master the use and features of Excel 2010. The training courses are divided into 3 levels for introduction to the Excel 2010 application environment, intermediate user lessons and advanced features for data and business analysis. The training courses are designed to be undertaken in a logical order to master all features of Excel 2010 and become proficient in using Excel for analysis and reporting.

Excel 2010 introductory training courses include:
  • Introduction to Excel
  • Data entry and editing Worksheet navigation and basic settings
  • Cell range selection
  • Manipulation with cell ranges
  • Cell inserting and deleting
  • Text and cell formatting
  • Number, Date and Time formats
  • Formatting with the style gallery
  • Working with files and windows
  • Printing smaller tables
  • The AutoSum button and formula copying
  • Custom formula creation
  • Working with functions
  • Chart creation
  • Chart formatting
  • Proofing  and revision
  • Basic Excel settings
  • Getting help for Excel 2010

Excel 2010 intermediate training courses include:
  • Locking and protection
  • Advanced cell formatting
  • Conditional and custom formatting
  • Creating and using templates
  • Workbook properties and work with sheets
  • Sharing workbooks and tracking changes
  • Comments and workbooks comparing
  • Copying options, orders and lists
  • Formula creation and absolute links
  • Errors and formulas dependencies
  • Connected sheets and workbooks
  • The IF, MIN, and COUNT functions
  • Functions and formulas used for Date and Time data
  • Functions for working with text
  • Rounding off
  • Financial functions
  • Techniques of work with relation tables
  • Data validation and sorting
  • Go To, Find and Replace tools
  • Printing larger tables
  • AutoFilters
  • Criteria table and advanced filter
  • Database functions
  • Outlines and totals
  • Splitting text into columns
  • Pivot tables
  • Editing pivot tables and charts
  • Advanced chart editing

Excel 2010 advanced training courses include:
  • Work with range names
  • Form creation in a sheet
  • Protection options within workbooks
  • Conditional calculations
  • Conditional calculations using SUMIF and COUNTIF
  • Working with an array
  • Calculation criteria in database functions
  • Using functions for searching in tables
  • Data importing
  • Work with Microsoft Query
  • Complicated queries in Microsoft Query
  • Data merging
  • Sheet scenarios
  • Resolver
  • What-if analysis and goal seek
  • Statistical methods and functions Macros recording and usage
  • The VBA code view and editing
  • Webpages, links and e-mail sending
  • File security
  • Permission control
  • Introduction to XML
  • Working with data in the XML format

Try It  Get It

(Pricing is available on the next page)

Related Excel Solutions for 2010 Training Courses

Training CoursesTraining and Tutorials  Interactive TutorialTraining and Tutorials  Video TrainingTraining and Tutorials  Online TrainingTraining and Tutorials  Training for Excel 2013Training and Tutorials

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum or proposed as a project to the Excel freelance community.