Courses / Microsoft Excel Introduction
Microsoft Excel Introduction
- Provider
- Abal Computer Services
- Summary
- This course is designed to provide a general introduction to spreadsheets. You will gain confidence in the use of everyday tasks, including creating spreadsheets, editing, printing and working with formulae. New features are gradually introduced, enabling you to use the full power and flexibility of the package.
This is an intensive tutor led course with emphasis on hands-on practical exercises. You will need to have keyboard and mouse skills together with an understanding of Windows.
About the Course
- Target
- Business users and Home users.
- Entry requirements
- Participants will need to have keyboard and mouse skills together with an understanding of Windows.
- Outcome
- Participants willl gain confidence in the use of everyday tasks, including spreadsheets, editing, printing and working with formulae. New features are gradually introduced, enabling participants to use the full power and flexibility of the package.
- Content
- THE FOLLOWING TOPICS WILL BE COVERED:
MODULE 1- Creating and saving a workbook
- Entering data and working in the formula bar
- Saving and closing a workbook
- Open and rename an existing workbook
MODULE 2- Working with functions and formulae
- Entering numbers and formulae
- Quickly create a series of dates using the Fill Handle
- Using Auto Sum to Calculate
- Using references and functions
- Paste function working with statistical functions
- Absolute and Relative cell addresses
MODULE 3- Printing selected parts of a sheet
- Printing the whole sheet
- Margins and other print options
- Selecting portrait or landscape and fit-to-page
- Working with gridlines and print titles
MODULE 4- Formatting
- Changing column width and row height
- Using the undo and repeat command
- Making non adjacent cell selections
- Hide/unhide columns and rows
- Format numbers for currency and dates
- Format a workbook using one of Excels built in templates
- Add borders and shading to cells
MODULE 5- Create charts using the ChartWizard
- Modify, add and delete chart data
- Change chart types to make sure the chart fits your data
MODULE 6- Managing workbooks
- Copy and move sheets to make your workbooks more manageable
- Document your work with cell notes and text boxes
- Find files quickly by searching for summary information in the properties dialog box
Abal Computer Services train a maximum of 7 delegates at each training session and individual support is always available. Abal have now become a Learn Direct Centre, open 9.30 am-5.00 pm, Wed and Thurs 9 am-9 pm, for more information please contact Abal Computer Services on 01787 374138. - Creating and saving a workbook
- Cost
- Contact course provider for details
- Enrolment
- Contact the provider for details.
Availability
- Starts
- Courses available throughout the year
- Duration
- One day
- Timetable
- 9.30 am - 4.30
Intensive tutored course, with emphasis on hands-on practical exercises - Provider
- Abal Computer Services
Venue and Contact details
Main
Unit 4, South Suffolk Business Centre
Alexandra Road
SUDBURY
Suffolk
CO10 2ZX
UNITED KINGDOM
Telephone 01787 374138
Fax 01787 312089
Email training@abal-computers.com
Website http://www.abal-computers.com
Courses
Syndicate
