مرحبا!  |  سجل  |  دخول
أدخل إعلانك مجانا
متاجر سوق السعودية
إتصل بإدارة الموقع

سوق السعودية

  سوق السعودية | دروس تعليمية | أخرى | عرض إستخدام إكسل في التحليلات المالية Excel 2010 Financials & Data A

إستخدام إكسل في التحليلات المالية Excel 2010 Financials & Data A


        
HPUX – HP Unix Fundamentals
الثمن يناقش
شوهدت 437
Unix Sun Solaris 10 Fundamental مقدمة نظام التشغيل سن سولاريس
الثمن يناقش
شوهدت 459
الثمن يناقش
شوهدت 363
الثمن يناقش
شوهدت 459
برمجة الويب الأحترافية باستخدام2012   ASP.NET v4.5 Using Visual
الثمن يناقش
شوهدت 393
HTML5 لغة برمجة ويب
الثمن يناقش
شوهدت 401
برمجة فيجوال بيسك 2012  Visual Basic 2012 Programming
الثمن يناقش
شوهدت 414
XML لغة البرمجة
الثمن يناقش
شوهدت 416
إستخدام  إكسل  التحليلات  المالية  Excel    Financials    Data  A            صور أخرى
الثمن:  يناقش 
 itsea 
المكان:  الرياض - الرياض 
 00966509475020 
تاريخ الإعلان:
 11-09-2013 
 موقع المعلن 
شوهدت:
 457 
 لا يوجد متجر خاص 


إستخدام إكسل في التحليلات المالية Excel 2010 Financials & Data Analysis

