.
الكورس مناسب لكل مستويات مستخدمي الاكسيل ( المبتديء والمحترف والمتوسط ) يشمل جميع اوامر ومعادلات الاكسيل - المعادلات البسيطه والبدائيه-

والمعادلات المعقده والتي يحتاجها المحترفين - يشمل ايضا العديد من تريكات الاكسيل التي يجهلها كثير من المستخدمين - اذا كنت لا تعلم في الاكسيل شيئا سو تخرج من الكورس بفضل الله محترف للاكسيل وعلي درايه تامه بكل تفاصيل الاكسيل .

- This course for all excel users levels ( primary and advanced levels ) including all excel details & functions & formulas .

- Throw the 70 Lectures you will find all your answers for any question which may face you when you are using excel .

- You will find many advanced tools ( Pivot table - Pivot chart - Pie Chart - Advanced Tables - Advanced equations - Advanced formulas )

- All Formatting Options

- All Insert options & Data options

- Advanced tools in excel

- Pivot table

- Power Quary 1

- Power Quary 2

......................................................................................

Excel Part 2 Lecture 1 Excel Tricks 1 CTRL + E

Excel Part 2 Lecture 2 Excel Tricks 2 CTRL + E

Excel Part 2 Lecture 3 Excel Tricks 3 CTRL + ; & Ctrl + E

Excel Part 2 Lecture 4 Excel Tricks 4 Custom List for dragging down

Excel Part 2 Lecture 5 Excel Tricks 5 Select Multi Sheets and make your work

Excel Part 2 Lecture 6 Quick access analysis tool

Excel Part 2 Lecture 7 Filter - table

Excel Part 2 Lecture 8 Data Validation ( Drop down list data validation )

Excel Part 2 Lecture 9 Auto fit columns & Rows

Excel Part 2 Lecture 10 Transpose ( تقلب الصف عمود والعمود صف )

Excel Part 2 Lecture 11 Remove duplicates

Excel Part 2 Lecture 12 Goal Seek ( Data - what if - goal seek ) ( محتاج احقق قيمه معينه )

Excel Part 2 Lecture 13 Vlockup

Excel Part 2 Lecture 14 Paste Sepacial

Excel Part 2 Lecture 15 changing chart columns to pattern or picture

Excel Part 2 Lecture 16 IF Function

Excel Part 2 Lecture 17 Insert ScreenShot ( insert - illustration - screenshot )

Excel Part 2 Lecture 18 Absolute Cell Reference

Excel Part 2 Lecture 19 Show Formula ( CTRL + ˜ )

Excel Part 2 Lecture 20 Convert Text to columns

Excel Part 2 Lecture 21 Conditional formatting

Excel Part 2 Lecture 22 Power Pivot

Excel Part 2 Lecture 23 Freeze Panes

Excel Part 2 Lecture 24 CTRL Arrow key to select last cell

Excel Part 2 Lecture 25 3D reference (جمع نفس الخليه في كل الشيتات )

Excel Part 2 Lecture 26 forecast sheet

Excel Part 2 Lecture 27 SUMIFS ـجميع القيم التي امام قيم معينه ( اكثر من criteria )

Excel Part 2 Lecture 28 IF ERROR - Advanced Transpose ( Live Edit ) تحديث القيم بعد عمل transpose عند تغيير القيم الاصليه

Excel Part 2 Lecture 29 Slicers

Excel Part 2 Lecture 30 Scenario Manager

Excel Part 2 Lecture 31 Convert Function

Excel Part 2 Lecture 32 Convert Currency Live

Excel Part 2 Lecture 33 Hide Cells

Excel Part 2 Lecture 34 remove blanks

Excel Part 2 Lecture 35 track changes

Excel Part 2 Lecture 36 advanced filter

Excel Part 2 Lecture 37 How To use pivot table & Slicer

Excel Part 2 Lecture 38 How to learn excel in 40 min & pivot tables

Excel Part 2 Lecture 39 How to make report by excel

Excel Part 2 Lecture 40 Paste Link & Transpose & combination for both of them

Excel Part 2 Lecture 41 Excel Shortcuts

Excel Part 2 Lecture 42 Pivot table Secrets

use table ( to be able to add data )

show pivot table details ( Double click or - right click and show details )

delete data source ( bring it again with double click on total )

replace empty cells with any values - replace errors with any value

field setting - layout print - show with no data (( to show empty cells ))

Group for pivot table items

group numeric items

group dates and show by month or year

automatic refresh - options - data - automatic refresh

show filter - put item in filter area - options - show filter area (( will create new sheets with each item )

filter by label & by value

sort

move the items manually to sort it

change the layout - design - report layout

repeat labels - design - report layout - repeat item labels

turn off (Get pivot table data formula ) - from options in the left corner - choos to turn off get pivot table data formula

prevent column width from changing - right click - pivot table options - autofit columns - change on update ( tick )

calculated fields - analyze - fields - calculated fields - insert formula and add

creat pivot chart ( choos any chart and link with pivot table

add slicer

insert timeline

link slicer with other tables ( right click - report connection - choose the tables to link )

filter on top N

add multible subtotals - field setting - CTRL select - sum & averag ( but before this stage you have to choose alow multible subtotals from the pivot table options

show values as - field setting OR right click values - show valuse as

Excel Part 2 Lecture 43 Excel Power Query 1 ( Home Tap )

Refresh

Properties

Manage

Choose Columns

Remove columns

remove rows

keep rows

sort

Split columns

Data Type

Use first row as header

replace values

Merge Quaries

Append Quaries

Data Source Setting

New Source

Excel Part 2 Lecture 44 Excel Power Query 2 ( Transform Tap )

Transpose ( تقلب الصف عمود والعمود صف )

Reverse rows

Count rows

Replace Values & errors

Fill

Pivot Columns

Unpivot columns

move

convert to list

format

split columns

Extract

Statistics

Standard

Rounding

Information

Date & Time & Duration

Excel Part 2 Lecture 45 Excel Power Query 3 ( Add Columns & View Taps )

Columns from example

custom column

merge columns

format & extract & statistics & standard & date and time