Training Program Details
What can be learned at this seminar:
VIEWING WORKSHEETS
Customizing View Options
Displaying and Customizing Toolbars
Hiding Workbooks and Worksheets
Freezing Panes
Grouping and Ungrouping Worksheets
MORE FORMATTING TECHNIQUES
Styles, Guidelines and the Format Painter
Conditional Formatting
Hiding and Displaying Cells
MORE FORMULAS AND FUNCTIONS
Using the Series Command
Using the Insert Function Wizard and the Excel Function Categories
Correcting Formulas
Using the Formula Error Checker and the Formula Auditing Toolbar
Using the Watch Window
DATABASE AND LIST MANAGEMENT
Sorting a Database
Using Auto-filters and Advanced Filters
Working with Filtered Data
Using Data Forms
CHARTS
Chart Wizard and Toolbar
Working with Charts
DRAWING AND PICTURE OBJECTS
Using the Drawing Toolbar
Working with Auto shapes
Creating Text Boxes
Adding Pictures
Layering Objects
Grouping and Ungrouping Objects
EXCEL AND OTHER APPLICATIONS
Converting Files from Other Applications
Copying Data From Another Application
Embedding and Linking Objects
Hyperlinks
Managing Links