Workshop Duration
1 day
Prerequisites
Delegates must have attended a Windows Introductory course, or have an equivalent working knowledge of the Windows environment.
Who will the course benefit?
Potential or first time users of Excel who wish to gain an in-depth introduction to this application.
Course Content
Exploring the Excel 2013 Environment
- Customize the Quick Access Toolbar
- Increased Row/Column capacity
File Management
- Pinning Recent Documents
Working with Multiple Documents
- Working with several workbooks in memory
- Multiple workbook display options
- Splitting windows and freezing panes
Building Spreadsheets
- Entering, editing and deleting within cells
- Quick methods for Navigation and Selecting cell ranges
- Copying and moving data
Working with the Sheets
- Inserting and deleting sheets
- Copying and moving sheets
- Renaming sheets and adding tab colours
AutoFill
- Generating series on text and numbers
Formulae and Functions
- Create a formula using +, -, *, /, % and ()
- Using predefined functions e.g. SUM, COUNT, COUNTA, AVERAGE
Absolute Cell Referencing
- Understanding Absolute addresses
- Using the F4 key – $E$3
Printing
- Page Break Preview
- Page Layout View, Setting page breaks
- Page set up – Orientation, Margins, Size Headers and Footers
- Setting up repeating column and row headings on every page
Formatting a Worksheet
- Changing the font style and size
- Applying bordering and shading
- Aligning cell contents, merging
- Column width and row height
- Deleting/inserting cells/rows/columns
- Hiding/Unhiding Columns and Rows Applying
- Cell/Table Styles and Themes
Number Formats
- Applying number and date formats
Charting Basics
- Creating Charts
Skills gained
On successful completion of the course, delegates will be able to work with the new results-oriented interface, prepare, edit and format basic spreadsheets, understand and use formulas and functions, take advantage of Excel features such as AutoSum and AutoFill, produce quality printed spreadsheets, create basic charts using the Microsoft Charting facility.
To book space on this course or find out more information call us on 01454 203 355 or fill out our contact form.