Microsoft Excel Intermediate
Course Outline

FORMATTING WORKSHEETS 
    Adjusting Column Width / Row Height 
        How To Adjust The Column Width Using The Mouse 
        How To Adjust The Column Width Using The Menu 
        How To Adjust The Row Height Using The Mouse 
        How To Adjust The Row Height Using The Menu 
        How To Hide / Unhide Rows / Columns 
        How To Freeze A Column / A Row 
        How To Split A Worksheet Into Panes 
    Formatting Cells Using The Toolbar 
        How To Change The Font 
        How To Change The Font Size 
        How To Make Text Bold 
        How To Italicize Text 
        How To Underline Text 
        How To Change The Font Color 
        How To Align Data In A Cell 
        How To Indent Data In A Cell 
        How To Merge Cells And Center Data 
        How To Change Numbers To Percentages 
        How To Increase / Decrease Decimal Places 
        How To Copy A Format Using Format Painter 
    Formatting Cells Using Menu Options 
        How To Double Underline Using The Menu Option 
        How To Align Cell Data Vertically 
        How To Change Text Orientation 
        How To Wrap Text In A Cell 
        How To Format Numbers As Currency 
        How To Format Dates 
        How To Change The Background Color Of A Cell 
        How To Add An Outline Border 
        How To Add A Double Line Border 
        How To Format A Table Using AutoFormat
CREATING CHARTS 
    Creating A Chart Using The Chart Wizard 
        How To Use The Chart Wizard 
        How To Move A Chart 
        How To Resize A Chart 
        How To Change The Chart Type 
        How To Change The Source Data Of A Chart 
        How To Swap Labels In Legend With The X-axis 
        How To Move An Existing Chart To A New Worksheet 
    Changing Chart Options 
        How To Change Chart, X axis And Y axis Titles 
        How To Change The Gridlines 
        How To Change The Legend 
        How To Insert Data Labels 
        How To Add A Data Table 
        How To Delete A Data Series 
        How To Add A Data Series Using The Mouse 
        How To Delete A Chart 
    Formatting A Chart 
        How To Change The Font Format 
        How To Change The Text Orientation 
        How To Change The Color Of An Object 
        How To Change The Order Of A Data Series 
        How To Use A Combination Of Chart Types 
        How To Create A Pie Chart 
        How To Use The 3-D View To Rotate A Chart 
        How To Explode A Wedge In A Pie Chart 
        How To Create A Picture Chart
SETTING UP A PAGE AND PRINTING 
    Setting Up A Page 
        How To Insert And Remove A Page Break 
        How To Set And Clear The Print Area 
        How To Change The Page Orientation 
        How To Change The Scaling 
        How To Change The Paper Size 
        How To Change The Page Margin 
        How To Align To The Center Of The Page 
        How To Add A Header / Footer 
    Previewing and Printing 
        How To View The Print Preview 
        How To Print Active Sheets 
        How To Print Selected Cells 
        How To Print A Chart 
        How To Print Multiple Copies