This week, our Excel MVP Frederic Le Guen from Toulouse, France, tells us about his clever use of Excel as a sports coach,


“With the coronavirus crisis, like everyone, I stay home.  But after a couple of weeks, watching TV is clearly a waste of time.  And also my scale tells me that I need to do some exercises.  But what can I do in my room?”


Or in his original version in French,


“Comme chacun d'entre nous, le temps est bien long et après avoir nettoyé ma salle de bains pour la 5e fois, je ne ne savais plus comment m'occuper. Et puis, je me suis rappeler d'une fonctionnalité très peu utilisée d'Excel ; faire parler Excel (si si, c'est possible).”


Frederic turned to Excel.



Read more > English / French


Share your stories with us in the comments below.





@Frederic LE GUEN , that's very creative and nice idea. As cosmetic comment, 

RndNumber = CStr(Int(Rnd() * 4) + 1)

is enough for the speech, "1" and "one" have no difference. 

Senior Member

Ok but I'm not sure if the property Application.Speech.Speak can understand Number type

For me, only Text is possible

@Frederic LE GUEN , I mean not number 1 but text "1". Speech speaks it the same way as "one".


Nice one Fred.

This is really looking good. Recently I have created Macro where Excel not only speak but also it's visible in Excel workbook and tells his story (Excel story)


I request to visit the full video and provide your feedback (it's just 7 minutes video)

Excel by Excel YouTube Link:


Did you know that Excel can be Animated?
Did you know that Excel can speak?
Do you want to see the Power of VBA/Macros?

An extremely innovative, interactive, and efficient presentation has been put together by exploring the maximum potential of Excel created by DataSkills.

If you like the videos, don’t forget to like & subscribe

The Excel features used to create this Excel Animation are Macros, Shapes Animation, 3D Pictures, Excel Speak, Formulas, Conditional Formatting


Your feedback is highly appreciate


Karthik Dale || Founder