We offer a wide range of high-quality and affordable training and events to help you develop and succeed at Carrowbreck House - our spacious and comfortable training centre in Hellesdon.
We can also ...
Introduction to Excel
Contact person
Matt Beckett
#112748
Scan me or visit www.getinvolvedskills.org.uk/o/Carrowbreck-Courses/Trainings/Introduction-to-Excel/112748 to join
Summary
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..
Detailed description
manipulate spreadsheets and produce printed reports.
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
Equipment: Pen and note paper will be provided.
Lunch provided: For full day training courses a lunch with sandwich or salad, crisps and cake or fruit will be provided. Light refreshments will also be available throughout.
About Carrowbreck Courses
We offer a wide range of high-quality and affordable training and events to help you develop and succeed at Carrowbreck House - our spacious and comfortable training centre in Hellesdon.
We can also look to offer bespoke training for your business either on-site, at Carrowbreck House or virtually to meet your needs on our whole range of available courses.
Room hire is also available on an hourly, half-day, full-day or multiple-day basis for meetings or training courses.