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 the data, using the provided manual if required. Audience Anybody that wants to learn the fundamentals of Microsoft excel. 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 MEX07-11 course
|
