Section outline

  • Having the skills to operate and get the most from a spreadsheet application directly enhances your ability to manage numerical data and will positively impact your job performance. This MS-Excel/ Spreadsheets Module provides you with the tools to understand the concept of spreadsheets, and to demonstrate an ability to use a spreadsheet to produce accurate work outputs.



    On completion of this Module you will be able to:

    • Work with spreadsheets and save them in different file formats.
    • Choose built-in options, such as the Help function, within the application to enhance productivity.
    • Enter data into cells; use good practice in creating lists.
    • Select, sort, copy, move and delete data.
    • Edit rows and columns in a worksheet.
    • Copy, move, delete, and appropriately rename worksheets.
    • Create mathematical and logical formulas using standard spreadsheet functions; use good practice in formula creation; recognize error values in formulas.
    • Format numbers and text content in a spreadsheet.
    • Choose, create, and format charts to communicate information meaningfully.
    • Adjust spreadsheet page settings.
    • Check and correct spreadsheet content before finally printing spreadsheets.

    What are the benefits of this module?

    This module gives you the skills to operate spreadsheet software, including the most common commercial and open-source offerings. Spreadsheets maintain an important role in business operations and having the knowledge to utilize their functions, formulas, and features is a necessary requirement for any worker. Once you have developed the skills  and knowledge set out in this Module, you will be in a position to become certified in

    Spreadsheets.




    • Students must
      Mark as done

      CHAPTER ONE- EXPLORING MICROSOFT EXCEL 2016

      In this Chapter, you will learn about:

      • Starting Excel
      • The user interface
      • Excel options
      • Creating a workbook
      • Opening a workbook
      • Saving a new workbook
      • Closing a workbook
      • Working with worksheets
      • Using the ribbon
      • Hiding the ribbon
      • Using magnification/zoom tools
      • Exiting Excel

    • STARTING EXCEL 2016 Book
      Students must
      Mark as done