Excel for good: Excel as a sports coach
Published May 01 2020 08:00 AM 7,064 Views
Microsoft

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.

 

Cuong
Microsoft

 

5 Comments

@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. 

Brass Contributor

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.

Copper Contributor

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: https://youtu.be/xkFlNT7eVOg

 

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

 

Regards,
Karthik Dale
www.dataskills.in || Founder

Version history
Last update:
‎May 01 2020 08:00 AM
Updated by: