Courses / Microsoft Excel Introduction (Home study)
Microsoft Excel Introduction (Home study)
- Provider
- Abal Computer Services
- Summary
- This course is designed to provide a general introduction to spreadsheets using Excel. 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. You will need to have keyboard and mouse skills together with an understanding of Windows.
About the Course
- Target
- Those familiar with computers
- Entry requirements
- Hardware Requirements:
In order to participate in our home study course you will need access to a personal computer running Windows 98 or above, with a printer attached. You will need a full copy of Microsoft Word and Excel version 97 or above. You will need about 2mb free space on the hard drive to save your work - Outcome
- Content
- Lesson 1 – Getting Started
- Starting a new workbook
- Entering data and working in the formula bar
- Saving and naming
- Entering values and formulae
- Create a series of dates using the fill handle
- Use auto sum to calculate
Lesson 2 – Creating formulas- Use cell references and functions
- Absolute and relative cell addresses
- Use function wizard to work with statistical data
- Formatting a sheet, change column width and row height
- Hide and unhide columns and rows
- Best cell selection techniques
Lesson 3 – Learning to format with style- Format cells
- Use borders, colour and shading
- Using conditional formatting
- Format a workbook using one of excels built in templates
Lesson 4 – Best printing practices- Printing multiple pages
- Printing a selection
- Setting up margins and other print options
- Scaling and fit-to-page options
- Working with commands and dialogue boxes
Lesson 5 – Working with Excels functions- A detailed view of the fill range option
- Creating your own custom lists
- Working with Date arithmetic
- Working with Volatile dates
Lesson 6 – Charting your work- Charting your data
- Create charts using the chart wizard
- Modify, add and delete chart data
- Quick ways to update your charts
Lesson 7 – More advanced chart techniques- Change chart types to make sure that the chart fits your data
- Use automatic formatting to skip repetitive formatting steps
- Creating comparison graphs
- Format and edit chart types
Lesson 8 – Managing your workbooks- Insert new sheets into your workbook
- Name your individual sheets
- Copy and move sheets to make your workbook more
- manageable
- Document your work with cell notes, text boxes, and summary information
- Create a formula to link sheet together
Lesson 9 – Working in Group Mode- Enter data to several sheets at once
- using Group mode
- Format a group of worksheets at the same time
- Consolidate data from different worksheets
- Create linking formal that update automatically
Lesson 10 – Sorting Data- Sort your data on multiple levels
- Create automatic subtotals
- Collapse and expand to show
- summary data only
- Understanding how Excel selects cell references to use in formulas
Lesson 11 – Group and Outline- Create an outline on a worksheet
- Expand and collapse an outline
- Create quick summary reports
- Creating an advanced outline
Lesson 12 – Range Names- Creating range names
- Modifying range names
- Using range names in formula
- Navigating using range names
- Starting a new workbook
- Cost
- Please contact the provider for details
- Enrolment
- Please contact 10787 374138
Availability
- Starts
- Home study
- Duration
- Home study
- Timetable
- Home study
- 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
Venue Notes Home Study no attendance required
Contact Notes Tel: 01787 374138
Courses
Syndicate
