GOOGLE SHEETS – TOUS NIVEAUX – 10 HEURES

FORMATION GOOGLE SHEETS - TOUS NIVEAUX

10 heures - à distance

Solution complète méthode immersive tous niveaux – Passage de la certification ICDL

Formation créée le 01/04/2024.

Présentation du cycle de formation​

Formation adaptée aux besoins, intérêts et disponibilités de l’apprenant. Elle vous permet de développer ou de perfectionner vos connaissances au travers d’exercices et de cas concrets réalisés. 8 heures en cours particuliers visioconférence + 2 heures préconisés sur plateforme. Accès illimité pendant 1 an.

Objectifs de la formation

Pour qui ?

Prérequis

Contenu de la formation

  • Définir les possibilités du tableur Google
  • Explorer l’interface et les différents menus
  • Masquer / démasquer les différents menus
  • Utiliser les ressources d’aide disponibles
  • Etude des différents raccourcis clavier
  • Comprendre la notion d’information unique au sein d’une cellule
  • Utiliser l’enregistrement automatique et incrémentiel dans le drive
  • Travailler à plusieurs sur un même document
  • Restaurer et créer une copie d’une version antérieure grâce à l’historique des versions
  • Découvrir le travail en mode hors connexion via le drive
  • Naviguer entre plusieurs classeurs
  • Créer un fichier Sheets dans le drive, vierge ou à partir d’un modèle
  • Enregistrer un fichier Google Sheets et le renommer
  • Ouvrir un fichier Sheets récemment fermé
  • Exporter une feuille de calcul dans un format téléchargeable et l’envoyer par mail
  • Importer un fichier CSV dans une feuille de calcul
  • Paramétrer une feuille de calcul
  • Modifier, déplacer, masquer des cellules, lignes et colonnes
  • Sélectionner des cellules adjacentes ou non
  • Modifier le nom et la couleur des feuilles
  • Créer une série de dates, de nombres et de textes
  • Insérer une image dans un tableur
  • Copier et déplacer des données
  • Utiliser la fonction “Rechercher et remplacer”
  • Utiliser la fonction “Annuler” et “Répéter”
  • Copier des données d’une feuille et les coller dans une autre feuille
  • Fusionner des cellules
  • Appliquer des couleurs en alternance sur un tableau
  • Appliquer différents formats à une plage (date, devise, décimales, texte, pourcentages…)
  • Présentation des cellules (alignement, encadrement, couleur…)
  • Dupliquer des mises en forme
  • Modifier la largeur d’une colonne
  • Changer la police, la taille, le soulignage et la mise en gras des caractères
  • Appliquer une mise en forme conditionnelle automatique
  •  
  • Comprendre les formules dans Google Sheets
  • Utiliser les fonctions statistiques (SOMME, MOYENNE, NB, MAX, MIN) Exploiter les données de Google Sheets

Trier des données sur une feuille de calcul de façon croissante ou décroissante

 
  • Faire des commentaires notifiés
  • Informer les collègues des modifications, et faire des suggestions à ceux qui coéditent avec vous

Equipe pédagogique

CONNECT LEARNING est le spécialiste des formations en cours particuliers à distance. Nous concevons votre parcours personnalisé, en fonction de votre niveau, de votre besoin et des thématiques choisies. Parcours 100% sur mesure, 100% flexible, 100% progressif. Notre approche pédagogique innovante et multimodale, à la pointe des nouvelles technologies, permet un apprentissage efficace, motivant et immersif. Notre méthode comprend :

Notre équipe pédagogique expérimentée depuis de nombreuses années vous accompagne tout au long de votre parcours de formation.

Votre service administratif vous conseille pour la mise en place et le suivi de vos dossiers de formations.

Un (e) conseiller (ère) pédagogique dédiée vous assiste tout au long de votre apprentissage avec des contacts réguliers pour s’assurer du bon avancement de la formation.

Chaque stagiaire bénéfice d’un “espace apprenant ” illimité et permanent, comprenant :

Vous trouverez dans cet espace, l’ensemble des documents nécessaires attestant du bon déroulement de la formation et des enquêtes de satisfaction.
Votre conseiller (ère) vous guidera pour la prise en main de tous les outils que nous mettons à votre disposition.

Votre service administratif : Ouvert du lundi au jeudi de 9h00 à 17h00 et le vendredi de 9h00 à 12h30.

Votre service pédagogique : Ouvert du lundi au jeudi de 9h00 à 17h00 et le vendredi de 9h00 à 12h30.

Votre référent handicap :

Suivi de l'exécution et évaluation des résultats

