Course details

Module One: Managing Worksheets and Workbooks

  • Create and format worksheets: Insert worksheets, delete worksheets, copy, reposition, copy and move, rename, grouping, apply coloring to worksheet tabs, hiding worksheet tabs, un-hiding worksheet tabs.
  • Manipulate window views: splitting window views, arranging window views, and opening a new window with contents from the current worksheet.
  • Manipulate workbook views: using Normal, Page Layout, and Page Break workbook views, and creating custom views.

Module Two: Creating and Manipulating Data

  • Insert data by using AutoFill.
  • Ensure data integrity.
  • Modify cell contents and formats.
  • Change worksheet views.
  • Manage worksheets.

Module Three: Formatting Data and Content

  • Format worksheets.
  • Insert and modify rows and columns.
  • Format cells and cell content.
  • Format data as a table.

Module Four: Creating and Modifying Formulas

  • Reference data in formulas.
  • Summarize data by using a formula.
  • Summarize data by using subtotals.
  • Conditionally summarize data by using a formula.
  • Look up data by using a formula.
  • Use conditional logic in a formula.
  • Format or modify text by using formulas.
  • Display and print formulas.

Module Five: Presenting Data Visually

  • Create and format charts.
  • Modify charts.
  • Apply conditional formatting.
  • Insert and modify illustrations.
  • Outline data.
  • Sort and filter data.

Module Six: Collaborating on and Securing Data

  • Manage changes to workbooks.
  • Protect and share workbooks.
  • Prepare workbooks for distribution.
  • Save workbooks.
  • Set print options for printing data, worksheets, and workbooks.
Updated on 08 November, 2015

About CTC Academy

We_They Academy | Authorized Training Center: We_They Academy is an Egyptian company established in 1999 in Cairo-Egypt.

We_They Academy Training centers are private independent training centers.

Our office is located in Cairo. We_They Academy Training centers programs are offered by highly professional training methods. We_They Academy is one of the leading private educational centers which offers International Universities and Training Colleges programs.

Employers in the international employment market are confident that holders of our certificates and diplomas have been well trained and have acquired good skills and knowledge. Certificates and diplomas awarded by We_They Academy Training Centers are stamped by highly professional international training colleges and universities. The demand on We_They Academy Training Centers courses, programs, certificates and diplomas are on the increase nationally in the Arab Republic of Egypt.

See all CTC Academy courses
Are you from CTC Academy ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Office starting now. See all courses

Is this the right course for you?

Didn't find what you were looking for ?

or