Leo Edunomics would like to invite those who wants to learn, understand MS® Excel Advanced level and Finance knowledge for entrepreneurs, startups & non financial professionals.

Batch- 1 Advance Excel                            Time: 9.30am to 1.30pm 

Batch- 2 Finance for Startups                    Time: 2.30pm to 6.30pm 

When:              23^rd May 2015, Saturday & 24th May 2015 Sunday

Where:            5^th Floor, Synerzip Building, Opp. Van Devi Mandir, Near Dahanukar Colony,

                        Karve Nagar, Pune. 

Registration Fees: INR. 600 per candidate for each module. 

Combo offer: INR 1100 including Lunch 

Detail content about Advance Excel

MS® Excel is a great tool which help us to manage, maintain, identify, analyses complex and large volume of reports, data quickly. As per our research we have found out that still most of us are not aware of many expedient functions, commands and shortcuts of it.

Join our workshop and learn the insights of Advance level MS® Excel

Topics covered for advance excel:

• VLOOKUP & HLOOKUP understanding
  
• Use Database Functions like DSUM, DCOUNT, DCOUNTA
  
• SEARCH, INDEX, MATCH
  
• Use functions like SUMIF, SUMIFS, COUNTIF, COUNTIFS, IFERROR
  
• Understand & use of PASTE SPECIAL, FREEZING & UNFREEZING PANES, DATEDIF
  
• Use goal seeking to determine the values required to reach a desired result
  
• Using conditional formatting to analyze data easier
  
• Create and use defined names in a workbook.
  
• Protect data in worksheets and workbooks.
  
• Understand and create PivotTable & charts
  
• How to design Dashboard
  
• Data Validation, Creating drop down lists
  
• Linking Workbooks and Uses of Edit Link options
  
• Excel Options, Customizing the Quick Access Tool Bar
  
• Recording and Viewing Macros

Topics covered for Financial Modelling: 

Finance & essential excel understanding for Finance & Non-Finance professionals/ entrepreneurs:

Finance is the most important aspect of any business. Understanding finance is not only required by finance team but for each & every person in the company.

Well, the higher you go, the more you need to interact with the finance people in your organisation. You have to understand what they’re saying and how your actions influence their numbers. You also need to understand the constraints of the markets on decisions like laying people off versus lowering productivity or paying dividends rather than investing. And ultimately, the more senior you are, the more your performance gets measured by the financial numbers.

Our training program on finance for non-finance professional aims at providing working knowledge of finance fundamentals which will empower you to take appropriate decisions taking in to account financial aspects. 

• Understanding of P&L account, Balance sheet, CF & ratios
  
• How to read financials
  
• Interpret and Evaluate Financial Information
  
• Measure Management Performance
  
• How to Use Cash Flow Analysis
  
• Evaluate Capital Investment Proposals
  
• Equity Research, Business analysis, Projections & Valuations

Who should attend?

The following categories of professionals can take the exam and obtain the certification:

• Startup founders, entrepreneurs
• Business Analysts
• Professionals into Corporate Finance
• MBA students
• Commerce graduates
• Any professionals looking forward to strengthen their knowledge of financial modeling techniques and implication
• Mid-to-senior level professionals from non-financial domains like

-          Marketing

-          IT

-          Purchase

-          Production

-          Project

-          Human resources

Prerequisites:

·         Basic knowledge and understanding of MS Excel.

·         Kindly bring your laptop

·         Requesting all participants to reach at the venue 15 mins prior.

*40% discount for POCC, PICC members & students. 

How to register: Pay by Cash, Cheque or online payment. Please send your Name, Designation, Company, email ID, phone number for further process.

For more detail, registration process kindly contact on 9960672518, 7028312952, or mail info@leoedunomics.com