Monday, September 21, 2009

Microsoft Excel Tutorials 5- 10- Assignment # 5

Introduction

Microsoft Excel is a spreadsheet-application written and distributed by Microsoft. Some of its features may include calculation, graphing tools, pivot tables and a macro programming language called VBA (Visual Basic for Applications). It is widely used across the world as one of the top spreadsheet applications software.

The series of videos that were viewed seeks to educate viewers about various ways of formatting text, charts, cells and other objects in Microsoft Excel. The videos also helped viewers to understand ways of of creating charts.

Tutorial # 6

  • Formatting
    Merging and centering
    Font sizes, bold, text wrapping
    Text alignment
    Changing data types
    Copying formatting
    Applying background colours

    Tutorial # 7

    Formatting Cont’d
    Changing font colours
    Adding borders/gridlines
    Conditional Formatting

    Tutorial # 8

    Conditional Formatting Cont’d

    Tutorial # 9

    Creating Charts
    Formatting and editing chart information ad chart features (changing colours, columns width, creating chart backgrounds

    Tutorial #10

    Updating spreadsheets
    Updating charts
    Relocating charts