FREE Course on Data Analytics Using Excel

Key Topics
Learn to use Functions in Excel
Learn to use Conditional Formatting through Logical Expressions
Learn to create Charts in Excel
Get a thorough understanding of the Date Functions
Formatting of Tables
Understand about Data Validation
Perform What-If Analysis

Day 1 - Introduction, Basic Functions (Sum, Avg, Min, Max, Count)
Day 2 - Relative and Absolute referencing, Conditional Statements - IF, NESTEDIF, IFS
Day 3 - MAXIFS, MINIFS, SUMIFS, COUNTIFS, Error Handling using IFERROR and IFNA, Mixed Referencing, Conditional Formatting
Day 4 - Conditional Formatting - Highlight Cell Rules, Top/Bottom Rules, Data Bars, Color Scales, Icon Sets, Writing Formulas, Manage Rules, Introduction to Lookup Functions
Day 5 - VLOOKUP Exact match, Approximate Match, VLOOKUP on expanding data, HLOOKUP
Day 6 - VLOOKUP with Match Function, Limitations of VLOOKUP, XLOOKUP, Data Validation Lists with LOOKUPS
Day 7 - INDEX and MATCH, 2-Way LOOKUP, Text Functions, Formatting Data
Day 8 - Formatting Data in Table, Creating Pivot Tables, Working with Pivot Tables, Summarizing the Data
Day 9 - GetPivotData feature, Calculated Fields, Show Data As option
Day 10 - Show Data As option, Slicer, TimeLine, Basic Charts
Day 11 - Bar Graphs, Pie Charts, Line Charts, Histograms
Day 12 - Tree Map, Pareto Chart, Waterfall Chart, Funnel Chart, Basic Dashboard
Day 13 - Basic Interactive Dashboard, Forecasting, Scatter Plots, Regression
Day 14 - Date and Time Functions, Get and Transform Data
Day 15 - What If Analysis

SUBSCRIBE TO 360DigiTMG’s YOUTUBE CHANNEL NOW
https://www.youtube.com/c/360DigiTMG

We have specifically created a Facebook Group for all our Data Science aspirants. You can use the below link to join.
In addition to this, we are going to host 2 FREE training sessions Every Single Month on various topics inside this group.

Join FREE Data Science Facebook Group
https://www.facebook.com/groups/DataScience.MachineLearning.ArtificialIntellegence/


CONNECT WITH 360DigiTMG ON SOCIAL MEDIA

Facebook: https://www.facebook.com/360Digitmg/
LinkedIn: https://www.linkedin.com/company/360digitmg/
Instagram: https://www.instagram.com/360digitmg_india/
YouTube: https://www.youtube.com/c/360DigiTMG

About 360DigiTMG
360DigiTMG is a 9-year-old training & consulting organization led by stalwarts of the industry who are alumnus of premier institutions like the Indian Institute of Technology, Indian Institute of Management and Indian School of Business. 360DigiTMG since its inception has been the forerunner in the space of management and niche programs that aid in up-skilling and cross skilling executives across various levels and domains. 360DigiTMG has been conducting training programs across the globe for corporate and individuals alike.
360DigiTMG is one stop solution to all the trainings in emerging technologies such as Artificial Intelligence, Machine Learning, Big Data, Project Management, Quality Management, etc. 360DigiTMG is a training company, which is a division of the analytics consulting firm Innodatatics Inc.

For more Information Contact us @::
India : +91 99899 94319
Malaysia: +603 2092 9488

Email: [email protected]
Web: https://360digitmg.com/

Did you find this video helpful? Leave a comment below!
#Excel #DataAnalytics #FreeSession #DataScience #ArtificialIntelligence #Scholarship #DataAnalytics #Jumpstart #360DigiTMG #Malaysia