Understanding Formulas
Getting the Most from This Chapter
Introduction to Formulas
Entering Your First Formula
Building a Formula
The Relative Nature of Formulas
Overriding Relative Behavior: Absolute Cell References
Using Mixed References to Combine Features of Relative and Absolute References
Using the F4 Key to Simplify Dollar Sign Entry
Three Methods of Entering Formulas
Enter Formulas Using the Mouse Method
Entering Formulas Using the Arrow-Key Method
Entering the Same Formula in Many Cells
Copying a Formula by Using Ctrl+Enter
Copying a Formula by Dragging the Fill Handle
Double-Click the Fill Handle to Copy a Formula
Use the Table Tool to Copy a Formula
Controlling Formulas
Formula Operators
Order of Operations
Stacking Multiple Parentheses
Understanding Error Messages in Formulas
Using Formulas to Join Text
Joining Text and a Number
Copying Versus Cutting a Formula
Automatically Formatting Formula Cells
Using Date Math
Troubleshooting Formulas
Highlighting All Formula Cells
Seeing All Formulas
Editing a Single Formula to Show Direct Precedents
Using Formula Auditing Arrows
Tracing Dependents
Using the Watch Window
Evaluate a Formula in Slow Motion
Evaluating Part of a Formula
Understanding Functions
Working with Functions
The Formulas Tab in Excel
Finding the Function You Need
Using AutoComplete to Find Functions
Using the Function Wizard to Find Functions
Getting Help with Excel Functions
Using In-Cell ToolTips
Using the Function Arguments Dialog
Using Excel Help
Using AutoSum
Potential Problems with AutoSum
Special Tricks with AutoSum
Using the AutoSum Drop-Down
Using the New General-Purpose Functions in Excel
Like SUBTOTAL, but Better: AGGREGATE()
Added in Excel : IFERROR()
Using Conditional Formulas with Multiple Conditions: SUMIFS(), AVERAGEIFS(), and
COUNTIFS()
Functions with New Variations in Excel
Calculating Multiple MODE Values
Calculating Workdays
Handling Ties in the RANK Function
Calculating Percentiles and Quartiles
Calculating CEILING and FLOOR for Negative Values
Functions That Have Been Renamed
Using Everyday Functions: Math, Date and Time, and Text Functions
Using SUM to Add Numbers
Using AGGREGATE to Ignore Error Cells or Filtered Rows
Using COUNT or COUNTA to Count Numbers or Nonblank Cells
Using ROUND, ROUNDDOWN, ROUNDUP, INT, TRUNC, FLOOR, FLOOR.PRECISE, CEILING,
CEILING.PRECISE, EVEN, ODD, or MROUND to Remove Decimals or Round Numbers
Using SUBTOTAL Instead of SUM with Multiple Levels of Totals
Using RAND and RANDBETWEEN to Generate Random Numbers and Data
Using ABS() to Figure Out the Magnitude of ERROR
Using PRODUCT to Multiply Numbers
Using SIGN to Determine the Sign of a Number
Using COUNTIF, AVERAGEIF, and SUMIF to Conditionally Count, Average, or Sum Data
Using Conditional Formulas with Multiple Conditions: SUMIFS(), AVERAGEIFS(), and
COUNTIFS()
Dates and Times in Excel
Understanding Excel Date and Time Formats
Examples of Date and Time Functions
Using NOW and TODAY to Calculate the Current Data and Time or Current Date
Using YEAR, MONTH, DAY, HOUR, MINUTE, and SECOND to Break a Date/Time Apart
Using DATE to Calculate a Date from Year, Month, and Day
Using TIME to Calculate a Time
Using DATEVALUE to Convert Text Dates to Real Dates
Using TIMEVALUE to Convert Text Times to Real Times
Using WEEKDAY to Group Dates by Day of the Week
Using WEEKNUM to Group Dates into Weeks
Alternative Calendar Systems and DAYS
Using YEARFRAC or DATEDIF to Calculate Elapsed Time
Using EDATE to Calculate Loan or Investment Maturity Dates
Using EOMONTH to Calculate the End of the Month
Using WORKDAY or NETWORKDAYS to Calculate Workdays
Using International Versions of WORKDAY or NETWORKDAYS
Joining Text with the Ampersand (&) Operator
Using LOWER, UPPER, or PROPER to Convert Text Case
Using TRIM to Remove Trailing Spaces
Using CLEAN to Remove Nonprintable Characters from Text
Using the CHAR Function to Generate Any Character
Using the CODE Function to Learn the Character Number for Any Character
Using LEFT, MID, or RIGHT to Split Text
Using LEN to Find the Number of Characters in a Text Cell
Using SEARCH or FIND to Locate Characters in a Particular Cell
Using SUBSTITUTE and REPLACE to Replace Characters
Using REPT to Repeat Text Multiple Times
Using EXACT to Test Case
Using the T and VALUE Functions
Using Functions for Non-English Character Sets
Using Powerful Functions: Logical, Lookup, and Database Functions
Examples of Logical Functions
Using the IF Function to Make a Decision
Using the AND Function to Check for Two or More Conditions
Using OR to Check Whether Any Conditions Are Met
Using the TRUE and FALSE Functions
Using the NOT Function to Simplify the Use of AND and OR
Using the IFERROR Function to Simplify Error Checking
Using the IS Functions to Test for Errors
Using the ISREF Function
Using the N Function to Add a Comment to a Formula
Using the NA Function to Force Charts to Not Plot Missing Data
Using the INFO Function to Print Information about a Computer
Using the CELL Function
Using TYPE to Determine Type of Cell Value
Examples of Lookup and Reference Functions
Using the CHOOSE Function for Simple Lookups
Using VLOOKUP with TRUE to Find a Value Based on a Range
Using COLUMN to Assist with VLOOKUP When Filling a Wide Table
Using HLOOKUP for Horizontal Lookup Tables
Using the MATCH Function to Locate the Position of a Matching Value
Using INDEX and MATCH for a Left Lookup
Using MATCH and INDEX to Fill a Wide Table
Performing Many Lookups with LOOKUP
Using Functions to Describe the Shape of a Contiguous Reference
Using AREAS and INDEX to Describe a Range with More Than One Area
Using Numbers with OFFSET to Describe a Range
Using ADDRESS to Find the Address for Any Cell
Using INDIRECT to Build and Evaluate Cell References On-the-Fly
Using the HYPERLINK Function to Quickly Add Hyperlinks
Using the TRANSPOSE Function to Formulaically Turn Data
Using the RTD Function and COM Add-ins to Retrieve Real-Time Data
Using GETPIVOTDATA to Retrieve One Cell from a Pivot Table
Using DSUM to Conditionally Sum Records from a Database
Using the DGET Function
Using Financial Functions
Examples of Common Household Loan and Investment Functions
Using PMT to Calculate the Monthly Payment on an Automobile Loan
Using RATE to Determine an Interest Rate
Using PV to Figure Out How Much House You Can Afford
Using NPER to Estimate How Long a Nest Egg Will Last
Using FV to Estimate the Future Value of a Regular Savings Plan
Using PPMT to Calculate the Principal Payment for Any Month
Using IPMT to Calculate the Interest Portion of a Loan Payment for Any Month
Using CUMIPMT to Calculate Total Interest Payments During a Time Frame
Using CUMPRINC to Calculate Total Principal Paid in Any Range of Periods
Using EFFECT to Calculate the Effect of Compounding Period on Interest Rates
Using NOMINAL to Convert the Effective Interest Rate to a Nominal Rate
Using SLN to Calculate Straight-Line Depreciation
Using DB to Calculate Declining-Balance Depreciation
Using DDB to Calculate Double-Declining-Balance Depreciation
Using SYD to Calculate Sum-of-Years’-Digits Depreciation
Using the NPV Function to Determine Net Present Value
Using IRR to Calculate the Return of a Series of Cash Flows
Using MIRR to Calculate Internal Rate of Return, Including Interest Rates
Using XNPV to Calculate the Net Present Value When the Payments Are Not Periodic
Using XIRR to Calculate a Return Rate When Cash Flow Dates Are Not Periodic
Using YIELD to Calculate a Bond’s Yield
Using PRICE to Back into a Bond Price
Using RECEIVED to Calculate Total Cash Generated from a Bond Investment
Using INTRATE to Back into the Coupon Interest Rate
Using DISC to Back into the Discount Rate
Three-Dimensional Formulas.
The Auditing Tool
Sensitivity Analysis with Data Tables
The Goal Seek Command.
Using the Scenario Manager for Sensitivity Analysis
The COUNTIF, COUNTIFS, COUNT, COUNTA, and
COUNTBLANK Functions
The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS
The OFFSET Function.
The INDIRECT Function.
Conditional Formatting.
Sorting in Excel
Tables.
Spin Buttons, Scroll Bars, Option Buttons, Check Boxes,
Combo Boxes, and Group List Boxes
An Introduction to Optimization with Excel Solver
Using Solver to Determine the Optimal Product Mix
Using Solver for Capital Budgeting.
Using Solver for Financial Planning.
Penalties and the Evolutionary Solver
The Traveling Salesperson Problem
Importing Data from a Text File or Document
Validating Data.
Summarizing Data by Using Histograms
Summarizing Data by Using Descriptive Statistics
Using PivotTables and Slicers to Describe Data .
Sparklines
Summarizing Data with Database Statistical Functions .
Filtering Data and Removing Duplicates
Consolidating Data
Using Moving Averages to Understand Time Series
40 ساعة دراسية
من الممكن أن يكون الكورس بصورة فردية – درس خصوصي
مواعيد مرنة
نضمن لك الفهم الكامل لمحتوى الدورة
0562407065 --- itseacom@gmail.com


 مراسلة صاحب الإعلان
 أخبر إدارة الموقع عن إعلان مخالف!
تنبيه: لا تدفع أي مبلغ حتى تحصل على منتجك كاملا غير منقوصا!
كل الإعلانات المدرجة في سوق العرب هي مسؤولية من أعلن، و سوق العرب غير مسؤولة عن مضمون الإعلانات و لا عن نتائجه.
أدرج تعليقك على إستخدام إكسل في التحليلات المالية Excel 2010 Financials & Data A!
خارطة الموقع
أضف إعلانك مجانا
جميع الحقوق محفوظة لسوق العرب © 2015.