Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? 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 there data, using the provided manual if required. Audience Users who are new to spreadsheets. Prerequisites None. Course Outline Excel Basics - Spreadsheet Terminology
- Exploring The Excel Window
- Opening And Navigating A Workbook
- Closing A Workbook
Entering And Editing Data - Creating A New Excel Workbook
- Entering And Editing Labels And Values
- Entering And Editing Formulas
- Saving And Updating A Workbook
Printing - Preparing To Print
- Page Set up Options
Modifying A Worksheet - Moving A Copying Data
- Moving And Copying Formulas
- Using Absolute References
- Inserting And Deleting Ranges Using Functions
- Entering Functions
- Using Autosum
- Using AVERAGE, MIN, MAX, And COUNT
Formatting Worksheets - Formatting Text
- Formatting Rows And Columns
- Number Formatting
- Other Formatting Features Creating Charts
- Creating A Chart
- Printing Charts
Web Features - Saving A Worksheet As A Web Page
- Adding Hyperlinks
- Sending A Workbook Via Email
How to make a booking for the MEX00-11 course
|
