اكسل من البداية حتى الاحتراف
محتوى الدورة
Microsoft Excel
-
Getting Started with Microsoft Office Excel
-
Navigate the Excel User Interface
-
Use Excel Commands
-
Create and Save a Basic Workbook
-
Data Cell Enter
-
Modifying a Worksheet
-
Insert, Delete, and Adjust Cells, Columns, and Rows
-
Working with sheet
-
Search for and Replace Dat a
-
Use Proofing and Research Tools
-
Formatting a Worksheet
-
Apply Text Formats
-
Align Cell Contents
-
Apply Number Formats
-
Apply Styles and Themes
-
Apply Basic Conditional Formatting
-
Create and Use Templates
-
Printing Workbooks
-
Preview and Print a Workbook
-
Set Up the Page Layout
-
Configure Headers and Footers
-
Views Worksheet and Workbook Manage
-
Protecting workbooks & protect sheet
-
Create Formulas
-
?How to Insert Functions
-
Use Specialized Functions
-
Use Specialized Functions
-
Work with Date & Time Functions
-
Work with Text Functions
-
Working with Lists and data validation
-
Sort Data
-
Filter Data
-
Data Subtotal and Outline
-
Create and Modify Tables
-
Charts with Data Visualizing
-
Charts Create
-
Modify and Format Charts
-
Features Chart Advanced Use
-
Create sparklines
-
Create a PivotTable
-
PivotCharts with Data Present
-
Slicer
-
Timeline
-
Use Links and external references
-
D3 reference
-
Consolidate Data
-
Advanced filter
-
Using Lookup functions and formula Auditing
-
Work with Macros
تقييمات ومراجعات الطلاب
لا يوجد تقييم حتى الآن