Ressources techniques et pédagogiques

Qualité et satisfaction

Taux de satisfaction jusqu’en septembre 2023 : 7/10 Taux d’obtention jusqu’en septembre 2023 : en attente de passage des certifications
 
 

Modalités de certification

Résultats attendus à l’issue de la formation
  • Certification ENI
Modalité d’obtention
  • L’épreuve de certification est réalisée en ligne via une machine à distance qui reproduit un environnement de travail réel, avec un système de e-surveillance. Elle est constituée de cas pratiques qui positionnent le candidat dans une situation similaire à son environnement de travail ainsi que de questionnaires
Détails sur la certification
  • RS6289 – Certification bureautique Excel ENI – Date de décision de l’enregistrement 27-03-2023 – Date d’échéance 27-03-2026

Capacité d'accueil

Un seul apprenant 

Délais d'accueil

14 jours

Accessibilité

CONNECT LEARNING s’assure que la formation proposée puisse être accessible aux personnes en situation de handicap.
Notre réfèrent handicap vous accompagnera dans votre projet de formation afin d’anticiper ensemble les aménagements éventuels à mettre en œuvre pour favoriser la réussite de votre parcours.
Vous trouverez également sur notre site internet et dans votre espace apprenant le livret “politique du handicap” vous donnant toutes les informations utiles afin de réaliser votre formation dans les meilleures conditions.
Votre contact : Thierry DAHAN
Courriel: thierry.dahan@connect-learning.com
Téléphone 01 77 38 18 15
GOOGLE SHEETS – TOUS NIVEAUX – 10 HEURES

