Microsoft Office Excel 2016 – Intermediate هذه الدورة تدرس باللغة الإنجليزية

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

Unit 1: Working with Defined Names

• About defined names
• Creating range names
• Using names in formulas and functions
• Managing names
• Listing names and references on a worksheet
• Applying new names to existing formulas

Unit 2: Working with Data and Lists

• Sorting data
• Creating a custom list
• Filtering data
• Working with Excel Tables
• Summarising data with automatic subtotals
• Consolidating data
• Working with duplicate values
• Linking cells across worksheets and workbooks

Unit 3: Advanced Formatting

• Themes, colors, fonts and effects
• Hiding zeros on a worksheet
• Working with cell styles
• Conditional formatting
• Creating and using templates

Unit 4: Collaborating in Excel

• Editing workbook properties
• Adding Data Validation criteria to cells
• Working with comments
• Working with hyperlinks
• Protecting worksheets, workbooks and files

Unit 5: Formula Auditing

• Tracing Cells
• Error Checking
• Evaluate a formula
Unit 6: Working with Charts
• Data layout for charts
• Creating a new chart
• Changing the chart data
• Applying a different chart layout
• Adding and removing chart elements
• Changing the chart style
• Changing the chart type
• Moving a chart
• Formatting chart elements
• Working with sparklines

Unit 7: Illustrating Excel

• Working with pictures
• Working with SmartArt
• Working with shapes
• Working with WordArt تحديث بتاريخ 08 February, 2023