People Innovation Excellence
 

OFFICE FOR PROFESSIONAL (2 Credits)

Learning Outcomes:

On successful completion of this Course, students will be able to: Organize a large volume of data across multiple worksheets or pages of information in the file; Analyze a name to a section of data on a worksheet  to use the name in a formula; Apply formula and number format; Translate data into a meaningful image by creating a chart in Excel; Manage and sort lists that combine text and numerical values.

Topics :

  1. Getting Started with Excel 1;
  2. Getting Started with Excel 2;
  3. Introducing Formulas and Functions;
  4. Working With Formulas and Functions;
  5. Creating Formulas that Look Up Values;
  6. Getting Started Making Charts;
  7. Working with Database Tables in Excel;
  8. Using Advanced Excel Features;
  9. Analyzing Data with PivotTables;
  10. Review

Published at : Updated

Periksa Browser Anda

Check Your Browser

Situs ini tidak lagi mendukung penggunaan browser dengan teknologi tertinggal.

Apabila Anda melihat pesan ini, berarti Anda masih menggunakan browser Internet Explorer seri 8 / 7 / 6 / ...

Sebagai informasi, browser yang anda gunakan ini tidaklah aman dan tidak dapat menampilkan teknologi CSS terakhir yang dapat membuat sebuah situs tampil lebih baik. Bahkan Microsoft sebagai pembuatnya, telah merekomendasikan agar menggunakan browser yang lebih modern.

Untuk tampilan yang lebih baik, gunakan salah satu browser berikut. Download dan Install, seluruhnya gratis untuk digunakan.

We're Moving Forward.

This Site Is No Longer Supporting Out-of Date Browser.

If you are viewing this message, it means that you are currently using Internet Explorer 8 / 7 / 6 / below to access this site. FYI, it is unsafe and unable to render the latest CSS improvements. Even Microsoft, its creator, wants you to install more modern browser.

Best viewed with one of these browser instead. It is totally free.

  1. Google Chrome
  2. Mozilla Firefox
  3. Opera
  4. Internet Explorer 9
Close