Articles

Publish at 23 novembre 2021 Updated 26 novembre 2021

Master the art of the spreadsheet

Learning to use Excel, Google Sheets, Numbers, EtherClac and other spreadsheets has good effects

Most software suites, whether free or closed source, offer various applications that are widely used in professional settings. Because Microsoft was one of the pioneers in this area, the names of the programs have entered the common language. We speak of a "PowerPoint presentation" rather than a slide show. We write in "Word" when there are a plethora of word processors other than Word. So the image of a spreadsheet does not always come to mind. On the other hand, say Excel and everyone knows what it's about.

Good for everyone

While Excel's domestic uses are lesser, the business, management, analyst, accountant and even data journalist communities need to master it. Consequently, instilling the basics of spreadsheets is essential to equip students for future careers.

In fact, mastering Excel or Google Sheets concepts is good for learners in general. This type of technological tool can prepare them to multitask, better manage massive data and improve their analytical skills. As for those wishing to go into the world of business management, this is simply a must-have.

Teachers have the opportunity to enhance their classroom management with spreadsheets. In fact, they can keep track of each student's results for each assignment, make an average, see trends, etc. In fact, it's even possible to teach with spreadsheets. Especially since, as this university professor reminds us, many students will have to use it in their future lives. Might as well incorporate it directly into teaching materials to show examples of completed spreadsheets, functionality, etc.

Teaching Spreadsheets

Ideally, such software should be introduced as early as elementary school. Without requiring 7 or 8 year olds to do accounting, it is possible to teach them the basics. What is a cell? Are they able to find a specific one like D4 or F9? A simple exercise as demonstrated here is to ask students to enter into a spreadsheet the number of cars of different colors parked at the school or that have driven by during a period of time. As the years go by, it will be possible to add slightly more complex tasks whether it be basic functions or slightly more advanced formulas.

Teachers can ensure the use of spreadsheets by requiring for some classes the spreadsheet where students will be able to respond. There are also full lessons (in English) using Google Sheets this time, the free version offered by the Google suite. They will learn the basics and be able to think on their feet when it comes to spreadsheets. After all, the idea is that learners should not just become passive consumers but rather understand the software and be able to use it to their heart's content.

Teachers have found an interesting way to instill keyboard shortcuts in Excel. These are very handy but numerous and ultimately difficult to remember especially for people not used to them. So they created a periodic table of shortcuts. They taught this table piece by piece to the students. The students experimented with the ones they had learned each time. Afterwards, a Jeopardy-type session was held in the classroom and they had to answer the statements given by their teacher. A playful method that paid off as the young adults' results were up by about 14% on the questionnaires after the activities.

Self-study

Is it possible for young and older people who have not had a course to learn how to use spreadsheets, especially Excel? Absolutely. There are a plethora of online solutions specifically for them. This page counts all the Android phone apps to learn more about this software. Whether for beginners or more advanced courses, there are various ways to learn how to use it in the palm of your hand. Many courses are also available on Cursus

Those well-versed in English should visit this site, which lists some 40 online tutorials to learn about Excel. The suggestions start with the basics but also offer advanced tutorials in math, databases, charts, printing a spreadsheet page and even programming with the application. Enough to meet the needs of both neophytes and professionals looking to improve their knowledge.

Illustration: Mika Baumeister on Unsplash

References:

"Learn Excel Once and For All With These Free Apps." OneAndroid EN. Last updated August 6, 2021. https://oneandroid.net/fr/apprenez-excel-une-fois-pour-toutes-avec-ces-applications-gratuites/.

Barron, Brenda. "40 Excel Tutorials That Prove No-One Is Too Stupid To Master Spreadsheets." Digital.com. Last updated November 8, 2021. https://digital.com/excel-tutorials/.

Ford, Joe. "What Are the Benefits of Spreadsheets to You As a Student?" AnswersToAll. Last updated April 14, 2021. https://answerstoall.com/popular/what-are-the-benefits-of-spreadsheets-to-you-as-a-student/.

G, Nitin. "5 Important Benefits of Excel for Students." Medium. Last updated February 18, 2021. https://medium.com/career-guide/5-important-benefits-of-excel-for-students-27bd9bd6eacd.

Hermans, Felienne. "Teaching Excel and Data Analysis-one Professor's Efforts to Prepare Students for Today's Careers." Microsoft 365 Blog. Last updated August 19, 2016. https://www.microsoft.com/en-us/microsoft-365/blog/2015/04/06/teaching-excel-and-data-analysis-one-professors-efforts-to-prepare-students-for-todays-careers/.

Hummel, Brad. "3 Best Lesson Plans for Teaching Google Sheets in Your Middle School Classroom." AES. Last updated August 11, 2021. https://www.aeseducation.com/blog/google-sheets-lesson-plans.

Kyle Anderson H. "5 Ways to Start Using Excel in Your Class." Wiley. Last updated September 16, 2020. https://www.wiley.com/network/instructors-students/teaching-strategies/five-ways-to-start-using-excel-174-in-your-class.

Lee, Lorraine, Eileen Shifflett, and Tom Downen. "Teaching Excel Shortcuts: A Visualization and Game-based Approach." ResearchGate. Last updated July 2019. https://www.researchgate.net/publication/334271668_Teaching_excel_shortcuts_A_visualization_and_game-based_approach.

Olson, Angie. "Google Sheets Tips for Teachers." Lucky Little Learners. Last updated September 17, 2021. https://luckylittlelearners.com/google-sheets-tips-for-teachers/.

Poth, Richard. "Teaching Spreadsheets - A Guide to Introducing Spreadsheets to Primary Students." Attechedu. Last updated November 7, 2020. https://www.attechedu.com/single-post/teaching-spreadsheets-a-guide-to-introducing-spreadsheets-to-primary-students.

Richards, Sam. "Importance of Microsoft Excel for Management Students." The Exeter Daily. Last updated February 4, 2021. https://www.theexeterdaily.co.uk/news/business/importance-microsoft-excel-management-students.


See more articles by this author
payhip

Access exclusive services for free

Subscribe and receive newsletters on:

  • The lessons
  • The learning resources
  • The file of the week
  • The events
  • The technologies

In addition, index your favorite resources in your own folders and find your history of consultation.

Subscribe to the newsletter

Add to my playlists


Create a playlist

Receive our news by email

Every day, stay informed about digital learning in all its forms. Great ideas and resources. Take advantage, it's free!