GOOGLE SHEETS – TOUS NIVEAUX – 14 HEURES

FORMATION GOOGLE SHEETS - TOUS NIVEAUX

14 heures - présentiel

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. 14 heures en présentiel avec un formateur expérimenté.. En INTRA-ENTREPRISE ou dans nos locaux sur PARIS 8

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 – 14 HEURES

172 commentaires sur “GOOGLE SHEETS – TOUS NIVEAUX – 14 HEURES

  1. Good post. I learn something totally new and challenging on blogs I stumbleupon on a daily basis. It’s always useful to read through content from other authors and practice something from other web sites.

  2. Greetings! Very helpful advice in this particular post! It’s the little changes that will make the most important changes. Many thanks for sharing!

  3. Good day! I simply want to give you a huge thumbs up for your excellent info you have right here on this post. I will be returning to your site for more soon.

  4. A fascinating discussion is definitely worth comment. I do believe that you should publish more on this subject matter, it might not be a taboo subject but usually people don’t talk about these topics. To the next! Kind regards!

  5. Right here is the right site for anybody who wishes to find out about this topic. You understand a whole lot its almost hard to argue with you (not that I personally would want to…HaHa). You certainly put a new spin on a subject that’s been written about for ages. Excellent stuff, just wonderful.

  6. I’m very happy to uncover this web site. I wanted to thank you for ones time for this wonderful read!! I definitely enjoyed every bit of it and I have you bookmarked to check out new information in your blog.

  7. The next time I read a blog, I hope that it won’t fail me as much as this particular one. I mean, I know it was my choice to read through, but I really thought you would probably have something helpful to talk about. All I hear is a bunch of complaining about something that you can fix if you weren’t too busy looking for attention.

  8. I’d like to thank you for the efforts you have put in penning this site. I really hope to see the same high-grade content from you in the future as well. In fact, your creative writing abilities has motivated me to get my own, personal website now 😉

  9. I seriously love your blog.. Very nice colors & theme. Did you build this website yourself? Please reply back as I’m attempting to create my very own blog and want to find out where you got this from or exactly what the theme is called. Kudos.

  10. I absolutely love your blog.. Pleasant colors & theme. Did you develop this amazing site yourself? Please reply back as I’m attempting to create my own site and would like to find out where you got this from or what the theme is named. Kudos!

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

  12. Hello, I believe your website may be having browser compatibility problems. When I take a look at your site in Safari, it looks fine but when opening in I.E., it has some overlapping issues. I merely wanted to give you a quick heads up! Other than that, wonderful website!

  13. Hi, I do believe this is a great blog. I stumbledupon it 😉 I am going to revisit once again since i have book-marked it. Money and freedom is the best way to change, may you be rich and continue to help others.

  14. Good day! 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. Regardless, I’m definitely pleased I stumbled upon it and I’ll be bookmarking it and checking back regularly.

  15. I’m amazed, I have to admit. Seldom do I encounter a blog that’s both educative and interesting, and without a doubt, you have hit the nail on the head. The problem is an issue that not enough men and women are speaking intelligently about. I’m very happy that I came across this during my search for something concerning this.

  16. Can I just say what a relief to find somebody that actually knows what they’re discussing on the internet. You definitely realize how to bring a problem to light and make it important. More and more people really need to read this and understand this side of your story. I was surprised you are not more popular since you most certainly possess the gift.

  17. Having read this I believed it was extremely informative. I appreciate you taking the time and effort to put this information together. I once again find myself personally spending way too much time both reading and commenting. But so what, it was still worthwhile!

  18. You’re so cool! I do not suppose I have read through anything like that before. So nice to discover somebody with some unique thoughts on this topic. Seriously.. many thanks for starting this up. This website is something that’s needed on the web, someone with a bit of originality.

  19. I blog frequently and I really appreciate your information. This article has truly peaked my interest. I am going to bookmark your blog and keep checking for new details about once per week. I subscribed to your RSS feed as well.

  20. An outstanding share! I have just forwarded this onto a coworker who was conducting a little homework on this. And he actually bought me dinner because I discovered it for him… lol. So let me reword this…. Thanks for the meal!! But yeah, thanx for spending time to discuss this topic here on your website.

  21. Nice post. I learn something new and challenging on websites I stumbleupon on a daily basis. It will always be helpful to read through articles from other authors and use a little something from other sites.

  22. This is a very good tip especially to those fresh to the blogosphere. Short but very accurate information… Many thanks for sharing this one. A must read post!

  23. Hello there! This blog post could not be written any better! Looking at this article reminds me of my previous roommate! He continually kept preaching about this. I will send this article to him. Pretty sure he will have a great read. I appreciate you for sharing!

  24. I would like to thank you for the efforts you’ve put in penning this site. I’m hoping to see the same high-grade blog posts from you later on as well. In fact, your creative writing abilities has encouraged me to get my own, personal site now 😉

  25. After I originally left a comment I appear to have clicked the -Notify me when new comments are added- checkbox and from now on whenever a comment is added I recieve four emails with the exact same comment. Perhaps there is an easy method you are able to remove me from that service? Kudos.

  26. You’re so awesome! I do not believe I have read something like that before. So great to find someone with some original thoughts on this issue. Really.. thank you for starting this up. This web site is something that’s needed on the internet, someone with some originality.

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

  28. Everything is very open with a clear clarification of the challenges. It was truly informative. Your site is very useful. Many thanks for sharing.

  29. Spot on with this write-up, I really believe this site needs a lot more attention. I’ll probably be returning to see more, thanks for the information!

  30. Your style is very unique compared to other people I have read stuff from. Many thanks for posting when you’ve got the opportunity, Guess I’ll just book mark this web site.

  31. Howdy! This article couldn’t be written much better! Looking at this post reminds me of my previous roommate! He constantly kept preaching about this. I most certainly will forward this article to him. Pretty sure he’ll have a good read. Many thanks for sharing!

  32. Hello! Do you know if they make any plugins to assist with Search Engine
    Optimization? I’m trying to get my website to rank for some targeted keywords but I’m not seeing
    very good gains. If you know of any please share.
    Thank you! I saw similar art here: Eco wool

  33. After looking at a handful of the blog articles on your blog, I truly like your technique of blogging. I book marked it to my bookmark website list and will be checking back soon. Take a look at my web site too and tell me what you think.

  34. I’d like to thank you for the efforts you’ve put in penning this site. I am hoping to view the same high-grade blog posts from you in the future as well. In fact, your creative writing abilities has motivated me to get my very own website now 😉

  35. I truly love your blog.. Excellent colors & theme. Did you make this site yourself? Please reply back as I’m looking to create my own blog and would love to find out where you got this from or exactly what the theme is named. Thanks.

  36. Can I just say what a comfort to find somebody that genuinely understands what they’re talking about over the internet. You certainly understand how to bring a problem to light and make it important. A lot more people should read this and understand this side of the story. I can’t believe you’re not more popular since you definitely have the gift.

  37. Hi there! I could have sworn I’ve been to this blog before but after going through a few of the posts I realized it’s new to me. Regardless, I’m definitely happy I found it and I’ll be bookmarking it and checking back regularly!

  38. Hello! I could have sworn I’ve visited this web site before but after browsing through many of the articles I realized it’s new to me. Anyhow, I’m definitely happy I stumbled upon it and I’ll be book-marking it and checking back frequently!

  39. Hi there! This article could not be written much better! Looking at this article reminds me of my previous roommate! He always kept preaching about this. I’ll forward this information to him. Pretty sure he will have a great read. Many thanks for sharing!

  40. I need to to thank you for this great read!! I definitely enjoyed every bit of it. I have got you bookmarked to check out new stuff you post…

  41. Can I simply say what a comfort to uncover someone who truly understands what they’re talking about online. You certainly understand how to bring an issue to light and make it important. A lot more people should look at this and understand this side of the story. I was surprised that you’re not more popular given that you most certainly possess the gift.

  42. sugar defender ingredients Sugarcoating Defender to my daily regimen was one of the best choices I’ve created my health.
    I beware about what I eat, however this supplement adds an added layer of assistance.
    I really feel extra steady throughout the day, and my cravings have actually lowered dramatically.
    It behaves to have something so straightforward that makes such a huge distinction!

  43. I’d like to thank you for the efforts you have put in penning this blog. I’m hoping to see the same high-grade blog posts by you later on as well. In truth, your creative writing abilities has encouraged me to get my very own website now 😉

  44. I blog frequently and I really thank you for your content. This great article has really peaked my interest. I’m going to take a note of your blog and keep checking for new information about once per week. I subscribed to your Feed as well.

  45. Way cool! Some very valid points! I appreciate you penning this article plus the rest of the site is also really good.

  46. You are so cool! I don’t think I’ve read something like this before. So great to find another person with genuine thoughts on this issue. Really.. many thanks for starting this up. This site is something that is required on the web, someone with a little originality.

  47. Hello there! This post could not be written much better! Looking at this article reminds me of my previous roommate! He constantly kept preaching about this. I’ll send this article to him. Pretty sure he’ll have a good read. Thanks for sharing!

  48. The next time I read a blog, Hopefully it won’t fail me as much as this one. I mean, I know it was my choice to read through, but I actually believed you would probably have something helpful to talk about. All I hear is a bunch of moaning about something you can fix if you were not too busy seeking attention.

  49. Hello! I could have sworn I’ve been to your blog before but after looking at many of the posts I realized it’s new to me. Nonetheless, I’m definitely delighted I stumbled upon it and I’ll be bookmarking it and checking back regularly.

  50. A fascinating discussion is worth comment. There’s no doubt that that you need to publish more on this subject, it might not be a taboo subject but generally people don’t talk about such issues. To the next! Many thanks.

  51. The next time I read a blog, I hope that it won’t disappoint me as much as this particular one. After all, I know it was my choice to read through, however I really believed you would have something useful to talk about. All I hear is a bunch of complaining about something that you could fix if you were not too busy seeking attention.

  52. Hi, I do think this is a great site. I stumbledupon it 😉 I will revisit once again since i have book-marked it. Money and freedom is the greatest way to change, may you be rich and continue to guide others.

  53. Howdy! I could have sworn I’ve been to this blog before but after looking at a few of the posts I realized it’s new to me. Nonetheless, I’m definitely pleased I came across it and I’ll be bookmarking it and checking back regularly.

  54. Next time I read a blog, I hope that it doesn’t disappoint me just as much as this particular one. After all, Yes, it was my choice to read through, however I genuinely thought you’d have something helpful to talk about. All I hear is a bunch of crying about something that you could fix if you were not too busy searching for attention.

  55. Howdy! I could have sworn I’ve visited this site before but after looking at some of the posts I realized it’s new to me. Regardless, I’m definitely delighted I discovered it and I’ll be book-marking it and checking back often.

  56. I quite like looking through a post that can make men and women think. Also, thanks for permitting me to comment.

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

  58. I’m amazed, I must say. Seldom do I encounter a blog that’s both educative and engaging, and let me tell you, you’ve hit the nail on the head. The issue is something that not enough folks are speaking intelligently about. I’m very happy that I stumbled across this during my hunt for something relating to this.

  59. An interesting discussion is worth comment. I believe that you should write more on this issue, it might not be a taboo matter but usually people do not talk about these subjects. To the next! Cheers.

  60. I blog frequently and I really thank you for your information. The article has really peaked my interest. I’m going to take a note of your site and keep checking for new details about once per week. I opted in for your RSS feed as well.

  61. I’m impressed, I have to admit. Rarely do I encounter a blog that’s both equally educative and amusing, and let me tell you, you have hit the nail on the head. The issue is an issue that not enough people are speaking intelligently about. Now i’m very happy I stumbled across this during my search for something concerning this.

  62. Introducing to you the most prestigious online entertainment address today. Visit now to experience now!

  63. I blog quite often and I genuinely appreciate your content. The article has really peaked my interest. I will book mark your website and keep checking for new information about once per week. I subscribed to your Feed as well.

  64. Having read this I thought it was very enlightening. I appreciate you spending some time and effort to put this content together. I once again find myself personally spending a significant amount of time both reading and leaving comments. But so what, it was still worthwhile.

  65. When I initially left a comment I appear to have clicked on the -Notify me when new comments are added- checkbox and from now on every time a comment is added I recieve four emails with the same comment. Perhaps there is a way you are able to remove me from that service? Thank you.

  66. Right here is the perfect site for everyone who hopes to find out about this topic. You know so much its almost tough to argue with you (not that I personally would want to…HaHa). You certainly put a brand new spin on a subject that has been written about for many years. Wonderful stuff, just great.

  67. I would like to thank you for the efforts you’ve put in penning this blog. I’m hoping to see the same high-grade content from you later on as well. In fact, your creative writing abilities has encouraged me to get my very own website now 😉

  68. I blog often and I seriously thank you for your content. This great article has truly peaked my interest. I am going to bookmark your site and keep checking for new details about once a week. I opted in for your RSS feed as well.

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 ?