EXCEL & BIG DATA

EXCEL & BIG DATA by XLNC Academy Training Institute in Anywhere in India

Beginner 0(0 Ratings) 0 Students enrolled
Created by XLNC Academy staff Last updated Sat, 14-May-2022 English


EXCEL & BIG DATA free videos and free material uploaded by XLNC Academy staff .

Syllabus / What will i learn?

INTRODUCTION+

WHAT IS BIG DATA?+

REVIEWING THE BASICS+

PIVOT TABLES+

POWERPIVOT+

WORKING WITH POWERPIVOT DAX+

DYNAMIC CHARTING+

INTERPRETING AND SUMMARIZING DATA+

MATCHING FUNCTIONS+

FUNCTIONS FOR MANIPULATING TEXT+

DATA CLEANING+

ARRAYS+

MACROS+

VBA+

CUSTOM FUNCTIONS+

AUDITING AND OTHER FEATURES+

ANALYSIS TOOLS+

SCENARIOS+

DASHBOARDS+

ABOUT THE AUTHOR



Curriculum for this course
0 Lessons 00:00:00 Hours
+ View more
Description

Microsoft Excel is one of the most popular programs to use for analysing, extracting, and cleaning the tremendous amounts of data that we have collected. Learn how Microsoft Excel can manage and summarize your data with PowerPivot and Pivot Tables, automation and coding, along with the standard features of Arrays, functions such as MATCH and INDEX, and the Data Analysis Tools. Understand speed and file size limitations while appreciating the art of data cleaning and manipulation. Explore how the What If Analysis tools can help with plans and forecasts and consolidate and link data for interactive reports. This course will allow you to unleash the power of Excel to make accurate decisions based on your data and Excel's power.

You need online training / explanation for this course?

1 to 1 Online Training contact instructor for demo :


+ View more

Other related courses
About the instructor
  • 0 Reviews
  • 0 Students
  • 40 Courses
+ View more
XLNC Academy staff
Student feedback
0
Average rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 0%
Reviews

Material price :

Free
Get enrolled
1:1 Online Training Fee: 4999 /-
Contact instructor for demo :