Sridhar Pabbisetty asked a month ago if I would teach a course on Data Analysis and Visualisation Using Excel to the students of National Institute of Design (NID) for three days, starting on 15th March. Though I do not use Excel in my work and studies, I accepted the offer to find a reason and create an opportunity to study its features. I am glad I did so. In preparing for the course, I discovered several excellent features of Excel. Discussing with the intelligent and interested participants, I learnt much more. NID, Bangalore, has a serene campus and culture to emulate. Interacting with multifaceted talent, Chakradhar Saswade of NID, was another treat.
My slides for the course were in Excel sheets, which helped to experiment with Excel features for the class without having to change the application. Discussions were easier. A simple act of avoiding power point slides made a difference. Excel is a good tool to teach concepts of arithmetic, basic trigonometry and statistics including visualisation.
Then, for 4 days starting on 21st March, I taught a course on Data Analysis with Python at Synechron Bangalore Centre. It was a great learning experience, again. Excellent professionals with 4 to 8 years of experience attended the course. This course helped in consolidating my understanding of Python and its use in data analysis and to identify some gaps in my knowledge.
No PowerPoint slides in this course either. I used Jupyter Notebooks. “Open source, interactive data science and scientific computing across over 40 programming languages. The Jupyter Notebook is a web application that allows you to create and share documents that contain live code, equations, visualizations and explanatory text. Uses include: data cleaning and transformation, numerical simulation, statistical modeling, machine learning and much more.”
This is a beautiful tool and I’ll reach out to this regularly in future. This is suitable for individual exploratory work, collaborative development, sharing with others what we learn, and for publication. Cyrille Rossant wrote an entire technical book using Jupyter Notebook.
I suggest you to move away from MS Word and MS PowerPoint.