This 7-hour Microsoft Excel 2019 course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets.

Course Format
This is a video-led training course. You can preview some videos in the pane above. This course includes practice exercises so you can practice as you learn. This course is suitable for Windows users.This course is also suitable for Office 365 users.

• Course Formats

  This is a video-led training course. You can preview some videos in the pane above. This course includes practice exercises so you can practice as you learn. This course is suitable for Windows users.

  This course is also suitable for Office 365 users.

Learning Excel on a Mac is different from learning Excel on a PC. 
Luckily, we’ve got you covered. We’ve put together this comprehensive Beginners Excel course, and it’s all recorded using Excel for Mac 2019. In this course, we assume you have zero Excel knowledge and help you grow your confidence with spreadsheets.
If you’ve used Excel before but never on a Mac, then this course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is certainly for you. This course uses Excel for Mac 2019, but much of it is still relevant if you’re using a different version.

Course Format

This is a video-led Microsoft Excel training course. You can preview some videos in the pane above. This course includes practice exercises so you can practice as you learn. This course is suitable for Mac users.
This course is also suitable for Office 365 users.

In this advanced Excel course, we look at three crucial advanced Excel features Power Pivot, Power Query, and DAX. This suite of Excel functions allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases.

***Exercise and demo files included***

• How to get started with Power Query

• How to connect Excel to multiple workbooks

• How to get data from the web and other sources

• How to merge and append queries using Power Query

• How the Power Pivot window works

• How to set up and manage relationships in a data model

• How to create a PivotTable to display your data from the Power Pivot data model

• How to add calculated columns using DAX

• How to use functions such as CALCULATE, DIVIDE, DATESYTD in DAX

• All about creating Pivot Charts and PivotTables and using your data model

• How to use slicers to adjust the data you display

Power BI

In this Power BI course, we start by looking at Power Query, and how to use this tool to organize and clean our data. We then show you how to build a Data Model and relate separate tables. After that, we teach you all about the data analysis language DAX in Power BI. Finally, we look at how to present this data using the charts and graphs available.

• What is Power BI and why you should be using it.

• To import CSV and Excel files into Power BI Desktop.

• How to use Merge Queries to fetch data from other queries.

• How to create relationships between the different tables of the data model.

• All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions.

• All about using the card visual to create summary information.

• How to use other visuals such as clustered column charts, maps, and trend graphs.

• How to use Slicers to filter your reports.

• How to use themes to format your reports quickly and consistently.

• How to edit the interactions between your visualizations and filter at visualization, page, and report level.
   

In this Advanced PivotTables in Excel course, we teach you how to make the most of this powerful data analysis function. PivotTables are ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel.

In this course, we give a PivotTable refresher before moving onto some of the advanced features of this tool including Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting.

This course is aimed at intermediate users of Excel who are comfortable using the PivotTable function. We don’t recommend this course for people brand new to Excel. If you are new to Excel, try out one of the Simon Sez IT Beginner Excel courses also available on Udemy.

This course includes:

1. 7+ hours of video tutorials

2. 50 individual video lectures

3. Exercise files to practice what you learned

4. Certificate of completion

This course was recorded using Excel from Office 365. It's also relevant to those using other, recent versions of Microsoft Excel including Excel 2013, 2016, and 2019.

We start by looking at how to take raw data and prepare it for analysis. After that, we look at a number of tools and functions that can be used to conduct analysis such as Pivot Tables, before moving onto how to display data in the most meaningful way using charts, Pivot Charts, Slicers and so much more. Finally, we move onto some more advanced techniques designed to aid forecasting and using existing data to predict future trends.

This course includes:

This course was recorded using Excel from Office 365. It's also relevant to those using other, recent versions of Microsoft Excel including Excel 2013, 2016, and 2019.

In Essential VBA Training for Excel - get up to speed on using VBA to help automate time-consuming procedures in Excel.

Contents and Overview

Through 4 hours of video lectures, exercise files, and an optional quiz, you'll learn the essentials you need to know to create powerful macros using VBA for Excel.

Discover how to define and manage variables, set up subroutines, and create functions.

Learn practical methods for using macro errors to improve your VBA code.

This course includes:

All of our videos are high definition; therefore, they are best viewed with the HD setting on and the videos enlarged.

In Essential VBA Training for Excel - get up to speed on using VBA to help automate time-consuming procedures in Excel.

Contents and Overview

Through 4 hours of video lectures, exercise files, and an optional quiz, you'll learn the essentials you need to know to create powerful macros using VBA for Excel.

Discover how to define and manage variables, set up subroutines, and create functions.

Learn practical methods for using macro errors to improve your VBA code.

This course includes:

All of our videos are high definition; therefore, they are best viewed with the HD setting on and the videos enlarged.

We start by looking at how to filter a dataset and sort using formulas. After that, we look at how to create multi-dependent drop-down lists, 2-way lookups, text extraction, dynamic chart titles and so much more! We end by looking at how to use XLOOKUP.
This course includes follow-along instructor files so you can immediately practice what you learn. This short course is not for Excel beginners. You will need an intermediate knowledge of Excel to get the most from this course.

Course Format

