Microsoft Excel is a very powerful tool for data analysis, number crunching, automation, reporting and building dashboards. This program aims to help novice excel users to pro users in about 5 days. The program is completely hands on based with embedded mini projects and use cases to make it easy for understanding and retention. The program will focus on all the essential skills that are required for expert excel users. This course would be perfect for who use excel at work and want to improve their productivity and excel at work. This course would also be ideal for those looking for job opportunities that require business intelligence, automation and building dashboards using excel.
– This module will focus on acing the essentials of excel and gearing up on speed of implementation of common and often used tasks.
– Understand how to apply essential data analysis tasks using excel. This module will focus on the application of graphs and pivot tables to answer business questions.
–Experience the joy of automation when you learn excel to automate day to day tasks at work like a pro. We will start with the fundamentals and help you build a complete solution all by yourself.
– We show how to use the latest features in excel for querying, data manipulation and dashboarding using Power BI.
–Learn to build customized professional dashboards using excel in minutes. We will focus on performance and efficiency along with visual insights in this module.
–Understand the appropriateness of tests like T-test, F-test and Chi-Square and implement the same to solve business case studies
– Professionals in the field of E-Commerce, Finance, Sales and Operations often need to build forecasting models to take sound decisions and we show you how to excel at making one. We integrate R and excel in this module and demonstrate the immense power that we gain through this.
Srikanth Balasubramanian has about 14 years of experience in training, consulting and software. He is a corporate trainer and an analytics consultant for Fortune 500 and MNC firms like VISA, Credit Suisse, Cisco, Honeywell, NXP, Metro, KPMG, PWC Analytics Advisory, Skoruz & Brillio technologies. He also has an extensive Machine Learning and Data Analytics consulting experience with SME firms like Merit Group and RVS Group, where he helped them set up new lines of business based on analytics despite constrained budgets and resources. He has a strong understanding of issues in analytics in the retail, marketing, and finance areas and hasend-to-end capabilities to link analytical models to business goals and outcomes. He works closely with mid-career and senior folks in MNCs around the globe; Canada, USA, Singapore, Hong Kong, and India.