Excel 2010 Beginners

Spreadsheets can process complex numerical data quickly, simply and accurately, and Excel 2010 is the most powerful spreadsheet software for the modern office. This course helps complete beginners master the basics of using spreadsheets with Excel 2010, compatible with 2010 operating systems. It gives a simple, no-nonsense introduction to what Excel 2010 is and the business tasks that it can help with.

• This course is a no-nonsense introduction for complete beginners
• It will also be helpful for those with a very basic experience in older versions of Excel and are new to Excel 2010 and its screen components
• This course is appropriate for any business sector and you don’t need any previous experience.

You'll learn how to:

• understand and use the new features, layout ,shortcuts and toolbars of Excel 2010
• create, navigate and edit workbooks and work with data and ranges
• format data, styles and change display options
• use formulas and functions to automatically calculate and fill cells
• move, copy and view data between worksheets and other documents
• use, manage and edit drives, folders and file formats, and change options for saving and opening worksheets
• change page setup, including orientation, margins, headers and footers, and page breaks
• use automatic tools to find and correct errors, or fill cells and columns
• print different areas of your work

Modules:

There are 13 modules in this eCourse:

• Introducing Excel
• Screen Components
• Open and Save Workbooks
• Creating Workbooks
• Navigating Workbooks
• Formulas and Functions
• Formatting Data
• Move and Copy Data
• Page Breaks and Previewing
• Page Setup Options
• Printing
• Proofing Tools
• Working with Ranges

Course features:

You’ll work through the course online, where you’ll complete a series of simple 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: 103083BT041