| |
|
Microsoft Office Training Surrey: Addlestone, Ashford, Banstead, Bellfields, Camberley, Caterham, Chertsey, Cobham, Dorking, Earlswood, Egham, Englesfield Green, Epsom, Esther, Ewell, Farleigh, Farnham, Godalming, Guildford, Haslemere, Horley, Hurst Green, Hythe End, Leatherhead, Oxted, Redhill, Reigate, Shepperton, Staines, Sunbury-on-Thames, Walton-on-Thames, Weybridge and Woking.
|
 |
Excel Basics Training Course in Surrey |
|
 |
| Excel
Training Surrey > Excel Basicsl
Training Surrey |
Basic Excel
Training Content (Excel 2010, 2007,
2003, XP and earlier) |
The Basic Excel training course is aimed at delegates who have little or no previous experience with Microsoft Excel. The course will take you through navigating a workbook, entering and editing data, performing simple calculations, creating charts and graphs, basic list management and printing options.
For pricing click
here
WE COME TO YOU!
We are happy to travel to you anywhere in Surrey without charging travel expenses including: Addlestone, Ashford, Banstead, Bellfields, Camberley, Caterham, Chertsey, Cobham, Dorking, Earlswood, Egham, Englesfield Green, Epsom, Esther, Ewell, Farleigh, Farnham, Godalming, Guildford, Haslemere, Horley, Hurst Green, Hythe End, Leatherhead, Oxted, Redhill, Reigate, Shepperton, Staines, Sunbury-on-Thames, Walton-on-Thames, Weybridge and Woking. |
| Excel Basics |
- Elements of a spreadsheet
- Navigating your way around
- Getting help when you need it
- Worksheet and workbooks
- Switching between multiple windows
|
|
|
| Entering Data into Your Worksheet |
- Entering labels for columns and rows
- Entering numbers, dates and times
- Using simple formula to perform basic calculations
- Creating new rows and columns
|
|
|
| Formulae and Functions |
- Using the SUM function to add up rows and columns
- Using the AVERAGE function
- Using MIN and MAX to return the smallest and largest values in a range
- Counting values with COUNT and COUNTA
- Fixing cell references with absolute referencing
- Using mixed cell referencing to avoid multiple formula in a table
- Naming cells and ranges for database work and calculations
- Looking at the logic behind IF statements
- Performing calculations with dates and times
|
|
|
| Printing Worksheets |
- Defining which part of your worksheet you want to print
- Getting data to fit on one page
- Including headers and footers on each page
- Getting row and column headers to appear on each printed page
- Printing gridlines
|
|
|
| Managing Lists & Tables |
- Sorting a table on more than one column
- Hiding columns and then getting them back again
- Changing the order of your columns
- Freezing rows and columns so they stay on the page when you scroll
- Filtering your list one or more criteria using AutoFilter
|
|
|
| Excel Charts and Graphs |
- Which chart type is appropriate for my data?
- Selecting a data source for a chart
- Adding titiles and labels
- Formatting chart elements
- Creating a custom chart type
- Setting a default chart
|
|
|
|
|
|
|
|
|
|
