Name: Learn tableau, tally and digital marketing
Price: 30000 INR
Availability: InStock
Rating: 4.7 (450 reviews)

Basic to Advanced statistical data analysis

₹25000(90 hours)

Basic Level
- Introduction to Statistics
  - Definition and importance of statistics.
  - Types of data: qualitative vs. quantitative.
  - Scales of measurement: nominal, ordinal, interval, and ratio.
- Descriptive Statistics
  - Measures of central tendency: mean, median, and mode.
  - Measures of variability: range, variance, standard deviation, and interquartile range.
  - Data visualization: bar charts, histograms, pie charts, and box plots.
- Probability
  - Basic concepts of probability.
  - Counting rules and sample spaces.
  - Conditional probability and the basics of Bayes' theorem.
  - Discrete and continuous probability distributions (uniform, binomial, normal).
- Hypothesis Testing and Confidence Intervals
  - Introduction to hypothesis testing.
  - Type I and Type II errors.
  - Concept of a p-value.
  - Construction of confidence intervals.
Intermediate Level
- Inferential Statistics
  - Z-tests, t-tests for one or two samples.
  - Analysis of Variance (ANOVA) for comparing more than two groups.
  - Chi-square tests for categorical data.
- Correlation and Regression
  - Correlation coefficient interpretation.
  - Simple linear regression analysis.
  - Determining the line of best fit.
  - Understanding residuals and the coefficient of determination (R^2).
- Multivariate Data Analysis
  - Introduction to multivariate statistics.
  - Multiple regression analysis.
  - Factor analysis and principle component analysis (PCA).
- Experimental Design
  - Basics of experimental design and analysis.
  - Randomized block design.
  - Factorial experiments.
Advanced Level
- Advanced Regression Techniques
  - Multiple linear regression with interaction terms.
  - Logistic regression for binary outcomes.
  - Generalized linear models.
  - Model selection and validation techniques.
  - Diagnostics for checking model assumptions.
- Time Series Analysis
  - Components of time series data: trend, seasonality, and noise.
  - Moving averages and exponential smoothing.
  - Autoregressive (AR) and moving average (MA) models.
  - ARIMA and seasonal decomposition models.
- Bayesian Statistics
  - Probability and prior distributions.
  - Bayes' Theorem application in hypothesis testing.
  - Bayesian inference and decision making.
  - Markov Chain Monte Carlo (MCMC) simulations.
- Advanced Topics in Multivariate Analysis
  - Cluster analysis.
  - Discriminant analysis.
  - Canonical correlation.
  - Structural equation modeling.
- Big Data Analytics
  - Introduction to Big Data concepts.
  - Data mining techniques and algorithms.
  - Introduction to machine learning.
  - Use of statistical software for handling large datasets (e.g., R, Python, SAS).
- Reporting and Communication of Results
  - Effective data visualization techniques for complex models.
  - Writing reports and interpreting results for different audiences.
  - Ethical considerations in data analysis.

Get Free Demo

Basic to Advanced MS Office

₹20000(90 hours)

Basic Level
- Microsoft Word
  - Introduction to Word Interface
  - Editing Text and Basic Formatting
  - Creating New Documents
  - Working with Templates
  - Inserting Basic Tables and Lists
  - Printing Documents
  - Basic Document Management
- Microsoft Excel
  - Understanding Excel Interface and Workbook Structure
  - Data Entry and Basic Formatting
  - Introduction to Formulas and Basic Functions
  - Creating Simple Spreadsheets
  - Using Basic Charts
  - Sorting and Filtering Data
  - Printing Spreadsheets
- Microsoft PowerPoint
  - Navigating PowerPoint Interface
  - Creating New Presentations
  - Adding and Formatting Slides
  - Inserting Text, Images, and Basic Shapes
  - Applying Themes and Layouts
  - Delivering a Basic Presentation
  - Printing Slides and Handouts
- Microsoft Outlook
  - Setting up Email Accounts
  - Basic Email Management
  - Sending and Receiving Emails
  - Managing Contacts
  - Scheduling Appointments and Meetings
  - Organizing Calendar
Intermediate Level
- Microsoft Word
  - Advanced Formatting and Styles
  - Working with Images and Graphics
  - Headers, Footers, and Page Numbers
  - Creating Tables of Contents and Indexes
  - Mail Merge and Labels
  - Track Changes and Comments for Collaboration
- Microsoft Excel
  - Complex Formulas and Functions (e.g., VLOOKUP, IF statements)
  - Data Validation and Conditional Formatting
  - Introduction to PivotTables and PivotCharts
  - Working with Large Datasets
  - Named Ranges and Error Checking
  - Intermediate Charting Techniques
