Category
ICT
Course Type
Microsoft
Price Per Delegate
£195 +VAT
Public Scheduled Course
Price Per Course
£695 +VAT
On-Site at Customer Premises, Max 10 Delegates
Duration
1 Day
Full/Part Time
Part Time
Provider
Book courseThis course is intended for users who need to be able to create, edit and format Excel spreadsheets, including creating basic calculations and formulae.
Objectives: By the end of the course users will be able to produce a variety of spreadsheets, use formatting tools and page setup techniques to display and print spreadsheets effectively. Users will also be able to create simple calculations and use basic Excel functions.
Prerequisites: Users must be proficient with a mouse and keyboard and be able to confidently work within a Windows environment - minimise, maximise, open, close.
- Spreadsheet Concepts
- Exploring the Excel Window
- Working with the Ribbon & Commands
- Creating, Saving & Closing Spreadsheets
- Opening an Existing Spreadsheet
- Moving Around a Spreadsheet
- Entering, Editing & Deleting Data
- Using AutoFill & Flash Fills
- Creating Custom Lists
- Inserting & Navigating Worksheets
- Inserting & Deleting Rows & Columns
- Adjusting Column Widths & Row Heights
- Using Cut, Copy & Paste
- Formatting Text & Sizes
- Changing Cell Alignment
- Changing Number & Date Formats
- Adding Shading & Borders
- Using Formulas to Add, Subtract, Divide & Multiply Numbers
- Using the AutoSum Function
- Working with Relative & Absolute Cell References
- Introducing Data Lists
- Freezing Worksheet Titles
- Sorting A List of Data
- Filtering Data using AutoFilter
- Using Print Preview
- Change Page Layouts
- Changing & Applying Print Options
Book a course
Fill in your information to book this course. The information you provide on this booking form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.
If you just wish to enquire about this course click here