This is a video-led, Advanced Microsoft Excel short training course. You can preview some videos in the pane above. This course includes practice exercises so you can practice as you learn. This course is designed for PC users and does require a working knowledge of Microsoft Excel.
This course is also suitable for Excel 2013, 2016, 2019 and 365 users.

We start by giving a basic overview of Marcos and then show you how to create simple and more complex Marcos that could save you time every day. After that, we move on to some VBA basics and how to edit and debug Macros. Finally, we look at creating a Macro from scratch using VBA and how to create a custom Macro ribbon.
This course includes follow-along instructor files so you can immediately practice what you learn. This is an advanced level Excel course, an intermediate knowledge of Excel is required to get the most from this course.

Course Format

This is a video-led, Advanced Microsoft Excel short training course. You can preview some videos in the pane above. This course includes practice exercises so you can practice as you learn. This course is designed for PC users and does require a working knowledge of Microsoft Excel.
This course is also suitable for Excel 2013, 2016, 2019, and 365 users.

We’ll teach you how to create dashboards that look amazing, that are fully interactive so you (or anyone else!) can change the data they are seeing, and that can be updated with new data in a couple of clicks.

In this advanced Excel course, we look at how to create stunning, interactive dashboards in Excel.

• Creating a fully interactive Sales Dashboard from scratch.

• Creating a fully interactive HR Dashboard from scratch.

  This course includes:

  1. 9+ hours of video tutorials

  2. 70+ individual video lectures

  3. Exercise files to practice what you learned

  4. Certificate of completion

  This course was recorded using Excel 365. It's also relevant to those using other, recent versions of Microsoft Excel including Excel 2019, 2016, and 2013.

This course will fully prepare you for virtually any Excel related career path, including those that require advanced skills with this software. Once you complete the course, you’ll have access to the full functionality of Excel, and will know how to use all formulas, functions, and capabilities.

Whether you are brand new to the world of Excel, or you have training and knowledge of the software and are looking to improve your skills, this masterclass will take you to the next level. By the time you finish the beginner, intermediate and advanced portions, you too will be an expert in Excel.

Together we’re going to give you the foundational education that you need to know not just on how to use Excel at an expert level, but also how to get paid for your newly developed skills.

L'outil Microsoft Excel et le meilleur logiciel de calcul et de traitement de données. Qu'on est étudiant, salarié ou chercheur, Excel reste un passage obligé pour traiter des milliers de données. Cette formation est présentée sous forme d'exercices corrigés indépendants traitant des notions fondamentales et indispensables pour l'apprentissage et la maîtrise d'Excel.

1- Caractéristiques d'Excel Prise en main de l'interface. Utilisation du bouton Office, de la barre d'accès rapide et du ruban. Caractéristiques et possibilités du tableur. Classeur, barre des menus, barres d'outils, règle.
2- Gérer ses documents Ouvrir, créer, modifier et enregistrer un document Excel. Pré-visualiser, paramétrer l'impression et imprimer.
3- Saisir des données et des formules de calcul Différencier les types de données (texte, nombre et formule (Saisir, modifier, corriger, copier et déplacer des données. La vérification du document (orthographe, synonyme). Créer des formules de calcul : opérateurs, variables et constantes. Écrire et recopier des formules avec des références relatives et absolues. Utiliser les fonctions simples : somme, moyenne, conditionnelles, min, max, somme. La plage de données et les outils de tableaux.
4- Mettre en forme Mettre en forme le texte. Mettre en forme les nombres (formats prédéfinis (Mettre en forme les cellules (encadrement, largeur, hauteur et motif (Utiliser les thèmes et les styles pour la mise en forme. Appliquer des formats conditionnels.
5- Mettre en page et impression Présenter le document en vue de l'impression Réaliser des en-têtes et pieds de pages différents.
6- Générer des graphiques Créer un graphique et utilisation de l'outil à partir d'une feuille de calcul Disposition rapide, styles et mises en forme Ajouter des éléments de présentation.
7- Exploiter ses tableaux Utiliser la multi-feuille : insérer, supprimer, nommer, déplacer, dupliquer. Faire des liaisons dans le classeur.
8- Enregistrement et compatibilité Enregistrer les documents dans les versions précédentes Enregistrer un document en PDF .
 

1. Utiliser la bibliothèque de fonctions Calculs sur les dates, les heures, le texte. Utiliser les fonctions de recherche avancée, conditionnelle, statistique. Faciliter la réalisation des formules par l'utilisation des noms. Le gestionnaire de noms.
2. Fonctionnalités de bases de données et les différents outils. Les recommandations pour une vrai base de données. Déplacement, sélection facile et rapide dans un tableau de grande capacité. Les outils de tris et de filtres. Les outils de données : validation, consolidation, suppression des doublons. Créer un tableau de type base de données. Les outils de sous-totaux et d'analyse. Gestionnaire de scénario. Les filtres avancés.
3. Réaliser des tableaux croisés dynamiques L'outil de tableau croisé dynamique, création et options. Styles et dispositions. Manipulation des résultats. Graphique croisé dynamique. Les segments et les chronologies. Les connections de rapport.
4. Préparer et contrôler des tableaux Créer des modèles de tableaux. Maîtriser la validation des données. Mettre en oeuvre les outils de protection. Mise en forme conditionnel.
5. Macros sans programmation Enregistrement de macros. Exécution de macros : raccourcis clavier, ruban.