Technologies de l'Information Formations

IT Training Taxo Menu

 

Excel 2016/2019/365 - Level 1

Being able to create tables and manage the tables’ calculations, formatting and page layout. The new Office interface, Using the File tab (“Backstage”). Managing the Quick Access Toolbar. New tricks and techniques. One window per workbook...

Excel 2016/2019/365 - Level 2

Handling the important basic functions. Nesting functions. Using the powerful analysis tools. Creating automated templates and macros. The new Office interface, using the File tab ("Backstage"), ...

Excel 2016/2019/365 - Macro

Want to save time on routine tasks in Microsoft Excel? Macros are the answer. In this course, the instructor will explain how macros can be used to automate tasks in Excel, and how you can create simple macros of your own. Learn when and how to record a macro in stages, share macros between workbooks, set up keyboard shortcuts to run macros quickly, and use Visual Basic for Applications (VBA) to code macros that can't be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario: converting mailing list data into a database-friendly format.