2010 Training Courses

Excel 2010 training courses for training and tutorials

Submit Excel Solution
Submit Solution [Guide]

Recently Added:
Tools Add-ins
Data Tools
Directory Contents Lister
Business Intelligence Dashboards
Automation Add-ins
More Resources:
Excel Help Forum




Follow Business Spreadsheets On:
 
Find Excel Solutions:
Suggested text load results and icon loads solution.
Browse Main Categories: Business Finance | Financial Markets | Operations Management | Excel Productivity

2010 Training Courses

Rate this solution:
(3/5 from 2 votes)
DownloadBuy Now
2010 Training Courses screenshot
Pin It
  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

Download Buy Now
(Pricing is available on the next page)

Related Excel Solutions:Training Courses-Training and Tutorials  Interactive Tutorial-Training and Tutorials  Video Training-Training and Tutorials  Online Training-Training and Tutorials  Training Tutorials-Training and Tutorials  Training for Excel 2013-Training and Tutorials

Share your thoughts with other users: Create your own review
 


Popular Searches




Upgrade Excel with always the latest Office apps
Get Office 365

   
  © 2014 Business Spreadsheets. All Rights Reserved. Legal | About Us