Request availability or book by selecting a date: England
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview By the end of this course you will be able to produce a formatted worksheet, confidently create basic dynamic formulae and create a visual representation of the data, using the provided manual if required. Audience Users who are new to spreadsheets. Prerequisites This course requires that you have a good working knowledge of Microsoft Windows and you should also be able to use a mouse and keyboard. Course Outline Excel Basics - Spreadsheet Terminology
- Exploring The Excel Window
- Getting Help
- Opening And Navigating Workbooks
- Closing Workbooks
Entering And Editing Data - Creating Workbooks
- Entering And Editing Labels And Values
- Entering And Editing Formulas
- Saving And Updating Workbooks
Printing - Preparing To Print
- Page Set Up Options
Modifying A Worksheet - Moving And Copying Data
- Moving And Copying Formulas
- Using Absolute References
- Inserting And Deleting Ranges
Using Functions - Entering Functions
- Using Autosum
- Using AVERAGE, MIN, And MAX
Formatting Worksheets - Formatting Text
- Formatting Rows And Columns
- Number Formatting
- Other Formatting Features
Creating Charts - Chart Basics
- Printing Charts
Web Features - Saving Worksheets As Web Pages
- Hyperlinks
- Workbooks And Email
How to make a booking for the MEX03-11 course
|
