Excel 2010 Intermediate

Excel 2010 is the most powerful spreadsheet software for the modern office. This course provides a comprehensive overview of the more advanced features and functions of the Excel 2010 spreadsheet software, from producing a professional-looking financial statement to using charts and graphs to spot sales trends at a glance. It's compatible with 2010 operating systems.

• This course is for experienced computer users who are already confident using the basics of Excel 2010, or are confident users of older versions of Excel.

You'll learn how to:

• understand the differences between relative and absolute cell referencing
• use a range of formulae to complete complex calculations
• work with advanced commands on the format menu
• use multiple workbooks and create 3D formulas
• split windows, freeze frames and hide columns when working with large spreadsheets
• create and format charts to highlight trends
• publish workbooks as web pages for viewing or collaboration

Modules:

There are 11 modules in this eCourse:

• Worksheets
• Using Functions
• Creating Charts
• Formatting Charts
• Formatting Menu Options
• Splitting, Freezing and Hiding
• 3D Workbooks
• Additional Formatting Features
• Creating a Web Page
• Relative and Absolute References
• Worksheet Design

Course features:

You’ll work through the course online, where you’ll complete a series of exercises with actual Excel 2010 spreadsheets. A quiz at the end of each section lets you practise your new skills and check that you have understood all the techniques covered. You’ll have access to this course for six months from the date of purchase – giving you plenty of time to finish your course.

How this course can help your business:

• Make the most of your investment in IT
• Use information to assess and evaluate business performance
• Make sound business decisions based on accurate data
• Forecast and plan more accurately and effectively
• Improve communication by providing staff with better access to information

Course Code: 103083BT046