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