Excel Part 1 – An entry level introduction for delegates with little of no experience of using Excel.
If you are unsure if this is the right course for you, please complete the self-assessment at the bottom of the page. If you need further guidance please contact Scomis@devon.gov.uk or call 01392 385300
Elements of The Excel Interface – What is Excel, What does it do, how is it used. An introduction to Excel and the elements you will be using on this course.
Create a Basic Worksheet – Open a Worksheet and populate with data.
Create Formulas in a Worksheet (performing calculations and other simple operations)
- The Formula Bar – .Where to find the options for creating formulas. What is a formula? Formulas can be simple, like adding two cell values, or quite complex, involving multiple mathematical operations
- Elements of An Excel Formula – how to build a formula to do what you want to do in am excel Spreadsheet
- Common Mathematical Operators – SUM, Percentage, etc.
- The Order of Operators – How to build a formula so it works properly.
- Insert Functions in A Worksheet – The purpose of a function is to provide you with an easy way to perform a complex calculation
- The Functions Library – What functions are available to suit your needs.
- Common Functions in Excel – The most popular and commonly used functions.
- Formula Autofill Feature – How to use one formula on multiple sections
- Reuse Formulas – Copy a formula from one section to another.
Cut, Copy and Paste – How to cut, copy and paste in Excel.
- Paste Special Options – other ways of pasting.
Relative (Such references are flexible in that they change depending upon the position of the formula) and Absolute Cell References – (make sure a formula always references the same location, no matter where it is moved)
Modify A Worksheet
- Edit Data in A Worksheet
- Column Widths and Row Heights
- Hide and Unhide
- Insert, Manipulate and Delete Cells, Columns and Rows
- Format Worksheets
- Modify Fonts
- Add Borders and Colours to Cells
- Apply Number Formats
Printing Workbook Contents – knowing how to print data from your workbook is essential. In this topic, we will explore how to use the printing functionality in Excel.
- Define Page Layout for Printing – setting the area for printing
- Print Titles
- Scaling Options
Manage Large Workbooks – In this topic, we will learn all of the ways that you can format worksheet tabs. We will also learn how to manage worksheets and view worksheets and workbooks in different ways.
- Format Worksheet Tabs
- Manage Worksheets
- Repositioning Worksheets
- Inserting/Deleting Worksheets
- Worksheet References in Formulas
- Managing the View of Worksheets and Workbooks
- Freeze Panes Command
- The Split Command
Use the Help System
Attendance: Full day 9.30 – 15.30
Cost: £170.00 per person SLA Rate
Feedback from our customers: (July 2018)