Training Earning

About Course

Our course is thoughtfully designed in such a way that learner gets theu00a0Real Time Investment bankingu00a0& Equity Research exposure. Learner is not necessarily be from finance background, as our course ensures that Basic finance & account concepts are covered in detail with real time examples.

It isu00a080%u00a0practical with industry used case studies.

Our assessment & presentation evaluations are similar to top investment banks & equity research firms Our expert trainers are on hand to help answer any questions you might have along the way.

Content Of Course

Module 1
nBasic Formulan
    n t
  1. Formulae that Add/Subtract/Multiply/Divide
    2. n t
  2. BODMAS/Formula Error Checking
    3. n t
  3. The Sum Function
    4. n
nAbsolute ReferencingnnProblems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed ReferencesnnLOOKUP Functionsn
    n t
  1. The VLOOKUP/HLOOKUP Functions
    2. n
nPIVOT Tablesn
    n t
  1. Creating, Formatting Simple PivotTables
    2. n t
  2. Page Field in a PivotTable
    3. n t
  3. Formatting a PivotTable
    4. n t
  4. Creating/Modifying a PivotChart
    5. n
nLOGICAL FUNCTIONSn
    n t
  1. IFs and Nested IF Functions
    2. n t
  2. Using AND/OR/NOT Functions
    3. n
nSTATISTICAL FUNCITIONSnnUsing The SUMIF/COUNTIF Functionsn
    n t
  1. Using The AVERAGE/COUNT/LARGER/SMALLER Functions
    2. n
nPivot Tables u2013 Advancen
    n t
  1. Adding new calculated Fields / Items
    2. n t
  2. Changing the Summary Function
    3. n t
  3. Consolidate Pivot table
    4. n
n
Module 2
nLOOKUP Functions u2013 Advancen
    n t
  1. MATCH with VLOOKUP Functions
    2. n t
  2. INDEX & MATCH Functions
    3. n t
  3. OFFSET/ INDIRECT functions
    4. n
nLogical Functions u2013 Advancen
    n t
  1. If Loop and Nested IF Loop Functions
    2. n t
  2. Using IF/ISERROR Functions
    3. n
nChart Data Techniquesn
    n t
  1. The Chart Wizard
    2. n t
  2. Chart Types
    3. n t
  3. Adding Title/Legends/Lables
    4. n t
  4. Printing Charts
    5. n t
  5. Adding Data to a Chart
    6. n t
  6. Formatting/Renaming/Deleting Data Series
    7. n t
  7. Changing the Order of Data Series
    8. n
nDate/Time Functionsn
    n t
  1. Using the Today
    2. n t
  2. Now & Date Functions
    3. n t
  3. Using theDatedif/ Networkdays/ Eomonth Functions
    4. n t
  4. Using theWeeknum Functions
    5. n t
  5. Using theEdate/ Networkdays.Intl/ Weekdays.Intl Functions.
    6. n
nText Functions Usingn
    n t
  1. The Mid/ Search/ Left/ Right Functions
    2. n t
  2. Using the Trim/ Clean/ Upper/ Lower Functions
    3. n t
  3. Using theSubsitute/ Text Functions
    4. n
nValidationsn
    n t
  1. Input Messages / Error Alerts/ Drop-Down Lists
    2. n t
  2. Conditional Formatting
    3. n
n
Module 3
nAdvanced Filtersn
    n t
  1. Extracting Records with Advanced Filter
    2. n t
  2. Using Formulas In Criteria
    3. n
nAdvanced Sortingn
    n t
  1. Sorting by Top to Bottom / Left to Right
    2. n t
  2. Creating / Deleting Custom List
    3. n t
  3. Sort by using Custom List
    4. n
nHyper / Data Linkingn
    n t
  1. Hyper linking data, within sheet / workbook
    2. n t
  2. Linking & Updating links between workbooks & application
    3. n
nMath & Trigonometry Functionsn
    n t
  1. Using SUMPRODUCT Functions
    2. n t
  2. Using FLOOR/ CEILING/ MROUND/ MOD/ QUOTIENT Functions
    3. n
nStatistical Analysisn
    n t
  1. Conduct sensitivity and u2018What if Analysisu2019, Scenario Analysis, Dashboards, Interactive Financial Models, Monte Carlo Simulation
    2. n
nFinancial Functionsn
    n t
  1. Loan Amortization Schedule and functions like PV, FV, PMT, Rate, Nper, IPMT, CUMPMT, etc
    2. n
nu00a0n
Module 4
nSummarizing Datan
    n t
  1. Creating Subtotals/Nested Subtotals
    2. n t
  2. SUBTOTALS Formula
    3. n
