RGSwamy
Excelling Simplified
Unleash the Power of MS Excel for Cricket Analytics!
[Date: 15th, 16th, 22nd, 23rd July 2023] [ 07:00 PM – 09:00 PM ]
Duration : 2 Hours each session / Total of 8 hours
Payment : Rs.749/-
Payment Method : UPI IDs: 9003039235@ybl or 9003039235@ibl
(Once Paid please share a screenshot through WhatsApp at 9003039235)
Are you ready to dive into the world of data analytics and cricket? Join our exclusive MS Excel Cricket Analytics Training and discover how to harness the power of Microsoft Excel to analyze IPL Cricket data.
Interactive Learning Experience
Our training consists of 4 engaging sessions, each spanning 2 hours, for a total duration of 8 hours. The sessions are designed to be interactive, allowing participants to actively participate, ask questions, and engage in discussions. You'll have the opportunity to talk directly with our expert trainers and fellow participants through live chat.
Feedback
Feedback can be given post training. Now, you can give me inputs even before the training !!
I believe in personalized learning experiences. Before the training begins, you can submit some Cricket Analytics / Questions related to IPL through this form which you would like to learn. I will put in our best efforts to address your interests keeping in mind the larger audience interest and time in hand.
​
You can submit some Cricket Analytics / Questions related to IPL through https://forms.microsoft.com/r/fG9yAkqKuZ
​
Registration Details
To register for the training, visit rgswamy.com/ipl and secure your spot. Payment can be conveniently made through UPI using the following UPI IDs: 9003039235@ybl or 9003039235@ibl. Once the payment is made, share a screenshot of the transaction along with your Name and Email Address through WhatsApp to 9003039235
​
Comprehensive Learning Materials
As a participant, you'll receive exclusive access to the training recordings and practice files. We understand the importance of hands-on practice, so we provide complete raw data for you to sharpen your skills even after the training ends. All the data used is sourced from Kaggle.com, and we extend our gratitude to them for their support.
Modules / Topics / Analytics you will Learn (Just a sample and there is lot more)
​
-
Cricket Analytics (Sample tasks)
-
Discover the top 5 players with the highest batting average in IPL matches.
-
Uncover which player has taken the most catches in IPL matches between 2008-2020.
-
Explore which team has won the most matches by a margin of 10 runs or less in IPL history.
-
What is the highest partnership for each wicket in IPL matches?
-
Which player has the highest boundary percentage in IPL matches?
-
Who has bowled the most number of dot balls in IPL history
-
Which team has won the most matches by a margin of 10 runs or less in IPL history.
For Any doubts clarifications just send WhatsApp message "Cricket" to 9003039235 and we will get back to you.
Excel Learnings (Sample)
Data Analysis Made Easy
Content: Learn powerful data analysis techniques in Excel, such as sorting, filtering, and conditional formatting. Analyze large datasets effortlessly and gain valuable insights into IPL Cricket match statistics.
Visualizing Trends with Charts
Content: Master charting capabilities in Excel to visually represent IPL Cricket data trends. Create dynamic charts, such as line charts for analyzing batting averages or bar charts for comparing team scores.
Efficient Data Summarization with Pivot Tables
Content: Uncover the power of pivot tables in Excel to summarize and analyze IPL Cricket data. Sum up runs scored by teams, calculate average wickets taken per match, and explore various combinations for insightful analysis.
Automating Repetitive Tasks with Macros
Content: Streamline your workflow by automating repetitive tasks using Excel macros. Save time and effort by recording and executing macros to perform actions like data formatting, report generation, and more.
Advanced Formulas for Data Manipulation
Content: Discover advanced Excel formulas to manipulate IPL Cricket data efficiently. Use functions like XLOOKUP, VLOOKUP, SUMIFS, and IFERROR to extract specific information, calculate batting strike rates, or identify top performers.
Data Cleaning and Transformation Techniques
Content: Learn effective data cleaning techniques in Excel, such as removing duplicates, handling missing values, and transforming data formats. Ensure data accuracy and consistency for robust analysis.
Powerful Data Visualization with Conditional Formatting
Content: Enhance data visualizations with conditional formatting in Excel. Highlight exceptional performances, identify trends, and bring attention to key insights in IPL Cricket data through color scales, data bars, and more.
Collaboration and Data Sharing
Content: Explore Excel's collaboration features to facilitate teamwork and data sharing. Protect sheets, set permissions, and track changes to ensure data integrity and collaboration among multiple participants.
Efficient Data Import and Export
Content: Master the art of importing and exporting data in Excel. Import IPL Cricket match data from external sources, such as CSV files or databases, and export analysis results for further reporting and sharing.
Creating Interactive Dashboards
Content: Design interactive dashboards in Excel to provide a comprehensive view of IPL Cricket match insights. Combine charts, pivot tables, slicers, and dynamic data connections to create dynamic and interactive reports.
Error-Free Analysis with Error Handling
Content: Learn how to handle errors effectively in Excel to ensure accurate and reliable data analysis. Discover techniques to identify and troubleshoot errors, such as using error-handling functions like IFERROR and ISERROR. Avoid potential pitfalls in IPL Cricket data analysis and gain confidence in your results.
​