230 commentaires sur “GOOGLE SHEETS – TOUS NIVEAUX – 10 HEURES

  1. I am curious to find out what blog system you have been using?
    I’m experiencing some small security problems with my latest website and I would like to find something more safeguarded.

    Do you have any suggestions?

    My web site … 만세력 무료

  2. Hi, I do think this is a great blog. I stumbledupon it 😉 I will return yet again since I book-marked it. Money and freedom is the best way to change, may you be rich and continue to help other people.

  3. Hello there! This post could not be written much better! Looking through this article reminds me of my previous roommate! He always kept preaching about this. I will send this post to him. Fairly certain he’ll have a good read. Thank you for sharing!

  4. You made some really good points there. I looked on the web for additional information about the issue and found most individuals will go along with your views on this website.

  5. Greetings, There’s no doubt that your website could possibly be having browser compatibility issues. When I look at your website in Safari, it looks fine however when opening in Internet Explorer, it’s got some overlapping issues. I merely wanted to provide you with a quick heads up! Apart from that, excellent blog.

  6. Oh my goodness! Awesome article dude! Thank you, However I am experiencing troubles with your RSS. I don’t understand the reason why I can’t subscribe to it. Is there anybody having similar RSS issues? Anybody who knows the solution will you kindly respond? Thanks.

  7. Everything is very open with a very clear explanation of the challenges. It was truly informative. Your website is very useful. Thanks for sharing!

  8. I’m pretty pleased to find this site. I want to to thank you for ones time just for this wonderful read!! I definitely really liked every part of it and I have you book-marked to check out new things in your web site.

  9. That is a great tip especially to those fresh to the blogosphere. Brief but very accurate info… Thanks for sharing this one. A must read post!

  10. You made some really good points there. I looked on the net to find out more about the issue and found most individuals will go along with your views on this web site.

  11. This is the right webpage for everyone who hopes to find out about this topic. You realize a whole lot its almost hard to argue with you (not that I personally will need to…HaHa). You certainly put a new spin on a subject that has been written about for decades. Excellent stuff, just great.

  12. This is the right website for anyone who would like to understand this topic. You know a whole lot its almost tough to argue with you (not that I really would want to…HaHa). You definitely put a new spin on a subject that’s been discussed for many years. Excellent stuff, just wonderful.

  13. I’m impressed, I must say. Rarely do I come across a blog that’s both educative and amusing, and without a doubt, you’ve hit the nail on the head. The issue is an issue that not enough men and women are speaking intelligently about. Now i’m very happy I found this during my search for something relating to this.

  14. May I simply say what a comfort to uncover a person that really knows what they are talking about on the net. You actually know how to bring a problem to light and make it important. More and more people really need to look at this and understand this side of the story. I can’t believe you are not more popular since you certainly have the gift.

  15. A motivating discussion is worth comment. I believe that you should publish more about this subject, it might not be a taboo subject but typically people don’t speak about such subjects. To the next! Cheers!

  16. Greetings, I believe your website might be having browser compatibility issues. Whenever I look at your website in Safari, it looks fine however, when opening in Internet Explorer, it’s got some overlapping issues. I simply wanted to provide you with a quick heads up! Apart from that, fantastic site.

  17. After exploring a few of the blog articles on your web site, I really like your technique of blogging. I saved it to my bookmark website list and will be checking back in the near future. Please visit my website as well and let me know what you think.

  18. I’m impressed, I must say. Seldom do I encounter a blog that’s both equally educative and engaging, and let me tell you, you have hit the nail on the head. The problem is something too few people are speaking intelligently about. I am very happy I came across this in my hunt for something concerning this.

  19. Having read this I believed it was rather enlightening. I appreciate you spending some time and effort to put this article together. I once again find myself spending way too much time both reading and leaving comments. But so what, it was still worth it!

  20. This is the perfect website for anybody who would like to understand this topic. You understand a whole lot its almost hard to argue with you (not that I personally will need to…HaHa). You definitely put a new spin on a topic which has been discussed for a long time. Excellent stuff, just wonderful.

  21. For years, I have actually fought uncertain blood sugar swings that left me feeling
    drained and sluggish. But because including Sugar my power degrees are now secure and
    regular, and I no more strike a wall in the afternoons.
    I appreciate that it’s a gentle, natural method that does not featured
    any kind of undesirable side effects. It’s truly transformed
    my day-to-day live.

  22. Hello! I simply want to offer you a big thumbs up for the great info you have got right here on this post. I’ll be returning to your blog for more soon.

  23. Oh my goodness! Incredible article dude! Thank you, However I am going through troubles with your RSS. I don’t know the reason why I am unable to subscribe to it. Is there anyone else having the same RSS issues? Anyone who knows the solution can you kindly respond? Thanks!

  24. Including Sugar Defender right into my everyday regimen has
    actually been a game-changer for my total well-being.
    As somebody who already prioritizes healthy consuming,
    this supplement has offered an included boost of defense.
    in my power levels, and my wish for undesirable snacks so simple and easy can have such
    an extensive effect on my daily life.

  25. Sugarcoating Defender to my day-to-day routine
    was one of the most effective decisions I’ve made for my health.
    I beware regarding what I consume, but this supplement adds an extra layer of assistance.
    I really feel extra steady throughout the day, and my yearnings
    have actually decreased dramatically. It behaves to have something so simple that makes
    such a huge distinction!

  26. I was more than happy to find this site. I wanted to thank you for your time for this particularly wonderful read!! I definitely appreciated every little bit of it and I have you book marked to check out new information in your web site.

  27. After looking over a number of the blog articles on your website, I truly appreciate your technique of blogging. I book marked it to my bookmark webpage list and will be checking back in the near future. Please check out my website as well and let me know what you think.

  28. Howdy! This post couldn’t be written any better! Reading through this article reminds me of my previous roommate! He continually kept preaching about this. I’ll forward this post to him. Pretty sure he’ll have a great read. I appreciate you for sharing!

  29. Having read this I thought it was extremely informative. I appreciate you finding the time and effort to put this content together. I once again find myself personally spending a significant amount of time both reading and posting comments. But so what, it was still worthwhile!

  30. After looking into a number of the articles on your website, I seriously like your way of writing a blog. I saved as a favorite it to my bookmark webpage list and will be checking back soon. Please visit my web site too and tell me what you think.

  31. You are so interesting! I do not suppose I’ve truly read through a single thing like that before. So nice to find another person with some unique thoughts on this issue. Seriously.. thanks for starting this up. This web site is one thing that is needed on the internet, someone with a little originality.

  32. Hey! Do you know if they make any plugins to help with Search Engine Optimization? I’m trying to get my website to rank for some targeted keywords but I’m not seeing very good results.
    If you know of any please share. Many thanks! You can read similar article here:
    Warm blankets

  33. May I simply just say what a comfort to find a person that actually knows what they are talking about on the internet. You actually realize how to bring an issue to light and make it important. A lot more people need to look at this and understand this side of the story. I was surprised you aren’t more popular because you definitely possess the gift.

  34. You have made some good points there. I looked on the internet to learn more about the issue and found most individuals will go along with your views on this website.

  35. I’m more than happy to find this site. I wanted to thank you for ones time for this particularly wonderful read!! I definitely really liked every part of it and I have you book-marked to see new information in your blog.

  36. Having read this I thought it was very informative. I appreciate you taking the time and energy to put this information together. I once again find myself personally spending a lot of time both reading and posting comments. But so what, it was still worth it!

  37. I blog quite often and I truly appreciate your content. This great article has truly peaked my interest. I am going to book mark your site and keep checking for new details about once a week. I subscribed to your RSS feed as well.

  38. I seriously love your website.. Great colors & theme. Did you build this web site yourself? Please reply back as I’m hoping to create my own blog and want to find out where you got this from or just what the theme is called. Thank you.

  39. I was pretty pleased to discover this great site. I wanted to thank you for your time for this particularly wonderful read!! I definitely liked every part of it and i also have you saved to fav to check out new information on your site.

  40. Hi there! I could have sworn I’ve visited this blog before but after browsing through a few of the posts I realized it’s new to me. Anyways, I’m certainly happy I stumbled upon it and I’ll be book-marking it and checking back frequently.

  41. Great web site you’ve got here.. It’s hard to find high-quality writing like yours these days. I really appreciate people like you! Take care!!

  42. I wanted to thank you for this fantastic read!! I definitely loved every little bit of it. I have you book marked to look at new things you post…

  43. It’s difficult to find well-informed people in this particular topic, however, you seem like you know what you’re talking about! Thanks

  44. Hello there! I could have sworn I’ve been to this web site before but after going through a few of the posts I realized it’s new to me. Anyhow, I’m definitely delighted I came across it and I’ll be bookmarking it and checking back regularly.

  45. Oh my goodness! Amazing article dude! Thank you, However I am having difficulties with your RSS. I don’t know the reason why I can’t join it. Is there anybody else getting the same RSS problems? Anybody who knows the solution will you kindly respond? Thanx!

  46. Greetings, I think your website might be having internet browser compatibility problems. Whenever I look at your website in Safari, it looks fine however when opening in I.E., it has some overlapping issues. I merely wanted to provide you with a quick heads up! Other than that, wonderful site.

  47. I needed to thank you for this very good read!! I absolutely enjoyed every bit of it. I’ve got you bookmarked to look at new things you post…

  48. Oh my goodness! Impressive article dude! Many thanks, However I am going through issues with your RSS. I don’t understand the reason why I can’t subscribe to it. Is there anybody else having identical RSS problems? Anyone that knows the solution can you kindly respond? Thanx.

  49. The next time I read a blog, Hopefully it won’t disappoint me as much as this one. After all, Yes, it was my choice to read, nonetheless I truly believed you would probably have something useful to say. All I hear is a bunch of whining about something you could fix if you were not too busy looking for attention.

  50. I’m amazed, I must say. Rarely do I come across a blog that’s both equally educative and interesting, and let me tell you, you’ve hit the nail on the head. The issue is something not enough people are speaking intelligently about. I’m very happy that I found this during my hunt for something concerning this.

  51. Spot on with this write-up, I absolutely believe that this website needs far more attention. I’ll probably be back again to see more, thanks for the info!

  52. Right here is the perfect blog for everyone who wishes to understand this topic. You understand a whole lot its almost tough to argue with you (not that I actually will need to…HaHa). You certainly put a brand new spin on a topic which has been discussed for years. Great stuff, just great.

  53. An outstanding share! I’ve just forwarded this onto a coworker who was conducting a little research on this. And he actually bought me dinner due to the fact that I discovered it for him… lol. So let me reword this…. Thank YOU for the meal!! But yeah, thanx for spending some time to talk about this issue here on your site.

  54. I really love your blog.. Very nice colors & theme. Did you develop this website yourself? Please reply back as I’m wanting to create my own personal website and would love to know where you got this from or what the theme is named. Kudos.

  55. After I initially commented I appear to have clicked the -Notify me when new comments are added- checkbox and from now on each time a comment is added I receive four emails with the exact same comment. Is there an easy method you are able to remove me from that service? Thank you.

  56. I’m amazed, I must say. Rarely do I come across a blog that’s both equally educative and interesting, and let me tell you, you’ve hit the nail on the head. The issue is something which too few men and women are speaking intelligently about. Now i’m very happy that I stumbled across this during my hunt for something relating to this.

  57. I’m very happy to find this page. I need to to thank you for ones time just for this fantastic read!! I definitely loved every part of it and i also have you bookmarked to see new stuff on your blog.

  58. This is a very good tip especially to those new to the blogosphere. Short but very accurate information… Appreciate your sharing this one. A must read article!

  59. Hello there, There’s no doubt that your blog could be having browser compatibility issues. When I take a look at your site in Safari, it looks fine however, when opening in Internet Explorer, it has some overlapping issues. I merely wanted to give you a quick heads up! Besides that, excellent website!

  60. You have made some really good points there. I looked on the internet for additional information about the issue and found most individuals will go along with your views on this website.

  61. Hi there! This post could not be written much better! Reading through this article reminds me of my previous roommate! He continually kept preaching about this. I am going to send this article to him. Fairly certain he’ll have a great read. Thank you for sharing!

  62. Right here is the right website for anyone who hopes to understand this topic. You know a whole lot its almost hard to argue with you (not that I really will need to…HaHa). You definitely put a new spin on a topic which has been written about for years. Wonderful stuff, just wonderful.

  63. You have made some good points there. I looked on the web for more information about the issue and found most people will go along with your views on this site.

  64. That is a really good tip especially to those fresh to the blogosphere. Simple but very precise info… Many thanks for sharing this one. A must read article!

  65. Can I just say what a relief to find an individual who really knows what they are discussing online. You definitely understand how to bring a problem to light and make it important. More people have to look at this and understand this side of your story. It’s surprising you aren’t more popular because you surely possess the gift.

  66. Hi! I could have sworn I’ve been to your blog before but after looking at some of the posts I realized it’s new to me. Nonetheless, I’m certainly pleased I stumbled upon it and I’ll be book-marking it and checking back frequently.

  67. Having read this I thought it was rather enlightening. I appreciate you taking the time and effort to put this short article together. I once again find myself spending way too much time both reading and commenting. But so what, it was still worthwhile!

  68. Nice post. I learn something totally new and challenging on blogs I stumbleupon everyday. It’s always useful to read articles from other writers and practice a little something from other sites.

  69. I’m excited to find this great site. I want to to thank you for ones time for this fantastic read!! I definitely enjoyed every part of it and i also have you book marked to check out new information in your blog.

  70. I want to to thank you for this great read!! I definitely enjoyed every bit of it. I have you book marked to check out new stuff you post…

  71. You made some decent points there. I checked on the net to find out more about the issue and found most individuals will go along with your views on this web site.

  72. Greetings! Very helpful advice in this particular article! It’s the little changes that produce the most important changes. Thanks for sharing!

  73. After I originally commented I seem to have clicked the -Notify me when new comments are added- checkbox and now every time a comment is added I recieve four emails with the same comment. There has to be a means you can remove me from that service? Thank you.

  74. Greetings! Very useful advice within this post! It is the little changes that will make the biggest changes. Thanks for sharing!

  75. I was pretty pleased to find this page. I wanted to thank you for your time for this particularly wonderful read!! I definitely really liked every little bit of it and I have you book marked to check out new information in your site.

  76. You’re so cool! I do not suppose I’ve read through anything like that before. So nice to discover another person with a few original thoughts on this issue. Seriously.. thanks for starting this up. This website is one thing that is needed on the web, someone with some originality.

  77. This blog was… how do I say it? Relevant!! Finally I have found something that helped me. Many thanks.

  78. Everything is very open with a very clear description of the issues. It was definitely informative. Your site is extremely helpful. Thanks for sharing.

  79. I’m amazed, I have to admit. Seldom do I come across a blog that’s both educative and entertaining, and let me tell you, you have hit the nail on the head. The issue is something which not enough people are speaking intelligently about. I’m very happy I found this in my hunt for something concerning this.

  80. I absolutely love your blog.. Excellent colors & theme. Did you develop this website yourself? Please reply back as I’m attempting to create my own website and would love to learn where you got this from or what the theme is called. Kudos!

  81. I must thank you for the efforts you have put in penning this website. I really hope to view the same high-grade content from you in the future as well. In truth, your creative writing abilities has inspired me to get my own blog now 😉

  82. After exploring a number of the articles on your blog, I honestly appreciate your technique of blogging. I saved it to my bookmark site list and will be checking back in the near future. Please visit my web site as well and tell me what you think.

  83. After looking over a number of the blog posts on your web site, I seriously like your way of blogging. I book-marked it to my bookmark webpage list and will be checking back soon. Please visit my website too and tell me how you feel.

  84. Greetings! Very useful advice within this article! It’s the little changes which will make the most important changes. Thanks for sharing!

  85. A motivating discussion is definitely worth comment. I do believe that you should publish more on this issue, it might not be a taboo matter but generally people don’t speak about these issues. To the next! Cheers.

Laisser un commentaire

Votre adresse e-mail ne sera pas publiée. Les champs obligatoires sont indiqués avec *

Retour en haut
Rappelez moi
+
Rappelez moi!

Solverwp- WordPress Theme and Plugin

× Comment puis-je vous aider ?