Excel Intermediate Training Course - Bristol or Bracknell
£229.13 Retail Price (inc VAT)
100% Contra Cash
£Contra 229.13 + £Cash 0.00
Excel Intermediate Training Course at either our Bristol or Bracknell training centre, view website www.computertrainingsolutions.co.uk for dates
Course Content:
VIEWING WORKSHEETS
Customising View Options
Displaying And Customising Toolbars
Hiding Workbooks And Worksheets
Freezing Panes
Grouping And Ungrouping Worksheets
MORE FORMATTING TECHNIQUES
Using Styles
Conditional Formatting
Using The Format Painter
Using Guidelines
Hiding And Displaying Cells
MORE FORMULAS AND FUNCTIONS
Using The Series Command
Using The Insert Function Wizard
Financial functions PMT and FV
Using The Excel Function Categories
Correcting Formulas
Using The Formula Error Checker
Using The Formula Auditing Toolbar
Using The Watch Window
ABSOLUTE REFERENCES
Entering an absolute column and absolute row cell reference into a formula
Entering mixed cell references into a formula
USING LOGICAL FUNCTIONS
Using the IF function
Nesting IF functions
DATABASE AND LIST MANAGEMENT
Using Excel as a database
Creating And Editing A Database
Sorting A Database
Using Autofilters
Advanced Filters
Working With Filtered Data
Using Data Forms
CHARTS
Chart Wizard
Chart Toolbar
Working With Charts
Formatting The Chart
LINKING WORKSHEETS WITHIN A WORKBOOK
Renaming worksheets
Inserting and deleting worksheets
Formatting multiple worksheets
Creating formulas to link worksheets
DRAWING AND PICTURE OBJECTS
Drawing Toolbar
Working With Autoshapes
Creating Text Boxes
Adding Pictures
Layering Objects
Grouping And Ungrouping Objects
EXCEL 2003 AND OTHER APPLICATIONS
Converting Files From Other Applications
Copying Data From Another Application
Embedding And Linking Objects
Hyperlinks
Managing Links
£229.13 (free postage/postage not applicable)
The seller would like to be paid as follows: 100% £Contra.
You need to log-in to purchase this product. Click here to log-in.
|