MS Excel Intermediate Level هذه الدورة تدرس باللغة الإنجليزية

Course Outline:

1.Tables and Formatting:

• Pivot Tables & Formatting
• Sorting & Filtering
• Creating Pivot table & Analyzing data
• Sorting a worksheet with filter
• Refreshing & Changing PivotTable Range
• Sorting a worksheet without filter
• Creating sheets from Pivot table
• Advanced Sorting
• Calculations & creating dynamic Pivot
• Types of Filters
• Table Creation
• Difference between soft filter and regular filter
• Defining name & Working with tables
• Subtotal

2. Fields and Fomatting:

• Creating fields and formatting
• Creating Sub Totals
• Creating more than one pivot table on one sheet
• Sorting data with Multiple Level Sorts
• Changing Source
• Advance Filtering on more than 1 Criteria
• Slicer
• Extracting Unique Values with Filtering

3.Conditional Formatting:

• Tips of copying Filtered data to New File
• Formatting data on Conditions
• Using Charts and Visualization
• Highlight Duplicate & Unique Values
• Creating Column, Line & Pie Charts
• Finding top 5 / 10 Items in the Data
• Shortcuts of Creating Charts
• Formatting data using Data Bars & Icons

4. Charts:

• Chanting Chart type
• Clearing & Managing rules adding Target Line in chart
• Analyzing only total rows method of pasting chart into PowerPoint
• Summarizing a data based on single attribute
• Creating two axis chart & advance charting
• Adding data based on two attributes Creating Drop Downs in cell
• Advanced Formatting & Customization Sharing Workbook
• Go To Options Inserting object, Hyperlinking
• Sheet Protection, No Right/Left Click, no copy Formulas and Functions

5. Hiding Formulas Statistical:

• Count/CountA/CountIF/CountIFs/CountBlank
• Protecting Parts of a Worksheet Trim & Concatenate, Sum, SumIF & SumIFs
• Change Case: Upper, Lower & Proper
• Logical: If/IF's, Using AND & OR in IF Condition
• Lookup: Advance & Multiple Vlookup & Hlookup