INFORMATION TECHNOLOGY / MICROSOFT APPLICATIONS

Power Query is a technology that allows you to find, link, merge and optimize your data sources for analysis. Power Query will be able to import, clean and evaluate millions of rows in the data model. Compared with other Excel tools it is an incredibly short learning curve. You set up a query once and use it again with a simple refresh. Power query helps to prepare your data for a pivot table report. A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data

In recent years, the term infographic has typically come to mean an easily shareable information visual with multiple illustrations in one graphic. These seem to have a way of going viral because they give the viewer that exciting feeling of understanding complexity in just a single image file. Many learners describe themselves as "visual learners." This means that they would rather get a simple, concise image or chart that conveys information. Data means to the most to this crowd when there are charts and graphs that drive the message home. All this can be done within Microsoft PowerPoint, the most used Presentation Application.

This course is aimed to help Excel users to use formulas & functions Creatively, starting from Fundamental of References to the complicated Nested Functions to simplify the Daily Workflow.

Power Query is a technology that allows you to find, link, merge and optimize your data sources for analysis. Power Query will be able to import, clean and evaluate millions of rows in the data model. Compared with other Excel tools it is an incredibly short learning curve. You set up a query once and use it again with a simple refresh. Power query helps to prepare your data for a pivot table report. A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data