- Microsoft PowerPoint
  - Working with Multimedia (Audio and Video)
  - Custom Animations and Transitions
  - Advanced Slide Management
  - Linking and Embedding Objects
  - Customizing Slide Master and Layouts
  - Collaborative Editing and Comments
- Microsoft Outlook
  - Advanced Email Management (Rules and Auto-Responses)
  - Using Tasks and To-Do Lists
  - Categorizing and Organizing Emails
  - Advanced Calendar Management
  - Sharing Calendars and Mailboxes
  - Email Archiving and Data Files
Advanced Level
- Microsoft Word
  - Developing Complex Documents
  - Advanced Table Techniques
  - Form Controls and Content Protection
  - Macros and VBA for Automation
  - Collaborative Features and Document Sharing
  - Integration with Other Office Applications
- Microsoft Excel
  - Advanced Data Analysis Tools
  - Mastering PivotTables and PivotCharts
  - Introduction to Macros and VBA
  - Forecasting and Solving Linear Programming Problems
  - Advanced Data Importing and Querying (e.g., Power Query)
  - Using Excel Add-ins (e.g., Solver, Analysis ToolPak)
- Microsoft PowerPoint
  - Advanced Multimedia Techniques
  - Interactive Elements and Action Buttons
  - Integration with Excel and Other Applications
  - Advanced Presentation Techniques (e.g., Rehearse Timings, Presenter View)
  - Custom Template Creation
  - Best Practices for Presentation Design and Delivery
- Microsoft Outlook
  - Advanced Mail and Calendar Automation
  - Working with Forms and Templates in Outlook
  - Configuring Advanced Account Settings
  - Managing Large Mailboxes and Performance
  - Troubleshooting Common Issues
  - Using Outlook with Other Office Programs and Services

Get Free Demo

Advanced tally with GST

₹10000(72 hours)

Basic Level: Introduction to Tally with GST
- Overview of Tally ERP 9
  - Introduction to Tally software
  - Basic accounting terms and concepts
  - Understanding the Tally interface
- Creating Masters in Tally
  - Creating company/profile setup
  - Setting up ledger accounts
  - Creating stock/inventory masters
- Accounting Vouchers
  - Recording sales, purchases, receipts, payments
  - Contra, journal, credit note, and debit note entries
- Basic GST Concepts
  - Introduction to GST
  - Understanding CGST, SGST, IGST, and UTGST
  - GST registration process
  - Invoicing and GST rates
- Implementing GST in Tally
  - Enabling and setting up GST features
  - Creating tax ledgers
  - GST-based inventory and service ledgers
- Reporting
  - Generating basic financial statements
  - Displaying ledger reports
  - Tax computation and credit reports
Intermediate Level: Tally Operations & Management
- Inventory Management
  - Configuring inventory profiles
  - Recording inventory transactions
  - Managing batch-wise details and manufacturing dates
- Advanced Accounting Features
  - Bill-wise details tracking
  - Multi-currency transactions
  - Interest calculations
- GST Adjustments and Returns
  - GST adjustments like input tax credit
  - Generating GSTR-1, GSTR-2, GSTR-3B, etc.
- Banking and Payments
  - Bank reconciliation
  - Managing cheque register
  - E-payments
- Tax Deducted at Source (TDS)
  - TDS introduction in the context of Tally
  - Creating TDS ledgers
  - Recording TDS transactions
- Data Management
  - Data backup and restore
  - Splitting company data
  - Exporting and importing data
Advanced Level: Tally Expertise & Compliance
- Advanced GST Features
  - GST annual return
  - GST audit
  - e-Way Bills in compliance with GST
- Tally Security Controls
  - User roles and profiles
  - Data security features
  - Tally Audit feature for data integrity
- Payroll Management in Tally
  - Payroll configuration
  - Recording payroll transactions
  - Managing employee database and payroll reports
- Cost Centers and Cost Categories
  - Setting up cost centers
  - Budgeting and variance analysis
- Manufacturing and Job Work
  - Bill of materials (BoM)
  - Job costing
  - Job work analysis
- Advanced MIS Reporting
  - Cash flow and funds flow statements
  - Ratio analysis
  - Multi-dimensional reporting
- Compliance and Data Synchronization
  - Handling compliance in Tally
  - Syncing data across multiple locations
- Customisation and System Administration
  - Tally TDL (Tally Definition Language)
  - Basic introduction to customization options
  - Application management and updates