Welcome to Euro Barter Business. Log-in to your EBB Account or Register.

EBB Page Content

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.

EBB Home | My EBB Account | EBB Marketplace | About EBB | Barter News & Events | Contact Us | Register | Log-in | Testimonials

• Read our Privacy Policy • Your access to and use of this Website is conditional on your acceptance of these Terms and Conditions of Use
© EBB 2020