FREE Workshop | Excel Analytics Basics

With the right questions and a clean dataset in-hand, the time has finally come to find the answers to your questions with analysis in Excel.

This free, 2-hour workshop gives you hands-on practice with data analysis in Excel. You’ll practice applying some of the most commonly used Excel actions like Regular Tables, Pivot Tables, VLOOKUP, Charts, and Conditional Formatting to your dataset to extract the answers to your questions - and maybe prompt some new questions.

Make sure to join us next week where you’ll turn your findings from Excel into easily communicated visualizations when we Visualize Data in Tableau. We’ll see you there.

You’ll leave this workshop knowing:

• When, why and how to use regular tables and VLOOKUP
• How pivot tables work, and how to use them to quickly create dynamic aggregations, slices, and filter
• Common Excel visualizations like bar charts, pie charts, line charts, and conditional formatting

• This is an entry level workshop, so no prior knowledge is necessary.
• You’ll need an Excel account if you are planning to follow-along live. If you don’t have one already, you can sign-up for a Free 1-Month Trial of Microsoft 365
• If anything prevents you from following-along live, the recording will be shared after the series so you can review the content anytime.
• Your mic and camera will be off for the duration of the workshop.
• Interact with your instructor and fellow classmates through the Chat and Q&A.

Kishan is a seasoned data and marketing professional with a proven track record across all key areas of digital including Data Mining, Data Science, Data Visualisation, Data-Driven Transformation, Sentiment Analysis, Data Storytelling, Web Analytics, Social Analytics, App Analytics, Advanced Analytics, Omni-channel Tracking, Paid Social, SEO, SEM, CRM, E-Commerce, and Digital Strategy

He has worked for 4 of the world's leading digital technology agencies: Amobee, Golin, Datalicious, and Socialbakers. Throughout his career, he has managed hundreds of digital campaigns and built several digital teams from ground-up, working with a diverse portfolio of local and global companies – including some of the world’s biggest brands: McDonalds, Sony, Prudential, Volkswagen, and Cartier.

Kishan also has extensive hands-on experience in Data Science where he has worked with E-Commerce and FMCG clients to build Machine Learning models to enhance the performance of product recommendation engines and drive profitability of product bundles among other areas.

He has also previously worked as a data scientist, automating data extraction from Weibo and Taobao to measure the impact of online retailers' social media marketing strategies on consumer engagement and sales performance using quantitative methods including random-effects panel regression.

Throughout the past decade, Kishan has also worked on other interesting Data Science projects including a predictive modelling app which allows users to find the number of parking lots at their destination for a given location and time slot. He also built an innovative sentiment analysis model for a software company to evaluate their customer satisfaction rate using data extracted and automated from customer support tickets.

Kishan's experience has also centred around managing business growth and day-day operations for data-driven marketing start-ups in Asia. Having built and led several high-performance digital teams and programs in the past decade, Kishan combines management experience with deep subject matter expertise across business analytics, data science and digital marketing. He is also highly skilled in leveraging MarTech to grow digital revenue and reduce customer churn for leading brands in Asia including Singtel and Globe Telecom.