Basic and advanced Excel training in accounting

Basic and advanced Excel training in accounting

Advanced Excel training topics in accounting Introduce some practical properties of Excel Working with patterns in Excel Various methods of data protection  Familiarity with the concept of OLE and working with it - Communicating Excel files with other files  Automatic formatting - Defining formats and numeric formats  Creating a named block for different ranges and referencing it Conditional Formatting  Important Formulation Tips How to Address and Name Methods Introduce Reference Operators - Working with Complex Computational Formulas  3D Formula Writing and Combined References  Working with Formula Auditing and Error Checking  Working with some of the most widely used mathematical, reference, date and time, logical, textual, financial, database, etc. functions. Introducing the IF  Text Formulas, Date Text Formulas Date Formulas Excel Search Functions  Lookup tools Index & match tools Select tools Introduce table & subtotal tools Introduce database formulas  Combining functions with formulas - Using Nested functions Working with different types of filters: AutoFilter and Advanced Filter Working with data analysis tools What if Analysis  Scenarios scenario analysis to estimate future financial conditions Financial ratio scenario formation Dopon ratio sensitivity analysis Using the Goal Seek tool to estimate future financial objectives Analysis of types of bank facilities and their installments Validation Validation Category Group & Outline Use Subtotals tool to calculate subtotals Consolidation and one Consolidate information Analyze financial functions in Excel How to use financial functions in calculating the time value of money  Examining methods for depreciation of assets Data table Using financial functions in evaluating economic plans and industrial projects The logic of time in Excel Payment system Legit file A tax analysis in the system Salary Preparation of personnel entry and exit reporting software case study Warehousing calculations No empty Financial statements Preparation of balance sheet Preparation of profit and loss statement Preparation of payroll system program in the form of Excel software format Introduction of various types of charts in Excel) Charts Bubble - Dispersion in Accounting (
Combination Charts and Chart Details Draw professional charts and work with the Trend line and obtain the equivalent function of the lines  Professional settings in the chart Iv Pivot Table and PivotChart Table charts and diagrams \ d Doing repetitive tasks by creating Macro and programming preliminaries

For more information on in-person and out-of-class classes, contact the following number: (At the bottom of the ad)136018430 School hours 8 am to 5 pm