Microsoft Excel as a tool for Data Analytics
www.skillfinlearning.com
01
Microsoft Excel as a
today’s world
tool for data analytics in that can help analysts to
ANALYZE, SYNTHESIZE AND VISUALIZE
Information in a meaningful
way.
www.skillfinlearning.com
02 Excel has basic functionalities like LOOKUP FUNCTIONS, PIVOT TABLES, SLICERS, etc
with the
data.
www.skillfinlearning.com
that will
help
you to
play
03
Excel has some great
visualization tools that helps to present information in a graphical way. There are basic charts like LINE graph, Column chart, etc
www.skillfinlearning.com
04 EXCEL allows for creating an interactive
user
interface so
that the user can make a choice of what he or she wants to see. It uses functionalities like the OFFSET FUNCTION, list functionality etc.
www.skillfinlearning.com
05
Excel has in built programming functionalities
(Statistical add-ins) with VBA macros that allows to play with extremely large and complicated volumes of data.
www.skillfinlearning.com
MS Excel is a comprehensive
tool for analyzing, synthesizing and visualizing large data sets for data analysis jobs.
Follow | Save | Share
www.skillfinlearning.com