Introduction to Excel
Customizing tabs, options in excel
Data validation: Options in data validation for list, whole numbers, dates
Using name manager for data validation
Sorting left to right
Advanced sorting with multiple options
Advanced filter options
Sorting and filtering with color options
Short cuts to create pivot tables
Changing row and column labels
Custom format tables and default tables
Changing number formats
Value field settings and summarizing values by 11 different options
Value field settings and showing values as different options
Grouping of continuous fields
Pivot charts, compared regular charts
Slicers, Slicer settings, advanced slicer
Calculated fields in pivot tables
Vlookup and Hlookup
Syntax for Vlookup
What-if there are errors
Vlookup with data validation
Approximation for Vlookup
Using column function for dynamic column numbers
Using Choose function to select a table for Vlookup
Using Match function to identify column number
Locking cells for absolute and relative cells
Auto sum functions
Date and Time functions
Lookup and reference functions
Pie charts, Pie in pie and Bar of pie, Donut
Stacker bar and clustered bar charts
Gantt charts and Formula
Text to columns
Remove duplicates, Consolidate
Grouping, ungrouping and sub-totals
Freezing and unfreezing panes
Understanding the start pane
Connecting to data source
Data sources that can be connected
Various file formats
Connecting to excel, Joins, Splitting data
Live and extract
Dimensions and measures
Clearing sorts and filters
Views: Standard fit width and height
Expanding the marks in pane
Editing color pane
Understanding show me
Sorting and hierarchy
Data pane and analytics pane
Different view options at bottom of sheet
Managing data and extracts
Hiding and unhiding fields
Creating folders to move dimensions and measures
Adding default colors and properties
Adding multiple data sources
Replacing data sources
Sorting and Filtering
Highlighter for color and shape
Sorting from axis, color, category, manually and clearing sort
Creating groups from pane, manually, visually, parameters, and bins
Adding filter, show filter, wildcards, Top N parameters
Discrete and continuous dates
Types of filters: Applying to specific sheets, Editing page shelf
Sets and parameters
Dashboards and storyboards
Hiding and unhiding sheets
Interface between sheets, dashboard and storyboard
Elements in dashboard
Actions in dashboard
Box and whisker
Step and Line
Show me charts
Regular calc and table calc
Converting geo to non-geo
Options for maps
Creating and configuring sheets
Pivots and Sets
Lookup and apply map functions
Interchanging bar and Line
References in chart
Before and after functions
Creating blank database
Creating table at backend table design view
Creating select query
Defining relationships between tables
Controls and properties
And Or Not
Min and Max
Count, Avg, sum
Connecting to database, basic transformation
Managing queries, splitting columns
Modifying data types
Re-ordering columns, conditional columns
Connecting to folders
Insert new data tables
Grouping and Binning
Create and format visualizations
Hierarchical axis and concatenating
Data behind visualization
Maps, ESRI maps
Tables and matrixes
Waterfall and funnel charts
Gauge, cards and KPIs
Shapes, grid lines, page settings
Duplicates, categories with no data
Custom visual store
Waterfall and funnel charts
Grouping and binning
Tables and matrices
Turn off visual headers
Custom date tables
Excel data and collaboration
Upload an excel table
Excel data with BI content
Pinning excel tables
Analyze in excel
Power BI service
Overview of dashboards
Publish from Power BI
Pinning on dashboards, dashboard tiles, display options
Filter the list in navigating pane
Sharing, print and export dashboards
Export to csv or excel or ppt
Employee Attrition is an important subject to gauge the satisfaction of the employee in a company. HR departments take various...Read More
Predict the sales price for each house based on input features provided for the house.
Industry: Real Estate
Tools: Linear Regression, Multi...
Customer analysis plays a crucial role in determining the profitability of Retail companies. Segmentation of the customers based on their...Read More
This project deals with the predictions of stock market prices using history of Data. It also considers the physical factors...Read More
This project analyses data using quantitative prediction of crimes in Boston and drawing visualizations of Trends in the data over the...Read More
Lenovo India’s BI Analytics & Visualization team created an interactive and flexible Tableau sales dashboard for departments to use it for ad-hoc analysis and reporting.
Tableau has made Lufthansa free from the bounds of IT department and made it independent in its functioning.
Our Data Analysis training has precisely been developed to reach out to the demand of the learners by keeping in mind the industry standards.
This Data Analysis course will particularly be helpful for the career advancement of the following audience -
Graduates from the College.
Currently working employees looking to upskill themselves.
Candidates looking for a change in the IT Field.
As such, there are no specific prerequisites for Data Analysis institutes in Hyderabad. If you are familiar with programming and foundation skills with a sense of curiosity and willingness to learn you are all set for the Data Analysis training.
Data Analysis Training Classes are conducted over the Weekdays and Weekends through classroom and online sessions. Please get in touch with the Digital Lync team to get the exact schedule and timings.
Our Data Analysis faculty has over 12 years of experience.
Data Analysis Course duration is 50 hours.
Weekday Data Analysis Training classes will be one hour long and Weekend classes will be three hours long.
Please find the detailed Data Analysis course curriculum in the Digital Lync Data Analysis training curriculum section.
Yes, we will assist our students with all the interview preparation techniques
Data Analysis training is excellent here. I specifically suggest for working professionals who are looking for advanced knowledge in Data Analysis course.
I have done my Data Analysis course here, the work environment is very good. Especially during training great tasks were taught. Everything explained cleared. Finally, I like to comment that "Digital Lync" is the right choice for those who wants to learn the Data Analysis course.
Here training seekers will be given the opportunity what exactly wanna be done.
Best Data Analysis Training in Hyderabad with hand on Labs and great exposure to all the other Technologies. The best platform to learn the Data Analysis course.
I took Data Analysis training in Hyderabad. Digital Lync is the best institute if you want to make yourself better. The best part is, the classes won't be like someone standing there and giving lectures, there is a lot of interaction between the trainers and the students.
After Taking Data Analysis Training in Hyderabad, I got placed in as a Data Analysis Engineer. Digital Lync has helped me a lot to unleash my potential.
It has been a very good school of learning, the trainer explains every individual concept (Theory/Practical) in-depth when I joined for Data Analysis training at the Gachibowli branch Hyderabad. It has an extraordinary infrastructure with un-interrupted broadband. Your doubts can be clarified with live projects. Altogether it was an awesome experience learning in Digital Lync.
The best place to learn the Data Analysis course in Hyderabad, the trainer is well knowledged and trains in depth. Practice sessions helped me a lot and the infrastructure is superb compared to other places. I have cracked my certification exam in the Data Analysis training course with the help of the training here.
I have finished my Data Analysis training in Hyderabad from Digital Lync. I got the job right after the training. I'm very happy. You should definitely check out Digital Lync to elevate your career prospects.
1st Floor, Plot No: 6-11, survey No., 40 Khajaguda, Naga Hills Rd, Madhura Nagar Colony, Gachibowli Hyderabad, Telangana 500008
Uptown Cyberabad Building, Block-C, 1st Floor Plot – 532 & 533, 100 Feet Road Sri Swamy Ayyappa Housing Society, Madhapur, Telangana 500081
11, Pusat Dagang Seksyen 16 Seksyen 16, 46350 Petaling Jaya Selangor, Malaysia
#23664, Richland Grove Dr, Ashburn, VA 20148