Microsoft Excel XP- Intermediate
With this course you will be taught to create a broad range of professional spreadsheets, you will learn to: design and create Charts, troubleshoot with difficult formulas, link formulas, outline data, work more proficiently with Worksheets and create Templates
Table of Contents
Fill
Insert ClipArt Pictures
Page Break View
Sizing the Sheet Area
Normal View
Inserting & Deleting Worksheets
AutoFormat
Charts
Creating a Chart (Bar, Pie, etc)
Moving and Sizing Charts
Chart Areas (Plot, Category, Value, Walls, Gridlines, Titles, etc)
Bar Patterns
Chart Types
Row and Column Labels
Exploding Pie pieces
Drawing Arrows
Outlines
Paste Special \ Value
Paste Special \ Transpose
IF Formula
Labelling a Sheet Tag
Absolute Referencing
Formula Display
CountIF, CountBlank, Count Formulas
SumIf Formula
Removing a Merge and Center Function
Creating a Template
Conditional Formatting
Linking Cells
Saving Files to a WorkSpace
Assignments |