Data sources designed for big data, such as SaaS, HDFS and large relational sources, can sometimes require specialized tools. Thankfully, Excel has a solution.
You don't always have control over the data that you import from an external data source.Before you can analyze the data, you often need to clean it up.
Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value.Use formulas in conditional formatting.
Learn Formula Automation making computer do a repetitive task or a task that requires great precision or multiple steps, without requiring human intervention.
Dashboard reports allows us to get high level overview of the data. Dashboards can provide analysis, insight and alerts in timely manner.
Chart in Excel can say more than a sheet full of numbers. It allows us to visually display data in a variety of different chart formats such as Bar, Column, Pie etc.
Use your exising data to calculate outputs for custom equations.
Evaluate Formula tool to calculate the result of a cell – one step at a time
Use numerical analysis methods to calculate data.
Learn to create userdefined functions and get output for your task.
Venue : IITM Research Park, Taramani
Date : 27th May 2018 | 10.00am - 4.00pm
Contact : P. Prakash, Operations Engineer
Call / WhatsApp : 9846 646 234
One Day Workshop | Limited Seats...Book Your Seat