Excel Intermediate Training Course - Bristol or Bracknell
£229.13 Approx: €286.41 Retail Price (inc VAT)
100% Contra Cash
£Contra 229.13 + £Cash 0.00
(Approx: €Contra 286.41 + €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 (Approx: €286.41)
(Kostenfreier Versand / Versandkosten nicht angegeben)
Der Verkäufer akzeptiert die Zahlung mit: 100% €Contra.
You need to log-in to purchase this product. Click here to log-in.
|
)
Arabic
Chinese
Italiano
Deutsch
Français
Japanese
Portugues
Korean