تحميل Excel from Beginner to Advanced
Computer Softwares
روابط التحميل
يوجد صيانة لقسم تحميل الدورات لذلك يمكنك مشاهدة الدورة بشكل مباشر من هنا بدلا من التحميل لحين الانتهاء من صيانة القسم
-
1 Launching Excel
-
2 Microsoft Excel Startup Screen
-
3 Introduction to the Excel Interface
-
4 Customizing the Excel Quick Access Toolbar
-
5 More on the Excel Interface
-
6 Entering Text to Create Spreadsheet Titles
-
7 Working with Numeric Data in Excel
-
8 Entering Date Values in Excel
-
9 Working with Cell References
-
10 Creating Basic Formulas in Excel
-
11 Relative Versus Absolute Cell References in Formulas
-
12 Understanding the Order of Operation DOWNLOAD EXERCISE FILE
-
13 The structure of an Excel Function
-
14 Working with the SUM Function
-
15 Working with the MIN and MAX Functions
-
16 Working with the AVERAGE Function
-
17 Working with the COUNT Function
-
18 Adjacent Cells Error in Excel Calculations
-
19 Using the AutoSum Command
-
20 Excel s AutoSum Shortcut Key
-
21 Using the AutoFill Command to Copy Formulas
-
22 Moving and Copying Data in an Excel Worksheet
-
23 Inserting and Deleting Rows and Columns
-
24 Changing the Width and Height of Cells
-
25 Hiding and Unhiding Excel Rows and Columns
-
26 Renaming an Excel Worksheet
-
27 Deleting an Excel Worksheet
-
28 Moving and Copying an Excel Worksheet
-
29 Working with Font Formatting Commands
-
30 Changing the Background Color of a Cell
-
31 Adding Borders to Cells
-
32 Formatting Data as Currency Values
-
33 Formatting Percentages
-
34 Using Excel s Format Painter
-
35 Creating Styles to Format Data
-
36 Merging and Centering Cells
-
37 Using Conditional Formatting
-
38 Inserting Images
-
39 Inserting Excel Shapes
-
40 Formatting Excel Shapes
-
41 Working with Excel SmartArt
-
42 Creating an Excel Column Chart
-
43 Working with the Excel Chart Ribbon
-
44 Adding and Modifying Data on an Excel Chart
-
45 Formatting an Excel Chart
-
46 Moving a Chart to another Worksheet
-
47 Working with Excel Pie Charts
-
48 Viewing your Document in Print Preview
-
49 Changing the Margins Scaling and Orientation
-
50 Working with Page Layout View
-
51 Adding Header and Footer Content
-
52 Printing a Specific Range of Cells
-
53 Intro to Excel Templates
-
54 Opening an Existing Template
-
55 Creating a Custom Template
-
56 Congratulations
-
57 Understanding Excel List Structure
-
58 Sorting a List Using Single Level Sort
-
59 Sorting a List Using Multi Level Sorts
-
60 Using Custom Sorts in an Excel List
-
61 Filter an Excel List Using the AutoFilter Tool
-
62 Creating Subtotals in a List
-
63 Format a List as a Table
-
64 Using Conditional Formatting to Find Duplicates
-
65 Removing Duplicates
-
66 Excel Function DSUM
-
67 Excel Function DAVERAGE
-
68 Excel Function DCOUNT
-
69 Excel Function SUBTOTAL
-
70 Understanding the Need for Data Validation
-
71 Creating a Validation List
-
72 Adding a Custom Validation Error
-
73 Dynamic Formulas by Using Validation Techniques
-
74 Importing Data from Text Files
-
75 Importing Data from Microsoft Access
-
76 Exporting Data to a Text File
-
77 Understanding Excel PivotTables
-
78 Creating an Excel PivotTable
-
79 Modifying Excel PivotTable Calculations
-
80 Grouping PivotTable Data
-
81 Formatting PivotTable Data
-
82 Drilling Down into PivotTable Data
-
83 Creating PivotCharts
-
84 Filtering PivotTable Data
-
85 Filtering with the Slicer Tool
-
86 Why PowerPivot
-
87 Activating the Excel PowerPivot AddIn
-
88 Creating Data Models with PowerPivot
-
89 Creating PivotTables based on Data Models
-
90 PowerPivot Calculated Fields
-
91 PowerPivot KPIs
-
92 Using the Freeze Panes Tool
-
93 Grouping Data Columns andor Rows
-
94 Print Options for Large Sets of Data
-
95 Linking Worksheets 3D Formulas
-
96 Consolidating Data from Multiple Worksheets
-
97 Congratulations
-
98 Working with Excel Name Ranges
-
99 Using Excel s IF Function
-
100 Nesting Functions
-
101 Using Excel s COUNTIF Function
-
102 Using Excel s SUMIF Function
-
103 Using Excel s IFERROR Function
-
104 Using Excel s VLOOKUP Function
-
105 Using Excel s HLOOKUP Function
-
106 Using Excel s INDEX and MATCH Functions
-
107 Using Excel s LEFT RIGHT and MID Functions
-
108 Using Excel s LEN Function
-
109 Using Excel s SEARCH Function
-
110 Using Excel s CONCATENATE Function
-
111 Tracing Precendents in Excel Formulas
-
112 Tracing Dependents in Excel Formulas
-
113 Working with the Watch Window
-
114 Showing Formulas
-
115 Protecting Specific Cells in a Worksheet
-
116 Protecting the Structure of a Workbook
-
117 Adding a Workbook Password
-
118 Working with Excel s Goal Seek Tool
-
119 Working with Excel s Solver Tool
-
120 Building Effective Data Tables in Excel
-
121 Creating Scenarios in Excel
-
122 Understanding Excel Macros
-
123 Activating the Developer Tab in Excel
-
124 Creating a Macro with the Macro Recorder
-
125 Editing a Macro with VBA
-
126 Creating Buttons to Run Macros
-
127 Congratulations on Competing the Microsoft Excel 103
We Appreciate Your Feedback
24 Reviews
Muhammad Bilal
Shehbaz Iqbal
GHAWATE KOMAL ASHOK
Marcel Asiegbu
Show More Reviews
تحميل Excel from Beginner to Advanced Computer Softwares ، دروس تحميل Excel from Beginner to Advanced ، تحميل برابط مباشر و مشاهدة تحميل Excel from Beginner to Advanced ، تعليم الاطفال تحميل Excel from Beginner to Advanced ، البداية لتعلم تحميل Excel from Beginner to Advanced ، تحميل Excel from Beginner to Advanced ، تحميل كورس تحميل Excel from Beginner to Advanced
Trends
French
l anglais
Création de logo sur Illustrator
Web Design for Beginners
Learning English Speaking
Accounting Finance course
Création de logos avec lettres
Formation efficace à l écoute de l
Logo design typographique dans illustrator
Graphic design tools for beginners
l IA pour les entreprises
Graphic Design | Photoshop
Web Design 101 Free Full Course
Création de logos avec illustrator
création des logos dans illustrator
Créer des logos avec illustrator
Création de logo musique et Logo digital
la programmation Python
aux bordures en CSS
Graphic Design Basics