NEW IN NOVEMBRE 2019 : POWER QUERY & PIVOT TABLE - advanced Excel modules
Lenght : 8 hours
***You don't need intermediate knowledge for this course.
Are you spending a lot of time extracting and formatting the same data in Excel?
There is a big chance you could automate all of this
using Power Query Power Query is an Excel ETL Extract Transform and Load tool You can pull data from multiple sources ( TXT, SQL, Web) and compile it into one table which can be refreshed in one click. For example let’s say you have 1000 's of files with the same format that you want to compile into one file With one simple query you can get all the data in a report with just a few clicks!
Power Pivot (Advanced)
Power Pivot is one of the most powerful features in Excel and hands down one of the best enhancements in the past few years
Power Pivot works in tandem with Power Query : you use Power Query to acquire / format and load the data, then you use Power
Pivot to do your analysis . You can link entire sets of data together, then create a data model that can handle millions of data records!
You can then connect other tools like Power View /Power Map /Pivot Chart to visualize your insights.
Our computer lab has been built in order to allow students to learn in an optimal and comfortable way!
Our customized training is adapted to your needs:
- Scheduling flexibility
- Small classes
TRAINING AVAILABLE FOR MICROSOFT OFFICE 2016
- Windows 10 : 228$ 12 hours
- Word: 228$12 hours
- Excel : 228$ 12 hours
- Access: 228$12 hours
- Powerpoint : 171$ 9 hours
- Outlook : 114$6 hours
EXCEL Intermediate : 380$ 20 hours
EXCEL Advanced: 380$ 20 hours
Simply Accounting: 350$ 18 hours
Quickbooks: 350$ 18 hours
Special rate for 5 employees and more !
Please contact Julie Lavoie at: 733-1567