Inauctus is up with its first offering M.S. Excel and Visual Basic Ana-Learn-Ytics. M.S. Excel is intensively used in industry. Learning this course will add value to any freshers knowledge as well as c.v. and will be key to fetch a job. Our offering cover all domains of Excel and visual basics with analytical approach that will be very useful. It will give you crisp theoretical concepts and Industry-relevant project data based applied learning. 4 sessions 4 hours each. Registration link: goo.gl/forms/iPTmCUN9E1 When: 8th December 2014-11 December 2014. Fee: 3000 per person Where: Inauctus training centre, North Campus GTB Nagar, Netaji Subhash Place, Delhi. # Why you should attend? Become answerable during your placement interviews – >How you used Excel for Management Information System! > Understand practical implications of theoretical concepts > Get certified for this workshop > This is not an extensive “Excel” programming, however to learn important and most widely used “Excel” commands for MIS within quick time # INTRODUCTION >Basic mathematics in excel >Basic Excel Features: Auto Sum, Auto Fill, Series Fill, Flash Fill, Wrap Text, Merge And Center, Number >Formatting, Increase And Decrease Decimal, Inserting Pictures, Shapes, Cliparts, Smartart, Hyperlinks, >Wordart & Textbox, Inserting Headers & Footers, Inserting Symbols, Inserting Signature Line, Margin Setting, >Changing Page Orientation, Password Protecting The Workbooks #FORMULAS & FUNCTIONS >Working with Formulas and Functions, Reference Styles: Relative, Absolute & Mixed. >FINANCIAL FUNCTIONS >MATHEMATICAL FUNCTIONS >STATISTICAL FUNCTIONS >LOGICAL FUNCTIONS >CONDITIONAL FUNCTIONS >TIME FUNCTIONS #MOST USED FUNCTIONS >Hands-On Experience – Creating: Loan Repayment Worksheets, Payroll Statements, Bank Reconciliation >Statements, Frequency Distribution & calculation of Statistical Parameters, Linear Regression Analysis, >Creating Depreciation Schedules #VISUALIZATION >Introduction to Charts >Learning Different types of Charts: Line Graphs, Pie Charts, Histograms & Bar Diagrams, XY-Scatter >Diagrams, XY-Line Graphs >PIVOT TABLES & PIVOT CHARTS >PIVOT TABLES & PIVOT CHARTS #ADVANCED EXCEL ANALYTICAL TOOLS >SORTING #FILTERING: AUTO FILTERS, ADVANCED FILTERS #CONDITIONAL FORMATTING #DATA PARSING #REMOVING DUPLICATES #CONSOLIDATING DATA #DATA VALIDATION: Creating & Managing Drop-Down Lists #GROUP, UNGROUP & SUB-TOTAL #DASHBOARDS & DYNAMIC DASHBOARDS: Introduction to Dashboards, Introduction to Slicers, >Interactive Dashboards with slicers, pivot tables & pivot charts, Data Visualization >Hands-On Experience: Creating – Call Center Dashboard, Executive Dashboards #DYNAMIC NAMED RANGES #DATA ANALYSIS TOOLPAK #Descriptive Statistics, Correlation, Regression, Anova #VBA & EXCEL MACROS Introduction to VBA & Excel Macros, VBE in Excel, Developing Macros in the VBE, Testing Macros in the VB, Excel Macro Recorder, VBA Events, VBA Coding Tips, Dealing with errors Hands-On Experience: Creating – Budget-Expenses Calculator using Excel VBA & Macros Crisp theoretical concepts and Industry-relevant project data based applied learning. #Our Faculty: >Our trainers are from INauctus and are one of the finest analytics consultants in the country with the tag of being amongst the first group of CAP (INFORMS) professionals in India. They have taught analytics at platforms such as IIM, DU, Amity, NIIT, and the likes. Their industrial experience blended with international style of classroom teaching makes learning a very good experience for the analytics aspirant. >Website: inauctus >For any queries contact: Abhishek: 9910120228 POSTS
Posted on: Sat, 29 Nov 2014 07:18:16 +0000
Trending Topics
Recently Viewed Topics
© 2015