Master Excel 2016 - Advanced Technics

Master Excel 2016
5

Learn how to master Microsoft Excel 2016 and become a power user with this video training. In this Excel 2016 video tutorial you learn how to create and manage huge projects with data. You will discover how to import data from text files, XML files, from the Web or a database like SQL server. Then you learn how to use advanced filters and Pivot Tables to consolidate your data. Master the use of Power BI, a new feature in Excel 2016, which will help you to get and sort your data so as to present it easily in a dashboard of in a map. In this training, you also learn very important tools such as research (VLOOKUP), statistics functions (COUNTIF, COUNTIFS, SUMIFS...) This video tutorial features Frédéric Leguen : Microsoft Excel expert Most Valuable Professional Trainer Certified. By the end of this tutorial, you become totally freehand with Microsoft Excel 2016.

How to master Advanced Technics of Excel 2016
Know Excel fundamentals
Total duration: 4h10min
55 lessons

Un contenu flash devrait s'afficher ici. Votre navigateur ne comporte pas de plugin flash, ou il ne s'est pas correctement initialisé.

Vous pouvez télécharger le plugin flash depuis le site d'Adobe à l'adresse suivante : http://get.adobe.com/flashplayer/.

Master Excel 2016
Total duration: 4h10min
55 lessons

You're watching: Master Excel 2016 - Advanced Technics

Create Table in Excel 2016

1 Credit 04:10 min
1 Credit 06:18 min
1 Credit 05:29 min

Basic easy calculation

1 Credit 02:58 min
1 Credit 02:20 min

Import Data in Excel 2016

2 Credits 09:41 min
1 Credit 05:46 min
1 Credit 03:11 min
1 Credit 03:57 min
1 Credit 02:55 min
1 Credit 04:36 min

Advanced Filters in Excel 2016

1 Credit 05:09 min
1 Credit 03:24 min
1 Credit 04:16 min
1 Credit 04:01 min
1 Credit 03:10 min
1 Credit 02:53 min

Using Pivot Table in Excel 2016

1 Credit 06:14 min
1 Credit 04:31 min
1 Credit 04:38 min
1 Credit 03:45 min
1 Credit 02:23 min
1 Credit 02:09 min
1 Credit 05:04 min
1 Credit 02:50 min
1 Credit 03:19 min
1 Credit 04:46 min
1 Credit 05:02 min
1 Credit 02:50 min
1 Credit 03:08 min
1 Credit 03:01 min

Analysis in Excel 2016

1 Credit 03:42 min
1 Credit 04:49 min
1 Credit 03:59 min

Advanced functions

2 Credits 09:48 min
1 Credit 04:11 min
1 Credit 05:04 min
2 Credits 07:27 min
1 Credit 05:56 min
1 Credit 02:09 min
2 Credits 08:11 min
1 Credit 03:46 min
1 Credit 04:18 min
1 Credit 04:43 min
1 Credit 06:16 min
1 Credit 06:12 min
1 Credit 04:57 min
1 Credit 04:34 min
2 Credits 06:40 min

Power BI

1 Credit 03:21 min
1 Credit 05:29 min
1 Credit 05:14 min
1 Credit 03:59 min
1 Credit 05:06 min
1 Credit 02:11 min
Credit grand total : 60 Credits
No work files
No comment : to post a comment you have to purchase this tutorial
All software & topics
Learn

Over 1561 tutorials featuring the best trainers available

Teach

Join our worldwide international trainers community, share knowledge and start making money !

Get social, share
Universal Player

Download your tutorials right to your hard drive :
install our ELEPHORM Universal Player, and learn even without network access.

  • Access Notes
  • Your personal tutorial Library
Support

Excel addict?
You may also like...