Become a confident computer user through personalised and friendly IT training.
Success guaranteed.
This is just some of what we offer in Excel Spreadsheet training. Please ask for a detailedExcel Spreadsheets Course Content Sheetto select what you would like to learn.
EXCEL TRAINING
Choose a level or mix and match to select exactly what you wish to learn.
Beginners
- Creating, editing and saving a spreadsheet
- Page layout – margins, landscape, portrait, fit to size, gridlines
- Autofill and Autolists
- Column and Row inserting, deleting, moving
- Print features
- Header/footer
- Basic Formula writing - relative and absolute
- Linking worksheets
- AutoSum and other functions
- Date and Currency formats
- Useful shortcut codes for quick navigation of your text and for editing purposes
- Create charts and graphs
- Autofilter and sorting
Intermediate
- Spreadsheet Layout enhancements and customisation – formatting cells, spacing, alignment, borders
- Advanced chart and graph presentation – manipulating data, formatting text, enhancing layout
- Custom Number formats
- Using comments
- The MDAS rule
- Use of Function Wizard - writing formulas
- Useful What If formulas
- Customised filters and autofilters
- Managing large spreadsheets effectively – linking, naming cells, using names in formulas
- Paste Special
- Freeze panes
- More Printing options
- Validation, lists and input messages
- Custom lists
Advanced
- Creating, editing and running Macros
- Tracking and auditing
- Error messages in formulas
- Conditional formatting
- Nested if statements
- V and hlookups
- Pivot tables
- Subtotals
- Advanced filters
- Importing external data
- Exporting data
- Inserting pictures and hyperlinks
- Default customisation of spreadsheet layout
- Using styles
Top of Page
Philippa Benjamin
Bristol Computer Training
92 Egerton Road
Bristol
BS7 8HP
(+ 44) 117 9247567Contact by email
www.bristolcomputertraining.co.uk