MOS: Excel 2007 هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

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.