We at Ikusei offer a comprehensive Excel VBA package for learners that comprises training people, support on projects, help on creating a presentable project portfolio, and professional mentorship. Our team with folks from BCG, ZS, XLRI, Kellogg and IIFT will work with you on certain strategic goals of your professional career during the engagement period
Excel modeling with VBA is meant for people working in data analytics, visualization & automation. It is used to manage projects, track income & expenses, maintain schedules, analyze KPI’s, manage employee payroll, create invoices & manage inventory. We help you become more effective in your role through our course with diverse case studies from logistics, financial planning, pricing, project management & data science.
We deliver this program through a live, instructor-led online environment that would enable the learners to experience real world problem solving along with achieving work life balance.
The course is designed by industry experts who have relevant experience in solving complex business problems using Excel VBA. Also, there are dedicated sessions to address Q&A or feedback from learners.
To learn advanced Excel for statistical, econometric & financial modeling along with automation using VBA macros.
The course is structured to have both classroom learning and hands-on projects in a cohort-based learning environment.
The course can be conducted on weekends or weekdays (flexible as per your schedule). At the end of this course, all learners will be fully aware of key Excel concepts & capabilities.
Ranges, Tables, Functions (Text, Date & Time, Numeric, Logical), Data consolidation, IFERROR, Conditional formatting (Rules, Data Bars, Scales, Icon Sets, Duplicates, Lists, Conflicts, Heat Map)
Sorting (Custom, Color, Reverse, Random), Filtering (Number, Text, Date), Subtotals, Lookup, Arrays, Data Validation, Formula evaluation
Column Chart, Line Chart, Pie Chart, Bar Chart, Area Chart, Scatter Plot, Data Series, Axes, Trendline, Error Bars, Combination Chart, Gauge Chart, Thermometer Chart, Gantt Chart, Pareto Chart, Band chart, Waterfall chart, Sparklines
Future Value, Present Value, Net Present Value, XNPV, Internal Rate of Return, MIRR, Loan Term, Loan Interest Rate, Payments, Principal & Interest Payments, Amount left to be repaid, Case studies
Variance, Standard Deviation, Standardization, Slope, Intercept, Skewness, Exponential Growth, Linear Forecasting, Correlation & Regression, COUNTIF(S), AVERAGEIF(S)
One & Two Variable Data tables setup & output, Scenario manager, Scenario output – summary & pivot table, Goal-seek setup & output, Forecasting sales for various combinations of COGS & profit
Setup, Output, Demand Curve Pricing using Price Elasticity, Transportation problem, Project management, Travelling salesperson, Retirement planning, Workforce scheduling, Logistic regression
Pivot Tables (Group Pivot Table Items, Multi-level Pivot Table, Frequency Distribution, Pivot Chart, Slicers, Update Pivot Table, Calculated Field/Item, GetPivotData)
Histogram, Descriptive statistics, ANOVA, F-test for variances, Moving average, Exponential smoothing, Correlation, Linear regression, t-Test (equal variances), Limitations, Linear regression result interpretation, Impact of price & discount on sales
Modules, Variables, Scope, Debugging, Operators, Events, Decisions, Loops, Arrays, Functions, Sub Procedure, Error Handling, Userforms, ActiveX controls, Excel objects
We are an experiential learning platform with live, instructor-led courses designed to help you succeed in the roles you want!
Trademark No: 5014872
Contact Person: Mridul Sharma
Email: [email protected]
Phone: +91 9560095330
Registered Address: F4, Kurunji Appt No. 40 East Vanniyar Street, West KK Nagar, Chennai, Tamil Nadu, India – 600078
© Ikusei Pvt. Ltd. 2022. All Rights Reserved
Made with ❤ in India by Shubh Mishra