nOutliningn
    n t
  1. Creating/Working with an Automatic/Manual Outline
    2. n t
  2. Grouping / Ungrouping
    3. n
nConsolidationn
    n t
  1. Consolidating Data with Identical/Different Layout
    2. n
nUsing Auditing Toolsn
    n t
  1. Displaying/Removing Dependent & Precedent Arrows
    2. n t
  2. Evaluate Formula u2013 Step IN/ Step Out
    3. n
nCustom Viewsn
    n t
  1. Creating Custom Views
    2. n t
  2. Displaying Custom Views
    3. n t
  3. Deleting Custom Views
    4. n
nSharing and Protecting Workbooksn
    n t
  1. Sharing Workbooks & Tracking Changes
    2. n t
  2. Protecting sheets / workbooks / Files
    3. n
nImporting & Exporting Datan
    n t
  1. Importing Data from Database/ Text Files/ Web
    2. n t
  2. Exporting Data
    3. n t
  3. Changing External Data Range
    4. n
n
Module 5
nDashboard Preparation-n
    n t
  1. Dashboard for MIS, Analysis, different dashboards for different business types and business segments, will include a self-assignment (formulas like offset, advance formatting, macros, hyperlink, etc.)
    2. n
nAdvance PivotnnFormatting, grouping, computing %, Summarizing Values, Auto report Generation u2013100s with a click, Calculated Fields, Connecting Multiple Sources of data, Use of Slicer and Report Filter to create quick dashboard, Pivot charts, Power pivot and Power View u2013Introduction, and other Advance features, Consolidating data across multiple table.

Duration

Duration of Basic Latest Tally Prime Course :u00a01.5 to 2 Months

Batch Timing

COURSE TRAINING TYPEBATCHCITYREGISTER
Certified Professional AccountantClassroom / OnlineRegular Batch (Mon-Fri)PuneApply Now
Certified society accountant professionalClassroom / OnlineRegular Batch (Mon-Fri)PuneApply Now
Certified Excel professionalClassroom / OnlineRegular Batch (Mon-Fri)PuneApply Now
Certified GST ProfessionalClassroom / OnlineRegular Batch (Mon-Fri)PuneApply Now
Certified Taxation ProfessionalClassroom / OnlineRegular Batch (Mon-Fri)PuneApply Now

Benefit with us

  1. Understand practical issues faced with EXCEL with the focused FAQ session
  2. Gain experience of computer-based practical training on Excel
  3. Get knowledge on recent amendments & their challenges
  4. Resolve doubts on EXCEL during & after training
  5. Real-life cases and experiences shared by EXCEL experts

u00a0

1. Increased salary percent

With the course certificate, the salary of the people working in the financial sector may increase by a significant amount. They are also likely to get a superior and advanced job position with increased perks.

2. Improved Career Progress

The course certificate may also increase the chances of getting in a better position at the workplace. They can make the work of the individual with this certificate extra inevitable in the tax sector than the ones not having it. They may accelerate the career path with less effort and give better outcomes for the given Hard work.

3. Improved Skill set

The certification course in goods and services tax can also increase the taxation skills of the professionals. They can also provide skills to individuals eager to learn about the indirect tax system. So the people can learn extra about the indirect taxes easily and get a clear picture of their EXCELdetails.

4.Sophisticated syllabus

Unlike some other courses, these certification courses have a better understanding of the syllabus with many types of course delivery. They could even be learned with online classes if the individual has previous experience or a better understanding of the taxation system.

Eligibility

  1. B.com, M.com, MBA Finance
  2. There are as such no prerequisites
  3. Student of any field can enroll
  4. Graduates, Undergraduates, 10+2
  5. Business Owner
  6. Commerce Subject Students

Salary Package

Salary Package is aroundu00a0Rs 4,00,000 to Rs 6,00,000u00a0u00a0as per Industry Standard.

Exams & Certification

Training Earning Certification is Accredited by all major Global Companies around the world. We provide after completion of the theoretical and practical sessions to fresheru2019s as well as corporate trainees. Our certification in Latest Tally at Training Earning is accredited worldwide. It increases the value of your resume and you can attain leading job posts with the help of this certification in leading MNCu2019s of the world. The certification is only provided after successful completion of our training and practical based projects.

Job Roles After Training

  1. Student can assist his client in developing Accounting and Book keeping Framework.
  2. Freelance Opportunities.
  3. Student can do accounting of Micro, Small, Medium Enterprises.
  4. Student can be a master of Statutory Compliances.
  5. Preparation of Books of accounts for all types of Audit work.
  6. Huge opportunities to work as a Account Manager, Assistance Account Manager, Compliance Officer, etc.
  7. In BPO or KPO as a Excel Expert.