محتوای دوره:
- Excel
- User Interface
- Working with Ribbon & QAT , Status Bar
- Working with cells
- Active Cell , Comments (Insert, Edit, Delete)
- Undo/Redo , Editing Cells
- Fill Series & Clear
- Sort & Filter & Auto Filter , Subtotals
- Find & Select(Find, Replace, Go To, Go to Special)
- Working with Sheets
- Remove, Delete, Insert Sheets
- Hide & Tab Color , Insert, delete (Row & Column)
- Width & Height (Row & Column)
- Working with Sheet Options
- Sheet Direction , Gridlines , Headings
- Working with Workbook
- Properties, Save & Save As Type (PDF)
- Password , Templates
- Working with Data
- Format Cells , Styles , Number Formatting
- Date & Time in Excel
- Copy, Paste (Office Clipboard)
- Paste Special(Paste Options)
- Auto Complete , Custom List , Text To Columns , Shortcut Keys
- Charts
- Insert Charts & Editing Charts
- Bar, Column, Line, Area, Doughnut, Pie, Bubble
- Scatter, Radar , Surface, Stock ,Pareto, Waterfall
- Sparklines ,Treemap, Sunburst ,Pareto ,Histogram
- Insert Charts & Editing Charts
- Protect in Excel
- Protecting Worksheets & Workbooks
- Protecting & Share Workbook
- Error in Excel
- Excel formulation errors and their meaning
- Use TRACE PRECEDENTS
- Work with the Evaluate formula option
- Use trace error
- Use the Watch window
- Print in Excel
- Panes/Freeze/Zoom , Custom View
- Page Setup & Custom Margin
- Print Area & Print Title
- Help in Excel
- Formulas in Excel
- Creating Formulas
- Overview of formulas
- Types of operators , Create or delete a formula
- Use Formula AutoComplete
- Nested Functions , 3D Formulas , Define Names
- Correcting Formulas , Examples Of Formulas
- Conditional, Look up , Date & time
- Math & Trig , Financial , Text , Array formulation
- Creating Formulas
- Table
- Table Design
- Editing & Working with Table Tools
- Using Formula in Table
- Filtering and Querying Data
- Filtering Data, Working with Auto Filter
- Advanced Filter & Group & Outline
- Working with Data in Lists
- Understanding Data Lists
- Sorting Data
- Creating and removing Subtotals
- Conditional Formatting
- Working with Data Forms
- Text to Columns
- Using Data Validation
- Dynamic List
- Custom Formula
- Working with Pivot Tables & Charts
- Creating Pivot Tables
- Pivot Options & Pivot Design
- Calculated Field & Calculated Item
- Creating Pivot Charts
- Analyzing Data
- Consolidation
- Using Analysis Tool Pak
- Solving What – If Analysis
- Goal Seek
- Data Table
- Scenario
- Solver
- Using Lookup and Database Functions
- Lookup Value in a table
- Working with Database Functions
- Time, Mathematical, Statistical, Text, Financial
- Lookup, Logical, Database Functions
- Protect in Excel
- Protecting Worksheets & Workbooks
- Protecting & Share Workbook
- Auditing Worksheets
- Finding Referenced Cell sets
- Finding Formulas that refer to a cell
- Import External Data
- Access, Web
- User Form
- Form Control
- Combo box, Button, Check Box, Option Button
- Working with Macros
- Record a Simple Macro
- Run a Macro
- Other Techniques
- Define Name, Calculation
- Custom Number Format, Mail Merge
- Using Auto Correct, Freeze Pane
- Insert Symbols , Illustrations
- Auto Correct & Spelling , Hyperlink , Calculation
- Custom Number Format, Mail Merge, Wildcard
نقد و بررسیها
هنوز بررسیای ثبت نشده است.