The course is designed for users new to Excel. It will provide trainees with the confidence, knowledge and practical experience to use Excel, to create and manipulate spreadsheets and produce printed reports. Delegates should have sufficient Windows experience beforehand. Equipment: No equipment is necessary for you to bring to the course. Pens and note paper will be available. Lunch provided: Lunch and refreshments will be provided throughout the course. Course Content
- The Excel Screen
- Ribbons, Quick Access Toolbar, Formula Bar, and Status Bar
- Workbooks and Sheet Tabs
- Data Entry
- Types of Data
- Data Entry Techniques
- In Cell Editing
- Selecting
- Cut/Copy/Paste
- Drag & Drop
- Using AutoFill to fill Adjacent Cells and Extend Series, Custom Lists
- Formulae and Functions
- Simple formulas & Functions
- Relative and Absolute References
- Named Ranges
- AutoSum
- AutoFill
- Paste Function
- Average, Max, Min & Count Functions
- Multiple Panes
- Freeze and Unfreeze
- Formatting a Worksheet
- Using Borders and Shading to improve presentation
- Font & Number Formatting, Alignment
- Printing
- Print Preview & Setup
- Headers & Footers
- Print Row/Column headings
- File Management
- Saving, Closing and opening files
- New Workbooks
- Good Working Practice
- Creating a Chart
- Creating Charts
An explanation of different versions Course costs £109 per person. For more details please contact us at [email protected] or on 01603 788950. Link to book – www.southnorfolkandbroadland.gov.uk/training
Venue: UK
Start Date / Time: 21/02/2023 9:30 am
End Date / Time: 21/02/2023 4:00 pm
Member Rate: Free
Non-Member Rate: Free
Book Now
