Microsoft Excel 2010 - Introduction

This is an onsite course catering for up to 10 delegates

This course introduces the delegate to the basic commands, functions and capabilities of Microsoft Excel 2010.  It is designed for those computer users who are new to spreadsheets or are only going to use Excel occasionally.

More details

More info

Prerequisites:

Delegates should be familiar with the basics of using a keyboard & mouse.

Delegates will learn how to:

¨      Use formulas & functions to add, subtract, multiply & divide numbers

¨      Use Page Break Preview to control how Excel prints pages

¨      Use relative, mixed & absolute cell references

¨      Use Excel 2010 Tables to quickly perform calculations

¨      Use conditional formatting & Sparklines to highlight results & show trends

¨      Create formulas to calculate totals from other worksheets & workbooks

¨      Use logical, mathematical, statistical, date/time & text functions

¨      Create charts & customise their appearance

Course Outline

¨      Creating Excel Formulas

¨      Introduction to Formulas

¨      Controlling the Order of Calculation

¨      Working with Excel Functions

¨      Introducing Excel Functions

¨      Using SUM & Average"

¨      AutoSum

¨      Finding Excel Functions

¨      Logical Functions (IF, AND, OR)

¨      Math Functions

¨      Statistical Functions

¨      Date and Time Functions

¨      Text Functions

¨      Cell Styles

¨      Using AutoFill

¨      Page Break Preview

¨      Absolute & Relative References

¨      Custom Cell Formats

¨      Using Format Painter

¨      Excel 2010 Tables

¨      Clearing Cell Contents and Formats

¨      Jumping to a Cell

¨      Conditional Formatting

¨      Sparklines

¨      Sorting & Filtering Data

¨      Linking Worksheets & Workbooks with Formulas

¨      Named Ranges

¨      Creating Charts

¨      Customising Chart Appearance

¨      Adding Data to a Chart

£ 895.00 ex.vat

Data sheet

Course Duration 1 Day
Location Various